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
VendorRefListID Varchar 36 True False True No String
VendorRefFullName Varchar 41 True True True No String
APAccountRefListID Varchar 36 True False True No String
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
TotalAmount Decimal 11 True False False N/A 8.2
RefNumber Varchar 20 True True True No String
Memo Varchar 4095 True True True No String
LinkToTxnID1 Varchar 36 True False True No String
ItemLineType Varchar 11 True False False N/A ItemType
ItemLineSeqNo Integer 13 True False False N/A SeqNo
ItemGroupLineTxnLineID Varchar 36 True True False N/A String
ItemGroupLineItemGroupRefListID Varchar 36 True False True Yes String
ItemGroupLineItemGroupRefFullName Varchar 31 True True True Yes String
ItemGroupLineDesc Varchar 4095 True False False N/A String
ItemGroupLineQuantity Decimal 13 True True True No 7.5
ItemGroupLineTotalAmount Decimal 14 True False False N/A 8.5
ItemGroupSeqNo Integer 13 True False False N/A SubSeqNo
ItemLineTxnLineID Varchar 36 True True False N/A String
ItemLineItemRefListID Varchar 36 True False True Yes String
ItemLineItemRefFullName Varchar 159 True True True Yes String
ItemLineDesc Varchar 4095 True True True No String
ItemLineQuantity Decimal 13 True True True No 7.5
ItemLineCost Decimal 14 True True True No 8.5
ItemLineAmount Decimal 11 True True True No 8.2
ItemLineCustomerRefListID Varchar 36 True False True No String
ItemLineCustomerRefFullName Varchar 209 True True True No String
ItemLineClassRefListID Varchar 36 True False True No String
ItemLineClassRefFullName Varchar 159 True True True No String
ItemLineBillableStatus Varchar 13 True True True No Billable NotBillable HasBeenBilled
ItemLineOverrideItemAccountRefListID Varchar 36 True False True No String
ItemLineOverrideItemAccountRefFullName Varchar 159 True True True No String
ItemLineLinkToTxnTxnID Varchar 36 True False True No String
ItemLineLinkToTxnTxnLineID Varchar 36 True False True No String
ItemLineTxnLineID Varchar 36 True True False N/A String
ItemLineItemRefListID Varchar 36 True False False N/A String
ItemLineItemRefFullName Varchar 159 True True False N/A String
ItemLineDesc Varchar 4095 True True False N/A String
ItemLineQuantity Decimal 13 True True False N/A 7.5
ItemLineCost Decimal 14 True True False N/A 8.5
ItemLineAmount Decimal 11 True True False N/A 8.2
ItemLineCustomerRefListID Varchar 36 True False False N/A String
ItemLineCustomerRefFullName Varchar 209 True True False N/A String
ItemLineClassRefListID Varchar 36 True False False N/A String
ItemLineClassRefFullName Varchar 159 True True False N/A String
ItemLineBillableStatus Varchar 13 True True False N/A Billable NotBillable HasBeenBilled
FQSaveToCache Bit 5 True True True No FQSaveToCache
FQPrimaryKey Varchar 110 True False False N/A FQPrimaryKey