This import template enables to add:
▪Printed copy data.
To add each of these items, the standard documented below must be followed.
Insert - DIINTERFACE
|
Column
|
Required
|
Type
|
Precision
|
Description
|
OIDINTERFACE
|
X
|
TEXT
|
32
|
Sequential code - Identifies an item to be imported into SoftExpert Suite.
|
FGIMPORT
|
X
|
NUMERIC
|
2
|
Import status:
1 – New;
2 – In progress;
3 – Finished;
4 – Error.
|
CDISOSYSTEM
|
X
|
NUMERIC
|
10
|
System code where the integration will be performed to:
73 - Code of component SoftExpert Document.
|
FGOPTION
|
X
|
NUMERIC
|
2
|
Code of the operation to be performed:
56 – Create copy protocol.
|
NMFIELD01
|
X
|
TEXT
|
50
|
Protocol ID #.
|
NMFIELD02
|
X
|
TEXT
|
1
|
Copy type:
1 – controlled;
2 – uncontrolled.
|
NMFIELD03
|
|
TEXT
|
10
|
Issue date (if it is not entered, the current date will be considered). The date format must be Y-M-D (Year-Month-Day).
|
NMFIELD04
|
|
TEXT
|
50
|
Distribution reason ID #.
|
NMFIELD05
|
X
|
TEXT
|
50
|
Issuer's ID.
|
NMFIELD06
|
X1
|
TEXT
|
50
|
Copy station ID #.
|
NMFIELD07
|
|
TEXT
|
50
|
ID of the user responsible for the station.
|
NMFIELD08
|
|
TEXT
|
255
|
Company.
|
NMFIELD09
|
|
TEXT
|
255
|
Company's responsible party.
|
NMFIELD10
|
X
|
TEXT
|
1
|
Protocol status:
1 – Awaiting receipt confirmation;
2 – Receipt confirmed.
|
NMFIELD11
|
|
TEXT
|
50
|
ID of the user responsible for receiving (if it is not entered, and STATUS is 2, RESPONSIBLE will be considered)
|
NMFIELD12
|
|
TEXT
|
10
|
Receiving date (if it is not entered, and STATUS is 2, the current date will be considered). The date format
must be "Y-M-D" (Year-Month-Day).
|
NMFIELD14
|
X2
|
NUMERIC
|
1
|
Addressee type:
1 - Copy station;
2 – Organizational unit;
3 - User.
|
NMFIELD15
|
X
|
TEXT
|
50
|
Default control team ID #.
|
NMFIELD16
|
X3
|
TEXT
|
50
|
Organizational unit ID #.
|
NMFIELD17
|
X4
|
TEXT
|
50
|
User ID #.
|
DSFIELD01
|
|
TEXT
|
4000
|
Comments.
|
Example of the "Edit copy station" function:
INSERT INTO DIINTERFACE (OIDINTERFACE, FGIMPORT, CDISOSYSTEM, FGOPTION, NMFIELD01, NMFIELD02, NMFIELD03, NMFIELD04, NMFIELD05, NMFIELD06, NMFIELD07, NMFIELD08, NMFIELD09, NMFIELD10, NMFIELD11, NMFIELD12, DSFIELD01) VALUES (1, 1, 73, 56, ' ProtocolID', ' Copytype', ' Date', ' ReasonID', ' Responsible', 'CopyStationID', 'Copystationresp', 'Company', 'Companyresp', 'Status', 'Receivingresp', 'Receivingdate', 'Observation');
|
For the list of documents, the DIINTERFACEDETAIL table must be used, referencing the parent record in the DIINTERFACE table, as specified below:
Insert - DIINTERFACEDETAIL
|
Column
|
Required
|
Type
|
Precision
|
Description
|
OIDINTERFACEDETAIL
|
X
|
TEXT
|
32
|
Registry key
Oracle: DBMS_RANDOM.STRING('x',32) or SYS_GUID()
|
OIDINTERFACE
|
X
|
TEXT
|
32
|
DIINTERFACE table registry key
|
NMFIELD01
|
X
|
TEXT
|
50
|
Document ID #.
|
NMFIELD02
|
|
TEXT
|
50
|
Revision ID # (controlled copy: must be blank; uncontrolled copy: if it is not entered, the current revision will be considered).
|
NMFIELD03
|
|
TEXT
|
50
|
Document category ID # (required when there is more than one document with the same ID # in different categories).
|
NMFIELD04
|
X
|
NUMERIC
|
10
|
Number of copies.
|
Example of the document list function:
INSERT INTO DIINTERFACEDETAIL (OIDINTERFACEDETAIL, OIDINTERFACE, NMFIELD01, NMFIELD02, NMFIELD03, NMFIELD04) VALUES (1, 1, 'DocumentID', 'RevisionID', 'CategoryID', 'QtdCopy');
|
|