ROIPRICINGPOLICYRULE - Database Reporting Guide - English - Foundation 22.1 - OnBase - external

Database Reporting Guide

Platform
OnBase
Product
Database Reporting Guide
Release
Foundation 22.1
License

The ROIPRICINGPOLICYRULE table stores the rules for each pricing policy.

ROIPRICINGPOLICYRULE Table Values
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.

ROIPRICINGPOLICYRULE Table Indexes
Index Name Indexed Columns
roipricingpolicyrule1 pricingrulenum
roipricingpolicyrule2 pricingpolicynum