Sundry Payment

Table Owner	Table Name	Table Comment	Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
dbo	snp_bank_isupdate_tmp		guid	sql_variant	Guid	Yes	No
			ou_id	int	Organization Unit Id
			document_no	sql_variant	Document Number
			timestamp	int	Time Stamp	No
			bankcash_code	sql_variant	Bank Cash Code
			currency_code		Currency Code
			pay_type		Pay Type
			amount_type		Amount Type
			tran_type		Transaction Type
			fb_id		Finance Book Id
			bankcash_amount	bigint	Bank Cash Amount
			request_date	datetime	Request Date
			component_id	sql_variant	Component Id
			user_id		User Id
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	snp_delvoucherser_tmp		batch_id	sql_variant	Batch Id	Yes
			voucher_lineno	int	Voucher Line Number
			timestamp		Time Stamp	No
			ou_id		Organization Unit Id
			voucher_no	sql_variant	Voucher Number
			voucher_type		Voucher Type
			voucher_status		Voucher Status.Values RQ-Requested,DR-Draft,FR-Fresh,RT-Returned,RV-Reversed,DT-Deleted,HD-Held,PD-Paid,VD-Void
			refdoc_no		Reference Document Number
			refdoc_type		Reference Document Type
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	snp_fapost_tmp		guid	sql_variant	Guid	Yes
			ou_id	int	Organization Unit Id
			voucher_no	sql_variant	Voucher Number
			account_lineno	int	Account Line Number
			timestamp		Time Stamp	No
			voucher_type	sql_variant	Voucher Type
			account_code		Account Code
			amount	bigint	Amount
			fb_id	sql_variant	Finance Book Id
			request_date	datetime	Request Date
			payee_name	sql_variant	Payee Name
			proposal_no		Proposal Number
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	snp_fbposting_dtl	Table that maintains the posting level info and Amounts for each Transaction numbers	batch_id	sql_variant	Batch Id	Yes
			ou_id	int	Organization Unit Id
			document_no	sql_variant	Document Number
			account_lineno	int	Account Line Number
			account_code	sql_variant	Account Code
			timestamp	int	Time Stamp	No
			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
			tran_type	sql_variant	Transaction Type
			tran_date	datetime	Transaction Date
			posting_date		Posting Date
			drcr_flag	sql_variant	Debit Credit Flag
			currency_code		Currency Code
			tran_amount	bigint	Transaction Amount
			base_amount		Base Amount
			exchange_rate		Exchange Rate
			par_base_amount		Parallel Base Amount
			par_exchange_rate		Parallel Exchange Rate
			analysis_code	sql_variant	Analysis Code
			subanalysis_code		Subanalysis Code
			cost_center		Cost Center
			mac_post_flag		Management Accounting Post Flag
			acct_type		Accounting Type
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	snp_genvoucher_tmp		batch_id	sql_variant	Batch Id	Yes
			voucher_lineno	int	Voucher Line Number
			timestamp		Time Stamp	No
			ou_id		Organization Unit Id
			fb_id	sql_variant	Finance Book Id
			voucher_type		Voucher Type
			voucher_no		Voucher Number
			request_date	datetime	Request Date
			payee_name	sql_variant	Payee Name
			pay_date	datetime	Payment Date
			pay_currency	sql_variant	Payment Currency
			exchange_rate	bigint	Exchange Rate
			pay_amount		Payment Amount
			payment_route	sql_variant	Payment Route
			pay_mode		Payment Mode
			instr_charge		Instrument Charge
			priority		Priority
			voucher_status		Voucher Status.Values RQ-Requested,DR-Draft,FR-Fresh,RT-Returned,RV-Reversed,DT-Deleted,HD-Held,PD-Paid,VD-Void
			refdoc_no		Reference Number
			refdoc_type		Reference Document Type
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	snp_genvoucheracct_tmp		batch_id	sql_variant	Batch Id	Yes
			voucher_lineno	int	Voucher Line Number
			account_lineno		Account Line Number
			timestamp		Time Stamp	No
			usage_id	sql_variant	Usage Id
			account_code		Account Code
			currency		Currency
			amount	bigint	Amount
			base_amount		Base Amount
			drcr_flag	sql_variant	Debit Credit Flag
			cost_center		Cost Center
			analysis_code		Analysis Code
			subanalysis_code		Subanalysis Code
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	snp_genvoucherbank_tmp		batch_id	sql_variant	Batch Id	Yes
			voucher_lineno	int	Voucher Line Number
			timestamp		Time Stamp	No
			ou_id		Organization Unit Id
			fb_id	sql_variant	Finance Book Id
			bank_cash_code		Bank Cash Code
			pay_amount	bigint	Payment Amount
			pay_currency	sql_variant	Payment Currency
			pay_date	datetime	Payment Date
			tran_type	sql_variant	Transaction Type
			voucher_no		Voucher Number
			voucher_type		Voucher Type
			voucher_status		Voucher Status.Values RQ-Requested,DR-Draft,FR-Fresh,RT-Returned,RV-Reversed,DT-Deleted,HD-Held,PD-Paid,VD-Void
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	snp_genvoucherhr_tmp		batch_id	sql_variant	Batch Id	Yes
			voucher_lineno	int	Voucher Line Number
			timestamp		Time Stamp	No
			ou_id		Organization Unit Id
			fb_id	sql_variant	Finance Book Id
			pay_amount	bigint	Payment Amount
			pay_currency	sql_variant	Payment Currency
			pay_date	datetime	Payment Date
			payment_route	sql_variant	Payment Route
			pay_mode		Payment Mode
			account_code		Account Code
			cost_center		Cost Center
			analysis_code		Analysis Code
			subanalysis_code		Subanalysis Code
			tran_type		Transaction Type
			voucher_no		Voucher Number
			voucher_type		Voucher Type
			voucher_status		Voucher Status.Values RQ-Requested,DR-Draft,FR-Fresh,RT-Returned,RV-Reversed,DT-Deleted,HD-Held,PD-Paid,VD-Void
			refdoc_no		Reference Document Number
			refdoc_type		Reference Document Type
			payee_name		Payee Name
			address		Address
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	snp_is_notes_tmp		guid	sql_variant	Guid	Yes
			timestamp	int	Time Stamp	No
			st_notes_id	sql_variant	Standard Notes Id
			st_notes_desc		Standard Notes Description
			notes		Notes
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	snp_notes_dtl	Table that contains the notes and comments details for the Document number	ou_id	int	Organization Unit Id	Yes
			voucher_no	sql_variant	Voucher Number
			voucher_type		Voucher Type
			tran_type		Transaction Type
			notes_for		Notes For
			notes_level		Notes Level
			line_no	int	Line Number
			timestamp		Time Stamp	No
			notes	sql_variant	Notes
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	snp_processparameter_his	Process parameter table history table	ou_id	int	Organization Unit Id	Yes
			parameter_type	sql_variant	Parameter Type
			parameter_category		Parameter Category
			parameter_code		Parameter Code
			actiontime	datetime	Action Time
			timestamp	int	Time Stamp	No
			paramater_text	sql_variant	Parameter Text
			extension_flag		Extension Flag
			actionflag		Action Flag
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	snp_template_dtl	Table contains the usage id and account codes for each recurring templete vouchers	ou_id	int	Organization Unit Id	Yes
			template_no	sql_variant	Template Number
			account_lineno	int	Account Line Number
			tran_type	sql_variant	Transaction Type
			timestamp	int	Time Stamp	No
			usage_id	sql_variant	Usage Id
			account_code		Account Code
			currency		Currency
			amount	bigint	Amount
			drcr_flag	sql_variant	Debit Credit
			base_amount	bigint	Base Amount
			proposal_no	sql_variant	Proposal Number
			remarks		Remarks
			cost_center		Cost Center
			analysis_code		Analysis Code
			subanalysis_code		Subanalysis Code
			batch_id		Batch Id
			acct_type		Account Type
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	snp_template_hdr	Table contains the document number and status and bankcodes for each recurring sundry vouchers	ou_id	int	Organization Unit Id	Yes
			template_no	sql_variant	Template Number
			tran_type		Transaction Type
			timestamp	int	Time Stamp	No
			description	sql_variant	Description
			fb_id		Finance Book Id
			notype_no		Payment Voucher Numbering Type
			request_date	datetime	Request Date
			rv_notype_no	sql_variant	Reversal Voucher Numbering Type
			rv_status		Reversal Voucher Status.Values RQ-Requested,DR-Draft,FR-Fresh,RT-Returned,RV-Reversed,DT-Deleted,HD-Held,PD-Paid,VD-Void
			paydate_freq		Payment Date Frequency
			start_date	datetime	Start Date
			end_date		End Date
			day	sql_variant	Day
			option_flag		Option Flag
			elec_payment		Electron Payment
			pay_method		Payment Method
			priority		Priority
			payment_route		Payment Route
			pay_mode		Payment Mode
			pay_currency		Payment Currency
			exchange_rate	bigint	Exchange Rate
			pay_amount_bef_roff		Pay Amount Before Round Off
			pay_amount		Payment Amount
			roundoff_amount		Round Off Amount
			bank_cash_code	sql_variant	Bank Cash Code
			payee_name		Payee Name
			instr_charge		Instrument Charge
			relpay_ou	int	Release Payment Organization Unit
			remarks	sql_variant	Remarks
			cap_charge		Capitalization Charge
			address1		Address 1
			address2		Address 2
			address3		Address 3
			city		City
			state		State
			country		Country
			zip_code		Zip Code
			contact		Contact
			url		Universal Resource Locator
			mail_stop		Mail Stop
			pager_no		Pager Number
			email_id		Email Id
			telex		Telex
			phone_no		Phone Number
			mobile_no		Mobile Number
			fax_no		Fax Number
			lsv_id		LSV Id
			lsv_reference		LSV Reference
			bank_code		Bank Code
			partid_digits	int	Part Id Digits
			esr_id	sql_variant	ESR Id
			refno_digits	int	Reference Number Digits
			esr_reference	sql_variant	ESR Reference
			esr_amount	bigint	ESR Amount
			esr_code_line	sql_variant	ESR Code Line
			payee_accountin		Payee Account Information
			payee_bankrefno		Payee Bank Reference Number
			payee_accountcode		Payee Account Code
			comp_accountin		Company Account Information
			comp_bankref		Company Bank Reference
			comp_accountcode		Company Account Code
			template_status		Template Status.Values A-Active,I-Inactive
			batch_id		Batch Id
			pbcexchrate	bigint	Parallel Base Currency Exchange
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	snp_template_tmp		ou_id	int	Organization Unit Id	Yes
			guid	sql_variant	Guid
			account_lineno	int	Account Line Number
			timestamp		Time Stamp	No
			template_no	sql_variant	Template Number
			usage_id		Usage Id
			account_code		Account Code
			currency		Currency
			amount	bigint	Amount
			drcr_flag	sql_variant	Debit Credit Flag
			base_amount	bigint	Base Amount
			proposal_no	sql_variant	Proposal Number
			remarks		Remarks
			cost_center		Cost Center
			analysis_code		Analysis Code
			subanalysis_code		Subanalysis Code
			batch_id		Batch Id
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	snp_tempvataccount_dtl		ou_id	int	Organization Unit Id	Yes
			template_no	sql_variant	Template Number
			account_lineno	int	Account Line Number
			vat_lineno		Value Added Tax Line Number
			tran_type	sql_variant	Transaction Type
			timestamp	int	Time Stamp	No
			account_code	sql_variant	Account Code
			itemtcd_code		Item Tax Charge Discount Code
			itemtcd_vrnt		Item Tax Charge Discount Variant
			vat_category		Value Added Tax Category
			vat_class		Value Added Tax Class
			tcd_vrnt		Tax Charge Discount Variant
			vat_rate	bigint	Value Added Tax Rate
			vatdeductible_per		Value Added Tax Deductible Percentage
			vat_inclusive	sql_variant	Value Added Tax Inclusive
			item_amount	bigint	Item Amount
			tranvat_amount		Transaction Value Added Tax Amount
			basevat_amount		Base Value Added Tax Amount
			batch_id	sql_variant	Batch Id
			currency		Currency
			vatexchange_rate	bigint	Value Added Tax Exchange Rate
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	snp_tempvataccount_tmp		ou_id	int	Organization Unit Id	Yes
			guid	sql_variant	Guid
			account_lineno	int	Account Line Number
			vat_lineno		Value Added Tax Line Number
			timestamp		Time Stamp	No
			template_no	sql_variant	Template Number
			account_code		Account Code
			itemtcd_code		Item Tax Charge Discount Code
			itemtcd_vrnt		Item Tax Charge Discount Variant
			vat_category		Value Added Tax Category
			vat_class		Value Added Tax Class
			tcd_vrnt		Tax Charge Discount Variant
			vat_rate	bigint	Value Added Tax Rate
			vatdeductible_per		Value Added Tax Deductible Percentage
			vat_inclusive	sql_variant	Value Added Tax Inclusive
			item_amount	bigint	Item Amount
			tranvat_amount		Transaction Value Added Tax Amount
			basevat_amount		Base Value Added Tax Amount
			batch_id	sql_variant	Batch Id
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	snp_tempvatpostings_dtl		ou_id	int	Organization Unit Id	Yes
			template_no	sql_variant	Template Number
			tran_type		Transaction Type
			account_lineno	int	Account Line Number
			vat_lineno		Value Added Tax Line Number
			vataccount_lineno		Value Added Tax Account Line Number
			timestamp		Time Stamp	No
			account_type	sql_variant	Account Type
			account_code		Account Code
			drcr_flag		Debit Credit
			tranvat_amount	bigint	Transaction Value Added Tax Amount
			corrtranvat_amount		Corrected Transaction Value Added Tax Amount
			basevat_amount		Base Value Added Tax Amount
			corrbasevat_amount		Corrected Base Value Added Tax Amount
			cost_center	sql_variant	Cost Center
			analysis_code		Analysis Code
			subanalysis_code		Subanalysis Code
			batch_id		Batch Id
			currency		Currency
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	snp_vataccount_dtl		ou_id	int	Organization Unit Id	Yes
			voucher_type	sql_variant	Voucher Type
			voucher_no		Voucher Number
			tran_type		Transaction Type
			account_lineno	int	Account Line Number
			vat_lineno		Value Added Tax Line Number
			timestamp		Time Stamp	No
			account_code	sql_variant	Account Code
			itemtcd_code		Item Tax Charge Discount Code
			itemtcd_vrnt		Item Tax Charge Discount Variant
			vat_category		Value Added Tax Category
			vat_class		Value Added Tax Class
			tcd_vrnt		Tax Charge Discount Variant
			vat_rate	bigint	Value Added Tax Rate
			vatdeductible_per		Value Added Tax Deductible Percentage
			vat_inclusive	sql_variant	Value Added Tax Inclusive
			item_amount	bigint	Item Amount
			tranvat_amount		Transaction Value Added Tax Amount
			basevat_amount		Base Value Added Tax Amount
			batch_id	sql_variant	Batch Id
			currency		Currency
			vatexchange_rate	bigint	Value Added Tax Exchange Rate
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	snp_vatitem_tmp		guid	sql_variant	Guid	Yes
			ou_id	int	Organization Unit Id
			voucher_type	sql_variant	Voucher Type
			voucher_no		Voucher Number
			item_lineno	int	Item Line Number
			timestamp		Time Stamp	No
			vat_lineno		Value Added Tax Line Number
			voucher_currency	sql_variant	Voucher Currency
			exchange_rate	bigint	Exchange Rate
			account_code	sql_variant	Account Code
			itemtcd_code		Item Tax Charge Discount Code
			itemtcd_vrnt		Item Tax Charge Discount Variant
			item_flag		Item Flag
			tcd_flag		Tax Charge Discount Flag
			vat_category		Value Added Tax Category
			vat_class		Value Added Tax Class
			vat_code		Value Added Tax Code
			vat_rate	bigint	Value Added Tax Rate
			vatdeductible_per		Value Added Tax Deductible Percentage
			vat_inclusive	sql_variant	Value Added Tax Inclusive
			mode_flag		Mode Flag
			item_amount	bigint	Item Amount
			item_value_prop		Item Value Proposed
			doc_taxamt		Document Tax Charge Discount Amount
			doc_chargeamt		Document Charge Amount
			doc_discntamt		Document Distinct Amount
			basevat_amount		Base Value Added Tax Amount
			tranvat_amount		Transaction Value Added Tax Amount
			basenonvat_amt		Other than Base Value Added Tax Amount
			trannonvat_amt		Other than Transaction Value Added Tax Amount
			vatable_flag	sql_variant	Value Added Taxable Flag
			tranvat_inclamt	bigint	Transaction Value Added Tax Included Amount
			basevat_inclamt		Base Value Added Tax Included Amount
			tranvat_exclamt		Transaction Value Added Tax Excluded Amount
			basevat_exclamt		Base Value Added Tax Excluded Amount
			trandedvat_amt		Transaction Deduction Value Added Tax Amount
			basededvat_amt		Base Deduction Value Added Tax Amount
			trannondedvat_amt		Other than Transaction Deduction Value Added Tax Amount
			basenondedvat_amt		Other than Base Deduction Value Added Tax Amount
			drcrflag	sql_variant	Debit Credit Flag
			batch_id		Batch Id
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	snp_vatpostings_dtl		ou_id	int	Organization Unit Id	Yes
			voucher_no	sql_variant	Voucher Number
			voucher_type		Voucher Type
			tran_type		Transaction Type
			account_lineno	int	Account Line Number
			vat_lineno		Value Added Tax Line Number
			vataccount_lineno		Value Added Tax Account Line Number
			timestamp		Time Stamp	No
			account_type	sql_variant	Account Type
			account_code		Account Code
			drcr_flag		Debit Credit Flag
			tranvat_amount	bigint	Transaction Value Added Tax
			corrtranvat_amount		Corrected Transaction Value Added Tax Amount
			basevat_amount		Base Value Added Tax Amount
			corrbasevat_amount		Corrected Base Value Added Tax Amount
			cost_center	sql_variant	Cost Center
			analysis_code		Analysis Code
			subanalysis_code		Subanalysis Code
			batch_id		Batch Id
			currency		Currency
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	snp_voucher_dtl	Table contains the usage id and account codes for sundry vouchers	ou_id	int	Organization Unit Id	Yes
			voucher_no	sql_variant	Voucher Number
			voucher_type		Voucher Type
			account_lineno	int	Account Line Number
			tran_type	sql_variant	Transaction Type
			timestamp	int	Time Stamp	No
			usage_id	sql_variant	Usage Id
			account_code		Account Code
			currency		Currency
			amount	bigint	Amount
			drcr_flag	sql_variant	Debit Credit
			base_amount	bigint	Base Amount
			proposal_no	sql_variant	Proposal Number
			remarks		Remarks
			cost_center		Cost Center
			analysis_code		Analysis Code
			subanalysis_code		Subanalysis Code
			batch_id		Batch Id
			acct_type		Account Type
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	snp_voucher_hdr	Table contains the document number and status and bankcodes for each sundry vouchers	ou_id	int	Organization Unit Id	Yes
			voucher_no	sql_variant	Voucher Number
			voucher_type		Voucher Type
			tran_type		Transaction Type
			timestamp	int	Time Stamp	No
			fb_id	sql_variant	Finance Book Id
			notype_no		Number Type Number
			request_date	datetime	Request Date
			payee_name	sql_variant	Payee Name
			pay_date	datetime	Payment Date
			elec_payment	sql_variant	Electronic Payment
			pay_currency		Payment Currency
			exchange_rate	bigint	Exchange Rate
			pay_amount_bef_roff		Payment Amount Before Rounding Off
			pay_amount		Payment Amount
			roundoff_amount		Round Off Amount
			pay_method	sql_variant	Payment Method
			payment_route		Payment Route
			pay_mode		Payment Mode
			bank_cash_code		Bank Cash Code
			relpay_ou	int	Release Payment Organization Unit
			instr_charge	sql_variant	Instrument Charge
			priority		Priority
			remarks		Remarks
			hr_reason_code		HR Reason Code
			hr_remarks		HR Remarks
			reversal_reason_code		Reversal Reason Code
			reversal_date	datetime	Reversal Date
			reversal_remarks	sql_variant	Reversal Remarks
			address1		Address1
			address2		Address2
			address3		Address3
			city		City
			state		State
			country		Country
			zip_code		Zip Code
			contact		Contact
			url		Uniform Resource Locator
			mail_stop		Mail Stop
			pager_no		Pager Number
			email_id		Email Id
			telex		Telex
			phone_no		Phone Number
			mobile_no		Mobile Number
			fax_no		Fax Number
			lsv_id		LSV Id
			lsv_reference		LSV Reference
			bank_code		Bank Code
			partid_digits	int	Part Id
			esr_id	sql_variant	ESR Id
			refno_digits	int	Reference Number
			esr_reference	sql_variant	ESR Reference
			esr_amount	bigint	ESR Amount
			esr_code_line	sql_variant	ESR Code Line
			payee_accountin		Payee Accounting Information
			payee_bankrefno		Payee Bank Reference Number
			payee_accountcode		Payee Account Code
			comp_accountin		Component Account Information
			comp_bankref		Component Bank Reference
			comp_accountcode		Component Account Code
			template_no		Template Number
			cap_charge		Capital Charge
			batch_id		Batch Id
			voucher_status		Voucher Status.Values RQ-Requested,DR-Draft,FR-Fresh,RT-Returned,RV-Reversed,DT-Deleted,HD-Held,PD-Paid,VD-Void
			refdoc_no		Reference Document Number
			refdoc_type		Reference Document Type
			pbcexchrate	bigint	Parallel Base Currency Exchange Rate
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			tranferee_fb	sql_variant	Tranferee Finance Book
			tranferee_bank_code		Tranferee Bank Code
	snp_voucher_tmp		ou_id	int	Organization Unit Id
			guid	sql_variant	Guid
			voucher_type		Voucher Type
			account_lineno	int	Account Line Number
			timestamp		Time Stamp
			voucher_no	sql_variant	Voucher Number
			usage_id		Usage Id
			account_code		Account Code
			currency		Currency
			amount	bigint	Amount
			drcr_flag	sql_variant	Debit Credit
			base_amount	bigint	Base Amount
			proposal_no	sql_variant	Proposal Number
			remarks		Remarks
			cost_center		Cost Center
			analysis_code		Analysis Code
			subanalysis_code		Subanalysis Code
			batch_id		Batch Id
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date