BAS_TSK_TSKD_TASK_DETAILS
Subtask Details For Task
Process: MAINTPLANNING · Component: BASTask · Table type: Transaction Category: Provides master data for task definitions, sub-task definitions and task zones used in maintenance and operational planning.
Columns (24)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | TSKD_OUINSTANCE | — | Organization Unit |
| 2 | TSKD_TASK_NO | — | Task Number |
| 3 | TSKD_REVISION_NO | — | Revision Number of the Task |
| 4 | TSKD_BASE_MODEL_NO | — | Model Number |
| 5 | TSKD_SEQ_NO | — | Sequence number of the Sub Task |
| 6 | TSKD_SUB_TASK | — | Sub Task Number |
| 7 | TSKD_RESOURCE_GRP | — | Resource group of the Sub Task. Can be "Inspector", "Mechanic" or "Both" INS - Inspector MEC - Mechanic BO - Inspector and Mechanic |
| 8 | TSKD_DOCUMENTNO | — | Document Number |
| 9 | TSKD_PATH | — | Path |
| 10 | TSKD_SUBTASK_ROW_NO | — | Running seq no |
| 11 | TSKD_AMMCMM_ITEMNO | — | AMM\CMM Item Number |
| 12 | TSKD_DSCLCODE | — | Dependent System Code |
| 13 | TSKD_MPD_ITEMNO | — | Item number |
| 14 | TSKD_CREATED_BY | — | Login id of the user who created the task |
| 15 | TSKD_MODIFIED_BY | — | Login id of the user who modified the task |
| 16 | TSKD_CREATIONDATE | — | Date on which the sub-task details are created |
| 17 | TSKD_MODIFIEDDATE | — | Date on which the sub-task details are modified |
| 18 | tskd_uti | — | Sub task unique id |
| 19 | created_area_code | — | Null |
| 20 | TSKD_ELAPSED_TIME | — | Task Elapsed Time |
| 21 | TSKD_EMP_LOADING | — | Employee Count |
| 22 | TSKD_OPQTY_Type | — | Quantity |
| 23 | TSKD_TIME_UOM | — | Unit of Measurement |
| 24 | TSKD_SCH_WORKTIME | — | Scheduled Work time |
Sample rows (from live DB)
TSKD_OUINSTANCE | TSKD_TASK_NO | TSKD_REVISION_NO | TSKD_BASE_MODEL_NO | TSKD_SEQ_NO | TSKD_SUB_TASK |
|---|---|---|---|---|---|
| 2.0 | % | ## | A310 | 1.0 | test task |
| 2.0 | % | ## | ## | 2.0 | ca |
| 2.0 | % | ## | ## | 3.0 | ca |
Showing 3 of 50,000 rows.