Skip to main content
Version: 2.2.2

ITCUST - Item x Customer association import

This import template allows inserting/editing/deleting:

▪Item and customer association data.

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

Insert/edit/delete association between item and customers

ColumnRequiredTypePrecisionDescription
OIDINTERFACEXTEXT32Sequential 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 for which the integration will be performed:
107 - Code of the SoftExpert PDM component.
FGOPTIONXNUMERIC2Code of the operation to be performed:
5 - Insert/edit customer association with items;
;6 - Delete customer association with items.
NMFIELD01TEXT255Item ID #.
NMFIELD02TEXT255Customer company ID.
NMFIELD03TEXT255Customer company name.
NMFIELD04TEXT255Customer item #.
NMFIELD05TEXT255Customer revision #.
NMFIELD06TEXT255Customer drawing #.
NMFIELD07TEXT255Customer drawing date.
NMFIELD10X⁴TEXT255Company code.
NMFIELD11TEXT2551 - Defines that the customer is preferential.
2 - Defines that the customer is NOT preferential.
For insertion, in case of blank value or any other value different from 1, the record will be non-preferential.
For editing, if a blank value or any other value different from 1 and 2 is entered, the field will not be changed, it will keep the value previously set.
info

Note:

  • X¹ - Field required for deletion.
  • X² - Field required if “Company code” is empty (also valid for deletion).
  • X³ - Field required if “Company code” is empty (also valid for deletion).
  • X⁴ - Field required if “Company ID” and/or “Company name” are empty (also valid for deletion).