Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
---|---|---|---|---|---|---|---|---|---|---|
1 | MRP_BUF_PLANT_DT | Current dates of Plant | 6 | FACTORY_CALENDAR | Factory calendar key | nvarchar | 2 | 0 | ||
2 | PPH_CACHE_PLT_DT | Current dates of Plant | 6 | FACTORY_CALENDAR | Factory calendar key | nvarchar | 2 | 0 | ||
Accounting - General | ||||||||||
3 | TFC_INST_HDR | Header Information on Status Admin for Fast Close | 11 | FACTORY_CALENDAR | Factory Calendar | nvarchar | 2 | 0 | ||
4 | TFC_INST_ORG | Organizational Structure: Fast Close | 14 | FACTORY_CALENDAR | Factory Calendar | nvarchar | 2 | 0 | ||
5 | TFC_TEMPL_HDR | Header Information on Status Admin for Fast Close | 11 | FACTORY_CALENDAR | Factory Calendar | nvarchar | 2 | 0 | ||
6 | TFC_TEMPL_ORG | Organizational Structure: Fast Close | 14 | FACTORY_CALENDAR | Factory Calendar | nvarchar | 2 | 0 | ||
Maintenance Orders | ||||||||||
7 | /MRSS/C_SGU_PRO | UI Planning Profiles | 14 | FACTORY_CALENDAR | Factory Calendar | nvarchar | 2 | 0 | ||
SAP Multiresource Scheduling | ||||||||||
8 | /MRSS/C_DISTRBTR | Distributor | 4 | FACTORY_CALENDAR | Factory calendar | nvarchar | 2 | 0 | ||
9 | /MRSS/C_RES_GRP | Resource Group | 4 | FACTORY_CALENDAR | Factory Calendar | nvarchar | 2 | 0 | ||
10 | /MRSS/C_SGX_WPRO | Header Table of the Web UI Profile | 3 | FACTORY_CALENDAR | Factory Calendar | nvarchar | 2 | 0 | ||
Schedule Manager | ||||||||||
11 | TSCMA | Schedule Manager: Task List Index | 3 | FACTORY_CALENDAR | Factory Calendar | nvarchar | 2 | 0 | ||
Workforce Management Core | ||||||||||
12 | WFDBPC_RULE | WFD Template rules | 6 | FACTORY_CALENDAR | Factory calendar | nvarchar | 2 | 0 |