| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPFunctions for U.S. Federal Government |
1 | FMFGKEY96 | Key for FACTS - Attributes for Ledger 96/FMUSFGFACTS1T | 9 | SGL_ACCOUNT | Standard General Ledger Account for US Federal Government | nvarchar | 6 | 0 | | |
TOPFunds Management |
2 | FMFGF2EDGRP | SGL Accounts Edits 2, 3, 5, 10, 11 (FACTS II) | 3 | SGL_ACCOUNT | Standard General Ledger Account for US Federal Government | nvarchar | 6 | 0 | | |
3 | FMFGF2EDINV | Edit 6 - Investment Authority (FACTS II) | 3 | SGL_ACCOUNT | Standard General Ledger Account for US Federal Government | nvarchar | 6 | 0 | | |
4 | FMFGF2EDPRF | Edit 8- SF 133 Proof Edit (FACTS II) | 3 | SGL_ACCOUNT | Standard General Ledger Account for US Federal Government | nvarchar | 6 | 0 | | |
5 | FMFGF2EDSGL | SGL Account Edits 4, 7, 12 (FACTS II) | 3 | SGL_ACCOUNT | Standard General Ledger Account for US Federal Government | nvarchar | 6 | 0 | | |
6 | FMFGF2FADT | (FACTS II) Account Balance Definition Table | 4 | SGL_ACCOUNT | Standard General Ledger Account for US Federal Government | nvarchar | 6 | 0 | | |
7 | FMFGF2PREDA | Pre-edit A - Authority (FACTS II) | 3 | SGL_ACCOUNT | Standard General Ledger Account for US Federal Government | nvarchar | 6 | 0 | | |
8 | FMFGF2PREDC | Pre-edit C - Expired/Unexpired (FACTS II) | 2 | SGL_ACCOUNT | Standard General Ledger Account for US Federal Government | nvarchar | 6 | 0 | | |
9 | FMFGF2_SGL | FMFG2 - FACTS II SGL Accounts | 2 | SGL_ACCOUNT | Standard General Ledger Account for US Federal Government | nvarchar | 6 | 0 | | |
10 | FMFGF2_SGLATR | FMFG2 - FACTS SGL Attributes | 2 | SGL_ACCOUNT | Standard General Ledger Account for US Federal Government | nvarchar | 6 | 0 | | |
11 | FMFGF2_SGLATRVAL | FMFG2 - FACTS II SGL Account Attribute Allowable Values | 2 | SGL_ACCOUNT | Standard General Ledger Account for US Federal Government | nvarchar | 6 | 0 | | |
12 | FMFGF2_SGL_TEXTS | FACTS2 - SGL Text Table | 3 | SGL_ACCOUNT | Standard General Ledger Account for US Federal Government | nvarchar | 6 | 0 | | |
13 | FMFG_SAV_FACTS1A | Saved FACTS1A data for docs excluded from SL Repost for 600 | 60 | SGL_ACCOUNT | Standard General Ledger Account for US Federal Government | nvarchar | 6 | 0 | | |
14 | FMFG_SAV_FACTS2A | Saved FACTS2A data for docs excluded from SL Repost for 600 | 59 | SGL_ACCOUNT | Standard General Ledger Account for US Federal Government | nvarchar | 6 | 0 | | |
15 | FMFG_SAV_FMUSFGA | Saved FMUSFGA data for docs excluded from SL Repost for 600 | 82 | SGL_ACCOUNT | Standard General Ledger Account for US Federal Government | nvarchar | 6 | 0 | | |
16 | FMUSFGA | Actual line item table for US Federal Government. | 82 | SGL_ACCOUNT | Standard General Ledger Account for US Federal Government | nvarchar | 6 | 0 | | |
17 | FMUSFGFACTS1A | 4Actual line item table | 60 | SGL_ACCOUNT | Standard General Ledger Account for US Federal Government | nvarchar | 6 | 0 | | |
18 | FMUSFGFACTS1T | Summary table | 71 | SGL_ACCOUNT | Standard General Ledger Account for US Federal Government | nvarchar | 6 | 0 | | |
19 | FMUSFGFACTS2A | Actual line item table | 59 | SGL_ACCOUNT | Standard General Ledger Account for US Federal Government | nvarchar | 6 | 0 | | |
20 | FMUSFGFACTS2T | Summary table | 69 | SGL_ACCOUNT | Standard General Ledger Account for US Federal Government | nvarchar | 6 | 0 | | |
21 | FMUSFGT | Summary table for US Federal Government | 67 | SGL_ACCOUNT | Standard General Ledger Account for US Federal Government | nvarchar | 6 | 0 | | |