TABLE DETAIL REFERENCE: RecurringDepositLine
(Online VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
EditSequence | 12 | VARCHAR | 10 | True | False | False | False | %s | |
TxnNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
CurrencyRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
CurrencyRefFullName | 12 | VARCHAR | 1000 | True | True | True | False | %s | Yes |
ExchangeRate | 3 | DECIMAL | 13 | True | True | True | False | %11.7f | |
GlobalTaxCalculation | 12 | VARCHAR | 15 | True | True | True | False | TaxExcluded TaxInclusive NotApplicable | |
PrivateNote | 12 | VARCHAR | 4000 | True | True | True | False | %s | |
DepositToAccountRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
DepositToAccountRefFullName | 12 | VARCHAR | 1000 | True | True | True | False | %s | Yes |
Domain | 12 | VARCHAR | 50 | True | False | False | False | %s | |
Sparse | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
CashBackAccountRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
CashBackAccountRefFullName | 12 | VARCHAR | 1000 | True | True | True | False | %s | Yes |
CashBackAmount | 12 | VARCHAR | 21 | True | True | True | False | %s | |
CashBackMemo | 12 | VARCHAR | 21 | True | True | True | False | %s | |
TotalAmt | 3 | DECIMAL | 13 | True | True | True | False | %11.2f | |
HomeTotalAmt | 3 | DECIMAL | 13 | True | True | True | False | %11.2f | |
RecurringObjectType | 12 | VARCHAR | 15 | True | True | True | False | Bill CreditMemo Deposit Estimate Invoice JournalEntry Purchase PurchaseOrder RefundReceipt SalesReceipt Transfer VendorCredit | |
RecurringInfoName | 12 | VARCHAR | 1000 | True | True | True | False | %s | |
RecurringInfoType | 12 | VARCHAR | 1000 | True | True | True | False | %s | |
RecurringInfoActive | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
RecurringInfoScheduleInfoIntervalType | 12 | VARCHAR | 15 | True | True | True | False | Daily Weekly Monthly Yearly | |
RecurringInfoScheduleInfoNumInterval | 12 | VARCHAR | 15 | True | True | True | False | %s | |
RecurringInfoScheduleInfoDayOfMonth | 4 | INTEGER | 4 | True | True | True | False | %11.0f | |
RecurringInfoScheduleInfoDayOfWeek | 4 | INTEGER | 4 | True | True | True | False | %11.0f | |
RecurringInfoScheduleInfoWeekOfMonth | 4 | INTEGER | 4 | True | True | True | False | %11.0f | |
RecurringInfoScheduleInfoMonthOfYear | 4 | INTEGER | 4 | True | True | True | False | %11.0f | |
RecurringInfoScheduleInfoNextDate | 12 | VARCHAR | 27 | True | True | True | False | %s | |
RecurringInfoScheduleInfoPreviousDate | 12 | VARCHAR | 27 | True | True | True | False | %s | |
RecurringInfoScheduleInfoStartDate | 12 | VARCHAR | 27 | True | True | True | False | %s | |
RecurringInfoScheduleInfoEndDate | 12 | VARCHAR | 27 | True | True | True | False | %s | |
RecurringInfoScheduleInfoMaxOccurrences | 4 | INTEGER | 4 | True | True | True | False | %11.0f | |
RecurringInfoScheduleInfoRemindDays | 4 | INTEGER | 4 | True | True | True | False | %11.0f | |
RecurringInfoScheduleInfoDaysBefore | 4 | INTEGER | 4 | True | True | True | False | %11.0f | |
RecurDataRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | |
RecurDataRefFullName | 12 | VARCHAR | 1000 | True | True | True | False | %s | |
DepositLineTxnLineID | 12 | VARCHAR | 36 | True | True | False | False | %s | |
DepositLineLineNum | 4 | INTEGER | 4 | True | True | True | False | %s | |
DepositLineDescription | 12 | VARCHAR | 4000 | True | True | True | False | %s | |
DepositLineAmount | 3 | DECIMAL | 15 | True | True | True | False | %11.2f | |
DepositLineDetailType | 12 | VARCHAR | 64 | True | True | True | False | DepositLineDetail | |
DepositLineIsTaxable | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
DepositLineDetailEntityRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
DepositLineDetailEntityRefFullName | 12 | VARCHAR | 1000 | True | True | True | False | %s | Yes |
DepositLineDetailClassRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
DepositLineDetailClassRefFullName | 12 | VARCHAR | 1000 | True | True | True | False | %s | Yes |
DepositLineDetailAccountRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
DepositLineDetailAccountRefFullName | 12 | VARCHAR | 1000 | True | True | True | False | %s | Yes |
DepositLineDetailPaymentMethodRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
DepositLineDetailPaymentMethodRefFullName | 12 | VARCHAR | 1000 | True | True | True | False | %s | Yes |
DepositLineDetailCheckNum | 12 | VARCHAR | 4000 | True | True | True | False | %s | |
DepositLineDetailTxnType | 12 | VARCHAR | 32 | True | True | True | False | 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 | |
FQSaveToCache | -7 | BIT | 1 | True | False | True | False | FQSaveToCache | |
FQPrimaryKey | 12 | VARCHAR | 73 | True | True | False | False | FQPrimaryKey |