| Table Name: | price_type |
| Table Number: | 5767 |
| Group: | Morder |
| Description: | Different types of charges associated in an offering, e.g. recurring charge, one time charge etc |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| charge_code | CHAR | varchar | 40 | The charge code of the price type. e.g. immediate, on bill, and recurring | ||||
| description | CHAR | varchar | 255 | Marketing text to be used to present the pricing to the user or customer e.g. 'Connection Fee', 'Monthly Line Rental', 'Deposit' | Search (7) | |||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| last_update | CLK_TIME | datetime | 46 | Date time of last update | ||||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (3) | ||
| type | LONG | int | DIRECT | Pricing type used to decide how to handle the charge. 1=One time charge on the Bill, 2=Immediate Charge, 3= Recurring Charge | Search (3) | |||
| view_field | CHAR | varchar | 80 | Name of field to be used in order capture view to display this price type |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| price_type2order_line_price | OTM | order_line_price | order_line_price2price_type | Order line item's price type | |||
| price_type2price_inst | OTM | price_inst | price_inst2price_type | Prices of this type |
| Index Name | Fields | Flags |
|---|
| Index Name | Fields | Additional Information |
|---|---|---|
| objindex | objid | clustered, unique located on PRIMARY |
| price_type | |||