COCON

Table Owner	Table Name	Table Comment	Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
dbo	cocon_bcon_parent_sum_bal	Contains summarized balances for parent companies	run_no	int	Run Number	Yes	No
			company_code	sql_variant	Company Code
			account_code		Account Code
			timestamp	int	Time Stamp	No
			finance_year	sql_variant	Finance Year
			finance_period		Finance Period
			ou_id	int	Organization Unit Id
			exchange_rate	bigint	Exchange Rate
			account_balance		Account Balance
			dr_cr_identifier	sql_variant	Debit Credit  Identifier
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	cocon_bcon_run_trn	Contains parameters for business consolidation runs	company_code	sql_variant	Company Code	Yes
			run_no		Run Number
			serial_no	int	Serial Number
			timestamp		Time Stamp	No
			finance_sgmntid	sql_variant	Finance Segment Id
			finance_sbuid		Finance Simulation Business Unit Id
			finance_year		Finance Year
			finance_period		Finance Period
			finance_bookid		Finance Book Id
			ext_enterprise_id		External Enterprise Id
			currency_code		Currency Code
			currencycode_from		Currency Code From
			error_id	int	Error Id
			run_status	sql_variant	Run Status.Values C - Completed,N-Not completed,I-In progress
			numbering_type		Numbering Type
			select_option		Select Options
			chcompany_code		Child Company Code
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	cocon_bcon_run_trn_tmp		company_code	sql_variant	Company Code	Yes
			run_no		Run Number
			serial_no	int	Serial Number
			timestamp		Time Stamp	No
			finance_structid	sql_variant	Finance Structure Id
			finance_sbuid		Finance Simulation Business Unit Id
			finance_year		Finance Year
			finance_period		Finance Period
			fb_id		Finance Book Id
			ext_enterprise_id		External Enterprise Id
			currency_code		Currency Code
			error_id	int	Error Id
			run_status	sql_variant	Run Status
			numbering_type		Numbering Type
			select_option		Select Options
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	cocon_bcon_sum_bal	Maintain company soft consolidation balances	run_no	sql_variant	Run Number	Yes
			company_code		Company Code
			finance_bookid		Finance Book Id
			account_code		Account Code
			dr_cr_identifier		Debit Credit Identifier
			timestamp	int	Time Stamp	No
			acglyhd	sql_variant	General Ledger Header
			finance_year		Finance Year
			finance_period		Finance Period
			ou_id	int	Organization Unit Id
			exchange_rate	bigint	Exchange Rate
			account_balance		Account Balance
			open_account_balance		Open Account Balance
			open_dr_cr_identifier	sql_variant	Open Debit Credit  Identifier
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	cocon_coa_dtl	Gives the details of the consolidation chart of accounts	company_code	sql_variant	Company Code	Yes
			coaid		Chart Of Account Id
			account_code		Account Code
			serial_no		Serial Number
			timestamp	int	Time Stamp	No
			account_desc	sql_variant	Acount Description
			status		Status.Values C - Completed,N-Not completed
			account_group		Account Group
			account_class		Account Class
			effective_from	datetime	Effective From
			effective_to		Effective To
			grp_account_code	sql_variant	Group Account Code
			layout_head_code		Layout head Code
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	cocon_coa_his	Gives the consolidation chart of accounts history	company_code	sql_variant	Company Code	Yes
			coaid		Chart Of Account Id
			account_code		Account Code
			serial_no	int	Serial Number
			action_time	datetime	Action Number
			timestamp	int	Time Stamp	No
			account_desc	sql_variant	Account Description
			status		Status.Values C - Completed,N-Not completed
			account_group		Account Group
			account_class		Account Class
			effective_from	datetime	Effective From
			effective_to		Effective To
			grp_account_code	sql_variant	Group Account Code
			layout_head_code		Layout Head Code
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	cocon_coa_mst	Gives the consolidation chart of accounts defined	company_code	sql_variant	Company Code	Yes
			coaid		Chart Of Account Id
			timestamp	int	Time Stamp	No
			coaid_desc	sql_variant	Chart Of Account Id Description
			fb_id		Finance Book Id
			ou_id	int	Organization Unit Id
			modified_ou		Modified Organization Unit
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	cocon_coa_tmp		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			account_code		Account Code
			account_desc		Account Description
			account_group		Account Group
			account_class		Account Class
			effective_from	datetime	Effective From
			effective_to		Effective To
			grp_account_code	sql_variant	Group Account Code
			layout_heading		Layout Heading
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	cocon_company_is_tmp		timestamp	int	Time Stamp
			cost_center	sql_variant	Cost Center
			mac_post_flag		Management Account Posting Flag
			run_no		Run Number
			batch_id		Batch Id
			tran_ou	int	Transaction Organization Unit
			component_name	sql_variant	Component Name
			finance_bookid		Finance Book Id
			account_code		Account Code
			bank_code		Back Code
			currency_code		Currency Code
			drcr_flag		Debit Credit Flag
			tran_amt	bigint	Transaction Amount
			tran_type	sql_variant	Transaction Type
			tran_date	datetime	Transaction Date
			post_amt	bigint	Post Amount
			exchange_rate		Exchange Rate
			doc_no	sql_variant	Document Number
			entry_date	datetime	Entry Date
			auth_date		Authorized Date
			narration	sql_variant	Narration
			reftran_fbid		Reference Transaction Finance Book Id
			reftran_no	bigint	Reference Transaction Number
			reftran_ou	int	Reference Transaction  Organization Unit
			reftran_type	sql_variant	Reference Transaction Type
			supcust_code		Supplier Customer Code
			item_code		Item Code
			item_variant		Item Variant
			quantity	bigint	Quantity
			uom	sql_variant	Unit Of Measurement
			posting_date	datetime	Posting Date
			company_code	sql_variant	Company Code
			bu_id		Business Unit Id
			par_base_amount	bigint	Parallel Base Amount
			par_exchange_rate		Parallel Exchange Rate
			con_ref_voucherno	sql_variant	Consolidation Reference Voucher Number
			ou_id	int	Organization Unit Id
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	cocon_convert_rate	Company consolidation convertion rate	run_no	sql_variant	Run Number	Yes
			company_code		Company Code
			option_code		Option Code
			currency_code		Currency Code
			fb_id		Finance Book Id
			option_desc		Option Description
			from_currency		From Currency
			exchgrate_typeno		Exchange Rate Type Number
			timestamp	int	Time Stamp	No
			exchange_rate	bigint	Exchange Rate
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	cocon_error_desc	Maintains error enteries in case of Offline scheduler	timestamp	int	Time Stamp
			fin_error_desc	sql_variant	Finance Error Description
			error_id		Error Id
			run_no		Run Number
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	cocon_jv_dtl	Company consolidation Journal Voucher detail information	company_code	sql_variant	Company Code	Yes
			voucher_no		Voucher Number
			fb_id		Finance Book Id
			account_code		Account Code
			timestamp	int	Time Stamp	No
			drcr_flag	sql_variant	Debit Credit Flag
			tran_currency		Transaction Currency
			base_amt	bigint	Base Amount
			par_base_amt		Parallel Base Amount
			par_exchange_rate		Parallel Exchange Rate
			remarks	sql_variant	Remarks
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	cocon_jv_hdr	Company consolidation Journal Voucher header information	company_code	sql_variant	Company Code	Yes
			voucher_no		Voucher Number
			fb_id		Finance Book Id
			timestamp	int	Time Stamp	No
			tran_date	datetime	Transaction Type
			credit_base_total	bigint	Credit Base Total
			credit_parbase_total		Credit Parallel Base Total
			debit_base_total		Debit Base Total
			debit_parbase_total		Debit Parallel Base Total
			status	sql_variant	Status.Values A-Active,I-Inactive
			remarks		Remarks
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	cocon_jv_tmp		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			voucher_no		Voucher Number
			account_code		Account Code
			drcr_flag		Debit Credit Flag
			tran_currency		Transaction Currency
			base_amt	bigint	Base Amount
			par_base_amt		Parallel Base Amount
			par_exchange_rate		Parallel Exchange Rate
			remarks	sql_variant	Remarks
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	cocon_notes_his	Contains notes history	company_code	sql_variant	Company Code	Yes
			coaid		Chart Of Account Id
			account_code		Account Code
			action_time	datetime	Action Time
			timestamp	int	Time Stamp	No
			notes	sql_variant	Notes
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	cocon_notes_mst	Contains notes information	company_code	sql_variant	Company Code	Yes
			coaid		Chart Of Account Id
			account_code		Account Code
			timestamp	int	Time Stamp	No
			notes	sql_variant	Notes
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	cocon_notes_tmp		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			notes		Notes
			stdnotesid		Standard Notes Id
			stdnotesiddesc		Standard Notes Id Description
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	cocon_post_hdr_tmp		guid	sql_variant	Guid	Yes
			timestamp	int	Time Stamp	No
			finance_bookid	sql_variant	Finance Book Id
			dest_finance_bookid		Destination Finance Book Id
			company_code		Company Code
			finance_period		Finance Period
			finance_year		Finance Year
			conbyoption		Consolidation By Option
			fin_period_range		Finance Period Range
			fin_financeyearrange		Finance Year Range
			book_type		Book Type
			sim_run_no		Simulation Run Number
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	cocon_post_run_history	Contains consolidation run history	confb_id	sql_variant	Consolidation Finance Book Id	Yes
			run_no		Run Number
			serial_no	int	Serial Number
			company_code	sql_variant	Company Code
			finance_bookid		Finance Book Id
			currency_code		Currency Code
			finance_year		Finance Year
			finance_period		Finance Period
			batch_id		Batch Id
			timestamp	int	Time Stamp	No
			login_ou		Login Organization Unit
			run_status	sql_variant	Run Status.Values C - Completed,N-Not completed
			consol_status		Consolidation Status.Values C - Completed,N-Not completed,I-In progress
			numbering_type		Numbering Type
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	cocon_posted_status	Contains consolidation status	run_no	sql_variant	Run Number	Yes
			serial_no	int	Serial Number
			company_code	sql_variant	Company Code
			finance_bookid		Finance Book Id
			confb_id		Consolidation Finance Book Id
			currency_code		Currency Code
			finance_year		Finance Year
			finance_period		Finance Period
			batch_id		Batch Id
			timestamp	int	Time Stamp	No
			parcompcode	sql_variant	Parent Company Code
			fromcurrency		From Currency
			conref_runno		Run number
			login_ou	int	Login Organization Unit
			consol_type	sql_variant	Consolidation Type
			consol_status		Consolidation Status.Values C - Completed,N-Not completed,I-In progress
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			run_status	sql_variant	Run Status.Values C - Completed,N-Not completed
	cocon_posted_status_tmp		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			serial_no	int	Serial Number
			company_code	sql_variant	Company Code
			finance_bookid		Finance Book Id
			finance_year		Finance Year
			currency_code		Currency Code
			finance_period		Finance Period
			batch_id		Batch Id
			run_no		Run Number
			login_ou	int	Login Orgnization Unit
			consol_type	sql_variant	Consolidation Type
			consol_status		Consolidation Status
			run_status		Run Status
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	cocon_postings_dtl	Company consolidation Finance Book posting information	timestamp	int	Time Stamp
			guid	sql_variant	Guid
			ou_id	int	Organization Unit Id
			component_name	sql_variant	Component Name
			company_code		Company Code
			fb_id		Finance Book Id
			bu_id		Business Unit Id
			account_code		Account Code
			drcr_flag		Debit Credit Flag
			tran_ou	int	Transaction Organization Unit
			tran_type	sql_variant	Transaction Type
			tran_date	datetime	Transaction Date
			tran_amt	bigint	Transaction Amount
			voucher_no	sql_variant	Voucher Number
			currency_code		Currency Code
			posting_date	datetime	Posting Date
			base_amt	bigint	Base Amount
			exchange_rate		Exchange Rate
			par_base_amt		Parallel Base Amount
			par_exchange_rate		Parallel Exchange Rate
			remarks	sql_variant	Remarks
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date