aurora_standard.chmardyd

Field Type Null Default Key Extra Comment
fac_no varchar(3) YES
rev_from_date date YES
age_date date YES MUL
age_year decimal(4,0) YES
age_month decimal(2,0) YES
age_fc varchar(2) YES
fc_group char(3) YES
tot_rev decimal(16,2) YES
avg_rev decimal(16,2) YES
tot_ar decimal(16,2) YES
ar_days smallint(6) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
age_date
TableColumn
aurora_standard.atklrrevrpt_age_date
aurora_standard.chmtkl1rrpt_age_date
aurora_standard.chmtkl2rrpt_age_date
aurora_standard.chmtkl3rrpt_age_date
aurora_standard.chmtkl4rrpt_age_date
aurora_standard.chmtkl5rrpt_age_date
aurora_standard.chmtkl6rrpt_age_date
aurora_standard.chmtkl7rrpt_age_date
aurora_standard.chmtkl8rrpt_age_date
aurora_standard.chmtkl9rrpt_age_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