| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | EHHSSD_HSP_ROOT | Protocol - Root | 9 | EXT_REF | External Reference Key for Protocol | nvarchar | 60 | 0 | | |
2 | LOP_D_LIST_HD | Option list header | 3 | EXT_REF | External Reference | nvarchar | 32 | 0 | | |
3 | LOP_D_LIST_IT | Option list items | 5 | EXT_REF | External Reference | nvarchar | 32 | 0 | | |
4 | LOP_D_MASTER_HD | Option list header as master data | 4 | EXT_REF | External Reference | nvarchar | 32 | 0 | | |
5 | LOP_D_MASTER_IT | Option List items as master data | 5 | EXT_REF | External Reference | nvarchar | 32 | 0 | | |
TOPCase Management |
6 | SCMG_T_CASE_ATTR | Case Attributes | 5 | EXT_REF | External reference | nvarchar | 30 | 0 | | |
TOPChargeback |
7 | WCOCOH | Condition Contract: Header | 51 | EXT_REF | External Reference | nvarchar | 32 | 0 | | |
TOPContract Accounts Receivable and Payable |
8 | FKKMAREDUCT | Dunning Reductions | 10 | EXT_REF | Character field, length 32 | nvarchar | 32 | 0 | | |
TOPExpenditure Certification |
9 | FMEUFFNS | Financing Source | 26 | EXT_REF | External Reference | nvarchar | 20 | 0 | | |
10 | FMEUFTYP | Financing Source Type | 14 | EXT_REF | External Reference | nvarchar | 20 | 0 | | |
TOPGlobal Trade |
11 | WB2_D_COMSUB | Trading Contract: commodity sub items | 29 | EXT_REF | External Identifier for Commodity Item | nvarchar | 10 | 0 | | |
12 | WB2_D_PRASP | Trading Contract: pricing aspects | 45 | EXT_REF | External Identifier for Pricing Aspect | nvarchar | 10 | 0 | | |
TOPGRC Risk Management |
13 | /ORM/ORMTEVNT | The ILD Event Main table | 10 | EXT_REF | Event External Reference | nvarchar | 80 | 0 | | |
TOPManagement of Internal Controls |
14 | FOPCDEFICANA | MIC: Deficiency Analysis | 7 | EXT_REF | External reference | nvarchar | 30 | 0 | | |
TOPProcess Controls |
15 | GRPCDEFICANA | PC: Deficiency Analysis | 7 | EXT_REF | External reference | nvarchar | 30 | 0 | | |
TOPTransaction Manager |
16 | TCORT_CODUL | Deal: Underlying | 18 | EXT_REF | External order number | nvarchar | 20 | 0 | | |
17 | TCORT_CODUL2 | Deal: 2nd Underlying | 19 | EXT_REF | External order number | nvarchar | 20 | 0 | | |