TABLE DETAIL REFERENCE: VendorCreditItemLine

(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	False	False	False	%11.0f
VendorRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
VendorRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
APAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
APAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
DepartmentRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
DepartmentRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
CurrencyRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	64	True	True	True	False	%s	Yes
ExchangeRate	3	DECIMAL	16	True	False	False	False	%11.7f
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
CreditAmount	3	DECIMAL	15	True	False	False	False	%11.2f
CreditAmountInHomeCurrency	3	DECIMAL	13	True	False	False	False	%11.2f
RefNumber	12	VARCHAR	21	True	False	True	False	%s
GlobalTaxCalculation	12	VARCHAR	15	True	True	True	False	TaxExcluded TaxIncluded NotApplicable
PrivateNote	12	VARCHAR	4000	True	True	True	False	%s
ItemLineSeqNo	4	INTEGER	4	True	False	False	False	SeqNo
ItemLineTxnLineID	12	VARCHAR	36	True	True	False	False	%s
ItemLineItemRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineItemRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
ItemLineMemo	12	VARCHAR	4000	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	1000	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
ItemLineAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
ItemLineCustomerRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineCustomerRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
ItemLineBillableStatus	12	VARCHAR	11	True	True	True	False	Billable NotBillable HasBeenBill
ItemLineMarkupInfoPercentBased	-7	BIT	1	True	False	False	False	1 0 true false
ItemLineMarkupInfoValue	3	DECIMAL	13	True	False	False	False	%10.7f
ItemLineMarkupInfoPercent	3	DECIMAL	13	True	False	False	False	%10.7f
ItemLineMarkupInfoPriceLevelRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
ItemLineMarkupInfoPriceLevelRefFullName	12	VARCHAR	209	True	False	False	False	%s	Yes
ItemLineTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineTaxCodeRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
OpenAmount	3	DECIMAL	15	True	False	False	False	%11.2f
FQSaveToCache	-7	BIT	1	True	False	True	False	FQSaveToCache
FQPrimaryKey	12	VARCHAR	110	True	True	False	False	FQPrimaryKey