aurora_standard.chmdfpsd

Field Type Null Default Key Extra Comment
ps varchar(2) YES
fac_no varchar(3) YES
seq_no smallint(6) YES
dfy_code varchar(6) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
ps
TableColumn
aurora_standard.chmabstrprimary_ps
aurora_standard.chmabstrsecondary_ps
aurora_standard.chmabstrtertiary_ps
aurora_standard.chmadmtrarrival_ps
aurora_standard.chmadmtrnew_pat_this_ps
aurora_standard.chmchfcdnew_ps
aurora_standard.chmchfcdold_ps
aurora_standard.chmchpsdold_ps
aurora_standard.chmchpsdnew_ps
aurora_standard.chmcostaprimary_ps
aurora_standard.chmcostasecondary_ps
aurora_standard.chmcostatertiary_ps
aurora_standard.chmhid4aprimary_ps
aurora_standard.chmhid4asecondary_ps
aurora_standard.chmhid4atertiary_ps
aurora_standard.chmhidiaprimary_ps
aurora_standard.chmhidicprimary_ps
aurora_standard.chmhidicsecondary_ps
aurora_standard.chmhidictertiary_ps
aurora_standard.chmradexarrival_ps
aurora_standard.financial_class_changesnew_ps
aurora_standard.financial_class_changesold_ps
aurora_standard.stxautodchg_inc_ps
aurora_standard.stxautodchg_exc_ps
aurora_standard.stxautodvis_inc_ps
aurora_standard.stxautodvis_exc_ps
aurora_standard.stxautodadj_inc_ps
aurora_standard.stxautodadj_exc_ps
aurora_standard.tmpmrrptprimary_ps
aurora_standard.tmpmrrptsecondary_ps
seq_no
TableColumn
aurora_standard.chmarstarec_seq_no
aurora_standard.chmarstacrec_seq_no
aurora_standard.chmarstairec_seq_no
aurora_standard.chmarstdrec_seq_no
aurora_standard.chmarstdirec_seq_no
aurora_standard.chmarsterec_seq_no
aurora_standard.chmarsthrec_seq_no
aurora_standard.chmarsthirec_seq_no
aurora_standard.chmarstphrec_seq_no
aurora_standard.chmarstpirec_seq_no
aurora_standard.chmarstporec_seq_no
aurora_standard.chmarstpqrec_seq_no
aurora_standard.chmarstprrec_seq_no
aurora_standard.chmarstpsrec_seq_no
aurora_standard.chmarstptrec_seq_no
aurora_standard.chmarstpyrec_seq_no
aurora_standard.chmcostarec_seq_no
aurora_standard.chmcostbrec_seq_no
aurora_standard.chmcostdrec_seq_no
aurora_standard.chmcostrcrec_seq_no
aurora_standard.chmgltcda_seq_no
aurora_standard.chmgltcdb_seq_no
aurora_standard.chmhid4arec_seq_no
aurora_standard.chmhid4brec_seq_no
aurora_standard.chmhid4crec_seq_no
aurora_standard.chmhid4drec_seq_no
aurora_standard.chmhid4grec_seq_no
aurora_standard.chrhhdcclisting_seq_no
aurora_standard.chrhhmprlisting_seq_no
aurora_standard.chrhhndclisting_seq_no
aurora_standard.chrhhndcfirm_seq_no
aurora_standard.chrhhroclisting_seq_no
aurora_standard.chrmndclisting_seq_no
aurora_standard.chrmndcfirm_seq_no
aurora_standard.chxhistdh_seq_no
aurora_standard.chyhistdh_seq_no
aurora_standard.drugclaslisting_seq_no
aurora_standard.formulatlisting_seq_no
aurora_standard.listingslisting_seq_no
aurora_standard.listingsfirm_seq_no
aurora_standard.packagelisting_seq_no
aurora_standard.routeslisting_seq_no
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