Skip to main content
Version: 2.2.2

STMTRANSFEROBJECT - Transfer event object import

This import template allows inserting:

  • Transfer event objects.

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:
15 - Add transfer event.
NMFIELD01XTEXT255Transfer event ID #.
NMFIELD02XTEXT255Object ID #.
NMFIELD03XTEXT255Source storage place ID #.
NMFIELD04XTEXT255Quantity.
NMFIELD05TEXT255Lot number.
NMFIELD06TEXT255Serial number.
NMFIELD07TEXT255Expiration date. The date format must be Y-M-D (Year-Month-Day).
DSFIELD01TEXT4000Attribute 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, DSFIELD01) VALUES (1, 1, 180, 15, 'TransferEventId', 'ObjectId', 'StoragePlaceId', 'Amount', 'LotNumber', 'SerialNumber', 'ValidityDate', 'Attributes');