| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | BBP_PCACC | Procurement Card: Accounting Data | 30 | RES_ITEM | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
2 | BBP_PCMOD | Procurement Card: Modified Statement Data | 32 | RES_ITEM | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
3 | BBP_PDACC | Account Assignment | 44 | RES_ITEM | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
TOPAP-LIM Logistics Inventory Management Engine |
4 | /LIME/COLL_APS | Collection for Planning System | 85 | RES_ITEM | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
5 | /LIME/COLL_BW | Collection for Business Warehouse | 85 | RES_ITEM | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
6 | /LIME/COLL_FIN | Collection for Financial System | 85 | RES_ITEM | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
7 | /LIME/COLL_INV | Collection for Inventory System | 85 | RES_ITEM | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
8 | /LIME/COLL_LEG | Collection for External System | 85 | RES_ITEM | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
9 | /LIME/COLL_MMIM | Collection for R/3 Inventory Management | 85 | RES_ITEM | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
10 | /LIME/COLL_W2IM | Collection for WME after ERP-MMIM | 85 | RES_ITEM | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
11 | /LIME/PN_ITEM | Table to Save Prima Nota Item Data | 59 | RES_ITEM | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
TOPFunds Management |
12 | IAOM_GTR_EXAT | Grantor: Account Assignment Manager External Characteristics | 12 | RES_ITEM | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
TOPLogistics - General |
13 | CRM_SRV_RESERV | CRM Service Reservations | 5 | RES_ITEM | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |