| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | VIYCMETERCOSTS | Meter Based Costs | 17 | CONSUMPTION | Consumption | decimal | 17 | 4 | | |
TOPConsumption-Based Planning See Also PP-MRP |
2 | WFCS_WRFT | Movement Data for Store Forecasts | 5 | CONSUMPTION | Consumption Value (POS) for Forecasting | decimal | 13 | 3 | | |
TOPContract Billing |
3 | ETTIF | Instln Facts | 44 | CONSUMPTION | Consumption for streetlight | decimal | 16 | 7 | | |
4 | ETTIFB | Installation Facts (Reference Values) | 37 | CONSUMPTION | Consumption for streetlight | decimal | 16 | 7 | | |
TOPEnergy Data Management |
5 | EEDMREPLACE | IS-U: EDM Replacement Value Procedure | 10 | CONSUMPTION | Replacement Value Procedure Valid for Consumption Profiles | nvarchar | 1 | 0 | | |
6 | EEDMREPLACEGRP | IS-U-EDM Replacement Value Procedure Group | 5 | CONSUMPTION | Replacement Value Procedure Group Valid for Cons. Profiles | nvarchar | 1 | 0 | | |
7 | EEDMSETTLPODCONS | Generated Consumption per Point of Delivery | 6 | CONSUMPTION | Profile value at application level | decimal | 31 | 14 | | |
TOPIntercompany Data Exchange |
8 | EMRDETAIL | IDE: detailed information on MR results (ISU_USAGE_DATA) | 12 | CONSUMPTION | Consumption value (without power factor) | nvarchar | 20 | 0 | | |
TOPInvoicing |
9 | TEPYPM | Contract history for generating payment schedule | 6 | CONSUMPTION | Quantity Consumed | decimal | 31 | 14 | | |
10 | TEPYPM_TEMPLATE | Templates for contract history, payment plan generation | 6 | CONSUMPTION | Quantity Consumed | decimal | 31 | 14 | | |
TOPLocalization |
11 | VIXCJPSCCOSTSEXT | Costs per Object - Legacy Data Transfer | 27 | CONSUMPTION | Consumption of the Real Estate Object | decimal | 12 | 4 | | |
TOPPosition Budgeting and Control |
12 | T77HRFPM_CLOSING | Settings for Period Closing with Commitment Creation | 5 | CONSUMPTION | Reduction of Cmmt Docs in Closed Periods | nvarchar | 1 | 0 | | |