Accounting Data Dictionary

codaPurchaseInvoiceExpenseLineItem__c

Label: Payable Invoice Expense Line Item

The expenses line items on the payable invoice

Field NameField LabelCreated in VersionDescriptionTypeDefault Value
AllocationRule__c Allocation Rule Spring 2024 Looks up to: AllocationRule__c
 Lookup
CalculateTaxValueFromRate__c Calculate Tax Value from Rate Pre-Spring 2018 If selected, calculates the relevant tax value from the associated tax rate. In Combined Tax mode, this checkbox applies to both Tax Value and Tax Value 2 fields. You must clear the values in both fields before saving the page to have the values calculated from their associated tax rate.

 Checkbox true
DateFrom__c Date From Pre-Spring 2018 Date
DateTo__c Date To Pre-Spring 2018 Date
DeriveLineNumber__c Derive Line Number Pre-Spring 2018 If selected, derives the line number from the highest existing line number and increments it by one.

 Checkbox true
DeriveTaxRateFromCode__c Derive Tax Rate from Code Pre-Spring 2018 If selected, derives the relevant tax rate from the associated tax code. In Combined Tax mode, this checkbox applies to both Tax Rate and Tax Rate 2 fields. You must clear the values in both fields before saving the page to have the rates calculated from their associated tax code.

 Checkbox true
DestinationCompany__c Destination Company Pre-Spring 2018 Looks up to: codaCompany__c
 Lookup
DestinationNetValue__c Destination Net Value Pre-Spring 2018 Number(18,2)
Dimension1__c Dimension 1 Pre-Spring 2018 Looks up to: codaDimension1__c
 Lookup
Dimension2__c Dimension 2 Pre-Spring 2018 Looks up to: codaDimension2__c
 Lookup
Dimension3__c Dimension 3 Pre-Spring 2018 Looks up to: codaDimension3__c
 Lookup
Dimension4__c Dimension 4 Pre-Spring 2018 Looks up to: codaDimension4__c
 Lookup
EditTaxValue__c Edit Tax Value Pre-Spring 2018 Checkbox false
ExcludeFromWithholding__c Exclude from Withholding Spring 2021 Indicates that the Expense line item is excluded from the withholding tax calculation.

 Checkbox false
ExternalId__c External Id Pre-Spring 2018 Text(32)
GLACode__c GLA Code Pre-Spring 2018 Formula:
GeneralLedgerAccount__r.ReportingCode__c
 Text
GeneralLedgerAccount__c General Ledger Account Pre-Spring 2018 Looks up to: codaGeneralLedgerAccount__c
 Lookup
InputVATCode__c Input Tax Code Pre-Spring 2018 Looks up to: codaTaxCode__c
 Lookup
IntercompanyTransfer__c Intercompany Transfer Pre-Spring 2018 Looks up to: codaIntercompanyTransfer__c
 Lookup
IsReverseChargeTax__c Reverse Charge Pre-Spring 2018 Checkbox false
LineDescription__c Line Description Pre-Spring 2018 TextArea
LineNumber__c Line Number Pre-Spring 2018 Number(18,0)
LocalGLACode__c Local GLA Code Pre-Spring 2018 Formula:
LocalGLA__r.ReportingCode__c
 Text
LocalGLA__c Local GLA Pre-Spring 2018 Looks up to: codaGeneralLedgerAccount__c
 Lookup
NetValue__c Net Value Pre-Spring 2018 Number(18,2)
OutputTaxRate__c Output Tax Rate Pre-Spring 2018 Number(7,3)
OutputTaxValue__c Output Tax Value Pre-Spring 2018 Number(18,2)
OutputVATCode__c Output Tax Code Pre-Spring 2018 OutPut Tax Code for Reverse Charge Tax Code.

Looks up to: codaTaxCode__c
 Lookup
OwnerCompany__c Company Pre-Spring 2018 Looks up to: codaCompany__c
 Lookup
PrepaidExpenses__c Prepaid Expenses Fall 2019 Checkbox false
PurchaseInvoice__c Payable Invoice Number Pre-Spring 2018 Looks up to: codaPurchaseInvoice__c
 MasterDetail
SetGLAToDefault__c Derive GLA from Account Pre-Spring 2018 If selected, sets the general ledger account to the account's default general ledger account.

 Checkbox true
SetTaxCodeToDefault__c Set Tax Code to Default Pre-Spring 2018 If selected, sets the tax code to the default defined by the tax mode. In Combined Tax mode, this checkbox applies to the Combined Tax Code, Input Tax Code, and Input Tax Code 2 fields.

 Checkbox true
TaxCode2__c Input Tax Code 2 Pre-Spring 2018 Looks up to: codaTaxCode__c
 Lookup
TaxCodeCombined__c Combined Tax Code Pre-Spring 2018 Looks up to: codaTaxCode__c
 Lookup
TaxRate1__c Input Tax Rate Pre-Spring 2018 Number(7,3)
TaxRate2__c Tax Rate 2 Pre-Spring 2018 Number(7,3)
TaxRateTotal__c Tax Rate Total Pre-Spring 2018 Formula:
TaxRate1__c + TaxRate2__c - OutputTaxRate__c
 Number(18,3)
TaxValue1__c Input Tax Value Pre-Spring 2018 Number(18,2)
TaxValue2__c Tax Value 2 Pre-Spring 2018 Number(18,2)
TaxValueTotal__c Tax Value Total Pre-Spring 2018 Formula:
TaxValue1__c + TaxValue2__c - OutputTaxValue__c
 Number(18,2)
UnitOfWork__c Unit of Work Pre-Spring 2018 Number(18,0)


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