Defects
| Order | Field Name | Values/Table Reference |
|---|---|---|
| 0 | Result Set Type | 13 |
| 1 | Update Type |
|
| 2 | Transaction Type |
|
| 3 | Transaction Number | |
| 4 | Defect Detail Id | Defect_Details.Defect_Detail_Id |
| 5 | Defect Type Id | Defect_Details.Defect_Type_Id Defect_Types.Defect_Type_Id |
| 6 | Cause 1 | Defect_Details.Cause1 Event_Reasons.Reason_Id |
| 7 | Cause 2 | Defect_Details.Cause2 Event_Reasons.Reason_Id |
| 8 | Cause 3 | Defect_Details.Cause3 Event_Reasons.Reason_Id |
| 9 | Cause 4 | Defect_Details.Cause4 Event_Reasons.Reason_Id |
| 10 | Cause Comment Id | Defect_Details.Cause_Comment_Id Comments.Comment_Id |
| 11 | Action 1 | Defect_Details.Action1 Event_Reasons.Reason_Id |
| 12 | Action 2 | Defect_Details.Action1 Event_Reasons.Reason_Id |
| 13 | Action 3 | Defect_Details.Action1 Event_Reasons.Reason_Id |
| 14 | Action 4 | Defect_Details.Action1 Event_Reasons.Reason_Id |
| 15 | Action Comment Id | Defect_Details.Action_Comment_Id Comments.Comment_Id |
| 16 | Research Status Id | Defect_Details.Research_User_Id Users.User_Id |
| 17 | Research Comment Id | Defect_Details.Research_Comment_Id |
| 18 | Research User Id | Defect_Details.Research_User_Id Users.User_Id |
| 19 | Event Id | Defect_Details.Event_Id Events.Event_Id |
| 20 | Source Event Id | Defect_Details.Source_Event_Id Events.Event_Id |
| 21 | Unit Id | Defect_Details.PU_Id Prod_Units.PU_Id |
| 22 | Event Subtype Id | Defect_Details.Event_Subtype_Id Event_Subtypes.Event_Subtype_Id |
| 23 | User Id | Defect_Details.User_Id Users.User_Id |
| 24 | Visual Start X | |
| 25 | Visual Start Y | |
| 26 | Severity | |
| 27 | Repeat | |
| 28 | Dimension X | Defect_Details.Dimension_X |
| 29 | Dimension Y | Defect_Details.Dimension_Y |
| 30 | Dimension Z | Defect_Details.Dimension_Z |
| 31 | Amount | Defect_Details.Amount |
| 32 | Start Position X | Defect_Details.Start_Position_X |
| 33 | Start Position Y | Defect_Details.Start_Position_Y |
| 34 | End Position X | Defect_Details.End_Position_X |
| 35 | End Position Y | Defect_Details.Start_Position_Y |
| 36 | Research Open Date | Defect_Details.Research_Open_Date |
| 37 | Research Close Date | Defect_Details.Research_Close_Date |
| 38 | Start Time | Defect_Details.Start_Time |
| 39 | End Time | Defect_Details.End_Time |
| 40 | Entry On | Defect_Details.Entry_On |