etl_all_Products Normal / ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID TRANSNAME Y TRANSNAME STATUS Y STATUS LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS STARTDATE Y STARTDATE ENDDATE Y ENDDATE LOGDATE Y LOGDATE DEPDATE Y DEPDATE REPLAYDATE Y REPLAYDATE LOG_FIELD Y LOG_FIELD EXECUTING_SERVER N EXECUTING_SERVER EXECUTING_USER N EXECUTING_USER CLIENT N CLIENT ID_BATCH Y ID_BATCH SEQ_NR Y SEQ_NR LOGDATE Y LOGDATE TRANSNAME Y TRANSNAME STEPNAME Y STEPNAME STEP_COPY Y STEP_COPY LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS INPUT_BUFFER_ROWS Y INPUT_BUFFER_ROWS OUTPUT_BUFFER_ROWS Y OUTPUT_BUFFER_ROWS ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE LOGGING_OBJECT_TYPE Y LOGGING_OBJECT_TYPE OBJECT_NAME Y OBJECT_NAME OBJECT_COPY Y OBJECT_COPY REPOSITORY_DIRECTORY Y REPOSITORY_DIRECTORY FILENAME Y FILENAME OBJECT_ID Y OBJECT_ID OBJECT_REVISION Y OBJECT_REVISION PARENT_CHANNEL_ID Y PARENT_CHANNEL_ID ROOT_CHANNEL_ID Y ROOT_CHANNEL_ID ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE TRANSNAME Y TRANSNAME STEPNAME Y STEPNAME STEP_COPY Y STEP_COPY LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS LOG_FIELD N LOG_FIELD ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE METRICS_DATE Y METRICS_DATE METRICS_CODE Y METRICS_CODE METRICS_DESCRIPTION Y METRICS_DESCRIPTION METRICS_SUBJECT Y METRICS_SUBJECT METRICS_TYPE Y METRICS_TYPE METRICS_VALUE Y METRICS_VALUE 0.0 0.0 10000 50 50 N Y 50000 Y N 1000 100 - 2019/08/28 16:23:04.650 - 2019/08/28 16:23:04.650 N 219.128.77.96Mall 219.128.77.96 MSSQLNATIVE Native Mall 1433 caixukun Encrypted 2be98afc86aa7f2e4a801a5508cc2fe83 FORCE_IDENTIFIERS_TO_LOWERCASE N FORCE_IDENTIFIERS_TO_UPPERCASE N IS_CLUSTERED N MSSQLUseIntegratedSecurity false MSSQL_DOUBLE_DECIMAL_SEPARATOR N PORT_NUMBER 1433 PRESERVE_RESERVED_WORD_CASE Y QUOTE_ALL_FIELDS N SUPPORTS_BOOLEAN_DATA_TYPE Y SUPPORTS_TIMESTAMP_DATA_TYPE Y USE_POOLING N 50.32 192.168.50.32 MSSQLNATIVE Native Mall 1433 sa Encrypted 2be98afc86aa7f297aa15a478c7d38f99 FORCE_IDENTIFIERS_TO_LOWERCASE N FORCE_IDENTIFIERS_TO_UPPERCASE N INITIAL_POOL_SIZE 30 IS_CLUSTERED N MAXIMUM_POOL_SIZE 1000 MSSQLUseIntegratedSecurity false MSSQL_DOUBLE_DECIMAL_SEPARATOR N PORT_NUMBER 1433 PRESERVE_RESERVED_WORD_CASE Y QUOTE_ALL_FIELDS N SUPPORTS_BOOLEAN_DATA_TYPE Y SUPPORTS_TIMESTAMP_DATA_TYPE Y USE_POOLING Y 表输入 插入 / 更新 Y 表输入 TableInput Y 1 none 219.128.77.96Mall select * from Product where ProductCode > 793897 0 N N N

160 80 Y 执行SQL脚本 ExecSQL Y 1 none 50.32 Y N N Y insert into Product (ProductCode,CreationDate,LastModified,ProductName,ClassCode,CommonTitle,Introduction,Unit,Manufacturer,Packing,ProductStatusType,IsVisible,PurchasePrice,MarketPrice,OurPrice,AppreciationPrice,ProfitLevel,Manual,WapManual,Views,PriceSectorPricing,BrandCode,ProductType,Inspection,Composition,Weight,GmpCode,GmpCertificateUrl,ProductImageUrl,ThumbnailUrl,Img100,Img180,Img320,StandardCode,BarCode,ApprovalNumber,ProductAttribute,Formulation,PrescriptionType,PurchaseWhile,HealthInsuranceType,ConsumeDays,ProductTag,IsGifts,Standards,Dosage,MassDate,Storage,IsControl,ControlNumber,PackingNumber,PinyinCode,PinyinFullCode,ProductLine,SubProductLine,IsRecommend,SFDACode,SFDAApprovalValidDate,SFDAGmpCertificateDate,SFDAStatus,QcClass,SyncStatus,recordState,IsSuit,SuitDescription,FinancialType,ProudctDescription,PlureProductStatusType, Productmainmaterial,Productusecrowd,Displaytab,EnglishName,ChemicalName,Structure,Formula,Molecular,Characters,Adverse,Taboo,Precautions,Child,OlderPatients,PregnantWoman,DrugInteractions,Overdose,Pharmaco,Pharmacokinetics,PackingProduct,ExternalID,Remark,ProductHotType,MobilephoneUrl,BtManual,ProductRecommend,ToErp,ProductusecrowdCode,PlaceCode,FormulationCode,UsageCode,ManufacturerCode,ShowMall,DivisionCode,BranchCode,MerchantManageCode,MinMarketPrice,CheckPendingPrice,ControlAreaRegion,ProductCodeForOutOfStock,IsLimitPrice,CommonTitlePinyin,ProductInventory,PostageLogo,Quantity,IsDrugRecord,OutOfStockRecommendCodes,GiftCategory,BusinessIds,CategoryType,XQuantity,UserName,Comment,CQuantity) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) N ProductCode CreationDate LastModified ProductName ClassCode CommonTitle Introduction Unit Manufacturer Packing ProductStatusType IsVisible PurchasePrice MarketPrice OurPrice AppreciationPrice ProfitLevel Manual WapManual Views PriceSectorPricing BrandCode ProductType Inspection Composition Weight GmpCode GmpCertificateUrl ProductImageUrl ThumbnailUrl Img100 Img180 Img320 StandardCode BarCode ApprovalNumber ProductAttribute Formulation PrescriptionType PurchaseWhile HealthInsuranceType ConsumeDays ProductTag IsGifts Standards Dosage MassDate Storage IsControl ControlNumber PackingNumber PinyinCode PinyinFullCode ProductLine SubProductLine IsRecommend SFDACode SFDAApprovalValidDate SFDAGmpCertificateDate SFDAStatus QcClass SyncStatus recordState IsSuit SuitDescription FinancialType ProudctDescription PlureProductStatusType Productmainmaterial Productusecrowd Displaytab EnglishName ChemicalName Structure Formula Molecular Characters Adverse Taboo Precautions Child OlderPatients PregnantWoman DrugInteractions Overdose Pharmaco Pharmacokinetics PackingProduct ExternalID Remark ProductHotType MobilephoneUrl BtManual ProductRecommend ToErp ProductusecrowdCode PlaceCode FormulationCode UsageCode ManufacturerCode ShowMall DivisionCode BranchCode MerchantManageCode MinMarketPrice CheckPendingPrice ControlAreaRegion ProductCodeForOutOfStock IsLimitPrice CommonTitlePinyin ProductInventory PostageLogo Quantity IsDrugRecord OutOfStockRecommendCodes GiftCategory BusinessIds CategoryType XQuantity UserName Comment CQuantity

416 80 Y 插入 / 更新 InsertUpdate Y 1 none 50.32 100 N Product ProductCode ProductCode = ProductCode ProductCode Y CreationDate CreationDate Y LastModified LastModified Y ProductName ProductName Y ClassCode ClassCode Y CommonTitle CommonTitle Y Introduction Introduction Y Unit Unit Y Manufacturer Manufacturer Y Packing Packing Y ProductStatusType ProductStatusType Y IsVisible IsVisible Y PurchasePrice PurchasePrice Y MarketPrice MarketPrice Y OurPrice OurPrice Y AppreciationPrice AppreciationPrice Y ProfitLevel ProfitLevel Y Manual Manual Y WapManual WapManual Y Views Views Y PriceSectorPricing PriceSectorPricing Y BrandCode BrandCode Y ProductType ProductType Y Inspection Inspection Y Composition Composition Y Weight Weight Y GmpCode GmpCode Y GmpCertificateUrl GmpCertificateUrl Y ProductImageUrl ProductImageUrl Y ThumbnailUrl ThumbnailUrl Y Img100 Img100 Y Img180 Img180 Y Img320 Img320 Y StandardCode StandardCode Y BarCode BarCode Y ApprovalNumber ApprovalNumber Y ProductAttribute ProductAttribute Y Formulation Formulation Y PrescriptionType PrescriptionType Y PurchaseWhile PurchaseWhile Y HealthInsuranceType HealthInsuranceType Y ConsumeDays ConsumeDays Y ProductTag ProductTag Y IsGifts IsGifts Y Standards Standards Y Dosage Dosage Y MassDate MassDate Y Storage Storage Y IsControl IsControl Y ControlNumber ControlNumber Y PackingNumber PackingNumber Y PinyinCode PinyinCode Y PinyinFullCode PinyinFullCode Y ProductLine ProductLine Y SubProductLine SubProductLine Y IsRecommend IsRecommend Y SFDACode SFDACode Y SFDAApprovalValidDate SFDAApprovalValidDate Y SFDAGmpCertificateDate SFDAGmpCertificateDate Y SFDAStatus SFDAStatus Y QcClass QcClass Y SyncStatus SyncStatus Y recordState recordState Y IsSuit IsSuit Y SuitDescription SuitDescription Y FinancialType FinancialType Y ProudctDescription ProudctDescription Y PlureProductStatusType PlureProductStatusType Y Productmainmaterial Productmainmaterial Y Productusecrowd Productusecrowd Y Displaytab Displaytab Y EnglishName EnglishName Y ChemicalName ChemicalName Y Structure Structure Y Formula Formula Y Molecular Molecular Y Characters Characters Y Adverse Adverse Y Taboo Taboo Y Precautions Precautions Y Child Child Y OlderPatients OlderPatients Y PregnantWoman PregnantWoman Y DrugInteractions DrugInteractions Y Overdose Overdose Y Pharmaco Pharmaco Y Pharmacokinetics Pharmacokinetics Y PackingProduct PackingProduct Y ExternalID ExternalID Y Remark Remark Y ProductHotType ProductHotType Y MobilephoneUrl MobilephoneUrl Y BtManual BtManual Y ProductRecommend ProductRecommend Y ToErp ToErp Y ProductusecrowdCode ProductusecrowdCode Y PlaceCode PlaceCode Y FormulationCode FormulationCode Y UsageCode UsageCode Y ManufacturerCode ManufacturerCode Y ShowMall ShowMall Y DivisionCode DivisionCode Y BranchCode BranchCode Y MerchantManageCode MerchantManageCode Y MinMarketPrice MinMarketPrice Y CheckPendingPrice CheckPendingPrice Y ControlAreaRegion ControlAreaRegion Y ProductCodeForOutOfStock ProductCodeForOutOfStock Y IsLimitPrice IsLimitPrice Y CommonTitlePinyin CommonTitlePinyin Y ProductInventory ProductInventory Y PostageLogo PostageLogo Y Quantity Quantity Y IsDrugRecord IsDrugRecord Y OutOfStockRecommendCodes OutOfStockRecommendCodes Y GiftCategory GiftCategory Y BusinessIds BusinessIds Y CategoryType CategoryType Y XQuantity XQuantity Y UserName UserName Y Comment Comment Y CQuantity CQuantity Y

384 160 Y N