Skip to main content
Version: 2.2.0

Interface data template

The DIINTERFACE table in our data structure is responsible for receiving data from third-party systems and making it available to the interfaces published in our system.

info

The DIINTERFACE table is compatible with all resources related to the theme.

However, this table has a difference in relation to ADINTERFACE: its primary key. The OIDINTERFACE field (a 32-character text field) replaces the CDINTERFACE field (a sequential number) present in the ADINTERFACE table, which will be discontinued.

In short, third-party information systems are responsible for inserting and fetching data in this table.

Below is a drawing with the specifications of each field in the DIINTERFACE table.

ColumnTypePrecisionDescription
OIDINTERFACETEXT32Object identification (primary key).
CDISOSYSTEMNUMERIC10Code of the system for which the import will be performed.
DTEXECUTIONDATE-Date on which the record is imported.
FGIMPORTNUMERIC10Import status.
FGBLOBOPTIONNUMERIC10Defines that only the FLFIELD01 field will be used for this import.
FGOPTIONNUMERIC10Type of the object to be imported.
QTHRFINISHNUMERIC10End time of the record import (in seconds).
QTHRINITNUMERIC10Start time of the record import (in seconds).
DSERRORTEXT4000Description of the inconsistency found during the import process.
NRSEQUENCENUMERIC10Import sequence referring to the scheduling that imported this record.
NMFIELD01TEXT255Import parameter.
NMFIELD02TEXT255Import parameter.
NMFIELD03TEXT255Import parameter.
NMFIELD04TEXT255Import parameter.
NMFIELD05TEXT255Import parameter.
NMFIELD06TEXT255Import parameter.
NMFIELD07TEXT255Import parameter.
NMFIELD08TEXT255Import parameter.
NMFIELD09TEXT255Import parameter.
NMFIELD10TEXT255Import parameter.
NMFIELD11TEXT255Import parameter.
NMFIELD12TEXT255Import parameter.
NMFIELD13TEXT255Import parameter.
NMFIELD14TEXT255Import parameter.
NMFIELD15TEXT255Import parameter.
NMFIELD16TEXT255Import parameter.
NMFIELD17TEXT255Import parameter.
NMFIELD18TEXT255Import parameter.
NMFIELD19TEXT255Import parameter.
NMFIELD20TEXT255Import parameter.
NMFIELD21TEXT255Import parameter.
NMFIELD22TEXT255Import parameter.
NMFIELD23TEXT255Import parameter.
NMFIELD24TEXT255Import parameter.
NMFIELD25TEXT255Import parameter.
NMFIELD26TEXT255Import parameter.
NMFIELD27TEXT255Import parameter.
NMFIELD28TEXT255Import parameter.
NMFIELD29TEXT255Import parameter.
NMFIELD30TEXT255Import parameter.
NMFIELD31TEXT255Import parameter.
NMFIELD32TEXT255Import parameter.
NMFIELD33TEXT255Import parameter.
NMFIELD34TEXT255Import parameter.
NMFIELD35TEXT255Import parameter.
NMFIELD36TEXT255Import parameter.
NMFIELD37TEXT255Import parameter.
NMFIELD38TEXT255Import parameter.
NMFIELD39TEXT255Import parameter.
NMFIELD40TEXT255Import parameter.
NMFIELD41TEXT255Import parameter.
NMFIELD42TEXT255Import parameter.
NMFIELD43TEXT255Import parameter.
NMFIELD44TEXT255Import parameter.
NMFIELD45TEXT255Import parameter.
NMFIELD46TEXT255Import parameter.
NMFIELD47TEXT255Import parameter.
NMFIELD48TEXT255Import parameter.
NMFIELD49TEXT255Import parameter.
NMFIELD50TEXT255Import parameter.
NMFIELD51TEXT255Import parameter.
NMFIELD52TEXT255Import parameter.
NMFIELD53TEXT255Import parameter.
NMFIELD54TEXT255Import parameter.
NMFIELD55TEXT255Import parameter.
NMFIELD56TEXT255Import parameter.
NMFIELD57TEXT255Import parameter.
NMFIELD58TEXT255Import parameter.
NMFIELD59TEXT255Import parameter.
NMFIELD60TEXT255Import parameter.
NMFIELD61TEXT255Import parameter.
NMFIELD62TEXT255Import parameter.
NMFIELD63TEXT255Import parameter.
NMFIELD64TEXT255Import parameter.
NMFIELD65TEXT255Import parameter.
NMFIELD66TEXT255Import parameter.
NMFIELD67TEXT255Import parameter.
NMFIELD68TEXT255Import parameter.
NMFIELD69TEXT255Import parameter.
NMFIELD70TEXT255Import parameter.
NMFIELD71TEXT255Import parameter.
NMFIELD72TEXT255Import parameter.
NMFIELD73TEXT255Import parameter.
NMFIELD74TEXT255Import parameter.
NMFIELD75TEXT255Import parameter.
NMFIELD76TEXT255Import parameter.
NMFIELD77TEXT255Import parameter.
NMFIELD78TEXT255Import parameter.
NMFIELD79TEXT255Import parameter.
NMFIELD80TEXT255Import parameter.
NMFIELD81TEXT255Import parameter.
NMFIELD82TEXT255Import parameter.
NMFIELD83TEXT255Import parameter.
NMFIELD84TEXT255Import parameter.
NMFIELD85TEXT255Import parameter.
NMFIELD86TEXT255Import parameter.
NMFIELD87TEXT255Import parameter.
NMFIELD88TEXT255Import parameter.
NMFIELD89TEXT255Import parameter.
NMFIELD90TEXT255Import parameter.
NMFIELD91TEXT255Import parameter.
NMFIELD92TEXT255Import parameter.
NMFIELD93TEXT255Import parameter.
NMFIELD94TEXT255Import parameter.
NMFIELD95TEXT255Import parameter.
NMFIELD96TEXT255Import parameter.
NMFIELD97TEXT255Import parameter.
NMFIELD98TEXT255Import parameter.
NMFIELD99TEXT255Import parameter.
NMFIELD100TEXT255Import parameter.
NMFIELD101TEXT255Import parameter.
DSFIELD01TEXT4000Import parameter.
DSFIELD02TEXT4000Import parameter.
DSFIELD03TEXT4000Import parameter.
DSFIELD04TEXT4000Import parameter.
DSFIELD05TEXT4000Import parameter.
DSFIELD06TEXT4000Import parameter.
DSFIELD07TEXT4000Import parameter.
DSFIELD08TEXT4000Import parameter.
DSFIELD09TEXT4000Import parameter.
DSFIELD10TEXT4000Import parameter.
DSFIELD11TEXT4000Import parameter.
DSFIELD12TEXT4000Import parameter.
DSFIELD13TEXT4000Import parameter.
DSFIELD14TEXT4000Import parameter.
DSFIELD15TEXT4000Import parameter.
VLFIELD01NUMERIC28,12Import parameter.
VLFIELD02NUMERIC28,12Import parameter.
VLFIELD03NUMERIC28,12Import parameter.
VLFIELD04NUMERIC28,12Import parameter.
VLFIELD05NUMERIC28,12Import parameter.
VLFIELD06NUMERIC28,12Import parameter.
VLFIELD07NUMERIC28,12Import parameter.
VLFIELD08NUMERIC28,12Import parameter.
VLFIELD09NUMERIC28,12Import parameter.
VLFIELD10NUMERIC28,12Import parameter.
DTFIELD01DATE-Import parameter.
DTFIELD02DATE-Import parameter.
DTFIELD03DATE-Import parameter.
DTFIELD04DATE-Import parameter.
DTFIELD05DATE-Import parameter.
DTFIELD06DATE-Import parameter.
DTFIELD07DATE-Import parameter.
DTFIELD08DATE-Import parameter.
DTFIELD09DATE-Import parameter.
DTFIELD10DATE-Import parameter.
BNFIELD01NUMERIC19Import parameter.
BNFIELD02NUMERIC19Import parameter.
BNFIELD03NUMERIC19Import parameter.
BNFIELD04NUMERIC19Import parameter.
BNFIELD05NUMERIC19Import parameter.
BNFIELD06NUMERIC19Import parameter.
BNFIELD07NUMERIC19Import parameter.
BNFIELD08NUMERIC19Import parameter.
BNFIELD09NUMERIC19Import parameter.
BNFIELD10NUMERIC19Import parameter.
NRFIELD01NUMERIC10Import parameter.
NRFIELD02NUMERIC10Import parameter.
NRFIELD03NUMERIC10Import parameter.
NRFIELD04NUMERIC10Import parameter.
NRFIELD05NUMERIC10Import parameter.
NRFIELD06NUMERIC10Import parameter.
NRFIELD07NUMERIC10Import parameter.
NRFIELD08NUMERIC10Import parameter.
NRFIELD09NUMERIC10Import parameter.
NRFIELD10NUMERIC10Import parameter.
FLFIELD01BLOB-Import parameter.
caution

Important!

  • Every record type will be saved in these tables, even after the import or even if there are errors during the import;
  • What distinguishes one record from another is the system code (CDISOSYSTEM) and the import type you intend to execute (FGOPTION);
  • When spreadsheets are imported from the CM015 menu, the OIDINTERFACE field is automatically populated by the system. Manual field completion is only necessary if you want to import records directly through DDL scripts into the database.

Both the CDISOSYSTEM and FGOPTION fields, as well as the other fields related to the import templates already published in SoftExpert Suite, will be described in detail in the Reference section. Each of these published imports has a different quantity of data, including required and complementary data, which are specified individually.

In other words, the import templates may have different requirements in terms of mandatory and optional fields. To better understand the details of each of these fields in relation to each template, the Reference section should be consulted.