📄 ttt.txt
字号:
CREATE PROCEDURE [dbo].[_PM_P_Product_Insert]
(@cInvCode [nvarchar](20),
@cInvName [nvarchar](60),
@cInvStd [nvarchar](60),
@cInvCCode [nvarchar](12),
@cVenCode [nvarchar](20),
@cLabel [nvarchar](20),
@cUnitCode [nvarchar](35),
@bControl [nvarchar](20),
@bMyLabel [nvarchar](20),
@Person [nvarchar](20),
@DefWH [nvarchar](20),
@cSouName [nvarchar](20),
@cSize [nvarchar](500),
@cColor [nvarchar](500),
@iPlanCust [Integer],
@iInvSPrice [float],
@iInvSCost [float],
@iInvLSCost [float],
@fRetailPrice [float],
@dSDate [datetime],
@cInvType1 [nvarchar](20),
@cInvType2 [nvarchar](20),
@cInvType3 [nvarchar](20),
@cInvType4 [nvarchar](60),
@cInvType5 [nvarchar](60),
@cInvType6 [nvarchar](60))
AS
INSERT INTO [UFDATA_168_2008].[dbo].[Inventory]
( [cInvCode],
[cInvAddCode],
[cInvName],
[cInvStd],
[cInvCCode],
[cVenCode],
[cReplaceItem],
[cPosition],
[bSale],
[bPurchase],
[bSelf],
[bComsume],
[bProducing],
[bService],
[bAccessary],
[iTaxRate],
[iInvWeight],
[iVolume],
[iInvRCost],
[iInvSPrice],
[iInvSCost],
[iInvLSCost],
[iInvNCost],
[iInvAdvance],
[iInvBatch],
[iSafeNum],
[iTopSum],
[iLowSum],
[iOverStock],
[cInvABC],
[bInvQuality],
[bInvBatch],
[bInvEntrust],
[bInvOverStock],
[dSDate],
[dEDate],
[bFree1],
[bFree2],
[cInvDefine1],
[cInvDefine2],
[cInvDefine3],
-- [I_id],
[bInvType],
[iInvMPCost],
[cQuality],
[iInvSaleCost],
[iInvSCost1],
[iInvSCost2],
[iInvSCost3],
[bFree3],
[bFree4],
[bFree5],
[bFree6],
[bFree7],
[bFree8],
[bFree9],
[bFree10],
[cCreatePerson],
[cModifyPerson],
[dModifyDate],
[fSubscribePoint],
[fVagQuantity],
[cValueType],
[bFixExch],
[fOutExcess],
[fInExcess],
[iMassDate],
[iWarnDays],
[fExpensesExch],
[bTrack],
[bSerial],
[bBarCode],
[iId],
[cBarCode],
[cInvDefine4],
[cInvDefine5],
[cInvDefine6],
[cInvDefine7],
[cInvDefine8],
[cInvDefine9],
[cInvDefine10],
[cInvDefine11],
[cInvDefine12],
[cInvDefine13],
[cInvDefine14],
[cInvDefine15],
[cInvDefine16],
[iGroupType],
[cGroupCode],
[cComUnitCode],
[cAssComUnitCode],
[cSAComUnitCode],
[cPUComUnitCode],
[cSTComUnitCode],
[cCAComUnitCode],
[cFrequency],
[iFrequency],
[iDays],
[dLastDate],
[iWastage],
[bSolitude],
[cEnterprise],
[cAddress],
[cFile],
[cLabel],
[cCheckOut],
[cLicence],
[bSpecialties],
[cDefWareHouse],
[iHighPrice],
[iExpSaleRate],
[cPriceGroup],
[cOfferGrade],
[iOfferRate],
[cMonth],
[iAdvanceDate],
[cCurrencyName],
[cProduceAddress],
[cProduceNation],
[cRegisterNo],
[cEnterNo],
[cPackingType],
[cEnglishName],
[bPropertyCheck],
[cPreparationType],
[cCommodity],
[iRecipeBatch],
[cNotPatentName],
[pubufts],
[bPromotSales],
[iPlanPolicy],
[iROPMethod],
[iBatchRule],
[fBatchIncrement],
[iAssureProvideDays],
[iTestStyle],
[iDTMethod],
[fDTRate],
[fDTNum],
[cDTUnit],
[iDTStyle],
[iQTMethod],
[PictureGUID],
[bPlanInv],
[bProxyForeign],
[bATOModel],
[bCheckItem],
[bPTOModel],
[bEquipment],
[cProductUnit],
[fOrderUpLimit],
[cMassUnit],
[fRetailPrice],
[cInvDepCode],
[iAlterAdvance],
[fAlterBaseNum],
[cPlanMethod],
[bMPS],
[bROP],
[bRePlan],
[cSRPolicy],
[bBillUnite],
[iSupplyDay],
[fSupplyMulti],
[fMinSupply],
[bCutMantissa],
[cInvPersonCode],
[iInvTfId],
[cEngineerFigNo],
[bInTotalCost],
[iSupplyType],
[bConfigFree1],
[bConfigFree2],
[bConfigFree3],
[bConfigFree4],
[bConfigFree5],
[bConfigFree6],
[bConfigFree7],
[bConfigFree8],
[bConfigFree9],
[bConfigFree10],
[iDTLevel],
[cDTAQL],
[bPeriodDT],
[cDTPeriod],
[iBigMonth],
[iBigDay],
[iSmallMonth],
[iSmallDay],
[bOutInvDT],
[bBackInvDT],
[iEndDTStyle],
[bDTWarnInv],
[fBackTaxRate],
[cCIQCode],
[cWGroupCode],
[cWUnit],
[fGrossW],
[cVGroupCode],
[cVUnit],
[fLength],
[fWidth],
[fHeight],
[iDTUCounter],
[iDTDCounter],
[iBatchCounter],
[cShopUnit],
[cPurPersonCode],
[bImportMedicine],
[bFirstBusiMedicine],
[bForeExpland],
[cInvPlanCode],
[fConvertRate],
[dReplaceDate],
[bInvModel],
[bKCCutMantissa],
[bReceiptByDT],
[iImpTaxRate],
[iExpTaxRate],
[bExpSale],
[iDrawBatch],
[bCheckBSATP],
[cInvProjectCode],
[iTestRule],
[cRuleCode],
[bCheckFree1],
[bCheckFree2],
[bCheckFree3],
[bCheckFree4],
[bCheckFree5],
[bCheckFree6],
[bCheckFree7],
[bCheckFree8],
[bCheckFree9],
[bCheckFree10],
[bBomMain],
[bBomSub],
[bProductBill],
[iCheckATP],
[iInvATPId],
[iPlanTfDay],
[iOverlapDay],
[bPiece],
[bSrvItem],
[bSrvFittings],
[fMaxSupply],
[fMinSplit],
[bSpecialOrder],
[bTrackSaleBill])
VALUES
( @cInvCode , --@cInvCode_1,
Null , --@cInvAddCode_2,
@cInvName, --@cInvName_3,
@cInvStd, --@cInvStd_4,
@cInvCCode , --@cInvCCode_5,
@cVenCode , --@cVenCode_6,
Null , --@cReplaceItem_7,
Null , --@cPosition_8,
-1 , --@bSale_9,
-1 , --@bPurchase_10,
0 , --@bSelf_11,
0 , --@bComsume_12,
0 , --@bProducing_13,
0 , --@bService_14,
0 , --@bAccessary_15,
0 , --@iTaxRate_16,
Null , --@iInvWeight_17,
0 , --@iVolume_18,
0 , --@iInvRCost_19,
@iInvSPrice, --@iInvSPrice_20,
@iInvSCost , --@iInvSCost_21,
@iInvLSCost , --@iInvLSCost_22,
@iInvSPrice , --@iInvNCost_23,
0 , --@iInvAdvance_24,
Null , --@iInvBatch_25,
Null , --@iSafeNum_26,
Null , --@iTopSum_27,
Null , --@iLowSum_28,
Null , --@iOverStock_29,
Null , --@cInvABC_30,
0 , --@bInvQuality_31,
0 , --@bInvBatch_32,
0 , --@bInvEntrust_33,
0 , --@bInvOverStock_34,
@dSDate, --@dSDate_35,
Null , --@dEDate_36,
-1 , --@bFree1_37,
-1, --@bFree2_38,
@bMyLabel , --@cInvDefine1_39,
Null , --@cInvDefine2_40,
Null , --@cInvDefine3_41,
-- Null , --@I_id_42,
0 , --@bInvType_43,
Null , --@iInvMPCost_44,
Null , --@cQuality_45,
Null , --@iInvSaleCost_46,
Null , --@iInvSCost1_47,
Null , --@iInvSCost2_48,
Null , --@iInvSCost3_49,
0, --@bFree3_50,
0 , --@bFree4_51,
0 , --@bFree5_52,
0 , --@bFree6_53,
0 , --@bFree7_54,
0, --@bFree8_55,
0, --@bFree9_56,
0 , --@bFree10_57,
@Person , --@cCreatePerson_58,
@Person, --@cModifyPerson_59,
@dSDate, --@dModifyDate_60,
Null , --@fSubscribePoint_61,
Null , --@fVagQuantity_62,
Null , --@cValueType_63,
0 , --@bFixExch_64,
Null , --@fOutExcess_65,
1000 , --@fInExcess_66,
Null , --@iMassDate_67,
Null , --@iWarnDays_68,
Null , --@fExpensesExch_69,
0 , --@bTrack_70,
0 , --@bSerial_71,
-1 , --@bBarCode_72,
Null , --@iId_73,
@cInvCode , --@cBarCode_74,
Null , --@cInvDefine4_75,
Null , --@cInvDefine5_76,
Null , --@cInvDefine6_77,
Null , --@cInvDefine7_78,
Null , --@cInvDefine8_79,
Null , --@cInvDefine9_80,
@bControl, --@cInvDefine10_81,
@iPlanCust, --@cInvDefine11_82,
Null , --@cInvDefine12_83,
@iInvSPrice, --@cInvDefine13_84,
@iInvSCost, --@cInvDefine14_85,
Null , --@cInvDefine15_86,
Null , --@cInvDefine16_87,
1 , --@iGroupType_88,
@cUnitCode , --@cGroupCode_89,
@cUnitCode+'01' , --@cComUnitCode_90,
Null , --@cAssComUnitCode_91,
@cUnitCode+'02', --@cSAComUnitCode_92,
@cUnitCode+'02', --@cPUComUnitCode_93,
@cUnitCode+'02', --@cSTComUnitCode_94,
@cUnitCode+'02', --@cCAComUnitCode_95,
Null , --@cFrequency_96,
Null , --@iFrequency_97,
Null , --@iDays_98,
Null , --@dLastDate_99,
Null , --@iWastage_100,
0, --@bSolitude_101,
Null , --@cEnterprise_102,
Null , --@cAddress_103,
Null , --@cFile_104,
@cLabel , --@cLabel_105,
Null , --@cCheckOut_106,
Null , --@cLicence_107,
0, --@bSpecialties_108,
@DefWH, --@cDefWareHouse_109,
Null , --@iHighPrice_110,
Null , --@iExpSaleRate_111,
Null , --@cPriceGroup_112,
Null , --@cOfferGrade_113,
Null , --@iOfferRate_114,
'200800', --@cMonth_115,
Null , --@iAdvanceDate_116,
@cSouName, --@cCurrencyName_117,
Null , --@cProduceAddress_118,
Null , --@cProduceNation_119,
Null , --@cRegisterNo_120,
Null , --@cEnterNo_121,
Null , --@cPackingType_122,
@cLabel, --@cEnglishName_123,
0 , --@bPropertyCheck_124,
Null , --@cPreparationType_125,
Null , --@cCommodity_126,
0, --@iRecipeBatch_127,
Null , --@cNotPatentName_128,
Null , --@pubufts_129,
0 , --@bPromotSales_130,
Null , --@iPlanPolicy_131,
Null , --@iROPMethod_132,
Null , --@iBatchRule_133,
Null , --@fBatchIncrement_134,
Null , --@iAssureProvideDays_135,
-1 , --@iTestStyle_136,
-1, --@iDTMethod_137,
Null , --@fDTRate_138,
Null , --@fDTNum_139,
Null , --@cDTUnit_140,
-1 , --@iDTStyle_141,
Null , --@iQTMethod_142,
Null , --@PictureGUID_143,
0 , --@bPlanInv_144,
0, --@bProxyForeign_145,
0 , --@bATOModel_146,
0, --@bCheckItem_147,
0 , --@bPTOModel_148,
0 , --@bEquipment_149,
@cUnitCode+'02' , --@cProductUnit_150,
1000, --@fOrderUpLimit_151,
Null , --@cMassUnit_152,
@fRetailPrice, --@fRetailPrice_153,
Null , --@cInvDepCode_154,
Null , --@iAlterAdvance_155,
Null , --@fAlterBaseNum_156,
'R', --@cPlanMethod_157,
0, --@bMPS_158,
0 , --@bROP_159,
0 , --@bRePlan_160,
'PE' , --@cSRPolicy_161,
0 , --@bBillUnite_162,
Null , --@iSupplyDay_163,
Null , --@fSupplyMulti_164,
Null , --@fMinSupply_165,
0, --@bCutMantissa_166,
Null , --@cInvPersonCode_167,
Null , --@iInvTfId_168,
Null , --@cEngineerFigNo_169,
-1, --@bInTotalCost_170,
0 , --@iSupplyType_171,
0 , --@bConfigFree1_172,
0 , --@bConfigFree2_173,
0 , --@bConfigFree3_174,
0, --@bConfigFree4_175,
0 , --@bConfigFree5_176,
0 , --@bConfigFree6_177,
0, --@bConfigFree7_178,
0 , --@bConfigFree8_179,
0, --@bConfigFree9_180,
0, --@bConfigFree10_181,
-1 , --@iDTLevel_182,
Null , --@cDTAQL_183,
0 , --@bPeriodDT_184,
Null , --@cDTPeriod_185,
Null , --@iBigMonth_186,
Null , --@iBigDay_187,
Null , --@iSmallMonth_188,
Null , --@iSmallDay_189,
0 , --@bOutInvDT_190,
0 , --@bBackInvDT_191,
-1, --@iEndDTStyle_192,
0 , --@bDTWarnInv_193,
0 , --@fBackTaxRate_194,
Null , --@cCIQCode_195,
Null , --@cWGroupCode_196,
Null , --@cWUnit_197,
Null , --@fGrossW_198,
Null , --@cVGroupCode_199,
Null , --@cVUnit_200,
Null , --@fLength_201,
Null , --@fWidth_202,
Null , --@fHeight_203,
Null , --@iDTUCounter_204,
Null , --@iDTDCounter_205,
Null , --@iBatchCounter_206,
@cUnitCode+'01' , --@cShopUnit_207,
Null , --@cPurPersonCode_208,
0 , --@bImportMedicine_209,
0, --@bFirstBusiMedicine_210,
0, --@bForeExpland_211,
Null , --@cInvPlanCode_212,
-1 , --@fConvertRate_213,
Null , --@dReplaceDate_214,
0 , --@bInvModel_215,
0, --@bKCCutMantissa_216,
0, --@bReceiptByDT_217,
0, --@iImpTaxRate_218,
Null , --@iExpTaxRate_219,
0 , --@bExpSale_220,
Null , --@iDrawBatch_221,
0, --@bCheckBSATP_222,
Null , --@cInvProjectCode_223,
-1 , --@iTestRule_224,
Null , --@cRuleCode_225,
0, --@bCheckFree1_226,
0 , --@bCheckFree2_227,
0, --@bCheckFree3_228,
0, --@bCheckFree4_229,
0, --@bCheckFree5_230,
0 , --@bCheckFree6_231,
0 , --@bCheckFree7_232,
0, --@bCheckFree8_233,
0 , --@bCheckFree9_234,
0 , --@bCheckFree10_235,
0, --@bBomMain_236,
0 , --@bBomSub_237,
0 , --@bProductBill_238,
0, --@iCheckATP_239,
Null , --@iInvATPId_240,
Null , --@iPlanTfDay_241,
Null , --@iOverlapDay_242,
0, --@bPiece_243,
0 , --@bSrvItem_244,
0, --@bSrvFittings_245,
Null , --@fMaxSupply_246,
Null , --@fMinSplit_247,
0 , --@bSpecialOrder_248,
0) --@bTrackSaleBill_249)
/*
INSERT INTO [UFDATA_168_2008].[dbo].[Inventory]
( [cInvCode],
[cInvAddCode],
[cInvName],
[cInvStd],
[cInvCCode],
[cVenCode],
[cReplaceItem],
[cPosition],
[bSale],
[bPurchase],
[bSelf],
[bComsume],
[bProducing],
[bService],
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -