 CHANGES FOR DATABASE CHANGES
 *****************************************

 1. CMHDR
    a. New Fields SIDISCTPR,SIDISC1,SIDISC2,SICASHCR
    b. SIDISCTPR will be replaced by SIDISCOUNT
    c. SIDISCOUNT will be replaced by 0 after step b.
    d. SICASHCR will be replaced by :
	   'C' if SINETAMT+SIOTHADJ=SICASHAMT else it will be replaced by 'R'

 2. SIHDR/S2HDR/TOHDR
    a. New Fields SISPCODE,SICASHDT,SICASHAMT
    b. SISPCODE will be replaced by Customer's CUSPCODE
    c. SICASHDT will be replaced by SIDATE
    d. SICASHAMT will be replaced by SINETAMT+SIOTHADJ if SICASHCR=='C'

 3. FRFMDTL
    a. New Fields FDQTY1,FDQTY2,FDQTY3
    b. FDQTY1 Will be replaced by FDQTY

 4. FRFMHDR
    a. New Fields FHORDPER1,FHORDPER2,FHORDPER3
    b. FHORDPER1 Will be replaced by 100.00 
		if  FHORDPER1+FHORDPER2+FHORDPER3=0

  5. Supplier New DBF
     a. Records from Account for Supplier Schedule will append in sup master
     b. Records from PIHDR,TIHDR,CHLNHDR will append in Supplier master 
		(for each princple)

  6. BankMas New Dbf
     a. Bank Names & Address form customer master will append in bankmas

  7. BankMas New Dbf
     a. Transport names form customer master will append in bankmas

  8. GLPART New dbf
	 i) VHeader
  	  a. VHPART is posted to GLPART.DBF
		 if VHPART is empty
		 with following detail :  VHVTSERIES,VHNO,space(2) as ISNO
      a. Old Field VHPART Removed

    ii) GRLEDGER
  	  a. GLPART is posted to GLPART.DBF
		 if GHPART is empty and Narration in VHeader (VHPART) is != GLPART
		 with following detail : GLVTSERIES,GLVHNO,GLISNO as ISNO
      a. Old Field GLPART Removed

    iii) Posting in GLPART.DBF for one voucher is done as
         a. replaced GPVTSERIES with VTSERIES
         b. replaced GPVHNO     with VHNO
         c. replaced GPISNO     with ISNO
         d. replaced GPSEQNO    with 1
         e. replaced GPPART     with first 40 chars of PART
         f. if lenght of PART is > 40 then repeate a to c and
            replaced GPSEQNO    with 2
            replaced GPPART     with second 40 chars of PART


Continue....













  9. CrDrDtl
     a. NewField CDSICMSR,CDSICMNO,CDRTTYPE
     b. CDSTOCKIST will be replaced by CRDRHDR->CHSTOCKIST
     c. CDSICMSR   will be replaced by CRDRHDR->CHSICMSR
     d. CDSICMNO   will be replaced by CRDRHDR->CHSICMNO
     e. CDRTTYPE   will be replaced :
        by 'M' if CRDRHDR->CHSERIES $ 'mwdb' else CRDRHDR->CHRTTYPE
   	 f. CDSeqNo    will be replace  by CRDRHDR->CHSICMNO if CDSERIES $ 'wdb'
     g. CDSERIES   will be replaced :
		By 'c' if CRDRHDR->CHSERIES='w'
		By 's' if CRDRHDR->CHSERIES='d'
		By 'a' if CRDRHDR->CHSERIES='b'

 10. CrDrHdr
     a. NewField CHREPLBAL
     b. CHREPLBAL will be replaced by CHNETAMT for CHSERIES $ 'mwdb'
     c. CHREPLDATE is empty and record exist in CRDRDTL for CDTYPE $ 'MT' 
        of this	credit note then CHREPLDATE will be replaced by CHDATE

	 d. CHADJ will be replaced by .t.
		if CHSERIES='m' and (CHREPLDATE is empty or CMSICMNO is not empty)


     e. if CHSERIES ='w'
      	  i) ChSeqNo  will be replace  by CHSICMNO
  	     ii) CHSERIES will be replaced By c
  	    iii) Trans in stock for 'x'+chseqno will be replace with 'c'+CHSICMNO
   	     iv) Trans in Stock for 'w'+chseqno will be replace with 'w'+CHSICMNO


     f. if CHSERIES ='d'
      	  i) ChSeqNo  will be replace  by CHSICMNO
  	     ii) CHSERIES will be replaced By s
	   iii) Trans in stock for 'y'+chseqno will be replace with 's'+CHSICMNO
   	    iv) Trans in stock for 'd'+chseqno will be replace with 'd'+CHSICMNO

     g. if CHSERIES ='b'
      	  i) ChSeqNo  will be replace  by CHSICMNO
  	     ii) CHSERIES will be replaced By a
	    iii) Trans in stock for 'z'+chseqno will be replace with 'a'+CHSICMNO
   	     vi) Trans in stock for 'b'+chseqno will be replace with 'b'+CHSICMNO



























