aurora_standard.icitems

Field Type Null Default Key Extra Comment
item_code varchar(10) YES
qty decimal(12,2) YES
desc1 varchar(30) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
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
desc1
TableColumn
aurora_standard.chrschdrlabel_desc1
aurora_standard.chshotlrprob_desc1
aurora_standard.chsmodsrprob_desc1
aurora_standard.stmmastrwarr_desc1
aurora_standard.styocovccoverage_desc1
aurora_standard.styosafcsafe_desc1