create table bm_data (
pk_bm_data char(20) NOT NULL,
pk_psndoc varchar(20) default '~' NULL,
pk_psnjob varchar(20) default '~' NULL,
pk_psnorg varchar(20) NULL,
assgid int NULL,
pk_group varchar(20) NULL,
pk_org varchar(20) NULL,
pk_bm_class varchar(20) default '~' NULL,
cyear char(4) NULL,
cperiod char(2) NULL,
caculateflag char(1) NULL,
checkflag char(1) NULL,
bmaccountno varchar(40) NULL,
paylocation varchar(20) default '~' NULL,
dbegindate char(10) NULL,
accountstate char(50) NULL,
accounttype char(1) NULL,
vcancelreason varchar(500) NULL,
pk_transferorg varchar(20) default '~' NULL,
workorg varchar(20) default '~' NULL,
workorgvid varchar(20) default '~' NULL,
workdept varchar(20) default '~' NULL,
workdeptvid varchar(20) default '~' NULL,
pk_financeorg varchar(20) default '~' NULL,
fiporgvid varchar(20) default '~' NULL,
pk_financedept varchar(20) default '~' NULL,
fipdeptvid varchar(20) default '~' NULL,
pk_liabilityorg varchar(20) default '~' NULL,
pk_liabilitydept varchar(20) default '~' NULL,
libdeptvid varchar(20) default '~' NULL,
pk_sourcecls varchar(20) default '~' NULL,
glbdef1 varchar(101) NULL,
glbdef2 varchar(101) NULL,
glbdef3 varchar(101) NULL,
glbdef4 varchar(101) NULL,
glbdef5 varchar(101) NULL,
glbdef6 varchar(101) NULL,
glbdef7 varchar(101) NULL,
glbdef8 varchar(101) NULL,
glbdef9 varchar(101) NULL,
glbdef10 varchar(101) NULL,
glbdef11 varchar(101) NULL,
glbdef12 varchar(101) NULL,
glbdef13 varchar(101) NULL,
glbdef14 varchar(101) NULL,
glbdef15 varchar(101) NULL,
glbdef16 varchar(101) NULL,
glbdef17 varchar(101) NULL,
glbdef18 varchar(101) NULL,
glbdef19 varchar(101) NULL,
glbdef20 varchar(101) NULL,
CONSTRAINT PK_BM_DATA PRIMARY KEY (pk_bm_data),
ts char(19) NULL,
dr smallint default 0 
)


