The ROIPRICINGPOLICYRULE table stores the rules for each pricing policy.
| Column Name | Data Type | Data Length | Description |
|---|---|---|---|
| pricingrulenum | bigint | 8 | Unique identifier for the pricing policy rule. |
| pricingpolicynum | bigint | 8 | Foreign key to ROIPRICINGPOLICY. |
| pricingrulename | char | 100 | Name of the rule. Will be made available to Doc Comp for itemized billing. |
| pricingruletype | bigint | 8 | Enumeration for type of pricing (1 – Flat fee, 2 – Page Range). |
| pricingcost | bigint | 8 | Cost (stored in hundredths e.g. $.01 = 1, $1.00 = 100). |
| startpage | bigint | 8 | Start of page range for pricing rule. |
| endpage | bigint | 8 | End of page range for pricing rule. |
| flags | bigint | 8 | Currently not used. |
The indexes for ROIPRICINGPOLICYRULE table are located in DBSpace8.
| Index Name | Indexed Columns |
|---|---|
| roipricingpolicyrule1 | pricingrulenum |
| roipricingpolicyrule2 | pricingpolicynum |