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
CustomerRefListID Varchar 36 True False False N/A String
CustomerRefFullName Varchar 209 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 11 True False False N/A String
ItemRefListID Varchar 36 True False False N/A String
ItemRefFullName Varchar 159 True False False N/A String
Quantity Decimal 13 True False False N/A 7.5
Rate Decimal 14 True False False N/A 8.5
Amount Decimal 11 True False False N/A 8.2
BalanceRemaining Decimal 11 True False False N/A 8.2
Desc Varchar 4095 True False False N/A String
ARAccountRefListID Varchar 36 True False False N/A String
ARAccountRefFullName Varchar 159 True False False N/A String
ClassRefListID Varchar 36 True False False N/A String
ClassRefFullName Varchar 159 True False False N/A String
BilledDate Date 10 True False False N/A CCCC-MM-DD
DueDate Date 10 True False False N/A CCCC-MM-DD
OverrideItemAccountRefListID Varchar 36 True False False N/A String
OverrideItemAccountRefFullName Varchar 159 True False False N/A String
IsPaid Bit 5 True False False N/A 1 0 true false
LinkedTxnSeqNo Integer 13 True False False N/A SeqNo
LinkedTxnTxnID Varchar 36 True False False N/A String
LinkedTxnTxnType Varchar 21 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
LinkedTxnTxnDate Date 10 True False False N/A CCCC-MM-DD
LinkedTxnRefNumber Varchar 20 True False False N/A String
LinkedTxnLinkType Varchar 8 True False False N/A AMTTYPE QUANTYPE
LinkedTxnAmount Decimal 11 True False False N/A 8.2
FQPrimaryKey Varchar 73 True False False N/A FQPrimaryKey