| Name |
Type |
DBType |
Nullable |
| Resource_Id |
Int64 |
NUMBER (10) |
False |
| Rec_Vers |
Int64 |
NUMBER (10) |
False |
| Create_User |
String |
VARCHAR2 (30) |
False |
| Create_Date |
DateTime |
DATE (7) |
False |
| Modify_User |
String |
VARCHAR2 (30) |
False |
| Modify_Date |
DateTime |
DATE (7) |
False |
| C4550_Resource_Type |
Int32 |
NUMBER (8) |
False |
| Resource_No |
Int32 |
NUMBER (8) |
False |
| C4542_Scheduling_Group |
Int32 |
NUMBER (8) |
True |
| Parent_Resource_Id |
Int64 |
NUMBER (10) |
True |
| Attr_Value_Set_Id |
Int64 |
NUMBER (10) |
True |
| Job_Description |
String |
VARCHAR2 (2000) |
True |
| C4542_Trailer_Group |
Int32 |
NUMBER (8) |
True |
| Order_Header_Id |
Int64 |
NUMBER (10) |
False |
| O_Trnsp_Order_Phase_Id |
Int64 |
NUMBER (10) |
True |
| R_Trnsp_Order_Phase_Id |
Int64 |
NUMBER (10) |
True |
| Trnsp_C4560_Attachment_Group |
Int32 |
NUMBER (8) |
True |
| Setup_Condition_Id |
Int64 |
NUMBER (10) |
True |
| Machine_Config_Id |
Int64 |
NUMBER (10) |
True |
| Resource_Partlist_Pos_Id |
Int64 |
NUMBER (10) |
True |
| Ready_At_Job_Start_bool |
Int32 |
NUMBER (1) |
False |
| Delivered_bool |
Int32 |
NUMBER (1) |
False |
| Job_Start |
DateTime |
DATE (7) |
True |
| Job_End |
DateTime |
DATE (7) |
True |
| Duration_Round_Trip |
Decimal |
NUMBER (5, 2) |
True |
| Handover |
DateTime |
DATE (7) |
True |
| Return |
DateTime |
DATE (7) |
True |
| Transports_Generate_bool |
Int32 |
NUMBER (1) |
False |
| Driver_Shift_Plan_bool |
Int32 |
NUMBER (1) |
False |
| Comment |
String |
VARCHAR2 (500) |
True |
| Auto_Job_Extension_bool |
Int32 |
NUMBER (1) |
False |
| Split_Scheduling_Mult_Res_bool |
Int32 |
NUMBER (1) |
False |
| Job_End_Date_Is_Fixed_bool |
Int32 |
NUMBER (1) |
False |
| Flex_Time_Spec_Handover |
String |
VARCHAR2 (20) |
False |
| Flex_Time_Spec_Return |
String |
VARCHAR2 (20) |
False |
| Goes_To_Tour_bool |
Int32 |
NUMBER (1) |
False |
| Maximum_Load_Kg |
Int64 |
NUMBER (10) |
True |
| Working_Height_M |
Decimal |
NUMBER (14, 4) |
True |
| Lateral_Range_M |
Decimal |
NUMBER (14, 4) |
True |
| Load_Weight_Kg |
Int64 |
NUMBER (10) |
True |
| Horizontal_Reach_M |
Decimal |
NUMBER (14, 4) |
True |
| Boom_Length_M |
Decimal |
NUMBER (14, 4) |
True |
| Duration_Buildup |
Decimal |
NUMBER (5, 2) |
True |
| Duration_Destruction |
Decimal |
NUMBER (5, 2) |
True |
| Transports_Remain_bool |
Int32 |
NUMBER (1) |
False |
| Pure_Crane_Work_bool |
Int32 |
NUMBER (1) |
False |
| Duration_Unload |
Decimal |
NUMBER (5, 2) |
True |
| Duration_Outbound_Trip |
Decimal |
NUMBER (5, 2) |
True |
| Duration_Return_Trip |
Decimal |
NUMBER (5, 2) |
True |
| Weight_Kg |
Int64 |
NUMBER (10) |
True |
| Early_Delivery_Possible_bool |
Int32 |
NUMBER (1) |
False |
| Job_End_Comment |
String |
VARCHAR2 (500) |
True |
| Transport_Type |
String |
VARCHAR2 (20) |
True |
| Use_Genius_bool |
Int32 |
NUMBER (1) |
False |
| Auto_Online_Checkout_bool |
Int32 |
NUMBER (1) |
False |
| Manual_Online_Checkout_bool |
Int32 |
NUMBER (1) |
False |
| Master_bool |
Int32 |
NUMBER (1) |
False |