| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAvailability Control |
1 | FMAVCA | Actual line item table | 24 | WFSTATE_9 | Workflow Status of a Record in the AVC Totals Table | nvarchar | 1 | 0 | | |
2 | FMAVCC | Object table 2 | 4 | WFSTATE_9 | Workflow Status of a Record in the AVC Totals Table | nvarchar | 1 | 0 | | |
3 | FMAVCP | Plan line items table | 24 | WFSTATE_9 | Workflow Status of a Record in the AVC Totals Table | nvarchar | 1 | 0 | | |
4 | FMAVCT | AVC Summary Table (BCS) | 23 | WFSTATE_9 | Workflow Status of a Record in the AVC Totals Table | nvarchar | 1 | 0 | | |
TOPBudgeting |
5 | FMBDA | Actual line item table | 24 | WFSTATE_9 | Workflow Status of a Record in the Budget Totals Table | nvarchar | 1 | 0 | | |
6 | FMBDC | Object table 2 | 5 | WFSTATE_9 | Workflow Status of a Record in the Budget Totals Table | nvarchar | 1 | 0 | | |
7 | FMBDP | FM Budget change line items table | 24 | WFSTATE_9 | Workflow Status of a Record in the Budget Totals Table | nvarchar | 1 | 0 | | |
8 | FMBDT | FM budget totals table | 23 | WFSTATE_9 | Workflow Status of a Record in the Budget Totals Table | nvarchar | 1 | 0 | | |
9 | FMPEPLAY_COL | FMPEP: layout customizing settings for columns | 12 | WFSTATE_9 | Workflow Status of a Record in the Budget Totals Table | nvarchar | 1 | 0 | | |
TOPFund Accounting |
10 | FMCCAVCA | Actual line item table | 20 | WFSTATE_9 | Workflow Status of a Record in the AVC Totals Table | nvarchar | 1 | 0 | | |
11 | FMCCAVCC | Object table 2 | 3 | WFSTATE_9 | Workflow Status of a Record in the AVC Totals Table | nvarchar | 1 | 0 | | |
12 | FMCCAVCP | Plan line items table | 20 | WFSTATE_9 | Workflow Status of a Record in the AVC Totals Table | nvarchar | 1 | 0 | | |
13 | FMCCAVCRESERVE | CCAVC aux table for reserved items | 21 | WFSTATE_9 | Workflow Status of a Record in the AVC Totals Table | nvarchar | 1 | 0 | | |
14 | FMCCAVCT | Totals Table | 19 | WFSTATE_9 | Workflow Status of a Record in the AVC Totals Table | nvarchar | 1 | 0 | | |
TOPGrantee Management |
15 | GMAVCA | Actual line item table | 21 | WFSTATE_9 | Workflow Status of a Record in the AVC Totals Table | nvarchar | 1 | 0 | | |
16 | GMAVCC | Object table 2 | 4 | WFSTATE_9 | Workflow Status of a Record in the AVC Totals Table | nvarchar | 1 | 0 | | |
17 | GMAVCP | Plan line items table | 21 | WFSTATE_9 | Workflow Status of a Record in the AVC Totals Table | nvarchar | 1 | 0 | | |
18 | GMAVCT | Summary table | 20 | WFSTATE_9 | Workflow Status of a Record in the AVC Totals Table | nvarchar | 1 | 0 | | |