alter_order_type.sql

来自「工厂采购系统,DELPHI+SQL SERVER,三层技术」· SQL 代码 · 共 19 行

alter table gl_order_type
		add alt_nm varchar(120) null

update gl_order_type
	set alt_nm ='客供采购单' where order_type ='DMPO'

update gl_order_type
	set alt_nm ='内部采购单' where order_type ='INPO'

update gl_order_type
	set alt_nm ='普通采购单' where order_type ='NLPO'
update gl_order_type
	set alt_nm ='外协采购单' where order_type ='SCPO'

update gl_order_type
	set alt_nm ='样板采购单' where order_type ='SMPO'

update gl_order_type
	set alt_nm ='模具采购单' where order_type ='TLPO'