10 12 04 回sh

今天又在hf待了一天,等到他们的人下班了才离开,发现做这行不简单,有很多的芯片代理也同时做板卡,能活下来是不错的了。傍晚买票搞错了,结果买了张早上车但晚到的票。

 

读在今天:把书读完了,没什么收获。

想在今天:这行业生存下来不容易,都是被夹在中间的。

--select count(loadkey),loadkey from orders(nolock) where storerkey='rituals' and loadkey<>'' and doctype='E' group by loadkey SELECT a.sku, a.ExtendedField01 AS descr, a.qty, a.loadkey, a.orderkey, a.externorderkey, a.lottable02 AS N'批号', a.lottable04 AS N'有效期', a.RN, a.RN2, a.RN3, a.deviceposition, a.loc, a.zone_code, CASE WHEN a.zone_number % 2 = 1 THEN CAST(a.row_code AS INT) ELSE -CAST(a.row_code AS INT) END, a.position_num, a.pickslipno, a.print_date, a.qty_pickslipno, a.sku_number, a.locaisle, a.orderkey_number, a.page_number, a.qty_orderkey, a.case_number, a.LoadLineNumber, a.ShipperKey, a.Lottable03 AS N'库区' FROM ( SELECT AL2.Sku, AL10.ExtendedField01, SUM(AL5.Qty) Qty, AL1.LoadKey, AL1.OrderKey, AL1.ExternOrderKey, AL6.Lottable02, AL6.Lottable04, AL7.Loc, AL8.LoadLineNumber, AL5.PickSlipNo, GETDATE() print_date, SUM(SUM(AL5.Qty)) OVER (PARTITION BY AL5.pickslipno) qty_pickslipno, pp.sku_number, AL7.LocAisle, pp.orderkey_number, SUBSTRING(AL8.LoadLineNumber, 4, 2) page_number, SUM(SUM(AL5.Qty)) OVER (PARTITION BY AL1.OrderKey) qty_orderkey, AL9.DevicePosition, DENSE_RANK() OVER (PARTITION BY AL5.PickSlipNo ORDER BY AL9.DevicePosition,AL1.ExternOrderKey) case_number, AL1.ShipperKey, AL6.Lottable03, -- 提取库位三部分用于排序 LEFT(AL7.Loc, CHARINDEX('-', AL7.Loc) - 1) AS zone_code, CAST(SUBSTRING(AL7.Loc, 3, 2) AS INT) AS zone_number, SUBSTRING(AL7.Loc, CHARINDEX('-', AL7.Loc) + 1, CHARINDEX('-', AL7.Loc, CHARINDEX('-', AL7.Loc) + 1) - CHARINDEX('-', AL7.Loc) - 1) AS row_code, CAST(RIGHT(AL7.Loc, LEN(AL7.Loc) - CHARINDEX('-', AL7.Loc, CHARINDEX('-', AL7.Loc) + 1)) AS INT) AS position_num, ROW_NUMBER() OVER (PARTITION BY AL5.PICKSLIPNO, AL5.LOC, AL5.SKU ORDER BY AL5.PICKSLIPNO, AL5.SKU, AL9.DevicePosition) RN, -- 修改RN2计算逻辑,按照库位排序顺序进行分区排序 CEILING(CAST(ROW_NUMBER() OVER ( PARTITION BY AL5.PICKSLIPNO ORDER BY LEFT(AL7.Loc, CHARINDEX('-', AL7.Loc) - 1), CASE WHEN CAST(SUBSTRING(AL7.Loc, 3, 2) AS INT) % 2 = 1 THEN CAST(SUBSTRING(AL7.Loc, CHARINDEX('-', AL7.Loc) + 1, CHARINDEX('-', AL7.Loc, CHARINDEX('-', AL7.Loc) + 1) - CHARINDEX('-', AL7.Loc) - 1) AS INT) ELSE -CAST(SUBSTRING(AL7.Loc, CHARINDEX('-', AL7.Loc) + 1, CHARINDEX('-', AL7.Loc, CHARINDEX('-', AL7.Loc) + 1) - CHARINDEX('-', AL7.Loc) - 1) AS INT) END, CAST(RIGHT(AL7.Loc, LEN(AL7.Loc) - CHARINDEX('-', AL7.Loc, CHARINDEX('-', AL7.Loc) + 1)) AS INT) ) AS FLOAT) / 28) RN2, CEILING(CAST(COUNT(1) OVER (PARTITION BY AL5.PICKSLIPNO) AS FLOAT) / 28) RN3 FROM BI.V_ORDERS(NOLOCK) AL1 INNER JOIN BI.V_ORDERDETAIL(NOLOCK) AL2 ON AL1.OrderKey = AL2.OrderKey AND AL1.StorerKey = AL2.StorerKey INNER JOIN BI.V_SKU(NOLOCK) AL3 ON AL2.StorerKey = AL3.StorerKey AND AL2.Sku = AL3.Sku INNER JOIN BI.V_PACK(NOLOCK) AL4 ON AL3.PACKKey = AL4.PackKey INNER JOIN BI.V_PICKDETAIL(NOLOCK) AL5 ON AL5.OrderKey = AL2.OrderKey AND AL5.OrderLineNumber = AL2.OrderLineNumber AND AL5.Storerkey = AL2.StorerKey AND AL5.Sku = AL2.Sku INNER JOIN BI.V_LOTATTRIBUTE(NOLOCK) AL6 ON AL5.Sku = AL6.Sku AND AL5.Lot = AL6.Lot AND AL5.Storerkey = AL6.StorerKey INNER JOIN BI.V_LOC(NOLOCK) AL7 ON AL5.Loc = AL7.Loc INNER JOIN BI.V_LoadPlanDetail(NOLOCK) AL8 ON AL2.OrderKey = AL8.OrderKey INNER JOIN BI.V_PackTask(NOLOCK) AL9 ON AL9.Orderkey = AL1.OrderKey INNER JOIN BI.V_SkuInfo(NOLOCK) AL10 ON AL3.SKU = AL10.SKU AND AL3.StorerKey = AL10.Storerkey INNER JOIN ( SELECT p.pickslipno, COUNT(DISTINCT p.sku) sku_number, COUNT(DISTINCT p.orderkey) orderkey_number FROM BI.V_PickDetail(NOLOCK) p WHERE p.storerkey = 'Rituals' GROUP BY p.pickslipno ) pp ON AL5.pickslipno = pp.pickslipno WHERE AL1.StorerKey = 'Rituals' AND AL1.LoadKey in ('0015585602') --:FX_Rituals_Loadkey GROUP BY AL2.Sku, AL10.ExtendedField01, AL1.LoadKey, AL1.OrderKey, AL1.ExternOrderKey, AL6.Lottable02, AL6.Lottable04, AL7.Loc, AL8.LoadLineNumber, AL5.PickSlipNo, pp.sku_number, AL7.LocAisle, pp.orderkey_number, AL9.DevicePosition, AL1.ShipperKey, AL6.Lottable03, AL5.LOC, AL5.SKU ) a ORDER BY a.PickSlipNo asc, A.RN2 asc, a.zone_code asc, CASE WHEN a.zone_number % 2 = 1 THEN CAST(a.row_code AS INT) ELSE -CAST(a.row_code AS INT) END asc, a.position_num asc, a.rn asc --a.DevicePosition asc --a.ExternOrderKey; 结果 sku descr qty loadkey orderkey externorderkey 批号 有效期 RN RN2 RN3 deviceposition loc zone_code (No column name) position_num pickslipno print_date qty_pickslipno sku_number locaisle orderkey_number page_number qty_orderkey case_number LoadLineNumber ShipperKey 库区 1115335 RITUALS怡式樱花仪式沐浴油 1 0015585602 0288199364 SH2025092300000493 270602 2027-06-01 00:00:00.000 1 1 2 17 2C01-016-3 2C01 16 3 B008626029 2025-09-24 10:04:40.017 37 6 031 18 18 2 17 00018 ZTO A 1118506 RITUALS赋能车载香氛 1 0015585602 0288183177 SH2025092300000408 98782 2027-07-01 00:00:00.000 1 1 2 04 2C01-040-3 2C01 40 3 B008626029 2025-09-24 10:04:40.017 37 6 079 18 05 2 4 00005 ZTO A 1118506 RITUALS赋能车载香氛 1 0015585602 0288197200 SH2025092300000477 98782 2027-07-01 00:00:00.000 2 1 2 14 2C01-040-3 2C01 40 3 B008626029 2025-09-24 10:04:40.017 37 6 079 18 15 2 14 00015 ZTO A 1115064 2 0015585602 0288183174 SH2025092300000410 6758 2027-07-01 00:00:00.000 1 1 2 02 2C01-044-2 2C01 44 2 B008626029 2025-09-24 10:04:40.017 37 6 086 18 03 3 2 00003 ZTO A 1115064 2 0015585602 0288189469 SH2025092300000435 6758 2027-07-01 00:00:00.000 2 1 2 08 2C01-044-2 2C01 44 2 B008626029 2025-09-24 10:04:40.017 37 6 086 18 09 2 8 00009 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288181998 SH2025092300000397 NO-LOT 2030-12-31 00:00:00.000 1 1 2 01 2C02-042-3 2C02 -42 3 B008626029 2025-09-24 10:04:40.017 37 6 98 18 02 2 1 00002 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288183174 SH2025092300000410 NO-LOT 2030-12-31 00:00:00.000 2 1 2 02 2C02-042-3 2C02 -42 3 B008626029 2025-09-24 10:04:40.017 37 6 98 18 03 3 2 00003 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288183176 SH2025092300000411 NO-LOT 2030-12-31 00:00:00.000 3 1 2 03 2C02-042-3 2C02 -42 3 B008626029 2025-09-24 10:04:40.017 37 6 98 18 04 2 3 00004 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288183177 SH2025092300000408 NO-LOT 2030-12-31 00:00:00.000 4 1 2 04 2C02-042-3 2C02 -42 3 B008626029 2025-09-24 10:04:40.017 37 6 98 18 05 2 4 00005 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288184970 SH2025092300000418 NO-LOT 2030-12-31 00:00:00.000 5 1 2 05 2C02-042-3 2C02 -42 3 B008626029 2025-09-24 10:04:40.017 37 6 98 18 06 2 5 00006 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288188469 SH2025092300000442 NO-LOT 2030-12-31 00:00:00.000 6 1 2 06 2C02-042-3 2C02 -42 3 B008626029 2025-09-24 10:04:40.017 37 6 98 18 07 2 6 00007 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288189079 SH2025092300000444 NO-LOT 2030-12-31 00:00:00.000 7 1 2 07 2C02-042-3 2C02 -42 3 B008626029 2025-09-24 10:04:40.017 37 6 98 18 08 2 7 00008 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288189876 SH2025092300000453 NO-LOT 2030-12-31 00:00:00.000 8 1 2 09 2C02-042-3 2C02 -42 3 B008626029 2025-09-24 10:04:40.017 37 6 98 18 10 2 9 00010 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288191727 SH2025092300000459 NO-LOT 2030-12-31 00:00:00.000 9 1 2 10 2C02-042-3 2C02 -42 3 B008626029 2025-09-24 10:04:40.017 37 6 98 18 11 2 10 00011 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288192724 SH2025092300000467 NO-LOT 2030-12-31 00:00:00.000 10 1 2 11 2C02-042-3 2C02 -42 3 B008626029 2025-09-24 10:04:40.017 37 6 98 18 12 2 11 00012 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288193671 SH2025092300000468 NO-LOT 2030-12-31 00:00:00.000 11 1 2 12 2C02-042-3 2C02 -42 3 B008626029 2025-09-24 10:04:40.017 37 6 98 18 13 2 12 00013 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288194441 SH2025092300000472 NO-LOT 2030-12-31 00:00:00.000 12 1 2 13 2C02-042-3 2C02 -42 3 B008626029 2025-09-24 10:04:40.017 37 6 98 18 14 2 13 00014 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288197200 SH2025092300000477 NO-LOT 2030-12-31 00:00:00.000 13 1 2 14 2C02-042-3 2C02 -42 3 B008626029 2025-09-24 10:04:40.017 37 6 98 18 15 2 14 00015 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288199071 SH2025092300000490 NO-LOT 2030-12-31 00:00:00.000 14 1 2 15 2C02-042-3 2C02 -42 3 B008626029 2025-09-24 10:04:40.017 37 6 98 18 16 2 15 00016 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288199363 SH2025092300000494 NO-LOT 2030-12-31 00:00:00.000 15 1 2 16 2C02-042-3 2C02 -42 3 B008626029 2025-09-24 10:04:40.017 37 6 98 18 17 2 16 00017 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288199364 SH2025092300000493 NO-LOT 2030-12-31 00:00:00.000 16 1 2 17 2C02-042-3 2C02 -42 3 B008626029 2025-09-24 10:04:40.017 37 6 98 18 18 2 17 00018 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288199540 SH2025092300000499 NO-LOT 2030-12-31 00:00:00.000 17 1 2 18 2C02-042-3 2C02 -42 3 B008626029 2025-09-24 10:04:40.017 37 6 98 18 19 2 18 00019 ZTO A 1118509 RITUALS琥珀麝香车载香氛补充装 1 0015585602 0288183176 SH2025092300000411 82860 2027-03-01 00:00:00.000 1 1 2 03 2C02-011-1 2C02 -11 1 B008626029 2025-09-24 10:04:40.017 37 6 224 18 04 2 3 00004 ZTO A 1118509 RITUALS琥珀麝香车载香氛补充装 1 0015585602 0288194441 SH2025092300000472 82860 2027-03-01 00:00:00.000 2 1 2 13 2C02-011-1 2C02 -11 1 B008626029 2025-09-24 10:04:40.017 37 6 224 18 14 2 13 00014 ZTO A 1118505 RITUALS琥珀麝香车载香氛 1 0015585602 0288193671 SH2025092300000468 87371 2028-01-01 00:00:00.000 8 1 2 12 2C02-008-3 2C02 -8 3 B008626029 2025-09-24 10:04:40.017 37 6 234 18 13 2 12 00013 ZTO A 1118505 RITUALS琥珀麝香车载香氛 1 0015585602 0288199071 SH2025092300000490 87371 2028-01-01 00:00:00.000 9 1 2 15 2C02-008-3 2C02 -8 3 B008626029 2025-09-24 10:04:40.017 37 6 234 18 16 2 15 00016 ZTO A 1118505 RITUALS琥珀麝香车载香氛 1 0015585602 0288199363 SH2025092300000494 87371 2028-01-01 00:00:00.000 10 1 2 16 2C02-008-3 2C02 -8 3 B008626029 2025-09-24 10:04:40.017 37 6 234 18 17 2 16 00017 ZTO A 1118505 RITUALS琥珀麝香车载香氛 1 0015585602 0288199540 SH2025092300000499 87371 2028-01-01 00:00:00.000 11 1 2 18 2C02-008-3 2C02 -8 3 B008626029 2025-09-24 10:04:40.017 37 6 234 18 19 2 18 00019 ZTO A 1118505 RITUALS琥珀麝香车载香氛 1 0015585602 0288181998 SH2025092300000397 87371 2028-01-01 00:00:00.000 1 2 2 01 2C02-008-3 2C02 -8 3 B008626029 2025-09-24 10:04:40.017 37 6 234 18 02 2 1 00002 ZTO A 1118505 RITUALS琥珀麝香车载香氛 1 0015585602 0288184970 SH2025092300000418 87371 2028-01-01 00:00:00.000 2 2 2 05 2C02-008-3 2C02 -8 3 B008626029 2025-09-24 10:04:40.017 37 6 234 18 06 2 5 00006 ZTO A 1118505 RITUALS琥珀麝香车载香氛 1 0015585602 0288188469 SH2025092300000442 87371 2028-01-01 00:00:00.000 3 2 2 06 2C02-008-3 2C02 -8 3 B008626029 2025-09-24 10:04:40.017 37 6 234 18 07 2 6 00007 ZTO A 1118505 RITUALS琥珀麝香车载香氛 1 0015585602 0288189079 SH2025092300000444 87371 2028-01-01 00:00:00.000 4 2 2 07 2C02-008-3 2C02 -8 3 B008626029 2025-09-24 10:04:40.017 37 6 234 18 08 2 7 00008 ZTO A 1118505 RITUALS琥珀麝香车载香氛 1 0015585602 0288189876 SH2025092300000453 87371 2028-01-01 00:00:00.000 5 2 2 09 2C02-008-3 2C02 -8 3 B008626029 2025-09-24 10:04:40.017 37 6 234 18 10 2 9 00010 ZTO A 1118505 RITUALS琥珀麝香车载香氛 1 0015585602 0288191727 SH2025092300000459 87371 2028-01-01 00:00:00.000 6 2 2 10 2C02-008-3 2C02 -8 3 B008626029 2025-09-24 10:04:40.017 37 6 234 18 11 2 10 00011 ZTO A 1118505 RITUALS琥珀麝香车载香氛 1 0015585602 0288192724 SH2025092300000467 87371 2028-01-01 00:00:00.000 7 2 2 11 2C02-008-3 2C02 -8 3 B008626029 2025-09-24 10:04:40.017 37 6 234 18 12 2 11 00012 ZTO A 1114332 RITUALS樱花仪式护手霜 1 0015585602 0288217132 SH2025092300000560 3394 2027-07-01 00:00:00.000 1 1 2 18 2C01-016-4 2C01 16 4 B008626030 2025-09-24 10:04:40.017 36 5 032 18 37 2 18 00037 ZTO A 1118506 RITUALS赋能车载香氛 1 0015585602 0288202383 SH2025092300000517 98782 2027-07-01 00:00:00.000 1 1 2 03 2C01-040-3 2C01 40 3 B008626030 2025-09-24 10:04:40.017 36 5 079 18 22 2 3 00022 ZTO A 1118506 RITUALS赋能车载香氛 1 0015585602 0288209026 SH2025092300000552 98782 2027-07-01 00:00:00.000 2 1 2 11 2C01-040-3 2C01 40 3 B008626030 2025-09-24 10:04:40.017 36 5 079 18 30 2 11 00030 ZTO A 1118506 RITUALS赋能车载香氛 1 0015585602 0288209855 SH2025092300000557 98782 2027-07-01 00:00:00.000 3 1 2 14 2C01-040-3 2C01 40 3 B008626030 2025-09-24 10:04:40.017 36 5 079 18 33 2 14 00033 ZTO A 1115064 2 0015585602 0288204781 SH2025092300000521 6758 2027-07-01 00:00:00.000 1 1 2 06 2C01-044-2 2C01 44 2 B008626030 2025-09-24 10:04:40.017 36 5 086 18 25 2 6 00025 ZTO A 1115064 2 0015585602 0288216935 SH2025092300000555 6758 2027-07-01 00:00:00.000 2 1 2 15 2C01-044-2 2C01 44 2 B008626030 2025-09-24 10:04:40.017 36 5 086 18 34 2 15 00034 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288200207 SH2025092300000502 NO-LOT 2030-12-31 00:00:00.000 1 1 2 01 2C02-042-3 2C02 -42 3 B008626030 2025-09-24 10:04:40.017 36 5 98 18 20 2 1 00020 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288200208 SH2025092300000503 NO-LOT 2030-12-31 00:00:00.000 2 1 2 02 2C02-042-3 2C02 -42 3 B008626030 2025-09-24 10:04:40.017 36 5 98 18 21 2 2 00021 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288202383 SH2025092300000517 NO-LOT 2030-12-31 00:00:00.000 3 1 2 03 2C02-042-3 2C02 -42 3 B008626030 2025-09-24 10:04:40.017 36 5 98 18 22 2 3 00022 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288203341 SH2025092300000528 NO-LOT 2030-12-31 00:00:00.000 4 1 2 04 2C02-042-3 2C02 -42 3 B008626030 2025-09-24 10:04:40.017 36 5 98 18 23 2 4 00023 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288203342 SH2025092300000527 NO-LOT 2030-12-31 00:00:00.000 5 1 2 05 2C02-042-3 2C02 -42 3 B008626030 2025-09-24 10:04:40.017 36 5 98 18 24 2 5 00024 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288204783 SH2025092300000532 NO-LOT 2030-12-31 00:00:00.000 6 1 2 07 2C02-042-3 2C02 -42 3 B008626030 2025-09-24 10:04:40.017 36 5 98 18 26 2 7 00026 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288206272 SH2025092300000541 NO-LOT 2030-12-31 00:00:00.000 7 1 2 08 2C02-042-3 2C02 -42 3 B008626030 2025-09-24 10:04:40.017 36 5 98 18 27 2 8 00027 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288206629 SH2025092300000543 NO-LOT 2030-12-31 00:00:00.000 8 1 2 09 2C02-042-3 2C02 -42 3 B008626030 2025-09-24 10:04:40.017 36 5 98 18 28 2 9 00028 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288208536 SH2025092300000551 NO-LOT 2030-12-31 00:00:00.000 9 1 2 10 2C02-042-3 2C02 -42 3 B008626030 2025-09-24 10:04:40.017 36 5 98 18 29 2 10 00029 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288209026 SH2025092300000552 NO-LOT 2030-12-31 00:00:00.000 10 1 2 11 2C02-042-3 2C02 -42 3 B008626030 2025-09-24 10:04:40.017 36 5 98 18 30 2 11 00030 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288209405 SH2025092300000554 NO-LOT 2030-12-31 00:00:00.000 11 1 2 12 2C02-042-3 2C02 -42 3 B008626030 2025-09-24 10:04:40.017 36 5 98 18 31 2 12 00031 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288209406 SH2025092300000553 NO-LOT 2030-12-31 00:00:00.000 12 1 2 13 2C02-042-3 2C02 -42 3 B008626030 2025-09-24 10:04:40.017 36 5 98 18 32 2 13 00032 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288209855 SH2025092300000557 NO-LOT 2030-12-31 00:00:00.000 13 1 2 14 2C02-042-3 2C02 -42 3 B008626030 2025-09-24 10:04:40.017 36 5 98 18 33 2 14 00033 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288217130 SH2025092300000562 NO-LOT 2030-12-31 00:00:00.000 14 1 2 16 2C02-042-3 2C02 -42 3 B008626030 2025-09-24 10:04:40.017 36 5 98 18 35 2 16 00035 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288217131 SH2025092300000565 NO-LOT 2030-12-31 00:00:00.000 15 1 2 17 2C02-042-3 2C02 -42 3 B008626030 2025-09-24 10:04:40.017 36 5 98 18 36 2 17 00036 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288217132 SH2025092300000560 NO-LOT 2030-12-31 00:00:00.000 16 1 2 18 2C02-042-3 2C02 -42 3 B008626030 2025-09-24 10:04:40.017 36 5 98 18 37 2 18 00037 ZTO A 1118505 RITUALS琥珀麝香车载香氛 1 0015585602 0288206629 SH2025092300000543 87371 2028-01-01 00:00:00.000 7 1 2 09 2C02-008-3 2C02 -8 3 B008626030 2025-09-24 10:04:40.017 36 5 234 18 28 2 9 00028 ZTO A 1118505 RITUALS琥珀麝香车载香氛 1 0015585602 0288208536 SH2025092300000551 87371 2028-01-01 00:00:00.000 8 1 2 10 2C02-008-3 2C02 -8 3 B008626030 2025-09-24 10:04:40.017 36 5 234 18 29 2 10 00029 ZTO A 1118505 RITUALS琥珀麝香车载香氛 1 0015585602 0288209405 SH2025092300000554 87371 2028-01-01 00:00:00.000 9 1 2 12 2C02-008-3 2C02 -8 3 B008626030 2025-09-24 10:04:40.017 36 5 234 18 31 2 12 00031 ZTO A 1118505 RITUALS琥珀麝香车载香氛 1 0015585602 0288209406 SH2025092300000553 87371 2028-01-01 00:00:00.000 10 1 2 13 2C02-008-3 2C02 -8 3 B008626030 2025-09-24 10:04:40.017 36 5 234 18 32 2 13 00032 ZTO A 1118505 RITUALS琥珀麝香车载香氛 1 0015585602 0288217130 SH2025092300000562 87371 2028-01-01 00:00:00.000 11 1 2 16 2C02-008-3 2C02 -8 3 B008626030 2025-09-24 10:04:40.017 36 5 234 18 35 2 16 00035 ZTO A 1118505 RITUALS琥珀麝香车载香氛 1 0015585602 0288217131 SH2025092300000565 87371 2028-01-01 00:00:00.000 12 1 2 17 2C02-008-3 2C02 -8 3 B008626030 2025-09-24 10:04:40.017 36 5 234 18 36 2 17 00036 ZTO A 1118505 RITUALS琥珀麝香车载香氛 1 0015585602 0288200207 SH2025092300000502 87371 2028-01-01 00:00:00.000 1 2 2 01 2C02-008-3 2C02 -8 3 B008626030 2025-09-24 10:04:40.017 36 5 234 18 20 2 1 00020 ZTO A 1118505 RITUALS琥珀麝香车载香氛 1 0015585602 0288200208 SH2025092300000503 87371 2028-01-01 00:00:00.000 2 2 2 02 2C02-008-3 2C02 -8 3 B008626030 2025-09-24 10:04:40.017 36 5 234 18 21 2 2 00021 ZTO A 1118505 RITUALS琥珀麝香车载香氛 1 0015585602 0288203341 SH2025092300000528 87371 2028-01-01 00:00:00.000 3 2 2 04 2C02-008-3 2C02 -8 3 B008626030 2025-09-24 10:04:40.017 36 5 234 18 23 2 4 00023 ZTO A 1118505 RITUALS琥珀麝香车载香氛 1 0015585602 0288203342 SH2025092300000527 87371 2028-01-01 00:00:00.000 4 2 2 05 2C02-008-3 2C02 -8 3 B008626030 2025-09-24 10:04:40.017 36 5 234 18 24 2 5 00024 ZTO A 1118505 RITUALS琥珀麝香车载香氛 1 0015585602 0288204783 SH2025092300000532 87371 2028-01-01 00:00:00.000 5 2 2 07 2C02-008-3 2C02 -8 3 B008626030 2025-09-24 10:04:40.017 36 5 234 18 26 2 7 00026 ZTO A 1118505 RITUALS琥珀麝香车载香氛 1 0015585602 0288206272 SH2025092300000541 87371 2028-01-01 00:00:00.000 6 2 2 08 2C02-008-3 2C02 -8 3 B008626030 2025-09-24 10:04:40.017 36 5 234 18 27 2 8 00027 ZTO A 1118506 RITUALS赋能车载香氛 1 0015585602 0288217137 SH2025092300000593 98782 2027-07-01 00:00:00.000 1 1 2 03 2C01-040-3 2C01 40 3 B008626031 2025-09-24 10:04:40.017 36 6 079 18 40 2 3 00040 ZTO A 1116414 RITUALS阿姆斯特丹系列润手乳 1 0015585602 0288218659 SH2025092300000617 11839979 2027-10-01 00:00:00.000 1 1 2 13 2C01-054-4 2C01 54 4 B008626031 2025-09-24 10:04:40.017 36 6 108 18 50 2 13 00050 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288217133 SH2025092300000572 NO-LOT 2030-12-31 00:00:00.000 1 1 2 01 2C02-042-3 2C02 -42 3 B008626031 2025-09-24 10:04:40.017 36 6 98 18 38 2 1 00038 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288217135 SH2025092300000564 NO-LOT 2030-12-31 00:00:00.000 2 1 2 02 2C02-042-3 2C02 -42 3 B008626031 2025-09-24 10:04:40.017 36 6 98 18 39 2 2 00039 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288217137 SH2025092300000593 NO-LOT 2030-12-31 00:00:00.000 3 1 2 03 2C02-042-3 2C02 -42 3 B008626031 2025-09-24 10:04:40.017 36 6 98 18 40 2 3 00040 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288217139 SH2025092300000566 NO-LOT 2030-12-31 00:00:00.000 4 1 2 04 2C02-042-3 2C02 -42 3 B008626031 2025-09-24 10:04:40.017 36 6 98 18 41 2 4 00041 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288217140 SH2025092300000567 NO-LOT 2030-12-31 00:00:00.000 5 1 2 05 2C02-042-3 2C02 -42 3 B008626031 2025-09-24 10:04:40.017 36 6 98 18 42 2 5 00042 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288217141 SH2025092300000573 NO-LOT 2030-12-31 00:00:00.000 6 1 2 06 2C02-042-3 2C02 -42 3 B008626031 2025-09-24 10:04:40.017 36 6 98 18 43 2 6 00043 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288217143 SH2025092300000563 NO-LOT 2030-12-31 00:00:00.000 7 1 2 07 2C02-042-3 2C02 -42 3 B008626031 2025-09-24 10:04:40.017 36 6 98 18 44 2 7 00044 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288217146 SH2025092300000571 NO-LOT 2030-12-31 00:00:00.000 8 1 2 08 2C02-042-3 2C02 -42 3 B008626031 2025-09-24 10:04:40.017 36 6 98 18 45 2 8 00045 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288217148 SH2025092300000575 NO-LOT 2030-12-31 00:00:00.000 9 1 2 09 2C02-042-3 2C02 -42 3 B008626031 2025-09-24 10:04:40.017 36 6 98 18 46 2 9 00046 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288217149 SH2025092300000569 NO-LOT 2030-12-31 00:00:00.000 10 1 2 10 2C02-042-3 2C02 -42 3 B008626031 2025-09-24 10:04:40.017 36 6 98 18 47 2 10 00047 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288217150 SH2025092300000574 NO-LOT 2030-12-31 00:00:00.000 11 1 2 11 2C02-042-3 2C02 -42 3 B008626031 2025-09-24 10:04:40.017 36 6 98 18 48 2 11 00048 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288217151 SH2025092300000568 NO-LOT 2030-12-31 00:00:00.000 12 1 2 12 2C02-042-3 2C02 -42 3 B008626031 2025-09-24 10:04:40.017 36 6 98 18 49 2 12 00049 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288218659 SH2025092300000617 NO-LOT 2030-12-31 00:00:00.000 13 1 2 13 2C02-042-3 2C02 -42 3 B008626031 2025-09-24 10:04:40.017 36 6 98 18 50 2 13 00050 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288219329 SH2025092300000621 NO-LOT 2030-12-31 00:00:00.000 14 1 2 14 2C02-042-3 2C02 -42 3 B008626031 2025-09-24 10:04:40.017 36 6 98 18 51 2 14 00051 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288219330 SH2025092300000619 NO-LOT 2030-12-31 00:00:00.000 15 1 2 15 2C02-042-3 2C02 -42 3 B008626031 2025-09-24 10:04:40.017 36 6 98 18 52 2 15 00052 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288220478 SH2025092300000625 NO-LOT 2030-12-31 00:00:00.000 16 1 2 17 2C02-042-3 2C02 -42 3 B008626031 2025-09-24 10:04:40.017 36 6 98 18 54 2 17 00054 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288220482 SH2025092300000623 NO-LOT 2030-12-31 00:00:00.000 17 1 2 18 2C02-042-3 2C02 -42 3 B008626031 2025-09-24 10:04:40.017 36 6 98 18 55 2 18 00055 ZTO A 1118504 RITUALS予善车载香氛 1 0015585602 0288217139 SH2025092300000566 85805 2027-09-01 00:00:00.000 1 1 2 04 2C02-012-3 2C02 -12 3 B008626031 2025-09-24 10:04:40.017 36 6 218 18 41 2 4 00041 ZTO A 1118509 RITUALS琥珀麝香车载香氛补充装 1 0015585602 0288217135 SH2025092300000564 82860 2027-03-01 00:00:00.000 1 1 2 02 2C02-011-1 2C02 -11 1 B008626031 2025-09-24 10:04:40.017 36 6 224 18 39 2 2 00039 ZTO A 1118509 RITUALS琥珀麝香车载香氛补充装 1 0015585602 0288219330 SH2025092300000619 82860 2027-03-01 00:00:00.000 2 1 2 15 2C02-011-1 2C02 -11 1 B008626031 2025-09-24 10:04:40.017 36 6 224 18 52 2 15 00052 ZTO A 1118505 RITUALS琥珀麝香车载香氛 1 0015585602 0288217150 SH2025092300000574 87371 2028-01-01 00:00:00.000 8 1 2 11 2C02-008-3 2C02 -8 3 B008626031 2025-09-24 10:04:40.017 36 6 234 18 48 2 11 00048 ZTO A 1118505 RITUALS琥珀麝香车载香氛 1 0015585602 0288217151 SH2025092300000568 87371 2028-01-01 00:00:00.000 9 1 2 12 2C02-008-3 2C02 -8 3 B008626031 2025-09-24 10:04:40.017 36 6 234 18 49 2 12 00049 ZTO A 1118505 RITUALS琥珀麝香车载香氛 1 0015585602 0288219329 SH2025092300000621 87371 2028-01-01 00:00:00.000 10 1 2 14 2C02-008-3 2C02 -8 3 B008626031 2025-09-24 10:04:40.017 36 6 234 18 51 2 14 00051 ZTO A 1118505 RITUALS琥珀麝香车载香氛 2 0015585602 0288220287 SH2025092300000583 87371 2028-01-01 00:00:00.000 11 1 2 16 2C02-008-3 2C02 -8 3 B008626031 2025-09-24 10:04:40.017 36 6 234 18 53 2 16 00053 ZTO A 1118505 RITUALS琥珀麝香车载香氛 1 0015585602 0288220478 SH2025092300000625 87371 2028-01-01 00:00:00.000 12 1 2 17 2C02-008-3 2C02 -8 3 B008626031 2025-09-24 10:04:40.017 36 6 234 18 54 2 17 00054 ZTO A 1118505 RITUALS琥珀麝香车载香氛 1 0015585602 0288220482 SH2025092300000623 87371 2028-01-01 00:00:00.000 13 1 2 18 2C02-008-3 2C02 -8 3 B008626031 2025-09-24 10:04:40.017 36 6 234 18 55 2 18 00055 ZTO A 1118505 RITUALS琥珀麝香车载香氛 1 0015585602 0288217133 SH2025092300000572 87371 2028-01-01 00:00:00.000 1 2 2 01 2C02-008-3 2C02 -8 3 B008626031 2025-09-24 10:04:40.017 36 6 234 18 38 2 1 00038 ZTO A 1118505 RITUALS琥珀麝香车载香氛 1 0015585602 0288217140 SH2025092300000567 87371 2028-01-01 00:00:00.000 2 2 2 05 2C02-008-3 2C02 -8 3 B008626031 2025-09-24 10:04:40.017 36 6 234 18 42 2 5 00042 ZTO A 1118505 RITUALS琥珀麝香车载香氛 1 0015585602 0288217141 SH2025092300000573 87371 2028-01-01 00:00:00.000 3 2 2 06 2C02-008-3 2C02 -8 3 B008626031 2025-09-24 10:04:40.017 36 6 234 18 43 2 6 00043 ZTO A 1118505 RITUALS琥珀麝香车载香氛 1 0015585602 0288217143 SH2025092300000563 87371 2028-01-01 00:00:00.000 4 2 2 07 2C02-008-3 2C02 -8 3 B008626031 2025-09-24 10:04:40.017 36 6 234 18 44 2 7 00044 ZTO A 1118505 RITUALS琥珀麝香车载香氛 1 0015585602 0288217146 SH2025092300000571 87371 2028-01-01 00:00:00.000 5 2 2 08 2C02-008-3 2C02 -8 3 B008626031 2025-09-24 10:04:40.017 36 6 234 18 45 2 8 00045 ZTO A 1118505 RITUALS琥珀麝香车载香氛 1 0015585602 0288217148 SH2025092300000575 87371 2028-01-01 00:00:00.000 6 2 2 09 2C02-008-3 2C02 -8 3 B008626031 2025-09-24 10:04:40.017 36 6 234 18 46 2 9 00046 ZTO A 1118505 RITUALS琥珀麝香车载香氛 1 0015585602 0288217149 SH2025092300000569 87371 2028-01-01 00:00:00.000 7 2 2 10 2C02-008-3 2C02 -8 3 B008626031 2025-09-24 10:04:40.017 36 6 234 18 47 2 10 00047 ZTO A 1116118 RITUALS赋能仪式身体乳 1 0015585602 0288180958 SH2025092300000392 1543336 2027-02-01 00:00:00.000 1 1 1 01 2C01-024-1 2C01 24 1 B008626032 2025-09-24 10:04:40.017 22 6 045 11 01 2 1 00001 ZTO A 1118506 RITUALS赋能车载香氛 1 0015585602 0288224195 SH2025092300000653 98782 2027-07-01 00:00:00.000 1 1 1 11 2C01-040-3 2C01 40 3 B008626032 2025-09-24 10:04:40.017 22 6 079 11 65 2 11 00065 ZTO A 1115064 2 0015585602 0288222204 SH2025092300000622 6758 2027-07-01 00:00:00.000 1 1 1 06 2C01-044-2 2C01 44 2 B008626032 2025-09-24 10:04:40.017 22 6 086 11 60 2 6 00060 ZTO A 1115064 2 0015585602 0288224091 SH2025092300000637 6758 2027-07-01 00:00:00.000 2 1 1 10 2C01-044-2 2C01 44 2 B008626032 2025-09-24 10:04:40.017 22 6 086 11 64 2 10 00064 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288180958 SH2025092300000392 NO-LOT 2030-12-31 00:00:00.000 1 1 1 01 2C02-042-3 2C02 -42 3 B008626032 2025-09-24 10:04:40.017 22 6 98 11 01 2 1 00001 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288221008 SH2025092300000635 NO-LOT 2030-12-31 00:00:00.000 2 1 1 02 2C02-042-3 2C02 -42 3 B008626032 2025-09-24 10:04:40.017 22 6 98 11 56 2 2 00056 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288221009 SH2025092300000636 NO-LOT 2030-12-31 00:00:00.000 3 1 1 03 2C02-042-3 2C02 -42 3 B008626032 2025-09-24 10:04:40.017 22 6 98 11 57 2 3 00057 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288221010 SH2025092300000634 NO-LOT 2030-12-31 00:00:00.000 4 1 1 04 2C02-042-3 2C02 -42 3 B008626032 2025-09-24 10:04:40.017 22 6 98 11 58 2 4 00058 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288222079 SH2025092300000640 NO-LOT 2030-12-31 00:00:00.000 5 1 1 05 2C02-042-3 2C02 -42 3 B008626032 2025-09-24 10:04:40.017 22 6 98 11 59 2 5 00059 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288222718 SH2025092300000648 NO-LOT 2030-12-31 00:00:00.000 6 1 1 07 2C02-042-3 2C02 -42 3 B008626032 2025-09-24 10:04:40.017 22 6 98 11 61 2 7 00061 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288222719 SH2025092300000646 NO-LOT 2030-12-31 00:00:00.000 7 1 1 08 2C02-042-3 2C02 -42 3 B008626032 2025-09-24 10:04:40.017 22 6 98 11 62 2 8 00062 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288223431 SH2025092300000650 NO-LOT 2030-12-31 00:00:00.000 8 1 1 09 2C02-042-3 2C02 -42 3 B008626032 2025-09-24 10:04:40.017 22 6 98 11 63 2 9 00063 ZTO A MKT250627005 综合闻香卡-经典系列 1 0015585602 0288224195 SH2025092300000653 NO-LOT 2030-12-31 00:00:00.000 9 1 1 11 2C02-042-3 2C02 -42 3 B008626032 2025-09-24 10:04:40.017 22 6 98 11 65 2 11 00065 ZTO A 1118509 RITUALS琥珀麝香车载香氛补充装 1 0015585602 0288221009 SH2025092300000636 82860 2027-03-01 00:00:00.000 1 1 1 03 2C02-011-1 2C02 -11 1 B008626032 2025-09-24 10:04:40.017 22 6 224 11 57 2 3 00057 ZTO A 1118505 RITUALS琥珀麝香车载香氛 1 0015585602 0288221008 SH2025092300000635 87371 2028-01-01 00:00:00.000 1 1 1 02 2C02-008-3 2C02 -8 3 B008626032 2025-09-24 10:04:40.017 22 6 234 11 56 2 2 00056 ZTO A 1118505 RITUALS琥珀麝香车载香氛 1 0015585602 0288221010 SH2025092300000634 87371 2028-01-01 00:00:00.000 2 1 1 04 2C02-008-3 2C02 -8 3 B008626032 2025-09-24 10:04:40.017 22 6 234 11 58 2 4 00058 ZTO A 1118505 RITUALS琥珀麝香车载香氛 1 0015585602 0288222079 SH2025092300000640 87371 2028-01-01 00:00:00.000 3 1 1 05 2C02-008-3 2C02 -8 3 B008626032 2025-09-24 10:04:40.017 22 6 234 11 59 2 5 00059 ZTO A 1118505 RITUALS琥珀麝香车载香氛 1 0015585602 0288222718 SH2025092300000648 87371 2028-01-01 00:00:00.000 4 1 1 07 2C02-008-3 2C02 -8 3 B008626032 2025-09-24 10:04:40.017 22 6 234 11 61 2 7 00061 ZTO A 1118505 RITUALS琥珀麝香车载香氛 1 0015585602 0288222719 SH2025092300000646 87371 2028-01-01 00:00:00.000 5 1 1 08 2C02-008-3 2C02 -8 3 B008626032 2025-09-24 10:04:40.017 22 6 234 11 62 2 8 00062 ZTO A 1118505 RITUALS琥珀麝香车载香氛 1 0015585602 0288223431 SH2025092300000650 87371 2028-01-01 00:00:00.000 6 1 1 09 2C02-008-3 2C02 -8 3 B008626032 2025-09-24 10:04:40.017 22 6 234 11 63 2 9 00063 ZTO A
09-25
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值