CREATE TABLE [payreqmain] (
  [ID] COUNTER not null CONSTRAINT [PK_payreqmain_id] PRIMARY KEY,
  [comment] text(200) not NULL,                       --摘要
  [money] CURRENCY NOT NULL,                     --请款金额
  [createDate] datetime NOT NULL,                --请款单日期
  [modityDate] datetime NOT NULL,                --修改时间
  [acid] text(50)  NOT NULL,                     --科目
  [pacid] text(50) NOT NULL,                     --对方科目
  [deptstaffid] text(50) null,                   --部门
  [prjid] text(50) null,                         --项目
  [companyid] text(50)  NULL,                    --往来
  [poid] TEXT(50) null,                          -
  [maker] text(30) null,
  [uid] text(30) null ,
  [daudit] text(30) null,
  [faudit] text(30) null,
  [gaudit] text(30) null,
  [ismajor] INTEGER null default 0 ,
  [explain]  memo not null ,
  [S1]  text(20) null,
  [S2]  text(100) null,
  [S3]  text(200) null,
  [D1]  datetime NULL,
  [D2]  datetime NULL,
  [I1] INTEGER null,
  [I2] INTEGER null,
  [I3] INTEGER null,
  [C1] CURRENCY NULL,
  [C2] CURRENCY NULL,
  [C3] CURRENCY NULL
);