![]() |
In a spreadsheet, all discrete values (a value that must be one of few fixed values) must be entered as an internal value, not the display value. For example, for the Default Unit attribute, use as_needed (internal), not As Needed (display).
|
Column Name
|
Required
|
Editable on reimport
|
Description
|
||
Action
|
Yes
|
Yes (for deleting)
|
Actions include Add or Delete.
|
||
Level
|
Yes
|
The level of the component in the part structure hierarchy. For example if part_1 had children part_2 and part_3, and part_3 had a child part_4, the level for each part is specified as follows:
• for part_1, level is 0
• for part_2, level is 1
• for part_3, level is 1
• for part_4, level is 2
|
|||
Number
|
Yes
|
No
|
The part number.
|
||
Trace Code
|
Yes
|
Yes
|
The trace code value on the part usage link. Use the following values:
• untraced: 0
• serial number: S
• lot number: L
• lot/serial number: X
|
||
OrganizationID
|
No
|
No
|
The owning organization for the component part. The default value is the organization from the owning container.
|
||
Container
|
No
|
No
|
The default value of the container from which the import tool was launched.
The following example shows the full path to the container:
/wt.inf.container.OrgContainer=PTC/wt.pdmlink.PDMLinkProduct=Test_Product
where PTC is the name of the organization and the Test_Product is the name of the product.
|
||
Revision
|
No
|
No
|
Specifies which revision of the parent part is getting updated.
|
||
View
|
Yes
|
No
|
Specifies which view of the structure is getting updated. Enter Design or Manufacturing. If you have created a customized view using the View Administrator, it can also be listed as the value.
|
||
Quantity
|
No
|
Yes
|
Defines the number of parts in the assembly. The default value is 1.
|
||
Unit of Measure
|
No
|
Yes
|
Quantity unit for the parts in the assembly. The default value is ea. Other possible values are as follows:
• as needed: as_needed
• kilograms: kg
• meters: m
• liters: l
• square meters: sq_m
• cubic meters: cu_m
|
||
Reference Designators
|
No
|
Yes (but it must be unique)
|
Reference designators specified using shorthand format (for example: R1, R3, or R1-R10).
Use the following syntax rules for specifying reference designators:
• A reference designator consists of an alphanumeric string prefix, followed by a numeric integer suffix. For example: R57, PS1, A66A2.
• The first and last characters in the prefix must be alpha characters. For example: R1, RAX3, R4X5.
• Use a comma to separate sequences of reference designators. For example, R1, R2, R7.
• Reference designators can be specified as a sequence and as a range. For example: R1-R7, R10, R12.
|
||
Type
|
Yes
|
No
|
For the wt.part usage link, set the value to wt.part.WTPartUsageLink.
For the soft typed part usage link, provide either an external form of the type (for example, wt.part.WTPartUsageLink|com.ptc.MyUsageLink) or its logical identifier.
|
||
Component Reference
|
No
|
Alias for the component.
|
|||
Quantity Option (for configurable parts
|
No
|
Yes
|
Integer value parameter in the parent generic part's logic base that controls the quantity of this component.
|
||
Inclusion Option (for configurable parts)
|
No
|
Yes
|
Boolean value parameter in the parent generic part's logic base that controls the inclusion or exclusion of this component.
|
||
Line Number)
|
No
|
Yes
|
Identifies the line number of this part within a manufacturing Bill of Materials. Also known as position numbers that are used with Enterprise Resource Planning systems.
|