Resource

Group

b_htr_stat

Name

BI_IMS_SUBJECT_V

Description

View für PowerBI mit IMS Subjectdaten aus leva_quality_management

Entity

Name Type DBType Nullable
IMS_Subject_Id String VARCHAR2 (36) True
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
IMS_Incident_Id String VARCHAR2 (36) True
Title String VARCHAR2 (200) False
Description String VARCHAR2 (4000) True
Causer_Party String VARCHAR2 (200) True
Damaged_Party String VARCHAR2 (200) True
Customer_Company_Id Int32 NUMBER (6) True
Invoice_Address_Bp_Addr_Id Int64 NUMBER (10) True
Invoice_Shipping_Address_Bp_Addr_Id Int64 NUMBER (10) True
Insurance_Case_No String VARCHAR2 (100) True
Insurance_Other_Party String VARCHAR2 (200) True
Insurance_Case_No_Other_Party String VARCHAR2 (100) True
Involved_Employee_Id Int64 NUMBER (10) True
Involved_Person_Other_Party String VARCHAR2 (200) True
C4562_Assigned_Branch Int64 NUMBER (10) True
Active_Bool Int32 NUMBER (1) False
C6958_Ims_Causer_Category Int32 NUMBER (8) True
C6959_Ims_Status Int32 NUMBER (8) False
Resolved_Bool Int32 NUMBER (1) False
Causer_Party_Bp_Addr_Id Int64 NUMBER (10) True
Causer_Rental_Order_Id Int64 NUMBER (10) True
C3344_Insurance_Type Int32 NUMBER (8) True
Costs_Estimated Decimal NUMBER (12, 2) True
Involved_Accessory_Id Int64 NUMBER (10) True
Involved_Machine_Id Int64 NUMBER (10) True
Amount_Paid_By_Insurance Decimal NUMBER (12, 2) True
Amount_Received Decimal NUMBER (12, 2) True
Order_Header_Id Int64 NUMBER (10) True