invantive documentation
Invantive Support ForumsLog In / Sign Up

SYSTEMPARTITIONS: Data Dictionary Partitions

read only

  • Catalog: DataDictionary
  • Schema: Invantive
  • Label: Partitions

Partitions for all active data containers.

Can only retrieve data.

Table Columns

The columns of the table SYSTEMPARTITIONS are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
ALLOW_WRITE char Allow Write Whether the partition allows writes.
CODE varchar2(240) Code Unique code of the partition.
COMPANY_ADDRESS varchar2(4000) Company Address Address of the company of the partition.
COMPANY_ADDRESS_LINE_2 varchar2(4000) Company Address Line 2 Second address line of the company of the partition.
COMPANY_ADDRESS_LINE_3 varchar2(4000) Company Address Line 3 Third address line of the company of the partition.
COMPANY_BIC varchar2(4000) Company BIC BIC of the bank account of the company of the partition.
COMPANY_CITY varchar2(4000) Company City City of the company of the partition.
COMPANY_COC_NUMBER varchar2(4000) Company Chamber of Commerce Number Chamber of Commerce number of the company of the partition.
COMPANY_COUNTRY varchar2(4000) Company Country Country of the company of the partition.
COMPANY_CURRENCY_CODE varchar2(4000) Company Currency Code Code of the currency the company of the partition keeps its books in.
COMPANY_EMAIL_ADDRESS varchar2(4000) Company Email Address Email address of the company of the partition.
COMPANY_GLN_NUMBER varchar2(4000) Company GLN Number Global Location Number (GLN) of the company of the partition.
COMPANY_IBAN_NUMBER varchar2(4000) Company IBAN Number IBAN number of the company of the partition.
COMPANY_ID varchar2(4000) Company ID Identifier of the company of the partition on the platform.
COMPANY_LEGAL_FORM varchar2(4000) Company Legal Form Legal form of the company of the partition, such as a private limited company.
COMPANY_NAME varchar2(4000) Company Name Name of the company of the partition.
COMPANY_PAYPAL_IDENTIFIER varchar2(4000) Company PayPal Identifier PayPal account of the company of the partition.
COMPANY_PHONE varchar2(4000) Company Phone Phone of the company of the partition.
COMPANY_POSTAL_CODE varchar2(4000) Company ZIP Code ZIP-code of the company of the partition.
COMPANY_RSIN_NUMBER varchar2(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 varchar2(4000) Company State State of the company of the partition.
COMPANY_TRADENAMES varchar2(4000) Company Trade Names Trade names of the company of the partition.
COMPANY_TWITTER_ACCOUNT varchar2(4000) Company Twitter Account Twitter account of the company of the partition.
COMPANY_VAT_NUMBER varchar2(4000) Company VAT Number VAT number of the company of the partition.
COMPANY_WAGE_TAX_NUMBER varchar2(4000) Company Wage Tax Number Wage tax number of the company of the partition.
COMPANY_WEB_SITE varchar2(4000) Company Web Site Web site of the company of the partition.
CONSUMPTION_LAST_CALL int64 Consumption Last Call fetched only when named
CREATED_UTC datetime Created When the partition was created (UTC).
DAILY_LIMIT int64 Maximum Calls per Day fetched only when named
DAILY_REMAINING int64 Remaining Calls Today fetched only when named
DAILY_RESET_DATE_UTC datetime Reset Time fetched only when named
DAILY_USED int64 Calls Made Today fetched only when named
DESCRIPTION varchar2(4000) Description Description.
FIRST_DAILY_REMAINING int64 First Remaining Calls fetched only when named
FIRST_MEASUREMENT_UTC datetime First Measurement Moment fetched only when named
FIRST_MINUTELY_REMAINING int64 First Remaining Calls per Minute fetched only when named
FIRST_USE_UTC datetime First Use When the partition has been used first in this session (UTC).
INSTANCE_UID guid Instance UID Unique ID of the instance.
IS_ACTIVE char Active Whether the partition is active.
IS_ARCHIVED char Archived Whether the partition is archived.
IS_SELECTED char Selected Whether the partition is currently selected.
IS_SELECTED_BY_DEFAULT char Selected by Default Whether the partition is selected by default.
IS_USED char Used Whether the partition has been used in this session.
LABEL varchar2(4000) Label Label for use in lists.
LAST_MEASUREMENT_UTC datetime Measurement Moment fetched only when named
LAST_UPDATE_REMOTE_CORRELATION_IDS varchar2(1024) Last Update Remote Correlation IDs Request ID.
LAST_UPDATE_REQUEST_ID varchar2(60) Last Updated Request ID Request ID.
MASTER_ROLL_UP varchar2(4000) Master Roll-up Master roll-up.
MINUTELY_LIMIT int64 Maximum Remaining Calls per Minute fetched only when named
MINUTELY_REMAINING int64 Remaining Calls per Minute fetched only when named
MINUTELY_RESET_DATE_UTC datetime Reset Time per Minute fetched only when named
MODIFIED_UTC datetime Modified When the partition was last modified (UTC).
NAME varchar2(4000) Name Name.
PREVIOUS_DAILY_REMAINING int64 Previous Remaining Calls fetched only when named
PREVIOUS_DAY_DAILY_REMAINING int64 Previous Day Remaining Calls fetched only when named
PREVIOUS_DAY_DAILY_TIMESTAMP_UTC datetime Previous Day Timestamp fetched only when named
PREVIOUS_HOUR_DAILY_REMAINING int64 Previous Hour Remaining Calls fetched only when named
PREVIOUS_HOUR_DAILY_TIMESTAMP_UTC datetime Previous Hour Timestamp fetched only when named
PREVIOUS_MEASUREMENT_UTC datetime Previous Measurement Moment fetched only when named
PREVIOUS_MINUTELY_REMAINING int64 Previous Remaining Calls per Minute fetched only when named
PREVIOUS_MINUTE_DAILY_REMAINING int64 Previous Minute Remaining Calls fetched only when named
PREVIOUS_MINUTE_DAILY_TIMESTAMP_UTC datetime Previous Minute Timestamp fetched only when named
PROVIDER_DATA_CONTAINER_ALIAS varchar2(4000) Data Container Alias Data container alias.
PROVIDER_DATA_CONTAINER_ID varchar2(4000) Data Container ID Data container ID.
PROVIDER_DESCRIPTION varchar2(16000) Provider Description Provider description.
PROVIDER_INSTANCE_UID guid Provider Instance UID Unique ID of the provider instance.
PROVIDER_NAME varchar2(240) Provider Name Name of the provider.
PROVIDER_SHORT_NAME varchar2(240) Provider Short Name Provider short name.
ROLL_UP varchar2(4000) Roll-up Roll-up.
SELECTED_LAST_MODIFIED_UTC datetime Selected Last Modified (UTC) When the partition selection was last modified (UTC).
SELECTED_LAST_SET_UTC datetime Selected Last Set (UTC) When the partition selection was last set (UTC).
SELECTED_LAST_UNSET_UTC datetime Selected Last Unset (UTC) When the partition selection was last unset (UTC).
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 double I/O Execution Duration Other (ms) Total duration for other in milliseconds.
SESSION_IO_DURATION_MS_OVERALL double I/O Execution Duration (ms) Total duration overall in milliseconds.
SESSION_IO_DURATION_MS_READ double I/O Execution Duration Read (ms) Total duration for read in milliseconds.
SESSION_IO_DURATION_MS_WRITE double 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 varchar2(4000) Short Name Short name.
SUBSCRIPTION_HOLDER_ADDRESS_LINE_1 varchar2(4000) Company Address Line 1 Address line 1 of the subscription holder of the partition.
SUBSCRIPTION_HOLDER_ADDRESS_LINE_2 varchar2(4000) Company Address Line 2 Address line 2 of the subscription holder of the partition.
SUBSCRIPTION_HOLDER_ADDRESS_LINE_3 varchar2(4000) Company Address Line 3 Address line 3 of the subscription holder of the partition.
SUBSCRIPTION_HOLDER_BIC varchar2(4000) Subscription Holder BIC BIC of the bank account of the subscription holder of the partition.
SUBSCRIPTION_HOLDER_CITY varchar2(4000) Company City City of the subscription holder of the partition.
SUBSCRIPTION_HOLDER_COC_NUMBER varchar2(4000) Company CoC Number CoC number of the subscription holder of the partition.
SUBSCRIPTION_HOLDER_CODE varchar2(4000) Owner Company Code Code of the subscription holder of the partition.
SUBSCRIPTION_HOLDER_COUNTRY varchar2(4000) Company Country Country of the subscription holder of the partition.
SUBSCRIPTION_HOLDER_CURRENCY_CODE varchar2(4000) Subscription Holder Currency Code Code of the currency the subscription holder of the partition keeps its books in.
SUBSCRIPTION_HOLDER_EMAIL_ADDRESS varchar2(4000) Company Email Address Email address of the subscription holder of the partition.
SUBSCRIPTION_HOLDER_GLN_NUMBER varchar2(4000) Subscription Holder GLN Number Global Location Number (GLN) 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_IBAN_NUMBER varchar2(4000) Subscription Holder IBAN Number IBAN of the bank account of the subscription holder of the partition.
SUBSCRIPTION_HOLDER_ID varchar2(4000) Owner Company ID Unique ID of the subscription holder of the partition.
SUBSCRIPTION_HOLDER_LEGAL_FORM varchar2(4000) Company Legal Form Legal form of the subscription holder of the partition.
SUBSCRIPTION_HOLDER_NAME varchar2(4000) Owner Company Name Name of the subscription holder of the partition.
SUBSCRIPTION_HOLDER_PAYPAL_IDENTIFIER varchar2(4000) Subscription Holder PayPal Identifier PayPal account of the subscription holder of the partition.
SUBSCRIPTION_HOLDER_PHONE varchar2(4000) Company Phone Phone number of the subscription holder of the partition.
SUBSCRIPTION_HOLDER_POSTAL_CODE varchar2(4000) Company ZIP Code Postal code of the subscription holder of the partition.
SUBSCRIPTION_HOLDER_RSIN_NUMBER varchar2(4000) Subscription Holder RSIN Number RSIN of the subscription holder of the partition, the Dutch number for legal entities.
SUBSCRIPTION_HOLDER_SBI_CODE varchar2(4000) Company SBI Code SBI code of the subscription holder of the partition.
SUBSCRIPTION_HOLDER_SIRET_NUMBER varchar2(4000) Subscription Holder SIRET Number SIRET number of the subscription holder of the partition, the French number for business locations.
SUBSCRIPTION_HOLDER_VAT_NUMBER varchar2(4000) Company VAT Number VAT number of the subscription holder of the partition.
SUBSCRIPTION_HOLDER_WAGE_TAX_NUMBER varchar2(4000) Subscription Holder Wage Tax Number Wage tax number of the subscription holder of the partition.
SUBSCRIPTION_HOLDER_WEB_SITE varchar2(4000) Company Website Website of the subscription holder of the partition.
UPDATE_COUNT int64 Update Count fetched only when named
UPDATE_WITH_CHANGE_COUNT int64 Update with Change Count fetched only when named

Keys

Key Column Refers to Kind Description
SYSTEMPARTITIONS_PROVIDER_INSTANCE_UID_SYSTEMDATACONTAINERS_fk PROVIDER_INSTANCE_UID SYSTEMDATACONTAINERS.PROVIDER_INSTANCE_UID Key

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: