*********************************************************************
DATA BASE CHANGES IN UNISOLVE 6.1 (To run with windows)
*********************************************************************
FILE NAME       OLD FIELD DESCRIPTION      NEW FIELD DESCRIPTION  
*********************************************************************
PRODUCT.DBF     PDOPFRQTY      N    9    1 PDOPFRQTY      N   10    2 
				PDFRTRANS      N    9    1 PDFRTRANS      N   10    2 
				PDCURFRQTY     N    9    1 PDCURFRQTY     N   10    2 
-------------------------------------------------------------------------
FREE.DBF		FRQTY          N   10    0 FRQTY          N   12    2 
-------------------------------------------------------------------------
GROUP.DBF		New Field                  GPLIBLESS      N    8    2
				New Field                  GPLEBLESS      N    8    2
				New Field                  GPLIRLESS      N    8    2
				New Field                  GPLERLESS      N    8    2
-------------------------------------------------------------------------
BATCH.DBF       BHOPFRQTY      N    9    1 BHOPFRQTY      N   10    2 
				BHFRTRANS      N    9    1 BHFRTRANS      N   10    2 
				BHCURFRQTY     N    9    1 BHCURFRQTY     N   10    2 
				New Field                  BHINACTIVE     L    1    0
-------------------------------------------------------------------------
EXBATCH.DBF		New Field                  BHINACTIVE     L    1    0
-------------------------------------------------------------------------
SCHMAS.DBF		New Field                  SMBHNO         C   10    0
				New Field                  SMSDISCOUN     N    7    2
				New Field                  SMSDISCTYP     C    1    0
-------------------------------------------------------------------------
MSR.DBF			New Field                  MRMGCODE       C    5    0
				New Field                  MRADDRESS1     C   30    0
				New Field                  MRADDRESS2     C   30    0
				New Field                  MRADDRESS3     C   30    0
				New Field                  MRSTATION      C   15    0
				New Field                  MRPINCODE      C    7    0
				New Field                  MRPHONE1       C   20    0
				New Field                  MRPHONE2       C   20    0
-------------------------------------------------------------------------
SIHDR.DBF &     SIMTRNO        C   10    0 SIMTRNO        C   20    0 
SI2HDR.DBF &    New Field                  SILOOSECS      N    3    0
TOHDR.DBF		New Field                  SICDISCRT      N    6    2
				New Field                  SICDISCON      N   10    2
				New Field                  SIDDNO         C   10    0
				New Field                  SIDDDT         D    8    0
				New Field                  SIDDBANK       C   30    0
-------------------------------------------------------------------------
CMHDR.DBF		CMDISCOUNT     N    7    4 CMDISCOUNT     N    8    4 
				New Field                  CMDISCTPR      N    7    4
				New Field                  CMCDISCRT      N    6    2
				New Field                  CMCDISCON      N   10    2
				New Field                  CMCASHCR       C    1    0
				New Field                  CMORDERNO      C   10    0
				New Field                  CMORDATE       D    8    0
				New Field                  CMORDRCPTD     D    8    0
				New Field                  CMBANK         C   30    0
				New Field                  CMDRAFTNO      C   10    0
				New Field                  CMDRAFTDAT     D    8    0
				New Field                  CMTRANS        C   30    0
				New Field                  CMMTRNO        C   20    0
				New Field                  CMMTRDATE      D    8    0
				New Field                  CMCASES        N    5    0
				New Field                  CMLOOSECS      N    3    0
				New Field                  CMFREIGHT      N    7    2
				New Field                  CMOCTROI       N    8    2
				New Field                  CMDISC1        N    6    2
				New Field                  CMDISC2        N    5    2
				New Field                  CMPERMITNO     C   20    0
				New Field                  CMDDNO         C   10    0
				New Field                  CMDDDT         D    8    0
				New Field                  CMDDBANK       C   30    0
-------------------------------------------------------------------------
FRFMHDR.DBF		New Field                  FHORDPER1      N    6    2
				New Field                  FHORDPER2      N    5    2
				New Field                  FHORDPER3      N    5    2
				New Field                  FHCASELOT      L    1    0
				New Field                  FHURCODE       C    5    0
				New Field                  FHTIME         C    5    0
				New Field                  FHPRINTED      L    1    0
-------------------------------------------------------------------------
FRFMDTL.DBF		New Field                  FDQTY1         N    5    0
				New Field                  FDQTY2         N    5    0
				New Field                  FDQTY3         N    5    0
				New Field                  FDREMARK       C   40    0
				New Field                  FDDISC         N    7    3
-------------------------------------------------------------------------
CHLNHDR.DBF		New Field                  LHURCODE       C    5    0
				New Field                  LHTIME         C    5    0
				New Field                  LHPRINTED      L    1    0
-------------------------------------------------------------------------
CHLNDTL.DBF		New Field                  LDFREEQTY      N    8    2
				New Field                  LDSCHBASE      N    4    0
				New Field                  LDSCHFREE      N    3    0
-------------------------------------------------------------------------
CRDRHDR.DBF		CHREFNO        C   10    0 CHREFNO        C   20    0 
CR2HDR.DBF		CHGRNO         C   10    0 CHGRNO         C   20    0 
				New Field                  CHREPLBAL      N   10    2
				New Field                  CHURCODE       C    5    0
				New Field                  CHTIME         C    5    0
				New Field                  CHPRINTED      L    1    0
-------------------------------------------------------------------------
CRDRDTL.DBF		CDBASEQTY      N    3    0 CDBASEQTY      N    4    0 
CR2DTL.DBF		CDFREEQTY      N    2    0 CDFREEQTY      N    3    0 
				New Field                  CDSTOCKIST     C    7    0
				New Field                  CDSICMSR       C    1    0
				New Field                  CDSICMNO       N    6    0
				New Field                  CDRTTYPE       C    1    0
-------------------------------------------------------------------------
PIHDR.DBF		PIINVNO        C   20    0 PIINVNO        C    8    0 
				PIGRNO         C   10    0 PIGRNO         C   20    0 
				New Field                  PICRDRSR       C    1    0
				New Field                  PICRDRNO       N    6    0
				New Field                  PIURCODE       C    5    0
				New Field                  PITIME         C    5    0
				New Field                  PIPRINTED      L    1    0
-------------------------------------------------------------------------
PKHDR.DBF		New Field                  PHNETAMT       N   10    2
				New Field                  PHCASHCR       C    1    0
				New Field                  PHURCODE       C    5    0
				New Field                  PHTIME         C    5    0
				New Field                  PHPRINTED      L    1    0
-------------------------------------------------------------------------
PACKING.DBF		PKFREEQTY      N    6    1 PKFREEQTY      N    8    2 
				New Field                  PKSCHBASE      N    4    0
				New Field                  PKSCHFREE      N    3    0
-------------------------------------------------------------------------
STOCK.DBF		STFREEQTY      N    6    1 STFREEQTY      N    8    2 
				New Field                  STSCHBASE      N    4    0
				New Field                  STSCHFREE      N    3    0
-------------------------------------------------------------------------
TAXTYPE.DBF		TXABTRATE      N    8    5 TXABTRATE      N    9    5 
				TXCSTRATE      N    5    2 TXCSTRATE      N    8    4 
				TXRSTRATE      N    5    2 TXRSTRATE      N    8    4 
				TXLESSBY       N    5    2 TXLESSBY       N    8    4 
				TXSCHRG        N    7    4 TXSCHRG        N    8    4 
				TXADSCHRG      N    7    4 TXADSCHRG      N    8    4 
				TXABATERT      N    7    4 TXABATERT      N    8    4 
				TXPROMORT      N    7    4 TXPROMORT      N    8    4 
				New Field                  TXCSTFLAG      L    1    0
				New Field                  TXRPOSTAC      C    7    0
				New Field                  TXBPOSTAC      C    7    0
				New Field                  TXEPOSTAC      C    7    0
				New Field                  TXTAXDESC      C   15    0
				New Field                  TXSCDESC       C   15    0
				New Field                  TXADSCDESC     C   15    0
				New Field                  TXSCON         C    1    0
				New Field                  TXADSCON       C    1    0
				New Field                  TXINCLINRT     N    8    4
-------------------------------------------------------------------------
CUSTOMER.DBF	CUSCISNO       N    2    0 CUSCISNO       N    3    0 
				New Field                  CUDUEPKAMT     N   12    2
				New Field                  CUCRLOCKDY     N    3    0
				New Field                  CURATEHIKE     N    5    2
-------------------------------------------------------------------------
BANKLET.DBF		New Field                  BLLOOSECS      N    5    0
-------------------------------------------------------------------------
SPMAS.DBF		New Field                  SPCRLOCKDY     N    3    0
-------------------------------------------------------------------------
RCDTL1.DBF		RD1AMTRECD     N    9    2 RD1AMTRECD     N   10    2 
-------------------------------------------------------------------------
BKDETAIL.DBF	BDSCISNO       N    2    0 BDSCISNO       N    3    0 
-------------------------------------------------------------------------
SCHEDULE.DBF	SCISNO         N    2    0 SCISNO         N    3    0 
				SCMISNO        N    2    0 SCMISNO        N    3    0 
-------------------------------------------------------------------------
ACCOUNT.DBF		ACSCISNO       N    2    0 ACSCISNO       N    3    0 
-------------------------------------------------------------------------
VHEADER.DBF		VHPART         C   80    0 Removed             
				New Field                  VHPRTOLD       C    1    0
-------------------------------------------------------------------------
GRLEDGER.DBF	GLPART         C   80    0 Removed             
				New Field                  GLPRTOLD       C    1    0
-------------------------------------------------------------------------
IHEADER.DBF		IHSCISNO       N    2    0 IHSCISNO       N    3    0 
				New Field                  IHETYPE        C    1    0
-------------------------------------------------------------------------
ACADDRES.DBF	New Field                  ACCSTNO        C   20    0
				New Field                  ACPAN          C   10    0
-------------------------------------------------------------------------
VERINFO.DBF		New Field                  VERID          C   12    0
				New Field                  VERPCCODE      C    1    0









*************************************************************************
							INDEX CHANGES
*************************************************************************
DISCMAS.DBF	Old Index -> MDCUCODE+MDGPCODE+MDPDCODE
			New Index -> MDCUCODE+MDGPCODE+MDPDCODE+Str(MDMINAMT,9,2)
-------------------------------------------------------------------------
SCHMAS.DBF	Old Index -> SMSR+SMPDCODE+DTOS(SMIDATE)+STR(SMBASEQTY,4)
		    New Index -> SMSR+SMPDCODE+SMBHNO+DTOS(SMIDATE)+STR(SMBASEQTY,4)
-------------------------------------------------------------------------
MS.DBF		New Index -> MSMRCODE+MSCUCODE
-------------------------------------------------------------------------
CRDRDTL		New Index -> CDSICMSR+PADL(CDSICMNO,6,"0")
			New Index -> CDSTOCKIST+CDSERIES+PADL(CDSEQNO,6,"0")
-------------------------------------------------------------------------
CR2DTL		New Index -> CDSICMSR+PADL(CDSICMNO,6,"0")
			New Index -> CDSTOCKIST+CDSERIES+PADL(CDSEQNO,6,"0")
-------------------------------------------------------------------------
PIHDR.DBF	New Index -> PISPCD+PADL(UPPER(ALLTRIM(PIINVNO)),20,'0')
TIHDR.DBF	New Index -> PISPCD+PADL(UPPER(ALLTRIM(PIINVNO)),20,'0')
-------------------------------------------------------------------------
ACCOUNT.DBF	Old Index -> PADL(ACSCISNO,2,"0")+UPPER(ACNAME)
		    New Index -> PADL(ACSCISNO,3,"0")+UPPER(ACNAME)
-------------------------------------------------------------------------
LOCALITY	Old Index -> LOCNAME
		    New Index -> UPPER(LOCNAME)
-------------------------------------------------------------------------
USER.DBF	Old Index -> URNAME
		    New Index -> Upper(URNAME)
-------------------------------------------------------------------------
VERINFO		Old Index -> DTOS(VERDATE)
		    New Index -> VERID+DTOS(VERDATE)
-------------------------------------------------------------------------