Resource

Group

b_htr_stat

Name

BI_MACHINE_V

Description

View für PowerBI mit Maschinen-Information der LEVA+ Aufträge

Entity

Name Type DBType Nullable
Machine_Id Int64 NUMBER (10) False
Machine_No String VARCHAR2 (20) True
Machine_UID String VARCHAR2 (36) False
Create_Date DateTime DATE (7) False
Create_User String VARCHAR2 (30) False
Modify_Date DateTime DATE (7) False
Modify_User String VARCHAR2 (30) False
Machine String VARCHAR2 (200) False
Master_Number String VARCHAR2 (100) True
Chassis_Number String VARCHAR2 (100) True
Engine_Number String VARCHAR2 (100) True
Type_Certificate_Number String VARCHAR2 (100) True
License_Plate String VARCHAR2 (20) True
Year_of_Manufacturing Int32 NUMBER (4) True
Info_AssetNo String VARCHAR2 (16) True
C4541_Machine_Category Int32 NUMBER (8) False
Machine_Category String VARCHAR2 (100) False
C4542_Scheduling_Group Int32 NUMBER (8) True
Scheduling_Group String VARCHAR2 (100) True
C4562_Branch_Machine Int32 NUMBER (8) True
Branch_Machine String VARCHAR2 (100) True
External_Resource Int32 NUMBER (1) False
Acquisition_Date DateTime DATE (7) True
Warranty_Until DateTime DATE (7) True
C4543_Manufacturer Int32 NUMBER (8) True
Manufacturer String VARCHAR2 (100) True
Owner String VARCHAR2 (50) False
Registration_Date DateTime DATE (7) True
Regular_Driver_Bp_Id Int64 NUMBER (10) True
Regular_Driver String VARCHAR2 (101) True
C4562_Branch Int32 NUMBER (8) True
Location_Bp_Addr_Id Int64 NUMBER (10) True
Location String VARCHAR2 (50) True
Asset_No String VARCHAR2 (16) True
Cost_Center String VARCHAR2 (20) True
Owner_Company_No Int32 NUMBER (6) True
Owner_Bp_Addr_Id Int64 NUMBER (10) False
Dimension_ASVID Int64 NUMBER (10) True
Add_Info_ASVID Int64 NUMBER (10) True
Add_Info_Confidential_ASVID Int64 NUMBER (10) True
Regular_Trailer_Machine_Id Int64 NUMBER (10) True