| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPClinical System |
1 | N1CONNDEMO | Connectivity: Demo Table for Local Handler | 6 | ORDERNR | Order Number | nvarchar | 10 | 0 | | |
TOPContract Billing |
2 | DBERCHZ4 | Individual line items (rarely used fields) | 33 | ORDERNR | Internal Number for Identifying a Waste Disposal Order | nvarchar | 20 | 0 | | |
3 | DBERCHZ8 | Document line items (rarely used fields, unimportant) | 33 | ORDERNR | Internal Number for Identifying a Waste Disposal Order | nvarchar | 20 | 0 | | |
TOPPortal Content |
4 | ISTNLMORDERAL | Orders with Triggered Alerts | 2 | ORDERNR | Order Number | nvarchar | 12 | 0 | | |
TOPPosition Budgeting and Control |
5 | T77HRFPM_AC | HRFPM: Cust Tab for Activating Activities in HR | 2 | ORDERNR | Sequence of Execution of Additional Checks in HR | nvarchar | 3 | 0 | | |
6 | T77HRFPM_CHECK | HRFPM: Cust. Tab for Activating Checks in HR | 2 | ORDERNR | Sequence of Execution of Additional Checks in HR | nvarchar | 3 | 0 | | |
7 | T77HRFPM_OCC_CHK | HRFPM: Cust Tab for Activating Staff Assignment Rules | 4 | ORDERNR | Sequence of Execution of Additional Checks in HR | nvarchar | 3 | 0 | | |
TOPProduction Backflush |
8 | PPC_ORD_INF | Information on APO Order | 10 | ORDERNR | External Number for an Order | nvarchar | 12 | 0 | | |
TOPWaste Management |
9 | EWATDEVLOC | Provisional Container/Container Location Allocation | 2 | ORDERNR | Internal Number for Identifying a Waste Disposal Order | nvarchar | 20 | 0 | | |
10 | EWA_ORDER_BULKY | Bulk Waste Objects for Item in Waste Disposal Order | 2 | ORDERNR | Internal Number for Identifying a Waste Disposal Order | nvarchar | 20 | 0 | | |
11 | EWA_ORDER_HD_CO | Header Table for Waste Disposal Order (CO Data) | 2 | ORDERNR | Internal Number for Identifying a Waste Disposal Order | nvarchar | 20 | 0 | | |
12 | EWA_ORDER_HD_CP | Header Table for Waste Disposal Order (CO-PA Data) | 2 | ORDERNR | Internal Number for Identifying a Waste Disposal Order | nvarchar | 20 | 0 | | |
13 | EWA_ORDER_HEAD | Header Table for Waste Disposal Order | 2 | ORDERNR | Internal Number for Identifying a Waste Disposal Order | nvarchar | 20 | 0 | | |
14 | EWA_ORDER_OBJECT | Item Table for Waste Disposal Order | 2 | ORDERNR | Internal Number for Identifying a Waste Disposal Order | nvarchar | 20 | 0 | | |
15 | EWA_ORDER_OBJ_CO | Item Table in Waste Disposal Order (CO Data) | 2 | ORDERNR | Internal Number for Identifying a Waste Disposal Order | nvarchar | 20 | 0 | | |
16 | EWA_ORDER_OBJ_CP | Item Table in Waste Disposal Order (CO-PA Data) | 2 | ORDERNR | Internal Number for Identifying a Waste Disposal Order | nvarchar | 20 | 0 | | |
17 | EWA_ORDER_OBJ_SD | SD Contracts for Waste Disposal Order Item | 2 | ORDERNR | Internal Number for Identifying a Waste Disposal Order | nvarchar | 20 | 0 | | |
18 | EWA_ORDER_RESOBJ | Resource Table for Waste Disposal Order | 2 | ORDERNR | Internal Number for Identifying a Waste Disposal Order | nvarchar | 20 | 0 | | |
19 | EWA_ORDER_WEIGH | Weighing Data for Waste Disposal Order | 2 | ORDERNR | Internal Number for Identifying a Waste Disposal Order | nvarchar | 20 | 0 | | |
20 | EWA_ORDER_WGH_CO | Weighing Data Table for Waste Disposal Order (CO Data) | 2 | ORDERNR | Internal Number for Identifying a Waste Disposal Order | nvarchar | 20 | 0 | | |
21 | EWA_ORDER_WGH_CP | Weighing Data Table for Waste Disposal Order (CO-PA Data) | 2 | ORDERNR | Internal Number for Identifying a Waste Disposal Order | nvarchar | 20 | 0 | | |
22 | EWA_WA_WEIGHOFFL | Offline Weighing | 9 | ORDERNR | Internal Number for Identifying a Waste Disposal Order | nvarchar | 20 | 0 | | |
23 | EWA_WA_WEIGHPROC | Weighing Transaction | 8 | ORDERNR | Internal Number for Identifying a Waste Disposal Order | nvarchar | 20 | 0 | | |