TABLE DETAIL REFERENCE:
 
(US VERSION)
FIELD NAME TYPE LENGTH QRY MOD INS REQ INS VALIDATE REL
OwnerID Varchar 50 True False True Yes String
Name Varchar 31 True False True Yes String
EntityType Varchar 23 True False True No Customer Vendor Employee OtherName Item Account
EntityRefListID Varchar 36 True False True No String
EntityRefFullName Varchar 159 True False True No String
TxnType Varchar 23 True False True No Bill BillPaymentCheck BillPaymentCreditCard Charge Check CreditCardCharge CreditCardCredit CreditMemo Deposit Estimate InventoryAdjustment Invoice ItemReceipt JournalEntry PurchaseOrder ReceivePayment SalesOrder SalesReceipt SalesTaxPaymentCheck VendorCredit BuildAssembly ARRefundCreditCard
TxnID Varchar 36 True False True No String
TxnLineID Varchar 36 True False True No String
OtherType Varchar 7 True False True No Company
Value Varchar 4095 True False True Yes