CustomerMaster

This page describes the columns in this table. Customers can be entered via the [PHP Admin Portal] using the 'Customers' link on the main page or you can insert customer records directly into the CustomerMaster table.

Column | Data type | Nulls | Description

CustomerID | varchar(15) | No Nulls | This is the unique CustomerID. It must match the CustomerID supplied in the CDR.

CustomerName | varchar(100) | No Nulls | The customer's full name.

CNAMDipRate | numeric(9, 9) | No Nulls | This is the fee per CNAM dip. The CNAMDipped flag must be set in the CDR if you want it billed.

LRNDipRate | numeric(9, 9) | No Nulls | This is the fee per LRN dip. If the LRN is supplied in the CDR, we will assume it was dipped and we will bill this fee on the call.

IndeterminateJurisdictionCallType | 1-byte integer | No Nulls | Required. This controls how calls of Indeterminate Jurisdiction will be handled for this customer. Valid values are 5, 10. See [Call Types].

BillingCycleID | varchar(15) | Nulls Allowed | This is used to configure the cycle the customer will be billed in.

CustomerType | varchar(50) | No Nulls | Wholesale customers will be billed using wholesale rates. Retail customer will be billed using retail plans.

RowID | integer | Auto-increment | This is an internal field used primarily for adhoc queries. Do not supply a value for this field. Do not remove this field.

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