INT_BASE_PI_RES_PMT_REVERSALS_ORIG

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY_NO INTEGER 4
2 POLICY_NO BIGINT 8
3 ITEM_NO SMALLINT 2
4 PRODUCT_TYPE_CODE CHARACTER VARYING(3) 3
5 PRODUCT_CLASS_CODE CHARACTER VARYING(2) 2
6 PRODUCT_SUBCLASS CHARACTER VARYING(2) 2
7 PRODUCT_EXTRA_KEY1 CHARACTER VARYING(1) 1
8 PRODUCT_EXTRA_KEY2 CHARACTER VARYING(10) 10
9 DUE_DATE DATE 4
10 TRANSACTION_DATE DATE 4
11 TRANTIME_REF INTEGER 4
12 REV_TRANSACTION_DATE DATE 4
13 REV_TRANTIME_REF INTEGER 4
14 POLICY_STAGE_KEY5 CHARACTER VARYING(4) 4
15 REVERSED_FLAG CHARACTER VARYING(1) 1