| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | CNVCMIS_A_SESS | Table to store status information about table analysis | 3 | PORTION | Portion Number for Size Analysis | nvarchar | 14 | 0 | | |
| 2 | CNVCMIS_A_SIZE | table to store result of the table size analysis | 4 | PORTION | Portion Number for Size Analysis | nvarchar | 14 | 0 | | |
| 3 | CNVMBTDEXCLUKEYS | Cluster-Portions for File Transfer | 3 | PORTION | Max. portion | nvarchar | 5 | 0 | | |
| 4 | CNVMBTTRTRACK | To store tables configured for tracking | 9 | PORTION | Data element for portions | int | 10 | 0 | | |
| 5 | CNVTDMSSCM_DC | Cluster: SCM EWM Delivery DOCID | 7 | PORTION | Portion | nvarchar | 5 | 0 | | |
| 6 | CNVTDMS_02_COUNT | Rows per table and client and calculated size in client | 4 | PORTION | TDMS: portion number for size analysis | nvarchar | 14 | 0 | | |
| 7 | CNVTDMS_02_PORT | table for storing values on screen | 3 | PORTION | TDMS: portion number for size analysis | nvarchar | 14 | 0 | | |
| 8 | CNVTDMS_02_SESS | Table to store status information about table analysis | 3 | PORTION | TDMS: portion number for size analysis | nvarchar | 14 | 0 | | |
| 9 | CNVTDMS_02_SIZE | table to store result of the table size analysis | 4 | PORTION | TDMS: portion number for size analysis | nvarchar | 14 | 0 | | |
| 10 | CNVTDMS_02_STEMP | Table to store current view on CNVTDMS_02_SIZE_STRUCT | 4 | PORTION | TDMS: portion number for size analysis | nvarchar | 14 | 0 | | |
| 11 | CNVTDMS_EC_STMPC | Table to store copy of CNVTDMS_02_STEMP data with Table Desc | 4 | PORTION | TDMS: portion number for size analysis | nvarchar | 14 | 0 | | |
| 12 | CNV_CMIS_A_SIZE | TABLE TO STORE WORKLIST TABLES FOR SIZE CALCULATIONS | 4 | PORTION | Portion Number for Size Analysis | nvarchar | 14 | 0 | | |
| 13 | DMC_ACCESS_PLAN | DMC: WHERE clauses of an access plan | 2 | PORTION | | int | 10 | 0 | | |
| 14 | DMC_DW_ACPLAN | Assignment Select Strings - Access Plan | 4 | PORTION | Text field length 200 | nvarchar | 200 | 0 | | |
| 15 | DMC_RTO_TABKEY | MWB: Key for Tabl Entries to be Transferred | 3 | PORTION | | nvarchar | 10 | 0 | | |
| 16 | DMC_RUNINFO_TIME | DMC: Time and status for data portions | 2 | PORTION | | int | 10 | 0 | | |
| 17 | DMC_RUN_INFO | DMC: Record Counter and Status for a Run | 2 | PORTION | | int | 10 | 0 | | |
| 18 | DMC_RUN_STAT | Saves the number of actual inserts in target table | 2 | PORTION | | int | 10 | 0 | | |
| 19 | IUUC_REPL_LTNCY | Keep history for the latency of each replicated portion | 2 | PORTION | | int | 10 | 0 | | |
| 20 | IUUC_REPL_LTNCYH | Keep history for the latency of each replicated portion | 4 | PORTION | | int | 10 | 0 | | |
| 21 | IUUC_REPL_STAT | Statistics about the number of I/U/D entries for replication | 2 | PORTION | Natural Number | int | 10 | 0 | | |
| 22 | IUUC_REPL_STATH | Statistics about the number of I/U/D entries for replication | 5 | PORTION | Natural Number | int | 10 | 0 | | |
| 23 | IUUC_RUNINFO_CNT | IUUC: Record counter for IUUC data transfer portions | 2 | PORTION | | int | 10 | 0 | | |
| 24 | IUUC_RUNINFO_TIM | IUUC: Time and status for data portions | 2 | PORTION | | int | 10 | 0 | | |
| TOPContract Billing |
| 25 | ERCH | Billing Doc. Data | 20 | PORTION | Portion | nvarchar | 8 | 0 | | |
| 26 | TE125 | Alloc. Data for Gas | 4 | PORTION | Portion | nvarchar | 8 | 0 | | |
| TOPInvoicing |
| 27 | DEABP | Table: Customer Change Header Data for BB Amounts | 10 | PORTION | Portion | nvarchar | 8 | 0 | | |
| 28 | EABP | Budget Billing Plan | 10 | PORTION | Portion | nvarchar | 8 | 0 | | |
| 29 | EITEDI | Temporary Index Selection in Invoicing -> EDI Transmission | 5 | PORTION | Portion | nvarchar | 8 | 0 | | |
| 30 | EITERDK | Temporary Data Selection: Invoicing -> Bill Printout | 5 | PORTION | Portion | nvarchar | 8 | 0 | | |
| 31 | EITR | Temporary Selection Data for IS-U Invoicing | 5 | PORTION | Portion | nvarchar | 8 | 0 | | |
| 32 | ERDK | Print Document/Header Data | 27 | PORTION | Portion | nvarchar | 8 | 0 | | |
| 33 | ERDK_SHORT | Header Data for Print Document - Extract | 16 | PORTION | Portion | nvarchar | 8 | 0 | | |
| TOPMaster Data |
| 34 | EVER | IS-U Cont. | 7 | PORTION | Alternative portion | nvarchar | 8 | 0 | | |
| TOPMeter Reading |
| 35 | ETRG | Billing Order | 7 | PORTION | Portion | nvarchar | 8 | 0 | | |
| TOPPortioning and scheduling |
| 36 | TE422 | Schedule Master Data for Meter Reading Unit | 13 | PORTION | Portion | nvarchar | 8 | 0 | | |
| 37 | TE424 | Portion: Definition of Dates | 2 | PORTION | Portion | nvarchar | 8 | 0 | | |
| TOPUpgrade Tools |
| 38 | CRR_ACCESS_PLAN | Package delimitation for initial transfer | 2 | PORTION | | int | 10 | 0 | | |
| TOPWaste Management |
| 39 | TEWADUEDATEDET | Parameter for Due Date Calculation of Charge Notification | 3 | PORTION | Portion | nvarchar | 8 | 0 | | |
| 40 | TEWAPRORATION | Waste-Specific Restriction Dates | 2 | PORTION | Portion | nvarchar | 8 | 0 | | |
