| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SMERP/STG_MM001 | Data staging - Material master plant view complex table | 37 | TEMPB | Temperature conditions indicator | nvarchar | 2 | 0 | | |
2 | /SMERP/STG_MM002 | Data staging - Material storage location view complex table | 37 | TEMPB | Temperature conditions indicator | nvarchar | 2 | 0 | | |
3 | /SMERP/STG_MM003 | Data staging - Material UoM view complex table | 38 | TEMPB | Temperature conditions indicator | nvarchar | 2 | 0 | | |
4 | /SMERP/STG_MM004 | Data staging - Material warehouse view complex table | 37 | TEMPB | Temperature conditions indicator | nvarchar | 2 | 0 | | |
5 | /SMERP/STG_MM005 | Data staging - Material batch view complex table | 37 | TEMPB | Temperature conditions indicator | nvarchar | 2 | 0 | | |
6 | ZEIMMARA | USING FOR STORING EIM MARA DATAS | 37 | TEMPB | Temperature conditions indicator | nvarchar | 2 | 0 | | |
TOPContract Billing |
7 | TE447 | Measured Gas Temperature (Monthly Values) | 4 | TEMPB | Measured gas temperature | decimal | 4 | 2 | | |
8 | TE448 | Daily Gas Temperatures | 4 | TEMPB | Measured gas temperature | decimal | 4 | 2 | | |
TOPCross-Application Components |
9 | MMARA | General material data | 37 | TEMPB | Temperature conditions indicator | nvarchar | 2 | 0 | | |
TOPMaterial Master |
10 | MARA | General Material Data | 37 | TEMPB | Temperature conditions indicator | nvarchar | 2 | 0 | | |
11 | MARA_TMP | File for Incorrect Data in Direct Input | 44 | TEMPB | Temperature conditions indicator | nvarchar | 2 | 0 | | |
12 | MVRA | Cross-version fields for MARA | 37 | TEMPB | Temperature conditions indicator | nvarchar | 2 | 0 | | |
13 | T143 | Temperature Conditions for Storing Materials | 2 | TEMPB | Temperature conditions indicator | nvarchar | 2 | 0 | | |
14 | T143T | Temperature Condition Texts | 3 | TEMPB | Temperature conditions indicator | nvarchar | 2 | 0 | | |