[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE < SKIP 219 > < TAKE 28 >
28 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO48306_9 | EA27-471A-9D | PO17574166075 | 19 | 291 | 391 | 678 | 6 | 2023-03-27 | 355.73 | 8.89 | 2023-03-15 | 4 | 65.81 | 1 | 355.73 | 9 | SO48306 | 2023-03-22 | 28.46 | 263.24 | 88.93 | |||
SO45797_2 | B3FE-4436-96 | PO11049120115 | 19 | 284 | 312 | 679 | 6 | 2022-07-26 | 4293.92 | 107.35 | 2022-07-14 | 2 | 2171.29 | 1 | 4293.92 | 2 | SO45797 | 2022-07-21 | 343.51 | 4342.59 | 2146.96 | |||
SO50265_47 | 6C30-435D-9D | PO18705169014 | 19 | 291 | 236 | 479 | 6 | 2023-08-25 | 28.84 | 0.72 | 2023-08-13 | 1 | 29.08 | 1 | 28.84 | 47 | SO50265 | 2023-08-20 | 2.31 | 29.08 | 28.84 | |||
SO49484_2 | B25F-4DF4-8E | PO18299142683 | 19 | 291 | 464 | 118 | 6 | 2023-06-25 | 42.39 | 1.06 | 2023-06-13 | 3 | 9.71 | 1 | 42.39 | 2 | SO49484 | 2023-06-20 | 3.39 | 29.14 | 14.13 | |||
SO49501_6 | EF67-4713-BD | PO17574111786 | 19 | 291 | 367 | 678 | 6 | 2023-06-25 | 647.99 | 16.20 | 2023-06-13 | 1 | 598.44 | 1 | 647.99 | 6 | SO49501 | 2023-06-20 | 51.84 | 598.44 | 647.99 | |||
SO65171_4 | 9B7E-4D7A-B3 | PO17690122097 | 19 | 291 | 474 | 47 | 6 | 2024-06-25 | 419.94 | 10.50 | 2024-06-13 | 10 | 26.18 | 1 | 419.94 | 4 | SO65171 | 2024-06-20 | 33.60 | 261.76 | 41.99 | |||
SO71808_15 | 2E63-4616-B1 | PO14761198562 | 19 | 284 | 566 | 408 | 6 | 2024-09-25 | 1336.23 | 33.41 | 2024-09-13 | 3 | 461.44 | 1 | 1336.23 | 15 | SO71808 | 2024-09-20 | 106.90 | 1384.33 | 445.41 | |||
SO57022_11 | 9202-4FEB-88 | PO17806175482 | 19 | 291 | 491 | 101 | 6 | 2024-02-25 | 129.58 | 3.24 | 2024-02-13 | 4 | 41.57 | 1 | 129.58 | 11 | SO57022 | 2024-02-20 | 10.37 | 166.29 | 32.39 | |||
SO48059_19 | E21D-4968-B0 | PO4901134783 | 19 | 284 | 233 | 84 | 6 | 2023-02-25 | 173.04 | 4.33 | 2023-02-13 | 6 | 29.08 | 1 | 173.04 | 19 | SO48059 | 2023-02-20 | 13.84 | 174.48 | 28.84 | |||
SO47709_7 | C56A-4A93-90 | PO4930142687 | 19 | 291 | 354 | 425 | 6 | 2023-01-25 | 1242.85 | 31.07 | 2023-01-13 | 1 | 1117.86 | 1 | 1242.85 | 7 | SO47709 | 2023-01-20 | 99.43 | 1117.86 | 1242.85 | |||
SO58930_14 | 3C7F-464E-B2 | PO14790187151 | 19 | 291 | 600 | 497 | 6 | 2024-03-26 | 647.99 | 16.20 | 2024-03-14 | 2 | 294.58 | 1 | 647.99 | 14 | SO58930 | 2024-03-21 | 51.84 | 589.16 | 323.99 | |||
SO47966_9 | 86D0-4101-B5 | PO19227154269 | 19 | 284 | 327 | 210 | 6 | 2023-02-25 | 939.59 | 23.49 | 2023-02-13 | 2 | 486.71 | 1 | 939.59 | 9 | SO47966 | 2023-02-20 | 75.17 | 973.41 | 469.79 | |||
SO49827_46 | E4F0-4B91-84 | PO15312199090 | 19 | 291 | 457 | 299 | 6 | 2023-07-26 | 89.99 | 2.25 | 2023-07-14 | 2 | 30.93 | 1 | 89.99 | 46 | SO49827 | 2023-07-21 | 7.20 | 61.87 | 44.99 | |||
SO45323_8 | 8E16-4834-8A | PO4901118407 | 19 | 284 | 220 | 84 | 6 | 2022-05-28 | 60.56 | 1.51 | 2022-05-16 | 3 | 12.03 | 1 | 60.56 | 8 | SO45323 | 2022-05-23 | 4.84 | 36.08 | 20.19 | |||
SO50284_15 | F8D1-49E1-A5 | PO4901178867 | 19 | 284 | 453 | 84 | 6 | 2023-08-25 | 179.97 | 4.50 | 2023-08-13 | 5 | 24.75 | 1 | 179.97 | 15 | SO50284 | 2023-08-20 | 14.40 | 123.73 | 35.99 | |||
SO43855_9 | FB88-4B92-82 | PO17748116016 | 19 | 284 | 264 | 102 | 6 | 2021-11-25 | 183.94 | 4.60 | 2021-11-13 | 1 | 181.49 | 1 | 183.94 | 9 | SO43855 | 2021-11-20 | 14.72 | 181.49 | 183.94 | |||
SO46334_22 | F652-4575-B7 | PO17574196050 | 19 | 272 | 292 | 678 | 6 | 2022-09-25 | 818.70 | 20.47 | 2022-09-13 | 1 | 706.81 | 1 | 818.70 | 22 | SO46334 | 2022-09-20 | 65.50 | 706.81 | 818.70 | |||
SO51786_1 | CB32-4179-97 | PO18357130739 | 19 | 272 | 572 | 13 | 138 | 6 | 150.33 | 2023-11-25 | 1002.17 | 21.30 | 2023-11-13 | 3 | 461.44 | 1 | 851.85 | 1 | SO51786 | 2023-11-20 | 68.15 | 1384.33 | 334.06 | 0.15 |
SO48296_20 | FC37-4F3E-BB | PO19401157526 | 19 | 291 | 331 | 173 | 6 | 2023-03-27 | 469.79 | 11.74 | 2023-03-15 | 1 | 486.71 | 1 | 469.79 | 20 | SO48296 | 2023-03-22 | 37.58 | 486.71 | 469.79 | |||
SO69401_23 | 5377-4B5B-80 | PO17603155358 | 19 | 284 | 463 | 12 | 6 | 2024-08-25 | 102.86 | 2.57 | 2024-08-13 | 7 | 9.16 | 1 | 102.86 | 23 | SO69401 | 2024-08-20 | 8.23 | 64.12 | 14.69 | |||
SO50668_23 | A5FC-4831-B4 | PO17574113752 | 19 | 291 | 365 | 678 | 6 | 2023-09-25 | 2591.98 | 64.80 | 2023-09-13 | 4 | 598.44 | 1 | 2591.98 | 23 | SO50668 | 2023-09-20 | 207.36 | 2393.74 | 647.99 | |||
SO47013_3 | 4AB0-4FA0-95 | PO1827132360 | 19 | 291 | 323 | 317 | 6 | 2022-11-25 | 939.59 | 23.49 | 2022-11-13 | 2 | 486.71 | 1 | 939.59 | 3 | SO47013 | 2022-11-20 | 75.17 | 973.41 | 469.79 | |||
SO47973_36 | B9F1-47DA-87 | PO18705118148 | 19 | 291 | 263 | 479 | 6 | 2023-02-25 | 202.33 | 5.06 | 2023-02-13 | 1 | 187.16 | 1 | 202.33 | 36 | SO47973 | 2023-02-20 | 16.19 | 187.16 | 202.33 | |||
SO46616_32 | 1264-43E6-B7 | PO14732122562 | 19 | 291 | 265 | 514 | 6 | 2022-10-25 | 607.00 | 15.17 | 2022-10-13 | 3 | 187.16 | 1 | 607.00 | 32 | SO46616 | 2022-10-20 | 48.56 | 561.47 | 202.33 | |||
SO47670_53 | 0CD2-463E-8F | PO14732184884 | 19 | 291 | 456 | 514 | 6 | 2023-01-25 | 179.98 | 4.50 | 2023-01-13 | 4 | 30.93 | 1 | 179.98 | 53 | SO47670 | 2023-01-20 | 14.40 | 123.73 | 44.99 | |||
SO44765_7 | 54D5-4FF7-BB | PO11107155025 | 19 | 284 | 315 | 156 | 6 | 2022-03-27 | 874.79 | 21.87 | 2022-03-15 | 1 | 884.71 | 1 | 874.79 | 7 | SO44765 | 2022-03-22 | 69.98 | 884.71 | 874.79 | |||
SO55287_3 | 4BBD-4DA3-AD | PO13862128497 | 19 | 291 | 595 | 119 | 6 | 2024-01-25 | 338.99 | 8.47 | 2024-01-13 | 1 | 308.22 | 1 | 338.99 | 3 | SO55287 | 2024-01-20 | 27.12 | 308.22 | 338.99 | |||
SO71794_41 | C39A-4835-99 | PO17574111985 | 19 | 291 | 543 | 678 | 6 | 2024-09-25 | 74.51 | 1.86 | 2024-09-13 | 2 | 27.57 | 1 | 74.51 | 41 | SO71794 | 2024-09-20 | 5.96 | 55.14 | 37.25 |
Generated 2024-11-13 01:04:09.094 UTC