Data Management Capabilities > Using Excel to Export and Import Data > About Importing Data from Excel > Considerations for Importing All Data > Considerations for Importing AML/AVL Entries > File Format for Importing AML/AVL Entries
File Format for Importing AML/AVL Entries
The following table describes the format of data in an AML/AVL import spreadsheet. It defines the column header, whether the column is required, and the description of the data that can be entered for each column.
* 
When importing attributes that have units of measure, use the International System of Units.
Column Name
Required
Description
Action
Yes
Actions include Add or Delete.
Container
Yes
The default value is the container from which the import action is initiated.
OEM part number
Yes
The part for which the AML/AVL is created.
OEM container
No
The container where the OEM part resides. If no value is specified, it uses the container organization of the product from where the action is invoked.
* 
The organization of the OEM container and the OEM organization ID can be different.
OEM organization ID
No
The owning organization for the OEM part. If no value is specified, the OEM part is searched in the container organization. The default is the organization from the owning container.
* 
• Always use lower case text.
• The organization of the OEM container and the OEM organization ID can be different.
OEM part revision
No
The default value is the latest version.
OEM part view
Yes
The view of the OEM part being used for importing AML/AVL entries. For example, enter Design or Manufacturing.
Manufacturer part number
Yes
A manufacturer part for the AML.
Manufacturer organization ID
Yes
The owning organization for the manufacturer part (owning organization ID).
Manufacturer part revision
No
The default value is the latest version.
Manufacturer sourcing status
No
The default value is determined using sourcing rules.
Vendor part number
Yes
A vendor part for the AML/AVL (optional).
Vendor organization ID
Yes
The owning organization for the vendor part (owning organization ID).
Vendor part revision
No
The default value is the latest version.
Vendor sourcing status
No
The default value is determined using sourcing rules.
Sourcing context
No
The context must exist in the organization. If no value is specified, the default is used.
* 
This value is case sensitive.
Sourcing context organization
No
The owning organization for the sourcing context.
The following table explains the behavior of adding AML/AVL entry in which sourcing context is defined in a different organization using four scenarios:
Sourcing Context specified
Sourcing Context Organization specified
Behavior
No
No
AML/AVL entry is added under default sourcing context of OEM part organization.
Yes
No
If sourcing context under OEM part organization is found, AML/AVL entry is added under that sourcing context. Otherwise, error is displayed.
No
Yes
AML/AVL entry is added under default sourcing Context of specified sourcing context organization.
Yes
Yes
If sourcing context under specified sourcing context organization is found, AML/AVL is added under that sourcing context. Otherwise, error is displayed.
Was this helpful?