PRT_INSTACCT

Database

SDSNZS01_PRT

Schema

CDCPADM_PRT

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY SMALLINT 2
2 PRODUCT CHARACTER VARYING(3) 3
3 POLICY INTEGER 4
4 TRANCNT SMALLINT 2
5 TERMSTART INTEGER 4
6 ACCTTYPE CHARACTER VARYING(1) 1
7 BSBNO CHARACTER VARYING(6) 6
8 DEBITACCT CHARACTER VARYING(9) 9
9 HOLDFLAG CHARACTER VARYING(1) 1
10 HOLDDATE INTEGER 4
11 ACCTNAME CHARACTER VARYING(32) 32
12 CREDCARD CHARACTER VARYING(16) 16
13 CARDEXPRY SMALLINT 2
14 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
15 RECORD_TYPE CHARACTER VARYING(16) 16
16 COMMIT_TIMESTAMP TIMESTAMP 8
17 EXTRACT_TIMESTAMP TIMESTAMP 8
18 CDC_ID BIGINT 8
19 COMPANY_CDC SMALLINT 2
20 POLICY_CDC BIGINT 8
21 DW_TIMESTAMP TIMESTAMP 8
22 DEBITDAY SMALLINT 2
23 CENTCRN CHARACTER(10) 10
24 AUTHNAME CHARACTER(32) 32
25 CANCEFFDTE INTEGER 4
26 HOLDRSN CHARACTER(2) 2