# AccountsByAccountIdPlans Retrieve plan information for a sub account Retrieve plan information for a sub account under the master account <aside>Only for the sub account which is paid by master account</aside> - Catalog: `Zoom` - Schema: `Billing` - Select Zoom API URL: `/accounts/{accountId}/plans` - Insert Zoom API URL: `/accounts/{accountId}/plans` - Update Zoom API URL: `/accounts/{accountId}/plans` - Delete Zoom API URL: `/accounts/{accountId}/plans` - Field Selection Method: NotRequired - Select Zoom API Operation: `get /accounts/{accountId}/plans` This is a read-only table function. The Zoom API may not support changing the data or the Invantive SQL driver for Zoom does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Zoom API. ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `accountId` | `string` | ☑ | | The account ID | ## Columns of Table Function The columns of the table function `AccountsByAccountIdPlans` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `plan_audio_callout_countries` | `string` | | ☐ | Call-out countries, multiple value separated by comma | | `plan_audio_ddi_numbers` | `int64` | | ☐ | Dedicated Dial-In Numbers | | `plan_audio_premium_countries` | `string` | | ☐ | Premium countries, multiple value separated by comma | | `plan_audio_tollfree_countries` | `string` | | ☐ | Toll-free countries, multiple value separated by comma | | `plan_audio_type` | `string` | | ☐ | Additional Audio Conferencing <a href="#plans">plan type</a> | | `plan_base_hosts` | `int64` | | ☑ | Account base plan number of hosts. For a Pro Plan, please select a value between 1 and 9. For a Business Plan, please select a value between 10 and 49. For a Education Plan, please select a value between 20 and 149. For a Free Trial Plan, please select a value between 1 and 9999. | | `plan_base_type` | `string` | | ☑ | Account base <a href="#plans">plan type</a> | | `plan_recording` | `string` | | ☐ | Additional Cloud Recording Plan | | `plan_room_connector_hosts` | `int64` | | ☐ | Account plan number of hosts | | `plan_room_connector_type` | `string` | | ☐ | Account <a href="#plans">plan type</a> | | `plan_zoom_rooms_hosts` | `int64` | | ☐ | Account plan number of hosts | | `plan_zoom_rooms_type` | `string` | | ☐ | Account <a href="#plans">plan type</a> |