This import template enables to insert/edit/delete:
▪Data of the association between supply and supplier.
To add/edit/delete each of these items, the standard documented below must be followed.
Insert
|
Column
|
Required
|
Type
|
Precision
|
Description
|
NRSEQUENCE
|
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
|
System code where the integration will be performed to:
149 - Code of component SoftExpert Supply.
|
FGOPTION
|
X
|
NUMERIC
|
2
|
Code of the operation to be performed:
9 – Add/edit the supply x supplier association.
10 – Delete the supply x supplier association.
|
NMFIELD01
|
X
|
TEXT
|
255
|
Supply ID #.
|
NMFIELD02
|
X1
|
TEXT
|
255
|
Supplier company ID.
|
NMFIELD03
|
X1
|
TEXT
|
255
|
Supplier company name.
|
NMFIELD04
|
X
|
TEXT
|
255
|
Supply reference in the supplier.
|
NMFIELD05
|
X
|
TEXT
|
255
|
Description of the supply in the supplier.
|
NMFIELD06
|
|
TEXT
|
255
|
Cost.
|
NMFIELD07
|
X2
|
TEXT
|
255
|
Supplier ID #.
|
NMFIELD08
|
|
TEXT
|
255
|
1 - Defines that the supplier is preferential.
2 - Defines that it is NOT preferential.
When inserting, for a blank value or any other value different from 1, the record will not be preferential.
When editing, if a blank or any other value different from 1 and 2 is entered, the field will not be changed, it will keep the value previously set.
|
Example of insertion/editing/deletion of the association between supply and suppliers:
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’);
|
|