TABLE DETAIL REFERENCE: VendorCredit

(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
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	False	True	False	%s	Yes
VendorRefFullName	12	VARCHAR	41	True	False	True	False	%s	Yes
APAccountRefListID	12	VARCHAR	36	True	False	True	False	%s	Yes
APAccountRefFullName	12	VARCHAR	159	True	False	True	False	%s	Yes
TxnDate	9	DATE	6	True	False	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 ThisFiscalYeCC
CreditAmount	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	18	True	False	False	False	%6.6f
CreditAmountInHomeCurrency	3	DECIMAL	15	True	False	False	False	%10.2f
RefNumber	12	VARCHAR	20	True	False	True	False	%s
Memo	12	VARCHAR	4095	True	False	True	False	%s
IsTaxIncluded	-7	BIT	1	True	False	True	False	1 0 true false
SalesTaxCodeRefListID	12	VARCHAR	36	True	False	True	False	%s	Yes
SalesTaxCodeRefFullName	12	VARCHAR	3	True	False	True	False	%s	Yes
TaxCodeRefListID	12	VARCHAR	36	True	False	True	False	%s	Yes
TaxCodeRefFullName	12	VARCHAR	3	True	False	True	False	%s	Yes
ExternalGUID	12	VARCHAR	40	True	False	True	False	{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}
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