Partitions for all active data containers.
Catalog: DataDictionary
Schema: Invantive
Alias: ptn
Label: Partitions
This is a read-only view. The Data Dictionary API may not support changing the data or the Invantive SQL driver for Data Dictionary does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Data Dictionary API.
The columns of the view SYSTEMPARTITIONS are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
ALLOW_WRITE |
boolean |
Allow Write |
☑ |
Whether the partition allows writes. |
CODE |
string(240) |
Code |
☑ |
Unique code of the partition. |
COMPANY_ADDRESS |
string(4000) |
Company Address |
☐ |
Address of the company of the partition. |
COMPANY_CITY |
string(4000) |
Company City |
☐ |
City of the company of the partition. |
COMPANY_COC_NUMBER |
string(4000) |
Company Chamber of Commerce Number |
☐ |
Chamber of Commerce number of the company of the partition. |
COMPANY_COUNTRY |
string(4000) |
Company Country |
☐ |
Country of the company of the partition. |
COMPANY_EMAIL_ADDRESS |
string(4000) |
Company Email Address |
☐ |
Email address of the company of the partition. |
COMPANY_IBAN_NUMBER |
string(4000) |
Company IBAN Number |
☐ |
IBAN number of the company of the partition. |
COMPANY_NAME |
string(4000) |
Company Name |
☐ |
Name of the company of the partition. |
COMPANY_PHONE |
string(4000) |
Company Phone |
☐ |
Phone of the company of the partition. |
COMPANY_RSIN_NUMBER |
string(4000) |
Company RSIN Number |
☐ |
RSIN number of the company of the partition. |
COMPANY_STATE |
string(4000) |
Company State |
☐ |
State of the company of the partition. |
COMPANY_TWITTER_ACCOUNT |
string(4000) |
Company Twitter Account |
☐ |
Twitter account of the company of the partition. |
COMPANY_VAT_NUMBER |
string(4000) |
Company VAT Number |
☐ |
VAT number of the company of the partition. |
COMPANY_WAGE_TAX_NUMBER |
string(4000) |
Company Wage Tax Number |
☐ |
Wage tax number of the company of the partition. |
COMPANY_WEB_SITE |
string(4000) |
Company Web Site |
☐ |
Web site of the company of the partition. |
COMPANY_ZIP_CODE |
string(4000) |
Company ZIP Code |
☐ |
ZIP-code of the company of the partition. |
CREATED_UTC |
datetime |
Created |
|
When the partition was created (UTC). |
DESCRIPTION |
string(4000) |
Description |
☐ |
Description. |
FIRST_USE_UTC |
datetime |
First Use |
|
When the partition has been used first in this session (UTC). |
IS_ACTIVE |
boolean |
Active |
|
Whether the partition is active. |
IS_ARCHIVED |
boolean |
Archived |
|
Whether the partition is archived. |
IS_SELECTED_BY_DEFAULT |
boolean |
Selected by Default |
|
Whether the partition is selected by default. |
IS_SELECTED |
boolean |
Selected |
☑ |
Whether the partition is currently selected. |
IS_USED |
boolean |
Used |
|
Whether the partition has been used in this session. |
LABEL |
string(4000) |
Label |
☑ |
Label for use in lists. |
MASTER_ROLL_UP |
string(4000) |
Master Roll-up |
☐ |
Master roll-up. |
MODIFIED_UTC |
datetime |
Modified |
|
When the partition was last modified (UTC). |
NAME |
string(4000) |
Name |
☐ |
Name. |
PROVIDER_DATA_CONTAINER_ALIAS |
string(4000) |
Data Container Alias |
☐ |
Data container alias. |
PROVIDER_DATA_CONTAINER_ID |
string(4000) |
Data Container ID |
☐ |
Data container ID. |
PROVIDER_DESCRIPTION |
string(16000) |
Provider Description |
☑ |
Provider description. |
PROVIDER_NAME |
string(240) |
Provider Name |
☑ |
Name of the provider. |
PROVIDER_SHORT_NAME |
string(240) |
Provider Short Name |
☑ |
Provider short name. |
ROLL_UP |
string(4000) |
Roll-up |
☐ |
Roll-up. |
SESSION_IO_BYTES_RECEIVED_OTHER |
int64 |
|
☐ |
Number of bytes sent (other). |
SESSION_IO_BYTES_RECEIVED_OVERALL |
int64 |
|
☐ |
Number of bytes sent overall. |
SESSION_IO_BYTES_RECEIVED_READ |
int64 |
|
☐ |
Number of bytes sent for read. |
SESSION_IO_BYTES_RECEIVED_WRITE |
int64 |
|
☐ |
Number of bytes sent for write. |
SESSION_IO_BYTES_SENT_OTHER |
int64 |
|
☐ |
Number of bytes received (other). |
SESSION_IO_BYTES_SENT_OVERALL |
int64 |
|
☐ |
Number of bytes received overall. |
SESSION_IO_BYTES_SENT_READ |
int64 |
|
☐ |
Number of bytes received for read. |
SESSION_IO_BYTES_SENT_WRITE |
int64 |
|
☐ |
Number of bytes received for write. |
SESSION_IO_DURATION_MS_OTHER |
int64 |
|
☐ |
Total duration for other in milliseconds. |
SESSION_IO_DURATION_MS_OVERALL |
int64 |
|
☐ |
Total duration overall in milliseconds. |
SESSION_IO_DURATION_MS_READ |
int64 |
|
☐ |
Total duration for read in milliseconds. |
SESSION_IO_DURATION_MS_WRITE |
int64 |
|
☐ |
Total duration for write in milliseconds. |
SESSION_IO_EXECUTION_COUNT_OTHER |
int64 |
|
☐ |
Number of I/Os executed (other). |
SESSION_IO_EXECUTION_COUNT_OVERALL |
int64 |
|
☐ |
Number of I/Os executed overall. |
SESSION_IO_EXECUTION_COUNT_READ |
int64 |
|
☐ |
Number of I/Os executed for read. |
SESSION_IO_EXECUTION_COUNT_WRITE |
int64 |
|
☐ |
Number of I/Os executed for write. |
SHORT_NAME |
string(4000) |
Short Name |
☐ |
Short name. |
SUBSCRIPTION_HOLDER_ADDRESS_LINE_1 |
string(4000) |
|
☐ |
Address line 1 of the subscription holder of the partition. |
SUBSCRIPTION_HOLDER_ADDRESS_LINE_2 |
string(4000) |
|
☐ |
Address line 2 of the subscription holder of the partition. |
SUBSCRIPTION_HOLDER_ADDRESS_LINE_3 |
string(4000) |
|
☐ |
Address line 3 of the subscription holder of the partition. |
SUBSCRIPTION_HOLDER_CITY |
string(4000) |
|
☐ |
City of the subscription holder of the partition. |
SUBSCRIPTION_HOLDER_COC_NUMBER |
string(4000) |
|
☐ |
CoC number of the subscription holder of the partition. |
SUBSCRIPTION_HOLDER_CODE |
string(4000) |
Owner Company Code |
☐ |
Code of the subscription holder of the partition. |
SUBSCRIPTION_HOLDER_COUNTRY |
string(4000) |
|
☐ |
Country of the subscription holder of the partition. |
SUBSCRIPTION_HOLDER_EMAIL_ADDRESS |
string(4000) |
|
☐ |
Email address of the subscription holder of the partition. |
SUBSCRIPTION_HOLDER_GUID |
guid |
Owner Company GUID |
☐ |
Unique GUID of the subscription holder of the partition. |
SUBSCRIPTION_HOLDER_ID |
string(4000) |
Owner Company ID |
☐ |
Unique ID of the subscription holder of the partition. |
SUBSCRIPTION_HOLDER_LEGAL_FORM |
string(4000) |
|
☐ |
Legal form of the subscription holder of the partition. |
SUBSCRIPTION_HOLDER_NAME |
string(4000) |
Owner Company Name |
☐ |
Name of the subscription holder of the partition. |
SUBSCRIPTION_HOLDER_PHONE |
string(4000) |
|
☐ |
Phone number of the subscription holder of the partition. |
SUBSCRIPTION_HOLDER_SBI_CODE |
string(4000) |
|
☐ |
SBI code of the subscription holder of the partition. |
SUBSCRIPTION_HOLDER_VAT_NUMBER |
string(4000) |
|
☐ |
VAT number of the subscription holder of the partition. |
SUBSCRIPTION_HOLDER_WEB_SITE |
string(4000) |
|
☐ |
Website of the subscription holder of the partition. |
SUBSCRIPTION_HOLDER_ZIP_CODE |
string(4000) |
|
☐ |
ZIP code of the subscription holder of the partition. |
17-05-2021 11:57 Version 20.1.419-BETA+3191