FFA Data Dictionary

codaPurchaseInvoiceLineItem__c

Label: Payable Invoice Line Item

The line items on the payable invoice, such as product, unit price, quantity and line total.

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
DeriveUnitPricefromProduct__c Derive Unit Price from Product 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 Formula:
DestinationUnitPrice__c * DestinationQuantity__c
Number(18,2)
DestinationQuantity__c Destination Quantity Pre-Spring 2018 The quantity of product bought by destination company.

Number(18,6) 1
DestinationUnitPrice__c Destination Unit Price Pre-Spring 2018 The unit price for this product for destination company.

Number(18,9)
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 Product line item is excluded from the withholding tax calculation.

Checkbox false
ExternalId__c External Id Pre-Spring 2018 Text(32)
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
InvoiceCurrencyDecimalPlaces__c Currency Decimal Places Fall 2020 The number of decimal places used by the invoice currency. Permitted values are 0 and 2. The default is 2.

Number(1,0) 2
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)
NetValue__c Net Value Pre-Spring 2018 Formula:
Round((UnitPrice__c * Quantity__c), IF(ISBLANK(InvoiceCurrencyDecimalPlaces__c), 2, InvoiceCurrencyDecimalPlaces__c))
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
ProductCode__c Product Code Pre-Spring 2018 Formula:
Product__r.ProductCode
Text
Product__c Product Pre-Spring 2018 The product name.

Looks up to: Product2

Lookup
PurchaseInvoice__c Payable Invoice Number Pre-Spring 2018 The auto-generated payable invoice number.

Looks up to: codaPurchaseInvoice__c
MasterDetail
Quantity__c Quantity Pre-Spring 2018 The quantity of product bought.

Number(18,6) 1
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)
UnitPrice__c Unit Price Pre-Spring 2018 The unit price for this product.

Number(18,9)


© Copyright 2009–2022 FinancialForce.com, inc. All rights reserved. Various trademarks held by their respective owners.