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 VersionDescriptionTypeDefault 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
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 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)
UnitPrice__c Unit Price Pre-Spring 2018 The unit price for this product.

Number(18,9)


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