FCT_CI_NEGOTIATION

Database

INSNZP01

Schema

X01PADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
2 NEGOTIATION_CLAIM_ID BIGINT 8
3 NEGOTIATION_ID BIGINT 8
4 NEGOTIATION_CREATE_DATE TIMESTAMP 8
5 NEGOTIATION_CREATE_DATE_ID INTEGER 4
6 NEGOTIATION_UPDATE_DATE TIMESTAMP 8
7 NEGOTIATION_UPDATE_DATE_ID INTEGER 4
8 NEGOTIATION_CREATE_USER_ID BIGINT 8
9 NEGOTIATION_UPDATE_USER_ID BIGINT 8
10 NEGOTIATION_NAME CHARACTER VARYING(128) 128
11 NEGOTIATION_MATTER_ID BIGINT 8
12 NEGOTIATION_LIABILITY_ASSESSMENT_AMOUNT NUMERIC(18,2) 19
13 NEGOTIATION_TARGETOFFER_AMOUNT NUMERIC(18,2) 19
14 NEGOTIATION_MAXOFFER_AMOUNT NUMERIC(18,2) 19
15 NEGOTIATION_RATIONALE CHARACTER VARYING(2000) 2000
16 NEGOTIATION_COUNT INTEGER 4
17 NEGOTIATION_SETTLEMENT_PLAN CHARACTER VARYING(2000) 2000
18 NEGOTIATION_RECORD_TYPE CHARACTER VARYING(10) 10