DCPROTOCOLPRINTEDCOPYNEW - Add printed copy data

This import template allows adding:

• Printed copy data.

To insert 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	Code of the system for which the integration will be performed: 73 - Code of the SoftExpert Document component.
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	X¹	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	X²	NUMERIC	1	Addressee type: 1 - Copy station; 2 - Organizational unit; 3 - User.
NMFIELD15	X	TEXT	50	Default control team ID #.
NMFIELD16	X³	TEXT	50	Organizational unit ID #
NMFIELD17	X⁴	TEXT	50	User ID.
DSFIELD01		TEXT	4000	Comments.

info

Notes:

• X¹ - Required when NMFIELD14 is equal to 1;
• X² - Required when NMFIELD02 is equal to 1.
• X³ - Required when NMFIELD14 is equal to 2;
• X⁴ - Required when NMFIELD14 is equal to 3.

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');