What columns are needed?

The table below illustrates the critical columns needed for each section when being updated:

	Item Structure (Parent)	Component (Child)	Substitutes (Child)	Reference Designator (Child)
Structure Upload Action	○
Organization Name	○	○	○	○
Item Number	○	○	○	○
Structure Name	○	○	○	○
Component Upload Action		○
Component Item Number		○	○	○
Start Date		○
From Unit (unit effective structure only)		○
Substitute Upload Action			○
Substitute Item Number			○
Reference Designator Upload Action				○
Reference Designator				○

Item Structure (Parent)

Component (Child)

Substitutes (Child)

Reference Designator (Child)

Structure Upload Action

○

Organization Name

○

Item Number

○

Structure Name

○

Component Upload Action

○

Component Item Number

○

Start Date

○

From Unit
(unit effective structure only)

○

Substitute Upload Action

○

Substitute Item Number

○

Reference Designator Upload Action

○

Reference Designator

○

To elaborate on the table above:

For ALL updates, the ‘Organization Name’, ‘Item Number’ and ‘Structure Name’ are required.
When updating the corresponding sections in the table, the indicated columns must contain a value for the record to be updated.
An action column is only required in sections that are intending to be uploaded.