CRev

Table Owner	Table Name	Table Comment	Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
dbo	cisi_acct_info_dtl_tmp		guid	sql_variant	Guid	No	No
			tran_ou	int	Transaction Organization Unit
			tran_type	sql_variant	Tranaction Type
			tran_no		Transaction Number
			line_no	int	Line Number
			company_code	sql_variant	Company Code
			fb_id		Finance Book Id
			account_code		Account Code
			drcr_flag		Debit Credit Flag
			component_id		Component Id
			txnou_id	int	Transaction Organization Unit Id
			bu_id	sql_variant	Business Unit Id
			tran_date	datetime	Transaction Date
			custsupp_code	sql_variant	Customer Supplier Code
			acct_currency		Account Currency
			TtlTranAmt	bigint	Total Transaction Amount
			TtlBaseAmt		Total Base Amount
			TtlPrlBaseAmt		Total Parallel Base Amount
			auth_date	datetime	Authorized Date
			posting_date		Posting Date
	crev_account_control_tmp		ou_id	int	Organization Unit	Yes
			fb_id	sql_variant	Finance Book Id
			account_code		Account Code
			year_code		Year Code
			period_code		Period Code
			run_flag		Run Flag
			voucher_no		Voucher Number
			timestamp	int	Time Stamp	No
			currency_code	sql_variant	Currency Code
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	crev_attach_notes	Gives the details of the notes attached	ou_id	sql_variant	Organization Unit Id	Yes
			voucher_no		Voucher Number
			timestamp	int	Time Stamp	No
			attach_notes_desc	sql_variant	Attach Notes Description
			voucher_status		Voucher Status.Values Rev-reversed,Aut-Authorized.
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	crev_attach_notes_hist	Gives the history of the notes attached	ou_id	sql_variant	Orgnization Unit Id	Yes
			voucher_no		Voucher Number
			serial_no	int	Serial Number
			timestamp		Time Stamp	No
			attach_notes_desc	sql_variant	Attach Notes Description
			voucher_status		Voucher Status.Values Rev-reversed,Aut-Authorzied.
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	crev_fb_is_tran_post_tmp		guid	sql_variant	Guid	Yes
			ou_id	int	Organization Unit Id
			voucher_no	sql_variant	Voucher Number
			voucher_serial_no	int	Voucher Serial Number
			timestamp		Time Stamp	No
			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 Account Flag
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	crev_hdr_tmp		timestamp	int	Time Stamp
			fb_id	sql_variant	Finance Book Id
			currency_code		Currency Code
			year_code		Year Code
			period_code		Period Code
			account_group		Account Group
			guid		Guid
			simul_no		Simulation Number
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	crev_rep_simuldtl_tmp		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			voucher_no		Voucher Number
			account_code		Account Code
			exchange_rate	bigint	Exchange Rate
			base_balance		Base Balance
			rev_base_balance		Reverse Base Balance
			exchgl_base		Exchange General Ledger base
			exchgl_baseper		Exchange General Ledger base Per
			base_drcr	sql_variant	Base Debit Credit
			pbase_balance	bigint	Parallel Base Balance
			rev_pbase_balance		Reverse Parallel Base Balance
			exchgl_pbase		Exchange General Ledger Parallel Base
			exchgl_pbaseper		Exchange General Ledger Parallel Base Per
			pbase_drcr	sql_variant	Parallel Base Debit Credit
			account_balance	bigint	Account Balance
			par_exchange_rate		Parallel Exchange Rate
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	crev_rep_simulhdr_tmp		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			voucher_no		Voucher Number
			account_code		Account Code
			start_date	datetime	Start Date
			end_date		End Date
			acc_curr	sql_variant	Account Currency
			account_desc		Account Description
			ou_id	int	Organization Unit Id
			run_flag	sql_variant	Run Flag
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			voucher_date		Voucher Date
	crev_voucher_compute_tmp		timestamp	int	Time Stamp
			ou_id		Organization Unit Id
			voucher_no	sql_variant	Voucher Number
			serial_no	int	Serial Number
			account_code	sql_variant	Account Code
			exchange_rate	bigint	Exchange Rate
			base_balance		Base Balance
			rev_base_balance		Reverse Base Balance
			exchgl_base		Exchange General Ledger Parallel Base
			exchgl_baseper		Exchange General Ledger Parallel Base Per
			base_drcr	sql_variant	Base Debit Credit
			pbase_balance	bigint	Parallel Base Balance
			rev_pbase_balance		Reverse Parallel Base Balance
			exchgl_pbase		Exchange General Ledger Parallel Base
			exchgl_pbaseper		Exchange General Ledger Parallel Base Per
			pbase_drcr	sql_variant	Parallel Base Debit Credit
			account_balance	bigint	Account Balance
			costcenter_code	sql_variant	Cost Center Code
			analysis_code		Analysis Code
			subanal_code		Subanalysis Code
			remarks		Remarks
			par_exchange_rate	bigint	Parallel Exchange Rate
			guid	sql_variant	Guid
			std_id		Standard Id
			std_desc		Standard Description
			std_notes		Standard Notes
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	crev_voucher_compute_tmp_Recmp		timestamp	int	Time Stamp
			ou_id		Organization Unit Id
			voucher_no	sql_variant	Voucher Number
			serial_no	int	Serial Number
			account_code	sql_variant	Account Code
			exchange_rate	bigint	Exchange Rate
			base_balance		Base Balance
			rev_base_balance		Reverse Base Balance
			exchgl_base		Exchange General Ledger base
			exchgl_baseper		Exchange General Ledger Base Per
			base_drcr	sql_variant	Base Debit Credit
			pbase_balance	bigint	Parallel Base Balance
			rev_pbase_balance		Reverse Parallel Base Balance
			exchgl_pbase		Exchange General Ledger Parallel Base
			exchgl_pbaseper		Exchange General Ledger Parallel Base Per
			pbase_drcr	sql_variant	Parallel Base Debit Credit
			account_balance	bigint	Account Balance
			costcenter_code	sql_variant	Cost Center Code
			analysis_code		Analysis Code
			subanal_code		Subanalysis Code
			remarks		Remarks
			par_exchange_rate	bigint	Parallel Exchange Rate
			guid	sql_variant	Guid
			std_id		Standard Id
			std_desc		Standard Description
			std_notes		Standard Notes
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	crev_voucher_trn_dtl	Gives the voucher details	ou_id	int	Organization Unit	Yes
			voucher_no	sql_variant	Voucher Number
			voucher_serial_no	int	Voucher Serial Number
			timestamp		Time Stamp	No
			account_code	sql_variant	Account Code
			exchange_rate	bigint	Exchange Rate
			base_balance		Base Balance
			rev_base_balance		Reverse Base Balance
			exchgl_base		Exchange General Ledger base
			exchgl_baseper		Exchange General Ledger base Per
			base_drcr	sql_variant	Base Debit Credit
			pbase_balance	bigint	Parallel Base Balance
			rev_pbase_balance		Reverse Parallel Base Balance
			exchgl_pbase		Exchange Parallel Base Balance
			exchgl_pbaseper		Exchange Parallel Base Balance Per
			pbase_drcr	sql_variant	Parallel Base Debit Credit
			account_balance	bigint	Account Balance
			costcenter_code	sql_variant	Cost Center Code
			analysis_code		Analysis Code
			subanal_code		Subanalysis Code
			remarks		Remarks
			par_exchange_rate	bigint	Parallel Exchange Rate
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	crev_voucher_trn_hdr	Gives the header information	ou_id	int	Organization Unit	Yes
			voucher_no	sql_variant	Voucher Number
			timestamp	int	Time Stamp	No
			year_code	sql_variant	Year Code
			period_code		Period Code
			run_flag		Run Flag
			voucher_status		Voucher Status.Values AUT-Authorized,REV-Reversed,RVL-Reversal
			voucher_date	datetime	Voucher Date
			numbering_type	sql_variant	Numbering Type
			fb_id		Finance Book Id
			currency_code		Currency Code
			rev_voucher_no		Reverse Voucher No
			rev_voucher_date	datetime	Reverse Voucher Number
			rev_numbering_type	sql_variant	Reverse Numbering Type
			rev_year		Reverse Year
			rev_period		Reverse Period
			remarks		Remarks
			ref_voucher_no		Reference Voucher Number
			simul_no		Simulation Number
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date