TABLE DETAIL REFERENCE: SalesReceiptItem
(POS 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
Associate12 VARCHAR 40TrueFalseTrueFalse%s
Cashier12 VARCHAR 40TrueFalseTrueFalse%s
Comments12 VARCHAR 300TrueFalseTrueFalse%s
CustomerListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
Discount3 DECIMAL 20TrueFalseTrueFalse%8.5f
DiscountPercent3 DECIMAL 13TrueFalseTrueFalse%8.2f
HistoryDocStatus12 VARCHAR 9TrueFalseFalseFalse
Regular
Reversed
Reversing
ItemsCount4 INTEGER 4TrueFalseFalseFalse%11.0f
PriceLevelNumber12 VARCHAR 1TrueFalseTrueFalse
1
2
3
4
PromoCode12 VARCHAR 10TrueFalseTrueFalse%s
QuickBooksFlag12 VARCHAR 17TrueFalseTrueFalse
NotPosted
Completed
Error
UnbilledPurchases
SalesOrderTxnID12 VARCHAR 36TrueFalseTrueFalse%s Yes
SalesReceiptNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
SalesReceiptType12 VARCHAR 7TrueFalseTrueFalse
Sales
Return
Deposit
Refund
Payout
Payin
ShipDate9 DATE 6TrueFalseTrueFalseCCCC-MM-DD
StoreExchangeStatus12 VARCHAR 12TrueFalseFalseFalse
Modified
Sent
Acknowledged
StoreNumber4 INTEGER 4TrueFalseTrueFalse%11.0f
Subtotal3 DECIMAL 20TrueFalseFalseFalse%8.5f
TaxAmount3 DECIMAL 20TrueFalseFalseFalse%8.5f
TaxCategory12 VARCHAR 20TrueFalseTrueFalse%s
TaxPercentage3 DECIMAL 13TrueFalseFalseFalse%8.2f
TenderType12 VARCHAR 12TrueFalseFalseFalse
None
Cash
Check
CreditCard
DebitCard
GiftCard
Account
Gift
Deposit
Split
Total3 DECIMAL 16TrueFalseFalseFalse%8.5f
TrackingNumber12 VARCHAR 50TrueFalseTrueFalse%s
TxnDate9 DATE 6TrueFalseTrueFalseCCCC-MM-DD
TxnState12 VARCHAR 6TrueFalseTrueFalse
Normal
Held
Workstation4 INTEGER 4TrueFalseTrueFalse%11.0f
BillingInformationCity12 VARCHAR 31TrueFalseFalseFalse%s
BillingInformationCompanyName12 VARCHAR 48TrueFalseFalseFalse%s
BillingInformationCountry12 VARCHAR 32TrueFalseFalseFalse%s
BillingInformationFirstName12 VARCHAR 30TrueFalseFalseFalse%s
BillingInformationLastName12 VARCHAR 30TrueFalseFalseFalse%s
BillingInformationPhone12 VARCHAR 40TrueFalseFalseFalse%s
BillingInformationPhone212 VARCHAR 40TrueFalseFalseFalse%s
BillingInformationPhone312 VARCHAR 40TrueFalseFalseFalse%s
BillingInformationPhone412 VARCHAR 40TrueFalseFalseFalse%s
BillingInformationPostalCode12 VARCHAR 10TrueFalseFalseFalse%s
BillingInformationSalutation12 VARCHAR 15TrueFalseFalseFalse%s
BillingInformationState12 VARCHAR 21TrueFalseFalseFalse%s
BillingInformationStreet12 VARCHAR 41TrueFalseFalseFalse%s
ShippingInformationCity12 VARCHAR 31TrueFalseTrueFalse%s
ShippingInformationCompanyName12 VARCHAR 48TrueFalseTrueFalse%s
ShippingInformationCountry12 VARCHAR 32TrueFalseTrueFalse%s
ShippingInformationFullName12 VARCHAR 159TrueFalseTrueFalse%s
ShippingInformationPhone12 VARCHAR 15TrueFalseTrueFalse%s
ShippingInformationPhone212 VARCHAR 15TrueFalseTrueFalse%s
ShippingInformationPhone312 VARCHAR 15TrueFalseTrueFalse%s
ShippingInformationPhone412 VARCHAR 15TrueFalseTrueFalse%s
ShippingInformationPostalCode12 VARCHAR 10TrueFalseTrueFalse%s
ShippingInformationShipBy12 VARCHAR 50TrueFalseTrueFalse%s
ShippingInformationShipping3 DECIMAL 16TrueFalseTrueFalse%8.5f
ShippingInformationState12 VARCHAR 21TrueFalseTrueFalse%s
ShippingInformationStreet12 VARCHAR 41TrueFalseTrueFalse%s
SalesReceiptItemSeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
SalesReceiptItemListID12 VARCHAR 36FalseFalseTrueFalse%s
SalesReceiptItemALU12 VARCHAR 20FalseFalseTrueFalse%s
SalesReceiptItemAssociate12 VARCHAR 40FalseFalseTrueFalse%s
SalesReceiptItemAttribute12 VARCHAR 8FalseFalseTrueFalse%s
SalesReceiptItemCommission3 DECIMAL 16FalseFalseTrueFalse%8.5f
SalesReceiptItemCost3 DECIMAL 18TrueFalseFalseFalse%8.5f
SalesReceiptItemDesc112 VARCHAR 30FalseFalseTrueFalse%s
SalesReceiptItemDesc212 VARCHAR 8000FalseFalseTrueFalse%s
SalesReceiptItemDiscount3 DECIMAL 20FalseFalseTrueFalse%8.5f
SalesReceiptItemDiscountPercent3 DECIMAL 13FalseFalseTrueFalse%8.2f
SalesReceiptItemDiscountType12 VARCHAR 16FalseFalseTrueFalse%s
SalesReceiptItemExtendedPrice3 DECIMAL 20FalseFalseTrueFalse%8.5f
SalesReceiptItemExtendedTax3 DECIMAL 20FalseFalseTrueFalse%8.5f
SalesReceiptItemPrice3 DECIMAL 16FalseFalseTrueFalse%8.5f
SalesReceiptItemQty3 DECIMAL 15FalseFalseTrueFalse%7.5f
SalesReceiptItemSerialNumber12 VARCHAR 25FalseFalseTrueFalse%s
SalesReceiptItemSize12 VARCHAR 8FalseFalseTrueFalse%s
SalesReceiptItemTaxAmount3 DECIMAL 20FalseFalseTrueFalse%8.5f
SalesReceiptItemTaxCode12 VARCHAR 100FalseFalseTrueFalse%s
SalesReceiptItemUnitOfMeasure12 VARCHAR 20TrueFalseTrueFalse%s
SalesReceiptItemUPC12 VARCHAR 18FalseFalseTrueFalse%s
SalesReceiptItemWebDesc12 VARCHAR 4095TrueFalseTrueFalse%s
SalesReceiptItemManufacturer12 VARCHAR 50TrueFalseTrueFalse%s
SalesReceiptItemWeight3 DECIMAL 15TrueFalseTrueFalse%7.5f
SalesReceiptItemWebSKU12 VARCHAR 20TrueFalseTrueFalse%s
TenderAccount01TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount01TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount02TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount02TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount03TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount03TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount04TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount04TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount05TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount05TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount06TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount06TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount07TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount07TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount08TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount08TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount09TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount09TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount10TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount10TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCheck01CheckNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderCheck01TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCheck02CheckNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderCheck02TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCheck03CheckNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderCheck03TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCheck04CheckNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderCheck04TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCheck05CheckNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderCheck05TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCheck06CheckNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderCheck06TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCheck07CheckNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderCheck07TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCheck08CheckNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderCheck08TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCheck09CheckNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderCheck09TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCheck10CheckNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderCheck10TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCash01TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCash02TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCash03TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCash04TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCash05TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCash06TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCash07TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCash08TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCash09TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCash10TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCreditCard01CardName12 VARCHAR 16TrueFalseTrueFalse%s
TenderCreditCard01TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCreditCard01TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCreditCard02CardName12 VARCHAR 16TrueFalseTrueFalse%s
TenderCreditCard02TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCreditCard02TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCreditCard03CardName12 VARCHAR 16TrueFalseTrueFalse%s
TenderCreditCard03TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCreditCard03TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCreditCard04CardName12 VARCHAR 16TrueFalseTrueFalse%s
TenderCreditCard04TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCreditCard04TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCreditCard05CardName12 VARCHAR 16TrueFalseTrueFalse%s
TenderCreditCard05TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCreditCard05TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderDebitCard01Cashback3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderDebitCard01TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderDebitCard02Cashback3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderDebitCard02TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderDebitCard03Cashback3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderDebitCard03TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderDebitCard04Cashback3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderDebitCard04TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderDebitCard05Cashback3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderDebitCard05TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderDeposit01TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderDeposit02TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderDeposit03TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderDeposit04TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderDeposit05TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGift01TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGift01GiftCertificateNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderGift02TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGift02GiftCertificateNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderGift03TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGift03GiftCertificateNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderGift04TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGift04GiftCertificateNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderGift05TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGift05GiftCertificateNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderGift06TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGift06GiftCertificateNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderGift07TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGift07GiftCertificateNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderGift08TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGift08GiftCertificateNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderGift09TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGift09GiftCertificateNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderGift10TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGift10GiftCertificateNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderGiftCard01TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGiftCard01TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGiftCard02TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGiftCard02TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGiftCard03TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGiftCard03TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGiftCard04TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGiftCard04TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGiftCard05TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGiftCard05TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey