Line Definition Fields

You can configure fields for line definitions from the Fields tab. You can add, delete, and move fields, and also set the properties of the fields.

A line definition can have a maximum of 150 field definitions, with a maximum of 50 each of string, numeric, and date type.

Interdependent data definitions

The following fields are interdependent and must be added together.
  • Product Name and Product Number
  • Internal Party Name and Internal Party Number
  • External Party Name and External Party Number
  • Clause Template Name and Clause Template Text
  • External Company/Individual Name and External Company/Individual Number

Compound data definitions

Multiple fields are required to calculate compound data definitions. If the required fields are not present, you cannot save the line definition.

The following compound data definitions are dependent on other fields.

Dependent data definitions

Data definitions can be simple or complex. A data definition field can be dependent on other fields to function properly. Some data definition fields cannot be added in the same line.

The following table lists the data definition fields that must be added with other fields. It also lists the fields that cannot be added in the same line.
Table 1. Dependent data definitions
Data Definition Must also add Cannot add along with
base_contract_line percentage_factor
product_name_entered product_name
product_number_entered product_number
sales_price_list

Can only be added to a Sales Agreement or Other type of contract.

product_name, product_number, total_list_price supplier_price_list, sales_price_list_entered, supplier_price_list_entered
sales_price_list_entered

Can only be added to a Sales Agreement or Other type of contract.

sales_price_list, supplier_price_list, supplier_price_list_entered
supplier_price_list

Can only be added to a Purchase Agreement or Other type of contract.

total_list_price sales_price_list, sales_price_list_entered, supplier_price_list_entered
price_list product_name, product_number
supplier_price_list_entered

Can only be added to a Purchase Agreement or Other type of contract.

sales_price_list, sales_price_list_entered, supplier_price_list
sales_unit_price

Can only be added to a Sales Agreement or Other type of contract.

supplier_unit_price, sourcing_item_unit_cost
supplier_unit_price

Can only be added to a Purchase Agreement or Other type of contract.

sales_unit_price, sourcing_item_unit_cost
sourcing_item_unit_cost

Can only be added to a Purchase Agreement or Other type of contract.

sales_unit_price, supplier_unit_price
total_list_price quantity, unit_price
discount_percent discount_pct_round
total_net_price total_list_price, (discount_amount OR discount_percent) supplier_item_total_price
sourcing_item_total_cost total_list_price, (discount_amount OR discount_percent) total_net_price
promised_delivery_date sourcing_item_delivery_date
term_quantity All term range fields.
term_unit All term range fields.
org_address external_company_individual_name, external_company_individual_number
internal_party_address internal_party_name, internal_party_number  
external_party_address external_party_name, external_party_number  
external_company_or_individual_address external_company_or_individual_name, external_company_or_individual_number  
internal_party_address_role internal_party_address  
external_party_address_role external_party_address  
external_company_or_individual_address_role external_company_or_individual_address