Accounting Data Dictionary

codaGeneralLedgerAccount__c

Label: General Ledger Account

General ledger account represent different categories of income/expenses/assets/liabilities and reserves.

Field NameField LabelCreated in VersionDescriptionTypeDefault Value
AdjustOperatingActivities__c Reclassify Profits Pre-Spring 2018 Checkbox false
AllowRevaluation__c Allow Revaluation Pre-Spring 2018 Checkbox false
BalanceSheet1__c Balance Sheet 1 Pre-Spring 2018 Picklist:
Balance Sheet
BalanceSheet2__c Balance Sheet 2 Pre-Spring 2018 Picklist:
Current Assets
Current Liabilities
Fixed Assets
Income Statement
Intangible Assets
Long Term Liabilities
Profit and Loss
Shareholders Funds
BalanceSheet3__c Balance Sheet 3 Pre-Spring 2018 Picklist:
Accounts Payable
Accounts Receivable
Accruals and Deferred Income
Bank and Cash
Capital and Reserves
Creditors
Creditors Due After 1 Year
Debtors
Employment Creditors
Employment Payables
Fixtures Fittings and Equipment
Intangible Assets
Inventory
Land and Buildings
Payable After 1 Year
Prepayments and Accrued Income
Provisions
Stock
Tax Liability
CashFlowCategory__c Cash Flow Category Pre-Spring 2018 Cash Flow Category

Picklist:
Financing Activities
Investing Activities
Operating Activities
Other
CashFlowLineSummary__c Cash Flow Line Summary Pre-Spring 2018 Picklist:
(Gain) / Loss on Foreign Exchange
(Gain) / Loss on Investment Disposals
(Increase) / Decrease in Inventory
(Increase) / Decrease in Other Current Assets
(Increase) / Decrease in Receivables
Deferred Revenue
Depreciation & Amortization
Dividends Received
Dividends on Common Shares
Dividends on Preference Shares
Impairment
Increase / (Decrease) in Common Capital
Increase / (Decrease) in Employment Creditors
Increase / (Decrease) in Long Term Borrowing
Increase / (Decrease) in Other Current Liabilities
Increase / (Decrease) in Payables
Increase / (Decrease) in Preference Capital
Increase / (Decrease) in Short Term Borrowing
Increase / (Decrease) in Tax Liability
Interest Expense
Interest Income
Purchase of Fixed Assets
Purchase of Investment Securities
Research & Development
Sale of Investment Securities
Sales Proceeds from Disposal of Fixed Assets
Taxation
Unrealized (Gain) / Loss on Foreign Exchange
ChartOfAccountsStructure__c Chart of Accounts Structure Pre-Spring 2018 Looks up to: ChartOfAccountsStructure__c
Lookup
DateFrom__c Date From Winter 2023 If the period start and end date of the document match or are within the dates mentioned in the Date From and Date To fields in the Posting Effective Dates section of the GLA, then that GLA is available to be assigned to that document.

Date
DateTo__c Date To Winter 2023 If the period start and end date of the document match or are within the dates mentioned in the Date From and Date To fields in the Posting Effective Dates section of the GLA, then that GLA is available to be assigned to that document.

Date
ExternalId__c External Id Pre-Spring 2018 Text(32)
GLAGroup__c GLA Group Pre-Spring 2018 Picklist:
Accounts Payable
Accounts Receivable
Cash
IntercompanyElimination__c Intercompany Elimination Spring 2021 Checkbox false
LocalBalanceSheet1__c Local Balance Sheet 1 Spring 2020 Text(255)
LocalBalanceSheet2__c Local Balance Sheet 2 Spring 2020 Text(255)
LocalBalanceSheet3__c Local Balance Sheet 3 Spring 2020 Text(255)
LocalBalanceSheet4__c Local Balance Sheet 4 Spring 2020 Text(255)
LocalBalanceSheetOrder1__c Local Balance Sheet Order 1 Spring 2020 Text(5)
LocalBalanceSheetOrder2__c Local Balance Sheet Order 2 Spring 2020 Text(5)
LocalBalanceSheetOrder3__c Local Balance Sheet Order 3 Spring 2020 Text(5)
LocalBalanceSheetOrder4__c Local Balance Sheet Order 4 Spring 2020 Text(5)
LocalTrialBalance1__c Local Trial Balance 1 Spring 2020 Text(255)
LocalTrialBalance2__c Local Trial Balance 2 Spring 2020 Text(255)
LocalTrialBalance3__c Local Trial Balance 3 Spring 2020 Text(255)
LocalTrialBalance4__c Local Trial Balance 4 Spring 2020 Text(255)
Localization__c Localization Spring 2020 Stores the ISO country code of the localization. The field is populated by the localization that exists in the GLA. This field is hidden and read only.

Picklist:
AT
BE
CH
DE
DK
ES
FI
FR
IT
LU
NL
NO
SE
PostingAllowed__c Allow Posting Winter 2023 By default, this field is set to “All Dates” which allows this GLA to be assigned to any document irrespective of its period. You can set it to “Select Dates” and specify the dates in the Date From and Date To fields. This makes the GLA available for posting only those documents that have the period start and end dates within the dates mentioned here.

Picklist:
All Dates
Select Dates
ReportingCode__c Reporting Code Pre-Spring 2018 Text(24)
StandardAccountID__c Standard Account ID Fall 2021 Text(24)
TrialBalance1__c Trial Balance 1 Pre-Spring 2018 Picklist:
Assets
Equity
Expenses
Gross Profit
Liabilities
TrialBalance2__c Trial Balance 2 Pre-Spring 2018 Picklist:
Cost of Sales
Current Assets
Current Liabilities
Depreciation and Amortization
Fixed Assets
Intangible Assets
Interest and Tax
Long Term Liabilities
Operating Expenses
Other Assets
Other Income/Expense
Retained Earnings
Sales Revenue
Shareholders Funds
TrialBalance3__c Trial Balance 3 Pre-Spring 2018 Picklist:
Accounts Payable
Accounts Receivable
Accruals and Deferred Income
Administration Costs
Amortization
Bank and Cash
Capital and Reserves
Cost of Sales
Creditors
Creditors Due After 1 Year
Debtors
Depreciation
Employment Creditors
Employment Payables
Equipment Hire and Repairs
Finance Costs
Fixtures Fittings and Equipment
Intangible Assets
Inventory
Land and Buildings
Marketing Expenses
Motor Expenses
Occupation Costs
Other Assets
Other Income and Expenses
Payable After 1 Year
Payroll Costs
Prepayments and Accrued Income
Professional Fees
Provisions
Retained Earnings
Sales Revenue
Staff Costs
Stock
Tax Liability
Taxation
Travel Expenses
TrialBalance4__c Trial Balance 4 Pre-Spring 2018 Picklist:
Cost of Sales - Direct
Cost of Sales - Indirect
Sales - Direct
Sales - Indirect
Type__c Type Pre-Spring 2018 Picklist:
Balance Sheet
Profit and Loss
Retained Earnings
UnitOfWork__c Unit of Work Pre-Spring 2018 Number(18,0)
UnrealizedGainLossGLA__c Unrealized Gains/Losses GLA Spring 2020 Checkbox false
hasLocalization__c Has a localization value Spring 2020 Formula:
!ISPICKVAL(Localization__c, '')
Checkbox


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