Relase Payment

Release Payment

Table Name rp_checkseries_dtl

Table Comment Table contains the info about check amount and Check series no of each payments against the bank
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
ou_id	sql_variant	Organization Unit Id	Yes	No
bank_code		Bank Code
checkseries_no		Check Series Number
check_no		Check Number
timestamp	int	Time Stamp	No
sequence_no		Sequence Number
check_date	datetime	Check Date
check_amount	bigint	Check Amount
reason_code	sql_variant	Reason Code
remarks		Remarks
pay_charges	bigint	Pay Charge
instr_no	sql_variant	Instrument Number
instr_date	datetime	Instrument Date
checkno_status	sql_variant	Check Number Status.Values AT-Active,IT-Inactive,DM-Damaged,DT-Deleted,VD-Void,PR-Printed,REPR-RePrinted
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
ou_id	sql_variant	Organization Unit Id	Yes	No
bank_code		Bank Code
checkseries_no		Check Series Number
check_no		Check Number

Table Name rp_checkseries_hdr
Table Comment Table contains info about the Check series Prefix and the Effective period of the Check numbering type and the number of check that is issued.
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
ou_id	int	Organization Unit Id	Yes	No
bank_code	sql_variant	Bank Code
checkseries_no		Check Series Number
timestamp	int	Time Stamp	No
payment_route	sql_variant	Payment Route
checkseries_type		Check Series Type
noof_checkdgt	int	Number Of Check Digits
check_prefix	sql_variant	Check Prefix
noof_check	int	Number Of Check
first_checkno	sql_variant	First Check Number
last_checkno		Last Check Number
lastused_checkno		Last Used Check Number
effective_from	datetime	Effective From
effective_to		Effective To
preprint_check	sql_variant	Preprint Check
checkseries_status		Check Series Status.Values A-Automatic,M-Manual,A-Active,I-Inactive
reason_code		Reason Code
remarks		Remarks
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
ou_id	int	Organization Unit Id	Yes	No
bank_code	sql_variant	Bank Code
checkseries_no		Check Series Number

Table Name rp_chkseries_ai_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	Time Stamp	No	No
guid	sql_variant	Guid
checkseries_no		Check Series Number
checkseries_status		Check Series Status.Values A-Automatic,M-Manual,A-Active,I-Inactive
bank_code		Bank Code
check_prefix		Check Prefix
first_checkno		First Check Number
last_checkno		Last Check Number
lastused_checkno		Last Used Check Number
checkseries_type		Check Series Type
preprint_check		Preprint Check
reason_code		Reason Code
remarks		Remarks
flag		Flag
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Name rp_delchk_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	Time Stamp	No	No
guid	sql_variant	Guid
bank_code		Bank Code
checkseries_type		Check Series Type
checkseries_no_from		Check Series Number From
checkseries_no_to		Check Series Number To
check_no_from		Check Number From
check_no_to		Check Number To
checkdatefrom	datetime	Check Date From
checkdateto		Check Date To
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Name rp_deletechk_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	Time Stamp	No	No
guid	sql_variant	Guid
check_no		Check Number
checkseries_no		Check Series Number
checkseries_type		Check Series Type
bank_code		Bank Code
currency		Currency
check_amount	bigint	Check Amount
payt_category	sql_variant	Payment Category
reason_code		Reason Code
remarks		Remarks
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Name rp_denomination_mst

Table Comment Table contains the info about the check denominations
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	Time Stamp	No	No
ou_id		Organization Unit Id
voucher_no	sql_variant	Voucher Number
payment_category		Payment Category
denomination	bigint	Denomination
number	int	Number
amount	bigint	Amount
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Name rp_denomination_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	Time Stamp	No	No
guid	sql_variant	Guid
ou_id	int	Organization Unit Id
voucher_no	sql_variant	Voucher Number
payment_category		Payment Category
currency		Currency
denomination	bigint	Denomination
number	int	Number
amount	bigint	Amount
flag	sql_variant	Flag
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Name rp_eft_details

Table Comment Table contains the info about the bank acc/no and clearence no for EFT Payments
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	Time Stamp	No	No
ou_id		Organization Unit Id
voucher_no	sql_variant	Voucher Number
bank_ptt_code		Bank / PTT Code
pay_mode		Pay Mode
payee_name		Payee Name
bank_acc_no		Bank Account Number
bank_clear_no		Bank Clear Number
bank_name		Bank Name
iso_country_cd		ISO Country Code
region		Region
description		Description
address1		Address 1
address2		Address 2
pay_reason1		Pay Reason 1
pay_reason2		Pay Reason 2
pay_reason3		Pay Reason 3
pay_reason4		Pay Reason 4
pay_instruct1		Pay Instruction 1
pay_instruct2		Pay Instruction 2
pay_instruct3		Pay Instruction 3
pay_instruct4		Pay Instruction 4
info_block1		Information Block 1
info_block2		Information Block 2
info_block3		Information Block 3
info_block4		Information Block 4
info_block5		Information Block 5
voucher_amount	bigint	Voucher Amount
currency	sql_variant	Currency
pay_date	datetime	Pay Date
pay_category	sql_variant	Pay Category
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Name rp_eft_file_structure

Table Comment Table contains the info about the Credit documents and bank info and Payto supp info’s
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
paybatch_no	sql_variant	Pay Batch Number	No	No
voucher_no		Voucher Number
voucher_amount	bigint	Voucher Amount
payee	sql_variant	Payee
pay_mode		Pay Mode
pay_currency		Pay Currency
priority		Priority
status		Status.Values RE-Requested
bank_cash_code		Bank Cash Code
cr_doc_ou		Credit Document Oragnization Unit
cr_doc_no		Credit Document Number
Vchr_tran_type		Voucher Transaction Type
pay_amount	bigint	Pay Amount
supp_code	sql_variant	Supplier Code
Crd_tran_type		Credit Transaction Type
tran_ou	int	Transaction Organization Unit
paytosupp	varchar(16)	Pay To Supplier
Pay_ref_id	sql_variant	Pay Reference Id
SBank_Supplier_Id		Supplier Id
SBank_Bank_Type		Bank Type
SBank_Currency		Currency
SBank_Bank_AC_No		Bank Account Number
SBank_IBAN_No		IBAN Number
SBank_Swift_No		Swift Number
SBank_Nat_Clear_Code		Supplier Bank National Clearing Code
SBank_Bank_Name		Bank Name
SBank_Bank_Address1		Bank Address 1
SBank_Bank_Address2		Bank Address 2
SBank_Bank_Address3		Bank Address 3
SBank_Eff_Date_From	datetime	Effective Date from
SBank_Eff_Date_To		Effective Date to
SBank_Comments	sql_variant	Comments
SBank_TimeStamp	int	Time Stamp
company_code	sql_variant	Company Code
bank_acc_no	varchar(20)	Bank Account Number
fb_id	sql_variant	Finance Book Id

Table Name rp_eft_formatted_data

Table Comment Table contains the final EFT text data
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	Time Stamp	No	No
guid	sql_variant	Guid
tran_no	int	Transaction Number
record_no		Record Number
file_format	sql_variant	File Format
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
eft_text	sql_variant	Electronic File Transfer Transaction Text

Table Name rp_eft_metadata

Table Comment Table contains the EFT code
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	Time Stamp	No	No
file_format	sql_variant	File Format
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
eft_code	sql_variant	Electronic File Transfer Code
eft_value		Electronic File Transfer Value

Table Name rp_eft_tran_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	Time Stamp	No	No
guid	sql_variant	Guid
company_code		Company Code
ou_id	int	Organizatrion Unit Id
bank_acc_no	sql_variant	Bank Account Number
pay_mode		Pay Mode
tran_date	datetime	Transaction Date
reference_no	sql_variant	Reference Number
currency_code		Currency Code
tran_amount	bigint	Transaction Amount
post_amount		Post Amount
ref_remit_name	sql_variant	Reference Remitter Name
ref_remit_addr1		Reference Remitter Address 1
ref_remit_addr2		Reference Remitter Address 2
ref_remit_addr3		Reference Remitter Address 3
exchange_rate	bigint	Exchange Rate
created_date	datetime	Created Date
document_no	sql_variant	Document Number
vendor_participant_no		Vendor Participant Number
payment_reason1		Payment Reason 1
payment_reason2		Payment Reason 2
payment_reason3		Payment Reason 3
payment_reason4		Payment Reason 4
vendor_bank_acc		Vendor Bank Account
vendor_name		Vendor Name
vendor_street		Vendor Street
vendor_place		Vendor Place
vendor_zip		Vendor Zip
payee_bank_acc		Payee Bank Account
payee_bank_bank_acc		Payee Bank Bank Account
payee_bank_name		Payee Bank Name
payee_bank_addl_desc		Payee Bank Addtional Description
payee_bank_street		Payee Bank Street
payee_bank_place		Payee Bank Place
bank_payment_instn1		Bank Payment Instruction 1
bank_payment_instn2		Bank Payment Instruction 2
bank_payment_instn3		Bank Payment Instruction 3
bank_payment_instn4		Bank Payment Instruction 4
payee_bcn		Payee Bank Currency
esr_ref_no		ESR Reference Number
parity		Parity
createdby		By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
supp_bank_type	sql_variant	Supplier Bank Type
swiftid		Swift Id
sr_no	int	Trn-Bsg-RCN-RP-R62-1.0 Sr_no
supplier_code	sql_variant	Supplier Code
pay_ref_id		Pay reference id

Table Name RP_EFT_VchrDtl_PyRf

Table Comment Table contains the info about the Supplier code and Payref details for the payments
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
EftDtlId	int	Effective Detail Id	Yes	No
supp_ou		Supplier Organization Unit	No
voucher_no	sql_variant	Voucher Number
cr_doc_no		Credit Document Number
tran_type		Transaction Type
supp_code		Supplier Code
payrefId		Pay Reference Id
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
EftDtlId	int	Effective Detail Id	Yes	No

Table Name rp_eftdtls_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
BANKCLEARINGNUMBER	sql_variant	Bank Clearing Number	No	No
PAYEEBANKPTT		Payee Bank/PTT
VOUCHERNUMBERML		Voucher Number Multiple Line
guid		Guid
BANKNAMEML		Bank Name Multiple Line

Table Name rp_eftvoucher_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	Time Stamp	No	No
guid	sql_variant	Guid
ou_id	int	Organization Unit Id
voucher_no	sql_variant	Voucher Number
eftno		Effcetive Number
efttype		Effcetibe Type
payeename		Payee Name
pay_mode		Pay Mode
pay_date	datetime	Pay Date
currency	sql_variant	Currency
voucher_amount	bigint	Voucher Amount
priority	sql_variant	Priority
pay_status		Pay Status.Values ADJ-Adjusted,REQ-requested,PPAD-partially paid,RVD-reversed,PADJ-partially adjusted,AUT-authorised,VD-void,HLD-Hold,HAU-Hold authorise,PAD-Fully paid,RE-Requested
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Name rp_fbposting_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	Time Stamp	No	No
batch_id	sql_variant	Batch Id
serial_no	int	Serial Number
company_code	sql_variant	Company Code
component_name		Component Name
bu_id		Business Unit Id
fb_id		Finance Book Id
tran_ou	int	Transaction Organization Unit
document_no	sql_variant	Document Number
tran_type		Transaction Type
tran_date	datetime	Transaction Date
posting_date		Posting Date
account_code	sql_variant	Account Code
account_currcode		Account Currency Code
drcr_flag		Debit Credit Flag
currency_code		Currency Code
tran_amount	bigint	Transaction Amount
base_amount		Base Amount
exchange_rate		Exchange Rate
ou_id	int	Organization Unit Id
par_base_amount	bigint	Parallel Base Amount
par_exchange_rate		Parallel Exchange Rate
analysis_code	sql_variant	Analysis Code
subanalysis_code		Subanalysis Code
cost_center		Cost Center
entry_date	datetime	Entry Date
auth_date		Authorized Date
narration	sql_variant	Narration
bank_code		Bank Code
item_code		Item Code
item_varinat		Item Variant
quantity	bigint	Quantity
mac_post_flag	sql_variant	Management Account Posting Flag
reftran_fbid		Reference Transaction Finance Book Id
reftran_no		Reference Transaction Number
supcust_code		Supplier Customer Code
reftran_ou	int	Reference Transaction Organization Unit
ref_tran_type	sql_variant	Reference Transaction Type
uom		Unit Of Measurement
pay_type		Pay Type
iudflag		IUD Flag
void_tran_ou	int	Void Transaction Organization Unit
void_tran_no	sql_variant	Void Transaction Number
void_tran_type		Void Transaction Type
uniqueno	int	Unique Number
amount_status	sql_variant	Amount Status.Values PAID,VOID
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
ctrlacctype	sql_variant	Control Account Type
doctype		Document Type
vat_line_no	int	Value Added Tax Line Number
doc_line_no		Document Line Number
cr_docno	fin_documentnumber	Reference document number

Table Name rp_guid_dtl
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
oldguid	sql_variant	Old Guid	No	No
newguid		New Guid

Table Name rp_ispaytdetails_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	Time Stamp	No	No
ou_id		Organization Unit
bank_code	sql_variant	Bank Code
voucher_no		Voucher Number
trantype		Transaction Type
pay_date	datetime	Pay Date
check_no	sql_variant	Check Number
comp_reference		Company Reference
guid		Guid
checkprefix		Check Prefix
checkamount	bigint	Check Amount
remarks	sql_variant	Remarks
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
currency_code	sql_variant	Currency Code

Table Name rp_isvoucherdetails_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	Time Stamp	No	No
guid	sql_variant	Guid
componentid		Component Id
tran_number		Transaction Number
tran_type		Transaction Type
tran_ou	int	Transaction Organization Unit
tran_date	datetime	Transaction Date
status	sql_variant	Status
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Name rp_paycash_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	Time Stamp	No	No
guid	sql_variant	Guid
ou_id	int	Organization Unit Id
voucher_no	sql_variant	Voucher Number
priority		Priority
bank_cash_code		Bank Cash Code
pay_date	datetime	Pay Date
currency	sql_variant	Currency
voucher_amount	bigint	Voucher Amount
payee_name	sql_variant	Payee Name
payt_category		Payment Category
flag		Flag
payt_category_desc		Payment Category Description
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Name rp_prck_rpt_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
voucher_no	sql_variant	Voucher Number	No	No
vendor_inv_no		Vendor Invoice Number
invoice_date	datetime	Invoice Date
invoice_amt	bigint	Invoice Amount
discount		Discount
payment_amt		Payment Amount
guid	sql_variant	Guid
flag	int	Flag
checkno	sql_variant	Check Number
amount	bigint	Amount
Vendor_Name	sql_variant	Vendor Name
Ven_Addr1		Vendor Address 1
Ven_Addr2		Vendor Address 2
Ven_Addr3		Vendor Address 3
Ven_Addr4		Vendor Address 4
Amount_type		Amount Type
Cur_type		Currency Type
companyname		Company Name
comp_address1		Company Address 1
comp_address2		Company Address 2
comp_address3		Company Address 3
bankname		Bank Name
bank_address1		Bank Address 1
bank_address2		Bank Address 2
bank_address3		Bank Address 3
swift_no		Swift Number
amount1		Amount 1
base_amount	bigint	Base Amount
created_by	sql_variant	Created By
maxline	int	Maximum Line
pay_term	sql_variant	Pay Term

Table Name rp_print_txt_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
checkno	sql_variant	Check Number	No	No
textcontent	text	Text Context
guid	sql_variant	Guid

Table Name rp_printcheck_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	Time Stamp	No	No
guid	sql_variant	Guid
voucher_no		Voucher Number
payee_name		Payee Name
check_date	datetime	Check Date
voucher_amount	bigint	Voucher Amount
check_no	sql_variant	Check Number
pay_charges	bigint	Pay Charges
priority	sql_variant	Priority
address		Address
no_stub_lines	int	Number Stub Lines
stub_prt_opt	sql_variant	Stud Printing Option
comp_reference		Component Reference
pay_date	datetime	Pay Date
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
payee_code	sql_variant	Payee Code
voucher_type		Voucher Type

Table Name rp_printchk_rpt_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
paycategory	sql_variant	Pay Category	No	No
bankcode		Bank Code
currency_code		Currency Code
checkseriesnumber		Check Series Number
checkseriestype		Check Series Type
checkprefix		Check Prefix
startingchecknumber		Starting Check Number
nextusablechecknumber		Next Usable Check Number
singlecheck		Single Check
voucherno		Voucher Number
guid1		Guid 1

Table Name rp_rcd_damage_check_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	Time Stamp	No	No
guid	sql_variant	Guid
check_no		Check Number
checkno_status		Check Number Status.Values AT-Active,IT-Inactive,DM-Damaged,DT-Deleted,VD-Void,PR-Printed,REPR-RePrinted
checkseries_no		Check Series Number
checkseries_type		Check Series Type
bank_code		Bank Code
reason_code		Reason Code
remarks		Remarks
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Name rp_recordinsinfo_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	Time Stamp	No	No
guid	sql_variant	Guid
voucher_no		Voucher Number
check_no		Check Number
payee_name		Payee Name
check_amount	bigint	Check Amount
pay_charges		Pay Charges
bankref_instrno	sql_variant	Bank Reference Instrument Number
bankref_instrdate	datetime	Bank Reference Instrument Date
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date


Table Name rp_reprck_rpt_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
voucher_no	sql_variant	Voucher Number	No	No
vendor_inv_no		Vendor Invoice Number
invoice_date	datetime	Invoice Date
invoice_amt	bigint	Invoice Amount
discount		Discount
payment_amt		Payment Amount
guid	sql_variant	Guid
flag	int	Flag
checkno	sql_variant	Check Number
amount	bigint	Amount
Vendor_Name	sql_variant	Vendor Name
Ven_add1		Vendor Address 1
Ven_add2		Vendor Address 2
Ven_add3		Vendor Address 3
Ven_add4		Vendor Address &nbsp4
Amount_type		Amount Type
Cur_type		Currency Type
companyname		Company Name
comp_address1		Company Address 1
comp_address2		Company Address 2
comp_address3		Company Address 3
bankname		Bank Name
bank_address1		Bank Address 1
bank_address2		Bank Address 2
bank_address3		Bank Address 3
swift_no		Swift Number
dis_amount		Discount Amount
base_amount	bigint	Base Amount
created_by	sql_variant	Created By
maxline	int	Maximum Line
pay_term	sql_variant	Pay Term


Table Name rp_reprint_dtl
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
ou_id	sql_variant	Organization Unit Id	Yes	No
bank_code		Bank Code
checkseries_no		Check Series Number
check_no		Check Number
sequence_no	int	Sequence Number
reprintseqno		Reprint Sequence Number
timestamp		Time Stamp	No
reprint_date	datetime	Reprint Date
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
Reprint_check_no	sql_variant	Reprint Check Number
Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
ou_id	sql_variant	Organization Unit Id	Yes	No
bank_code		Bank Code
checkseries_no		Check Series Number
check_no		Check Number
sequence_no	int	Sequence Number
reprintseqno		Reprint Sequence Number

Table Name rp_reprint_srch_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
guid	sql_variant	Guid	No	No
bank_code		Bank Code
voucher_amount	bigint	Voucher Number
check_date	datetime	Check Date
check_no	sql_variant	Check Number
currency		Currency
voucher_date	datetime	Voucher Date
payee_name	sql_variant	Payee Name
timestamp		Time Stamp
voucher_no		Voucher Number
no_of_damaged_checks	int	Number Of Damaged Checks
row_no		Row Number
Reprint_check_no	sql_variant	Reprint Check Number


Table Name rp_reprintchk_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	Time Stamp	No	No
guid	sql_variant	Guid
ou_id	int	Organization Unit Id
bank_code	sql_variant	Bank Code
check_no		Check Number
check_date	datetime	Check Date
check_amount	bigint	Check Amount
voucher_no	sql_variant	Voucher Number
currency		Currency
payee_name		Payee Name
voucher_date	datetime	Voucher Number
voucher_amount	bigint	Voucher Amount
flag	sql_variant	Flag
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
checkno_status	sql_variant	Check Number Status.Values AT-Active,IT-Inactive,DM-Damaged,DT-Deleted,VD-Void,PR-Printed,REPR-RePrinted
Reprint_check_no		Reprint Check Number
preprint_check		Reprint Check
row_no	int	Row Number


Table Name rp_voidcheck_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	Time Stamp	No	No
guid	sql_variant	Guid
check_no		Check Number
checkseries_no		Check Series Number
bank_code		Bank Code
check_date	datetime	Check Date
currency_code	sql_variant	Currency Code
check_amount	bigint	Check Amount
voucher_no	sql_variant	Voucher Number
payee_name		Payee Name
reason_code		Reason Code
remarks		Remarks
flag		Flag
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date


Table Name rp_voiddirectdebit_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	Time Stamp	No	No
guid	sql_variant	Guid
Comp_reference		Company Reference
bank_code		Bank Code
Pay_date	datetime	Pay Date
currency_code	sql_variant	Currency Code
Debit_Amount	bigint	Debit Amount
voucher_no	sql_variant	Voucher Number
payee_name		Payee Name
reason_code		Reason Code
remarks		Remarks
Void_date	datetime	Void Date
flag	sql_variant	Flag
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date


Table Name rp_voucher_dtl

Table Comment Table contains the info about the credit documents that are released against the banks
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
ou_id	int	Organization Unit Id	Yes	No
serial_no		Serial Number
doc_type	sql_variant	Document Type
tran_ou	int	Transaction Organization Unit
voucher_no	sql_variant	Voucher Number
payment_category		Payment Category
timestamp	int	Time Stamp	No
checkseries_no	sql_variant	Check Series Number
check_no		Check Number
comp_reference		Company Reference
currency		Currency
payee_name		Payee Name
voucher_date	datetime	Voucher Date
voucher_amount	bigint	Voucher Amount
fb_id	sql_variant	Finance Book Id
bank_code		Bank Code
flag		Flag
pay_date	datetime	Pay Date
priority	sql_variant	Priority
address		Address
pay_mode		Pay Mode
voucher_status		Voucher Status.Values RQ-Requested,DR-Draft,FR-Fresh,RT-Returned,RV-Reversed,DT-Deleted,HD-Held,PD-Paid,VD-Void
void_tran_no		Void Transaction Number
nolinesinstub	int	Number Lines In Stub
stubpropt	sql_variant	Stub printing option
void_date	datetime	Void Date
eft_no	sql_variant	Electronic File Transfer Number
eft_type		Electronic File Transfer Type
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
filename	sql_variant	Trn-Bsg-RCN-RP-R62-1.0 File Name
run_no	fin_txt255	RunNo
Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
ou_id	int	Organization Unit Id	Yes	No
serial_no		Serial Number
doc_type	sql_variant	Document Type
tran_ou	int	Transaction Organization Unit
voucher_no	sql_variant	Voucher Number
payment_category		Payment Category

Table Name rp_voucher_hdr

Table Comment Table contains the info about the serial no that are generated against each payment releases
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
ou_id	int	Organization Unit Id	Yes	No
serial_no		Serial Number
doc_type	sql_variant	Document Type
timestamp	int	Time Stamp	No
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
ou_id	int	Organization Unit Id	Yes	No
serial_no		Serial Number
doc_type	sql_variant	Document Type

Table Name rp_voucher_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	Time Stamp	No	No
guid	sql_variant	Guid
voucher_no		Voucher Number
payee_name		Payee Name
address		Address
priority		Priority
payment_category		Payment Category
bank_code		Bank Code
pay_mode		Pay Mode
pay_date	datetime	Pay Date
currency	sql_variant	Currency
voucher_amount	bigint	Voucher Amount
check_no	sql_variant	Check Number
ou_id	int	Organization Unit Id
voucher_date	datetime	Voucher Date
comp_reference	sql_variant	Company Reference
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date


Table Name rp_vouchermain_tmp
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	Time Stamp	No	No
guid	sql_variant	Guid
voucher_no		Voucher Number
payment_category		Payment Category
ou_id	int	Organization Unit Id
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date


Table name rp_postings_dtl
Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
ou_id	fin_ouinstid	Organization Unit Id	yes	No
serial_no	fin_lineno	Serial number	yes
unique_no	fin_lineno	Unique Number	yes
doc_type	fin_desc40	Document type	yes
tran_ou	fin_ouinstid	Organization Unit Id	yes
document_no	fin_documenttype	Document number	yes
account_code	fin_accountcode	Account code	yes
tran_type	fin_transactiontypeid	Transaction type	yes
timestamp	int	Time stamp
fb_id	fin_financebookid	Finance Book Id
bu_id	fin_buid	Business unit id
tran_date	datetime	Transaction date
posting_date	datetime	Posting date
account_currcode	fin_currencycode	Account currency code
drcr_flag	fin_cmbflag	Debit credit flag
currency_code	fin_currencycode	Currency code
tran_amount	fin_amount	Transaction amount
base_amount	fin_amount	Base amount
exchange_rate	fin_exchangerate	Exchange rate
par_base_amount	fin_amount	Parallel base amount
par_exchange_rate	fin_exchangerate	Parallel exchange rate
analysis_code	fin_analysiscode	Analysis code
subanalysis_code	fin_subanalysiscode	Sub analysis code
cost_center	fin_costcentercode	Cost center
entry_date	datetime	Entry date
auth_date	datetime	Authorization date
narration	fin_desc255	Comments
bank_code	fin_bankid	Bank code
item_code	fin_itemcode	Item code
item_varinat	fin_variant	Item variant
quantity	fin_quantitry	Quantity
mac_post_flag	fin_flag	Posting flag
reftran_fbid	fin_transactionnumber	Ref tran Finance book id
reftran_no	fin_transactionnumber	Reference transaction number
supcust_code	fin_vendorcode	Supplier/Customer code
reftran_ou	fin_ouinstid	Ref tran Organisation unit id
ref_tran_type	fin_transactiontype	Reference transaction type
uom	fin_uom	UOM
createdby	fin_user	Created by
createddate	datetime	Created date
modifiedby	fin_user	Modified by
modifieddate	datetime	Modified date
ctrlacctype	fin_accounttype	Control account type
vat_line_no	fin_lineno	Line number
doc_line_no	fin_lineno	Document line number
cr_docno	fin_documentnumber	Reference Document number

Release Payment