[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SKIP 2875 SHUFFLE < SKIP 1000 > < TAKE 31 >
31 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO67305_43 | CBB5-42BF-9E | PO16298111473 | 100 | 287 | 493 | 599 | 4 | 2024-06-03 | 1200.31 | 30.01 | 2024-05-22 | 6 | 199.85 | 1 | 1200.31 | 43 | SO67305 | 2024-05-29 | 96.03 | 1199.11 | 200.05 | |||
SO47027_1 | 1A9C-4166-A7 | PO3480112515 | 100 | 283 | 403 | 436 | 4 | 2022-10-03 | 97.18 | 2.43 | 2022-09-21 | 4 | 17.98 | 1 | 97.18 | 1 | SO47027 | 2022-09-28 | 7.77 | 71.91 | 24.29 | |||
SO65193_1 | 59C0-42E7-8F | PO13021128161 | 100 | 282 | 372 | 276 | 4 | 2024-05-03 | 1466.01 | 36.65 | 2024-04-21 | 1 | 1554.95 | 1 | 1466.01 | 1 | SO65193 | 2024-04-28 | 117.28 | 1554.95 | 1466.01 | |||
SO46668_45 | 6711-47BE-BF | PO7859142972 | 100 | 287 | 453 | 2 | 221 | 4 | 7.65 | 2022-09-02 | 382.74 | 9.38 | 2022-08-21 | 11 | 24.75 | 1 | 375.08 | 45 | SO46668 | 2022-08-28 | 30.01 | 272.20 | 34.79 | 0.02 |
SO57144_45 | 074E-478C-99 | PO3799111077 | 100 | 282 | 511 | 312 | 4 | 2024-01-03 | 436.91 | 10.92 | 2023-12-22 | 2 | 199.38 | 1 | 436.91 | 45 | SO57144 | 2023-12-29 | 34.95 | 398.75 | 218.45 | |||
SO50282_10 | 9C0C-42E0-B6 | PO6525160235 | 100 | 281 | 352 | 345 | 4 | 2023-07-03 | 2485.70 | 62.14 | 2023-06-21 | 2 | 1117.86 | 1 | 2485.70 | 10 | SO50282 | 2023-06-28 | 198.86 | 2235.71 | 1242.85 | |||
SO67287_19 | 3F1F-44DB-96 | PO10730119334 | 100 | 287 | 408 | 491 | 4 | 2024-06-03 | 288.65 | 7.22 | 2024-05-22 | 4 | 53.40 | 1 | 288.65 | 19 | SO67287 | 2024-05-29 | 23.09 | 213.60 | 72.16 | |||
SO53470_15 | 932B-41E0-AF | PO17052111209 | 100 | 282 | 553 | 420 | 4 | 2023-11-03 | 55.31 | 1.38 | 2023-10-22 | 2 | 20.46 | 1 | 55.31 | 15 | SO53470 | 2023-10-29 | 4.42 | 40.93 | 27.65 | |||
SO53606_45 | 6A19-463C-B7 | PO5539128997 | 100 | 282 | 592 | 61 | 4 | 2023-11-03 | 1355.98 | 33.90 | 2023-10-22 | 4 | 308.22 | 1 | 1355.98 | 45 | SO53606 | 2023-10-29 | 108.48 | 1232.87 | 338.99 | |||
SO50745_22 | 02DB-4CC5-85 | PO5539140407 | 100 | 282 | 362 | 61 | 4 | 2023-08-03 | 3688.38 | 92.21 | 2023-07-22 | 3 | 1105.81 | 1 | 3688.38 | 22 | SO50745 | 2023-07-29 | 295.07 | 3317.43 | 1229.46 | |||
SO71882_3 | D5D4-42D4-91 | PO5597123008 | 100 | 281 | 603 | 75 | 4 | 2024-08-03 | 145.79 | 3.64 | 2024-07-22 | 2 | 53.94 | 1 | 145.79 | 3 | SO71882 | 2024-07-29 | 11.66 | 107.88 | 72.89 | |||
SO71783_2 | 7E03-4B8A-BA | PO19343113609 | 100 | 282 | 546 | 24 | 4 | 2024-08-03 | 223.52 | 5.59 | 2024-07-22 | 6 | 27.57 | 1 | 223.52 | 2 | SO71783 | 2024-07-29 | 17.88 | 165.41 | 37.25 | |||
SO48071_25 | E6F7-41F8-92 | PO6525193011 | 100 | 283 | 396 | 345 | 4 | 2023-01-03 | 74.84 | 1.87 | 2022-12-22 | 1 | 55.38 | 1 | 74.84 | 25 | SO48071 | 2022-12-29 | 5.99 | 55.38 | 74.84 | |||
SO67273_8 | 9BAE-4E69-B9 | PO13688176638 | 100 | 282 | 559 | 475 | 4 | 2024-06-03 | 36.43 | 0.91 | 2024-05-22 | 3 | 8.99 | 1 | 36.43 | 8 | SO67273 | 2024-05-29 | 2.91 | 26.96 | 12.14 | |||
SO55256_11 | 686E-4D36-8B | PO12528136439 | 100 | 282 | 571 | 331 | 4 | 2023-12-03 | 445.41 | 11.14 | 2023-11-21 | 1 | 461.44 | 1 | 445.41 | 11 | SO55256 | 2023-11-28 | 35.63 | 461.44 | 445.41 | |||
SO65167_9 | D40C-4211-94 | PO18125182344 | 100 | 287 | 287 | 311 | 4 | 2024-05-03 | 202.33 | 5.06 | 2024-04-21 | 1 | 204.63 | 1 | 202.33 | 9 | SO65167 | 2024-04-28 | 16.19 | 204.63 | 202.33 | |||
SO44521_24 | E46D-4692-AC | PO12557171689 | 100 | 282 | 342 | 240 | 4 | 2022-01-03 | 838.92 | 20.97 | 2021-12-22 | 2 | 413.15 | 1 | 838.92 | 24 | SO44521 | 2021-12-29 | 67.11 | 826.29 | 419.46 | |||
SO69528_28 | 2644-4747-86 | PO6438163496 | 100 | 272 | 590 | 309 | 4 | 2024-07-03 | 461.69 | 11.54 | 2024-06-21 | 1 | 419.78 | 1 | 461.69 | 28 | SO69528 | 2024-06-28 | 36.94 | 419.78 | 461.69 | |||
SO57145_37 | 4C59-4193-B1 | PO3654153385 | 100 | 281 | 601 | 435 | 4 | 2024-01-03 | 32.39 | 0.81 | 2023-12-22 | 1 | 23.97 | 1 | 32.39 | 37 | SO57145 | 2023-12-29 | 2.59 | 23.97 | 32.39 | |||
SO55282_7 | A72A-4D3A-BA | PO16298125578 | 100 | 287 | 574 | 599 | 4 | 2023-12-03 | 12873.98 | 321.85 | 2023-11-21 | 9 | 1481.94 | 1 | 12873.98 | 7 | SO55282 | 2023-11-28 | 1029.92 | 13337.44 | 1430.44 | |||
SO50688_4 | C55C-41B0-92 | PO10701178438 | 100 | 282 | 448 | 133 | 4 | 2023-08-03 | 71.96 | 1.80 | 2023-07-22 | 6 | 8.25 | 1 | 71.96 | 4 | SO50688 | 2023-07-29 | 5.76 | 49.48 | 11.99 | |||
SO47438_17 | 69E0-4082-B4 | PO6757114691 | 100 | 283 | 360 | 21 | 4 | 2022-11-03 | 9835.67 | 245.89 | 2022-10-22 | 8 | 1105.81 | 1 | 9835.67 | 17 | SO47438 | 2022-10-29 | 786.85 | 8846.48 | 1229.46 | |||
SO48055_2 | 35B7-4279-8E | PO4698166117 | 100 | 282 | 422 | 528 | 4 | 2023-01-03 | 135.08 | 3.38 | 2022-12-22 | 2 | 49.98 | 1 | 135.08 | 2 | SO48055 | 2022-12-29 | 10.81 | 99.96 | 67.54 | |||
SO44314_17 | 6FDF-4206-A7 | PO5626111923 | 100 | 283 | 279 | 166 | 4 | 2021-12-03 | 178.58 | 4.46 | 2021-11-21 | 1 | 176.20 | 1 | 178.58 | 17 | SO44314 | 2021-11-28 | 14.29 | 176.20 | 178.58 | |||
SO55303_24 | 5C9C-4B35-B8 | PO5626137276 | 100 | 281 | 434 | 166 | 4 | 2023-12-03 | 2855.18 | 71.38 | 2023-11-21 | 8 | 360.94 | 1 | 2855.18 | 24 | SO55303 | 2023-11-28 | 228.41 | 2887.54 | 356.90 | |||
SO65306_20 | 6B9B-439C-94 | PO5597142402 | 100 | 281 | 363 | 75 | 4 | 2024-05-03 | 5507.98 | 137.70 | 2024-04-21 | 4 | 1251.98 | 1 | 5507.98 | 20 | SO65306 | 2024-04-28 | 440.64 | 5007.93 | 1376.99 | |||
SO46076_6 | E898-4203-B0 | PO2523131751 | 100 | 287 | 317 | 167 | 4 | 2022-07-03 | 1749.59 | 43.74 | 2022-06-21 | 2 | 884.71 | 1 | 1749.59 | 6 | SO46076 | 2022-06-28 | 139.97 | 1769.42 | 874.79 | |||
SO44538_25 | E495-47A9-AD | PO2523126243 | 100 | 287 | 314 | 167 | 4 | 2022-01-03 | 4293.92 | 107.35 | 2021-12-22 | 2 | 2171.29 | 1 | 4293.92 | 25 | SO44538 | 2021-12-29 | 343.51 | 4342.59 | 2146.96 | |||
SO44787_11 | CFC8-46AC-A7 | PO5597180446 | 100 | 283 | 350 | 75 | 4 | 2022-02-02 | 6074.98 | 151.87 | 2022-01-21 | 3 | 1898.09 | 1 | 6074.98 | 11 | SO44787 | 2022-01-28 | 486.00 | 5694.28 | 2024.99 | |||
SO46964_12 | B3E6-43CC-A2 | PO15689139014 | 100 | 283 | 337 | 328 | 4 | 2022-10-03 | 2818.76 | 70.47 | 2022-09-21 | 6 | 486.71 | 1 | 2818.76 | 12 | SO46964 | 2022-09-28 | 225.50 | 2920.24 | 469.79 | |||
SO49523_1 | 852E-47A8-A9 | PO3915144057 | 100 | 281 | 448 | 130 | 4 | 2023-05-03 | 59.97 | 1.50 | 2023-04-21 | 5 | 8.25 | 1 | 59.97 | 1 | SO49523 | 2023-04-28 | 4.80 | 41.23 | 11.99 |
Generated 2024-09-20 06:52:43.274 UTC