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