Details:SalesOrderItem

TABLE DETAIL REFERENCE: SalesOrderItem

(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	True	True	False	%s
BalanceDue	3	DECIMAL	16	True	False	False	False	%8.5f
Cashier	12	VARCHAR	40	True	True	True	False	%s
CustomerListID	12	VARCHAR	36	True	True	True	True	%s	Yes
DepositBalance	3	DECIMAL	16	True	False	False	False	%8.5f
Discount	3	DECIMAL	16	True	True	True	False	%8.5f
DiscountPercent	3	DECIMAL	13	True	True	True	False	%8.2f
Instructions	12	VARCHAR	2000	True	True	True	False	%s
ItemsCount	4	INTEGER	4	True	False	False	False	%11.0f
PriceLevelNumber	12	VARCHAR	1	True	True	True	False	1 2 3 4
PromoCode	12	VARCHAR	10	True	True	True	False	%s
Qty	3	DECIMAL	15	True	False	False	False	%7.5f
SalesOrderNumber	12	VARCHAR	32	True	False	False	False	%11.0f
SalesOrderStatusDesc	12	VARCHAR	50	True	True	True	False	%s
SalesOrderType	12	VARCHAR	10	True	True	True	False	SalesOrder Layaway WorkOrder
StoreExchangeStatus	12	VARCHAR	12	True	False	False	False	Modified Sent Acknowledged
Subtotal	3	DECIMAL	16	True	False	False	False	%8.5f
TaxAmount	3	DECIMAL	16	True	False	False	False	%8.5f
TaxCategory	12	VARCHAR	20	True	True	True	False	%s
TaxPercent	3	DECIMAL	13	True	False	False	False	%8.2f
Total	3	DECIMAL	16	True	False	False	False	%8.5f
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
UnfilledPercent	3	DECIMAL	13	True	False	False	False	%8.2f
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	15	True	False	False	False	%s
BillingInformationPhone2	12	VARCHAR	15	True	False	False	False	%s
BillingInformationPhone3	12	VARCHAR	15	True	False	False	False	%s
BillingInformationPhone4	12	VARCHAR	15	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	True	True	False	%s
ShippingInformationCompanyName	12	VARCHAR	48	True	True	True	False	%s
ShippingInformationCountry	12	VARCHAR	32	True	True	True	False	%s
ShippingInformationFullName	12	VARCHAR	159	True	True	True	False	%s
ShippingInformationPhone	12	VARCHAR	15	True	True	True	False	%s
ShippingInformationPhone2	12	VARCHAR	15	True	True	True	False	%s
ShippingInformationPhone3	12	VARCHAR	15	True	True	True	False	%s
ShippingInformationPhone4	12	VARCHAR	15	True	True	True	False	%s
ShippingInformationPostalCode	12	VARCHAR	10	True	True	True	False	%s
ShippingInformationShipBy	12	VARCHAR	50	True	True	True	False	%s
ShippingInformationShipping	3	DECIMAL	16	True	True	True	False	%8.5f
ShippingInformationState	12	VARCHAR	21	True	True	True	False	%s
ShippingInformationStreet	12	VARCHAR	41	True	True	True	False	%s
ShippingInformationStreet2	12	VARCHAR	41	True	True	True	False	%s
SalesOrderItemSeqNo	4	INTEGER	4	True	False	False	False	SeqNo
SalesOrderItemListID	12	VARCHAR	36	True	True	True	True	%s
SalesOrderItemTxnLineID	4	INTEGER	4	True	True	False	False	%11.0f
SalesOrderItemALU	12	VARCHAR	20	True	True	True	False	%s
SalesOrderItemAssociate	12	VARCHAR	40	True	True	True	False	%s
SalesOrderItemAttribute	12	VARCHAR	12	True	True	True	False	%s
SalesOrderItemCommission	3	DECIMAL	16	True	True	True	False	%8.5f
SalesOrderItemDesc1	12	VARCHAR	30	True	True	True	False	%s
SalesOrderItemDesc2	12	VARCHAR	8000	True	True	True	False	%s
SalesOrderItemDiscount	3	DECIMAL	13	True	True	True	False	%8.2f
SalesOrderItemDiscountPercent	3	DECIMAL	13	True	True	True	False	%8.2f
SalesOrderItemDiscountType	12	VARCHAR	16	True	True	True	False	%s
SalesOrderItemExtendedPrice	3	DECIMAL	16	True	True	True	False	%8.5f
SalesOrderItemExtendedTax	3	DECIMAL	16	True	False	False	False	%8.5f
SalesOrderItemItemNumber	4	INTEGER	4	True	False	False	False	%11.0f
SalesOrderItemPrice	3	DECIMAL	16	True	True	True	False	%8.5f
SalesOrderItemPriceLevelNumber	12	VARCHAR	1	True	False	False	False	1 2 3 4
SalesOrderItemQty	3	DECIMAL	15	True	True	True	False	%7.5f
SalesOrderItemSerialNumber	12	VARCHAR	25	True	True	True	False	%s
SalesOrderItemSize	12	VARCHAR	8	True	True	True	False	%s
SalesOrderItemTaxAmount	3	DECIMAL	16	True	False	False	False	%8.5f
SalesOrderItemTaxCode	12	VARCHAR	36	True	True	True	False	%s
SalesOrderItemTaxPercent	3	DECIMAL	13	True	False	False	False	%8.2f
SalesOrderItemUnitOfMeasure	12	VARCHAR	20	True	True	True	False	%s
SalesOrderItemUPC	12	VARCHAR	18	True	True	True	False	%s
SalesOrderItemWebDesc	12	VARCHAR	4095	True	False	False	False	%s
SalesOrderItemManufacturer	12	VARCHAR	50	True	False	False	False	%s
SalesOrderItemWeight	3	DECIMAL	15	True	False	False	False	%7.5f
SalesOrderItemWebSKU	12	VARCHAR	20	True	False	False	False	%s
FQSaveToCache	-7	BIT	1	True	True	True	False	FQSaveToCache
FQPrimaryKey	12	VARCHAR	110	True	False	False	False	FQPrimaryKey

QODBC.com Tools for QuickBooks