Data Dictionary -- Release Payment

Srl. No.	Table Name	Comment
1	edk_check_prnt_bnk_dtl	To Store Check Printed Banking Detail
2	edk_check_prnt_fb_dtl	To store Check Printed Finance Book Detail
3	rp_autorun_det	To store information of auto run details
4	rp_bnkcharges_dtl	To Store Information Of Bank Charges Detail
5	rp_checkseries_dtl	To store information of checkseries detail
6	rp_checkseries_hdr	To store information of checkseries header
7	rp_denomination_mst	To store information of denomination detail
8	rp_eft_details	To store information of effective details
9	rp_eft_file_structure	To store information of effective fine structure
10	rp_eft_formatted_data	To store information of effective formatted data
11	rp_eft_metadata	To store information of effective metadata
12	RP_EFT_VchrDtl_PyRf	To store information of voucher detail payment reference
13	rp_guid_dtl	To store information of guid detail
14	rp_intg_eft_payment_dtl	To Store Integration Effective payment Detail
15	rp_postings_dtl	To store information of posting detail
16	rp_reprint_dtl	To store information of reprint detail
17	rp_voucher_dtl	To store information of voucher detail
18	rp_voucher_hdr	To store information of voucher header

Table Name :	edk_check_prnt_bnk_dtl
Comment :	To Store Check Printed Banking Detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
bank_ref_no	fin_banknumber	varchar(20)	Yes	Bank Reference Number	No
frac_rout_no	fin_banknumber	varchar(20)	Yes	Route Number	No
onus_no	fin_banknumber	varchar(20)	Yes	onus_no	No
transit_no	fin_banknumber	varchar(20)	Yes	Transist Numbere	No
checknoprefix	approvalstatus	varchar(25)	Yes	Check Number Prefix	No
checknosuffix	approvalstatus	varchar(25)	Yes	Check Number suffix	No
CreatedBy	udd_ctxt_user	varchar(30)	Yes	Created By	No
CreatedDate	datetime	Datetime(8)	Yes	Created Date	No
ModifiedBy	udd_ctxt_user	varchar(30)	Yes	Modified By	No
ModifiedDate	datetime	Datetime(8)	Yes	Modified Date	No
TimeStamp	udd_timestamp	int(4)	Yes	TimeStamp	No
replication_key	uniqueidentifier	Varchar(160)	No	Replication Key	Yes

Table Name :	edk_check_prnt_fb_dtl
Comment :	To store Check Printed Finance Book Detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
fb_id	fin_financebook	Varchar(40)	Yes	Finance Book ID	No
co_logo	fin_txt255	varchar(255)	Yes	Logo	No
co_add1	fin_txt255	varchar(255)	Yes	Address1	No
co_add2	fin_txt255	varchar(255)	Yes	Address 2	No
co_city	fin_city	Char(40)	Yes	City	No
co_state	fin_state	Char(40)	Yes	State	No
co_zip	fin_zip	Char(20)	Yes	Zip	No
co_country	fin_country	varchar(40)	Yes	Country	No
telephone	fin_phone	Char(18)	Yes	Telephone	No
signature	fin_txt255	varchar(255)	Yes	Signature	No
CreatedBy	udd_ctxt_user	varchar(30)	Yes	Created By	No
CreatedDate	fin_datetime	datetime(8)	Yes	Created Date	No
ModifiedBy	udd_ctxt_user	varchar(30)	Yes	Modified By	No
ModifiedDate	fin_datetime	datetime(8)	Yes	Modified Date	No
TimeStamp	udd_timestamp	int(4)	Yes	Timestamp	No
FB_TAX_ID	varchar	Char(10)	Yes	Finance book Tax Id	No
replication_key	uniqueidentifier	Varchar(160)	No	Replication Id	Yes

Table Name :	rp_autorun_det
Comment :	To store information of auto run details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
rp_language_id	fin_ctxt_language	int(4)	Yes	Language id	No
rp_ou_id	fin_ctxt_ouinstance	int(4)	Yes	Organization unit id	No
rp_comp_code	fin_companycode	varchar(10)	Yes	Comp code	No
rp_runfmt_txt	fin_txt255	varchar(255)	Yes	rp_runfmt_txt	No
rp_runfmt	fin_txt255	varchar(255)	Yes	rp_runfmt	No
rp_lastupdno	fin_int	int(4)	Yes	Last updated number	No
rp_remarks	fin_txt255	varchar(255)	Yes	Remarks	No
rp_createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
rp_createddate	fin_datetime	datetime(8)	Yes	Created date	No
rp_modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
rp_modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	rp_bnkcharges_dtl
Comment :	To Store Information Of Bank Charges Detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
tranou	fin_ouinstid	int(4)	Yes	Tran Ou	No
seqno	fin_seqno	int(4)	No	Sequence Number	Yes
ref_paydate	fin_date	datetime(8)	Yes	Reference pay Date	No
snpvoucherno	fin_documentno	varchar(40)	Yes	SNP Voucher Number	No
snpstatus	fin_status	varchar(25)	Yes	SNP Status	No
ref_bankcode	fin_banknumber	varchar(20)	Yes	Reference bank Code	No
ref_doctype	fin_transactiontype	varchar(40)	Yes	Reference Document type	No
ref_paycurrency	fin_currencycode	varchar(5)	Yes	Reference pay currency	No
ref_bnkcurrency	fin_currency	varchar(5)	Yes	Reference bank Currency	No
ref_docamount	fin_amount	numeric(13)	Yes	Reference Document Amount	No
bnkcharges	fin_amount	numeric(13)	Yes	bank Charges	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
ref_voucherno	fin_documentno	varchar(40)	Yes	Reference voucher number	No
ref_paybatchno	fin_documentno	varchar(40)	Yes	reference paybath number	No
ref_docstatus	fin_status	varchar(25)	Yes	reference document status	No

Table Name :	rp_checkseries_dtl
Comment :	To store information of checkseries detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstname	varchar(16)	No	Ouinstance id	Yes
bank_code	fin_bankcode	varchar(32)	No	Bank code	Yes
checkseries_no	fin_checkseriesnumber	varchar(32)	No	Checkseries number	Yes
check_no	fin_checknumber	varchar(30)	No	Check number	Yes
timestamp	fin_int	int(4)	Yes	timestamp	No
sequence_no	fin_lineno	int(4)	Yes	Sequence number	No
check_date	fin_datetime	datetime(8)	Yes	Check date	No
check_amount	fin_amount	numeric(13)	Yes	Check amount	No
reason_code	fin_quickcodes	varchar(25)	Yes	Reason code	No
remarks	fin_remarks	varchar(100)	Yes	remarks	No
pay_charges	fin_amount	numeric(13)	Yes	Pay changes	No
instr_no	fin_checknumber	varchar(30)	Yes	Instrument number	No
instr_date	fin_datetime	datetime(8)	Yes	Instrument date	No
checkno_status	fin_cmbflag	varchar(4)	Yes	Check number status	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 :	rp_checkseries_hdr
Comment :	To store information of checkseries header

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	No	Ouinstance id	Yes
bank_code	fin_bankcode	varchar(32)	No	Bank code	Yes
checkseries_no	fin_checkseriesnumber	varchar(32)	No	Checkseries number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
payment_route	fin_cmbflag	varchar(4)	Yes	Payment route	No
checkseries_type	fin_cmbflag	varchar(4)	Yes	Checkseries type	No
noof_checkdgt	fin_noofcheckdigits	int(4)	Yes	Number of check digit	No
check_prefix	fin_checkprefix	varchar(15)	Yes	Check prefix	No
noof_check	fin_nofchecks	int(4)	Yes	Number of check	No
first_checkno	fin_checknumber	varchar(30)	Yes	First check number	No
last_checkno	fin_checknumber	varchar(30)	Yes	Last check number	No
lastused_checkno	fin_checknumber	varchar(30)	Yes	Last used check number	No
effective_from	fin_datetime	datetime(8)	Yes	Effective from	No
effective_to	fin_datetime	datetime(8)	Yes	Effective to	No
preprint_check	fin_cmbflag	varchar(4)	Yes	Preprint check	No
checkseries_status	fin_cmbflag	varchar(4)	Yes	Checkseries status	No
reason_code	fin_quickcodes	varchar(25)	Yes	Reason code	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
ModifyCheckno	fin_int	int(4)	Yes	Modify check number	No

Table Name :	rp_denomination_mst
Comment :	To store information of denomination detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	fin_int	int(4)	Yes	Timestamp	No
ou_id	fin_ouinstid	int(4)	Yes	Ouinstance id	No
voucher_no	fin_documentnumber	varchar(18)	Yes	Voucher number	No
payment_category	fin_desc40	varchar(40)	Yes	Payment category	No
denomination	fin_denomination	numeric(9)	Yes	Denomination	No
number	fin_number	int(4)	Yes	Number	No
amount	fin_amount	numeric(13)	Yes	Amount	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	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	rp_eft_details
Comment :	To store information of effective details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	fin_int	int(4)	Yes	Timestamp	No
ou_id	fin_ouinstid	int(4)	Yes	Ouinstance id	No
voucher_no	fin_voucher	varchar(20)	Yes	Voucher number	No
bank_ptt_code	fin_bankcode	varchar(32)	Yes	Bank ptt code	No
pay_mode	fin_paymode	varchar(25)	Yes	Payment number	No
payee_name	fin_name	varchar(60)	Yes	Payee name	No
bank_acc_no	fin_banknumber	varchar(20)	Yes	Bank account number	No
bank_clear_no	fin_banknumber	varchar(20)	Yes	Bank clear number	No
bank_name	fin_bankname	varchar(40)	Yes	Bank name	No
iso_country_cd	fin_countrycode	varchar(5)	Yes	iso country code	No
region	fin_description	varchar(100)	Yes	Region	No
description	fin_description	varchar(100)	Yes	Description	No
address1	fin_address	varchar(40)	Yes	Address 1	No
address2	fin_address	varchar(40)	Yes	Address 2	No
pay_reason1	fin_reason	varchar(256)	Yes	Pay reason 1	No
pay_reason2	fin_reason	varchar(256)	Yes	Pay reason 2	No
pay_reason3	fin_reason	varchar(256)	Yes	Pay reason 3	No
pay_reason4	fin_reason	varchar(256)	Yes	Pay reason 4	No
pay_instruct1	fin_instruction	varchar(16)	Yes	Pay instruction 1	No
pay_instruct2	fin_instruction	varchar(16)	Yes	Pay instruction 2	No
pay_instruct3	fin_instruction	varchar(16)	Yes	Pay instruction 3	No
pay_instruct4	fin_instruction	varchar(16)	Yes	Pay instruction 4	No
info_block1	fin_description	varchar(100)	Yes	Information block 1	No
info_block2	fin_description	varchar(100)	Yes	Information block 2	No
info_block3	fin_description	varchar(100)	Yes	Information block 3	No
info_block4	fin_description	varchar(100)	Yes	Information block 4	No
info_block5	fin_description	varchar(100)	Yes	Information block 5	No
voucher_amount	fin_amount	numeric(13)	Yes	Voucher amount	No
currency	fin_currencycode	varchar(5)	Yes	Currency	No
pay_date	fin_datetime	datetime(8)	Yes	Payment date	No
pay_category	fin_paycategory	varchar(40)	Yes	Payment category	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	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	rp_eft_file_structure
Comment :	To store information of effective fine structure

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
paybatch_no	fin_documentnumber	varchar(18)	Yes	Paybatch number	No
voucher_no	fin_documentnumber	varchar(18)	Yes	Voucher number	No
voucher_amount	fin_amount	numeric(13)	Yes	Voucher amount	No
payee	fin_suppliercode	varchar(16)	Yes	Payee	No
pay_mode	fin_paymode	varchar(25)	Yes	Payment mode	No
pay_currency	fin_currency	varchar(5)	Yes	Payment currency	No
priority	fin_priority	varchar(12)	Yes	Priority	No
status	fin_status	varchar(25)	Yes	Status	No
bank_cash_code	fin_bankcashcode	varchar(32)	Yes	Bank cash code	No
cr_doc_ou	fin_ouinstname	varchar(16)	Yes	Credit document OU	No
cr_doc_no	fin_documentnumber	varchar(18)	Yes	Credit document number	No
Vchr_tran_type	fin_type	varchar(25)	Yes	Voucher transaction type	No
pay_amount	fin_amount	numeric(13)	Yes	Payment amount	No
supp_code	fin_suppliercode	varchar(16)	Yes	Supplier code	No
Crd_tran_type	fin_cmntrantype	varchar(10)	Yes	Credit transaction type	No
tran_ou	fin_ouinstid	int(4)	Yes	Transaction OU	No
paytosupp	fin_varchar	varchar(800)	Yes	Pay to supplier	No
Pay_ref_id	fin_documentno	varchar(40)	Yes	Payment reference id	No
SBank_Supplier_Id	udd_vendorcode	varchar(45)	Yes	Supplier id	No
SBank_Bank_Type	udd_type	varchar(25)	Yes	Bank type	No
SBank_Currency	udd_currency	varchar(20)	Yes	Currency	No
SBank_Bank_AC_No	udd_banknumber	varchar(20)	Yes	Bank AC number	No
SBank_IBAN_No	UDD_paycodes	varchar(45)	No	IBAN number	No
SBank_Swift_No	UDD_paycodes	varchar(45)	No	Swift number	No
SBank_Nat_Clear_Code	udd_banknumber	varchar(20)	Yes	Nat cla\ear code	No
SBank_Bank_Name	udd_bankname	varchar(40)	Yes	Bank name	No
SBank_Bank_Address1	udd_txt255	varchar(255)	Yes	Bank address 1	No
SBank_Bank_Address2	udd_txt255	varchar(255)	Yes	Bank address 2	No
SBank_Bank_Address3	udd_txt255	varchar(255)	Yes	Bank address 3	No
SBank_Eff_Date_From	fin_datetime	datetime(8)	Yes	Effective date from	No
SBank_Eff_Date_To	fin_datetime	datetime(8)	Yes	Effective date to	No
SBank_Comments	udd_txt255	varchar(255)	Yes	Comments	No
SBank_TimeStamp	udd_timestampint	int(4)	Yes	Timestamp	No
company_code	fin_companycode	varchar(10)	Yes	Company code	No
bank_acc_no	fin_varchar	varchar(800)	Yes	Bank account number	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	rp_eft_formatted_data
Comment :	To store information of effective formatted data

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	fin_int	int(4)	Yes	Timestamp	No
guid	fin_guid	varchar(40)	Yes	Guid	No
tran_no	fin_number	int(4)	Yes	Transaction number	No
record_no	fin_number	int(4)	Yes	Record number	No
file_format	fin_param_categ	varchar(16)	Yes	File format	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_text	fin_varchar	varchar(800)	No	eft_text	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	rp_eft_metadata
Comment :	To store information of effective metadata

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	fin_int	int(4)	Yes	Timestamp	No
file_format	fin_param_categ	varchar(16)	Yes	File format	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_code	fin_eftcode	Varchar(120)	Yes	Effective code	No
eft_value	fin_eftvalue	Varchar(40)	Yes	Effective value	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	RP_EFT_VchrDtl_PyRf
Comment :	To store information of voucher detail payment reference

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
EftDtlId	fin_int	int(4)	No	EftDtlId	Yes
supp_ou	fin_ctxt_ouinstance	int(4)	Yes	Supplier OU	No
voucher_no	fin_documentnumber	varchar(18)	Yes	Voucher number	No
cr_doc_no	fin_documentnumber	varchar(18)	Yes	Credit document number	No
tran_type	fin_type	varchar(25)	Yes	Transaction type	No
supp_code	fin_suppliercode	varchar(16)	Yes	Supplier code	No
payrefId	fin_documentno	varchar(40)	Yes	Payment reference 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 :	rp_guid_dtl
Comment :	To store information of guid detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
oldguid	fin_guid	varchar(40)	No	Old guid	No
newguid	fin_guid	varchar(40)	No	New guid	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	rp_intg_eft_payment_dtl
Comment :	To Store Integration Effective payment Detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ouid	fin_ctxt_ouinstance	int(4)	Yes	Organisation Unit Id	No
companycode	fin_companycode	varchar(10)	Yes	Company Code	No
serial_no	fin_lineno	int(4)	Yes	Serial Number	No
doc_type	fin_flag	varchar(25)	Yes	Document Type	No
payment_category	fin_desc40	varchar(40)	Yes	Parameter Category	No
voucher_no	fin_documentno	varchar(40)	Yes	Vocher Number	No
pay_date	fin_date	datetime(8)	Yes	Pay Date	No
voucher_status	fin_txt255	varchar(255)	Yes	Vocher status	No
pay_accountno	fin_banknumber	varchar(20)	Yes	Pay Account Number	No
tran_amount	fin_amount	numeric(13)	Yes	Transaction Amount	No
currency	fin_currency	varchar(5)	Yes	Currency	No
rcv_bnk_swift_no	UDD_paycodes	varchar(45)	Yes	Bank Swift Number	No
rcv_bnk_code	fin_desc40	varchar(40)	Yes	Bank Code	No
rcv_accountno	fin_desc40	varchar(40)	Yes	Account Number	No
supplier_name	fin_txt150	varchar(150)	Yes	Supplier Name	No
rcv_address1	fin_txt255	varchar(255)	Yes	Address 1	No
rcv_address2	fin_txt255	varchar(255)	Yes	Adderss 2	No
rcv_address3	fin_txt255	varchar(255)	Yes	Address 3	No
rcv_countrycode	fin_txt255	varchar(255)	Yes	Country Code	No
creditdoc	fin_documentno	varchar(40)	Yes	Credit Document	No
bank_name	fin_bankname	varchar(40)	Yes	Bank Nmae	No
bank_address1	fin_txt255	varchar(255)	Yes	Bank Address 1	No
bank_address2	fin_txt255	varchar(255)	Yes	Bank Address 2	No
bank_address3	fin_txt255	varchar(255)	Yes	Bank Address 3	No
bank_countrycode	fin_txt255	varchar(255)	Yes	Bank Country Code	No
pay_currency	fin_currency	varchar(5)	Yes	Pay Currency	No
priority	fin_desc20	varchar(20)	Yes	Priority	No
comments	fin_txt255	varchar(255)	Yes	Comments	No
systemdate	fin_date	datetime(8)	Yes	Systemdate	No
eft_no	fin_desc20	varchar(20)	Yes	Eft number	No
status	fin_status	varchar(25)	Yes	Status	No
modified_flag	fin_flag	varchar(25)	Yes	Modified Log	No
REPLICATION_KEY	int	int(4)	No	Replication Key	Yes
sup_inv_no	fin_documentno	varchar(40)	Yes	Suppiler Invoice Number	No
Supplier_code	fin_suppliercode	varchar(16)	Yes	Supplier code	No
File_Process_status	fin_status	varchar(25)	Yes	File Process Status	No
rp_timestamp	udd_seqno	int(4)	Yes	Time Stamp	No
rp_modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
rp_modifieddate	udd_datetime1	datetime(8)	Yes	Modified Date	No
rcv_bank_comments	udd_txt255	varchar(255)	Yes	Bank Comments	No
Nat_Clear_Code	udd_banknumber	varchar(20)	Yes	Clear Code	No

Table Name :	rp_postings_dtl
Comment :	To store information of posting detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	No	Ouinstance id	Yes
serial_no	fin_lineno	int(4)	No	Serial number	Yes
unique_no	fin_lineno	int(4)	No	Unique number	Yes
doc_type	fin_desc40	varchar(40)	No	Document type	Yes
tran_ou	fin_ouinstid	int(4)	No	Transaction OU	Yes
document_no	fin_documenttype	varchar(40)	No	Document number	Yes
account_code	fin_accountcode	varchar(32)	No	Account code	Yes
tran_type	fin_transactiontypeid	varchar(10)	No	Transaction type	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
bu_id	fin_buid	varchar(20)	Yes	Business unit id	No
tran_date	fin_datetime	datetime(8)	Yes	Transaction date	No
posting_date	fin_datetime	datetime(8)	Yes	Posting date	No
account_currcode	fin_currencycode	varchar(5)	Yes	Account currency code	No
drcr_flag	fin_cmbflag	varchar(4)	Yes	Debit credit flag	No
currency_code	fin_currencycode	varchar(5)	Yes	Currency code	No
tran_amount	fin_amount	numeric(13)	Yes	Transaction amount	No
base_amount	fin_amount	numeric(13)	Yes	Base amount	No
exchange_rate	fin_exchangerate	numeric(9)	Yes	Exchange rate	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
analysis_code	fin_analysiscode	varchar(5)	Yes	Analysis code	No
subanalysis_code	fin_subanalysiscode	varchar(5)	Yes	Subanalysis code	No
cost_center	fin_costcentercode	varchar(10)	Yes	Cost center	No
entry_date	fin_datetime	datetime(8)	Yes	Entry date	No
auth_date	fin_datetime	datetime(8)	Yes	Author date	No
narration	fin_desc255	varchar(255)	Yes	Narration	No
bank_code	fin_bankid	varchar(20)	Yes	Bank code	No
item_code	fin_itemcode	varchar(40)	Yes	Item code	No
item_varinat	fin_variant	varchar(8)	Yes	Item variant	No
quantity	fin_quantitry	numeric(13)	Yes	Quantity	No
mac_post_flag	fin_flag	varchar(25)	Yes	Mac post flag	No
reftran_fbid	fin_transactionnumber	varchar(18)	Yes	Reference transaction finance book id	No
reftran_no	fin_transactionnumber	varchar(18)	Yes	Reference transaction number	No
supcust_code	fin_vendorcode	varchar(45)	Yes	Supplier customer code	No
reftran_ou	fin_ouinstid	int(4)	Yes	Reference transaction OU	No
ref_tran_type	fin_transactiontype	varchar(40)	Yes	Reference transaction type	No
uom	fin_uom	varchar(15)	Yes	UOM	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
ctrlacctype	fin_accounttype	varchar(15)	Yes	Control account type	No
vat_line_no	fin_lineno	int(4)	Yes	Vat line number	No
doc_line_no	fin_lineno	int(4)	Yes	Document line number	No
cr_docno	fin_documentnumber	varchar(18)	Yes	Credit document number	No

Table Name :	rp_reprint_dtl
Comment :	To store information of reprint detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstname	varchar(16)	No	Ouinstance id	Yes
bank_code	fin_bankcode	varchar(32)	No	Bank code	Yes
checkseries_no	fin_checkseriesnumber	varchar(32)	No	Checkseries number	Yes
check_no	fin_checknumber	varchar(30)	No	Check number	Yes
sequence_no	fin_lineno	int(4)	No	Sequence number	Yes
reprintseqno	fin_lineno	int(4)	No	Reprint sequence number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
reprint_date	fin_datetime	datetime(8)	Yes	Reprint 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
Reprint_check_no	fin_checknumber	varchar(30)	Yes	Reprint check number	No

Table Name :	rp_voucher_dtl
Comment :	To store information of voucher detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	No	Ouinstance id	Yes
serial_no	fin_lineno	int(4)	No	Serail number	Yes
doc_type	fin_flag	varchar(25)	No	Document type	Yes
tran_ou	fin_ouinstid	int(4)	No	Transaction OU	Yes
voucher_no	fin_documentnumber	varchar(18)	No	Voucher number	Yes
payment_category	fin_desc40	varchar(40)	No	Payment category	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
checkseries_no	fin_checkseriesnumber	varchar(32)	Yes	Checkseries number	No
check_no	fin_checknumber	varchar(30)	Yes	Check number	No
comp_reference	fin_desc40	varchar(40)	Yes	Comp reference	No
currency	fin_currencycode	varchar(5)	Yes	Currency	No
payee_name	fin_hrtext255	varchar(255)	Yes	Payee name	No
voucher_date	fin_datetime	datetime(8)	Yes	Voucher date	No
voucher_amount	fin_amount	numeric(13)	Yes	Voucher amount	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
bank_code	fin_bankcode	varchar(32)	Yes	Bank code	No
flag	fin_cmbflag	varchar(4)	Yes	Flag	No
pay_date	fin_datetime	datetime(8)	Yes	Payment date	No
priority	fin_cmbflag	varchar(4)	Yes	Priority	No
address	fin_address	varchar(40)	Yes	Address	No
pay_mode	fin_paymode	varchar(25)	Yes	Payment mode	No
voucher_status	fin_cmbflag	varchar(4)	Yes	Voucher status	No
void_tran_no	fin_transactionnumber	varchar(18)	Yes	Void transaction number	No
nolinesinstub	fin_integer8	int(4)	Yes	nolinesinstub	No
stubpropt	fin_cmbflag	varchar(4)	Yes	stubpropt	No
void_date	fin_datetime	datetime(8)	Yes	Void transaction date	No
eft_no	fin_docuemntno	varchar(18)	Yes	eft number	No
eft_type	fin_type	varchar(25)	Yes	eft type	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
FILENAME	fin_filename	varchar(50)	Yes	FILENAME	No
run_no	fin_txt255	varchar(255)	Yes	Run number	No
GenCheckno	fin_checknumber	varchar(30)	Yes	Generate check number	No

Table Name :	rp_voucher_hdr
Comment :	To store information of voucher header

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	No	Ouinstance id	Yes
serial_no	fin_lineno	int(4)	No	Serial number	Yes
doc_type	fin_flag	varchar(25)	No	Document type	Yes
timestamp	fin_int	int(4)	Yes	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