Resource

Group

b_htr_stat

Name

BI_WS_SALES_ITEM_V

Description

View für PowerBI mit verkaufsartikel aus B_WKST

Entity

Name Type DBType Nullable
WS_Sales_Item_Id Int64 NUMBER (10) False
Rec_Vers Int64 NUMBER (10) False
Create_User String VARCHAR2 (30) False
Create_Date DateTime DATE (7) 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
Item_Id Int64 NUMBER (10) False
Short_Description String VARCHAR2 (80) True
Description String VARCHAR2 (200) True
Sellable_From DateTime DATE (7) True
Sellable_Until DateTime DATE (7) True
Comment String VARCHAR2 (2000) True
Attr_Value_Set_Id Int64 NUMBER (10) True
C3322_Position_Type Int32 NUMBER (8) True
WS_Origin_bool Int32 NUMBER (1) False
Item_Group_Id Int64 NUMBER (10) True
C28_Unit Int32 NUMBER (8) True
Stock_Management_bool Int32 NUMBER (1) False
Inventory_Management_bool Int32 NUMBER (1) False
Statistic_Item_bool Int32 NUMBER (1) False
EAN_Code String VARCHAR2 (13) True
Template_Item_bool Int32 NUMBER (1) False
Expense_Account_Selector String VARCHAR2 (10) True
Allowance_Id Int64 NUMBER (10) True