Accounting Data Dictionary

c2g__codaCreditNoteLineItem__c

Label: Sales Credit Note Line Item

The line items on the credit note, 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__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__CalculateTaxValueFromRate__c Calculate Tax Value from Rate Pre-Spring 2018 Checkbox true
c2g__CreditNoteCurrencyDecimalPlaces__c Currency Decimal Places Summer 2020 The number of decimal places used by the credit note currency. Permitted values are 0 and 2. The default is 2.

Number(1,0) 2
c2g__CreditNote__c Credit Note Number Pre-Spring 2018 Looks up to: c2g__codaCreditNote__c
MasterDetail
c2g__DeriveLineNumber__c Derive Line Number 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__DeriveTaxRateFromCode__c Derive Tax Rate 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
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__IntercompanyTransfer__c Intercompany Transfer Pre-Spring 2018 Looks up to: c2g__codaIntercompanyTransfer__c
Lookup
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 Formula:
Round((c2g__UnitPrice__c * c2g__Quantity__c), IF(ISBLANK(c2g__CreditNoteCurrencyDecimalPlaces__c), 2, c2g__CreditNoteCurrencyDecimalPlaces__c))
Number(18,2)
c2g__OriginalInvoice__c Original Invoice Summer 2022 Lookup to the original invoice of the sales invoice line item.

Looks up to: c2g__codaInvoice__c
Lookup
c2g__OwnerCompany__c Company Pre-Spring 2018 Looks up to: c2g__codaCompany__c
Lookup
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 Looks up to: Product2

Lookup
c2g__Quantity__c Quantity Pre-Spring 2018 Number(18,6) true 1
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__SetTaxCodeToDefault__c Set Tax Code 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 credit note 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 credit note line item when the Calculate Tax Using Line Level Address custom setting is enabled.

Looks up to: Contact

Lookup false
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 Number(18,9) false


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