| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /OPT/AT_APPR_HIS | Approval History for Level Based Approvals | 77 | CMMT_ITEM | Commitment Item | nvarchar | 14 | 0 | | |
2 | /OPT/AT_LBA_LOG | Approval History for Level Based Approvals | 78 | CMMT_ITEM | Commitment Item | nvarchar | 14 | 0 | | |
3 | /SAPPSSRM/C_UFD | Incremental Funding: Customizing for the Unfunded Acctg Line | 3 | CMMT_ITEM | Commitment Item | nvarchar | 14 | 0 | | |
4 | /SAPPSSRM/SPFSET | Selective Release - Blocking Options by Account | 6 | CMMT_ITEM | Commitment Item | nvarchar | 14 | 0 | | |
5 | /SAPPSSRM/TGMACC | IBU PS: link table between Contract data and earmarked funds | 13 | CMMT_ITEM | Commitment Item | nvarchar | 24 | 0 | | |
6 | BBP_PCACC | Procurement Card: Accounting Data | 26 | CMMT_ITEM | Commitment Item | nvarchar | 14 | 0 | | |
7 | BBP_PCMOD | Procurement Card: Modified Statement Data | 28 | CMMT_ITEM | Commitment Item | nvarchar | 14 | 0 | | |
8 | BBP_PDACC | Account Assignment | 30 | CMMT_ITEM | Commitment Item | nvarchar | 24 | 0 | | |
9 | REQACCT | Account Assignment for the Req. Coverage Request Lines | 33 | CMMT_ITEM | Commitment Item | nvarchar | 14 | 0 | | |
TOPAP-LIM Logistics Inventory Management Engine |
10 | /LIME/COLL_APS | Collection for Planning System | 99 | CMMT_ITEM | Commitment Item | nvarchar | 14 | 0 | | |
11 | /LIME/COLL_BW | Collection for Business Warehouse | 99 | CMMT_ITEM | Commitment Item | nvarchar | 14 | 0 | | |
12 | /LIME/COLL_FIN | Collection for Financial System | 99 | CMMT_ITEM | Commitment Item | nvarchar | 14 | 0 | | |
13 | /LIME/COLL_INV | Collection for Inventory System | 99 | CMMT_ITEM | Commitment Item | nvarchar | 14 | 0 | | |
14 | /LIME/COLL_LEG | Collection for External System | 99 | CMMT_ITEM | Commitment Item | nvarchar | 14 | 0 | | |
15 | /LIME/COLL_MMIM | Collection for R/3 Inventory Management | 99 | CMMT_ITEM | Commitment Item | nvarchar | 14 | 0 | | |
16 | /LIME/COLL_W2IM | Collection for WME after ERP-MMIM | 99 | CMMT_ITEM | Commitment Item | nvarchar | 14 | 0 | | |
TOPBasis Components |
17 | /XFT/INV_Q_11 | Account assignment data | 24 | CMMT_ITEM | Commitment Item | nvarchar | 14 | 0 | | |
18 | /XFT/INV_Q_11_S | Account assignment data | 24 | CMMT_ITEM | Commitment Item | nvarchar | 14 | 0 | | |
TOPFunctions for U.S. Federal Government |
19 | FMFGYECLAA | US Federal Gov't : Y/E Pre-Closing of Anticipated Accounts | 6 | CMMT_ITEM | Commitment Item | nvarchar | 24 | 0 | | |
TOPFunds Management |
20 | FMBUDBCS | Budgetary ledger account derivation: BCS | 11 | CMMT_ITEM | Commitment Item | nvarchar | 24 | 0 | | |
21 | FMBUDDIS | Budgetary ledger account derivation: Budgeting (old) | 11 | CMMT_ITEM | Commitment Item | nvarchar | 24 | 0 | | |
TOPGrantee Management |
22 | GMIA | Actual Line Item Table | 56 | CMMT_ITEM | Commitment Item | nvarchar | 24 | 0 | | |
TOPIncentive and Commission Management ICM |
23 | YCRM01_ACCAS | Account Assignment Type/Cost Information for Remuneration | 24 | CMMT_ITEM | Commitment Item | nvarchar | 24 | 0 | | |
24 | YTEL01_ACCAS | Account Assignment Type/Cost Information for Remuneration | 11 | CMMT_ITEM | Commitment Item | nvarchar | 24 | 0 | | |
TOPStructures Workbench |
25 | /ISDFPS/CMATPLN | Parameters for Material Planning | 15 | CMMT_ITEM | Commitment Item | nvarchar | 14 | 0 | | |
TOPTravel Expenses |
26 | PTRV_COMM_ITM | Header Data: Transfer to FM When Trip Saved | 21 | CMMT_ITEM | Commitment Item | nvarchar | 14 | 0 | | |
27 | PTRV_SCOS | Trip Statistics - Cost Assignment | 19 | CMMT_ITEM | Commitment Item | nvarchar | 14 | 0 | | |