INT_CTP_OUTSTANDING_CASH_V

Database

INSNZP01

Schema

X01PADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 POLICY_NUMBER CHARACTER VARYING(12) 12
2 POLICY_STAGE_LEVEL1 CHARACTER VARYING(20) 20
3 CTP_NUMBER CHARACTER VARYING(12) 12
4 REGO_NUMBER CHARACTER VARYING(12) 12
5 CLIENT_NUMBER INTEGER 4
6 COMPANY SMALLINT 2
7 SUBCOY SMALLINT 2
8 STATE SMALLINT 2
9 BRANCH SMALLINT 2
10 BRANCH_DESC CHARACTER VARYING(41) 41
11 OSCSHTYPE CHARACTER(1) 1
12 RECEIPT CHARACTER VARYING(13) 13
13 SEQUENCE SMALLINT 2
14 CASHTYPE CHARACTER(1) 1
15 AMOUNT NUMERIC(11,2) 19
16 AGENT CHARACTER VARYING(20) 20
17 PRODUCT CHARACTER(3) 3
18 POLICY INTEGER 4
19 CLIENT INTEGER 4
20 CLAIMNO NUMERIC(11,0) 19
21 GLCOMPANY SMALLINT 2
22 GLSTATE SMALLINT 2
23 GLBRANCH SMALLINT 2
24 ACCTCODE INTEGER 4
25 AREARESP SMALLINT 2
26 COMMAMT NUMERIC(11,2) 19
27 NAME CHARACTER(40) 40
28 TRANDATE INTEGER 4
29 LOCKUSER CHARACTER(8) 8
30 LOCKDATE INTEGER 4
31 LOCKTIME INTEGER 4
32 INVOICE INTEGER 4
33 USERID CHARACTER(8) 8
34 USERALLOC CHARACTER(1) 1
35 CUSTREF CHARACTER(14) 14
36 RECOVTYPE CHARACTER(2) 2
37 PAYMNTTYP CHARACTER(2) 2
38 CLTDETAIL CHARACTER(30) 30
39 BUSUNIT CHARACTER(4) 4
40 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
41 RECORD_TYPE CHARACTER VARYING(16) 16
42 COMMIT_TIMESTAMP TIMESTAMP 8
43 EXTRACT_TIMESTAMP TIMESTAMP 8
44 COUNT NUMERIC(38,0) 19
45 ERROR_IDENTIFIER CHARACTER VARYING(9) 9
46 SCHEME_STATE CHARACTER(3) 3
47 ENTRY_RAISED CHARACTER VARYING(12) 12
48 AGENT_NAME CHARACTER VARYING(100) 100
49 AGENT_TYPE CHARACTER(20) 20
50 AGE_OF_ERROR_IN_DAYS INTEGER 4
51 AGED_ERROR_GROUP CHARACTER VARYING(13) 13
52 AGED_ERROR_GROUP_ORDER_KEY INTEGER 4
53 AGENT_GROUP CHARACTER VARYING(24) 24
54 LICENSE_CHANNEL CHARACTER VARYING(24) 24