金碟K3基礎資料單位組修改源碼
select * from
from t_ICItemBase v1
inner join t_item t1 on t1.fitemid=v1.fitemid
inner join t_UnitGroup u1
on ( u1.fname='单位组名称'
and t1.fnumber='物料完整编号')
update v1
set v1.funitgroupid=u1.funitgroupid,
v1.funitid=u1.fdefaultunitid,
t1.FOrderUnitID=u1.fdefaultunitid,
t1.FSaleUnitID=u1.fdefaultunitid,
t1.FStoreUnitID=u1.fdefaultunitid,
t1.FProductUnitID=u1.fdefaultunitid
from t_ICItemBase v1
inner join t_item t1 on t1.fitemid=v1.fitemid
inner join t_UnitGroup u1
on ( u1.fname='新单位组名称:如数量单位组'
and t1.fnumber='需要修改的记录代码:如01.01.000104101')
参考:t_icitem视图
Copy code SELECT
t0.FItemID,t0.FModel,t0.FName,t0.FHelpCode,t0.FDeleted,t0.FShortNumber,t0.FNumber,t0.FModifyTime,t0.FParentID,t0.FBrNo,t0.FTopID,t0.FRP,t0.FOmortize,t0.FOmortizeScale,t0.FForSale,t0.FStaCost,t0.FOrderPrice,t0.FOrderMethod,t0.FPriceFixingType,t0.FSalePriceFixingType,t0.FPerWastage,t0.FARAcctID,t0.FPlanPriceMethod,t0.FPlanClass,
t1.FErpClsID,t1.FUnitID,t1.FUnitGroupID,t1.FDefaultLoc,t1.FSPID,t1.FSource,t1.FQtyDecimal,t1.FLowLimit,t1.FHighLimit,t1.FSecInv,t1.FUseState,t1.FIsEquipment,t1.FEquipmentNum,t1.FIsSparePart,t1.FFullName,t1.FSecUnitID,t1.FSecCoefficient,t1.FSecUnitDecimal,t1.FAlias,
t1.FOrderUnitID,t1.FSaleUnitID,t1.FStoreUnitID,t1.FProductUnitID,t1.FApproveNo,t1.FAuxClassID,t1.FTypeID,t1.FPreDeadLine,t1.FSerialClassID,
t2.FOrderRector,t2.FPOHghPrcMnyType,t2.FPOHighPrice,t2.FWWHghPrc,t2.FWWHghPrcMnyType,t2.FSOLowPrc,t2.FSOLowPrcMnyType,t2.FIsSale,t2.FProfitRate,t2.FSalePrice,t2.FBatchManager,t2.FISKFPeriod,t2.FKFPeriod,t2.FTrack,t2.FPlanPrice,t2.FPriceDecimal,t2.FAcctID,t2.FSaleAcctID,t2.FCostAcctID,t2.FAPAcctID,t2.FGoodSpec,t2.FCostProject,t2.FIsSnManage,t2.FStockTime,t2.FBookPlan,t2.FBeforeExpire,t2.FTaxRate,t2.FAdminAcctID,t2.FNote,t2.FIsSpecialTax,t2.FSOHighLimit,t2.FSOLowLimit,t2.FOIHighLimit,t2.FOILowLimit,t2.FDaysPer,t2.FLastCheckDate,t2.FCheckCycle,t2.FCheckCycUnit,t2.FStockPrice,t2.FABCCls,t2.FBatchQty,t2.FClass,t2.FCostDiffRate,t2.FDepartment,t2.FSaleTaxAcctID,t2.FCBBmStandardID,
t3.FPlanTrategy,t3.FOrderTrategy,t3.FLeadTime,t3.FFixLeadTime,t3.FTotalTQQ,t3.FQtyMin,t3.FQtyMax,t3.FCUUnitID,t3.FOrderInterVal,t3.FBatchAppendQty,t3.FOrderPoint,t3.FBatFixEconomy,t3.FBatChangeEconomy,t3.FRequirePoint,t3.FPlanPoint,t3.FDefaultRoutingID,t3.FDefaultWorkTypeID,t3.FProductPrincipal,t3.FDailyConsume,t3.FMRPCon,t3.FPlanner,t3.FPutInteger,t3.FInHighLimit,t3.FInLowLimit,t3.FLowestBomCode,t3.FMRPOrder,t7.F_102,t7.F_664,t7.F_665,
t4.FChartNumber,t4.FIsKeyItem,t4.FMaund,t4.FGrossWeight,t4.FNetWeight,t4.FCubicMeasure,t4.FLength,t4.FWidth,t4.FHeight,t4.FSize,t4.FVersion,
t5.FStandardCost,t5.FStandardManHour,t5.FStdPayRate,t5.FChgFeeRate,t5.FStdFixFeeRate,t5.FOutMachFee,t5.FPieceRate,
t6.FInspectionLevel,t6.FInspectionProject,t6.FIsListControl,t6.FProChkMde,t6.FWWChkMde,t6.FSOChkMde,t6.FWthDrwChkMde,t6.FStkChkMde,t6.FOtherChkMde,t6.FStkChkPrd,t6.FStkChkAlrm,t6.FIdentifier,
t8.FNameEn,t8.FModelEn,t8.FHSNumber,t8.FFirstUnit,t8.FSecondUnit,t8.FFirstUnitRate,t8.FSecondUnitRate,t8.FIsManage,t8.FPackType,t8.FLenDecimal,t8.FCubageDecimal,t8.FWeightDecimal,t8.FImpostTaxRate,t8.FConsumeTaxRateFROM t_ICItemCore t0
LEFT JOIN t_ICItemBase t1 ON t0.FItemID=t1.FItemID
LEFT JOIN t_ICItemMaterial t2 ON t0.FItemID=t2.FItemID
LEFT JOIN t_ICItemPlan t3 ON t0.FItemID=t3.FItemID
LEFT JOIN t_ICItemDesign t4 ON t0.FItemID=t4.FItemID
LEFT JOIN t_ICItemStandard t5 ON t0.FItemID=t5.FItemID
LEFT JOIN t_ICItemQuality t6 ON t0.FItemID=t6.FItemID
LEFT JOIN t_ICItemCustom t7 ON t0.FItemID=t7.FItemID
LEFT JOIN T_BASE_ICItemEntrance t8 ON t0.FItemID=t8.FItemID
復制過過，直接在sql中運行即可 |
发表于 2008-6-26 14:14:11
发表于 2008-6-26 15:20:43
