| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBudget Control System |
1 | FMBASIDX | Index table for budget structure and AVC | 3 | S_OBJNR | Object number for FM budgeting and AVC | nvarchar | 22 | 0 | | |
TOPBudgeting and Availability Control |
2 | GMBASIDX | Index table for GM objects | 2 | S_OBJNR | Object number for GM RIB and AVC | nvarchar | 22 | 0 | | |
TOPFinancial Accounting |
3 | FERC_D1 | Paths per account, sender and receiver | 8 | S_OBJNR | Number of Source Object | nvarchar | 22 | 0 | | |
4 | FERC_D2 | Documents per sender and account | 7 | S_OBJNR | Object number | nvarchar | 22 | 0 | | |
5 | FERC_F1 | Detailed audit trace file | 6 | S_OBJNR | Object number | nvarchar | 22 | 0 | | |
6 | FERC_F2 | Compact audit trace file | 3 | S_OBJNR | Number of Source Object | nvarchar | 22 | 0 | | |
7 | FERC_F3 | Totals per source object, transaction type, and CO element | 3 | S_OBJNR | Object number | nvarchar | 22 | 0 | | |
TOPFund Accounting |
8 | FMCCBASIDX | Index table for structures | 3 | S_OBJNR | Object number for FM budgeting and AVC | nvarchar | 22 | 0 | | |
9 | FMCCSRCIDX | Index table for sources | 3 | S_OBJNR | Object number for FM budgeting and AVC | nvarchar | 22 | 0 | | |
TOPFunds Management |
10 | FMCFBPAKS | FM-FYC: Budget/Planning Updates (Interim Storage) | 2 | S_OBJNR | Object number | nvarchar | 22 | 0 | | |