STMTRANSFEREVENT - Transfer event import
This import template allows inserting:
- Transfer events.
For the insertion of each one of these items, the standard documented below must be followed.
Insertā
Column | Required | Type | Precision | Description |
---|---|---|---|---|
OIDINTERFACE | X | NUMERIC | 10 | 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: 180 - Code of the SoftExpert Storeroom component. |
FGOPTION | X | NUMERIC | 2 | Code of the operation to be performed: 14 - Add transfer event. |
NMFIELD01 | X | TEXT | 255 | Transfer event ID #. |
NMFIELD02 | X | TEXT | 255 | Source storeroom ID #. |
NMFIELD03 | TEXT | 255 | Source responsibility ID #. | |
NMFIELD04 | TEXT | 255 | Source date. | |
NMFIELD05 | X | TEXT | 255 | Destination storeroom ID #. |
NMFIELD06 | TEXT | 255 | Destination responsibility ID #. | |
NMFIELD07 | TEXT | 255 | Destination date. | |
NMFIELD08 | TEXT | 255 | Approval route ID #. | |
DSFIELD01 | TEXT | 255 | Event description. | |
DSFIELD02 | TEXT | 4000 | Attribute value. Information required if the attribute value is of the MEMO type. Example: identifier_of_attribute1=value_of_attribute1 ; identifier_of_attribute2=value_of_attribute2 ; identifier_of_attribute3=value_of_attribute3 .Example with a multivalued attribute: identifier_of_attribute1=value1_of_attribute1 , value2_of_attribute1 , value3_of_attibute1 Note: For attributes with a numeric value, the decimal place separator must be ".". For date fields, the value must have the āY-M-Dā (Year-Month-Day) format. |
:::
Insertion example:
INSERT INTO DIINTERFACE (OIDINTERFACE, FGIMPORT, CDISOSYSTEM, FGOPTION, NMFIELD01, NMFIELD02, NMFIELD03, NMFIELD04, NMFIELD05, NMFIELD06, NMFIELD07, NMFIELD08, DSFIELD01, DSFIELD02) VALUES (1, 1, 180, 14, 'TransferEventId', 'IdStoreroomFrom', 'IdResponsibleFrom', 'DateFrom', 'IdStoreroomTo', 'IdResponsibleTo', 'DateTo', 'IdentifierRouteApprov', 'Description', 'Attributes');