aurora_standard.sturtrne

Field Type Null Default Key Extra Comment
ret_doc_no int(11) YES UNI
return_date date YES
return_auth varchar(10) YES
ok_post varchar(1) YES
post_date date YES
post_no int(11) YES
return_fee decimal(10,2) YES
comment varchar(30) YES
vend_code varchar(6) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
comment
TableColumn
_1.orders_commentsorc_comment
_1.orders_comments_templatesorct_comment
_1.precerts_commentsprc_comment
_1.radiology_order_notesradnot_comment
_1188.orders_commentsorc_comment
_1188.orders_comments_templatesorct_comment
_1188.precerts_commentsprc_comment
_1188.radiology_order_notesradnot_comment
_1218.orders_commentsorc_comment
_1218.orders_comments_templatesorct_comment
_1218.precerts_commentsprc_comment
_1218.radiology_order_notesradnot_comment
_1548.orders_commentsorc_comment
_1548.orders_comments_templatesorct_comment
_1548.precerts_commentsprc_comment
_1548.radiology_order_notesradnot_comment
_435.orders_commentsorc_comment
_435.orders_comments_templatesorct_comment
_435.precerts_commentsprc_comment
_435.radiology_order_notesradnot_comment
_436.orders_commentsorc_comment
_436.orders_comments_templatesorct_comment
_436.precerts_commentsprc_comment
_436.radiology_order_notesradnot_comment
_436_archive_testing.orders_commentsorc_comment
_436_archive_testing.orders_comments_templatesorct_comment
_436_archive_testing.precerts_commentsprc_comment
_436_archive_testing.radiology_order_notesradnot_comment
_437.orders_commentsorc_comment
_437.orders_comments_templatesorct_comment
_437.precerts_commentsprc_comment
_437.radiology_order_notesradnot_comment
_8.orders_commentsorc_comment
_8.orders_comments_templatesorct_comment
_8.precerts_commentsprc_comment
_8.radiology_order_notesradnot_comment
_81.orders_commentsorc_comment
_81.orders_comments_templatesorct_comment
_81.precerts_commentsprc_comment
_81.radiology_order_notesradnot_comment
_999.orders_commentsorc_comment
_999.orders_comments_templatesorct_comment
_999.precerts_commentsprc_comment
_999.radiology_order_notesradnot_comment
ahiWiki.archivear_comment
ahiWiki.logginglog_comment
ahiWiki.recentchangesrc_comment
ahiWiki.revisionrev_comment
aurora_standard.audppayddenial_comment
aurora_standard.chmabstrstatus_comment
aurora_standard.chmblogddenial_comment
aurora_standard.chmbremddenial_comment
aurora_standard.chmmcqudemp_comment
aurora_standard.chmmcqudsp_emp_comment
aurora_standard.chmozpcdacct_comment
aurora_standard.chmppayddenial_comment
aurora_standard.chpevaldreviewer_comment
aurora_standard.hl7ntesrc_comment
aurora_standard.hl7nteadsrc_comment
common.service_tickets_commentsstcp_comment
template_library.orders_comments_templatesorct_comment
post_no
TableColumn
aurora_standard.chmgltrcar_post_no
aurora_standard.stfcntrcfa_post_no
aurora_standard.stgcntrcgenjrn_post_no
aurora_standard.stgcntrcgenled_post_no
aurora_standard.stpcntrcap_post_no
aurora_standard.stpcntrccd_post_no
aurora_standard.strcntrcar_post_no
aurora_standard.strcntrccr_post_no
aurora_standard.stucntrcreq_post_no
aurora_standard.stucntrcrec_post_no
aurora_standard.stucntrcinv_post_no
aurora_standard.stucntrcret_post_no
aurora_standard.stuinvceinv_post_no
aurora_standard.sturqstdreq_post_no
aurora_standard.stycntrcpy_post_no
post_date
TableColumn
aurora_standard.hl7ft1trans_post_date
aurora_standard.stuinvceinv_post_date
vend_code
TableColumn
aurora_standard.vndxrefold_vend_code
aurora_standard.vndxrefnew_vend_code