| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAerospace Defence Industry Solution |
| 1 | ORFCALC | Data Record ORF Calculation, ATTENTION: MOVE-CORR! | 6 | EIM | End Item Manufacturer Code | nvarchar | 5 | 0 | | |
| TOPProvisioning |
| 2 | ADS2KIPBRO_CMD | SPEC 2000 IP: Key fields for master data creation | 7 | EIM | End Item Manufacturer Code | nvarchar | 5 | 0 | | |
| 3 | SPCIPCSN | Locations | 6 | EIM | End Item Manufacturer Code | nvarchar | 5 | 0 | | |
| 4 | SPCIPOSC | SPEC2000: Stores optional suppliers for the subject SPL | 5 | EIM | End Item Manufacturer Code | nvarchar | 5 | 0 | | |
| 5 | SPCIPOSC_D | SPEC2000: Stores deleted entries for SPCIPOSC | 5 | EIM | End Item Manufacturer Code | nvarchar | 5 | 0 | | |
| 6 | SPCIPPARTS | Other parts that can be used | 6 | EIM | End Item Manufacturer Code | nvarchar | 5 | 0 | | |
| 7 | SPCIPPDR | Spare parts / End items | 6 | EIM | End Item Manufacturer Code | nvarchar | 5 | 0 | | |
| 8 | SPCIPRPDE | Replacing Parts / Replaced Parts | 6 | EIM | End Item Manufacturer Code | nvarchar | 5 | 0 | | |
| 9 | SPCIPSPLMNT | SPEC2000: Stores Additional/Long/MultipleOccurance fields | 9 | EIM | End Item Manufacturer Code | nvarchar | 5 | 0 | | |
| 10 | SPCIPUOA | Used On Assemblies | 6 | EIM | End Item Manufacturer Code | nvarchar | 5 | 0 | | |
