Skip to main content
Version: 2.2.0

INSUPP - Supply X supplier association import

This import template allows inserting/editing/deleting:

  • Supply and supplier association data.

To insert/edit/delete each of these items, the standard documented below must be followed.

Insert

ColumnRequiredTypePrecisionDescription
NRSEQUENCEXNUMERIC10Sequential 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 in which the integration will be performed:
149 - Code of the SoftExpert Supply component.
FGOPTIONXNUMERIC2Code of the operation to be performed:
9 - Insert/edit supply x supplier association.
10 - Delete supply x supplier association.
NMFIELD01XTEXT255Supply ID #
NMFIELD02TEXT255Customer company ID.
NMFIELD03TEXT255Supplier company name.
NMFIELD04XTEXT255Supply reference in the supplier.
NMFIELD05XTEXT255Supply description in the supplier.
NMFIELD06TEXT255Cost.
NMFIELD07TEXT255Supplier ID #.
NMFIELD08TEXT2551 - Defines that the supplier is preferential.
2 - Defines that it is NOT preferential.
For insertion, if the field is left blank, or is filled with any value other than 1, the record will be nonpreferential.
For editing, if the field is left blank, or is filled with any value other than 1 and 2, it will not be changed, keeping the value previously set.
info

Note:

  • X¹ - Field required if “Supplier ID #” is empty; valid also for deletion.
  • X² - Field required if “Company ID” and/or “Company name” are empty; valid also for deletion.

Example of insertion/editing/deletion of supply and supplier association>:

INSERT INTO DIINTERFACE (OIDINTERFACE, FGIMPORT, CDISOSYSTEM, FGOPTION, NMFIELD01, NMFIELD02, NMFIELD03, NMFIELD04, NMFIELD05, NMFIELD06, NMFIELD08) VALUES (replace(cast (uuid_in(md5(random()::text || clock_timestamp()::text)::cstring) as text),'-',''), 1, 149, 9, ‘INS01’, ‘SoftExpert’, ‘SOFTEXPERT SOFTWARE S.A., ‘SE EAM’, ‘Asset management’, 79800, 1);
INSERT INTO DIINTERFACE (OIDINTERFACE, FGIMPORT,CDISOSYSTEM, FGOPTION, NMFIELD01, NMFIELD04, NMFIELD05, NMFIELD06, NMFIELD07, NMFIELD08) VALUES (replace(cast (uuid_in(md5(random()::text || clock_timestamp()::text)::cstring) as text),'-',''), 1, 149, 9, ‘INS01’, ‘SE EAM’, ‘Asset management’, 79800, 111, 1);
INSERT INTO DIINTERFACE (OIDINTERFACE, FGIMPORT, CDISOSYSTEM, FGOPTION, NMFIELD01, NMFIELD02, NMFIELD03, NMFIELD04) VALUES (replace(cast (uuid_in(md5(random()::text || clock_timestamp()::text)::cstring) as text),'-',''), ‘INS01’, ‘SE EAM’, ‘Asset management’);