[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SKIP 4000 SHUFFLE < SKIP 62 > < TAKE 62 >
62 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO59018_33 | F605-4DA0-8F | PO8033148787 | 6 | 296 | 353 | 15 | 9 | 2024-02-01 | 4175.98 | 104.40 | 2024-01-20 | 3 | 1265.62 | 1 | 4175.98 | 33 | SO59018 | 2024-01-27 | 334.08 | 3796.86 | 1391.99 | |||
SO45329_10 | CFFE-4184-BD | PO5858128971 | 100 | 285 | 212 | 566 | 5 | 2022-04-04 | 80.75 | 2.02 | 2022-03-23 | 4 | 12.03 | 1 | 80.75 | 10 | SO45329 | 2022-03-30 | 6.46 | 48.11 | 20.19 | |||
SO67304_6 | 5E78-4926-A4 | PO18444191982 | 19 | 291 | 374 | 227 | 6 | 2024-06-02 | 1466.01 | 36.65 | 2024-05-21 | 1 | 1554.95 | 1 | 1466.01 | 6 | SO67304 | 2024-05-28 | 117.28 | 1554.95 | 1466.01 | |||
SO69517_2 | B70F-4B16-A6 | PO5655130015 | 100 | 287 | 497 | 563 | 4 | 2024-07-02 | 602.35 | 15.06 | 2024-06-20 | 1 | 601.74 | 1 | 602.35 | 2 | SO69517 | 2024-06-27 | 48.19 | 601.74 | 602.35 | |||
SO71948_11 | DCEE-428D-87 | PO9599179297 | 100 | 285 | 482 | 170 | 5 | 2024-08-02 | 26.97 | 0.67 | 2024-07-21 | 5 | 3.36 | 1 | 26.97 | 11 | SO71948 | 2024-07-28 | 2.16 | 16.81 | 5.39 | |||
SO59067_1 | E3EE-4893-A2 | PO9396164546 | 6 | 296 | 571 | 267 | 9 | 2024-02-01 | 445.41 | 11.14 | 2024-01-20 | 1 | 461.44 | 1 | 445.41 | 1 | SO59067 | 2024-01-27 | 35.63 | 461.44 | 445.41 | |||
SO48321_10 | FA9B-4026-BF | PO14790154902 | 19 | 291 | 456 | 497 | 6 | 2023-02-01 | 134.98 | 3.37 | 2023-01-20 | 3 | 30.93 | 1 | 134.98 | 10 | SO48321 | 2023-01-27 | 10.80 | 92.80 | 44.99 | |||
SO46334_6 | F652-4575-B7 | PO17574196050 | 19 | 272 | 344 | 7 | 678 | 6 | 2677.49 | 2022-08-02 | 7649.98 | 124.31 | 2022-07-21 | 9 | 1912.15 | 1 | 4972.49 | 6 | SO46334 | 2022-07-28 | 397.80 | 17209.39 | 850.00 | 0.35 |
SO51121_45 | 9E4C-40B6-B1 | PO10730114575 | 100 | 287 | 491 | 491 | 4 | 2023-09-01 | 194.36 | 4.86 | 2023-08-20 | 6 | 41.57 | 1 | 194.36 | 45 | SO51121 | 2023-08-27 | 15.55 | 249.43 | 32.39 | |||
SO61248_43 | 67A0-4D10-87 | PO4495126386 | 19 | 291 | 222 | 496 | 6 | 2024-03-03 | 41.99 | 1.05 | 2024-02-20 | 2 | 13.09 | 1 | 41.99 | 43 | SO61248 | 2024-02-27 | 3.36 | 26.17 | 20.99 | |||
SO49821_13 | 0B9B-460C-BC | PO551117366 | 100 | 281 | 379 | 4 | 4 | 2023-06-02 | 2617.88 | 65.45 | 2023-05-21 | 2 | 1320.68 | 1 | 2617.88 | 13 | SO49821 | 2023-05-28 | 209.43 | 2641.37 | 1308.94 | |||
SO65160_4 | 9375-44FE-94 | PO19343172976 | 100 | 282 | 482 | 24 | 4 | 2024-05-02 | 16.18 | 0.40 | 2024-04-20 | 3 | 3.36 | 1 | 16.18 | 4 | SO65160 | 2024-04-27 | 1.29 | 10.09 | 5.39 | |||
SO47440_10 | 490D-4B3C-84 | PO7018185620 | 100 | 283 | 468 | 695 | 3 | 2022-11-02 | 22.79 | 0.57 | 2022-10-21 | 1 | 15.67 | 1 | 22.79 | 10 | SO47440 | 2022-10-28 | 1.82 | 15.67 | 22.79 | |||
SO44559_20 | 8618-4A1B-AD | PO6641148111 | 100 | 281 | 223 | 342 | 2 | 2022-01-02 | 20.75 | 0.52 | 2021-12-21 | 4 | 5.71 | 1 | 20.75 | 20 | SO44559 | 2021-12-28 | 1.66 | 22.82 | 5.19 | |||
SO65164_3 | 07B8-4AF8-8A | PO18299114573 | 19 | 291 | 603 | 118 | 6 | 2024-05-02 | 218.68 | 5.47 | 2024-04-20 | 3 | 53.94 | 1 | 218.68 | 3 | SO65164 | 2024-04-27 | 17.49 | 161.82 | 72.89 | |||
SO44544_3 | E01E-42FD-93 | PO3799116414 | 100 | 282 | 292 | 312 | 4 | 2022-01-02 | 1637.40 | 40.94 | 2021-12-21 | 2 | 706.81 | 1 | 1637.40 | 3 | SO44544 | 2021-12-28 | 130.99 | 1413.62 | 818.70 | |||
SO67295_28 | D785-46A0-BC | PO1711155302 | 19 | 291 | 476 | 3 | 245 | 6 | 28.87 | 2024-06-02 | 577.42 | 13.71 | 2024-05-21 | 15 | 26.18 | 1 | 548.55 | 28 | SO67295 | 2024-05-28 | 43.88 | 392.64 | 38.49 | 0.05 |
SO47995_2 | E14D-40EA-B3 | PO15254116423 | 100 | 281 | 325 | 377 | 3 | 2023-01-02 | 3288.56 | 82.21 | 2022-12-21 | 7 | 486.71 | 1 | 3288.56 | 2 | SO47995 | 2022-12-28 | 263.08 | 3406.95 | 469.79 | |||
SO48012_11 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 445 | 78 | 4 | 2023-01-02 | 179.97 | 4.50 | 2022-12-21 | 5 | 24.75 | 1 | 179.97 | 11 | SO48012 | 2022-12-28 | 14.40 | 123.73 | 35.99 | |||
SO51714_12 | D33A-4EAE-B1 | PO15689195197 | 100 | 281 | 380 | 328 | 4 | 2023-10-02 | 10262.07 | 256.55 | 2023-09-20 | 7 | 1554.95 | 1 | 10262.07 | 12 | SO51714 | 2023-09-27 | 820.97 | 10884.64 | 1466.01 | |||
SO44772_20 | F5E6-4B81-A3 | PO1624122637 | 100 | 283 | 315 | 579 | 3 | 2022-02-01 | 1749.59 | 43.74 | 2022-01-20 | 2 | 884.71 | 1 | 1749.59 | 20 | SO44772 | 2022-01-27 | 139.97 | 1769.42 | 874.79 | |||
SO46987_18 | 60CF-4768-AF | PO12702179544 | 100 | 292 | 412 | 175 | 7 | 2022-10-02 | 720.52 | 18.01 | 2022-09-20 | 4 | 133.30 | 1 | 720.52 | 18 | SO46987 | 2022-09-27 | 57.64 | 533.18 | 180.13 | |||
SO46047_4 | 2520-47B8-B9 | PO16211157418 | 100 | 285 | 292 | 99 | 5 | 2022-07-02 | 818.70 | 20.47 | 2022-06-20 | 1 | 706.81 | 1 | 818.70 | 4 | SO46047 | 2022-06-27 | 65.50 | 706.81 | 818.70 | |||
SO48740_13 | 158B-4BBF-9F | PO551143768 | 100 | 281 | 381 | 4 | 4 | 2023-03-04 | 600.26 | 15.01 | 2023-02-20 | 1 | 605.65 | 1 | 600.26 | 13 | SO48740 | 2023-02-27 | 48.02 | 605.65 | 600.26 | |||
SO47416_2 | 6B45-44AB-84 | PO2813155355 | 100 | 281 | 254 | 90 | 5 | 2022-11-02 | 1471.51 | 36.79 | 2022-10-21 | 8 | 170.14 | 1 | 1471.51 | 2 | SO47416 | 2022-10-28 | 117.72 | 1361.14 | 183.94 | |||
SO47380_24 | EF71-4036-91 | PO14790123967 | 19 | 291 | 464 | 497 | 6 | 2022-11-02 | 56.52 | 1.41 | 2022-10-21 | 4 | 9.71 | 1 | 56.52 | 24 | SO47380 | 2022-10-28 | 4.52 | 38.85 | 14.13 | |||
SO67297_9 | 58AA-422C-BB | PO2552176926 | 100 | 286 | 587 | 506 | 1 | 2024-06-02 | 923.39 | 23.08 | 2024-05-21 | 2 | 419.78 | 1 | 923.39 | 9 | SO67297 | 2024-05-28 | 73.87 | 839.56 | 461.69 | |||
SO46326_4 | EDD8-4703-B2 | PO19401160698 | 19 | 288 | 229 | 173 | 6 | 2022-08-02 | 57.68 | 1.44 | 2022-07-21 | 2 | 31.72 | 1 | 57.68 | 4 | SO46326 | 2022-07-28 | 4.61 | 63.45 | 28.84 | |||
SO67347_24 | 6E87-4127-80 | PO8787117055 | 100 | 282 | 390 | 523 | 3 | 2024-06-02 | 2689.18 | 67.23 | 2024-05-21 | 4 | 713.08 | 1 | 2689.18 | 24 | SO67347 | 2024-05-28 | 215.13 | 2852.32 | 672.29 | |||
SO51844_12 | DE76-4481-AA | PO4553182082 | 100 | 282 | 234 | 313 | 4 | 2023-10-02 | 269.95 | 6.75 | 2023-09-20 | 9 | 38.49 | 1 | 269.95 | 12 | SO51844 | 2023-09-27 | 21.60 | 346.43 | 29.99 | |||
SO58909_8 | EBC4-496C-90 | PO19343180161 | 100 | 282 | 237 | 24 | 4 | 2024-02-01 | 29.99 | 0.75 | 2024-01-20 | 1 | 38.49 | 1 | 29.99 | 8 | SO58909 | 2024-01-27 | 2.40 | 38.49 | 29.99 | |||
SO67317_3 | 4A70-41C2-8F | PO6032167181 | 6 | 296 | 579 | 177 | 9 | 2024-06-02 | 1457.82 | 36.45 | 2024-05-21 | 2 | 755.15 | 1 | 1457.82 | 3 | SO67317 | 2024-05-28 | 116.63 | 1510.30 | 728.91 | |||
SO53606_24 | 6A19-463C-B7 | PO5539128997 | 100 | 282 | 511 | 61 | 4 | 2023-11-02 | 1310.72 | 32.77 | 2023-10-21 | 6 | 199.38 | 1 | 1310.72 | 24 | SO53606 | 2023-10-28 | 104.86 | 1196.25 | 218.45 | |||
SO53590_20 | E7FF-4C04-9E | PO4118162346 | 100 | 281 | 502 | 454 | 3 | 2023-11-02 | 400.10 | 10.00 | 2023-10-21 | 2 | 199.85 | 1 | 400.10 | 20 | SO53590 | 2023-10-28 | 32.01 | 399.70 | 200.05 | |||
SO44559_18 | 8618-4A1B-AD | PO6641148111 | 100 | 281 | 334 | 342 | 2 | 2022-01-02 | 419.46 | 10.49 | 2021-12-21 | 1 | 413.15 | 1 | 419.46 | 18 | SO44559 | 2021-12-28 | 33.56 | 413.15 | 419.46 | |||
SO51806_8 | 644D-4C45-8E | PO9425112104 | 6 | 296 | 483 | 519 | 9 | 2023-10-02 | 648.00 | 16.20 | 2023-09-20 | 9 | 44.88 | 1 | 648.00 | 8 | SO51806 | 2023-09-27 | 51.84 | 403.92 | 72.00 | |||
SO48050_17 | 88AC-458C-88 | PO3625155257 | 100 | 281 | 370 | 666 | 2 | 2023-01-02 | 2932.02 | 73.30 | 2022-12-21 | 2 | 1518.79 | 1 | 2932.02 | 17 | SO48050 | 2022-12-28 | 234.56 | 3037.57 | 1466.01 | |||
SO63180_15 | B8CD-47BA-8C | PO2523117609 | 100 | 287 | 225 | 167 | 4 | 2024-04-03 | 5.39 | 0.13 | 2024-03-22 | 1 | 6.92 | 1 | 5.39 | 15 | SO63180 | 2024-03-29 | 0.43 | 6.92 | 5.39 | |||
SO61251_1 | 0DCB-4D48-AF | PO6380165323 | 100 | 281 | 564 | 597 | 4 | 2024-03-03 | 1430.44 | 35.76 | 2024-02-20 | 1 | 1481.94 | 1 | 1430.44 | 1 | SO61251 | 2024-02-27 | 114.44 | 1481.94 | 1430.44 | |||
SO51761_33 | 056F-4C15-93 | PO580111702 | 36 | 295 | 503 | 230 | 8 | 2023-10-02 | 200.05 | 5.00 | 2023-09-20 | 1 | 199.85 | 1 | 200.05 | 33 | SO51761 | 2023-09-27 | 16.00 | 199.85 | 200.05 | |||
SO50283_4 | C5D2-4791-8E | PO6670132986 | 100 | 283 | 239 | 432 | 2 | 2023-07-02 | 3123.27 | 78.08 | 2023-06-20 | 4 | 722.26 | 1 | 3123.27 | 4 | SO50283 | 2023-06-27 | 249.86 | 2889.03 | 780.82 | |||
SO44768_10 | 18BD-48B8-95 | PO261164909 | 100 | 283 | 317 | 647 | 4 | 2022-02-01 | 2624.38 | 65.61 | 2022-01-20 | 3 | 884.71 | 1 | 2624.38 | 10 | SO44768 | 2022-01-27 | 209.95 | 2654.12 | 874.79 | |||
SO46333_14 | B042-408B-A8 | PO17545158984 | 19 | 288 | 264 | 155 | 6 | 2022-08-02 | 367.88 | 9.20 | 2022-07-21 | 2 | 181.49 | 1 | 367.88 | 14 | SO46333 | 2022-07-28 | 29.43 | 362.97 | 183.94 | |||
SO71863_7 | F39F-4A8F-B9 | PO16124166561 | 100 | 282 | 545 | 649 | 4 | 2024-08-02 | 48.59 | 1.21 | 2024-07-21 | 2 | 17.98 | 1 | 48.59 | 7 | SO71863 | 2024-07-28 | 3.89 | 35.96 | 24.29 | |||
SO59064_44 | AE68-4CAD-B8 | PO8671111477 | 98 | 290 | 295 | 502 | 10 | 2024-02-01 | 1637.40 | 40.94 | 2024-01-20 | 2 | 747.20 | 1 | 1637.40 | 44 | SO59064 | 2024-01-27 | 130.99 | 1494.40 | 818.70 | |||
SO50246_1 | F243-44EB-B2 | PO1827174701 | 19 | 291 | 377 | 317 | 6 | 2023-07-02 | 3926.81 | 98.17 | 2023-06-20 | 3 | 1320.68 | 1 | 3926.81 | 1 | SO50246 | 2023-06-27 | 314.15 | 3962.05 | 1308.94 | |||
SO65165_5 | E659-4F16-8A | PO18241154115 | 100 | 285 | 573 | 477 | 5 | 2024-05-02 | 1430.44 | 35.76 | 2024-04-20 | 1 | 1481.94 | 1 | 1430.44 | 5 | SO65165 | 2024-04-27 | 114.44 | 1481.94 | 1430.44 | |||
SO46988_28 | 2D2E-4EC3-AC | PO12499171502 | 100 | 282 | 369 | 78 | 4 | 2022-10-02 | 7330.05 | 183.25 | 2022-09-20 | 5 | 1518.79 | 1 | 7330.05 | 28 | SO46988 | 2022-09-27 | 586.40 | 7593.93 | 1466.01 | |||
SO65177_23 | 1619-495E-81 | PO16501143019 | 98 | 288 | 546 | 142 | 10 | 2024-05-02 | 74.51 | 1.86 | 2024-04-20 | 2 | 27.57 | 1 | 74.51 | 23 | SO65177 | 2024-04-27 | 5.96 | 55.14 | 37.25 | |||
SO53492_15 | 6D1A-4E58-A3 | PO13630111535 | 6 | 294 | 490 | 640 | 9 | 2023-11-02 | 32.39 | 0.81 | 2023-10-21 | 1 | 41.57 | 1 | 32.39 | 15 | SO53492 | 2023-10-28 | 2.59 | 41.57 | 32.39 | |||
SO71817_1 | 999E-4556-8F | PO12905185178 | 19 | 284 | 570 | 228 | 6 | 2024-08-02 | 445.41 | 11.14 | 2024-07-21 | 1 | 461.44 | 1 | 445.41 | 1 | SO71817 | 2024-07-28 | 35.63 | 461.44 | 445.41 | |||
SO71881_28 | 8EDF-4F9F-97 | PO6757112103 | 100 | 281 | 595 | 16 | 21 | 4 | 45.20 | 2024-08-02 | 113.00 | 1.70 | 2024-07-21 | 1 | 308.22 | 1 | 67.80 | 28 | SO71881 | 2024-07-28 | 5.42 | 308.22 | 113.00 | 0.40 |
SO63137_4 | 269D-49DF-89 | PO18183116686 | 100 | 283 | 524 | 667 | 2 | 2024-04-03 | 158.43 | 3.96 | 2024-03-22 | 1 | 144.59 | 1 | 158.43 | 4 | SO63137 | 2024-03-29 | 12.67 | 144.59 | 158.43 | |||
SO71904_3 | DBF0-4665-A7 | PO5017189568 | 100 | 289 | 560 | 308 | 1 | 2024-08-02 | 728.91 | 18.22 | 2024-07-21 | 1 | 755.15 | 1 | 728.91 | 3 | SO71904 | 2024-07-28 | 58.31 | 755.15 | 728.91 | |||
SO46633_39 | D8C9-4AB8-A4 | PO11484122930 | 100 | 281 | 410 | 594 | 2 | 2022-09-01 | 109.34 | 2.73 | 2022-08-20 | 3 | 26.97 | 1 | 109.34 | 39 | SO46633 | 2022-08-27 | 8.75 | 80.91 | 36.45 | |||
SO45794_9 | 945F-4477-83 | PO12760191318 | 19 | 288 | 232 | 83 | 6 | 2022-06-02 | 230.72 | 5.77 | 2022-05-21 | 8 | 31.72 | 1 | 230.72 | 9 | SO45794 | 2022-05-28 | 18.46 | 253.80 | 28.84 | |||
SO69560_15 | B1B6-43F4-BC | PO9077167302 | 19 | 291 | 309 | 100 | 6 | 2024-07-02 | 818.70 | 20.47 | 2024-06-20 | 1 | 747.20 | 1 | 818.70 | 15 | SO69560 | 2024-06-27 | 65.50 | 747.20 | 818.70 | |||
SO63202_2 | 5C83-47EE-AA | PO15631193825 | 100 | 282 | 475 | 43 | 1 | 2024-04-03 | 41.99 | 1.05 | 2024-03-22 | 1 | 26.18 | 1 | 41.99 | 2 | SO63202 | 2024-03-29 | 3.36 | 26.18 | 41.99 | |||
SO49529_2 | B302-4F32-AA | PO4437195427 | 100 | 281 | 254 | 39 | 3 | 2023-05-02 | 183.94 | 4.60 | 2023-04-20 | 1 | 170.14 | 1 | 183.94 | 2 | SO49529 | 2023-04-27 | 14.72 | 170.14 | 183.94 | |||
SO47024_28 | F254-4053-A3 | PO3654136382 | 100 | 283 | 367 | 435 | 4 | 2022-10-02 | 1295.99 | 32.40 | 2022-09-20 | 2 | 598.44 | 1 | 1295.99 | 28 | SO47024 | 2022-09-27 | 103.68 | 1196.87 | 647.99 | |||
SO55301_53 | C4D6-4789-A9 | PO3828165579 | 100 | 283 | 214 | 414 | 2 | 2023-12-02 | 83.98 | 2.10 | 2023-11-20 | 4 | 13.09 | 1 | 83.98 | 53 | SO55301 | 2023-11-27 | 6.72 | 52.35 | 20.99 | |||
SO57034_12 | 57D0-46D3-B7 | PO15689142548 | 100 | 281 | 222 | 328 | 4 | 2024-01-02 | 188.95 | 4.72 | 2023-12-21 | 9 | 13.09 | 1 | 188.95 | 12 | SO57034 | 2023-12-28 | 15.12 | 117.78 | 20.99 |
Generated 2024-09-19 19:55:18.313 UTC