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
TxnLineID Varchar 21 True False False N/A
TxnType 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
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
RefNumber Varchar 20 True False False N/A String
Amount Decimal 11 True False False N/A 8.2
FQPrimaryKey Varchar 73 True False False N/A FQPrimaryKey