DepositLine Table

Back to list of tables.

Column Data type Data type name Length Can be queried? Can be updated? Can be inserted? Mandatory when inserting? Format Refers To Version introduced in Edition available in
ID 12 VARCHAR 75
TxnID 12 VARCHAR 36 True False False False %s 2.0 US, CA, UK
TimeCreated 93 TIMESTAMP 23 True False False False CCCC-MM-DDThh:mm:ssZ 2.0 US, CA, UK
TimeModified 93 TIMESTAMP 23 True False False False CCCC-MM-DDThh:mm:ssZ 2.0 US, CA, UK
EditSequence 12 VARCHAR 16 True False False False %s 2.0 US, CA, UK
TxnNumber 4 INTEGER 9 True False False False %12.0f 2.0 US, CA, UK
TxnDate 9 DATE 91 True False True False CCCC-MM-DD 2.0 US, CA, UK
TxnDateMacro 12 VARCHAR 25 True False False False
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
 2.0 US, CA, UK
DepositToAccountRef_ListID 12 VARCHAR 36 True True True True %s ListID 2.0 US, CA, UK
DepositToAccountRef_FullName 12 VARCHAR 159 True True True True %s FullName 2.0 US, CA, UK
Memo 12 VARCHAR 4095 True True True False %s 2.0 US, CA, UK
DepositTotal 2 NUMERIC 15 True False False False %10.2f 2.0 US, CA, UK
CurrencyRef_ListID 12 VARCHAR 36 True True True True %s ListID 8.0 US, CA, UK
CurrencyRef_FullName 12 VARCHAR 64 True True True True %s FullName 8.0 US, CA, UK
ExchangeRate 2 NUMERIC 18 True False False False %6.6f 8.0 US, CA, UK
DepositTotalInHomeCurrency 2 NUMERIC 15 True False False False %10.2f 8.0 US, CA, UK
CashBackInfo_TxnLineID 12 VARCHAR 36 True False False False %s 2.0 US, CA, UK
CashBackInfo_AccountRef_ListID 12 VARCHAR 36 True True True False %s ListID 2.0 US, CA, UK
CashBackInfo_AccountRef_FullName 12 VARCHAR 159 True True True False %s FullName 2.0 US, CA, UK
CashBackInfo_Memo 12 VARCHAR 4095 True True True False %s 2.0 US, CA, UK
CashBackInfo_Amount 2 NUMERIC 15 True False True False %10.2f 2.0 US, CA, UK
ExternalGUID 12 VARCHAR 40 9.0 US, CA, UK
DepositLine_TxnType 12 VARCHAR 22 True False False False
Bill
BillPaymentCheck
BillPaymentCreditCard
Charge
Check
CreditCardCharge
CreditCardCredit
CreditMemo
Deposit
Estimate
Invoice
InventoryAdjustment
JournalEntry
LiabilityAdjustment
PurchaseOrder
ReceivePayment
SalesReceipt
SalesTaxPaymentCheck
TimeTracking
Transfer
VendorCredit
 2.0 US, CA, UK
DepositLine_TxnID 12 VARCHAR 36 True False False False %s 2.0 US, CA, UK
DepositLine_TxnLineID 12 VARCHAR 36 True True False False %s 2.0 US, CA, UK
DepositLine_PaymentTxnID 12 VARCHAR 36 True True True False %s 2.0 US, CA, UK
DepositLine_PaymentTxnLineID 12 VARCHAR 36 True True True False %s 7.0 US, CA, UK
DepositLine_OverrideMemo 12 VARCHAR 255 2.0 US, CA, UK
DepositLine_OverrideMemo 12 VARCHAR 255 2.0 US, CA, UK
DepositLine_OverrideMemo 12 VARCHAR 255 2.0 US, CA, UK
DepositLine_OverrideMemo 12 VARCHAR 255 2.0 US, CA, UK
DepositLine_EntityRef_ListID 12 VARCHAR 36 True True True False %s ListID 2.0 US, CA, UK
DepositLine_EntityRef_FullName 12 VARCHAR 255 True True True False %s FullName 2.0 US, CA, UK
DepositLine_AccountRef_ListID 12 VARCHAR 36 True True True True %s ListID 2.0 US, CA, UK
DepositLine_AccountRef_FullName 12 VARCHAR 159 True True True True %s FullName 2.0 US, CA, UK
DepositLine_Memo 12 VARCHAR 4095 True True True False %s 2.0 US, CA, UK
DepositLine_CheckNumber 12 VARCHAR 11 True True True False %s 2.0 US, CA, UK
DepositLine_PaymentMethodRef_ListID 12 VARCHAR 36 True True True False %s ListID 2.0 US, CA, UK
DepositLine_PaymentMethodRef_FullName 12 VARCHAR 31 True True True False %s Name 2.0 US, CA, UK
DepositLine_ClassRef_ListID 12 VARCHAR 36 True True True False %s ListID 2.0 US, CA, UK
DepositLine_ClassRef_FullName 12 VARCHAR 159 True True True False %s FullName 2.0 US, CA, UK
DepositLine_Amount 3 NUMERIC 15 True True True False %10.2f 2.0 US, CA, UK
RQUseCachedID -7 BIT 2 2.0 US, CA, UK