| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /OEE/MPH_KPITARG | Plant Hierarchy KPI Target Details | 9 | TARGET2 | OEE KPI Target | decimal | 31 | 14 | | |
TOPFunds Management |
2 | FMDERIVE002 | Derivation rule:Cost Center/CE to Commitment Item/Funds Ctr/ | 10 | TARGET2 | Funds Center | nvarchar | 16 | 0 | | |
3 | FMDERIVE004 | Derivation rule:Order/CE to Commitment Item/Funds Ctr/Fund/F | 8 | TARGET2 | Funds Center | nvarchar | 16 | 0 | | |
4 | FMDERIVE005 | Derivation rule:Order to Commitment Item/Funds Ctr/Fund/Func | 6 | TARGET2 | Funds Center | nvarchar | 16 | 0 | | |
5 | FMDERIVE006 | Derivation rule:WBS Element/CE to Commitment Item/Funds Ctr/ | 8 | TARGET2 | Funds Center | nvarchar | 16 | 0 | | |
6 | FMDERIVE008 | Profit Ctr/CE to Commit Item/Funds Center/Fund/Function | 8 | TARGET2 | Funds Center | nvarchar | 16 | 0 | | |
7 | FMDERIVE009 | Derivation rule:Profit Center to Commitment Item/Funds Ctr/F | 6 | TARGET2 | Funds Center | nvarchar | 16 | 0 | | |
8 | FMDT_CHANGEDOC | Empty table for change document on DRULE derivation tables | 5 | TARGET2 | Target value from Derivation table | nvarchar | 60 | 0 | | |
TOPGeneral Application Functions |
9 | FMFMOAID38000003 | Derivation rule: | 6 | TARGET2 | Functional Area | nvarchar | 16 | 0 | | |
10 | FMFMOAID38000016 | Derivation rule:Order to Commitment Item/Funds Ctr/Fund/Func | 6 | TARGET2 | Funds Center | nvarchar | 16 | 0 | | |
11 | FMFMOAID38000042 | Derivation rule:Cost Center to all | 8 | TARGET2 | Fund | nvarchar | 10 | 0 | | |
TOPProfitability Analysis |
12 | ACEDTF7300087 | Derivation rule:Posting Rule to GL Accounts | 8 | TARGET2 | Start Account | nvarchar | 10 | 0 | | |
13 | ACEID38000035 | Règle dérivat.:Comptes FR | 8 | TARGET2 | Compte cible | nvarchar | 10 | 0 | | |
14 | ACEID38000040 | Ableitungsregel:Accounts for other accrual types (costs) | 12 | TARGET2 | Startkonto | nvarchar | 10 | 0 | | |
15 | ACEID38000042 | Ableitungsregel:Accounts for accrual type INSURA | 8 | TARGET2 | Startkonto | nvarchar | 10 | 0 | | |
16 | ACEID38000056 | Derivation rule:OR Accruals IPM HT - Account Determination | 8 | TARGET2 | Target account | nvarchar | 10 | 0 | | |
17 | FILADTF7300081 | Derivation rule:Derivation of Classification | 12 | TARGET2 | Check Sequence in Financing Classification | nvarchar | 10 | 0 | | |
18 | FILADTF7300082 | Derivation rule:Derivation of Useful Life | 10 | TARGET2 | Time Unit | nvarchar | 1 | 0 | | |
19 | FOTPDTF7300088 | Derivation rule:One Time Postings Acc.Princ. 01 | 10 | TARGET2 | Offsetting Account | nvarchar | 10 | 0 | | |
20 | FOTPDTF7300089 | Derivation rule:One Time Postings Acc.Princ. 60 | 10 | TARGET2 | Offsetting Account | nvarchar | 10 | 0 | | |
21 | K9RID34000022 | Derivation rule: | 12 | TARGET2 | Plant used for reading cost estimate | nvarchar | 4 | 0 | | |
22 | K9RID34000025 | Derivation rule:Template determination for sales processes | 8 | TARGET2 | Additional update characteristic | nvarchar | 30 | 0 | | |
23 | K9RID34000026 | Derivation rule:Template determination for sales processes | 8 | TARGET2 | Additional update characteristic | nvarchar | 30 | 0 | | |
24 | K9RID38000012 | Derivation Rule: Procedure Determination for Sales Processes | 8 | TARGET2 | Additional update characteristic | nvarchar | 30 | 0 | | |
25 | K9RID38000023 | Derivation Rule: Access to Cost Estimate for Transfer Prices | 12 | TARGET2 | Second costing key (CO-PA) | nvarchar | 3 | 0 | | |
26 | K9RID38000026 | Derivation Rule: Assignment at Material Type / Plant Level | 14 | TARGET2 | Second costing key (CO-PA) | nvarchar | 3 | 0 | | |
27 | K9RID38000028 | Derivation Rule: Access to Material Type Level | 12 | TARGET2 | Second costing key (CO-PA) | nvarchar | 3 | 0 | | |
28 | K9RID38000030 | Derivation Rule: Access to Cost Estimate for Transfer Prices | 12 | TARGET2 | Second costing key (CO-PA) | nvarchar | 3 | 0 | | |
29 | K9RID38000043 | Ableitungsregel: | 6 | TARGET2 | Kennzeichen AR - Aktiv | nvarchar | 1 | 0 | | |
30 | K9RID38000044 | Ableitungsregel:Foreign Exchange | 8 | TARGET2 | Kennzeichen AR - Aktiv | nvarchar | 1 | 0 | | |
31 | K9RID38000045 | Ableitungsregel:Loans | 6 | TARGET2 | Kennzeichen AR - Aktiv | nvarchar | 1 | 0 | | |
32 | K9RID38000046 | Ableitungsregel:Money Market | 6 | TARGET2 | Kennzeichen AR - Aktiv | nvarchar | 1 | 0 | | |
33 | K9RID38000047 | Ableitungsregel:Depot-Gattungsbestand | 6 | TARGET2 | Kennzeichen AR - Aktiv | nvarchar | 1 | 0 | | |
34 | K9RID38000048 | Ableitungsregel:Risikoträger | 6 | TARGET2 | Kennzeichen AR - Aktiv | nvarchar | 1 | 0 | | |
TOPRental Accounting |
35 | ACESLN0000003 | Ableitungsregel:Konten | 10 | TARGET2 | Doelrekening | nvarchar | 10 | 0 | | |
36 | ACESLN1000002 | Derivation Rule: Accounts | 10 | TARGET2 | Target account | nvarchar | 10 | 0 | | |