TABLE DETAIL REFERENCE: BillItemLine

(Online 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	10	True	False	False	False	%s
TxnNumber	4	INTEGER	4	True	True	True	False	%11.0f
VendorRefListID	12	VARCHAR	36	True	True	True	True	%s	Yes
VendorRefFullName	12	VARCHAR	1000	True	True	True	True	%s	Yes
APAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
APAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
CurrencyRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
ExchangeRate	3	DECIMAL	13	True	False	True	False	%11.7f
DepartmentRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
DepartmentRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
DueDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
AmountDue	3	DECIMAL	13	True	True	True	False	%11.2f
RefNumber	12	VARCHAR	21	True	True	True	False	%s
TermsRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
TermsRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
Memo	12	VARCHAR	4000	True	True	True	False	%s
GlobalTaxCalculation	12	VARCHAR	15	True	True	True	False	TaxExcluded TaxIncluded NotApplicable
ItemLineTxnLineID	12	VARCHAR	36	True	True	False	False	%s
ItemLineNumber	12	VARCHAR	16	True	False	False	False	%s
ItemLineItemRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineItemRefFullName	12	VARCHAR	209	True	True	True	False	%s	Yes
ItemLineMemo	12	VARCHAR	4095	True	True	True	False	%s
ItemLineQuantity	3	DECIMAL	16	True	True	True	False	%10.7f
ItemLineRate	3	DECIMAL	18	True	True	True	False	%10.7f
ItemLineClassRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineClassRefFullName	12	VARCHAR	209	True	True	True	False	%s	Yes
ItemLineAmount	3	DECIMAL	15	True	True	True	False	%11.2f
ItemLineIsTaxable	-7	BIT	1	True	True	True	False	1 0 true false
ItemLineDetailType	12	VARCHAR	32	True	False	False	False	ItemBasedExpenseLineDetail
ItemLineCustomerRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineCustomerRefFullName	12	VARCHAR	209	True	True	True	False	%s	Yes
ItemLineBillableStatus	12	VARCHAR	11	True	True	True	False	Billable NotBillable HasBeenBill
ItemLineMarkupInfoPercent	3	DECIMAL	13	True	False	False	False	%10.7f
ItemLineMarkupInfoPercentBased	-7	BIT	1	True	False	False	False	1 0 true false
ItemLineMarkupInfoPriceLevelRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
ItemLineMarkupInfoPriceLevelRefFullName	12	VARCHAR	209	True	False	False	False	%s	Yes
ItemLineMarkupInfoValue	3	DECIMAL	13	True	False	False	False	%10.7f
ItemLineTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineTaxCodeRefFullName	12	VARCHAR	209	True	True	True	False	%s	Yes
ItemLineTaxInclusiveAmount	4	INTEGER	4	True	True	True	False	%11.0f
ExpenseLineBillableStatus	12	VARCHAR	23	True	True	True	False	Billable NotBillable HasBeenBilled
OpenAmount	3	DECIMAL	15	True	False	False	False	%11.2f
HomeBalance	3	DECIMAL	13	True	False	False	False	%11.2f
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