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 True Yes String
CustomerRefFullName Varchar 209 True True True Yes String
ClassRefListID Varchar 36 True False True No String
ClassRefFullName Varchar 159 True True True No String
ARAccountRefListID Varchar 36 True False True No String
ARAccountRefFullName Varchar 159 True True True No String
TemplateRefListID Varchar 36 True False True No String
TemplateRefFullName Varchar 159 True True True No String
TxnDate Date 10 True True 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
RefNumber Varchar 11 True True True No String
BillAddressAddr1 Varchar 41 True True True No String
BillAddressAddr2 Varchar 41 True True True No String
BillAddressAddr3 Varchar 41 True True True No String
BillAddressAddr4 Varchar 41 True True True No String
BillAddressAddr5 Varchar 41 True True True No String
BillAddressCity Varchar 31 True True True No String
BillAddressState Varchar 21 True True True No String
BillAddressPostalCode Varchar 13 True True True No String
BillAddressCountry Varchar 31 True True True No 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 True No String
ShipAddressAddr2 Varchar 41 True True True No String
ShipAddressAddr3 Varchar 41 True True True No String
ShipAddressAddr4 Varchar 41 True True True No String
ShipAddressAddr5 Varchar 41 True True True No String
ShipAddressCity Varchar 31 True True True No String
ShipAddressState Varchar 21 True True True No String
ShipAddressPostalCode Varchar 13 True True True No String
ShipAddressCountry Varchar 31 True True True No 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 True No 1 0 true false
IsFinanceCharge Bit 5 True False False N/A 1 0 true false
PONumber Varchar 25 True True True No String
TermsRefListID Varchar 36 True False True No String
TermsRefFullName Varchar 31 True True True No String
DueDate Date 10 True True True No CCCC-MM-DD
SalesRepRefListID Varchar 36 True False True No String
SalesRepRefFullName Varchar 5 True True True No String
FOB Varchar 13 True True True No String
ShipDate Date 10 True True True No CCCC-MM-DD
ShipMethodRefListID Varchar 36 True False True No String
ShipMethodRefFullName Varchar 15 True True True No String
Subtotal Decimal 11 True False False N/A 8.2
ItemSalesTaxRefListID Varchar 36 True False True No String
ItemSalesTaxRefFullName Varchar 31 True True True No String
SalesTaxPercentage Decimal 13 True False False N/A 7.5
SalesTaxTotal Decimal 11 True False False N/A 8.2
AppliedAmount Decimal 11 True False False N/A 8.2
BalanceRemaining Decimal 11 True False False N/A 8.2
Memo Varchar 4095 True True True No String
IsPaid Bit 5 True False False N/A 1 0 true false
CustomerMsgRefListID Varchar 36 True False True No String
CustomerMsgRefFullName Varchar 101 True True True No String
IsToBePrinted Bit 5 True True True No 1 0 true false
IsToBeEmailed Bit 5 True True True No 1 0 true false
CustomerSalesTaxCodeRefListID Varchar 36 True False True No String
CustomerSalesTaxCodeRefFullName Varchar 3 True True True No String
SuggestedDiscountAmount Decimal 11 True False False N/A 8.2
SuggestedDiscountDate Date 10 True False False N/A CCCC-MM-DD
Other Varchar 29 True True True No String
LinkToTxnID1 Varchar 36 True True True No String
InvoiceLineType Varchar 11 True False True No ItemType
InvoiceLineSeqNo Integer 13 True False False N/A SeqNo
InvoiceLineGroupTxnLineID Varchar 36 True True False N/A String
InvoiceLineGroupItemGroupRefListID Varchar 36 True False True No String
InvoiceLineGroupItemGroupRefFullName Varchar 31 True True True No String
InvoiceLineGroupDesc Varchar 4095 True False True No String
InvoiceLineGroupQuantity Decimal 13 True True True No 7.5
InvoiceLineGroupIsPrintItemsInGroup Bit 5 True False True No 1 0 true false
InvoiceLineGroupTotalAmount Decimal 11 True False True No 8.2
InvoiceLineGroupSeqNo Integer 13 True False False N/A SubSeqNo
InvoiceLineTxnLineID Varchar 36 True True False N/A String
InvoiceLineItemRefListID Varchar 36 True False True No String
InvoiceLineItemRefFullName Varchar 159 True True True No String
InvoiceLineDesc Varchar 4095 True True True No String
InvoiceLineQuantity Decimal 13 True True True No 7.5
InvoiceLineRate Decimal 14 True True True No 8.5
InvoiceLineRatePercent Decimal 13 True True True No 7.5
InvoiceLinePriceLevelRefListID Varchar 36 True False True No String
InvoiceLinePriceLevelRefFullName Varchar 159 True True True No String
InvoiceLineClassRefListID Varchar 36 True False True No String
InvoiceLineClassRefFullName Varchar 159 True True True No String
InvoiceLineAmount Decimal 11 True True True No 8.2
InvoiceLineServiceDate Date 10 True True True No CCCC-MM-DD
InvoiceLineSalesTaxCodeRefListID Varchar 36 True False True No String
InvoiceLineSalesTaxCodeRefFullName Varchar 3 True True True No String
InvoiceLineOverrideItemAccountRefListID Varchar 36 True False True No String
InvoiceLineOverrideItemAccountRefFullName Varchar 159 True True True No String
InvoiceLineOther1 Varchar 29 True True True No String
InvoiceLineOther2 Varchar 29 True True True No String
InvoiceLineLinkToTxnTxnID Varchar 36 True False True No String
InvoiceLineLinkToTxnTxnLineID Varchar 36 True False True No String
InvoiceLineTxnLineID Varchar 36 True True False N/A String
InvoiceLineItemRefListID Varchar 36 True False False N/A String
InvoiceLineItemRefFullName Varchar 159 True True False N/A String
InvoiceLineDesc Varchar 4095 True True False N/A String
InvoiceLineQuantity Decimal 13 True True False N/A 7.5
InvoiceLineRate Decimal 14 True True False N/A 8.5
InvoiceLineRatePercent Decimal 13 True True False N/A 7.5
InvoiceLineClassRefListID Varchar 36 True False False N/A String
InvoiceLineClassRefFullName Varchar 159 True True False N/A String
InvoiceLineAmount Decimal 11 True True False N/A 8.2
InvoiceLineServiceDate Date 10 True True False N/A CCCC-MM-DD
InvoiceLineSalesTaxCodeRefListID Varchar 36 True False False N/A String
InvoiceLineSalesTaxCodeRefFullName Varchar 3 True True False N/A String
InvoiceLineOverrideItemAccountRefListID Varchar 36 True False False N/A String
InvoiceLineOverrideItemAccountRefFullName Varchar 159 True True False N/A String
InvoiceLineOther1 Varchar 29 True True False N/A String
InvoiceLineOther2 Varchar 29 True True False N/A String
FQSaveToCache Bit 5 True True True No FQSaveToCache
FQPrimaryKey Varchar 110 True False False N/A FQPrimaryKey