aurora_standard.chmgstmr

Field Type Null Default Key Extra Comment
guar_no int(11) YES MUL
stmnt_no smallint(6) YES
create_date date YES
stmnt_date date YES MUL
prev_stmnt_date date YES
due_date date YES
message_code varchar(10) YES
input_by int(11) YES
print_date date YES MUL
fac_no varchar(3) YES MUL
stmnt_bal decimal(16,2) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
create_date
TableColumn
_1.configured_encountersconfenc_create_date
_1548.configured_encountersconfenc_create_date
_435.configured_encountersconfenc_create_date
_436.configured_encountersconfenc_create_date
_436_archive_testing.configured_encountersconfenc_create_date
_437.configured_encountersconfenc_create_date
_8.configured_encountersconfenc_create_date
_999.configured_encountersconfenc_create_date
due_date
TableColumn
_1.patients_reminderspr_due_date
_1.patients_statementspst_due_date
_1188.patients_reminderspr_due_date
_1188.patients_statementspst_due_date
_1218.patients_reminderspr_due_date
_1218.patients_statementspst_due_date
_1548.patients_reminderspr_due_date
_1548.patients_statementspst_due_date
_435.patients_reminderspr_due_date
_435.patients_statementspst_due_date
_436.patients_reminderspr_due_date
_436.patients_statementspst_due_date
_436_archive_testing.patients_reminderspr_due_date
_436_archive_testing.patients_statementspst_due_date
_437.patients_reminderspr_due_date
_437.patients_statementspst_due_date
_8.patients_reminderspr_due_date
_8.patients_statementspst_due_date
_81.patients_reminderspr_due_date
_81.patients_statementspst_due_date
_999.patients_reminderspr_due_date
_999.patients_statementspst_due_date
guar_no
TableColumn
aurora_standard.anmpinew_guar_no
aurora_standard.apsmpinew_guar_no
aurora_standard.bs2mpinew_guar_no
aurora_standard.bsmpinew_guar_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