Resource

Group

b_htr_stat

Name

BI_SALE_ITEM_V

Description

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

Entity

Name Type DBType Nullable
Sale_Item_Id Int64 NUMBER (10) False
Rec_Vers Int64 NUMBER (10) False
Modify_User String VARCHAR2 (30) False
Modify_Date DateTime DATE (7) False
Active_bool Int32 NUMBER (1) False
Company_No Int32 NUMBER (6) False
Sale_Item_No String VARCHAR2 (20) False
Description_long String VARCHAR2 (300) False
Description String VARCHAR2 (80) False
Main_Item_Group String VARCHAR2 (300) False
Item_Group String VARCHAR2 (300) False
Item_Category String VARCHAR2 (100) True
Item_Attr_Value_ID Int64 NUMBER (10) True
Ba_Article_id Int64 NUMBER (10) False
Comment String VARCHAR2 (2000) True
C4560_Standard_Att_Group Int32 NUMBER (8) True
Standard_Att_Group String VARCHAR2 (100) True
Internal_Service_Charging_bool Int32 NUMBER (1) False
Percentage_Article_bool Int32 NUMBER (1) False
Eligible_Reimbursement_bool Int32 NUMBER (1) False
Service_Provider_Id Int64 NUMBER (10) True
Standard_Rate_Mode_bool Int32 NUMBER (1) False
Standard_Rate_Mode_Id Int64 NUMBER (10) True
Sellable_from DateTime DATE (7) False
Sellable_until DateTime DATE (7) True