codaInvoiceLineItem__c

Label: Sales Invoice Line Item

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

Field Name	Field Label	Created in Version	Description	Type	Required	Default Value
CalculateIncomeSchedule__c	Calculate Income Schedule	Pre-Spring 2018	Checkbox, checked by default, changed to unchecked if has been used	Checkbox		true
CalculateTaxValue1FromRate__c	Calculate Tax Value from Rate	Pre-Spring 2018		Checkbox		true
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
DeriveLineNumber__c	Derive Line Number	Pre-Spring 2018		Checkbox		true
DeriveTaxRate1FromCode__c	Derive Tax Rate from Code	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
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	false
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
IncomeScheduleGroup__c	Group	Pre-Spring 2018	Looks up to: codaGroupingReference__c	Lookup
IncomeSchedule__c	Income Schedule	Pre-Spring 2018	Looks up to: codaIncomeScheduleDefinition__c	Lookup
IntercompanyTransfer__c	Intercompany Transfer	Pre-Spring 2018	Looks up to: codaIntercompanyTransfer__c	Lookup	false
InternalCalculateIS__c	Internal Calculate IS	Pre-Spring 2018		Checkbox		true
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
Invoice__c	Invoice Number	Pre-Spring 2018	The auto-generated invoice number. Looks up to: codaInvoice__c	MasterDetail
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	The unit price multiplied by the quantity. Formula: Round((UnitPrice__c * Quantity__c), IF(ISBLANK(InvoiceCurrencyDecimalPlaces__c), 2, InvoiceCurrencyDecimalPlaces__c))	Number(18,2)
NumberofJournals__c	Number of Journals	Pre-Spring 2018		Number(12,0)
OriginalInvoice__c	Original Invoice	Spring 2022	Lookup to the original invoice that this line came from before consolidation. Looks up to: codaInvoice__c	Lookup
OwnerCompany__c	Company	Pre-Spring 2018	Looks up to: codaCompany__c	Lookup
PeriodInterval__c	Period Interval	Pre-Spring 2018		Number(12,0)
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	The product name. Looks up to: Product2	Lookup
Quantity__c	Quantity	Pre-Spring 2018	The quantity of product sold.	Number(18,6)	true	1
ScheduleNetTotal__c	Schedule Net Total	Pre-Spring 2018	Sum of the Amount on the Income Schedule Lines	Number(18,2)	false
Scheduled__c	Deprecated: Scheduled	Pre-Spring 2018	Income Schedule	Checkbox		false
SetTaxCode1ToDefault__c	Set Tax Code 1 to Default	Pre-Spring 2018		Checkbox		true
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
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
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
StartDate__c	Start Date	Pre-Spring 2018		Date
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	The unit price for this product.	Number(18,9)	false
UsePartPeriods__c	Use Part Periods	Pre-Spring 2018		Checkbox		true
UseProductInformation__c	Use Product Information	Pre-Spring 2018	Checkbox, checked by default, changed to unchecked if has been used	Checkbox		true