objid | contr_itm | objid | contract line item internal record number | 3 (UNIQUE) |
line_no | contr_itm | line_no | Contract line item line no | |
unit_type | contr_itm | unit_type | The type of unit the contract is delivered by; e.g., day, case, etc | |
units_purch | contr_itm | units_purch | The number of units purchased for the line item | |
units_used | contr_itm | units_used | The number of line item units which remaining | |
units_avail | contr_itm | units_avail | The number of line item units which still unused | |
price | contr_itm | prc | The price which was copied from the price schedule (price_inst) | |
net_price | contr_itm | net_prc | The price after all adjustments (price factors) have been applied | |
quote_item | contr_itm | quote_item | Defines whether the line item is to be priced on the quote worksheet; i.e., 0=no, 1=yes, default=1 | |
pro_price | contr_itm | pro_prc | The prorated price of the item | |
extension | contr_itm | extn | The extended price of the item before price factors were applied. It is determined by quantity * price or quantity * rate as appropriate | |
quantity | contr_itm | quantity | Contracted/Quoted quantity of the part | |
product | part_num | part_number | Contract line item part number | |
mod_level_objid | mod_level | objid | Mod_level internal record number | |
rev | mod_level | mod_level | Contract line item mod level | |
description | part_num | description | Contract line item description | |
sched_objid | contr_schedule | objid | Contr_schedule internal record number | |
child_cnt | contr_itm | child_cnt | For a parent line, the number of child parent lines under it | |
part_num_objid | part_num | objid | Part_num internal record number | |
line_no_txt | contr_itm | line_no_txt | Concatination of parent and child line numbers delimited by a period | |
tot_adj | contr_itm | tot_adj | The sum of all adjustments against the line | |
rollup_prc | contr_itm | rollup_prc | The sum of the net_prc field on all child items and the current item. If no child items, it is the same as the net_prc value of the current item | |
handling_cost | contr_itm | handling_cost | The sum of all handling costs for the item. Used where contract.struct_type=2 | |
tot_ship_amt | contr_itm | tot_ship_amt | The sum of all shipping charges for the item | |
status | contr_itm | status | Current status of an order line item. This is a user-defined popup with default name Order Line Status | |
total_tax_amt | contr_itm | total_tax_amt | The sum of all taxes applied to the item. Used where contract.struct_type=2 | |
valid_prc_ind | contr_itm | valid_prc_ind | Indicates whether a valid price for the item was found; i.e., 0=no valid price found; 1=valid price found, default=1. Used in re-pricing | |
gross_prc | contr_itm | gross_prc | For childless items this is the item's non-extended base price, for child items this is the sum of the extended base prices of all its child items plus its own non-extended base price | |
line_key | contr_itm | line_key | The Configurator line item identifier corresponding to the contract schedule line item | |
domain | part_num | domain | Name of the domain for the part num. See object prt_domain | |