| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /OPT/WT_3S_MAP | Supplier Self Service - User Mapping | 3 | SUPPLIER_ID | Supplier Self Service - Supplier ID | nvarchar | 10 | 0 | | |
2 | /OPT/WT_3S_SUPPL | Supplier Self Service - Supplier Definition | 3 | SUPPLIER_ID | Supplier Self Service - Supplier ID | nvarchar | 10 | 0 | | |
3 | /OPT/WT_3S_SUPPM | Supplier Self Service - Supplier Mapping | 4 | SUPPLIER_ID | Supplier Self Service - Supplier ID | nvarchar | 10 | 0 | | |
4 | /SAPSRM/D_PARMST | Participant Master | 12 | SUPPLIER_ID | ID of an SRM Supplier | nvarchar | 10 | 0 | | |
5 | /SAPSRM/D_SURPAR | Survey Participant | 13 | SUPPLIER_ID | ID of an SRM Supplier | nvarchar | 10 | 0 | | |
6 | BBPC_SUS_ALERTS | Alerts for SUS | 2 | SUPPLIER_ID | Business Partner Number | nvarchar | 10 | 0 | | |
7 | EHFNDD_PCHA_ROOT | Process Control - Root | 37 | SUPPLIER_ID | Supplier | nvarchar | 10 | 0 | | |
8 | EHFNDD_PTN_ROOT | | 37 | SUPPLIER_ID | Supplier | nvarchar | 10 | 0 | | |
9 | EHFNDD_REQC_ROOT | Process Control - Root | 37 | SUPPLIER_ID | Supplier | nvarchar | 10 | 0 | | |
10 | EHFNDD_SDSE_ROOT | Process Control - Root | 37 | SUPPLIER_ID | Supplier | nvarchar | 10 | 0 | | |
11 | EHHSSD_CHAI_ROOT | Process Control - Root | 37 | SUPPLIER_ID | Supplier | nvarchar | 10 | 0 | | |
12 | EHHSSD_PCI_ROOT | Control Inspection PCBO | 37 | SUPPLIER_ID | Supplier | nvarchar | 10 | 0 | | |
13 | EHHSSD_PRQ_ROOT | Process Control - Root | 37 | SUPPLIER_ID | Supplier | nvarchar | 10 | 0 | | |
14 | EHHSSD_PRSPS_RT | Process Control - Sample Shipment - Root | 37 | SUPPLIER_ID | Supplier | nvarchar | 10 | 0 | | |
15 | EHHSSD_RPL_ROOT | Process Control - Mass Replace Controls - Root | 37 | SUPPLIER_ID | Supplier | nvarchar | 10 | 0 | | |
16 | EHPRCD_BBT_ROOT | Process Control - Root | 38 | SUPPLIER_ID | Supplier | nvarchar | 10 | 0 | | |
17 | EHPRCD_CMP_POS | Campaign Position | 12 | SUPPLIER_ID | Supplier | nvarchar | 10 | 0 | | |
18 | EHPRCD_COD_ROOT | Compliance Data Object : Root | 9 | SUPPLIER_ID | Supplier | nvarchar | 10 | 0 | | |
19 | EHPRCD_OBL_ITEM | Object List Item | 10 | SUPPLIER_ID | Supplier | nvarchar | 10 | 0 | | |
20 | EHPRCD_PBB_ROOT | Process Control - Root | 38 | SUPPLIER_ID | Supplier | nvarchar | 10 | 0 | | |
21 | EHPRCD_PCA_ROOT | Process Control - Root | 37 | SUPPLIER_ID | Supplier | nvarchar | 10 | 0 | | |
22 | EHPRCD_PCR_ROOT | Process Control - Root | 38 | SUPPLIER_ID | Supplier | nvarchar | 10 | 0 | | |
23 | EHPRCD_PSA_ROOT | Process Control - Root | 38 | SUPPLIER_ID | Supplier | nvarchar | 10 | 0 | | |
24 | EHPRCD_PSI_ROOT | Process Control - Root | 38 | SUPPLIER_ID | Supplier | nvarchar | 10 | 0 | | |
25 | EHPRCD_SUP_ROOT | Supplier Data - Root | 7 | SUPPLIER_ID | Supplier | nvarchar | 10 | 0 | | |
TOPBusiness Objects, Common Components |
26 | EHFNDD_PAM_ROOT | Process Control - Root | 38 | SUPPLIER_ID | Supplier | nvarchar | 10 | 0 | | |
TOPControl Plan |
27 | DPR_CTRLPLAN_V | Control Plan: Versions | 11 | SUPPLIER_ID | Identification Key of Vendor in Control Plan | nvarchar | 20 | 0 | | |
TOPIncident Workflow and Tasks |
28 | EHHSSD_IIL_ROOT | Process Control - Root | 37 | SUPPLIER_ID | Supplier | nvarchar | 10 | 0 | | |
29 | EHHSSD_IIS_ROOT | Process Control - Root | 37 | SUPPLIER_ID | Supplier | nvarchar | 10 | 0 | | |
30 | EHHSSD_PGI_ROOT | Process Control - Root | 37 | SUPPLIER_ID | Supplier | nvarchar | 10 | 0 | | |
31 | EHHSSD_PIA_ROOT | Process Control - Root | 37 | SUPPLIER_ID | Supplier | nvarchar | 10 | 0 | | |
32 | EHHSSD_PIC_ROOT | Process Control - Root | 37 | SUPPLIER_ID | Supplier | nvarchar | 10 | 0 | | |
33 | EHHSSD_PIH_ROOT | Process Control - Root | 37 | SUPPLIER_ID | Supplier | nvarchar | 10 | 0 | | |
34 | EHHSSD_PII_ROOT | Process Control - Root | 37 | SUPPLIER_ID | Supplier | nvarchar | 10 | 0 | | |
35 | EHHSSD_PIL_ROOT | Process Control - Root | 37 | SUPPLIER_ID | Supplier | nvarchar | 10 | 0 | | |
36 | EHHSSD_PIN_ROOT | Process Control - Root | 37 | SUPPLIER_ID | Supplier | nvarchar | 10 | 0 | | |
37 | EHHSSD_PIR_ROOT | Process Control - Root | 37 | SUPPLIER_ID | Supplier | nvarchar | 10 | 0 | | |
TOPRisk Assessment |
38 | EHHSSD_PRA_ROOT | Action PCBO for Risk Assesment | 37 | SUPPLIER_ID | Supplier | nvarchar | 10 | 0 | | |
TOPWorkflows and Tasks for Risk Assessment |
39 | EHHSSD_EVL_ROOT | Process Control - Root | 37 | SUPPLIER_ID | Supplier | nvarchar | 10 | 0 | | |
40 | EHHSSD_PRF_ROOT | Process Control - Root | 37 | SUPPLIER_ID | Supplier | nvarchar | 10 | 0 | | |
41 | EHHSSD_PRL_ROOT | Process Control - Root | 37 | SUPPLIER_ID | Supplier | nvarchar | 10 | 0 | | |
42 | EHHSSD_PRN_ROOT | Process Control - Root | 37 | SUPPLIER_ID | Supplier | nvarchar | 10 | 0 | | |
43 | EHHSSD_PRR_ROOT | Process Control - Root | 38 | SUPPLIER_ID | Supplier | nvarchar | 10 | 0 | | |
44 | EHHSSD_PRS_ROOT | Process Control - Root | 37 | SUPPLIER_ID | Supplier | nvarchar | 10 | 0 | | |
45 | EHHSSD_PRT_ROOT | Process Control - Root | 38 | SUPPLIER_ID | Supplier | nvarchar | 10 | 0 | | |