aurora_standard.stprepsd

Field Type Null Default Key Extra Comment
vend_code varchar(6) YES
rep_name varchar(30) YES
rep_phone varchar(20) YES
rep_fax varchar(20) YES
rep_email varchar(40) YES
rep_add1 varchar(30) YES
rep_add2 varchar(30) YES
rep_city varchar(20) YES
rep_state varchar(2) YES
rep_zip varchar(10) YES
rep_hos_acctno varchar(20) YES
effective_dt date YES
inactive varchar(1) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
inactive
TableColumn
_1.patients_implantable_devicespid_inactive
_1188.patients_implantable_devicespid_inactive
_1218.patients_implantable_devicespid_inactive
_1548.patients_implantable_devicespid_inactive
_435.patients_implantable_devicespid_inactive
_436.patients_implantable_devicespid_inactive
_436_archive_testing.patients_implantable_devicespid_inactive
_437.patients_implantable_devicespid_inactive
_8.patients_implantable_devicespid_inactive
_81.patients_implantable_devicespid_inactive
_999.patients_implantable_devicespid_inactive
common.login_blockslb_inactive
vend_code
TableColumn
aurora_standard.vndxrefold_vend_code
aurora_standard.vndxrefnew_vend_code