| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAvailability Control |
1 | FMAVCA | Actual line item table | 20 | RMEASURE | Funded Program | nvarchar | 24 | 0 | | |
2 | FMAVCP | Plan line items table | 20 | RMEASURE | Funded Program | nvarchar | 24 | 0 | | |
3 | FMAVCT | AVC Summary Table (BCS) | 19 | RMEASURE | Funded Program | nvarchar | 24 | 0 | | |
TOPBudgeting |
4 | FMBDA | Actual line item table | 20 | RMEASURE | Funded Program | nvarchar | 24 | 0 | | |
5 | FMBDP | FM Budget change line items table | 20 | RMEASURE | Funded Program | nvarchar | 24 | 0 | | |
6 | FMBDT | FM budget totals table | 19 | RMEASURE | Funded Program | nvarchar | 24 | 0 | | |
7 | FMRBA | Actual line item table | 20 | RMEASURE | Funded Program | nvarchar | 24 | 0 | | |
8 | FMRBP | Plan line items table | 20 | RMEASURE | Funded Program | nvarchar | 24 | 0 | | |
9 | FMRBT | Summary table | 19 | RMEASURE | Funded Program | nvarchar | 24 | 0 | | |
TOPFunds Management |
10 | FMCCFD | Fiscal Year Change Documents (FM) | 33 | RMEASURE | Receiver Funded Program (Fiscal Year Change FM) | nvarchar | 24 | 0 | | |
11 | FMCCFLOT | Commitment Carryforward of Held Documents (Approval Proc.) | 28 | RMEASURE | Receiver Funded Program (Fiscal Year Change FM) | nvarchar | 24 | 0 | | |
12 | FMIA | Actual Line Item Table for Funds Management | 27 | RMEASURE | Funded Program | nvarchar | 24 | 0 | | |
13 | FMIP | Plan Line Items Table for Funds Management | 26 | RMEASURE | Funded Program | nvarchar | 24 | 0 | | |
14 | FMIT | Totals Table for Funds Management | 25 | RMEASURE | Funded Program | nvarchar | 24 | 0 | | |