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 No String
CustomerRefFullName Varchar 209 True True True No 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
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
CheckNumber Varchar 25 True True True No String
PaymentMethodRefListID Varchar 36 True False True No String
PaymentMethodRefFullName 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
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
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
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
DepositToAccountRefListID Varchar 36 True False True No String
DepositToAccountRefFullName Varchar 159 True True True No String
CreditCardTxnInfoInputCreditCardNumber Varchar 25 True False True No String
CreditCardTxnInfoInputExpirationMonth Integer 13 True False True No 11.0
CreditCardTxnInfoInputExpirationYear Integer 13 True False True No 11.0
CreditCardTxnInfoInputNameOnCard Varchar 41 True False True No String
CreditCardTxnInfoInputCreditCardAddress Varchar 41 True False True No String
CreditCardTxnInfoInputCreditCardPostalCode Varchar 41 True False True No String
CreditCardTxnInfoInputCommercialCardCode Varchar 50 True False True No String
CreditCardTxnInfoInputTransactionMode Varchar 14 True False True No CardNotPresent CardPresent
CreditCardTxnInfoResultResultCode Integer 13 True False True No 11.0
CreditCardTxnInfoResultResultMessage Varchar 500 True False True No String
CreditCardTxnInfoResultCreditCardTransID Varchar 24 True False True No String
CreditCardTxnInfoResultMerchantAccountNumber Varchar 32 True False True No String
CreditCardTxnInfoResultAuthorizationCode Varchar 12 True False True No String
CreditCardTxnInfoResultAVSStreet Varchar 12 True False True No Pass Fail NotAvailable
CreditCardTxnInfoResultAVSZip Varchar 12 True False True No Pass Fail NotAvailable
CreditCardTxnInfoResultReconBatchID Varchar 84 True False True No String
CreditCardTxnInfoResultPaymentGroupingCode Integer 13 True False True No 11.0
CreditCardTxnInfoResultPaymentStatus Varchar 9 True False True No Unknown Completed
CreditCardTxnInfoResultTxnAuthorizationTime Timestamp 27 True False True No CCCC-MM-DDThh:mm:ssZ
CreditCardTxnInfoResultTxnAuthorizationStamp Integer 13 True False True No 11.0
CreditCardTxnInfoResultClientTransID Varchar 16 True False True No String
Other Varchar 29 True True True No String
SalesReceiptLineItemLineType Varchar 11 True False False N/A ItemType
SalesReceiptLineSeqNo Integer 13 True False False N/A SeqNo
SalesReceiptLineGroupTxnLineID Varchar 36 True True False N/A String
SalesReceiptLineGroupItemGroupRefListID Varchar 36 True False True No String
SalesReceiptLineGroupItemGroupRefFullName Varchar 159 True True True No String
SalesReceiptLineGroupDesc Varchar 4095 True False False N/A String
SalesReceiptLineGroupQuantity Decimal 13 True True True No 7.5
SalesReceiptLineGroupIsPrintItemsInGroup Bit 5 True False False N/A 1 0 true false
SalesReceiptLineGroupTotalAmount Decimal 11 True False False N/A 8.2
SalesReceiptLineGroupSeqNo Integer 13 True False False N/A SubSeqNo
SalesReceiptLineTxnLineID Varchar 36 True True False N/A String
SalesReceiptLineItemRefListID Varchar 36 True False True No String
SalesReceiptLineItemRefFullName Varchar 159 True True True No String
SalesReceiptLineDesc Varchar 4095 True True True No String
SalesReceiptLineQuantity Decimal 13 True True True No 7.5
SalesReceiptLineRate Decimal 14 True True True No 8.5
SalesReceiptLineRatePercent Decimal 13 True True True No 7.5
SalesReceiptLinePriceLevelRefListID Varchar 36 True False True No String
SalesReceiptLinePriceLevelRefFullName Varchar 159 True True True No String
SalesReceiptLineClassRefListID Varchar 36 True False True No String
SalesReceiptLineClassRefFullName Varchar 159 True True True No String
SalesReceiptLineAmount Decimal 11 True True True No 8.2
SalesReceiptLineServiceDate Date 10 True True True No CCCC-MM-DD
SalesReceiptLineSalesTaxCodeRefListID Varchar 36 True False True No String
SalesReceiptLineSalesTaxCodeRefFullName Varchar 3 True True True No String
SalesReceiptLineOverrideItemAccountRefListID Varchar 36 True False True No String
SalesReceiptLineOverrideItemAccountRefFullName Varchar 159 True True True No String
SalesReceiptLineOther1 Varchar 29 True True True No String
SalesReceiptLineOther2 Varchar 29 True True True No String
SalesReceiptLineTxnLineID Varchar 36 True True False N/A String
SalesReceiptLineItemRefListID Varchar 36 True False False N/A String
SalesReceiptLineItemRefFullName Varchar 159 True True False N/A String
SalesReceiptLineDesc Varchar 4095 True True False N/A String
SalesReceiptLineQuantity Decimal 13 True True False N/A 7.5
SalesReceiptLineRate Decimal 14 True True False N/A 8.5
SalesReceiptLineRatePercent Decimal 13 True True False N/A 7.5
SalesReceiptLineClassRefListID Varchar 36 True False False N/A String
SalesReceiptLineClassRefFullName Varchar 159 True True False N/A String
SalesReceiptLineAmount Decimal 11 True True False N/A 8.2
SalesReceiptLineServiceDate Date 10 True True False N/A CCCC-MM-DD
SalesReceiptLineSalesTaxCodeRefListID Varchar 36 True False False N/A String
SalesReceiptLineSalesTaxCodeRefFullName Varchar 3 True True False N/A String
SalesReceiptLineOther1 Varchar 29 True True False N/A String
SalesReceiptLineOther2 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