[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE SKIP 2000 < SKIP 93 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO49831_25 | 8BCC-466B-AB | PO13688123267 | 100 | 282 | 352 | 475 | 4 | 2023-07-24 | 4971.41 | 124.29 | 2023-07-12 | 4 | 1117.86 | 1 | 4971.41 | 25 | SO49831 | 2023-07-19 | 397.71 | 4471.42 | 1242.85 | |||
SO69536_30 | 9646-48B3-9E | PO3654177498 | 100 | 281 | 588 | 435 | 4 | 2024-08-23 | 923.39 | 23.08 | 2024-08-11 | 2 | 419.78 | 1 | 923.39 | 30 | SO69536 | 2024-08-18 | 73.87 | 839.56 | 461.69 | |||
SO47024_17 | F254-4053-A3 | PO3654136382 | 100 | 283 | 360 | 435 | 4 | 2022-11-23 | 4917.84 | 122.95 | 2022-11-11 | 4 | 1105.81 | 1 | 4917.84 | 17 | SO47024 | 2022-11-18 | 393.43 | 4423.24 | 1229.46 | |||
SO47386_4 | 53D3-4CF9-BD | PO13717112244 | 100 | 287 | 424 | 473 | 4 | 2022-12-24 | 214.24 | 5.36 | 2022-12-12 | 1 | 158.53 | 1 | 214.24 | 4 | SO47386 | 2022-12-19 | 17.14 | 158.53 | 214.24 | |||
SO47458_31 | 5D5A-47FC-AE | PO9686113121 | 100 | 282 | 426 | 457 | 4 | 2022-12-24 | 418.51 | 10.46 | 2022-12-12 | 2 | 185.82 | 1 | 418.51 | 31 | SO47458 | 2022-12-19 | 33.48 | 371.64 | 209.26 | |||
SO50294_18 | F34B-46CA-8D | PO3799186112 | 100 | 282 | 470 | 4 | 312 | 4 | 62.68 | 2023-08-23 | 626.84 | 14.10 | 2023-08-11 | 33 | 15.67 | 1 | 564.15 | 18 | SO50294 | 2023-08-18 | 45.13 | 517.14 | 19.00 | 0.10 |
SO47435_16 | B7A7-4F07-94 | PO5597154214 | 100 | 283 | 354 | 75 | 4 | 2022-12-24 | 2485.70 | 62.14 | 2022-12-12 | 2 | 1117.86 | 1 | 2485.70 | 16 | SO47435 | 2022-12-19 | 198.86 | 2235.71 | 1242.85 | |||
SO44795_18 | 629B-45A2-8B | PO7569171528 | 100 | 287 | 346 | 2 | 608 | 4 | 473.28 | 2022-03-25 | 23663.93 | 579.77 | 2022-03-13 | 12 | 1912.15 | 1 | 23190.65 | 18 | SO44795 | 2022-03-20 | 1855.25 | 22945.85 | 1971.99 | 0.02 |
SO51714_2 | D33A-4EAE-B1 | PO15689195197 | 100 | 281 | 434 | 328 | 4 | 2023-11-23 | 2498.29 | 62.46 | 2023-11-11 | 7 | 360.94 | 1 | 2498.29 | 2 | SO51714 | 2023-11-18 | 199.86 | 2526.60 | 356.90 | |||
SO48071_6 | E6F7-41F8-92 | PO6525193011 | 100 | 283 | 395 | 345 | 4 | 2023-02-23 | 613.74 | 15.34 | 2023-02-11 | 10 | 45.42 | 1 | 613.74 | 6 | SO48071 | 2023-02-18 | 49.10 | 454.17 | 61.37 | |||
SO46992_14 | C958-4FD6-A0 | PO11745117547 | 100 | 282 | 286 | 97 | 4 | 2022-11-23 | 551.81 | 13.80 | 2022-11-11 | 3 | 170.14 | 1 | 551.81 | 14 | SO46992 | 2022-11-18 | 44.15 | 510.43 | 183.94 | |||
SO59068_36 | B7CC-4A9D-86 | PO9715112509 | 100 | 281 | 555 | 490 | 4 | 2024-03-24 | 255.60 | 6.39 | 2024-03-12 | 4 | 47.29 | 1 | 255.60 | 36 | SO59068 | 2024-03-19 | 20.45 | 189.14 | 63.90 | |||
SO69527_5 | A6FE-49DA-BE | PO4843110434 | 100 | 287 | 287 | 257 | 4 | 2024-08-23 | 607.00 | 15.17 | 2024-08-11 | 3 | 204.63 | 1 | 607.00 | 5 | SO69527 | 2024-08-18 | 48.56 | 613.88 | 202.33 | |||
SO49127_10 | 01A1-43AB-A2 | PO3480145572 | 100 | 272 | 216 | 436 | 4 | 2023-05-26 | 20.19 | 0.50 | 2023-05-14 | 1 | 13.88 | 1 | 20.19 | 10 | SO49127 | 2023-05-21 | 1.61 | 13.88 | 20.19 | |||
SO71787_20 | 94A7-4406-B3 | PO18038111279 | 100 | 287 | 556 | 509 | 4 | 2024-09-23 | 210.59 | 5.26 | 2024-09-11 | 2 | 77.92 | 1 | 210.59 | 20 | SO71787 | 2024-09-18 | 16.85 | 155.84 | 105.29 | |||
SO47386_3 | 53D3-4CF9-BD | PO13717112244 | 100 | 287 | 221 | 473 | 4 | 2022-12-24 | 20.19 | 0.50 | 2022-12-12 | 1 | 13.88 | 1 | 20.19 | 3 | SO47386 | 2022-12-19 | 1.61 | 13.88 | 20.19 | |||
SO43873_20 | 494C-48D2-BD | PO12499138177 | 100 | 282 | 324 | 78 | 4 | 2021-11-23 | 2516.75 | 62.92 | 2021-11-11 | 6 | 413.15 | 1 | 2516.75 | 20 | SO43873 | 2021-11-18 | 201.34 | 2478.88 | 419.46 | |||
SO71881_2 | 8EDF-4F9F-97 | PO6757112103 | 100 | 281 | 559 | 21 | 4 | 2024-09-23 | 36.43 | 0.91 | 2024-09-11 | 3 | 8.99 | 1 | 36.43 | 2 | SO71881 | 2024-09-18 | 2.91 | 26.96 | 12.14 | |||
SO69417_11 | 6746-4842-AD | PO15196165910 | 100 | 282 | 605 | 258 | 4 | 2024-08-23 | 647.99 | 16.20 | 2024-08-11 | 2 | 343.65 | 1 | 647.99 | 11 | SO69417 | 2024-08-18 | 51.84 | 687.30 | 323.99 | |||
SO46992_21 | C958-4FD6-A0 | PO11745117547 | 100 | 282 | 254 | 97 | 4 | 2022-11-23 | 183.94 | 4.60 | 2022-11-11 | 1 | 170.14 | 1 | 183.94 | 21 | SO46992 | 2022-11-18 | 14.72 | 170.14 | 183.94 | |||
SO53621_20 | 9324-4A3D-83 | PO9715186811 | 100 | 281 | 603 | 490 | 4 | 2023-12-24 | 364.47 | 9.11 | 2023-12-12 | 5 | 53.94 | 1 | 364.47 | 20 | SO53621 | 2023-12-19 | 29.16 | 269.71 | 72.89 | |||
SO61218_44 | 8441-4C6F-89 | PO13688193778 | 100 | 282 | 531 | 475 | 4 | 2024-04-24 | 599.50 | 14.99 | 2024-04-12 | 4 | 136.79 | 1 | 599.50 | 44 | SO61218 | 2024-04-19 | 47.96 | 547.14 | 149.87 | |||
SO46964_41 | B3E6-43CC-A2 | PO15689139014 | 100 | 283 | 417 | 328 | 4 | 2022-11-23 | 1297.81 | 32.45 | 2022-11-11 | 4 | 300.12 | 1 | 1297.81 | 41 | SO46964 | 2022-11-18 | 103.82 | 1200.48 | 324.45 | |||
SO53621_4 | 9324-4A3D-83 | PO9715186811 | 100 | 281 | 558 | 490 | 4 | 2023-12-24 | 2429.94 | 60.75 | 2023-12-12 | 10 | 179.82 | 1 | 2429.94 | 4 | SO53621 | 2023-12-19 | 194.40 | 1798.16 | 242.99 | |||
SO47032_5 | 090F-4070-AA | PO4553172367 | 100 | 282 | 343 | 313 | 4 | 2022-11-23 | 2348.97 | 58.72 | 2022-11-11 | 5 | 486.71 | 1 | 2348.97 | 5 | SO47032 | 2022-11-18 | 187.92 | 2433.53 | 469.79 | |||
SO50745_27 | 02DB-4CC5-85 | PO5539140407 | 100 | 282 | 354 | 61 | 4 | 2023-09-23 | 2485.70 | 62.14 | 2023-09-11 | 2 | 1117.86 | 1 | 2485.70 | 27 | SO50745 | 2023-09-18 | 198.86 | 2235.71 | 1242.85 | |||
SO53606_27 | 6A19-463C-B7 | PO5539128997 | 100 | 282 | 474 | 3 | 61 | 4 | 30.80 | 2023-12-24 | 615.91 | 14.63 | 2023-12-12 | 16 | 26.18 | 1 | 585.12 | 27 | SO53606 | 2023-12-19 | 46.81 | 418.82 | 38.49 | 0.05 |
SO50672_52 | 1BE9-437C-8A | PO16472110144 | 100 | 287 | 254 | 239 | 4 | 2023-09-23 | 183.94 | 4.60 | 2023-09-11 | 1 | 170.14 | 1 | 183.94 | 52 | SO50672 | 2023-09-18 | 14.72 | 170.14 | 183.94 | |||
SO50672_39 | 1BE9-437C-8A | PO16472110144 | 100 | 287 | 242 | 239 | 4 | 2023-09-23 | 1561.64 | 39.04 | 2023-09-11 | 2 | 722.26 | 1 | 1561.64 | 39 | SO50672 | 2023-09-18 | 124.93 | 1444.51 | 780.82 | |||
SO51829_5 | 448A-443D-89 | PO5655146578 | 100 | 287 | 521 | 563 | 4 | 2023-11-23 | 32.54 | 0.81 | 2023-11-11 | 2 | 12.04 | 1 | 32.54 | 5 | SO51829 | 2023-11-18 | 2.60 | 24.08 | 16.27 | |||
SO47712_32 | 299D-4C8A-BF | PO5626117491 | 100 | 283 | 239 | 166 | 4 | 2023-01-23 | 4684.91 | 117.12 | 2023-01-11 | 6 | 722.26 | 1 | 4684.91 | 32 | SO47712 | 2023-01-18 | 374.79 | 4333.54 | 780.82 |
Generated 2024-11-11 02:04:02.416 UTC