We currently have a table in our data structure responsible for receiving data from third-party systems and making them available to the interfaces published in our system.
The DIINTERFACE table adheres to all available features related to the theme. This table has one difference, its primary key. Basically, the OIDINTERFACE field (text field with 32 positions) replaces the CDINTERFACE field (numeric and sequential) that exists in ADINTERFACE (which will be discontinued).
In short, third-party information systems are responsible for data insertion and search in these tables. See below the drawing with the specifications of each field in each of the tables in question.
DIINTERFACE
|
Column
|
Type
|
Precision
|
Description
|
OIDINTERFACE
|
TEXT
|
32
|
Object identification (primary key).
|
CDISOSYSTEM
|
NUMERIC
|
10
|
Code of the system which the import will be performed into.
|
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 (seconds).
|
QTHRINIT
|
NUMERIC
|
10
|
Start time of the record import (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 importing spreadsheets into the CM015 menu, the OIDINTERFACE field is automatically filled out by the system. The manual completion of the field is only necessary if you wish to import records directly through DML scripts into the database. |
Both CDISOSYSTEM and FGOPTION, as well as the other fields related to the imports already published in SoftExpert Suite, will be described in detail in the subsequent chapters. Each of these published imports has a different quantity of data, both of required and complementary data.
|