TABLE DETAIL REFERENCE:		Bill
(US VERSION)

FIELD NAME	TYPE	LENGTH	QRY	MOD	INS	REQ INS	VALIDATE	REL
TxnID	Varchar	36	True	False	False	N/A	String
TimeCreated	Timestamp	27	True	False	False	N/A	CCCC-MM-DDThh:mm:ssZ
TimeModified	Timestamp	27	True	False	False	N/A	CCCC-MM-DDThh:mm:ssZ
EditSequence	Varchar	16	True	False	False	N/A	String
TxnNumber	Integer	13	True	False	False	N/A	11.0
VendorRefListID	Varchar	36	True	False	True	Yes	String	Yes
VendorRefFullName	Varchar	41	True	True	True	Yes	String
APAccountRefListID	Varchar	36	True	False	True	No	String	Yes
APAccountRefFullName	Varchar	159	True	True	True	No	String
TxnDate	Date	10	True	True	True	No	CCCC-MM-DD
TxnDateMacro	Varchar	23	True	False	False	N/A	All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYear ThisFiscalYearToDate Yesterday LastWeek LastWeekToDate LastMonth LastMonthToDate LastCalendarQuarter LastCalendarQuarterToDate LastFiscalQuarter LastFiscalQuarterToDate LastCalendarYear LastCalendarYearToDate LastFiscalYear LastFiscalYearToDate NextWeek NextFourWeeks NextMonth NextCalendarQuarter NextCalendarYear NextFiscalQuarter NextFiscalYear
DueDate	Date	10	True	True	True	No	CCCC-MM-DD
AmountDue	Decimal	11	True	False	False	N/A	8.2
RefNumber	Varchar	20	True	True	True	No	String
TermsRefListID	Varchar	36	True	False	True	No	String	Yes
TermsRefFullName	Varchar	31	True	True	True	No	String
Memo	Varchar	4095	True	True	True	No	String
LinkToTxnID1	Varchar	36	True	False	True	No	String
IsPaid	Bit	5	True	False	False	N/A	1 0 true false