| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPFund Accounting |
1 | FMGLFLEX00 | General ledger: Transaction attributes | 8 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
2 | FMGLFLEX01 | General ledger: Technical fields | 7 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
3 | FMGLFLEX02 | General ledger: Main account assignment | 5 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
4 | FMGLFLEX03 | General ledger: SAP additional account assignment | 7 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
5 | FMGLFLEX04 | General ledger: Customer additional account assignment | 3 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
6 | FMGLFLEX05 | General Ledger: Additional Acct Assignment: Customer 2 | 3 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
7 | FMGLFLEX06 | General ledger: Sender SAP additional account assignment | 8 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
8 | FMGLFLEX07 | General Ledger: Reserve Table 1 | 6 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
9 | FMGLFLEX08 | General Ledger: Reserve Table 2 | 3 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
10 | PSGLFLEX00 | General ledger: Transaction attributes | 8 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
11 | PSGLFLEX01 | General ledger: Technical fields | 7 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
12 | PSGLFLEX02 | General ledger: Main account assignment | 7 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
13 | PSGLFLEX03 | General ledger: SAP additional account assignment | 7 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
14 | PSGLFLEX04 | General ledger: Customer additional account assignment | 3 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
15 | PSGLFLEX05 | General Ledger: Additional Acct Assignment: Customer 2 | 3 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
16 | PSGLFLEX06 | General ledger: Sender SAP additional account assignment | 9 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
17 | PSGLFLEX07 | General Ledger: Reserve Table 1 | 7 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
18 | PSGLFLEX08 | General Ledger: Reserve Table 2 | 3 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
TOPGeneral Ledger Accounting |
19 | FAGLFLEX00 | General ledger: Transaction attributes | 8 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
20 | FAGLFLEX01 | General ledger: Technical fields | 7 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
21 | FAGLFLEX02 | General ledger: Main account assignment | 5 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
22 | FAGLFLEX03 | General ledger: SAP additional account assignment | 10 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
23 | FAGLFLEX04 | General ledger: Customer additional account assignment | 4 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
24 | FAGLFLEX05 | General Ledger: Additional Acct Assignment: Customer 2 | 3 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
25 | FAGLFLEX06 | General ledger: Sender SAP additional account assignment | 9 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
26 | FAGLFLEX07 | General Ledger: Reserve Table 1 | 3 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
27 | FAGLFLEX08 | General Ledger: Reserve Table 2 | 3 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
28 | FAGL_RMAP_CUST | Reorganization: Object Number of the Signature Values | 5 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
29 | FAGL_RMAP_SAP | Reorganization: Object Number of the Signature Values | 7 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
30 | FAGL_RMAP_SIG | Reorganization: Object Number of the Signature Values | 10 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
TOPGeneral Ledger Reorganization |
31 | FAGL_R_MAP_CUST | Reorganization: Object Number of the Signature Values | 4 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
32 | FAGL_R_MAP_SAP | Reorganization: Object Number of the Included SAP Fields | 10 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
33 | FAGL_R_OI_TRACK0 | Reorganization: Open Items for Inclusion | 5 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
34 | JVGLFLEX00 | General ledger: Transaction attributes | 8 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
35 | JVGLFLEX01 | General ledger: Technical fields | 7 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
36 | JVGLFLEX02 | General ledger: Main account assignment | 5 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
37 | JVGLFLEX03 | General ledger: SAP additional account assignment | 10 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
38 | JVGLFLEX04 | General ledger: Customer additional account assignment | 3 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
39 | JVGLFLEX05 | General Ledger: Additional Acct Assignment: Customer 2 | 3 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
40 | JVGLFLEX06 | General ledger: Sender SAP additional account assignment | 9 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
41 | JVGLFLEX07 | General Ledger: Joint Venture Accounting Fields | 6 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
42 | JVGLFLEX08 | General Ledger: Reserve Table 2 | 3 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
TOPSpecial Purpose Ledger |
43 | /CCIS/PROFTAX00 | Object Table Number:00 | 8 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
44 | /CCIS/PROFTAX01 | Object Table Number:01 | 7 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
45 | /CCIS/PROFTAX02 | Object Table Number:02 | 5 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
46 | /CCIS/PROFTAX03 | Object Table Number:03 | 17 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
47 | /CCIS/PROFTAX04 | Object Table Number:04 | 3 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
48 | /CCIS/PROFTAX05 | Object Table Number:05 | 3 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
49 | /CCIS/PROFTAX06 | Object Table Number:06 | 13 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
50 | /CCIS/PROFTAX07 | Object Table Number:07 | 3 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |
51 | /CCIS/PROFTAX08 | Object Table Number:08 | 3 | XTRUSTED | Record is committed on database (reliable) | nvarchar | 1 | 0 | | |