tb_po_order_header.sql

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

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

Create table PO_Order_Header
(
   Order_Number varchar(30) not null constraint PK_Order_Header primary key,
   Order_Type	CHAR(4) NOT NULL default 'NLPO',
   Order_Status CHAR(1) NOT NULL default 'O',
   Version 	numeric(4,2) not null default 1.0,
   Vednor_ID    varchar(10) not null constraint FK_Order_Vendor references PO_Vendor_Mstr(Vendor_ID),
   Customer_ID  CHAR(5) NULL,
   PR_Number    varchar(30) null,
   Charge	numeric(18,3) not null default 0.00,
   Charge_Type  CHAR(1) NOT NULL default '%',
   Charge_Class CHAR(1) NOT NULL default 'D',  -- D---Discount ,H-- handing charge
   Deliv_ID     CHAR(3) NOT NULL constraint FK_Deliv_ID references GL_Deliv_Location(Deliv_ID),	
   Printed	Char(1) not null default 'N',   
   Printed_By   VARCHAR(15)  NULL,
   Buyer_Sig	CHAR(1)  NULL default 'N',
   Signatured_by VARCHAR(15) NULL,
   Signatured_dt Datetime null,
   Confirmed_Sig CHAR(1) NULL,
   Confirmed_by  VARCHAR(15) NULL,
   Confirmed_dt   Datetime null,
   Approved_Sig   CHAR(1) NULL,
   Approved_By    VARCHAR(15) NULL,
   Approved_dt    Datetime NULL,
   Closed_Flag    CHAR(1) NULL,
   Closed_By	  VARCHAR(15) NULL,
   Closed_Dt	  Datetime null,
   Extesion 	  CHAR(4) NULL,
   Telephone1     VARCHAR(8) NULL,
   Telephone2     VARCHAR(8) NULL,
   Fax1		  VARCHAR(8) NULL,
   Fax2		  VARCHAR(8) NULL,
   LinkMan	  VARCHAR(30) NULL
)