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 |
|
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 |
|
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) |
|
AsOfDate__c |
As of Date |
Pre-Spring 2018 |
|
Date |
|
AsOfDualValue__c |
As of Dual Value |
Pre-Spring 2018 |
|
Number(18,2) |
|
AsOfHomeValue__c |
As of Home Value |
Pre-Spring 2018 |
|
Number(18,2) |
|
AsOfName__c |
As of Name |
Pre-Spring 2018 |
|
Text(80) |
|
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 |
|
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 |
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 |
|
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 |
|
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) |
|
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) |
|
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: 1 - Rents 10 - Crop Insurance Proceeds 11 - Unused 11 12 - Unused 12 13 - Excess Golden Parachute Payments 14 - Gross Proceeds Paid to an Attorney 2 - Royalties 3 - Other Income 4 - Federal Income Tax Withheld 5 - Fishing Boat Proceeds 6 - Medical and Healthcare Payments 7 - Nonemployee Compensation 8 - Substitute Payments in Lieu of Dividends or Interest 9 - Payer Made Direct Sales of 5000 or More 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 |
|
LastReminderDate__c |
Last Reminder Date |
Fall 2018 |
|
DateTime |
|
LineDescription__c |
Line Description |
Pre-Spring 2018 |
|
TextArea |
|
LineNumber__c |
Line Number |
Pre-Spring 2018 |
|
Number(18,0) |
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 |
|
LocalGLAValue__c |
Local GLA Value |
Pre-Spring 2018 |
|
Number(18,2) |
|
LocalGLA__c |
Local GLA |
Pre-Spring 2018 |
Looks up to: codaGeneralLedgerAccount__c
|
Lookup |
|
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) |
|
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) |
|
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) |
|
OwningReportingCurrencyRevaluation__c |
Owning Reporting Currency Translation |
Fall 2021 |
The ID of the Reporting Currency Translation (if any) which owns this transaction line.
|
Text(12) |
|
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 |
|
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 |
|
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 |
|
Severity__c |
Severity |
Fall 2018 |
|
Number(2,0) |
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 |
|
TransactionReconciliationStatus__c |
Transaction Reconciliation Status |
Pre-Spring 2018 |
|
Picklist: Proposed Reconciled |
|
TransactionReconciliation__c |
Transaction Reconciliation |
Pre-Spring 2018 |
Looks up to: TransactionReconciliation__c
|
Lookup |
|
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) |
1 |