Accounting Data Dictionary

codaJournal__c

Label: Journal

Acts as a container for a number of journal lines and provides common information about the document.

Field NameField LabelCreated in VersionDescriptionTypeRequiredDefault Value
AccountingBook__c Accounting Book Spring 2020 A lookup to the Accounting Book.

Looks up to: AccountingBook__c
Lookup false
Allocation__c Allocation Pre-Spring 2018 Looks up to: Allocation__c
Lookup false
ArchiveSet__c Archive Set Fall 2018 Looks up to: ArchiveSet__c
Lookup false
AutoReverseJournal__c Auto-Reverse Winter 2024 If selected, a reversing journal is automatically created and posted when you post the journal.

Checkbox false
CanceledJournal__c Canceled Pre-Spring 2018 True if the Journal has been canceled by a cancelling Journal

Checkbox false false
CorrelationId__c Correlation ID Spring 2020 Records the correlation key used within the ERP system.

Text(255) false
Credits1__c Credits Fall 2018 Shows the total of credit values in document currency, displayed without a minus sign.

Formula:
IF(Credits__c < 0, Credits__c * -1, 0)
Number(18,2) false
Credits__c Credits Pre-Spring 2018 Shows the total of credit values in document currency, displayed with a minus sign.

Summary
Debits__c Debits Pre-Spring 2018 Summary
DeriveCurrency__c Derive Currency Pre-Spring 2018 Checkbox true
DerivePeriod__c Derive Period Pre-Spring 2018 Checkbox true
DiscardReason__c Discard Reason Pre-Spring 2018 TextArea false
DualRate__c Dual Rate Pre-Spring 2018 Number(18,9)
ExternalCounterparty__c External Counterparty Pre-Spring 2018 External Counterparty.

Looks up to: Account

Lookup
ExternalId__c External Id Pre-Spring 2018 Text(32) false
IncomeScheduleGroup__c Group Pre-Spring 2018 Looks up to: codaGroupingReference__c
Lookup false
IntercompanyLineCount__c Intercompany-line Count Fall 2020 Shows a count of intercompany lines for this journal.

Summary
IntercompanyTransfer__c Intercompany Transfer Pre-Spring 2018 Looks up to: codaIntercompanyTransfer__c
Lookup
JournalCurrency__c Journal Currency Pre-Spring 2018 A journal is expressed in a currency

Looks up to: codaAccountingCurrency__c
Lookup false
JournalDate__c Journal Date Pre-Spring 2018 The effective date for the journal

Date true Today()
JournalDescription__c Journal Description Pre-Spring 2018 A description for the whole document

TextArea false
JournalRate__c Journal Rate Pre-Spring 2018 Number(18,9)
JournalStatus__c Journal Status Pre-Spring 2018 The posting status

Picklist:
Complete
Discarded
In Progress
Ready To Post
LargeTransaction__c DEPRECATED: Large Journal Fall 2020 Indicates that this journal uses Large Document Processing functionality and can contain up to 9980 lines.

Checkbox false
LineCount__c Line Count Fall 2020 Summary
OriginalJournal__c Original Journal Number Pre-Spring 2018 Looks up to: codaJournal__c
Lookup false
OverrideCurrency1__c Override Currency 1 Pre-Spring 2018 Looks up to: codaAccountingCurrency__c
Lookup false
OverrideCurrency2__c Override Currency 2 Pre-Spring 2018 Looks up to: codaAccountingCurrency__c
Lookup false
OverrideCurrency3__c Override Currency 3 Pre-Spring 2018 Looks up to: codaAccountingCurrency__c
Lookup false
OverrideDebitValue1__c Override Debit Value 1 Pre-Spring 2018 Number(18,2) false
OverrideDebitValue2__c Override Debit Value 2 Pre-Spring 2018 Number(18,2) false
OverrideDebitValue3__c Override Debit Value 3 Pre-Spring 2018 Number(18,2) false
OwnerCompany__c Company Pre-Spring 2018 Looks up to: codaCompany__c
Lookup false
Period__c Period Pre-Spring 2018 Financial period

Looks up to: codaPeriod__c
Lookup false
RecurringJournalSourceJournal__c Recurring Journal Source Journal Number Pre-Spring 2018 Lookup to the source journal of a recurring journal

Looks up to: codaJournal__c
Lookup false
Reference__c Reference Pre-Spring 2018 A reference, possibly to an external document

Text(80) false
ReportingRate__c Reporting Rate Fall 2021 Number(18,9)
ReversingJournal__c Reversing Journal Number Winter 2024 The reversing journal that relates to the journal.

Looks up to: codaJournal__c
Lookup false
SourceJournal__c Source Journal Number Pre-Spring 2018 Looks up to: codaJournal__c
Lookup false
SummarizationArchiveSet__c Summarization Archive Set Spring 2018 Looks up to: ArchiveSet__c
Lookup false
Tax1Total__c Tax 1 Total Pre-Spring 2018 Summary
Tax2Total__c Tax 2 Total Pre-Spring 2018 Summary
Tax3Total__c Tax 3 Total Pre-Spring 2018 Summary
TaxTotal__c Tax Total Pre-Spring 2018 Formula:
Tax1Total__c + Tax2Total__c + Tax3Total__c
Number(18,2)
TaxableValueTotal__c Taxable Value Total Pre-Spring 2018 Summary
Total__c Total Pre-Spring 2018 Summary
Transaction__c Transaction Pre-Spring 2018 Looks up to: codaTransaction__c
Lookup false
TriggerPostingError__c Trigger Posting Error Winter 2023 TextArea false
TriggerPosting__c Trigger Posting Winter 2023 The method of trigger-posting a document after its header has been updated.

Picklist:
Asynchronous
Synchronous
Type__c Type Pre-Spring 2018 Picklist:
Archive Summarization Journal
Bank Account Adjustment Journal
Cancelling Journal
Cash Matching Journal
Cost Amortization Journal
Currency Revaluation Journal
Fixed Asset Acquisition Journal
Fixed Asset Depreciation Journal
Fixed Asset Disposal Journal
Income Schedule
Manual Journal
PSA Miscellaneous Adjustment Journal
Prepaid Expenses Journal
Reconciliation Journal
Revenue Recognition Journal
Revenue Recognition True Up Journal
Reversing Journal
SCM Drop Ship Journal
SCM Inventory Journal
SCM Procurement Journal
Year End Journal
UnitofWork__c Unit of Work Pre-Spring 2018 Number(18,0) false
Year__c Year Pre-Spring 2018 Formula:
Period__r.YearName__r.Name
Text false
codaPurchaseInvoiceExpenseLineItem__c Payable Invoice Expense Line Item Fall 2019 A lookup to the Payable Invoice Expense Line Item for a Prepaid Expenses Journal.

Looks up to: codaPurchaseInvoiceExpenseLineItem__c
Lookup false


© Copyright 2009–2024 Certinia Inc. All rights reserved. Various trademarks held by their respective owners.