| 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 | PARENT_KEY | NodeID | varbinary | 16 | 0 | | | | |
| 4 | FC_GROUP | Forecast Grouping Key | varbinary | 16 | 0 | | | | |
| 5 | START_DATE | Start Date of Staff Assignment | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | END_DATE | End Date of Staff Assignment | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | TASKTYPE | Task Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 8 | TASKLEVEL | Task Level | nvarchar | 8 | 0 | | | | Allow NULL? |
| 9 | ACTIVITY_CLASS | Competency | nvarchar | 8 | 0 | | | | Allow NULL? |
| 10 | DESCRIPTION | Staff Assignment: Item Description | nvarchar | 80 | 0 | | | | Allow NULL? |
| 11 | EXPECTED_DAYS | Staff Assignment: Expected Days | nvarchar | 4 | 0 | | | | Allow NULL? |
| 12 | MAXIMUM_DAYS | Staff Assignment: Maximum Days | nvarchar | 4 | 0 | | | | Allow NULL? |
| 13 | BOOKING_STATUS | Booking Status | char | 1 | 0 | | | | Allow NULL? |
| 14 | EXP_TRVL_EXP | Expected Travel Expense | decimal | 13 | 2 | | | | |
| 15 | EXP_TRVL_CURR | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 16 | MAIL_STATUS | E-Mail Status | char | 1 | 0 | | | | Allow NULL? |
| 17 | CATS_RELEVANT | Staff Assignment: CATS-Relevant | char | 1 | 0 | | | | Allow NULL? |
| 18 | FC_RELEVANT | Staff Assignment: Relevant for Forecasting | char | 1 | 0 | | | | Allow NULL? |
| 19 | DATETIME_CR | Date/Time of Item Creation | decimal | 15 | 0 | | | | |
| 20 | USER_ID_CR | Object Created By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 21 | DATETIME_CH | Date/Time of Item Change | decimal | 15 | 0 | | | | |
| 22 | USER_ID_CH | Object Changed By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 23 | Z_PRS_OFFSHORE | Professional Services: Delivery Type | char | 1 | 0 | | | | Allow NULL? |
| 24 | Z_PRS_BILL_FLAG | Professional Services: Billable/Non-Billable | char | 1 | 0 | | | | Allow NULL? |
| 25 | Z_PRS_COUNTRY | Country Key | nvarchar | 3 | 0 | | | | Allow NULL? |
| 26 | Z_PRS_CHARGELEVL | Professional Services: Charge Level | nvarchar | 2 | 0 | | | | Allow NULL? |
| 27 | TASKCOMPONENT | Task component | nvarchar | 8 | 0 | | | | Allow NULL? |
| 28 | ACTIVITY_TYPE | Activity Type | nvarchar | 6 | 0 | | | | Allow NULL? |
| 29 | ROLE | Staff Assignment Role | nvarchar | 4 | 0 | | | | Allow NULL? |
