eFactoryPro Wiki

9.1 PME - Import

Updated on

CREATE PART

PropertyTypeAllowed Values
manufacturerstringExisting manufacturer name. Must resolve to an approved, active manufacturer.
manufacturerpartnumberstringManufacturer part number. Max 128. Also drives cleanpartid (alphanumerics only).
brandstringOptional. Brand name under that manufacturer. Must exist, be approved, and be active.
nounstringExisting noun name. Must resolve to an approved, active noun.
modifierstringOptional. Modifier name under that noun. Must exist, be approved, and be active.
externalsystemsstringOptional. Comma-separated names: d365, salesforce, efactorypro. Example: "efactorypro,salesforce". Names must be unique. d365 is added automatically if omitted or missing.
repairablebool?true, false, or omit
descriptionstringMax 128 chars
notesstringMax 1000 chars
unspscstringExactly 6 or 8 digits. Invalid codes fail. Sets commoditygroup / category / subcategory. OPTIONAL.
purchaseuomstringcm, each, ft, gl, kg, lb, liter, mile, m, pallet, yd. Defaults to each if omitted.
issueuomstringSame list as purchaseuom. Defaults to each if omitted.
taxgroupstringMust match an enabled taxgroup configuration value for type part. Must be lower case.
averageleadtimeint?Must be > 0. Defaults to  10 if omitted.

UPDATE PART

PropertyTypesAllowed Values
displayidstringExisting part display ID. This is how import finds the part (id is not used).
manufacturerstringManufacturer name. Same resolution rules as create.
manufacturerpartnumberstringMax 128. If changed, cleanpartid is recalculated. UniversalID and Manufacturer required.
brandstringBrand name under that manufacturer. Must exist, be approved, and be active. UniversalID and Manufacturer required. 
nounstringNoun name. Same resolution rules as create.
modifierstringModifier name under that noun. Noun name required. Must exist, be approved, and be active. UniversalID and Manufacturer required. 
repairablebool?true, false, or omit (omit = leave unchanged)
descriptionstringMax 128 chars
notesstringMax 1000 chars
unspscstring6 or 8 digits. Hierarchy is reapplied if provided.
purchaseuomstringcm, each, ft, gl, kg, lb, liter, mile, m, pallet, yd
issueuomstringSame list as purchaseuom
taxgroupstringMust match an enabled taxgroup configuration value for type part. Must be lower case.
averageleadtimeint?Must be > 0
verifiedbool?Verified must always be "true" or "false".

MANUFACTURER CREATE

PropertyTypeAllowed Values
namestringNew manufacturer name. Required. Max  300. Must not already exist.
approvedbool?true / false
examplesstringMax 300
definitionstringMax 1000
URLstringAny string

MANUFACTURER UPDATE

PropertyTypeAllowed Values
manufacturerstringExisting manufacturer name (lookup). Required.
statusstringactive or removed
approvedbool?Same as create
examplesstringMax 300
definitionstringMax 1000
URLstringAny string

BRAND CREATE

PropertyTypeAllowed Values
manufacturerstringParent manufacturer name. Must exist and be active.
namestringNew brand name. Required. Max 300. Unique under that manufacturer.
approvedbool?true / false /
examplesstringMax 300
definitionstringMax 1000
URLstringAny string

BRAND UPDATE

PropertyTypeAllowed Values
manufacturerstringParent manufacturer name. Must exist and be active.
brandstringExisting brand name under that manufacturer (lookup). Required.
statusstringactive or removed
approvedbool?Same as create
examplesstringMax 300
definitionstringMax 1000
URLstringAny string

NOUN CREATE

PropertyTypeAllowed Values
namestringNew noun name. Required. Max 100. Must not already exist.
approvedbool?true / false /
examplesstringMax 300
definitionstringMax 1000

NOUN UPDATE

PropertyTypeAllowed Values
nounstringExisting noun name (lookup). Required.
statusstringactive or removed
approvedbool?Same as create
examplesstringMax 300
definitionstringMax 1000

MODIFIER CREATE

PropertyTypeAllowed Values
nounstringParent noun name. Must exist and be active.
namestringNew modifier name. Required. Max 100. Unique under that noun.
approvedbool?true / false /
examplesstringMax 300
definitionstringMax 1000
URLstringAny string

MODIFIER UPDATE

PropertyTypeAllowed Values
nounstringParent noun name. Must exist and be active.
modifierstringExisting modifier name under that noun (lookup). Required.
statusstringactive or removed
approvedbool?Same as create
examplesstringMax 300
definitionstringMax 1000
urlstringAny string

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Previous Article 8.6 SBS - When would I run the Open Req_PO Report?
Next Article 9.2 PME - Roles