ADCOM - Company import

This import template allows inserting/editing/deleting:

• Company data (customer/manufacturer/supplier).

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

Insert/edit/delete

Column	Required	Type	Precision	Description
OIDINTERFACE	X	TEXT	32	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 for which the integration will be performed: 153 - Code of the SoftExpert Administration component.
FGOPTION	X	NUMERIC	2	Code of the operation to be performed: 17 - Insert company; if the record exists already, it will be edited. 18 - Delete company.
NMFIELD01	X	TEXT	50	Company ID (field required for deletion).
NMFIELD02	X	TEXT	255	Company name (field required for deletion).
NMFIELD03		TEXT	255	Address.
NMFIELD04		TEXT	255	City.
NMFIELD05		TEXT	50	State.
NMFIELD06		TEXT	255	Country.
NMFIELD07		TEXT	50	Postal code.
NMFIELD08		TEXT	50	Phone #.
NMFIELD09		TEXT	50	Fax #.
NMFIELD10		TEXT	255	Home Page.
NMFIELD11	X	TEXT	255	Customer company: 1 - Yes; 2 - No.
NMFIELD12	X	TEXT	255	Supplier company: 1 - Yes; 2 - No.
NMFIELD13	X	TEXT	255	Manufacturer company: 1 - Yes; 2 - No.
NMFIELD14		TEXT	255	Description.
NMFIELD15		TEXT	50	Company code (E.g.: Corporate taxpayer registry). Note: It has to be a unique value.
NMFIELD16	X	TEXT	50	Company type ID #.
NMFIELD17		TEXT	255	Associate the company with the component. Separate the component codes with “;”. Example: 109;107.
NMFIELD18	X¹	TEXT	50	Customer category ID #.
NMFIELD19	X²	TEXT	50	Supplier category ID #.

info

Note:

• X¹ - Required when NMFIELD11 is 1;
• X² - Required when NMFIELD12 is 1.