| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | DFKK_ACCADJ | Adjustment Postings when Implementing Acct Assgmt Chars | 4 | LAUFNR | Sequence Number | nvarchar | 2 | 0 | | |
2 | DFKK_NEWACCADJ | Obsolete: See DFKK_ACCADJ | 4 | LAUFNR | Sequence Number | nvarchar | 2 | 0 | | |
3 | P01BN_STAT | Status Table for Contribution Statements | 17 | LAUFNR | Run Number | nvarchar | 3 | 0 | | |
4 | T5D4Y_MAP | Mapping of Previous Months HI Fund List or Run Number | 2 | LAUFNR | Run Number | nvarchar | 3 | 0 | | |
TOPContract Accounts Receivable and Payable |
5 | DFKK_DUEGRID | OI - Reclassifications | 4 | LAUFNR | Sequence Number | nvarchar | 2 | 0 | | |
6 | DFKK_RECLASS | OI - Reclassifications | 4 | LAUFNR | Sequence Number | nvarchar | 2 | 0 | | |
TOPContract Billing |
7 | DBERCHZ4 | Individual line items (rarely used fields) | 34 | LAUFNR | Sequence Number of Service Frequency | nvarchar | 5 | 0 | | |
8 | DBERCHZ8 | Document line items (rarely used fields, unimportant) | 34 | LAUFNR | Sequence Number of Service Frequency | nvarchar | 5 | 0 | | |
TOPMeter Reading |
9 | DBTAB_TEMPPC | database table for temporary Periodic consumption | 3 | LAUFNR | Counter | nvarchar | 3 | 0 | | |
TOPRisk Analysis |
10 | JBRBDSGUV | RM-BDS: P+L Distribution | 2 | LAUFNR | RDB: Run Number | nvarchar | 20 | 0 | | |
11 | JBRBDSGUV10 | RM-BDS: P+L Distribution in Blocks of Ten | 2 | LAUFNR | RDB: Run Number | nvarchar | 20 | 0 | | |
12 | JBRBDSLFN | RM-BDS: Run Number Definition | 2 | LAUFNR | RDB: Run Number | nvarchar | 20 | 0 | | |
13 | JBRBDSLFNA | RM-BDS: Index for P+L Data in the Archive File | 2 | LAUFNR | RDB: Run Number | nvarchar | 20 | 0 | | |
14 | JBRBDSLFNB | RM-BDS: Archive Information per Run | 2 | LAUFNR | RDB: Run Number | nvarchar | 20 | 0 | | |
15 | JBRBDSLFNC | RM-BDS: Calculation Basis per Run Number | 3 | LAUFNR | RDB: Run Number | nvarchar | 20 | 0 | | |
16 | JBRBDSLFNS | RM-BDS: Run Number Status | 2 | LAUFNR | RDB: Run Number | nvarchar | 20 | 0 | | |
17 | JBRBDSVAR | RM-BDS: VaR Data | 2 | LAUFNR | RDB: Run Number | nvarchar | 20 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
18 | NEO_NFAL | IS-H: External Orders - Order Data | 13 | LAUFNR | IS-H: EO Laboratory Order Number | nvarchar | 16 | 0 | | |
19 | NWCH91 | Fee Breakdown Results | 4 | LAUFNR | Run Number for Fee Results | nvarchar | 15 | 0 | | |
20 | NWCH91_AUSG | Fee Breakdown Results from Clearing Report | 4 | LAUFNR | Run Number for Fee Results | nvarchar | 15 | 0 | | |
21 | NWCHNBEW | IS-H CH: Bewegungen zum Fall - Zusatzfelder Schweiz | 29 | LAUFNR | IS-H: OE n. ordine esterno laboratorio | nvarchar | 16 | 0 | | |
TOPSAP Media |
22 | J_1SPUPBESTAND | IS-M/SD CH: Temporary Table for Postal Data Upgrade in DSet | 5 | LAUFNR | Sequence Number | nvarchar | 3 | 0 | | |
23 | J_1SSUPBESTAND | IS-M/SD CH: Temporary Table for Postal Data Upgrade in DSet | 5 | LAUFNR | Character field of length 6 | nvarchar | 6 | 0 | | |
TOPWaste Management |
24 | EWAEHSGP_F | Business Partner Integration Table EHS/ IS-W: Vehicles | 3 | LAUFNR | Consecutive Number | nvarchar | 4 | 0 | | |
25 | EWAOBJH | Service Frequency -> Services (History for EWAOBJ) | 3 | LAUFNR | Sequence Number of Service Frequency | nvarchar | 5 | 0 | | |
26 | EWAOBJH_AAT | Waste Billing Categories for Service Frequency Service | 3 | LAUFNR | Sequence Number of Service Frequency | nvarchar | 5 | 0 | | |
27 | EWAOBJH_AAT_HIST | History and Valution of WBCs for Service Freq. Service | 3 | LAUFNR | Sequence Number of Service Frequency | nvarchar | 5 | 0 | | |
28 | EWAOBJH_DATES | Appendix table of changed data for service frequency | 3 | LAUFNR | Sequence Number of Service Frequency | nvarchar | 5 | 0 | | |
29 | EWAOBJH_DIFFCULT | Service Frequency Notes | 3 | LAUFNR | Sequence Number of Service Frequency | nvarchar | 5 | 0 | | |
30 | EWAOBJH_SDSHARE | Subitems of Sales Document for Service Type | 3 | LAUFNR | Sequence Number of Service Frequency | nvarchar | 5 | 0 | | |
31 | EWAOBJH_SEQUENCE | Route Sequence per EWAOBJH | 3 | LAUFNR | Sequence Number of Service Frequency | nvarchar | 5 | 0 | | |
32 | EWAOBJH_UPOS | Subitems of Sales Document for Service Type | 3 | LAUFNR | Sequence Number of Service Frequency | nvarchar | 5 | 0 | | |
33 | EWATDEVLOC | Provisional Container/Container Location Allocation | 3 | LAUFNR | Sequence Number | nvarchar | 4 | 0 | | |
34 | EWA_BILL_RELEVNT | Valuation of Fields Relevant for Billing in Waste Bill.Cat. | 3 | LAUFNR | Consecutive Number for Valuation of Waste Billing Category | nvarchar | 4 | 0 | | |
35 | EWA_ORDER_HD_CO | Header Table for Waste Disposal Order (CO Data) | 3 | LAUFNR | Sequence Number of CO Item | nvarchar | 10 | 0 | | |
36 | EWA_ORDER_HD_CP | Header Table for Waste Disposal Order (CO-PA Data) | 3 | LAUFNR | Sequence Number of CO Item | nvarchar | 10 | 0 | | |
37 | EWA_ORDER_OBJ_CO | Item Table in Waste Disposal Order (CO Data) | 4 | LAUFNR | Sequence Number of CO Item | nvarchar | 10 | 0 | | |
38 | EWA_ORDER_OBJ_CP | Item Table in Waste Disposal Order (CO-PA Data) | 4 | LAUFNR | Sequence Number of CO Item | nvarchar | 10 | 0 | | |
39 | EWA_ORDER_WGH_CO | Weighing Data Table for Waste Disposal Order (CO Data) | 4 | LAUFNR | Sequence Number of CO Item | nvarchar | 10 | 0 | | |
40 | EWA_ORDER_WGH_CP | Weighing Data Table for Waste Disposal Order (CO-PA Data) | 4 | LAUFNR | Sequence Number of CO Item | nvarchar | 10 | 0 | | |
41 | EWA_WA_WPROC_CO | Weighing Transaction (CO Data) | 3 | LAUFNR | Sequence Number of CO Item | nvarchar | 10 | 0 | | |
42 | EWA_WA_WPROC_CP | Weighing Transaction (CO-PA - Data) | 3 | LAUFNR | Sequence Number of CO Item | nvarchar | 10 | 0 | | |