Resource

Group

b_htr_stat

Name

BI_WS_ORDER_V

Description

View für PowerBI mit auftrag aus B_WKST

Entity

Name Type DBType Nullable
WS_Order_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
Company_No Int32 NUMBER (6) False
C3318_Order_Type Int32 NUMBER (8) False
Offer_bool Int32 NUMBER (1) False
Order_No String VARCHAR2 (20) False
Title String VARCHAR2 (100) False
C3317_Branch Int32 NUMBER (8) False
C3319_Order_Status Int32 NUMBER (8) False
C3320_Order_Lock_Status Int32 NUMBER (8) False
Machine_Id Int64 NUMBER (10) True
Cost_Center_No String VARCHAR2 (20) True
Asset_No String VARCHAR2 (16) True
External_Company_No Int32 NUMBER (6) True
External_Order_No String VARCHAR2 (20) True
Our_Reference String VARCHAR2 (50) True
Your_Reference String VARCHAR2 (50) True
Customer_Company_Id Int64 NUMBER (10) True
Contact_Bp_Id Int64 NUMBER (10) True
Invoice_Bp_Addr_Id Int64 NUMBER (10) True
Shipping_Bp_Adr_Id Int64 NUMBER (10) True
Shipping_Address String VARCHAR2 (500) True
C27_Payment_Terms Int32 NUMBER (8) True
Currency String VARCHAR2 (3) False
C124_Vat_System Int32 NUMBER (8) False
Export_bool Int32 NUMBER (1) False
Cost_Unit_No String VARCHAR2 (20) True
Order_Date DateTime DATE (7) False
Order_Date_Start DateTime DATE (7) True
Order_Date_Finish DateTime DATE (7) True
Place_Of_Work_Bp_Addr_Id Int64 NUMBER (10) True
Place_Of_Work_Address String VARCHAR2 (500) True
Outsourcing_bool Int32 NUMBER (1) False
Outsourcing_Bp_Addr_Id Int64 NUMBER (10) True
Outsourcing_Address String VARCHAR2 (500) True
Notes String CLOB (2147483647) True
C3321_Pool_Order_Type Int32 NUMBER (8) False
App_Id Byte[] RAW (16) False
C3333_Accounting_Group Int32 NUMBER (8) True
Template_bool Int32 NUMBER (1) False
Your_Phone_No String VARCHAR2 (50) True
Annual_Order_bool Int32 NUMBER (1) False
Origin String VARCHAR2 (10) False
Origin_Id String VARCHAR2 (50) True
Text_Offer String VARCHAR2 (4000) True
C3339_Template_Category Int32 NUMBER (8) True
Vat_Order_Indicator_Id Int64 NUMBER (10) True
C126_Export_Indicator Int32 NUMBER (8) True
Accessory_Id Int64 NUMBER (10) True
Block_Other_Allocations_bool Int32 NUMBER (1) False
Rental_Context String VARCHAR2 (50) True
Rental_Context_Id String VARCHAR2 (50) True
Maintenance_bool Int32 NUMBER (1) False
Rental_Context_Text String VARCHAR2 (200) True