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
PayeeEntityRefListID Varchar 36 True False True Yes String
PayeeEntityRefFullName Varchar 209 True False True Yes String
APAccountRefListID Varchar 36 True False True No String
APAccountRefFullName Varchar 159 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
CreditCardAccountRefListID Varchar 36 True False True Yes String
CreditCardAccountRefFullName Varchar 159 True False True Yes String
Amount Decimal 11 True False False N/A 8.2
RefNumber Varchar 11 True False True Yes String
Memo Varchar 4095 True False True No String
AppliedToTxnSeqNo Integer 13 True False False N/A SeqNo
AppliedToTxnTxnID Varchar 36 True False True Yes String
AppliedToTxnPaymentAmount Decimal 11 True False True No 8.2
AppliedToTxnTxnType Varchar 14 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
AppliedToTxnTxnDate Date 10 True False False N/A CCCC-MM-DD
AppliedToTxnRefNumber Varchar 20 True False False N/A String
AppliedToTxnBalanceRemaining Decimal 11 True False False N/A 8.2
AppliedToTxnAmount Decimal 11 True False False N/A 8.2
AppliedToTxnSetCreditCreditTxnID Varchar 36 True False True No String
AppliedToTxnSetCreditAppliedAmount Decimal 11 True False True No 8.2
AppliedToTxnDiscountAmount Decimal 11 True False True No 8.2
AppliedToTxnDiscountAccountRefListID Varchar 36 True False True No String
AppliedToTxnDiscountAccountRefFullName Varchar 159 True False True No String
FQSaveToCache Bit 5 True False True No FQSaveToCache
FQPrimaryKey Varchar 73 True False False N/A FQPrimaryKey