aurora_standard.chmbalhc

Field Type Null Default Key Extra Comment
fac_no varchar(3) YES
prime_name varchar(40) YES
close_date date YES
cutoff_date date YES
item_date date YES
cash_date date YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
close_date
TableColumn
_1.closed_periodsclp_close_date
_1.closed_periods_dailyclpd_close_date
_1188.closed_periodsclp_close_date
_1188.closed_periods_dailyclpd_close_date
_1218.closed_periodsclp_close_date
_1218.closed_periods_dailyclpd_close_date
_1548.closed_periodsclp_close_date
_1548.closed_periods_dailyclpd_close_date
_435.closed_periodsclp_close_date
_435.closed_periods_dailyclpd_close_date
_436.closed_periodsclp_close_date
_436.closed_periods_dailyclpd_close_date
_436_archive_testing.closed_periodsclp_close_date
_436_archive_testing.closed_periods_dailyclpd_close_date
_437.closed_periodsclp_close_date
_437.closed_periods_dailyclpd_close_date
_8.closed_periodsclp_close_date
_8.closed_periods_dailyclpd_close_date
_81.closed_periodsclp_close_date
_81.closed_periods_dailyclpd_close_date
_999.closed_periodsclp_close_date
_999.closed_periods_dailyclpd_close_date
fac_no
TableColumn
aurora_standard.chmpricaprev_fac_no
aurora_standard.chmpricacur_fac_no
aurora_standard.chpcashrcash_fac_no
aurora_standard.chpcobpdcash_fac_no
aurora_standard.chpcobpdbal_fac_no
aurora_standard.chscustddept_fac_no
aurora_standard.chshotlrdept_fac_no
aurora_standard.chtemplrdflt_fac_no
aurora_standard.curs_tempcash_fac_no
aurora_standard.curs_tempap_fac_no
aurora_standard.stgrowpdrod_beg_fac_no
aurora_standard.stgrowpdrod_end_fac_no
aurora_standard.stpcashddist_fac_no
aurora_standard.stpcashddisc_fac_no
aurora_standard.stpcashecash_fac_no
aurora_standard.stpcntrccash_fac_no
aurora_standard.stpcntrcdisc_fac_no
aurora_standard.stpinvcecash_fac_no
aurora_standard.stpopendap_fac_no
aurora_standard.stpopendcash_fac_no
aurora_standard.stucntrccash_fac_no
aurora_standard.stuinvcecash_fac_no
aurora_standard.stxfinsdfin_fac_no
aurora_standard.styaccrrliab_fac_no
aurora_standard.styaccrrexpense_fac_no
aurora_standard.styemplrcash_fac_no
aurora_standard.stypayfdcash_fac_no
aurora_standard.stypayodbal_fac_no
aurora_standard.stypayrecash_fac_no
aurora_standard.styrevsdcash_fac_no
aurora_standard.stytypercash_fac_no