TABLE DETAIL REFERENCE: DepositLine
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
TxnDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
DocNumber12 VARCHAR 21TrueTrueTrueFalse%s
DepartmentRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepartmentRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 13TrueTrueTrueFalse%11.7f
GlobalTaxCalculation12 VARCHAR 15TrueTrueTrueFalse
TaxExcluded
TaxInclusive
NotApplicable
PrivateNote12 VARCHAR 4000TrueTrueTrueFalse%s
TxnStatus12 VARCHAR 13TrueTrueTrueFalse
Draft
Overdue
Pending
Payable
Paid
Trash
Unpaid
DepositToAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepositToAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
TxnSource12 VARCHAR 100TrueFalseFalseFalse%s
CashBackAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CashBackAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
CashBackAmount12 VARCHAR 21TrueTrueTrueFalse%s
CashBackMemo12 VARCHAR 21TrueTrueTrueFalse%s
TotalAmt3 DECIMAL 13TrueTrueTrueFalse%11.2f
HomeTotalAmt3 DECIMAL 13TrueTrueTrueFalse%11.2f
DepositLineTxnLineID12 VARCHAR 36TrueTrueFalseFalse%s
DepositLineLineNum4 INTEGER 4TrueTrueTrueFalse%s
DepositLineDescription12 VARCHAR 4000TrueTrueTrueFalse%s
DepositLineAmount3 DECIMAL 15TrueTrueTrueFalse%11.2f
DepositLineDetailType12 VARCHAR 64TrueTrueTrueFalse
DepositLineDetail
DepositLineIsTaxable-7 BIT 1TrueTrueTrueFalse
1
0
true
false
DepositLineDetailEntityRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepositLineDetailEntityRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
DepositLineDetailClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepositLineDetailClassRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
DepositLineDetailAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepositLineDetailAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
DepositLineDetailPaymentMethodRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepositLineDetailPaymentMethodRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
DepositLineDetailCheckNum12 VARCHAR 4000TrueTrueTrueFalse%s
DepositLineDetailTxnType12 VARCHAR 32TrueTrueTrueFalse
APCreditCard
ARRefundCreditCard
Bill
BillPaymentCheck
BuildAssembly
CarryOver
CashPurchase
Charge
Check
CreditMemo
Deposit
EFPLiabilityCheck
EFTBillPayment
EFTRefund
Estimate
InventoryAdjustment
InventoryTransfer
Invoice
ItemReceipt
JournalEntry
LiabilityAdjustment
Paycheck
PayrollLiabilityCheck
Purchase
PurchaseOrder
PriorPayment
ReceivePayment
RefundCheck
RefundReceipt
SalesOrder
SalesReceipt
SalesTaxPaymentCheck
Transfer
TimeActivity
VendorCredit
YTDAdjustment
DepositLineDetailTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepositLineDetailTaxCodeRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
AppliedToTxnTxnID12 VARCHAR 36TrueTrueTrueFalse%s
AppliedToTxnTxnType12 VARCHAR 32TrueTrueTrueFalse
ARRefundCreditCard
Transfer
Cash
CreditCardCharge
CreditCardCredit
SalesReceipt
RefundReceipt
JournalEntry
BillPaymentCheck
Check
ReceivePayment
Payment
AppliedToTxnTxnLineID12 VARCHAR 36TrueTrueTrueFalse%s
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 73TrueTrueFalseFalseFQPrimaryKey