| 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! | 2 | SQNBR | Sequence Number | nvarchar | 5 | 0 | | |
| TOPProvisioning |
| 2 | ADS2KIPBRO_CMD | SPEC 2000 IP: Key fields for master data creation | 3 | SQNBR | Sequence Number | nvarchar | 5 | 0 | | |
| 3 | SPCIPCSN | Locations | 2 | SQNBR | Sequence Number | nvarchar | 5 | 0 | | |
| 4 | SPCIPEFF | Effectivity Range | 2 | SQNBR | Sequence Number | nvarchar | 5 | 0 | | |
| 5 | SPCIPHDR | Stores header information for IP data | 3 | SQNBR | Sequence Number | nvarchar | 5 | 0 | | |
| 6 | SPCIPHDRT | Texts for SPCIPHDR - for every SQNBR | 2 | SQNBR | Sequence Number | nvarchar | 5 | 0 | | |
| 7 | SPCIPOCH | Other Charges - Code & Amount | 2 | SQNBR | Sequence Number | nvarchar | 5 | 0 | | |
| 8 | SPCIPOSDS | Optional Suppliers and Distributors | 2 | SQNBR | Sequence Number | nvarchar | 5 | 0 | | |
| 9 | SPCIPPARTS | Other parts that can be used | 2 | SQNBR | Sequence Number | nvarchar | 5 | 0 | | |
| 10 | SPCIPPDR | Spare parts / End items | 2 | SQNBR | Sequence Number | nvarchar | 5 | 0 | | |
| 11 | SPCIPPDS | SPEC2000: Procurement Data Segment | 2 | SQNBR | Sequence Number | nvarchar | 5 | 0 | | |
| 12 | SPCIPPQA | Price Break - Quantity & Amount | 2 | SQNBR | Sequence Number | nvarchar | 5 | 0 | | |
| 13 | SPCIPRPDE | Replacing Parts / Replaced Parts | 2 | SQNBR | Sequence Number | nvarchar | 5 | 0 | | |
| 14 | SPCIPUOA | Used On Assemblies | 2 | SQNBR | Sequence Number | nvarchar | 5 | 0 | | |
