INT_EOD_SNPT_OBP_PORTFOLIO_PIT

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP05_BANK..INT_EOD_SNPT_OBP_PORTFOLIO_PIT_V

Columns
# Name Data Type Length
1 ACCOUNT_ID CHARACTER VARYING(40) 40
2 VALUE_DATE DATE 4
3 SNPT_EOD_TS TIMESTAMP 8
4 PRODUCT_ID CHARACTER VARYING(30) 30
5 PRODUCT_GROUP_CODE CHARACTER VARYING(30) 30
6 BRANCH_CODE CHARACTER VARYING(10) 10
7 BANK_CODE CHARACTER VARYING(10) 10
8 OFFER_ID CHARACTER VARYING(30) 30
9 PARTY_ID CHARACTER VARYING(40) 40
10 EXPECTED_CODE_TYPE CHARACTER VARYING(14) 14
11 PRINCIPAL_OFFSET_FLAG CHARACTER(1) 1
12 REDRAW_FLAG CHARACTER(1) 1
13 APPLN_REQ_TYPE CHARACTER VARYING(100) 100
14 CURRENCY_CODE CHARACTER VARYING(3) 3
15 ACCOUNT_STATUS_CODE CHARACTER VARYING(50) 50
16 LOAN_PURPOSE_TYPE CHARACTER VARYING(40) 40
17 PURPOSE_CODE CHARACTER VARYING(10) 10
18 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
19 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
20 CDC_COMMIT_TIMESTAMP DATE 4
21 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
22 CURRENT_INTEREST_RATE DOUBLE PRECISION 8
23 APPROVED_AMOUNT DOUBLE PRECISION 8
24 PAYMENT_DONE_TODAY_AMT DOUBLE PRECISION 8
25 PRINCIPAL_ARREARS_AMT DOUBLE PRECISION 8
26 ARREARS_AMT_EXPT_PRNC_ARREAR DOUBLE PRECISION 8
27 UNCOLL_INTEREST_AMT DOUBLE PRECISION 8
28 PRINCIPAL_BALANCE_AMT DOUBLE PRECISION 8
29 RPA_BALANCE_AMT DOUBLE PRECISION 8
30 DISBURSED_AMT DOUBLE PRECISION 8
31 IOA_BALANCE_AMT DOUBLE PRECISION 8
32 UNCLEAR_AMT DOUBLE PRECISION 8
33 OFFSET_CLEAR_BALANCE DOUBLE PRECISION 8
34 OFFSET_UNCLEAR_BALANCE DOUBLE PRECISION 8
35 INTEREST_ACCRUED_LST_DTE_AMT DOUBLE PRECISION 8
36 UNDRAWN_AMOUNT DOUBLE PRECISION 8
37 BILL_AMOUNT DOUBLE PRECISION 8
38 PRINCIPLE_LIMIT DOUBLE PRECISION 8