Insert/edit/delete company (customer/manufacturer/supplier)
|
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
|
System code where the integration will be performed to:
153 - Code of component SoftExpert Administration.
|
FGOPTION
|
X
|
NUMERIC
|
2
|
Code of the operation to be performed:
17 - Insert company. If it exists, edits the existing record;
18 - Delete company.
|
NMFIELD01
|
X
|
TEXT
|
50
|
Company ID (required field for deletion).
|
NMFIELD02
|
X
|
TEXT
|
255
|
Company name (required field 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
|
Supply company:
1 - Yes;
2 - No.
|
NMFIELD13
|
X
|
TEXT
|
255
|
Manufacturing 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
|
X1
|
TEXT
|
50
|
Customer category ID #.
|
NMFIELD19
|
X2
|
TEXT
|
50
|
Supplier category ID #.
|
