[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SHUFFLE < SKIP 829 > < TAKE 60 >
60 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimPromotionId | DimResellerId | DimSalesTerritoryId | DiscountAmount | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice | UnitPriceDiscountPct |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO43902_19 | E3ED-44B5-B2 | PO5858178400 | 100 | 285 | 218 | 566 | 5 | 2021-10-02 | 34.20 | 0.86 | 2021-09-20 | 6 | 3.40 | 1 | 34.20 | 19 | SO43902 | 2021-09-27 | 2.74 | 20.38 | 5.70 | |||
SO53484_10 | CEC0-499D-80 | PO14790120337 | 19 | 291 | 551 | 497 | 6 | 2023-11-02 | 316.86 | 7.92 | 2023-10-21 | 2 | 144.59 | 1 | 316.86 | 10 | SO53484 | 2023-10-28 | 25.35 | 289.19 | 158.43 | |||
SO46959_4 | 9007-4F97-9C | PO16733197949 | 19 | 291 | 459 | 533 | 6 | 2022-10-02 | 323.96 | 8.10 | 2022-09-20 | 6 | 37.12 | 1 | 323.96 | 4 | SO46959 | 2022-09-27 | 25.92 | 222.73 | 53.99 | |||
SO53520_3 | 7FFF-4635-B3 | PO1131160733 | 36 | 295 | 575 | 536 | 8 | 2023-11-02 | 7152.21 | 178.81 | 2023-10-21 | 5 | 1481.94 | 1 | 7152.21 | 3 | SO53520 | 2023-10-28 | 572.18 | 7409.69 | 1430.44 | |||
SO65189_19 | 985E-4937-94 | PO14761195376 | 19 | 284 | 560 | 408 | 6 | 2024-05-02 | 2186.73 | 54.67 | 2024-04-20 | 3 | 755.15 | 1 | 2186.73 | 19 | SO65189 | 2024-04-27 | 174.94 | 2265.45 | 728.91 | |||
SO58991_5 | D7E6-4630-81 | PO16530115443 | 100 | 282 | 569 | 601 | 1 | 2024-02-01 | 890.82 | 22.27 | 2024-01-20 | 2 | 461.44 | 1 | 890.82 | 5 | SO58991 | 2024-01-27 | 71.27 | 922.89 | 445.41 | |||
SO46622_20 | 1009-4D99-85 | PO13862155069 | 19 | 291 | 399 | 119 | 6 | 2022-09-01 | 67.55 | 1.69 | 2022-08-20 | 2 | 24.99 | 1 | 67.55 | 20 | SO46622 | 2022-08-27 | 5.40 | 49.99 | 33.77 | |||
SO45811_3 | C0A1-43C4-AE | PO6409111249 | 100 | 283 | 319 | 292 | 4 | 2022-06-02 | 1749.59 | 43.74 | 2022-05-21 | 2 | 884.71 | 1 | 1749.59 | 3 | SO45811 | 2022-05-28 | 139.97 | 1769.42 | 874.79 | |||
SO53454_11 | 278D-445A-99 | PO19633151350 | 100 | 287 | 491 | 149 | 3 | 2023-11-02 | 323.94 | 8.10 | 2023-10-21 | 10 | 41.57 | 1 | 323.94 | 11 | SO53454 | 2023-10-28 | 25.92 | 415.72 | 32.39 | |||
SO51117_5 | 1B03-4F11-83 | PO10237188382 | 100 | 287 | 546 | 41 | 4 | 2023-09-01 | 111.76 | 2.79 | 2023-08-20 | 3 | 27.57 | 1 | 111.76 | 5 | SO51117 | 2023-08-27 | 8.94 | 82.70 | 37.25 | |||
SO53563_21 | C955-44BD-A8 | PO9599165865 | 100 | 285 | 605 | 170 | 5 | 2023-11-02 | 647.99 | 16.20 | 2023-10-21 | 2 | 343.65 | 1 | 647.99 | 21 | SO53563 | 2023-10-28 | 51.84 | 687.30 | 323.99 | |||
SO53478_35 | 6005-4C44-A8 | PO15486115045 | 100 | 292 | 556 | 121 | 7 | 2023-11-02 | 105.29 | 2.63 | 2023-10-21 | 1 | 77.92 | 1 | 105.29 | 35 | SO53478 | 2023-10-28 | 8.42 | 77.92 | 105.29 | |||
SO55276_13 | 81AA-41E5-B0 | PO2755182998 | 100 | 282 | 554 | 205 | 4 | 2023-12-02 | 54.94 | 1.37 | 2023-11-20 | 1 | 40.66 | 1 | 54.94 | 13 | SO55276 | 2023-11-27 | 4.40 | 40.66 | 54.94 | |||
SO51144_7 | 6330-4EB9-A5 | PO6409122852 | 100 | 281 | 580 | 292 | 4 | 2023-09-01 | 4082.38 | 102.06 | 2023-08-20 | 4 | 1082.51 | 1 | 4082.38 | 7 | SO51144 | 2023-08-27 | 326.59 | 4330.04 | 1020.59 | |||
SO48364_7 | 93FF-4A54-BA | PO3886118778 | 100 | 283 | 221 | 165 | 4 | 2023-02-01 | 20.19 | 0.50 | 2023-01-20 | 1 | 13.88 | 1 | 20.19 | 7 | SO48364 | 2023-01-27 | 1.61 | 13.88 | 20.19 | |||
SO61199_13 | EFA0-4D12-A2 | PO2552199779 | 100 | 286 | 353 | 506 | 1 | 2024-03-03 | 1391.99 | 34.80 | 2024-02-20 | 1 | 1265.62 | 1 | 1391.99 | 13 | SO61199 | 2024-02-27 | 111.36 | 1265.62 | 1391.99 | |||
SO45308_20 | 81AA-4F3D-A7 | PO10440184078 | 100 | 283 | 229 | 623 | 3 | 2022-04-04 | 144.20 | 3.61 | 2022-03-23 | 5 | 31.72 | 1 | 144.20 | 20 | SO45308 | 2022-03-30 | 11.54 | 158.62 | 28.84 | |||
SO51748_59 | 1D77-486A-86 | PO11658169327 | 100 | 283 | 559 | 233 | 2 | 2023-10-02 | 48.58 | 1.21 | 2023-09-20 | 4 | 8.99 | 1 | 48.58 | 59 | SO51748 | 2023-09-27 | 3.89 | 35.95 | 12.14 | |||
SO57105_31 | 3AE1-4A72-91 | PO18676113963 | 100 | 282 | 599 | 697 | 1 | 2024-01-02 | 323.99 | 8.10 | 2023-12-21 | 1 | 294.58 | 1 | 323.99 | 31 | SO57105 | 2023-12-28 | 25.92 | 294.58 | 323.99 | |||
SO61240_3 | 16E9-4057-BF | PO6467181082 | 100 | 283 | 463 | 660 | 3 | 2024-03-03 | 29.39 | 0.73 | 2024-02-20 | 2 | 9.16 | 1 | 29.39 | 3 | SO61240 | 2024-02-27 | 2.35 | 18.32 | 14.69 | |||
SO44552_17 | 79A1-4836-9F | PO5858149301 | 100 | 285 | 296 | 566 | 5 | 2022-01-02 | 1429.41 | 35.74 | 2021-12-21 | 2 | 617.03 | 1 | 1429.41 | 17 | SO44552 | 2021-12-28 | 114.35 | 1234.06 | 714.70 | |||
SO67327_30 | 2D2C-4C57-A2 | PO6467126287 | 100 | 283 | 374 | 660 | 3 | 2024-06-02 | 1466.01 | 36.65 | 2024-05-21 | 1 | 1554.95 | 1 | 1466.01 | 30 | SO67327 | 2024-05-28 | 117.28 | 1554.95 | 1466.01 | |||
SO71819_31 | DBA3-430C-8B | PO12354153257 | 100 | 283 | 225 | 197 | 3 | 2024-08-02 | 21.58 | 0.54 | 2024-07-21 | 4 | 6.92 | 1 | 21.58 | 31 | SO71819 | 2024-07-28 | 1.73 | 27.69 | 5.39 | |||
SO50232_19 | 3919-46D4-A1 | PO11020171211 | 19 | 284 | 339 | 336 | 6 | 2023-07-02 | 469.79 | 11.74 | 2023-06-20 | 1 | 486.71 | 1 | 469.79 | 19 | SO50232 | 2023-06-27 | 37.58 | 486.71 | 469.79 | |||
SO48758_15 | 709A-4AE0-B1 | PO13688180139 | 100 | 282 | 421 | 475 | 4 | 2023-03-04 | 196.33 | 4.91 | 2023-02-20 | 1 | 145.28 | 1 | 196.33 | 15 | SO48758 | 2023-02-27 | 15.71 | 145.28 | 196.33 | |||
SO45799_1 | 4DE8-4B9B-A1 | PO10730195041 | 100 | 287 | 326 | 491 | 4 | 2022-06-02 | 419.46 | 10.49 | 2022-05-21 | 1 | 413.15 | 1 | 419.46 | 1 | SO45799 | 2022-05-28 | 33.56 | 413.15 | 419.46 | |||
SO71849_11 | D1AA-4C46-B9 | PO18125130930 | 100 | 287 | 376 | 311 | 4 | 2024-08-02 | 2932.02 | 73.30 | 2024-07-21 | 2 | 1554.95 | 1 | 2932.02 | 11 | SO71849 | 2024-07-28 | 234.56 | 3109.90 | 1466.01 | |||
SO45577_21 | 7B09-45DB-A3 | PO9599125078 | 100 | 285 | 312 | 170 | 5 | 2022-05-02 | 2146.96 | 53.67 | 2022-04-20 | 1 | 2171.29 | 1 | 2146.96 | 21 | SO45577 | 2022-04-27 | 171.76 | 2171.29 | 2146.96 | |||
SO51875_9 | CB08-4C83-82 | PO10266131482 | 6 | 296 | 502 | 393 | 9 | 2023-10-02 | 800.21 | 20.01 | 2023-09-20 | 4 | 199.85 | 1 | 800.21 | 9 | SO51875 | 2023-09-27 | 64.02 | 799.41 | 200.05 | |||
SO50703_3 | 4A3D-44CB-B3 | PO2813140706 | 100 | 283 | 343 | 90 | 5 | 2023-08-02 | 1409.38 | 35.23 | 2023-07-21 | 3 | 486.71 | 1 | 1409.38 | 3 | SO50703 | 2023-07-28 | 112.75 | 1460.12 | 469.79 | |||
SO49473_21 | EAA2-43E2-87 | PO2813142084 | 100 | 283 | 456 | 90 | 5 | 2023-05-02 | 89.99 | 2.25 | 2023-04-20 | 2 | 30.93 | 1 | 89.99 | 21 | SO49473 | 2023-04-27 | 7.20 | 61.87 | 44.99 | |||
SO51864_1 | 2389-4E32-92 | PO5568126648 | 100 | 285 | 474 | 3 | 422 | 5 | 34.65 | 2023-10-02 | 692.90 | 16.46 | 2023-09-20 | 18 | 26.18 | 1 | 658.26 | 1 | SO51864 | 2023-09-27 | 52.66 | 471.17 | 38.49 | 0.05 |
SO48297_7 | FF31-49F8-B2 | PO18531121802 | 19 | 284 | 233 | 613 | 6 | 2023-02-01 | 144.20 | 3.61 | 2023-01-20 | 5 | 29.08 | 1 | 144.20 | 7 | SO48297 | 2023-01-27 | 11.54 | 145.40 | 28.84 | |||
SO69412_22 | 14B1-47FE-BF | PO15689112657 | 100 | 281 | 491 | 328 | 4 | 2024-07-02 | 291.55 | 7.29 | 2024-06-20 | 9 | 41.57 | 1 | 291.55 | 22 | SO69412 | 2024-06-27 | 23.32 | 374.15 | 32.39 | |||
SO45814_6 | 9844-4839-BA | PO8120138004 | 100 | 272 | 223 | 485 | 5 | 2022-06-02 | 5.19 | 0.13 | 2022-05-21 | 1 | 5.71 | 1 | 5.19 | 6 | SO45814 | 2022-05-28 | 0.41 | 5.71 | 5.19 | |||
SO49062_24 | D3FD-415F-A5 | PO928133820 | 98 | 288 | 367 | 484 | 10 | 2023-04-04 | 1943.98 | 48.60 | 2023-03-23 | 3 | 598.44 | 1 | 1943.98 | 24 | SO49062 | 2023-03-30 | 155.52 | 1795.31 | 647.99 | |||
SO53500_10 | BEF0-4525-AF | PO12470126979 | 100 | 287 | 502 | 672 | 1 | 2023-11-02 | 800.21 | 20.01 | 2023-10-21 | 4 | 199.85 | 1 | 800.21 | 10 | SO53500 | 2023-10-28 | 64.02 | 799.41 | 200.05 | |||
SO47031_26 | 3FA6-4120-BD | PO4466161844 | 19 | 291 | 358 | 352 | 6 | 2022-10-02 | 3688.38 | 92.21 | 2022-09-20 | 3 | 1105.81 | 1 | 3688.38 | 26 | SO47031 | 2022-09-27 | 295.07 | 3317.43 | 1229.46 | |||
SO51812_16 | 24E8-4559-AB | PO8555114368 | 98 | 288 | 544 | 250 | 10 | 2023-10-02 | 97.19 | 2.43 | 2023-09-20 | 2 | 35.96 | 1 | 97.19 | 16 | SO51812 | 2023-09-27 | 7.78 | 71.92 | 48.59 | |||
SO69461_23 | F8C1-4A85-91 | PO1508119064 | 98 | 288 | 580 | 430 | 10 | 2024-07-02 | 1020.59 | 25.51 | 2024-06-20 | 1 | 1082.51 | 1 | 1020.59 | 23 | SO69461 | 2024-06-27 | 81.65 | 1082.51 | 1020.59 | |||
SO53569_33 | 113E-43AD-94 | PO9309141312 | 100 | 293 | 499 | 55 | 1 | 2023-11-02 | 602.35 | 15.06 | 2023-10-21 | 1 | 601.74 | 1 | 602.35 | 33 | SO53569 | 2023-10-28 | 48.19 | 601.74 | 602.35 | |||
SO69479_10 | 3D8D-4908-A6 | PO18328116976 | 19 | 284 | 378 | 552 | 6 | 2024-07-02 | 1466.01 | 36.65 | 2024-06-20 | 1 | 1554.95 | 1 | 1466.01 | 10 | SO69479 | 2024-06-27 | 117.28 | 1554.95 | 1466.01 | |||
SO55289_1 | D66B-411C-95 | PO15022133270 | 100 | 289 | 525 | 560 | 1 | 2023-12-02 | 158.43 | 3.96 | 2023-11-20 | 1 | 144.59 | 1 | 158.43 | 1 | SO55289 | 2023-11-27 | 12.67 | 144.59 | 158.43 | |||
SO49103_3 | 0B8A-4326-8A | PO17748175932 | 19 | 284 | 433 | 102 | 6 | 2023-04-04 | 324.45 | 8.11 | 2023-03-23 | 1 | 300.12 | 1 | 324.45 | 3 | SO49103 | 2023-03-30 | 25.96 | 300.12 | 324.45 | |||
SO46976_7 | 23E2-4510-88 | PO14558186797 | 100 | 289 | 468 | 2 | 1 | 2022-10-02 | 68.38 | 1.71 | 2022-09-20 | 3 | 15.67 | 1 | 68.38 | 7 | SO46976 | 2022-09-27 | 5.47 | 47.01 | 22.79 | |||
SO53483_42 | A0BE-40E0-81 | PO14761137153 | 19 | 284 | 573 | 408 | 6 | 2023-11-02 | 11443.54 | 286.09 | 2023-10-21 | 8 | 1481.94 | 1 | 11443.54 | 42 | SO53483 | 2023-10-28 | 915.48 | 11855.50 | 1430.44 | |||
SO69465_1 | B8B2-4B14-99 | PO2842153886 | 100 | 285 | 376 | 700 | 5 | 2024-07-02 | 2932.02 | 73.30 | 2024-06-20 | 2 | 1554.95 | 1 | 2932.02 | 1 | SO69465 | 2024-06-27 | 234.56 | 3109.90 | 1466.01 | |||
SO48776_19 | 81D9-4651-84 | PO3828123354 | 100 | 283 | 420 | 414 | 2 | 2023-03-04 | 283.23 | 7.08 | 2023-02-20 | 2 | 104.80 | 1 | 283.23 | 19 | SO48776 | 2023-02-27 | 22.66 | 209.59 | 141.62 | |||
SO47005_2 | 8590-4C1D-A5 | PO754119110 | 100 | 289 | 216 | 645 | 1 | 2022-10-02 | 20.19 | 0.50 | 2022-09-20 | 1 | 13.88 | 1 | 20.19 | 2 | SO47005 | 2022-09-27 | 1.61 | 13.88 | 20.19 | |||
SO61173_26 | 6B8D-47B8-8E | PO522171689 | 100 | 285 | 511 | 676 | 5 | 2024-03-03 | 436.91 | 10.92 | 2024-02-20 | 2 | 199.38 | 1 | 436.91 | 26 | SO61173 | 2024-02-27 | 34.95 | 398.75 | 218.45 | |||
SO49157_19 | 9DDB-4852-A8 | PO7424122254 | 100 | 283 | 362 | 642 | 2 | 2023-04-04 | 8606.21 | 215.16 | 2023-03-23 | 7 | 1105.81 | 1 | 8606.21 | 19 | SO49157 | 2023-03-30 | 688.50 | 7740.67 | 1229.46 | |||
SO53460_52 | 3BD9-47C3-94 | PO19343112747 | 100 | 282 | 281 | 24 | 4 | 2023-11-02 | 809.33 | 20.23 | 2023-10-21 | 4 | 204.63 | 1 | 809.33 | 52 | SO53460 | 2023-10-28 | 64.75 | 818.50 | 202.33 | |||
SO47365_54 | 4535-457B-B0 | PO17574153673 | 19 | 291 | 460 | 678 | 6 | 2022-11-02 | 431.95 | 10.80 | 2022-10-21 | 8 | 37.12 | 1 | 431.95 | 54 | SO47365 | 2022-10-28 | 34.56 | 296.97 | 53.99 | |||
SO58948_38 | 1534-4AB5-81 | PO11774195497 | 6 | 296 | 214 | 682 | 9 | 2024-02-01 | 188.95 | 4.72 | 2024-01-20 | 9 | 13.09 | 1 | 188.95 | 38 | SO58948 | 2024-01-27 | 15.12 | 117.78 | 20.99 | |||
SO46940_6 | 6ADC-4363-B3 | PO18705126181 | 19 | 291 | 453 | 479 | 6 | 2022-10-02 | 71.99 | 1.80 | 2022-09-20 | 2 | 24.75 | 1 | 71.99 | 6 | SO46940 | 2022-09-27 | 5.76 | 49.49 | 35.99 | |||
SO48028_20 | B23F-4743-B9 | PO928137953 | 98 | 288 | 421 | 484 | 10 | 2023-01-02 | 392.66 | 9.82 | 2022-12-21 | 2 | 145.28 | 1 | 392.66 | 20 | SO48028 | 2022-12-28 | 31.41 | 290.57 | 196.33 | |||
SO49078_2 | 827E-4512-AD | PO2668184206 | 100 | 290 | 352 | 535 | 7 | 2023-04-04 | 2485.70 | 62.14 | 2023-03-23 | 2 | 1117.86 | 1 | 2485.70 | 2 | SO49078 | 2023-03-30 | 198.86 | 2235.71 | 1242.85 | |||
SO71949_10 | D52C-4E65-AA | PO9483195097 | 100 | 283 | 231 | 54 | 2 | 2024-08-02 | 149.97 | 3.75 | 2024-07-21 | 5 | 38.49 | 1 | 149.97 | 10 | SO71949 | 2024-07-28 | 12.00 | 192.46 | 29.99 | |||
SO44093_19 | 8356-4625-B2 | PO15138128112 | 100 | 283 | 235 | 93 | 4 | 2021-11-02 | 115.36 | 2.88 | 2021-10-21 | 4 | 31.72 | 1 | 115.36 | 19 | SO44093 | 2021-10-28 | 9.23 | 126.90 | 28.84 | |||
SO49884_9 | 822A-428D-94 | PO5626129805 | 100 | 281 | 323 | 166 | 4 | 2023-06-02 | 1409.38 | 35.23 | 2023-05-21 | 3 | 486.71 | 1 | 1409.38 | 9 | SO49884 | 2023-05-28 | 112.75 | 1460.12 | 469.79 |
Generated 2024-09-20 02:29:24.043 UTC