| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SDF/DRM_CONF | Data Readyness Monitoring - Configuration | 2 | CGROUP | Character String - 32 User-Defined Characters | nvarchar | 32 | 0 | | |
2 | /SDF/DRM_RESULTS | Data Readyness Monitoring - Results | 6 | CGROUP | Character String - 32 User-Defined Characters | nvarchar | 32 | 0 | | |
3 | CMM_MTM_CALC | Assign Condition Types to Groups | 5 | CGROUP | MtM Condition Group | nvarchar | 1 | 0 | | |
4 | CMM_MTM_CGROUPT | MtM Condition Group | 2 | CGROUP | MtM Condition Group | nvarchar | 1 | 0 | | |
5 | CMM_MTM_CGROUPTT | MtM Condition Group | 3 | CGROUP | MtM Condition Group | nvarchar | 1 | 0 | | |
6 | CMM_MTM_PO | MtM per Purchase Order | 31 | CGROUP | MtM Condition Group | nvarchar | 1 | 0 | | |
7 | CMM_MTM_SO | MtM per Sales Order | 28 | CGROUP | MtM Condition Group | nvarchar | 1 | 0 | | |
8 | GSWCGRP_SERVER_A | Component --- Group | 3 | CGROUP | GTABKEY Group | nvarchar | 20 | 0 | | |
9 | GTABKEYEXC20 | Exception List: Global Key Check | 6 | CGROUP | GTABKEY Group | nvarchar | 20 | 0 | | |
10 | GTABKEYEXC_ARCH | Exception List: Global Key Check | 6 | CGROUP | GTABKEY Group | nvarchar | 20 | 0 | | |
11 | GTABKEY_ARCHIVE | Global Key Entries from Requests/Tasks | 2 | CGROUP | GTABKEY Group | nvarchar | 20 | 0 | | |
12 | GTABKEY_EXT | Mapping of Group to Virtual Group to Check for Conflicts | 1 | CGROUP | GTABKEY Group | nvarchar | 20 | 0 | | |
13 | WB2B_CMM_MTM_TC | MtM per Trading Contract | 34 | CGROUP | MtM Condition Group | nvarchar | 1 | 0 | | |
14 | ZCMM_MTM_01 | MtM Persistency per Transaction | 26 | CGROUP | MtM Condition Group | nvarchar | 1 | 0 | | |
15 | ZCMM_MTM_TC | MtM per TC | 33 | CGROUP | MtM Condition Group | nvarchar | 1 | 0 | | |
TOPPhilippines |
16 | T7PHRS | Receipt number and Issue dates-Company Grouping. | 3 | CGROUP | Tax grouping | nvarchar | 4 | 0 | | |
TOPSequencing |
17 | TSPG2 | Order characteristic | 3 | CGROUP | Order characteristic group | nvarchar | 2 | 0 | | |
TOPTariffs, Duties and Permits |
18 | OIH_J1B_CPR | Brazil: Posting exceptions for ICMS complement | 7 | CGROUP | Customer tax group | nvarchar | 4 | 0 | | |
19 | OIH_J1B_FAC | Brazil: Factor for calculation of PIS / COFINS ST | 6 | CGROUP | Customer tax group | nvarchar | 4 | 0 | | |
20 | OIH_J1B_PIC | Brazil: Printing exceptions for ICMS | 6 | CGROUP | Customer tax group | nvarchar | 4 | 0 | | |
21 | OIH_J1B_ZFD | Brazil tax: Sub. Trib. Discount for Zona Franca de Manaus | 8 | CGROUP | Customer tax group | nvarchar | 4 | 0 | | |
22 | OIH_J_1BTXCI2 | Tax calc.: Complement of ICMS rules INSIDE CALCULATION | 8 | CGROUP | Customer tax group | nvarchar | 4 | 0 | | |
23 | OIH_J_1BTXIX1 | Tax calc.: ISS rules for sales and purchasing exeptions | 9 | CGROUP | Customer tax group | nvarchar | 4 | 0 | | |
TOPTransport Organizer |
24 | GGRP | Group for Global Table Keys | 1 | CGROUP | GTABKEY Group | nvarchar | 20 | 0 | | |
25 | GSWCGRP | Component --- Group | 3 | CGROUP | GTABKEY Group | nvarchar | 20 | 0 | | |
26 | GSWCGRP_SERVER | Component --- Group | 3 | CGROUP | GTABKEY Group | nvarchar | 20 | 0 | | |
27 | GTABKEY | Global Key Entries from Requests/Tasks | 2 | CGROUP | GTABKEY Group | nvarchar | 20 | 0 | | |
28 | GTABKEY_LOCAL | Global Key Entries from Requests/Tasks | 2 | CGROUP | GTABKEY Group | nvarchar | 20 | 0 | | |
29 | GTABKEY_TABEXCL | Tables Excluded from Conflict Check | 2 | CGROUP | GTABKEY Group | nvarchar | 20 | 0 | | |
30 | GUPDLAYOUT | List of Table Layouts that Need to Be Updated | 1 | CGROUP | GTABKEY Group | nvarchar | 20 | 0 | | |