Database Schema for

Data Dictionary -- Sundry Payment

Srl. No.	Table Name	Comment
1	snp_apportioned_tcd_dtl	To store the Information about the Apportioned tcd details
2	snp_fbposting_dtl	Sundry Payment Postings Detail
3	snp_notes_dtl	Sundry Payment Notes Detail
4	snp_processparameter_his	Sundry Payment Parameter Detail
5	snp_tcd_dtl	To store information about tcd details
6	snp_template_dtl	Sundry Payment Template Detail
7	snp_template_hdr	Sundry Payment Template Header
8	snp_tempvataccount_dtl	Sundry Payment Payment Template VAT Account Detail
9	snp_tempvatpostings_dtl	Sundry Payment Payment Template VAT Postings Detail
10	snp_vataccount_dtl	Sundry Payment Payment VAT Detail
11	snp_vatpostings_dtl	Sundry Payment Payment VAT Postings Detail
12	snp_voucher_dtl	Sundry Payment Detail
13	snp_voucher_hdr	Sundry Payment Header


Table Name :	snp_apportioned_tcd_dtl
Comment :	To store the Information about the Apportioned tcd details


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
tran_type	fin_cmntrantype	varchar(10)	No	Transaction Type	Yes
tran_ou	fin_ouinstid	int(4)	No	Transaction Organization Unit	Yes
tran_no	fin_documentnumber	varchar(18)	No	Transaction No	Yes
line_no	fin_lineno	int(4)	No	Line No	Yes
item_tcd_code	fin_itemcode	varchar(40)	No	Item TCD Code	Yes
item_tcd_var	fin_itemcode	varchar(40)	No	Item TCD Variable	Yes
tcd_version	fin_macseqno	int(4)	No	TCD Version	Yes
timestamp	fin_int	int(4)	No	Timestamp	Yes
item_type	fin_abbreviation	varchar(3)	No	Item Type	Yes
tcd_rate	fin_amount	numeric(13)	No	TCD Rate	Yes
taxable_amt	fin_amount	numeric(13)	No	Taxable Amount	Yes
tcd_amount	fin_amount	numeric(13)	No	TCD Amount	Yes
tcd_currency	fin_currency	varchar(5)	No	TCD Currency	Yes
base_amount	fin_amount	numeric(13)	No	Base Amount	Yes
par_base_amount	fin_amount	numeric(13)	No	Par Base Amount	Yes
cost_center	fin_costcentercode	varchar(10)	No	Cost Center	Yes
analysis_code	fin_analysiscode	varchar(5)	No	Analysis Code	Yes
subanalysis_code	fin_subanalysiscode	varchar(5)	No	Subanalysis Code	Yes
remarks	fin_text255	varchar(255)	No	Remarks	Yes
createdby	fin_ctxt_user	varchar(30)	No	Created By	Yes
createddate	fin_text255	varchar(255)	No	Created Date	Yes
modifiedby	fin_ctxt_user	varchar(30)	No	Modified By	Yes
modifieddate	fin_text255	varchar(255)	No	Modified Date	Yes


Table Name :	snp_fbposting_dtl
Comment :	Sundry Payment Postings Detail


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
batch_id	fin_guid	varchar(40)	No	Batch ID	Yes
ou_id	fin_ouinstid	int(4)	No	Organization unit id	Yes
document_no	fin_docuemntno	varchar(18)	No	Trasaction number	Yes
account_lineno	fin_lineno	int(4)	No	Account Line Number	Yes
account_code	fin_accountcode	varchar(32)	No	Account code	Yes
timestamp	udd_integer	varchar(32)	No	Time Stamp	No
company_code	fin_companycode	varchar(10)	Yes	Company Code	No
component_name	fin_compid	varchar(10)	Yes	Component Name	No
bu_id	fin_buid	varchar(20)	Yes	Business unit id	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
tran_ou	fin_ouinstid	int(4)	Yes	Transaction Organization unit id	No
tran_type	fin_transactiontype	varchar(40)	Yes	Transaction type	No
tran_date	datetime(8)	varchar(40)	Yes	Transaction Date	No
posting_date	datetime(8)	varchar(40)	Yes	Posting Date	No
drcr_flag	fin_drcridentifier	varchar(6)	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	Sub Analysis Code	No
cost_center	fin_costcentercode	varchar(10)	Yes	Cost Center	No
mac_post_flag	fin_flag	varchar(25)	Yes	Posting Flag	No
acct_type	fin_account_type	varchar(10)	Yes	Account Type	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime(8)	varchar(30)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime(8)	varchar(30)	Yes	Modified Date	No
remarks	fin_text255	varchar(255)	Yes	Remarks	No


Table Name :	snp_notes_dtl
Comment :	Sundry Payment Notes Detail


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	No	Organization unit id	Yes
voucher_no	fin_documentnumber	varchar(18)	No	Voucher number	Yes
voucher_type	fin_cmbflag	varchar(4)	No	Voucher type	Yes
tran_type	fin_transactiontype	varchar(40)	No	Transaction type	Yes
notes_for	fin_param_text	varchar(255)	No	Notes For	Yes
notes_level	fin_param_text	varchar(255)	No	Notes Level	Yes
line_no	fin_sequence	int(4)	No	Line Number	Yes
timestamp	udd_integer	int(4)	No	Time Stamp	No
notes	fin_notes	varchar(2000)	Yes	Notes	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime(8)	varchar(30)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime(8)	varchar(30)	Yes	Modified Date	No


Table Name :	snp_processparameter_his
Comment :	Sundry Payment Parameter Detail


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	No	Organization unit id	Yes
parameter_type	fin_param_type	varchar(6)	No	Parameter Type	Yes
parameter_category	fin_param_categ	varchar(16)	No	Parameter Category	Yes
parameter_code	fin_paramcode	varchar(30)	No	Parameter Code	Yes
actiontime	datetime(8)	varchar(30)	No	Action Time	Yes
timestamp	udd_integer	varchar(30)	No	Time Stamp	No
paramater_text	fin_remarks	varchar(100)	Yes	Parameter Text	No
extension_flag	fin_cmbflag	varchar(4)	Yes	Extension Flag	No
actionflag	fin_cmbflag	varchar(4)	Yes	Action Flag	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime(8)	varchar(30)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime(8)	varchar(30)	Yes	Modified Date	No


Table Name :	snp_tcd_dtl
Comment :	To store information about tcd details


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
reference_info	fin_cmntrantype	varchar(10)	No	Reference Information	Yes


Table Name :	snp_template_dtl
Comment :	Sundry Payment Template Detail


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	No	Organization unit id	Yes
template_no	fin_documentnumber	varchar(18)	No	Template number	Yes
account_lineno	fin_lineno	int(4)	No	Account Line Number	Yes
tran_type	fin_transactiontype	varchar(40)	No	Transaction type	Yes
timestamp	udd_integer	varchar(40)	No	Time Stamp	No
usage_id	fin_usageid	varchar(20)	Yes	Usage ID	No
account_code	fin_accountcode	varchar(32)	Yes	Account Code	No
currency	fin_currencycode	varchar(5)	Yes	Currency Code	No
amount	fin_amount	numeric(13)	Yes	Amount	No
drcr_flag	fin_cmbflag	varchar(4)	Yes	Debit Credit Flag	No
base_amount	fin_amount	numeric(13)	Yes	Base Amount	No
proposal_no	fin_documentnumber	varchar(18)	Yes	Proposal Number	No
remarks	fin_remarks	varchar(100)	Yes	Remarks	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	Sub Analysis Code	No
batch_id	fin_guid	varchar(40)	Yes	Batch ID	No
acct_type	fin_account_type	varchar(10)	Yes	Account Type	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime(8)	varchar(30)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime(8)	varchar(30)	Yes	Modified Date	No
taxkey	fin_tcdtype	Char(10)	Yes	TaxKey	No
taxcode	fin_usageid	varchar(20)	Yes	taxcode	No
variantcode	fin_tcdtype	Char(10)	Yes	variantcode	No
taxrate	fin_designparamcode	varchar(5)	Yes	taxrate	No
taxableamount	fin_usageid	varchar(20)	Yes	taxableamount	No
taxamount	fin_tcdtype	Char(10)	Yes	taxamount	No


Table Name :	snp_template_hdr
Comment :	Sundry Payment Template Header


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	No	Organization unit id	Yes
template_no	fin_documentnumber	varchar(18)	No	Template number	Yes
tran_type	fin_transactiontype	varchar(40)	No	Transaction type	Yes
timestamp	udd_integer	varchar(40)	No	Time Stamp	No
description	fin_desc40	varchar(40)	Yes	Description	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
notype_no	fin_notypeno	varchar(10)	Yes	Note Type Number	No
request_date	datetime(8)	varchar(10)	Yes	Request date	No
rv_notype_no	fin_notypeno	varchar(10)	Yes	RVNote Type Number	No
rv_status	fin_statuscode	varchar(2)	Yes	Status	No
paydate_freq	fin_cmbflag	varchar(4)	Yes	Pay date Freq	No
start_date	datetime(8)	varchar(4)	Yes	Start Date	No
end_date	datetime(8)	varchar(4)	Yes	End Date	No
day	fin_cmbflag	varchar(4)	Yes	Day	No
option_flag	fin_cmbflag	varchar(4)	Yes	Option Flag	No
elec_payment	fin_cmbflag	varchar(4)	Yes	Electronic Payment	No
pay_method	fin_paramcode	varchar(30)	Yes	Payment Method	No
priority	fin_cmbflag	varchar(4)	Yes	Priority	No
payment_route	fin_cmbflag	varchar(4)	Yes	Payament Route	No
pay_mode	fin_param_text	varchar(255)	Yes	Payment Mode	No
pay_currency	fin_currencycode	varchar(5)	Yes	Payment Currency	No
exchange_rate	fin_exchangerate	numeric(9)	Yes	Exchange rate	No
pay_amount_bef_roff	fin_amount	numeric(13)	Yes	Payment Amount before rounding off	No
pay_amount	fin_amount	numeric(13)	Yes	Payment Amount	No
roundoff_amount	fin_amount	numeric(13)	Yes	Rounding off amount	No
bank_cash_code	fin_bankcashcode	varchar(32)	Yes	Bank Cash Code	No
payee_name	fin_payeename	varchar(40)	Yes	Payee Name	No
instr_charge	fin_cmbflag	varchar(4)	Yes	Instrument Charge	No
relpay_ou	fin_ouinstid	int(4)	Yes	Release Payment OU	No
remarks	fin_remarks	varchar(100)	Yes	Remarks	No
cap_charge	fin_cmbflag	varchar(4)	Yes	Cap Charge	No
address1	fin_txt255	varchar(255)	Yes	Address1	No
address2	fin_txt255	varchar(255)	Yes	Address2	No
address3	fin_txt255	varchar(255)	Yes	Address3	No
city	fin_city	varchar(40)	Yes	City	No
state	fin_state	varchar(40)	Yes	State	No
country	fin_country	varchar(40)	Yes	Country	No
zip_code	fin_zip	varchar(20)	Yes	Zip Code	No
contact	fin_contact	varchar(40)	Yes	Contact Number	No
url	fin_url	varchar(50)	Yes	URL	No
mail_stop	fin_mailstop	varchar(20)	Yes	Mail Stop	No
pager_no	fin_communicationid	varchar(30)	Yes	Pager Number	No
email_id	fin_email	varchar(60)	Yes	Mail ID	No
telex	fin_communicationid	varchar(30)	Yes	Telex Number	No
phone_no	fin_communicationid	varchar(30)	Yes	Phone Number	No
mobile_no	fin_communicationid	varchar(30)	Yes	Mobile Number	No
fax_no	fin_communicationid	varchar(30)	Yes	Fax Number	No
lsv_id	fin_participationid	varchar(30)	Yes	ISV ID	No
lsv_reference	fin_desc40	varchar(40)	Yes	ISV Reference	No
bank_code	fin_bankcode	varchar(32)	Yes	Bank Code	No
partid_digits	fin_number	int(4)	Yes	Part ID	No
esr_id	fin_participationid	varchar(30)	Yes	ESR ID	No
refno_digits	fin_number	int(4)	Yes	Reference Number	No
esr_reference	fin_participationid	varchar(30)	Yes	ESR reference	No
esr_amount	fin_amount	numeric(13)	Yes	ESR Amount	No
esr_code_line	fin_reference_det2	varchar(128)	Yes	Code	No
payee_accountin	fin_cmbflag	varchar(4)	Yes	payee_accountin	No
payee_bankrefno	fin_banknumber	varchar(20)	Yes	Payee Bank Reference Number	No
payee_accountcode	fin_accountcode	varchar(32)	Yes	Payee Account code	No
comp_accountin	fin_option	varchar(20)	Yes	comp_accountin	No
comp_bankref	fin_banknumber	varchar(20)	Yes	Bank Reference	No
comp_accountcode	fin_accountcode	varchar(32)	Yes	Account Code	No
template_status	fin_cmbflag	varchar(4)	Yes	Template Status	No
batch_id	fin_guid	varchar(40)	Yes	Batch ID	No
pbcexchrate	fin_exchangerate	numeric(9)	Yes	Parallel Exchange rate	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime(8)	varchar(30)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime(8)	varchar(30)	Yes	Modified Date	No


Table Name :	snp_tempvataccount_dtl
Comment :	Sundry Payment Payment Template VAT Account Detail


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	No	Organization unit id	Yes
template_no	fin_documentnumber	varchar(18)	No	Template number	Yes
account_lineno	fin_lineno	int(4)	No	Account Line Number	Yes
vat_lineno	fin_lineno	int(4)	No	VAT Line Number	Yes
tran_type	fin_transactiontype	varchar(40)	No	Transaction type	Yes
timestamp	udd_integer	varchar(40)	No	Time Stamp	No
account_code	fin_accountcode	varchar(32)	Yes	Account code	No
itemtcd_code	fin_itemcode	varchar(40)	Yes	Item TCD Code	No
itemtcd_vrnt	fin_itemcode	varchar(40)	Yes	Item Variant Code	No
vat_category	fin_vatcategory	varchar(40)	Yes	VAT Category	No
vat_class	fin_vatclass	varchar(40)	Yes	Class	No
tcd_vrnt	fin_quickcodes	varchar(25)	Yes	Variant	No
vat_rate	fin_amount	numeric(13)	Yes	Rate	No
vatdeductible_per	fin_vatdeductible	numeric(9)	Yes	Deductible Percentage	No
vat_inclusive	fin_cmbflag	varchar(4)	Yes	VAT Inclusive	No
item_amount	fin_amount	numeric(13)	Yes	Item Amount	No
tranvat_amount	fin_amount	numeric(13)	Yes	Transaction VAT Amount	No
basevat_amount	fin_amount	numeric(13)	Yes	Base VAT amount	No
batch_id	fin_guid	varchar(40)	Yes	Batch ID	No
currency	fin_currencycode	varchar(5)	Yes	Currency Code	No
vatexchange_rate	fin_exchangerate	numeric(9)	Yes	Exchange rate	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime(8)	varchar(30)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime(8)	varchar(30)	Yes	Modified Date	No


Table Name :	snp_tempvatpostings_dtl
Comment :	Sundry Payment Payment Template VAT Postings Detail


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	No	Organization unit id	Yes
template_no	fin_documentnumber	varchar(18)	No	Template number	Yes
tran_type	fin_transactiontype	varchar(40)	No	Transaction type	Yes
account_lineno	fin_lineno	int(4)	No	Account Line Number	Yes
vat_lineno	fin_lineno	int(4)	No	Line Number	Yes
vataccount_lineno	fin_sequence	int(4)	No	Account Line Number2	Yes
timestamp	udd_integer	int(4)	No	Time Stamp	No
account_type	fin_account_type	varchar(10)	Yes	Account Type	No
account_code	fin_accountcode	varchar(32)	Yes	Account code	No
drcr_flag	fin_cmbflag	varchar(4)	Yes	Debit Credit Flag	No
tranvat_amount	fin_amount	numeric(13)	Yes	Transaction Amount	No
corrtranvat_amount	fin_amount	numeric(13)	Yes	CTransaction Amount	No
basevat_amount	fin_amount	numeric(13)	Yes	Base VAT amount	No
corrbasevat_amount	fin_amount	numeric(13)	Yes	CBase VAT 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	Sub Analysis Code	No
batch_id	fin_guid	varchar(40)	Yes	Batch ID	No
currency	fin_currencycode	varchar(5)	Yes	Currency Code	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime(8)	varchar(30)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime(8)	varchar(30)	Yes	Modified Date	No


Table Name :	snp_vataccount_dtl
Comment :	Sundry Payment Payment VAT Detail


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	No	Organization unit id	Yes
voucher_type	fin_cmbflag	varchar(4)	No	Voucher type	Yes
voucher_no	fin_documentnumber	varchar(18)	No	Voucher number	Yes
tran_type	fin_transactiontype	varchar(40)	No	Transaction type	Yes
account_lineno	fin_lineno	int(4)	No	Account Line Number1	Yes
vat_lineno	fin_lineno	int(4)	No	Line Number	Yes
timestamp	udd_integer	int(4)	No	Time Stamp	No
account_code	fin_accountcode	varchar(32)	Yes	Account code	No
itemtcd_code	fin_itemcode	varchar(40)	Yes	Item TCD Code	No
itemtcd_vrnt	fin_itemcode	varchar(40)	Yes	Item Variant Code	No
vat_category	fin_vatcategory	varchar(40)	Yes	VAT Category	No
vat_class	fin_vatclass	varchar(40)	Yes	Class	No
tcd_vrnt	fin_quickcodes	varchar(25)	Yes	Variant	No
vat_rate	fin_amount	numeric(13)	Yes	Rate	No
vatdeductible_per	fin_vatdeductible	numeric(9)	Yes	Deductible Percentage	No
vat_inclusive	fin_cmbflag	varchar(4)	Yes	VAT Inclusive	No
item_amount	fin_amount	numeric(13)	Yes	Item Amount	No
tranvat_amount	fin_amount	numeric(13)	Yes	Transaction Amount	No
basevat_amount	fin_amount	numeric(13)	Yes	Base VAT amount	No
batch_id	fin_guid	varchar(40)	Yes	Batch ID	No
currency	fin_currencycode	varchar(5)	Yes	Currency Code	No
vatexchange_rate	fin_exchangerate	numeric(9)	Yes	Exchange rate	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime(8)	varchar(30)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime(8)	varchar(30)	Yes	Modified Date	No


Table Name :	snp_vatpostings_dtl
Comment :	Sundry Payment Payment VAT Postings Detail


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	No	Organization unit id	Yes
voucher_no	fin_documentnumber	varchar(18)	No	Voucher number	Yes
voucher_type	fin_cmbflag	varchar(4)	No	Voucher type	Yes
tran_type	fin_transactiontype	varchar(40)	No	Transaction type	Yes
account_lineno	fin_lineno	int(4)	No	Account Line Number1	Yes
vat_lineno	fin_lineno	int(4)	No	Line Number	Yes
vataccount_lineno	fin_sequence	int(4)	No	Account Line Number2	Yes
timestamp	udd_integer	int(4)	No	Time Stamp	No
account_type	fin_vataccounttype	varchar(40)	Yes	Account Type	No
account_code	fin_accountcode	varchar(32)	Yes	Account code	No
drcr_flag	fin_cmbflag	varchar(4)	Yes	Debit Credit Flag	No
tranvat_amount	fin_amount	numeric(13)	Yes	Transaction Amount	No
corrtranvat_amount	fin_amount	numeric(13)	Yes	CTransaction Amount	No
basevat_amount	fin_amount	numeric(13)	Yes	Base VAT amount	No
corrbasevat_amount	fin_amount	numeric(13)	Yes	CBase VAT 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	Sub Analysis Code	No
batch_id	fin_guid	varchar(40)	Yes	Batch ID	No
currency	fin_currencycode	varchar(5)	Yes	Currency Code	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime(8)	varchar(30)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime(8)	varchar(30)	Yes	Modified Date	No


Table Name :	snp_voucher_dtl
Comment :	Sundry Payment Detail


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	No	Organization unit id	Yes
voucher_no	fin_documentnumber	varchar(18)	No	Voucher number	Yes
voucher_type	fin_cmbflag	varchar(4)	No	Voucher type	Yes
account_lineno	fin_lineno	int(4)	No	Account Line Number	Yes
tran_type	fin_transactiontype	varchar(40)	No	Transaction type	Yes
timestamp	udd_integer	varchar(40)	No	Time Stamp	No
usage_id	fin_usageid	varchar(20)	Yes	Usage ID	No
account_code	fin_accountcode	varchar(32)	Yes	Account code	No
currency	fin_currencycode	varchar(5)	Yes	Currency Code	No
amount	fin_amount	numeric(13)	Yes	Amount	No
drcr_flag	fin_cmbflag	varchar(4)	Yes	Debit Credit Flag	No
base_amount	fin_amount	numeric(13)	Yes	Base Amount	No
proposal_no	fin_documentnumber	varchar(18)	Yes	Proposal Number	No
remarks	fin_txt255	varchar(255)	Yes	Remarks	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	Sub Analysis Code	No
batch_id	fin_guid	varchar(40)	Yes	Batch ID	No
acct_type	fin_account_type	varchar(10)	Yes	Account Type	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime(8)	varchar(30)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime(8)	varchar(30)	Yes	Modified Date	No
taxkey	fin_tcdtype	Char(10)	Yes	Tax Key	No


Table Name :	snp_voucher_hdr
Comment :	Sundry Payment Header


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	No	Organization unit id	Yes
voucher_no	fin_documentnumber	varchar(18)	No	Voucher number	Yes
voucher_type	fin_cmbflag	varchar(4)	No	Voucher type	Yes
tran_type	fin_transactiontype	varchar(40)	No	Transaction type	Yes
timestamp	udd_integer	varchar(40)	No	Time Stamp	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
notype_no	fin_notypeno	varchar(10)	Yes	Note Type Number	No
request_date	datetime(8)	varchar(10)	Yes	Request date	No
payee_name	fin_payeename	varchar(40)	Yes	Payee Name	No
pay_date	datetime(8)	varchar(40)	Yes	Payment Date	No
elec_payment	fin_cmbflag	varchar(4)	Yes	Electronic Payment	No
pay_currency	fin_currencycode	varchar(5)	Yes	Payment Currency	No
exchange_rate	fin_exchangerate	numeric(9)	Yes	Exchange rate	No
pay_amount_bef_roff	fin_amount	numeric(13)	Yes	Payment Amount before rounding off	No
pay_amount	fin_amount	numeric(13)	Yes	Payement Amount	No
roundoff_amount	fin_amount	numeric(13)	Yes	Rounding off amount	No
pay_method	fin_paramcode	varchar(30)	Yes	Payment Method	No
payment_route	fin_cmbflag	varchar(4)	Yes	Payment Route	No
pay_mode	fin_param_text	varchar(255)	Yes	Payment Mode	No
bank_cash_code	fin_bankcashcode	varchar(32)	Yes	Bank Cash Code	No
relpay_ou	fin_ouinstid	int(4)	Yes	Release Payment OU	No
instr_charge	fin_cmbflag	varchar(4)	Yes	Instrument Charge	No
priority	fin_cmbflag	varchar(4)	Yes	Priority	No
remarks	fin_remarks	varchar(100)	Yes	Remarks	No
hr_reason_code	fin_quickcodes	varchar(25)	Yes	Reason Code	No
hr_remarks	fin_remarks	varchar(100)	Yes	Remarks2	No
reversal_reason_code	fin_quickcodes	varchar(25)	Yes	Reversal Reason Code	No
reversal_date	datetime(8)	varchar(25)	Yes	Reversal Date	No
reversal_remarks	fin_remarks	varchar(100)	Yes	Reversal Remarks	No
address1	fin_txt255	varchar(255)	Yes	Address1	No
address2	fin_txt255	varchar(255)	Yes	Address2	No
address3	fin_txt255	varchar(255)	Yes	Address3	No
city	fin_city	varchar(40)	Yes	City	No
state	fin_state	varchar(40)	Yes	State	No
country	fin_country	varchar(40)	Yes	Country	No
zip_code	fin_zip	varchar(20)	Yes	Zip Code	No
contact	fin_contact	varchar(40)	Yes	Contact Number	No
url	fin_url	varchar(50)	Yes	URL	No
mail_stop	fin_mailstop	varchar(20)	Yes	Mail Stop	No
pager_no	fin_communicationid	varchar(30)	Yes	Pager Number	No
email_id	fin_email	varchar(60)	Yes	Email ID	No
telex	fin_communicationid	varchar(30)	Yes	Telex Number	No
phone_no	fin_communicationid	varchar(30)	Yes	Phone Number	No
mobile_no	fin_communicationid	varchar(30)	Yes	Mobile Number	No
fax_no	fin_communicationid	varchar(30)	Yes	Fax Number	No
lsv_id	fin_participationid	varchar(30)	Yes	ISV ID	No
lsv_reference	fin_desc40	varchar(40)	Yes	ISV Reference	No
bank_code	fin_bankcode	varchar(32)	Yes	Bank Code	No
partid_digits	fin_number	int(4)	Yes	Part ID	No
esr_id	fin_participationid	varchar(30)	Yes	ESR ID	No
refno_digits	fin_number	int(4)	Yes	Reference Number	No
esr_reference	fin_participationid	varchar(30)	Yes	ESR reference	No
esr_amount	fin_amount	numeric(13)	Yes	Amount	No
esr_code_line	fin_reference_det2	varchar(128)	Yes	Code	No
payee_accountin	fin_option	varchar(20)	Yes	Payee Account code	No
payee_bankrefno	fin_banknumber	varchar(20)	Yes	Bank Reference	No
payee_accountcode	fin_bankcode	varchar(32)	Yes	Payee Account code1	No
comp_accountin	fin_option	varchar(20)	Yes	Company Account	No
comp_bankref	fin_banknumber	varchar(20)	Yes	Bank Reference2	No
comp_accountcode	fin_bankcode	varchar(32)	Yes	Company Account2	No
template_no	fin_documentnumber	varchar(18)	Yes	Template number	No
cap_charge	fin_cmbflag	varchar(4)	Yes	Cap Charge	No
batch_id	fin_guid	varchar(40)	Yes	Batch ID	No
voucher_status	fin_statuscode	varchar(2)	Yes	Status	No
refdoc_no	fin_documentno	varchar(40)	Yes	Reference Number2	No
refdoc_type	fin_doctype	varchar(40)	Yes	Reference Document Type	No
pbcexchrate	fin_exchangerate	numeric(9)	Yes	Parallel Exchange rate	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime(8)	varchar(30)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime(8)	varchar(30)	Yes	Modified Date	No
tranferee_fb	fin_financebookid	varchar(20)	Yes	Finance book id2	No
tranferee_bank_code	fin_bankcode	varchar(32)	Yes	Bank Code2	No
trnsferee_erate	fin_exchangerate	numeric(9)	Yes	Transfer Exchange rate	No
printcheck_name	fin_txt150	varchar(150)	Yes	Print check name	No
receipt_amt	fin_amount	numeric(13)	Yes	receipt amount	No
comments	fin_comments	varchar(256)	Yes	Comments	No
notes	fin_notes	varchar(2000)	Yes	Notes	No
additional_remarks	fin_remarks	varchar(100)	Yes	Additional Remarks	No
snp_wf_doc_key	fin_flag	varchar(25)	Yes	Workflow Document Key	No
snp_wf_new_State	fin_txt150	varchar(150)	Yes	Workflow New State	No