| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | SIMID | WFM Planning Version (UID) | nvarchar | 22 | 0 | CHAR | (N' ') | No | | /SAPAPO/LRP_SIMVERSION | Allow NULL? |
| 3 | SCHEDUID | GUID of a Persistent Object | nvarchar | 22 | 0 | CHAR | (N' ') | No | | /SAPAPO/LRP_GUID | Allow NULL? |
| 4 | CREATED_BY | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SYUNAME | Allow NULL? |
| 5 | CREATED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
| 6 | CHANGED_BY | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SYUNAME | Allow NULL? |
| 7 | CHANGED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
| 8 | ASSIGNUID | GUID of a Persistent Object | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/LRP_GUID | Allow NULL? |
| 9 | WDASSIGNUID | GUID of a Persistent Object | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/LRP_GUID | Allow NULL? |
| 10 | DEMANDUID | GUID of a Persistent Object | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/LRP_GUID | Allow NULL? |
| 11 | DEMANDPOSUID | GUID of a Persistent Object | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/LRP_GUID | Allow NULL? |
| 12 | STRATEGYUID | GUID of a Persistent Object | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/LRP_GUID | Allow NULL? |
| 13 | STATUS | Single-Character Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR1 | Allow NULL? |
| 14 | PLAN_START | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
| 15 | MAX_WORK_AS | Natural Number | int | 10 | 0 | INT4 | ((0)) | Yes | | INT4 | Allow NULL? |
