| Table Name: | price_inst |
| Table Number: | 225 |
| Group: | Sales Mgr |
| Description: | Contains instances of prices for related products and services appearing on a Price Schedule |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| create_date | CLK_TIME | datetime | Date and time when object was created | |||||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| effective_date | CLK_TIME | datetime | Date the price instance becomes effective | Search (16) | ||||
| expire_date | CLK_TIME | datetime | Last date the price instance is effective | Search (16) | ||||
| is_reference | LONG | int | 0 | DIRECT, ALLOW_NULL | Indicates that this price is referenced from another system an cannot be edited. 1=referenced, 0=not referenced | Search (7) | ||
| modify_stmp | CLK_TIME | datetime | 46 | Date and time when object was last saved | ||||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (18) | ||
| price | DECIMAL | decimal (19,4) | CURRENCY | Price for a given product | Search (16) | |||
| price_type | LONG | tinyint | 0 | DIRECT | Type of value in the price field; i.e., 0=currency amount, 1=percent of parent from price_qty, 2=percent of child, 3 =Fixed amount, 4=Precentage, 5=Final amount | Search (7) | ||
| rate_description | CHAR | varchar | 255 | ALLOW_NULL | String value of price amount | Search (7) | ||
| type_string | CHAR | varchar | 40 | Translates price_type | Search (7) |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| price_inst2contr_itm | OTM | contr_itm | contr_itm2price_inst | Contract/quote line items using the price instance | |||
| price_inst2part_info | MTO | mod_level | part_info2price_inst | Reserved; obsolete | Search (1) | ||
| price_inst2offr_price | MTO | offr_price | offr_price2price_inst | Offered price's instance | Search (4) | ||
| price_inst2part_num | MTO | part_num | part_num2price_inst | Reserved; obsolete | Search (1) | ||
| eligibility2price_factor | MTM | price_factor | eligibility2price_inst | Discounts and surcharges that are authorized for the price instance; reserved not used | mtm_price_factor0_ price_inst3 | ||
| override2price_inst | MTO | price_inst | price_inst2price_inst | Price_inst that is overridden by offering price | Search (3) | ||
| price_inst2price_inst | OTM | price_inst | override2price_inst | Price_inst(s) related to offering that override this price | |||
| price_inst2price_prog | MTO | price_prog | price_prog2price_inst | Related price program for the instance | Search (16) | ||
| price_inst2price_qty | MTO | price_qty | price_qty2price_inst | The part and quantity of it which are receiving the price | Search (10) | ||
| ref_price2price_qty | MTO | price_qty | ref_price2price_inst | For percentage pricing, the price quantity of the part the percentage will be applied against | Search (1) | ||
| price_inst2price_role | OTM | price_role | price_role2price_inst | The set of part revisions delivered for the price | |||
| price_inst2price_type | MTO | price_type | price_type2price_inst | Charge type for the price instance | Search (7) | ||
| price_orig2user | MTO | user | originator2price_inst | User who originated the price instance | |||
| price_modifier2user | MTO | user | modifier2price_inst | User who last modified the price instance |
| Index Name | Fields | Flags |
|---|---|---|
| price_inst_ind | price_inst2price_prog:price_inst2part_num:price_inst2part_info:price_inst2price_qty:price_inst2offr_price:price_inst2price_type:effective_date | UNIQUE |
| Index Name | Fields | Additional Information |
|---|---|---|
| ind_price_inst2price_prog | price_inst2price_prog, effective_date, expire_date | nonclustered located on PRIMARY |
| ind_price_inst2price_qty | price_inst2price_qty | nonclustered located on PRIMARY |
| ind_ref_price2price_qty | ref_price2price_qty | nonclustered located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| pi2op0225 | price_inst2offr_price | nonclustered located on PRIMARY |
| price_inst_ind | price_inst2price_prog, price_inst2part_num, price_inst2part_info, price_inst2price_qty, price_inst2offr_price, price_inst2price_type, effective_date | nonclustered, unique located on PRIMARY |
| price_inst | |||