| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | EHFNDD_CHM_MAT | Chemical - Material | 9 | MATERIAL_ID | Material | nvarchar | 18 | 0 | | |
2 | EHFNDD_PCHA_ROOT | Process Control - Root | 34 | MATERIAL_ID | Material | nvarchar | 18 | 0 | | |
3 | EHFNDD_PTN_ROOT | | 34 | MATERIAL_ID | Material | nvarchar | 18 | 0 | | |
4 | EHFNDD_REQC_ROOT | Process Control - Root | 34 | MATERIAL_ID | Material | nvarchar | 18 | 0 | | |
5 | EHFNDD_SDSE_ROOT | Process Control - Root | 34 | MATERIAL_ID | Material | nvarchar | 18 | 0 | | |
6 | EHHSSD_CHAI_ROOT | Process Control - Root | 34 | MATERIAL_ID | Material | nvarchar | 18 | 0 | | |
7 | EHHSSD_PCI_ROOT | Control Inspection PCBO | 34 | MATERIAL_ID | Material | nvarchar | 18 | 0 | | |
8 | EHHSSD_PRQ_ROOT | Process Control - Root | 34 | MATERIAL_ID | Material | nvarchar | 18 | 0 | | |
9 | EHHSSD_PRSPS_RT | Process Control - Sample Shipment - Root | 34 | MATERIAL_ID | Material | nvarchar | 18 | 0 | | |
10 | EHHSSD_RPL_ROOT | Process Control - Mass Replace Controls - Root | 34 | MATERIAL_ID | Material | nvarchar | 18 | 0 | | |
11 | EHPRCD_BBT_ROOT | Process Control - Root | 35 | MATERIAL_ID | Material | nvarchar | 18 | 0 | | |
12 | EHPRCD_CMP_POS | Campaign Position | 8 | MATERIAL_ID | Material Number | nvarchar | 18 | 0 | | |
13 | EHPRCD_OBL_ITEM | Object List Item | 8 | MATERIAL_ID | Material Number | nvarchar | 18 | 0 | | |
14 | EHPRCD_PBB_ROOT | Process Control - Root | 35 | MATERIAL_ID | Material | nvarchar | 18 | 0 | | |
15 | EHPRCD_PCA_ROOT | Process Control - Root | 34 | MATERIAL_ID | Material | nvarchar | 18 | 0 | | |
16 | EHPRCD_PCR_ROOT | Process Control - Root | 35 | MATERIAL_ID | Material | nvarchar | 18 | 0 | | |
17 | EHPRCD_PSA_ROOT | Process Control - Root | 35 | MATERIAL_ID | Material | nvarchar | 18 | 0 | | |
18 | EHPRCD_PSI_ROOT | Process Control - Root | 35 | MATERIAL_ID | Material | nvarchar | 18 | 0 | | |
19 | SESI_DEMO_ST_BO | Order status of the SESI Demo Backoffice Application | 16 | MATERIAL_ID | SRT FT Tests: Single Material Item | nvarchar | 20 | 0 | | |
20 | SESI_DEMO_ST_PL | Production status of the SESI Demo Plant Application | 7 | MATERIAL_ID | SRT FT Tests: Single Material Item | nvarchar | 20 | 0 | | |
21 | SESI_DEMO_ST_SO | Order status of the SESI Demo Salesoffice Application | 13 | MATERIAL_ID | | nvarchar | 20 | 0 | | |
22 | SESI_DEMO_ST_WH | Order status of the SESI Demo Warehouse Application | 13 | MATERIAL_ID | | nvarchar | 20 | 0 | | |
23 | VMP_EXPLODED_MAT | VMP Planning scope expanded materials | 5 | MATERIAL_ID | Material Number | nvarchar | 18 | 0 | | |
TOPBusiness Objects, Common Components |
24 | EHFNDD_PAM_ROOT | Process Control - Root | 35 | MATERIAL_ID | Material | nvarchar | 18 | 0 | | |
TOPCampaign Weighing and Dispensing |
25 | CWD_MATERIAL | Campaign Weighing Component Materials | 3 | MATERIAL_ID | Material Number | nvarchar | 18 | 0 | | |
TOPIncident Workflow and Tasks |
26 | EHHSSD_IIL_ROOT | Process Control - Root | 34 | MATERIAL_ID | Material | nvarchar | 18 | 0 | | |
27 | EHHSSD_IIS_ROOT | Process Control - Root | 34 | MATERIAL_ID | Material | nvarchar | 18 | 0 | | |
28 | EHHSSD_PGI_ROOT | Process Control - Root | 34 | MATERIAL_ID | Material | nvarchar | 18 | 0 | | |
29 | EHHSSD_PIA_ROOT | Process Control - Root | 34 | MATERIAL_ID | Material | nvarchar | 18 | 0 | | |
30 | EHHSSD_PIC_ROOT | Process Control - Root | 34 | MATERIAL_ID | Material | nvarchar | 18 | 0 | | |
31 | EHHSSD_PIH_ROOT | Process Control - Root | 34 | MATERIAL_ID | Material | nvarchar | 18 | 0 | | |
32 | EHHSSD_PII_ROOT | Process Control - Root | 34 | MATERIAL_ID | Material | nvarchar | 18 | 0 | | |
33 | EHHSSD_PIL_ROOT | Process Control - Root | 34 | MATERIAL_ID | Material | nvarchar | 18 | 0 | | |
34 | EHHSSD_PIN_ROOT | Process Control - Root | 34 | MATERIAL_ID | Material | nvarchar | 18 | 0 | | |
35 | EHHSSD_PIR_ROOT | Process Control - Root | 34 | MATERIAL_ID | Material | nvarchar | 18 | 0 | | |
TOPProduction Planning and Control |
36 | LPO_INTMODEL_MAT | Integration model LPO: Integrated Materials | 2 | MATERIAL_ID | Material Number | nvarchar | 18 | 0 | | |
TOPRisk Assessment |
37 | EHHSSD_PRA_ROOT | Action PCBO for Risk Assesment | 34 | MATERIAL_ID | Material | nvarchar | 18 | 0 | | |
TOPWorkflows and Tasks for Risk Assessment |
38 | EHHSSD_EVL_ROOT | Process Control - Root | 34 | MATERIAL_ID | Material | nvarchar | 18 | 0 | | |
39 | EHHSSD_PRF_ROOT | Process Control - Root | 34 | MATERIAL_ID | Material | nvarchar | 18 | 0 | | |
40 | EHHSSD_PRL_ROOT | Process Control - Root | 34 | MATERIAL_ID | Material | nvarchar | 18 | 0 | | |
41 | EHHSSD_PRN_ROOT | Process Control - Root | 34 | MATERIAL_ID | Material | nvarchar | 18 | 0 | | |
42 | EHHSSD_PRR_ROOT | Process Control - Root | 35 | MATERIAL_ID | Material | nvarchar | 18 | 0 | | |
43 | EHHSSD_PRS_ROOT | Process Control - Root | 34 | MATERIAL_ID | Material | nvarchar | 18 | 0 | | |
44 | EHHSSD_PRT_ROOT | Process Control - Root | 35 | MATERIAL_ID | Material | nvarchar | 18 | 0 | | |