Accounting Data Dictionary

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
CalculateTaxValue2FromRate__c Calculate Tax Value 2 from Rate Pre-Spring 2018 Checkbox true
CalculateTaxValue3FromRate__c Calculate Tax Value 3 from Rate Pre-Spring 2018 Checkbox true
CalculateTaxValueFromRate__c Calculate Tax Value from Rate Pre-Spring 2018 Checkbox true
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
CreditNote__c Credit Note Number Pre-Spring 2018 Looks up to: codaCreditNote__c
MasterDetail
DeriveLineNumber__c Derive Line Number Pre-Spring 2018 Checkbox true
DeriveTaxRate2FromCode__c Derive Tax Rate 2 from Code Pre-Spring 2018 Checkbox true
DeriveTaxRate3FromCode__c Derive Tax Rate 3 from Code Pre-Spring 2018 Checkbox true
DeriveTaxRateFromCode__c Derive Tax Rate from Code Pre-Spring 2018 Checkbox true
DeriveUnitPriceFromProduct__c Derive Unit Price from Product Pre-Spring 2018 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) 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
ExcludeFromWithholding__c Exclude from Withholding Fall 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)
GeneralLedgerAccount__c Override Product GLA Pre-Spring 2018 Looks up to: codaGeneralLedgerAccount__c
Lookup false
IntercompanyTransfer__c Intercompany Transfer Pre-Spring 2018 Looks up to: codaIntercompanyTransfer__c
Lookup
LineDescription__c Line Description Pre-Spring 2018 TextArea
LineNumber__c Line Number Pre-Spring 2018 Number(18,0)
LocalGLA__c Override Product Local GLA Pre-Spring 2018 Looks up to: codaGeneralLedgerAccount__c
Lookup false
NetValue__c Net Value Pre-Spring 2018 Formula:
Round((UnitPrice__c * Quantity__c), IF(ISBLANK(CreditNoteCurrencyDecimalPlaces__c), 2, CreditNoteCurrencyDecimalPlaces__c))
Number(18,2)
OriginalInvoice__c Original Invoice Summer 2022 Lookup to the original invoice of the sales invoice line item.

Looks up to: codaInvoice__c
Lookup
OwnerCompany__c Company Pre-Spring 2018 Looks up to: codaCompany__c
Lookup
ProductCode__c Product Code Pre-Spring 2018 Product Code.

Formula:
Product__r.ProductCode
Text
ProductReference__c Product Pre-Spring 2018 Formula:
Product__r.Name
Text
Product__c Product Name Pre-Spring 2018 Looks up to: Product2

Lookup
Quantity__c Quantity Pre-Spring 2018 Number(18,6) true 1
SetTaxCode2ToDefault__c Set Tax Code 2 to Default Pre-Spring 2018 Checkbox true
SetTaxCode3ToDefault__c Set Tax Code 3 to Default Pre-Spring 2018 Checkbox true
SetTaxCodeToDefault__c Set Tax Code to Default Pre-Spring 2018 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 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
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
TaxCode1__c Tax Code Pre-Spring 2018 Looks up to: codaTaxCode__c
Lookup
TaxCode2__c Tax Code 2 Pre-Spring 2018 Looks up to: codaTaxCode__c
Lookup
TaxCode3__c Tax Code 3 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 Tax Rate Pre-Spring 2018 Number(7,3)
TaxRate2__c Tax Rate 2 Pre-Spring 2018 Number(7,3)
TaxRate3__c Tax Rate 3 Pre-Spring 2018 Number(7,3)
TaxRateTotal__c Tax Rate Total Pre-Spring 2018 Formula:
TaxRate1__c + TaxRate2__c + TaxRate3__c
Number(18,3)
TaxValue1__c Tax Value Pre-Spring 2018 Number(18,2)
TaxValue2__c Tax Value 2 Pre-Spring 2018 Number(18,2)
TaxValue3__c Tax Value 3 Pre-Spring 2018 Number(18,2)
TaxValueTotal__c Tax Value Total Pre-Spring 2018 Formula:
TaxValue1__c + TaxValue2__c + TaxValue3__c
Number(18,2)
UnitOfWork__c Unit of Work Pre-Spring 2018 Number(18,0)
UnitPrice__c Unit Price Pre-Spring 2018 Number(18,9) false


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