Data Dictionary -- Bank Reconciliation

Srl. No.	Table Name	Comment
1	abr_bank_reconcile_dtl	Stores the Detail fof Bank Reconcile
2	abr_bank_reconcile_his	Stores the History of Bank Reconcile
3	abr_bank_statement_dtl	Stores the Detail of Bank Statement
4	abr_bank_statement_hdr	Stores the Header Information of Bank Statement
5	abr_reconcile_hdr	Stores the Header Information of Reconcile
6	abr_reconcile_trackData	Stores the Information of Reconcile Track Data

Table Name :	abr_bank_reconcile_dtl
Comment :	Stores the Detail fof Bank Reconcile

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
bank_code	fin_banknumber	varchar(20)	No	Bank code	Yes
serial_no	fin_number	int(4)	No	Serial number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
ref_no	fin_documenttype	varchar(40)	Yes	Reference number	No
tran_type	fin_transactiontype	varchar(40)	Yes	Transaction type	No
tran_date	fin_datetime	datetime(8)	Yes	Transaction date	No
tran_amount	fin_amount	numeric(13)	Yes	Transaction amount	No
tran_remarks	fin_text255	varchar(255)	Yes	Transaction remarks	No
document_no	fin_documenttype	varchar(40)	Yes	Document number	No
prefix	fin_prefix	varchar(6)	Yes	Prefix	No
check_no	fin_checknumber	varchar(30)	Yes	Check number	No
comp_reference	fin_checknumber	varchar(30)	Yes	Comp reference	No
ou_id	fin_ouinstid	int(4)	Yes	Organization unit id	No
recon_status	fin_status	varchar(25)	Yes	Reconsile status	No
recon_remarks	fin_comments	varchar(256)	Yes	Reconsil remarks	No
recon_by	fin_ctxt_user	varchar(30)	Yes	Reconsile by	No
recon_date	fin_datetime	datetime(8)	Yes	Reconsile date	No
confirm_date	fin_datetime	datetime(8)	Yes	Confirm date	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 :	abr_bank_reconcile_his
Comment :	Stores the History of Bank Reconcile

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
bank_code	fin_banknumber	varchar(20)	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)	No	Timestamp	No
ref_no	fin_documenttype	varchar(40)	Yes	Reference number	No
tran_type	fin_transactiontype	varchar(40)	Yes	Transaction type	No
tran_date	fin_datetime	datetime(8)	Yes	Transaction date	No
tran_amount	fin_amount	numeric(13)	Yes	Transaction amount	No
tran_remarks	fin_text255	varchar(255)	Yes	Transaction remarks	No
document_no	fin_documenttype	varchar(40)	Yes	Document number	No
prefix	fin_prefix	varchar(6)	Yes	Prefix	No
check_no	fin_checknumber	varchar(30)	Yes	Check number	No
comp_reference	fin_checknumber	varchar(30)	Yes	comp reference	No
ou_id	fin_ouinstid	int(4)	Yes	Organization unit id	No
recon_status	fin_status	varchar(25)	Yes	Reconsile status	No
recon_remarks	fin_comments	varchar(256)	Yes	Reconsil remarks	No
recon_by	fin_ctxt_user	varchar(30)	Yes	Reconsile by	No
recon_date	fin_datetime	datetime(8)	Yes	Reconsile date	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 :	abr_bank_statement_dtl
Comment :	Stores the Detail of Bank Statement

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
bank_code	fin_banknumber	varchar(20)	No	Bank code	Yes
stmt_no	fin_documenttype	varchar(40)	No	Statement number	Yes
serial_no	fin_number	int(4)	No	Serial number	Yes
timestamp	fin_int	int(4)	No	Timestamp	No
ou_id	fin_ouinstid	int(4)	Yes	Organization unit id	No
ref_no	fin_documenttype	varchar(40)	Yes	Reference number	No
tran_type	fin_transactiontype	varchar(40)	Yes	Transaction type	No
tran_date	fin_datetime	datetime(8)	Yes	Transaction date	No
check_no	fin_checknumber	varchar(30)	Yes	Check number	No
tran_amount	fin_amount	numeric(13)	Yes	Transaction amount	No
tran_remarks	fin_text255	varchar(255)	Yes	Transaction remarks	No
prefix	fin_prefix	varchar(6)	Yes	Prefix	No
comp_reference	fin_checknumber	varchar(30)	Yes	comp reference	No
payinslip_no	fin_documentnumber	varchar(18)	Yes	Payin slip number	No
recon_status	fin_status	varchar(25)	Yes	Reconsile status	No
recon_by	fin_ctxt_user	varchar(30)	Yes	Reconsile by	No
recon_date	fin_datetime	datetime(8)	Yes	Reconsile date	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 :	abr_bank_statement_hdr
Comment :	Stores the Header Information of Bank Statement

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
bank_code	fin_banknumber	varchar(20)	No	Bank code	Yes
stmt_no	fin_documenttype	varchar(40)	No	Statement number	Yes
timestamp	fin_int	int(4)	No	Timestamp	No
ou_id	fin_ouinstid	int(4)	Yes	Organization unit id	No
stmt_start_date	fin_datetime	datetime(8)	Yes	Statement start date	No
stmt_end_date	fin_datetime	datetime(8)	Yes	Statement end date	No
open_bal	fin_amount	numeric(13)	Yes	Open balance	No
openbal_drcr	fin_drcridentifier	varchar(6)	Yes	Open balance debit credit	No
close_bal	fin_amount	numeric(13)	Yes	Close balance	No
closebal_drcr	fin_drcridentifier	varchar(6)	Yes	Close balance debit credit	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 :	abr_reconcile_hdr
Comment :	Stores the Header Information of Reconcile

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
confirm_date	fin_datetime	datetime(8)	No	Confirm date	Yes
timestamp	fin_int	int(4)	No	Timestamp	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 :	abr_reconcile_trackData
Comment :	Stores the Information of Reconcile Track Data

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	No
bank_acc_no	fin_banknumber	varchar(20)	No	Bank account number	No
bank_code	fin_banknumber	varchar(20)	No	Bank code	No
serial_no	fin_number	int(4)	No	Serial number	No
timestamp	fin_int	int(4)	No	Timestamp	No
guid	fin_guid	varchar(40)	Yes	Guid	No
ref_no	fin_documenttype	varchar(40)	Yes	Reference number	No
tran_type	fin_transactiontype	varchar(40)	Yes	Transaction type	No
tran_date	fin_datetime	datetime(8)	Yes	Transaction date	No
tran_amount	fin_amount	numeric(13)	Yes	Transaction amount	No
tran_remarks	fin_text255	varchar(255)	Yes	Transaction remarks	No
document_no	fin_documenttype	varchar(40)	Yes	Document number	No
prefix	fin_prefix	varchar(6)	Yes	Prefix	No
check_no	fin_checknumber	varchar(30)	Yes	Check number	No
comp_reference	fin_checknumber	varchar(30)	Yes	comp reference	No
ou_id	fin_ouinstid	int(4)	Yes	Organization unit id	No
recon_status	fin_status	varchar(25)	Yes	Reconsile status	No
recon_remarks	fin_comments	varchar(256)	Yes	Reconsile remarks	No
recon_by	fin_ctxt_user	varchar(30)	Yes	Reconsile by	No
recon_date	fin_datetime	datetime(8)	Yes	Reconsile date	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
stmt_no	fin_documenttype	varchar(40)	Yes	Statement number	No
BS_flag	fin_designparamcode	varchar(5)	Yes	BS flag	No
REPLICATION_KEY	bigint	Bigint(8)	No	REPLICATION KEY	Yes