Resource

Group

b_htr_stat

Name

BI_ORDER_BILLING_POS_V

Description

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

Entity

Name Type DBType Nullable
Order_Billing_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_Billing_id Int64 NUMBER (10) False
Order_Phase_id Int64 NUMBER (10) False
Order_Pos_id Int64 NUMBER (10) False
Order_Pos_Surcharge_id Int64 NUMBER (10) True
Billing_bool Int32 NUMBER (1) False
Text String VARCHAR2 (4000) True
Sales_Item_id Int64 NUMBER (10) True
C4560_Attachment_Group Int32 NUMBER (8) True
Attachment_Group String VARCHAR2 (100) True
Quantity_Ordered Decimal NUMBER (14, 4) True
Quantity_Selected Decimal NUMBER (14, 4) True
Quantity_Billed Decimal NUMBER (14, 4) True
Free_Of_Charge_bool Int32 NUMBER (1) False
C28_Price_Unit Int32 NUMBER (8) True
Price_Unit String VARCHAR2 (100) True
Price_Inv_Curr Decimal NUMBER (12, 2) True
Discount Decimal NUMBER (4, 2) True
Amount_Exkl_Inv_Curr Decimal NUMBER (16, 2) True
C23_Vat Int32 NUMBER (8) True
Vat String VARCHAR2 (100) True
Billing_id Int64 NUMBER (10) True
Flat_Rate_Amount_Inv_Curr Decimal NUMBER (16, 2) True
RV_Billing_id Int64 NUMBER (10) True
Number Int64 NUMBER (10) True
Surcharge_Pos_id Int64 NUMBER (10) True
Excl_To_Pos_Flatrate_bool Int32 NUMBER (1) False
Perc_Pos_Base_Amount_Inv_Curr Decimal NUMBER (16, 2) True
Perc_Pos_Base_Percentage Decimal NUMBER (12, 2) True
Perc_Pos_Amount_Round_Inv_Curr Decimal NUMBER (16, 2) True
Perc_Pos_Comment String VARCHAR2 (4000) True
Revenue_Account_Manual String VARCHAR2 (10) True
CU_Manual String VARCHAR2 (20) True
C23_Vat_Manual Int32 NUMBER (8) True
Vat_Manual String VARCHAR2 (100) True
Position_Text_Manual String VARCHAR2 (4000) True
Billing_On_Normal_Pos_bool Int32 NUMBER (1) False
Account_From_Order_Pos_bool Int32 NUMBER (1) False
Vat_From_Order_Pos_bool Int32 NUMBER (1) False
Excluded_bool Int32 NUMBER (1) False
Min_Sales_Quantity Decimal NUMBER (14, 4) True
Quantity_Requested Decimal NUMBER (14, 4) True
Service_Date_From DateTime DATE (7) True
Service_Date_To DateTime DATE (7) True