tb_gl_payment_terms.sql

工厂采购系统,DELPHI+SQL SERVER,三层技术

if object_id('dbo.GL_Payment_Terms') is not null
drop table GL_Payment_Terms
go

Create table GL_Payment_Terms
(
 Pay_Code  int IDENTITY(100,1) not null primary key,
 Description  varchar(120) not null,
 Language  CHAR(3) NOT NULL
)

go

insert into GL_Payment_Terms
(Description,Language)
select payterms,'EN' from ven_cust_mst
where Len(payterms)>3
group by Payterms