invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

SYSTEMMANAGEDFILES: Data Dictionary Managed Files

read only

  • Catalogus: DataDictionary
  • Schema: Invantive
  • Label: Managed Files

Managed files.

Kan alleen gegevens ophalen.

Tabelkolommen

De kolommen van de tabel SYSTEMMANAGEDFILES 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
CREATE_ACTION varchar2(30) Action Action.
CREATE_BILLING_ID varchar2 Factuur ID ID for billing.
CREATE_CALLING_PROVIDER_ALIAS varchar2(240) Aanroepende Provider Alias Calling provider alias.
CREATE_CALL_SAFE_NAME_OVERRULE varchar2 Aanroepveilige Nam (Overschrijven) Overruled name of the table.
CREATE_CATALOG_NAME varchar2 Catalogusnaam Name of the catalog.
CREATE_DATA_CONTAINER_ID varchar2(4000) Datacontainer ID Data container ID.
CREATE_DATE_DO_NOT_REMOVE_BEFORE datetime Verwijder niet voor Time before which not to remove.
CREATE_DATE_REGISTERED datetime Registered Time of registration.
CREATE_EXCEPTION_CODE varchar2 Uitzonderingscode Exception code.
CREATE_EXCEPTION_TEXT varchar2 Text Exception text.
CREATE_EXECUTION_STEP_ID int64 SQL-Uitvoeringsstap-ID ID of the SQL execution step.
CREATE_GUI_ACTION varchar2(240) GUI-actie Action performed within the user interface.
CREATE_GUI_IP_ADDRESS_EXTERNAL varchar2(240) GUI Extern IP-adres External IP address of the GUI application.
CREATE_GUI_IP_PORT uint16 GUI Externe IP-poort External IP port of the GUI application.
CREATE_GUI_MACHINE varchar2(240) GUI-Machine Name of the machine running the GUI application.
CREATE_GUI_MODULE_NAME varchar2(240) GUI-Module Naam Module within the GUI application currently running.
CREATE_GUI_MODULE_VERSION varchar2(240) GUI-Modules Versie Version of module within the GUI application currently running.
CREATE_GUI_OS_USER varchar2(240) GUI-OS-Gebruiker OS user.
CREATE_GUI_USER varchar2(240) User Application user.
CREATE_LIFE_CYCLE_TYPE varchar2(30) Levenscyclustype Life cycle type.
CREATE_MESSAGE_CODE varchar2(30) Type Type.
CREATE_PARTITION varchar2 Partition Specific partition on which the I/O was executed.
CREATE_POOL_IDENTITY varchar2(60) Pool Identiteit Pool identity.
CREATE_PROCESS_ID uint32 Proces-ID Process ID.
CREATE_PROVIDER_NAME varchar2(240) Providernaam Name of the provider.
CREATE_REQUEST_ID varchar2(240) Verzoek ID Request ID.
CREATE_SCHEMA_NAME varchar2 Schema Name of the schema.
CREATE_SESSION_ID varchar2(240) Sessie ID ID of the session.
CREATE_SIZE_BYTES int64 Bytes Size in bytes.
CREATE_SIZE_CHARACTERS int64 Characters Size in characters.
CREATE_TABLE_NAME varchar2 Tabelnaam Name of the table.
CREATE_TYPE varchar2(30) Type Type.
EXISTS_FLAG boolean Bestaat Vlag Whether the file exists.
FILE_NAME varchar2(4000) Bestandsnaam File name and path.
MODIFIED_ACTION varchar2(30) Action Action.
MODIFIED_BILLING_ID varchar2 Factuur ID ID for billing.
MODIFIED_CALLING_PROVIDER_ALIAS varchar2(240) Aanroepende Provider Alias Calling provider alias.
MODIFIED_CALL_SAFE_NAME_OVERRULE varchar2 Aanroepveilige Nam (Overschrijven) Overruled name of the table.
MODIFIED_CATALOG_NAME varchar2 Catalogusnaam Name of the catalog.
MODIFIED_DATA_CONTAINER_ID varchar2(4000) Datacontainer ID Data container ID.
MODIFIED_DATE_DO_NOT_REMOVE_BEFORE datetime Verwijder niet voor Time before which not to remove.
MODIFIED_DATE_REGISTERED datetime Registered Time of registration.
MODIFIED_EXCEPTION_CODE varchar2 Uitzonderingscode Exception code.
MODIFIED_EXCEPTION_TEXT varchar2 Text Exception text.
MODIFIED_EXECUTION_STEP_ID int64 SQL-Uitvoeringsstap-ID ID of the SQL execution step.
MODIFIED_GUI_ACTION varchar2(240) GUI-actie Action performed within the user interface.
MODIFIED_GUI_IP_ADDRESS_EXTERNAL varchar2(240) GUI Extern IP-adres External IP address of the GUI application.
MODIFIED_GUI_IP_PORT uint16 GUI Externe IP-poort External IP port of the GUI application.
MODIFIED_GUI_MACHINE varchar2(240) GUI-Machine Name of the machine running the GUI application.
MODIFIED_GUI_MODULE_NAME varchar2(240) GUI-Module Naam Module within the GUI application currently running.
MODIFIED_GUI_MODULE_VERSION varchar2(240) GUI-Modules Versie Version of module within the GUI application currently running.
MODIFIED_GUI_OS_USER varchar2(240) GUI-OS-Gebruiker OS user.
MODIFIED_GUI_USER varchar2(240) User Application user.
MODIFIED_LIFE_CYCLE_TYPE varchar2(30) Levenscyclustype Life cycle type.
MODIFIED_MESSAGE_CODE varchar2(30) Type Type.
MODIFIED_PARTITION varchar2 Partition Specific partition on which the I/O was executed.
MODIFIED_POOL_IDENTITY varchar2(60) Pool Identiteit Pool identity.
MODIFIED_PROCESS_ID uint32 Proces-ID Process ID.
MODIFIED_PROVIDER_NAME varchar2(240) Providernaam Name of the provider.
MODIFIED_REQUEST_ID varchar2(240) Verzoek ID Request ID.
MODIFIED_SCHEMA_NAME varchar2 Schema Name of the schema.
MODIFIED_SESSION_ID varchar2(240) Sessie ID ID of the session.
MODIFIED_SIZE_BYTES int64 Bytes Size in bytes.
MODIFIED_SIZE_CHARACTERS int64 Characters Size in characters.
MODIFIED_TABLE_NAME varchar2 Tabelnaam Name of the table.
MODIFIED_TYPE varchar2(30) Type Type.
NUMBER_OF_ACTIONS int32 Aantal Acties Number of actions.
NUMBER_OF_DELETES int32 Aantal Verwijderingen Number of deletes.
NUMBER_OF_READS int32 Aantal Leesacties Number of reads.
NUMBER_OF_WRITES int32 Aantal Schrijfacties Number of writes.
TOTAL_DELETE_BYTES int64 Totaal Verwijderde Bytes Total bytes deleted.
TOTAL_DELETE_CHARACTERS int64 Totaal Verwijderde Tekens Total characters deleted.
TOTAL_READ_BYTES int64 Totaal Gelezen Bytes Total bytes read.
TOTAL_READ_CHARACTERS int64 Totaal Gelezen Tekens Total characters read.
TOTAL_WRITE_BYTES int64 Totaal Geschreven Bytes Total bytes written.
TOTAL_WRITE_CHARACTERS int64 Totaal Geschreven Tekens Total characters written.
UID guid UID Unique ID.

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: