Resource

Group

b_htr_stat

Name

BI_ACCRUAL_SERVICE_TIME_V

Description

View für PowerBI mit Abgrenzungs-Leistungszeiten der LEVA+ Aufträge

Entity

Name Type DBType Nullable
Accrual_Service_Time_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
Resource_Allocation_Id Int64 NUMBER (10) False
Order_Phase_Id Int64 NUMBER (10) True
Date DateTime DATE (7) False
Time_From DateTime DATE (7) False
Time_To DateTime DATE (7) False
Quantity_Hour Decimal NUMBER (0, -127) False
Worker_Id Int64 NUMBER (10) True
Machine_Id Int64 NUMBER (10) True
Order_No String VARCHAR2 (20) False
Cost_Unit String VARCHAR2 (20) True
Sales_Channel String VARCHAR2 (3) True
Company_No Int32 NUMBER (6) False
Order_Pos_Id Int64 NUMBER (10) True