TEST

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ID BIGINT 8
2 ACTION_CODE CHARACTER VARYING(1) 1
3 KEY_COID CHARACTER VARYING(5) 5
4 KEY_PROD CHARACTER VARYING(3) 3
5 KEY_ACCT BIGINT 8
6 EFFECTIVE_DATE TIMESTAMP 8
7 ENVMT CHARACTER VARYING(5) 5
8 SOURCE_TYPE CHARACTER VARYING(5) 5
9 APPL_ID CHARACTER VARYING(5) 5
10 TRANSACTION_CODE CHARACTER VARYING(5) 5
11 AFTER_POSTING_BALANCE NUMERIC(16,2) 19
12 AMOUNT NUMERIC(16,2) 19
13 NBR_OF_DEPOSITED_CHQS INTEGER 4
14 OPERATOR CHARACTER VARYING(20) 20
15 PAID_INTO_OVERDRAFT CHARACTER VARYING(1) 1
16 POSTING_DATE TIMESTAMP 8
17 POSTING_TIME CHARACTER VARYING(8) 8
18 REFERENCE CHARACTER VARYING(47) 47
19 SOURCE_BRANCH CHARACTER VARYING(5) 5
20 TRACE_NUMBER CHARACTER VARYING(20) 20
21 TRAN_CREATION_DATE TIMESTAMP 8
22 XFER_FROM_ACCT_NBR BIGINT 8
23 XFER_FROM_APPL_ID CHARACTER VARYING(5) 5
24 XFER_FROM_TRANCODE CHARACTER VARYING(5) 5
25 XFER_TO_ACCT_NBR BIGINT 8
26 XFER_TO_APPL_ID CHARACTER VARYING(5) 5
27 XFER_TO_TRANCODE CHARACTER VARYING(5) 5
28 CHQ_NO BIGINT 8
29 TRAN_NO CHARACTER VARYING(9) 9
30 DATA_DATE TIMESTAMP 8
31 LOAD_ID INTEGER 4