| 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! | 5 | EIP | End Item Part Number | nvarchar | 15 | 0 | | |
| TOPProvisioning |
| 2 | ADS2KIPBRO_CMD | SPEC 2000 IP: Key fields for master data creation | 6 | EIP | End Item Part Number | nvarchar | 15 | 0 | | |
| 3 | SPCIPCSN | Locations | 5 | EIP | End Item Part Number | nvarchar | 15 | 0 | | |
| 4 | SPCIPOSC | SPEC2000: Stores optional suppliers for the subject SPL | 4 | EIP | End Item Part Number | nvarchar | 15 | 0 | | |
| 5 | SPCIPOSC_D | SPEC2000: Stores deleted entries for SPCIPOSC | 4 | EIP | End Item Part Number | nvarchar | 15 | 0 | | |
| 6 | SPCIPPARTS | Other parts that can be used | 5 | EIP | End Item Part Number | nvarchar | 15 | 0 | | |
| 7 | SPCIPPDR | Spare parts / End items | 5 | EIP | End Item Part Number | nvarchar | 15 | 0 | | |
| 8 | SPCIPRPDE | Replacing Parts / Replaced Parts | 5 | EIP | End Item Part Number | nvarchar | 15 | 0 | | |
| 9 | SPCIPSPLMNT | SPEC2000: Stores Additional/Long/MultipleOccurance fields | 8 | EIP | End Item Part Number | nvarchar | 15 | 0 | | |
| 10 | SPCIPUOA | Used On Assemblies | 5 | EIP | End Item Part Number | nvarchar | 15 | 0 | | |
