| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAvailability Control |
1 | FMAVCA | Actual line item table | 25 | ALLOCTYPE_9 | Amount Type (Availability Control) | nvarchar | 4 | 0 | | |
2 | FMAVCC | Object table 2 | 5 | ALLOCTYPE_9 | Amount Type (Availability Control) | nvarchar | 4 | 0 | | |
3 | FMAVCP | Plan line items table | 25 | ALLOCTYPE_9 | Amount Type (Availability Control) | nvarchar | 4 | 0 | | |
4 | FMAVCT | AVC Summary Table (BCS) | 24 | ALLOCTYPE_9 | Amount Type (Availability Control) | nvarchar | 4 | 0 | | |
TOPFund Accounting |
5 | FMCCAVCA | Actual line item table | 21 | ALLOCTYPE_9 | Amount Type (Availability Control) | nvarchar | 4 | 0 | | |
6 | FMCCAVCC | Object table 2 | 4 | ALLOCTYPE_9 | Amount Type (Availability Control) | nvarchar | 4 | 0 | | |
7 | FMCCAVCP | Plan line items table | 21 | ALLOCTYPE_9 | Amount Type (Availability Control) | nvarchar | 4 | 0 | | |
8 | FMCCAVCT | Totals Table | 20 | ALLOCTYPE_9 | Amount Type (Availability Control) | nvarchar | 4 | 0 | | |
TOPGrantee Management |
9 | GMAVCA | Actual line item table | 22 | ALLOCTYPE_9 | Amount Type (Availability Control) | nvarchar | 4 | 0 | | |
10 | GMAVCC | Object table 2 | 5 | ALLOCTYPE_9 | Amount Type (Availability Control) | nvarchar | 4 | 0 | | |
11 | GMAVCP | Plan line items table | 22 | ALLOCTYPE_9 | Amount Type (Availability Control) | nvarchar | 4 | 0 | | |
12 | GMAVCT | Summary table | 21 | ALLOCTYPE_9 | Amount Type (Availability Control) | nvarchar | 4 | 0 | | |