Journal Voucher

Journal Voucher

Table Owner	Table Name	Table Comment	Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
dbo	jv_attach_notes	Gives the details of the notes attached	ou_id	sql_variant	Organization Unit Id	Yes	No
			voucher_no		Voucher Number
			voucher_type		Voucher Type
			timestamp	int	Time Stamp	No
			attach_notes_desc	sql_variant	Attach Notes Description
			voucher_status		Voucher Status.Values FRS Fresh, FAL Failed, REJ Returned, AUT Authorised, PST Posted, REV Reversed, DEL Deleted, CON Converted
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	jv_attach_notes_hist	Gives the history of the notes attached	ou_id	sql_variant	Organization Unit Id	Yes
			voucher_no		Voucher Number
			voucher_type		Voucher Type
			serial_no	int	Serial Number
			timestamp		Time Stamp	No
			attach_notes_desc	sql_variant	Attach Notes Description
			voucher_status		Voucher Status.Values FRS Fresh FAL Failed REJ Returned AUT Authorised PST Posted REV Reversed DEL Deleted CON Converted
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	jv_cm_voucher_dtl_tmp		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			ou_id	int	Organization Unit Id
			voucher_no	sql_variant	Voucher Number
			voucher_serial_no	int	Voucher Serial Number
			account_code	sql_variant	Account Code
			drcr_flag		Debit Credit Flag
			tran_currency		Transaction Currency
			tran_amount	bigint	Transaction Amount
			exchange_rate		Exchange Rate
			par_exchange_rate		Parallel Exchange Rate
			base_amount		Base Amount
			par_base_amount		Parallel Base Amount
			remarks	sql_variant	Remarks
			costcenter_code		Cost Center Code
			analysis_code		Analysis Code
			subanal_code		Subanalysis Code
			voucher_status		Voucher Status.Values FRS Fresh, FAL Failed, REJ Returned, AUT Authorised, PST Posted, REV Reversed, DEL Deleted, CON Converted
			voucher_type		Voucher Type
			voucher_date	datetime	Voucher Date
			tran_date		Transaction Date
			mac_flag	sql_variant	Management Accounting Flag
			bu_id		Business Unit Id
			fb_id		Finance Book Id
			component_id		Component Id
			company_code		Company Code
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	jv_cm_vouchers_tmp		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			voucher_no		Voucher Number
			voucher_status		Voucher Status.Values FRS Fresh, FAL Failed, REJ Returned, AUT Authorised, PST Posted, REV Reversed, DEL Deleted, CON Converted
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	jv_compute_total_tmp		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			ou_id	int	Organization Unit Id
			voucher_no	sql_variant	Voucher Number
			voucher_serial_no	int	Voucher Serial Number
			dist_no	sql_variant	Distribution Number
			account_code		Account Code
			drcr_flag		Debit Credit Flag
			tran_currency		Transaction Currency
			tran_amount	bigint	Transaction Amount
			exchange_rate		Exchange Rate
			par_exchange_rate		Parallel Exchange Rate
			base_amount		Base Amount
			par_base_amount		Parallel Base Amount
			remarks	sql_variant	Remarks
			costcenter_code		Cost Center Code
			analysis_code		Analysis Code
			subanal_code		Subanalysis Code
			eff_from_dt	datetime	Effective From Date
			eff_to_dt		Effective To Date
			rec_vchr_tpl_no	sql_variant	Recurring Voucher Template Number
			posting_frequency		Posting Frequency
			voucher_status		Voucher Status.Values FRS Fresh, FAL Failed, REJ Returned, AUT Authorised, PST Posted, REV Reversed, DEL Deleted, CON Converted
			voucher_type		Voucher Type
			template_status		Template Status.Values FRS Fresh, CLS Close, TER Terminated, DEL Deleted, AUT Authorised
			voucher_date	datetime	Voucher Date
			tran_date		Transaction Date
			posting_date		Posting Date
			mac_flag	sql_variant	Management Accounting Flag
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			expclas	fin_Desc40	expclas
			destfb	fin_financebookid	destfb
			destaccode	fin_Accountcode	destaccode
			intfbjvno	fin_documentnumber	intfbjvno
	jv_consol_bfg_comp_mst	Gives the component - BFG mapping	timestamp	int	Time Stamp
			component	sql_variant	Component
			bfg_code		Business Function Group Code
			bfg_name		Business Function Group Name
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	jv_consol_bfg_mst		timestamp	int	Time Stamp
			company_code	sql_variant	Company Code
			bfg_code		Business Function Group Code
			bfg_name		Business Function Group Name
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	jv_distribution_setup_dtl	Gives the distribution setup details	ou_id	int	Organization Unit Id	Yes
			dist_no	sql_variant	Distribution Number
			dist_serial_no	int	Distribution Serial Number
			timestamp		Time Stamp	No
			account_code	sql_variant	Account Code
			drcr_flag		Debit Credit Flag
			tran_currency		Transaction Currency
			percentage	bigint	Percentage
			costcenter_code	sql_variant	Cost Center Code
			analysis_code		Analysis Code
			subanal_code		Subanalysis Code
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	jv_distribution_setup_hdr	Gives the distribution setup header information	ou_id	int	Organization Unit Id	Yes
			dist_no	sql_variant	Distribution Number
			timestamp	int	Time Stamp	No
			dist_desc	sql_variant	Distribution Description
			numbering_type		Numbering Type
			fb_id		Finance Book Id
			dist_status		Distribution Status.Values A Active,I Inactive
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	jv_fb_is_tran_post_tmp		guid	sql_variant	Guid
			ou_id	int	Organization Unit Id
			voucher_no	sql_variant	Voucher Number
			voucher_serial_no	int	Voucher Serial Number
			timestamp		Time Stamp
			voucher_type	sql_variant	Voucher Type
			voucher_date	datetime	Voucher Date
			fb_id	sql_variant	Finance Book Id
			account_code		Account Code
			drcr_flag		Debit Credit Flag
			tran_currency		Transaction Currency
			tran_amount	bigint	Transaction Amount
			exchange_rate		Exchange Rate
			base_amount		Base Amount
			remarks	sql_variant	Remarks
			costcenter_code		Cost Center Code
			analysis_code		Analysis Code
			subanal_code		Subanalysis Code
			par_exchange_rate	bigint	Parallel Exchange Rate
			par_base_amount		Parallel Base Amount
			tran_ou	int	Transaction Organization Unit
			component_name	sql_variant	Component Name
			bank_code		Bank Code
			tran_type		Transaction Type
			bu_id		Business Unit Id
			company_code		Company Code
			tran_date	datetime	Transaction Date
			posting_date		Posting Date
			mac_flag	sql_variant	Management Accounting Flag
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			ref_tran_no	sql_variant	reftranno
			ref_tran_ou	sql_variant	reference tran ou
			ref_tran_fbid	sql_variant	Reference tran no's FB id
	jv_material_dtl_tmp		jv_guid	sql_variant	Journal Voucher Guid
			jv_co_order_no		Journal Voucher Customer Order Order Number
			jv_co_currency		Journal Voucher Customer Order Currency
			jv_invoice_basic		Journal Voucher Basic
			jv_exect_doc_type		Journal Voucher Execution Document Type
			jv_execut_doc_no		Journal Voucher Execute Document Number
			jv_task_no		Journal Voucher Task Number
			jv_task_status		Journal Voucher Task Status.Values A Active,I Inactive
			jv_part_no		Journal Voucher Part Number
			jv_UOM		Journal Voucher Unit Of Measurement
			jv_Quoted_Qty	bigint	Journal Voucher Quoted By
			jv_actual_qty		Journal Voucher Actual Quantity
			jv_billable_qty		Journal Voucher Billable Quantity
			jv_billable_rate_qty		Journal Voucher Billable Rate Quantity
			jv_material_revenue_trn		Journal Voucher Material Revenue Transaction
			jv_exc_rate		Journal Voucher Exchange Rate
			jv_Material_Rev_Base		Journal Voucher Material Revenue Base
			jv_Actual_RQty_mat_Cost		Journal Voucher Required Quantity Material Cost
			jv_cust_acc_group	sql_variant	Journal Voucher Customer Account Group
			jv_customer		Journal Voucher Customer
			jv_Material_Cost	bigint	Journal Voucher Material Cost
			JV_voucher_no	sql_variant	Journal Voucher Number
	jv_numtype_num_gen_tmp		ou_id	int	Organization Unit Id	Yes
			tran_type	sql_variant	Transaction Type
			numbering_type		Numbering Type
			timestamp	int	Time Stamp	No
			serial_no	sql_variant	Serial Number
			gen_prefix		Generation Prefix
			gen_suffix		Generation Suffix
			last_gen_no		Last Generated Number
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	jv_rec_voucher_tpl_dtl	Gives the recurring voucher template details	ou_id	int	Organization Unit Id	Yes
			rec_vchr_tpl_no	sql_variant	Recurring Voucher Template Number
			rec_vchr_tpl_serial_no	int	Recurring Voucher Template Serial Number
			timestamp		Time Stamp	No
			account_code	sql_variant	Account Code
			drcr_flag		Debit Credit Flag
			tran_currency		Transaction Currency
			tran_amount	bigint	Transaction Amount
			exchange_rate		Exchange Rate
			par_exchange_rate		Parallel Exchange Rate
			par_base_amount		Parallel Base Amount
			base_amount		Base Amount
			remarks	sql_variant	Remarks
			costcenter_code		Cost Center Code
			analysis_code		Analysis Code
			subanal_code		Subanalysis Code
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	jv_rec_voucher_tpl_hdr	Gives the recurring voucher template header information	ou_id	int	Organization Unit Id	Yes
			rec_vchr_tpl_no	sql_variant	Recurring Voucher Template Number
			timestamp	int	Time Stamp	No
			eff_from_dt	datetime	Effective From Date
			eff_to_dt		Effective To Date
			tp_num_type	sql_variant	Trial Balance Numbering Type
			vchr_num_type		Voucher Number Type
			fb_id		Finance Book Id
			posting_frequency		Posting Frequency
			control_total	bigint	Control Total
			remarks	sql_variant	Remarks
			template_status		Template Status.Values FRS Fresh, CLS Close, TER Terminated, DEL Deleted, AUT Authorised
			vchr_cr_status		Voucher Credit Status.Values FRS Fresh, CLS Close, TER Terminated, DEL Deleted, AUT Authorised, FRS Fresh
			base_amount	bigint	Base Amount
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	jv_repair_order_rev_dtl_tmp		jv_guid	sql_variant	Journal Voucher Guid
			jv_co_order_no		Journal Voucher Customer Order Order Number
			jv_co_currency		Journal Voucher Customer Order Currency
			jv_reapair_ord_no		Journal Voucher Repair Order Number
			jv_qty_ordered	bigint	Journal Voucher Quantity Ordered
			jv_qty_received		Journal Voucher Quantity Received
			jv_rateqty_bill_cust		Journal Voucher Rate Quantity Billable Customer
			jv_bill_revenue_co_curr		Journal Voucher Billable Revenue Customer Order Currency
			jv_exc_rate		Journal Voucher Exchange Rate
			jv_billable_rep_rev	sql_variant	Journal Voucher Billable Repair Revenue
			jv_cust_acc_group		Journal Voucher Customer Account Group
			jv_customer		Journal Voucher Customer
			JV_voucher_no		Journal Voucher Number
	jv_resource_dtl_tmp		jv_guid		Accrual Journal Voucher Guid
			jv_co_order_no		Accrual Journal Voucher Customer Order Number
			jv_co_currency		Accrual Journal Voucher Customer Currency
			jv_invoice_basic		Accrual Journal Voucher Invoice Basic
			jv_quotation_level		Accrual Journal Voucher Quotation Level
			jv_exect_doc_type		Accrual Journal Voucher Execute Document Type
			jv_execut_doc_no		Accrual Journal Voucher Execute Document Number
			jv_task_no		Accrual Journal Voucher Task Number
			jv_task_status		Accrual Journal Voucher Task Status.Values A Active,I Inactive
			jv_estimated_hrs	bigint	Accrual Journal Voucher Estimated Hour
			jv_quoted_hrs		Accrual Journal Voucher Quoted Hours
			jv_actual_hrs_normal		Accrual Journal Voucher Hours Normal
			jv_actual_hrs_overtime		Accrual Journal Voucher Hours Overtime
			jv_billable_hrs_normal		Accrual Journal Voucher Billable Hours Normal
			jv_billable_hrs_overtime		Accrual Journal Voucher Billable Hours Overtime
			jv_billable_normal_rh		Accrual Journal Voucher Billable Hours Normal Rate Per Hour
			jv_billable_overtim_rh		Accrual Journal Voucher Billable Overtime Rate Per Hour
			jv_resource_rev_tan		Accrual Journal Voucher Resource Revenue Transaction Amount
			jv_exc_rate		Accrual Journal Voucher Exchange Rate
			jv_resource_rev_base		Accrual Journal Voucher Resource Revenue Base Amount
			jv_actual_rh_normal		Accrual Journal Voucher Actual Rate Per Hour Normal
			jv_actual_rh_overtime		Accrual Journal Voucher Actual Rate Per Hour Overtime
			jv_resource_cost		Accrual Journal Voucher Resource Cost
			jv_cust_acc_group	sql_variant	Accrual Journal Voucher Customer Account Group
			jv_customer		Accrual Journal Voucher Customer
			JV_voucher_no		Accrual Journal Voucher Number
	jv_task_level_summ_dtl_tmp		jv_guid		Accrual Journal Voucher Guid
			jv_co_order_no		Accrual Journal Voucher Customer Order Number
			jv_co_currency		Accrual Journal Voucher Customer Order Currency
			jv_invoice_basic		Accrual Journal Voucher Invoice Basic
			jv_quotation_level		Accrual Journal Voucher Quotation Level
			jv_exect_doc_type		Accrual Journal Voucher Execute Document Type
			jv_execut_doc_no		Accrual Journal Voucher Execute Document Number
			jv_task_no		Accrual Journal Voucher Task Number
			jv_task_status		Accrual Journal Voucher Task Status.Values A Active,I Inactive
			jv_material_revenue_trn	bigint	Accrual Journal Voucher Material Revenue Transaction
			jv_resource_revenue_trn		Accrual Journal Voucher Resource Revenue Transaction
			jv_Repair_Reve_Tran		Accrual Journal Voucher Repair Revenue Transaction
			jv_tot_rev_Trn		Accrual Journal Voucher Total Revenue Transaction
			jv_exc_rate		Accrual Journal Voucher Exchange Rate
			jv_Total_Rev_base		Accrual Journal Voucher Repair Revenue Base
			jv_Material_Cost		Accrual Journal Voucher Material Cost
			jv_Resource_Cost		Accrual Journal Voucher Resource Cost
			jv_total_Cost		Accrual Journal Voucher Total Cost
			jv_cust_acc_group	sql_variant	Accrual Journal Voucher Customer Account Group
			jv_customer		Accrual Journal Voucher Customer
			JV_voucher_no		Accrual Journal Voucher Number
	jv_tran_base_total_tmp		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			voucher_no		Voucher Number
			rev_voucher_no		Revenue Voucher Number
			tran_cr_amount	bigint	Transaction Credit Amount
			tran_dr_amount		Transaction Debit Amount
			base_cr_amount		Base Credit Amount
			base_dr_amount		Base Debit Amount
			prd_start_date	datetime	Period Start Date
			voucher_status	sql_variant	Voucher Status.Values FRS Fresh, FAL Failed, REJ Returned, AUT Authorised, PST Posted, REV Reversed, DEL Deleted, CON Converted
			rec_voucher_status		Recurring Voucher Status.Values FRS Fresh, FAL Failed, REJ Returned, AUT Authorised, PST Posted, REV Reversed, DEL Deleted, CON Converted
			std_notes_id		Standard Notes Id
			std_desc		Standard Notes Description
			notes_desc		Notes Description
			account_code		Account Code
			ou_id	int	Organization Unit Id
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	jv_voucher_Accr_eventfb_tmp		guid	sql_variant	Guid
			ou_id	int	Organization Unit Id
			tran_event	sql_variant	Transaction Event
			event_desc		Event Description
	jv_voucher_Accr_fbpost_tmp		guid		Guid
			voucher_no		Voucher Number
			voucher_type		Voucher Type
			account_code		Account Code
			Drcr_flag		Debit Credit Flag
			Tran_amt	bigint	Transaction Amount
			currency	sql_variant	Currency
			exch_rate	bigint	Exchange Rate
			par_exchrate		Parallel Exchange
			bas_amt		Base Amount
			par_bas_amt		Parallel Base Amount
			cost_center	sql_variant	Cost Center
			analysis		Analysis
			subanalysis		Subanalysis
			WORK_CENTER		Work Center
	jv_voucher_Accr_GET_dtl_tmp		guid		Guid
			voucher_no		Voucher Number
			voucher_date	datetime	Voucher Date
			fb_id	sql_variant	Finance Book Id
			ref_doc_type		Reference Document Type
			ref_doc_no		Reference Document Number
			currency		Currency
			material_rev	bigint	Material Revenue
			resource_rev		Resource Revenue
			repair_rev		Repair Revenue
			total_rev		Total Revenue
			exchrate		Exchange Rate
			total_rev_base		Total Revenue Base Amount
			material_cost		Material Cost
			resource_cost		Resource Cost
			total_cost		Total Cost
			total_rev_par		Total Revenue Parallel Base Currency
			total_cost_par		Total Cost Parallel Base Currency
			material_rev_bas		Material Revenue Base Amount
			resource_rev_bas		Resource Revenue Base Amount
			repair_rev_bas		Repair Revenue Base Amount
	jv_voucher_Accr_get_hdr_tmp		guid	sql_variant	Guid
			voucher_no		Voucher Number
			voucher_date	datetime	Voucher Date
			numbering_type	sql_variant	Numbering Type
			fb_id		Finance Book Id
			remarks		Remarks
			voucher_status		Voucher Status.Values FRS Fresh, FAL Failed, REJ Returned, AUT Authorised, PST Posted, REV Reversed, DEL Deleted, CON Converted
			rev_voucher_no		Revenue Voucher Number
			rev_voucher_status		Revenue Voucher Status.FRS Fresh, FAL Failed, REJ Returned, AUT Authorised, PST Posted, REV Reversed, DEL Deleted, CON Converted
			rev_numbering_type		Revenue Numbering Type
			rev_voucher_date	datetime	Revenue Voucher Date
			Accr_revenue	bigint	Accrual Revenue
			Accr_cost		Accrual Cost
			run_by	sql_variant	Run By
			run_date	datetime	Run Date
	jv_voucher_Accr_proc_hdr	Gives the process information	guid	sql_variant	Guid
			voucher_no		Voucher Number
			voucher_date	datetime	Voucher Date
			numbering_type	sql_variant	Numbering Type
			fb_id		Finance Book Id
			remarks		Remarks
			voucher_status		Voucher Status.Values FRS Fresh, FAL Failed, REJ Returned, AUT Authorised, PST Posted, REV Reversed, DEL Deleted, CON Converted
			fin_year		Finance Year
			fin_period		Finance Period
			rev_voucher_no		Revenue Voucher Number
			rev_voucher_status		Revenue Voucher Status.Values FRS Fresh FAL Failed REJ Returned AUT Authorised PST Posted REV Reversed DEL Deleted CON Converted
			rev_numbering_type		Revenue Numbering Type
			rev_voucher_date	datetime	Revenue Voucher Date
			Accr_revenue	bigint	Accrual Revenue
			Accr_cost		Accrual Cost
			run_by	sql_variant	Run By
			run_date	datetime	Run Date
	jv_voucher_accr_sumry_dtl_tmp		guid	sql_variant	Guid
			Ref_Doc_type		Reference Document Type
			ref_doc_no		Reference Document Number
			currency		Currency
			mat_rev_tran	bigint	Material Revenue Transaction
			res_rev_tran		Resource Revenue Transaction
			repair_rev_tran		Repair Revenue Transaction
			total_rev_tran		Total Revenue Transaction
			exchange_rate		Exchange Rate
			tot_rev_base_curr		Total Revenue Base Currency
			mat_cost		Material Cost
			res_cost		Resource Cost
			total_cost		Total Cost
			COST_CENTER	sql_variant	Cost Center
			WORK_CENTER		Work Center
	jv_voucher_Accr_trn_dtl	Gives the accrued voucher details	voucher_no		Voucher Number
			voucher_date	datetime	Voucher Date
			fb_id	sql_variant	Finance Book Id
			ref_doc_type		Reference Document Type
			ref_doc_no		Reference Document Number
			currency		Currency
			material_rev	bigint	Material Revenue
			resource_rev		Resource Revenue
			repair_rev		Repair Revenue
			total_rev		Total Revenue
			exchrate		Exchange Rate
			total_rev_base		Total Revenue Base
			material_cost		Material Cost
			resource_cost		Resource Cost
			total_cost		Total Cost
			material_rev_bas		Material Revenue Base Currency
			total_rev_par		Total Revenue Parallel Base Currency
			total_cost_par		Total Cost Parallel Base Currency
			resource_rev_bas		Resource Revenue Base Currency
			repair_rev_bas		Repair Revenue Base Currency
			ou_id	int	Organization Unit Id
			COST_CENTER	sql_variant	Cost Center
			WORK_CENTER		Work Center
	jv_voucher_Accr_trn_dtl_tmp		guid		Guid
			voucher_no		Voucher Number
			voucher_date	datetime	Voucher Date
			fb_id	sql_variant	Finance Book Id
			ref_doc_type		Reference Document Type
			ref_doc_no		Reference Document Number
			currency		Currency
			material_rev	bigint	Material Revenue
			resource_rev		Resource Revenue
			repair_rev		Repair Revenue
			total_rev		Total Revenue
			exchrate		Exchange Rate
			total_rev_base		Total Revenue Base
			material_cost		Material Cost
			resource_cost		Resource Cost
			total_cost		Total Cost
			total_rev_par		Total Revenue Parallel Base Amount
			total_cost_par		Total Cost Parallel Base Currency
			material_rev_bas		Material Revenue Base Currency
			resource_rev_bas		Resource Revenue Base Currency
			repair_rev_bas		Repair Revenue Base Currency
			ou_id	int	Organization Unit Id
			COST_CENTER	sql_variant	Cost Center
			WORK_CENTER		Work Center
	jv_voucher_Accr_trn_hdr	Gives the accrued voucher header information	ou_id	int	Organization Unit Id	Yes
			voucher_no	sql_variant	Voucher Number
			voucher_date	datetime	Voucher Date
			fb_id	sql_variant	Finance Book Id
			voucher_type		Voucher Number	No
			numbering_type		Numbering Type
			remarks		Remarks
			voucher_status		Voucher Status.Values FRS Fresh, FAL Failed, REJ Returned, AUT Authorised, PST Posted, REV Reversed, DEL Deleted, CON Converted
			fin_year		Finance Year
			fin_period		Finance Period
			ref_voucher_no		Reference Voucher Number
			ref_voucher_status		Reference Voucher Status.Values FRS Fresh, FAL Failed, REJ Returned, AUT Authorised, PST Posted, REV Reversed, DEL Deleted, CON Converted
			ref_numbering_type		Reference Numbering Type
			ref_voucher_date	datetime	Reference Voucher Date
			Accr_revenue	bigint	Accrual Revenue
			Accr_cost		Accrual Cost
			run_by	sql_variant	Run By
			run_date	datetime	Run Date
			timestamp	int	Time Stamp
	jv_voucher_Accr_trn_hdr_tmp		Guid	sql_variant	Guid
			voucher_no		Voucher Number
			voucher_date	datetime	Voucher Date
			numbering_type	sql_variant	Numbering Type
			fb_id		Finance Book Id
			remarks		Remarks
			voucher_status		Voucher Status.Values FRS Fresh, FAL Failed, REJ Returned, AUT Authorised, PST Posted, REV Reversed, DEL Deleted, CON Converted
			rev_voucher_no		Revenue Voucher Number
			rev_voucher_status		Revenue Voucher Status.Values FRS Fresh, FAL Failed, REJ Returned, AUT Authorised, PST Posted, REV Reversed, DEL Deleted, CON Converted
			rev_numbering_type		Revenue Numbering Type
			rev_voucher_date	datetime	Revenue Voucher Date
			Accr_revenue	bigint	Accrual Revenue
			Accr_cost		Accrual Cost
			run_by	sql_variant	Run By
			run_date	datetime	Run Date
			timestamp	int	Time Stamp
			ou_id		Organization Unit Id
			COST_CENTER	sql_variant	Cost Center
			WORK_CENTER		Work Center
	jv_voucher_trn_dtl	Gives the journal voucher details	ou_id	int	Organization Unit Id	Yes
			voucher_no	sql_variant	Voucher Number
			voucher_serial_no	int	Voucher Serial Number
			timestamp		Time Stamp	No
			account_code	sql_variant	Account Code
			drcr_flag		Debit Credit Flag
			tran_currency		Transaction Currency
			tran_amount	bigint	Transaction Amount
			exchange_rate		Exchange Rate
			par_exchange_rate		Parallel Exchage Rate
			base_amount		Base Amount
			par_base_amount		Parallel Base Amount
			remarks	sql_variant	Remarks
			costcenter_code		Cost Center Code
			analysis_code		Analysis Code
			subanal_code		Subanalysis Code
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			expclas	fin_Desc40	expclas
			destfb	fin_financebookid	destfb
			destaccode	fin_Accountcode	destaccode
			intfbjvno	fin_documentnumber	intfbjvno
	jv_voucher_trn_hdr	Gives the journal voucher header information	ou_id	int	Organization Unit Id	Yes
			voucher_no	sql_variant	Voucher Number
			timestamp	int	Time Stamp	No
			voucher_type	sql_variant	Voucher Type
			voucher_date	datetime	Voucher Date
			numbering_type	sql_variant	Numbering Type
			fb_id		Finance Book Id
			ref_voucher_no		Reference Voucher Number
			ref_voucher_type		Reference Voucher Type
			rev_year		Reversal Year
			rev_period		Reversal Period
			control_total	bigint	Control Total
			remarks	sql_variant	Remarks
			recvchrtemp_no		Reversal Voucher Temporary Number
			voucher_status		Voucher Status.Values FRS Fresh, FAL Failed, REJ Returned, AUT Authorised, PST Posted, REV Reversed, DEL Deleted, CON Converted
			converted_flag		Converted Flag
			authorised_by		Authorised By
			authorised_date	datetime	Authorised Date
			base_amount	bigint	Base Amount
			component_id	sql_variant	Component Id
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			voucher_cat	fin_desc20	voucher_cat
			jv_wf_new_state	fin_txt150	jv_wf_new_state
			jv_wf_doc_key	fin_flag	jv_wf_doc_key
			sourcejv	fin_documentno	sourcejv