Details:BillItemLine

TABLE DETAIL REFERENCE: BillItemLine

(UK 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
EditSequence	12	VARCHAR	16	True	False	False	False	%s
TxnNumber	4	INTEGER	4	True	False	False	False	%11.0f
VendorRefListID	12	VARCHAR	36	True	True	True	True	%s	Yes
VendorRefFullName	12	VARCHAR	41	True	True	True	True	%s	Yes
VendorAddressAddr1	12	VARCHAR	41	True	True	True	False	%s
VendorAddressAddr2	12	VARCHAR	41	True	True	True	False	%s
VendorAddressAddr3	12	VARCHAR	41	True	True	True	False	%s
VendorAddressAddr4	12	VARCHAR	41	True	True	True	False	%s
VendorAddressCity	12	VARCHAR	31	True	True	True	False	%s
VendorAddressState	12	VARCHAR	21	True	True	True	False	%s
VendorAddressPostalCode	12	VARCHAR	13	True	True	True	False	%s
APAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
APAccountRefFullName	12	VARCHAR	159	True	True	True	False	%s	Yes
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
TxnDateMacro	12	VARCHAR	23	True	False	False	False	All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYeRX<°ÖeüTà™ ‘T
DueDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
AmountDue	3	DECIMAL	15	True	False	False	False	%10.2f
CurrencyRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	159	True	False	False	False	%s	Yes
ExchangeRate	3	DECIMAL	15	True	True	True	False	%6.6f
AmountDueInHomeCurrency	3	DECIMAL	15	True	False	False	False	%10.2f
RefNumber	12	VARCHAR	20	True	True	True	False	%s
TermsRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
TermsRefFullName	12	VARCHAR	31	True	True	True	False	%s	Yes
Memo	12	VARCHAR	4095	True	True	True	False	%s
IsTaxIncluded	-7	BIT	1	True	True	True	False	1 0 true false
SalesTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
SalesTaxCodeRefFullName	12	VARCHAR	3	True	True	True	False	%s	Yes
TaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
TaxCodeRefFullName	12	VARCHAR	3	True	True	True	False	%s	Yes
LinkToTxnID1	12	VARCHAR	36	True	False	True	False	%s
IsPaid	-7	BIT	1	True	False	False	False	1 0 true false
ItemLineType	12	VARCHAR	11	True	False	False	False	ItemType
ItemLineSeqNo	4	INTEGER	4	True	False	False	False	SeqNo
ItemGroupLineTxnLineID	12	VARCHAR	36	True	True	False	False	%s
ItemGroupLineItemGroupRefListID	12	VARCHAR	36	True	True	True	True	%s	Yes
ItemGroupLineItemGroupRefFullName	12	VARCHAR	31	True	True	True	True	%s	Yes
ItemGroupLineQuantity	3	DECIMAL	18	True	True	True	False	%10.5f
ItemGroupUnitOfMeasure	12	VARCHAR	31	True	True	True	False	%s	Yes
ItemGroupOverrideUOMSetRefListID	12	VARCHAR	36	True	True	False	False	%s	Yes
ItemGroupOverrideUOMSetRefFullName	12	VARCHAR	31	True	True	False	False	%s	Yes
ItemGroupLineTotalAmount	3	DECIMAL	18	True	False	False	False	%10.5f
ItemGroupSeqNo	4	INTEGER	4	True	False	False	False	SubSeqNo
ItemLineTxnLineID	12	VARCHAR	36	True	True	False	False	%s
ItemLineItemRefListID	12	VARCHAR	36	True	True	True	True	%s	Yes
ItemLineItemRefFullName	12	VARCHAR	159	True	True	True	True	%s	Yes
ItemLineInventorySiteRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineInventorySiteRefFullName	12	VARCHAR	31	True	True	True	False	%s	Yes
ItemLineInventorySiteLocationRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineInventorySiteLocationRefFullName	12	VARCHAR	31	True	True	True	False	%s	Yes
ItemLineSerialNumber	12	VARCHAR	4095	True	True	True	False	%s
ItemLineLotNumber	12	VARCHAR	40	True	True	True	False	%s
ItemLineDesc	12	VARCHAR	4095	True	True	True	False	%s
ItemLineQuantity	3	DECIMAL	18	True	True	True	False	%10.5f
ItemLineUnitOfMeasure	12	VARCHAR	31	True	True	True	False	%s	Yes
ItemLineOverrideUOMSetRefListID	12	VARCHAR	36	True	True	False	False	%s	Yes
ItemLineOverrideUOMSetRefFullName	12	VARCHAR	31	True	True	False	False	%s	Yes
ItemLineCost	3	DECIMAL	18	True	True	True	False	%10.5f
ItemLineAmount	3	DECIMAL	15	True	True	True	False	%10.2f
ItemLineTaxAmount	3	DECIMAL	15	True	False	False	False	%10.2f
ItemLineTax1Amount	3	DECIMAL	15	True	False	False	False	%10.2f
ItemLineCustomerRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineCustomerRefFullName	12	VARCHAR	209	True	True	True	False	%s	Yes
ItemLineClassRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineClassRefFullName	12	VARCHAR	159	True	True	True	False	%s	Yes
ItemLineSalesTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineSalesTaxCodeRefFullName	12	VARCHAR	3	True	True	True	False	%s	Yes
ItemLineTaxCodeRefFullName	12	VARCHAR	3	True	True	True	False	%s	Yes
ItemLineBillableStatus	12	VARCHAR	13	True	True	True	False	Billable NotBillable HasBeenBilled
ItemLineOverrideItemAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineOverrideItemAccountRefFullName	12	VARCHAR	159	True	True	True	False	%s	Yes
ItemLineLinkToTxnTxnID	12	VARCHAR	36	True	False	True	False	%s
ItemLineLinkToTxnTxnLineID	12	VARCHAR	36	True	False	True	False	%s
Tax1Total	3	DECIMAL	15	True	False	False	False	%10.2f
Tax2Total	3	DECIMAL	15	True	False	False	False	%10.2f
OpenAmount	3	DECIMAL	15	True	False	False	False	%10.2f
AmountIncludesVAT	-7	BIT	1	True	False	False	False	1 0 true false
FQSaveToCache	-7	BIT	1	True	False	True	False	FQSaveToCache
FQPrimaryKey	12	VARCHAR	110	True	True	False	False	FQPrimaryKey
FQTxnLinkKey	12	VARCHAR	110	True	True	False	False	FQPrimaryKey

QODBC.com Tools for QuickBooks