| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | DB_KEY | NodeID | varbinary | 16 | 0 | | | | |
| 3 | NODE_CAT_KEY | NodeID | varbinary | 16 | 0 | | | | |
| 4 | DATETIME_CR | Date/Time of Item Creation | decimal | 15 | 0 | | | | |
| 5 | USER_ID_CR | Object Created By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 6 | DATETIME_CH | Date/Time of Item Change | decimal | 15 | 0 | | | | |
| 7 | USER_ID_CH | Object Changed By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 8 | BO_KEY_REF | BO Reference - Definition Key of the Business Object | varbinary | 16 | 0 | | | | |
| 9 | BO_ROOT_KEY_REF | BO Reference - Instance Key of the ROOT Node | varbinary | 16 | 0 | | | | |
| 10 | BO_NODE_KEY_REF | BO Reference - Definition Key of the Subnode | varbinary | 16 | 0 | | | | |
| 11 | BO_KEY_REF_NODE | BO Reference - Instance Key of the Subnode | varbinary | 16 | 0 | | | | |
| 12 | DTA_KEY_REF | Data BO Reference - Definition Key of the Business Object | varbinary | 16 | 0 | | | | |
| 13 | DTA_ROOT_KEY_REF | Data BO Reference - Instance Key of the ROOT Node | varbinary | 16 | 0 | | | | |
| 14 | DTA_NODE_KEY_REF | Data BO Reference - Definition Key of the Subnode | varbinary | 16 | 0 | | | | |
| 15 | DTA_KEY_REF_NODE | Data BO Reference - Instance Key of the Subnode | varbinary | 16 | 0 | | | | |
| 16 | PC_BO_KEY_REF | PCBO Reference - Definition Key of the Process Control BO | varbinary | 16 | 0 | | | | |
| 17 | PC_ROOT_KEY_REF | PCBO Reference - Instance Key of the ROOT Node | varbinary | 16 | 0 | | | | |
| 18 | VARIANT | Name of Process Variant | nvarchar | 30 | 0 | | | | Allow NULL? |
| 19 | STATUS | Internal Status of PCO | nvarchar | 2 | 0 | | | | Allow NULL? |
| 20 | STATUS_REMARK | Comment on Internal Status | nvarchar | 255 | 0 | | | | Allow NULL? |
| 21 | WF_INSTANCE_ID | Work item ID | nvarchar | 12 | 0 | | | | Allow NULL? |
| 22 | WF_TEMPLATE_ID | Task ID | nvarchar | 14 | 0 | | | | Allow NULL? |
| 23 | WI_COUNT | WFIS: Number of Tasks | decimal | 15 | 3 | | | | |
| 24 | TIME_TOTAL | WIS: Sum of Times in Hours (Gross) | decimal | 15 | 3 | | | | |
| 25 | NET_TOTAL | WFIS: Total Net Working Hours | decimal | 15 | 3 | | | | |
| 26 | UNIT | WFIS: Dummy Unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 27 | EHSM_COMPONENT | Component of EHS Management | nvarchar | 5 | 0 | | | | Allow NULL? |
| 28 | PURPOSE | Process Purpose | nvarchar | 23 | 0 | | | | Allow NULL? |
| 29 | FIN_TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | | | |
| 30 | FIN_TI_ZO | Time Zone for Finished Process | nvarchar | 6 | 0 | | | | Allow NULL? |
| 31 | PROC_STATUS | Work item ID | nvarchar | 12 | 0 | | | | Allow NULL? |
| 32 | DURATION | UTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun) | decimal | 21 | 7 | | | | |
| 33 | PSE_ROOT_KEY | NodeID | varbinary | 16 | 0 | | | | |
| 34 | IS_RECURRING | Recurring Process | char | 1 | 0 | | | | Allow NULL? |
| 35 | MATERIAL_ID | Material | nvarchar | 18 | 0 | | | | Allow NULL? |
| 36 | SUBSTANCE_ID | Substance ID | nvarchar | 12 | 0 | | | | Allow NULL? |
| 37 | CUSTOMER_ID | Customer ID | nvarchar | 10 | 0 | | | | Allow NULL? |
| 38 | SUPPLIER_ID | Supplier | nvarchar | 10 | 0 | | | | Allow NULL? |
| 39 | COMPLIANCE_CHECK | Compliance Requirement (Check) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 40 | PROC_STATUS_TYPE | Task ID | nvarchar | 14 | 0 | | | | Allow NULL? |
| 41 | EEW_PRC_ROOT_D | Dummy function in length 1 | char | 1 | 0 | | | | Allow NULL? |
