Accounting Data Dictionary

c2g__codaInvoiceLineItem__c

Label: Sales Invoice Line Item

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

Field NameField LabelCreated in VersionDescriptionTypeRequiredDefault Value
c2g__BillingDocumentLineItem__c Billing Document Line Item Spring 2025 Looks up to: fferpcore__BillingDocumentLineItem__c

Lookup false
c2g__CalculateIncomeSchedule__c Calculate Income Schedule Pre-Spring 2018 Checkbox, checked by default, changed to unchecked if has been used

Checkbox true
c2g__CalculateTaxValue1FromRate__c Calculate Tax Value from Rate Pre-Spring 2018 Checkbox true
c2g__CalculateTaxValue2FromRate__c Calculate Tax Value 2 from Rate Pre-Spring 2018 Checkbox true
c2g__CalculateTaxValue3FromRate__c Calculate Tax Value 3 from Rate Pre-Spring 2018 Checkbox true
c2g__DeriveLineNumber__c Derive Line Number Pre-Spring 2018 Checkbox true
c2g__DeriveTaxRate1FromCode__c Derive Tax Rate from Code Pre-Spring 2018 Checkbox true
c2g__DeriveTaxRate2FromCode__c Derive Tax Rate 2 from Code Pre-Spring 2018 Checkbox true
c2g__DeriveTaxRate3FromCode__c Derive Tax Rate 3 from Code Pre-Spring 2018 Checkbox true
c2g__DeriveUnitPriceFromProduct__c Derive Unit Price from Product Pre-Spring 2018 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__ExcludeFromWithholding__c Exclude from Withholding Fall 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__GeneralLedgerAccount__c Override Product GLA Pre-Spring 2018 Looks up to: c2g__codaGeneralLedgerAccount__c
Lookup false
c2g__IncomeScheduleGroup__c Group Pre-Spring 2018 Looks up to: c2g__codaGroupingReference__c
Lookup
c2g__IncomeSchedule__c Income Schedule Pre-Spring 2018 Looks up to: c2g__codaIncomeScheduleDefinition__c
Lookup
c2g__IntercompanyTransfer__c Intercompany Transfer Pre-Spring 2018 Looks up to: c2g__codaIntercompanyTransfer__c
Lookup false
c2g__InternalCalculateIS__c Internal Calculate IS Pre-Spring 2018 Checkbox true
c2g__InvoiceCurrencyDecimalPlaces__c Currency Decimal Places Summer 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__Invoice__c Invoice Number Pre-Spring 2018 The auto-generated invoice number.

Looks up to: c2g__codaInvoice__c
MasterDetail
c2g__LineDescription__c Line Description Pre-Spring 2018 TextArea
c2g__LineNumber__c Line Number Pre-Spring 2018 Number(18,0)
c2g__LocalGLA__c Override Product Local GLA Pre-Spring 2018 Looks up to: c2g__codaGeneralLedgerAccount__c
Lookup false
c2g__NetValue__c Net Value Pre-Spring 2018 The unit price multiplied by the quantity.

Formula:
Round((c2g__UnitPrice__c * c2g__Quantity__c), IF(ISBLANK(c2g__InvoiceCurrencyDecimalPlaces__c), 2, c2g__InvoiceCurrencyDecimalPlaces__c))
Number(18,2)
c2g__NumberofJournals__c Number of Journals Pre-Spring 2018 Number(12,0)
c2g__OriginalInvoice__c Original Invoice Spring 2022 Lookup to the original invoice that this line came from before consolidation.

Looks up to: c2g__codaInvoice__c
Lookup
c2g__OwnerCompany__c Company Pre-Spring 2018 Looks up to: c2g__codaCompany__c
Lookup
c2g__PeriodInterval__c Period Interval Pre-Spring 2018 Number(12,0)
c2g__ProductCode__c Product Code Pre-Spring 2018 Product Code.

Formula:
c2g__Product__r.ProductCode
Text
c2g__ProductReference__c Product Pre-Spring 2018 Formula:
c2g__Product__r.Name
Text
c2g__Product__c Product Name Pre-Spring 2018 The product name.

Looks up to: Product2

Lookup
c2g__Quantity__c Quantity Pre-Spring 2018 The quantity of product sold.

Number(18,6) true 1
c2g__ScheduleNetTotal__c Schedule Net Total Pre-Spring 2018 Sum of the Amount on the Income Schedule Lines

Number(18,2) false
c2g__Scheduled__c Deprecated: Scheduled Pre-Spring 2018 Income Schedule

Checkbox false
c2g__SetTaxCode1ToDefault__c Set Tax Code 1 to Default Pre-Spring 2018 Checkbox true
c2g__SetTaxCode2ToDefault__c Set Tax Code 2 to Default Pre-Spring 2018 Checkbox true
c2g__SetTaxCode3ToDefault__c Set Tax Code 3 to Default Pre-Spring 2018 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 sales 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 sales invoice line item when the Calculate Tax Using Line Level Address custom setting is enabled.

Looks up to: Contact

Lookup false
c2g__StartDate__c Start Date Pre-Spring 2018 Date
c2g__TaxCode1__c Tax Code Pre-Spring 2018 Looks up to: c2g__codaTaxCode__c
Lookup
c2g__TaxCode2__c Tax Code 2 Pre-Spring 2018 Looks up to: c2g__codaTaxCode__c
Lookup
c2g__TaxCode3__c Tax Code 3 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 Tax Rate Pre-Spring 2018 Number(7,3)
c2g__TaxRate2__c Tax Rate 2 Pre-Spring 2018 Number(7,3)
c2g__TaxRate3__c Tax Rate 3 Pre-Spring 2018 Number(7,3)
c2g__TaxRateTotal__c Tax Rate Total Pre-Spring 2018 Formula:
c2g__TaxRate1__c + c2g__TaxRate2__c + c2g__TaxRate3__c
Number(18,3)
c2g__TaxValue1__c Tax Value Pre-Spring 2018 Number(18,2)
c2g__TaxValue2__c Tax Value 2 Pre-Spring 2018 Number(18,2)
c2g__TaxValue3__c Tax Value 3 Pre-Spring 2018 Number(18,2)
c2g__TaxValueTotal__c Tax Value Total Pre-Spring 2018 Formula:
c2g__TaxValue1__c + c2g__TaxValue2__c + c2g__TaxValue3__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
c2g__UsePartPeriods__c Use Part Periods Pre-Spring 2018 Checkbox true
c2g__UseProductInformation__c Use Product Information Pre-Spring 2018 Checkbox, checked by default, changed to unchecked if has been used

Checkbox true


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