TABLE DETAIL REFERENCE: SalesReceiptLine
(Australia ,New Zealand,Singapore Southeast Asia 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
ThisFiscalYelities
Estimates
InventoryAssets
OpeningBalanceEquity
PayrollExpenses
PayrollLiabilities
PettyCash
P~õn,~õn))?_¸"x ¬ ± dLkwõnÌõnÜõn
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 13TrueFalseFalseFalse%8.2f
ItemSalesTaxRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ItemSalesTaxRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
SalesTaxPercentage3 DECIMAL 15TrueFalseFalseFalse%7.5f
SalesTaxTotal3 DECIMAL 13TrueFalseFalseFalse%8.2f
TotalAmount3 DECIMAL 13TrueFalseFalseFalse%8.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 1TrueTrueTrueFalse
1
0
true
false
CustomerSalesTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CustomerSalesTaxCodeRefFullName12 VARCHAR 6TrueTrueTrueFalse%s Yes
CustomerTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CustomerTaxCodeRefFullName12 VARCHAR 6TrueTrueTrueFalse%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
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 16TrueTrueTrueFalse%8.5f
SalesReceiptLineGroupIsPrintItemsInGroup-7 BIT 1TrueFalseFalseFalse
1
0
true
false
SalesReceiptLineGroupTotalAmount3 DECIMAL 13TrueFalseFalseFalse%8.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 16TrueTrueTrueFalse%8.5f
SalesReceiptLineRate3 DECIMAL 16TrueTrueTrueFalse%8.5f
SalesReceiptLineRatePercent3 DECIMAL 15TrueTrueTrueFalse%7.5f
SalesReceiptLinePriceLevelRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
SalesReceiptLinePriceLevelRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
SalesReceiptLineClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
SalesReceiptLineClassRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
SalesReceiptLineAmount3 DECIMAL 13TrueTrueTrueFalse%8.2f
SalesReceiptTaxAmount3 DECIMAL 13TrueTrueTrueFalse%8.2f
SalesReceiptLineServiceDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
SalesReceiptLineSalesTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
SalesReceiptLineSalesTaxCodeRefFullName12 VARCHAR 6TrueTrueTrueFalse%s Yes
SalesReceiptLineTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
SalesReceiptLineTaxCodeRefFullName12 VARCHAR 6TrueTrueTrueFalse%s Yes
CustomFieldSalesReceiptLineOther112 VARCHAR 29TrueTrueTrueFalse%s
CustomFieldSalesReceiptLineOther212 VARCHAR 29TrueTrueTrueFalse%s
Tax1Total3 DECIMAL 13TrueFalseFalseFalse%8.2f
Tax2Total3 DECIMAL 13TrueFalseFalseFalse%8.2f
ExchangeRate3 DECIMAL 15TrueFalseFalseFalse%6.8f
AmountIncludesVAT-7 BIT 1TrueTrueTrueFalse
1
0
true
false
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey
FQTxnLinkKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey