| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | OWNER | DMC: Globally Unique Key (22 Characters) | nvarchar | 22 | 0 | CHAR | (N' ') | No | | DMC_GUID | Allow NULL? |
| 2 | CONVOBJ | DMC: Globally Unique Key (22 Characters) | nvarchar | 22 | 0 | CHAR | (N' ') | No | | DMC_GUID | Allow NULL? |
| 3 | ID | DMC: Key | nvarchar | 5 | 0 | NUMC | (N'00000') | No | | DMC_ID | Allow NULL? |
| 4 | GUID | DMC: Globally Unique Key (22 Characters) | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | | DMC_GUID | Allow NULL? |
| 5 | DESCR | Description | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | DMC_DESCR | Allow NULL? |
| 6 | IS_CALCULATED | MWB: Calculation Status of an Access Plan | char | 1 | 0 | CHAR | (N' ') | Yes | | DMC_ACPLAN_CALCULATED | Allow NULL? |
| 7 | TS_CREATED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
| 8 | TS_CHANGED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
| 9 | BLOCKSIZE | MWB: Size of an RFC Package | int | 10 | 0 | INT4 | ((0)) | Yes | | DMC_BLOCKSIZE | Allow NULL? |
| 10 | PREC_STATE | Status of Access Plan From Precalculation (DATA/EMPTY) | char | 1 | 0 | CHAR | (N' ') | Yes | | DMC_ACP_PREC_STATE | Allow NULL? |
| 11 | FAILED | Boolean Variable (X=True, -=False, Space=Unknown) | char | 1 | 0 | CHAR | (N' ') | Yes | | BOOLEAN | Allow NULL? |
| 12 | IN_PROCESS | Boolean Variable (X=True, -=False, Space=Unknown) | char | 1 | 0 | CHAR | (N' ') | Yes | | BOOLEAN | Allow NULL? |
| 13 | LOADED | Boolean Variable (X=True, -=False, Space=Unknown) | char | 1 | 0 | CHAR | (N' ') | Yes | | BOOLEAN | Allow NULL? |
| 14 | TEMPLATE | Boolean Variable (X=True, -=False, Space=Unknown) | char | 1 | 0 | CHAR | (N' ') | Yes | | BOOLEAN | Allow NULL? |
| 15 | ORIGIN_ID | DMC: Key | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | DMC_ID | Allow NULL? |
| 16 | SUB_ID | DMC: Key | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | DMC_ID | Allow NULL? |