TABLE DETAIL REFERENCE: SalesReceiptLine
(USA VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 16TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
CustomerRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CustomerRefFullName12 VARCHAR 209TrueTrueTrueFalse%s Yes
ClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ClassRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
TemplateRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
TemplateRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
TxnDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
TxnDateMacro12 VARCHAR 23TrueFalseFalseFalse
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
RefNumber12 VARCHAR 11TrueTrueTrueFalse%s
BillAddressAddr112 VARCHAR 41TrueTrueTrueFalse%s
BillAddressAddr212 VARCHAR 41TrueTrueTrueFalse%s
BillAddressAddr312 VARCHAR 41TrueTrueTrueFalse%s
BillAddressAddr412 VARCHAR 41TrueTrueTrueFalse%s
BillAddressAddr512 VARCHAR 41TrueTrueTrueFalse%s
BillAddressCity12 VARCHAR 31TrueTrueTrueFalse%s
BillAddressState12 VARCHAR 21TrueTrueTrueFalse%s
BillAddressProvince12 VARCHAR 21TrueTrueTrueFalse%s
BillAddressCounty12 VARCHAR 21TrueTrueTrueFalse%s
BillAddressPostalCode12 VARCHAR 13TrueTrueTrueFalse%s
BillAddressCountry12 VARCHAR 31TrueTrueTrueFalse%s
BillAddressNote12 VARCHAR 41TrueTrueTrueFalse%s
BillAddressBlockAddr112 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr212 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr312 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr412 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr512 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressAddr112 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressAddr212 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressAddr312 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressAddr412 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressAddr512 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressCity12 VARCHAR 31TrueTrueTrueFalse%s
ShipAddressState12 VARCHAR 21TrueTrueTrueFalse%s
ShipAddressProvince12 VARCHAR 21TrueTrueTrueFalse%s
ShipAddressCounty12 VARCHAR 21TrueTrueTrueFalse%s
ShipAddressPostalCode12 VARCHAR 13TrueTrueTrueFalse%s
ShipAddressCountry12 VARCHAR 31TrueTrueTrueFalse%s
ShipAddressNote12 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressBlockAddr112 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr212 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr312 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr412 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr512 VARCHAR 41TrueFalseFalseFalse%s
IsPending-7 BIT 1TrueTrueTrueFalse
1
0
true
false
CheckNumber12 VARCHAR 25TrueTrueTrueFalse%s
PaymentMethodRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PaymentMethodRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
DueDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
SalesRepRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
SalesRepRefFullName12 VARCHAR 5TrueTrueTrueFalse%s Yes
ShipDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
ShipMethodRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ShipMethodRefFullName12 VARCHAR 15TrueTrueTrueFalse%s Yes
FOB12 VARCHAR 13TrueTrueTrueFalse%s
Subtotal3 DECIMAL 18TrueFalseFalseFalse%10.2f
ItemSalesTaxRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ItemSalesTaxRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
SalesTaxPercentage3 DECIMAL 18TrueFalseFalseFalse%10.5f
SalesTaxTotal3 DECIMAL 18TrueFalseFalseFalse%10.2f
ExchangeRate3 DECIMAL 17TrueTrueTrueFalse%11.7f
TotalAmount3 DECIMAL 17TrueFalseFalseFalse%10.2f
Memo12 VARCHAR 4095TrueTrueTrueFalse%s
CustomerMsgRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CustomerMsgRefFullName12 VARCHAR 101TrueTrueTrueFalse%s Yes
IsToBePrinted-7 BIT 1TrueTrueTrueFalse
1
0
true
false
IsToBeEmailed-7 BIT 1TrueTrueTrueFalse
1
0
true
false
IsTaxIncluded-7 BIT 1TrueFalseFalseFalse
1
0
true
false
CustomerSalesTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CustomerSalesTaxCodeRefFullName12 VARCHAR 3TrueTrueTrueFalse%s Yes
CustomerTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepositToAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepositToAccountRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
CreditCardTxnInfoInputCreditCardNumber12 VARCHAR 25TrueFalseTrueFalse%s
CreditCardTxnInfoInputExpirationMonth4 INTEGER 4TrueFalseTrueFalse%11.0f
CreditCardTxnInfoInputExpirationYear4 INTEGER 4TrueFalseTrueFalse%11.0f
CreditCardTxnInfoInputNameOnCard12 VARCHAR 41TrueFalseTrueFalse%s
CreditCardTxnInfoInputCreditCardAddress12 VARCHAR 41TrueFalseTrueFalse%s
CreditCardTxnInfoInputCreditCardPostalCode12 VARCHAR 41TrueFalseTrueFalse%s
CreditCardTxnInfoInputCommercialCardCode12 VARCHAR 50TrueFalseTrueFalse%s
CreditCardTxnInfoInputTransactionMode12 VARCHAR 14TrueFalseTrueFalse
CardNotPresent
CardPresent
CreditCardTxnInfoInputCreditCardTxnType12 VARCHAR 18TrueFalseTrueFalse
Authorization
Capture
Charge
Refund
VoiceAuthorization
CreditCardTxnInfoResultResultCode4 INTEGER 4TrueFalseTrueFalse%11.0f
CreditCardTxnInfoResultResultMessage12 VARCHAR 500TrueFalseTrueFalse%s
CreditCardTxnInfoResultCreditCardTransID12 VARCHAR 24TrueFalseTrueFalse%s
CreditCardTxnInfoResultMerchantAccountNumber12 VARCHAR 32TrueFalseTrueFalse%s
CreditCardTxnInfoResultAuthorizationCode12 VARCHAR 12TrueFalseTrueFalse%s
CreditCardTxnInfoResultAVSStreet12 VARCHAR 12TrueFalseTrueFalse
Pass
Fail
NotAvailable
CreditCardTxnInfoResultAVSZip12 VARCHAR 12TrueFalseTrueFalse
Pass
Fail
NotAvailable
CreditCardTxnInfoResultCardSecurityCodeMatch12 VARCHAR 12TrueFalseTrueFalse
Pass
Fail
NotAvailable
CreditCardTxnInfoResultReconBatchID12 VARCHAR 84TrueFalseTrueFalse%s
CreditCardTxnInfoResultPaymentGroupingCode4 INTEGER 4TrueFalseTrueFalse%11.0f
CreditCardTxnInfoResultPaymentStatus12 VARCHAR 9TrueFalseTrueFalse
Unknown
Completed
CreditCardTxnInfoResultTxnAuthorizationTime11 TIMESTAMP 16TrueFalseTrueFalseCCCC-MM-DDThh:mm:ssZ
CreditCardTxnInfoResultTxnAuthorizationStamp4 INTEGER 4TrueFalseTrueFalse%11.0f
CreditCardTxnInfoResultClientTransID12 VARCHAR 16TrueFalseTrueFalse%s
CustomFieldOther12 VARCHAR 29TrueTrueTrueFalse%s
SalesReceiptLineItemLineType12 VARCHAR 11TrueFalseFalseFalseItemType
SalesReceiptLineSeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
SalesReceiptLineGroupTxnLineID12 VARCHAR 36TrueTrueFalseFalse%s
SalesReceiptLineGroupItemGroupRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
SalesReceiptLineGroupItemGroupRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
SalesReceiptLineGroupDesc12 VARCHAR 4095TrueFalseFalseFalse%s
SalesReceiptLineGroupQuantity3 DECIMAL 18TrueTrueTrueFalse%10.5f
SalesReceiptLineGroupUnitOfMeasure12 VARCHAR 31TrueTrueTrueFalse%s Yes
SalesReceiptLineGroupInventorySiteRefListID12 VARCHAR 36FalseFalseTrueFalse%s Yes
SalesReceiptLineGroupInventorySiteRefFullName12 VARCHAR 31FalseFalseTrueFalse%s Yes
SalesReceiptLineGroupInventorySiteLocationRefListID12 VARCHAR 36FalseFalseTrueFalse%s Yes
SalesReceiptLineGroupInventorySiteLocationRefFullName12 VARCHAR 31FalseFalseTrueFalse%s Yes
SalesReceiptLineGroupOverrideUOMSetRefListID12 VARCHAR 36TrueTrueFalseFalse%s Yes
SalesReceiptLineGroupOverrideUOMSetRefFullName12 VARCHAR 31TrueTrueFalseFalse%s Yes
SalesReceiptLineGroupIsPrintItemsInGroup-7 BIT 1TrueFalseFalseFalse
1
0
true
false
SalesReceiptLineGroupTotalAmount3 DECIMAL 18TrueFalseFalseFalse%10.2f
SalesReceiptLineGroupServiceDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
SalesReceiptLineGroupSeqNo4 INTEGER 4TrueFalseFalseFalseSubSeqNo
SalesReceiptLineTxnLineID12 VARCHAR 36TrueTrueFalseFalse%s
SalesReceiptLineItemRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
SalesReceiptLineItemRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
SalesReceiptLineDesc12 VARCHAR 4095TrueTrueTrueFalse%s
SalesReceiptLineQuantity3 DECIMAL 18TrueTrueTrueFalse%10.5f
SalesReceiptLineUnitOfMeasure12 VARCHAR 31TrueTrueTrueFalse%s Yes
SalesReceiptLineOverrideUOMSetRefListID12 VARCHAR 36TrueTrueFalseFalse%s Yes
SalesReceiptLineOverrideUOMSetRefFullName12 VARCHAR 31TrueTrueFalseFalse%s Yes
SalesReceiptLineRate3 DECIMAL 18TrueTrueTrueFalse%10.5f
SalesReceiptLineRatePercent3 DECIMAL 18TrueTrueTrueFalse%10.5f
SalesReceiptLinePriceLevelRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
SalesReceiptLinePriceLevelRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
SalesReceiptLineClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
SalesReceiptLineClassRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
SalesReceiptLineAmount3 DECIMAL 18TrueTrueTrueFalse%10.2f
SalesReceiptLineInventorySiteRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
SalesReceiptLineInventorySiteRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
SalesReceiptLineInventorySiteLocationRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
SalesReceiptLineInventorySiteLocationRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
SalesReceiptLineSerialNumber12 VARCHAR 4095TrueTrueTrueFalse%s
SalesReceiptLineLotNumber12 VARCHAR 40TrueTrueTrueFalse%s
SalesReceiptTaxAmount3 DECIMAL 15TrueFalseFalseFalse%10.2f
SalesReceiptLineServiceDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
SalesReceiptLineSalesTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
SalesReceiptLineSalesTaxCodeRefFullName12 VARCHAR 3TrueTrueTrueFalse%s Yes
SalesReceiptLineTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
SalesReceiptLineTaxCodeRefFullName12 VARCHAR 3TrueTrueTrueFalse%s Yes
SalesReceiptLineOverrideItemAccountRefListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
SalesReceiptLineOverrideItemAccountRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
CustomFieldSalesReceiptLineOther112 VARCHAR 29TrueTrueTrueFalse%s
CustomFieldSalesReceiptLineOther212 VARCHAR 29TrueTrueTrueFalse%s
Tax1Total3 DECIMAL 17TrueFalseFalseFalse%10.2f
Tax2Total3 DECIMAL 17TrueFalseFalseFalse%10.2f
AmountIncludesVAT-7 BIT 1TrueFalseFalseFalse
1
0
true
false
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey
FQTxnLinkKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey
CustomFieldSalesReceiptLineALU12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldSalesReceiptLineALU212 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldSalesReceiptLineApproved12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldSalesReceiptLineColor12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldSalesReceiptLineCompletedby12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldSalesReceiptLineCustomer12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldSalesReceiptLineInspectedBy12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldSalesReceiptLineOrdered12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldSalesReceiptLinePulled12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldSalesReceiptLinePulledby12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldSalesReceiptLineQtyPriceBreak12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldSalesReceiptLineRequiredDate12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldSalesReceiptLineStartDate12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldSalesReceiptLineStyle12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldSalesReceiptLineGroupALU12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldSalesReceiptLineGroupALU212 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldSalesReceiptLineGroupApproved12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldSalesReceiptLineGroupColor12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldSalesReceiptLineGroupCompletedby12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldSalesReceiptLineGroupCustomer12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldSalesReceiptLineGroupInspectedBy12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldSalesReceiptLineGroupOrdered12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldSalesReceiptLineGroupPulled12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldSalesReceiptLineGroupPulledby12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldSalesReceiptLineGroupQtyPriceBreak12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldSalesReceiptLineGroupRequiredDate12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldSalesReceiptLineGroupStartDate12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldSalesReceiptLineGroupStyle12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldSalesReceiptLineGroupLineALU12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldSalesReceiptLineGroupLineALU212 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldSalesReceiptLineGroupLineApproved12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldSalesReceiptLineGroupLineColor12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldSalesReceiptLineGroupLineCompletedby12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldSalesReceiptLineGroupLineCustomer12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldSalesReceiptLineGroupLineInspectedBy12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldSalesReceiptLineGroupLineOrdered12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldSalesReceiptLineGroupLinePulled12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldSalesReceiptLineGroupLinePulledby12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldSalesReceiptLineGroupLineQtyPriceBreak12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldSalesReceiptLineGroupLineRequiredDate12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldSalesReceiptLineGroupLineStartDate12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldSalesReceiptLineGroupLineStyle12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldShipAccount12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldShipMethod12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldShipVendor12 VARCHAR 30TrueTrueTrueFalse%s