| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /ATL/FORDOCSPLIT | Document Header and Line details for Splitting | 8 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
2 | BSAS_BAK | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 76 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
3 | BSEG | Accounting Document Segment | 314 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
4 | BSIS_BAK | Accounting: Secondary Index for G/L Accounts | 76 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
5 | FMADB_DEFAULT_AA | FMADB: Default Account Assignment for Petty Amounts | 9 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
6 | FMADB_TC_WEIGHTS | FMADB: Trace - Saved Weights (Last Run) | 12 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
7 | FMBASOBJNR_TRACE | Trace for table FMBASOBJNR | 9 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
8 | FMBCS_FMBL_CD | Empty table for change documents on FMBL incl. local. fields | 17 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
9 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 303 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
10 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 303 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
11 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 303 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
12 | GLPOS_C_CT | FI Document: Entry View | 173 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
13 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 173 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
14 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 173 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
15 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 173 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
16 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 176 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
17 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 176 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
18 | T7PIQSINGLEFEES | Define Attributes for Individual Fees | 25 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
TOPAccounting Interface |
19 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 410 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
20 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 410 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
TOPActual Update and Commitment Update |
21 | GMREVBDGTFM1 | Defult settings for GM revaluation of currency | 8 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
TOPAvailability Control |
22 | FMAVCO | Object table 1 | 14 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
TOPBudget Control System |
23 | FMBASOBJNR | Object numbers for FM addresses | 11 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
TOPBudgeting |
24 | BUCC_RULE | Consistency Checks - Rules | 19 | MEASURE | Key Figures - Program in Funds Management | nvarchar | 1 | 0 | | |
25 | FMBDO | Object table 1 - Budget address | 14 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
26 | FMBL | Funds management budget document lines (entry documents) | 17 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
27 | FMHBL | Funds management budget document lines (held documents) | 17 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
28 | FMPEP_VARIANTL | Session variants (line part) for transaction FMPEP | 17 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
29 | FMRBO | Object table 1 | 14 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
TOPBudgeting and Availability Control |
30 | GMBDGTFYDLINE | GM Budgeting Fiscal Year Distribution Lines | 19 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
31 | GMFMRECS | GM RIB: FM Receivers (obsolete) | 10 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
32 | GMFMRECS1 | GM RIB: FM Budget Receivers | 7 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
33 | GMHBDGTFYDLINE | GM Budgeting Fiscal Year Distribution Lines | 20 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
TOPContract Accounts Receivable and Payable |
34 | DFKKFMBGAINFO | Tax Information for Public-Owned Commercial Operations | 12 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
35 | DFKKFMDYINFO | Log Data for Subsequent FM Activation in FI-CA | 8 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
36 | DFKKOPAA | Distribution Items with Account Assignment | 27 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
37 | DFKKOP_REP | Open Items from FPO4 | 161 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
38 | DFKKRP3 | Returns: Manual Posting Specifications | 27 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
39 | DFKKSUM | Posting totals from FI-CA | 64 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
40 | DFKKSUMOLD | Totals Records Without Account Assignment Changes | 20 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
41 | TFKFMDY2 | Account Assignments for Subsequent FM Activation | 7 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
TOPDepreciation Simulation |
42 | IMCC | IM Summarization: Characteristics that are master data | 9 | MEASURE | Measure: Identification for internal use | nvarchar | 26 | 0 | | |
43 | IMCEM | IM Summarization: Measures | 3 | MEASURE | Measure: Identification for internal use | nvarchar | 26 | 0 | | |
44 | IMCEMT | IM Summarization: Texts for measures | 4 | MEASURE | Measure: Identification for internal use | nvarchar | 26 | 0 | | |
TOPFinancial Accounting |
45 | ACCTIT | Compressed Data from FI/CO Document | 162 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
46 | BSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 76 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
47 | BSIS | Accounting: Secondary Index for G/L Accounts | 76 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
48 | VBSEGA | Document Segment for Document Parking - Asset Database | 89 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
49 | VBSEGS | Document Segment for Document Parking - G/L Account Database | 144 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
TOPFunctions for U.S. Federal Government |
50 | FMFGKEY | Key for Facts-Attributes for Ledger 95/FMUSFGT | 4 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
51 | FMFGKEY96 | Key for FACTS - Attributes for Ledger 96/FMUSFGFACTS1T | 11 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
52 | FMFGKEY97 | Key for FACTS - Attributes for Ledger 97/FMUSFGFACTS2T | 4 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
TOPFund Accounting |
53 | FMADB_ENTITY | ADB: Entities Involved in Procedure | 7 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
TOPFunds Management |
54 | FMFG_SAV_FACTS1A | Saved FACTS1A data for docs excluded from SL Repost for 600 | 64 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
55 | FMFG_SAV_FACTS2A | Saved FACTS2A data for docs excluded from SL Repost for 600 | 62 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
56 | FMFG_SAV_FMUSFGA | Saved FMUSFGA data for docs excluded from SL Repost for 600 | 90 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
57 | FMIFIIT | FI Line Item Table in Funds Management | 22 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
58 | FMIO | Object Table for Funds Management | 21 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
59 | FMIOI | Commitment Documents Funds Management | 28 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
60 | FMSPLITA | Actual line item table | 37 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
61 | FMSPLITC | Object table 2 | 5 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
62 | FMSPLITP | Plan line items table | 69 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
63 | FMSPLITT | Summary table | 24 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
64 | FMUSFGA | Actual line item table for US Federal Government. | 90 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
65 | FMUSFGFACTS1A | 4Actual line item table | 64 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
66 | FMUSFGFACTS1T | Summary table | 73 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
67 | FMUSFGFACTS2A | Actual line item table | 62 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
68 | FMUSFGFACTS2T | Summary table | 71 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
69 | FMUSFGT | Summary table for US Federal Government | 68 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
70 | FMZUOB | Allocation of CO Object to FM Account Assignment | 16 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
71 | IAOM_GTR_EXAT | Grantor: Account Assignment Manager External Characteristics | 9 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
72 | KBLP | Document Item: Manual Document Entry | 92 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
TOPFunds Management-Specific Postings |
73 | FMFUNDTRANSYEAR | Additional Documents for Funds Transfer to Diff. Years | 125 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
74 | PSOSEGA | Document Segment for Assets Document Parking | 46 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
75 | PSOSEGS | Recurring Request Document Segment, G/L Accounts | 137 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
TOPGeneral Ledger Accounting |
76 | BSEG_ADD | Entry View of Accounting Document for Additional Ledgers | 72 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
77 | FAGL_SPLINFO | Splittling Information of Open Items | 74 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
TOPGrantee Management |
78 | GMIA | Actual Line Item Table | 58 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
TOPInvoice Verification |
79 | RBCO | Document Item, Incoming Invoice, Account Assignment | 77 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
TOPMaster Data |
80 | FMMEASURE | FM Funded Program Master Data | 3 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
81 | FMMEASURET | FM Funded Program Text Table | 4 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
82 | GMSPPROGRAM | Sponsored program master | 7 | MEASURE | Obsolete - do not use | nvarchar | 24 | 0 | | |
83 | GMSPPROGRAM_FMBT | Sponsored Program Master Data - Budget Transfer Objects | 6 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
TOPPurchasing |
84 | EKCPA | Purchasing Contract Commitment Plan Account Assignment Data | 23 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |
TOPRental Accounting |
85 | VIEXCFCNDNS | Cash Flow Summarization | 31 | MEASURE | Program in Funds Management | nvarchar | 24 | 0 | | |
86 | VIRADOCITEM | RE Document Item | 36 | MEASURE | Program in Funds Management | nvarchar | 24 | 0 | | |
87 | VITMOA | Term: Organizational Assignment | 16 | MEASURE | Program in Funds Management | nvarchar | 24 | 0 | | |
TOPRepetitive Manufacturing |
88 | COMPMOVE | Goods Movement of Components | 136 | MEASURE | Funded Program | nvarchar | 24 | 0 | | |