CustomerMaster

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

This page describes the columns in this table.

Column | Data type | Nulls | Description

CustomerID | varchar(15) | No Nulls | This must be a 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.

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.