TABLE DETAIL REFERENCE:
  
(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
AccountRefListID Varchar 36 True False True Yes String
AccountRefFullName Varchar 159 True False True Yes String
PayeeEntityRefListID Varchar 36 True False True No String
PayeeEntityRefFullName Varchar 209 True False True No String
RefNumber Varchar 11 True False True No String
TxnDate Date 10 True False 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
Amount Decimal 11 True False False N/A 8.2
Memo Varchar 4095 True False True No String
AddressAddr1 Varchar 41 True False True No String
AddressAddr2 Varchar 41 True False True No String
AddressAddr3 Varchar 41 True False True No String
AddressAddr4 Varchar 41 True False True No String
AddressAddr5 Varchar 41 True True True No String
AddressCity Varchar 31 True False True No String
AddressState Varchar 21 True False True No String
AddressPostalCode Varchar 13 True False True No String
AddressCountry Varchar 31 True False True No String
AddressNote Varchar 41 True True True No String
AddressBlockAddr1 Varchar 41 True False False N/A String
AddressBlockAddr2 Varchar 41 True False False N/A String
AddressBlockAddr3 Varchar 41 True False False N/A String
AddressBlockAddr4 Varchar 41 True False False N/A String
AddressBlockAddr5 Varchar 41 True False False N/A String
IsToBePrinted Bit 5 True False True No 1 0 true false
ExpenseLineClearExpenseLines Bit 5 True True False N/A 1 0 true false
ExpenseLineSeqNo Integer 13 True False False N/A SeqNo
ExpenseLineTxnLineID Varchar 36 True True False N/A String
ExpenseLineAccountRefListID Varchar 36 True False True No String
ExpenseLineAccountRefFullName Varchar 159 True True True No String
ExpenseLineAmount Decimal 11 True True True No 8.2
ExpenseLineMemo Varchar 4095 True True True No String
ExpenseLineCustomerRefListID Varchar 36 True False True No String
ExpenseLineCustomerRefFullName Varchar 209 True True True No String
ExpenseLineClassRefListID Varchar 36 True False True No String
ExpenseLineClassRefFullName Varchar 159 True True True No String
ExpenseLineBillableStatus Varchar 13 True True True No Billable NotBillable HasBeenBilled
FQSaveToCache Bit 5 True False True No FQSaveToCache
FQPrimaryKey Varchar 73 True False False N/A FQPrimaryKey