| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPFund Accounting |
1 | FMCCAVCA | Actual line item table | 16 | RBUDGET_PD | FM: Budget Period | nvarchar | 10 | 0 | | |
2 | FMCCAVCP | Plan line items table | 16 | RBUDGET_PD | FM: Budget Period | nvarchar | 10 | 0 | | |
3 | FMCCAVCT | Totals Table | 15 | RBUDGET_PD | FM: Budget Period | nvarchar | 10 | 0 | | |
4 | PSGLFLEX07 | General Ledger: Reserve Table 1 | 5 | RBUDGET_PD | FM: Budget Period | nvarchar | 10 | 0 | | |
5 | PSGLFLEXA | General Ledger: Actual Line Items | 31 | RBUDGET_PD | FM: Budget Period | nvarchar | 10 | 0 | | |
6 | PSGLFLEXP | General Ledger: Plan Line Items | 33 | RBUDGET_PD | FM: Budget Period | nvarchar | 10 | 0 | | |
7 | PSGLFLEXT | General Ledger Public Sector: Total | 40 | RBUDGET_PD | FM: Budget Period | nvarchar | 10 | 0 | | |
TOPFunds Management |
8 | FMCCFD | Fiscal Year Change Documents (FM) | 49 | RBUDGET_PD | FM: Receiver Budget Period | nvarchar | 10 | 0 | | |
9 | FMCCFLOT | Commitment Carryforward of Held Documents (Approval Proc.) | 30 | RBUDGET_PD | FM: Receiver Budget Period | nvarchar | 10 | 0 | | |