aurora_standard.stiserle

Field Type Null Default Key Extra Comment
orig_journal varchar(2) YES MUL
doc_no int(11) YES
line_no smallint(6) YES
ship_no smallint(6) YES
lot_no varchar(20) YES
serial_no varchar(20) YES
lot_qty decimal(10,2) YES
item_code varchar(20) YES MUL
warehouse_code varchar(10) YES
in_out varchar(3) YES
exp_date date YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
exp_date
TableColumn
_1.patients_payment_methodspatpm_exp_date
_1188.patients_payment_methodspatpm_exp_date
_1218.patients_payment_methodspatpm_exp_date
_1548.patients_payment_methodspatpm_exp_date
_435.patients_payment_methodspatpm_exp_date
_436.patients_payment_methodspatpm_exp_date
_436_archive_testing.patients_payment_methodspatpm_exp_date
_437.patients_payment_methodspatpm_exp_date
_8.patients_payment_methodspatpm_exp_date
_81.patients_payment_methodspatpm_exp_date
_999.patients_payment_methodspatpm_exp_date
aurora_standard.bhphybakdea_exp_date
aurora_standard.c8phydea_exp_date
aurora_standard.chmphyncdea_exp_date
aurora_standard.chpempidlicense_exp_date
aurora_standard.chqcarddcardiac_exp_date
aurora_standard.chqliabdliab_pol_exp_date
aurora_standard.chqlicndlic_exp_date
aurora_standard.chqphyncbrd_cert_exp_date
aurora_standard.vault_providersdea_exp_date
doc_no
TableColumn
aurora_standard.audpadjdpy_doc_no
aurora_standard.chmgltrcar_doc_no
aurora_standard.chmgltrcrm_doc_no
aurora_standard.chmgltrcip_doc_no
aurora_standard.chmgltrcop_doc_no
aurora_standard.chmgltrcr3_doc_no
aurora_standard.chmgltrcr4_doc_no
aurora_standard.chmgltrccr_doc_no
aurora_standard.chmgltrcaj_doc_no
aurora_standard.chmgltrcnr_doc_no
aurora_standard.chmgltrcnc_doc_no
aurora_standard.chmgltrcfc_doc_no
aurora_standard.chmpadjdpy_doc_no
aurora_standard.chmrefndcheck_doc_no
aurora_standard.discountsinv_doc_no
aurora_standard.odhpayddpy_doc_no
aurora_standard.odhpayidpy_doc_no
aurora_standard.odhpayodpy_doc_no
aurora_standard.odhpayrepy_doc_no
aurora_standard.stfcntrcfa_doc_no
aurora_standard.stgcntrcgenjrn_doc_no
aurora_standard.stgcntrcstdent_doc_no
aurora_standard.sticstvrrec_doc_no
aurora_standard.stoinvceinv_doc_no
aurora_standard.stoordreorig_doc_no
aurora_standard.stoordreinv_doc_no
aurora_standard.stoshipdinv_doc_no
aurora_standard.stoshipdpo_doc_no
aurora_standard.stpactvdinv_doc_no
aurora_standard.stpactvvinv_doc_no
aurora_standard.stpcashdinv_doc_no
aurora_standard.stpcntrcap_doc_no
aurora_standard.stpcntrccd_doc_no
aurora_standard.stpvoidrchk_doc_no
aurora_standard.stractvdinv_doc_no
aurora_standard.stractvvinv_doc_no
aurora_standard.strcashdinv_doc_no
aurora_standard.strcntrcar_doc_no
aurora_standard.strcntrccr_doc_no
aurora_standard.stucntrcreq_doc_no
aurora_standard.stucntrcpo_doc_no
aurora_standard.stucntrcrec_doc_no
aurora_standard.stucntrcinv_doc_no
aurora_standard.stucntrcret_doc_no
aurora_standard.stuinvcdinv_doc_no
aurora_standard.stuinvcdpo_doc_no
aurora_standard.stuinvceinv_doc_no
aurora_standard.stuinvcepo_doc_no
aurora_standard.stuordrdorder_doc_no
aurora_standard.stuordreorig_doc_no
aurora_standard.stuordreorder_doc_no
aurora_standard.stuprcheinv_doc_no
aurora_standard.sturectdrec_doc_no
aurora_standard.sturectdpo_doc_no
aurora_standard.sturecterec_doc_no
aurora_standard.sturectepo_doc_no
aurora_standard.sturqstdpo_doc_no
aurora_standard.sturqstdref_doc_no
aurora_standard.sturtrndret_doc_no
aurora_standard.sturtrndpo_doc_no
aurora_standard.sturtrndrec_doc_no
aurora_standard.sturtrndinv_doc_no
aurora_standard.sturtrneret_doc_no
aurora_standard.stxmtaxdinv_doc_no
aurora_standard.stxtaxldinv_doc_no
aurora_standard.stycdeddpy_doc_no
aurora_standard.stycincdpy_doc_no
aurora_standard.stycntrcpy_doc_no
aurora_standard.stypayarpy_doc_no
aurora_standard.stypddrdpy_doc_no
aurora_standard.styvoidepay_doc_no
serial_no
TableColumn
aurora_standard.chhcntrcneic_serial_no
aurora_standard.chmcntrcneic_serial_no
aurora_standard.stmaintdmaint_serial_no
aurora_standard.stmnotednote_serial_no
aurora_standard.stmwarrdwarr_serial_no
item_code
TableColumn
aurora_standard.chmbitmdvend_item_code
aurora_standard.chmschgdvend_item_code
aurora_standard.glstrackp_item_code
aurora_standard.glstrackm_item_code
aurora_standard.icactvvvend_item_code
aurora_standard.stiixrefvend_item_code
aurora_standard.stmaintdmaint_po_item_code
aurora_standard.stuctlgdvend_item_code
aurora_standard.sturqstdvend_item_code
aurora_standard.tmpctlgdvend_item_code
aurora_standard.tmplvl2vend_item_code
aurora_standard.tmplvl3vend_item_code
aurora_standard.tmpparlvlvend_item_code
line_no
TableColumn
aurora_standard.chmmbc41service_line_no
aurora_standard.sticstvrrec_line_no
aurora_standard.stmnotednote_line_no
aurora_standard.stmwarrdwarr_line_no
aurora_standard.stoordrdkit_line_no
aurora_standard.stuinvcdinv_line_no
aurora_standard.stuinvcdpo_line_no
aurora_standard.stuordrdorder_line_no
aurora_standard.stuprcheinv_line_no
aurora_standard.sturectdrec_line_no
aurora_standard.sturectdpo_line_no
aurora_standard.sturqstdpo_line_no
aurora_standard.sturqstdref_line_no
aurora_standard.sturtrndret_line_no
aurora_standard.sturtrndpo_line_no
aurora_standard.sturtrndrec_line_no
aurora_standard.sturtrndinv_line_no
lot_no
TableColumn
aurora_standard.chxexamrcontrast_lot_no
aurora_standard.chxleasrcontrast_lot_no
ship_no
TableColumn
aurora_standard.stuordrdorder_ship_no
aurora_standard.sturqstdref_ship_no