| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /OPT/VIM_STG_PO | Table: Staging data - Purchase Orders & Deliveries for ICC | 2 | ORDERID | Purchasing Document Number | nvarchar | 10 | 0 | | |
2 | /OPT/VIM_STG_POH | Table: PO header staging data for Download Infrastructure | 3 | ORDERID | Purchasing Document Number | nvarchar | 10 | 0 | | |
3 | /OPT/VIM_STG_POI | Table: PO Item staging data for Download Infrastructure | 3 | ORDERID | Purchasing Document Number | nvarchar | 10 | 0 | | |
4 | BBP_PCACC | Procurement Card: Accounting Data | 17 | ORDERID | Order Number | nvarchar | 12 | 0 | | |
5 | BBP_PCMOD | Procurement Card: Modified Statement Data | 19 | ORDERID | Order Number | nvarchar | 12 | 0 | | |
6 | IUUC_REPL_ORDER | Replication Worklist for use with API | 3 | ORDERID | | int | 10 | 0 | | |
7 | T5FDSNFILE_ORDER | DSN: Define the order to process response file of the GIP | 1 | ORDERID | File order ID | int | 10 | 0 | | |
8 | T5FDSNSTATORDER | DSN: It contains the list of the statuses and their order | 2 | ORDERID | Numc3, internal use | nvarchar | 3 | 0 | | |
TOPAccrual Engine |
9 | ACEDSASSGMT | Standard Account Assignments for Accrual Objects | 11 | ORDERID | Order Number | nvarchar | 12 | 0 | | |
TOPAP-LIM Logistics Inventory Management Engine |
10 | /LIME/COLL_APS | Collection for Planning System | 91 | ORDERID | Order Number | nvarchar | 12 | 0 | | |
11 | /LIME/COLL_BW | Collection for Business Warehouse | 91 | ORDERID | Order Number | nvarchar | 12 | 0 | | |
12 | /LIME/COLL_FIN | Collection for Financial System | 91 | ORDERID | Order Number | nvarchar | 12 | 0 | | |
13 | /LIME/COLL_INV | Collection for Inventory System | 91 | ORDERID | Order Number | nvarchar | 12 | 0 | | |
14 | /LIME/COLL_LEG | Collection for External System | 91 | ORDERID | Order Number | nvarchar | 12 | 0 | | |
15 | /LIME/COLL_MMIM | Collection for R/3 Inventory Management | 91 | ORDERID | Order Number | nvarchar | 12 | 0 | | |
16 | /LIME/COLL_W2IM | Collection for WME after ERP-MMIM | 91 | ORDERID | Order Number | nvarchar | 12 | 0 | | |
TOPBasis Components |
17 | /XFT/INV_Q_11 | Account assignment data | 22 | ORDERID | Order Number | nvarchar | 12 | 0 | | |
18 | /XFT/INV_Q_11_S | Account assignment data | 22 | ORDERID | Order Number | nvarchar | 12 | 0 | | |
TOPClinical System |
19 | N2CLIM_OBSVS | Vital Signs: Examination | 19 | ORDERID | Order Number | nvarchar | 255 | 0 | | |
TOPCross-Application Components |
20 | /EAM/EAMT_ORDER | Stores order numbers temporarily for Push implementation | 2 | ORDERID | Order Number | nvarchar | 12 | 0 | | |
21 | ALM_ME_SYNC_ARCH | MAM 1.0 Obsolete | 4 | ORDERID | | nvarchar | 12 | 0 | | |
TOPField Service |
22 | IWWO | Pervasive Service: Cluster with Internet Data | 8 | ORDERID | Order Number | nvarchar | 12 | 0 | | |
TOPGrantee Management |
23 | GMIA | Actual Line Item Table | 47 | ORDERID | Order Number | nvarchar | 12 | 0 | | |
TOPIncentive and Commission Management ICM |
24 | CACSHR_DOCHR_PD | Settlement to PY: Reference Line Item | 10 | ORDERID | Order Number | nvarchar | 12 | 0 | | |
25 | YCRM01_ACCAS | Account Assignment Type/Cost Information for Remuneration | 14 | ORDERID | Order Number | nvarchar | 12 | 0 | | |
26 | YTEL01_ACCAS | Account Assignment Type/Cost Information for Remuneration | 22 | ORDERID | Order Number | nvarchar | 12 | 0 | | |
TOPMaintenance Processing |
27 | ALM_ME_SYNC | Sync Status | 4 | ORDERID | Order Number | nvarchar | 12 | 0 | | |
TOPMaster Data |
28 | GMGR | Grant Master | 61 | ORDERID | Order Number | nvarchar | 12 | 0 | | |
TOPProduction Backflush |
29 | PPC_HEAD | Document PP Backflush - Header | 3 | ORDERID | Key (UID) for an order | nvarchar | 22 | 0 | | |
30 | PPC_ORD_INF | Information on APO Order | 2 | ORDERID | Key (UID) for an order | nvarchar | 22 | 0 | | |
TOPRental Accounting |
31 | VIEXCFCNDNS | Cash Flow Summarization | 39 | ORDERID | Order Number | nvarchar | 12 | 0 | | |
TOPRevenues and Earnings |
32 | AD01DLI | Dynamic items (DI) | 51 | ORDERID | Order Number | nvarchar | 12 | 0 | | |
TOPSAP Retail Store |
33 | WOSCR_EXI_ST_02 | Vendor Invoice - Store Settings (FI/CO) | 5 | ORDERID | Order Number | nvarchar | 12 | 0 | | |
34 | WOSCR_SITE_GRP | Cash Balancing: Settings for Each Group of Accounts | 6 | ORDERID | Order Number | nvarchar | 12 | 0 | | |
TOPTravel Expenses |
35 | PTRV_COMM_ITM | Header Data: Transfer to FM When Trip Saved | 16 | ORDERID | Order Number | nvarchar | 12 | 0 | | |