Skip to main content
Version: 2.2.1

STMTRANSFEREVENTEXECUTE - Transfer event execution

This import template allows executing:

  • Transfer events.

For the insertion of each one of these items, the standard documented below must be followed.

Insert​

ColumnRequiredTypePrecisionDescription
OIDINTERFACEXNUMERIC10Sequential code - Identifies an item to be imported into SoftExpert Suite.
FGIMPORTXNUMERIC2Import status:
1 - New;
2 - In progress;
3 - Finished;
4 - Error.
CDISOSYSTEMXNUMERIC10Code of the system for which the integration will be performed:
180 - Code of the SoftExpert Storeroom component.
FGOPTIONXNUMERIC2Code of the operation to be performed:
18 - Add transfer event.
NMFIELD01XTEXT255Transfer event ID #.

:::

Insertion example:

INSERT INTO DIINTERFACE (OIDINTERFACE, FGIMPORT, CDISOSYSTEM, FGOPTION, NMFIELD01) VALUES (1, 1, 180, 18, 'TransarchivalId');