VersionDB '5.00.0';
VersionMod OWPW.EXE '5.0.1';
Ask 'Your company will now be converted. If you have not backed up your company database, you should exit this script. Continue?';
output into APTRAN.dat
select TH_MSG,TH_SHIPAD1,TH_SHIPAD2,TH_SHIPCNY,TH_SHIPCTY,TH_SHIPNAM,TH_SHIPST,TH_SHIPZIP,TR_AMT,TR_AMTAPPL,TR_BAL,TR_BKOID,TR_CBNKIND,TR_CDOID,TR_DATE,TR_DESC,TR_DISCDAT,TR_DISCORG,TR_DISCPCT,TR_DISCTAK,TR_DISCUSD,TR_DUEDATE,TR_EDITFLG,TR_GSTAMT,TR_HISTFLG,TR_OID,TR_PRNTIND,TR_PROID,TR_PYOID,TR_RECRFLG,TR_REFNO,TR_REFOID,TR_SESSIND,TR_STATIND,TR_TYPE,TR_VOIDFLG, from APTRAN;
output into artran.dat
select TH_BILLAD1,TH_BILLAD2,TH_BILLCNY,TH_BILLCTY,TH_BILLNAM,TH_BILLST,TH_BILLZIP,TH_FRTAMT,TH_FRTAXID,TH_FRTPCT,TH_FSGLOID,TH_INSTRCT,TH_MSG,TH_ORDDATE,TH_PONUM,TH_PRCCODE,TH_SHIPAD1,TH_SHIPAD2,TH_SHIPCNY,TH_SHIPCTY,TH_SHIPFOB,TH_SHIPNAM,TH_SHIPST,TH_SHIPVIA,TH_SHIPZIP,TH_SHPDATE,TH_STOID,TR_AMT,TR_AMTAPPL,TR_BAL,TR_BKOID,TR_CBNKIND,TR_CDOID,TR_DATE,TR_DESC,TR_DISCAMT,TR_DISCDAT,TR_DISCORG,TR_DISCPCT,TR_DISCTAK,TR_DISCUSD,TR_DPSTFLG,TR_DTLFLG,TR_DUEDATE,TR_EDITFLG,TR_GSTAMT,TR_HISTFLG,TR_OID,TR_PRNTIND,TR_PROID,TR_PYOID,TR_RECRFLG,TR_REFNO,TR_REFOID,TR_SESSIND,TR_SRINTLS,TR_STAMT,TR_STATIND,TR_STYLE,TR_TYPE,TR_VOIDFLG, from artran;
output into BKTRAN.dat
select TR_AMT,TR_BKOID,TR_CBNKIND,TR_DATE,TR_DESC,TR_EDITFLG,TR_HISTFLG,TR_OID,TR_PROID,TR_REFNO,TR_REFOID,TR_REFTYPE,TR_SESSIND,TR_TYPE,TR_VOIDFLG, from BKTRAN;
output into GJTRAN.dat
select TH_LNGDECR,TH_ONESIDE,TR_DATE,TR_EDITFLG,TR_HISTFLG,TR_OID,TR_PROID,TR_RECRFLG,TR_REFNO,TR_SESSIND,TR_TYPE,TR_VOIDFLG, from GJTRAN;
output into GLACTBAL.dat
select GB_ACTBAL,GB_BDGBAL,GB_GLOID,GB_OID,GB_PROID, from GLACTBAL;
output into GLDIST.dat
select GD_AMOUNT,GD_EDITFLG,GD_GLOID,GD_OID,GD_OWNFLG,GD_TAOID,GD_TROID,GD_TRTYPE,GD_VISIFLG, from GLDIST;
output into GLHIST.dat
select GH_AMOUNT,GH_DESCR,GH_GLOID,GH_MODDATE,GH_OID,GH_REASON,GH_TROID,GH_TRREFNO,GH_TRTYPE, from GLHIST;
output into MSG.dat
select MS_DESC,MS_OID, from MSG;
output into PRCNTRB.dat
select PC_AMT,PC_CALC,PC_ENOID,PC_GLEXP,PC_GLLIAB,PC_OID,PC_TROID, from PRCNTRB;
output into PRDEDUCT.dat
select PD_AMT,PD_CALC,PD_EDOID,PD_GLOID,PD_OID,PD_TROID, from PRDEDUCT;
output into PREARN.dat
select PE_AMT,PE_EEOID,PE_GLOID,PE_HOURS,PE_OID,PE_RATE,PE_TROID, from PREARN;
output into PREMFICA.dat
select PF_AMT,PF_GLEXP,PF_GLLIAB,PF_OID,PF_SUBJTO,PF_TROID,PF_TYPE, from PREMFICA;
output into PRTRAN.dat
select PH_ADDR1,PH_ADDR2,PH_CITY,PH_CONTRIB,PH_CYCLE1,PH_CYCLE2,PH_CYCLE3,PH_CYCLE4,PH_CYCLE5,PH_CYCLE6,PH_DEDUCT,PH_FREQ,PH_FROM,PH_GROSS,PH_HOURS,PH_MEMO,PH_NAME,PH_STATE,PH_TO,PH_WITHHLD,PH_ZIP,TR_AMT,TR_BKOID,TR_CBNKIND,TR_CDOID,TR_DATE,TR_DESC,TR_EDITFLG,TR_GSTAMT,TR_HISTFLG,TR_OID,TR_PRNTIND,TR_PROID,TR_REFNO,TR_REFOID,TR_SESSIND,TR_TYPE,TR_VOIDFLG, from PRTRAN;
output into PRWTHHLD.dat
select PW_AMT,PW_CALC,PW_ERNSUBJ,PW_EWOID,PW_GLOID,PW_OID,PW_SUBJTO,PW_TROID, from PRWTHHLD;
output into TRANSAPP.dat
select TA_AMT,TA_DATE,TA_DISCAMT,TA_DTROID,TA_DTRTYPE,TA_OID,TA_PROID,TA_SESSIND,TA_STROID,TA_STRTYPE, from TRANSAPP;
output into TRANSLIN.dat
select TL_EXTDAMT,TL_GLOID,TL_GSTID,TL_GSTPCT,TL_ITCRDID,TL_ITEMDSC,TL_ITEMTYP,TL_ITOID,TL_OID,TL_ORDQTY,TL_SHIPQTY,TL_STGLOID,TL_STPCT,TL_STTAXID,TL_TROID,TL_UNITPRC, from TRANSLIN;
output into COMPANY.dat
select CO_ADD1,CO_ADD2,CO_CITY,CO_CNTRY,CO_FAX,CO_FDTAXID,CO_LNAME,CO_LOC,CO_NAME,CO_OID,CO_PASWD,CO_PHONE,CO_STATE,CO_STTAXID,CO_TYPE,CO_ZIP, from COMPANY;
output into CUSTCAT.dat
select CC_OID,CC_VALUE, from CUSTCAT;
output into CUSTOMER.dat
select CS_ADDR1,CS_ADDR2,CS_BFWDFLG,CS_CARDID,CS_CCOID,CS_CITY,CS_CONTACT,CS_COUNTRY,CS_CREDLIM,CS_CREDST,CS_FAX,CS_FCHGPCT,CS_GLOID,CS_GTEXPNO,CS_HICRED,CS_INACFLG,CS_NAME,CS_NOTE,CS_OCFLG,CS_OID,CS_PHNEXT,CS_PHONE,CS_PRCCODE,CS_PYOID,CS_SHADDR1,CS_SHADDR2,CS_SHCITY,CS_SHCNTRY,CS_SHNAME,CS_SHSTATE,CS_SHZIP,CS_SROID,CS_STATE,CS_STEXPNO,CS_STMTFLG,CS_STOID,CS_ZIP, from CUSTOMER;
output into EMPLBUCK.dat
select EB_DTOID,EB_OID,EB_TOTAL,EB_TYPE,EB_WBOID, from EMPLBUCK;
output into EMPLCAT.dat
select EC_OID,EC_VALUE, from EMPLCAT;
output into EMPLCNTB.dat
select EN_ACTIVE,EN_AMOUNT,EN_CNOID,EN_CYCLE1,EN_CYCLE2,EN_CYCLE3,EN_CYCLE4,EN_CYCLE5,EN_CYCLE6,EN_EMOID,EN_LIMIT,EN_OID, from EMPLCNTB;
output into EMPLDED.dat
select ED_ACTIVE,ED_AMOUNT,ED_CYCLE1,ED_CYCLE2,ED_CYCLE3,ED_CYCLE4,ED_CYCLE5,ED_CYCLE6,ED_DTOID,ED_EMOID,ED_LIMIT,ED_OID, from EMPLDED;
output into EMPLDEPT.dat
select ET_NAME,ET_OID, from EMPLDEPT;
output into EMPLEARN.dat
select EE_ACTIVE,EE_CYCLE1,EE_CYCLE2,EE_CYCLE3,EE_CYCLE4,EE_CYCLE5,EE_CYCLE6,EE_EGOID,EE_EMOID,EE_LIMIT,EE_OID,EE_PAYRATE,EE_RECHRS, from EMPLEARN;
output into EMPLWH.dat
select EW_ACTIVE,EW_ALLOWS,EW_CR1,EW_CR2,EW_DEXMPT,EW_EMOID,EW_EXAMT,EW_OEXMPT,EW_OID,EW_PEXMPT,EW_WHOID, from EMPLWH;
output into GLACCT.dat
select GL_ACCTDEP,GL_ACCTNAM,GL_ACCTNO,GL_BSOID,GL_INACFLG,GL_ISOID,GL_NORMBAL,GL_OID,GL_TYPE, from GLACCT;
output into INVITEM.dat
select IT_ADGLOID,IT_CARDID,IT_CSGLOID,IT_DESC,IT_GSTXOID,IT_ICOID,IT_INACFLG,IT_NOTE,IT_OID,IT_PSTXOID,IT_SLGLOID,IT_TYPE,IT_UNITPR1,IT_UNITPR2,IT_UNITPR3,IT_UNITS,IT_USTXFLG,IT_VENDPNO,IT_VNOID, from INVITEM;
output into VENDCAT.dat
select VC_OID,VC_VALUE, from VENDCAT;
output into VENDOR.dat
select VN_1099FLG,VN_ACCTNO,VN_ADDR1,VN_ADDR2,VN_CARDID,VN_CITY,VN_CONTACT,VN_COUNTRY,VN_DISCFLG,VN_EIN,VN_FAX,VN_GLOID,VN_HOLDFLG,VN_INACFLG,VN_NAME,VN_NOTE,VN_OCFLG,VN_OID,VN_PHNEXT,VN_PHONE,VN_PYOID,VN_STATE,VN_VCOID,VN_ZIP, from VENDOR;
output into BANK.dat
select BK_ACTNO,BK_ACTTYPE,BK_ADDR1,BK_ADDR2,BK_CARDID,BK_CITY,BK_CONTACT,BK_COUNTRY,BK_CUTDATE,BK_ENDBAL,BK_ENDDATE,BK_ENDHBAL,BK_ENDHDAT,BK_FAX,BK_GLOID,BK_HOLDIND,BK_INACFLG,BK_INTOID,BK_NAME,BK_NOTE,BK_OID,BK_PHNEXT,BK_PHONE,BK_STATE,BK_STRBAL,BK_STRDATE,BK_STRHBAL,BK_STRHDAT,BK_SVCOID,BK_TRANSIT,BK_ZIP, from BANK;
output into CONTRIB.dat
select CN_CARDID,CN_EXPOID,CN_LABEL,CN_LIABOID,CN_LIMIT,CN_NAME,CN_OID,CN_TYPE,CN_WXBOX, from CONTRIB;
output into DEDUCT.dat
select DT_CARDID,DT_FED,DT_GLOID,DT_LABEL,DT_LIMIT,DT_LOCAL,DT_MED,DT_NAME,DT_OID,DT_OTHLOC,DT_OTHST,DT_SOCSEC,DT_STATE,DT_TYPE,DT_WXBOX, from DEDUCT;
output into EARNING.dat
select EG_CARDID,EG_EXCLUDE,EG_FED,EG_GLOID,EG_LABEL,EG_LIMIT,EG_LOCAL,EG_MED,EG_NAME,EG_OID,EG_OTHLOC,EG_OTHST,EG_RECHRS,EG_SOCSEC,EG_STATE,EG_TYPE,EG_WXBOX, from EARNING;
output into EMPLOYEE.dat
select EM_942EMP,EM_ADDR1,EM_ADDR2,EM_BUCKET,EM_CARDID,EM_CITY,EM_DEAD,EM_DEFCOMP,EM_DOB,EM_DOH,EM_DOT,EM_ECOID,EM_ETOID,EM_FIRST,EM_LAST,EM_LASTREV,EM_LEGREP,EM_MARRIED,EM_NAME,EM_NEXTREV,EM_NOTE,EM_OID,EM_PAYFREQ,EM_PAYTYPE,EM_PENPLAN,EM_PHNEXT,EM_PHONE,EM_PREVPAY,EM_SICK,EM_SOCSEC,EM_STATE,EM_STATEMP,EM_STATUS,EM_SUBTTL,EM_VACAT,EM_ZIP, from EMPLOYEE;
output into ITEMCAT.dat
select IC_OID,IC_VALUE, from ITEMCAT;
output into SHIPVIA.dat
select SV_DESC,SV_OID, from SHIPVIA;
output into SLTAX.dat
select ST_GSTFLG,ST_GSTLTR,ST_NAME,ST_OID,ST_PRGLOID,ST_PTAXPCT,ST_SLGLOID,ST_STAXPCT,ST_TAXID,ST_TYPE, from SLTAX;
output into W2BOX.dat
select WX_BOX,WX_CONTRIB,WX_CTBSIGN,WX_DEDSIGN,WX_DEDUCT,WX_DESC,WX_EARNING,WX_ERNSIGN,WX_OID,WX_TYPE,WX_WHSIGN,WX_WITHHLD,WX_YEAR, from W2BOX;
output into W2BUCK.dat
select WB_EMOID,WB_OID,WB_TOTAL,WB_WXOID,WB_YEAR, from W2BUCK;
output into WITHHOLD.dat
select WH_CALC,WH_CARDID,WH_CMPNYID,WH_CREDIT1,WH_CREDIT2,WH_DOLLAR,WH_FORMULA,WH_GLOID,WH_LABEL,WH_LASTUPD,WH_LIMIT,WH_NAME,WH_OID,WH_PERCENT,WH_ROUND,WH_TYPE,WH_USERMOD,WH_WXBOX, from WITHHOLD;
output into AGEGRP.dat
select AG_GRP,AG_MAXDAY,AG_MINDAY,AG_OID,AG_PERIOD,AG_TITLE, from AGEGRP;
output into BSSECT.dat
select BS_DETIND,BS_EDITFMT,BS_ENDACCT,BS_FORMAT,BS_FTRIND,BS_GRPUNDR,BS_HDRIND,BS_LVL1OID,BS_LVL2OID,BS_LVL3OID,BS_LVL4OID,BS_LVL5OID,BS_LVL6OID,BS_NAME,BS_NORMBAL,BS_OID,BS_SECLEV,BS_STACCT,BS_TYPE, from BSSECT;
output into ISSECT.dat
select IS_DETIND,IS_EDITFMT,IS_ENDACCT,IS_FORMAT,IS_FTRIND,IS_GRPUNDR,IS_HDRIND,IS_LVL1OID,IS_LVL2OID,IS_LVL3OID,IS_LVL4OID,IS_LVL5OID,IS_LVL6OID,IS_NAME,IS_NORMBAL,IS_OID,IS_SECLEV,IS_STACCT,IS_TYPE, from ISSECT;
output into PAYTERMS.dat
select PY_DISCDAY,PY_DISCDTE,PY_DISCPCT,PY_DUEDATE,PY_DUEDAYS,PY_NAME,PY_OID,PY_TYPE, from PAYTERMS;
output into PERIOD.dat
select PR_EDATE,PR_FISCYR,PR_NUM,PR_OID,PR_SDATE,PR_STAT, from PERIOD;
output into SALESREP.dat
select SR_INITLS,SR_NAME,SR_OID, from SALESREP;
output into TAXTABLE.dat
select TT_AMOUNT,TT_EXCESS,TT_NOTOVER,TT_OID,TT_OVER,TT_PERCENT,TT_WHOID, from TAXTABLE;
output into FORMCMPY.dat
select FC_FEOID,FC_FRMTYPE,FC_LASTNUM,FC_OID,FC_PNUMFLG,FC_PRDEV,FC_PRDRV,FC_PRPORT,FC_PRT0FLG,FC_RTADDR,FC_TXIDFLG,FC_VNTEFLG, from FORMCMPY;
output into CONFIG.dat
select cf_id,cf_name,cf_value,dd_id, from CONFIG;
output into CTLACCT.dat
select CA_GLOID,CA_OID,CA_TYPE, from CTLACCT;
output into OIDS.dat
select OD_TABLEID, OD_NEXTAVL, from OIDS;
Disconnect;
DeleteDB;
CloneDB;
Connect;
DELETE FROM GLDIST;
DELETE FROM INVITEM;
DELETE FROM ITEMCAT;
DELETE FROM TRANSAPP;
DELETE FROM TRANSLIN;
DELETE FROM ARTRAN;
DELETE FROM APTRAN;
DELETE FROM PRWTHHLD;
DELETE FROM PREMFICA;
DELETE FROM PRDEDUCT;
DELETE FROM PREARN;
DELETE FROM PRCNTRB;
DELETE FROM PRTRAN;
DELETE FROM BKTRAN;
DELETE FROM GJTRAN;
COMMIT;
DELETE FROM CUSTCAT;
DELETE FROM CUSTOMER;
COMMIT;
DELETE FROM VENDCAT;
DELETE FROM VENDOR;
COMMIT;
DELETE FROM W2BUCK;
DELETE FROM EMPLBUCK;
DELETE FROM EMPLEARN;
DELETE FROM EMPLDED;
DELETE FROM EMPLWH;
DELETE FROM EMPLCAT;
DELETE FROM EMPLCNTB;
DELETE FROM EMPLDEPT;
DELETE FROM EMPLOYEE;
DELETE FROM EARNING;
DELETE FROM DEDUCT;
DELETE FROM WITHHOLD;
DELETE FROM CONTRIB;
DELETE FROM TAXTABLE;
DELETE FROM W2BOX;
COMMIT;
DELETE FROM BANK;
DELETE FROM SALESREP;
DELETE FROM SHIPVIA;
COMMIT;
DELETE FROM SLTAX;
COMMIT;
DELETE FROM GLHIST;
DELETE FROM GLACTBAL;
COMMIT;
DELETE FROM CTLACCT;
COMMIT;
DELETE FROM GLACCT;
COMMIT;
DELETE FROM ISSECT;
COMMIT;
DELETE FROM BSSECT;
COMMIT;
DELETE FROM PAYTERMS;
COMMIT;
DELETE FROM SALESREP;
COMMIT;
DELETE FROM PERIOD;
COMMIT;
DELETE FROM AGEGRP;
COMMIT;
DELETE FROM COMPANY;
DELETE FROM FORMCMPY;
COMMIT;
DELETE FROM CNTBSEED;
DELETE FROM DEDSEED;
DELETE FROM EARNSEED;
DELETE FROM WHSEED;
DELETE FROM W2BOX;
DELETE FROM TTSEED;
DELETE FROM CONFIG;
DELETE FROM MSG;
COMMIT;
DELETE FROM OIDS;
COMMIT;
input from FORMCMPY.dat
into FORMCMPY(FC_FEOID,FC_FRMTYPE,FC_LASTNUM,FC_OID,FC_PNUMFLG,FC_PRDEV,FC_PRDRV,FC_PRPORT,FC_PRT0FLG,FC_RTADDR,FC_TXIDFLG,FC_VNTEFLG);
COMMIT;
input from MSG.dat
into MSG(MS_DESC,MS_OID);
COMMIT;
input from AGEGRP.dat
into AGEGRP(AG_GRP,AG_MAXDAY,AG_MINDAY,AG_OID,AG_PERIOD,AG_TITLE);
COMMIT;
input from PERIOD.dat
into PERIOD(PR_EDATE,PR_FISCYR,PR_NUM,PR_OID,PR_SDATE,PR_STAT);
COMMIT;
input from SALESREP.dat
into SALESREP(SR_INITLS,SR_NAME,SR_OID);
COMMIT;
input from SHIPVIA.dat
into SHIPVIA(SV_DESC,SV_OID);
COMMIT;
input from PAYTERMS.dat
into PAYTERMS(PY_DISCDAY,PY_DISCDTE,PY_DISCPCT,PY_DUEDATE,PY_DUEDAYS,PY_NAME,PY_OID,PY_TYPE);
COMMIT;
input from BSSECT.dat
into BSSECT(BS_DETIND,BS_EDITFMT,BS_ENDACCT,BS_FORMAT,BS_FTRIND,BS_GRPUNDR,BS_HDRIND,BS_LVL1OID,BS_LVL2OID,BS_LVL3OID,BS_LVL4OID,BS_LVL5OID,BS_LVL6OID,BS_NAME,BS_NORMBAL,BS_OID,BS_SECLEV,BS_STACCT,BS_TYPE);
COMMIT;
input from ISSECT.dat
into ISSECT(IS_DETIND,IS_EDITFMT,IS_ENDACCT,IS_FORMAT,IS_FTRIND,IS_GRPUNDR,IS_HDRIND,IS_LVL1OID,IS_LVL2OID,IS_LVL3OID,IS_LVL4OID,IS_LVL5OID,IS_LVL6OID,IS_NAME,IS_NORMBAL,IS_OID,IS_SECLEV,IS_STACCT,IS_TYPE);
COMMIT;
input from GLACCT.dat
into GLACCT(GL_ACCTDEP,GL_ACCTNAM,GL_ACCTNO,GL_BSOID,GL_INACFLG,GL_ISOID,GL_NORMBAL,GL_OID,GL_TYPE);
COMMIT;
input from CTLACCT.dat
into CTLACCT(CA_GLOID,CA_OID,CA_TYPE);
COMMIT;
input from SLTAX.dat
into SLTAX(ST_GSTFLG,ST_GSTLTR,ST_NAME,ST_OID,ST_PRGLOID,ST_PTAXPCT,ST_SLGLOID,ST_STAXPCT,ST_TAXID,ST_TYPE);
input from W2BOX.dat
into W2BOX(WX_BOX,WX_CONTRIB,WX_CTBSIGN,WX_DEDSIGN,WX_DEDUCT,WX_DESC,WX_EARNING,WX_ERNSIGN,WX_OID,WX_TYPE,WX_WHSIGN,WX_WITHHLD,WX_YEAR);
COMMIT;
input from EMPLCAT.dat
into EMPLCAT(EC_OID,EC_VALUE);
COMMIT;
input from EMPLDEPT.dat
into EMPLDEPT(ET_NAME,ET_OID);
COMMIT;
input from EMPLOYEE.dat
into EMPLOYEE(EM_942EMP,EM_ADDR1,EM_ADDR2,EM_BUCKET,EM_CARDID,EM_CITY,EM_DEAD,EM_DEFCOMP,EM_DOB,EM_DOH,EM_DOT,EM_ECOID,EM_ETOID,EM_FIRST,EM_LAST,EM_LASTREV,EM_LEGREP,EM_MARRIED,EM_NAME,EM_NEXTREV,EM_NOTE,EM_OID,EM_PAYFREQ,EM_PAYTYPE,EM_PENPLAN,EM_PHNEXT,EM_PHONE,EM_PREVPAY,EM_SICK,EM_SOCSEC,EM_STATE,EM_STATEMP,EM_STATUS,EM_SUBTTL,EM_VACAT,EM_ZIP);
COMMIT;
input from EARNING.dat
into EARNING(EG_CARDID,EG_EXCLUDE,EG_FED,EG_GLOID,EG_LABEL,EG_LIMIT,EG_LOCAL,EG_MED,EG_NAME,EG_OID,EG_OTHLOC,EG_OTHST,EG_RECHRS,EG_SOCSEC,EG_STATE,EG_TYPE,EG_WXBOX);
COMMIT;
input from DEDUCT.dat
into DEDUCT(DT_CARDID,DT_FED,DT_GLOID,DT_LABEL,DT_LIMIT,DT_LOCAL,DT_MED,DT_NAME,DT_OID,DT_OTHLOC,DT_OTHST,DT_SOCSEC,DT_STATE,DT_TYPE,DT_WXBOX);
COMMIT;
input from WITHHOLD.dat
into WITHHOLD(WH_CALC,WH_CARDID,WH_CMPNYID,WH_CREDIT1,WH_CREDIT2,WH_DOLLAR,WH_FORMULA,WH_GLOID,WH_LABEL,WH_LASTUPD,WH_LIMIT,WH_NAME,WH_OID,WH_PERCENT,WH_ROUND,WH_TYPE,WH_USERMOD,WH_WXBOX);
COMMIT;
input from TAXTABLE.dat
into TAXTABLE(TT_AMOUNT,TT_EXCESS,TT_NOTOVER,TT_OID,TT_OVER,TT_PERCENT,TT_WHOID);
COMMIT;
input from CONTRIB.dat
into CONTRIB(CN_CARDID,CN_EXPOID,CN_LABEL,CN_LIABOID,CN_LIMIT,CN_NAME,CN_OID,CN_TYPE,CN_WXBOX);
COMMIT;
input from BANK.dat
into BANK(BK_ACTNO,BK_ACTTYPE,BK_ADDR1,BK_ADDR2,BK_CARDID,BK_CITY,BK_CONTACT,BK_COUNTRY,BK_CUTDATE,BK_ENDBAL,BK_ENDDATE,BK_ENDHBAL,BK_ENDHDAT,BK_FAX,BK_GLOID,BK_HOLDIND,BK_INACFLG,BK_INTOID,BK_NAME,BK_NOTE,BK_OID,BK_PHNEXT,BK_PHONE,BK_STATE,BK_STRBAL,BK_STRDATE,BK_STRHBAL,BK_STRHDAT,BK_SVCOID,BK_TRANSIT,BK_ZIP);
COMMIT;
input from EMPLCNTB.dat
into EMPLCNTB(EN_ACTIVE,EN_AMOUNT,EN_CNOID,EN_CYCLE1,EN_CYCLE2,EN_CYCLE3,EN_CYCLE4,EN_CYCLE5,EN_CYCLE6,EN_EMOID,EN_LIMIT,EN_OID);
COMMIT;
input from EMPLDED.dat
into EMPLDED(ED_ACTIVE,ED_AMOUNT,ED_CYCLE1,ED_CYCLE2,ED_CYCLE3,ED_CYCLE4,ED_CYCLE5,ED_CYCLE6,ED_DTOID,ED_EMOID,ED_LIMIT,ED_OID);
COMMIT;
input from EMPLEARN.dat
into EMPLEARN(EE_ACTIVE,EE_CYCLE1,EE_CYCLE2,EE_CYCLE3,EE_CYCLE4,EE_CYCLE5,EE_CYCLE6,EE_EGOID,EE_EMOID,EE_LIMIT,EE_OID,EE_PAYRATE,EE_RECHRS);
COMMIT;
input from EMPLWH.dat
into EMPLWH(EW_ACTIVE,EW_ALLOWS,EW_CR1,EW_CR2,EW_DEXMPT,EW_EMOID,EW_EXAMT,EW_OEXMPT,EW_OID,EW_PEXMPT,EW_WHOID);
COMMIT;
input from VENDCAT.dat
into VENDCAT(VC_OID,VC_VALUE);
input from VENDOR.dat
into VENDOR(VN_1099FLG,VN_ACCTNO,VN_ADDR1,VN_ADDR2,VN_CARDID,VN_CITY,VN_CONTACT,VN_COUNTRY,VN_DISCFLG,VN_EIN,VN_FAX,VN_GLOID,VN_HOLDFLG,VN_INACFLG,VN_NAME,VN_NOTE,VN_OCFLG,VN_OID,VN_PHNEXT,VN_PHONE,VN_PYOID,VN_STATE,VN_VCOID,VN_ZIP);
COMMIT;
input from CUSTCAT.dat
into CUSTCAT(CC_OID,CC_VALUE);
input from CUSTOMER.dat
into CUSTOMER(CS_ADDR1,CS_ADDR2,CS_BFWDFLG,CS_CARDID,CS_CCOID,CS_CITY,CS_CONTACT,CS_COUNTRY,CS_CREDLIM,CS_CREDST,CS_FAX,CS_FCHGPCT,CS_GLOID,CS_GTEXPNO,CS_HICRED,CS_INACFLG,CS_NAME,CS_NOTE,CS_OCFLG,CS_OID,CS_PHNEXT,CS_PHONE,CS_PRCCODE,CS_PYOID,CS_SHADDR1,CS_SHADDR2,CS_SHCITY,CS_SHCNTRY,CS_SHNAME,CS_SHSTATE,CS_SHZIP,CS_SROID,CS_STATE,CS_STEXPNO,CS_STMTFLG,CS_STOID,CS_ZIP);
COMMIT;
input from ITEMCAT.dat
into ITEMCAT(IC_OID,IC_VALUE);
input from INVITEM.dat
into INVITEM(IT_ADGLOID,IT_CARDID,IT_CSGLOID,IT_DESC,IT_GSTXOID,IT_ICOID,IT_INACFLG,IT_NOTE,IT_OID,IT_PSTXOID,IT_SLGLOID,IT_TYPE,IT_UNITPR1,IT_UNITPR2,IT_UNITPR3,IT_UNITS,IT_USTXFLG,IT_VENDPNO,IT_VNOID);
COMMIT;
input from APTRAN.dat
into APTRAN(TH_MSG,TH_SHIPAD1,TH_SHIPAD2,TH_SHIPCNY,TH_SHIPCTY,TH_SHIPNAM,TH_SHIPST,TH_SHIPZIP,TR_AMT,TR_AMTAPPL,TR_BAL,TR_BKOID,TR_CBNKIND,TR_CDOID,TR_DATE,TR_DESC,TR_DISCDAT,TR_DISCORG,TR_DISCPCT,TR_DISCTAK,TR_DISCUSD,TR_DUEDATE,TR_EDITFLG,TR_GSTAMT,TR_HISTFLG,TR_OID,TR_PRNTIND,TR_PROID,TR_PYOID,TR_RECRFLG,TR_REFNO,TR_REFOID,TR_SESSIND,TR_STATIND,TR_TYPE,TR_VOIDFLG);
COMMIT;
input from artran.dat
into ARTRAN(TH_BILLAD1,TH_BILLAD2,TH_BILLCNY,TH_BILLCTY,TH_BILLNAM,TH_BILLST,TH_BILLZIP,TH_FRTAMT,TH_FRTAXID,TH_FRTPCT,TH_FSGLOID,TH_INSTRCT,TH_MSG,TH_ORDDATE,TH_PONUM,TH_PRCCODE,TH_SHIPAD1,TH_SHIPAD2,TH_SHIPCNY,TH_SHIPCTY,TH_SHIPFOB,TH_SHIPNAM,TH_SHIPST,TH_SHIPVIA,TH_SHIPZIP,TH_SHPDATE,TH_STOID,TR_AMT,TR_AMTAPPL,TR_BAL,TR_BKOID,TR_CBNKIND,TR_CDOID,TR_DATE,TR_DESC,TR_DISCAMT,TR_DISCDAT,TR_DISCORG,TR_DISCPCT,TR_DISCTAK,TR_DISCUSD,TR_DPSTFLG,TR_DTLFLG,TR_DUEDATE,TR_EDITFLG,TR_GSTAMT,TR_HISTFLG,TR_OID,TR_PRNTIND,TR_PROID,TR_PYOID,TR_RECRFLG,TR_REFNO,TR_REFOID,TR_SESSIND,TR_SRINTLS,TR_STAMT,TR_STATIND,TR_STYLE,TR_TYPE,TR_VOIDFLG);
COMMIT;
input from BKTRAN.dat
into BKTRAN(TR_AMT,TR_BKOID,TR_CBNKIND,TR_DATE,TR_DESC,TR_EDITFLG,TR_HISTFLG,TR_OID,TR_PROID,TR_REFNO,TR_REFOID,TR_REFTYPE,TR_SESSIND,TR_TYPE,TR_VOIDFLG);
input from GJTRAN.dat
into GJTRAN(TH_LNGDECR,TH_ONESIDE,TR_DATE,TR_EDITFLG,TR_HISTFLG,TR_OID,TR_PROID,TR_RECRFLG,TR_REFNO,TR_SESSIND,TR_TYPE,TR_VOIDFLG);
COMMIT;
input from TRANSLIN.dat
into TRANSLIN(TL_EXTDAMT,TL_GLOID,TL_GSTID,TL_GSTPCT,TL_ITCRDID,TL_ITEMDSC,TL_ITEMTYP,TL_ITOID,TL_OID,TL_ORDQTY,TL_SHIPQTY,TL_STGLOID,TL_STPCT,TL_STTAXID,TL_TROID,TL_UNITPRC);
COMMIT;
input from W2BUCK.dat
into W2BUCK(WB_EMOID,WB_OID,WB_TOTAL,WB_WXOID,WB_YEAR);
COMMIT;
input from EMPLBUCK.dat
into EMPLBUCK(EB_DTOID,EB_OID,EB_TOTAL,EB_TYPE,EB_WBOID);
COMMIT;
input from PRTRAN.dat
into PRTRAN(PH_ADDR1,PH_ADDR2,PH_CITY,PH_CONTRIB,PH_CYCLE1,PH_CYCLE2,PH_CYCLE3,PH_CYCLE4,PH_CYCLE5,PH_CYCLE6,PH_DEDUCT,PH_FREQ,PH_FROM,PH_GROSS,PH_HOURS,PH_MEMO,PH_NAME,PH_STATE,PH_TO,PH_WITHHLD,PH_ZIP,TR_AMT,TR_BKOID,TR_CBNKIND,TR_CDOID,TR_DATE,TR_DESC,TR_EDITFLG,TR_GSTAMT,TR_HISTFLG,TR_OID,TR_PRNTIND,TR_PROID,TR_REFNO,TR_REFOID,TR_SESSIND,TR_TYPE,TR_VOIDFLG);
COMMIT;
input from PRCNTRB.dat
into PRCNTRB(PC_AMT,PC_CALC,PC_ENOID,PC_GLEXP,PC_GLLIAB,PC_OID,PC_TROID);
COMMIT;
input from PRDEDUCT.dat
into PRDEDUCT(PD_AMT,PD_CALC,PD_EDOID,PD_GLOID,PD_OID,PD_TROID);
COMMIT;
input from PREARN.dat
into PREARN(PE_AMT,PE_EEOID,PE_GLOID,PE_HOURS,PE_OID,PE_RATE,PE_TROID);
COMMIT;
input from PREMFICA.dat
into PREMFICA(PF_AMT,PF_GLEXP,PF_GLLIAB,PF_OID,PF_SUBJTO,PF_TROID,PF_TYPE);
COMMIT;
input from PRWTHHLD.dat
into PRWTHHLD(PW_AMT,PW_CALC,PW_ERNSUBJ,PW_EWOID,PW_GLOID,PW_OID,PW_SUBJTO,PW_TROID);
COMMIT;
input from TRANSAPP.dat
into TRANSAPP(TA_AMT,TA_DATE,TA_DISCAMT,TA_DTROID,TA_DTRTYPE,TA_OID,TA_PROID,TA_SESSIND,TA_STROID,TA_STRTYPE);
COMMIT;
input from GLDIST.dat
into GLDIST(GD_AMOUNT,GD_EDITFLG,GD_GLOID,GD_OID,GD_OWNFLG,GD_TAOID,GD_TROID,GD_TRTYPE,GD_VISIFLG);
COMMIT;
input from GLHIST.dat
into GLHIST(GH_AMOUNT,GH_DESCR,GH_GLOID,GH_MODDATE,GH_OID,GH_REASON,GH_TROID,GH_TRREFNO,GH_TRTYPE);
COMMIT;
input from COMPANY.dat
into COMPANY(CO_ADD1,CO_ADD2,CO_CITY,CO_CNTRY,CO_FAX,CO_FDTAXID,CO_LNAME,CO_LOC,CO_NAME,CO_OID,CO_PASWD,CO_PHONE,CO_STATE,CO_STTAXID,CO_TYPE,CO_ZIP);
COMMIT;
input from CONFIG.dat
into CONFIG(cf_id,cf_name,cf_value,dd_id);
COMMIT;
input from GLACTBAL.dat
into GLACTBAL(GB_ACTBAL,GB_BDGBAL,GB_GLOID,GB_OID,GB_PROID);
COMMIT;
input from OIDS.dat
into OIDS(OD_TABLEID, OD_NEXTAVL);
COMMIT;
update CONFIG set CF_VALUE=
if substr(cf_value,1,1) = 's' then 
cf_value
else
string('s', substr(cf_value,1,length(cf_value)/2),
'^s',substr(cf_value,length(cf_value)/2+2,length(cf_value) )
)
endif
where CF_ID in (118,119);
COMMIT;
update w2detvw set wb_total = wb_total - eb_total where
wx_box = 'Box 3' and eb_type = 1 and eb_dtoid in
(select eb_dtoid from w2detvw where 
wx_box = 'Box 7' and eb_type = 1);
delete from emplbuck where eb_oid in 
(select eb_oid from w2detvw where 
wx_box = 'Box 3' and eb_type = 1 and eb_dtoid in
(select eb_dtoid from w2detvw where 
wx_box = 'Box 7' and eb_type = 1) );
COMMIT;
update CONFIG set CF_VALUE = '5.0.1'
where CF_ID = 148;
COMMIT;
DeleteFile *.dat;
