Field Name |
Notes |
<supp_plan_ind> |
Allowable values
Values |
Description |
0 |
Master Plan |
1 |
Supplemental Plan |
|
<billing_ind> |
Allowable values
Values |
Description |
0 |
Plan is not billable. |
1 |
Plan is billable. |
|
<display_ind> |
Allowable values
Values |
Description |
0 |
Plan is not displayable. |
1 |
Plan is displayable. |
|
<new_plan_status> |
Allowable values
Values |
Description |
0 |
INACTIVE |
1 |
ACTIVE |
2 |
CANCELLATION PENDING |
3 |
TERMINATION PENDING |
10 |
ACTIVE DUNNING PENDING |
11 |
ACTIVE DUNNING 1 |
12 |
ACTIVE DUNNING 1 |
13 |
ACTIVE DUNNING 3 |
14 |
ACTIVE DUNNING 4 |
15 |
ACTIVE DUNNING 5 |
16 |
ACTIVE DUNNING 6 |
17 |
ACTIVE DUNNING 7 |
18 |
ACTIVE DUNNING 8 |
21 |
REINSTATED FORWARD BILL |
22 |
REINSTATED BACK BILL |
31 |
INSTALLATION PENDING |
32 |
REGISTERED PENDING ACTIVATION |
41 |
ACTIVE TRIAL |
51 |
TEMPORARY SERVICE BAN |
61 |
ACTIVE NON-BILLABLE |
99 |
PERMANENT |
-1 |
SUSPENDED |
-2 |
CANCELLED |
-3 |
TERMINATED |
-4 |
CONTRACT EXPIRED |
-11 |
SUSPENDED DUNNING 1 |
-12 |
SUSPENDED DUNNING 2 |
-13 |
SUSPENDED DUNNING 3 |
-14 |
SUSPENDED DUNNING 4 |
-15 |
SUSPENDED DUNNING 5 |
-99 |
ARCHIVED |
|
<rollover_plan_status> |
Allowable values
Values |
Description |
0 |
INACTIVE |
1 |
ACTIVE |
2 |
CANCELLATION PENDING |
3 |
TERMINATION PENDING |
10 |
ACTIVE DUNNING PENDING |
11 |
ACTIVE DUNNING 1 |
12 |
ACTIVE DUNNING 1 |
13 |
ACTIVE DUNNING 3 |
14 |
ACTIVE DUNNING 4 |
15 |
ACTIVE DUNNING 5 |
16 |
ACTIVE DUNNING 6 |
17 |
ACTIVE DUNNING 7 |
18 |
ACTIVE DUNNING 8 |
21 |
REINSTATED FORWARD BILL |
22 |
REINSTATED BACK BILL |
31 |
INSTALLATION PENDING |
32 |
REGISTERED PENDING ACTIVATION |
41 |
ACTIVE TRIAL |
51 |
TEMPORARY SERVICE BAN |
61 |
ACTIVE NON-BILLABLE |
99 |
PERMANENT |
-1 |
SUSPENDED |
-2 |
CANCELLED |
-3 |
TERMINATED |
-4 |
CONTRACT EXPIRED |
-11 |
SUSPENDED DUNNING 1 |
-12 |
SUSPENDED DUNNING 2 |
-13 |
SUSPENDED DUNNING 3 |
-14 |
SUSPENDED DUNNING 4 |
-15 |
SUSPENDED DUNNING 5 |
-99 |
ARCHIVED |
|
<default_notify_method> |
Allowable values
Values |
Description |
0 |
None |
1 |
HTML Email |
2 |
Text Email |
3 |
Text Email w/link to HTML |
4 |
Data export |
5 |
Printable (no Email) w/Surcharge |
6 |
Printable & Text Email |
7 |
Printable & HTML Email w/Surcharge |
8 |
Printable (no Email) |
9 |
PDF (Printing required, no Email) |
10 |
PDF (delivered by Email) |
11 |
PDF (Printing req & Email)w/surcharge |
12 |
PDF (Printing req, no Email)w/surcharge |
13 |
XML Master File |
14 |
PDF Master File |
|
<prepaid_ind> |
Allowable values
Values |
Description |
0 |
Indicates that the plan is not prepaid. |
1 |
Indicates the plan is prepaid. |
|
<rollover_plan_uom_cd> |
Allowable values
Values |
Description |
1 |
Day |
2 |
Week |
3 |
Month |
4 |
Quarter |
5 |
Year |
|
<init_free_period_uom_cd> |
Allowable values
Values |
Description |
1 |
Day |
2 |
Week |
3 |
Month |
4 |
Quarter |
5 |
Year |
|
<initial_plan_status_cd> |
Allowable values
Values |
Description |
1 |
ACTIVE |
41 |
ACTIVE TRIAL |
61 |
ACTIVE NON-BILLABLE |
|
<rollover_plan_status_uom_cd> |
Allowable values
Values |
Description |
1 |
Day |
2 |
Week |
3 |
Month |
4 |
Quarter |
5 |
Year |
|
<rollover_plan_status_cd> |
Allowable values
Values |
Description |
1 |
ACTIVE |
41 |
ACTIVE TRIAL |
61 |
ACTIVE NON-BILLABLE |
|
<is_recurring_ind> |
Allowable values
Values |
Description |
0 |
Service is not recurring-based. |
1 |
Service is recurring-based. |
|
<is_usage_based_ind> |
Allowable values
Values |
Description |
0 |
Service is not usage-based. |
1 |
Service is usage-based. |
|
<taxable_ind> |
Allowable values
Values |
Description |
0 |
Service is not taxable. |
1 |
Service is taxable. |
|
<is_tax_ind> |
Allowable values
Values |
Description |
0 |
Service is not a tax-based service. |
1 |
Service is a tax-based service. |
|
<is_arrears_ind> |
Allowable values
Values |
Description |
0 |
Service is not arrears-based. |
1 |
Service is arrears-based. |
|
<is_setup_ind> |
Allowable values
Values |
Description |
0 |
Service is not setup-based. |
1 |
Service is setup-based. |
|
<is_misc_ind> |
Allowable values
Values |
Description |
0 |
Service is not miscellaneous. |
1 |
Service is miscellaneous. |
|
<is_donation_ind> |
Allowable values
Values |
Description |
0 |
Service is not donation-based. |
1 |
Service is donation-based. |
|
<is_order_based_ind> |
Allowable values
Values |
Description |
0 |
Service is not order-based. |
1 |
Service is order-based. |
|
<is_cancellation_ind> |
Allowable values
Values |
Description |
0 |
Service is not cancellation-based. |
1 |
Service is cancellation-based. |
|
<display_ind> |
Allowable values
Values |
Description |
0 |
Service is not displayable. |
1 |
Service is displayable. |
|
<tiered_pricing_rule> |
Allowable values
Values |
Description |
1 |
Standard |
2 |
Volume Discount |
3 |
Flat Rate Per Tier |
|
<is_min_fee_ind> |
Allowable values
Values |
Description |
0 |
Service is not a minimum fee. |
1 |
Service is a minimum fee. |
|
<future_rate> |
Allowable values
Values |
Description |
0 |
false, i.e., no future rate. |
1 |
True, i.e., future rates are captured. |
|
null, i.e., no future rate. |
|
<apply_usage_rates_daily> |
Allowable values
Values |
Description |
0 |
usage shall be rated based on the entire billing period |
1 |
usage shall be rated based on one day periods individually. |
|
<tax_inclusive_ind> |
Allowable values
Values |
Description |
0 |
The service is tax-exclusive. |
1 |
The service is tax-inclusive. |
|
<recurring_billing_period_type> |
Allowable values
Values |
Description |
1 |
Period type for recurring billing cycle is Daily. |
2 |
Period type for recurring billing cycle is Weekly. |
3 |
Period type for recurring billing cycle is Monthly. |
4 |
Period type for recurring billing cycle is Quarterly. |
5 |
Period type for recurring billing cycle is Yearly. |
|
<usage_billing_period_type> |
Allowable values
Values |
Description |
1 |
Period type for usage billing cycle is Daily. |
2 |
Period type for usage billing cycle is Weekly. |
3 |
Period type for usage billing cycle is Monthly. |
4 |
Period type for usage billing cycle is Quarterly. |
5 |
Period type for usage billing cycle is Yearly. |
|
<default_ind> |
Allowable values
Values |
Description |
0 |
Rate schedule is not the default. |
1 |
Rate schedule is the default. |
|
<default_ind_curr> |
Allowable values
Values |
Description |
0 |
Rate schedule is not default for specified currency. |
1 |
Rate schedule is default for specified currency. |
|
<schedule_display_ind> |
Allowable values
Values |
Description |
0 |
Rate schedule is not displayable. |
1 |
Rate schedule is displayable. |
|