| 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 | T000 | MANDT | Allow NULL? |
| 2 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001W | WERKS_D | Allow NULL? |
| 3 | AUART | Order Type | nvarchar | 4 | 0 | CHAR | (N' ') | No | T003O | AUFART | Allow NULL? |
| 4 | VAGRP | Production Supervisor | nvarchar | 3 | 0 | CHAR | (N' ') | No | T024F | FEVOR | Allow NULL? |
| 5 | TERMKZ | Scheduling type | char | 1 | 0 | CHAR | (N' ') | Yes | T482 | TERMKZ | Allow NULL? |
| 6 | TERM_AUTO | Indicator: Calculate dates automatically during saving | char | 1 | 0 | CHAR | (N' ') | Yes | | TERM_AUTO | Allow NULL? |
| 7 | PROT_AUTO | Display scheduling log automatically | char | 1 | 0 | CHAR | (N' ') | Yes | | PROT_AUTO | Allow NULL? |
| 8 | STVERG | Maximum number of days start date can be in the past | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | STVERG | Allow NULL? |
| 9 | ECKTM_UPD | Indicator: Adjust Basic Dates | char | 1 | 0 | CHAR | (N' ') | Yes | | ECKTM_UPD | Allow NULL? |
| 10 | AUF_SHIFT | Indicator: Shift order/network | char | 1 | 0 | CHAR | (N' ') | Yes | | AUF_SHIFT | Allow NULL? |
| 11 | REDST_MAX | Maximum reduction level | char | 1 | 0 | NUMC | (N'0') | Yes | | REDST_MAX | Allow NULL? |
| 12 | REDVS_S1 | Red. of floats before and after production (%) | decimal | 3 | 0 | DEC | ((0)) | Yes | | REDVS_S1 | |
| 13 | REDVS_S2 | Reduction level 2: Red. of floats bef./after prod. (in %) | decimal | 3 | 0 | DEC | ((0)) | Yes | | REDVS_S2 | |
| 14 | REDVS_S3 | Reduction level 3: Red. of floats bef./aft. prod. (in %) | decimal | 3 | 0 | DEC | ((0)) | Yes | | REDVS_S3 | |
| 15 | REDVS_S4 | Reduction level 4: Red. of floats bef./aft. prod. (in %) | decimal | 3 | 0 | DEC | ((0)) | Yes | | REDVS_S4 | |
| 16 | REDVS_S5 | Reduction level 5: Red. of floats bef./aft. prod. (in %) | decimal | 3 | 0 | DEC | ((0)) | Yes | | REDVS_S5 | |
| 17 | REDVS_S6 | Reduction level 6: Red. of floats bef./aft. prod. (in %) | decimal | 3 | 0 | DEC | ((0)) | Yes | | REDVS_S6 | |
| 18 | MATFRUEH | Latest date for material staging | char | 1 | 0 | CHAR | (N' ') | Yes | | LAGE_FR | Allow NULL? |
| 19 | BREAKS | Indicator: Scheduling allowing for breaks | char | 1 | 0 | CHAR | (N' ') | Yes | | BREAKS | Allow NULL? |
