Navigation:  Integration via database >

Interface data template

 Previous  Top  Next

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.