SYSTEMPARTITIONS: Data Dictionary Partitions |
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 UniversalSQL 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.
View Columns
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_SERVER_MOVE_DATE_UTC |
datetime |
Company Server Move Date (UTC) |
☐ |
Last server move date of the company. |
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. |
CONSUMPTION_LAST_CALL |
int64 |
Consumption Last Call |
☐ |
|
CREATED_UTC |
datetime |
Created |
|
When the partition was created (UTC). |
DAILY_LIMIT |
int64 |
Maximum Calls per Day |
☐ |
|
DAILY_REMAINING |
int64 |
Remaining Calls Today |
☐ |
|
DAILY_RESET_DATE_UTC |
datetime |
Reset Time |
☐ |
|
DAILY_USED |
int64 |
Calls Made Today |
☐ |
|
DESCRIPTION |
string(4000) |
Description |
☐ |
Description. |
FIRST_DAILY_REMAINING |
int64 |
First Remaining Calls |
☐ |
|
FIRST_MEASUREMENT_UTC |
datetime |
First Measurement Moment |
☐ |
|
FIRST_MINUTELY_REMAINING |
int64 |
First Remaining Calls per Minute |
☐ |
|
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. |
LAST_MEASUREMENT_UTC |
datetime |
Measurement Moment |
☐ |
|
MASTER_ROLL_UP |
string(4000) |
Master Roll-up |
☐ |
Master roll-up. |
MINUTELY_LIMIT |
int64 |
Maximum Remaining Calls per Minute |
☐ |
|
MINUTELY_REMAINING |
int64 |
Remaining Calls per Minute |
☐ |
|
MINUTELY_RESET_DATE_UTC |
datetime |
Reset Time per Minute |
☐ |
|
MODIFIED_UTC |
datetime |
Modified |
|
When the partition was last modified (UTC). |
NAME |
string(4000) |
Name |
☐ |
Name. |
PREVIOUS_DAILY_REMAINING |
int64 |
Previous Remaining Calls |
☐ |
|
PREVIOUS_DAY_DAILY_REMAINING |
int64 |
Previous Day Remaining Calls |
☐ |
|
PREVIOUS_DAY_DAILY_TIMESTAMP_UTC |
datetime |
Previous Day Timestamp |
☐ |
|
PREVIOUS_HOUR_DAILY_REMAINING |
int64 |
Previous Hour Remaining Calls |
☐ |
|
PREVIOUS_HOUR_DAILY_TIMESTAMP_UTC |
datetime |
Previous Hour Timestamp |
☐ |
|
PREVIOUS_MEASUREMENT_UTC |
datetime |
Previous Measurement Moment |
☐ |
|
PREVIOUS_MINUTE_DAILY_REMAINING |
int64 |
Previous Minute Remaining Calls |
☐ |
|
PREVIOUS_MINUTE_DAILY_TIMESTAMP_UTC |
datetime |
Previous Minute Timestamp |
☐ |
|
PREVIOUS_MINUTELY_REMAINING |
int64 |
Previous Remaining Calls per Minute |
☐ |
|
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_INSTANCE_UID |
guid |
Provider Instance UID |
☑ |
Unique ID of the provider instance. |
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 |
I/O Execution Bytes Received Other |
☐ |
Number of bytes sent (other). |
SESSION_IO_BYTES_RECEIVED_OVERALL |
int64 |
I/O Execution Bytes Received |
☐ |
Number of bytes sent overall. |
SESSION_IO_BYTES_RECEIVED_READ |
int64 |
I/O Execution Bytes Received Read |
☐ |
Number of bytes sent for read. |
SESSION_IO_BYTES_RECEIVED_WRITE |
int64 |
I/O Execution Bytes Received Write |
☐ |
Number of bytes sent for write. |
SESSION_IO_BYTES_SENT_OTHER |
int64 |
I/O Execution Bytes Sent Other |
☐ |
Number of bytes received (other). |
SESSION_IO_BYTES_SENT_OVERALL |
int64 |
I/O Execution Bytes Sent |
☐ |
Number of bytes received overall. |
SESSION_IO_BYTES_SENT_READ |
int64 |
I/O Execution Bytes Sent Read |
☐ |
Number of bytes received for read. |
SESSION_IO_BYTES_SENT_WRITE |
int64 |
I/O Execution Bytes Sent Write |
☐ |
Number of bytes received for write. |
SESSION_IO_DURATION_MS_OTHER |
int64 |
I/O Execution Duration Other (ms) |
☐ |
Total duration for other in milliseconds. |
SESSION_IO_DURATION_MS_OVERALL |
int64 |
I/O Execution Duration (ms) |
☐ |
Total duration overall in milliseconds. |
SESSION_IO_DURATION_MS_READ |
int64 |
I/O Execution Duration Read (ms) |
☐ |
Total duration for read in milliseconds. |
SESSION_IO_DURATION_MS_WRITE |
int64 |
I/O Execution Duration Write (ms) |
☐ |
Total duration for write in milliseconds. |
SESSION_IO_EXECUTION_COUNT_OTHER |
int64 |
I/O Execution Count Other |
☐ |
Number of I/Os executed (other). |
SESSION_IO_EXECUTION_COUNT_OVERALL |
int64 |
I/O Execution Count |
☐ |
Number of I/Os executed overall. |
SESSION_IO_EXECUTION_COUNT_READ |
int64 |
I/O Execution Count Read |
☐ |
Number of I/Os executed for read. |
SESSION_IO_EXECUTION_COUNT_WRITE |
int64 |
I/O Execution Count Write |
☐ |
Number of I/Os executed for write. |
SHORT_NAME |
string(4000) |
Short Name |
☐ |
Short name. |
SUBSCRIPTION_HOLDER_ADDRESS_LINE_1 |
string(4000) |
Company Address Line 1 |
☐ |
Address line 1 of the subscription holder of the partition. |
SUBSCRIPTION_HOLDER_ADDRESS_LINE_2 |
string(4000) |
Company Address Line 2 |
☐ |
Address line 2 of the subscription holder of the partition. |
SUBSCRIPTION_HOLDER_ADDRESS_LINE_3 |
string(4000) |
Company Address Line 3 |
☐ |
Address line 3 of the subscription holder of the partition. |
SUBSCRIPTION_HOLDER_CITY |
string(4000) |
Company City |
☐ |
City of the subscription holder of the partition. |
SUBSCRIPTION_HOLDER_COC_NUMBER |
string(4000) |
Company CoC Number |
☐ |
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) |
Company Country |
☐ |
Country of the subscription holder of the partition. |
SUBSCRIPTION_HOLDER_EMAIL_ADDRESS |
string(4000) |
Company Email Address |
☐ |
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) |
Company Legal Form |
☐ |
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) |
Company Phone |
☐ |
Phone number of the subscription holder of the partition. |
SUBSCRIPTION_HOLDER_SBI_CODE |
string(4000) |
Company SBI Code |
☐ |
SBI code of the subscription holder of the partition. |
SUBSCRIPTION_HOLDER_VAT_NUMBER |
string(4000) |
Company VAT Number |
☐ |
VAT number of the subscription holder of the partition. |
SUBSCRIPTION_HOLDER_WEB_SITE |
string(4000) |
Company Website |
☐ |
Website of the subscription holder of the partition. |
SUBSCRIPTION_HOLDER_ZIP_CODE |
string(4000) |
Company ZIP Code |
☐ |
ZIP code of the subscription holder of the partition. |
UPDATE_COUNT |
int64 |
Update Count |
☐ |
|
UPDATE_WITH_CHANGE_COUNT |
int64 |
Update with Change Count |
☐ |
|
18-10-2024 06:49 Version 24.0.345-PROD+4945