| 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 | DEXDUECNTRID | Identification of Due Date Control | nvarchar | 22 | 0 | CHAR | (N' ') | No | | E_DEXDUECNTRID | Allow NULL? |
| 3 | DEXDUETYPE | Type of Due Date | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | E_DEXDUETYPE | Allow NULL? |
| 4 | WORKCALID | Factory Calendar | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TFACD | WFCID | Allow NULL? |
| 5 | WORKCALCNTR | Control of Due Dates on Public Holidays for Factory Calender | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | E_WORKCALCNTR | Allow NULL? |
| 6 | DEXCYCLETYPE | Type of Cyclical Due Date | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | E_DEXCYCLETYPE | Allow NULL? |
| 7 | DEXCYCLELENGTH | Length of Cycle | int | 10 | 0 | INT4 | ((0)) | Yes | | E_DEXCYCLELENGTH | Allow NULL? |
| 8 | DEXREFPERTYPE | Type of Reference Period | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | E_DEXREFPERTYPE | Allow NULL? |
| 9 | DEXDUESTARTDATE | Start Date for Gereration | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | E_DEXDUESTARTDATE | Allow NULL? |
| 10 | DEXDUESTARTTIME | Start Time for Generation | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | E_DEXDUESTARTTIME | Allow NULL? |
| 11 | DEXADDYEARS | Shift of Due Date in Years | int | 10 | 0 | INT4 | ((0)) | Yes | | E_DEXADDYEARS | Allow NULL? |
| 12 | DEXADDMONTHS | Shift of Due Date in Months | int | 10 | 0 | INT4 | ((0)) | Yes | | E_DEXADDMONTH | Allow NULL? |
| 13 | DEXADDDAYS | Shift of Due Date in Days | int | 10 | 0 | INT4 | ((0)) | Yes | | E_DEXADDDAYS | Allow NULL? |
| 14 | DEXREFYEARSFROM | Shift of Reference Period in Years | int | 10 | 0 | INT4 | ((0)) | Yes | | E_DEXREFYEARSFROM | Allow NULL? |
| 15 | DEXREFMONTHSFROM | Shift of Reference Period in Months | int | 10 | 0 | INT4 | ((0)) | Yes | | E_DEXREFMONTHSFROM | Allow NULL? |
| 16 | DEXREFDAYSFROM | Shift of Reference Period in Days | int | 10 | 0 | INT4 | ((0)) | Yes | | E_DEXREFDAYSFROM | Allow NULL? |
| 17 | DEXREFTIMEFROM | From Time for Reference Period | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | E_DEXREFTIMEFROM | Allow NULL? |
| 18 | DEXREFYEARSTO | Shift of Reference Period in Years | int | 10 | 0 | INT4 | ((0)) | Yes | | E_DEXREFYEARSTO | Allow NULL? |
| 19 | DEXREFMONTHSTO | Shift of Reference Period in Months | int | 10 | 0 | INT4 | ((0)) | Yes | | E_DEXREFMONTHSTO | Allow NULL? |
| 20 | DEXREFDAYSTO | Shift of Reference Period in Days | int | 10 | 0 | INT4 | ((0)) | Yes | | E_DEXREFDAYSTO | Allow NULL? |
| 21 | DEXREFTIMETO | Time for Reference Period | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | E_DEXREFTIMETO | Allow NULL? |
