TABLE DETAIL REFERENCE: RecurringJournalEntryCreditLine

(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
IsAdjustment	-7	BIT	1	True	True	True	False	1 0 true false
IsHomeCurrencyAdjustment	-7	BIT	1	True	True	True	False	1 0 true false
IsAmountsEnteredInHomeCurrency	-7	BIT	1	True	True	True	False	1 0 true false
CurrencyRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	64	True	True	True	False	%s	Yes
ExchangeRate	3	DECIMAL	13	True	False	True	False	%11.7f
RefNumber	12	VARCHAR	21	True	True	True	False	%s
Memo	12	VARCHAR	4000	True	True	True	False	%s
TotalAmount	3	DECIMAL	15	True	True	True	False	%11.2f
HomeTotalAmount	3	DECIMAL	15	True	False	False	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
JournalCreditLineTxnLineID	12	VARCHAR	36	True	True	True	False	%s
JournalCreditLineAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
JournalCreditLineAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
JournalCreditLineAmount	3	DECIMAL	15	True	True	True	False	%11.2f
JournalCreditLineMemo	12	VARCHAR	4000	True	True	True	False	%s
JournalCreditLineEntityRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
JournalCreditLineEntityRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
JournalCreditLineClassRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
JournalCreditLineClassRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
JournalCreditLineDepartmentRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
JournalCreditLineDepartmentRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
JournalCreditLineBillableStatus	12	VARCHAR	13	True	True	True	False	Billable NotBillable HasBeenBilled
FQTransactionLinkKey	12	VARCHAR	73	True	False	False	False	FQPrimaryKey
FQPrimaryKey	12	VARCHAR	73	True	False	False	False	FQPrimaryKey