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
TxnID Varchar 36 True False False N/A String
ListID Varchar 36 True False False N/A String
TimeCreated Timestamp 27 True False False N/A CCCC-MM-DDThh:mm:ssZ
TimeCreated Timestamp 27 True False False N/A CCCC-MM-DDThh:mm:ssZ
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
TimeModified 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
EditSequence Varchar 16 True False False N/A String
EditSequence Varchar 16 True False False N/A String
TxnNumber Integer 13 True False False N/A 11.0
Name Varchar 31 True True True Yes String
TxnNumber Integer 13 True False False N/A 11.0
CustomerRefListID Varchar 36 True False False N/A String
TxnDate Date 10 True False False N/A CCCC-MM-DD
IsActive Bit 5 True True True No 1 0 true false
CustomerRefFullName Varchar 209 True False False N/A String
Desc Varchar 256 True True True No String
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
ClassRefListID Varchar 36 True False False N/A String
RefNumber Varchar 11 True False False N/A String
ClassRefFullName Varchar 159 True False False N/A String
IsAdjustment Bit 5 True False False N/A 1 0 true false
ARAccountRefListID Varchar 36 True False False N/A String
ARAccountRefFullName Varchar 159 True False False N/A String
TxnDate Date 10 True False False N/A CCCC-MM-DD
JournalLineSeqNo Integer 13 True False False N/A SeqNo
JournalLineType Varchar 25 True False False N/A String
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
JournalLineTxnLineID Varchar 36 True False False N/A String
RefNumber Varchar 11 True False False N/A String
BillAddressAddr1 Varchar 41 True False False N/A String
JournalLineAccountRefListID Varchar 36 True False False N/A String
JournalLineAccountRefFullName Varchar 159 True False False N/A String
BillAddressAddr2 Varchar 41 True False False N/A String
BillAddressAddr3 Varchar 41 True False False N/A String
JournalLineAmount Decimal 11 True False False N/A -%8.2f
BillAddressAddr4 Varchar 41 True False False N/A String
JournalLineCreditAmount Decimal 11 True False False N/A 8.2
BillAddressAddr5 Varchar 41 True False False N/A String
JournalLineDebitAmount Decimal 11 True False False N/A 8.2
BillAddressCity Varchar 31 True False False N/A String
JournalLineMemo Varchar 4095 True False False N/A String
BillAddressState Varchar 21 True False False N/A String
JournalLineEntityRefListID Varchar 36 True False False N/A String
JournalLineEntityRefFullName Varchar 209 True False False N/A String
JournalLineClassRefListID Varchar 36 True False False N/A String
BillAddressPostalCode Varchar 13 True False False N/A String
JournalLineClassRefFullName Varchar 159 True False False N/A String
BillAddressCountry Varchar 31 True False False N/A String
JournalLineBillableStatus Varchar 13 True False False N/A Billable NotBillable HasBeenBilled
BillAddressNote Varchar 41 True False False N/A String
JournalLineType Varchar 25 True False False N/A String
ShipAddressAddr1 Varchar 41 True False False N/A String
JournalLineTxnLineID Varchar 36 True False False N/A String
ShipAddressAddr2 Varchar 41 True False False N/A String
JournalLineAccountRefListID Varchar 36 True False False N/A String
ShipAddressAddr3 Varchar 41 True False False N/A String
JournalLineAccountRefFullName Varchar 159 True False False N/A String
ShipAddressAddr4 Varchar 41 True False False N/A String
JournalLineAmount Decimal 11 True False False N/A 8.2
ShipAddressAddr5 Varchar 41 True False False N/A String
JournalLineCreditAmount Decimal 11 True False False N/A 8.2
ShipAddressCity Varchar 31 True False False N/A String
JournalLineDebitAmount Decimal 11 True False False N/A 8.2
ShipAddressState Varchar 21 True False False N/A String
JournalLineMemo Varchar 4095 True False False N/A String
JournalLineEntityRefListID Varchar 36 True False False N/A String
JournalLineEntityRefFullName Varchar 209 True False False N/A String
ShipAddressPostalCode Varchar 13 True False False N/A String
JournalLineClassRefListID Varchar 36 True False False N/A String
ShipAddressCountry Varchar 31 True False False N/A String
JournalLineClassRefFullName Varchar 159 True False False N/A String
ShipAddressNote Varchar 41 True False False N/A String
JournalLineBillableStatus Varchar 13 True False False N/A Billable NotBillable HasBeenBilled
IsPending Bit 5 True False False N/A 1 0 true false
CheckNumber Varchar 25 True False False N/A String
FQPrimaryKey Varchar 73 True False False N/A FQPrimaryKey
PaymentMethodRefListID Varchar 36 True False False N/A String
PaymentMethodRefFullName Varchar 31 True False False N/A String
IsFinanceCharge Bit 5 True False False N/A 1 0 true false
PONumber Varchar 25 True False False N/A String
TermsRefListID Varchar 36 True False False N/A String
TermsRefFullName Varchar 31 True False False N/A String
DueDate Date 10 True False False N/A CCCC-MM-DD
SalesRepRefListID Varchar 36 True False False N/A String
SalesRepRefFullName Varchar 5 True False False N/A String
FOB Varchar 13 True False False N/A String
ShipDate Date 10 True False False N/A CCCC-MM-DD
ShipMethodRefListID Varchar 36 True False False N/A String
ShipMethodRefFullName Varchar 15 True False 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 False False N/A String
SalesTaxPercentage Decimal 13 True False False N/A 7.5
SalesTaxTotal Decimal 11 True False False N/A 8.2
Amount Decimal 11 True False False N/A 8.2
Remaining Decimal 11 True False False N/A 8.2
Memo Varchar 4095 True False False N/A String
IsPaid Bit 5 True False False N/A 1 0 true false
CustomerMsgRefListID Varchar 36 True False False N/A String
CustomerMsgRefFullName Varchar 101 True False False N/A String
IsToBePrinted Bit 5 True False False N/A 1 0 true false
IsToBeEmailed Bit 5 True False False N/A 1 0 true false
CustomerSalesTaxCodeRefListID Varchar 36 True False False N/A String
CustomerSalesTaxCodeRefFullName Varchar 3 True False False N/A String
SuggestedDiscountAmount Decimal 11 True False False N/A 8.2
SuggestedDiscountDate Date 10 True False False N/A CCCC-MM-DD
DepositToAccountRefListID Varchar 36 True False False N/A String
DepositToAccountRefFullName Varchar 159 True False False N/A String
CreditMemoLineGroupIsPrintItemsInGroup Bit 5 True False False N/A 1 0 true false
Type Varchar 20 True False False N/A String
SalesLineType Varchar 11 True False True No ItemType
SalesLineSeqNo Integer 13 True False False N/A SeqNo
SalesLineGroupTxnLineID Varchar 36 True True False N/A String
SalesLineGroupItemGroupRefListID Varchar 36 True False True No String
SalesLineGroupItemGroupRefFullName Varchar 31 True True True No String
SalesLineGroupDesc Varchar 4095 True False True No String
SalesLineGroupQuantity Decimal 13 True True True No 7.5
SalesLineGroupIsPrintItemsInGroup Bit 5 True False True No 1 0 true false
SalesLineGroupTotalAmount Decimal 11 True False True No 8.2
SalesLineGroupSeqNo Integer 13 True False False N/A SubSeqNo
SalesLineTxnLineID Varchar 36 True True False N/A String
SalesLineItemRefListID Varchar 36 True False True No String
SalesLineItemRefFullName Varchar 159 True True True No String
SalesLineDesc Varchar 4095 True True True No String
SalesLineQuantity Decimal 13 True True True No 7.5
SalesLineRate Decimal 14 True True True No 8.5
SalesLineRatePercent Decimal 13 True True True No 7.5
SalesLineClassRefListID Varchar 36 True False True No String
SalesLineClassRefFullName Varchar 159 True True True No String
SalesLineAmount Decimal 11 True True True No 8.2
SalesLineServiceDate Date 10 True True True No CCCC-MM-DD
SalesLineSalesTaxCodeRefListID Varchar 36 True False True No String
SalesLineSalesTaxCodeRefFullName Varchar 3 True True True No String
SalesLineTxnLineID Varchar 36 True True False N/A String
SalesLineItemRefListID Varchar 36 True False False N/A String
SalesLineItemRefFullName Varchar 159 True True False N/A String
SalesLineDesc Varchar 4095 True True False N/A String
SalesLineQuantity Decimal 13 True True False N/A 7.5
SalesLineRate Decimal 14 True True False N/A 8.5
SalesLineRatePercent Decimal 13 True True False N/A 7.5
SalesLineClassRefListID Varchar 36 True False False N/A String
SalesLineClassRefFullName Varchar 159 True True False N/A String
SalesLineAmount Decimal 11 True True False N/A 8.2
SalesLineServiceDate Date 10 True True False N/A CCCC-MM-DD
SalesLineSalesTaxCodeRefListID Varchar 36 True False False N/A String
SalesLineSalesTaxCodeRefFullName Varchar 3 True True False N/A String
FQPrimaryKey Varchar 110 True False False N/A FQPrimaryKey