| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPFunds Management |
1 | FMFCPO | FIFM: Commitment Summarization Item | 10 | AENDAT | FIFM: Changed on | nvarchar | 8 | 0 | | |
2 | FMFCTR | Funds Center Master Record | 9 | AENDAT | FIFM: Changed on | nvarchar | 8 | 0 | | |
3 | FMFINCODE | FIFM: Financing code | 9 | AENDAT | FIFM: Changed on | nvarchar | 8 | 0 | | |
4 | FMFIPGR | Budget Structure Template | 9 | AENDAT | FIFM: Changed on | nvarchar | 8 | 0 | | |
5 | FMFPO | FIFM: Commitment Item | 15 | AENDAT | FIFM: Changed on | nvarchar | 8 | 0 | | |
6 | FMFUNDBPD | FM: Assignments of Funds to Budget Periods | 9 | AENDAT | FIFM: Changed on | nvarchar | 8 | 0 | | |
7 | FMFUSE | FIFM: Application of Funds from Secondary Sources | 9 | AENDAT | FIFM: Changed on | nvarchar | 8 | 0 | | |
8 | FMHICI | Commitment items hierarchy | 14 | AENDAT | FIFM: Changed on | nvarchar | 8 | 0 | | |
9 | FMHICTR | FIFB: DB Table for Hierarchy Relations in a Center | 12 | AENDAT | FIFM: Changed on | nvarchar | 8 | 0 | | |
10 | FMHIPG | Hierarchy Table of Commitment Items in Fiscal Year | 15 | AENDAT | FIFM: Changed on | nvarchar | 8 | 0 | | |
11 | FMHIPOS | FIFM: DB Table for Hierarchy Relations for an Item | 14 | AENDAT | FIFM: Changed on | nvarchar | 8 | 0 | | |
12 | FMHIPP | Hierarchy Table of Commitment Items in Chart of Cmmt Items | 14 | AENDAT | FIFM: Changed on | nvarchar | 8 | 0 | | |
TOPPayment Transactions |
13 | T042U | Block Entries for Debit Customers/Credit Vendors | 9 | AENDAT | Date of last change | nvarchar | 8 | 0 | | |
TOPProduct Cost by Period |
14 | CHZP | Reporting Points - Change History | 4 | AENDAT | Date Document Was Created | nvarchar | 8 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
15 | /BEV3/CHSORTK | CH Assortments Header | 9 | AENDAT | Date | nvarchar | 8 | 0 | | |