DIM_SDW_TSLND_ARRANGEMENT_TYP3

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 ARRANGEMENT_ID CHARACTER VARYING(20) 20
2 ORIG_PERIOD_DIM_ID BIGINT 8
3 ORIG_PREAPPROVED_FLAG CHARACTER VARYING(1) 1
4 ORIG_PREAPPROVED_DT TIMESTAMP 8
5 ORIG_CONDITIONAL_APPROVAL_DT TIMESTAMP 8
6 ORIG_UNCONDITIONAL_APPROVAL_DT TIMESTAMP 8
7 ORIG_APP_CAPTURE_USER_ID CHARACTER VARYING(100) 100
8 ORIG_APP_CAPTURE_USER_NAME CHARACTER VARYING(80) 80
9 ORIG_APP_CAPTURE_USER_DT TIMESTAMP 8
10 ORIG_SALES_OFFICER_ID CHARACTER VARYING(12) 12
11 ORIG_SALES_OFFICER_NAME CHARACTER VARYING(80) 80
12 ORIG_SALES_OFFICER_DT TIMESTAMP 8
13 ORIG_SALES_BRANCH CHARACTER VARYING(5) 5
14 ORIG_SALES_BRANCH_DT TIMESTAMP 8
15 ORIG_SETTLEMENT_BRANCH CHARACTER VARYING(5) 5
16 ORIG_SETTLEMENT_BRANCH_DT TIMESTAMP 8
17 CURR_PERIOD_DIM_ID BIGINT 8
18 CURR_PREAPPROVED_FLAG CHARACTER VARYING(1) 1
19 CURR_PREAPPROVED_DT TIMESTAMP 8
20 CURR_CONDITIONAL_APPROVAL_DT TIMESTAMP 8
21 CURR_UNCONDITIONAL_APPROVAL_DT TIMESTAMP 8
22 CURR_SALES_OFFICER_ID CHARACTER VARYING(12) 12
23 CURR_SALES_OFFICER_NAME CHARACTER VARYING(80) 80
24 CURR_SALES_OFFICER_DT TIMESTAMP 8
25 CURR_SALES_BRANCH CHARACTER VARYING(5) 5
26 CURR_SALES_BRANCH_DT TIMESTAMP 8
27 CURR_SETTLEMENT_BRANCH CHARACTER VARYING(5) 5
28 CURR_SETTLEMENT_BRANCH_DT TIMESTAMP 8