| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPFinancial Accounting |
1 | AC400T001B | P02 Schulung AC400 Periodenwechselstichtage | 5 | STICHTAG | | nvarchar | 2 | 0 | | |
TOPLoans Management |
2 | CML_ARC_DEADLINE | Residence Time for Loans - Archiving | 3 | STICHTAG | Key Date for Selection According to Time-Related Validity | nvarchar | 8 | 0 | | |
TOPMarketing |
3 | TEMKT_BPSEG_BW | Standard Values for Extracting Marketing-Relevant Data | 3 | STICHTAG | Key Date for Demand History in BW | nvarchar | 2 | 0 | | |
TOPPlant Maintenance |
4 | Z9I_STK_IF_NPV | PM/PS-Schnittstelle: Netzplanvorgänge | 13 | STICHTAG | Stichtag Stillstandsplanung | nvarchar | 8 | 0 | | |
5 | Z9I_STK_IF_NPV_W | PM/PS-Schnittstelle: Netzplanvorgänge Werkstattsicht | 18 | STICHTAG | Stichtag Stillstandsplanung | nvarchar | 8 | 0 | | |
6 | Z9I_STK_VORGANG | Terminkontrolle Stillstandsplanung: Relevante Vorgänge | 45 | STICHTAG | Stichtag Stillstandsplanung | nvarchar | 8 | 0 | | |
TOPPortioning and scheduling |
7 | TE422 | Schedule Master Data for Meter Reading Unit | 47 | STICHTAG | Key Date in Billing on a Monthly Basis | nvarchar | 2 | 0 | | |
TOPTax |
8 | P01E2_STATUS | ELStAM Procedure: Status Table | 5 | STICHTAG | ELStAM: Start Date | nvarchar | 8 | 0 | | |
TOPWaste Management |
9 | EWAROUTE | Header table of route | 4 | STICHTAG | Date from which the route is valid | nvarchar | 8 | 0 | | |