TABLE DETAIL REFERENCE: Transfer

(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
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
CurrencyRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	64	True	True	True	False	%s	Yes
ExchangeRate	3	DECIMAL	13	True	False	True	False	%11.7f
TxnDate	9	DATE	6	True	True	False	False	CCCC-MM-DD
FromAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
FromAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
ToAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ToAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
TxnSource	12	VARCHAR	100	True	True	True	False	%s
Amount	3	DECIMAL	15	True	True	True	False	%11.2f
SalesTaxPercentage	3	DECIMAL	15	True	False	True	False	%10.7f
SalesTaxTotal	3	DECIMAL	13	True	False	True	False	%11.2f
Memo	12	VARCHAR	100	True	True	True	False	%s
TaxDetailDefaultTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
TaxDetailDefaultTaxCodeRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
TaxDetailTxnTaxCodeRef	12	VARCHAR	11	True	True	True	False	%8.2f
TaxDetailTotalTax	3	DECIMAL	13	True	True	True	False	%10.7f
TaxDetailReviewStatus	12	VARCHAR	11	True	True	True	False	Billable NotBillable HasBeenBill