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