| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /IWFND/C_CONSA | Consumer Activation | 2 | CONSUMER_TYPE | Identifier - Used for Development Components of GW | nvarchar | 16 | 0 | | |
| 2 | /IWFND/D_SUB_CNT | Subscription content | 9 | CONSUMER_TYPE | Consumer Type Code ID | nvarchar | 16 | 0 | | |
| 3 | /IWFND/L_MET_AGR | Metering Data - Aggregated Info ODC vs. GC | 3 | CONSUMER_TYPE | Consumer Type | nvarchar | 255 | 0 | | |
| 4 | /IWFND/L_MET_COL | Metering Data Collector | 3 | CONSUMER_TYPE | Consumer Type | ntext | 1073741823 | 0 | | |
| 5 | /IWPGW/C_TGW_COS | Task processing consumer and scenario table | 2 | CONSUMER_TYPE | Task Gateway Consumer Type | nvarchar | 32 | 0 | | |
| 6 | /IWPGW/C_TGW_SCR | Task Gateway Role for Scenario and Consumer assignment | 2 | CONSUMER_TYPE | Task Gateway Consumer Type | nvarchar | 32 | 0 | | |
| 7 | /IWPGW/I_TGW_CON | Control Table for consumer types | 1 | CONSUMER_TYPE | Task Gateway Consumer Type | nvarchar | 32 | 0 | | |
| 8 | ESH_DBT_CONN | Database Trigger Consumer Registrations | 4 | CONSUMER_TYPE | Database Trigger Consumer Type | nvarchar | 1 | 0 | | |
| 9 | HRICP_D_CONSM | Timestamp of Last Delta Run per Consumer | 3 | CONSUMER_TYPE | Consumer Type | nvarchar | 2 | 0 | | |
| 10 | HRICP_D_IT_CUST | Infotypes to Be Tracked per Consumer | 1 | CONSUMER_TYPE | Consumer Type | nvarchar | 2 | 0 | | |
| 11 | HRICP_D_IT_REG | Infotype to Be Tracked per Registered Consumer | 2 | CONSUMER_TYPE | Consumer Type | nvarchar | 2 | 0 | | |
| 12 | HRICP_D_IT_SYST | Infotypes to Be Tracked per Consumer | 1 | CONSUMER_TYPE | Consumer Type | nvarchar | 2 | 0 | | |
