因为客户习惯,不愿放弃K3,从定制的MES中把生产领料写回K3,因为生产模块完全不用K3了!
其后台自定义表如下:
其sql语句如下:
INSERT into ICStockBillEntry(FBrNo,FInterID,FItemID,FEntryID,FQtyMust,FQty,FPrice,FBatchNo,FAmount,FUnitID,
FAuxPrice,FAuxQty,FAuxQtyMust,FQtyActual,FAuxQtyActual,FPlanPrice,FAuxPlanPrice,FSourceEntryID,FCommitQty,FAuxCommitQty,
FKFPeriod,FConsignPrice,FConsignAmount,FProcessCost,FMaterialCost,FTaxAmount,FMapNumber,FOrgBillEntryID,FPlanAmount,
FProcessPrice,FTaxRate,FAmtRef,FAuxPropID,FCost,FPriceRef,FAuxPriceRef,FQtyInvoice,FQtyInvoiceBase,FUnitCost,FSecCoefficient,
FSecQty,FSecCommitQty,FSourceTranType,FSourceInterId,FSourceBillNo,FContractInterID,FContractEntryID,FContractBillNo,
FICMOBillNo,FICMOInterID,FPPBomEntryID,FOrderInterID,FOrderEntryID,FOrderBillNo,FAllHookQTY,FAllHookAmount,FCurrentHookQTY,
FCurrentHookAmount,FStdAllHookAmount,FStdCurrentHookAmount,FSCStockID,FDCStockID,FCostObjGroupID,FCostOBJID,FMaterialCostPrice,
FReProduceType,FBomInterID,FDiscountRate,FDiscountAmount,FSepcialSaleId,FOutCommitQty,FOutSecCommitQty,FDBCommitQty,
FDBSecCommitQty,FAuxQtyInvoice,FOperSN,FCheckStatus,FInStockID,FSaleCommitQty,FSaleSecCommitQty,FSaleAuxCommitQty,
FSelectedProcID,FVWInStockQty,FAuxVWInStockQty,FSecVWInStockQty,FSecInvoiceQty,FCostCenterID,FPlanMode,FMTONo,FSecQtyActual,
FSecQtyMust,FRowClosed,FItemSize,FItemSuite,FPositionNo,FIsVMI,FEntrySupply,FChkPassItem,FSEOutInterID,FSEOutEntryID,
FSEOutBillNo,FConfirmMemEntry,FWebReturnQty,FWebReturnAuxQty,FItemStatementBillNO,FItemStatementEntryID,FItemStatementInterID,
FRealAmount,FRealPrice,FDefaultBaseQty,FDefaultQty,FRealStockBaseQty,FRealStockQty,FDiscardID,FLockFlag,FReturnNoticeBillNO,
FReturnNoticeEntryID,FReturnNoticeInterID,FProductFileQty,FSplitState,FQtySplit,FAuxQtySplit,FAddQty,FAuxAddQty)
VALUES
( 0,@FInterID,@FItemID,@Row,ISNULL(@FQty,0),ISNULL(@FQty,0),0,@FBatchNo,0,@FUnitID,
0,ISNULL(@FQty,0),0,0,0,0,0,1,0,0,
0,0,0,0,0,0,'',0,0,
0,0,0,0,0,0,0,0,0,0,0,
0,0,85,89206,@mNo,0,0,'',
@pudNo,26262,0,0,0,0,0,0,0,
0,0,0,@FStockID,0,0,@FCostObjID,0,
0,0,0,0,0,0,0,0,
0,0,0,0,0,0,0,0,
0,0,0,0,0,0,14036,'',0,
0,0,'','','',0,0,0,0,0,
'','',0,0,'',0,0,
0,0,0,0,0,0,0,0,'',
0,0,0,'',0,0,0,0 )
本人专业从事管理软件升级与深度改造,范围包括SAP 、INFO、用友及金碟等,欢迎共同讨论,共同进步!