TABLE DETAIL REFERENCE: RecurringBillExpenseLine
(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
TxnNumber4 INTEGER 4TrueTrueTrueFalse%11.0f
VendorRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
VendorRefFullName12 VARCHAR 1000TrueTrueTrueTrue%s Yes
APAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
APAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
CurrencyRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CurrencyRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
ExchangeRate3 DECIMAL 13TrueFalseTrueFalse%11.7f
DepartmentRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepartmentRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
AmountDue3 DECIMAL 13TrueTrueTrueFalse%11.2f
TermsRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
TermsRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
Memo12 VARCHAR 4000TrueTrueTrueFalse%s
GlobalTaxCalculation12 VARCHAR 15TrueTrueTrueFalse
TaxExcluded
TaxIncluded
NotApplicable
OpenAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
HomeBalance3 DECIMAL 13TrueFalseFalseFalse%11.2f
RecurringObjectType12 VARCHAR 15TrueTrueTrueFalse
Bill
CreditMemo
Deposit
Estimate
Invoice
JournalEntry
Purchase
PurchaseOrder
RefundReceipt
SalesReceipt
Transfer
VendorCredit
RecurringInfoName12 VARCHAR 1000TrueTrueTrueFalse%s
RecurringInfoType12 VARCHAR 1000TrueTrueTrueFalse%s
RecurringInfoActive-7 BIT 1TrueTrueTrueFalse
1
0
true
false
RecurringInfoScheduleInfoIntervalType12 VARCHAR 15TrueTrueTrueFalse
Daily
Weekly
Monthly
Yearly
RecurringInfoScheduleInfoNumInterval12 VARCHAR 15TrueTrueTrueFalse%s
RecurringInfoScheduleInfoDayOfMonth4 INTEGER 4TrueTrueTrueFalse%11.0f
RecurringInfoScheduleInfoDayOfWeek4 INTEGER 4TrueTrueTrueFalse%11.0f
RecurringInfoScheduleInfoWeekOfMonth4 INTEGER 4TrueTrueTrueFalse%11.0f
RecurringInfoScheduleInfoMonthOfYear4 INTEGER 4TrueTrueTrueFalse%11.0f
RecurringInfoScheduleInfoNextDate12 VARCHAR 27TrueTrueTrueFalse%s
RecurringInfoScheduleInfoPreviousDate12 VARCHAR 27TrueTrueTrueFalse%s
RecurringInfoScheduleInfoStartDate12 VARCHAR 27TrueTrueTrueFalse%s
RecurringInfoScheduleInfoEndDate12 VARCHAR 27TrueTrueTrueFalse%s
RecurringInfoScheduleInfoMaxOccurrences4 INTEGER 4TrueTrueTrueFalse%11.0f
RecurringInfoScheduleInfoRemindDays4 INTEGER 4TrueTrueTrueFalse%11.0f
RecurringInfoScheduleInfoDaysBefore4 INTEGER 4TrueTrueTrueFalse%11.0f
RecurDataRefListID12 VARCHAR 36TrueTrueTrueFalse%s
RecurDataRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s
ExpenseLineSeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
ExpenseLineTxnLineID12 VARCHAR 36TrueTrueTrueFalse%s
ExpenseLineMemo12 VARCHAR 4000TrueTrueTrueFalse%s
ExpenseLineClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ExpenseLineClassRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
ExpenseLineAmount3 DECIMAL 15TrueTrueTrueFalse%11.2f
ExpenseLineTaxAmount3 DECIMAL 15TrueTrueTrueFalse%11.2f
ExpenseLineIsTaxable-7 BIT 1TrueTrueTrueFalse
1
0
true
false
ExpenseLineDetailType12 VARCHAR 32TrueFalseFalseFalse
ItemBasedExpenseLineDetail
ExpenseLineAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ExpenseLineAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
ExpenseLineCustomerRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ExpenseLineCustomerRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
ExpenseLineBillableStatus12 VARCHAR 23TrueTrueTrueFalse
Billable
NotBillable
HasBeenBilled
ExpenseLineMarkupInfoPercent3 DECIMAL 13TrueFalseFalseFalse%7.5f
ExpenseLineMarkupInfoPercentBased-7 BIT 1TrueFalseFalseFalse
1
0
true
false
ExpenseLineMarkupInfoPriceLevelRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ExpenseLineMarkupInfoPriceLevelRefFullName12 VARCHAR 209TrueFalseFalseFalse%s Yes
ExpenseLineMarkupInfoValue3 DECIMAL 13TrueFalseFalseFalse%8.2f
ExpenseLineTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ExpenseLineTaxCodeRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
ExpenseLineTaxInclusiveAmount4 INTEGER 4TrueTrueTrueFalse%11.0f
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 73TrueTrueFalseFalseFQPrimaryKey