| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /MRSS/D_DAG_ASG | Demand Agr. Graph for Demand that is planned | 9 | UNITS | Demand Units (Natural Number) | int | 10 | 0 | | |
2 | /MRSS/D_DAG_DEM | Demand Agr. Graph for Total and Attribute specific Demand | 9 | UNITS | Demand Units (Natural Number) | int | 10 | 0 | | |
3 | /MRSS/D_DAG_MOB | OBSOLETE DB Table - NOT IN USE | 9 | UNITS | Demand Units (Natural Number) | int | 10 | 0 | | |
4 | /MRSS/D_DAG_PAS | Demand Agr. Graph for Preparation/Warp-up of Assignments | 9 | UNITS | Demand Units (Natural Number) | int | 10 | 0 | | |
5 | /MRSS/D_DAG_PDE | Demand Agr. Graph for expected Prep/Warp-up of unpl. Dem. | 9 | UNITS | Demand Units (Natural Number) | int | 10 | 0 | | |
6 | /MRSS/D_DAG_RSB | Demand Agr. Graph for virtual Reserve Base(non existing Dem) | 9 | UNITS | Demand Units (Natural Number) | int | 10 | 0 | | |
7 | /MRSS/D_DAG_RSV | Demand Agr. Graph for virtual Reservation (non existing Dem) | 9 | UNITS | Demand Units (Natural Number) | int | 10 | 0 | | |
8 | /MRSS/D_DAG_TAS | Demand Agr. Graph for Travel Times of Assignments | 9 | UNITS | Demand Units (Natural Number) | int | 10 | 0 | | |
9 | /MRSS/D_DAG_TDE | Demand Agr. Graph for expected Travel Times of unpl. Dem. | 9 | UNITS | Demand Units (Natural Number) | int | 10 | 0 | | |
10 | /MRSS/D_DAG_TRV | OBSOLETE DB Table - NOT IN USE | 9 | UNITS | Demand Units (Natural Number) | int | 10 | 0 | | |
11 | /MRSS/D_DAG_UNA | Demand Agr. Graph for Demand that is not planned yet | 9 | UNITS | Demand Units (Natural Number) | int | 10 | 0 | | |
12 | BCKTRDT_MULTASSG | Multiple Account Assignment of Flows | 8 | UNITS | Units | decimal | 22 | 6 | | |
13 | T5A4A | General Absence Data | 9 | UNITS | Quotas and Deduction Methods | nvarchar | 1 | 0 | | |
TOPBack Office |
14 | TRET_PROTOCOL | Transactions Generated for Endowments | 10 | UNITS | No. of Units for Financial Instruments | decimal | 15 | 5 | | |
15 | TRFT_FLOW | Treasury: Table with TRF Flows | 9 | UNITS | Units | decimal | 22 | 6 | | |
16 | TRFT_MATCH_FLOW | Treasury: Table with Matching Process Flows | 9 | UNITS | Units | decimal | 22 | 6 | | |
17 | TRFT_SUBTOTAL | Treasury: Table with TRF Transaction Figure | 4 | UNITS | Units | decimal | 22 | 6 | | |
18 | TRFT_SUBTRANS | Treasury: TRF Business Subtransaction | 6 | UNITS | Units | decimal | 22 | 6 | | |
19 | TRST_CLASFLO | CFM: Class Flows in Securities Account | 21 | UNITS | Units | decimal | 22 | 6 | | |
20 | TRST_CLASFLO_REV | CFM: Reversed Class Flows in Securities Account | 21 | UNITS | Units | decimal | 22 | 6 | | |
21 | TRST_POSCHG_FLOW | CFM: Flow for Securities Account Position Change | 4 | UNITS | Units | decimal | 22 | 6 | | |
22 | TRST_SECACCTRANS | Treasury: Securities Account Transfer | 12 | UNITS | Units | decimal | 22 | 6 | | |
23 | TRST_SUBTOTAL | Treasury: Table with Trans.Figs - Class Pos. in Sec. Acct | 4 | UNITS | Units | decimal | 22 | 6 | | |
TOPCompensation Management |
24 | PA0380 | HR Master Data Record Infotype 0380 (Comp. Adjustment) | 40 | UNITS | Units of time/measuremenet for intervals | nvarchar | 3 | 0 | | |
TOPIndia |
25 | T7INC5 | Perk value of car | 9 | UNITS | Unit field (cc or hp) | nvarchar | 2 | 0 | | |
TOPPayroll |
26 | T5H2Y | Különadó bérelemei | 11 | UNITS | Bérelem idoegysége | nvarchar | 1 | 0 | | |
TOPRegulatory reporting for insurance companies |
27 | ISSRPREFLOW | ISSR: Basistabelle/Bewegungstabelle | 24 | UNITS | ISSR: Stücke | decimal | 22 | 6 | | |
TOPTaiwan |
28 | T7TW3C | Retirement Pay Calculation Rule | 8 | UNITS | Unit: Month/Point | nvarchar | 1 | 0 | | |
29 | T7TW3E | Severance Pay Calculation Rule | 8 | UNITS | Unit: Month/Point | nvarchar | 1 | 0 | | |
30 | T7TW3G | Resignation Pay Calculation Rule | 8 | UNITS | Unit: Month/Point | nvarchar | 1 | 0 | | |
TOPTask Resource Management |
31 | LEGOR | ECOs' subscriptions at runtime | 5 | UNITS | Quantity of Objects | int | 10 | 0 | | |
32 | LEGRS | Resource-ECO subscription | 6 | UNITS | Quantity of Objects | int | 10 | 0 | | |
33 | LRTCP | Capacity assignment for resource types | 6 | UNITS | Number of Units | tinyint | 3 | 0 | | |
34 | LSECC | Capacity of Static Execution Control (SEC) | 6 | UNITS | Quantity of Objects | int | 10 | 0 | | |
TOPTransaction Management |
35 | THXT_HR_FLOWS | Treasury: Hedging Relationship Flows | 7 | UNITS | Units | decimal | 22 | 6 | | |
36 | THXT_MD_PV | market data present value | 11 | UNITS | Units | decimal | 22 | 6 | | |
TOPTransaction Manager |
37 | BCKTCAT_FLOW | BACKUP: Flow Table of Capital Actions | 12 | UNITS | Units | decimal | 22 | 6 | | |
38 | BCKTERT_FLOW | BACKUP: Flow Table for Executable Rights | 14 | UNITS | Units | decimal | 22 | 6 | | |
39 | IDCFM_DATA_SEC | Valuation-Area-Independent Data for Securities | 15 | UNITS | Units | decimal | 22 | 6 | | |
40 | IDCFM_FRIM_DATA | Impairment Main Data | 34 | UNITS | Number of units | decimal | 22 | 6 | | |
41 | SLDT_FLOW | Subledger Distributor Transactions | 28 | UNITS | Units | decimal | 22 | 6 | | |
42 | TCAT_FLOW | Flow Table of the Corporate Actions | 15 | UNITS | Units | decimal | 22 | 6 | | |
43 | TCORT_CODMD | Deal: Main Data | 60 | UNITS | Units | decimal | 22 | 6 | | |
44 | TCORT_COSAFL | Security Account Transfer: Flows | 7 | UNITS | Units | decimal | 22 | 6 | | |
45 | TCORT_COSAPO | Security Account Transfer: Positions | 7 | UNITS | Units | decimal | 22 | 6 | | |
46 | TERT_FLOW | Flow Table for Rights that can be Exercised | 36 | UNITS | Units | decimal | 22 | 6 | | |
47 | TERT_TRANSACTION | Business Transaction: Exercise of Rights | 17 | UNITS | Units | decimal | 22 | 6 | | |
48 | TRDTT_DATA_SEC | Valuation-Area-Independent Data for Securities | 14 | UNITS | Units | decimal | 22 | 6 | | |
49 | TRDT_FLOW | Persistent distributor flows | 26 | UNITS | Units | decimal | 22 | 6 | | |
50 | TRDT_MULTASSGN | Multiple Account Assignment of Flows | 7 | UNITS | Units | decimal | 22 | 6 | | |
51 | TRLT_VCL_FLOW | Flows Valuation Class Transfer | 12 | UNITS | Units | decimal | 22 | 6 | | |
52 | TRQT_ASSIGN_HIST | CFM: Lot Assignment History | 7 | UNITS | Units | decimal | 22 | 6 | | |
53 | TRQT_FLOW | Treasury: Flow Data Quantity Ledger | 7 | UNITS | Units | decimal | 22 | 6 | | |
54 | TRQT_INIT_LOT | (obsolete) | 8 | UNITS | Units | decimal | 22 | 6 | | |
55 | TRQT_LOTFLOW | Treasury: Table with Lot Flows | 5 | UNITS | Units | decimal | 22 | 6 | | |
56 | TRQT_SUBTOTAL | Treasury: Table with Quantity Ledger Position Trans. Figures | 7 | UNITS | Units | decimal | 22 | 6 | | |
57 | VTBFASGT | Account Assignment of a Financial Transaction Flow | 8 | UNITS | Units | decimal | 22 | 6 | | |
TOPTransfer to Financial Accounting |
58 | TLVT_VAL_STEP | Treasury: Valuation Step | 21 | UNITS | Units | decimal | 22 | 6 | | |
59 | TRLT_BACKUPVORAB | Backup Flow Table from Preliminary Solution - Pos. Mgmt Sol. | 17 | UNITS | Units | decimal | 22 | 6 | | |
60 | TRLT_DERIVFLOWS | Treasury: Flows for Derived Business Transactions | 9 | UNITS | Units | decimal | 22 | 6 | | |
61 | TRLT_FBP_CMP_VAL | Flow Backpack Values for Each Component and Subposition | 5 | UNITS | Units | decimal | 22 | 6 | | |
62 | TRLT_FLOW | Treasury Ledger Flows | 11 | UNITS | Units | decimal | 22 | 6 | | |
63 | TRLT_FS_COMP | TR Ledger: Transaction Figures per Component | 4 | UNITS | Units | decimal | 22 | 6 | | |
64 | TRLT_FS_SUB_COMP | Transaction Figures for Each Component and Subposition | 5 | UNITS | Units | decimal | 22 | 6 | | |
65 | TRLT_INIT_VAL_FU | Initialization Values for TRL Futures Positions | 13 | UNITS | Units | decimal | 22 | 6 | | |
66 | TRLT_INIT_VAL_SE | Initialization Values for TRL Positions: Securities | 17 | UNITS | Units | decimal | 22 | 6 | | |
TOPTreasury and Risk Management |
67 | TREAT_FLOW | Treasury: TREA Flows | 21 | UNITS | Units | decimal | 22 | 6 | | |
TOPUSA |
68 | PA0103 | HR Master Record: Infotype 0103 (Bond Purchases NA) | 34 | UNITS | Unit of measurement | nvarchar | 3 | 0 | | |
TOPWorkforce Management Application |
69 | WFAC_CONTR_RULE | Contract Rule | 5 | UNITS | Number of Periods in Contract | int | 10 | 0 | | |
70 | WFA_ACT_SUMM | Actual summary hours, total paid hours and total pay | 9 | UNITS | Base Unit of Measure | nvarchar | 3 | 0 | | |
71 | WFA_SCHED_SUMM | Schedule summary hours, total paid hours and total pay | 9 | UNITS | Base Unit of Measure | nvarchar | 3 | 0 | | |
72 | WFA_SCH_CONPAY | Contract employee pay to min hours per week | 6 | UNITS | Base Unit of Measure | nvarchar | 3 | 0 | | |
TOPWorkforce Management Core |
73 | WFMCAS_ACT_SUMM | Actual summary hours, total paid hours and total pay | 9 | UNITS | Base Unit of Measure | nvarchar | 3 | 0 | | |