[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > SKIP 500 SHUFFLE SKIP 2593 SKIP 0 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46996_4 | 775B-42D6-A5 | PO11571149031 | 100 | 285 | 381 | 512 | 5 | 2022-10-04 | 1200.53 | 30.01 | 2022-09-22 | 2 | 605.65 | 1 | 1200.53 | 4 | SO46996 | 2022-09-29 | 96.04 | 1211.30 | 600.26 | |||
SO48393_8 | 5B6A-41B6-BF | PO9599137631 | 100 | 285 | 331 | 170 | 5 | 2023-02-03 | 1409.38 | 35.23 | 2023-01-22 | 3 | 486.71 | 1 | 1409.38 | 8 | SO48393 | 2023-01-29 | 112.75 | 1460.12 | 469.79 | |||
SO51816_5 | 415B-4D48-B0 | PO6293129251 | 100 | 285 | 382 | 612 | 5 | 2023-10-04 | 672.29 | 16.81 | 2023-09-22 | 1 | 713.08 | 1 | 672.29 | 5 | SO51816 | 2023-09-29 | 53.78 | 713.08 | 672.29 | |||
SO45337_1 | C8D2-41D4-AF | PO7598166612 | 100 | 285 | 326 | 45 | 5 | 2022-04-06 | 838.92 | 20.97 | 2022-03-25 | 2 | 413.15 | 1 | 838.92 | 1 | SO45337 | 2022-04-01 | 67.11 | 826.29 | 419.46 | |||
SO71844_28 | 410D-4079-9E | PO2813198985 | 100 | 283 | 483 | 2 | 90 | 5 | 19.49 | 2024-08-04 | 974.40 | 23.87 | 2024-07-23 | 14 | 44.88 | 1 | 954.91 | 28 | SO71844 | 2024-07-30 | 76.39 | 628.32 | 69.60 | 0.02 |
SO65207_21 | B20E-440F-A3 | PO1537156240 | 100 | 285 | 506 | 611 | 5 | 2024-05-04 | 400.10 | 10.00 | 2024-04-22 | 2 | 199.85 | 1 | 400.10 | 21 | SO65207 | 2024-04-29 | 32.01 | 399.70 | 200.05 | |||
SO48063_43 | AEA4-4489-90 | PO5858143254 | 100 | 285 | 447 | 566 | 5 | 2023-01-04 | 30.00 | 0.75 | 2022-12-23 | 2 | 10.31 | 1 | 30.00 | 43 | SO48063 | 2022-12-30 | 2.40 | 20.63 | 15.00 | |||
SO48395_18 | 46D3-4C51-AD | PO9570174316 | 100 | 285 | 460 | 585 | 5 | 2023-02-03 | 269.97 | 6.75 | 2023-01-22 | 5 | 37.12 | 1 | 269.97 | 18 | SO48395 | 2023-01-29 | 21.60 | 185.60 | 53.99 | |||
SO61230_18 | B9F1-4FF8-B4 | PO12644163346 | 100 | 285 | 363 | 530 | 5 | 2024-03-05 | 1376.99 | 34.42 | 2024-02-22 | 1 | 1251.98 | 1 | 1376.99 | 18 | SO61230 | 2024-02-29 | 110.16 | 1251.98 | 1376.99 | |||
SO47416_51 | 6B45-44AB-84 | PO2813155355 | 100 | 281 | 280 | 90 | 5 | 2022-11-04 | 919.69 | 22.99 | 2022-10-23 | 5 | 170.14 | 1 | 919.69 | 51 | SO47416 | 2022-10-30 | 73.58 | 850.71 | 183.94 | |||
SO49509_1 | 1105-4F75-BE | PO9599181538 | 100 | 285 | 379 | 170 | 5 | 2023-05-04 | 5235.75 | 130.89 | 2023-04-22 | 4 | 1320.68 | 1 | 5235.75 | 1 | SO49509 | 2023-04-29 | 418.86 | 5282.74 | 1308.94 | |||
SO67349_25 | 7BC2-4E87-BA | PO9831186318 | 100 | 285 | 434 | 81 | 5 | 2024-06-04 | 356.90 | 8.92 | 2024-05-23 | 1 | 360.94 | 1 | 356.90 | 25 | SO67349 | 2024-05-30 | 28.55 | 360.94 | 356.90 | |||
SO63245_10 | 1025-4AD1-A1 | PO5800120355 | 100 | 285 | 355 | 63 | 5 | 2024-04-05 | 1391.99 | 34.80 | 2024-03-24 | 1 | 1265.62 | 1 | 1391.99 | 10 | SO63245 | 2024-03-31 | 111.36 | 1265.62 | 1391.99 | |||
SO71821_1 | 3D95-45AC-A2 | PO11977190694 | 100 | 285 | 408 | 675 | 5 | 2024-08-04 | 288.65 | 7.22 | 2024-07-23 | 4 | 53.40 | 1 | 288.65 | 1 | SO71821 | 2024-07-30 | 23.09 | 213.60 | 72.16 | |||
SO69518_22 | 96AA-48F8-80 | PO5800191682 | 100 | 285 | 398 | 63 | 5 | 2024-07-04 | 26.72 | 0.67 | 2024-06-22 | 1 | 19.78 | 1 | 26.72 | 22 | SO69518 | 2024-06-29 | 2.14 | 19.78 | 26.72 | |||
SO45077_1 | 4002-46AC-B7 | PO10179199539 | 100 | 285 | 349 | 27 | 5 | 2022-03-06 | 4049.99 | 101.25 | 2022-02-22 | 2 | 1898.09 | 1 | 4049.99 | 1 | SO45077 | 2022-03-01 | 324.00 | 3796.19 | 2024.99 | |||
SO47681_24 | 0580-4A09-A8 | PO12644124767 | 100 | 285 | 221 | 530 | 5 | 2022-12-04 | 60.56 | 1.51 | 2022-11-22 | 3 | 13.88 | 1 | 60.56 | 24 | SO47681 | 2022-11-29 | 4.84 | 41.63 | 20.19 | |||
SO47693_31 | 3962-4A1A-93 | PO522165713 | 100 | 285 | 448 | 676 | 5 | 2022-12-04 | 23.99 | 0.60 | 2022-11-22 | 2 | 8.25 | 1 | 23.99 | 31 | SO47693 | 2022-11-29 | 1.92 | 16.49 | 11.99 | |||
SO51816_4 | 415B-4D48-B0 | PO6293129251 | 100 | 285 | 243 | 612 | 5 | 2023-10-04 | 858.90 | 21.47 | 2023-09-22 | 1 | 868.63 | 1 | 858.90 | 4 | SO51816 | 2023-09-29 | 68.71 | 868.63 | 858.90 | |||
SO46943_1 | 6F43-4A10-80 | PO18560122957 | 100 | 285 | 263 | 531 | 5 | 2022-10-04 | 809.33 | 20.23 | 2022-09-22 | 4 | 187.16 | 1 | 809.33 | 1 | SO46943 | 2022-09-29 | 64.75 | 748.63 | 202.33 | |||
SO51824_37 | A1F7-477E-BA | PO5800114202 | 100 | 285 | 552 | 63 | 5 | 2023-10-04 | 219.58 | 5.49 | 2023-09-22 | 4 | 40.62 | 1 | 219.58 | 37 | SO51824 | 2023-09-29 | 17.57 | 162.49 | 54.89 | |||
SO69394_13 | A04D-4E1B-B4 | PO19546195663 | 100 | 285 | 604 | 206 | 5 | 2024-07-04 | 323.99 | 8.10 | 2024-06-22 | 1 | 343.65 | 1 | 323.99 | 13 | SO69394 | 2024-06-29 | 25.92 | 343.65 | 323.99 | |||
SO49865_23 | E9A6-42D3-91 | PO9831136904 | 100 | 285 | 263 | 81 | 5 | 2023-06-04 | 809.33 | 20.23 | 2023-05-23 | 4 | 187.16 | 1 | 809.33 | 23 | SO49865 | 2023-05-30 | 64.75 | 748.63 | 202.33 | |||
SO50306_23 | D376-4A40-86 | PO5858194676 | 100 | 285 | 356 | 566 | 5 | 2023-07-04 | 3728.56 | 93.21 | 2023-06-22 | 3 | 1117.86 | 1 | 3728.56 | 23 | SO50306 | 2023-06-29 | 298.28 | 3353.57 | 1242.85 | |||
SO47416_8 | 6B45-44AB-84 | PO2813155355 | 100 | 281 | 325 | 2 | 90 | 5 | 108.99 | 2022-11-04 | 5449.61 | 133.52 | 2022-10-23 | 12 | 486.71 | 1 | 5340.62 | 8 | SO47416 | 2022-10-30 | 427.25 | 5840.48 | 454.13 | 0.02 |
SO51780_23 | 30C4-4B8F-AA | PO18560115626 | 100 | 285 | 222 | 531 | 5 | 2023-10-04 | 83.98 | 2.10 | 2023-09-22 | 4 | 13.09 | 1 | 83.98 | 23 | SO51780 | 2023-09-29 | 6.72 | 52.35 | 20.99 | |||
SO69419_5 | 09D7-42E3-8E | PO15051119574 | 100 | 285 | 475 | 207 | 5 | 2024-07-04 | 167.98 | 4.20 | 2024-06-22 | 4 | 26.18 | 1 | 167.98 | 5 | SO69419 | 2024-06-29 | 13.44 | 104.71 | 41.99 | |||
SO47682_1 | 685F-4FCA-A2 | PO12615189875 | 100 | 285 | 421 | 440 | 5 | 2022-12-04 | 196.33 | 4.91 | 2022-11-22 | 1 | 145.28 | 1 | 196.33 | 1 | SO47682 | 2022-11-29 | 15.71 | 145.28 | 196.33 | |||
SO47993_8 | 48A5-4EA7-AE | PO15051142366 | 100 | 285 | 469 | 207 | 5 | 2023-01-04 | 45.59 | 1.14 | 2022-12-23 | 2 | 15.67 | 1 | 45.59 | 8 | SO47993 | 2022-12-30 | 3.65 | 31.34 | 22.79 | |||
SO63190_1 | 9392-46BC-92 | PO18734125624 | 100 | 283 | 512 | 449 | 5 | 2024-04-05 | 218.45 | 5.46 | 2024-03-24 | 1 | 199.38 | 1 | 218.45 | 1 | SO63190 | 2024-03-31 | 17.48 | 199.38 | 218.45 | |||
SO51693_26 | 6FEB-4D5B-92 | PO19546179477 | 100 | 285 | 436 | 206 | 5 | 2023-10-04 | 713.80 | 17.84 | 2023-09-22 | 2 | 360.94 | 1 | 713.80 | 26 | SO51693 | 2023-09-29 | 57.10 | 721.89 | 356.90 | |||
SO53474_26 | E5B6-4103-8D | PO15457187993 | 100 | 285 | 585 | 13 | 297 | 5 | 50.11 | 2023-11-04 | 334.06 | 7.10 | 2023-10-23 | 1 | 461.44 | 1 | 283.95 | 26 | SO53474 | 2023-10-30 | 22.72 | 461.44 | 334.06 | 0.15 |
SO49524_2 | 62E9-414A-91 | PO4089179431 | 100 | 285 | 360 | 368 | 5 | 2023-05-04 | 2458.92 | 61.47 | 2023-04-22 | 2 | 1105.81 | 1 | 2458.92 | 2 | SO49524 | 2023-04-29 | 196.71 | 2211.62 | 1229.46 | |||
SO49149_36 | D41E-4EFF-A5 | PO5858123072 | 100 | 285 | 420 | 566 | 5 | 2023-04-06 | 283.23 | 7.08 | 2023-03-25 | 2 | 104.80 | 1 | 283.23 | 36 | SO49149 | 2023-04-01 | 22.66 | 209.59 | 141.62 | |||
SO51137_27 | A47F-4FEF-94 | PO9889144162 | 100 | 285 | 590 | 494 | 5 | 2023-09-03 | 461.69 | 11.54 | 2023-08-22 | 1 | 419.78 | 1 | 461.69 | 27 | SO51137 | 2023-08-29 | 36.94 | 419.78 | 461.69 | |||
SO44801_1 | 4DBD-4E98-A7 | PO9599152040 | 100 | 285 | 318 | 170 | 5 | 2022-02-03 | 874.79 | 21.87 | 2022-01-22 | 1 | 884.71 | 1 | 874.79 | 1 | SO44801 | 2022-01-29 | 69.98 | 884.71 | 874.79 | |||
SO63181_20 | CB4E-4CF5-87 | PO2842135731 | 100 | 285 | 380 | 700 | 5 | 2024-04-05 | 1466.01 | 36.65 | 2024-03-24 | 1 | 1554.95 | 1 | 1466.01 | 20 | SO63181 | 2024-03-31 | 117.28 | 1554.95 | 1466.01 | |||
SO49149_26 | D41E-4EFF-A5 | PO5858123072 | 100 | 285 | 294 | 566 | 5 | 2023-04-06 | 1488.55 | 37.21 | 2023-03-25 | 2 | 660.91 | 1 | 1488.55 | 26 | SO49149 | 2023-04-01 | 119.08 | 1321.83 | 744.27 | |||
SO65220_22 | 6D87-4C24-98 | PO15457146892 | 100 | 285 | 217 | 297 | 5 | 2024-05-04 | 20.99 | 0.52 | 2024-04-22 | 1 | 13.09 | 1 | 20.99 | 22 | SO65220 | 2024-04-29 | 1.68 | 13.09 | 20.99 | |||
SO65207_30 | B20E-440F-A3 | PO1537156240 | 100 | 285 | 561 | 611 | 5 | 2024-05-04 | 7152.21 | 178.81 | 2024-04-22 | 5 | 1481.94 | 1 | 7152.21 | 30 | SO65207 | 2024-04-29 | 572.18 | 7409.69 | 1430.44 | |||
SO47455_25 | 41F3-48C2-B7 | PO9599169586 | 100 | 285 | 459 | 170 | 5 | 2022-11-04 | 53.99 | 1.35 | 2022-10-23 | 1 | 37.12 | 1 | 53.99 | 25 | SO47455 | 2022-10-30 | 4.32 | 37.12 | 53.99 | |||
SO58971_4 | 319A-4CAC-B1 | PO1537134870 | 100 | 285 | 477 | 611 | 5 | 2024-02-03 | 14.97 | 0.37 | 2024-01-22 | 5 | 1.87 | 1 | 14.97 | 4 | SO58971 | 2024-01-29 | 1.20 | 9.33 | 2.99 | |||
SO65242_3 | 0175-4222-B3 | PO14297142992 | 100 | 285 | 565 | 627 | 5 | 2024-05-04 | 445.41 | 11.14 | 2024-04-22 | 1 | 461.44 | 1 | 445.41 | 3 | SO65242 | 2024-04-29 | 35.63 | 461.44 | 445.41 | |||
SO58971_36 | 319A-4CAC-B1 | PO1537134870 | 100 | 285 | 217 | 2 | 611 | 5 | 5.68 | 2024-02-03 | 284.12 | 6.96 | 2024-01-22 | 14 | 13.09 | 1 | 278.44 | 36 | SO58971 | 2024-01-29 | 22.27 | 183.21 | 20.29 | 0.02 |
SO47725_34 | 2501-4A1D-99 | PO9831133395 | 100 | 285 | 433 | 81 | 5 | 2022-12-04 | 648.91 | 16.22 | 2022-11-22 | 2 | 300.12 | 1 | 648.91 | 34 | SO47725 | 2022-11-29 | 51.91 | 600.24 | 324.45 | |||
SO46383_2 | 2398-4D5E-8F | PO9106128085 | 100 | 285 | 344 | 7 | 602 | 5 | 595.00 | 2022-08-04 | 1700.00 | 27.62 | 2022-07-23 | 2 | 1912.15 | 1 | 1105.00 | 2 | SO46383 | 2022-07-30 | 88.40 | 3824.31 | 850.00 | 0.35 |
SO58974_20 | FB64-4792-81 | PO2813115918 | 100 | 283 | 482 | 90 | 5 | 2024-02-03 | 16.18 | 0.40 | 2024-01-22 | 3 | 3.36 | 1 | 16.18 | 20 | SO58974 | 2024-01-29 | 1.29 | 10.09 | 5.39 | |||
SO49133_4 | 50D5-4F65-92 | PO9512136037 | 100 | 285 | 343 | 135 | 5 | 2023-04-06 | 1409.38 | 35.23 | 2023-03-25 | 3 | 486.71 | 1 | 1409.38 | 4 | SO49133 | 2023-04-01 | 112.75 | 1460.12 | 469.79 | |||
SO44801_24 | 4DBD-4E98-A7 | PO9599152040 | 100 | 285 | 262 | 170 | 5 | 2022-02-03 | 367.88 | 9.20 | 2022-01-22 | 2 | 181.49 | 1 | 367.88 | 24 | SO44801 | 2022-01-29 | 29.43 | 362.97 | 183.94 | |||
SO47693_33 | 3962-4A1A-93 | PO522165713 | 100 | 285 | 216 | 676 | 5 | 2022-12-04 | 40.37 | 1.01 | 2022-11-22 | 2 | 13.88 | 1 | 40.37 | 33 | SO47693 | 2022-11-29 | 3.23 | 27.76 | 20.19 | |||
SO46091_7 | 6DCB-4063-BA | PO6293193126 | 100 | 285 | 313 | 612 | 5 | 2022-07-04 | 2146.96 | 53.67 | 2022-06-22 | 1 | 2171.29 | 1 | 2146.96 | 7 | SO46091 | 2022-06-29 | 171.76 | 2171.29 | 2146.96 | |||
SO49865_37 | E9A6-42D3-91 | PO9831136904 | 100 | 285 | 224 | 81 | 5 | 2023-06-04 | 31.12 | 0.78 | 2023-05-23 | 6 | 5.23 | 1 | 31.12 | 37 | SO49865 | 2023-05-30 | 2.49 | 31.38 | 5.19 | |||
SO53524_9 | 2B2B-440F-8B | PO1537151724 | 100 | 285 | 487 | 2 | 611 | 5 | 7.65 | 2023-11-04 | 382.73 | 9.38 | 2023-10-23 | 12 | 20.57 | 1 | 375.08 | 9 | SO53524 | 2023-10-30 | 30.01 | 246.80 | 31.89 | 0.02 |
SO51853_8 | 3754-4D33-92 | PO3596145757 | 100 | 285 | 592 | 476 | 5 | 2023-10-04 | 338.99 | 8.47 | 2023-09-22 | 1 | 308.22 | 1 | 338.99 | 8 | SO51853 | 2023-09-29 | 27.12 | 308.22 | 338.99 | |||
SO48792_1 | F238-4277-97 | PO9976183547 | 100 | 285 | 339 | 242 | 5 | 2023-03-06 | 469.79 | 11.74 | 2023-02-22 | 1 | 486.71 | 1 | 469.79 | 1 | SO48792 | 2023-03-01 | 37.58 | 486.71 | 469.79 | |||
SO69465_5 | B8B2-4B14-99 | PO2842153886 | 100 | 285 | 547 | 700 | 5 | 2024-07-04 | 145.78 | 3.64 | 2024-06-22 | 3 | 35.96 | 1 | 145.78 | 5 | SO69465 | 2024-06-29 | 11.66 | 107.88 | 48.59 | |||
SO57118_16 | 69CB-481B-8D | PO5800191707 | 100 | 285 | 544 | 63 | 5 | 2024-01-04 | 194.38 | 4.86 | 2023-12-23 | 4 | 35.96 | 1 | 194.38 | 16 | SO57118 | 2023-12-30 | 15.55 | 143.84 | 48.59 | |||
SO47726_7 | 7256-4599-93 | PO9657190563 | 100 | 285 | 421 | 315 | 5 | 2022-12-04 | 588.99 | 14.72 | 2022-11-22 | 3 | 145.28 | 1 | 588.99 | 7 | SO47726 | 2022-11-29 | 47.12 | 435.85 | 196.33 | |||
SO51137_30 | A47F-4FEF-94 | PO9889144162 | 100 | 285 | 551 | 494 | 5 | 2023-09-03 | 158.43 | 3.96 | 2023-08-22 | 1 | 144.59 | 1 | 158.43 | 30 | SO51137 | 2023-08-29 | 12.67 | 144.59 | 158.43 | |||
SO53625_7 | 98EA-458A-B9 | PO9744185498 | 100 | 285 | 511 | 98 | 5 | 2023-11-04 | 436.91 | 10.92 | 2023-10-23 | 2 | 199.38 | 1 | 436.91 | 7 | SO53625 | 2023-10-30 | 34.95 | 398.75 | 218.45 | |||
SO48766_17 | A56F-4A7B-AD | PO9831126274 | 100 | 285 | 221 | 81 | 5 | 2023-03-06 | 60.56 | 1.51 | 2023-02-22 | 3 | 13.88 | 1 | 60.56 | 17 | SO48766 | 2023-03-01 | 4.84 | 41.63 | 20.19 | |||
SO57175_1 | 8997-4142-90 | PO7714123713 | 100 | 285 | 580 | 495 | 5 | 2024-01-04 | 1020.59 | 25.51 | 2023-12-23 | 1 | 1082.51 | 1 | 1020.59 | 1 | SO57175 | 2023-12-30 | 81.65 | 1082.51 | 1020.59 |
Generated 2024-09-21 07:42:01.842 UTC