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 |