| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPFunds Management |
1 | FMDERIVE002 | Derivation rule:Cost Center/CE to Commitment Item/Funds Ctr/ | 7 | SOUR3_TO | Cost Element | nvarchar | 10 | 0 | | |
TOPProfitability Analysis |
2 | ACEDTF7300086 | Derivation rule:Accrual Types, Acc. Principle, Process in A | 7 | SOUR3_TO | Transaction in Accrual Engine | nvarchar | 1 | 0 | | |
3 | ACEID38000040 | Ableitungsregel:Accounts for other accrual types (costs) | 7 | SOUR3_TO | Kontenplan | nvarchar | 4 | 0 | | |
4 | FILADTF7300081 | Derivation rule:Derivation of Classification | 7 | SOUR3_TO | Accounting Principle | nvarchar | 4 | 0 | | |
5 | FILADTF7300082 | Derivation rule:Derivation of Useful Life | 7 | SOUR3_TO | Used Goods | nvarchar | 1 | 0 | | |
6 | FOTPDTF7300088 | Derivation rule:One Time Postings Acc.Princ. 01 | 7 | SOUR3_TO | Financing Classification | nvarchar | 8 | 0 | | |
7 | FOTPDTF7300089 | Derivation rule:One Time Postings Acc.Princ. 60 | 7 | SOUR3_TO | Financing Classification | nvarchar | 8 | 0 | | |
8 | K9RID34000007 | Derivation rule: | 7 | SOUR3_TO | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
9 | K9RID34000022 | Derivation rule: | 7 | SOUR3_TO | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
10 | K9RID34000028 | Derivation rule:AC610 Derive Profit Center 1016 | 7 | SOUR3_TO | Business Area | nvarchar | 4 | 0 | | |
11 | K9RID34000029 | Derivation rule: | 7 | SOUR3_TO | Product number | nvarchar | 18 | 0 | | |
12 | K9RID38000006 | Derivation Rule: Assignment to plant | 7 | SOUR3_TO | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
13 | K9RID38000016 | Ableitungsregel:T-Ableitungsregel Umwertung Nr 1 | 7 | SOUR3_TO | Geschäftsbereich | nvarchar | 8 | 0 | | |
14 | K9RID38000017 | Ableitungsregel:T-Ableitungsregel Verteilung Nr 1 | 7 | SOUR3_TO | Geschäftsbereich | nvarchar | 8 | 0 | | |
15 | K9RID38000018 | Ableitungsregel:T-Ableitungsregel Prognose Nr 1 | 7 | SOUR3_TO | Geschäftsbereich | nvarchar | 8 | 0 | | |
16 | K9RID38000023 | Derivation Rule: Access to Cost Estimate for Transfer Prices | 7 | SOUR3_TO | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
17 | K9RID38000026 | Derivation Rule: Assignment at Material Type / Plant Level | 7 | SOUR3_TO | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
18 | K9RID38000028 | Derivation Rule: Access to Material Type Level | 7 | SOUR3_TO | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
19 | K9RID38000030 | Derivation Rule: Access to Cost Estimate for Transfer Prices | 7 | SOUR3_TO | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
20 | K9RID38000032 | Ableitungsregel:Konto/Buchungskreis/Geschäftsbereich | 7 | SOUR3_TO | Geschäftsbereich | nvarchar | 4 | 0 | | |
TOPRental Accounting |
21 | ACESLN0000003 | Ableitungsregel:Konten | 7 | SOUR3_TO | Periodetoerekeningssoort | nvarchar | 6 | 0 | | |
22 | ACESLN1000002 | Derivation Rule: Accounts | 7 | SOUR3_TO | Accrual Type | nvarchar | 6 | 0 | | |