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
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 | Code of the system in which the integration will be performed: 149 - Code of the SoftExpert Supply component. |
FGOPTION | X | NUMERIC | 2 | Code of the operation to be performed: 9 - Insert/edit supply x supplier association. 10 - Delete supply x supplier association. |
NMFIELD01 | X | TEXT | 255 | Supply ID # |
NMFIELD02 | X¹ | TEXT | 255 | Customer company ID. |
NMFIELD03 | X¹ | TEXT | 255 | Supplier company name. |
NMFIELD04 | X | TEXT | 255 | Supply reference in the supplier. |
NMFIELD05 | X | TEXT | 255 | Supply description in the supplier. |
NMFIELD06 | TEXT | 255 | Cost. | |
NMFIELD07 | X² | TEXT | 255 | Supplier ID #. |
NMFIELD08 | TEXT | 255 | 1 - 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’);