SELECT "t41"."__fcol_677" "__fcol_760" ,"t41"."__fcol_678" "__fcol_761" ,"t41"."__fcol_679" "__fcol_762" ,"t41"."__fcol_680" "__fcol_763" ,"t41"."__fcol_681" "__fcol_764" ,"t41"."__fcol_682" "__fcol_765" ,"t41"."__fcol_683" "__fcol_766" ,"t41"."__fcol_684" "__fcol_767" ,"t41"."__fcol_685" "__fcol_768" ,"t41"."__fcol_686" "__fcol_769" ,"t41"."__fcol_687" "__fcol_770" ,"t41"."__fcol_688" "__fcol_771" ,"t41"."__fcol_689" "__fcol_772" ,"t41"."__fcol_690" "__fcol_773" ,"t41"."__fcol_691" "__fcol_774" ,"t41"."__fcol_692" "__fcol_775" ,"t41"."__fcol_693" "__fcol_776" ,"t41"."__fcol_694" "__fcol_777" ,"t41"."__fcol_695" "__fcol_778" ,"t41"."__fcol_696" "__fcol_779" ,"t41"."__fcol_697" "__fcol_780" ,"t41"."__fcol_698" "__fcol_781" ,"t41"."__fcol_699" "__fcol_782" ,"t41"."__fcol_700" "__fcol_783" ,"t41"."__fcol_701" "__fcol_784" ,"t41"."__fcol_702" "__fcol_785" ,"t41"."__fcol_703" "__fcol_786" ,"t41"."__fcol_704" "__fcol_787" ,"t41"."__fcol_705" "__fcol_788" ,"t41"."__fcol_706" "__fcol_789" ,"t41"."__fcol_707" "__fcol_790" ,"t41"."__fcol_708" "__fcol_791" ,"t41"."__fcol_709" "__fcol_792" ,"t41"."__fcol_710" "__fcol_793" ,"t41"."__fcol_711" "__fcol_794" ,"t43"."__fcol_719" "__fcol_795" ,"t43"."__fcol_720" "__fcol_796" ,"t43"."__fcol_721" "__fcol_797" FROM ( SELECT "t40"."__fcol_639" "__fcol_677" ,"t40"."__fcol_640" "__fcol_678" ,CASE WHEN CASE WHEN "t40"."__fcol_676" IS NULL THEN 1 ELSE 0 END = 0 THEN "t40"."__fcol_676" ELSE 0 END "__fcol_679" ,"t40"."__fcol_641" "__fcol_680" ,"t40"."__fcol_642" "__fcol_681" ,"t40"."__fcol_643" "__fcol_682" ,"t40"."__fcol_644" "__fcol_683" ,"t40"."__fcol_645" "__fcol_684" ,"t40"."__fcol_646" "__fcol_685" ,"t40"."__fcol_647" "__fcol_686" ,"t40"."__fcol_648" "__fcol_687" ,"t40"."__fcol_649" "__fcol_688" ,"t40"."__fcol_650" "__fcol_689" ,"t40"."__fcol_651" "__fcol_690" ,"t40"."__fcol_652" "__fcol_691" ,"t40"."__fcol_653" "__fcol_692" ,"t40"."__fcol_654" "__fcol_693" ,"t40"."__fcol_655" "__fcol_694" ,"t40"."__fcol_656" "__fcol_695" ,"t40"."__fcol_657" "__fcol_696" ,"t40"."__fcol_658" "__fcol_697" ,"t40"."__fcol_659" "__fcol_698" ,"t40"."__fcol_660" "__fcol_699" ,"t40"."__fcol_661" "__fcol_700" ,"t40"."__fcol_662" "__fcol_701" ,"t40"."__fcol_663" "__fcol_702" ,"t40"."__fcol_664" "__fcol_703" ,"t40"."__fcol_665" "__fcol_704" ,"t40"."__fcol_666" "__fcol_705" ,"t40"."__fcol_667" "__fcol_706" ,"t40"."__fcol_668" "__fcol_707" ,"t40"."__fcol_669" "__fcol_708" ,"t40"."__fcol_670" "__fcol_709" ,"t40"."__fcol_671" "__fcol_710" ,( cast(YEAR(TIMESTAMPADD(MONTH, cast((0 - 1) AS INTEGER), "t40"."__fcol_651")) AS VARCHAR) || '-' || SUBSTRING(('0' || cast(MONTH(TIMESTAMPADD(MONTH, cast((0 - 1) AS INTEGER), "t40"."__fcol_651")) AS VARCHAR)), CASE WHEN 1 > ((char_length(('0' || cast(MONTH(TIMESTAMPADD(MONTH, cast((0 - 1) AS INTEGER), "t40"."__fcol_651")) AS VARCHAR))) + 1) - 2) THEN 1 ELSE ((char_length(('0' || cast(MONTH(TIMESTAMPADD(MONTH, cast((0 - 1) AS INTEGER), "t40"."__fcol_651")) AS VARCHAR))) + 1) - 2) END) ) "__fcol_711" FROM ( SELECT "t36"."__fcol_558" "__fcol_639" ,"t36"."__fcol_559" "__fcol_640" ,"t36"."__fcol_564" "__fcol_641" ,"t36"."__fcol_565" "__fcol_642" ,"t36"."__fcol_566" "__fcol_643" ,"t36"."__fcol_567" "__fcol_644" ,"t36"."__fcol_568" "__fcol_645" ,"t36"."__fcol_569" "__fcol_646" ,"t36"."__fcol_570" "__fcol_647" ,"t36"."__fcol_571" "__fcol_648" ,"t36"."__fcol_572" "__fcol_649" ,"t36"."__fcol_573" "__fcol_650" ,"t36"."__fcol_574" "__fcol_651" ,"t36"."__fcol_575" "__fcol_652" ,"t36"."__fcol_576" "__fcol_653" ,"t36"."__fcol_577" "__fcol_654" ,"t36"."__fcol_578" "__fcol_655" ,"t36"."__fcol_579" "__fcol_656" ,"t36"."__fcol_580" "__fcol_657" ,"t36"."__fcol_581" "__fcol_658" ,"t36"."__fcol_582" "__fcol_659" ,"t36"."__fcol_583" "__fcol_660" ,"t36"."__fcol_584" "__fcol_661" ,"t36"."__fcol_585" "__fcol_662" ,"t36"."__fcol_586" "__fcol_663" ,"t36"."__fcol_587" "__fcol_664" ,"t36"."__fcol_588" "__fcol_665" ,"t36"."__fcol_589" "__fcol_666" ,"t36"."__fcol_590" "__fcol_667" ,"t36"."__fcol_591" "__fcol_668" ,"t36"."__fcol_592" "__fcol_669" ,"t36"."__fcol_593" "__fcol_670" ,"t36"."__fcol_594" "__fcol_671" ,CASE WHEN ( CASE WHEN ( "t36"."__fcol_558" = 'BN4' OR "t36"."__fcol_558" = 'SPHC' OR "t36"."__fcol_558" = '304L' OR "t36"."__fcol_558" = 'DC51D+Z' OR "t36"."__fcol_558" = 'SECCN5' OR "t36"."__fcol_558" = '50WW1300' OR "t36"."__fcol_558" = '410L' ) THEN 1 WHEN NOT ( ( "t36"."__fcol_558" = 'BN4' OR "t36"."__fcol_558" = 'SPHC' OR "t36"."__fcol_558" = '304L' OR "t36"."__fcol_558" = 'DC51D+Z' OR "t36"."__fcol_558" = 'SECCN5' OR "t36"."__fcol_558" = '50WW1300' OR "t36"."__fcol_558" = '410L' ) ) THEN 0 ELSE NULL END = 1 AND CASE WHEN ( "t36"."__fcol_560" IS NULL OR "t36"."__fcol_561" IS NULL ) THEN 1 WHEN NOT ( ( "t36"."__fcol_560" IS NULL OR "t36"."__fcol_561" IS NULL ) ) THEN 0 ELSE NULL END = 1 ) THEN "t38"."__fcol_601" ELSE "t36"."__fcol_562" END "__fcol_676" FROM ( SELECT "t35"."__fcol_521" "__fcol_558" ,"t35"."__fcol_522" "__fcol_559" ,"t35"."__fcol_523" "__fcol_560" ,"t35"."__fcol_524" "__fcol_561" ,"t35"."__fcol_525" "__fcol_562" ,cast("t35"."__fcol_557" AS TIMESTAMP) "__fcol_563" ,"t35"."__fcol_526" "__fcol_564" ,"t35"."__fcol_527" "__fcol_565" ,"t35"."__fcol_528" "__fcol_566" ,"t35"."__fcol_529" "__fcol_567" ,"t35"."__fcol_530" "__fcol_568" ,"t35"."__fcol_531" "__fcol_569" ,"t35"."__fcol_532" "__fcol_570" ,"t35"."__fcol_533" "__fcol_571" ,"t35"."__fcol_534" "__fcol_572" ,"t35"."__fcol_535" "__fcol_573" ,"t35"."__fcol_536" "__fcol_574" ,"t35"."__fcol_537" "__fcol_575" ,"t35"."__fcol_538" "__fcol_576" ,"t35"."__fcol_539" "__fcol_577" ,"t35"."__fcol_540" "__fcol_578" ,"t35"."__fcol_541" "__fcol_579" ,"t35"."__fcol_542" "__fcol_580" ,"t35"."__fcol_543" "__fcol_581" ,"t35"."__fcol_544" "__fcol_582" ,"t35"."__fcol_545" "__fcol_583" ,"t35"."__fcol_546" "__fcol_584" ,"t35"."__fcol_547" "__fcol_585" ,"t35"."__fcol_548" "__fcol_586" ,"t35"."__fcol_549" "__fcol_587" ,"t35"."__fcol_550" "__fcol_588" ,"t35"."__fcol_551" "__fcol_589" ,"t35"."__fcol_552" "__fcol_590" ,"t35"."__fcol_553" "__fcol_591" ,"t35"."__fcol_554" "__fcol_592" ,"t35"."__fcol_555" "__fcol_593" ,"t35"."__fcol_556" "__fcol_594" FROM ( SELECT "t31"."__fcol_444" "__fcol_521" ,"t31"."__fcol_445" "__fcol_522" ,"t31"."__fcol_446" "__fcol_523" ,"t33"."__fcol_482" "__fcol_524" ,"t33"."__fcol_484" "__fcol_525" ,"t31"."__fcol_447" "__fcol_526" ,"t31"."__fcol_448" "__fcol_527" ,"t31"."__fcol_449" "__fcol_528" ,"t31"."__fcol_450" "__fcol_529" ,"t31"."__fcol_451" "__fcol_530" ,"t31"."__fcol_452" "__fcol_531" ,"t31"."__fcol_453" "__fcol_532" ,"t31"."__fcol_454" "__fcol_533" ,"t31"."__fcol_455" "__fcol_534" ,"t31"."__fcol_456" "__fcol_535" ,"t31"."__fcol_457" "__fcol_536" ,"t31"."__fcol_458" "__fcol_537" ,"t31"."__fcol_459" "__fcol_538" ,"t31"."__fcol_460" "__fcol_539" ,"t31"."__fcol_461" "__fcol_540" ,"t31"."__fcol_462" "__fcol_541" ,"t31"."__fcol_463" "__fcol_542" ,"t31"."__fcol_464" "__fcol_543" ,"t31"."__fcol_465" "__fcol_544" ,"t31"."__fcol_466" "__fcol_545" ,"t31"."__fcol_467" "__fcol_546" ,"t31"."__fcol_468" "__fcol_547" ,"t31"."__fcol_469" "__fcol_548" ,"t31"."__fcol_470" "__fcol_549" ,"t31"."__fcol_471" "__fcol_550" ,"t31"."__fcol_472" "__fcol_551" ,"t31"."__fcol_473" "__fcol_552" ,"t31"."__fcol_474" "__fcol_553" ,"t31"."__fcol_475" "__fcol_554" ,"t31"."__fcol_476" "__fcol_555" ,"t31"."__fcol_477" "__fcol_556" ,( cast(YEAR(TIMESTAMPADD(MONTH, cast((0 - 1) AS INTEGER), CURRENT_DATE)) AS VARCHAR) || '-' || SUBSTRING(('0' || cast(MONTH(TIMESTAMPADD(MONTH, cast((0 - 1) AS INTEGER), CURRENT_DATE)) AS VARCHAR)), CASE WHEN 1 > ((char_length(('0' || cast(MONTH(TIMESTAMPADD(MONTH, cast((0 - 1) AS INTEGER), CURRENT_DATE)) AS VARCHAR))) + 1) - 2) THEN 1 ELSE ((char_length(('0' || cast(MONTH(TIMESTAMPADD(MONTH, cast((0 - 1) AS INTEGER), CURRENT_DATE)) AS VARCHAR))) + 1) - 2) END) ) "__fcol_557" FROM ( SELECT "t27"."__fcol_368" "__fcol_444" ,"t29"."__fcol_409" "__fcol_445" ,"t27"."__fcol_371" "__fcol_446" ,"t27"."__fcol_372" "__fcol_447" ,"t27"."__fcol_373" "__fcol_448" ,"t27"."__fcol_374" "__fcol_449" ,"t27"."__fcol_375" "__fcol_450" ,"t27"."__fcol_376" "__fcol_451" ,"t27"."__fcol_377" "__fcol_452" ,"t27"."__fcol_378" "__fcol_453" ,"t27"."__fcol_379" "__fcol_454" ,"t27"."__fcol_380" "__fcol_455" ,"t27"."__fcol_381" "__fcol_456" ,"t27"."__fcol_382" "__fcol_457" ,"t27"."__fcol_383" "__fcol_458" ,"t27"."__fcol_384" "__fcol_459" ,"t27"."__fcol_385" "__fcol_460" ,"t27"."__fcol_386" "__fcol_461" ,"t27"."__fcol_387" "__fcol_462" ,"t27"."__fcol_388" "__fcol_463" ,"t27"."__fcol_389" "__fcol_464" ,"t27"."__fcol_390" "__fcol_465" ,"t27"."__fcol_391" "__fcol_466" ,"t27"."__fcol_392" "__fcol_467" ,"t27"."__fcol_393" "__fcol_468" ,"t27"."__fcol_394" "__fcol_469" ,"t27"."__fcol_395" "__fcol_470" ,"t27"."__fcol_396" "__fcol_471" ,"t27"."__fcol_397" "__fcol_472" ,"t27"."__fcol_398" "__fcol_473" ,"t27"."__fcol_399" "__fcol_474" ,"t27"."__fcol_400" "__fcol_475" ,"t27"."__fcol_401" "__fcol_476" ,"t27"."__fcol_402" "__fcol_477" FROM ( SELECT "t26"."__fcol_364" "__fcol_368" ,cast("t26"."__fcol_365" AS TIMESTAMP) "__fcol_369" ,cast("t26"."__fcol_367" AS TIMESTAMP) "__fcol_371" ,"t26"."__fcol_366" "__fcol_372" ,"t26"."__fcol_363" "__fcol_373" ,"t26"."__fcol_334" "__fcol_374" ,"t26"."__fcol_335" "__fcol_375" ,"t26"."__fcol_336" "__fcol_376" ,"t26"."__fcol_337" "__fcol_377" ,"t26"."__fcol_338" "__fcol_378" ,"t26"."__fcol_339" "__fcol_379" ,"t26"."__fcol_340" "__fcol_380" ,"t26"."__fcol_341" "__fcol_381" ,"t26"."__fcol_342" "__fcol_382" ,"t26"."__fcol_343" "__fcol_383" ,"t26"."__fcol_344" "__fcol_384" ,"t26"."__fcol_345" "__fcol_385" ,"t26"."__fcol_346" "__fcol_386" ,"t26"."__fcol_347" "__fcol_387" ,"t26"."__fcol_348" "__fcol_388" ,"t26"."__fcol_349" "__fcol_389" ,"t26"."__fcol_350" "__fcol_390" ,"t26"."__fcol_351" "__fcol_391" ,"t26"."__fcol_352" "__fcol_392" ,"t26"."__fcol_353" "__fcol_393" ,"t26"."__fcol_354" "__fcol_394" ,"t26"."__fcol_355" "__fcol_395" ,"t26"."__fcol_356" "__fcol_396" ,"t26"."__fcol_357" "__fcol_397" ,"t26"."__fcol_358" "__fcol_398" ,"t26"."__fcol_359" "__fcol_399" ,"t26"."__fcol_360" "__fcol_400" ,"t26"."__fcol_361" "__fcol_401" ,"t26"."__fcol_362" "__fcol_402" FROM ( SELECT "t25"."__fcol_304" "__fcol_334" ,"t25"."__fcol_305" "__fcol_335" ,"t25"."__fcol_306" "__fcol_336" ,"t25"."__fcol_307" "__fcol_337" ,"t25"."__fcol_308" "__fcol_338" ,"t25"."__fcol_309" "__fcol_339" ,"t25"."__fcol_310" "__fcol_340" ,"t25"."__fcol_311" "__fcol_341" ,"t25"."__fcol_312" "__fcol_342" ,"t25"."__fcol_313" "__fcol_343" ,"t25"."__fcol_314" "__fcol_344" ,"t25"."__fcol_315" "__fcol_345" ,"t25"."__fcol_316" "__fcol_346" ,"t25"."__fcol_317" "__fcol_347" ,"t25"."__fcol_318" "__fcol_348" ,"t25"."__fcol_319" "__fcol_349" ,"t25"."__fcol_320" "__fcol_350" ,"t25"."__fcol_321" "__fcol_351" ,"t25"."__fcol_322" "__fcol_352" ,"t25"."__fcol_323" "__fcol_353" ,"t25"."__fcol_324" "__fcol_354" ,"t25"."__fcol_325" "__fcol_355" ,"t25"."__fcol_326" "__fcol_356" ,"t25"."__fcol_327" "__fcol_357" ,"t25"."__fcol_328" "__fcol_358" ,"t25"."__fcol_329" "__fcol_359" ,"t25"."__fcol_330" "__fcol_360" ,"t25"."__fcol_331" "__fcol_361" ,"t25"."__fcol_332" "__fcol_362" ,"t25"."__fcol_333" "__fcol_363" ,CASE WHEN CASE WHEN ( "t25"."__fcol_308" = 'BN4' OR "t25"."__fcol_308" = '410L' ) THEN 1 WHEN NOT ( ( "t25"."__fcol_308" = 'BN4' OR "t25"."__fcol_308" = '410L' ) ) THEN 0 ELSE NULL END = 1 THEN "t25"."__fcol_308" ELSE CASE WHEN CASE WHEN ( (SUBSTRING("t25"."__fcol_333", 1, cast(2 AS INTEGER)) || "t25"."__fcol_332") = '冷轧300' OR (SUBSTRING("t25"."__fcol_333", 1, cast(2 AS INTEGER)) || "t25"."__fcol_332") = '热轧300' OR (SUBSTRING("t25"."__fcol_333", 1, cast(2 AS INTEGER)) || "t25"."__fcol_332") = '酸洗300' OR (SUBSTRING("t25"."__fcol_333", 1, cast(2 AS INTEGER)) || "t25"."__fcol_332") = '冷轧400' OR (SUBSTRING("t25"."__fcol_333", 1, cast(2 AS INTEGER)) || "t25"."__fcol_332") = '热轧400' OR (SUBSTRING("t25"."__fcol_333", 1, cast(2 AS INTEGER)) || "t25"."__fcol_332") = '酸洗400' OR (SUBSTRING("t25"."__fcol_333", 1, cast(2 AS INTEGER)) || "t25"."__fcol_332") = '冷轧BN' OR (SUBSTRING("t25"."__fcol_333", 1, cast(2 AS INTEGER)) || "t25"."__fcol_332") = '热轧BN' OR (SUBSTRING("t25"."__fcol_333", 1, cast(2 AS INTEGER)) || "t25"."__fcol_332") = '酸洗BN' OR (SUBSTRING("t25"."__fcol_333", 1, cast(2 AS INTEGER)) || "t25"."__fcol_332") = '冷轧SUH409L' OR (SUBSTRING("t25"."__fcol_333", 1, cast(2 AS INTEGER)) || "t25"."__fcol_332") = '热轧SUH409L' OR (SUBSTRING("t25"."__fcol_333", 1, cast(2 AS INTEGER)) || "t25"."__fcol_332") = '酸洗SUH409L' ) THEN 1 WHEN NOT ( ( (SUBSTRING("t25"."__fcol_333", 1, cast(2 AS INTEGER)) || "t25"."__fcol_332") = '冷轧300' OR (SUBSTRING("t25"."__fcol_333", 1, cast(2 AS INTEGER)) || "t25"."__fcol_332") = '热轧300' OR (SUBSTRING("t25"."__fcol_333", 1, cast(2 AS INTEGER)) || "t25"."__fcol_332") = '酸洗300' OR (SUBSTRING("t25"."__fcol_333", 1, cast(2 AS INTEGER)) || "t25"."__fcol_332") = '冷轧400' OR (SUBSTRING("t25"."__fcol_333", 1, cast(2 AS INTEGER)) || "t25"."__fcol_332") = '热轧400' OR (SUBSTRING("t25"."__fcol_333", 1, cast(2 AS INTEGER)) || "t25"."__fcol_332") = '酸洗400' OR (SUBSTRING("t25"."__fcol_333", 1, cast(2 AS INTEGER)) || "t25"."__fcol_332") = '冷轧BN' OR (SUBSTRING("t25"."__fcol_333", 1, cast(2 AS INTEGER)) || "t25"."__fcol_332") = '热轧BN' OR (SUBSTRING("t25"."__fcol_333", 1, cast(2 AS INTEGER)) || "t25"."__fcol_332") = '酸洗BN' OR (SUBSTRING("t25"."__fcol_333", 1, cast(2 AS INTEGER)) || "t25"."__fcol_332") = '冷轧SUH409L' OR (SUBSTRING("t25"."__fcol_333", 1, cast(2 AS INTEGER)) || "t25"."__fcol_332") = '热轧SUH409L' OR (SUBSTRING("t25"."__fcol_333", 1, cast(2 AS INTEGER)) || "t25"."__fcol_332") = '酸洗SUH409L' ) ) THEN 0 ELSE NULL END = 1 THEN CASE (SUBSTRING("t25"."__fcol_333", 1, cast(2 AS INTEGER)) || "t25"."__fcol_332") WHEN '冷轧300' THEN '304/2B' WHEN '热轧300' THEN '304/No.1' WHEN '酸洗300' THEN '304/No.1' WHEN '冷轧400' THEN '430/2B' WHEN '热轧400' THEN '430/No.1' WHEN '酸洗400' THEN '430/No.1' WHEN '冷轧BN' THEN '201J2/2B' WHEN '热轧BN' THEN '201J1/No.1' WHEN '酸洗BN' THEN '201J1/No.1' WHEN '冷轧SUH409L' THEN 'SUH409L/2B' WHEN '热轧SUH409L' THEN 'SUH409L/No.1' WHEN '酸洗SUH409L' THEN 'SUH409L/No.1' END ELSE CASE WHEN CASE WHEN ( "t25"."__fcol_305" = '股份' AND "t25"."__fcol_322" LIKE 'TI%' ) THEN 1 WHEN NOT ( ( "t25"."__fcol_305" = '股份' AND "t25"."__fcol_322" LIKE 'TI%' ) ) THEN 0 ELSE NULL END = 1 THEN 'SPHC' ELSE CASE WHEN CASE WHEN ( "t25"."__fcol_305" = '股份' AND "t25"."__fcol_322" = 'BI22' ) THEN 1 WHEN NOT ( ( "t25"."__fcol_305" = '股份' AND "t25"."__fcol_322" = 'BI22' ) ) THEN 0 ELSE NULL END = 1 THEN '304L' ELSE CASE WHEN CASE WHEN '热镀锌' = '' THEN 1 ELSE position('热镀锌' IN "t25"."__fcol_327") END <> 0 THEN 'DC51D+Z' ELSE CASE WHEN CASE WHEN '电镀锌' = '' THEN 1 ELSE position('电镀锌' IN "t25"."__fcol_327") END <> 0 THEN 'SECCN5' ELSE CASE WHEN CASE WHEN '无取向电工' = '' THEN 1 ELSE position('无取向电工' IN "t25"."__fcol_327") END <> 0 THEN '50WW1300' ELSE ("t25"."__fcol_327" || "t25"."__fcol_308") END END END END END END END "__fcol_364" ,( cast(YEAR("t25"."__fcol_312") AS VARCHAR) || '-' || SUBSTRING(('0' || cast(MONTH("t25"."__fcol_312") AS VARCHAR)), CASE WHEN 1 > ((char_length(('0' || cast(MONTH("t25"."__fcol_312") AS VARCHAR))) + 1) - 2) THEN 1 ELSE ((char_length(('0' || cast(MONTH("t25"."__fcol_312") AS VARCHAR))) + 1) - 2) END) ) "__fcol_365" ,CURRENT_DATE "__fcol_366" ,( cast(YEAR(CURRENT_DATE) AS VARCHAR) || '-' || SUBSTRING(('0' || cast(MONTH(CURRENT_DATE) AS VARCHAR)), CASE WHEN 1 > ((char_length(('0' || cast(MONTH(CURRENT_DATE) AS VARCHAR))) + 1) - 2) THEN 1 ELSE ((char_length(('0' || cast(MONTH(CURRENT_DATE) AS VARCHAR))) + 1) - 2) END) ) "__fcol_367" FROM ( SELECT "t24"."__fcol_276" "__fcol_304" ,"t24"."__fcol_277" "__fcol_305" ,"t24"."__fcol_278" "__fcol_306" ,"t24"."__fcol_279" "__fcol_307" ,"t24"."__fcol_280" "__fcol_308" ,"t24"."__fcol_281" "__fcol_309" ,"t24"."__fcol_282" "__fcol_310" ,"t24"."__fcol_283" "__fcol_311" ,"t24"."__fcol_284" "__fcol_312" ,"t24"."__fcol_285" "__fcol_313" ,"t24"."__fcol_286" "__fcol_314" ,"t24"."__fcol_287" "__fcol_315" ,"t24"."__fcol_288" "__fcol_316" ,"t24"."__fcol_289" "__fcol_317" ,"t24"."__fcol_290" "__fcol_318" ,"t24"."__fcol_291" "__fcol_319" ,"t24"."__fcol_292" "__fcol_320" ,"t24"."__fcol_303" "__fcol_321" ,"t24"."__fcol_293" "__fcol_322" ,"t24"."__fcol_294" "__fcol_323" ,"t24"."__fcol_295" "__fcol_324" ,"t24"."__fcol_296" "__fcol_325" ,"t24"."__fcol_297" "__fcol_326" ,"t24"."__fcol_298" "__fcol_327" ,"t24"."__fcol_299" "__fcol_328" ,"t24"."__fcol_300" "__fcol_329" ,"t24"."__fcol_301" "__fcol_330" ,("t24"."__fcol_291" + "t24"."__fcol_292" + "t24"."__fcol_303") "__fcol_331" ,CASE WHEN "t24"."__fcol_280" = '06Cr18Ni11Ti' THEN '300' ELSE CASE WHEN "t24"."__fcol_280" = '06Cr19Ni10' THEN '300' ELSE CASE WHEN "t24"."__fcol_280" = '1.4301' THEN '300' ELSE CASE WHEN "t24"."__fcol_280" = '1.4404/316L' THEN '300' ELSE CASE WHEN "t24"."__fcol_280" = '1.4509' THEN '300' ELSE CASE WHEN "t24"."__fcol_280" = '2205' THEN '300' ELSE CASE WHEN "t24"."__fcol_280" = '304' THEN '300' ELSE CASE WHEN "t24"."__fcol_280" = '304/304L' THEN '300' ELSE CASE WHEN "t24"."__fcol_280" = '304DQ' THEN '300' ELSE CASE WHEN "t24"."__fcol_280" = '304H' THEN '300' ELSE CASE WHEN CASE WHEN ( "t24"."__fcol_280" = '304L' AND ("t24"."__fcol_298" || "t24"."__fcol_280") <> '热轧不锈钢中厚板304L' ) THEN 1 WHEN NOT ( ( "t24"."__fcol_280" = '304L' AND ("t24"."__fcol_298" || "t24"."__fcol_280") <> '热轧不锈钢中厚板304L' ) ) THEN 0 ELSE NULL END = 1 THEN '300' ELSE CASE WHEN "t24"."__fcol_280" = '304L/022Cr19Ni10' THEN '300' ELSE CASE WHEN "t24"."__fcol_280" = '304L-1' THEN '300' ELSE CASE WHEN "t24"."__fcol_280" = '304MC' THEN '300' ELSE CASE WHEN "t24"."__fcol_280" = '310S' THEN '300' ELSE CASE WHEN "t24"."__fcol_280" = '316' THEN '300' ELSE CASE WHEN "t24"."__fcol_280" = '316/316L' THEN '300' ELSE CASE WHEN "t24"."__fcol_280" = '316L' THEN '300' ELSE CASE WHEN "t24"."__fcol_280" = '321' THEN '300' ELSE CASE WHEN "t24"."__fcol_280" = 'B304' THEN '300' ELSE CASE WHEN "t24"."__fcol_280" = 'B304CQ' THEN '300' ELSE CASE WHEN "t24"."__fcol_280" = 'B304SQ' THEN '300' ELSE CASE WHEN "t24"."__fcol_280" = 'P265GH' THEN '300' ELSE CASE WHEN "t24"."__fcol_280" = 'S30408' THEN '300' ELSE CASE WHEN "t24"."__fcol_280" = 'S31603' THEN '300' ELSE CASE WHEN "t24"."__fcol_280" = 'S31608' THEN '300' ELSE CASE WHEN "t24"."__fcol_280" = 'SPHC' THEN 'SPHC' ELSE CASE WHEN "t24"."__fcol_280" = 'SUS301' THEN '300' ELSE CASE WHEN "t24"."__fcol_280" = 'SUS301-CSP-S' THEN '300' ELSE CASE WHEN "t24"."__fcol_280" = 'SUS301L' THEN '300' ELSE CASE WHEN "t24"."__fcol_280" = 'SUS304' THEN '300' ELSE CASE WHEN "t24"."__fcol_280" = 'SUS304J1' THEN '300' ELSE CASE WHEN "t24"."__fcol_280" = 'SUS316L' THEN '300' ELSE CASE WHEN "t24"."__fcol_280" = '06Cr13' THEN '400' ELSE CASE WHEN "t24"."__fcol_280" = '20Cr13-H' THEN '400' ELSE CASE WHEN "t24"."__fcol_280" = '20Cr13-L' THEN '400' ELSE CASE WHEN "t24"."__fcol_280" = '30Cr13-H' THEN '400' ELSE CASE WHEN "t24"."__fcol_280" = '430' THEN '400' ELSE CASE WHEN "t24"."__fcol_280" = '439' THEN 'SUH409L' ELSE CASE WHEN "t24"."__fcol_280" = '443' THEN '400' ELSE CASE WHEN "t24"."__fcol_280" = '443NT' THEN '400' ELSE CASE WHEN "t24"."__fcol_280" = '50WW1300' THEN '50WW1300' ELSE CASE WHEN "t24"."__fcol_280" = 'B430J1L' THEN '400' ELSE CASE WHEN "t24"."__fcol_280" = 'B430LNT' THEN '400' ELSE CASE WHEN "t24"."__fcol_280" = 'B430LNT-H' THEN '400' ELSE CASE WHEN "t24"."__fcol_280" = 'B430MN' THEN '400' ELSE CASE WHEN "t24"."__fcol_280" = 'B436D' THEN '400' ELSE CASE WHEN "t24"."__fcol_280" = 'B436MN' THEN '400' ELSE CASE WHEN "t24"."__fcol_280" = 'B439M' THEN 'SUH409L' ELSE CASE WHEN "t24"."__fcol_280" = 'B441' THEN 'SUH409L' ELSE CASE WHEN "t24"."__fcol_280" = 'B442D' THEN 'SUH409L' ELSE CASE WHEN "t24"."__fcol_280" = 'B445J2' THEN '400' ELSE CASE WHEN "t24"."__fcol_280" = 'B50A600' THEN '400' ELSE CASE WHEN "t24"."__fcol_280" = 'B50AYMZ-1' THEN '400' ELSE CASE WHEN "t24"."__fcol_280" = 'DC01EK' THEN '400' ELSE CASE WHEN "t24"."__fcol_280" = 'DC04EK' THEN '400' ELSE CASE WHEN "t24"."__fcol_280" = 'HC550/980DPD+Z' THEN '400' ELSE CASE WHEN "t24"."__fcol_280" = 'PES439' THEN '400' ELSE CASE WHEN "t24"."__fcol_280" = 'S22053' THEN '400' ELSE CASE WHEN "t24"."__fcol_280" = 'S43932' THEN '400' ELSE CASE WHEN "t24"."__fcol_280" = 'SPHD' THEN '400' ELSE CASE WHEN "t24"."__fcol_280" = 'SUH409L' THEN 'SUH409L' ELSE CASE WHEN "t24"."__fcol_280" = '%410L%' THEN '410L' ELSE CASE WHEN "t24"."__fcol_280" = 'SUS410S' THEN '400' ELSE CASE WHEN "t24"."__fcol_280" = 'SUS420J2' THEN '400' ELSE CASE WHEN "t24"."__fcol_280" = 'SUS430' THEN '400' ELSE CASE WHEN "t24"."__fcol_280" = 'SUS430NO.4(320#)' THEN '400' ELSE CASE WHEN "t24"."__fcol_280" = 'SUS436L' THEN 'SUH409L' ELSE CASE WHEN "t24"."__fcol_280" = 'SUS442MN' THEN '400' ELSE CASE WHEN "t24"."__fcol_280" = '201' THEN 'BN' ELSE CASE WHEN "t24"."__fcol_280" = '201J4' THEN 'BN' ELSE CASE WHEN "t24"."__fcol_280" = 'BFS400' THEN 'BN' ELSE CASE WHEN "t24"."__fcol_280" = 'BFS500' THEN 'BN' ELSE CASE WHEN "t24"."__fcol_280" = 'BMJ01(304+Q235B)' THEN 'BN' ELSE CASE WHEN "t24"."__fcol_280" = 'BN1A2' THEN 'BN' ELSE CASE WHEN "t24"."__fcol_280" = 'BN1D1' THEN 'BN' ELSE CASE WHEN "t24"."__fcol_280" = 'BN1D4' THEN 'BN' ELSE CASE WHEN "t24"."__fcol_280" = 'BN1G' THEN 'BN' ELSE CASE WHEN "t24"."__fcol_280" = 'BN1P4' THEN 'BN' ELSE CASE WHEN "t24"."__fcol_280" = 'BNDDQ' THEN 'BN' ELSE CASE WHEN "t24"."__fcol_280" = 'CJ1L' THEN 'BN' ELSE CASE WHEN "t24"."__fcol_280" = 'CJ5L' THEN 'BN' ELSE CASE WHEN "t24"."__fcol_280" = 'J1' THEN 'BN' ELSE CASE WHEN "t24"."__fcol_280" = 'J2' THEN 'BN' ELSE CASE WHEN "t24"."__fcol_280" = 'L1' THEN 'BN' ELSE CASE WHEN "t24"."__fcol_280" = 'LH（201）' THEN 'BN' ELSE CASE WHEN CASE WHEN ( "t24"."__fcol_280" = '304L' AND ("t24"."__fcol_298" || "t24"."__fcol_280" ) = '热轧不锈钢中厚板304L' ) THEN 1 WHEN NOT ( ( "t24"."__fcol_280" = '304L' AND ("t24"."__fcol_298" || "t24"."__fcol_280" ) = '热轧不锈钢中厚板304L' ) ) THEN 0 ELSE NULL END = 1 THEN '304L' ELSE CASE WHEN "t24"."__fcol_280" = 'B409L' THEN 'SUH409L' ELSE CASE WHEN "t24"."__fcol_280" = 'B409M' THEN 'SUH409L' ELSE CASE WHEN "t24"."__fcol_280" = 'B436L' THEN 'SUH409L' ELSE CASE WHEN "t24"."__fcol_280" = '436L' THEN 'SUH409L' ELSE CASE WHEN "t24"."__fcol_280" = '439M' THEN 'SUH409L' ELSE CASE WHEN "t24"."__fcol_280" = 'B439' THEN 'SUH409L' ELSE CASE WHEN "t24"."__fcol_280" = 'B346D' THEN 'SUH409L' ELSE CASE WHEN "t24"."__fcol_280" = 'DC51D+Z' THEN 'DC51D+Z' ELSE CASE WHEN "t24"."__fcol_280" = 'SECCN5' THEN 'SECCN5' ELSE CASE WHEN CASE WHEN ( "t24"."__fcol_299" IS NULL AND CASE WHEN ( "t24"."__fcol_280" = 'DC51D+Z' OR "t24"."__fcol_280" = 'SECCN5' OR "t24"."__fcol_280" = '50WW1300' ) THEN 1 WHEN NOT ( ( "t24"."__fcol_280" = 'DC51D+Z' OR "t24"."__fcol_280" = 'SECCN5' OR "t24"."__fcol_280" = '50WW1300' ) ) THEN 0 ELSE NULL END = 1 ) THEN 1 WHEN NOT ( ( "t24"."__fcol_299" IS NULL AND CASE WHEN ( "t24"."__fcol_280" = 'DC51D+Z' OR "t24"."__fcol_280" = 'SECCN5' OR "t24"."__fcol_280" = '50WW1300' ) THEN 1 WHEN NOT ( ( "t24"."__fcol_280" = 'DC51D+Z' OR "t24"."__fcol_280" = 'SECCN5' OR "t24"."__fcol_280" = '50WW1300' ) ) THEN 0 ELSE NULL END = 1 ) ) THEN 0 ELSE NULL END = 1 THEN "t24"."__fcol_299" ELSE "t24"."__fcol_280" END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END "__fcol_332" ,CASE WHEN CASE WHEN '冷轧' = '' THEN 1 ELSE position('冷轧' IN "t24"."__fcol_298") END <> 0 THEN '冷轧' ELSE CASE WHEN CASE WHEN '热轧' = '' THEN 1 ELSE position('热轧' IN "t24"."__fcol_298") END <> 0 THEN '热轧' ELSE CASE WHEN CASE WHEN '酸洗' = '' THEN 1 ELSE position('酸洗' IN "t24"."__fcol_298") END <> 0 THEN '热轧' ELSE "t24"."__fcol_298" END END END "__fcol_333" FROM ( SELECT "t16"."__fcol_193" "__fcol_276" ,"t16"."__fcol_194" "__fcol_277" ,"t16"."__fcol_195" "__fcol_278" ,"t16"."__fcol_196" "__fcol_279" ,"t16"."__fcol_197" "__fcol_280" ,"t16"."__fcol_198" "__fcol_281" ,"t16"."__fcol_199" "__fcol_282" ,"t16"."__fcol_200" "__fcol_283" ,"t16"."__fcol_201" "__fcol_284" ,"t16"."__fcol_202" "__fcol_285" ,"t16"."__fcol_203" "__fcol_286" ,"t16"."__fcol_204" "__fcol_287" ,"t16"."__fcol_205" "__fcol_288" ,"t16"."__fcol_206" "__fcol_289" ,"t16"."__fcol_207" "__fcol_290" ,"t16"."__fcol_208" "__fcol_291" ,"t16"."__fcol_219" "__fcol_292" ,"t16"."__fcol_209" "__fcol_293" ,"t16"."__fcol_210" "__fcol_294" ,"t16"."__fcol_211" "__fcol_295" ,"t16"."__fcol_212" "__fcol_296" ,"t16"."__fcol_213" "__fcol_297" ,"t16"."__fcol_214" "__fcol_298" ,"t16"."__fcol_215" "__fcol_299" ,"t16"."__fcol_216" "__fcol_300" ,"t16"."__fcol_217" "__fcol_301" ,CASE WHEN CASE WHEN "t22"."__fcol_248" IS NULL THEN 1 ELSE 0 END = 1 THEN 0 ELSE "t22"."__fcol_248" END "__fcol_303" FROM ( SELECT "t8"."__fcol_112" "__fcol_193" ,"t8"."__fcol_113" "__fcol_194" ,"t8"."__fcol_114" "__fcol_195" ,"t8"."__fcol_115" "__fcol_196" ,"t8"."__fcol_116" "__fcol_197" ,"t8"."__fcol_117" "__fcol_198" ,"t8"."__fcol_118" "__fcol_199" ,"t8"."__fcol_119" "__fcol_200" ,"t8"."__fcol_120" "__fcol_201" ,"t8"."__fcol_121" "__fcol_202" ,"t8"."__fcol_122" "__fcol_203" ,"t8"."__fcol_123" "__fcol_204" ,"t8"."__fcol_124" "__fcol_205" ,"t8"."__fcol_125" "__fcol_206" ,"t8"."__fcol_126" "__fcol_207" ,"t8"."__fcol_137" "__fcol_208" ,"t8"."__fcol_127" "__fcol_209" ,"t8"."__fcol_128" "__fcol_210" ,"t8"."__fcol_129" "__fcol_211" ,"t8"."__fcol_130" "__fcol_212" ,"t8"."__fcol_131" "__fcol_213" ,"t8"."__fcol_132" "__fcol_214" ,"t8"."__fcol_133" "__fcol_215" ,"t8"."__fcol_134" "__fcol_216" ,"t8"."__fcol_135" "__fcol_217" ,CASE WHEN CASE WHEN "t14"."__fcol_166" IS NULL THEN 1 ELSE 0 END = 1 THEN 0 ELSE "t14"."__fcol_166" END "__fcol_219" FROM ( SELECT "t2"."__fcol_45" "__fcol_112" ,"t2"."__fcol_46" "__fcol_113" ,"t2"."__fcol_47" "__fcol_114" ,"t2"."__fcol_49" "__fcol_115" ,"t2"."__fcol_50" "__fcol_116" ,"t2"."__fcol_48" "__fcol_117" ,"t2"."__fcol_56" "__fcol_118" ,"t2"."__fcol_52" "__fcol_119" ,"t2"."__fcol_53" "__fcol_120" ,"t2"."__fcol_57" "__fcol_121" ,"t2"."__fcol_54" "__fcol_122" ,"t2"."__fcol_55" "__fcol_123" ,"t2"."__fcol_58" "__fcol_124" ,"t2"."__fcol_67" "__fcol_125" ,"t2"."__fcol_68" "__fcol_126" ,"t2"."__fcol_59" "__fcol_127" ,"t2"."__fcol_51" "__fcol_128" ,"t2"."__fcol_61" "__fcol_129" ,"t2"."__fcol_62" "__fcol_130" ,"t2"."__fcol_63" "__fcol_131" ,"t2"."__fcol_60" "__fcol_132" ,"t2"."__fcol_64" "__fcol_133" ,"t2"."__fcol_65" "__fcol_134" ,"t2"."__fcol_66" "__fcol_135" ,CASE WHEN CASE WHEN "t6"."__fcol_86" IS NULL THEN 1 ELSE 0 END = 1 THEN 0 ELSE "t6"."__fcol_86" END "__fcol_137" FROM ( SELECT "t1"."__fcol_22" "__fcol_45" ,"t1"."__fcol_23" "__fcol_46" ,"t1"."__fcol_24" "__fcol_47" ,"t1"."__fcol_25" "__fcol_48" ,"t1"."__fcol_26" "__fcol_49" ,"t1"."__fcol_27" "__fcol_50" ,"t1"."__fcol_28" "__fcol_51" ,"t1"."__fcol_29" "__fcol_52" ,"t1"."__fcol_30" "__fcol_53" ,"t1"."__fcol_31" "__fcol_54" ,"t1"."__fcol_32" "__fcol_55" ,"t1"."__fcol_33" "__fcol_56" ,"t1"."__fcol_34" "__fcol_57" ,"t1"."__fcol_35" "__fcol_58" ,"t1"."__fcol_36" "__fcol_59" ,"t1"."__fcol_37" "__fcol_60" ,"t1"."__fcol_38" "__fcol_61" ,"t1"."__fcol_39" "__fcol_62" ,"t1"."__fcol_40" "__fcol_63" ,"t1"."__fcol_41" "__fcol_64" ,"t1"."__fcol_42" "__fcol_65" ,"t1"."__fcol_43" "__fcol_66" ,"t1"."__fcol_44" "__fcol_67" ,("t1"."__fcol_44" - "t1"."__fcol_35") "__fcol_68" FROM ( SELECT "T_DE3FFE"."公司别名" "__fcol_22" ,"T_DE3FFE"."供应商分类" "__fcol_23" ,"T_DE3FFE"."供应商名称" "__fcol_24" ,"T_DE3FFE"."采购合同号" "__fcol_25" ,"T_DE3FFE"."规格" "__fcol_26" ,"T_DE3FFE"."牌号" "__fcol_27" ,"T_DE3FFE"."采购业务类型" "__fcol_28" ,"T_DE3FFE"."去向用户" "__fcol_29" ,"T_DE3FFE"."交货期" "__fcol_30" ,"T_DE3FFE"."采购合同量" "__fcol_31" ,"T_DE3FFE"."入库量" "__fcol_32" ,"T_DE3FFE"."采购合同子项号" "__fcol_33" ,"T_DE3FFE"."采购合同录入日期" "__fcol_34" ,"T_DE3FFE"."累计发货量" "__fcol_35" ,"T_DE3FFE"."品种代码" "__fcol_36" ,"T_DE3FFE"."品种名称" "__fcol_37" ,"T_35FECF"."采购合约号" "__fcol_38" ,"T_35FECF"."采购子项号" "__fcol_39" ,"T_35FECF"."质量等级" "__fcol_40" ,"T_DE3FFE"."不锈钢系列1" "__fcol_41" ,"T_DE3FFE"."不锈钢系列2" "__fcol_42" ,"T_DE3FFE"."不锈钢分类合同标记" "__fcol_43" ,CASE WHEN ( "T_DE3FFE"."采购合同量" IS NULL OR "T_DE3FFE"."入库量" IS NULL ) THEN NULL WHEN "T_DE3FFE"."采购合同量" > "T_DE3FFE"."入库量" THEN "T_DE3FFE"."采购合同量" ELSE "T_DE3FFE"."入库量" END "__fcol_44" FROM ( SELECT sourse "来源" ,seg_name "公司别名" ,provider_id "供应商代码" ,provider_type "供应商分类" ,provider_name "供应商名称" ,pur_contract_type "采购合同性质" ,contract_id "采购合同号" ,contract_subid "采购合同子项号" ,producing_area_code "产地代码" ,producing_area_name "产地" ,product_type_id "品种代码" ,prod_type_desc "品种名称" ,factory_product_id "钢厂资源号" ,product_id "资源号" ,spec "规格" ,shopsign "牌号" ,tech_standard "技术标准" ,cust_name "去向用户" ,direction_type "去向标记" ,business_type "采购业务类型" ,contract_status "采购合同状态" ,pur_agreement_d_status "采购子项状态" ,contract_type "不锈钢分类合同标记" ,cast(replace(delivery_date, '/', '-') AS TIMESTAMP) "交货期" ,pers_name "营销员" ,dept_name "营销员部门" ,bxg_station "站点" ,code_desc "特殊合同类型" ,cast(replace(contract_input_date, '/', '-') AS TIMESTAMP) "采购合同录入日期" ,cast(replace(contract_effect_date, '/', '-') AS TIMESTAMP) "采购合同生效日期" ,series "不锈钢系列1" ,fcc_series "不锈钢系列2" ,weight_qty "采购合同量" ,pur_amount "采购合同金额" ,tot_purchase_settling "采购结算量" ,tot_purchase_settle_amount "采购结算金额" ,nodelweight "未交货量" ,ready_weight "准发量" ,memo_weight "码单量" ,tot_act_gathering "入库量" ,transit_weight "在途量1准发未入库" ,intransit_weight "在途量2码单未入库" ,tot_sales_volume "累计销售量" ,tot_act_consiging "累计发货量" ,tot_sale_settling "累计销售结算量" FROM dm_gyl.f_query_pur_bxe_trace ) "T_DE3FFE" LEFT OUTER JOIN ( SELECT seg_no ,apply_id "采购申请单号" ,apply_subid "采购申请子项号" ,apply_substatus "申请子项状态" ,s_contract_id "销售合同号" ,s_contract_subid "销售合同子项号" ,contract_id "采购合约号" ,contract_subid "采购子项号" ,contract_substatus "合同子项状态" ,lock_flag "合同子项封锁" ,product_id "资源号" ,internal_seg_no "内往业务单元代码" ,provider_contract_subnum "供应商合同子项号" ,provider_product_id "供应商资源号" ,factory_product_id "钢厂资源号" ,delivery_period "交货期" ,cer_self_take "按周交货标志" ,delivery_week "交货期(按周)" ,consign_date "交货日期" ,direction_type "去向标记" ,customer_id "去向客户" ,good_seg_no "货号业务单元代码" ,good_id "货号" ,product_type_id "品种代码" ,producing_area_code "产地代码" ,density "密度" ,tech_standard "技术标准" ,shopsign "牌号" ,quality_grade "质量等级" ,spec "规格" ,spec1 "规格1" ,spec2 "规格2" ,spec3 "规格3" ,spec4 "规格4" ,spec5 "规格5" ,spec6 "规格6" ,spec7 "规格7" ,spec8 "规格8" ,spec9 "规格9" ,spec10 "规格10" ,special_desc_flag "是否允许使用特殊描述" ,psr_code "PSR码" ,apn_code "用途代码" ,usage "用途" ,packing_require "包装要求" ,add_content "附加内容" ,special_desc "特殊说明" ,equal_piece "等片包装数" ,moreorless "溢短装" ,each_quantity_standard "目标件重" ,up_each_qty "捆包上限" ,down_each_qty "捆包下限" ,copy_n_certificate "质保书份数" ,dissent_flag "异议标记" ,valuation_type "计价方式" ,weight_method "计重方式" ,weight_qty "订货重量" ,quantity_qty "订货数量" ,weight_unit "重量单位" ,quantity_unit "数量单位" ,unit_conversion "重量数量转化关系" ,pur_price_at "采购价格(含税价)" ,pur_price "采购价格" ,tax_rate "税率" ,p_sale_unitprice "股份的销售价" ,discount "折扣价" ,additive_price_1 "直供加价(价内)" ,additive_price_2 "代理加价(价内)" ,additive_price_3 "其他加价1(价内)" ,additive_price_4 "其它加价2(价内)" ,trans_allow "运费补贴" ,trans_price "运费单价(价外)" ,ins_price "保险费单价(价外)" ,other_fee "杂费单价(价外)" ,other_amount "其他费用(金额)" ,deposit_ord "委托发货(控货标记)" ,sale_price "预计销售单价" ,sale_price_at "预估销售含税单价" ,remark "备注" ,modi_date "更新日期" ,modi_person "更新人" ,create_date ,lh_flag "统货理货标记" ,product_dscr "品种描述" ,direction_use "去向用途　10－销售　　20－加工" ,car_type "车型" ,sale_agent_price "销售代理加价(价外)" ,supply_mark "生产方代码" ,part_num "零部件号" ,cust_ord_id "客户订单编号" ,logistics_scheme_no "物流方案号//FORYTH" ,p_company_code "卖方公司别//FORYTH" ,update_desc "同步子项描述记录" ,direct_user_num "地区公司订货用户代码" ,direct_user_name "地区公司订货用户名称" ,fin_user_num "最终用户代码" ,fin_user_name "最终用户名称" ,consignee_num "收货用户代码" ,consignee_name "收货用户名称" ,trnp_mode_code "运输方式代码" ,trnp_mode_name "运输方式描述" ,delivery_place_code "终到站港代码" ,delivery_place_name "终到站港描述" ,private_route_code "专用线代码" ,private_route_name "专用线描述" ,rain_coat_flag "加盖雨布要求" ,gf_deposit_ord "股份委托控货标记" ,freight_invoice "运费发票抬头要求" ,provider_contract_num "供应商合同号" ,unit_wt_weight ,pree_price "提前付款优惠" ,pref_amt_3 "一体化优惠三" ,pref_amt_4 "一体化优惠四" ,pref_amt_5 "一体化优惠五" ,other_favor "其他优惠汇总" ,settle_shift_flag "开票点后移合同分类标识" ,gf_order_type_code "一体化销售合同性质" ,futures_auction_flag "期货拍卖标记" ,part_id "零件号" ,cust_part_id "客户零件号" ,packing_type_id "包装方式" ,face_plating "表面镀层" ,face_coating "表面涂层" ,face_frame "表面结构" ,face_cladding "表面覆膜" ,colour "颜色" ,surface_grade "表面等级" ,business_type "业务类型,分为贸易10,配送20,来料加工30,仓储40" ,pref_amt_code1 "一体化优惠一原因" ,pref_amt_code2 "一体化优惠二原因" ,pref_amt_code3 "一体化优惠三原因" ,pref_amt_code4 "一体化优惠四原因" ,pref_amt_code5 "一体化优惠五原因" ,project_code "工程代码" ,project_name "工程名称" ,current_price_mark "当期价格标志P-前期价格空-当期价格" ,agree_price_sort "协议价格属性空-确定不锁定;N-不确定;L-锁定" ,agent_flag "代理资源标记1为是" ,old_apply_subid "原采购申请子项号" ,agent_price_type "代理费类型T-特殊代理费;空-标准代理费" ,certi_print_type "质保书打印类型1-用户自助打印;0-销售方打印;D-电子质保书下载;9-不打印" ,sale_price_add "销售加价" ,plan_stock_type "备库标记(10宝钢股份产能备库,20地区公司集中备库,30加工中心自行备库)" ,freight_flag "代收代付完成标记" ,xs_pay_style "销售付款类型" ,freight_finish_flag "采购合同运费结算完成标记" ,zbs_shopsign "质保书牌号" ,hd_property_dl "厚度属性大类:分六类1.NQ－普板2.NQ－低合金3.NQ－其他4.尾板－普板5.尾板－低合金6.尾板－其他" ,zbs_product_type_id "质保书品种代码" ,proxy_resource_price "代理资源代理费" ,tallying_fee "代理资源理货费" ,proxy_resource_price_at "代理资源代理费(含税)" ,tax_price_at "利息费(含税)" ,customs_product_num "海关商品编码" ,customs_product_name "海关商品名称" ,customs_product_en_name "海关商品英文名称" ,note_num "手册系统编号" ,contract_term_id "条款序号" ,straight_flag "直取标记" ,consignee_id "转入仓库" ,coat_structure_price_at "含税不锈钢表面加价" ,coat_code_price_at "含税不锈钢膜加价" ,add_price_base_at "含税不锈钢基价" ,add_price_edge_type_at "含税不锈钢毛边优惠" ,add_price_special_at "含税不锈钢大卷优惠" ,add_price_casing_expense_at "含税不锈钢包装加价" ,add_price_type_at "含税不锈钢平板加价" ,add_price_thick_at "含税不锈钢厚度加价" ,other_add_price_at "含税不锈钢其他加价" ,tc_upload_falg "交易中心上传标记0未上传,1已上传" ,order_agency_fee "订货代理费" ,order_unit "订货单位" ,auxiliary_unit "辅助单位" ,zt_product_flag "在途资源标记" ,tg_contract_num "特钢合同号" ,pree_date "提前生效合同优惠日期" ,if_syn_putin_apply "是否协同生成入库申请单" ,syn_seg_no "入库申请单协同单位" ,ship_id "船号" ,ship_name "船名" ,shipping_date "到港日期" ,pref_reason_code_6 "优惠原因代码6" ,pref_amt_6 "优惠金额6" ,pref_reason_code_7 "优惠原因代码7" ,pref_amt_7 "优惠金额7" ,pref_reason_code_8 "优惠原因代码8" ,pref_amt_8 "优惠金额8" ,pref_reason_code_9 "优惠原因代码9" ,pref_amt_9 "优惠金额9" ,pref_reason_code_10 "优惠原因代码10" ,pref_amt_10 "优惠金额10" ,base_price_improve "供方基价调整" ,product_no_green_flag "交易中心非绿灯资源标志" ,no_goods_power_consignment "不转货权的寄售" ,part_type "零件类型(10:正常零件20:可利用材30:异性件40:异型件50:平行四边形60:管件)" ,zj_qty "预收支架数" ,zj_price "支架单价" ,zj_amt "预收支架费" ,add_zj_qty "追加预收支架数" ,stock_flag "备料标志0-否1-是" ,stock_class "备料类别10-自采购备料(无销售合同)20-月滚动备料(有销售合同)30-第三方融资备料(有销售合同)" ,product_process_id "原卷首道加工工序" ,order_type "订货类型(同订货卡主项同名字段)" ,future_month "期货月" ,product_marking "非宝钢产品标记" ,parts_code "零部件代码" ,parts_name "零部件名称" ,car_type_code "车型代码" ,car_type_name "车型名称" ,quotawer "定额(KG)" ,prod_code "股份销售品种代码" ,prod_class "股份产品分类码" ,mbom_id "mbom和模板号id" ,suspected_repo_mark "疑似回购标记" ,material_code "物料编码" ,add_price_finishing "精整补偿优惠" ,al_price "铝锭单价" ,spec_contract_type "特殊合同类型" FROM odsp_bxe.bxe_cg_t_p_contract_d ) "T_35FECF" ON ( "T_DE3FFE"."采购合同号" = "T_35FECF"."采购合约号" AND "T_DE3FFE"."采购合同子项号" = "T_35FECF"."采购子项号" ) WHERE ( "T_DE3FFE"."采购业务类型" IN ('配送') AND "T_DE3FFE"."公司别名" IN ( '佛山宝钢' ,'欧冶上海不锈' ,'宁波宝钢' ) AND "T_35FECF"."质量等级" NOT LIKE '%YY%' AND "T_DE3FFE"."采购合同录入日期" >= TIMESTAMP '2022-03-01 00:00:00.0' ) ) "t1" WHERE ("t1"."__fcol_44" - "t1"."__fcol_35") > 0 ) "t2" LEFT OUTER JOIN ( SELECT "t5"."__fcol_79" "__fcol_84" ,"t5"."__fcol_81" "__fcol_85" ,("t5"."__fcol_82" - "t5"."__fcol_83") "__fcol_86" FROM ( SELECT "t3"."__fcol_73" "__fcol_79" ,"t3"."__fcol_69" "__fcol_80" ,"T_82D296"."客户名称" "__fcol_81" ,sum("t3"."__fcol_70") "__fcol_82" ,sum("t3"."__fcol_71") "__fcol_83" FROM ( SELECT "T_4B0357"."客户代码" "__fcol_69" ,"T_4B0357"."金额入" "__fcol_70" ,"T_4B0357"."金额出" "__fcol_71" ,CASE WHEN "T_4B0357"."业务单元代码" IN ('00181') THEN '欧冶上海不锈' WHEN "T_4B0357"."业务单元代码" IN ('00126') THEN '佛山宝钢' WHEN "T_4B0357"."业务单元代码" IN ('00140') THEN '宁波宝钢' ELSE cast("T_4B0357"."业务单元代码" AS VARCHAR) END "__fcol_73" FROM ( SELECT seg_no "业务单元代码" ,accset_no "帐套序号" ,io_id "出入流水号" ,io_batch_id "出入批次号" ,currency_id "币种" ,currency_rate "汇率" ,gathering_id "收条号" ,customer_id "客户代码" ,contract_id "合同号" ,in_amount "金额入" ,out_amount "金额出" ,manner_id "出入方式" ,depend_num1 "依据凭单1" ,depend_num2 "依据凭单2" ,depend_num3 "依据凭单3" ,voucher_id "对应凭证号" ,period_id "对应期间号" ,remark "备注" ,operate_flag "操作标识" ,modi_person "更新人" ,modi_date "更新日期" ,backup_flag "可归档标识" ,bill_patch_flag "是否通过提单补欠款页面补欠款" ,yjj_flag "是否月均价资金帐" ,e_pay_flag "是否iec网上自助配款" ,report_num "审批报告单据" ,is_settle_check "是否通过发票核销页面补欠款" ,dsdf_patch_flag "是否通过运费发票补欠款页面补欠款" FROM odsp_bxe.bxe_cw_t_fc_c_capital_io ) "T_4B0357" WHERE ( "T_4B0357"."业务单元代码" IN ( '00181' ,'00126' ,'00140' ) AND "T_4B0357"."出入方式" IN ( '302' ,'301' ) ) ) "t3" LEFT OUTER JOIN ( SELECT customer_id "客户代码" ,cust_name "客户名称" ,cust_eng_name "客户名称(英文)" ,cust_short_name "客户简称" ,STATUS "客户状态" ,cust_type "客户分类" ,cust_invester_type "客户投资类别" ,cust_asset_type "客户资产类别(国企外资)" ,cust_style "客户性质" ,vocation_code "行业编码" ,privince_id "省份代码" ,town_id "地级市代码" ,area_code "地区代码(区域)" ,group_flag "集团客户标识" ,group_cust_id "对应集团客户代码" ,credit_class "信用等级" ,tax_num "税号" ,reg_currency_id "注册资金币种" ,reg_fund "注册资金" ,reg_addr "注册地址" ,valid_end_date "有效终止日期" ,valid_start_date "有效起始日期" ,bank_acct_num "银行开户行帐号" ,bank_name "开户行名称" ,ivoice_addr "发票地址" ,invoice_tele "发票电话" ,invoice_zip "发票邮编" ,invoice_acct_num "发票结算户帐号" ,invoice_bank "发票结算户开户行" ,invoice_post_type "发票领取方式" ,invoice_build_type "发票要求" ,settle_acct_num "结算户帐号" ,settle_bank "结算户开户行" ,art_person "法人" ,art_person_pre "法人代表" ,boss "公司负责人" ,contact_person "公司联系人" ,contact_addr "公司联系地址" ,contact_tele "公司联系电话" ,fax_num "公司联系传真" ,post_code "公司联系邮编" ,email "公司电子邮箱" ,web "公司网站地址" ,trade_remark "公司业务说明" ,remark "备注" ,seg_no "对应业务单元代码" ,modi_date "更新日期" ,modi_person "更新人" ,sales_pers_no "营销员" ,print_freight "是否打印运费(1是0否)" ,gljy_code "股份关联交易对应代码" ,if_fee_all "运费全额预收标记" ,currency_id "记账币种" ,insurance_company "保险公司" ,insurance_type "保险类型(a价内;b价外;c免保险费;d按实际合同约定方式;)" ,insurance_flag "保险标志(1入成本,即价内加价保险;0代收代付)" ,invoice_print_type "发票打印类型" ,gf_company_code "股份公司组织码" ,general_taxpayer_flag "一般纳税人" ,create_date "客户开户日期" ,qa_flag "是否需要质保书" ,p_customer_id "一体化客户代码" ,ems_contact_person "EMS发票联系人" ,ss_customer_id "现货客户代码" ,ss_password "初始密码" ,contract_customer_id "对应合同客户" ,dis_plus_flag "正数折扣单独结算" ,organization_code "组织机构证件号" ,if_mach "加工中心标记//FORYTH(J或空)" ,fig_contract_flag "数字合同标记" ,company_scale "公司规模" ,cust_inner_type "客户内部分类" ,gz_flag "行业跟踪标记" ,report_count "走访报告数" ,if_free_discount "是否自由款给付利息" ,tax_shopsign_flag "发票商品名称牌号标记" ,agency_type "代理用户类型(10:纯代理商20:用户代理)" ,earnest_ratio "定金比例" ,factory_bank_cust_flag "厂商银客户标记" ,ca_user_flag "CA用户使用标志1.使用0不使用" ,recdepacnt "收款人银行帐号" ,recdepbranch "收款人开户行" ,recareaname "收款人帐户地区名" ,samebankflag "银行标志" ,cityflag "同城异地标志(0-同城1-异地)" ,cust_seg_no "客户所属组织机构" ,cust_dept_id "客户所属部门" ,cust_rz_flag "融资标记" ,cust_rz_upflag "融资上传标记" ,cust_rz_name "融资平台客户代码" ,fixed_insurance_flag "是否固定保险单价" ,fixed_insurance_fee "固定保险单价" ,app_num "申请号" ,org_code_num "销售中心管理科室码" ,english_usnm_abbr "英文简称" ,bank_name_code "银行代码" ,cust_dis_num "股份用户区别码" ,user_type "销售用户业务属性" ,stratagem_mark "销售用户分级类别" ,sale_user_type "销售内部用户属性区别码" ,country_name_abbr "国别" ,user_mark "用户税号区分码" ,trade "行业代码" ,company_code "公司别" ,tab_user_num "总公司代码" ,tab_user_name "总公司名称" ,label_from "标签格式" ,office_addr "办公所在地省份" ,busin_num "工商登记号" ,tax_num_add "税号附加码" ,id_card "客户供应商身份证号" ,duty "职务" ,addr_regst "注册所在地省份" ,applice_tel "申请人电话" ,sale_network "销售渠道" ,charge_remark "期货/现货/社会贸易用户标志" ,list_tele_num "联系人电话" ,pack_bill_flag "按捆包开提单" ,accrual_zero_flag "零利率标记" ,inner_user_id "内销员" ,outer_user_id "外销员" ,xh_customer_id "UMC客户代码" ,xh_customer_flag "UMC客户标记" ,ower_certificate_flag "客户自主打印质保书标记:1是,0否" ,xh_upload_flag "UMC平台更新标记(为0或者为空时需要更新,为1时已经更新)" ,all_contract_txt "通用合同文本" ,umc_company_code "BSP平台客户代码" ,settle_maths_type "销售结算金额计算方式" ,bsp_channel1 "标准版" ,bsp_channel2 "融资" ,bsp_channel3 "现货" ,bsp_channel4 "钢贸宝时达" ,business_license_p_name "营业执照电子文件名" ,business_license_ftp_paths "营业执照电子文件路径" ,tax_registration_p_name "税务登记证文件名" ,tax_registration_ftp_paths "税务登记证文件路径" ,organization_code_p_name "组织机构代码证文件名" ,organization_code_ftp_path "组织机构代码证文件路径" ,operating_activities_p_name "经营活动证明及材料名" ,operating_activities_ftp_paths "经营活动证明及材料路径" ,own_cust_id "自有代码标记,1为该用户自身对应的代码" ,tax_collect_flag "税控系统是否传80位规格" ,ss_bill_fact_flag "ss平台未实收资金用于开提单" ,bill_settle_control "合同暂缓开票(0:不控制1:控制)" ,longitude "经度(转换为小数)" ,latitude "纬度(转换为小数)" ,get_notice "获知宝时达渠道" ,get_notice_remark "获知渠道备注" ,power_of_attorney_path "授权委托书路径" ,power_of_attorney_name "授权委托书文件名" ,not_verify "未验证资料(用户钢贸现货客户开户)" ,mes_flag "记录客户是否具有提单短信发送功能" ,mes_mobil "记录提单短信发送手机号" ,mes_receiver "记录短信接收人名称" ,iftransfers_rule "是否遵守自助配款顺序规则(1是0否)" ,dun_brand "邓百氏代码" ,company_flag "地区公司/剪切中心标志" ,tab_flag "是否集团公司标志" ,distributor_identify "经销商标识" ,distributor_busuiness_type "经销商业务属性" ,customer_registration_status "用户性质" ,version_num "版本号" ,active_start_date "有效标志起始日期" ,active_end_date "有效标志终止日期" ,stratagem_mark_2 "特钢产品销售用户分级类别" ,stratagem_mark_1 "不锈钢销售用户分级类别" ,trade_2 "特钢产品代表行业代码" ,trade_1 "不锈钢产品代表行业代码" ,cust_from "客户来源" ,overseas_id_card "境外营业证号" ,ivoice_mail_address "发票寄送地址" ,receive_man "收件人" ,receive_tel "收件电话" ,bg_org_num "宝钢组织机构码" ,wg_customer_id "武钢客户代码" ,wg_cust_name "武钢客户名称" ,check_num "检查码" ,quality_send_type "质保书传递方式" ,english_addr "客户英文地址" ,contact_engl "联络英文地址" ,apply_remark "武钢开户申请备注" ,stock_wg "渠道代码" ,cust_attri_wg "客户属性" ,flag_wg "资料传递标识" ,law_man_id_card_wg "法人代表身份证" ,calling_num_wg "行业地位" ,ds_p_customer_id "德盛客商代码" FROM odsp_bxe.bxe_xt_t_ss_customer ) "T_82D296" ON "t3"."__fcol_69" = "T_82D296"."客户代码" GROUP BY "t3"."__fcol_73" ,"t3"."__fcol_69" ,"T_82D296"."客户名称" ) "t5" ) "t6" ON ( "t2"."__fcol_45" = "t6"."__fcol_84" AND "t2"."__fcol_52" = "t6"."__fcol_85" ) ) "t8" LEFT OUTER JOIN ( SELECT "t13"."__fcol_161" "__fcol_164" ,"t13"."__fcol_162" "__fcol_165" ,"t13"."__fcol_163" "__fcol_166" FROM ( SELECT "t12"."__fcol_156" "__fcol_161" ,"t12"."__fcol_157" "__fcol_162" ,sum("t12"."__fcol_160") "__fcol_163" FROM ( SELECT "t11"."__fcol_150" "__fcol_156" ,"t11"."__fcol_152" "__fcol_157" ,("t11"."__fcol_155" - "t11"."__fcol_154") "__fcol_160" FROM ( SELECT "t9"."__fcol_143" "__fcol_150" ,"t9"."__fcol_138" "__fcol_151" ,"T_82D296_0"."客户名称" "__fcol_152" ,"t9"."__fcol_141" "__fcol_153" ,sum("t9"."__fcol_139") "__fcol_154" ,sum("t9"."__fcol_140") "__fcol_155" FROM ( SELECT "T_4B0357_0"."客户代码" "__fcol_138" ,"T_4B0357_0"."金额入" "__fcol_139" ,"T_4B0357_0"."金额出" "__fcol_140" ,"T_4B0357_0"."合同号" "__fcol_141" ,CASE WHEN "T_4B0357_0"."业务单元代码" IN ('00181') THEN '欧冶上海不锈' WHEN "T_4B0357_0"."业务单元代码" IN ('00126') THEN '佛山宝钢' WHEN "T_4B0357_0"."业务单元代码" IN ('00140') THEN '宁波宝钢' ELSE cast("T_4B0357_0"."业务单元代码" AS VARCHAR) END "__fcol_143" FROM ( SELECT seg_no "业务单元代码" ,accset_no "帐套序号" ,io_id "出入流水号" ,io_batch_id "出入批次号" ,currency_id "币种" ,currency_rate "汇率" ,gathering_id "收条号" ,customer_id "客户代码" ,contract_id "合同号" ,in_amount "金额入" ,out_amount "金额出" ,manner_id "出入方式" ,depend_num1 "依据凭单1" ,depend_num2 "依据凭单2" ,depend_num3 "依据凭单3" ,voucher_id "对应凭证号" ,period_id "对应期间号" ,remark "备注" ,operate_flag "操作标识" ,modi_person "更新人" ,modi_date "更新日期" ,backup_flag "可归档标识" ,bill_patch_flag "是否通过提单补欠款页面补欠款" ,yjj_flag "是否月均价资金帐" ,e_pay_flag "是否iec网上自助配款" ,report_num "审批报告单据" ,is_settle_check "是否通过发票核销页面补欠款" ,dsdf_patch_flag "是否通过运费发票补欠款页面补欠款" FROM odsp_bxe.bxe_cw_t_fc_c_capital_io ) "T_4B0357_0" WHERE ( "T_4B0357_0"."业务单元代码" IN ( '00181' ,'00126' ,'00140' ) AND "T_4B0357_0"."出入方式" IN ( '151' ,'152' ) ) ) "t9" LEFT OUTER JOIN ( SELECT customer_id "客户代码" ,cust_name "客户名称" ,cust_eng_name "客户名称(英文)" ,cust_short_name "客户简称" ,STATUS "客户状态" ,cust_type "客户分类" ,cust_invester_type "客户投资类别" ,cust_asset_type "客户资产类别(国企外资)" ,cust_style "客户性质" ,vocation_code "行业编码" ,privince_id "省份代码" ,town_id "地级市代码" ,area_code "地区代码(区域)" ,group_flag "集团客户标识" ,group_cust_id "对应集团客户代码" ,credit_class "信用等级" ,tax_num "税号" ,reg_currency_id "注册资金币种" ,reg_fund "注册资金" ,reg_addr "注册地址" ,valid_end_date "有效终止日期" ,valid_start_date "有效起始日期" ,bank_acct_num "银行开户行帐号" ,bank_name "开户行名称" ,ivoice_addr "发票地址" ,invoice_tele "发票电话" ,invoice_zip "发票邮编" ,invoice_acct_num "发票结算户帐号" ,invoice_bank "发票结算户开户行" ,invoice_post_type "发票领取方式" ,invoice_build_type "发票要求" ,settle_acct_num "结算户帐号" ,settle_bank "结算户开户行" ,art_person "法人" ,art_person_pre "法人代表" ,boss "公司负责人" ,contact_person "公司联系人" ,contact_addr "公司联系地址" ,contact_tele "公司联系电话" ,fax_num "公司联系传真" ,post_code "公司联系邮编" ,email "公司电子邮箱" ,web "公司网站地址" ,trade_remark "公司业务说明" ,remark "备注" ,seg_no "对应业务单元代码" ,modi_date "更新日期" ,modi_person "更新人" ,sales_pers_no "营销员" ,print_freight "是否打印运费(1是0否)" ,gljy_code "股份关联交易对应代码" ,if_fee_all "运费全额预收标记" ,currency_id "记账币种" ,insurance_company "保险公司" ,insurance_type "保险类型(a价内;b价外;c免保险费;d按实际合同约定方式;)" ,insurance_flag "保险标志(1入成本,即价内加价保险;0代收代付)" ,invoice_print_type "发票打印类型" ,gf_company_code "股份公司组织码" ,general_taxpayer_flag "一般纳税人" ,create_date "客户开户日期" ,qa_flag "是否需要质保书" ,p_customer_id "一体化客户代码" ,ems_contact_person "EMS发票联系人" ,ss_customer_id "现货客户代码" ,ss_password "初始密码" ,contract_customer_id "对应合同客户" ,dis_plus_flag "正数折扣单独结算" ,organization_code "组织机构证件号" ,if_mach "加工中心标记//FORYTH(J或空)" ,fig_contract_flag "数字合同标记" ,company_scale "公司规模" ,cust_inner_type "客户内部分类" ,gz_flag "行业跟踪标记" ,report_count "走访报告数" ,if_free_discount "是否自由款给付利息" ,tax_shopsign_flag "发票商品名称牌号标记" ,agency_type "代理用户类型(10:纯代理商20:用户代理)" ,earnest_ratio "定金比例" ,factory_bank_cust_flag "厂商银客户标记" ,ca_user_flag "CA用户使用标志1.使用0不使用" ,recdepacnt "收款人银行帐号" ,recdepbranch "收款人开户行" ,recareaname "收款人帐户地区名" ,samebankflag "银行标志" ,cityflag "同城异地标志(0-同城1-异地)" ,cust_seg_no "客户所属组织机构" ,cust_dept_id "客户所属部门" ,cust_rz_flag "融资标记" ,cust_rz_upflag "融资上传标记" ,cust_rz_name "融资平台客户代码" ,fixed_insurance_flag "是否固定保险单价" ,fixed_insurance_fee "固定保险单价" ,app_num "申请号" ,org_code_num "销售中心管理科室码" ,english_usnm_abbr "英文简称" ,bank_name_code "银行代码" ,cust_dis_num "股份用户区别码" ,user_type "销售用户业务属性" ,stratagem_mark "销售用户分级类别" ,sale_user_type "销售内部用户属性区别码" ,country_name_abbr "国别" ,user_mark "用户税号区分码" ,trade "行业代码" ,company_code "公司别" ,tab_user_num "总公司代码" ,tab_user_name "总公司名称" ,label_from "标签格式" ,office_addr "办公所在地省份" ,busin_num "工商登记号" ,tax_num_add "税号附加码" ,id_card "客户供应商身份证号" ,duty "职务" ,addr_regst "注册所在地省份" ,applice_tel "申请人电话" ,sale_network "销售渠道" ,charge_remark "期货/现货/社会贸易用户标志" ,list_tele_num "联系人电话" ,pack_bill_flag "按捆包开提单" ,accrual_zero_flag "零利率标记" ,inner_user_id "内销员" ,outer_user_id "外销员" ,xh_customer_id "UMC客户代码" ,xh_customer_flag "UMC客户标记" ,ower_certificate_flag "客户自主打印质保书标记:1是,0否" ,xh_upload_flag "UMC平台更新标记(为0或者为空时需要更新,为1时已经更新)" ,all_contract_txt "通用合同文本" ,umc_company_code "BSP平台客户代码" ,settle_maths_type "销售结算金额计算方式" ,bsp_channel1 "标准版" ,bsp_channel2 "融资" ,bsp_channel3 "现货" ,bsp_channel4 "钢贸宝时达" ,business_license_p_name "营业执照电子文件名" ,business_license_ftp_paths "营业执照电子文件路径" ,tax_registration_p_name "税务登记证文件名" ,tax_registration_ftp_paths "税务登记证文件路径" ,organization_code_p_name "组织机构代码证文件名" ,organization_code_ftp_path "组织机构代码证文件路径" ,operating_activities_p_name "经营活动证明及材料名" ,operating_activities_ftp_paths "经营活动证明及材料路径" ,own_cust_id "自有代码标记,1为该用户自身对应的代码" ,tax_collect_flag "税控系统是否传80位规格" ,ss_bill_fact_flag "ss平台未实收资金用于开提单" ,bill_settle_control "合同暂缓开票(0:不控制1:控制)" ,longitude "经度(转换为小数)" ,latitude "纬度(转换为小数)" ,get_notice "获知宝时达渠道" ,get_notice_remark "获知渠道备注" ,power_of_attorney_path "授权委托书路径" ,power_of_attorney_name "授权委托书文件名" ,not_verify "未验证资料(用户钢贸现货客户开户)" ,mes_flag "记录客户是否具有提单短信发送功能" ,mes_mobil "记录提单短信发送手机号" ,mes_receiver "记录短信接收人名称" ,iftransfers_rule "是否遵守自助配款顺序规则(1是0否)" ,dun_brand "邓百氏代码" ,company_flag "地区公司/剪切中心标志" ,tab_flag "是否集团公司标志" ,distributor_identify "经销商标识" ,distributor_busuiness_type "经销商业务属性" ,customer_registration_status "用户性质" ,version_num "版本号" ,active_start_date "有效标志起始日期" ,active_end_date "有效标志终止日期" ,stratagem_mark_2 "特钢产品销售用户分级类别" ,stratagem_mark_1 "不锈钢销售用户分级类别" ,trade_2 "特钢产品代表行业代码" ,trade_1 "不锈钢产品代表行业代码" ,cust_from "客户来源" ,overseas_id_card "境外营业证号" ,ivoice_mail_address "发票寄送地址" ,receive_man "收件人" ,receive_tel "收件电话" ,bg_org_num "宝钢组织机构码" ,wg_customer_id "武钢客户代码" ,wg_cust_name "武钢客户名称" ,check_num "检查码" ,quality_send_type "质保书传递方式" ,english_addr "客户英文地址" ,contact_engl "联络英文地址" ,apply_remark "武钢开户申请备注" ,stock_wg "渠道代码" ,cust_attri_wg "客户属性" ,flag_wg "资料传递标识" ,law_man_id_card_wg "法人代表身份证" ,calling_num_wg "行业地位" ,ds_p_customer_id "德盛客商代码" FROM odsp_bxe.bxe_xt_t_ss_customer ) "T_82D296_0" ON "t9"."__fcol_138" = "T_82D296_0"."客户代码" GROUP BY "t9"."__fcol_143" ,"t9"."__fcol_138" ,"T_82D296_0"."客户名称" ,"t9"."__fcol_141" ) "t11" WHERE NOT (("t11"."__fcol_155" - "t11"."__fcol_154") = 0) ) "t12" GROUP BY "t12"."__fcol_156" ,"t12"."__fcol_157" ) "t13" ) "t14" ON ( "t8"."__fcol_112" = "t14"."__fcol_164" AND "t8"."__fcol_119" = "t14"."__fcol_165" ) ) "t16" LEFT OUTER JOIN ( SELECT "t21"."__fcol_243" "__fcol_246" ,"t21"."__fcol_244" "__fcol_247" ,"t21"."__fcol_245" "__fcol_248" FROM ( SELECT "t20"."__fcol_238" "__fcol_243" ,"t20"."__fcol_239" "__fcol_244" ,sum("t20"."__fcol_242") "__fcol_245" FROM ( SELECT "t19"."__fcol_232" "__fcol_238" ,"t19"."__fcol_234" "__fcol_239" ,("t19"."__fcol_237" - "t19"."__fcol_236") "__fcol_242" FROM ( SELECT "t17"."__fcol_225" "__fcol_232" ,"t17"."__fcol_220" "__fcol_233" ,"T_82D296_1"."客户名称" "__fcol_234" ,"t17"."__fcol_223" "__fcol_235" ,sum("t17"."__fcol_221") "__fcol_236" ,sum("t17"."__fcol_222") "__fcol_237" FROM ( SELECT "T_4B0357_1"."客户代码" "__fcol_220" ,"T_4B0357_1"."金额入" "__fcol_221" ,"T_4B0357_1"."金额出" "__fcol_222" ,"T_4B0357_1"."依据凭单1" "__fcol_223" ,CASE WHEN "T_4B0357_1"."业务单元代码" IN ('00181') THEN '欧冶上海不锈' WHEN "T_4B0357_1"."业务单元代码" IN ('00126') THEN '佛山宝钢' WHEN "T_4B0357_1"."业务单元代码" IN ('00140') THEN '宁波宝钢' ELSE cast("T_4B0357_1"."业务单元代码" AS VARCHAR) END "__fcol_225" FROM ( SELECT seg_no "业务单元代码" ,accset_no "帐套序号" ,io_id "出入流水号" ,io_batch_id "出入批次号" ,currency_id "币种" ,currency_rate "汇率" ,gathering_id "收条号" ,customer_id "客户代码" ,contract_id "合同号" ,in_amount "金额入" ,out_amount "金额出" ,manner_id "出入方式" ,depend_num1 "依据凭单1" ,depend_num2 "依据凭单2" ,depend_num3 "依据凭单3" ,voucher_id "对应凭证号" ,period_id "对应期间号" ,remark "备注" ,operate_flag "操作标识" ,modi_person "更新人" ,modi_date "更新日期" ,backup_flag "可归档标识" ,bill_patch_flag "是否通过提单补欠款页面补欠款" ,yjj_flag "是否月均价资金帐" ,e_pay_flag "是否iec网上自助配款" ,report_num "审批报告单据" ,is_settle_check "是否通过发票核销页面补欠款" ,dsdf_patch_flag "是否通过运费发票补欠款页面补欠款" FROM odsp_bxe.bxe_cw_t_fc_c_capital_io ) "T_4B0357_1" WHERE ( "T_4B0357_1"."业务单元代码" IN ( '00181' ,'00126' ,'00140' ) AND "T_4B0357_1"."出入方式" IN ( '201' ,'202' ) AND "T_4B0357_1"."备注" LIKE '%协议%' AND "T_4B0357_1"."合同号" IN ('ZYK') ) ) "t17" LEFT OUTER JOIN ( SELECT customer_id "客户代码" ,cust_name "客户名称" ,cust_eng_name "客户名称(英文)" ,cust_short_name "客户简称" ,STATUS "客户状态" ,cust_type "客户分类" ,cust_invester_type "客户投资类别" ,cust_asset_type "客户资产类别(国企外资)" ,cust_style "客户性质" ,vocation_code "行业编码" ,privince_id "省份代码" ,town_id "地级市代码" ,area_code "地区代码(区域)" ,group_flag "集团客户标识" ,group_cust_id "对应集团客户代码" ,credit_class "信用等级" ,tax_num "税号" ,reg_currency_id "注册资金币种" ,reg_fund "注册资金" ,reg_addr "注册地址" ,valid_end_date "有效终止日期" ,valid_start_date "有效起始日期" ,bank_acct_num "银行开户行帐号" ,bank_name "开户行名称" ,ivoice_addr "发票地址" ,invoice_tele "发票电话" ,invoice_zip "发票邮编" ,invoice_acct_num "发票结算户帐号" ,invoice_bank "发票结算户开户行" ,invoice_post_type "发票领取方式" ,invoice_build_type "发票要求" ,settle_acct_num "结算户帐号" ,settle_bank "结算户开户行" ,art_person "法人" ,art_person_pre "法人代表" ,boss "公司负责人" ,contact_person "公司联系人" ,contact_addr "公司联系地址" ,contact_tele "公司联系电话" ,fax_num "公司联系传真" ,post_code "公司联系邮编" ,email "公司电子邮箱" ,web "公司网站地址" ,trade_remark "公司业务说明" ,remark "备注" ,seg_no "对应业务单元代码" ,modi_date "更新日期" ,modi_person "更新人" ,sales_pers_no "营销员" ,print_freight "是否打印运费(1是0否)" ,gljy_code "股份关联交易对应代码" ,if_fee_all "运费全额预收标记" ,currency_id "记账币种" ,insurance_company "保险公司" ,insurance_type "保险类型(a价内;b价外;c免保险费;d按实际合同约定方式;)" ,insurance_flag "保险标志(1入成本,即价内加价保险;0代收代付)" ,invoice_print_type "发票打印类型" ,gf_company_code "股份公司组织码" ,general_taxpayer_flag "一般纳税人" ,create_date "客户开户日期" ,qa_flag "是否需要质保书" ,p_customer_id "一体化客户代码" ,ems_contact_person "EMS发票联系人" ,ss_customer_id "现货客户代码" ,ss_password "初始密码" ,contract_customer_id "对应合同客户" ,dis_plus_flag "正数折扣单独结算" ,organization_code "组织机构证件号" ,if_mach "加工中心标记//FORYTH(J或空)" ,fig_contract_flag "数字合同标记" ,company_scale "公司规模" ,cust_inner_type "客户内部分类" ,gz_flag "行业跟踪标记" ,report_count "走访报告数" ,if_free_discount "是否自由款给付利息" ,tax_shopsign_flag "发票商品名称牌号标记" ,agency_type "代理用户类型(10:纯代理商20:用户代理)" ,earnest_ratio "定金比例" ,factory_bank_cust_flag "厂商银客户标记" ,ca_user_flag "CA用户使用标志1.使用0不使用" ,recdepacnt "收款人银行帐号" ,recdepbranch "收款人开户行" ,recareaname "收款人帐户地区名" ,samebankflag "银行标志" ,cityflag "同城异地标志(0-同城1-异地)" ,cust_seg_no "客户所属组织机构" ,cust_dept_id "客户所属部门" ,cust_rz_flag "融资标记" ,cust_rz_upflag "融资上传标记" ,cust_rz_name "融资平台客户代码" ,fixed_insurance_flag "是否固定保险单价" ,fixed_insurance_fee "固定保险单价" ,app_num "申请号" ,org_code_num "销售中心管理科室码" ,english_usnm_abbr "英文简称" ,bank_name_code "银行代码" ,cust_dis_num "股份用户区别码" ,user_type "销售用户业务属性" ,stratagem_mark "销售用户分级类别" ,sale_user_type "销售内部用户属性区别码" ,country_name_abbr "国别" ,user_mark "用户税号区分码" ,trade "行业代码" ,company_code "公司别" ,tab_user_num "总公司代码" ,tab_user_name "总公司名称" ,label_from "标签格式" ,office_addr "办公所在地省份" ,busin_num "工商登记号" ,tax_num_add "税号附加码" ,id_card "客户供应商身份证号" ,duty "职务" ,addr_regst "注册所在地省份" ,applice_tel "申请人电话" ,sale_network "销售渠道" ,charge_remark "期货/现货/社会贸易用户标志" ,list_tele_num "联系人电话" ,pack_bill_flag "按捆包开提单" ,accrual_zero_flag "零利率标记" ,inner_user_id "内销员" ,outer_user_id "外销员" ,xh_customer_id "UMC客户代码" ,xh_customer_flag "UMC客户标记" ,ower_certificate_flag "客户自主打印质保书标记:1是,0否" ,xh_upload_flag "UMC平台更新标记(为0或者为空时需要更新,为1时已经更新)" ,all_contract_txt "通用合同文本" ,umc_company_code "BSP平台客户代码" ,settle_maths_type "销售结算金额计算方式" ,bsp_channel1 "标准版" ,bsp_channel2 "融资" ,bsp_channel3 "现货" ,bsp_channel4 "钢贸宝时达" ,business_license_p_name "营业执照电子文件名" ,business_license_ftp_paths "营业执照电子文件路径" ,tax_registration_p_name "税务登记证文件名" ,tax_registration_ftp_paths "税务登记证文件路径" ,organization_code_p_name "组织机构代码证文件名" ,organization_code_ftp_path "组织机构代码证文件路径" ,operating_activities_p_name "经营活动证明及材料名" ,operating_activities_ftp_paths "经营活动证明及材料路径" ,own_cust_id "自有代码标记,1为该用户自身对应的代码" ,tax_collect_flag "税控系统是否传80位规格" ,ss_bill_fact_flag "ss平台未实收资金用于开提单" ,bill_settle_control "合同暂缓开票(0:不控制1:控制)" ,longitude "经度(转换为小数)" ,latitude "纬度(转换为小数)" ,get_notice "获知宝时达渠道" ,get_notice_remark "获知渠道备注" ,power_of_attorney_path "授权委托书路径" ,power_of_attorney_name "授权委托书文件名" ,not_verify "未验证资料(用户钢贸现货客户开户)" ,mes_flag "记录客户是否具有提单短信发送功能" ,mes_mobil "记录提单短信发送手机号" ,mes_receiver "记录短信接收人名称" ,iftransfers_rule "是否遵守自助配款顺序规则(1是0否)" ,dun_brand "邓百氏代码" ,company_flag "地区公司/剪切中心标志" ,tab_flag "是否集团公司标志" ,distributor_identify "经销商标识" ,distributor_busuiness_type "经销商业务属性" ,customer_registration_status "用户性质" ,version_num "版本号" ,active_start_date "有效标志起始日期" ,active_end_date "有效标志终止日期" ,stratagem_mark_2 "特钢产品销售用户分级类别" ,stratagem_mark_1 "不锈钢销售用户分级类别" ,trade_2 "特钢产品代表行业代码" ,trade_1 "不锈钢产品代表行业代码" ,cust_from "客户来源" ,overseas_id_card "境外营业证号" ,ivoice_mail_address "发票寄送地址" ,receive_man "收件人" ,receive_tel "收件电话" ,bg_org_num "宝钢组织机构码" ,wg_customer_id "武钢客户代码" ,wg_cust_name "武钢客户名称" ,check_num "检查码" ,quality_send_type "质保书传递方式" ,english_addr "客户英文地址" ,contact_engl "联络英文地址" ,apply_remark "武钢开户申请备注" ,stock_wg "渠道代码" ,cust_attri_wg "客户属性" ,flag_wg "资料传递标识" ,law_man_id_card_wg "法人代表身份证" ,calling_num_wg "行业地位" ,ds_p_customer_id "德盛客商代码" FROM odsp_bxe.bxe_xt_t_ss_customer ) "T_82D296_1" ON "t17"."__fcol_220" = "T_82D296_1"."客户代码" GROUP BY "t17"."__fcol_225" ,"t17"."__fcol_220" ,"T_82D296_1"."客户名称" ,"t17"."__fcol_223" ) "t19" WHERE NOT (("t19"."__fcol_237" - "t19"."__fcol_236") = 0) ) "t20" GROUP BY "t20"."__fcol_238" ,"t20"."__fcol_239" ) "t21" ) "t22" ON ( "t16"."__fcol_193" = "t22"."__fcol_246" AND "t16"."__fcol_200" = "t22"."__fcol_247" ) ) "t24" ) "t25" ) "t26" ) "t27" LEFT OUTER JOIN ( SELECT "t28"."__fcol_403" "__fcol_407" ,cast("t28"."__fcol_406" AS TIMESTAMP) "__fcol_408" ,"t28"."__fcol_404" "__fcol_409" FROM ( SELECT "T_2FF518"."不锈钢价格-材质/表面" "__fcol_403" ,"T_2FF518"."不锈钢价格-基价" "__fcol_404" ,( cast(YEAR("T_2FF518"."不锈钢价格-日期") AS VARCHAR) || '-' || SUBSTRING(('0' || cast(MONTH("T_2FF518"."不锈钢价格-日期") AS VARCHAR)), CASE WHEN 1 > ((char_length(('0' || cast(MONTH("T_2FF518"."不锈钢价格-日期") AS VARCHAR))) + 1) - 2) THEN 1 ELSE ((char_length(('0' || cast(MONTH("T_2FF518"."不锈钢价格-日期") AS VARCHAR))) + 1) - 2) END) ) "__fcol_406" FROM ( SELECT field1 "不锈钢价格-日期" ,field2 "不锈钢价格-地区" ,field3 "不锈钢价格-材质/表面" ,field4 "不锈钢价格-品种" ,field5 "不锈钢价格-产地" ,field6 "不锈钢价格-基价" ,field7 "原料价格-日期" ,field8 "原料价格-镍铁价格" ,field9 "原料价格-铬铁价格" ,field10 "原料价格-地区" ,field11 "无锡周库存（单位：万吨）-日期" ,field12 "无锡周库存（单位：万吨）-200系" ,field13 "无锡周库存（单位：万吨）-300系" ,field14 "无锡周库存（单位：万吨）-400系" ,field15 "无锡周库存（单位：万吨）-总量" ,field16 "佛山周库存（单位：万吨）-日期" ,field17 "佛山周库存（单位：万吨）-200系" ,field18 "佛山周库存（单位：万吨）-300系" ,field19 "佛山周库存（单位：万吨）-400系" ,field20 "佛山周库存（单位：万吨）-总量" FROM ods_finebi.t_bi_t_069181 ) "T_2FF518" WHERE ( "T_2FF518"."不锈钢价格-地区" IN ('无锡') AND ( "T_2FF518"."不锈钢价格-材质/表面" LIKE 'BN4%' OR "T_2FF518"."不锈钢价格-材质/表面" LIKE 'SPHC%' OR "T_2FF518"."不锈钢价格-材质/表面" LIKE '304L%' OR "T_2FF518"."不锈钢价格-材质/表面" LIKE 'DC51D+Z%' OR "T_2FF518"."不锈钢价格-材质/表面" LIKE 'SECCN5%' OR "T_2FF518"."不锈钢价格-材质/表面" LIKE '50WW1300%' ) ) ) "t28" ) "t29" ON ( "t27"."__fcol_369" = "t29"."__fcol_408" AND "t27"."__fcol_368" = "t29"."__fcol_407" ) ) "t31" LEFT OUTER JOIN ( SELECT cast("t32"."__fcol_481" AS TIMESTAMP) "__fcol_482" ,"t32"."__fcol_478" "__fcol_483" ,"t32"."__fcol_479" "__fcol_484" FROM ( SELECT "T_2FF518_0"."不锈钢价格-材质/表面" "__fcol_478" ,"T_2FF518_0"."不锈钢价格-基价" "__fcol_479" ,( cast(YEAR("T_2FF518_0"."不锈钢价格-日期") AS VARCHAR) || '-' || SUBSTRING(('0' || cast(MONTH("T_2FF518_0"."不锈钢价格-日期") AS VARCHAR)), CASE WHEN 1 > ((char_length(('0' || cast(MONTH("T_2FF518_0"."不锈钢价格-日期") AS VARCHAR))) + 1) - 2) THEN 1 ELSE ((char_length(('0' || cast(MONTH("T_2FF518_0"."不锈钢价格-日期") AS VARCHAR))) + 1) - 2) END) ) "__fcol_481" FROM ( SELECT field1 "不锈钢价格-日期" ,field2 "不锈钢价格-地区" ,field3 "不锈钢价格-材质/表面" ,field4 "不锈钢价格-品种" ,field5 "不锈钢价格-产地" ,field6 "不锈钢价格-基价" ,field7 "原料价格-日期" ,field8 "原料价格-镍铁价格" ,field9 "原料价格-铬铁价格" ,field10 "原料价格-地区" ,field11 "无锡周库存（单位：万吨）-日期" ,field12 "无锡周库存（单位：万吨）-200系" ,field13 "无锡周库存（单位：万吨）-300系" ,field14 "无锡周库存（单位：万吨）-400系" ,field15 "无锡周库存（单位：万吨）-总量" ,field16 "佛山周库存（单位：万吨）-日期" ,field17 "佛山周库存（单位：万吨）-200系" ,field18 "佛山周库存（单位：万吨）-300系" ,field19 "佛山周库存（单位：万吨）-400系" ,field20 "佛山周库存（单位：万吨）-总量" FROM ods_finebi.t_bi_t_069181 ) "T_2FF518_0" WHERE ( "T_2FF518_0"."不锈钢价格-地区" IN ('无锡') AND ( "T_2FF518_0"."不锈钢价格-材质/表面" LIKE 'BN4%' OR "T_2FF518_0"."不锈钢价格-材质/表面" LIKE 'SPHC%' OR "T_2FF518_0"."不锈钢价格-材质/表面" LIKE '304L%' OR "T_2FF518_0"."不锈钢价格-材质/表面" LIKE 'DC51D+Z%' OR "T_2FF518_0"."不锈钢价格-材质/表面" LIKE 'SECCN5%' OR "T_2FF518_0"."不锈钢价格-材质/表面" LIKE '50WW1300%' ) ) ) "t32" ) "t33" ON ( "t31"."__fcol_446" = "t33"."__fcol_482" AND "t31"."__fcol_444" = "t33"."__fcol_483" ) ) "t35" ) "t36" LEFT OUTER JOIN ( SELECT cast("t37"."__fcol_598" AS TIMESTAMP) "__fcol_599" ,"t37"."__fcol_595" "__fcol_600" ,"t37"."__fcol_596" "__fcol_601" FROM ( SELECT "T_2FF518_1"."不锈钢价格-材质/表面" "__fcol_595" ,"T_2FF518_1"."不锈钢价格-基价" "__fcol_596" ,( cast(YEAR("T_2FF518_1"."不锈钢价格-日期") AS VARCHAR) || '-' || SUBSTRING(('0' || cast(MONTH("T_2FF518_1"."不锈钢价格-日期") AS VARCHAR)), CASE WHEN 1 > ((char_length(('0' || cast(MONTH("T_2FF518_1"."不锈钢价格-日期") AS VARCHAR))) + 1) - 2) THEN 1 ELSE ((char_length(('0' || cast(MONTH("T_2FF518_1"."不锈钢价格-日期") AS VARCHAR))) + 1) - 2) END) ) "__fcol_598" FROM ( SELECT field1 "不锈钢价格-日期" ,field2 "不锈钢价格-地区" ,field3 "不锈钢价格-材质/表面" ,field4 "不锈钢价格-品种" ,field5 "不锈钢价格-产地" ,field6 "不锈钢价格-基价" ,field7 "原料价格-日期" ,field8 "原料价格-镍铁价格" ,field9 "原料价格-铬铁价格" ,field10 "原料价格-地区" ,field11 "无锡周库存（单位：万吨）-日期" ,field12 "无锡周库存（单位：万吨）-200系" ,field13 "无锡周库存（单位：万吨）-300系" ,field14 "无锡周库存（单位：万吨）-400系" ,field15 "无锡周库存（单位：万吨）-总量" ,field16 "佛山周库存（单位：万吨）-日期" ,field17 "佛山周库存（单位：万吨）-200系" ,field18 "佛山周库存（单位：万吨）-300系" ,field19 "佛山周库存（单位：万吨）-400系" ,field20 "佛山周库存（单位：万吨）-总量" FROM ods_finebi.t_bi_t_069181 ) "T_2FF518_1" WHERE ( "T_2FF518_1"."不锈钢价格-地区" IN ('无锡') AND ( "T_2FF518_1"."不锈钢价格-材质/表面" LIKE 'BN4%' OR "T_2FF518_1"."不锈钢价格-材质/表面" LIKE 'SPHC%' OR "T_2FF518_1"."不锈钢价格-材质/表面" LIKE '304L%' OR "T_2FF518_1"."不锈钢价格-材质/表面" LIKE 'DC51D+Z%' OR "T_2FF518_1"."不锈钢价格-材质/表面" LIKE 'SECCN5%' OR "T_2FF518_1"."不锈钢价格-材质/表面" LIKE '50WW1300%' ) ) ) "t37" ) "t38" ON ( "t36"."__fcol_563" = "t38"."__fcol_599" AND "t36"."__fcol_558" = "t38"."__fcol_600" ) ) "t40" ) "t41" LEFT OUTER JOIN ( SELECT "t42"."__fcol_712" "__fcol_719" ,"t42"."__fcol_714" "__fcol_720" ,CASE WHEN 5 = 0 THEN cast(NULL AS DOUBLE) ELSE (cast("t42"."__fcol_718" AS DOUBLE) / 5) END "__fcol_721" FROM ( SELECT "T_2FF518_2"."不锈钢价格-材质/表面" "__fcol_712" ,( cast(YEAR("T_2FF518_2"."不锈钢价格-日期") AS VARCHAR) || '-' || SUBSTRING(('0' || cast(MONTH("T_2FF518_2"."不锈钢价格-日期") AS VARCHAR)), CASE WHEN 1 > ((char_length(('0' || cast(MONTH("T_2FF518_2"."不锈钢价格-日期") AS VARCHAR))) + 1) - 2) THEN 1 ELSE ((char_length(('0' || cast(MONTH("T_2FF518_2"."不锈钢价格-日期") AS VARCHAR))) + 1) - 2) END) ) "__fcol_714" ,sum(CASE WHEN CASE WHEN ( "T_2FF518_2"."不锈钢价格-日期" >= TIMESTAMPADD(DAY, cast((0 - 5) AS INTEGER), cast((cast(YEAR("T_2FF518_2"."不锈钢价格-日期") AS VARCHAR) || '-' || cast((MONTH("T_2FF518_2"."不锈钢价格-日期") + 1) AS VARCHAR) || '-' || cast(1 AS VARCHAR)) AS DATE)) AND "T_2FF518_2"."不锈钢价格-日期" <= TIMESTAMPADD(DAY, cast((0 - 1) AS INTEGER), cast((cast(YEAR("T_2FF518_2"."不锈钢价格-日期") AS VARCHAR) || '-' || cast((MONTH("T_2FF518_2"."不锈钢价格-日期") + 1) AS VARCHAR) || '-' || cast(1 AS VARCHAR)) AS DATE)) ) THEN 1 WHEN NOT ( ( "T_2FF518_2"."不锈钢价格-日期" >= TIMESTAMPADD(DAY, cast((0 - 5) AS INTEGER), cast((cast(YEAR("T_2FF518_2"."不锈钢价格-日期") AS VARCHAR) || '-' || cast((MONTH("T_2FF518_2"."不锈钢价格-日期") + 1) AS VARCHAR) || '-' || cast(1 AS VARCHAR)) AS DATE)) AND "T_2FF518_2"."不锈钢价格-日期" <= TIMESTAMPADD(DAY, cast((0 - 1) AS INTEGER), cast((cast(YEAR("T_2FF518_2"."不锈钢价格-日期") AS VARCHAR) || '-' || cast((MONTH("T_2FF518_2"."不锈钢价格-日期") + 1) AS VARCHAR) || '-' || cast(1 AS VARCHAR)) AS DATE)) ) ) THEN 0 ELSE NULL END = 1 THEN "T_2FF518_2"."不锈钢价格-基价" ELSE 0 END) OVER ( PARTITION BY ( cast(YEAR("T_2FF518_2"."不锈钢价格-日期") AS VARCHAR) || '-' || SUBSTRING(('0' || cast(MONTH("T_2FF518_2"."不锈钢价格-日期") AS VARCHAR)), CASE WHEN 1 > ((char_length(('0' || cast(MONTH("T_2FF518_2"."不锈钢价格-日期") AS VARCHAR))) + 1) - 2) THEN 1 ELSE ((char_length(('0' || cast(MONTH("T_2FF518_2"."不锈钢价格-日期") AS VARCHAR))) + 1) - 2) END) ) ,"T_2FF518_2"."不锈钢价格-材质/表面" ) "__fcol_718" FROM ( SELECT field1 "不锈钢价格-日期" ,field2 "不锈钢价格-地区" ,field3 "不锈钢价格-材质/表面" ,field4 "不锈钢价格-品种" ,field5 "不锈钢价格-产地" ,field6 "不锈钢价格-基价" ,field7 "原料价格-日期" ,field8 "原料价格-镍铁价格" ,field9 "原料价格-铬铁价格" ,field10 "原料价格-地区" ,field11 "无锡周库存（单位：万吨）-日期" ,field12 "无锡周库存（单位：万吨）-200系" ,field13 "无锡周库存（单位：万吨）-300系" ,field14 "无锡周库存（单位：万吨）-400系" ,field15 "无锡周库存（单位：万吨）-总量" ,field16 "佛山周库存（单位：万吨）-日期" ,field17 "佛山周库存（单位：万吨）-200系" ,field18 "佛山周库存（单位：万吨）-300系" ,field19 "佛山周库存（单位：万吨）-400系" ,field20 "佛山周库存（单位：万吨）-总量" FROM ods_finebi.t_bi_t_069181 ) "T_2FF518_2" WHERE ( "T_2FF518_2"."不锈钢价格-地区" IN ('无锡') AND ( "T_2FF518_2"."不锈钢价格-材质/表面" IN ( '304/No.1' ,'304/2B' ,'201J2/2B' ,'430/2B' ,'201J1/No.1' ,'430/No.1' ) OR "T_2FF518_2"."不锈钢价格-材质/表面" LIKE 'SUH409L/2B%' OR "T_2FF518_2"."不锈钢价格-材质/表面" LIKE 'SUH409L/No.1%' ) ) ) "t42" ) "t43" ON ( "t41"."__fcol_711" = "t43"."__fcol_720" AND "t41"."__fcol_677" = "t43"."__fcol_719" ) limit 5000