Accounting Data Dictionary

c2g__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
c2g__AccountingBook__c Accounting Book Spring 2020 A lookup to the Accounting Book.

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

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

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

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

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

Summary
c2g__Debits__c Debits Pre-Spring 2018 Summary
c2g__DeriveCurrency__c Derive Currency Pre-Spring 2018 Checkbox true
c2g__DerivePeriod__c Derive Period Pre-Spring 2018 Checkbox true
c2g__DiscardReason__c Discard Reason Pre-Spring 2018 TextArea false
c2g__DualRate__c Dual Rate Pre-Spring 2018 Number(18,9)
c2g__ExternalCounterparty__c External Counterparty Pre-Spring 2018 External Counterparty.

Looks up to: Account

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

Summary
c2g__IntercompanyTransfer__c Intercompany Transfer Pre-Spring 2018 Looks up to: c2g__codaIntercompanyTransfer__c
Lookup
c2g__JournalCurrency__c Journal Currency Pre-Spring 2018 A journal is expressed in a currency

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

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

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

Picklist:
Complete
Discarded
In Progress
Ready To Post
c2g__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
c2g__LineCount__c Line Count Fall 2020 Summary
c2g__OriginalJournal__c Original Journal Number Pre-Spring 2018 Looks up to: c2g__codaJournal__c
Lookup false
c2g__OverrideCurrency1__c Override Currency 1 Pre-Spring 2018 Looks up to: c2g__codaAccountingCurrency__c
Lookup false
c2g__OverrideCurrency2__c Override Currency 2 Pre-Spring 2018 Looks up to: c2g__codaAccountingCurrency__c
Lookup false
c2g__OverrideCurrency3__c Override Currency 3 Pre-Spring 2018 Looks up to: c2g__codaAccountingCurrency__c
Lookup false
c2g__OverrideDebitValue1__c Override Debit Value 1 Pre-Spring 2018 Number(18,2) false
c2g__OverrideDebitValue2__c Override Debit Value 2 Pre-Spring 2018 Number(18,2) false
c2g__OverrideDebitValue3__c Override Debit Value 3 Pre-Spring 2018 Number(18,2) false
c2g__OwnerCompany__c Company Pre-Spring 2018 Looks up to: c2g__codaCompany__c
Lookup false
c2g__Period__c Period Pre-Spring 2018 Financial period

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

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

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

Looks up to: c2g__codaJournal__c
Lookup false
c2g__SourceJournal__c Source Journal Number Pre-Spring 2018 Looks up to: c2g__codaJournal__c
Lookup false
c2g__SummarizationArchiveSet__c Summarization Archive Set Spring 2018 Looks up to: c2g__ArchiveSet__c
Lookup false
c2g__Tax1Total__c Tax 1 Total Pre-Spring 2018 Summary
c2g__Tax2Total__c Tax 2 Total Pre-Spring 2018 Summary
c2g__Tax3Total__c Tax 3 Total Pre-Spring 2018 Summary
c2g__TaxTotal__c Tax Total Pre-Spring 2018 Formula:
c2g__Tax1Total__c + c2g__Tax2Total__c + c2g__Tax3Total__c
Number(18,2)
c2g__TaxableValueTotal__c Taxable Value Total Pre-Spring 2018 Summary
c2g__Total__c Total Pre-Spring 2018 Summary
c2g__Transaction__c Transaction Pre-Spring 2018 Looks up to: c2g__codaTransaction__c
Lookup false
c2g__TriggerPostingError__c Trigger Posting Error Winter 2023 TextArea false
c2g__TriggerPosting__c Trigger Posting Winter 2023 The method of trigger-posting a document after its header has been updated.

Picklist:
Asynchronous
Synchronous
c2g__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
c2g__UnitofWork__c Unit of Work Pre-Spring 2018 Number(18,0) false
c2g__Year__c Year Pre-Spring 2018 Formula:
c2g__Period__r.c2g__YearName__r.Name
Text false
c2g__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: c2g__codaPurchaseInvoiceExpenseLineItem__c
Lookup false


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