FFA Data Dictionary

codaJournalLineItem__c

Label: Journal Line Item

Stores the details of the journal lines.

Field NameField LabelCreated in VersionDescriptionTypeDefault Value
AccountAnalysis__c Account Analysis Pre-Spring 2018 Looks up to: Account

Lookup
AccountValue__c Override Account Value Pre-Spring 2018 The value in account currency

Number(18,2)
Account__c Account Pre-Spring 2018 A journal line may refer to an account

Looks up to: Account

Lookup
ArchivingGLAKey__c Archiving GLA Key Spring 2020 Stores the key for the Archiving Journal Line Item, based on the Account and GLA.

Formula:
IF(OR(ISNULL(GeneralLedgerAccount__c ),ISBLANK(GeneralLedgerAccount__c ), NOT(ISPICKVAL(Journal__r.Type__c, 'Archive Summarization Journal'))),'', IF(OR(ISNULL(Account__c), ISBLANK(Account__c)) , GeneralLedgerAccount__c , Account__c + "#" + GeneralLedgerAccount__c))
Text
BankAccountValue__c Override Bank Account Value Pre-Spring 2018 The value in bank currency

Number(18,2)
BankAccount__c Bank Account Pre-Spring 2018 A journal line may refer to a bank

Looks up to: codaBankAccount__c
Lookup
CorrelationId__c Correlation ID Spring 2020 Records the correlation key used within the ERP system.

Text(255)
Credits__c Credits Fall 2018 Shows the credit value in document currency, displayed without a minus sign.

Formula:
IF(Value__c < 0, Value__c * -1, 0)
Number(18,2)
DebitCredit__c Debit/Credit Pre-Spring 2018 Picklist:
Credit
Debit
Debits__c Debits Fall 2018 Shows the debit value in document currency.

Formula:
IF(Value__c > 0, Value__c, 0)
Number(18,2)
DeriveLineNumber__c Derive Line Number Pre-Spring 2018 Checkbox true
DestinationCompany__c Destination Company Pre-Spring 2018 Looks up to: codaCompany__c
Lookup
DestinationLineType__c Destination Line Type Pre-Spring 2018 Picklist:
Account - Customer
Account - Vendor
Bank Account
General Ledger Account
Product - Purchases
Product - Sales
Tax Code
Dimension1Value__c Override Dimension 1 Value Pre-Spring 2018 The value in dimension currency

Number(18,2)
Dimension1__c Dimension 1 Pre-Spring 2018 Looks up to: codaDimension1__c
Lookup
Dimension2Value__c Override Dimension 2 Value Pre-Spring 2018 The value in dimension currency

Number(18,2)
Dimension2__c Dimension 2 Pre-Spring 2018 Looks up to: codaDimension2__c
Lookup
Dimension3Value__c Override Dimension 3 Value Pre-Spring 2018 The value in dimension currency

Number(18,2)
Dimension3__c Dimension 3 Pre-Spring 2018 Looks up to: codaDimension3__c
Lookup
Dimension4Value__c Override Dimension 4 Value Pre-Spring 2018 The value in dimension currency

Number(18,2)
Dimension4__c Dimension 4 Pre-Spring 2018 Looks up to: codaDimension4__c
Lookup
DualRate__c Dual Rate Pre-Spring 2018 Number(18,9)
DualValue__c Override Dual Value Pre-Spring 2018 The value in dual currency

Number(18,2)
ExcludefromCashFlow__c Exclude from Cash Flow Fall 2020 If selected, indicates that the bank account line item is excluded from the Cash Flow Analytics dashboard in Business Analytics.

Checkbox false
ExternalId__c External Id Pre-Spring 2018 Text(32)
GeneralLedgerAccountValue__c Override General Ledger Account Value Pre-Spring 2018 Number(18,2)
GeneralLedgerAccount__c General Ledger Account Pre-Spring 2018 A journal line always refers to a GLA

Looks up to: codaGeneralLedgerAccount__c
Lookup
HomeValue__c Override Home Value Pre-Spring 2018 The value in home currency

Number(18,2)
IntercompanyTransfer__c Intercompany Transfer Pre-Spring 2018 Looks up to: codaIntercompanyTransfer__c
Lookup
JournalRate__c Journal Rate Pre-Spring 2018 Number(18,9)
Journal__c Journal Pre-Spring 2018 A journal consists of a set of journal lines

Looks up to: codaJournal__c
MasterDetail
LineDescription__c Line Description Pre-Spring 2018 A reference linking matched lines

Text(255)
LineNumber__c Line Number Pre-Spring 2018 Number(18,0)
LineType__c Line Type Pre-Spring 2018 Every journal line must have a line type

Picklist:
Account - Customer
Account - Vendor
Bank Account
General Ledger Account
Intercompany
Product - Purchases
Product - Sales
Tax Code
LocalGLAValue__c Override Local GLA Value Pre-Spring 2018 Number(18,2)
LocalGLA__c Local GLA Pre-Spring 2018 Looks up to: codaGeneralLedgerAccount__c
Lookup
OwnerCompany__c Company Pre-Spring 2018 Looks up to: codaCompany__c
Lookup
ProductAnalysis__c Product Analysis Pre-Spring 2018 Looks up to: Product2

Lookup
Product__c Product Pre-Spring 2018 A journal line may refer to a product

Looks up to: Product2

Lookup
ReportingRate__c Reporting Rate Fall 2021 The rate used to report to the parent company.

Number(18,9)
ReportingValue__c Override Reporting Value Fall 2021 Overrides the value used to report to the parent company.

Number(18,2)
TaxAnalysis1__c Tax Analysis Pre-Spring 2018 Looks up to: codaTaxCode__c
Lookup
TaxAnalysis2__c Tax Analysis 2 Pre-Spring 2018 Looks up to: codaTaxCode__c
Lookup
TaxAnalysis3__c Tax Analysis 3 Pre-Spring 2018 Looks up to: codaTaxCode__c
Lookup
TaxCode__c Tax Code Pre-Spring 2018 A journal line may refer to a tax code

Looks up to: codaTaxCode__c
Lookup
TaxValue1__c Tax Value Pre-Spring 2018 Number(18,2)
TaxValue2__c Tax Value 2 Pre-Spring 2018 Number(18,2)
TaxValue3__c Tax Value 3 Pre-Spring 2018 Number(18,2)
TaxableValue__c Taxable Value Pre-Spring 2018 Number(18,2)
UnitOfWork__c Unit of Work Pre-Spring 2018 Number(18,0)
Value__c Value Pre-Spring 2018 The value in document currency

Number(18,2) 0
VendorValue__c Vendor Value Pre-Spring 2018 The value in vendor currency

Number(18,2) 0
YearEndCriterionIdentifier__c Year End Criteria Identifier Pre-Spring 2018 Text(255)


© Copyright 2009–2022 FinancialForce.com, inc. All rights reserved. Various trademarks held by their respective owners.