Accounting 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 VersionDescriptionTypeRequiredDefault Value
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
DeriveUnitPricefromProduct__c Derive Unit Price from Product Pre-Spring 2018 If selected, retrieves the unit price from the selected product.

Checkbox true
DestinationCompany__c Destination Company Pre-Spring 2018 Looks up to: codaCompany__c
Lookup false
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) false 1
DestinationUnitPrice__c Destination Unit Price Pre-Spring 2018 The unit price for this product for destination company.

Number(18,9) false
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) false
OutputTaxValue__c Output Tax Value Pre-Spring 2018 Number(18,2) false
OutputVATCode__c Output Tax Code Pre-Spring 2018 OutPut Tax Code for Reverse Charge Tax Code.

Looks up to: codaTaxCode__c
Lookup false
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) true 1
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
ShipFrom__c Ship From Winter 2025 The address of the company site from which the item is shipped. This field is used to calculate tax on the payable invoice line item when the Calculate Tax Using Line Level Address custom setting is enabled.

Looks up to: fferpcore__CompanySite__c

Lookup false
ShipTo__c Ship To Winter 2025 The address of the contact to which the item is shipped. This field is used to calculate tax on the payable invoice line item when the Calculate Tax Using Line Level Address custom setting is enabled.

Looks up to: Contact

Lookup false
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) false


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