Tables

This is a first-release of the documentation. Additional detail will be added as the project matures.

The table scripts can be downloaded from https://sourceforge.net/projects/opencdrrate/files/Tables/

Table | Description

BillingBatchDetails | This table stores billing/invoice line items after a billing batch has been created using the [fnGenerateBillingBatch] function.

BillingBatchMaster | This table stores 1 row per billing batch created.

CallRecordMaster | This table stores rated call records. More information at [CallRecordMaster].

CallRecordMaster_HELD | This table stores call records that failed rating. More information at [CallRecordMaster_HELD].

CallRecordMaster_TBR | This table stores call records that have not yet been rated. More information at [CallRecordMaster_TBR].

EffectiveInternationalRateMaster | The rating engine uses this table to temporarily store rates during the rating process. Do not load/alter data in this table.

EffectiveInterstateRateMaster | The rating engine uses this table to temporarily store rates during the rating process. Do not load/alter data in this table.

EffectiveIntrastateRateMaster | The rating engine uses this table to temporarily store rates during the rating process. Do not load/alter data in this table.

EffectiveTollFreeOriginationRateMaster | The rating engine uses this table to temporarily store rates during the rating process. Do not load/alter data in this table.

InternationalRateMaster | Load your international rates into this table. More information at [InternationalRateMaster].

InterstateRateMaster | Load your interstate rates into this table. More information at [InterstateRateMaster].

IntrastateRateMaster | Load your intrastate rates into this table. More information at [IntrastateRateMaster].

IPAddressMaster | Create one entry for each IP address you accept traffic from. This will be used in the future to determine the CustomerID based on IP address.

ProcessHistory | This table stores the runtime for many of the functions we use.

SystemSettings_Date | This table is used to store date-based system settings.

TieredOriginationRateCenterMaster | Load your Rate Center to Origination Tier mapping into this table. More information at [TieredOriginationRateCenterMaster]. This is required for rating Tiered Origination calls.

TieredOriginationRateMaster | Load your tiered origination rates into this table. More information at [TieredOriginationRateMaster].

TollFreeOriginationRateMaster | Load your toll-free origination rates into this table. More information at [TollFreeOriginationRateMaster].

If you have any questions, please contact [Support].

-The OpenCDRRate team.

Follow us on twitter to receive new feature notifications: http://www.twitter.com/opencdrrate/

Join our LinkedIn group to open discussions on features you would like to see in the system. http://www.linkedin.com/groups/OpenCDRRate-4381972