TABLE DETAIL REFERENCE:
  
(US VERSION)
FIELD NAME TYPE LENGTH QRY MOD INS REQ INS VALIDATE REL
TxnType Varchar 25 True False False N/A Bill BillPaymentCheck BillPaymentCreditCard BuildAssembly Charge Check CreditCardCharge CreditCardCredit CreditMemo Deposit Estimate InventoryAdjustment Invoice ItemReceipt JournalEntry LiabilityAdjustment Paycheck PayrollLiabilityCheck PurchaseOrder ReceivePayment SalesOrder SalesReceipt SalesTaxPaymentCheck Transfer VendorCredit YTDAdjustment ARRefundCreditCard
TxnID Varchar 36 True False False N/A String
TxnLineID 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
EntityRefListID Varchar 36 True False False N/A String
EntityRefFullName Varchar 209 True False False N/A String
AccountRefListID Varchar 36 True False False N/A String
AccountRefFullName Varchar 159 True False False N/A String
TxnDate Date 10 True False False N/A 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
RefNumber Varchar 20 True False False N/A String
Amount Decimal 11 True False False N/A 8.2
Memo Varchar 4095 True False False N/A String
TransactionDetailLevelFilter Varchar 23 True False False N/A All SummaryOnly AllExceptSummary
TransactionPostingStatusFilter Varchar 23 True False False N/A Either NonPosting Posting
TransactionPaidStatusFilter Varchar 23 True False False N/A Either Closed Open
FQPrimaryKey Varchar 184 True False False N/A FQPrimaryKey