| objid | contr_itm | objid | Contract line item objid | 3 (UNIQUE) |
| line_no | contr_itm | line_no | Contract line item line no | |
| parent_line_no | contr_itm | p_line_no | Line number of the parent contract item | |
| create_date | contr_itm | create_date | The create date for the line item | |
| start_date | contr_itm | start_date | The starting date for the line item | |
| end_date | contr_itm | end_date | The ending date for the line item | |
| 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 | |
| quote_sn | contr_itm | quote_sn | The serial number of the product to be installed under the contract line item | |
| prod_sales_ord | contr_itm | prod_sales_ord | The sales order of the product to be installed under the contract line item | |
| taxable | contr_itm | taxable | Indicates whether the item is taxable; i.e., 0=no, 1=yes | |
| chg_start_dt | contr_itm | chg_start_dt | The date from which charges start to accrue | |
| chg_end_dt | contr_itm | chg_end_dt | The last date through which charges accrue | |
| credit_ind | contr_itm | credit_ind | If line is canceled or closed, whether or not credit is to be issued: 0=no, 1=yes | |
| cancel_dt | contr_itm | cancel_dt | If a line is canceled or closed, the date when the cancel or close becomes effective | |
| last_mod_dt | contr_itm | last_mod_dt | The date/time indicating the last time the row was updated to reflect a mid-term change. If any of the billing related columns in this record change then this column is updated | |
| last_xfer_dt | contr_itm | last_xfer_dt | The date/time that the set of billing records for this line item were transferred into Trans_record | |
| oride_price | contr_itm | oride_price | The value of a manually overridden price | |
| renew_ind | contr_itm | renew_ind | Indicates whether a line item is to be renewed or not: 0=no, 1=yes, default=0 | |
| auto_inst_ind | contr_itm | auto_inst_ind | Indicates whether indicates whether a generic part is to be auto installed: 0=no, 1=yes, default=0 | |
| qty_based_ind | contr_itm | qty_based_ind | Indicates whether a service line item is qty or time based: 0=time, 1=qty, default=0 | |
| comments | contr_itm | comments | Comments about the line item | |
| 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 | |
| cover_site_objid | cover_by_site(site) | objid | Covered site internal record number | |
| cover_site_id | cover_by_site(site) | site_id | Covered site unique ID number | |
| warranty_dt | site_part | warranty_date | Contract line item warranty date | |
| serial_no | site_part | serial_no | Contract line item serial no | |
| sched_objid | contr_schedule | objid | Contr_schedule internal record number | |
| child_cnt | contr_itm | child_cnt | For a parent line, the number of child contr_itm lines under it | |
| part_num_objid | part_num | objid | Part_num internal record number | |
| model_num | part_num | model_num | Contract line item part number | |
| sn_track | part_num | sn_track | Contract line item part number | |
| is_sppt_prog | part_num | is_sppt_prog | Indicates if line is support program | |
| prog_type | part_num | prog_type | Indicates if line is support program | |
| p_standalone | part_num | p_standalone | Indicates if line is support program | |
| p_as_parent | part_num | p_as_parent | Indicates if line is support program | |
| p_as_child | part_num | p_as_child | Indicates if line is support program | |
| site_part_qty | site_part | quantity | Installed part quantity; equal to 1 for serialized parts | |
| prorate_type | contr_itm | prorate_type | The type of proration for this lineitem | |
| site_part_objid | site_part | objid | Site_part internal record number | |
| unit_measure | part_num | unit_measure | Unit of measure for part number; e.g., roll, set, etc | |
| price_inst_objid | price_inst | objid | Price_inst internal record number | |
| cover_site_name | cover_by_site(site) | name | Covered site name | |
| po_objid | purchase_ord | objid | Purchase_ord internal record number | |
| line_no_txt | contr_itm | line_no_txt | Concatination of parent and child line numbers delimited by a period | |
| d_adj_fxd | contr_itm | d_adj_fxd | A single, fixed price adjustment placed directly against the line | |
| d_adj_pct | contr_itm | d_adj_pct | A single, percentage adjustment placed directly against the line | |
| d_adj_type | contr_itm | d_adj_type | Type of single adjustment: either discount or surcharge | |
| d_adj_extn | contr_itm | d_adj_extn | The extended amount of a single adjustment; whether a fixed value or the result of d_adj_pct * unit price | |
| 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 parent 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 | |
| instance_id | contr_itm | instance_id | Installed part unique instnace id | |
| action | contr_itm | action | MACD action | |