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
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
IsActive Bit 5 True True True No 1 0 true false
CreateChangeOrder Bit 5 True True 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
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
TotalAmount Decimal 11 True False False N/A 8.2
Memo Varchar 4095 True True True No String
CustomerMsgRefListID Varchar 36 True False True No String
CustomerMsgRefFullName Varchar 101 True True True No String
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
Other Varchar 29 True True True No String
EstimateLineType Varchar 11 True False False N/A ItemType
EstimateLineSeqNo Integer 13 True False False N/A SeqNo
EstimateLineGroupTxnLineID Varchar 36 True True False N/A String
EstimateLineGroupItemGroupRefListID Varchar 36 True False True No String
EstimateLineGroupItemGroupRefFullName Varchar 159 True True True No String
EstimateLineGroupDesc Varchar 4095 True False False N/A String
EstimateLineGroupQuantity Decimal 13 True True True No 7.5
EstimateLineGroupIsPrintItemsInGroup Bit 5 True False False N/A 1 0 true false
EstimateLineGroupTotalAmount Decimal 11 True False False N/A 8.2
EstimateLineGroupSeqNo Integer 13 True False False N/A SubSeqNo
EstimateLineTxnLineID Varchar 36 True True False N/A String
EstimateLineItemRefListID Varchar 36 True False True No String
EstimateLineItemRefFullName Varchar 159 True True True No String
EstimateLineDesc Varchar 4095 True True True No String
EstimateLineQuantity Decimal 13 True True True No 7.5
EstimateLineRate Decimal 14 True True True No 8.5
EstimateLineRatePercent Decimal 13 True True True No 7.5
EstimateLineClassRefListID Varchar 36 True False True No String
EstimateLineClassRefFullName Varchar 159 True True True No String
EstimateLineAmount Decimal 11 True True True No 8.2
EstimateLineSalesTaxCodeRefListID Varchar 36 True False True No String
EstimateLineSalesTaxCodeRefFullName Varchar 3 True True True No String
EstimateLineMarkupRate Decimal 14 True True True No 8.5
EstimateLineMarkupRatePercent Decimal 13 True True True No 7.5
EstimateLineOverrideItemAccountRefListID Varchar 36 True False True No String
EstimateLineOverrideItemAccountRefFullName Varchar 159 True False True No String
EstimateLineOther1 Varchar 29 True True True No String
EstimateLineOther2 Varchar 29 True True True No String
EstimateLineTxnLineID Varchar 36 True True False N/A String
EstimateLineItemRefListID Varchar 36 True False False N/A String
EstimateLineItemRefFullName Varchar 159 True True False N/A String
EstimateLineDesc Varchar 4095 True True False N/A String
EstimateLineQuantity Decimal 13 True True False N/A 7.5
EstimateLineRate Decimal 14 True True False N/A 8.5
EstimateLineRatePercent Decimal 13 True True False N/A 7.5
EstimateLineClassRefListID Varchar 36 True False False N/A String
EstimateLineClassRefFullName Varchar 159 True True False N/A String
EstimateLineAmount Decimal 11 True True False N/A 8.2
EstimateLineSalesTaxCodeRefListID Varchar 36 True False False N/A String
EstimateLineSalesTaxCodeRefFullName Varchar 3 True True False N/A String
EstimateLineTaxCodeRefListID Varchar 36 True False False N/A String
EstimateLineTaxCodeRefFullName Varchar 3 True True False N/A String
EstimateLineMarkupRate Decimal 14 True True False N/A 8.5
EstimateLineMarkupRatePercent Decimal 13 True True False N/A 7.5
EstimateLineOther1 Varchar 29 True True False N/A String
EstimateLineOther2 Varchar 29 True True False N/A String
FQSaveToCache Bit 5 True False True No FQSaveToCache
FQPrimaryKey Varchar 110 True False False N/A FQPrimaryKey