aurora_standard.surpcinvtrd

Field Type Null Default Key Extra Comment
card_no int(11) NO PRI
seq_no int(11) NO PRI
item_code varchar(10) NO
qty int(11) NO

References

Local Column References
seq_no
TableColumn
aurora_standard.chmarstarec_seq_no
aurora_standard.chmarstacrec_seq_no
aurora_standard.chmarstairec_seq_no
aurora_standard.chmarstdrec_seq_no
aurora_standard.chmarstdirec_seq_no
aurora_standard.chmarsterec_seq_no
aurora_standard.chmarsthrec_seq_no
aurora_standard.chmarsthirec_seq_no
aurora_standard.chmarstphrec_seq_no
aurora_standard.chmarstpirec_seq_no
aurora_standard.chmarstporec_seq_no
aurora_standard.chmarstpqrec_seq_no
aurora_standard.chmarstprrec_seq_no
aurora_standard.chmarstpsrec_seq_no
aurora_standard.chmarstptrec_seq_no
aurora_standard.chmarstpyrec_seq_no
aurora_standard.chmcostarec_seq_no
aurora_standard.chmcostbrec_seq_no
aurora_standard.chmcostdrec_seq_no
aurora_standard.chmcostrcrec_seq_no
aurora_standard.chmgltcda_seq_no
aurora_standard.chmgltcdb_seq_no
aurora_standard.chmhid4arec_seq_no
aurora_standard.chmhid4brec_seq_no
aurora_standard.chmhid4crec_seq_no
aurora_standard.chmhid4drec_seq_no
aurora_standard.chmhid4grec_seq_no
aurora_standard.chrhhdcclisting_seq_no
aurora_standard.chrhhmprlisting_seq_no
aurora_standard.chrhhndclisting_seq_no
aurora_standard.chrhhndcfirm_seq_no
aurora_standard.chrhhroclisting_seq_no
aurora_standard.chrmndclisting_seq_no
aurora_standard.chrmndcfirm_seq_no
aurora_standard.chxhistdh_seq_no
aurora_standard.chyhistdh_seq_no
aurora_standard.drugclaslisting_seq_no
aurora_standard.formulatlisting_seq_no
aurora_standard.listingslisting_seq_no
aurora_standard.listingsfirm_seq_no
aurora_standard.packagelisting_seq_no
aurora_standard.routeslisting_seq_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
qty
TableColumn
aurora_standard.chmpriccndc_qty
aurora_standard.chrdrugcpack_qty
aurora_standard.gary13sum_qty
aurora_standard.gary2sum_recv_qty
aurora_standard.item1ordr_qty
aurora_standard.sthcadjdadj_qty
aurora_standard.sthcadjdcount_qty
aurora_standard.stiadjmdadj_qty
aurora_standard.sticadjdadj_qty
aurora_standard.sticadjdcount_qty
aurora_standard.stiinvtrcase_qty
aurora_standard.stilocarlast_qty
aurora_standard.stilocarconsign_qty
aurora_standard.stipurcdpurch_qty
aurora_standard.stiselldsell_qty
aurora_standard.stiserlalot_qty
aurora_standard.stiserldlot_qty
aurora_standard.stiserlelot_qty
aurora_standard.stitrandtran_qty
aurora_standard.stoordrdordr_qty
aurora_standard.stoordrdback_qty
aurora_standard.stoordrdcommit_qty
aurora_standard.stopricddisc_qty
aurora_standard.stoshipdship_qty
aurora_standard.stoshipdcommit_qty
aurora_standard.stuctlgdcase_qty
aurora_standard.stuinvcdcost_qty
aurora_standard.stuordrdordr_qty
aurora_standard.stuordrdrlse_qty
aurora_standard.stuordrdrjct_qty
aurora_standard.stuordrdrecv_qty
aurora_standard.stuordrdcost_qty
aurora_standard.stuordrdacpt_qty
aurora_standard.stuordrdexp_rec_qty
aurora_standard.stuordrdexp_inv_qty
aurora_standard.stuprchecost_qty
aurora_standard.stupricddisc_qty
aurora_standard.sturectdrecv_qty
aurora_standard.sturectdrjct_qty
aurora_standard.sturqstdordr_qty
aurora_standard.sturqstdrecv_qty
aurora_standard.sturqstdcase_qty
aurora_standard.sturtrndreturn_qty
aurora_standard.tmpctlgdcase_qty
aurora_standard.tmplocarlast_qty
aurora_standard.tmplocarconsign_qty
aurora_standard.tmplvl2consign_qty
aurora_standard.tmplvl3consign_qty
aurora_standard.tmpparlvlconsign_qty
aurora_standard.ttiinvtrcase_qty
card_no
TableColumn
aurora_standard.stpvendrcredit_card_no
aurora_standard.styrtimdrec_card_no
aurora_standard.styrtimerec_card_no