| AccountAnalysis__c |
Account Analysis |
Pre-Spring 2018 |
Looks up to: Account
|
Lookup |
false |
|
| AccountReference__c |
Account Reference |
Spring 2023 |
Enables you to enter one or more references to be used by background matching.
|
Text(255) |
|
|
| AccountValue__c |
Override Account Value |
Pre-Spring 2018 |
The value in account currency
|
Number(18,2) |
false |
|
| Account__c |
Account |
Pre-Spring 2018 |
A journal line may refer to an account
Looks up to: Account
|
Lookup |
false |
|
| 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 |
false |
|
| BankAccountValue__c |
Override Bank Account Value |
Pre-Spring 2018 |
The value in bank currency
|
Number(18,2) |
false |
|
| BankAccount__c |
Bank Account |
Pre-Spring 2018 |
A journal line may refer to a bank
Looks up to: codaBankAccount__c
|
Lookup |
false |
|
| CorrelationId__c |
Correlation ID |
Spring 2020 |
Records the correlation key used within the ERP system.
|
Text(255) |
false |
|
| Credits__c |
Credit |
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) |
false |
|
| DebitCredit__c |
Debit/Credit |
Pre-Spring 2018 |
|
Picklist:
Credit
Debit |
|
|
| Debits__c |
Debit |
Fall 2018 |
Shows the debit value in document currency.
Formula:
IF(Value__c > 0, Value__c, 0)
|
Number(18,2) |
false |
|
| DeriveLineNumber__c |
Derive Line Number |
Pre-Spring 2018 |
|
Checkbox |
|
true |
| DestinationCompany__c |
Destination Company |
Pre-Spring 2018 |
Looks up to: codaCompany__c
|
Lookup |
false |
|
| 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) |
false |
|
| Dimension1__c |
Dimension 1 |
Pre-Spring 2018 |
Looks up to: codaDimension1__c
|
Lookup |
false |
|
| Dimension2Value__c |
Override Dimension 2 Value |
Pre-Spring 2018 |
The value in dimension currency
|
Number(18,2) |
false |
|
| Dimension2__c |
Dimension 2 |
Pre-Spring 2018 |
Looks up to: codaDimension2__c
|
Lookup |
false |
|
| Dimension3Value__c |
Override Dimension 3 Value |
Pre-Spring 2018 |
The value in dimension currency
|
Number(18,2) |
false |
|
| Dimension3__c |
Dimension 3 |
Pre-Spring 2018 |
Looks up to: codaDimension3__c
|
Lookup |
false |
|
| Dimension4Value__c |
Override Dimension 4 Value |
Pre-Spring 2018 |
The value in dimension currency
|
Number(18,2) |
false |
|
| Dimension4__c |
Dimension 4 |
Pre-Spring 2018 |
Looks up to: codaDimension4__c
|
Lookup |
false |
|
| 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) |
false |
|
| 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) |
false |
|
| GeneralLedgerAccountValue__c |
Override General Ledger Account Value |
Pre-Spring 2018 |
|
Number(18,2) |
false |
|
| GeneralLedgerAccount__c |
General Ledger Account |
Pre-Spring 2018 |
A journal line always refers to a GLA
Looks up to: codaGeneralLedgerAccount__c
|
Lookup |
false |
|
| HomeValue__c |
Override Home Value |
Pre-Spring 2018 |
The value in home currency
|
Number(18,2) |
false |
|
| 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) |
false |
|
| LineNumber__c |
Line Number |
Pre-Spring 2018 |
|
Number(18,0) |
false |
|
| 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) |
false |
|
| LocalGLA__c |
Local GLA |
Pre-Spring 2018 |
Looks up to: codaGeneralLedgerAccount__c
|
Lookup |
false |
|
| OwnerCompany__c |
Company |
Pre-Spring 2018 |
Looks up to: codaCompany__c
|
Lookup |
false |
|
| ProductAnalysis__c |
Product Analysis |
Pre-Spring 2018 |
Looks up to: Product2
|
Lookup |
false |
|
| Product__c |
Product |
Pre-Spring 2018 |
A journal line may refer to a product
Looks up to: Product2
|
Lookup |
false |
|
| 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) |
false |
|
| TaxAnalysis1__c |
Tax Analysis |
Pre-Spring 2018 |
Looks up to: codaTaxCode__c
|
Lookup |
false |
|
| TaxAnalysis2__c |
Tax Analysis 2 |
Pre-Spring 2018 |
Looks up to: codaTaxCode__c
|
Lookup |
false |
|
| TaxAnalysis3__c |
Tax Analysis 3 |
Pre-Spring 2018 |
Looks up to: codaTaxCode__c
|
Lookup |
false |
|
| TaxCode__c |
Tax Code |
Pre-Spring 2018 |
A journal line may refer to a tax code
Looks up to: codaTaxCode__c
|
Lookup |
false |
|
| TaxValue1__c |
Tax Value |
Pre-Spring 2018 |
|
Number(18,2) |
false |
|
| TaxValue2__c |
Tax Value 2 |
Pre-Spring 2018 |
|
Number(18,2) |
false |
|
| TaxValue3__c |
Tax Value 3 |
Pre-Spring 2018 |
|
Number(18,2) |
false |
|
| TaxableValue__c |
Taxable Value |
Pre-Spring 2018 |
|
Number(18,2) |
false |
|
| UnitOfWork__c |
Unit of Work |
Pre-Spring 2018 |
|
Number(18,0) |
false |
|
| Value__c |
Value |
Pre-Spring 2018 |
The value in document currency
|
Number(18,2) |
true |
0 |
| VendorValue__c |
Vendor Value |
Pre-Spring 2018 |
The value in vendor currency
|
Number(18,2) |
false |
0 |
| YearEndCriterionIdentifier__c |
Year End Criteria Identifier |
Pre-Spring 2018 |
|
Text(255) |
false |
|
