| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SLOAP/USER_ROLE | SLOAS user and role data | 3 | USER_GUID | SLOAS: User GUID | varbinary | 16 | 0 | | |
2 | /SLOAP/USR_PROF | Delivery authorisation - profile assignment | 3 | USER_GUID | SLOAS: User GUID | varbinary | 16 | 0 | | |
3 | /SMERP/STG_MM001 | Data staging - Material master plant view complex table | 4 | USER_GUID | User GUID | nvarchar | 32 | 0 | | |
4 | /SMERP/STG_MM002 | Data staging - Material storage location view complex table | 4 | USER_GUID | User GUID | nvarchar | 32 | 0 | | |
5 | /SMERP/STG_MM003 | Data staging - Material UoM view complex table | 4 | USER_GUID | User GUID | nvarchar | 32 | 0 | | |
6 | /SMERP/STG_MM004 | Data staging - Material warehouse view complex table | 4 | USER_GUID | User GUID | nvarchar | 32 | 0 | | |
7 | /SMERP/STG_MM005 | Data staging - Material batch view complex table | 4 | USER_GUID | User GUID | nvarchar | 32 | 0 | | |
8 | /SMERP/STG_PM001 | Data staging - Equipment complex table | 4 | USER_GUID | User GUID | nvarchar | 32 | 0 | | |
9 | /SMERP/STG_PM002 | Data staging - Functional Location complex table | 4 | USER_GUID | User GUID | nvarchar | 32 | 0 | | |
10 | /SMERP/STG_PM003 | Data staging - Equipment List Set - Hdr - complex tab | 4 | USER_GUID | User GUID | nvarchar | 32 | 0 | | |
11 | /SMERP/STG_PM004 | Data staging - Equipment list set - Measuring Points | 4 | USER_GUID | User GUID | nvarchar | 32 | 0 | | |
12 | /SMERP/STG_PM005 | Data staging - Equipment LSet - DMS Doc. Obj - complex table | 4 | USER_GUID | User GUID | nvarchar | 32 | 0 | | |
13 | /SMERP/STG_PM006 | Data staging - Equip List Set - Classifications - Cmplx Tab | 4 | USER_GUID | User GUID | nvarchar | 32 | 0 | | |
14 | /SMERP/STG_PM007 | Data staging - Equip List Set - Char Values - complex table | 4 | USER_GUID | User GUID | nvarchar | 32 | 0 | | |
15 | /SMERP/STG_PM008 | Data staging - Functional Loc. List Set - Hdr - complex tab | 4 | USER_GUID | User GUID | nvarchar | 32 | 0 | | |
16 | /SMERP/STG_PM009 | Data staging - Func. Loc. List Set - Meas. Pts - cmplex tab | 4 | USER_GUID | User GUID | nvarchar | 32 | 0 | | |
17 | /SMERP/STG_PM010 | Data staging - Func. Loc. LSet - DMS Doc. Obj - complex tab | 4 | USER_GUID | User GUID | nvarchar | 32 | 0 | | |
18 | /SMERP/STG_PM011 | Data staging - Func Loc. LSet - Classifications - Cmplx Tab | 4 | USER_GUID | User GUID | nvarchar | 32 | 0 | | |
19 | /SMERP/STG_PM012 | Data staging - Func Loc LSet - Char Values - complex table | 4 | USER_GUID | User GUID | nvarchar | 32 | 0 | | |
20 | /SYCLO/AP001 | Syclo Integration Framework Runtime Settings | 3 | USER_GUID | User GUID | nvarchar | 32 | 0 | | |
21 | /SYCLO/AP002 | Runtime overwrite for mobile app param, globals | 4 | USER_GUID | User GUID | nvarchar | 32 | 0 | | |
22 | /SYCLO/MDW00 | Syclo Middleware User Registry | 2 | USER_GUID | User GUID | nvarchar | 32 | 0 | | |
23 | /SYCLO/MDW00C | Mobile user communication info | 2 | USER_GUID | User GUID | nvarchar | 32 | 0 | | |
24 | /SYCLO/MDW00D | Mobile user client deployment status - last update | 2 | USER_GUID | User GUID | nvarchar | 32 | 0 | | |
25 | /SYCLO/MDW00R | Mobile user cross reference | 2 | USER_GUID | User GUID | nvarchar | 32 | 0 | | |
26 | /SYCLO/MDW01 | Syclo Middleware Session Registry | 3 | USER_GUID | User GUID | nvarchar | 32 | 0 | | |
27 | /SYCLO/MDW01R | Middleware session cross reference | 5 | USER_GUID | User GUID | nvarchar | 32 | 0 | | |
28 | /SYCLO/MDW02 | Syclo Middleware Session Data Object Registry | 3 | USER_GUID | User GUID | nvarchar | 32 | 0 | | |
29 | /SYCLO/MDW03 | Syclo Middleware Session Cross Reference Table | 3 | USER_GUID | User GUID | nvarchar | 32 | 0 | | |
30 | /SYCLO/MSG01 | Syclo Mobile Data Unit Message Queue (Outbound) | 5 | USER_GUID | User GUID | nvarchar | 32 | 0 | | |
31 | /SYCLO/MSG02 | Syclo Mobile Data Unit Message Queue (Inbound) | 5 | USER_GUID | User GUID | nvarchar | 32 | 0 | | |
32 | /SYCLO/PSH02 | Syclo Push Register - Instance items | 6 | USER_GUID | User GUID | nvarchar | 32 | 0 | | |
33 | /SYCLO/PSH03 | Push Instance Subscriber List | 3 | USER_GUID | User GUID | nvarchar | 32 | 0 | | |
34 | /SYCLO/PSH05 | User Push history | 4 | USER_GUID | User GUID | nvarchar | 32 | 0 | | |
35 | /SYCLO/SYSLOG001 | System statistics - Middleware integration | 8 | USER_GUID | User GUID | nvarchar | 32 | 0 | | |
TOPCentral Part of Product Master |
36 | COMM_PRWBIL_USER | User Settings for Interlinkages in the Product Workbench | 2 | USER_GUID | GUID: User Settings | varbinary | 16 | 0 | | |