| Table Name: | contr_pr |
| Table Number: | 157 |
| Group: | Sales Mgr |
| Description: | Detailed price adjustments applied for a contract or quote |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| eff_end_dt | CLK_TIME | datetime | The last date through which the price factor is effective | Search (1) | ||||
| eff_start_dt | CLK_TIME | datetime | The date that the price factor becomes effective | Search (1) | ||||
| extended_amt | DECIMAL | decimal (19,4) | CURRENCY | The extended amount whether fixed amount or percentage | Search (1) | |||
| factor_base | LONG | tinyint | DIRECT | How the price factor was applied; i.e. 0=against the base price, 1=against the net price, default=0 | Search (1) | |||
| fxd_amt | DECIMAL | decimal (19,4) | CURRENCY | A fixed currency amount applied to the price | Search (1) | |||
| is_man_adj | LONG | tinyint | 1 | DIRECT | Indicates whether the adjustment was predefined: i.e., 0=predefined, 1=manual adjustment, default=1 | Search (1) | ||
| notes | CHAR | varchar | 80 | Notes about the applied adjustment | Search (1) | |||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (1) | ||
| pct | DECIMAL | decimal (19,4) | A percentage applied to the price | Search (1) | ||||
| precedence | LONG | tinyint | DIRECT | The order in which the price factor should be applied | Search (1) | |||
| symbol | CHAR | varchar | 5 | Currency symbol for the applied price factor; e.g., $ for US dollar | Search (1) | |||
| type | CHAR | varchar | 40 | Indicates the type e.g., 'Discount -Percentage', 'Discount - Fixed Amount' 'Surcharge Percentage', 'Surcharge Fixed Amount' | Search (1) |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| contr_pr2amort_dtl | OTM | amort_dtl | amort_dtl2contr_pr | Amortization components using the adjustment | |||
| contr_pr2contr_itm | MTO | contr_itm | contr_itm2contr_pr | Contract item being adjusted-for item-level adjustments | |||
| contr_pr2contr_schedule | MTO | contr_schedule | schedule2contr_pr | Contract/quote schedule being adjusted-for schedule-level adjustments | |||
| contr_pr2price_factor | MTO | price_factor | price_factor2contr_pr | Price factor used for the header or line item adjustment | Search (1) |
| Index Name | Fields | Flags |
|---|
| Index Name | Fields | Additional Information |
|---|---|---|
| ind_contr_pr2contr_itm | contr_pr2contr_itm, eff_start_dt, eff_end_dt, precedence | nonclustered located on PRIMARY |
| ind_contr_pr2contr_schedule | contr_pr2contr_schedule, eff_start_dt, eff_end_dt, precedence | nonclustered located on PRIMARY |
| ind_contr_pr2price_factor | contr_pr2price_factor | nonclustered located on PRIMARY |
| ind_eff_start_dt | eff_start_dt, eff_end_dt, precedence | nonclustered located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|---|---|
| 426 | contr_pr_pf | contr_pr, price_factor |
| contr_pr | |||