Data Dictionary -- Realize Receipt

Srl. No.	Table Name	Comment
1	rr_acct_info_dtl	To store acount information detial
2	RR_DTcdAP_DocTcd_Apportioned	To store information of document tcd apportioned detail
3	RR_PAYINSLIP_DTL	To store information of payinslip detail
4	rr_payinslip_hdr	To store information of payinslip header

Table Name :	rr_acct_info_dtl
Comment :	To store acount information detial

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	No	Organization unit id	Yes
tran_no	fin_documentno	varchar(40)	No	Transaction number	Yes
tran_type	fin_transactiontype	varchar(40)	No	Transaction type	Yes
account_code	fin_accountcode	varchar(32)	No	Account code	Yes
drcr_flag	fin_drcridentifier	varchar(6)	No	Debit credit flag	Yes
bank_code	fin_bankcode	varchar(32)	No	Bank code	Yes
posting_line_no	fin_lineno	int(4)	No	Posting line number	No
timestamp	fin_int	int(4)	Yes	Timestamp	No
fin_post_date	fin_datetime	datetime(8)	Yes	Finance post date	No
currency_code	fin_currencycode	varchar(5)	Yes	Currency code	No
cost_center	fin_costcentercode	varchar(10)	Yes	Cost center	No
tran_amount	fin_amount	numeric(13)	Yes	Transaction amount	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
analysis_code	fin_analysiscode	varchar(5)	Yes	Analysis code	No
subanalysis_code	fin_subanalysiscode	varchar(5)	Yes	Subanalysis code	No
basecur_erate	fin_amount	numeric(13)	Yes	Base currency exchange rate	No
base_amount	fin_amount	numeric(13)	Yes	Base amount	No
pbcur_erate	fin_amount	numeric(13)	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
guid	fin_guid	varchar(40)	Yes	Guid	No
company_code	fin_companycode	varchar(10)	Yes	Company code	No
account_type	fin_accounttype	varchar(15)	Yes	Account tyoe	No
bu_id	fin_buid	varchar(20)	Yes	Business id	No
ref_no	fin_docuemntno	varchar(18)	Yes	Reference number	No
dep_bank	fin_bankcode	varchar(32)	Yes	Depreciation bank	No

Table Name :	RR_DTcdAP_DocTcd_Apportioned
Comment :	To store information of document tcd apportioned detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
DTcdAP_RR_No	udd_documentno	varchar(40)	No	DTcdAP_RR_No	Yes
DTcdAP_RR_Ou	udd_ctxt_ouinstance	int(4)	No	DTcdAP_RR_Ou	Yes
DTcdAP_DTcdlineid	udd_seqno	int(4)	No	DTcdAP_DTcdlineid	Yes
DTcdAP_PartlineId	udd_seqno	int(4)	No	DTcdAP_PartlineId	Yes
DTcdAP_TCD_CODE	udd_documentno	varchar(40)	Yes	DTcdAP_TCD_CODE	No
DTcdAP_TCD_VARIANT	udd_text255	varchar(255)	Yes	DTcdAP_TCD_VARIANT	No
DTCDAP_TCDAMOUNT_TRN	udd_amount	numeric(13)	Yes	DTCDAP_TCDAMOUNT_TRN	No
DTCDAP_APPORTVAL_TRN	udd_amount	numeric(13)	Yes	DTCDAP_APPORTVAL_TRN	No
DTcdAP_Accrule	udd_designparamcode	varchar(5)	Yes	DTcdAP_Accrule	No
RRPDT_ACC_POST_FLAG	udd_flag	varchar(25)	Yes	RRPDT_ACC_POST_FLAG	No
rrpdt_currency	udd_currency	varchar(20)	Yes	rrpdt_currency	No
DTCDAP_DBACC_FLAG	udd_designparamcode	varchar(5)	Yes	DTCDAP_DBACC_FLAG	No
DTCDAP_EXCH_RATE	fin_exchangerate	numeric(9)	Yes	DTCDAP_EXCH_RATE	No
DTCDAP_APPORTVAL_BASE	udd_amount	numeric(13)	Yes	DTCDAP_APPORTVAL_BASE	No

Table Name :	RR_PAYINSLIP_DTL
Comment :	To store information of payinslip detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
OU_ID	fin_decimal	decimal(17)	No	Organization unit id	Yes
PAYINSLIP_NO	fin_varchar	varchar(800)	No	Payinslip number	Yes
DEPOSITING_BANK	fin_varchar	varchar(800)	No	Depositing bank	Yes
INSTR_NO	fin_varchar	varchar(800)	No	Instrument number	Yes
INSTR_DATE	fin_datetime	datetime(8)	Yes	Instrument date	No
INSTR_AMOUNT	fin_amount	numeric(13)	Yes	Instrument amount	No
REMITTER	fin_varchar	varchar(800)	Yes	Remitter	No
REMITTING_BANK	fin_varchar	varchar(800)	No	Remitting bank	Yes
ADDRESS	fin_varchar	varchar(800)	Yes	Address	No
RECEIPT_NO	fin_varchar	varchar(800)	Yes	Receipt number	No
CURRENCY	fin_varchar	varchar(800)	Yes	Currency	No
RECEIPT_TYPE	fin_varchar	varchar(800)	Yes	Receipt type	No
PARENTKEY	fin_varchar	varchar(800)	Yes	Parent key	No
CURRENTKEY	fin_varchar	varchar(800)	Yes	Current key	No
COLLECTER_CODE	fin_varchar	varchar(800)	Yes	Collecter code	No
INSTR_STATUS	fin_varchar	varchar(800)	Yes	Instrument status	No
REASON_CODE	fin_varchar	varchar(800)	Yes	Reason code	No
REMARKS	fin_varchar	varchar(800)	Yes	Remarks	No
DEP_BANK_CHANGED	fin_varchar	varchar(800)	Yes	Depreciation bank changed	No
BANK_CODE	fin_varchar	varchar(800)	Yes	Bank code	No
AU_FB_ID	fin_varchar	varchar(800)	Yes	Author finance book id	No
BATCH_ID	fin_varchar	varchar(800)	Yes	Batch id	No

Table Name :	rr_payinslip_hdr
Comment :	To store information of payinslip header

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	No	Organization unit id	Yes
payinslip_no	fin_documentno	varchar(40)	No	Payinslip number	Yes
depositing_bank	fin_bankcode	varchar(32)	No	Depositing bank	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
payinslip_date	fin_datetime	datetime(8)	Yes	Payinslip date	No
status	fin_status	varchar(25)	Yes	Status	No
parentkey	fin_guid	varchar(40)	No	Parent key	Yes
fb_id	fin_financebookid	varchar(20)	Yes	Finance book 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
batch_id	fin_guid	varchar(40)	Yes	Batch id	No