TABLE DETAIL REFERENCE: SalesReceiptLine
(Online 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 10TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
CustomerRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CustomerRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
DepartmentRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepartmentRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
ClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ClassRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
ShipMethodRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ShipMethodRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 15TrueTrueTrueFalse%11.7f
GlobalTaxCalculation12 VARCHAR 15TrueTrueTrueFalse
TaxExcluded
TaxIncluded
NotApplicable
TxnDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
RefNumber12 VARCHAR 21TrueTrueTrueFalse%s
BillAddressAddr112 VARCHAR 500TrueTrueTrueFalse%s
BillAddressAddr212 VARCHAR 500TrueTrueTrueFalse%s
BillAddressAddr312 VARCHAR 500TrueTrueTrueFalse%s
BillAddressAddr412 VARCHAR 500TrueTrueTrueFalse%s
BillAddressAddr512 VARCHAR 500TrueTrueTrueFalse%s
BillAddressCity12 VARCHAR 255TrueTrueTrueFalse%s
BillAddressState12 VARCHAR 255TrueTrueTrueFalse%s
BillAddressPostalCode12 VARCHAR 30TrueTrueTrueFalse%s
BillAddressCountry12 VARCHAR 255TrueTrueTrueFalse%s
ShipAddressAddr112 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressAddr212 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressAddr312 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressAddr412 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressAddr512 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressCity12 VARCHAR 255TrueTrueTrueFalse%s
ShipAddressState12 VARCHAR 255TrueTrueTrueFalse%s
ShipAddressPostalCode12 VARCHAR 30TrueTrueTrueFalse%s
ShipAddressCountry12 VARCHAR 255TrueTrueTrueFalse%s
Memo12 VARCHAR 4000TrueTrueTrueFalse%s
ShipDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
TrackingNumber12 VARCHAR 1000TrueTrueTrueFalse%s
CheckNumber12 VARCHAR 25TrueTrueTrueFalse%s
PaymentMethodRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PaymentMethodRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
Subtotal3 DECIMAL 13TrueFalseFalseFalse%11.2f
SalesTaxPercentage3 DECIMAL 15TrueTrueTrueFalse%10.7f
SalesTaxTotal3 DECIMAL 13TrueTrueTrueFalse%11.2f
TotalAmount3 DECIMAL 15TrueTrueTrueFalse%11.2f
ApplyTaxAfterDiscount-7 BIT 1TrueTrueTrueFalse
1
0
true
false
IsToBePrinted-7 BIT 1TrueTrueTrueFalse
1
0
true
false
IsToBeEmailed-7 BIT 1TrueTrueTrueFalse
1
0
true
false
TxnSource12 VARCHAR 100TrueFalseFalseFalse%s
TransactionLocationType12 VARCHAR 32TrueTrueTrueFalse
WithinFrance
FranceOverseas
OutsideFranceWithEU
OutsideEU
HomeBalance3 DECIMAL 13TrueFalseFalseFalse%11.2f
DepositToAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepositToAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
SalesReceiptLineItemLineType12 VARCHAR 11TrueFalseFalseFalseItemType
SalesReceiptLineSeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
SalesReceiptLineTxnLineID12 VARCHAR 36TrueTrueFalseFalse%s
SalesReceiptLineItemRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
SalesReceiptLineItemRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
SalesReceiptLineDesc12 VARCHAR 4000TrueTrueTrueFalse%s
SalesReceiptLineQuantity3 DECIMAL 16TrueTrueTrueFalse%10.7f
SalesReceiptLineRate3 DECIMAL 18TrueTrueTrueFalse%10.7f
SalesReceiptLineRatePercent3 DECIMAL 15TrueTrueTrueFalse%10.7f
SalesReceiptLineClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
SalesReceiptLineClassRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
SalesReceiptLineAmount3 DECIMAL 13TrueTrueTrueFalse%11.2f
SalesReceiptLineTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
SalesReceiptLineTaxCodeRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
SalesReceiptTaxAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
SalesReceiptLineIsTaxable-7 BIT 1TrueTrueTrueFalse
1
0
true
false
SalesReceiptLineOverrideItemAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
SalesReceiptLineOverrideItemAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
SalesReceiptLineServiceDate9 DATE 6TrueTrueFalseFalseCCCC-MM-DD
DiscountLineAmount3 DECIMAL 15TrueTrueTrueFalse%11.2f
DiscountLineRatePercent3 DECIMAL 15TrueTrueTrueFalse%11.7f
DiscountLineAccountRefListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
DiscountLineAccountRefFullName12 VARCHAR 1000TrueFalseTrueFalse%s Yes
SalesTaxLineAmount3 DECIMAL 15TrueFalseTrueFalse%11.2f
SalesTaxLineRatePercent3 DECIMAL 15TrueFalseTrueFalse%10.7f
SalesTaxLineAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
SalesTaxLineAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey
FQTxnLinkKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey
CustomFieldCrew12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldCrew112 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldCrew212 VARCHAR 30TrueTrueTrueFalse%s