Resource

Group

b_htr_stat

Name

BI_ORDER_POS_SURCHARGE_V

Description

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

Entity

Name Type DBType Nullable
Order_Pos_Surcharge_Id Int64 NUMBER (10) False
Rec_Vers Int64 NUMBER (10) False
Modify_User String VARCHAR2 (30) False
Modify_Date DateTime DATE (7) False
Order_Pos_Id Int64 NUMBER (10) False
Surcharge_Pos_Id Int64 NUMBER (10) False
Quantity Decimal NUMBER (14, 4) False
C28_Price_Unit Int32 NUMBER (8) False
Price_Unit String VARCHAR2 (100) True
Price_Order_Curr Decimal NUMBER (12, 2) False
Amount_Order_Curr Decimal NUMBER (16, 2) False
C23_Vat Int32 NUMBER (8) True
Vat String VARCHAR2 (100) True
Flat_Rate_Amount_Order_Curr Decimal NUMBER (16, 2) True
Discount_Percentage Decimal NUMBER (4, 2) True
Min_Price Decimal NUMBER (14, 4) True
Min_Sales_Quantity Decimal NUMBER (14, 4) True
Quantity_Wish Decimal NUMBER (14, 4) True
Excluded_bool Int32 NUMBER (1) False
Excl_To_Pos_Flatrate_bool Int32 NUMBER (1) False
Fix_Price_bool Int32 NUMBER (1) False
Free_Of_Charge_bool Int32 NUMBER (1) False
Manual_bool Int32 NUMBER (1) False
Quantity_Per_bool Int32 NUMBER (1) False
Percentage_Of_Order_Line_bool Int32 NUMBER (1) False
Billing_On_Normal_Pos_bool Int32 NUMBER (1) False