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.
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.
The following fields must be added if you add Term Quantity or Term Unit.
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.
| 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 |