[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > SHUFFLE < SKIP 312 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO44518_11 | 359F-48A3-B9 | PO12586169040 | 100 | 285 | 293 | 278 | 5 | 2022-01-02 | 2167.78 | 54.19 | 2021-12-21 | 3 | 623.84 | 1 | 2167.78 | 11 | SO44518 | 2021-12-28 | 173.42 | 1871.52 | 722.59 | |||
SO43902_15 | E3ED-44B5-B2 | PO5858178400 | 100 | 285 | 223 | 566 | 5 | 2021-10-02 | 10.37 | 0.26 | 2021-09-20 | 2 | 5.71 | 1 | 10.37 | 15 | SO43902 | 2021-09-27 | 0.83 | 11.41 | 5.19 | |||
SO67349_37 | 7BC2-4E87-BA | PO9831186318 | 100 | 285 | 547 | 81 | 5 | 2024-06-02 | 145.78 | 3.64 | 2024-05-21 | 3 | 35.96 | 1 | 145.78 | 37 | SO67349 | 2024-05-28 | 11.66 | 107.88 | 48.59 | |||
SO46604_29 | 8062-4A97-B3 | PO522154989 | 100 | 285 | 464 | 676 | 5 | 2022-09-01 | 42.39 | 1.06 | 2022-08-20 | 3 | 9.71 | 1 | 42.39 | 29 | SO46604 | 2022-08-27 | 3.39 | 29.14 | 14.13 | |||
SO44130_8 | A870-450A-8A | PO9106111486 | 100 | 285 | 348 | 602 | 5 | 2021-11-02 | 6074.98 | 151.87 | 2021-10-21 | 3 | 1898.09 | 1 | 6074.98 | 8 | SO44130 | 2021-10-28 | 486.00 | 5694.28 | 2024.99 | |||
SO47026_10 | 123B-481F-8F | PO3596190739 | 100 | 285 | 468 | 476 | 5 | 2022-10-02 | 45.59 | 1.14 | 2022-09-20 | 2 | 15.67 | 1 | 45.59 | 10 | SO47026 | 2022-09-27 | 3.65 | 31.34 | 22.79 | |||
SO46630_34 | F512-40F2-91 | PO12644161356 | 100 | 285 | 468 | 530 | 5 | 2022-09-01 | 45.59 | 1.14 | 2022-08-20 | 2 | 15.67 | 1 | 45.59 | 34 | SO46630 | 2022-08-27 | 3.65 | 31.34 | 22.79 | |||
SO51718_2 | 27D3-4968-89 | PO15051113417 | 100 | 285 | 359 | 207 | 5 | 2023-10-02 | 1376.99 | 34.42 | 2023-09-20 | 1 | 1251.98 | 1 | 1376.99 | 2 | SO51718 | 2023-09-27 | 110.16 | 1251.98 | 1376.99 | |||
SO46991_13 | 6D99-4D79-AA | PO11803111101 | 100 | 285 | 410 | 513 | 5 | 2022-10-02 | 72.89 | 1.82 | 2022-09-20 | 2 | 26.97 | 1 | 72.89 | 13 | SO46991 | 2022-09-27 | 5.83 | 53.94 | 36.45 | |||
SO51693_14 | 6FEB-4D5B-92 | PO19546179477 | 100 | 285 | 580 | 206 | 5 | 2023-10-02 | 2041.19 | 51.03 | 2023-09-20 | 2 | 1082.51 | 1 | 2041.19 | 14 | SO51693 | 2023-09-27 | 163.30 | 2165.02 | 1020.59 | |||
SO69443_4 | 7B84-4BA4-86 | PO11542130895 | 100 | 285 | 484 | 62 | 5 | 2024-07-02 | 9.54 | 0.24 | 2024-06-20 | 2 | 2.97 | 1 | 9.54 | 4 | SO69443 | 2024-06-27 | 0.76 | 5.95 | 4.77 | |||
SO44318_5 | 6965-4539-96 | PO8120137646 | 100 | 281 | 349 | 485 | 5 | 2021-12-02 | 4049.99 | 101.25 | 2021-11-20 | 2 | 1898.09 | 1 | 4049.99 | 5 | SO44318 | 2021-11-27 | 324.00 | 3796.19 | 2024.99 | |||
SO51705_13 | DFFB-4C23-BD | PO16965171069 | 100 | 285 | 214 | 441 | 5 | 2023-10-02 | 83.98 | 2.10 | 2023-09-20 | 4 | 13.09 | 1 | 83.98 | 13 | SO51705 | 2023-09-27 | 6.72 | 52.35 | 20.99 | |||
SO49443_1 | 80CD-42C1-AB | PO435152332 | 100 | 285 | 422 | 651 | 5 | 2023-05-02 | 67.54 | 1.69 | 2023-04-20 | 1 | 49.98 | 1 | 67.54 | 1 | SO49443 | 2023-04-27 | 5.40 | 49.98 | 67.54 | |||
SO67277_37 | 9AB3-4F34-85 | PO12644174121 | 100 | 272 | 527 | 530 | 5 | 2024-06-02 | 475.29 | 11.88 | 2024-05-21 | 3 | 144.59 | 1 | 475.29 | 37 | SO67277 | 2024-05-28 | 38.02 | 433.78 | 158.43 | |||
SO50703_24 | 4A3D-44CB-B3 | PO2813140706 | 100 | 283 | 383 | 90 | 5 | 2023-08-02 | 2401.05 | 60.03 | 2023-07-21 | 4 | 605.65 | 1 | 2401.05 | 24 | SO50703 | 2023-07-28 | 192.08 | 2422.60 | 600.26 | |||
SO43900_2 | 1593-4BBA-9B | PO5568199700 | 100 | 285 | 219 | 422 | 5 | 2021-10-02 | 22.80 | 0.57 | 2021-09-20 | 4 | 3.40 | 1 | 22.80 | 2 | SO43900 | 2021-09-27 | 1.82 | 13.59 | 5.70 | |||
SO45801_5 | 588D-487D-A4 | PO10179161655 | 100 | 285 | 218 | 27 | 5 | 2022-06-02 | 45.60 | 1.14 | 2022-05-21 | 8 | 3.40 | 1 | 45.60 | 5 | SO45801 | 2022-05-28 | 3.65 | 27.17 | 5.70 | |||
SO69394_19 | A04D-4E1B-B4 | PO19546195663 | 100 | 285 | 376 | 206 | 5 | 2024-07-02 | 2932.02 | 73.30 | 2024-06-20 | 2 | 1554.95 | 1 | 2932.02 | 19 | SO69394 | 2024-06-27 | 234.56 | 3109.90 | 1466.01 | |||
SO71802_15 | 6B80-41A7-89 | PO15457184141 | 100 | 285 | 571 | 297 | 5 | 2024-08-02 | 890.82 | 22.27 | 2024-07-21 | 2 | 461.44 | 1 | 890.82 | 15 | SO71802 | 2024-07-28 | 71.27 | 922.89 | 445.41 | |||
SO46672_21 | FFCF-4848-99 | PO9831178966 | 100 | 285 | 245 | 81 | 5 | 2022-09-01 | 780.82 | 19.52 | 2022-08-20 | 1 | 722.26 | 1 | 780.82 | 21 | SO46672 | 2022-08-27 | 62.47 | 722.26 | 780.82 | |||
SO49091_15 | 7A94-486D-8A | PO19546118667 | 100 | 285 | 375 | 206 | 5 | 2023-04-04 | 3926.81 | 98.17 | 2023-03-23 | 3 | 1320.68 | 1 | 3926.81 | 15 | SO49091 | 2023-03-30 | 314.15 | 3962.05 | 1308.94 | |||
SO61230_24 | B9F1-4FF8-B4 | PO12644163346 | 100 | 285 | 544 | 530 | 5 | 2024-03-03 | 48.59 | 1.21 | 2024-02-20 | 1 | 35.96 | 1 | 48.59 | 24 | SO61230 | 2024-02-27 | 3.89 | 35.96 | 48.59 | |||
SO46971_3 | 5CEA-463B-A2 | PO15051144269 | 100 | 285 | 420 | 207 | 5 | 2022-10-02 | 141.62 | 3.54 | 2022-09-20 | 1 | 104.80 | 1 | 141.62 | 3 | SO46971 | 2022-09-27 | 11.33 | 104.80 | 141.62 | |||
SO49865_32 | E9A6-42D3-91 | PO9831136904 | 100 | 285 | 445 | 81 | 5 | 2023-06-02 | 107.98 | 2.70 | 2023-05-21 | 3 | 24.75 | 1 | 107.98 | 32 | SO49865 | 2023-05-28 | 8.64 | 74.24 | 35.99 | |||
SO46604_25 | 8062-4A97-B3 | PO522154989 | 100 | 285 | 458 | 676 | 5 | 2022-09-01 | 134.98 | 3.37 | 2022-08-20 | 3 | 30.93 | 1 | 134.98 | 25 | SO46604 | 2022-08-27 | 10.80 | 92.80 | 44.99 | |||
SO45805_3 | 4E35-406B-B7 | PO3393138494 | 100 | 285 | 313 | 549 | 5 | 2022-06-02 | 2146.96 | 53.67 | 2022-05-21 | 1 | 2171.29 | 1 | 2146.96 | 3 | SO45805 | 2022-05-28 | 171.76 | 2171.29 | 2146.96 | |||
SO46045_3 | 9345-48CB-A5 | PO16327127643 | 100 | 285 | 264 | 584 | 5 | 2022-07-02 | 367.88 | 9.20 | 2022-06-20 | 2 | 181.49 | 1 | 367.88 | 3 | SO46045 | 2022-06-27 | 29.43 | 362.97 | 183.94 | |||
SO69533_16 | AC2B-4C39-84 | PO3596133486 | 100 | 285 | 400 | 476 | 5 | 2024-07-02 | 74.30 | 1.86 | 2024-06-20 | 2 | 27.49 | 1 | 74.30 | 16 | SO69533 | 2024-06-27 | 5.94 | 54.99 | 37.15 | |||
SO44506_28 | CD67-4B07-B6 | PO16327113845 | 100 | 285 | 330 | 584 | 5 | 2022-01-02 | 1258.38 | 31.46 | 2021-12-21 | 3 | 413.15 | 1 | 1258.38 | 28 | SO44506 | 2021-12-28 | 100.67 | 1239.44 | 419.46 | |||
SO51705_14 | DFFB-4C23-BD | PO16965171069 | 100 | 285 | 491 | 441 | 5 | 2023-10-02 | 129.58 | 3.24 | 2023-09-20 | 4 | 41.57 | 1 | 129.58 | 14 | SO51705 | 2023-09-27 | 10.37 | 166.29 | 32.39 | |||
SO51853_3 | 3754-4D33-92 | PO3596145757 | 100 | 285 | 357 | 476 | 5 | 2023-10-02 | 2783.99 | 69.60 | 2023-09-20 | 2 | 1265.62 | 1 | 2783.99 | 3 | SO51853 | 2023-09-27 | 222.72 | 2531.24 | 1391.99 | |||
SO47042_28 | 42DB-4E2E-B9 | PO5858114009 | 100 | 285 | 354 | 566 | 5 | 2022-10-02 | 2485.70 | 62.14 | 2022-09-20 | 2 | 1117.86 | 1 | 2485.70 | 28 | SO47042 | 2022-09-27 | 198.86 | 2235.71 | 1242.85 | |||
SO51760_1 | 2C2D-41C9-8C | PO9918180623 | 100 | 285 | 509 | 260 | 5 | 2023-10-02 | 400.10 | 10.00 | 2023-09-20 | 2 | 199.85 | 1 | 400.10 | 1 | SO51760 | 2023-09-27 | 32.01 | 399.70 | 200.05 | |||
SO47455_35 | 41F3-48C2-B7 | PO9599169586 | 100 | 285 | 435 | 170 | 5 | 2022-11-02 | 1297.81 | 32.45 | 2022-10-21 | 4 | 300.12 | 1 | 1297.81 | 35 | SO47455 | 2022-10-28 | 103.82 | 1200.48 | 324.45 | |||
SO49836_22 | 0E32-48F7-89 | PO12644185975 | 100 | 285 | 409 | 530 | 5 | 2023-06-02 | 209.26 | 5.23 | 2023-05-21 | 1 | 185.82 | 1 | 209.26 | 22 | SO49836 | 2023-05-28 | 16.74 | 185.82 | 209.26 | |||
SO51107_2 | F39A-4F8D-98 | PO12615118267 | 100 | 285 | 533 | 440 | 5 | 2023-09-01 | 149.87 | 3.75 | 2023-08-20 | 1 | 136.79 | 1 | 149.87 | 2 | SO51107 | 2023-08-27 | 11.99 | 136.79 | 149.87 | |||
SO45796_7 | 8929-4623-95 | PO11861125955 | 100 | 281 | 351 | 17 | 5 | 2022-06-02 | 8099.98 | 202.50 | 2022-05-21 | 4 | 1898.09 | 1 | 8099.98 | 7 | SO45796 | 2022-05-28 | 648.00 | 7592.38 | 2024.99 | |||
SO63235_1 | 2F82-44A0-A0 | PO5568158964 | 100 | 285 | 359 | 422 | 5 | 2024-04-03 | 2753.99 | 68.85 | 2024-03-22 | 2 | 1251.98 | 1 | 2753.99 | 1 | SO63235 | 2024-03-29 | 220.32 | 2503.96 | 1376.99 | |||
SO49865_35 | E9A6-42D3-91 | PO9831136904 | 100 | 285 | 333 | 81 | 5 | 2023-06-02 | 1879.18 | 46.98 | 2023-05-21 | 4 | 486.71 | 1 | 1879.18 | 35 | SO49865 | 2023-05-28 | 150.33 | 1946.83 | 469.79 | |||
SO48343_3 | CE23-40B4-B6 | PO435176110 | 100 | 285 | 273 | 651 | 5 | 2023-02-01 | 404.66 | 10.12 | 2023-01-20 | 2 | 187.16 | 1 | 404.66 | 3 | SO48343 | 2023-01-27 | 32.37 | 374.31 | 202.33 | |||
SO53530_16 | A31D-483D-A1 | PO2813121313 | 100 | 283 | 214 | 2 | 90 | 5 | 5.68 | 2023-11-02 | 284.12 | 6.96 | 2023-10-21 | 14 | 13.09 | 1 | 278.44 | 16 | SO53530 | 2023-10-28 | 22.27 | 183.21 | 20.29 | 0.02 |
SO49865_27 | E9A6-42D3-91 | PO9831136904 | 100 | 285 | 213 | 81 | 5 | 2023-06-02 | 60.56 | 1.51 | 2023-05-21 | 3 | 13.88 | 1 | 60.56 | 27 | SO49865 | 2023-05-28 | 4.84 | 41.63 | 20.19 | |||
SO71844_20 | 410D-4079-9E | PO2813198985 | 100 | 283 | 580 | 90 | 5 | 2024-08-02 | 7144.16 | 178.60 | 2024-07-21 | 7 | 1082.51 | 1 | 7144.16 | 20 | SO71844 | 2024-07-28 | 571.53 | 7577.57 | 1020.59 | |||
SO45815_8 | 80EF-464E-97 | PO9657174967 | 100 | 285 | 296 | 315 | 5 | 2022-06-02 | 1429.41 | 35.74 | 2022-05-21 | 2 | 617.03 | 1 | 1429.41 | 8 | SO45815 | 2022-05-28 | 114.35 | 1234.06 | 714.70 | |||
SO49149_30 | D41E-4EFF-A5 | PO5858123072 | 100 | 285 | 459 | 566 | 5 | 2023-04-04 | 53.99 | 1.35 | 2023-03-23 | 1 | 37.12 | 1 | 53.99 | 30 | SO49149 | 2023-03-30 | 4.32 | 37.12 | 53.99 | |||
SO47026_7 | 123B-481F-8F | PO3596190739 | 100 | 285 | 409 | 476 | 5 | 2022-10-02 | 418.51 | 10.46 | 2022-09-20 | 2 | 185.82 | 1 | 418.51 | 7 | SO47026 | 2022-09-27 | 33.48 | 371.64 | 209.26 | |||
SO71844_3 | 410D-4079-9E | PO2813198985 | 100 | 283 | 465 | 2 | 90 | 5 | 3.41 | 2024-08-02 | 170.45 | 4.18 | 2024-07-21 | 12 | 9.16 | 1 | 167.04 | 3 | SO71844 | 2024-07-28 | 13.36 | 109.91 | 14.20 | 0.02 |
SO45331_14 | 4702-48B5-B8 | PO6293165974 | 100 | 285 | 312 | 612 | 5 | 2022-04-04 | 2146.96 | 53.67 | 2022-03-23 | 1 | 2171.29 | 1 | 2146.96 | 14 | SO45331 | 2022-03-30 | 171.76 | 2171.29 | 2146.96 | |||
SO45340_1 | 9ADF-4A2D-B6 | PO7714194147 | 100 | 285 | 319 | 495 | 5 | 2022-04-04 | 874.79 | 21.87 | 2022-03-23 | 1 | 884.71 | 1 | 874.79 | 1 | SO45340 | 2022-03-30 | 69.98 | 884.71 | 874.79 | |||
SO43659_5 | 4911-403C-98 | PO522145787 | 100 | 285 | 345 | 676 | 5 | 2021-09-01 | 2039.99 | 51.00 | 2021-08-20 | 1 | 1912.15 | 1 | 2039.99 | 5 | SO43659 | 2021-08-27 | 163.20 | 1912.15 | 2039.99 | |||
SO59076_5 | 6CC1-43A5-AC | PO9744156348 | 100 | 285 | 475 | 98 | 5 | 2024-02-01 | 41.99 | 1.05 | 2024-01-20 | 1 | 26.18 | 1 | 41.99 | 5 | SO59076 | 2024-01-27 | 3.36 | 26.18 | 41.99 | |||
SO45331_1 | 4702-48B5-B8 | PO6293165974 | 100 | 285 | 313 | 612 | 5 | 2022-04-04 | 2146.96 | 53.67 | 2022-03-23 | 1 | 2171.29 | 1 | 2146.96 | 1 | SO45331 | 2022-03-30 | 171.76 | 2171.29 | 2146.96 | |||
SO53524_16 | 2B2B-440F-8B | PO1537151724 | 100 | 285 | 214 | 611 | 5 | 2023-11-02 | 125.96 | 3.15 | 2023-10-21 | 6 | 13.09 | 1 | 125.96 | 16 | SO53524 | 2023-10-28 | 10.08 | 78.52 | 20.99 | |||
SO71821_4 | 3D95-45AC-A2 | PO11977190694 | 100 | 285 | 240 | 675 | 5 | 2024-08-02 | 858.90 | 21.47 | 2024-07-21 | 1 | 868.63 | 1 | 858.90 | 4 | SO71821 | 2024-07-28 | 68.71 | 868.63 | 858.90 | |||
SO48063_27 | AEA4-4489-90 | PO5858143254 | 100 | 285 | 354 | 566 | 5 | 2023-01-02 | 6214.26 | 155.36 | 2022-12-21 | 5 | 1117.86 | 1 | 6214.26 | 27 | SO48063 | 2022-12-28 | 497.14 | 5589.28 | 1242.85 | |||
SO63130_5 | EE88-4C2F-98 | PO18560122888 | 100 | 285 | 471 | 531 | 5 | 2024-04-03 | 76.20 | 1.91 | 2024-03-22 | 2 | 23.75 | 1 | 76.20 | 5 | SO63130 | 2024-03-29 | 6.10 | 47.50 | 38.10 | |||
SO46345_5 | 469D-4520-80 | PO13746192187 | 100 | 285 | 351 | 7 | 567 | 5 | 590.62 | 2022-08-02 | 1687.50 | 27.42 | 2022-07-21 | 2 | 1898.09 | 1 | 1096.87 | 5 | SO46345 | 2022-07-28 | 87.75 | 3796.19 | 843.75 | 0.35 |
SO61173_6 | 6B8D-47B8-8E | PO522171689 | 100 | 285 | 589 | 676 | 5 | 2024-03-03 | 461.69 | 11.54 | 2024-02-20 | 1 | 419.78 | 1 | 461.69 | 6 | SO61173 | 2024-02-27 | 36.94 | 419.78 | 461.69 | |||
SO50231_26 | B2CA-498D-9B | PO11571129150 | 100 | 285 | 381 | 512 | 5 | 2023-07-02 | 1800.79 | 45.02 | 2023-06-20 | 3 | 605.65 | 1 | 1800.79 | 26 | SO50231 | 2023-06-27 | 144.06 | 1816.95 | 600.26 | |||
SO47454_18 | E249-41EE-95 | PO9570119946 | 100 | 285 | 360 | 585 | 5 | 2022-11-02 | 4917.84 | 122.95 | 2022-10-21 | 4 | 1105.81 | 1 | 4917.84 | 18 | SO47454 | 2022-10-28 | 393.43 | 4423.24 | 1229.46 | |||
SO47416_38 | 6B45-44AB-84 | PO2813155355 | 100 | 281 | 466 | 90 | 5 | 2022-11-02 | 42.39 | 1.06 | 2022-10-21 | 3 | 9.71 | 1 | 42.39 | 38 | SO47416 | 2022-10-28 | 3.39 | 29.14 | 14.13 |
Generated 2024-09-19 21:07:56.398 UTC