--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