FCT_BNK_BROKER_TRAIL_MONTHLY

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 BROKER_CODE CHARACTER VARYING(40) 40
2 START_DATE CHARACTER VARYING(200) 200
3 SETTLE_DATE CHARACTER VARYING(200) 200
4 CLOSE_DATE CHARACTER VARYING(200) 200
5 ACCT_NBR CHARACTER VARYING(40) 40
6 NAME CHARACTER VARYING(101) 101
7 SUB_PROD_CODE CHARACTER VARYING(30) 30
8 LOAN_STAT CHARACTER VARYING(50) 50
9 ACC_BRKR_CODE CHARACTER VARYING(40) 40
10 SALES_OFF_CODE CHARACTER VARYING(50) 50
11 CURR_BAL_PREV CHARACTER VARYING(200) 200
12 CURR_BAL CHARACTER VARYING(200) 200
13 OD_LIMIT DOUBLE PRECISION 8
14 SUBMISSION_ID CHARACTER VARYING(50) 50