aurora_standard.ohotrbal

Field	Type	Null	Key	Extra
fac_no	varchar(1)	YES
acct_no	int(11)	YES
dept	varchar(3)	YES
credit	decimal(12,2)	YES
debit	decimal(12,2)	YES
doc_date	date	YES
chs_rowID	bigint(20) unsigned	NO	PRI	auto_increment

References

Local Column

References

credit

Table	Column
_1.billing_codes	bil_credit
_1.closed_periods_daily	clpd_payments_credit
_1.closed_periods_daily	clpd_adjustments_credit
_1188.billing_codes	bil_credit
_1188.closed_periods_daily	clpd_payments_credit
_1188.closed_periods_daily	clpd_adjustments_credit
_1218.billing_codes	bil_credit
_1218.closed_periods_daily	clpd_payments_credit
_1218.closed_periods_daily	clpd_adjustments_credit
_1548.billing_codes	bil_credit
_1548.closed_periods_daily	clpd_payments_credit
_1548.closed_periods_daily	clpd_adjustments_credit
_435.billing_codes	bil_credit
_435.closed_periods_daily	clpd_payments_credit
_435.closed_periods_daily	clpd_adjustments_credit
_435.ledger_running_balance	lrb_is_credit
_436.billing_codes	bil_credit
_436.closed_periods_daily	clpd_payments_credit
_436.closed_periods_daily	clpd_adjustments_credit
_436.ledger_running_balance	lrb_is_credit
_436_archive_testing.billing_codes	bil_credit
_436_archive_testing.closed_periods_daily	clpd_payments_credit
_436_archive_testing.closed_periods_daily	clpd_adjustments_credit
_436_archive_testing.ledger_running_balance	lrb_is_credit
_437.billing_codes	bil_credit
_437.closed_periods_daily	clpd_payments_credit
_437.closed_periods_daily	clpd_adjustments_credit
_437.ledger_running_balance	lrb_is_credit
_8.billing_codes	bil_credit
_8.closed_periods_daily	clpd_payments_credit
_8.closed_periods_daily	clpd_adjustments_credit
_8.daily_close_calculations	dcc_bil_credit
_81.billing_codes	bil_credit
_81.closed_periods_daily	clpd_payments_credit
_81.closed_periods_daily	clpd_adjustments_credit
_999.billing_codes	bil_credit
_999.closed_periods_daily	clpd_payments_credit
_999.closed_periods_daily	clpd_adjustments_credit
aurora_standard.chmperxd	charge_credit
aurora_standard.chmpxchd	charge_credit
aurora_standard.chpcashd	debit_credit
aurora_standard.chpempcd	ceu_credit
aurora_standard.chpinsrc	ceu_credit
aurora_standard.chrpxord	charge_credit
aurora_standard.dtgactvd	debit_credit
aurora_standard.stgactvd	debit_credit
aurora_standard.stgactvv	debit_credit
aurora_standard.stgjourd	debit_credit
aurora_standard.stgwhsed	debit_credit
aurora_standard.stitrant	debit_credit
aurora_standard.stpapckv	debit_credit
aurora_standard.stpinvcd	debit_credit
aurora_standard.strinvcd	debit_credit
aurora_standard.stxckrgd	debit_credit
aurora_standard.stxmtaxd	debit_credit
aurora_standard.stxtaxld	debit_credit

debit

Table	Column
_1.closed_periods_daily	clpd_payments_debit
_1.closed_periods_daily	clpd_adjustments_debit
_1188.closed_periods_daily	clpd_payments_debit
_1188.closed_periods_daily	clpd_adjustments_debit
_1218.closed_periods_daily	clpd_payments_debit
_1218.closed_periods_daily	clpd_adjustments_debit
_1548.closed_periods_daily	clpd_payments_debit
_1548.closed_periods_daily	clpd_adjustments_debit
_435.closed_periods_daily	clpd_payments_debit
_435.closed_periods_daily	clpd_adjustments_debit
_436.closed_periods_daily	clpd_payments_debit
_436.closed_periods_daily	clpd_adjustments_debit
_436_archive_testing.closed_periods_daily	clpd_payments_debit
_436_archive_testing.closed_periods_daily	clpd_adjustments_debit
_437.closed_periods_daily	clpd_payments_debit
_437.closed_periods_daily	clpd_adjustments_debit
_8.closed_periods_daily	clpd_payments_debit
_8.closed_periods_daily	clpd_adjustments_debit
_81.closed_periods_daily	clpd_payments_debit
_81.closed_periods_daily	clpd_adjustments_debit
_999.closed_periods_daily	clpd_payments_debit
_999.closed_periods_daily	clpd_adjustments_debit
aurora_standard.stpinvce	disc_debit_credit
aurora_standard.stpinvce	ap_debit_credit
aurora_standard.strinvce	disc_debit_credit
aurora_standard.strinvce	tax_debit_credit
aurora_standard.strinvce	frght_debit_credit
aurora_standard.strinvce	misc_debit_credit
aurora_standard.strinvce	ar_debit_credit
aurora_standard.stycntrc	offset_debit

dept

Table	Column
aurora_standard.TABLE 1424	new_dept
aurora_standard.TABLE 1425	new_dept
aurora_standard.axlscdm	gl_ip_dept
aurora_standard.axlscdm	gl_op_dept
aurora_standard.chmpchsd	rev_loc_dept
aurora_standard.chmrefnd	contr_dept
aurora_standard.chpcashr	cash_dept
aurora_standard.chpcempr	home_dept
aurora_standard.chpcntrc	educ_dept
aurora_standard.chpcntrc	cobra_cash_dept
aurora_standard.chpcntrc	cobra_bal_dept
aurora_standard.chpcntrc	cobra_fee_dept
aurora_standard.chpcobpd	cash_dept
aurora_standard.chpcobpd	bal_dept
aurora_standard.chpempcd	empl_dept
aurora_standard.chtemplr	dflt_dept
aurora_standard.chteshtv	dflt_dept
aurora_standard.chtsfdpd	shift_dept
aurora_standard.chtsupvc	supv_dept
aurora_standard.empldept	home_dept
aurora_standard.glxref	new_dept
aurora_standard.glxref	old_dept
aurora_standard.ohofadtl	depr_dept
aurora_standard.stfactvd	depr_dept
aurora_standard.stfactvv	depr_dept
aurora_standard.stfasstr	depr_dept
aurora_standard.stfasstr	accm_dept
aurora_standard.stgrowpd	rod_beg_dept
aurora_standard.stgrowpd	rod_end_dept
aurora_standard.stoinvce	td_ds_dept
aurora_standard.stoinvce	st_tx_dept
aurora_standard.stoinvce	co_tx_dept
aurora_standard.stoinvce	ci_tx_dept
aurora_standard.stoinvce	freight_dept
aurora_standard.stoinvce	asset_dept
aurora_standard.stoordrd	inv_dept
aurora_standard.stoordrd	sls_dept
aurora_standard.stoordrd	cog_dept
aurora_standard.stxcalix	medgenix_dept
aurora_standard.stxcalix	california_dept
aurora_standard.stxfinsd	fin_dept
aurora_standard.styaccrr	liab_dept
aurora_standard.styaccrr	expense_dept
aurora_standard.stydedcr	dflt_dept
aurora_standard.styemplr	home_dept
aurora_standard.styemplr	dir_dept
aurora_standard.styempod	bal_dept
aurora_standard.styinccr	dflt_dept
aurora_standard.styinccr	acru_lia_dept
aurora_standard.styoblcr	dflt_dept
aurora_standard.stypayod	bal_dept
aurora_standard.stytypod	bal_dept
common.test_codes	tco_x_lab_area_dept

acct_no

Table	Column
aurora_standard.chmcashd	non_pat_acct_no
aurora_standard.chmnbcgd	non_pat_acct_no
aurora_standard.chmnbpyd	non_pat_acct_no
aurora_standard.chmnchgd	non_pat_acct_no
aurora_standard.chmnpatr	non_pat_acct_no
aurora_standard.chmnpayd	non_pat_acct_no
aurora_standard.chmrefnd	contr_acct_no
aurora_standard.chpcashr	cash_acct_no
aurora_standard.chpcobpd	cash_acct_no
aurora_standard.chpcobpd	bal_acct_no
aurora_standard.chrcntrc	rx_inv_acct_no
aurora_standard.chrcntrc	rx_exp_acct_no
aurora_standard.curs_temp	cash_acct_no
aurora_standard.np_statm	non_pat_acct_no
aurora_standard.sticntrc	inv_acct_no
aurora_standard.sticntrc	sales_acct_no
aurora_standard.sticntrc	cog_acct_no
aurora_standard.sticntrc	adj_acct_no
aurora_standard.sticntrc	count_acct_no
aurora_standard.sticntrc	hold_acct_no
aurora_standard.stiinvtr	inv_acct_no
aurora_standard.stiinvtr	cog_acct_no
aurora_standard.stiinvtr	sales_acct_no
aurora_standard.stiinvtr	supp_acct_no
aurora_standard.stitrand	exp_acct_no
aurora_standard.stiwhser	inv_acct_no
aurora_standard.stpcntrc	ap_acct_no
aurora_standard.stpcntrc	cd_cash_acct_no
aurora_standard.stpcntrc	cd_disc_acct_no
aurora_standard.stpinvce	disc_acct_no
aurora_standard.stpinvce	ap_acct_no
aurora_standard.stpinvce	cash_acct_no
aurora_standard.stpopend	ap_acct_no
aurora_standard.stpopend	cash_acct_no
aurora_standard.stpvendr	cash_acct_no
aurora_standard.stpvendr	exp_acct_no
aurora_standard.stpvendr	hosp_acct_no
aurora_standard.strcntrc	ar_acct_no
aurora_standard.strcntrc	ar_sales_acct_no
aurora_standard.strcntrc	ar_tax_acct_no
aurora_standard.strcntrc	ar_frght_acct_no
aurora_standard.strcntrc	ar_misc_acct_no
aurora_standard.strcntrc	ar_fc_acct_no
aurora_standard.strcntrc	cr_cash_acct_no
aurora_standard.strcntrc	cr_disc_acct_no
aurora_standard.strinvce	disc_acct_no
aurora_standard.strinvce	tax_acct_no
aurora_standard.strinvce	frght_acct_no
aurora_standard.strinvce	misc_acct_no
aurora_standard.strinvce	ar_acct_no
aurora_standard.stropend	ar_acct_no
aurora_standard.stucntrc	ap_acct_no
aurora_standard.stucntrc	disc_acct_no
aurora_standard.stucntrc	frght_acct_no
aurora_standard.stucntrc	misc_acct_no
aurora_standard.stucntrc	inv_acct_no
aurora_standard.stucntrc	adj_acct_no
aurora_standard.stucntrc	prepaid_acct_no
aurora_standard.stucntrc	supp_acct_no
aurora_standard.stucntrc	cap_acct_no
aurora_standard.stucntrc	non_acct_no
aurora_standard.stucntrc	diff_acct_no
aurora_standard.stucntrc	cash_acct_no
aurora_standard.stucntrc	ret_acct_no
aurora_standard.stucntrc	ret_fee_acct_no
aurora_standard.stuinvcd	gl_acct_no
aurora_standard.stultypr	gl_acct_no
aurora_standard.stuordrd	gl_acct_no
aurora_standard.stxcurrr	ex_diff_acct_no
aurora_standard.stxfinsd	fin_acct_no
aurora_standard.stxinfor	src_acct_no
aurora_standard.stxmtaxr	ar_acct_no
aurora_standard.stxmtaxr	ar_disc_acct_no
aurora_standard.stxmtaxr	ap_acct_no
aurora_standard.stxmtaxr	ap_disc_acct_no
aurora_standard.stycntrc	co_bank_acct_no
aurora_standard.styddepd	bank_acct_no
aurora_standard.styemplr	bank_acct_no
aurora_standard.styempod	bal_acct_no
aurora_standard.stypayod	bal_acct_no
aurora_standard.stypayre	cash_acct_no
aurora_standard.stypddrd	bank_acct_no
aurora_standard.styrevsd	cash_acct_no
aurora_standard.stytypod	bal_acct_no
aurora_standard.styuimmr	ui_acct_no
aurora_standard.ttiinvtr	inv_acct_no
aurora_standard.ttiinvtr	cog_acct_no
aurora_standard.ttiinvtr	sales_acct_no
aurora_standard.ttiinvtr	supp_acct_no
aurora_standard.wkactvv	inv_acct_no

fac_no

Table	Column
aurora_standard.chmprica	prev_fac_no
aurora_standard.chmprica	cur_fac_no
aurora_standard.chpcashr	cash_fac_no
aurora_standard.chpcobpd	cash_fac_no
aurora_standard.chpcobpd	bal_fac_no
aurora_standard.chscustd	dept_fac_no
aurora_standard.chshotlr	dept_fac_no
aurora_standard.chtemplr	dflt_fac_no
aurora_standard.curs_temp	cash_fac_no
aurora_standard.curs_temp	ap_fac_no
aurora_standard.stgrowpd	rod_beg_fac_no
aurora_standard.stgrowpd	rod_end_fac_no
aurora_standard.stpcashd	dist_fac_no
aurora_standard.stpcashd	disc_fac_no
aurora_standard.stpcashe	cash_fac_no
aurora_standard.stpcntrc	cash_fac_no
aurora_standard.stpcntrc	disc_fac_no
aurora_standard.stpinvce	cash_fac_no
aurora_standard.stpopend	ap_fac_no
aurora_standard.stpopend	cash_fac_no
aurora_standard.stucntrc	cash_fac_no
aurora_standard.stuinvce	cash_fac_no
aurora_standard.stxfinsd	fin_fac_no
aurora_standard.styaccrr	liab_fac_no
aurora_standard.styaccrr	expense_fac_no
aurora_standard.styemplr	cash_fac_no
aurora_standard.stypayfd	cash_fac_no
aurora_standard.stypayod	bal_fac_no
aurora_standard.stypayre	cash_fac_no
aurora_standard.styrevsd	cash_fac_no
aurora_standard.stytyper	cash_fac_no