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.
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.
Column | Type | Precision | Description |
---|---|---|---|
OIDINTERFACE | TEXT | 32 | Object identification (primary key). |
CDISOSYSTEM | NUMERIC | 10 | Code of the system for which the import will be performed. |
DTEXECUTION | DATE | - | Date on which the record is imported. |
FGIMPORT | NUMERIC | 10 | Import status. |
FGBLOBOPTION | NUMERIC | 10 | Defines that only the FLFIELD01 field will be used for this import. |
FGOPTION | NUMERIC | 10 | Type of the object to be imported. |
QTHRFINISH | NUMERIC | 10 | End time of the record import (in seconds). |
QTHRINIT | NUMERIC | 10 | Start time of the record import (in seconds). |
DSERROR | TEXT | 4000 | Description of the inconsistency found during the import process. |
NRSEQUENCE | NUMERIC | 10 | Import sequence referring to the scheduling that imported this record. |
NMFIELD01 | TEXT | 255 | Import parameter. |
NMFIELD02 | TEXT | 255 | Import parameter. |
NMFIELD03 | TEXT | 255 | Import parameter. |
NMFIELD04 | TEXT | 255 | Import parameter. |
NMFIELD05 | TEXT | 255 | Import parameter. |
NMFIELD06 | TEXT | 255 | Import parameter. |
NMFIELD07 | TEXT | 255 | Import parameter. |
NMFIELD08 | TEXT | 255 | Import parameter. |
NMFIELD09 | TEXT | 255 | Import parameter. |
NMFIELD10 | TEXT | 255 | Import parameter. |
NMFIELD11 | TEXT | 255 | Import parameter. |
NMFIELD12 | TEXT | 255 | Import parameter. |
NMFIELD13 | TEXT | 255 | Import parameter. |
NMFIELD14 | TEXT | 255 | Import parameter. |
NMFIELD15 | TEXT | 255 | Import parameter. |
NMFIELD16 | TEXT | 255 | Import parameter. |
NMFIELD17 | TEXT | 255 | Import parameter. |
NMFIELD18 | TEXT | 255 | Import parameter. |
NMFIELD19 | TEXT | 255 | Import parameter. |
NMFIELD20 | TEXT | 255 | Import parameter. |
NMFIELD21 | TEXT | 255 | Import parameter. |
NMFIELD22 | TEXT | 255 | Import parameter. |
NMFIELD23 | TEXT | 255 | Import parameter. |
NMFIELD24 | TEXT | 255 | Import parameter. |
NMFIELD25 | TEXT | 255 | Import parameter. |
NMFIELD26 | TEXT | 255 | Import parameter. |
NMFIELD27 | TEXT | 255 | Import parameter. |
NMFIELD28 | TEXT | 255 | Import parameter. |
NMFIELD29 | TEXT | 255 | Import parameter. |
NMFIELD30 | TEXT | 255 | Import parameter. |
NMFIELD31 | TEXT | 255 | Import parameter. |
NMFIELD32 | TEXT | 255 | Import parameter. |
NMFIELD33 | TEXT | 255 | Import parameter. |
NMFIELD34 | TEXT | 255 | Import parameter. |
NMFIELD35 | TEXT | 255 | Import parameter. |
NMFIELD36 | TEXT | 255 | Import parameter. |
NMFIELD37 | TEXT | 255 | Import parameter. |
NMFIELD38 | TEXT | 255 | Import parameter. |
NMFIELD39 | TEXT | 255 | Import parameter. |
NMFIELD40 | TEXT | 255 | Import parameter. |
NMFIELD41 | TEXT | 255 | Import parameter. |
NMFIELD42 | TEXT | 255 | Import parameter. |
NMFIELD43 | TEXT | 255 | Import parameter. |
NMFIELD44 | TEXT | 255 | Import parameter. |
NMFIELD45 | TEXT | 255 | Import parameter. |
NMFIELD46 | TEXT | 255 | Import parameter. |
NMFIELD47 | TEXT | 255 | Import parameter. |
NMFIELD48 | TEXT | 255 | Import parameter. |
NMFIELD49 | TEXT | 255 | Import parameter. |
NMFIELD50 | TEXT | 255 | Import parameter. |
NMFIELD51 | TEXT | 255 | Import parameter. |
NMFIELD52 | TEXT | 255 | Import parameter. |
NMFIELD53 | TEXT | 255 | Import parameter. |
NMFIELD54 | TEXT | 255 | Import parameter. |
NMFIELD55 | TEXT | 255 | Import parameter. |
NMFIELD56 | TEXT | 255 | Import parameter. |
NMFIELD57 | TEXT | 255 | Import parameter. |
NMFIELD58 | TEXT | 255 | Import parameter. |
NMFIELD59 | TEXT | 255 | Import parameter. |
NMFIELD60 | TEXT | 255 | Import parameter. |
NMFIELD61 | TEXT | 255 | Import parameter. |
NMFIELD62 | TEXT | 255 | Import parameter. |
NMFIELD63 | TEXT | 255 | Import parameter. |
NMFIELD64 | TEXT | 255 | Import parameter. |
NMFIELD65 | TEXT | 255 | Import parameter. |
NMFIELD66 | TEXT | 255 | Import parameter. |
NMFIELD67 | TEXT | 255 | Import parameter. |
NMFIELD68 | TEXT | 255 | Import parameter. |
NMFIELD69 | TEXT | 255 | Import parameter. |
NMFIELD70 | TEXT | 255 | Import parameter. |
NMFIELD71 | TEXT | 255 | Import parameter. |
NMFIELD72 | TEXT | 255 | Import parameter. |
NMFIELD73 | TEXT | 255 | Import parameter. |
NMFIELD74 | TEXT | 255 | Import parameter. |
NMFIELD75 | TEXT | 255 | Import parameter. |
NMFIELD76 | TEXT | 255 | Import parameter. |
NMFIELD77 | TEXT | 255 | Import parameter. |
NMFIELD78 | TEXT | 255 | Import parameter. |
NMFIELD79 | TEXT | 255 | Import parameter. |
NMFIELD80 | TEXT | 255 | Import parameter. |
NMFIELD81 | TEXT | 255 | Import parameter. |
NMFIELD82 | TEXT | 255 | Import parameter. |
NMFIELD83 | TEXT | 255 | Import parameter. |
NMFIELD84 | TEXT | 255 | Import parameter. |
NMFIELD85 | TEXT | 255 | Import parameter. |
NMFIELD86 | TEXT | 255 | Import parameter. |
NMFIELD87 | TEXT | 255 | Import parameter. |
NMFIELD88 | TEXT | 255 | Import parameter. |
NMFIELD89 | TEXT | 255 | Import parameter. |
NMFIELD90 | TEXT | 255 | Import parameter. |
NMFIELD91 | TEXT | 255 | Import parameter. |
NMFIELD92 | TEXT | 255 | Import parameter. |
NMFIELD93 | TEXT | 255 | Import parameter. |
NMFIELD94 | TEXT | 255 | Import parameter. |
NMFIELD95 | TEXT | 255 | Import parameter. |
NMFIELD96 | TEXT | 255 | Import parameter. |
NMFIELD97 | TEXT | 255 | Import parameter. |
NMFIELD98 | TEXT | 255 | Import parameter. |
NMFIELD99 | TEXT | 255 | Import parameter. |
NMFIELD100 | TEXT | 255 | Import parameter. |
NMFIELD101 | TEXT | 255 | Import parameter. |
DSFIELD01 | TEXT | 4000 | Import parameter. |
DSFIELD02 | TEXT | 4000 | Import parameter. |
DSFIELD03 | TEXT | 4000 | Import parameter. |
DSFIELD04 | TEXT | 4000 | Import parameter. |
DSFIELD05 | TEXT | 4000 | Import parameter. |
DSFIELD06 | TEXT | 4000 | Import parameter. |
DSFIELD07 | TEXT | 4000 | Import parameter. |
DSFIELD08 | TEXT | 4000 | Import parameter. |
DSFIELD09 | TEXT | 4000 | Import parameter. |
DSFIELD10 | TEXT | 4000 | Import parameter. |
DSFIELD11 | TEXT | 4000 | Import parameter. |
DSFIELD12 | TEXT | 4000 | Import parameter. |
DSFIELD13 | TEXT | 4000 | Import parameter. |
DSFIELD14 | TEXT | 4000 | Import parameter. |
DSFIELD15 | TEXT | 4000 | Import parameter. |
VLFIELD01 | NUMERIC | 28,12 | Import parameter. |
VLFIELD02 | NUMERIC | 28,12 | Import parameter. |
VLFIELD03 | NUMERIC | 28,12 | Import parameter. |
VLFIELD04 | NUMERIC | 28,12 | Import parameter. |
VLFIELD05 | NUMERIC | 28,12 | Import parameter. |
VLFIELD06 | NUMERIC | 28,12 | Import parameter. |
VLFIELD07 | NUMERIC | 28,12 | Import parameter. |
VLFIELD08 | NUMERIC | 28,12 | Import parameter. |
VLFIELD09 | NUMERIC | 28,12 | Import parameter. |
VLFIELD10 | NUMERIC | 28,12 | Import parameter. |
DTFIELD01 | DATE | - | Import parameter. |
DTFIELD02 | DATE | - | Import parameter. |
DTFIELD03 | DATE | - | Import parameter. |
DTFIELD04 | DATE | - | Import parameter. |
DTFIELD05 | DATE | - | Import parameter. |
DTFIELD06 | DATE | - | Import parameter. |
DTFIELD07 | DATE | - | Import parameter. |
DTFIELD08 | DATE | - | Import parameter. |
DTFIELD09 | DATE | - | Import parameter. |
DTFIELD10 | DATE | - | Import parameter. |
BNFIELD01 | NUMERIC | 19 | Import parameter. |
BNFIELD02 | NUMERIC | 19 | Import parameter. |
BNFIELD03 | NUMERIC | 19 | Import parameter. |
BNFIELD04 | NUMERIC | 19 | Import parameter. |
BNFIELD05 | NUMERIC | 19 | Import parameter. |
BNFIELD06 | NUMERIC | 19 | Import parameter. |
BNFIELD07 | NUMERIC | 19 | Import parameter. |
BNFIELD08 | NUMERIC | 19 | Import parameter. |
BNFIELD09 | NUMERIC | 19 | Import parameter. |
BNFIELD10 | NUMERIC | 19 | Import parameter. |
NRFIELD01 | NUMERIC | 10 | Import parameter. |
NRFIELD02 | NUMERIC | 10 | Import parameter. |
NRFIELD03 | NUMERIC | 10 | Import parameter. |
NRFIELD04 | NUMERIC | 10 | Import parameter. |
NRFIELD05 | NUMERIC | 10 | Import parameter. |
NRFIELD06 | NUMERIC | 10 | Import parameter. |
NRFIELD07 | NUMERIC | 10 | Import parameter. |
NRFIELD08 | NUMERIC | 10 | Import parameter. |
NRFIELD09 | NUMERIC | 10 | Import parameter. |
NRFIELD10 | NUMERIC | 10 | Import parameter. |
FLFIELD01 | BLOB | - | Import parameter. |
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.