| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | GUID | GUID of Capacity Pot Instance | varbinary | 16 | 0 | RAW | | No | | /MRSS/T_POT_GUID | |
| 3 | LOGSYS | Logical system | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | LOGSYS | Allow NULL? |
| 4 | KEY_EXT | External Demand Key | nvarchar | 60 | 0 | CHAR | (N' ') | No | | /MRSS/T_DEM_KEY_EXT | Allow NULL? |
| 5 | GUID_MD_ATTR | GUID of Capacity Pot Master Data Attributes | varbinary | 16 | 0 | RAW | | Yes | /MRSS/D_POT_MD | /MRSS/T_POT_GUID_MD_ATTR | |
| 6 | DATE_FROM_TS | Data From Timestamp | decimal | 15 | 0 | DEC | ((0)) | Yes | | /MRSS/T_POT_DATE_FROM_TS | |
| 7 | DATE_TO_TS | Data To Timestamp | decimal | 15 | 0 | DEC | ((0)) | Yes | | /MRSS/T_POT_DATE_TO_TS | |
| 8 | SLA_PRIORITY | SLA Threshold Priority | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | /MRSS/T_POT_PRIORITY | Allow NULL? |
| 9 | DEMAND_GUID | GUID | varbinary | 16 | 0 | RAW | | Yes | | /MRSS/T_GUID | |
| 10 | ASSIGN_GUID | GUID | varbinary | 16 | 0 | RAW | | Yes | | /MRSS/T_GUID | |
| 11 | JOB_CAPA_PLAN | Planned Job Capacity | decimal | 12 | 2 | QUAN | ((0)) | Yes | | /MRSS/T_POT_JOB_CAPA_PLAN | |
| 12 | JOB_CAPA_P_UNIT | Unit of Job Capacity Planned | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | /MRSS/T_POT_JOB_CAPA_UNIT_PLA | Allow NULL? |
| 13 | JOB_CAPA_CALC | Job Capacity Calculated | decimal | 12 | 2 | QUAN | ((0)) | Yes | | /MRSS/T_POT_JOB_CAPA_CALC | |
| 14 | JOB_CAPA_C_UNIT | Unit of Job Capacity Calculated | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | /MRSS/T_POT_JOB_CAPA_UNIT_CAL | Allow NULL? |
| 15 | JOB_CAPA_ACT | Job Capacity Actual | decimal | 12 | 2 | QUAN | ((0)) | Yes | | /MRSS/T_POT_JOB_CAPA_ACT | |
| 16 | JOB_CAPA_A_UNIT | Unit of Job Capacity Actual | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | /MRSS/T_POT_JOB_CAPA_UNIT_ACT | Allow NULL? |
| 17 | TRAVEL_TIME_PLAN | Travel Time Planned | decimal | 7 | 2 | QUAN | ((0)) | Yes | | /MRSS/T_POT_TRAVEL_TIME_PLAN | |
| 18 | TRAVEL_TIME_P_UN | Unit of Travel Time Planned | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | /MRSS/POT_TRAVEL_TIME_UNIT_PLA | Allow NULL? |
| 19 | TRAVEL_TIME_CALC | Travel Time Calculated | decimal | 7 | 2 | QUAN | ((0)) | Yes | | /MRSS/T_POT_TRAVEL_TIME_CALC | |
| 20 | TRAVEL_TIME_C_UN | Unit of Travel Time Calculated | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | /MRSS/POT_TRAVEL_TIME_UNIT_CAL | Allow NULL? |
| 21 | TRAVEL_TIME_ACT | Travel Time Actual | decimal | 7 | 2 | QUAN | ((0)) | Yes | | /MRSS/T_POT_TRAVEL_TIME_ACT | |
| 22 | TRAVEL_TIME_A_UN | Unit of Travel Time Actual | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | /MRSS/POT_TRAVEL_TIME_UNIT_ACT | Allow NULL? |
| 23 | TRV_TO_BEG_CALC | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
| 24 | TRV_TO_END_CALC | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
| 25 | TRV_FRM_BEG_CALC | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
| 26 | TRV_FRM_END_CALC | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
| 27 | TRV_TO_BEG_ACT | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
| 28 | TRV_TO_END_ACT | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
| 29 | TRV_FRM_BEG_ACT | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
| 30 | TRV_FRM_END_ACT | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
| 31 | CREATED_BY | User who created Capacity Pot | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_POT_CREATE_BY | Allow NULL? |
| 32 | CREATED_ON | Creation Timestamp | decimal | 15 | 0 | DEC | ((0)) | Yes | | /MRSS/T_POT_CREATED_ON | |
| 33 | CHANGED_BY | User who changed Capacity Pot | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_POT_CHANGED_BY | Allow NULL? |
| 34 | CHANGED_ON | Change Timestamp | decimal | 15 | 0 | DEC | ((0)) | Yes | | /MRSS/T_POT_CHANGED_ON | |
