Home > Aria6 User Documentation > Aria6 core api > get_acct_plans_all

get_acct_plans_all

Returns the plan, service, and rate schedule data for all master and supplemental plans assigned to a specified account.

Input Arguments

Req Field Name Field Type Max Length Description
required-icon.png client_no long 22 Aria-assigned unique identifier indicating the Aria client providing service to this account.
required-icon.png auth_key string 32 Aria-assigned unique key to be passed with each method call for authenticating the validity of the requestor.
required-icon.png acct_no long 22 Aria-assigned account identifier. This value is unique across all Aria-managed accounts.
  alt_caller_id string 30 Person or process that submitted the API call. This can be someone's user ID, or the name of an application.
  optional_transaction_qualifiers array   Array of additional values you can associate with this API call.
  brd_arrow.gif qualifier_name string 100 Name of the field you want to associate with this API call.
  brd_arrow.gif qualifier_value string 100 Corresponding value of the field you want to associate with this API call.
 

Output Arguments

Field Name Field Type Description
error_code long Aria-assigned error identifier. 0 indicates no error.
error_msg string Description of any error that occurred. "OK" if there was no error.
all_acct_plans hash  
brd_arrow.gif plan_no long Aria-assigned unique plan identifier
brd_arrow.gif plan_name string Plan Name
brd_arrow.gif plan_desc string Text description of this plan
brd_arrow.gif plan_date string Date on which the account was assigned to their current plan.
brd_arrow.gif plan_units long Number of plan units the account is billed for.
brd_arrow.gif queued_plan_units long Number of plan units the account is queued to change to on "units_change_date".
brd_arrow.gif units_change_date string The date queued units are effective
brd_arrow.gif last_bill_date string The date the account was last billed
brd_arrow.gif next_bill_date string Date the account will be evaluated for invoicing, whether or not it results in any actual charges.
brd_arrow.gif bill_thru_date string Date the accounts forward charges have been billed through.
brd_arrow.gif bill_day long Day of month the account is billed on.
brd_arrow.gif billing_interval long Number of months between billing cycles
brd_arrow.gif billing_ind long Indicates whether or not this plan is billable 

Allowable values for billing_ind:

Values Description
0 0
1 1
brd_arrow.gif display_ind long Indicates whether or not the plan is marked as "displayable". 0 means not displayable. 1 means displayable. 

Allowable values for display_ind:

Values Description
0 Not displayable
1 displayable
brd_arrow.gif rollover_months long Number of months in which the account will change from the current plan to the pre-defined rollover plan.
brd_arrow.gif rollover_plan_no long Pre-defined plan to which the account will change based on the defined rollover_months value; the rollover record is created when an account is placed on a plan with a defined rollover plan.
brd_arrow.gif early_cancel_fee double Fee charged for early cancellations.
brd_arrow.gif early_cancel_min_months long Number of months during which early cancellation fees would apply on plan cancellation.
brd_arrow.gif suspension_period long Pre-defined period in days in which an account will degrade to Suspended status (-1) if action is not taken such as a plan or status change.
brd_arrow.gif new_acct_status long The status of new accounts subscribing to this plan 

Allowable values for new_acct_status:

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
brd_arrow.gif rollover_acct_status long Default status for new accounts created on this plan. 

Allowable values for rollover_acct_status:

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
brd_arrow.gif rollover_acct_status_days long Number of days in which an account will change from the initial status code to the pre-defined rollover status code.
brd_arrow.gif init_free_months long Initial free months.
brd_arrow.gif plan_2_assign_on_susp long Plan to assign when an account on this plan is suspended.
brd_arrow.gif default_notify_method long Default notification method given to an account that is assigned to this plan. 

Allowable values for default_notify_method:

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
brd_arrow.gif prepaid_ind long Indicates whether or not this plan is prepaid 

Allowable values for prepaid_ind:

Values Description
0 0
1 1
brd_arrow.gif currency_cd string The 3-character ISO-compliant currency code in lowercase for monetary values used in the context of this API method.
brd_arrow.gif rate_schedule_no long Aria-assigned unique rate schedule number
brd_arrow.gif rate_schedule_name string Name of the rate schedule
brd_arrow.gif rate_sched_is_default_ind long Indicates whether or not the account is using the plans default rate schedule. 0 means the account is using an alternate rate schedule. 1 means the account is using the default rate schedule. 

Allowable values for rate_sched_is_default_ind:

Values Description
0 Alternate rate schedule
1 Default rate schedule
brd_arrow.gif supp_plan_ind long Indicates whether or not the plan is a supplemental plan. If it is "1", then the plan is a supplemental plan and if it is "0", then the plan is a master plan. 

Allowable values for supp_plan_ind:

Values Description
0 Master plan
1 Supplemental plan
brd_arrow.gif supp_plan_status_cd long The status code of the supplemental plan associated with this account. 

Allowable values for supp_plan_status_cd:

Values Description
1 Active
2 Active Pending
3 Terminate Pending
-1 Terminated
brd_arrow.gif supp_plan_status_label string The status code of the supplemental plan returned by the API method. 

Allowable values for supp_plan_status_label:

Values Description
1 Active
2 Active Pending
3 Terminate Pending
-1 Terminated
brd_arrow.gif supp_plan_status_date string The most recent date of the status change due to the supplemental plan
brd_arrow.gif supp_plan_activate_date string The activation date of this supplemental plan
brd_arrow.gif supp_plan_terminate_date string The termination date, if any, of this supplemental plan
brd_arrow.gif client_receipt_id string Client-defined unique identifier used to track related system actions
brd_arrow.gif client_plan_id string Client-defined Plan ID for which to query available child plans
brd_arrow.gif client_rollover_plan_id string Pre-defined plan to which the account will change based on the defined rollover_months value; the rollover record is created when an account is placed on a plan with a defined client rollover plan ID.
brd_arrow.gif client_plan_2_assign_on_susp string Client-defined Plan identifier to assign when an account on this plan is suspended.
brd_arrow.gif client_rate_schedule_id string Client assigned unique rate schedule number
brd_arrow.gifproration_invoice_timing_cd string Indicates whether to defer the pro-rated charges to the next anniversary date or to create a separate invoice immediately. 

Allowable values for proration_invoice_timing_cd:

Values Description
I Indicates to generate the invoice immediately for the pro-rated charges.
A Indicates to generate the invoice to the next anniversary date for the pro-rated charges.
brd_arrow.gif usage_accumulation_reset_months long for each plan specified, the number of months to accumulate before being reset.
brd_arrow.gifusage_accumulation_reset_months_renewal_option long Determines whether the usage accumulation reset months will automatically reset to same value at the end of the current period or will expire at the end of the current period.  

Allowable values for usage_accumulation_reset_months_ renewal_option:

Values Description
1 Recurring / Auto Renew.
NULL or 2 Single Use. (Default)
brd_arrow.gif usage_accumulation_reset_counter long Number of months since last reset. Once this value reaches the <usage_accumulation_reset_months> value, it will reset to 0 (zero).
brd_arrow.gif plan_services hash A multidimensional array of Services for this plan
brd_arrow.gif service_no long A multidimensional array of Services for this plan
brd_arrow.gif service_desc string Description of this service
brd_arrow.gif is_recurring_ind long Indicates whether or not this service is a recurring service 

Allowable values for is_recurring_ind:

Values Description
0 0
1 1
brd_arrow.gif is_usage_based_ind long Indicates whether or not this service is a usage based service 

Allowable values for is_usage_based_ind:

Values Description
0 0
1 1
brd_arrow.gif usage_type long The usage type supported by this usage based service
brd_arrow.gif taxable_ind long Indicates whether or not this service is taxable 

Allowable values for taxable_ind:

Values Description
0 0
1 1
brd_arrow.gif is_tax_ind long Indicates whether or not this service is a tax based service 

Allowable values for is_tax_ind:

Values Description
0 0
1 1
brd_arrow.gif is_arrears_ind long Indicates whether or not this service is an arrears based service 

Allowable values for is_arrears_ind:

Values Description
0 0
1 1
brd_arrow.gif is_setup_ind long Indicates whether or not this service is a setup bases service 

Allowable values for is_setup_ind:

Values Description
0 0
1 1
brd_arrow.gif is_misc_ind long Indicates whether or not this service is a miscellaneous service 

Allowable values for is_misc_ind:

Values Description
0 0
1 1
brd_arrow.gif is_donation_ind long Indicates whether or not this service is a donation based service 

Allowable values for is_donation_ind:

Values Description
0 0
1 1
brd_arrow.gif is_order_based_ind long Indicates whether or not this service is an order based service 

Allowable values for is_order_based_ind:

Values Description
0 0
1 1
brd_arrow.gif is_cancellation_ind long Indicates whether or not this service is a cancellation based service 

Allowable values for is_cancellation_ind:

Values Description
0 0
1 1
brd_arrow.gif coa_id string Chart of accounts ID
brd_arrow.gif ledger_code string This field is deprecated in favor of coa_id
brd_arrow.gif client_coa_code string The client-defined override for coa_id
brd_arrow.gif display_ind long Indicates if this service is displayable or not 

Allowable values for display_ind:

Values Description
0 0
1 1
brd_arrow.gif tiered_pricing_rule long The Tiered Pricing Rule 

Allowable values for tiered_pricing_rule:

Values Description
1 Standard
2 Volume Discount
3 Flat Rate Per Tier
brd_arrow.gif is_min_fee_ind long Indicates whether or not this service is a minimum fee. 

Allowable values for is_min_fee_ind:

Values Description
0 0
1 1
brd_arrow.gif client_service_id string A multidimensional array of client-defined Service ID for this plan.
brd_arrow.gif usage_type_cd string An array containing usage_type_cd(s) to denote which usage type(s) to record.
brd_arrow.gif all_service_supp_fields hash  
brd_arrow.gif field_name string The machine-readable name of this field
brd_arrow.gif field_desc string The human-readable name of this field
brd_arrow.gif field_order_no long The sort order of this field
brd_arrow.gif field_value string The value stored in this field
brd_arrow.gif fulfillment_based_ind long Indicates if the service is Fulfillment Based or not.
brd_arrow.gif plan_service_rates hash Represents the rates for the default rate schedule for the default currency for the plan
brd_arrow.gif rate_seq_no long Sequential number in the rate schedule for determining tiers
brd_arrow.gif from_unit double Tiered Units (from) This value represents the start of a tiered range of values.
brd_arrow.gif to_unit double Tiered Units (to) This value represents the end of the range for a single tier of values.
brd_arrow.gif rate_per_unit double The cost per unit of this service over the time period the plan is billed for
brd_arrow.gif future_rate_per_unit double The future cost per unit of this service over the time period the plan is billed for
brd_arrow.gif monthly_fee double If the plan interval is more than one month, this field will rate per unit per month
brd_arrow.gif client_rate_schedule_id string Client assigned unique rate schedule number
brd_arrow.gif rate_tier_description string Rate Tier Description
brd_arrow.gif all_plan_service_rates hash All rates for all rate schedules and currencies for this plan
brd_arrow.gif schedule_no long Rate schedule number
brd_arrow.gif client_rate_schedule_id string Client assigned unique rate schedule number
brd_arrow.gif future_rate long Indicates whether future rates are captured or not. 

Allowable values for future_rate:

Values Description
0 false, i.e., no future rate.
1 True, i.e., future rates are captured.
  null, i.e., no future rate.
brd_arrow.gif future_change_date string Future Change Date of the rates.
brd_arrow.gif followup_rs_no long Aria internal id of follow-up default rate schedule
brd_arrow.gif client_followup_rs_id string Client defined id of followup rate schedule
brd_arrow.gif plan_service_rates hash Represents the rates for the default rate schedule for the default currency for the plan
brd_arrow.gif rate_seq_no long Sequential number in the rate schedule for dertermining tiers
brd_arrow.gif from_unit double Tiered Units (from) This value represents the start of a tiered range of values.
brd_arrow.gif to_unit double Tiered Units (to) This value represents the end of the range for a single tier of values.
brd_arrow.gif rate_per_unit double The cost per unit of this service over the time period the plan is billed for
brd_arrow.gif future_rate_per_unit double The future cost per unit of this service over the time period the plan is billed for
brd_arrow.gif monthly_fee double If the plan interval is more than one month, this field will rate per unit per month
brd_arrow.gif client_rate_schedule_id string Client assigned unique rate schedule number
brd_arrow.gif rate_tier_description string Rate Tier Description
brd_arrow.gif usage_type_name string The human-readable name of this usage type
brd_arrow.gif usage_type_desc string The long description of this usage type
brd_arrow.gif usage_type_code string Client-assigned identifier for the type of usage being recorded.
brd_arrow.gif usage_unit_label string The display-level description of the units this usage represents.
brd_arrow.gif apply_usage_rates_daily long Indicates whether or not this usage-based service is rated on a daily basis. 

Allowable values for apply_usage_rates_daily:

Values Description
0 usage shall be rated based on the entire billing period
1 usage shall be rated based on one day periods individually.
brd_arrow.gif surcharges_all hash A multidimensional array of Surcharges for this plan'
brd_arrow.gif surcharge_no long Surcharge number for this plan
brd_arrow.gif surcharge_name string Surcharge name for this plan
brd_arrow.gif client_surcharge_id string Client-defined surcharge ID.
brd_arrow.gif description string description for surcharge.
brd_arrow.gif ext_description string External Description for surcharge.
brd_arrow.gif surcharge_type string Surcharge type for the plan.
brd_arrow.gif currency string Currency for this surcharge plan
brd_arrow.gif tax_group string If taxable, the tax group this item belongs to
brd_arrow.gif invoice_app_method string Invoice application method of this plan surcharge
brd_arrow.gif rev_gl_code string Revenue Account GL Code for this plan surcharge
brd_arrow.gif ar_gl_code string Accounts Receivable GL Code for this plan surcharge
brd_arrow.gif surcharge_rate hash A multidimensional array of Surcharges Rate for this plan'
brd_arrow.gif rate_seq_no long Aria-assigned unique rate sequence number
brd_arrow.gif from_unit double Tiered Units (from) This value represents the start of a tiered range of values.
brd_arrow.gif to_unit double Tiered Units (to) This value represents the end of the range for a single tier of values.
brd_arrow.gif rate_per_unit double This is the rate for the tiered units specified by from and to unit values above.
brd_arrow.gif include_zero long This indicator indicates whether the rate schedule has includes zero or not.
brd_arrow.gif rate_sched_is_assigned_ind long This indicator indicates the assigned rate schedule for the surcharge.
brd_arrow.gif rate_tier_description string Rate Tier Description
 
 
 
Last modified

Tags

This page has no custom tags.

Classifications

This page has no classifications.
Powered by CXone Expert ®