SalesReceiptLine Table

Back to list of tables.

Column	Data type	Data type name	Length	Can be queried?	Can be updated?	Can be inserted?	Mandatory when inserting?	Format	Refers To	Version introduced in	Edition available in
TxnID	12	VARCHAR	36	True	False	False	False	%s		1.0	US, CA, UK
TimeCreated	93	TIMESTAMP	23	True	False	False	False	CCCC-MM-DDThh:mm:ssZ		1.0	US, CA, UK
TimeModified	93	TIMESTAMP	23	True	False	False	False	CCCC-MM-DDThh:mm:ssZ		1.0	US, CA, UK
EditSequence	12	VARCHAR	16	True	False	False	False	%s		1.0	US, CA, UK
TxnNumber	4	INTEGER	9	True	False	False	False	%11.0f		1.0	US, CA, UK
CustomerRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	1.0	US, CA, UK
CustomerRef_FullName	12	VARCHAR	209	True	True	True	False	%s	Fullname	1.0	US, CA, UK
ClassRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	3.0	US, CA, UK
ClassRef_FullName	12	VARCHAR	159	True	True	True	False	%s	Name	3.0	US, CA, UK
TemplateRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	1.0	US, CA, UK
TemplateRef_FullName	12	VARCHAR	31	True	True	True	False	%s	Name	1.0	US, CA, UK
TxnDate	91	DATE	10	True	True	True	False	CCCC-MM-DD		1.0	US, CA, UK
TxnDateMacro	12	VARCHAR	25	True	False	False	False	All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYear ThisFiscalYearToDate Yesterday LastWeek LastWeekToDate LastMonth LastMonthToDate LastCalendarQuarter LastCalendarQuarterToDate LastFiscalQuarter LastFiscalQuarterToDate LastCalendarYear LastCalendarYearToDate LastFiscalYear LastFiscalYearToDate NextWeek NextFourWeeks NextMonth NextCalendarQuarter NextCalendarYear NextFiscalQuarter NextFiscalYear		1.0	US, CA, UK
RefNumber	12	VARCHAR	11	True	True	True	False	%s		1.0	US, CA, UK
BillAddress_Addr1	12	VARCHAR	41	True	True	True	False	%s		1.0	US, CA, UK
BillAddress_Addr2	12	VARCHAR	41	True	True	True	False	%s		1.0	US, CA, UK
BillAddress_Addr3	12	VARCHAR	41	True	True	True	False	%s		1.0	US, CA, UK
BillAddress_Addr4	12	VARCHAR	41	True	True	True	False	%s		2.0	US, CA, UK
BillAddress_Addr5	12	VARCHAR	41	True	True	True	False	%s		6.0	US, CA, UK
BillAddress_City	12	VARCHAR	31	True	True	True	False	%s		1.0	US, CA, UK
BillAddress_State	12	VARCHAR	21	True	True	True	False	%s		1.0	US, CA, UK
BillAddress_PostalCode	12	VARCHAR	13	True	True	True	False	%s		1.0	US, CA, UK
BillAddress_Country	12	VARCHAR	31	True	True	True	False	%s		1.0	US, CA, UK
BillAddress_Note	12	VARCHAR	41	True	True	True	False	%s		6.0	US, CA, UK
BillAddressBlock_Addr1	12	VARCHAR	41	True	False	False	False	%s		6.0	US, CA, UK
BillAddressBlock_Addr2	12	VARCHAR	41	True	False	False	False	%s		6.0	US, CA, UK
BillAddressBlock_Addr3	12	VARCHAR	41	True	False	False	False	%s		6.0	US, CA, UK
BillAddressBlock_Addr4	12	VARCHAR	41	True	False	False	False	%s		6.0	US, CA, UK
BillAddressBlock_Addr5	12	VARCHAR	41	True	False	False	False	%s		6.0	US, CA, UK
ShipAddress_Addr1	12	VARCHAR	41	True	True	True	False	%s		1.0	US, CA, UK
ShipAddress_Addr2	12	VARCHAR	41	True	True	True	False	%s		1.0	US, CA, UK
ShipAddress_Addr3	12	VARCHAR	41	True	True	True	False	%s		1.0	US, CA, UK
ShipAddress_Addr4	12	VARCHAR	41	True	True	True	False	%s		2.0	US, CA, UK
ShipAddress_Addr5	12	VARCHAR	41	True	True	True	False	%s		6.0	US, CA, UK
ShipAddress_City	12	VARCHAR	31	True	True	True	False	%s		1.0	US, CA, UK
ShipAddress_State	12	VARCHAR	21	True	True	True	False	%s		1.0	US, CA, UK
ShipAddress_PostalCode	12	VARCHAR	13	True	True	True	False	%s		1.0	US, CA, UK
ShipAddress_Country	12	VARCHAR	31	True	True	True	False	%s		1.0	US, CA, UK
ShipAddress_Note	12	VARCHAR	41	True	True	True	False	%s		6.0	US, CA, UK
ShipAddressBlock_Addr1	12	VARCHAR	41	True	False	False	False	%s		6.0	US, CA, UK
ShipAddressBlock_Addr2	12	VARCHAR	41	True	False	False	False	%s		6.0	US, CA, UK
ShipAddressBlock_Addr3	12	VARCHAR	41	True	False	False	False	%s		6.0	US, CA, UK
ShipAddressBlock_Addr4	12	VARCHAR	41	True	False	False	False	%s		6.0	US, CA, UK
ShipAddressBlock_Addr5	12	VARCHAR	41	True	False	False	False	%s		6.0	US, CA, UK
IsPending	-7	BIT	2	True	True	True	False	1 0 true false		1.0	US, CA, UK
CheckNumber	12	VARCHAR	25	True	True	True	False	%s		1.0	US, CA, UK
PaymentMethodRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	1.0	US, CA, UK
PaymentMethodRef_FullName	12	VARCHAR	31	True	True	True	False	%s	Name	1.0	US, CA, UK
DueDate	91	DATE	10	True	True	True	False	CCCC-MM-DD		1.0	US, CA, UK
SalesRepRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	1.0	US, CA, UK
SalesRepRef_FullName	12	VARCHAR	15	True	True	True	False	%s	Initial	1.0	US, CA, UK
ShipDate	91	DATE	10	True	True	True	False	CCCC-MM-DD		1.0	US, CA, UK
ShipMethodRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	1.0	US, CA, UK
ShipMethodRef_FullName	12	VARCHAR	15	True	True	True	False	%s	Name	1.0	US, CA, UK
FOB	12	VARCHAR	13	True	True	True	False	%s		1.0	US, CA, UK
ItemSalesTaxRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	1.0	US, CA, UK
ItemSalesTaxRef_FullName	12	VARCHAR	31	True	True	True	False	%s	Name	1.0	US, CA, UK
Subtotal	2	NUMERIC	15	True	False	False	False	%10.2f		1.0	US, CA, UK
SalesTaxPercentage	2	NUMERIC	18	True	False	False	False	%10.5f		1.0	US, CA, UK
SalesTaxTotal	2	NUMERIC	15	True	False	False	False	%10.2f		1.0	US, CA, UK
TotalAmount	2	NUMERIC	15	True	False	False	False	%10.2f		1.0	US, CA, UK
CurrencyRef_ListID	12	VARCHAR	36	True	False	False	False	%s	ListID	8.0	US, CA, UK
CurrencyRef_FullName	12	VARCHAR	64	True	False	False	False	%s	Name	8.0	US, CA, UK
ExchangeRate	2	NUMERIC	18	True	True	True	False	%6.6f		8.0	US, CA, UK
TotalAmountInHomeCurrency	2	NUMERIC	15	True	False	False	False	%10.2f		8.0	US, CA, UK
Memo	12	VARCHAR	4095	True	True	True	False	%s		1.0	US, CA, UK
CustomerMsgRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	1.0	US, CA, UK
CustomerMsgRef_FullName	12	VARCHAR	101	True	True	True	False	%s	Name	1.0	US, CA, UK
IsToBePrinted	-7	BIT	2	True	True	True	False	1 0 true false		1.0	US, CA, UK
IsToBeEmailed	-7	BIT	2	True	True	True	False	1 0 true false		6.0	US, CA, UK
CustomerSalesTaxCodeRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	1.0	US, CA, UK
CustomerSalesTaxCodeRef_FullName	12	VARCHAR	159	True	True	True	False	%s	Name	1.0	US, CA, UK
DepositToAccountRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	1.0	US, CA, UK
DepositToAccountRef_FullName	12	VARCHAR	159	True	True	True	False	%s	Fullname	1.0	US, CA, UK
CreditCardTxnInfo_Input_CreditCardNumber	12	VARCHAR	25	True	False	True	False	%s		4.1	US, CA, UK
CreditCardTxnInfo_Input_ExpirationMonth	4	INTEGER	9	True	False	True	False	%11.0f		4.1	US, CA, UK
CreditCardTxnInfo_Input_ExpirationYear	4	INTEGER	9	True	False	True	False	%11.0f		4.1	US, CA, UK
CreditCardTxnInfo_Input_NameOnCard	12	VARCHAR	41	True	False	True	False	%s		4.1	US, CA, UK
CreditCardTxnInfo_Input_CreditCardAddress	12	VARCHAR	41	True	False	True	False	%s		4.1	US, CA, UK
CreditCardTxnInfo_Input_CreditCardPostalCode	12	VARCHAR	18	True	False	True	False	%s		4.1	US, CA, UK
CreditCardTxnInfo_Input_CommercialCardCode	12	VARCHAR	24	True	False	True	False	%s		4.1	US, CA, UK
CreditCardTxnInfo_Input_TransactionMode	12	VARCHAR	14	True	False	True	False	CardNotPresent CardPresent		6.0	US, CA, UK
CreditCardTxnInfo_Input_CreditCardTxnType	12	VARCHAR	18	True	False	True	False	Authorization Capture Charge Refund VoiceAuthorization		7.0	US, CA, UK
CreditCardTxnInfo_Result_ResultCode	4	INTEGER	9	True	False	True	False	%14.1f		4.1	US, CA, UK
CreditCardTxnInfo_Result_ResultMessage	12	VARCHAR	60	True	False	True	False	%s		4.1	US, CA, UK
CreditCardTxnInfo_Result_CreditCardTransID	12	VARCHAR	24	True	False	True	False	%s		4.1	US, CA, UK
CreditCardTxnInfo_Result_MerchantAccountNumber	12	VARCHAR	32	True	False	True	False	%s		4.1	US, CA, UK
CreditCardTxnInfo_Result_AuthorizationCode	12	VARCHAR	12	True	False	True	False	%s		4.1	US, CA, UK
CreditCardTxnInfo_Result_AVSStreet	12	VARCHAR	12	True	False	True	False	Pass Fail NotAvailable		4.1	US, CA, UK
CreditCardTxnInfo_Result_AVSZip	12	VARCHAR	12	True	False	True	False	Pass Fail NotAvailable		4.1	US, CA, UK
CreditCardTxnInfo_Result_CardSecurityCodeMatch	12	VARCHAR	12	True	False	True	False	Pass Fail NotAvailable		6.0	US, CA, UK
CreditCardTxnInfo_Result_ReconBatchID	12	VARCHAR	84	True	False	True	False	%s		4.1	US, CA, UK
CreditCardTxnInfo_Result_PaymentGroupingCode	4	INTEGER	9	True	False	True	False	%11.0f		4.1	US, CA, UK
CreditCardTxnInfo_Result_PaymentStatus	12	VARCHAR	9	True	False	True	False	Unknown Completed		4.1	US, CA, UK
CreditCardTxnInfo_Result_TxnAuthorizationTime	93	TIMESTAMP	23	True	False	True	False	CCCC-MM-DDThh:mm:ssZ		4.1	US, CA, UK
CreditCardTxnInfo_Result_TxnAuthorizationStamp	4	INTEGER	4	True	False	True	False	%11.0f		4.1	US, CA, UK
CreditCardTxnInfo_Result_ClientTransID	12	VARCHAR	16	True	False	True	False	%s		6.0	US, CA, UK
Other	12	VARCHAR	29	True	True	True	False	%s		6.0	US, CA, UK
ExternalGUID	12	VARCHAR	40							9.0	US, CA, UK
SalesReceiptLineType	12	VARCHAR	10	True	False	False	False	ItemType		1.0	US, CA, UK
SalesReceiptLineGroup_TxnLineID	12	VARCHAR	36	True	True	False	False	%s		1.0	US, CA, UK
SalesReceiptLineGroup_ItemGroupRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	1.0	US, CA, UK
SalesReceiptLineGroup_ItemGroupRef_FullName	12	VARCHAR	31	True	True	True	False	%s	Name	1.0	US, CA, UK
SalesReceiptLineGroup_Desc	12	VARCHAR	4095	True	False	False	False	%s		1.0	US, CA, UK
SalesReceiptLineGroup_Quantity	4	INTEGER	9	True	True	True	False	%10.5f		1.0	US, CA, UK
SalesReceiptLineGroup_UnitOfMeasure	12	VARCHAR	31	True	True	True	False	%s		1.0	US, CA, UK
SalesReceiptLineGroup_OverrideUOMSetRef_ListID	12	VARCHAR	36	True	True	False	False	%s	ListID	1.0	US, CA, UK
SalesReceiptLineGroup_OverrideUOMSetRef_FullName	12	VARCHAR	31	True	True	False	False	%s	Name	1.0	US, CA, UK
SalesReceiptLineGroup_IsPrintItemsInGroup	-7	BIT	2	True	False	False	False	1 0 true false		1.0	US, CA, UK
SalesReceiptLineGroup_TotalAmount	2	NUMERIC	15	True	False	False	False	%10.2f		1.0	US, CA, UK
SalesReceiptLineGroup_InventorySiteRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	1.0	US, CA, UK
SalesReceiptLineGroup_InventorySiteRef_FullName	12	VARCHAR	31	True	True	True	False	%s	Name	1.0	US, CA, UK
SalesReceiptLineGroup_InventorySiteLocationRef_ListID	12	VARCHAR	36	True	True	True	False	%s		1.0	US, CA, UK
SalesReceiptLineGroup_InventorySiteLocationRef_FullName	12	VARCHAR	31	True	True	True	False	%s		1.0	US, CA, UK
SalesReceiptLine_TxnLineID	12	VARCHAR	36	True	True	False	False	%s		1.0	US, CA, UK
SalesReceiptLine_ItemRef_ListID	12	VARCHAR	36	True	True	True	False	%s		1.0	US, CA, UK
SalesReceiptLine_ItemRef_FullName	12	VARCHAR	159	True	True	True	False	%s		1.0	US, CA, UK
SalesReceiptLine_Desc	12	VARCHAR	4095	True	True	True	False	%s		1.0	US, CA, UK
SalesReceiptLine_Quantity	4	INTEGER	9	True	True	True	False	%10.5f		1.0	US, CA, UK
SalesReceiptLine_UnitOfMeasure	12	VARCHAR	31	True	True	True	False	%s		1.0	US, CA, UK
SalesReceiptLine_OverrideUOMSetRef_ListID	12	VARCHAR	36	True	True	False	False	%s	ListID	1.0	US, CA, UK
SalesReceiptLine_OverrideUOMSetRef_FullName	12	VARCHAR	31	True	True	False	False	%s	Name	1.0	US, CA, UK
SalesReceiptLine_Rate	2	NUMERIC	18	True	True	True	False	%10.5f		1.0	US, CA, UK
SalesReceiptLine_RatePercent	2	NUMERIC	18	True	True	True	False	%10.5f		1.0	US, CA, UK
SalesReceiptLine_PriceLevelRef_ListID	12	VARCHAR	36	True	True	True	False	%s		1.0	US, CA, UK
SalesReceiptLine_PriceLevelRef_FullName	12	VARCHAR	159	True	True	True	False	%s		1.0	US, CA, UK
SalesReceiptLine_ClassRef_ListID	12	VARCHAR	36	True	True	True	False	%s		1.0	US, CA, UK
SalesReceiptLine_ClassRef_FullName	12	VARCHAR	159	True	True	True	False	%s		1.0	US, CA, UK
SalesReceiptLine_Amount	2	NUMERIC	15	True	True	True	False	%10.2f		1.0	US, CA, UK
SalesReceiptLine_OptionForPriceRuleConflict	12	VARCHAR	9							1.0	US, CA, UK
SalesReceiptLine_InventorySiteRef_ListID	12	VARCHAR	36	True	True	True	False	%s		1.0	US, CA, UK
SalesReceiptLine_InventorySiteRef_FullName	12	VARCHAR	31	True	True	True	False	%s		1.0	US, CA, UK
SalesReceiptLine_SerialNumber	12	VARCHAR	4095	True	True	True	True	%s		1.0	US, CA, UK
SalesReceiptLine_LotNumber	12	VARCHAR	40	True	True	True	True	%s		1.0	US, CA, UK
SalesReceiptLine_ServiceDate	91	DATE	10	True	True	True	False	CCCC-MM-DD		1.0	US, CA, UK
SalesReceiptLine_SalesTaxCodeRef_ListID	12	VARCHAR	36	True	True	True	False	%s		1.0	US, CA, UK
SalesReceiptLine_SalesTaxCodeRef_FullName	12	VARCHAR	3	True	True	True	False	%s		1.0	US, CA, UK
SalesReceiptLine_OverrideItemAccountRef_ListID	12	VARCHAR	36	True	False	True	False	%s		1.0	US, CA, UK
SalesReceiptLine_OverrideItemAccountRef_FullName	12	VARCHAR	159	True	True	True	False	%s		1.0	US, CA, UK
SalesReceiptLine_Other1	12	VARCHAR	29	True	True	True	False	%s		1.0	US, CA, UK
SalesReceiptLine_Other2	12	VARCHAR	29	True	True	True	False	%s		1.0	US, CA, UK
SalesReceiptLine_CreditCardTxnInfo_Input_CreditCardNumber	12	VARCHAR	25	True	True	True	False	%s		4.1	US, CA, UK
SalesReceiptLine_CreditCardTxnInfo_Input_ExpirationMonth	4	INTEGER	9	True	True	True	False	%14.1f		4.1	US, CA, UK
SalesReceiptLine_CreditCardTxnInfo_Input_ExpirationYear	4	INTEGER	9	True	True	True	False	%14.1f		4.1	US, CA, UK
SalesReceiptLine_CreditCardTxnInfo_Input_NameOnCard	12	VARCHAR	41	True	True	True	False	%s		4.1	US, CA, UK
SalesReceiptLine_CreditCardTxnInfo_Input_CreditCardAddress	12	VARCHAR	41	True	True	True	False	%s		4.1	US, CA, UK
SalesReceiptLine_CreditCardTxnInfo_Input_CreditCardPostalCode	12	VARCHAR	41	True	True	True	False	%s		4.1	US, CA, UK
SalesReceiptLine_CreditCardTxnInfo_Input_CommercialCardCode	12	VARCHAR	24	True	True	True	False	%s		4.1	US, CA, UK
SalesReceiptLine_CreditCardTxnInfo_Input_TransactionMode	12	VARCHAR	14	True	True	True	False	CardNotPresent CardPresent		6.0	US, CA, UK
SalesReceiptLine_CreditCardTxnInfo_Input_CreditCardTxnType	12	VARCHAR	18	True	True	True	False	Authorization Capture Charge Refund VoiceAuthorization		7.0	US, CA, UK
SalesReceiptLine_CreditCardTxnInfo_Result_ResultCode	4	INTEGER	9	True	True	True	False	%14.1f		4.1	US, CA, UK
SalesReceiptLine_CreditCardTxnInfo_Result_ResultMessage	12	VARCHAR	60	True	True	True	False	%s		4.1	US, CA, UK
SalesReceiptLine_CreditCardTxnInfo_Result_CreditCardTransID	12	VARCHAR	24	True	True	True	False	%s		6.0	US, CA, UK
SalesReceiptLine_CreditCardTxnInfo_Result_MerchantAccountNumber	12	VARCHAR	32	True	True	True	False	%s		4.1	US, CA, UK
SalesReceiptLine_CreditCardTxnInfo_Result_AuthorizationCode	12	VARCHAR	12	True	True	True	False	%s		4.1	US, CA, UK
SalesReceiptLine_CreditCardTxnInfo_Result_AVSStreet	12	VARCHAR	12	True	True	True	False	Pass Fail NotAvailable		4.1	US, CA, UK
SalesReceiptLine_CreditCardTxnInfo_Result_AVSZip	12	VARCHAR	12	True	True	True	False	Pass Fail NotAvailable		4.1	US, CA, UK
SalesReceiptLine_CreditCardTxnInfo_Result_CardSecurityCodeMatch	12	VARCHAR	12	True	True	True	False	Pass Fail NotAvailable		6.0	US, CA, UK
SalesReceiptLine_CreditCardTxnInfo_Result_ReconBatchID	12	VARCHAR	84	True	True	True	False	%s		4.1	US, CA, UK
SalesReceiptLine_CreditCardTxnInfo_Result_PaymentGroupingCode	4	INTEGER	9	True	True	True	False	%14.1f		4.1	US, CA, UK
SalesReceiptLine_CreditCardTxnInfo_Result_PaymentStatus	12	VARCHAR	9	True	True	True	False	Unknown Completed		4.1	US, CA, UK
SalesReceiptLine_CreditCardTxnInfo_Result_TxnAuthorizationTime	93	TIMESTAMP	23	True	True	True	False	CCCC-MM-DDThh:mm:ssZ		4.1	US, CA, UK
SalesReceiptLine_CreditCardTxnInfo_Result_TxnAuthorizationStamp	4	INTEGER	9	True	True	True	False	%14.1f		4.1	US, CA, UK
SalesReceiptLine_CreditCardTxnInfo_Result_ClientTransID	12	VARCHAR	16	True	True	True	False	%s		6.0	US, CA, UK
RQUseCachedID	-7	BIT	2

Back to list of tables.

• About Easysoft

• Contact us
• About us
• Clients
• Blog
• Careers

• Products

• ODBC drivers
• JDBC drivers
• Bridges and gateways
• In development

• Services

• Consultancy
• Training
• Custom development

• Licensing

• Product licenses
• Prices

• Support

• Support home
• Solution wizard
• Getting Started Guides
• User Guides
• Knowledge Base

• Search

• Easysoft.com
• Documentation
• Knowledge Base

• Popular Resources

• Developer area
• Client applications

• Legal

• Privacy statement

© 1993 - 2024 Easysoft Limited. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other trademarks and registered trademarks appearing on easysoft.com are the property of their respective owners.

• 
• 
•