aurora_standard.stxvckrd

Field Type Null Default Key Extra Comment
orig_journal varchar(2) YES
check_no varchar(15) YES
acct_no int(11) YES
vend_code varchar(6) YES
void_date date YES
void_reason varchar(30) YES
type_code varchar(1) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
type_code
TableColumn
_1.hl7_accessionsacc_type_code
_1.patients_icd9_problems_dx_modifierspipdm_type_code
_1188.hl7_accessionsacc_type_code
_1188.patients_icd9_problems_dx_modifierspipdm_type_code
_1218.hl7_accessionsacc_type_code
_1218.patients_icd9_problems_dx_modifierspipdm_type_code
_1548.hl7_accessionsacc_type_code
_1548.patients_icd9_problems_dx_modifierspipdm_type_code
_435.hl7_accessionsacc_type_code
_435.patients_icd9_problems_dx_modifierspipdm_type_code
_436.hl7_accessionsacc_type_code
_436.patients_icd9_problems_dx_modifierspipdm_type_code
_436_archive_testing.hl7_accessionsacc_type_code
_436_archive_testing.patients_icd9_problems_dx_modifierspipdm_type_code
_437.hl7_accessionsacc_type_code
_437.patients_icd9_problems_dx_modifierspipdm_type_code
_8.hl7_accessionsacc_type_code
_8.patients_icd9_problems_dx_modifierspipdm_type_code
_81.hl7_accessionsacc_type_code
_81.patients_icd9_problems_dx_modifierspipdm_type_code
_999.hl7_accessionsacc_type_code
_999.patients_icd9_problems_dx_modifierspipdm_type_code
aurora_standard.stmaintdmaint_type_code
aurora_standard.stmnotednote_type_code
aurora_standard.stmwarrdwarr_type_code
common.clientscli_service_type_code
acct_no
TableColumn
aurora_standard.chmcashdnon_pat_acct_no
aurora_standard.chmnbcgdnon_pat_acct_no
aurora_standard.chmnbpydnon_pat_acct_no
aurora_standard.chmnchgdnon_pat_acct_no
aurora_standard.chmnpatrnon_pat_acct_no
aurora_standard.chmnpaydnon_pat_acct_no
aurora_standard.chmrefndcontr_acct_no
aurora_standard.chpcashrcash_acct_no
aurora_standard.chpcobpdcash_acct_no
aurora_standard.chpcobpdbal_acct_no
aurora_standard.chrcntrcrx_inv_acct_no
aurora_standard.chrcntrcrx_exp_acct_no
aurora_standard.curs_tempcash_acct_no
aurora_standard.np_statmnon_pat_acct_no
aurora_standard.sticntrcinv_acct_no
aurora_standard.sticntrcsales_acct_no
aurora_standard.sticntrccog_acct_no
aurora_standard.sticntrcadj_acct_no
aurora_standard.sticntrccount_acct_no
aurora_standard.sticntrchold_acct_no
aurora_standard.stiinvtrinv_acct_no
aurora_standard.stiinvtrcog_acct_no
aurora_standard.stiinvtrsales_acct_no
aurora_standard.stiinvtrsupp_acct_no
aurora_standard.stitrandexp_acct_no
aurora_standard.stiwhserinv_acct_no
aurora_standard.stpcntrcap_acct_no
aurora_standard.stpcntrccd_cash_acct_no
aurora_standard.stpcntrccd_disc_acct_no
aurora_standard.stpinvcedisc_acct_no
aurora_standard.stpinvceap_acct_no
aurora_standard.stpinvcecash_acct_no
aurora_standard.stpopendap_acct_no
aurora_standard.stpopendcash_acct_no
aurora_standard.stpvendrcash_acct_no
aurora_standard.stpvendrexp_acct_no
aurora_standard.stpvendrhosp_acct_no
aurora_standard.strcntrcar_acct_no
aurora_standard.strcntrcar_sales_acct_no
aurora_standard.strcntrcar_tax_acct_no
aurora_standard.strcntrcar_frght_acct_no
aurora_standard.strcntrcar_misc_acct_no
aurora_standard.strcntrcar_fc_acct_no
aurora_standard.strcntrccr_cash_acct_no
aurora_standard.strcntrccr_disc_acct_no
aurora_standard.strinvcedisc_acct_no
aurora_standard.strinvcetax_acct_no
aurora_standard.strinvcefrght_acct_no
aurora_standard.strinvcemisc_acct_no
aurora_standard.strinvcear_acct_no
aurora_standard.stropendar_acct_no
aurora_standard.stucntrcap_acct_no
aurora_standard.stucntrcdisc_acct_no
aurora_standard.stucntrcfrght_acct_no
aurora_standard.stucntrcmisc_acct_no
aurora_standard.stucntrcinv_acct_no
aurora_standard.stucntrcadj_acct_no
aurora_standard.stucntrcprepaid_acct_no
aurora_standard.stucntrcsupp_acct_no
aurora_standard.stucntrccap_acct_no
aurora_standard.stucntrcnon_acct_no
aurora_standard.stucntrcdiff_acct_no
aurora_standard.stucntrccash_acct_no
aurora_standard.stucntrcret_acct_no
aurora_standard.stucntrcret_fee_acct_no
aurora_standard.stuinvcdgl_acct_no
aurora_standard.stultyprgl_acct_no
aurora_standard.stuordrdgl_acct_no
aurora_standard.stxcurrrex_diff_acct_no
aurora_standard.stxfinsdfin_acct_no
aurora_standard.stxinforsrc_acct_no
aurora_standard.stxmtaxrar_acct_no
aurora_standard.stxmtaxrar_disc_acct_no
aurora_standard.stxmtaxrap_acct_no
aurora_standard.stxmtaxrap_disc_acct_no
aurora_standard.stycntrcco_bank_acct_no
aurora_standard.styddepdbank_acct_no
aurora_standard.styemplrbank_acct_no
aurora_standard.styempodbal_acct_no
aurora_standard.stypayodbal_acct_no
aurora_standard.stypayrecash_acct_no
aurora_standard.stypddrdbank_acct_no
aurora_standard.styrevsdcash_acct_no
aurora_standard.stytypodbal_acct_no
aurora_standard.styuimmrui_acct_no
aurora_standard.ttiinvtrinv_acct_no
aurora_standard.ttiinvtrcog_acct_no
aurora_standard.ttiinvtrsales_acct_no
aurora_standard.ttiinvtrsupp_acct_no
aurora_standard.wkactvvinv_acct_no
vend_code
TableColumn
aurora_standard.vndxrefold_vend_code
aurora_standard.vndxrefnew_vend_code