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 True No 11.0
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
DepositToAccountRefListID Varchar 36 True False True Yes String
DepositToAccountRefFullName Varchar 159 True False True Yes String
Memo Varchar 4095 True False True No String
DepositTotal Decimal 11 True False False N/A 8.2
CashBackInfoTxnLineID Varchar 36 True False True No String
CashBackInfoAccountRefListID Varchar 36 True False True No String
CashBackInfoAccountRefFullName Varchar 159 True False True No String
CashBackInfoMemo Varchar 4095 True False True No String
CashBackInfoAmount Decimal 11 True False True No 8.2
DepositLineSeqNo Integer 13 True False False N/A SeqNo
DepositLinePaymentTxnID Varchar 36 True False True No String
DepositLinePaymentTxnLineID Varchar 36 True False True No String
DepositLineTxnType Varchar 22 True False False N/A Bill BillPaymentCheck BillPaymentCreditCard Charge Check CreditCardCharge CreditCardCredit CreditMemo Deposit Estimate Invoice InventoryAdjustment JournalEntry LiabilityAdjustment PurchaseOrder ReceivePayment SalesReceipt SalesTaxPaymentCheck TimeTracking Transfer VendorCredit
DepositLineTxnID Varchar 36 True False False N/A String
DepositLineTxnLineID Varchar 36 True False False N/A String
DepositLineEntityRefListID Varchar 36 True False True No String
DepositLineEntityRefFullName Varchar 209 True False True No String
DepositLineAccountRefListID Varchar 36 True False True Yes String
DepositLineAccountRefFullName Varchar 159 True False True Yes String
DepositLineMemo Varchar 4095 True False True No String
DepositLineCheckNumber Varchar 11 True False True No String
DepositLinePaymentMethodRefListID Varchar 36 True False True No String
DepositLinePaymentMethodRefFullName Varchar 31 True False True No String
DepositLineClassRefListID Varchar 36 True False True No String
DepositLineClassRefFullName Varchar 159 True False True No String
DepositLineAmount Decimal 11 True False True No 8.2
FQSaveToCache Bit 5 True False True No FQSaveToCache
FQPrimaryKey Varchar 73 True False False N/A FQPrimaryKey