| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | FMADB_DEFAULT_AA | FMADB: Default Account Assignment for Petty Amounts | 6 | FONDS | Fund | nvarchar | 10 | 0 | | |
2 | FMADB_TC_WEIGHTS | FMADB: Trace - Saved Weights (Last Run) | 9 | FONDS | Fund | nvarchar | 10 | 0 | | |
3 | T77PRNL_BEGREL | Pension Return: Determination of Pension Rel. Start Date | 2 | FONDS | Pension Fund | nvarchar | 4 | 0 | | |
4 | ZEIM_VBAP | Sales Document: Item Data | 240 | FONDS | Fund | nvarchar | 10 | 0 | | |
5 | CMACGRANT | Grant Master Data | 17 | FONDS | Fund | nvarchar | 10 | 0 | | |
6 | T7PIQSINGLEFEES | Define Attributes for Individual Fees | 23 | FONDS | Fund | nvarchar | 10 | 0 | | |
7 | TCMAC06D | Derivation of ISR Scenario Related Data | 21 | FONDS | Fund | nvarchar | 10 | 0 | | |
TOPBilling |
8 | VBRP | Billing Document: Item Data | 209 | FONDS | Fund | nvarchar | 10 | 0 | | |
TOPBudgeting and Availability Control |
9 | FMCDCF | Assign Commitment Item to Fund | 5 | FONDS | Fund | nvarchar | 10 | 0 | | |
10 | FMCDRB | Revenues Increasing the Budget Government of Canada | 4 | FONDS | Fund | nvarchar | 10 | 0 | | |
11 | FMCDRBE | Revenues Increasing Budget Government of Canada (Receiver) | 4 | FONDS | Sender fund | nvarchar | 10 | 0 | | |
12 | FMFCTRMV | Store Bgt vals. returned before moving funds ctr. | 6 | FONDS | Fund | nvarchar | 10 | 0 | | |
TOPContract Accounts Receivable and Payable |
13 | DFKKCASHFC | Interim Table for Cash Management and Forecast Data | 14 | FONDS | Fund | nvarchar | 10 | 0 | | |
14 | DFKKFMDYINFO | Log Data for Subsequent FM Activation in FI-CA | 6 | FONDS | Fund | nvarchar | 10 | 0 | | |
15 | DFKKOPAA | Distribution Items with Account Assignment | 25 | FONDS | Fund | nvarchar | 10 | 0 | | |
16 | DFKKOP_REP | Open Items from FPO4 | 159 | FONDS | Fund | nvarchar | 10 | 0 | | |
17 | DFKKRP3 | Returns: Manual Posting Specifications | 25 | FONDS | Fund | nvarchar | 10 | 0 | | |
18 | DFKKSUM | Posting totals from FI-CA | 62 | FONDS | Fund | nvarchar | 10 | 0 | | |
19 | DFKKSUMOLD | Totals Records Without Account Assignment Changes | 18 | FONDS | Fund | nvarchar | 10 | 0 | | |
20 | FMCA_CLEAR_ACC | Maintain Assgt of Clarification Worklist to FM Acct Assgt | 6 | FONDS | Fund | nvarchar | 10 | 0 | | |
21 | TFKFMDY2 | Account Assignments for Subsequent FM Activation | 5 | FONDS | Fund | nvarchar | 10 | 0 | | |
TOPFund Accounting |
22 | FMADB_ENTITY | ADB: Entities Involved in Procedure | 4 | FONDS | Fund | nvarchar | 10 | 0 | | |
TOPFunds Management |
23 | FMCDRBBS | FM Rev. Incr. Budget History - Government Canada | 4 | FONDS | Sender fund | nvarchar | 10 | 0 | | |
24 | FMCFSIF | FI-FM: Selected Open Documents from FI Update | 25 | FONDS | Fund | nvarchar | 10 | 0 | | |
25 | FMCFSIF_TR | Selected Open FI Documents (Settlement) | 25 | FONDS | Fund | nvarchar | 10 | 0 | | |
26 | FMCFSIO | FI-FM: Selected Open Commitment Documents | 28 | FONDS | Fund | nvarchar | 10 | 0 | | |
27 | FMCFSIO_TR | FI-FM: Selected Open Commitment Documents | 28 | FONDS | Fund | nvarchar | 10 | 0 | | |
28 | FMDECK3 | Cover eligibility: amount management for sender budget obj. | 6 | FONDS | Fund | nvarchar | 10 | 0 | | |
29 | FMDECKHK | Assignment of FM Account Assignment to Cover Pool | 4 | FONDS | Fund | nvarchar | 10 | 0 | | |
30 | FMDECKHKC | Assignment of FM Account Assignment to Cover Pool | 5 | FONDS | Fund | nvarchar | 10 | 0 | | |
31 | FMDECKRG | Cover Pool | 5 | FONDS | Fund | nvarchar | 10 | 0 | | |
32 | FMDECKUNG | Assignment of a Cover Pool to an FM Account Assignment | 5 | FONDS | Fund | nvarchar | 10 | 0 | | |
33 | FMFUNDSEL | FIFM: Selected Fund for Closing Operations | 4 | FONDS | Fund | nvarchar | 10 | 0 | | |
34 | FMFYCVA | Value Adjustments Before Fiscal Year Change | 18 | FONDS | Fund | nvarchar | 10 | 0 | | |
35 | FMIAA | Assignment Table for Budget Ledger | 7 | FONDS | Fund | nvarchar | 10 | 0 | | |
36 | FMICOIT | FM/CO integration: Line item | 13 | FONDS | Fund | nvarchar | 10 | 0 | | |
37 | FMIFIIT | FI Line Item Table in Funds Management | 19 | FONDS | Fund | nvarchar | 10 | 0 | | |
38 | FMIO | Object Table for Funds Management | 9 | FONDS | Fund | nvarchar | 10 | 0 | | |
39 | FMIOI | Commitment Documents Funds Management | 25 | FONDS | Fund | nvarchar | 10 | 0 | | |
40 | FMUDPOOL | Assignment of Cover Pool to Rev. Increasing FM Acct Assgmt | 4 | FONDS | Fund | nvarchar | 10 | 0 | | |
41 | FMUDPOOLC | Assignment of Cover Pool to Rev. Increasing FM Acct Assgmt | 4 | FONDS | Fund | nvarchar | 10 | 0 | | |
42 | FMUDRULE | Rules for Revenues Increasing Budget | 4 | FONDS | Fund | nvarchar | 10 | 0 | | |
43 | FMUDRULEC | Rules for Revenues Increasing the Budget | 4 | FONDS | Fund | nvarchar | 10 | 0 | | |
44 | FMZUCH | Change information on allocation of CO Object to FM Object | 12 | FONDS | Fund | nvarchar | 10 | 0 | | |
45 | FMZUGR | Allocation of CO Group to FM Account Assignment | 12 | FONDS | Fund | nvarchar | 10 | 0 | | |
46 | FMZUOB | Allocation of CO Object to FM Account Assignment | 10 | FONDS | Fund | nvarchar | 10 | 0 | | |
TOPLocalization |
47 | ITFM_D_RESIDUALS | ITFM: Residuals: EFD Residuals data Table | 13 | FONDS | Fund | nvarchar | 10 | 0 | | |
TOPNetherlands |
48 | T5N1Q | Pension Accounting (NL) | 25 | FONDS | Pension Fund | nvarchar | 4 | 0 | | |
TOPReporting |
49 | T5N5P | Pension Schemes (NL) | 5 | FONDS | Pension Fund | nvarchar | 4 | 0 | | |
TOPSales |
50 | VBAP | Sales Document: Item Data | 247 | FONDS | Fund | nvarchar | 10 | 0 | | |