| Table Name: | price_prog |
| Table Number: | 224 |
| Group: | Sales Mgr |
| Description: | A Price Schedule. It contains a set or prices for products and services. Sometimes called a Price Book |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| active | LONG | smallint | 1 | DIRECT | Indicates whether the price program is active; i.e., 0=inactive, 1=active, default=1 | Search (2) | ||
| description | CHAR | varchar | 80 | Description of the pricing program | Search (5) | |||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | Search (1) | |
| display | LONG | int | 0 | DIRECT | If true, display pricing program for ClearLogistics in list box on parts look-up form; i.e., 0=false, 1=true. Default=0 | Search (4) | ||
| displaycc | LONG | tinyint | 1 | DIRECT | If true, display pricing program in Clear Contracts; i.e., 0=false, 1=true. Default=1 | Search (3) | ||
| displaycs | LONG | tinyint | 1 | DIRECT | If true, display pricing program in ClearSales; i.e., 0=false, 1=true. Default=1 | Search (1) | ||
| effective_date | CLK_TIME | datetime | Date the price program becomes effective | Search (7) | ||||
| expire_date | CLK_TIME | datetime | Last date the price program is effective | Search (7) | ||||
| name | CHAR | varchar | 2 | 40 | Name for the pricing program | Search (18) | ||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (14) | ||
| type | LONG | int | DIRECT | Price type; i.e., 0=Standard Cost, 1=Proposed Std. Cost, 2=Transfer Price, 3=List Price, 4=Repair Price, 5= Exchange Price, 6=Other, default=0 | Search (5) |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views | Set Name | Type ID Stored in | Objid Stored In |
|---|---|---|---|---|---|---|---|---|---|---|
| Exclusive Set Relations | ||||||||||
| default2account | OTOF | account | default2price_prog | Account for which the price schedule is the default. Reserved | ||||||
| defaultbus2bus_org | OTM | bus_org | defaultbus2price_prog | Accounts using the price_prog as their default price book | ||||||
| price_prog2campaign | OTM | campaign | campaign2price_prog | Campaigns using the price program | ||||||
| price_prog2contr_schedule | OTM | contr_schedule | default_prog2price_prog | Contract schedules using the price_prog as their default price schedule | ||||||
| price_prog2contract | OTM | contract | contract2price_prog | Order covered by a price program | ||||||
| price_prog2currency | MTO | currency | currency2price_prog | Currency in which the price program is denominated | Search (8) | |||||
| price_prog2elgblty_set | OTOF | elgblty_set | elgblty_set2price_prog | Eligibility criteria for a price program | eligibility_for | focus_type | focus_lowid | |||
| price_prog2price_inst | OTM | price_inst | price_inst2price_prog | Related price instances | ||||||
| price_prog2quick_quote | OTM | quick_quote | q_quote2price_prog | Campaigns using the price program | ||||||
| price_prog2site | MTO | site | site2price_prog | Site owning the price program | ||||||
| Index Name | Fields | Flags |
|---|
| Index Name | Fields | Additional Information |
|---|---|---|
| nm0224 | name | nonclustered located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| price_prog | |||