invantive documentation
Invantive Support ForumsLog In / Sign Up

SYSTEMDATACONTAINERS: Data Dictionary Datacontainer

read only

  • Catalog: DataDictionary
  • Schema: Invantive
  • Label: Datacontainer

Active data containers.

Can only retrieve data.

Table Columns

The columns of the table SYSTEMDATACONTAINERS 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
ALIAS varchar2(240) Alias Alias of the data container.
CONSUMPTION_LAST_CALL number Consumption Last Call Number of calls or credits the platform charged for its last answer.
DAILY_LIMIT number Daily Limit Number of calls allowed per day.
DAILY_REMAINING number Daily Remaining Number of calls left of the current day.
DAILY_RESET_DATE_UTC datetime Daily Reset Date Utc Moment at which the number of calls allowed per day is replenished.
DAILY_USED number Daily Used Number of calls spent of the current day.
HOURLY_LIMIT number Hourly Limit Number of calls allowed per hour.
HOURLY_REMAINING number Hourly Remaining Number of calls left of the current hour.
HOURLY_RESET_DATE_UTC datetime Hourly Reset Date Utc Moment at which the number of calls allowed per hour is replenished.
ID varchar2(4000) ID Data container ID.
IS_DEFAULT_FLAG char Is Default? Is the default provider?
IS_SERVICE_PROVIDER_FLAG char Is Service Provider? Is the provider a service provider?
LAST_MEASUREMENT_UTC datetime Measurement Utc Moment the platform last stated its rate limit, without which the figures beside it can not be read.
MINUTELY_LIMIT number Minutely Limit Number of calls allowed per minute.
MINUTELY_REMAINING number Minutely Remaining Number of calls left of the current minute.
MINUTELY_RESET_DATE_UTC datetime Minutely Reset Date Utc Moment at which the number of calls allowed per minute is replenished.
PARTITIONS_COUNT int32 Number of Partitions Number of partitions.
PARTITIONS_SELECTED_COUNT int32 Number of Selected Partitions Number of selected partitions.
PROVIDER_DATABASE_POOL_DESCRIPTION varchar2(240) Provider Database Pool Description Pool description of the database.
PROVIDER_DATABASE_PRICING_TIER varchar2(240) Provider Database Pricing Tier Pricing tier of the database.
PROVIDER_DATABASE_SERVICE_TIER varchar2(240) Provider Database Service Tier Service tier of the database.
PROVIDER_DATABASE_VERSION varchar2(240) Provider Database Version Version text of the database.
PROVIDER_DATABASE_VERSION_NUMBER varchar2(240) Provider Database Version Number Version number of the database.
PROVIDER_DESCRIPTION varchar2(16000) Provider Description Description of the provider.
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 Short name of the provider.
SECONDLY_LIMIT number Secondly Limit Number of calls allowed per second.
SECONDLY_REMAINING number Secondly Remaining Number of calls left of the current second.
SECONDLY_RESET_DATE_UTC datetime Secondly Reset Date Utc Moment at which the number of calls allowed per second is replenished.
SESSION_TIME_UTC_OFFSET_SECONDS int32 UTC Session Time Offset (sec) UTC session offset (seconds).
UI_LANGUAGE_CODE varchar2(30) UI Language Code User interface language code.
USER_COGNITO_USER_ID varchar2(240) Cognito User ID Identifier of the user in the Invantive Cloud user administration.
USER_COMPANY_ADDRESS_LINE_1 varchar2(240) User Company Address Line 1 Address line 1 of the company of the user.
USER_COMPANY_ADDRESS_LINE_2 varchar2(240) User Company Address Line 2 Address line 2 of the company of the user.
USER_COMPANY_ADDRESS_LINE_3 varchar2(240) User Company Address Line 3 Address line 3 of the company of the user.
USER_COMPANY_BIC varchar2(4000) Company BIC BIC of the company of the user.
USER_COMPANY_CITY varchar2(240) User Company City City of the company of the user.
USER_COMPANY_COC_NUMBER varchar2(240) User Company CoC Number CoC number of the company of the user.
USER_COMPANY_COUNTRY varchar2(4000) Company Country Country of the company of the user.
USER_COMPANY_CURRENCY_CODE varchar2(240) Company Currency Code Currency code of the company of the user.
USER_COMPANY_DATE_ESTABLISHED date User Company Established Date established of the company of the user.
USER_COMPANY_EMAIL_ADDRESS varchar2(240) User Company Email Address Email address of the company of the user.
USER_COMPANY_EMPLOYEES int32 User Company Employees Number of employees of the company of the user.
USER_COMPANY_GLN_NUMBER varchar2(240) Company GLN Number GLN number of the company of the user.
USER_COMPANY_IBAN varchar2(4000) Company IBAN IBAN of the company of the user.
USER_COMPANY_ID varchar2(4000) User Company ID Unique ID of the company of the user.
USER_COMPANY_LEGAL_STRUCTURE varchar2(240) User Company Legal Structure Legal structure of the company of the user.
USER_COMPANY_NAME varchar2(4000) User Company Name Name of the company of the user.
USER_COMPANY_PAYPAL_IDENTIFIER varchar2(240) User Company PayPal Identifier PayPal identifier of the company of the user.
USER_COMPANY_PHONE varchar2(4000) User Company Phone Phone of the company of the user.
USER_COMPANY_POSTAL_CODE varchar2(4000) Company ZIP Code ZIP-code of the company of the user.
USER_COMPANY_RSIN_NUMBER varchar2(240) User Company RSIN Number RSIN number of the company of the user.
USER_COMPANY_SIRET_NUMBER varchar2(240) User Company SIRET Number SIRET number of the company of the user.
USER_COMPANY_STATE varchar2(4000) Company State State of the company of the user.
USER_COMPANY_TRADENAMES varchar2(240) User Company Tradenames Tradenames of the company of the user.
USER_COMPANY_VAT_NUMBER varchar2(240) User Company VAT Number VAT number of the company of the user.
USER_COMPANY_WAGE_TAX_NUMBER varchar2(240) Company Wage Tax Number Wage tax number of the company of the user.
USER_COMPANY_WEB_SITE varchar2(4000) User Company Website Web site of the company of the user.
USER_EMAIL_ADDRESS varchar2(240) User Email Address User email address.
USER_FIRST_NAME varchar2(240) User First Name User first name.
USER_GENDER varchar2(30) User Gender User gender.
USER_ID varchar2(240) User ID User ID.
USER_LANGUAGE varchar2(240) User Language User language; the same value as the user language code.
USER_LANGUAGE_CODE varchar2(240) User Language Code User language code.
USER_LAST_LOGON datetime User Last Logon User last logon.
USER_LAST_NAME varchar2(240) User Last Name User last name.
USER_LINKED_IN_ACCOUNT varchar2(240) User LinkedIn Account User LinkedIn account URL.
USER_LOG_ON_CODE varchar2(240) User Log On Code User log on code.
USER_MIDDLE_NAME varchar2(240) User Middle Name User middle name.
USER_MOBILE_NUMBER varchar2(240) User Mobile Number User mobile number.
USER_NAME varchar2(240) User Name User name.
USER_NAME_AND_COMPANY varchar2(240) User Name and Company User name and company name.
USER_NATIONALITY varchar2(240) User Nationality User nationality.
USER_PHONE_NUMBER varchar2(240) User Phone Number User phone number.
USER_PICTURE_BLOB blob User Picture (BLOB) User picture as BLOB.
USER_PICTURE_MIME_TYPE varchar2(240) User Picture MIME Type User picture MIME type.
USER_PICTURE_URL varchar2(4000) User Picture (URL) User picture URL.
USER_SKYPE_ACCOUNT varchar2(240) User Skype Account User Skype account.
USER_TITLE varchar2(240) User Title User titlet.
USER_TWITTER_ACCOUNT varchar2(240) User Twitter Account User Twitter account.
USER_WEBSITE_URL varchar2(240) User Website User website URL.

Keys

Key Column Refers to Kind Description
SYSTEMDATACONTAINERS_PROVIDER_NAME_SYSTEMPROVIDERS_fk PROVIDER_NAME SYSTEMPROVIDERS.NAME Key

Referenced By

Release Notes

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