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 VersionDescriptionTypeDefault 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) 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
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
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
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) 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
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)


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