Data Dictionary -- Bank Cash Definition

Srl. No.	Table Name	Comment
1	bnkdef_acc_his	To store history of account information
2	bnkdef_acc_mst	To store account information
3	bnkdef_bnkusg_his	To store history of bank usage information
4	bnkdef_bnkusg_sys	To store system bank usage information
5	bnkdef_cash_his	To store history of cash information
6	bnkdef_cash_mst	To store cash information
7	bnkdef_charges_his	To store history of charges information
8	bnkdef_charges_mst	To store charge information detail
9	bnkdef_code_his	To store history of code information
10	bnkdef_code_mst	To store information of code details
11	bnkdef_contact_dtl	To store information of contact detail
12	bnkdef_cshusg_his	To store history of cash usage information
13	bnkdef_cshusg_sys	To store system cash usage information
14	bnkdef_filetransfer_mst	To store file transfer information
15	bnkdef_notes_his	To store history of notes information
16	bnkdef_notes_mst	To store notes information detail
17	bnkdef_ref_mst	To store reference information detail

Table Name :	bnkdef_acc_his
Comment :	To store history of account information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
bank_ref_no	fin_banknumber	varchar(20)	No	Bank reference number	Yes
bank_acc_no	fin_banknumber	varchar(20)	No	Bank account number	Yes
serial_no	fin_number	int(4)	No	Serial number	Yes
action_time	fin_datetime	datetime(8)	No	Action time	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
flag	fin_eflag	varchar(1)	Yes	Flag	No
currency_code	fin_currencycode	varchar(5)	Yes	Currency code	No
credit_limit	fin_amount	numeric(13)	Yes	Credit limit	No
draw_limit	fin_amount	numeric(13)	Yes	Draw limit	No
status	fin_status	varchar(25)	Yes	Status	No
effective_from	fin_datetime	datetime(8)	Yes	Effective from	No
effective_to	fin_datetime	datetime(8)	Yes	Effective to	No
creation_ou	fin_ouinstid	int(4)	Yes	Creation OU	No
modification_ou	fin_ouinstid	int(4)	Yes	Modification OU	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	bnkdef_acc_mst
Comment :	To store account information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
bank_ref_no	fin_banknumber	varchar(20)	No	Bank reference number	Yes
bank_acc_no	fin_banknumber	varchar(20)	No	Bank account number	Yes
serial_no	fin_number	int(4)	No	Serial number	Yes
timestamp	fin_int	int(4)	Yes	Timestmap	No
flag	fin_eflag	varchar(1)	Yes	Flag	No
currency_code	fin_currencycode	varchar(5)	Yes	Currency code	No
credit_limit	fin_amount	numeric(13)	Yes	Credit limit	No
draw_limit	fin_amount	numeric(13)	Yes	Draw limit	No
status	fin_status	varchar(25)	Yes	Status	No
effective_from	fin_datetime	datetime(8)	Yes	Effective from	No
effective_to	fin_datetime	datetime(8)	Yes	Effective to	No
creation_ou	fin_ouinstid	int(4)	Yes	Creation OU	No
modification_ou	fin_ouinstid	int(4)	Yes	Modification OU	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
eft_suppbanktype	fin_type	varchar(25)	Yes	eft supplier bank type	No

Table Name :	bnkdef_bnkusg_his
Comment :	To store history of bank usage information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
bank_ref_no	fin_banknumber	varchar(20)	No	Bank reference number	Yes
bank_acc_no	fin_banknumber	varchar(20)	No	Bank account number	Yes
bank_code	fin_bankcode	varchar(32)	No	Bank code	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance book id	Yes
action_time	fin_datetime	datetime(8)	No	Action time	Yes
component_id	fin_compid	varchar(10)	No	Component id	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
serial_no	fin_number	int(4)	Yes	Serial number	No
status	fin_status	varchar(25)	Yes	Status	No
creation_ou	fin_ouinstid	int(4)	Yes	Creation OU	No
modification_ou	fin_ouinstid	int(4)	Yes	Modification OU	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	bnkdef_bnkusg_sys
Comment :	To store system bank usage information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
bank_ref_no	fin_banknumber	varchar(20)	No	Bank reference number	Yes
bank_acc_no	fin_banknumber	varchar(20)	No	Bank account number	Yes
bank_code	fin_bankcode	varchar(32)	No	Bank code	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance book id	Yes
component_id	fin_compid	varchar(10)	No	Component id	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
serial_no	fin_number	int(4)	Yes	Serial number	No
status	fin_status	varchar(25)	Yes	Status	No
creation_ou	fin_ouinstid	int(4)	Yes	Creation OU	No
modification_ou	fin_ouinstid	int(4)	Yes	Modification OU	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	bnkdef_cash_his
Comment :	To store history of cash information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
cash_code	fin_cashcode	varchar(32)	No	Cash code	Yes
serial_no	fin_number	int(4)	No	Serial number	Yes
action_time	fin_datetime	datetime(8)	No	Action time	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
cash_desc	fin_cashdescription	varchar(40)	Yes	Cash description	No
currency_code	fin_currencycode	varchar(5)	Yes	Currency code	No
status	fin_status	varchar(25)	Yes	Status	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
effective_from	fin_datetime	datetime(8)	Yes	Effective from	No
effective_to	fin_datetime	datetime(8)	Yes	Effective to	No
creation_ou	fin_ouinstid	int(4)	Yes	Creation OU	No
modification_ou	fin_ouinstid	int(4)	Yes	Modification OU	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	bnkdef_cash_mst
Comment :	To store cash information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
cash_code	fin_cashcode	varchar(32)	No	Cash code	Yes
serial_no	fin_number	int(4)	No	Serial number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
cash_desc	fin_cashdescription	varchar(40)	Yes	Cash description	No
currency_code	fin_currencycode	varchar(5)	Yes	Currency code	No
status	fin_status	varchar(25)	Yes	Status	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
effective_from	fin_datetime	datetime(8)	Yes	Effective from	No
effective_to	fin_datetime	datetime(8)	Yes	Effective to	No
creation_ou	fin_ouinstid	int(4)	Yes	Creation OU	No
modification_ou	fin_ouinstid	int(4)	Yes	Modification OU	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	bnkdef_charges_his
Comment :	To store history of charges information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
bank_ref_no	fin_banknumber	varchar(20)	No	Bank reference number	Yes
bank_acc_no	fin_banknumber	varchar(20)	No	Bank account number	Yes
pay_mode	fin_paymode	varchar(25)	No	Pay mode	Yes
bank_charge_type	fin_option	varchar(20)	No	Bank charge type	Yes
tran_currency	fin_currencycode	varchar(5)	No	Transaction currency	Yes
effective_from	fin_datetime	datetime(8)	No	Effective from	Yes
serial_no	fin_number	int(4)	No	Serial number	Yes
action_time	fin_datetime	datetime(8)	No	Action time	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
charge_currency_code	fin_currencycode	varchar(5)	Yes	Charge currency code	No
effective_to	fin_datetime	datetime(8)	Yes	Effective to	No
amount_from	fin_amount	numeric(13)	Yes	Amount from	No
amount_to	fin_amount	numeric(13)	Yes	Amount to	No
inc_amount	fin_amount	numeric(13)	Yes	inc amount	No
flat_amount	fin_amount	numeric(13)	Yes	Flat amount	No
percentage	fin_percentage	numeric(9)	Yes	Percentage	No
min_charge	fin_amount	numeric(13)	Yes	Minimum charge	No
max_charge	fin_amount	numeric(13)	Yes	Maximum charge	No
misc_charge	fin_amount	numeric(13)	Yes	misc charge	No
creation_ou	fin_ouinstid	int(4)	Yes	Creation OU	No
modification_ou	fin_ouinstid	int(4)	Yes	Modification OU	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	bnkdef_charges_mst
Comment :	To store charge information detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
bank_ref_no	fin_banknumber	varchar(20)	No	Bank reference number	Yes
bank_acc_no	fin_banknumber	varchar(20)	No	Bank account number	Yes
pay_mode	fin_paymode	varchar(25)	No	Payment mode	Yes
bank_charge_type	fin_option	varchar(20)	No	Bank charge type	Yes
tran_currency	fin_currencycode	varchar(5)	No	Transaction type	Yes
effective_from	fin_datetime	datetime(8)	No	Effective from	Yes
serial_no	fin_number	int(4)	No	Serial number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
charge_currency_code	fin_currencycode	varchar(5)	Yes	Charge currency code	No
effective_to	fin_datetime	datetime(8)	Yes	Effective to	No
amount_from	fin_amount	numeric(13)	Yes	Amount from	No
amount_to	fin_amount	numeric(13)	Yes	Amount to	No
inc_amount	fin_amount	numeric(13)	Yes	inc amount	No
flat_amount	fin_amount	numeric(13)	Yes	Flat amount	No
percentage	fin_percentage	numeric(9)	Yes	Percentage	No
min_charge	fin_amount	numeric(13)	Yes	Minimum charge	No
max_charge	fin_amount	numeric(13)	Yes	Maximum charge	No
misc_charge	fin_amount	numeric(13)	Yes	misc charge	No
creation_ou	fin_ouinstid	int(4)	Yes	Creation OU	No
modification_ou	fin_ouinstid	int(4)	Yes	Modification OU	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	bnkdef_code_his
Comment :	To store history of code information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
bank_ref_no	fin_banknumber	varchar(20)	No	Bank reference number	Yes
bank_acc_no	fin_banknumber	varchar(20)	No	Bank account number	Yes
bank_code	fin_bankcode	varchar(32)	No	Bank code	Yes
serial_no	fin_number	int(4)	No	Serial number	Yes
action_time	fin_datetime	datetime(8)	No	Action time	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
flag	fin_eflag	varchar(1)	Yes	Flag	No
bank_desc	fin_bankdescription	varchar(40)	Yes	Bank description	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
credit_limit	fin_amount	numeric(13)	Yes	Credit limit	No
draw_limit	fin_amount	numeric(13)	Yes	Draw limit	No
od_amount	fin_amount	numeric(13)	Yes	Order base amount	No
intrate_eff_date	fin_datetime	datetime(8)	Yes	intrate effective date	No
intrate_od_bal	fin_finrate	numeric(9)	Yes	intrate order balance	No
intrate_cr_bal	fin_finrate	numeric(9)	Yes	intrate credit balance	No
intrate_dr_bal	fin_finrate	numeric(9)	Yes	intrate debit balance	No
status	fin_status	varchar(25)	Yes	Status	No
effective_from	fin_datetime	datetime(8)	Yes	Effective from	No
effective_to	fin_datetime	datetime(8)	Yes	Effective to	No
creation_ou	fin_ouinstid	int(4)	Yes	Creation OU	No
modification_ou	fin_ouinstid	int(4)	Yes	Modificetion OU	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	bnkdef_code_mst
Comment :	To store information of code details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
bank_ref_no	fin_banknumber	varchar(20)	No	Bank reference number	Yes
bank_acc_no	fin_banknumber	varchar(20)	No	Bank account number	Yes
bank_code	fin_bankname	varchar(40)	No	Bank code	Yes
serial_no	fin_number	int(4)	No	Serial number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
flag	fin_eflag	varchar(1)	Yes	Flag	No
bank_desc	fin_bankdescription	varchar(40)	Yes	Bank description	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
credit_limit	fin_amount	numeric(13)	Yes	Credit limit	No
draw_limit	fin_amount	numeric(13)	Yes	Draw limit	No
od_amount	fin_amount	numeric(13)	Yes	od amount	No
intrate_eff_date	fin_datetime	datetime(8)	Yes	intrate effective date	No
intrate_od_bal	fin_amount	numeric(13)	Yes	intrate order balance	No
intrate_cr_bal	fin_amount	numeric(13)	Yes	intrate credit balance	No
intrate_dr_bal	fin_amount	numeric(13)	Yes	intrate debit balance	No
status	fin_status	varchar(25)	Yes	Status	No
effective_from	fin_datetime	datetime(8)	Yes	Effective from	No
effective_to	fin_datetime	datetime(8)	Yes	Effective to	No
creation_ou	fin_ouinstid	int(4)	Yes	Creation OU	No
modification_ou	fin_ousiteid	varchar(40)	Yes	Modification OU	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	bnkdef_contact_dtl
Comment :	To store information of contact detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
bank_ref_no	fin_bankname	varchar(40)	No	Bank reference number	Yes
serial_no	fin_number	int(4)	No	Serial number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
flag	fin_eflag	varchar(1)	Yes	Flag	No
cnt_person	fin_contact	varchar(40)	Yes	Contact person	No
cnt_designation	fin_contact	varchar(40)	Yes	Contact designation	No
cnt_department	fin_contact	varchar(40)	Yes	Contact department	No
phone_no	fin_communicationid	varchar(30)	Yes	Phone number	No
email_id	fin_email	varchar(60)	Yes	Email id	No
creation_ou	fin_ouinstid	int(4)	Yes	Creation OU	No
modification_ou	fin_ouinstid	int(4)	Yes	Modification OU	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	bnkdef_cshusg_his
Comment :	To store history of cash usage information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
cash_code	fin_cashcode	varchar(32)	No	Cash code	Yes
company_code	fin_companycode	varchar(10)	No	Company code	Yes
fb_id	fin_financebookid	varchar(20)	No	Financebook	Yes
action_time	fin_datetime	datetime(8)	No	Action time	Yes
component_id	fin_compid	varchar(10)	No	Component id	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
serial_no	fin_number	int(4)	Yes	Serial number	No
status	fin_status	varchar(25)	Yes	Status	No
creation_ou	fin_ouinstid	int(4)	Yes	Creation OU	No
modification_ou	fin_ouinstid	int(4)	Yes	Modification OU	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	bnkdef_cshusg_sys
Comment :	To store system cash usage information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
cash_code	fin_cashcode	varchar(32)	No	Cash code	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance book id	Yes
component_id	fin_compid	varchar(10)	No	Component id	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
serial_no	fin_number	int(4)	Yes	Serial number	No
status	fin_status	varchar(25)	Yes	Status	No
creation_ou	fin_ouinstid	int(4)	Yes	Creation OU	No
modification_ou	fin_ouinstid	int(4)	Yes	Modification OU	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	bnkdef_filetransfer_mst
Comment :	To store file transfer information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
bank_ref_no	fin_banknumber	varchar(20)	No	Bank reference number	Yes
bank_acc_no	fin_banknumber	varchar(20)	No	Bank account number	Yes
serial_no	fin_number	int(4)	No	Serial number	Yes
dta_sad_id	fin_identificationnumber	varchar(10)	No	dta_sad_id	Yes
pay_mode	fin_paymode	varchar(25)	No	Payment mode	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
flag	fin_eflag	varchar(1)	Yes	Flag	No
status	fin_status	varchar(25)	Yes	Status	No
esr_part_id	fin_identificationnumber	varchar(10)	Yes	esr part id	No
esr_ppart_id	fin_identificationnumber	varchar(10)	Yes	esr ppart id	No
digit_no	fin_number	int(4)	Yes	Digit number	No
lsv_id	fin_id	varchar(6)	Yes	lsv id	No
remarks	fin_remarks	varchar(100)	Yes	Remarks	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_Datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_Datetime	datetime(8)	Yes	Modified date	No

Table Name :	bnkdef_notes_his
Comment :	To store history of notes information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
bank_acc_no	fin_banknumber	varchar(20)	No	Bank account number	Yes
action_time	fin_datetime	datetime(8)	No	Action time	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
notes	fin_text2500	varchar(2500)	Yes	Notes	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	bnkdef_notes_mst
Comment :	To store notes information detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
bank_acc_no	fin_banknumber	varchar(20)	No	Bank account number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
notes	fin_text2500	varchar(2500)	Yes	Notes	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_Datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_Datetime	datetime(8)	Yes	Modified date	No

Table Name :	bnkdef_ref_mst
Comment :	To store reference information detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
bank_ref_no	fin_bankname	varchar(40)	No	Bank reference number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
bank_name	fin_bankname	varchar(40)	Yes	Bank name	No
bank_type	fin_type	varchar(25)	Yes	Bank type	No
address1	fin_txt255	varchar(255)	Yes	Address 1	No
address2	fin_txt255	varchar(255)	Yes	Address 2	No
address3	fin_txt255	varchar(255)	Yes	Address 3	No
city	fin_city	varchar(40)	Yes	City	No
state	fin_state	varchar(40)	Yes	State	No
country	fin_country	varchar(40)	Yes	Country	No
clearing_no	fin_banknumber	varchar(20)	Yes	Clearing number	No
swift_no	fin_banknumber	varchar(20)	Yes	Swift number	No
phone_no	fin_communicationid	varchar(30)	Yes	Phone number	No
telex	fin_communicationid	varchar(30)	Yes	Telex	No
mail_stop	fin_mailstop	varchar(20)	Yes	Mail shop	No
zip_code	fin_zip	varchar(20)	Yes	Zip code	No
fax	fin_fax	varchar(40)	Yes	Fax	No
email_id	fin_email	varchar(60)	Yes	Email id	No
status	fin_status	varchar(25)	Yes	Status	No
creation_ou	fin_ouinstid	int(4)	Yes	Creation OU	No
modification_ou	fin_ouinstid	int(4)	Yes	Modification oU	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_Datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_Datetime	datetime(8)	Yes	Modified date	No