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 False True Yes String
RefundFromAccountRefListID Varchar 36 True False True No String
RefundFromAccountRefFullName Varchar 159 True False True No String
ARAccountRefListID Varchar 36 True False True No String
ARAccountRefFullName Varchar 159 True False True No String
TxnDate Date 10 True False 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 False True No String
TotalAmount Decimal 11 True False False N/A 8.2
AddressAddr1 Varchar 41 True False True No String
AddressAddr2 Varchar 41 True False True No String
AddressAddr3 Varchar 41 True False True No String
AddressAddr4 Varchar 41 True False True No String
AddressAddr5 Varchar 41 True False True No String
AddressCity Varchar 31 True False True No String
AddressState Varchar 21 True False True No String
AddressPostalCode Varchar 13 True False True No String
AddressCountry Varchar 31 True False True No String
AddressNote Varchar 41 True False True No String
AddressBlockAddr1 Varchar 41 True False False N/A String
AddressBlockAddr2 Varchar 41 True False False N/A String
AddressBlockAddr3 Varchar 41 True False False N/A String
AddressBlockAddr4 Varchar 41 True False False N/A String
AddressBlockAddr5 Varchar 41 True False False N/A String
PaymentMethodRefListID Varchar 36 True False True No String
PaymentMethodRefFullName Varchar 31 True False True No String
Memo Varchar 4095 True False 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
RefundAppliedToTxnTxnID Varchar 36 True False True Yes String
RefundAppliedToTxnTxnType 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
RefundAppliedToTxnTxnDate Date 10 True False False N/A CCCC-MM-DD
RefundAppliedToTxnRefNumber Varchar 20 True False False N/A String
RefundAppliedToTxnRefCreditRemaining Decimal 11 True False False N/A 8.2
RefundAppliedToTxnRefRefundAmount Decimal 11 True False True No 8.2
FQPrimaryKey Varchar 73 True False False N/A FQPrimaryKey