ǰ̨~2.txt

dos下pos机程序 连接sybase数据库 使用Microsoft c7 编译

--前台收银数据表
CREATE TABLE dbo.ck_thkgxb (
  kh char(10),
  mm char(6),
  xm char(10) NULL,
  dw char(30) NULL,
  ph char(8),
  fkrq datetime,
  yxqx datetime,
  cklx char(1),
  fkje decimal(19, 4),
  dqye decimal(19, 4),
  sydd char(100),
  zkr char(10) NULL,
  fkr char(10) NULL,
  syy char(3) NULL
)

CREATE TABLE dbo.ck_thkmxb (
  kh char(10),
  dtime datetime,
  sps decimal(28, 10) NULL,
  ys decimal(28, 10) NULL,
  ss decimal(28, 10) NULL,
  bx decimal(28, 10) NULL,
  bc char(6) NULL,
  syy char(4) NULL,
  syj char(4) NULL
)

CREATE TABLE dbo.ck_yhkgxb (
  kh char(10),
  mm char(6),
  xm char(10) NULL,
  fkrq datetime,
  yxrq datetime,
  yhl decimal(28, 10) NULL,
  ljss decimal(19, 4) NULL,
  ljys decimal(19, 4) NULL,
  syy char(3) NULL
)

CREATE TABLE dbo.ck_yhkmxb (
  kh char(10),
  dtime datetime,
  sps decimal(28, 10) NULL,
  ys decimal(28, 10) NULL,
  ss decimal(28, 10) NULL,
  bc char(6) NULL,
  syy char(4) NULL,
  syj char(4) NULL
)

CREATE TABLE dbo.jxc_dtmb (
  spbm char(8),
  tm char(13),
  sl decimal(28, 10) NULL,
  sj decimal(19, 4) NULL,
  dyzs int NULL,
  yhj decimal(19, 4) NULL,
  jc char(1) NULL
)

CREATE TABLE dbo.jxc_lbb (
  lbbm char(6),
  lbmc char(20),
  yhl decimal(28, 10) NULL,
  sl decimal(28, 10) NULL,
  tjbm char(6) NULL,
  sdyhl decimal(28, 10) NULL
)

CREATE TABLE dbo.jxc_sddzb (
  bm char(8),
  stime datetime,
  etime datetime,
  yhl decimal(28, 10),
  srr char(8) NULL,
  srtime datetime NULL,
  qfr char(8) NULL,
  qftime datetime NULL,
  qfbz char(1) NULL
)

CREATE TABLE dbo.jxc_syjb (
  syjh char(3),
  mc char(3) NULL,
  jrsj datetime NULL,
  jbsj datetime NULL,
  syy char(3) NULL,
  bc char(6) NULL,
  dbsr decimal(19, 4) NULL,
  drsr decimal(19, 4) NULL,
  ljsr decimal(19, 4) NULL,
  dbbs decimal(28, 10) NULL,
  drbs decimal(28, 10) NULL,
  ljbs decimal(28, 10) NULL,
  jbsyy char(3) NULL,
  lx char(1) NULL,
  lsdh char(4) NULL,
  status char(1) NULL
)

CREATE TABLE dbo.jxc_syyb (
  syybm char(3),
  xm char(8),
  mm char(6) NULL,
  jrjh char(3) NULL,
  bc char(6) NULL,
  dbsr decimal(19, 4) NULL,
  dysr decimal(19, 4) NULL,
  dbbs decimal(28, 10) NULL,
  dybs decimal(28, 10) NULL,
  ljsr decimal(19, 4) NULL,
  ljbs decimal(28, 10) NULL,
  lsdh char(4) NULL
)

CREATE TABLE dbo.jxc_tmcb (
  tplu char(6),
  spbm char(8),
  spmc char(32) NULL,
  sj decimal(19, 4) NULL,
  ysj decimal(19, 4) NULL,
  dtime datetime NULL,
  sr char(10) NULL,
  kjj char(10) NULL,
  tm char(6) NULL
)

CREATE TABLE dbo.jxc_wqrb (
  lsh decimal(28, 10) NULL,
  spbm char(8) NULL,
  dtime datetime,
  sl decimal(28, 10) NULL,
  jj decimal(19, 4) NULL,
  sj decimal(19, 4) NULL,
  je decimal(19, 4) NULL,
  zk decimal(19, 4) NULL,
  fkfs char(1) NULL,
  bx decimal(19, 4) NULL,
  csbm char(6) NULL,
  syy char(3) NULL,
  bc char(6) NULL,
  yyy char(4) NULL,
  gzbm char(4) NULL,
  jyfs char(2) NULL,
  lspf char(1) NULL,
  dept_id char(2) NULL,
  gzrq char(5) NULL,
  syjh char(3),
  ybrksl decimal(28, 10) NULL,
  ybrkcb decimal(19, 4) NULL,
  user_id char(4) NULL,
  djh char(8) NULL,
  xh int,
  lsdh char(4) NULL
)

CREATE TABLE dbo.jxc_xsdb (
  lsh decimal(28, 10) NULL,
  spbm char(8) NULL,
  dtime datetime,
  sl decimal(28, 10) NULL,
  jj decimal(19, 4) NULL,
  sj decimal(19, 4) NULL,
  je decimal(19, 4) NULL,
  zk decimal(19, 4) NULL,
  fkfs char(1) NULL,
  bx decimal(19, 4) NULL,
  csbm char(6) NULL,
  syy char(3) NULL,
  bc char(6) NULL,
  yyy char(4) NULL,
  gzbm char(4) NULL,
  jyfs char(2) NULL,
  lspf char(1) NULL,
  dept_id char(2) NULL,
  gzrq char(5) NULL,
  syjh char(3),
  ybrksl decimal(28, 10) NULL,
  ybrkcb decimal(19, 4) NULL,
  user_id char(4) NULL,
  djh char(8) NULL,
  xh int,
  lsdh char(4) NULL
)

CREATE TABLE dbo.xyk_gxb (
  km char(2),
  yh char(10),
  mc char(10)
)

CREATE TABLE dbo.xyk_mxb (
  kh char(16),
  km char(2) NULL,
  dtime datetime,
  je decimal(19, 4) NULL,
  syjh char(3),
  syy char(3) NULL,
  bc char(6) NULL,
  lsdh char(4) NULL
)
CREATE TABLE dbo.ytsys_globle (
  var_name char(10),
  var_type char(20),
  var_len int NULL,
  var_save varchar(255) NULL,
  var_note varchar(255) NULL,
  var_pass char(1) NULL
)