tb_gl_currency_mstr.sql

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

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

Create table GL_Currency_Mstr
(
Currency	CHAR(3) not null constraint pk_gl_currency  primary key,
Description    varchar(30) null,
lang		CHAR(3) null default 'ENG',
Rate numeric(18,8) not null default 0.000000,
Active  bit not null default 0
)

go