Result Set 10 - Production Event Details
The following table lists the parameters used in an Event Details Result Set.
|
Order |
Field Name |
Req |
Values/Table Reference |
|
0 |
Result Set Type |
X |
10 |
|
1 |
Update Type |
X |
0 - Post-Update. Data already in database and sent to clients only. 1 - Pre-Update. Database Manager writes to database and sends to client. |
|
2 |
User Id |
X |
Event_Details (User_Id), Users (User_Id). Allows a specific User_Id to be used and tracked. If not using a specific User_Id account then set it to 0 and the appropriate Service User_Id will be used. |
|
3 |
Transaction Type |
X |
1 Add, 2 Update, 3 - Delete |
|
4 |
Transaction Number |
X |
0 Update fields that are not null to the new values. 2 Update all fields of Event_Details to the values in Result Set. Values of 0 for dimensions are set to null. |
|
5 |
Event Id |
X |
Event_Details (Event_Id) Events (Event_Id) |
|
6 |
Unit Id |
X |
Prod_Units (PU_Id) |
|
7 |
Primary Event Number |
X |
Event_Details (Primary_Event_Num) |
|
8 |
Alternate Event Number |
|
Event_Details (Alternate_Event_Num) |
|
9 |
Comment Id |
|
Event_Details (Comment_Id) Comments (Comment_Id). |
|
10 |
Event Sub Type Id |
|
Event_Subtypes (Event_Subtype_Id) |
|
11 |
Original Product |
|
Event_Details (Original_Product) Products (Prod_Id) |
|
12 |
Applied Product |
|
Event_Details (Applied_Product) Products (Prod_Id) |
|
13 |
Event Status |
X |
Event_Details (Event_Status) Production_Status (ProdStatus_Id) |
|
14 |
Timestamp |
X |
Event_Details (TimeStamp) |
|
15 |
Entry On |
|
Event_Details (Entry_On) |
|
16 |
Production Plan Setup Detail Id |
|
Event_Details (PP_Setup_Detail_Id) Production_Setup_Detail (PP_Setup_Detail_Id) |
|
17 |
Shipment Item Id |
|
Event_Details (Shipment_Item_Id) Shipment_Line_Items (Shipment_Item_Id) |
|
18 |
Order Id |
|
Event_Details (Order_Id) Customer_Orders (Order_Id) |
|
19 |
Order_Line_Id |
|
Event_Details (Order_Line_Id) Customer_Order_Line_Items (Order_Line_Id) |
|
20 |
Production Plan Id |
|
Event_Details.PP_Id Production_Plan (PP_Id) |
|
21 |
Initial_Dimension X |
|
Event_Details (Initial_Dimension_X) |
|
22 |
Initial_Dimension Y |
|
Event_Details (Initial_Dimension_Y) |
|
23 |
Initial_Dimension Z |
|
Event_Details (Initial_Dimension_Z) |
|
24 |
Initial_Dimension A |
|
Event_Details (Initial_Dimension_A) |
|
25 |
Final_Dimension X |
|
Event_Details (Final_Dimension_X) |
|
26 |
Final_Dimension Y |
|
Event_Details (Final_Dimension_Y) |
|
27 |
Final_Dimension Z |
|
Event_Details (Final_Dimension_Z) |
|
28 |
Final_Dimension A |
|
Event_Details (Final_Dimension_A) |
|
29 |
Orientation X |
|
Event_Details (Orientation_X) |
|
30 |
Orientation Y |
|
Event_Details. (Orientation_Y) |
|
31 |
Orientation Z |
|
Event_Details (Orientation_Z) |
|
32 |
ESignature |
|
Signature ID from the ESignature table |