INT_SHRD_SUB_APPLN_FAC_MASTER_QRM_FEES

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP05_BANK..INT_SHRD_SUB_APPLN_FAC_MASTER_QRM_FEES_V

Columns
# Name Data Type Length
1 VALUE_DATE DATE 4
2 SUBMISSION_ID CHARACTER VARYING(50) 50
3 FACILITY_CREATION_DATE TIMESTAMP 8
4 SUBMISSION_CREATION_DATE TIMESTAMP 8
5 SUBMISSION_DATA_ENTRY_BRANCH CHARACTER VARYING(10) 10
6 SUBMISSION_CREATED_BY CHARACTER VARYING(254) 254
7 SUBMISSION_BRANCH CHARACTER VARYING(10) 10
8 SUBMISSION_DATE TIMESTAMP 8
9 SUBMISSION_STATUS CHARACTER VARYING(50) 50
10 WORKFLOW_STATUS CHARACTER VARYING(50) 50
11 PARTY_ID CHARACTER VARYING(40) 40
12 EXTERNAL_PARTY_ID CHARACTER VARYING(40) 40
13 APPLICANT_ID CHARACTER VARYING(50) 50
14 IS_PRIMARY_APPLICANT CHARACTER(1) 1
15 ENTITY_STATUS CHARACTER VARYING(1) 1
16 PARTY_TYPE CHARACTER VARYING(50) 50
17 APPLICATION_ID CHARACTER VARYING(50) 50
18 APPLICATION_CREATED_BY CHARACTER VARYING(254) 254
19 APPLICATION_BRANCH CHARACTER VARYING(10) 10
20 APPLICATION_STATUS CHARACTER VARYING(50) 50
21 APPLICATION_CREATION_DATE TIMESTAMP 8
22 APPLICATION_DATA_ENTRY_BRANCH CHARACTER VARYING(10) 10
23 FACILITY_ID CHARACTER VARYING(40) 40
24 PROD_GRP_SERIAL_NO BYTEINT 1
25 BORR_ENTITY_ID CHARACTER VARYING(50) 50
26 LOAN_PURPOSE CHARACTER VARYING(40) 40
27 LOAN_SUB_PURPOSE CHARACTER VARYING(255) 255
28 BASE_LOAN_AMOUNT DOUBLE PRECISION 8
29 TOTAL_CAPITALISED_FEE_AMOUNT DOUBLE PRECISION 8
30 TOTAL_CAPITALISED_INS_AMOUNT DOUBLE PRECISION 8
31 TOTAL_FUNDING_AMOUNT DOUBLE PRECISION 8
32 TOTAL_LOAN_AMOUNT DOUBLE PRECISION 8
33 OFFER_ID CHARACTER VARYING(40) 40
34 PRODUCT_CODE CHARACTER VARYING(50) 50
35 PRODUCT_GROUP_ID CHARACTER VARYING(50) 50
36 CCY_CODE CHARACTER VARYING(3) 3
37 BRANCH_CODE CHARACTER VARYING(10) 10
38 PRODUCT_GRP_CODE CHARACTER VARYING(16) 16
39 FACILITY_TYPE CHARACTER VARYING(3) 3
40 FACILITY_CATEGORY_CODE CHARACTER VARYING(50) 50
41 APPROVAL_TYPE CHARACTER VARYING(3) 3
42 APPROVER_ID CHARACTER VARYING(50) 50
43 APPROVER_NAME CHARACTER VARYING(50) 50
44 BUSINESS_UNIT CHARACTER VARYING(40) 40
45 EMPLOYEE_FLAG CHARACTER VARYING(1) 1
46 LENDING_CATEGORY_CODE CHARACTER VARYING(16) 16
47 LOWDOC_FLAG CHARACTER VARYING(1) 1
48 CD_APPLICATION_ID CHARACTER VARYING(50) 50
49 DECISION_DATE TIMESTAMP 8
50 DECISION_ID CHARACTER VARYING(50) 50
51 DECISION_STATUS_TYPE CHARACTER VARYING(50) 50
52 APPROVED_AMT DOUBLE PRECISION 8
53 FIRST_DISBURSEMENT_DATE TIMESTAMP 8
54 ACCOUNT_ID CHARACTER VARYING(40) 40
55 ACCOUNT_OPENING_DATE TIMESTAMP 8
56 SCHEDULE_CODE CHARACTER VARYING(40) 40
57 CDTL_APPROVAL_DATE TIMESTAMP 8
58 UNCDTL_APPROVAL_DATE TIMESTAMP 8
59 CDTL_APPROVED_OFFICER CHARACTER VARYING(254) 254
60 UNCDTL_APPROVED_OFFICER CHARACTER VARYING(254) 254
61 WORKFLOW_ACTION CHARACTER VARYING(50) 50
62 SIMULATION_ID CHARACTER VARYING(50) 50
63 OFFER_SERIAL_NUMBER BYTEINT 1
64 SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
65 BANK_CODE CHARACTER VARYING(4) 4
66 BANKING_TYPE CHARACTER VARYING(6) 6
67 IS_FEE_CAPITALIZED CHARACTER VARYING(1) 1
68 IS_CCI_CAPITALIZED CHARACTER VARYING(1) 1
69 TERM_MONTHS BIGINT 8
70 APPLN_REQ_TYPE CHARACTER VARYING(20) 20
71 APPLN_TYPE CHARACTER VARYING(20) 20
72 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
73 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
74 CDC_RECORD_TYPE CHARACTER VARYING(6) 6
75 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3