--执行以下语句，就能将出错的凭证的分录导入到核销余额表--导入借方数据insertintogl_verifydetail(ASSID,BUSINESSDATE,CREDITAMOUNT,CREDITQUANTITY,DEBITAMOUNT,DEBITQUANTITY,DETAILINDEX,DR,EXCRATE1,EXCRATE2,EXCRATE3,EXCRATE4,EXPLANATION,FRACCREDITAMOUNT,FRACDEBITAMOUNT,INITFLAG,LOCALCREDITAMOUNT,LOCALDEBITAMOUNT,PK_ACCASOA,PK_CURRTYPE,PK_DETAIL,PK_MANAGER,PK_PREPARED,PK_VERIFYDETAIL,PK_VOUCHER,PK_VOUCHERTYPE,PREPAREDDATE,PRICE,TS,VERIFYNO,VOUCHERNO,FREEVALUE20,ORIENTATION,BALANCECREDITAMOUNT,BALANCECREDITQUANTITY,BALANCEDEBITAMOUNT,BALANCEDEBITQUANTITY,BALANCEFRACCREDITAMOUNT,BALANCEFRACDEBITAMOUNT,BALANCELOCALCREDITAMOUNT,BALANCELOCALDEBITAMOUNT,BALANCEGLOBALCREDITAMOUNT,BALANCEGLOBALDEBITAMOUNT,BALANCEGROUPCREDITAMOUNT,BALANCEGROUPDEBITAMOUNT,PK_GROUP,PK_ORG,pk_accountingbook)selectASSID,CASEWHENGL_DETAIL.FREE2ISNOTNULLANDTRIM(GL_DETAIL.FREE2)ISNOTNULLTHENGL_DETAIL.FREE2ELSEGL_VOUCHER.PREPAREDDATEEND,CREDITAMOUNT,CREDITQUANTITY,DEBITAMOUNT,DEBITQUANTITY,DETAILINDEX,gl_detail.DR,EXCRATE1,EXCRATE2,EXCRATE3,EXCRATE4,gl_detail.EXPLANATION,FRACCREDITAMOUNT,FRACDEBITAMOUNT,'N',LOCALCREDITAMOUNT,LOCALDEBITAMOUNT,PK_ACCASOA,PK_CURRTYPE,PK_DETAIL,PK_MANAGER,PK_PREPARED,PK_DETAIL,gl_voucher.PK_VOUCHER,gl_voucher.PK_VOUCHERTYPE,PREPAREDDATE,PRICE,gl_detail.TS,gl_detail.free1,gl_voucher.num,'importmxdebit',1,CREDITAMOUNT,CREDITQUANTITY,DEBITAMOUNT,DEBITQUANTITY,FRACCREDITAMOUNT,FRACDEBITAMOUNT,LOCALCREDITAMOUNT,LOCALDEBITAMOUNT,GLOBALCREDITAMOUNT,GLOBALDEBITAMOUNT,GROUPCREDITAMOUNT,GROUPDEBITAMOUNT,gl_detail.PK_GROUP,gl_detail.PK_ORG,gl_voucher.pk_accountingbookfromgl_detail,gl_voucherwheregl_detail.pk_voucher=gl_voucher.pk_voucherandgl_detail.pk_accountingbook='1002P1100000000H8NS3'/*主体账簿pk*/--andgl_voucher.voucherkind<>2andgl_voucher.discardflag='N'andLOCALDEBITAMOUNT<>0andgl_voucher.prepareddate>='2011-09-01'/*核销对象启用时间*/andgl_detail.PK_ACCASOAin(selectPK_ACCASOAfrombd_accasoawherepk_account=(selectpk_accountfrombd_accountwherecode='220206'))/*科目编码*/andgl_voucher.dr=0andgl_detail.dr=0andnotexists(select1fromgl_verifydetailwherepk_detail=gl_detail.pk_detailanddr=0);--导入贷方数据insertintogl_verifydetail(ASSID,BUSINESSDATE,CREDITAMOUNT,CREDITQUANTITY,DEBITAMOUNT,DEBITQUANTITY,DETAILINDEX,DR,EXCRATE1,EXCRATE2,EXCRATE3,EXCRATE4,EXPLANATION,FRACCREDITAMOUNT,FRACDEBITAMOUNT,INITFLAG,LOCALCREDITAMOUNT,LOCALDEBITAMOUNT,PK_ACCASOA,PK_CURRTYPE,PK_DETAIL,PK_MANAGER,PK_PREPARED,PK_VERIFYDETAIL,PK_VOUCHER,PK_VOUCHERTYPE,PREPAREDDATE,PRICE,TS,VERIFYNO,VOUCHERNO,FREEVALUE20,ORIENTATION,BALANCECREDITAMOUNT,BALANCECREDITQUANTITY,BALANCEDEBITAMOUNT,BALANCEDEBITQUANTITY,BALANCEFRACCREDITAMOUNT,BALANCEFRACDEBITAMOUNT,BALANCELOCALCREDITAMOUNT,BALANCELOCALDEBITAMOUNT,BALANCEGLOBALCREDITAMOUNT,BALANCEGLOBALDEBITAMOUNT,BALANCEGROUPCREDITAMOUNT,BALANCEGROUPDEBITAMOUNT,PK_GROUP,PK_ORG,pk_accountingbook)selectASSID,CASEWHENGL_DETAIL.FREE2ISNOTNULLANDTRIM(GL_DETAIL.FREE2)ISNOTNULLTHENGL_DETAIL.FREE2ELSEGL_VOUCHER.PREPAREDDATEEND,CREDITAMOUNT,CREDITQUANTITY,DEBITAMOUNT,DEBITQUANTITY,DETAILINDEX,gl_detail.DR,EXCRATE1,EXCRATE2,EXCRATE3,EXCRATE4,gl_detail.EXPLANATION,FRACCREDITAMOUNT,FRACDEBITAMOUNT,'N',LOCALCREDITAMOUNT,LOCALDEBITAMOUNT,PK_ACCASOA,PK_CURRTYPE,PK_DETAIL,PK_MANAGER,PK_PREPARED,PK_DETAIL,gl_voucher.PK_VOUCHER,gl_voucher.PK_VOUCHERTYPE,PREPAREDDATE,PRICE,gl_detail.TS,gl_detail.free1,gl_voucher.num,'importmxcredit',-1,CREDITAMOUNT,CREDITQUANTITY,DEBITAMOUNT,DEBITQUANTITY,FRACCREDITAMOUNT,FRACDEBITAMOUNT,LOCALCREDITAMOUNT,LOCALDEBITAMOUNT,GLOBALCREDITAMOUNT,GLOBALDEBITAMOUNT,GROUPCREDITAMOUNT,GROUPDEBITAMOUNT,gl_detail.PK_GROUP,gl_detail.PK_ORG,gl_voucher.pk_accountingbookfromgl_detail,gl_voucherwheregl_detail.pk_voucher=gl_voucher.pk_voucherandgl_detail.pk_accountingbook='1002P1100000000H8NS3'/*主体账簿pk*/--andgl_voucher.voucherkind<>2andgl_voucher.discardflag='N'andLOCALCREDITAMOUNT<>0andgl_voucher.prepareddate>='2011-09-01'/*核销对象启用时间*/andgl_detail.PK_ACCASOAin(selectPK_ACCASOAfrombd_accasoawherepk_account=(selectpk_accountfrombd_accountwherecode='220206'))/*科目编码*/andgl_voucher.dr=0andgl_detail.dr=0andnotexists(select1fromgl_verifydetailwherepk_detail=gl_detail.pk_detailanddr=0);commit;
