Data Dictionary -- Journal Voucher

Srl. No.	Table Name	Comment
1	Cmn_Accrual_Acctpost_Metadata	Meta Data Table for Accruals Posting
2	cmn_accrual_co_acct_summary	Accrual summary Table in customer order, work order and task level
3	cmn_accrual_extrep_detail	Accrual external repair cost and Revenue break up
4	cmn_accrual_fixprice_detail	Accruals Fixed price revenue wise split up
5	cmn_accrual_labacct_dtl	labour accrual detail table
6	cmn_accrual_material_detail	Accrual Material Detail Table
7	cmn_accrual_postings_dtl	Local Postings table for Accrual
8	cmn_accrual_resource_detail	Accrual Table for Resouce cost and Revenue
9	jv_acrd_accrual_run_dtl	To store information of accrual run detail
10	jv_acrh_accrual_run_hdr	To store information of accrual run header
11	jv_attach_notes	To store information about attach notes
12	jv_attach_notes_hist	To store history about attach notes
13	jv_consol_bfg_comp_mst	To store infromation about console bfg comp detail
14	jv_consol_bfg_mst	To store information about console bfg detail
15	jv_distribution_setup_dtl	To store distribution setup detail
16	jv_distribution_setup_hdr	To store distribution setup header
17	jv_rec_voucher_tpl_dtl	To store information of voucher tpl detail
18	jv_rec_voucher_tpl_hdr	To store information of voucher tpl header
19	jv_voucher_Accr_proc_hdr	To store information of voucher accrual header
20	jv_voucher_Accr_trn_dtl	To store information of voucher accrual transaction detail
21	jv_voucher_Accr_trn_hdr	To store information of voucher accrual transaction header
22	jv_voucher_trn_dtl	To store information of voucher transaction detail
23	jv_voucher_trn_hdr	To store information of voucher transaction header

Table Name :	Cmn_Accrual_Acctpost_Metadata
Comment :	Meta Data Table for Accruals Posting

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
apm_component	fin_component	varchar(16)	No	component name (Accruals)	Yes
apm_accrual_type	fin_trantype	varchar(40)	No	Holds Labour or Service sale Accrual	Yes
apm_row_type	fin_type	varchar(25)	No	Row type with which account type is checked	Yes
apm_row_flag	fin_flag	varchar(25)	Yes	Holds the value of the Cost like Mat, Res, Ext or Others	No
apm_dr_accounttype	fin_flag	varchar(25)	Yes	Holds metadata for Debit account type.	No
apm_dr_fbtype	fin_flag	varchar(25)	Yes	Holds metadata for Debit finance book type.	No
apm_dr_cctype	fin_flag	varchar(25)	Yes	Holds metadata for Debit cost center type.	No
apm_dr_analtype	fin_flag	varchar(25)	Yes	Holds metadata for Debit Analysis type.	No
apm_dr_subanaltype	fin_flag	varchar(25)	Yes	Holds metadata for Debit Sub-Analysis type.	No
apm_cr_accounttype	fin_flag	varchar(25)	Yes	Holds metadata for credit account type.	No
apm_cr_fbtype	fin_flag	varchar(25)	Yes	Holds metadata for credit finance book type.	No
apm_cr_cctype	fin_flag	varchar(25)	Yes	Holds metadata for credit cost center type.	No
apm_cr_analtype	fin_flag	varchar(25)	Yes	Holds metadata for credit analysis type.	No
apm_cr_subanaltype	fin_flag	varchar(25)	Yes	Holds metadata for credit sub analysis type.	No
apm_line_no	fin_seqno	int(4)	Yes	Line number for the rows like serial No	No
apm_posting_id	fin_param_text	varchar(255)	Yes	Holds posting Id, with which against which metadata line posting has taken place	No

Table Name :	cmn_accrual_co_acct_summary
Comment :	Accrual summary Table in customer order, work order and task level

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	Yes	organization unit	No
fb_id	fin_financebookid	varchar(20)	Yes	finance book	No
run_no	fin_documentnumber	varchar(18)	Yes	run number	No
run_date	fin_date	datetime(8)	Yes	run date	No
run_type	fin_trantype	varchar(40)	Yes	run type	No
custorder_no	fin_documentnumber	varchar(18)	Yes	customer order number	No
refdoctype	fin_type	varchar(25)	Yes	reference document type	No
refdoc_no	fin_documentnumber	varchar(18)	Yes	reference document number	No
root_swo_no	fin_documentnumber	varchar(18)	Yes	root shop work order number	No
task_trackid	fin_seqno	int(4)	Yes	task track id	No
task_code	fin_workunitcode	varchar(30)	Yes	task code	No
swo_wc_code	fin_workcenter	varchar(80)	Yes	shop work order work center code	No
co_wc_code	fin_workcenter	varchar(80)	Yes	customer order work center code	No
task_exec_category	fin_quickcodes	varchar(25)	Yes	task execution category	No
cc_flag	fin_flag	varchar(25)	Yes	cost center flag	No
mat_cost	fin_amount	numeric(13)	Yes	material cost	No
mat_rev	fin_amount	numeric(13)	Yes	material revenue	No
mat_cost_acctype	fin_accounttype	varchar(15)	Yes	material cost account type	No
mat_rev_acctype	fin_accounttype	varchar(15)	Yes	material Revenue account type	No
mat_cost_acccode	fin_accountcode	varchar(32)	Yes	material cost account code	No
mat_rev_acccode	fin_accountcode	varchar(32)	Yes	material revenue account code	No
mat_cost_cctype	fin_type	varchar(25)	Yes	material cost cost center type	No
mat_rev_cctype	fin_type	varchar(25)	Yes	material revenue cost center type	No
mat_cost_costcenter	fin_costcentercode	varchar(10)	Yes	material cost center	No
mat_rev_costcenter	fin_costcentercode	varchar(10)	Yes	material revenue cost center	No
res_cost	fin_amount	numeric(13)	Yes	resource cost	No
res_rev	fin_amount	numeric(13)	Yes	resource revenue	No
res_cost_acctype	fin_accounttype	varchar(15)	Yes	resource cost account type	No
res_rev_acctype	fin_accounttype	varchar(15)	Yes	resource revenue account type	No
res_cost_acccode	fin_accountcode	varchar(32)	Yes	resource cost account code	No
res_rev_acccode	fin_accountcode	varchar(32)	Yes	resource revenue account code	No
res_cost_cctype	fin_type	varchar(25)	Yes	resource cost center type	No
res_rev_cctype	fin_type	varchar(25)	Yes	resource revenue cost center type	No
res_cost_costcenter	fin_costcentercode	varchar(10)	Yes	resource cost cost center	No
res_rev_costcenter	fin_costcentercode	varchar(10)	Yes	resource revenue cost center	No
oth_cost	fin_amount	numeric(13)	Yes	others cost	No
oth_rev	fin_amount	numeric(13)	Yes	others revenue	No
oth_cost_acctype	fin_accounttype	varchar(15)	Yes	others cost account type	No
oth_rev_acctype	fin_accounttype	varchar(15)	Yes	others revenue account type	No
oth_cost_acccode	fin_accountcode	varchar(32)	Yes	others cost account code	No
oth_rev_acccode	fin_accountcode	varchar(32)	Yes	others revenue account code	No
oth_cost_cctype	fin_type	varchar(25)	Yes	others cost cost center type	No
oth_rev_cctype	fin_type	varchar(25)	Yes	others revenue cost center type	No
oth_cost_costcenter	fin_costcentercode	varchar(10)	Yes	others cost cost center	No
oth_rev_costcenter	fin_costcentercode	varchar(10)	Yes	others revenue cost center	No
extrep_cost	fin_amount	numeric(13)	Yes	external repair cost	No
extrep_rev	fin_amount	numeric(13)	Yes	external repair revenue	No
extrep_cost_acctype	fin_accounttype	varchar(15)	Yes	external repair cost account type	No
extrep_rev_acctype	fin_accounttype	varchar(15)	Yes	external repair revenue account type	No
extrep_cost_acccode	fin_accountcode	varchar(32)	Yes	external repair cost account code	No
extrep_rev_acccode	fin_accountcode	varchar(32)	Yes	external repair revenue account code	No
extrep_cost_cctype	fin_type	varchar(25)	Yes	external repair cost cost center type	No
extrep_rev_cctype	fin_type	varchar(25)	Yes	external repair revenue cost center type	No
extrep_cost_costcenter	fin_costcentercode	varchar(10)	Yes	external repair cost center	No
extrep_rev_costcenter	fin_costcentercode	varchar(10)	Yes	external repair revenue cost cente	No
crd_param_value	_numeric_18_0	Numeric(18)	Yes	cost center return parameter value	No
order_Date	fin_date	datetime(8)	Yes	customert order date	No
order_desc	fin_notes	varchar(2000)	Yes	customer order description	No
order_appl	fin_designparamcode	varchar(5)	Yes	order applicability	No
part_app	fin_designparamcode	varchar(5)	Yes	part applicability	No
shop_jobtyp	fin_designparamcode	varchar(5)	Yes	shop job type	No
cont_unit	fin_maccost	varchar(32)	Yes	contract unit	No
saltype	fin_quickcodes	varchar(25)	Yes	sale type	No
event_ord_no	fin_documentno	varchar(40)	Yes	event order number	No
station	fin_station	varchar(40)	Yes	station	No
cust_po	fin_documentno	varchar(40)	Yes	customer order based purchase order	No
cust_po_dt	fin_date	datetime(8)	Yes	customer order based purchase order date	No
rep_prcd	fin_repairprocesscode	varchar(25)	Yes	repair process code	No
order_cat	fin_category	varchar(15)	Yes	order category	No
ac_regno	fin_acregno	varchar(30)	Yes	aircraft registration number	No
part_no	fin_partno	varchar(40)	Yes	part number	No
mfr_part_no	fin_partno	varchar(40)	Yes	manufacturer part number	No
mfr_no	fin_vendorcode	varchar(45)	Yes	manufacturer number	No
pri_wrk_ctr	fin_workcenter	varchar(80)	Yes	primary work center	No
Null	fin_workcenter	varchar(80)	Yes	Null	No
cost_ass_unit	fin_designparamcode	varchar(5)	Yes	cost assembly unit	No
part_desc	fin_txt150	varchar(150)	Yes	part description	No
prm_prt_group	fin_documentno	varchar(40)	Yes	part group	No
acimdl_model	fin_desc20	varchar(20)	Yes	aircraft model	No
cust_name	fin_custname	varchar(40)	Yes	customer name	No
custacct_grp	fin_desc20	varchar(20)	Yes	customer account group	No
ag_setoption	fin_int	int(4)	Yes	account group set option	No
exp_class	fin_desc28	varchar(28)	Yes	expense class	No
custord_curr	fin_currency	varchar(5)	Yes	customer order currency	No
cust_no	fin_customer_id	varchar(18)	Yes	customer number	No
base_curr	fin_currencycode	varchar(5)	Yes	base currency	No
exchg_rate	fin_exchangerate	numeric(9)	Yes	exchange rate	No
planning_base	fin_wccode	varchar(30)	Yes	planning base	No
field_base	fin_oucode	varchar(32)	Yes	field base	No
maintenance_base	fin_oucode	varchar(32)	Yes	maintenance base	No
reporting_station	fin_oucode	varchar(32)	Yes	reporting station	No
aircraft_ownership	fin_desc40	varchar(40)	Yes	aircraft ownership	No
component_ownership	fin_flag	varchar(25)	Yes	component ownership	No
part_classification	fin_flag	varchar(25)	Yes	part classification	No
part_category	fin_category	varchar(15)	Yes	part category	No
component_type	fin_flag	varchar(25)	Yes	component type	No
component_family	fin_componentfamilycode	varchar(25)	Yes	component family	No
fp_cost	fin_amount	numeric(13)	Yes	fixed price cost	No
fp_rev	fin_amount	numeric(13)	Yes	fixed price revenue	No
fp_cost_acctype	fin_accounttype	varchar(15)	Yes	fixed price cost account type	No
fp_rev_acctype	fin_accounttype	varchar(15)	Yes	fixed price revenue account type	No
fp_cost_acccode	fin_accountcode	varchar(32)	Yes	fixed price cost account code	No
fp_rev_acccode	fin_accountcode	varchar(32)	Yes	fixed price reveue account code	No
fp_cost_cctype	fin_type	varchar(25)	Yes	fixed price cost center type	No
fp_rev_cctype	fin_type	varchar(25)	Yes	fixed price revenue center type	No
fp_cost_costcenter	fin_costcentercode	varchar(10)	Yes	fixed price Cost- cost center	No
fp_rev_costcenter	fin_costcentercode	varchar(10)	Yes	fixed price revenue cost center	No
REPLICATION_KEY	_Bigint_8	Bigint(8)	No	replication key	Yes
mat_rev_base	fin_amount	numeric(13)	Yes	material revenue base	No
res_rev_base	fin_amount	numeric(13)	Yes	resource revenue base	No
oth_rev_base	fin_amount	numeric(13)	Yes	others revenue base	No
extrep_rev_base	fin_amount	numeric(13)	Yes	external repair revenue base	No
fp_rev_base	fin_amount	numeric(13)	Yes	fixed price revenue base	No
acc_rpt_type	fin_trantype	varchar(40)	Yes	accrual report type	No
Nonbillflag_Rev	fin_price	numeric(13)	Yes	cost or revenue flag or only revenue flag	No
acru_ard_errorlog	fin_error_desc	varchar(2000)	Yes	account code retrival error log	No
acru_crd_errorlog	fin_error_desc	varchar(2000)	Yes	cost center retrival error log	No
acru_abb_errorlog	fin_error_desc	varchar(2000)	Yes	annalysis code retrival error log	No

Table Name :	cmn_accrual_extrep_detail
Comment :	Accrual external repair cost and Revenue break up

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	Yes	organization unit	No
fb_id	fin_financebookid	varchar(20)	Yes	finance book	No
run_no	fin_documentnumber	varchar(18)	Yes	run number	No
run_date	fin_date	datetime(8)	Yes	run date	No
cust_no	fin_customer_id	varchar(18)	Yes	customer number	No
custorder_no	fin_documentnumber	varchar(18)	Yes	customer order number	No
spl_no	fin_documentno	varchar(40)	Yes	service price list number	No
spl_ou	fin_ctxt_ouinstance	int(4)	Yes	service price list organozation unit	No
spl_curr	fin_currencycode	varchar(5)	Yes	service price list currency	No
price_basis	fin_basis	varchar(8)	Yes	pricing basis	No
exchrate_date	fin_date	datetime(8)	Yes	exchange rate date	No
custorder_curr	fin_currencycode	varchar(5)	Yes	customer order currency	No
price_appliedon	fin_designparamcode	varchar(5)	Yes	price applied on	No
price_factor	fin_factor	numeric(13)	Yes	prcing factor	No
basic_value	fin_amount	numeric(13)	Yes	basic value	No
tot_value	fin_amount	numeric(13)	Yes	total value	No
price_exturr	fin_amount	numeric(13)	Yes	price extrenal currency	No
price_splcurr	fin_amount	numeric(13)	Yes	price service price list currency	No
erate_spl_co_curr	fin_exchangerate	numeric(9)	Yes	exchange rate service price list customer order currency	No
price_cocurr	fin_amount	numeric(13)	Yes	price customer order currency	No
pricing_comments	fin_notes	varchar(2000)	Yes	pricing comments	No
source_flag	fin_flag	varchar(25)	Yes	source flag	No
refdoc_curr	fin_currencycode	varchar(5)	Yes	refernce document currency	No
price_refdoc_curr	fin_exchangerate	numeric(9)	Yes	price reference document currency	No
erate_refdoc_spl_curr	fin_exchangerate	numeric(9)	Yes	exchange rate reference document service price list currency	No
exch_date	fin_date	datetime(8)	Yes	exchange date	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	replication key	Yes
ref_doc_ou	fin_ctxt_ouinstance	int(4)	Yes	referrence document	No
ref_doc_type	fin_trantype	varchar(40)	Yes	refernce document type	No
ref_doc_no	fin_documentnumber	varchar(18)	Yes	reference document number	No
run_type	fin_trantype	varchar(40)	Yes	run type	No
final_price	fin_price	numeric(13)	Yes	final price	No
ext_cost	fin_amount	numeric(13)	Yes	external cost	No
work_center	fin_workcenter	varchar(80)	Yes	work center	No
refdoctype	fin_doctype	varchar(40)	Yes	refernce document1 type	No
refdoc_no	fin_doctype	varchar(40)	Yes	reference document1 number	No
root_swo_no	fin_documentno	varchar(40)	Yes	root shop work order number	No
task_code	fin_taskno	varchar(40)	Yes	task code	No
swo_wc_code	fin_workcenter	varchar(80)	Yes	shop work order work center code	No
co_wc_code	fin_workcenter	varchar(80)	Yes	customer order work center code	No
Nonbillflag_Rev	fin_price	numeric(13)	Yes	billable flag	No
rel_error	fin_notes	varchar(2000)	Yes	release error	No

Table Name :	cmn_accrual_fixprice_detail
Comment :	Accruals Fixed price revenue wise split up

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	Yes	organization unit id	No
fb_id	fin_financebookid	varchar(20)	Yes	finance book	No
run_no	fin_documentnumber	varchar(18)	Yes	run number	No
run_date	fin_date	datetime(8)	Yes	run date	No
cust_no	fin_customer_id	varchar(18)	Yes	customer number	No
process_id	fin_lineno	int(4)	Yes	process id	No
sub_process_id	fin_lineno	int(4)	Yes	sub process id	No
custorder_no	fin_documentno	varchar(40)	Yes	customer order number	No
pricing_date	fin_date	datetime(8)	Yes	prcing date	No
custorder_curr	fin_currencycode	varchar(5)	Yes	customer order currency	No
task_no	fin_taskno	varchar(40)	Yes	task number	No
task_trackid	fin_seqno	int(4)	Yes	task track id	No
part_no	fin_partno	varchar(40)	Yes	part number	No
cnt_no	fin_documentno	varchar(40)	Yes	contract number	No
cnt_currency	fin_currencycode	varchar(5)	Yes	contract currency	No
eff_ref	fin_reference	varchar(18)	Yes	effectivity reference number	No
eff_refcode	fin_effectivitycode	varchar(40)	Yes	effectivity reference code	No
cont_lineno	fin_lineno	int(4)	Yes	contract line number	No
wbs_code	fin_quickcodes	varchar(25)	Yes	work break down structure	No
mfr_partno	fin_partno	varchar(40)	Yes	manufacturer part number	No
mfr_no	fin_vendorcode	varchar(45)	Yes	manufaturer number	No
covers_alt	fin_enum_cd	varchar(5)	Yes	covers alternative	No
mat_price	fin_price	numeric(13)	Yes	material price	No
lab_price	fin_price	numeric(13)	Yes	labourr price	No
oth_resprice	fin_price	numeric(13)	Yes	other resource price	No
tot_fixprice	fin_price	numeric(13)	Yes	total fixed price	No
pricing_notes	fin_notes	varchar(2000)	Yes	pricing notes	No
pricing_disposition	fin_notes	varchar(2000)	Yes	pricing disposition	No
fixprice_defnfor	fin_enum	varchar(40)	Yes	fixed price definition for	No
erate_cnt_co_curr	fin_exchangerate	numeric(9)	Yes	exchange rate contract customer order currency	No
mat_price_cocurr	fin_price	numeric(13)	Yes	material price customer order currency	No
lab_price_cocurr	fin_price	numeric(13)	Yes	labour price customer order currency	No
oth_resprice_cocurr	fin_price	numeric(13)	Yes	other resource price customer order currency	No
tot_fixprice_cocurr	fin_price	numeric(13)	Yes	total fixed price in customer order currency	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	replication key	Yes
run_type	fin_trantype	varchar(40)	Yes	Run type	No
final_price	fin_price	numeric(13)	Yes	Final price	No
work_center	fin_wccode	varchar(30)	Yes	work center	No
refdoctype	fin_doctype	varchar(40)	Yes	reference document type	No
refdoc_no	fin_documentno	varchar(40)	Yes	reference document number	No
root_swo_no	fin_documentno	varchar(40)	Yes	root shop work order number	No
task_code	fin_taskno	varchar(40)	Yes	task code	No
swo_wc_code	fin_workcenter	varchar(80)	Yes	shop work order work center code	No
co_wc_code	fin_workcenter	varchar(80)	Yes	customer order work center code	No
Nonbillflag_Rev	fin_price	numeric(13)	Yes	billable flag	No
rel_error	fin_notes	varchar(2000)	Yes	release error	No

Table Name :	cmn_accrual_labacct_dtl
Comment :	labour accrual detail table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	Yes	organization unit ID	No
fb_id	fin_financebookid	varchar(20)	Yes	finance book	No
run_type	fin_trantype	varchar(40)	Yes	run type	No
run_no	fin_documentnumber	varchar(18)	Yes	run number	No
run_date	fin_date	datetime(8)	Yes	run date	No
cust_no	fin_customer_id	varchar(18)	Yes	customer name	No
custorder_no	fin_documentnumber	varchar(18)	Yes	customer number	No
refdoctype	fin_type	varchar(25)	Yes	reference document type	No
refdoc_no	fin_documentnumber	varchar(18)	Yes	reference document number	No
root_swo_no	fin_documentnumber	varchar(18)	Yes	root shop work order number	No
task_trackid	fin_seqno	int(4)	Yes	task track ID	No
task_code	fin_workunitcode	varchar(30)	Yes	task code	No
swo_wc_code	fin_workcenter	varchar(80)	Yes	shop work order work center code	No
co_wc_code	fin_workcenter	varchar(80)	Yes	customer order work center code	No
task_exec_cat	fin_quickcodes	varchar(25)	Yes	task execution category	No
resource_code	fin_ctxt_user	varchar(30)	Yes	resource code	No
resource_type	fin_resourcetype	varchar(25)	Yes	resource type	No
resource_hours	fin_quantity	numeric(17)	Yes	resorce hours	No
resource_cost	fin_amount	numeric(13)	Yes	respource cost	No
resource_frmdate	fin_date	datetime(8)	Yes	resource from date	No
resource_todate	fin_date	datetime(8)	Yes	resource to date	No
booking_status	fin_status	varchar(25)	Yes	booking status	No
order_Date	fin_date	datetime(8)	Yes	order date	No
order_desc	fin_notes	varchar(2000)	Yes	order description	No
order_appl	fin_designparamcode	varchar(5)	Yes	order applicability	No
part_app	fin_designparamcode	varchar(5)	Yes	part applicability	No
shop_jobtyp	fin_designparamcode	varchar(5)	Yes	shop job type	No
cont_unit	fin_maccost	varchar(32)	Yes	contract unit	No
saltype	fin_quickcodes	varchar(25)	Yes	sale type	No
event_ord_no	fin_documentno	varchar(40)	Yes	event order number	No
station	fin_station	varchar(40)	Yes	station	No
cust_po	fin_documentno	varchar(40)	Yes	customer order based purchase order	No
cust_po_dt	fin_date	datetime(8)	Yes	customer order based purchase order PO date	No
rep_prcd	fin_repairprocesscode	varchar(25)	Yes	repair process code	No
order_cat	fin_category	varchar(15)	Yes	order category	No
ac_regno	fin_acregno	varchar(30)	Yes	aicraft registration number	No
part_no	fin_partno	varchar(40)	Yes	part number	No
mfr_part_no	fin_partno	varchar(40)	Yes	manufacturer part number	No
mfr_no	fin_vendorcode	varchar(45)	Yes	manufactured number	No
pri_wrk_ctr	fin_workcenter	varchar(80)	Yes	primary work center	No
custord_curr	fin_currencycode	varchar(5)	Yes	customer order currency	No
cost_ass_unit	fin_designparamcode	varchar(5)	Yes	cost assembly unit	No
part_desc	fin_txt150	varchar(150)	Yes	part description	No
prm_prt_group	fin_documentno	varchar(40)	Yes	part group	No
base_currency	fin_currencycode	varchar(5)	Yes	base currency	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	replication key	Yes

Table Name :	cmn_accrual_material_detail
Comment :	Accrual Material Detail Table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	Yes	Organization unit id	No
fb_id	fin_financebookid	varchar(20)	Yes	finance book id	No
run_no	fin_documentnumber	varchar(18)	Yes	Accrual Run Number	No
run_date	fin_date	datetime(8)	Yes	Run date	No
cust_no	fin_customer_id	varchar(18)	Yes	customer Number	No
custorder_no	fin_documentnumber	varchar(18)	Yes	Customer order number	No
process_id	fin_documentno	varchar(40)	Yes	Process id	No
sub_process_id	fin_seqno	int(4)	Yes	Sub process Id	No
task_trackid	fin_seqno	int(4)	Yes	task track id	No
part_seq_no	fin_seqno	int(4)	Yes	part sequence number	No
part_no	fin_partno	varchar(40)	Yes	part number	No
est_remarks	fin_notes	varchar(2000)	Yes	est remarks	No
mfr_no	fin_vendorcode	varchar(45)	Yes	manufacturer number	No
mfr_part_no	fin_partno	varchar(40)	Yes	manufacturer part number	No
Repair_Class	fin_repairclassification	varchar(25)	Yes	repair class	No
uom	fin_uom	varchar(15)	Yes	unit of measurement	No
est_qty	fin_quantity	numeric(17)	Yes	estimated quantity	No
stock_status	fin_status	varchar(25)	Yes	stock status	No
part_condition	fin_quickcodes	varchar(25)	Yes	part condition	No
confirmed_qty	fin_quantity	numeric(17)	Yes	confirmed quantity	No
pric_basis	fin_enum_cd	varchar(5)	Yes	pricing basis	No
cost	fin_amount	numeric(13)	Yes	cost	No
custord_curr	fin_currencycode	varchar(5)	Yes	cutomer order currency	No
ppl_no	fin_documentno	varchar(40)	Yes	part price list number	No
ppl_ou	fin_ctxt_ouinstance	int(4)	Yes	part price list organization unit	No
ppl_revision	fin_int	int(4)	Yes	part price list revision number	No
pricing_element	fin_desc20	varchar(20)	Yes	pricing element	No
pricing_date	fin_date	datetime(8)	Yes	pricing date	No
llp	fin_designparamcode	varchar(5)	Yes	life limited part	No
Repl_type	fin_designparamcode	varchar(5)	Yes	replacement type	No
part_type	fin_designparamcode	varchar(5)	Yes	part type	No
part_group	fin_desc40	varchar(40)	Yes	part group	No
part_class	fin_designparamcode	varchar(5)	Yes	part class	No
mfg_no	fin_vendorcode	varchar(45)	Yes	manufacturing number	No
mfg_partno	fin_partno	varchar(40)	Yes	manufacturing part number	No
part_uom	fin_uom	varchar(15)	Yes	part unit of measurement	No
factored_on	fin_designparamcode	varchar(5)	Yes	factored on	No
Ref_catalog_id	fin_quickcodes	varchar(25)	Yes	reference catalog id	No
ref_ppl_no	fin_documentno	varchar(40)	Yes	reference part price list number	No
ref_ppl_revision	fin_int	int(4)	Yes	reference part price list revision	No
ref_ppl_curr	fin_currencycode	varchar(5)	Yes	reference part price list currency	No
base_adj_fact	fin_amount	numeric(13)	Yes	base adjustment factor	No
price_fact	fin_amount	numeric(13)	Yes	price factor	No
price_facton	fin_designparamcode	varchar(5)	Yes	price factor on	No
process_seq	fin_int	int(4)	Yes	process sequence	No
dir_ppl_curr	fin_currencycode	varchar(5)	Yes	direct part price list currency	No
std_cost	fin_amount	numeric(13)	Yes	standard cost	No
price	fin_amount	numeric(13)	Yes	price	No
baseunit_rate	fin_amount	numeric(13)	Yes	base unit rate	No
adjunit_rate	fin_amount	numeric(13)	Yes	adjustment unit rate	No
ext_amt_baseval	fin_amount	numeric(13)	Yes	extrenal amount base value	No
markup	fin_amount	numeric(13)	Yes	markup	No
markup_val	fin_amount	numeric(13)	Yes	markup value	No
total_price	fin_amount	numeric(13)	Yes	total price	No
erate_co_curr	fin_exchangerate	numeric(9)	Yes	exchange rate customer order currency	No
adjunit_rate_cocurr	fin_amount	numeric(13)	Yes	adjustment unit rate customer order currency	No
ext_amt_coval	fin_amount	numeric(13)	Yes	external amount customer order curency	No
markup_cocurr	fin_amount	numeric(13)	Yes	markup in customer order currency	No
markup_val_cocurr	fin_amount	numeric(13)	Yes	mark up value in customer order currency	No
total_price_cocurr	fin_amount	numeric(13)	Yes	total price customer order currency	No
final_value	fin_amount	numeric(13)	Yes	final value	No
price_criteria	fin_flag	varchar(25)	Yes	price criteria	No
mult_criteria_match	fin_flag	varchar(25)	Yes	multi criteria match	No
matcount	fin_int	int(4)	Yes	material count	No
Price_desc	fin_notes	varchar(2000)	Yes	price description	No
price_notes	fin_notes	varchar(2000)	Yes	price notes	No
sourceflag	fin_flag	varchar(25)	Yes	source flag	No
pricing_disposition	fin_notes	varchar(2000)	Yes	pricing disposition	No
contract_no	fin_documentno	varchar(40)	Yes	contract number	No
billable	fin_designparamcode	varchar(5)	Yes	billable flag	No
updated_by	fin_ctxt_user	varchar(30)	Yes	updated by	No
updated_date	fin_date	datetime(8)	Yes	updated date	No
pricing_basis	fin_enum_cd	varchar(5)	Yes	pricing basis1	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	replication key	Yes
process_line_no	fin_lineno	int(4)	Yes	process line number	No
run_type	fin_trantype	varchar(40)	Yes	run type	No
work_center	fin_wccode	varchar(30)	Yes	work center	No
refdoctype	fin_doctype	varchar(40)	Yes	reference document type	No
refdoc_no	fin_documentno	varchar(40)	Yes	reference document number	No
root_swo_no	fin_documentno	varchar(40)	Yes	root shop workorder number	No
task_code	fin_taskno	varchar(40)	Yes	task code	No
swo_wc_code	fin_workcenter	varchar(80)	Yes	shop work order work center code	No
co_wc_code	fin_workcenter	varchar(80)	Yes	customer work order work center code	No
Nonbillflag_Rev	fin_price	numeric(13)	Yes	revenue flag	No
rel_error	fin_notes	varchar(2000)	Yes	release error	No

Table Name :	cmn_accrual_postings_dtl
Comment :	Local Postings table for Accrual

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
run_type	fin_trantype	varchar(40)	No	Accrual Run Type	Yes
tran_ou	fin_ouinstid	int(4)	No	Transaction Organization unit ID	Yes
Run_no	fin_documentnumber	varchar(18)	No	Accrual Run Number	Yes
posting_line_no	fin_lineno	int(4)	No	Posting line number	Yes
timestamp	fin_int	int(4)	Yes	timestamp of the transaction	No
line_no	fin_lineno	int(4)	Yes	line number	No
track_id	fin_tasktrackid	bigint(8)	Yes	task track id	No
company_code	fin_companycode	varchar(10)	No	company code	Yes
posting_status	fin_abbreviation	varchar(3)	Yes	posting status	No
posting_date	fin_datetime	datetime(8)	Yes	posting date	No
fb_id	fin_financebookid	varchar(20)	No	finance book	Yes
Run_date	fin_date	datetime(8)	Yes	Accrual Run date	No
account_type	fin_accounttype	varchar(15)	Yes	Account type	No
account_code	fin_accountcode	varchar(32)	No	account code	Yes
drcr_id	fin_drcridentifier	varchar(6)	No	debit credit flag	Yes
tran_currency	fin_currency	varchar(5)	Yes	transaction currenncy	No
tran_amount	fin_amount	numeric(13)	Yes	transaction amount	No
exchange_rate	fin_exchangerate	numeric(9)	Yes	exchange rate	No
base_amount	fin_amount	numeric(13)	Yes	base amount	No
par_exchange_rate	fin_exchangerate	numeric(9)	Yes	parallel exchange rate	No
par_base_amount	fin_amount	numeric(13)	Yes	parallel base amount	No
cost_center	fin_costcentercode	varchar(10)	Yes	cost senter	No
analysis_code	fin_analysiscode	varchar(5)	Yes	analysis code	No
subanalysis_code	fin_subanalysiscode	varchar(5)	Yes	sub analysis code	No
guid	fin_guid	varchar(40)	Yes	unique id	No
expclass	fin_desc40	varchar(40)	Yes	expense class	No
refdoctype_code	fin_desc5	varchar(5)	Yes	reference document type	No
refdoc_no	fin_documentno	varchar(40)	Yes	reference document number	No
item_code	fin_itemcode	varchar(40)	Yes	item code	No
item_variant	fin_itemcode	varchar(40)	Yes	item variant	No
custorder_no	fin_documentno	varchar(40)	Yes	customer order number	No
ame_no	fin_documentno	varchar(40)	Yes	aicraft maintanence execution number	No
swo_no	fin_documentno	varchar(40)	Yes	shop work order number	No
customer_id	fin_customer_id	varchar(18)	Yes	customer id	No
supplier_Id	fin_vendorcode	varchar(45)	Yes	supplier id	No
exchord_no	fin_documentno	varchar(40)	Yes	exchange order number	No
createdby	fin_ctxt_user	varchar(30)	Yes	created by	No
createddate	fin_datetime	datetime(8)	Yes	created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	modified date	No

Table Name :	cmn_accrual_resource_detail
Comment :	Accrual Table for Resouce cost and Revenue

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	Yes	organization unit	No
fb_id	fin_financebookid	varchar(20)	Yes	finance book	No
run_type	fin_trantype	varchar(40)	Yes	run type	No
run_no	fin_documentnumber	varchar(18)	Yes	Run number	No
run_date	fin_date	datetime(8)	Yes	run date	No
cust_no	fin_customer_id	varchar(18)	Yes	customer number	No
custorder_no	fin_documentnumber	varchar(18)	Yes	customer order number	No
process_id	fin_documentno	varchar(40)	Yes	process id	No
sub_process_id	fin_seqno	int(4)	Yes	sub process id	No
task_trackid	fin_seqno	int(4)	Yes	task track id	No
resource_seq_no	fin_seqno	int(4)	Yes	resource sequence number	No
resource_code	fin_ctxt_user	varchar(30)	Yes	resource code	No
resource_type	fin_resourcetype	varchar(25)	Yes	resource type	No
est_remarks	fin_notes	varchar(2000)	Yes	estimation remarks	No
warranty_reco	fin_checkflag	int(4)	Yes	warranty recommendation	No
estimated_qty	fin_quantity	numeric(17)	Yes	estimated quantity	No
estimated_uom	fin_uom	varchar(15)	Yes	estimated unit of measuremnt	No
repair_class	fin_repairclassification	varchar(25)	Yes	repair class	No
confirmed_qty	fin_quantity	numeric(17)	Yes	confirmed quantity	No
pric_basis	fin_enum_cd	varchar(5)	Yes	pricing basis	No
custord_curr	fin_currencycode	varchar(5)	Yes	customer order currency	No
spl_no	fin_documentno	varchar(40)	Yes	service price list number	No
spl_revno	fin_int	int(4)	Yes	service price list revision number	No
spl_ou	fin_ctxt_ouinstance	int(4)	Yes	service price list organization unit	No
aircraft_model	fin_model	varchar(20)	Yes	aircraft model	No
work_center	fin_workunitcode	varchar(30)	Yes	work center	No
pric_method	fin_designparamcode	varchar(5)	Yes	pricing method	No
spl_lineno	fin_int	int(4)	Yes	service price list line number	No
rate_uom	fin_uom	varchar(15)	Yes	rate unit of measuremnt	No
priceperhr_splcurr	fin_currencycode	varchar(5)	Yes	price per hour service price list currnecy	No
price_splcurr	fin_amount	numeric(13)	Yes	prcie service price list currency	No
erate_spl_co_curr	fin_exchangerate	numeric(9)	Yes	exchange rate service price list in customer order currency	No
price_cocurr	fin_amount	numeric(13)	Yes	prcie customer order currency	No
pricing_notes	fin_notes	varchar(2000)	Yes	pricing notes	No
res_desc	fin_description	varchar(100)	Yes	resource description	No
cap_flag	fin_enum_cd	varchar(5)	Yes	capital flag	No
resource_cost	fin_amount	numeric(13)	Yes	resource cost	No
billable	fin_designparamcode	varchar(5)	Yes	billable	No
inc_exc_ref_cod	fin_effectivitycode	varchar(40)	Yes	inclusion exclusion reference code	No
res_hrs_source	fin_designparamcode	varchar(5)	Yes	resoucr hours source	No
res_hrs	fin_quantity	numeric(17)	Yes	resouce hours	No
rate_perhr	fin_amount	numeric(13)	Yes	rate per hour	No
pricing_disposition	fin_notes	varchar(2000)	Yes	prcing disposition	No
updated_by	fin_ctxt_user	varchar(30)	Yes	updated by	No
updated_date	fin_date	datetime(8)	Yes	update date	No
pricing_basis	fin_enum_cd	varchar(5)	Yes	prcing basis	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	replication key	Yes
process_line_no	fin_lineno	int(4)	Yes	process line number	No
final_price	fin_amount	numeric(13)	Yes	final price	No
refdoctype	fin_doctype	varchar(40)	Yes	reference document type	No
refdoc_no	fin_documentno	varchar(40)	Yes	refernce document number	No
root_swo_no	fin_documentno	varchar(40)	Yes	root shop work order number	No
task_code	fin_taskno	varchar(40)	Yes	task code	No
swo_wc_code	fin_workcenter	varchar(80)	Yes	shop work order work center code	No
co_wc_code	fin_workcenter	varchar(80)	Yes	customer order work center code	No
Nonbillflag_Rev	fin_price	numeric(13)	Yes	billabable flag revenue	No
rel_error	fin_notes	varchar(2000)	Yes	release error	No

Table Name :	jv_acrd_accrual_run_dtl
Comment :	To store information of accrual run detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
acrd_ou_id	fin_ctxt_ouinstance	int(4)	Yes	Organization unit id	No
acrd_fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
acrd_serial_no	fin_int	int(4)	Yes	Serial number	No
acrd_company_code	fin_companycode	varchar(10)	Yes	Company code	No
acrd_acrurun_no	fin_documentno	varchar(40)	Yes	Accrual run number	No
acrd_acrurun_date	fin_date	datetime(8)	Yes	Accrual run date	No
acrd_reportrun_status	fin_status	varchar(25)	Yes	Report run status	No
acrd_report_type	fin_trantype	varchar(40)	Yes	Report type	No
acrd_exec_flag	fin_flag	varchar(25)	Yes	Execute flag	No
acrd_repfile_name	fin_txt150	varchar(150)	Yes	repfile name	No
acrd_proc_remarks	fin_txt255	varchar(255)	Yes	Process remarks	No
acrd_voucher_no	fin_documentno	varchar(40)	Yes	Voucher number	No
acrd_voucher_date	fin_date	datetime(8)	Yes	Voucher date	No
acrd_rev_voucher_no	fin_documentno	varchar(40)	Yes	Reversal voucher number	No
acrd_rev_voucher_date	fin_date	datetime(8)	Yes	Reversal voucher date	No
acrd_lkpflag	fin_status	varchar(25)	Yes	acrd_lkpflag	No
acrd_created_by	fin_ctxt_user	varchar(30)	Yes	Created by	No
acrd_created_date	fin_date	datetime(8)	Yes	Created date	No
acrd_Modified_by	fin_ctxt_user	varchar(30)	Yes	Modified by	No
acrd_Modified_date	fin_date	datetime(8)	Yes	Modified date	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes
acrd_dpkgflag	udd_designparamcode	varchar(5)	Yes	acrd_dpkgflag	No

Table Name :	jv_acrh_accrual_run_hdr
Comment :	To store information of accrual run header

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
acrh_ou_id	fin_ctxt_ouinstance	int(4)	Yes	Organization unit id	No
acrh_fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
acrh_company_code	fin_companycode	varchar(10)	Yes	Company code	No
acrh_acrurun_no	fin_documentno	varchar(40)	Yes	Accrual run number	No
acrh_acrurun_date	fin_date	datetime(8)	Yes	Accrual run date	No
acrh_schedule_type	fin_trantype	varchar(40)	Yes	Schedule type	No
acrh_status	fin_status	varchar(25)	Yes	Status	No
acrh_lkpflag	fin_status	varchar(25)	Yes	acrh_lkpflag	No
acrh_created_by	fin_ctxt_user	varchar(30)	Yes	Created by	No
acrh_created_date	fin_date	datetime(8)	Yes	Created date	No
acrh_Modified_by	fin_ctxt_user	varchar(30)	Yes	Modified by	No
acrh_Modified_date	fin_date	datetime(8)	Yes	Modified date	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	jv_attach_notes
Comment :	To store information about attach notes

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_companycode	varchar(10)	No	Organization unit id	Yes
voucher_no	fin_financebookid	varchar(20)	No	Voucher number	Yes
voucher_type	fin_calendarcode	varchar(10)	No	Voucher type	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
attach_notes_desc	fin_text2500	varchar(2500)	Yes	Attach notes description	No
voucher_status	fin_partstatus	varchar(40)	Yes	Voucher status	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	jv_attach_notes_hist
Comment :	To store history about attach notes

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_companycode	varchar(10)	No	Organization unit id	Yes
voucher_no	fin_financebookid	varchar(20)	No	Voucher number	Yes
voucher_type	fin_calendarcode	varchar(10)	No	Voucher type	Yes
serial_no	fin_int	int(4)	No	Serial number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
attach_notes_desc	fin_text2500	varchar(2500)	Yes	Attach notes description	No
voucher_status	fin_partstatus	varchar(40)	Yes	Voucher status	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	jv_consol_bfg_comp_mst
Comment :	To store infromation about console bfg comp detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	fin_int	int(4)	Yes	Timestamp	No
component	fin_component	varchar(16)	Yes	Component	No
bfg_code	fin_accountcode	varchar(32)	Yes	bfg code	No
bfg_name	fin_accountcode	varchar(32)	Yes	bfg name	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
REPLICATION_KEY	fin_datetime	datetime(8)	No	REPLICATION_KEY	Yes

Table Name :	jv_consol_bfg_mst
Comment :	To store information about console bfg detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	fin_int	int(4)	Yes	Timestamp	No
company_code	fin_companycode	varchar(10)	Yes	Company code	No
bfg_code	fin_accountcode	varchar(32)	Yes	bfg code	No
bfg_name	fin_accountcode	varchar(32)	Yes	bfg name	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	jv_distribution_setup_dtl
Comment :	To store distribution setup detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	No	Organization unit id	Yes
dist_no	fin_documentnumber	varchar(18)	No	Distribution number	Yes
dist_serial_no	fin_int	int(4)	No	Distribution serial number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
account_code	fin_accountcode	varchar(32)	Yes	Account code	No
drcr_flag	fin_drcridentifier	varchar(6)	Yes	Debit credit flag	No
tran_currency	fin_currencycode	varchar(5)	Yes	Transaction currency	No
percentage	fin_amount	numeric(13)	Yes	Percentage	No
costcenter_code	fin_costcentercode	varchar(10)	Yes	Cost center code	No
analysis_code	fin_analysiscode	varchar(5)	Yes	Analysis code	No
subanal_code	fin_subanalysiscode	varchar(5)	Yes	Subanalysis code	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	jv_distribution_setup_hdr
Comment :	To store distribution setup header

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	No	Organization unit id	Yes
dist_no	fin_documentnumber	varchar(18)	No	Distribution number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
dist_desc	fin_desc40	varchar(40)	Yes	Distribution description	No
numbering_type	fin_notypeno	varchar(10)	Yes	Numbering type	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
dist_status	fin_partstatus	varchar(40)	Yes	Distribution status	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	jv_rec_voucher_tpl_dtl
Comment :	To store information of voucher tpl detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	No	Organization unit id	Yes
rec_vchr_tpl_no	fin_documentnumber	varchar(18)	No	Record voucher tpl number	Yes
rec_vchr_tpl_serial_no	fin_int	int(4)	No	Record voucher tpl serial number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
account_code	fin_accountcode	varchar(32)	Yes	Account code	No
drcr_flag	fin_drcridentifier	varchar(6)	Yes	Debit credit flag	No
tran_currency	fin_currencycode	varchar(5)	Yes	Transaction currency	No
tran_amount	fin_amount	numeric(13)	Yes	Transaction amount	No
exchange_rate	fin_amount	numeric(13)	Yes	Exchange rate	No
par_exchange_rate	fin_exchangerate	numeric(9)	Yes	Paralllel exchange rate	No
par_base_amount	fin_amount	numeric(13)	Yes	Parallel base amount	No
base_amount	fin_amount	numeric(13)	Yes	Base amount	No
remarks	fin_text255	varchar(255)	Yes	Remarks	No
costcenter_code	fin_costcentercode	varchar(10)	Yes	Cost center code	No
analysis_code	fin_analysiscode	varchar(5)	Yes	Analysis code	No
subanal_code	fin_subanalysiscode	varchar(5)	Yes	Subanalysis code	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
expclas	fin_desc40	varchar(40)	Yes	Expire class	No
refdoctype_code	fin_desc5	varchar(5)	Yes	Reference document code	No
refdoc_no	fin_documentno	varchar(40)	Yes	Reference document number	No
custorder_no	fin_documentno	varchar(40)	Yes	Customer order number	No
ame_no	fin_documentno	varchar(40)	Yes	ame number	No
swo_no	fin_documentno	varchar(40)	Yes	swo number	No
customer_id	fin_customer_id	varchar(18)	Yes	Customer id	No
supplier_Id	fin_vendorcode	varchar(45)	Yes	Supplier id	No

Table Name :	jv_rec_voucher_tpl_hdr
Comment :	To store information of voucher tpl header

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	No	Organization unit id	Yes
rec_vchr_tpl_no	fin_documentnumber	varchar(18)	No	Record voucher tpl number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
eff_from_dt	fin_datetime	datetime(8)	Yes	Effective from date	No
eff_to_dt	fin_datetime	datetime(8)	Yes	Effective to date	No
tp_num_type	fin_notypeno	varchar(10)	Yes	tp Numbering type	No
vchr_num_type	fin_notypeno	varchar(10)	Yes	Voucher number type	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
posting_frequency	fin_postingfreqen	varchar(20)	Yes	Posting frequency	No
control_total	fin_amount	numeric(13)	Yes	Control total	No
remarks	fin_comments	varchar(256)	Yes	Remarks	No
template_status	fin_partstatus	varchar(40)	Yes	Template status	No
vchr_cr_status	fin_partstatus	varchar(40)	Yes	Voucher credit status	No
base_amount	fin_amount	numeric(13)	Yes	Base amount	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
voucher_cat	fin_desc20	varchar(20)	Yes	Voucher category	No

Table Name :	jv_voucher_Accr_proc_hdr
Comment :	To store information of voucher accrual header

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
guid	fin_guid	varchar(40)	Yes	Guid	No
voucher_no	fin_documentnumber	varchar(18)	Yes	Voucher number	No
voucher_date	fin_datetime	datetime(8)	Yes	Voucher date	No
numbering_type	fin_notypeno	varchar(10)	Yes	Numbering type	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
remarks	fin_comments	varchar(256)	Yes	Remarks	No
voucher_status	fin_partstatus	varchar(40)	Yes	Voucher status	No
fin_year	fin_calendarcode	varchar(10)	Yes	Finance year	No
fin_period	fin_calendarcode	varchar(10)	Yes	Finance period	No
rev_voucher_no	fin_documentnumber	varchar(18)	Yes	Reversal voucher number	No
rev_voucher_status	fin_partstatus	varchar(40)	Yes	Reversal voucher status	No
rev_numbering_type	fin_notypeno	varchar(10)	Yes	Reversal numbering type	No
rev_voucher_date	fin_datetime	datetime(8)	Yes	Reversal voucher date	No
Accr_revenue	fin_amount	numeric(13)	Yes	Accrual revenue	No
Accr_cost	fin_amount	numeric(13)	Yes	Accrual cost	No
run_by	ctxt_user	varchar(30)	Yes	Run by	No
run_date	fin_datetime	datetime(8)	Yes	Run date	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	jv_voucher_Accr_trn_dtl
Comment :	To store information of voucher accrual transaction detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
voucher_no	fin_documentnumber	varchar(18)	No	Voucher number	No
voucher_date	fin_datetime	datetime(8)	No	Voucher date	No
fb_id	fin_financebookid	varchar(20)	No	Finance book id	No
ref_doc_type	fin_documenttype	varchar(40)	No	Reference document type	No
ref_doc_no	fin_documentnumber	varchar(18)	No	Reference document number	No
currency	fin_currency	varchar(5)	Yes	Currency	No
material_rev	fin_amount	numeric(13)	Yes	Material reversed	No
resource_rev	fin_amount	numeric(13)	Yes	Resourse reversed	No
repair_rev	fin_amount	numeric(13)	Yes	Repair reversed	No
total_rev	fin_amount	numeric(13)	Yes	Total reversed	No
exchrate	fin_exchangerate	numeric(9)	Yes	Exchanged rate	No
total_rev_base	fin_amount	numeric(13)	Yes	Total reversed base	No
material_cost	fin_amount	numeric(13)	Yes	Material cost	No
resource_cost	fin_amount	numeric(13)	Yes	Resourse cost	No
total_cost	fin_amount	numeric(13)	Yes	Total cost	No
material_rev_bas	fin_amount	numeric(13)	Yes	Material reversed base	No
total_rev_par	fin_amount	numeric(13)	Yes	Total reversed parallel	No
total_cost_par	fin_amount	numeric(13)	Yes	Total cost parallel	No
resource_rev_bas	fin_amount	numeric(13)	Yes	Resourse reversed base	No
repair_rev_bas	fin_amount	numeric(13)	Yes	Repair reversed base	No
ou_id	fin_ouinstid	int(4)	No	Organization unit id	No
COST_CENTER	fin_costcentercode	varchar(10)	Yes	Cost center	No
WORK_CENTER	udd_wccode	varchar(30)	Yes	Work center	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	jv_voucher_Accr_trn_hdr
Comment :	To store information of voucher accrual transaction 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_date	fin_datetime	datetime(8)	No	Voucher date	Yes
voucher_type	fin_notypeno	varchar(10)	Yes	Voucher type	No
numbering_type	fin_notypeno	varchar(10)	Yes	Numbering type	No
fb_id	fin_financebookid	varchar(20)	No	Finance book id	Yes
remarks	fin_comments	varchar(256)	Yes	Remarks	No
voucher_status	fin_partstatus	varchar(40)	Yes	Voucher status	No
fin_year	fin_calendarcode	varchar(10)	Yes	Finance year	No
fin_period	fin_calendarcode	varchar(10)	Yes	Finance period	No
ref_voucher_no	fin_documentnumber	varchar(18)	Yes	Reference voucher number	No
ref_voucher_status	fin_partstatus	varchar(40)	Yes	Reference voucher status	No
ref_numbering_type	fin_notypeno	varchar(10)	Yes	Reference numbering type	No
ref_voucher_date	fin_datetime	datetime(8)	Yes	Reference voucher date	No
Accr_revenue	fin_amount	numeric(13)	Yes	Accrual revenue	No
Accr_cost	fin_amount	numeric(13)	Yes	Accrual cost	No
run_by	ctxt_user	varchar(30)	Yes	Run by	No
run_date	fin_datetime	datetime(8)	Yes	Run date	No
timestamp	fin_timestamp	int(4)	Yes	Timestamp	No

Table Name :	jv_voucher_trn_dtl
Comment :	To store information of voucher transaction 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_serial_no	fin_int	int(4)	No	Voucher serial number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
account_code	fin_accountcode	varchar(32)	Yes	Accountcode	No
drcr_flag	fin_drcridentifier	varchar(6)	Yes	Debit credit flag	No
tran_currency	fin_currencycode	varchar(5)	Yes	Transaction currency	No
tran_amount	fin_amount	numeric(13)	Yes	Transaction amount	No
exchange_rate	fin_amount	numeric(13)	Yes	Exchange rate	No
par_exchange_rate	fin_exchangerate	numeric(9)	Yes	Parallel exchange rate	No
base_amount	fin_amount	numeric(13)	Yes	Base amount	No
par_base_amount	fin_amount	numeric(13)	Yes	Parallel base amount	No
remarks	fin_text255	varchar(255)	Yes	Remarks	No
costcenter_code	fin_costcentercode	varchar(10)	Yes	Cost center code	No
analysis_code	fin_analysiscode	varchar(5)	Yes	Analysis code	No
subanal_code	fin_subanalysiscode	varchar(5)	Yes	Subanalysis code	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
expclas	fin_desc40	varchar(40)	Yes	Expire class	No
destfb	fin_financebookid	varchar(20)	Yes	Destination finance book	No
destaccode	fin_accountcode	varchar(32)	Yes	Destination account code	No
intfbjvno	fin_documentnumber	varchar(18)	Yes	intfbjvno	No
refdoctype_code	fin_desc5	varchar(5)	Yes	Reference document type code	No
refdoc_no	fin_documentno	varchar(40)	Yes	Reference document number	No
custorder_no	fin_documentno	varchar(40)	Yes	Customer order number	No
ame_no	fin_documentno	varchar(40)	Yes	ame number	No
swo_no	fin_documentno	varchar(40)	Yes	swo number	No
customer_id	fin_customer_id	varchar(18)	Yes	Customer id	No
supplier_Id	fin_vendorcode	varchar(45)	Yes	Supplier id	No

Table Name :	jv_voucher_trn_hdr
Comment :	To store information of voucher transaction 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
timestamp	fin_int	int(4)	Yes	Timestamp	No
voucher_type	fin_vouchertype	varchar(20)	Yes	Voucher type	No
voucher_date	fin_datetime	datetime(8)	Yes	Voucher date	No
numbering_type	fin_notypeno	varchar(10)	Yes	Numbering type	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
ref_voucher_no	fin_documentnumber	varchar(18)	Yes	Reference voucher number	No
ref_voucher_type	fin_vouchertype	varchar(20)	Yes	Reference voucher type	No
rev_year	fin_calendarcode	varchar(10)	Yes	Reversal year	No
rev_period	fin_calendarcode	varchar(10)	Yes	Reversal period	No
control_total	fin_amount	numeric(13)	Yes	Control total	No
remarks	fin_comments	varchar(256)	Yes	Remarks	No
recvchrtemp_no	fin_documentnumber	varchar(18)	Yes	recvchrtemp_no	No
voucher_status	fin_partstatus	varchar(40)	Yes	Voucher status	No
converted_flag	fin_eflag	varchar(1)	Yes	Converted flag	No
authorised_by	fin_ctxt_user	varchar(30)	Yes	Authorized by	No
authorised_date	fin_datetime	datetime(8)	Yes	Authorized date	No
base_amount	fin_amount	numeric(13)	Yes	Base amount	No
component_id	fin_componentshortid	varchar(20)	Yes	Component id	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
voucher_cat	fin_desc20	varchar(20)	Yes	Voucher category	No
jv_wf_doc_key	fin_flag	varchar(25)	Yes	jv_wf_doc_key	No
jv_wf_new_state	fin_txt150	varchar(150)	Yes	jv_wf_new_state	No
sourcejv	fin_documentno	varchar(40)	Yes	sourcejv	No