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 True False N/A String
ClassRefListID Varchar 36 True False False N/A String
ClassRefFullName Varchar 159 True True False N/A String
ARAccountRefListID Varchar 36 True False False N/A String
ARAccountRefFullName Varchar 159 True True False N/A String
TemplateRefListID Varchar 36 True False False N/A String
TemplateRefFullName Varchar 159 True True False N/A String
TxnDate Date 10 True True 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 True False N/A String
BillAddressAddr1 Varchar 41 True True False N/A String
BillAddressAddr2 Varchar 41 True True False N/A String
BillAddressAddr3 Varchar 41 True True False N/A String
BillAddressAddr4 Varchar 41 True True False N/A String
BillAddressAddr5 Varchar 41 True True True No String
BillAddressCity Varchar 31 True True False N/A String
BillAddressState Varchar 21 True True False N/A String
BillAddressPostalCode Varchar 13 True True False N/A String
BillAddressCountry Varchar 31 True True False N/A String
BillAddressNote Varchar 41 True True True No String
BillAddressBlockAddr1 Varchar 41 True False False N/A String
BillAddressBlockAddr2 Varchar 41 True False False N/A String
BillAddressBlockAddr3 Varchar 41 True False False N/A String
BillAddressBlockAddr4 Varchar 41 True False False N/A String
BillAddressBlockAddr5 Varchar 41 True False False N/A String
ShipAddressAddr1 Varchar 41 True True False N/A String
ShipAddressAddr2 Varchar 41 True True False N/A String
ShipAddressAddr3 Varchar 41 True True False N/A String
ShipAddressAddr4 Varchar 41 True True False N/A String
ShipAddressAddr5 Varchar 41 True True True No String
ShipAddressCity Varchar 31 True True False N/A String
ShipAddressState Varchar 21 True True False N/A String
ShipAddressPostalCode Varchar 13 True True False N/A String
ShipAddressCountry Varchar 31 True True False N/A String
ShipAddressNote Varchar 41 True True True No String
ShipAddressBlockAddr1 Varchar 41 True False False N/A String
ShipAddressBlockAddr2 Varchar 41 True False False N/A String
ShipAddressBlockAddr3 Varchar 41 True False False N/A String
ShipAddressBlockAddr4 Varchar 41 True False False N/A String
ShipAddressBlockAddr5 Varchar 41 True False False N/A String
IsPending Bit 5 True True False N/A 1 0 true false
PONumber Varchar 25 True True False N/A String
TermsRefListID Varchar 36 True False False N/A String
TermsRefFullName Varchar 31 True True False N/A String
DueDate Date 10 True True False N/A CCCC-MM-DD
SalesRepRefListID Varchar 36 True False False N/A String
SalesRepRefFullName Varchar 5 True True False N/A String
FOB Varchar 13 True True False N/A String
ShipDate Date 10 True True False N/A CCCC-MM-DD
ShipMethodRefListID Varchar 36 True False False N/A String
ShipMethodRefFullName Varchar 15 True True False N/A String
Subtotal Decimal 11 True False False N/A 8.2
ItemSalesTaxRefListID Varchar 36 True False False N/A String
ItemSalesTaxRefFullName Varchar 31 True True False N/A String
SalesTaxPercentage Decimal 13 True False False N/A 7.5
SalesTaxTotal Decimal 11 True False False N/A 8.2
TotalAmount Decimal 11 True False False N/A 8.2
CreditRemaining Decimal 11 True False False N/A 8.2
Memo Varchar 4095 True True False N/A String
CustomerMsgRefListID Varchar 36 True False False N/A String
CustomerMsgRefFullName Varchar 101 True True False N/A String
IsToBePrinted Bit 5 True True False N/A 1 0 true false
IsToBeEmailed Bit 5 True True True No 1 0 true false
CustomerSalesTaxCodeRefListID Varchar 36 True False False N/A String
CustomerSalesTaxCodeRefFullName Varchar 3 True True False N/A String
Other Varchar 29 True True True No String
LinkedTxnSeqNo Integer 13 True False False N/A SeqNo
LinkedTxnTxnID Varchar 36 True False False N/A String
LinkedTxnTxnType 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
LinkedTxnTxnDate Date 10 True False False N/A CCCC-MM-DD
LinkedTxnRefNumber Varchar 20 True False False N/A String
LinkedTxnAmount Decimal 11 True False False N/A 8.2
CreditMemoLineIsTaxable Bit 5 True True False N/A 1 0 true false
CreditMemoLineOverrideItemAccountRefListID Varchar 36 False False True No String
CreditMemoLineOverrideItemAccountRefFullName Varchar 159 False False True No String
FQPrimaryKey Varchar 73 True False False N/A FQPrimaryKey