TABLE DETAIL REFERENCE: VendorCreditExpenseLine

(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
ExpenseLineSeqNo	4	INTEGER	4	True	False	False	False	SeqNo
ExpenseLineTxnLineID	12	VARCHAR	36	True	True	False	False	%s
ExpenseLineMemo	12	VARCHAR	4000	True	True	True	False	%s
ExpenseLineClassRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ExpenseLineClassRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
ExpenseLineAmount	3	DECIMAL	15	True	True	True	False	%11.2f
ExpenseLineTaxAmount	3	DECIMAL	15	True	True	True	False	%11.2f
ExpenseLineIsTaxable	-7	BIT	1	True	True	True	False	1 0 true false
ExpenseLineAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ExpenseLineAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
ExpenseLineCustomerRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ExpenseLineCustomerRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
ExpenseLineBillableStatus	12	VARCHAR	23	True	True	True	False	Billable NotBillable HasBeenBilled
ExpenseLineMarkupInfoPercent	3	DECIMAL	13	True	False	False	False	%7.5f
ExpenseLineMarkupInfoPercentBased	-7	BIT	1	True	False	False	False	1 0 true false
ExpenseLineMarkupInfoPriceLevelRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
ExpenseLineMarkupInfoPriceLevelRefFullName	12	VARCHAR	209	True	False	False	False	%s	Yes
ExpenseLineMarkupInfoValue	3	DECIMAL	13	True	False	False	False	%8.2f
ExpenseLineTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ExpenseLineTaxCodeRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
ExpenseLineTaxInclusiveAmount	4	INTEGER	4	True	True	True	False	%11.0f
OpenAmount	3	DECIMAL	15	True	False	False	False	%11.2f
FQSaveToCache	-7	BIT	1	True	False	True	False	FQSaveToCache
FQPrimaryKey	12	VARCHAR	73	True	True	False	False	FQPrimaryKey