aurora_standard.stuprche

Field Type Null Default Key Extra Comment
inv_doc_no int(11) YES MUL
inv_line_no smallint(6) YES
item_code varchar(20) YES
desc1 varchar(30) YES
desc2 varchar(30) YES
cost_qty decimal(10,2) YES
old_price decimal(10,2) YES
new_price decimal(10,2) 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
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
desc2
TableColumn
aurora_standard.chrschdrlabel_desc2
aurora_standard.chshotlrprob_desc2
aurora_standard.chsmodsrprob_desc2
aurora_standard.stmaintdmaint_desc2
aurora_standard.stmmastrwarr_desc2
aurora_standard.sturondcrounding_desc2
aurora_standard.stymesgcmessage_desc2
aurora_standard.styocovccoverage_desc2
aurora_standard.styosafcsafe_desc2