FFA Data Dictionary

codaPurchaseCreditNoteLineItem__c

Label: Payable Credit Note Line Item

The line items on the payable credit note, such as product, unit price, quantity and line total.

Field NameField LabelCreated in VersionDescriptionTypeDefault Value
CalculateTaxValuefromRate__c Calculate Tax Value from Rate Pre-Spring 2018 Checkbox true
CreditNoteCurrencyDecimalPlaces__c Currency Decimal Places Fall 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
DateFrom__c Date From Pre-Spring 2018 Date
DateTo__c Date To Pre-Spring 2018 Date
DeriveLineNumber__c Derive Line Number 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
EditTaxValue__c Edit Tax Value Pre-Spring 2018 Checkbox false
ExcludeFromWithholding__c Exclude from Withholding Spring 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)
InputVATCode__c Input Tax Code Pre-Spring 2018 Looks up to: codaTaxCode__c
Lookup
IntercompanyTransfer__c Intercompany Transfer Pre-Spring 2018 Looks up to: codaIntercompanyTransfer__c
Lookup
IsReverseChargeTax__c Reverse Charge Pre-Spring 2018 Checkbox false
LineDescription__c Line Description Pre-Spring 2018 TextArea
LineNumber__c Line Number Pre-Spring 2018 Number(18,0)
NetValue__c Net Value Pre-Spring 2018 Formula:
Round((UnitPrice__c * Quantity__c), IF(ISBLANK(CreditNoteCurrencyDecimalPlaces__c), 2, CreditNoteCurrencyDecimalPlaces__c))
Number(18,2)
OutputTaxRate__c Output Tax Rate Pre-Spring 2018 Number(7,3)
OutputTaxValue__c Output Tax Value Pre-Spring 2018 Number(18,2)
OutputVATCode__c Output Tax Code Pre-Spring 2018 OutPut Tax Code for Reverse Charge Tax Code.

Looks up to: codaTaxCode__c
Lookup
OwnerCompany__c Company Pre-Spring 2018 Looks up to: codaCompany__c
Lookup
Product__c Product Name Pre-Spring 2018 Looks up to: Product2

Lookup
PurchaseCreditNote__c Payable Credit Note Number Pre-Spring 2018 The auto-generated payable credit note number.

Looks up to: codaPurchaseCreditNote__c
MasterDetail
Quantity__c Quantity Pre-Spring 2018 Number(18,6) 1
SetTaxCodetoDefault__c Set Tax Code to Default Pre-Spring 2018 Checkbox true
TaxCode2__c Input Tax Code 2 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 Input Tax Rate Pre-Spring 2018 Number(7,3)
TaxRate2__c Tax Rate 2 Pre-Spring 2018 Number(7,3)
TaxRateTotal__c Tax Rate Total Pre-Spring 2018 Formula:
TaxRate1__c + TaxRate2__c - OutputTaxRate__c
Number(18,3)
TaxValue1__c Input Tax Value Pre-Spring 2018 Number(18,2)
TaxValue2__c Tax Value 2 Pre-Spring 2018 Number(18,2)
TaxValueTotal__c Tax Value Total Pre-Spring 2018 Formula:
TaxValue1__c + TaxValue2__c - OutputTaxValue__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–2022 FinancialForce.com, inc. All rights reserved. Various trademarks held by their respective owners.