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.