| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | EHPRCD_HMFR | CP: Harmonization Manufacturer/Supplier | 5 | MFR | Supplier | nvarchar | 10 | 0 | | |
| TOPAerospace Defence Industry Solution |
| 2 | ORFCALC | Data Record ORF Calculation, ATTENTION: MOVE-CORR! | 4 | MFR | Manufacturer Code | nvarchar | 5 | 0 | | |
| TOPEnvironment, Health and Safety |
| 3 | /TDAG/CPT_HMFR | CP: Harmonization Manufacturer/Supplier | 5 | MFR | Supplier | nvarchar | 10 | 0 | | |
| TOPProvisioning |
| 4 | ADS2KIPBRO_CMD | SPEC 2000 IP: Key fields for master data creation | 5 | MFR | Manufacturer Code | nvarchar | 5 | 0 | | |
| 5 | SPCIPCSN | Locations | 4 | MFR | Manufacturer Code | nvarchar | 5 | 0 | | |
| 6 | SPCIPEFF | Effectivity Range | 4 | MFR | Manufacturer Code | nvarchar | 5 | 0 | | |
| 7 | SPCIPOCH | Other Charges - Code & Amount | 4 | MFR | Manufacturer Code | nvarchar | 5 | 0 | | |
| 8 | SPCIPOSC | SPEC2000: Stores optional suppliers for the subject SPL | 3 | MFR | Manufacturer Code | nvarchar | 5 | 0 | | |
| 9 | SPCIPOSC_D | SPEC2000: Stores deleted entries for SPCIPOSC | 3 | MFR | Manufacturer Code | nvarchar | 5 | 0 | | |
| 10 | SPCIPOSDS | Optional Suppliers and Distributors | 4 | MFR | Manufacturer Code | nvarchar | 5 | 0 | | |
| 11 | SPCIPPARTS | Other parts that can be used | 4 | MFR | Manufacturer Code | nvarchar | 5 | 0 | | |
| 12 | SPCIPPDR | Spare parts / End items | 4 | MFR | Manufacturer Code | nvarchar | 5 | 0 | | |
| 13 | SPCIPPDS | SPEC2000: Procurement Data Segment | 4 | MFR | Manufacturer Code | nvarchar | 5 | 0 | | |
| 14 | SPCIPPQA | Price Break - Quantity & Amount | 4 | MFR | Manufacturer Code | nvarchar | 5 | 0 | | |
| 15 | SPCIPRPDE | Replacing Parts / Replaced Parts | 4 | MFR | Manufacturer Code | nvarchar | 5 | 0 | | |
| 16 | SPCIPSPLMNT | SPEC2000: Stores Additional/Long/MultipleOccurance fields | 7 | MFR | Manufacturer Code | nvarchar | 5 | 0 | | |
| 17 | SPCIPUOA | Used On Assemblies | 4 | MFR | Manufacturer Code | nvarchar | 5 | 0 | | |
