| action | CHAR | varchar | | 20 | | ALLOW_NULL | MACD action | Search (2) |
| auto_inst_ind | LONG | tinyint | | | 0 | DIRECT | Indicates whether indicates whether a generic part is to be auto installed: 0=no, 1=yes, default=0 | Search (3) |
| bill_attn | CHAR | varchar | | 30 | | | First name of the person billing will be directed to. If used will override corresponding field on contr_schedule | |
| bill_attn2 | CHAR | varchar | | 40 | | | Last name of the person billing will be directed to. If used will override corresponding field on contr_schedule | |
| cancel_dt | CLK_TIME | datetime | | | | CHANGE_FIELD | If a line is canceled or closed, the date when the cancel or close becomes effective | Search (3) |
| chg_end_dt | CLK_TIME | datetime | | | | CHANGE_FIELD | The last date through which charges accrue | Search (2) |
| chg_start_dt | CLK_TIME | datetime | | | | CHANGE_FIELD | The date from which charges start to accrue | Search (2) |
| child_cnt | LONG | smallint | | | 0 | DIRECT | For a parent line, the number of child contr_itm lines under it | Search (3) |
| comments | CHAR | varchar | | 255 | | | Comments about the line item | Search (2) |
| create_date | CLK_TIME | datetime | | | | | The create date for the line item | Search (2) |
| credit_ind | LONG | tinyint | | | 0 | DIRECT | If line is canceled or closed, whether or not credit is to be issued: 0=no, 1=yes | Search (2) |
| d_adj_extn | DECIMAL | decimal (19,4) | | | | CURRENCY | The extended amount of a single adjustment; whether a fixed value or the result of d_adj_pct * unit price | Search (2) |
| d_adj_fxd | DECIMAL | decimal (19,4) | | | | CURRENCY | Single and last applied Line level adjustment. Used if d_adj_type is fixed | Search (2) |
| d_adj_pct | DECIMAL | decimal (19,4) | | | | | Single and last applied Line level percent adjustment. Used if d_adj_type is percent | Search (2) |
| d_adj_type | CHAR | varchar | | 40 | | | Type of adjustment, 'Discount-Fixed Amount', 'Surcharge-Fixed Amount', 'Discount-Percentage', 'Surcharge-Percentage' | Search (2) |
| dev | LONG | int | 151 | | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | |
| end_date | CLK_TIME | datetime | | | | | The last effective date for the line item | Search (7) |
| extn | DECIMAL | decimal (19,4) | | | | CHANGE_FIELD, CURRENCY | Rollup_Prc * quantity | Search (3) |
| gross_prc | DECIMAL | decimal (19,4) | | | | CURRENCY | Sum (child.prc * child.quantity) + prc | Search (3) |
| handling_cost | DECIMAL | decimal (19,4) | | | | CURRENCY | The sum of all handling costs for the item. Used where contract.struct_type=2 | Search (3) |
| instance_id | CHAR | varchar | | 30 | | ALLOW_NULL | Installed part unique instnace id | Search (2) |
| last_mod_dt | CLK_TIME | datetime | | | | CHANGE_DATE | 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 | Search (2) |
| last_xfer_dt | CLK_TIME | datetime | | | | | The date/time that the set of billing records for this line item were transferred into Trans_record | Search (2) |
| line_key | CHAR | varchar | | 40 | | | The Configurator line item identifier corresponding to the item | Search (3) |
| line_no | LONG | smallint | | | | DIRECT | Sequential line number of the contr_itm within its parent item. 0=line has no parent | Search (6) |
| line_no_txt | CHAR | varchar | | 20 | | | Sequential line number of line within its parent line.=0 if line has no parent | Search (6) |
| net_prc | DECIMAL | decimal (19,4) | | | | CHANGE_FIELD, CURRENCY | The price of the order item after adjustments have been applied. Extn +/- adjs | Search (4) |
| objid | LONG | int | 3 | | | DIRECT | Internal record number | Search (12) |
| oride_price | DECIMAL | decimal (19,4) | | | | CURRENCY | The value of a manually overridden price | Search (2) |
| p_line_no | LONG | smallint | | | 0 | DIRECT, CHANGE_FIELD | Sequential line number of parent lines. For child lines it equals parent's p_line_no | Search (3) |
| prc | DECIMAL | decimal (19,4) | | | | CURRENCY | The unit price of the product, which was copied from the related price_inst | Search (3) |
| pro_prc | DECIMAL | decimal (19,4) | | | | CHANGE_FIELD, CURRENCY | The prorated price of the item | Search (3) |
| prod_sales_ord | CHAR | varchar | | 40 | | | The sales order of the product to be installed under the contract line item | Search (2) |
| prorate_type | LONG | tinyint | | | 0 | DIRECT | How the line will be prorated; i.e., 0=no proration, 1=30-day-month basis, 2=actual-number-of-days-in-month basis; defaul=0 | Search (2) |
| qty_based_ind | LONG | tinyint | | | 0 | DIRECT | Indicates whether a service line item is qty or time based: 0=time, 1=qty, default=0 | Search (2) |
| quantity | LONG | int | | | | DIRECT | Number of products purchased | Search (9) |
| quote_item | LONG | tinyint | | | 1 | DIRECT | Defines whether or not line counts toward total price. (i.e. if it's a giveaway) | Search (3) |
| quote_sn | CHAR | varchar | | 40 | | | The serial number of the product to be installed under the contract line item | Search (3) |
| renew_ind | LONG | tinyint | | | 1 | DIRECT | Indicates whether a line item is to be renewed or not: 0=no, 1=yes, default=1 | Search (2) |
| rollup_prc | DECIMAL | decimal (19,4) | | | | CURRENCY | Sum (child.net_prc) + prc | Search (3) |
| start_date | CLK_TIME | datetime | | | | | The effective date for the line item | Search (7) |
| status | CHAR | varchar | | 20 | | | Current status of an order line item. This is a user-defined popup with default name Order Line Status | Search (3) |
| taxable | LONG | tinyint | | | | DIRECT | Indicates whether the item is taxable; i.e., 0=no, 1=yes | Search (2) |
| tot_adj | DECIMAL | decimal (19,4) | | | | CURRENCY | The sum of all adjustments against the line | Search (3) |
| tot_ship_amt | DECIMAL | decimal (19,4) | | | | CURRENCY | The sum of all shipping charges for the item | Search (3) |
| total_tax_amt | DECIMAL | decimal (19,4) | | | | CURRENCY | The sum of all taxes applied to the item. Used where contract.struct_type=2 | Search (3) |
| unit_type | CHAR | varchar | | 30 | | | Reserved; not used | Search (3) |
| units_avail | FLOAT | real | | | | | The number of line item units remaining | Search (6) |
| units_purch | FLOAT | real | | | | | Number of line item units purchased | Search (6) |
| units_used | FLOAT | real | | | | | The number of line item units used up | Search (6) |
| valid_prc_ind | LONG | tinyint | | | 1 | DIRECT | 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 | Search (3) |