Resource

Group

b_htr_stat

Name

BI_IMS_COST_NOTICE_V

Description

View für PowerBI mit IMS Schadensfeststellungsdaten aus leva_quality_management

Entity

Name Type DBType Nullable
IMS_Cost_Notice_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
Active_Bool Int32 NUMBER (1) False
Company_No Int64 NUMBER (10) False
IMS_Subject_Id String VARCHAR2 (36) True
Customer_Company_Mapping_Id Int64 NUMBER (10) False
Email_Sender String VARCHAR2 (50) False
Email_Recipient String VARCHAR2 (50) False
Email_Subject String VARCHAR2 (200) False
Email_Content String CLOB (2147483647) False
Recipient_Bp_Id Int64 NUMBER (10) True
Costs_Estimated Decimal NUMBER (12, 2) True
C17_Language Int32 NUMBER (8) False
C26_Currency Int32 NUMBER (8) False
Introduction String VARCHAR2 (4000) False
Subject String VARCHAR2 (1000) False
IMS_Cost_Notice_State String VARCHAR2 (1) False
Error_Message String VARCHAR2 (4000) True
IMS_Cost_Notice_No String VARCHAR2 (50) False