SYSTEMDATACONTAINERS: Data Dictionary Datacontainer
read only
- Catalogus:
DataDictionary - Schema:
Invantive - Label: Datacontainer
Active data containers.
Kan alleen gegevens ophalen.
Tabelkolommen
De kolommen van de tabel SYSTEMDATACONTAINERS worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.
| Name | Datatype | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
ALIAS |
varchar2 |
Alias | Alias of the data container. | ||
CONSUMPTION_ |
number |
Verbruik Laatste Aanroep | Number of calls or credits the platform charged for its last answer. | ||
DAILY_ |
number |
Dagelijkse limiet | Number of calls allowed per day. | ||
DAILY_ |
number |
Dagelijks resterend | Number of calls left of the current day. | ||
DAILY_ |
datetime |
Dagelijkse resetdatum (UTC) | Moment at which the number of calls allowed per day is replenished. | ||
DAILY_ |
number |
Dagelijks in gebruik | Number of calls spent of the current day. | ||
HOURLY_ |
number |
Uurlimiet | Number of calls allowed per hour. | ||
HOURLY_ |
number |
Resterende uren | Number of calls left of the current hour. | ||
HOURLY_ |
datetime |
Datum voor het resetten per uur (UTC) | Moment at which the number of calls allowed per hour is replenished. | ||
ID |
varchar2 |
ID | Data container ID. | ||
IS_ |
char |
Is Standaard? | Is the default provider? | ||
IS_ |
char |
Is Service Provider? | Is the provider a service provider? | ||
LAST_ |
datetime |
Meting UTC | Moment the platform last stated its rate limit, without which the figures beside it can not be read. | ||
MINUTELY_ |
number |
Minutielimiet | Number of calls allowed per minute. | ||
MINUTELY_ |
number |
Resterende minuten | Number of calls left of the current minute. | ||
MINUTELY_ |
datetime |
Datum UTC tot op de minuut nauwkeurig resetten | Moment at which the number of calls allowed per minute is replenished. | ||
PARTITIONS_ |
int32 |
Aantal Partities | Number of partitions. | ||
PARTITIONS_ |
int32 |
Aantal Geselecteerde Partities | Number of selected partitions. | ||
PROVIDER_ |
varchar2 |
Provider Database Poolomschrijving | Pool description of the database. | ||
PROVIDER_ |
varchar2 |
Provider Database Prijsstellingslaag | Pricing tier of the database. | ||
PROVIDER_ |
varchar2 |
Provider Database Dienstenlaag | Service tier of the database. | ||
PROVIDER_ |
varchar2 |
Provider Database Versie | Version text of the database. | ||
PROVIDER_ |
varchar2 |
Versienummer van de Providerdatabase | Version number of the database. | ||
PROVIDER_ |
varchar2 |
Provideromschrijving | Description of the provider. | ||
PROVIDER_ |
guid |
Providerinstantie UID | Unique ID of the provider instance. | ||
PROVIDER_ |
varchar2 |
Providernaam | Name of the provider. | ||
PROVIDER_ |
varchar2 |
Provider Korte Naam | Short name of the provider. | ||
SECONDLY_ |
number |
Ten tweede: Beperking | Number of calls allowed per second. | ||
SECONDLY_ |
number |
Ten tweede: wat overblijft | Number of calls left of the current second. | ||
SECONDLY_ |
datetime |
Ten tweede: de UTC-datum opnieuw instellen | Moment at which the number of calls allowed per second is replenished. | ||
SESSION_ |
int32 |
UTC Sessietijdverschil (sec) | UTC session offset (seconds). | ||
UI_ |
varchar2 |
UI Taalcode | User interface language code. | ||
USER_ |
varchar2 |
Cognito Gebruikers-ID | Identifier of the user in the Invantive Cloud user administration. | ||
USER_ |
varchar2 |
Gebruiker Bedrijf Adresregel 1 | Address line 1 of the company of the user. | ||
USER_ |
varchar2 |
Gebruiker Bedrijf Adresregel 2 | Address line 2 of the company of the user. | ||
USER_ |
varchar2 |
Gebruiker Bedrijf Adresregel 3 | Address line 3 of the company of the user. | ||
USER_ |
varchar2 |
Bedrijf BIC | BIC of the company of the user. | ||
USER_ |
varchar2 |
Gebruiker Bedrijf Stad | City of the company of the user. | ||
USER_ |
varchar2 |
Gebruiker Bedrijf KvK-nummer | CoC number of the company of the user. | ||
USER_ |
varchar2 |
Bedrijf Land | Country of the company of the user. | ||
USER_ |
varchar2 |
Bedrijf Valutacode | Currency code of the company of the user. | ||
USER_ |
date |
Gebruiker Bedrijf Opgericht | Date established of the company of the user. | ||
USER_ |
varchar2 |
Gebruiker Bedrijf E-mailadres | Email address of the company of the user. | ||
USER_ |
int32 |
Gebruiker Bedrijf Medewerkers | Number of employees of the company of the user. | ||
USER_ |
varchar2 |
Bedrijf GLN-nummer | GLN number of the company of the user. | ||
USER_ |
varchar2 |
Bedrijf IBAN | IBAN of the company of the user. | ||
USER_ |
varchar2 |
Gebruiker Bedrijfs-ID | Unique ID of the company of the user. | ||
USER_ |
varchar2 |
Gebruiker Bedrijf Juridische Structuur | Legal structure of the company of the user. | ||
USER_ |
varchar2 |
Gebruiker Bedrijfsnaam | Name of the company of the user. | ||
USER_ |
varchar2 |
Gebruiker Bedrijf PayPal-ID | PayPal identifier of the company of the user. | ||
USER_ |
varchar2 |
Gebruikerbedrijfstelefoonnummer | Phone of the company of the user. | ||
USER_ |
varchar2 |
Bedrijf Postcode | ZIP-code of the company of the user. | ||
USER_ |
varchar2 |
Gebruikersbedrijf RSIN-nummer | RSIN number of the company of the user. | ||
USER_ |
varchar2 |
SIRET-nummer Gebruiker | SIRET number of the company of the user. | ||
USER_ |
varchar2 |
Bedrijf Staat | State of the company of the user. | ||
USER_ |
varchar2 |
Gebruiker Bedrijf Handelsnamen | Tradenames of the company of the user. | ||
USER_ |
varchar2 |
BTW-nummer Gebruiker | VAT number of the company of the user. | ||
USER_ |
varchar2 |
Bedrijf Loonbelastingnummer | Wage tax number of the company of the user. | ||
USER_ |
varchar2 |
Gebruiker Bedrijfswebsite | Web site of the company of the user. | ||
USER_ |
varchar2 |
Gebruiker E-mailadres | User email address. | ||
USER_ |
varchar2 |
Gebruiker Voornaam | User first name. | ||
USER_ |
varchar2 |
Geslacht Gebruiker | User gender. | ||
USER_ |
varchar2 |
Gebruikers-ID | User ID. | ||
USER_ |
varchar2 |
Gebruikstaal | User language; the same value as the user language code. | ||
USER_ |
varchar2 |
Gebruikerstaalcode | User language code. | ||
USER_ |
datetime |
Laatste Aanmelding Gebruiker | User last logon. | ||
USER_ |
varchar2 |
Gebruiker Achternaam | User last name. | ||
USER_ |
varchar2 |
Gebruikers LinkedIn-account | User LinkedIn account URL. | ||
USER_ |
varchar2 |
Gebruiker Aanmeldcode | User log on code. | ||
USER_ |
varchar2 |
Tweede Naam Gebruiker | User middle name. | ||
USER_ |
varchar2 |
Gebruiker Mobiel Nummer | User mobile number. | ||
USER_ |
varchar2 |
Gebruikersnaam | User name. | ||
USER_ |
varchar2 |
Gebruikersnaam en Bedrijf | User name and company name. | ||
USER_ |
varchar2 |
Gebruikersnationaliteit | User nationality. | ||
USER_ |
varchar2 |
Gebruiker Telefoonnummer | User phone number. | ||
USER_ |
blob |
Gebruikersfoto (BLOB) | User picture as BLOB. | ||
USER_ |
varchar2 |
Gebruikersafbeelding MIME-type | User picture MIME type. | ||
USER_ |
varchar2 |
Gebruikersfoto (URL) | User picture URL. | ||
USER_ |
varchar2 |
Gebruiker Skype-account | User Skype account. | ||
USER_ |
varchar2 |
Gebruikerstitel | User titlet. | ||
USER_ |
varchar2 |
Gebruiker Twitter-account | User Twitter account. | ||
USER_ |
varchar2 |
Gebruikerswebsite | User website URL. |
Toetsen
| Key | Column | Verwijst naar | Kind | Description |
|---|---|---|---|---|
SYSTEMDATACONTAINERS_ |
PROVIDER_ |
SYSTEMPROVIDERS.NAME |
Key |
Geciteerd door
- SESSIONIOS
PROVIDER_INSTANCE_UID(Textual) - SESSIONROWSCHANGED
PROVIDER_INSTANCE_UID(Textual) - SYSTEMCATALOGS
PROVIDER_INSTANCE_UID(Key) - SYSTEMDATACONTAINERATTRIBUTES
PROVIDER_INSTANCE_UID(Key) - SYSTEMDATACONTAINERHTTPCACHECONTENTS
PROVIDER_INSTANCE_UID(Key) - SYSTEMDATACONTAINERMESSAGES
PROVIDER_INSTANCE_UID(Key) - SYSTEMDATACONTAINERPROPERTIES
PROVIDER_INSTANCE_UID(Key) - SYSTEMDATACONTAINERRESERVEDWORDS
PROVIDER_INSTANCE_UID(Key) - SYSTEMDATACONTAINERSLOTBASEDRATELIMITERS
PROVIDER_INSTANCE_UID(Key) - SYSTEMDATACONTAINERSLOTBASEDRATELIMITERSLOTS
PROVIDER_INSTANCE_UID(Key) - SYSTEMDOMAINCODES
PROVIDER_INSTANCE_UID(Key) - SYSTEMDOMAINCODEVALUES
PROVIDER_INSTANCE_UID(Key) - SYSTEMFILTERTOTABLEFUNCTIONPARAMETERS
PROVIDER_INSTANCE_UID(Key) - SYSTEMLICENSES
PROVIDER_INSTANCE_UID(Key) - SYSTEMOAUTHFLOWEVENTS
PROVIDER_INSTANCE_UID(Key) - SYSTEMPACKAGEFUNCTIONARGUMENTS
PROVIDER_INSTANCE_UID(Key) - SYSTEMPACKAGEFUNCTIONS
PROVIDER_INSTANCE_UID(Key) - SYSTEMPACKAGES
PROVIDER_INSTANCE_UID(Key) - SYSTEMPARTITIONS
PROVIDER_INSTANCE_UID(Key) - SYSTEMPARTITIONSTATISTICS
PROVIDER_INSTANCE_UID(Key) - SYSTEMPARTITIONTAGS
PROVIDER_INSTANCE_UID(Key) - SYSTEMPROVIDERSACTIVE
PROVIDER_INSTANCE_UID(Key) - SYSTEMSCHEMAS
PROVIDER_INSTANCE_UID(Key) - SYSTEMTABLECOLUMNS
PROVIDER_INSTANCE_UID(Key) - SYSTEMTABLEFOREIGNKEYS
PROVIDER_INSTANCE_UID(Key) - SYSTEMTABLEFUNCTIONPARAMETERS
PROVIDER_INSTANCE_UID(Key) - SYSTEMTABLEKEYS
PROVIDER_INSTANCE_UID(Key) - SYSTEMTABLES
PROVIDER_INSTANCE_UID(Key) - SYSTEMVIEWS
PROVIDER_INSTANCE_UID(Key)
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: