FFA Data Dictionary

codaPurchaseInvoiceExpenseLineItem__c

Label: Payable Invoice Expense Line Item

The expenses line items on the payable invoice

Field NameField LabelCreated in VersionDescriptionTypeDefault Value
CalculateTaxValueFromRate__c Calculate Tax Value from Rate Pre-Spring 2018 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 Checkbox true
DeriveTaxRateFromCode__c Derive Tax Rate from Code Pre-Spring 2018 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 Set GLA to Default Pre-Spring 2018 Checkbox true
SetTaxCodeToDefault__c Set Tax Code to Default Pre-Spring 2018 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–2022 FinancialForce.com, inc. All rights reserved. Various trademarks held by their respective owners.