Accounting Data Dictionary

codaTransactionLineItem__c

Label: Transaction Line Item

The line items on a transaction.

Field NameField LabelCreated in VersionDescriptionTypeRequiredDefault Value
AccountCurrency__c Account Currency Pre-Spring 2018 Looks up to: codaAccountingCurrency__c
Lookup
AccountOutstandingValue__c Account Outstanding Value Pre-Spring 2018 See note 1

Number(18,2)
AccountRollup__c Account Rollup Pre-Spring 2018 Formula:
IF( ISNULL( Transaction__r.Account__c ), 'False', 'True' )
Text
AccountTradingCurrencyMismatch__c Account Trading Currency Mismatch Pre-Spring 2018 Formula:
AccountCurrency__r.Name <> Account__r.CODAAccountTradingCurrency__c
Checkbox
AccountType__c Account Type Pre-Spring 2018 Formula:
IF( Account__r.CODAIntercompanyAccount__c, 'Intercompany', IF(AND(Account__r.CODAAccountsPayableControl__c != NULL, Account__r.CODAAccountsReceivableControl__c != NULL, Account__r.CODAAccountsPayableControl__c = Account__r.CODAAccountsReceivableControl__c), 'Customer - Vendor', IF(AND(Account__r.CODAAccountsPayableControl__c != NULL, Account__r.CODAAccountsPayableControl__c = GeneralLedgerAccount__c) , 'Vendor', IF(AND(Account__r.CODAAccountsReceivableControl__c != NULL, Account__r.CODAAccountsReceivableControl__c = GeneralLedgerAccount__c), 'Customer', NULL))))
Text
AccountValue__c Account Value Pre-Spring 2018 Number(18,2)
Account__c Account Pre-Spring 2018 Looks up to: Account

Lookup
AdjustOperatingActivities__c Reclassify Profits Pre-Spring 2018 Checkbox false
ArchiveSet__c Archive Set Spring 2018 Looks up to: ArchiveSet__c
Lookup false
AsOfAgeBand__c As of Age Band Pre-Spring 2018 Formula:
IF( OR( ISNULL( $Setup.AsOfAgingReportSettings__c.AgeBand1Max__c ), AsOfAge__c <= $Setup.AsOfAgingReportSettings__c.AgeBand1Max__c ), $Setup.AsOfAgingReportSettings__c.AgeBand1Label__c, IF( OR( ISNULL( $Setup.AsOfAgingReportSettings__c.AgeBand2Max__c ), AsOfAge__c <= $Setup.AsOfAgingReportSettings__c.AgeBand2Max__c ), $Setup.AsOfAgingReportSettings__c.AgeBand2Label__c, IF( OR( ISNULL( $Setup.AsOfAgingReportSettings__c.AgeBand3Max__c ), AsOfAge__c <= $Setup.AsOfAgingReportSettings__c.AgeBand3Max__c ), $Setup.AsOfAgingReportSettings__c.AgeBand3Label__c, IF( OR( ISNULL( $Setup.AsOfAgingReportSettings__c.AgeBand4Max__c ), AsOfAge__c <= $Setup.AsOfAgingReportSettings__c.AgeBand4Max__c ), $Setup.AsOfAgingReportSettings__c.AgeBand4Label__c, IF( OR( ISNULL( $Setup.AsOfAgingReportSettings__c.AgeBand5Max__c ), AsOfAge__c <= $Setup.AsOfAgingReportSettings__c.AgeBand5Max__c ), $Setup.AsOfAgingReportSettings__c.AgeBand5Label__c, IF( OR( ISNULL( $Setup.AsOfAgingReportSettings__c.AgeBand6Max__c ), AsOfAge__c <= $Setup.AsOfAgingReportSettings__c.AgeBand6Max__c ), $Setup.AsOfAgingReportSettings__c.AgeBand6Label__c, null ) ) ) ) ) )
Text false
AsOfAge__c As of Age Pre-Spring 2018 Formula:
AsOfDate__c - IF( $Setup.AsOfAgingReportSettings__c.AgeByDueDate__c, DueDate__c, Transaction__r.TransactionDate__c )
Number(18,0) false
AsOfDate__c As of Date Pre-Spring 2018 Date false
AsOfDualValue__c As of Dual Value Pre-Spring 2018 Number(18,2) false
AsOfHomeValue__c As of Home Value Pre-Spring 2018 Number(18,2) false
AsOfName__c As of Name Pre-Spring 2018 Text(80) false
BalanceUpdateDimensionsPriorToAmend__c Balance Update Dimensions Prior to Amend Spring 2022 When amending the dimensions of a transaction line item on any document, this field temporarily stores the existing dimension values, so that when the Balance Update process runs, the Reporting Balance values are correct.

Text(255)
BalanceUpdate__c Balance Update Summer 2020 Indicates whether the transaction line has updated the Reporting Balances records or not. It is only relevant if you use On Demand update of the Reporting Balances from Transactions. It will mark the balance update for the line as "Pending" or "Complete"

Text(25)
BankAccountCurrency__c Bank Account Currency Pre-Spring 2018 Looks up to: codaAccountingCurrency__c
Lookup
BankAccountValue__c Bank Account Value Pre-Spring 2018 Number(18,2)
BankAccount__c Bank Account Pre-Spring 2018 Looks up to: codaBankAccount__c
Lookup
BankReconciliationStatus__c Bank Reconciliation Status Pre-Spring 2018 Formula:
IF( ISNULL( DateCanceled__c ), TEXT(BankReconciliation__r.ReconciliationStatus__c), 'Canceled' )
Text
BankReconciliation__c Bank Reconciliation Pre-Spring 2018 Looks up to: codaBankReconciliation__c
Lookup
CashFlowCategory__c Cash Flow Category Pre-Spring 2018 Picklist:
Financing Activities
Investing Activities
Not Cash Flow Adjustable
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
DateCanceled__c Date Canceled Pre-Spring 2018 Date false
DaysOverdue__c Days Overdue Pre-Spring 2018 Formula:
IF(TODAY() - DueDate__c<0,0,TODAY() - DueDate__c)
Number(18,0)
Dimension1Currency__c Dimension 1 Currency Pre-Spring 2018 Looks up to: codaAccountingCurrency__c
Lookup
Dimension1Value__c Dimension 1 Value Pre-Spring 2018 Number(18,2)
Dimension1__c Dimension 1 Pre-Spring 2018 Looks up to: codaDimension1__c
Lookup
Dimension2Currency__c Dimension 2 Currency Pre-Spring 2018 Looks up to: codaAccountingCurrency__c
Lookup
Dimension2Value__c Dimension 2 Value Pre-Spring 2018 Number(18,2)
Dimension2__c Dimension 2 Pre-Spring 2018 Looks up to: codaDimension2__c
Lookup
Dimension3Currency__c Dimension 3 Currency Pre-Spring 2018 Looks up to: codaAccountingCurrency__c
Lookup
Dimension3Value__c Dimension 3 Value Pre-Spring 2018 Number(18,2)
Dimension3__c Dimension 3 Pre-Spring 2018 Looks up to: codaDimension3__c
Lookup
Dimension4Currency__c Dimension 4 Currency Pre-Spring 2018 Looks up to: codaAccountingCurrency__c
Lookup
Dimension4Value__c Dimension 4 Value Pre-Spring 2018 Number(18,2)
Dimension4__c Dimension 4 Pre-Spring 2018 Looks up to: codaDimension4__c
Lookup
DiscountAccountValue1__c Discount Account Value 1 Pre-Spring 2018 Number(18,2)
DiscountAccountValue2__c Discount Account Value 2 Pre-Spring 2018 Number(18,2)
DiscountAccountValue3__c Discount Account Value 3 Pre-Spring 2018 Number(18,2)
DiscountAccountValue4__c Discount Account Value 4 Pre-Spring 2018 Number(18,2)
DiscountDate1__c Discount Date 1 Pre-Spring 2018 Date
DiscountDate2__c Discount Date 2 Pre-Spring 2018 Date
DiscountDate3__c Discount Date 3 Pre-Spring 2018 Date
DiscountDate4__c Discount Date 4 Pre-Spring 2018 Date
DiscountValue1__c Discount Document Value 1 Pre-Spring 2018 Number(18,2)
DiscountValue2__c Discount Document Value 2 Pre-Spring 2018 Number(18,2)
DiscountValue3__c Discount Document Value 3 Pre-Spring 2018 Number(18,2)
DiscountValue4__c Discount Document Value 4 Pre-Spring 2018 Number(18,2)
DocumentCurrency__c Document Currency Pre-Spring 2018 Looks up to: codaAccountingCurrency__c
Lookup
DocumentNumber__c Document Number Pre-Spring 2018 Formula:
IF(Transaction__r.DocumentNumber__c <> null,if( BEGINS( Transaction__r.DocumentNumber__c , "SIN") && Transaction__r.SalesInvoice__c <> null, HYPERLINK("/" & Transaction__r.SalesInvoice__c ,Transaction__r.DocumentNumber__c) , if( BEGINS(Transaction__r.DocumentNumber__c, "SCR") && Transaction__r.SalesCreditNote__c <> null, HYPERLINK("/" & Transaction__r.SalesCreditNote__c ,Transaction__r.DocumentNumber__c) , if( BEGINS(Transaction__r.DocumentNumber__c, "CRV") && Transaction__r.CurrencyRevaluation__c <> null, HYPERLINK("/" & Transaction__r.CurrencyRevaluation__c ,Transaction__r.DocumentNumber__c) , if( BEGINS(Transaction__r.DocumentNumber__c, "PIN") && Transaction__r.PayableInvoice__c <> null, HYPERLINK("/" & Transaction__r.PayableInvoice__c ,Transaction__r.DocumentNumber__c) , if( BEGINS(Transaction__r.DocumentNumber__c, "PCR") && Transaction__r.PayableCreditNote__c <> null, HYPERLINK("/" & Transaction__r.PayableCreditNote__c ,Transaction__r.DocumentNumber__c) , if( BEGINS(Transaction__r.DocumentNumber__c, "JNL") && Transaction__r.Journal__c <> null , HYPERLINK("/" & Transaction__r.Journal__c ,Transaction__r.DocumentNumber__c) , if( BEGINS(Transaction__r.DocumentNumber__c, "BD") && Transaction__r.BillingDocument__c <> null , HYPERLINK("/" & Transaction__r.BillingDocument__c ,Transaction__r.DocumentNumber__c) , if( BEGINS(Transaction__r.DocumentNumber__c, "CSH") && Transaction__r.CashEntry__c <> null, HYPERLINK("/" & Transaction__r.CashEntry__c ,Transaction__r.DocumentNumber__c),Transaction__r.DocumentNumber__c) ))))))),"")
Text
DocumentOutstandingValue__c Document Outstanding Value Pre-Spring 2018 Number(18,2)
DocumentRate__c Document Rate Pre-Spring 2018 The document to home exchange rate.

Number(18,9)
DocumentTaxTotal__c Document Tax Total Pre-Spring 2018 Formula:
DocumentTaxValue1__c + DocumentTaxValue2__c + DocumentTaxValue3__c
Number(18,2)
DocumentTaxValue1__c Document Tax Value Pre-Spring 2018 Number(18,2)
DocumentTaxValue2__c Document Tax Value 2 Pre-Spring 2018 Number(18,2)
DocumentTaxValue3__c Document Tax Value 3 Pre-Spring 2018 Number(18,2)
DocumentTaxableValue__c Document Taxable Value Pre-Spring 2018 Number(18,2)
DocumentValue__c Document Value Pre-Spring 2018 Number(18,2) 0.00
DocumentsToMatch__c Documents to Match Spring 2023 Stores the documents to match with the cash entry line.

LongTextArea(131070)
DualCurrency__c Dual Currency Pre-Spring 2018 Looks up to: codaAccountingCurrency__c
Lookup
DualOutstandingValue__c Dual Outstanding Value Pre-Spring 2018 See note 1

Number(18,2)
DualRate__c Dual Rate Pre-Spring 2018 The dual to home exchange rate.

Number(18,9)
DualValue__c Dual Value Pre-Spring 2018 Number(18,2) 0.00
DueDate__c Due Date Pre-Spring 2018 The due date on matchable lines

Date
EliminationTransaction__c Elimination Transaction Spring 2021 Looks up to: codaTransaction__c
Lookup
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
Expense__c Expense Pre-Spring 2018 Looks up to: codaGeneralLedgerAccount__c
Lookup false
ExternalId__c External Id Pre-Spring 2018 Text(32)
GeneralLedgerAccountCurrency__c General Ledger Account Currency Pre-Spring 2018 Looks up to: codaAccountingCurrency__c
Lookup
GeneralLedgerAccountValue__c General Ledger Account Value Pre-Spring 2018 Number(18,2)
GeneralLedgerAccount__c General Ledger Account Pre-Spring 2018 Looks up to: codaGeneralLedgerAccount__c
Lookup false
HomeCredits__c Home Credits Fall 2018 Shows the credit value in home currency. This value is taken from the Home Value field, when it is a negative value.

Formula:
IF(HomeValue__c < 0, HomeValue__c * -1, 0)
Number(18,2) false
HomeCurrency__c Home Currency Pre-Spring 2018 Looks up to: codaAccountingCurrency__c
Lookup
HomeDebits__c Home Debits Fall 2018 Shows the debit value in home currency. This value is taken from the Home Value field, when it is a positive value.

Formula:
IF(HomeValue__c > 0, HomeValue__c, 0)
Number(18,2) false
HomeOutstandingValue__c Home Outstanding Value Pre-Spring 2018 See note 1

Number(18,2)
HomeTaxTotal__c Home Tax Total Pre-Spring 2018 Formula:
HomeTaxValue1__c + HomeTaxValue2__c + HomeTaxValue3__c
Number(18,2)
HomeTaxValue1__c Home Tax Value Pre-Spring 2018 Number(18,2)
HomeTaxValue2__c Home Tax Value 2 Pre-Spring 2018 Number(18,2)
HomeTaxValue3__c Home Tax Value 3 Pre-Spring 2018 Number(18,2)
HomeTaxableValue__c Home Taxable Value Pre-Spring 2018 Number(18,2)
HomeValue__c Home Value Pre-Spring 2018 Number(18,2) 0.00
IncomeTaxType__c Income Tax Type Pre-Spring 2018 Income Tax Type

Picklist:
(MISC) 1 - Rents
(MISC) 10 - Gross proceeds paid to an attorney
(MISC) 11 - Fish purchased for resale
(MISC) 12 - Section 409A deferrals
(MISC) 13 - FATCA filing requirement (Checkbox)
(MISC) 14 - Excess golden parachute payments
(MISC) 15 - Nonqualified deferred compensation
(MISC) 16 - State tax withheld
(MISC) 17 - State/Payer's state no.
(MISC) 18 - State income
(MISC) 2 - Royalties
(MISC) 3 - Other income
(MISC) 4 - Federal income tax withheld
(MISC) 5 - Fishing boat proceeds
(MISC) 6 - Medical and health care payments
(MISC) 7 - Payer made direct sales of 5000 or more (Checkbox)
(MISC) 8 - Substitute payments in lieu of dividends or interest
(MISC) 9 - Crop insurance proceeds
(NEC) 1 - Nonemployee compensation
(NEC) 2 - Payer made direct sales of 5000 or more (Checkbox)
(NEC) 4 - Federal income tax withheld
(NEC) 5 - State tax withheld
(NEC) 6 - State/Payer's state no.
(NEC) 7 - State income
Not Reportable
IntercompanyTransfer__c Intercompany Transfer Pre-Spring 2018 Looks up to: codaIntercompanyTransfer__c
Lookup
IsOutputVATTax__c Is Output VAT Tax Pre-Spring 2018 This checkbox identifies the tax line type i.e. Input VAT Tax or Output VAT Tax

Checkbox false
IsWithholdingTax__c Is Withholding Tax Spring 2021 Indicates that the Tax line item is a withholding tax line.

Checkbox false
LastCustomerStatementDate__c Last Customer Statement Date Spring 2019 Date false
LastReminderDate__c Last Reminder Date Fall 2018 DateTime false
LineDescription__c Line Description Pre-Spring 2018 TextArea
LineNumber__c Line Number Pre-Spring 2018 Number(18,0) true 0
LineReference__c Line Reference Pre-Spring 2018 TextArea
LineType__c Line Type Pre-Spring 2018 Picklist:
Account
Analysis
Tax
LocalGLACurrency__c Local GLA Currency Pre-Spring 2018 Looks up to: codaAccountingCurrency__c
Lookup false
LocalGLAValue__c Local GLA Value Pre-Spring 2018 Number(18,2) false
LocalGLA__c Local GLA Pre-Spring 2018 Looks up to: codaGeneralLedgerAccount__c
Lookup false
MatchingStatus__c Matching Status Pre-Spring 2018 Picklist:
Available
Matched
Not Matchable
Proposed
Proposed Void
OnHold__c On Hold Pre-Spring 2018 Checkbox false
OriginalAccount__c Original Account Pre-Spring 2018 Text(80) false
OwnerCompany__c Company Pre-Spring 2018 Looks up to: codaCompany__c
Lookup
OwningCurrencyRevaluation__c Owning Currency Revaluation Pre-Spring 2018 The ID of the Currency Revaluation (if any) which owns this transaction line.

Text(12) false
OwningDualCurrencyRevaluation__c Owning Dual Currency Revaluation Pre-Spring 2018 The ID of the Dual Currency Revaluation (if any) which owns this transaction line.

Text(12) false
OwningReportingCurrencyRevaluation__c Owning Reporting Currency Translation Fall 2021 The ID of the Reporting Currency Translation (if any) which owns this transaction line.

Text(12) false
ProcessStatus__c Process Status Pre-Spring 2018 Picklist:
Balance Sheet
Not Processed
Profit and Loss
Product__c Product Pre-Spring 2018 Looks up to: Product2

Lookup
ReportAdjustOperatingActivities__c Report Reclassify Profits Pre-Spring 2018 Formula:
if(isblank(text(CashFlowCategory__c)), GeneralLedgerAccount__r.AdjustOperatingActivities__c,AdjustOperatingActivities__c)
Checkbox
ReportCashFlowCategory__c Report Cash Flow Category Pre-Spring 2018 Formula:
if(isblank(text(CashFlowCategory__c)), text(GeneralLedgerAccount__r.CashFlowCategory__c), text(CashFlowCategory__c))
Text false
ReportCashFlowLineSummary__c Report Cash Flow Line Summary Pre-Spring 2018 Formula:
if(isblank(text(CashFlowCategory__c)), text(GeneralLedgerAccount__r.CashFlowLineSummary__c), text(CashFlowLineSummary__c))
Text false
ReportingCurrency__c Reporting Currency Fall 2021 Lookup to the currency used by a company.

Looks up to: codaAccountingCurrency__c
Lookup
ReportingOutstandingValue__c Reporting Outstanding Value Fall 2021 The outstanding value used to report up the company hierarchy.

Number(18,2)
ReportingRate__c Reporting Rate Fall 2021 The rate used to report up the company hierarchy.

Number(18,9)
ReportingValue__c Reporting Value Fall 2021 The value used to report up the company hierarchy.

Number(18,2)
ReverseChargeTaxCode__c Reverse Charge Tax Code Pre-Spring 2018 Looks up to: codaTaxCode__c
Lookup false
Severity__c Severity Fall 2018 Number(2,0) false 0
StatementDate__c Statement Date Pre-Spring 2018 Formula:
BankReconciliation__r.StatementDate__c
Date
TaxCode1__c Tax Code Pre-Spring 2018 Looks up to: codaTaxCode__c
Lookup
TaxCode2__c Tax Code 2 Pre-Spring 2018 Looks up to: codaTaxCode__c
Lookup
TaxCode3__c Tax Code 3 Pre-Spring 2018 Looks up to: codaTaxCode__c
Lookup
TaxGroup__c Tax Group Pre-Spring 2018 Text(255)
TransactionDate__c Transaction Date Pre-Spring 2018 Formula:
Transaction__r.TransactionDate__c
Date
TransactionReconciliationDate__c Transaction Reconciliation Date Pre-Spring 2018 Date false
TransactionReconciliationStatus__c Transaction Reconciliation Status Pre-Spring 2018 Picklist:
Proposed
Reconciled
false
TransactionReconciliation__c Transaction Reconciliation Pre-Spring 2018 Looks up to: TransactionReconciliation__c
Lookup false
Transaction__c Transaction Number Pre-Spring 2018 Looks up to: codaTransaction__c
MasterDetail
UnitOfWork__c Unit of Work Pre-Spring 2018 Number(18,0)
Version__c Version Pre-Spring 2018 Number(18,0) false 1


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