CustomerTaxSetup

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

This table contains all your taxes and their rates. 1 entry per customer per tax.

Column | Data type | Nulls | Description

CustomerID | varchar(15) | No Nulls | Required.

CallType | tinyint| No Nulls | Required. Refer to [Call Types].

TaxType | varchar(50) | No Nulls | Required. Use a descriptive name for the tax.

TaxRate | numeric(9, 7) | No Nulls | Required. A value of 0.05 would indicate a 5% tax.

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

Example: If you wanted to bill customer 100000 for 2 different taxes for interstate calls and 1 tax for intrastate calls, you would use the following entries in the table. A future version will allow this to be done via the PHP portal.

CustomerID, CallType, TaxType, TaxRate
100000, 5, Intrastate Tax 1, .05
100000, 10, Interstate Tax 1, .06
100000, 10, Interstate Tax 2, .06

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