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	TEXT	32	Primary key - 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_attribute1 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');