script.sql

SunwayERP框架(支持Plugin)

Create table QUOTATION_MAIN
  (
    QU_ID varchar(15) primary key not null,
    QU_VERSION smallint default(0),
    QU_CREATEDATE datetime default(GETDATE()),
    QU_CREATOR varchar(20),
    QU_STATUS smallint default(0),
    QU_MODIFYUSER varchar(20),
    QU_MODIFYDATE datetime,
    CUST_ID varchar(15) not null,
    CUST_NAME varchar(50),
    AREA_ID varchar(10),
    CUST_TYPE varchar(10),
    SAL_TYPE varchar(10),
    CURRENCRY varchar(10),
    CURRENCRY_RATE Float,
    PAY_MODE varchar(10),
    RATE float,
    INV_CODE varchar(6)
  )

Create table CUSTOMER
  (
    CUST_ID varchar(15) primary key not null,
    CUST_NAME varchar(50) not null unique,
    CUST_AREA varchar(10) not null,
    CUST_TYPE varchar(10),
    SAL_TYPE varchar(10),
    CUST_ADDRESS varchar(50),
    CUST_LINKMAN varchar(20),
    CUST_PHONE varchar(20),
    CUST_FAX varchar(20),
    CUST_EMAIL varchar(30),
    CUST_MOBILE varchar(20),
    CUST_BANK varchar(50),
    CUST_BANKNO varchar(30),
    CUST_TAXNO varchar(30),
    CUST_CURRENCRY varchar(10),
    CUST_PAYMODE varchar(10),
    CUST_INVCODE varchar(6),
    CUST_TOTALORDER int default(0),
    CUST_FINISHORDER int default(0),
    CUST_BADORDER int default(0),
    CUST_MAXCREDIT money,
    CUST_LEFTMONEY money,
    CUST_LEFTINV money
  )

Create table AREA
  (
    AREA_ID varchar(6) primary key not null,
    AREA_NAME varchar(20) unique
  )

Create table CUST_TYPE
  (
   CUST_TYPEID varchar(6) primary key not null,
   CUST_TYPENAME varchar(20) unique not null
  )

Create table SALE_TYPE
  (
   SAL_TYPEID varchar(6) primary key not null,
   SAL_TYPENAME varchar(20) unique not null
  )

Create table CURRENCRY
  (
   CUR_CODE varchar(6) primary key not null,
   CUR_NAME varchar(20) unique not null,
   CUR_RATE float,
   CUR_RATEDATE datetime
  )

Create table PAY_MODE
  (
    PAY_MODE_ID varchar(6) primary key not null, 
    PAY_MODE_NAME varchar(30) unique not null,
    PAY_MODE_DAYS int
  )

Create table INV_TYPE
  (
   INV_ID varchar(6) primary key not null,
   INV_NAME varchar(10) unique not null,
   INV_RATE float,
  )