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) |
|