Details:SalesReceiptItem

TABLE DETAIL REFERENCE: SalesReceiptItem

(POS VERSION)

FIELD NAME	TYPE	TYPENAME	LENGTH	QUERYABLE	UPDATEABLE	INSERTABLE	REQUIRED ON INSERT	VALIDATE	RELATES TO
TxnID	12	VARCHAR	36	True	False	False	False	%s	Yes
TimeCreated	11	TIMESTAMP	16	True	False	False	False	CCCC-MM-DDThh:mm:ssZ
TimeModified	11	TIMESTAMP	16	True	False	False	False	CCCC-MM-DDThh:mm:ssZ
Associate	12	VARCHAR	40	True	False	True	False	%s
Cashier	12	VARCHAR	40	True	False	True	False	%s
Comments	12	VARCHAR	300	True	False	True	False	%s
CustomerListID	12	VARCHAR	36	True	False	True	False	%s	Yes
Discount	3	DECIMAL	20	True	False	True	False	%8.5f
DiscountPercent	3	DECIMAL	13	True	False	True	False	%8.2f
HistoryDocStatus	12	VARCHAR	9	True	False	False	False	Regular Reversed Reversing
ItemsCount	4	INTEGER	4	True	False	False	False	%11.0f
PriceLevelNumber	12	VARCHAR	1	True	False	True	False	1 2 3 4
PromoCode	12	VARCHAR	10	True	False	True	False	%s
QuickBooksFlag	12	VARCHAR	17	True	False	True	False	NotPosted Completed Error UnbilledPurchases
SalesOrderTxnID	12	VARCHAR	36	True	False	True	False	%s	Yes
SalesReceiptNumber	4	INTEGER	4	True	False	False	False	%11.0f
SalesReceiptType	12	VARCHAR	7	True	False	True	False	Sales Return Deposit Refund Payout Payin
ShipDate	9	DATE	6	True	False	True	False	CCCC-MM-DD
StoreExchangeStatus	12	VARCHAR	12	True	False	False	False	Modified Sent Acknowledged
StoreNumber	4	INTEGER	4	True	False	True	False	%11.0f
Subtotal	3	DECIMAL	20	True	False	False	False	%8.5f
TaxAmount	3	DECIMAL	20	True	False	False	False	%8.5f
TaxCategory	12	VARCHAR	20	True	False	True	False	%s
TaxPercentage	3	DECIMAL	13	True	False	False	False	%8.2f
TenderType	12	VARCHAR	12	True	False	False	False	None Cash Check CreditCard DebitCard GiftCard Account Gift Deposit Split
Total	3	DECIMAL	16	True	False	False	False	%8.5f
TrackingNumber	12	VARCHAR	50	True	False	True	False	%s
TxnDate	9	DATE	6	True	False	True	False	CCCC-MM-DD
TxnState	12	VARCHAR	6	True	False	True	False	Normal Held
Workstation	4	INTEGER	4	True	False	True	False	%11.0f
BillingInformationCity	12	VARCHAR	31	True	False	False	False	%s
BillingInformationCompanyName	12	VARCHAR	48	True	False	False	False	%s
BillingInformationCountry	12	VARCHAR	32	True	False	False	False	%s
BillingInformationFirstName	12	VARCHAR	30	True	False	False	False	%s
BillingInformationLastName	12	VARCHAR	30	True	False	False	False	%s
BillingInformationPhone	12	VARCHAR	40	True	False	False	False	%s
BillingInformationPhone2	12	VARCHAR	40	True	False	False	False	%s
BillingInformationPhone3	12	VARCHAR	40	True	False	False	False	%s
BillingInformationPhone4	12	VARCHAR	40	True	False	False	False	%s
BillingInformationPostalCode	12	VARCHAR	10	True	False	False	False	%s
BillingInformationSalutation	12	VARCHAR	15	True	False	False	False	%s
BillingInformationState	12	VARCHAR	21	True	False	False	False	%s
BillingInformationStreet	12	VARCHAR	41	True	False	False	False	%s
ShippingInformationCity	12	VARCHAR	31	True	False	True	False	%s
ShippingInformationCompanyName	12	VARCHAR	48	True	False	True	False	%s
ShippingInformationCountry	12	VARCHAR	32	True	False	True	False	%s
ShippingInformationFullName	12	VARCHAR	159	True	False	True	False	%s
ShippingInformationPhone	12	VARCHAR	15	True	False	True	False	%s
ShippingInformationPhone2	12	VARCHAR	15	True	False	True	False	%s
ShippingInformationPhone3	12	VARCHAR	15	True	False	True	False	%s
ShippingInformationPhone4	12	VARCHAR	15	True	False	True	False	%s
ShippingInformationPostalCode	12	VARCHAR	10	True	False	True	False	%s
ShippingInformationShipBy	12	VARCHAR	50	True	False	True	False	%s
ShippingInformationShipping	3	DECIMAL	16	True	False	True	False	%8.5f
ShippingInformationState	12	VARCHAR	21	True	False	True	False	%s
ShippingInformationStreet	12	VARCHAR	41	True	False	True	False	%s
SalesReceiptItemSeqNo	4	INTEGER	4	True	False	False	False	SeqNo
SalesReceiptItemListID	12	VARCHAR	36	False	False	True	False	%s
SalesReceiptItemALU	12	VARCHAR	20	False	False	True	False	%s
SalesReceiptItemAssociate	12	VARCHAR	40	False	False	True	False	%s
SalesReceiptItemAttribute	12	VARCHAR	8	False	False	True	False	%s
SalesReceiptItemCommission	3	DECIMAL	16	False	False	True	False	%8.5f
SalesReceiptItemCost	3	DECIMAL	18	True	False	False	False	%8.5f
SalesReceiptItemDesc1	12	VARCHAR	30	False	False	True	False	%s
SalesReceiptItemDesc2	12	VARCHAR	8000	False	False	True	False	%s
SalesReceiptItemDiscount	3	DECIMAL	20	False	False	True	False	%8.5f
SalesReceiptItemDiscountPercent	3	DECIMAL	13	False	False	True	False	%8.2f
SalesReceiptItemDiscountType	12	VARCHAR	16	False	False	True	False	%s
SalesReceiptItemExtendedPrice	3	DECIMAL	20	False	False	True	False	%8.5f
SalesReceiptItemExtendedTax	3	DECIMAL	20	False	False	True	False	%8.5f
SalesReceiptItemPrice	3	DECIMAL	16	False	False	True	False	%8.5f
SalesReceiptItemQty	3	DECIMAL	15	False	False	True	False	%7.5f
SalesReceiptItemSerialNumber	12	VARCHAR	25	False	False	True	False	%s
SalesReceiptItemSize	12	VARCHAR	8	False	False	True	False	%s
SalesReceiptItemTaxAmount	3	DECIMAL	20	False	False	True	False	%8.5f
SalesReceiptItemTaxCode	12	VARCHAR	100	False	False	True	False	%s
SalesReceiptItemUnitOfMeasure	12	VARCHAR	20	True	False	True	False	%s
SalesReceiptItemUPC	12	VARCHAR	18	False	False	True	False	%s
SalesReceiptItemWebDesc	12	VARCHAR	4095	True	False	True	False	%s
SalesReceiptItemManufacturer	12	VARCHAR	50	True	False	True	False	%s
SalesReceiptItemWeight	3	DECIMAL	15	True	False	True	False	%7.5f
SalesReceiptItemWebSKU	12	VARCHAR	20	True	False	True	False	%s
TenderAccount01TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderAccount01TipAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderAccount02TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderAccount02TipAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderAccount03TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderAccount03TipAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderAccount04TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderAccount04TipAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderAccount05TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderAccount05TipAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderAccount06TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderAccount06TipAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderAccount07TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderAccount07TipAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderAccount08TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderAccount08TipAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderAccount09TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderAccount09TipAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderAccount10TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderAccount10TipAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderCheck01CheckNumber	12	VARCHAR	32	True	False	True	False	%s
TenderCheck01TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderCheck02CheckNumber	12	VARCHAR	32	True	False	True	False	%s
TenderCheck02TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderCheck03CheckNumber	12	VARCHAR	32	True	False	True	False	%s
TenderCheck03TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderCheck04CheckNumber	12	VARCHAR	32	True	False	True	False	%s
TenderCheck04TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderCheck05CheckNumber	12	VARCHAR	32	True	False	True	False	%s
TenderCheck05TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderCheck06CheckNumber	12	VARCHAR	32	True	False	True	False	%s
TenderCheck06TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderCheck07CheckNumber	12	VARCHAR	32	True	False	True	False	%s
TenderCheck07TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderCheck08CheckNumber	12	VARCHAR	32	True	False	True	False	%s
TenderCheck08TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderCheck09CheckNumber	12	VARCHAR	32	True	False	True	False	%s
TenderCheck09TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderCheck10CheckNumber	12	VARCHAR	32	True	False	True	False	%s
TenderCheck10TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderCash01TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderCash02TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderCash03TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderCash04TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderCash05TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderCash06TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderCash07TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderCash08TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderCash09TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderCash10TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderCreditCard01CardName	12	VARCHAR	16	True	False	True	False	%s
TenderCreditCard01TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderCreditCard01TipAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderCreditCard02CardName	12	VARCHAR	16	True	False	True	False	%s
TenderCreditCard02TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderCreditCard02TipAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderCreditCard03CardName	12	VARCHAR	16	True	False	True	False	%s
TenderCreditCard03TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderCreditCard03TipAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderCreditCard04CardName	12	VARCHAR	16	True	False	True	False	%s
TenderCreditCard04TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderCreditCard04TipAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderCreditCard05CardName	12	VARCHAR	16	True	False	True	False	%s
TenderCreditCard05TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderCreditCard05TipAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderDebitCard01Cashback	3	DECIMAL	20	True	False	True	False	%8.5f
TenderDebitCard01TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderDebitCard02Cashback	3	DECIMAL	20	True	False	True	False	%8.5f
TenderDebitCard02TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderDebitCard03Cashback	3	DECIMAL	20	True	False	True	False	%8.5f
TenderDebitCard03TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderDebitCard04Cashback	3	DECIMAL	20	True	False	True	False	%8.5f
TenderDebitCard04TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderDebitCard05Cashback	3	DECIMAL	20	True	False	True	False	%8.5f
TenderDebitCard05TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderDeposit01TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderDeposit02TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderDeposit03TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderDeposit04TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderDeposit05TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderGift01TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderGift01GiftCertificateNumber	12	VARCHAR	32	True	False	True	False	%s
TenderGift02TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderGift02GiftCertificateNumber	12	VARCHAR	32	True	False	True	False	%s
TenderGift03TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderGift03GiftCertificateNumber	12	VARCHAR	32	True	False	True	False	%s
TenderGift04TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderGift04GiftCertificateNumber	12	VARCHAR	32	True	False	True	False	%s
TenderGift05TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderGift05GiftCertificateNumber	12	VARCHAR	32	True	False	True	False	%s
TenderGift06TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderGift06GiftCertificateNumber	12	VARCHAR	32	True	False	True	False	%s
TenderGift07TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderGift07GiftCertificateNumber	12	VARCHAR	32	True	False	True	False	%s
TenderGift08TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderGift08GiftCertificateNumber	12	VARCHAR	32	True	False	True	False	%s
TenderGift09TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderGift09GiftCertificateNumber	12	VARCHAR	32	True	False	True	False	%s
TenderGift10TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderGift10GiftCertificateNumber	12	VARCHAR	32	True	False	True	False	%s
TenderGiftCard01TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderGiftCard01TipAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderGiftCard02TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderGiftCard02TipAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderGiftCard03TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderGiftCard03TipAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderGiftCard04TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderGiftCard04TipAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderGiftCard05TenderAmount	3	DECIMAL	20	True	False	True	False	%8.5f
TenderGiftCard05TipAmount	3	DECIMAL	20	True	False	True	False	%8.5f
FQSaveToCache	-7	BIT	1	True	False	True	False	FQSaveToCache
FQPrimaryKey	12	VARCHAR	110	True	False	False	False	FQPrimaryKey

QODBC.com Tools for QuickBooks