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 VersionDescriptionTypeDefault Value
AccountingBook__c Accounting Book Spring 2020 A lookup to the Accounting Book.

Looks up to: AccountingBook__c
Lookup
Allocation__c Allocation Pre-Spring 2018 Looks up to: Allocation__c
Lookup
ArchiveSet__c Archive Set Fall 2018 Looks up to: ArchiveSet__c
Lookup
CanceledJournal__c Canceled Pre-Spring 2018 True if the Journal has been canceled by a cancelling Journal

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

Text(255)
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)
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
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)
IncomeScheduleGroup__c Group Pre-Spring 2018 Looks up to: codaGroupingReference__c
Lookup
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
JournalDate__c Journal Date Pre-Spring 2018 The effective date for the journal

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

TextArea
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
OverrideCurrency1__c Override Currency 1 Pre-Spring 2018 Looks up to: codaAccountingCurrency__c
Lookup
OverrideCurrency2__c Override Currency 2 Pre-Spring 2018 Looks up to: codaAccountingCurrency__c
Lookup
OverrideCurrency3__c Override Currency 3 Pre-Spring 2018 Looks up to: codaAccountingCurrency__c
Lookup
OverrideDebitValue1__c Override Debit Value 1 Pre-Spring 2018 Number(18,2)
OverrideDebitValue2__c Override Debit Value 2 Pre-Spring 2018 Number(18,2)
OverrideDebitValue3__c Override Debit Value 3 Pre-Spring 2018 Number(18,2)
OwnerCompany__c Company Pre-Spring 2018 Looks up to: codaCompany__c
Lookup
Period__c Period Pre-Spring 2018 Financial period

Looks up to: codaPeriod__c
Lookup
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
Reference__c Reference Pre-Spring 2018 A reference, possibly to an external document

Text(80)
ReportingRate__c Reporting Rate Fall 2021 Number(18,9)
SourceJournal__c Source Journal Number Pre-Spring 2018 Looks up to: codaJournal__c
Lookup
SummarizationArchiveSet__c Summarization Archive Set Spring 2018 Looks up to: ArchiveSet__c
Lookup
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
TriggerPostingError__c Trigger Posting Error Winter 2023 TextArea
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
Cancelling Journal
Cash Matching Journal
Cost Amortization 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)
Year__c Year Pre-Spring 2018 Formula:
Period__r.YearName__r.Name
Text
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


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