Business Glossary

sdsrsp01_bank

VIEW

#	Name	Data Type	Length
1	trace_id	character varying	120
2	transaction_id	bigint	64
3	npp_transaction_id	character varying	105
4	end_to_end_id	character varying	105
5	case_id	character varying	105
6	transaction_date	date
7	last_updated_timestamp	timestamp without time zone
8	effective_date	timestamp without time zone
9	after_posting_balance	numeric	16
10	transaction_code	character varying	15
11	reference_transaction	character varying	141
12	transaction_type	character varying	72
13	amount	double precision	53
14	currency	character varying	30
15	payid	character varying	768
16	payid_type	character varying	300
17	payid_name	character varying	420
18	from_account_title	character varying	420
19	from_account_number	character varying	60
20	from_bsb	character varying	21
21	to_account_title	character varying	420
22	to_account_number	character varying	60
23	to_bsb	character varying	21
24	payment_domain	text
25	payment_address	text
26	payment_direction_fin	character varying	72
27	channel_code	character varying	72
28	channel_desc	character varying	150
29	account_type	character varying	30
30	payment_status	character varying	72
31	payment_status_flag	text
32	payment_service	character varying	750
33	rdm_payment_type	character varying	750
34	rdm_payment_type_status	character varying	750
35	rdm_return_status	character varying	750
36	rejection_flag	text
37	calendar_month_name	text
38	calendar_qtr	integer	32
39	calendar_qtr_name	text
40	calendar_year	integer	32
41	calendar_yyyymm	integer	32
42	calendar_qtr_no	integer	32