use ‘xxx’ (database) go insert pop10100 (PONUMBER ,POSTATUS ,STATGRP ,POTYPE ,USER2ENT ,CONFIRM1 ,DOCDATE ,LSTEDTDT ,LSTPRTDT ,PRMDATE ,PRMSHPDTE ,REQDATE ,REQTNDT ,SHIPMTHD ,TXRGNNUM ,REMSUBTO ,SUBTOTAL ,TRDISAMT ,FRTAMNT ,MSCCHAMT ,TAXAMNT ,VENDORID ,VENDNAME ,MINORDER ,VADCDPAD ,CMPANYID ,PRBTADCD ,PRSTADCD ,CMPNYNAM ,CONTACT ,ADDRESS1 ,ADDRESS2 ,ADDRESS3 ,CITY ,[STATE] ,ZIPCODE ,CCode ,COUNTRY ,PHONE1 ,PHONE2 ,PHONE3 ,FAX ,PYMTRMID ,DSCDLRAM ,DSCPCTAM ,DISAMTAV ,DISCDATE ,DUEDATE ,TRDPCTPR ,CUSTNMBR ,TIMESPRT ,CREATDDT ,MODIFDT ,PONOTIDS_1 ,PONOTIDS_2 ,PONOTIDS_3 ,PONOTIDS_4 ,PONOTIDS_5 ,PONOTIDS_6 ,PONOTIDS_7 ,PONOTIDS_8 ,PONOTIDS_9 ,PONOTIDS_10 ,PONOTIDS_11 ,PONOTIDS_12 ,PONOTIDS_13 ,PONOTIDS_14 ,PONOTIDS_15 ,COMMNTID ,CANCSUB ,CURNCYID ,CURRNIDX ,RATETPID ,EXGTBLID ,XCHGRATE ,EXCHDATE ,TIME1 ,RATECALC ,DENXRATE ,MCTRXSTT ,OREMSUBT ,ORSUBTOT ,Originating_Canceled_Sub ,ORTDISAM ,ORFRTAMT ,OMISCAMT ,ORTAXAMT ,ORDDLRAT ,ODISAMTAV ,BUYERID ,ALLOWSOCMTS ,DISGRPER ,DUEGRPER ,Revision_Number ,TAXSCHID ,TXSCHSRC ,BSIVCTTL ,Purchase_Freight_Taxable ,Purchase_Misc_Taxable ,FRTSCHID ,MSCSCHID ,FRTTXAMT ,ORFRTTAX ,MSCTXAMT ,ORMSCTAX ,BCKTXAMT ,OBTAXAMT ,BackoutFreightTaxAmt ,OrigBackoutFreightTaxAmt ,BackoutMiscTaxAmt ,OrigBackoutMiscTaxAmt ,Flags ,POPCONTNUM ,CONTENDDTE ,CNTRLBLKTBY ,PURCHCMPNYNAM ,PURCHCONTACT ,PURCHADDRESS1 ,PURCHADDRESS2 ,PURCHADDRESS3 ,PURCHCITY ,PURCHSTATE ,PURCHZIPCODE ,PURCHCCode ,PURCHCOUNTRY ,PURCHPHONE1 ,PURCHPHONE2 ,PURCHPHONE3 ,PURCHFAX ,BLNKTLINEEXTQTYSUM ) select PONUMBER ,POSTATUS ,STATGRP ,POTYPE ,USER2ENT ,CONFIRM1 ,DOCDATE ,LSTEDTDT ,LSTPRTDT ,PRMDATE ,PRMSHPDTE ,REQDATE ,REQTNDT ,SHIPMTHD ,TXRGNNUM ,REMSUBTO ,SUBTOTAL ,TRDISAMT ,FRTAMNT ,MSCCHAMT ,TAXAMNT ,VENDORID ,VENDNAME ,MINORDER ,VADCDPAD ,CMPANYID ,PRBTADCD ,PRSTADCD ,CMPNYNAM ,CONTACT ,ADDRESS1 ,ADDRESS2 ,ADDRESS3 ,CITY ,[STATE] ,ZIPCODE ,CCode ,COUNTRY ,PHONE1 ,PHONE2 ,PHONE3 ,FAX ,PYMTRMID ,DSCDLRAM ,DSCPCTAM ,DISAMTAV ,DISCDATE ,DUEDATE ,TRDPCTPR ,CUSTNMBR ,TIMESPRT ,CREATDDT ,MODIFDT ,PONOTIDS_1 ,PONOTIDS_2 ,PONOTIDS_3 ,PONOTIDS_4 ,PONOTIDS_5 ,PONOTIDS_6 ,PONOTIDS_7 ,PONOTIDS_8 ,PONOTIDS_9 ,PONOTIDS_10 ,PONOTIDS_11 ,PONOTIDS_12 ,PONOTIDS_13 ,PONOTIDS_14 ,PONOTIDS_15 ,COMMNTID ,CANCSUB ,CURNCYID ,CURRNIDX ,RATETPID ,EXGTBLID ,XCHGRATE ,EXCHDATE ,TIME1 ,RATECALC ,DENXRATE ,MCTRXSTT ,OREMSUBT ,ORSUBTOT ,Originating_Canceled_Sub ,ORTDISAM ,ORFRTAMT ,OMISCAMT ,ORTAXAMT ,ORDDLRAT ,ODISAMTAV ,BUYERID ,ALLOWSOCMTS ,DISGRPER ,DUEGRPER ,Revision_Number ,TAXSCHID ,TXSCHSRC ,BSIVCTTL ,Purchase_Freight_Taxable ,Purchase_Misc_Taxable ,FRTSCHID ,MSCSCHID ,FRTTXAMT ,ORFRTTAX ,MSCTXAMT ,ORMSCTAX ,BCKTXAMT ,OBTAXAMT ,BackoutFreightTaxAmt ,OrigBackoutFreightTaxAmt ,BackoutMiscTaxAmt ,OrigBackoutMiscTaxAmt ,Flags ,POPCONTNUM ,CONTENDDTE ,CNTRLBLKTBY ,PURCHCMPNYNAM ,PURCHCONTACT ,PURCHADDRESS1 ,PURCHADDRESS2 ,PURCHADDRESS3 ,PURCHCITY ,PURCHSTATE ,PURCHZIPCODE ,PURCHCCode ,PURCHCOUNTRY ,PURCHPHONE1 ,PURCHPHONE2 ,PURCHPHONE3 ,PURCHFAX ,BLNKTLINEEXTQTYSUM from POP30100 where ponumber = 'P0xxxxxx' insert POP10110 ( PONUMBER ,ORD ,POLNESTA ,POTYPE ,ITEMNMBR ,ITEMDESC ,VENDORID ,VNDITNUM ,VNDITDSC ,NONINVEN ,LOCNCODE ,UOFM ,UMQTYINB ,QTYORDER ,QTYCANCE ,UNITCOST ,EXTDCOST ,INVINDX ,REQDATE ,PRMDATE ,PRMSHPDTE ,REQSTDBY ,COMMNTID ,DOCTYPE ,POLNEARY_1 ,POLNEARY_2 ,POLNEARY_3 ,POLNEARY_4 ,POLNEARY_5 ,POLNEARY_6 ,POLNEARY_7 ,POLNEARY_8 ,POLNEARY_9 ,DECPLCUR ,DECPLQTY ,ITMTRKOP ,VCTNMTHD ,BRKFLD1 ,JOBNUMBR ,COSTCODE ,COSTTYPE ,CURRNIDX ,ORUNTCST ,OREXTCST ,LINEORIGIN ,FREEONBOARD ,ODECPLCU ,Product_Indicator ,Source_Document_Number ,Source_Document_Line_Num ,RELEASEBYDATE ,Released_Date ,Purchase_IV_Item_Taxable ,Purchase_Item_Tax_Schedu ,Purchase_Site_Tax_Schedu ,PURCHSITETXSCHSRC ,BSIVCTTL ,TAXAMNT ,ORTAXAMT ,BCKTXAMT ,OBTAXAMT ,Landed_Cost_Group_ID ,SHIPMTHD ,LineNumber ,ORIGPRMDATE ,FSTRCPTDT ,LSTRCPTDT ,RELEASE ,ADRSCODE ,CMPNYNAM ,CONTACT ,ADDRESS1 ,ADDRESS2 ,ADDRESS3 ,CITY ,STATE ,ZIPCODE ,CCode ,COUNTRY ,PHONE1 ,PHONE2 ,PHONE3 ,FAX ,ADDRSOURCE ,Flags ,ProjNum ,CostCatID ) SELECT PONUMBER ,ORD ,POLNESTA ,POTYPE ,ITEMNMBR ,ITEMDESC ,VENDORID ,VNDITNUM ,VNDITDSC ,NONINVEN ,LOCNCODE ,UOFM ,UMQTYINB ,QTYORDER ,QTYCANCE ,UNITCOST ,EXTDCOST ,INVINDX ,REQDATE ,PRMDATE ,PRMSHPDTE ,REQSTDBY ,COMMNTID ,DOCTYPE ,POLNEARY_1 ,POLNEARY_2 ,POLNEARY_3 ,POLNEARY_4 ,POLNEARY_5 ,POLNEARY_6 ,POLNEARY_7 ,POLNEARY_8 ,POLNEARY_9 ,DECPLCUR ,DECPLQTY ,ITMTRKOP ,VCTNMTHD ,BRKFLD1 ,JOBNUMBR ,COSTCODE ,COSTTYPE ,CURRNIDX ,ORUNTCST ,OREXTCST ,LINEORIGIN ,FREEONBOARD ,ODECPLCU ,Product_Indicator ,Source_Document_Number ,Source_Document_Line_Num ,RELEASEBYDATE ,Released_Date ,Purchase_IV_Item_Taxable ,Purchase_Item_Tax_Schedu ,Purchase_Site_Tax_Schedu ,PURCHSITETXSCHSRC ,BSIVCTTL ,TAXAMNT ,ORTAXAMT ,BCKTXAMT ,OBTAXAMT ,Landed_Cost_Group_ID ,SHIPMTHD ,LineNumber ,ORIGPRMDATE ,FSTRCPTDT ,LSTRCPTDT ,RELEASE ,ADRSCODE ,CMPNYNAM ,CONTACT ,ADDRESS1 ,ADDRESS2 ,ADDRESS3 ,CITY ,STATE ,ZIPCODE ,CCode ,COUNTRY ,PHONE1 ,PHONE2 ,PHONE3 ,FAX ,ADDRSOURCE ,Flags ,ProjNum ,CostCatID FROM POP30110 where ponumber = 'P0xxxxxx' update pop10100 set POSTATUS = 2 where PONUMBER = 'P0xxxxxx' update POP10110 set POLNESTA = 2 where PONUMBER = ' P0xxxxxx ' delete from POP30100 where PONUMBER = 'P0xxxxxx' delete from POP30110 where PONUMBER = 'P0xxxxxx'