Resource

Group

b_htr_stat

Name

BI_ORDER_POS_V

Description

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

Entity

Name Type DBType Nullable
Order_Pos_Id Int64 NUMBER (10) False
Rec_Vers Int64 NUMBER (10) False
Modify_User String VARCHAR2 (30) False
Modify_Date DateTime DATE (7) False
Order_Phase_Id Int64 NUMBER (10) False
C4549_Position_Type Int32 NUMBER (8) False
Position_Type String VARCHAR2 (100) True
Order_Header_Id Int64 NUMBER (10) False
Parent_Order_Pos_Id Int64 NUMBER (10) True
Position_No Int64 NUMBER (10) False
C4560_Attachment_Group Int32 NUMBER (8) True
Attachment_Group String VARCHAR2 (100) True
Sale_Item_Id Int64 NUMBER (10) True
Quantity_Position Int64 NUMBER (10) False
Quantity_Ordered Decimal NUMBER (14, 4) True
C28_Price_Unit Int32 NUMBER (8) True
Price_Unit String VARCHAR2 (100) True
Price_Order_Currency Decimal NUMBER (12, 2) True
Fixprice_Bool Int32 NUMBER (1) False
Discount Decimal NUMBER (4, 2) True
Free_of_Charge Int32 NUMBER (1) False
Flatrate_Amount_Order_Curr Decimal NUMBER (16, 2) True
Amount_Order_Curr Decimal NUMBER (16, 2) True
Sub_Order_Header_Id Int64 NUMBER (10) True
Internal_Comment String VARCHAR2 (2000) True
External_Comment String VARCHAR2 (2000) True
C23_Vat Int64 NUMBER (10) True
Vat String VARCHAR2 (100) True
Flatrate_Pos_Order_Curr Decimal NUMBER (16, 2) True
Quantity_Automaticaly_Bool Int32 NUMBER (1) False
Activity String VARCHAR2 (4000) True
C28_Base_Unit Int32 NUMBER (8) True
Base_Unit String VARCHAR2 (100) True
Quantity_Per_Bool Int32 NUMBER (1) False
Ressource_Partlist_Pos_Id Int64 NUMBER (10) True
C6951_Use_Case Int64 NUMBER (10) False
Use_Case String VARCHAR2 (100) True
Position_Text String VARCHAR2 (100) True
Rate_Mode_Id Int64 NUMBER (10) True
Excluded_Bool Int32 NUMBER (1) False
Min_Price Decimal NUMBER (14, 4) True
Min_Sales_Quantity Decimal NUMBER (14, 4) True
Quantity_Requested Decimal NUMBER (14, 4) True
Billing_Modus Int32 NUMBER (1) True
Billing_Date DateTime DATE (7) True
Ressource_Id Int64 NUMBER (10) True
Resource_Id Int64 NUMBER (10) True
Job_Start DateTime DATE (7) True
Job_End DateTime DATE (7) True
Ressource_Start DateTime DATE (7) True
Ressource_End DateTime DATE (7) True
Machine_Id Int64 NUMBER (10) True