Resource

Group

b_htr_stat

Name

BI_ORDER_ENTRY_DETAIL_V

Description

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

Entity

Name Type DBType Nullable
Order_Entry_Id Int64 NUMBER (11) True
Order_Header_Id Int64 NUMBER (10) True
Expense_Bsc Decimal NUMBER (20, 2) True
Entry_Type Int32 NUMBER (1) True
Income_Bsc Decimal NUMBER (20, 2) True
Income_Plan_Bsc Decimal NUMBER (20, 2) True
Company_No Int32 NUMBER (6) True
Worker_Id Int64 NUMBER (10) True
Leva_Employee_Id Int64 NUMBER (10) True
Customer_Bp_Addr_Id Int64 NUMBER (10) True
C4542_Scheduling_Group_Ordered Int32 NUMBER (8) True
Scheduling_Group_Ordered String VARCHAR2 (100) True
C4542_Scheduling_Group_Delivered Int32 NUMBER (8) True
Scheduling_Group_Delivered String VARCHAR2 (100) True
Performance_Record_H Decimal NUMBER (0, -127) True
Machine_Id Int64 NUMBER (10) True
Period Int32 NUMBER (6) True
Period_Year Int32 NUMBER (4) True
Period_Month Int32 NUMBER (2) True
Sale_Item_Id Int64 NUMBER (10) True
C4550_Resource_Type Int32 NUMBER (8) True
Resource_Type String VARCHAR2 (100) True
Surcharge_Id Int64 NUMBER (10) True
Accessory_Id Int64 NUMBER (10) True
Account String VARCHAR2 (20) True
Cost_Center String VARCHAR2 (20) True