Tags per partitions for all active data containers.
Catalog: DataDictionary
Schema: Invantive
Alias: ptg
Label: System Partition Tags
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 SYSTEMPARTITIONTAGS are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
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. |
PTN_ALLOW_WRITE |
boolean |
Partition Allow Write |
☑ |
Whether the partition allows writes. |
PTN_CODE |
string(240) |
Partition Code |
☑ |
Unique code of the partition. |
PTN_COMPANY_ADDRESS |
string(4000) |
Partition Company Address |
☐ |
Address of the company of the partition. |
PTN_COMPANY_CITY |
string(4000) |
Partition Company City |
☐ |
City of the company of the partition. |
PTN_COMPANY_COC_NUMBER |
string(4000) |
Partition Company CoC Number |
☐ |
Chamber of Commerce number of the company of the partition. |
PTN_COMPANY_COUNTRY |
string(4000) |
Partition Company Country |
☐ |
Country of the company of the partition. |
PTN_COMPANY_EMAIL_ADDRESS |
string(4000) |
Partition Company Email Address |
☐ |
Email address of the company of the partition. |
PTN_COMPANY_IBAN_NUMBER |
string(4000) |
Company IBAN Number |
☐ |
IBAN number of the company of the partition. |
PTN_COMPANY_NAME |
string(4000) |
Partition Company Name |
☐ |
Name of the company of the partition. |
PTN_COMPANY_PHONE |
string(4000) |
Partition Company Phone |
☐ |
Phone of the company of the partition. |
PTN_COMPANY_RSIN_NUMBER |
string(4000) |
Company RSIN Number |
☐ |
RSIN number of the company of the partition. |
PTN_COMPANY_STATE |
string(4000) |
Partition Company State |
☐ |
State of the company of the partition. |
PTN_COMPANY_TWITTER_ACCOUNT |
string(4000) |
Partition Company Twitter Account |
☐ |
Twitter account of the company of the partition. |
PTN_COMPANY_VAT_NUMBER |
string(4000) |
Partition Company VAT Number |
☐ |
VAT number of the company of the partition. |
PTN_COMPANY_WAGE_TAX_NUMBER |
string(4000) |
Partition Company Wage Tax Number |
☐ |
Wage tax number of the company of the partition. |
PTN_COMPANY_WEB_SITE |
string(4000) |
Partition Company Web Site |
☐ |
Web site of the company of the partition. |
PTN_COMPANY_ZIP_CODE |
string(4000) |
Partition Company ZIP Code |
☐ |
ZIP-code of the company of the partition. |
PTN_CREATED_UTC |
datetime |
Partition Created |
|
When the partition was created (UTC). |
PTN_DESCRIPTION |
string(4000) |
Partition Description |
☐ |
Description. |
PTN_FIRST_USE_UTC |
datetime |
Partition First Use |
|
When the partition has been used first in this session (UTC). |
PTN_IS_SELECTED_BY_DEFAULT |
boolean |
Partition Selected by Default |
|
Whether the partition is selected by default. |
PTN_IS_SELECTED |
boolean |
Partition Selected |
☑ |
Whether the partition is currently selected. |
PTN_IS_USED |
boolean |
Partition Used |
|
Whether the partition has been used in this session. |
PTN_LABEL |
string(4000) |
Partition Label |
☑ |
Label for use in lists. |
PTN_MASTER_ROLL_UP |
string(4000) |
Partition Master Roll-up |
☐ |
Master roll-up. |
PTN_MODIFIED_UTC |
datetime |
Partition Modified |
|
When the partition was last modified (UTC). |
PTN_NAME |
string(4000) |
Partition Name |
☐ |
Name. |
PTN_ROLL_UP |
string(4000) |
Partition Roll-up |
☐ |
Roll-up. |
PTN_SHORT_NAME |
string(4000) |
Partition Short Name |
☐ |
Short name. |
SEQ_NR |
int32 |
Sequences |
|
Unique sequence number of the tag for the partition. |
TAG_CODE |
string(240) |
Code |
☑ |
Unique code of the partition tag. |
TAG_CREATION_DATE |
datetime |
Creation Date |
|
Date at which the entry was originally created. |
TAG_CREATOR |
string(240) |
Creator |
☐ |
Person that first assigned a value. |
TAG_DOMAIN_CODE |
string(240) |
Domain Code |
☑ |
Domain of the code of the partition tag. |
TAG_TYPE |
string(240) |
Value Type |
☑ |
Type of value of the partition tag. |
TAG_UPDATE_DATE |
datetime |
Update Date |
|
Date at which the entry was last modified. |
TAG_UPDATER |
string(240) |
Updater |
☐ |
Person that last assigned a value. |
TAG_VALUE |
string(240) |
Value |
☐ |
Value of the partition tag. |
17-05-2021 11:57 Version 20.1.419-BETA+3191