Database Schema for

Data Dictionary -- Customer Receipt

Srl. No.	Table Name	Comment
1	rpt_acct_info_dtl	To store information of account information detail
2	rpt_apportioned_tcd_dtl	To store information of report apportioned tcd detail
3	rpt_elec_receipt_info	To store information of electronic information detail
4	Rpt_GRLineStatus_OptSetting	To store information of group line status option setting
5	rpt_notes_dtl	To store information of notes detail
6	RPT_Pers_parameter_details	To store information of parameter detail
7	rpt_receipt_dtl	To store information of receipt detail
8	rpt_receipt_hdr	To store information of receipt header
9	rpt_receipt_tcd_dtl	To store information of receipt tcd detail
10	Rpt_Report_Specific_data	To store information of report specific data


Table Name :	rpt_acct_info_dtl
Comment :	To store information of account information detail


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	No	Organization unit id	Yes
tran_no	fin_transactionnumber	varchar(18)	No	Transaction number	Yes
fb_id	fin_buid	varchar(20)	No	Finance book id	Yes
account_code	fin_accountcode	varchar(32)	No	Account code	Yes
tran_type	fin_transactiontype	varchar(40)	No	Transaction type	Yes
drcr_flag	fin_drcridentifier	varchar(6)	No	Debit credit flag	Yes
posting_line_no	fin_lineno	int(4)	No	Posting line number	Yes
fin_post_date	fin_datetime	datetime(8)	Yes	Finance post date	No
currency	fin_currency	varchar(5)	Yes	Currency	No
cost_center	fin_costcentercode	varchar(10)	Yes	Cost center	No
tran_amount	fin_amount	numeric(13)	Yes	Transaction amount	No
analysis_code	fin_analysiscode	varchar(5)	Yes	Analysis code	No
subanalysis_code	fin_subanalysiscode	varchar(5)	Yes	Subanalysis code	No
basecur_erate	fin_exchangerate	numeric(9)	Yes	Base currency exchange rate	No
base_amount	fin_amount	numeric(13)	Yes	Base amount	No
pbcur_erate	fin_exchangerate	numeric(9)	Yes	Parallel base currency exchange rate	No
par_base_amt	fin_amount	numeric(13)	Yes	Parallel base amount	No
fin_post_status	fin_status	varchar(25)	Yes	Finance post status	No
batch_id	fin_guid	varchar(40)	Yes	Batch id	No
account_type	fin_accounttype	varchar(15)	Yes	Account type	No
flag	fin_flag	varchar(25)	Yes	Flag	No
company_id	fin_companycode	varchar(10)	Yes	Company id	No
component_id	fin_component	varchar(16)	Yes	Component id	No
bu_id	fin_buid	varchar(20)	Yes	Business unit id	No
tran_date	fin_datetime	datetime(8)	Yes	Transaction	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
replication_key	udd_bigint	bigint(8)	No	replication key	No


Table Name :	rpt_apportioned_tcd_dtl
Comment :	To store information of report apportioned tcd detail


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
tran_ou	fin_ouinstid	int(4)	No	Transaction OU	Yes
tran_no	fin_documentnumber	varchar(18)	No	Transaction number	Yes
tran_type	fin_cmntrantype	varchar(10)	No	Transaction type	Yes
tran_currency	fin_currency	varchar(5)	Yes	Transaction currency	No
line_no	fin_lineno	int(4)	Yes	Line number	No
applied_on	fin_designparamcode	varchar(5)	Yes	Applied on	No
tcd_version	fin_macseqno	int(4)	Yes	TCD version	No
timestamp	fin_int	int(4)	Yes	Timestamp	No
item_type	fin_abbreviation	varchar(3)	Yes	Item type	No
tcd_level	fin_chkflag	varchar(1)	Yes	TCD level	No
tax_key	fin_itemcode	varchar(40)	Yes	Tax key	No
tcd_code	fin_itemcode	varchar(40)	Yes	TCD code	No
tcd_var_code	fin_itemcode	varchar(40)	Yes	TCD variance code	No
tcd_rate	fin_amount	numeric(13)	Yes	TCD rate	No
taxable_amount	fin_amount	numeric(13)	Yes	Taxable amount	No
tcd_currency	fin_currency	varchar(5)	Yes	TCD currency	No
tcd_amount	fin_amount	numeric(13)	Yes	TCD amount	No
tcd_amount_rptcurr	fin_amount	numeric(13)	Yes	TCD amount report currency	No
base_amount	fin_amount	numeric(13)	Yes	Base amount	No
cost_center	fin_costcentercode	varchar(10)	Yes	Cost center	No
analysis_code	fin_analysiscode	varchar(5)	Yes	Analysis code	No
subanalysis_code	fin_subanalysiscode	varchar(5)	Yes	Subanalysis code	No
remarks	fin_txt255	varchar(255)	Yes	Remarks	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_date	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_date	datetime(8)	Yes	Modified date	No
rowno	fin_rowno	int(4)	Yes	Row number	No
wht_currency	fin_currency	varchar(5)	Yes	What currency	No


Table Name :	rpt_elec_receipt_info
Comment :	To store information of electronic information detail


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ou	varchar(256)	No	Organization unit id	Yes
receipt_no	fin_documentno	varchar(40)	No	Receipt number	Yes
esr_part_id	fin_participationid	varchar(30)	Yes	esr part id	No
esr_ref_no	fin_documentnumber	varchar(18)	Yes	esr reference number	No
lsv_contract_id	fin_company	varchar(15)	Yes	lsv contract id	No
lsv_contract_ref	fin_documentnumber	varchar(18)	Yes	lsv contract reference	No
cust_bank_acct	fin_bankcode	varchar(32)	Yes	Customer bank account	No
cust_bank_id	fin_bankcode	varchar(32)	Yes	Customer bank id	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 :	Rpt_GRLineStatus_OptSetting
Comment :	To store information of group line status option setting


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SeqNo	udd_seqno	int(4)	No	Sequence number	Yes
OUinstName	udd_char	Char(8000)	No	OU instance name	Yes
OUInstDesc	udd_varchar	Varchar(8000)	No	OU instance description	No
EAI_Flag	udd_flag	varchar(25)	Yes	EAI flag	No
Status_Flag	udd_flag	varchar(25)	Yes	Status flag	No


Table Name :	rpt_notes_dtl
Comment :	To store information of notes detail


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ou	varchar(256)	No	Organization unit id	Yes
receipt_no	fin_documentno	varchar(40)	No	Receipt number	Yes
notes_for	fin_paramcode	varchar(30)	No	Notes for	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
note_level	fin_paramcode	varchar(30)	Yes	Note level	No
std_notesid	fin_documentno	varchar(40)	Yes	Standard notes id	No
std_notesid_desc	fin_description	varchar(100)	Yes	Standard notes id description	No
notes	fin_notes	varchar(2000)	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 :	RPT_Pers_parameter_details
Comment :	To store information of parameter detail


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
COMPONENTNAME	udd_ctxt_component	varchar(20)	Yes	Component name	No
PARAMCATEGORY	udd_description	varchar(40)	Yes	Parameter category	No
PARAMTYPE	udd_description	varchar(40)	Yes	Parameter type	No
PARAMCODE	udd_designparamcode	varchar(5)	Yes	Parameter code	No
PARAMDESC	udd_txt255	varchar(255)	Yes	Parameter description	No
LANGID	udd_ctxt_language	int(4)	Yes	Language id	No
CREATIONDATE	udd_date1	varchar(15)	Yes	Creation date	No
SORTBY	udd_sortby	numeric(9)	Yes	Sort by	No
REPLICATION_KEY	udd_bigint	bigint(8)	No	REPLICATION_KEY	Yes


Table Name :	rpt_receipt_dtl
Comment :	To store information of receipt detail


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ou	varchar(256)	No	Organization unit id	Yes
receipt_no	fin_documentno	varchar(40)	No	Receipt number	Yes
dr_doc_no	fin_documentno	varchar(40)	No	Debit document number	Yes
dr_doc_ou	fin_ou	varchar(256)	No	Debit document OU	Yes
term_no	fin_documentno	varchar(40)	No	Term number	Yes
dr_tran_type	fin_doctype	varchar(40)	No	Debit transaction type	Yes
dr_doc_type	fin_documenttype	varchar(40)	Yes	Debit document type	No
au_due_date	fin_datetime	datetime(8)	Yes	Author due date	No
au_dr_doc_cur	fin_currencycode	varchar(5)	Yes	Author debit document currency	No
au_dr_doc_date	fin_datetime	datetime(8)	Yes	Author debit document date	No
au_dr_doc_amount	fin_amount	numeric(13)	Yes	Author debit document amount	No
au_exchange_rate	fin_exchangerate	numeric(9)	Yes	Author exchange rate	No
au_outstanding_amt	fin_amount	numeric(13)	Yes	Author outstanding amount	No
recd_amount	fin_amount	numeric(13)	Yes	Received amount	No
batch_id	fin_guid	varchar(40)	Yes	Batch id	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
ftk_invoice_no	fin_documentno	varchar(40)	Yes	Invoice number	No
taxkey	udd_description	varchar(40)	No	Tax Key	No
whtamount	fin_amount	numeric(13)	No	With holding Amount	No
netrecamount	fin_amount	numeric(13)	No	Net Received amount	No


Table Name :	rpt_receipt_hdr
Comment :	To store information of receipt header


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ou	varchar(256)	No	Organization unit id	Yes
receipt_no	fin_documentno	varchar(40)	No	Receipt number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
receipt_date	fin_datetime	datetime(8)	Yes	Receipt date	No
receipt_category	fin_category	varchar(15)	Yes	Receipt category	No
receipt_status	fin_status	varchar(25)	Yes	Receipt status	No
fb_id	fin_buid	varchar(20)	Yes	Finance book id	No
notype_no	fin_notypeno	varchar(10)	Yes	notype_no	No
cust_area	fin_notetypeen	varchar(25)	Yes	Customer area	No
cust_code	fin_customercode	varchar(16)	Yes	Customer code	No
receipt_route	fin_route	varchar(10)	Yes	Receipt route	No
receipt_mode	fin_documentno	varchar(40)	Yes	Receipt mode	No
adjustment_type	fin_adjustmenttype	varchar(10)	Yes	Adjustment type	No
currency	fin_currencycode	varchar(5)	Yes	Currency	No
exchange_rate	fin_exchangerate	numeric(9)	Yes	Exchange rate	No
receipt_amount	fin_amount	numeric(13)	Yes	Receipt amount	No
bank_cash_code	fin_bankcashcode	varchar(32)	Yes	Bank cash code	No
collector	fin_custname	varchar(40)	Yes	Collector	No
remitter	fin_name	varchar(60)	Yes	Remitter	No
comments	fin_comments	varchar(256)	Yes	Comments	No
instr_no	fin_documentno	varchar(40)	Yes	Instrument number	No
micr_no	fin_documentno	varchar(40)	Yes	micr_no	No
instr_amount	fin_amount	numeric(13)	Yes	Instrument amount	No
instr_date	fin_datetime	datetime(8)	Yes	Instrument date	No
remitting_bank	fin_bankid	varchar(20)	Yes	Remitting bank	No
charges	fin_amount	numeric(13)	Yes	Charges	No
cost_center	fin_costcentercode	varchar(10)	Yes	Cost center	No
analysis_code	fin_analysiscode	varchar(5)	Yes	Analysis code	No
subanalysis_code	fin_subanalysiscode	varchar(5)	Yes	Subanalysis code	No
card_no	fin_documentno	varchar(40)	Yes	Card number	No
card_auth_no	fin_documentno	varchar(40)	Yes	Card author number	No
issuer	fin_bankid	varchar(20)	Yes	Issuer	No
card_val_month	fin_finmonth	varchar(10)	Yes	Card value month	No
card_val_year	fin_financeyear	varchar(15)	Yes	Card value year	No
unapplied_amount	fin_amount	numeric(13)	Yes	Unapplied amount	No
reason_code	fin_documentno	varchar(40)	Yes	Reason code	No
reversal_date	fin_datetime	datetime(8)	Yes	Reversal date	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
flag	fin_flag	varchar(25)	Yes	Flag	No
par_base_amount	fin_amount	numeric(13)	Yes	Parallel base amount	No
par_exchange_rate	fin_exchangerate	numeric(9)	Yes	Parallel exchange rate	No
tran_type	fin_type	varchar(25)	Yes	Transaction type	No
ref_doc_no	fin_documentno	varchar(40)	Yes	Reference document number	No
batch_id	fin_guid	varchar(40)	Yes	Batch id	No
forward_cover	fin_desc20	varchar(20)	Yes	Forward coverage	No
Fw_cov_flag	fin_flag2	varchar(25)	Yes	Fiorward coverage flag	No
Fw_cov_rate	fin_exchangerate	numeric(9)	Yes	Forward coverage rate	No
Tax_key	fin_itemcode	varchar(40)	Yes	Tax key	No
valuebfrtax	fin_amount	numeric(13)	Yes	Value before tax	No
withholdingtax	fin_amount	numeric(13)	Yes	With holding tax	No
valuenetax	fin_amount	numeric(13)	Yes	Value net tax	No


Table Name :	rpt_receipt_tcd_dtl
Comment :	To store information of receipt tcd detail


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
tran_ou	fin_ouinstid	int(4)	No	Transaction OU	Yes
tran_no	fin_documentnumber	varchar(18)	No	Transaction number	Yes
tran_type	fin_cmntrantype	varchar(10)	No	Transaction type	Yes
tran_currency	fin_currency	varchar(5)	Yes	Transaction currency	No
line_no	fin_lineno	int(4)	Yes	Line number	No
applied_on	fin_designparamcode	varchar(5)	Yes	Applied on	No
tcd_version	fin_macseqno	int(4)	Yes	TCD version	No
timestamp	fin_int	int(4)	Yes	Timestamp	No
item_type	fin_abbreviation	varchar(3)	Yes	Item type	No
tcd_level	fin_chkflag	varchar(1)	Yes	TCD level	No
tax_key	fin_itemcode	varchar(40)	Yes	Tax key	No
tcd_code	fin_itemcode	varchar(40)	Yes	TCD code	No
tcd_var_code	fin_itemcode	varchar(40)	Yes	TCD variance code	No
tcd_rate	fin_amount	numeric(13)	Yes	TCD rate	No
taxable_amount	fin_amount	numeric(13)	Yes	Taxable amount	No
tcd_currency	fin_currency	varchar(5)	Yes	TCD currency	No
tcd_amount	fin_amount	numeric(13)	Yes	TCD amount	No
tcd_amount_rptcurr	fin_amount	numeric(13)	Yes	TCD amount report currency	No
base_amount	fin_amount	numeric(13)	Yes	Base amount	No
cost_center	fin_costcentercode	varchar(10)	Yes	Cost center	No
analysis_code	fin_analysiscode	varchar(5)	Yes	Analysis code	No
subanalysis_code	fin_subanalysiscode	varchar(5)	Yes	Subanalusis code	No
remarks	fin_txt255	varchar(255)	Yes	Remarks	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_date	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_date	datetime(8)	Yes	Modified date	No
rowno	fin_rowno	int(4)	Yes	Row number	No
wht_currency	fin_currency	varchar(5)	Yes	What currency	No
tcd_exchrate	Fin_exchangerate	numeric(9)	Yes	Tcd Exchage rate	No


Table Name :	Rpt_Report_Specific_data
Comment :	To store information of report specific data


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
Rpt_RCNID	udd_txt20	varchar(20)	Yes	RCN id	No
Rpt_RCNName	udd_txt150	varchar(150)	Yes	RCN name	No
Rpt_Dataitem	udd_txt150	varchar(150)	Yes	Data item	No
rpt_SeqNo	udd_seqno	int(4)	Yes	Sequence number	No
Rpt_DataDesc	udd_txt6000	varchar(4000)	Yes	Data description	No
Rpt_Remarks	udd_txt2000	varchar(2000)	Yes	Remarks	No
REPLICATION_KEY	udd_bigint	bigint(8)	No	REPLICATION_KEY	Yes