Accounting Data Dictionary

c2g__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
c2g__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
c2g__DateFrom__c Date From Pre-Spring 2018 Date
c2g__DateTo__c Date To Pre-Spring 2018 Date
c2g__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
c2g__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
c2g__DeriveUnitPricefromProduct__c Derive Unit Price from Product Pre-Spring 2018 If selected, retrieves the unit price from the selected product.

Checkbox true
c2g__DestinationCompany__c Destination Company Pre-Spring 2018 Looks up to: c2g__codaCompany__c
Lookup false
c2g__DestinationNetValue__c Destination Net Value Pre-Spring 2018 Formula:
c2g__DestinationUnitPrice__c * c2g__DestinationQuantity__c
Number(18,2)
c2g__DestinationQuantity__c Destination Quantity Pre-Spring 2018 The quantity of product bought by destination company.

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

Number(18,9) false
c2g__Dimension1__c Dimension 1 Pre-Spring 2018 Looks up to: c2g__codaDimension1__c
Lookup
c2g__Dimension2__c Dimension 2 Pre-Spring 2018 Looks up to: c2g__codaDimension2__c
Lookup
c2g__Dimension3__c Dimension 3 Pre-Spring 2018 Looks up to: c2g__codaDimension3__c
Lookup
c2g__Dimension4__c Dimension 4 Pre-Spring 2018 Looks up to: c2g__codaDimension4__c
Lookup
c2g__EditTaxValue__c Edit Tax Value Pre-Spring 2018 Checkbox false
c2g__ExcludeFromWithholding__c Exclude from Withholding Spring 2021 Indicates that the Product line item is excluded from the withholding tax calculation.

Checkbox false
c2g__ExternalId__c External Id Pre-Spring 2018 Text(32)
c2g__InputVATCode__c Input Tax Code Pre-Spring 2018 Looks up to: c2g__codaTaxCode__c
Lookup
c2g__IntercompanyTransfer__c Intercompany Transfer Pre-Spring 2018 Looks up to: c2g__codaIntercompanyTransfer__c
Lookup
c2g__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
c2g__IsReverseChargeTax__c Reverse Charge Pre-Spring 2018 Checkbox false
c2g__LineDescription__c Line Description Pre-Spring 2018 TextArea
c2g__LineNumber__c Line Number Pre-Spring 2018 Number(18,0)
c2g__NetValue__c Net Value Pre-Spring 2018 Formula:
Round((c2g__UnitPrice__c * c2g__Quantity__c), IF(ISBLANK(c2g__InvoiceCurrencyDecimalPlaces__c), 2, c2g__InvoiceCurrencyDecimalPlaces__c))
Number(18,2)
c2g__OutputTaxRate__c Output Tax Rate Pre-Spring 2018 Number(7,3) false
c2g__OutputTaxValue__c Output Tax Value Pre-Spring 2018 Number(18,2) false
c2g__OutputVATCode__c Output Tax Code Pre-Spring 2018 OutPut Tax Code for Reverse Charge Tax Code.

Looks up to: c2g__codaTaxCode__c
Lookup false
c2g__OwnerCompany__c Company Pre-Spring 2018 Looks up to: c2g__codaCompany__c
Lookup
c2g__ProductCode__c Product Code Pre-Spring 2018 Formula:
c2g__Product__r.ProductCode
Text
c2g__Product__c Product Pre-Spring 2018 The product name.

Looks up to: Product2

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

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

Number(18,6) true 1
c2g__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
c2g__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
c2g__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
c2g__TaxCode2__c Input Tax Code 2 Pre-Spring 2018 Looks up to: c2g__codaTaxCode__c
Lookup
c2g__TaxCodeCombined__c Combined Tax Code Pre-Spring 2018 Looks up to: c2g__codaTaxCode__c
Lookup
c2g__TaxRate1__c Input Tax Rate Pre-Spring 2018 Number(7,3)
c2g__TaxRate2__c Tax Rate 2 Pre-Spring 2018 Number(7,3)
c2g__TaxRateTotal__c Tax Rate Total Pre-Spring 2018 Formula:
c2g__TaxRate1__c + c2g__TaxRate2__c - c2g__OutputTaxRate__c
Number(18,3)
c2g__TaxValue1__c Input Tax Value Pre-Spring 2018 Number(18,2)
c2g__TaxValue2__c Tax Value 2 Pre-Spring 2018 Number(18,2)
c2g__TaxValueTotal__c Tax Value Total Pre-Spring 2018 Formula:
c2g__TaxValue1__c + c2g__TaxValue2__c - c2g__OutputTaxValue__c
Number(18,2)
c2g__UnitOfWork__c Unit of Work Pre-Spring 2018 Number(18,0)
c2g__UnitPrice__c Unit Price Pre-Spring 2018 The unit price for this product.

Number(18,9) false


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