Create a Format Map for Bill of Material Import Files

Use Format Mapping Maintenance (XMAP) to specify the format of files to be imported, mapping imported data elements to their counterparts in PowerShift files.

The fields required for successful import are the same as those required if you were creating a record using Product Structure Maintenance (MPS).

If the import file does not include a unit of measure, quantity per is assumed to be in the component's stocking unit of measure. If the import file includes the UOM and it differs from the component item's stocking unit, the imported quantity per is converted based on the unit conversion established in Unit of Measure Codes Maintenance (TUM).
If the effective date is not imported, it is set to 01/01/1900.
If the expiration date is not imported, it is set to 12/31/9999.
Only valid inventory item numbers are processed: If the parent does not exist in the inventory file, all records for that parent are skipped. If an imported bill includes a component that does not exist in the inventory file, the component is skipped while valid component item numbers are processed.

Your PowerShift Support Representative can provide a sample format that you can adjust to work with the bill of material data you want to import.

The program displays:

Field Name	Displays
Format no	The order type
Description	The description of the format
Type	Mapping type: B: Banking C: Bill of Material or custom M: Manifest
Type	File type: O: Output (i.e., for export) I: Input (i.e., for import)) D: Data import (CSV file)

Choose the appropriate options:

To	Do This
Add a format number	Click Add.
Delete the selected number	Click Delete. See Delete.
Copy the selected format	Click Copy. See Copy.
Display the selected format	Click Select or double click the line.
Print the format number listing	Click Print. See Print.
Exit the program	Click Exit.

Enter/review data in these fields:

Field Name	Type / Max Length	Action / Description
Description	Required 35 alphanumeric	Enter the description for the file.
Mapping type	Required 1 alpha	Select Custom to map a file for importing bills of material.
Type	Conditional 1 alpha	Select I for input mapping.
Output file name	Conditional 50 or 8 maximum alphanumeric	Enter M1BOM for bill of material imports.
File type	Conditional 1 alpha	Select D for a sequential file.
Record length	Optional 999 numeric	Enter the maximum length of the record.
Key size	Optional 999 numeric	Enter zero.
Output directory	Optional 3 alphanumeric	Enter a directory for the output file.
File seq size	Conditional 9999999 numeric	Not used.
Delimiter	Optional 1 alphanumeric	Enter the field delimiter. The system does not validate the delimiter. Good delimiter choices are \| (pipe character) and ; (semicolon). You should not choose a character that is likely to appear in your data, such as these numeric symbols: [, (, ), -, %,], or these special characters: ), @, #.
Update program	Required	Enter MPSX.
Log report	Required	Enter ELBOM.

Choose the appropriate options:

To	Do This
Change a field	Move the cursor to the field and make changes. Click Apply to accept or click Cancel to abandon changes.
Delete a saved record	Click Delete. See Delete.
Enter file layout specification	Click Layout. See Enter Mapping File Layout.
Accept the data	Click OK. The program returns to the Format number field if this was a newly added format; it returns to the list of formats if you viewed or maintained an existing one.