TABLE DETAIL REFERENCE: JournalEntryCreditLine
(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 4TrueFalseFalseFalse%11.0f
IsAdjustment-7 BIT 1TrueTrueTrueFalse
1
0
true
false
IsHomeCurrencyAdjustment-7 BIT 1TrueTrueTrueFalse
1
0
true
false
IsAmountsEnteredInHomeCurrency-7 BIT 1TrueTrueTrueFalse
1
0
true
false
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 64TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 13TrueFalseTrueFalse%11.7f
TxnDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
RefNumber12 VARCHAR 21TrueTrueTrueFalse%s
Memo12 VARCHAR 4000TrueTrueTrueFalse%s
TotalAmount3 DECIMAL 15TrueTrueTrueFalse%11.2f
HomeTotalAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
TxnSource12 VARCHAR 100TrueFalseFalseFalse%s
TransactionLocationType12 VARCHAR 32TrueTrueTrueFalse
WithinFrance
FranceOverseas
OutsideFranceWithEU
OutsideEU
JournalCreditLineTxnLineID12 VARCHAR 36TrueTrueTrueFalse%s
JournalCreditLineType12 VARCHAR 14TrueTrueFalseFalse
Debit
Credit
JournalCreditLineAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
JournalCreditLineAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
JournalCreditLineAmount3 DECIMAL 15TrueTrueTrueFalse%11.2f
JournalCreditLineMemo12 VARCHAR 4000TrueTrueTrueFalse%s
JournalCreditLineEntityRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
JournalCreditLineEntityRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
JournalCreditLineClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
JournalCreditLineClassRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
JournalCreditLineDepartmentRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
JournalCreditLineDepartmentRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
JournalCreditLineTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
JournalCreditLineTaxCodeRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
JournalCreditLineBillableStatus12 VARCHAR 13TrueTrueTrueFalse
Billable
NotBillable
HasBeenBilled
FQSaveToCache-7 BIT 1TrueTrueTrueFalseFQSaveToCache
FQTransactionLinkKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey