[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SHUFFLE SKIP 371 < SKIP 1437 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO69501_25 | 8A65-4926-A6 | PO6525182870 | 100 | 281 | 398 | 345 | 4 | 2024-07-04 | 80.17 | 2.00 | 2024-06-22 | 3 | 19.78 | 1 | 80.17 | 25 | SO69501 | 2024-06-29 | 6.41 | 59.33 | 26.72 | |||
SO47708_38 | 86B1-46A5-95 | PO4495147689 | 19 | 291 | 391 | 496 | 6 | 2022-12-04 | 177.86 | 4.45 | 2022-11-22 | 2 | 65.81 | 1 | 177.86 | 38 | SO47708 | 2022-11-29 | 14.23 | 131.62 | 88.93 | |||
SO46074_11 | 5178-4FDE-97 | PO2088179248 | 19 | 288 | 324 | 136 | 6 | 2022-07-04 | 1677.84 | 41.95 | 2022-06-22 | 4 | 413.15 | 1 | 1677.84 | 11 | SO46074 | 2022-06-29 | 134.23 | 1652.59 | 419.46 | |||
SO57034_17 | 57D0-46D3-B7 | PO15689142548 | 100 | 281 | 234 | 328 | 4 | 2024-01-04 | 89.98 | 2.25 | 2023-12-23 | 3 | 38.49 | 1 | 89.98 | 17 | SO57034 | 2023-12-30 | 7.20 | 115.48 | 29.99 | |||
SO43857_5 | 0CD4-4091-9B | PO16733124458 | 19 | 288 | 232 | 533 | 6 | 2021-10-04 | 28.84 | 0.72 | 2021-09-22 | 1 | 31.72 | 1 | 28.84 | 5 | SO43857 | 2021-09-29 | 2.31 | 31.72 | 28.84 | |||
SO43875_9 | CE1F-4E31-89 | PO12586178184 | 100 | 285 | 307 | 278 | 5 | 2021-10-04 | 3612.97 | 90.32 | 2021-09-22 | 5 | 623.84 | 1 | 3612.97 | 9 | SO43875 | 2021-09-29 | 289.04 | 3119.20 | 722.59 | |||
SO45335_9 | CF69-4308-92 | PO6641155631 | 100 | 281 | 338 | 342 | 2 | 2022-04-06 | 419.46 | 10.49 | 2022-03-25 | 1 | 413.15 | 1 | 419.46 | 9 | SO45335 | 2022-04-01 | 33.56 | 413.15 | 419.46 | |||
SO53519_1 | 49E2-4016-AE | PO1015154789 | 36 | 290 | 569 | 13 | 122 | 8 | 50.11 | 2023-11-04 | 334.06 | 7.10 | 2023-10-23 | 1 | 461.44 | 1 | 283.95 | 1 | SO53519 | 2023-10-30 | 22.72 | 461.44 | 334.06 | 0.15 |
SO50206_36 | 7656-4E84-B8 | PO16414158832 | 100 | 289 | 354 | 236 | 1 | 2023-07-04 | 3728.56 | 93.21 | 2023-06-22 | 3 | 1117.86 | 1 | 3728.56 | 36 | SO50206 | 2023-06-29 | 298.28 | 3353.57 | 1242.85 | |||
SO47673_12 | AFCF-4DA6-99 | PO13862175462 | 19 | 291 | 358 | 119 | 6 | 2022-12-04 | 2458.92 | 61.47 | 2022-11-22 | 2 | 1105.81 | 1 | 2458.92 | 12 | SO47673 | 2022-11-29 | 196.71 | 2211.62 | 1229.46 | |||
SO69565_2 | F165-437F-B9 | PO9773181473 | 100 | 285 | 561 | 8 | 5 | 2024-07-04 | 1430.44 | 35.76 | 2024-06-22 | 1 | 1481.94 | 1 | 1430.44 | 2 | SO69565 | 2024-06-29 | 114.44 | 1481.94 | 1430.44 | |||
SO46629_16 | E8D3-4649-8A | PO12412165004 | 100 | 283 | 414 | 670 | 3 | 2022-09-03 | 1341.28 | 33.53 | 2022-08-22 | 9 | 110.28 | 1 | 1341.28 | 16 | SO46629 | 2022-08-29 | 107.30 | 992.55 | 149.03 | |||
SO43910_2 | 8233-42D0-BD | PO7598186753 | 100 | 285 | 322 | 45 | 5 | 2021-10-04 | 1677.84 | 41.95 | 2021-09-22 | 4 | 413.15 | 1 | 1677.84 | 2 | SO43910 | 2021-09-29 | 134.23 | 1652.59 | 419.46 | |||
SO46938_23 | 2E58-4440-89 | PO19198122384 | 19 | 291 | 297 | 653 | 6 | 2022-10-04 | 3680.73 | 92.02 | 2022-09-22 | 5 | 653.70 | 1 | 3680.73 | 23 | SO46938 | 2022-09-29 | 294.46 | 3268.49 | 736.15 | |||
SO65207_11 | B20E-440F-A3 | PO1537156240 | 100 | 285 | 477 | 611 | 5 | 2024-05-04 | 11.98 | 0.30 | 2024-04-22 | 4 | 1.87 | 1 | 11.98 | 11 | SO65207 | 2024-04-29 | 0.96 | 7.47 | 2.99 | |||
SO48379_2 | 703B-461C-A7 | PO7018165155 | 100 | 283 | 224 | 695 | 3 | 2023-02-03 | 25.93 | 0.65 | 2023-01-22 | 5 | 5.23 | 1 | 25.93 | 2 | SO48379 | 2023-01-29 | 2.07 | 26.15 | 5.19 | |||
SO49495_17 | A868-43CF-A4 | PO9570115481 | 100 | 285 | 456 | 585 | 5 | 2023-05-04 | 359.95 | 9.00 | 2023-04-22 | 8 | 30.93 | 1 | 359.95 | 17 | SO49495 | 2023-04-29 | 28.80 | 247.47 | 44.99 | |||
SO51739_6 | AF60-4F2F-9B | PO12702124697 | 100 | 292 | 599 | 175 | 7 | 2023-10-04 | 1943.96 | 48.60 | 2023-09-22 | 6 | 294.58 | 1 | 1943.96 | 6 | SO51739 | 2023-09-29 | 155.52 | 1767.48 | 323.99 | |||
SO45577_7 | 7B09-45DB-A3 | PO9599125078 | 100 | 285 | 315 | 170 | 5 | 2022-05-04 | 3499.18 | 87.48 | 2022-04-22 | 4 | 884.71 | 1 | 3499.18 | 7 | SO45577 | 2022-04-29 | 279.93 | 3538.83 | 874.79 | |||
SO46344_1 | BB3A-4D16-9E | PO14268133810 | 100 | 283 | 326 | 418 | 3 | 2022-08-04 | 1258.38 | 31.46 | 2022-07-23 | 3 | 413.15 | 1 | 1258.38 | 1 | SO46344 | 2022-07-30 | 100.67 | 1239.44 | 419.46 | |||
SO53493_15 | F767-491F-84 | PO13543118174 | 100 | 287 | 476 | 293 | 1 | 2023-11-04 | 293.96 | 7.35 | 2023-10-23 | 7 | 26.18 | 1 | 293.96 | 15 | SO53493 | 2023-10-30 | 23.52 | 183.23 | 41.99 | |||
SO55294_20 | D314-4552-B5 | PO6467116955 | 100 | 283 | 408 | 660 | 3 | 2023-12-04 | 72.16 | 1.80 | 2023-11-22 | 1 | 53.40 | 1 | 72.16 | 20 | SO55294 | 2023-11-29 | 5.77 | 53.40 | 72.16 | |||
SO47962_17 | 3B2C-487D-99 | PO19923193438 | 100 | 281 | 308 | 18 | 3 | 2023-01-04 | 2232.82 | 55.82 | 2022-12-23 | 3 | 660.91 | 1 | 2232.82 | 17 | SO47962 | 2022-12-30 | 178.63 | 1982.74 | 744.27 | |||
SO53586_14 | 37CB-4A82-96 | PO4002170204 | 100 | 282 | 483 | 674 | 4 | 2023-11-04 | 504.00 | 12.60 | 2023-10-23 | 7 | 44.88 | 1 | 504.00 | 14 | SO53586 | 2023-10-30 | 40.32 | 314.16 | 72.00 | |||
SO49092_22 | 72CE-4E29-82 | PO14442163644 | 100 | 293 | 459 | 127 | 1 | 2023-04-06 | 161.98 | 4.05 | 2023-03-25 | 3 | 37.12 | 1 | 161.98 | 22 | SO49092 | 2023-04-01 | 12.96 | 111.36 | 53.99 | |||
SO44107_16 | 99CE-4ADA-B1 | PO261177749 | 100 | 283 | 229 | 647 | 4 | 2021-11-04 | 28.84 | 0.72 | 2021-10-23 | 1 | 31.72 | 1 | 28.84 | 16 | SO44107 | 2021-10-30 | 2.31 | 31.72 | 28.84 | |||
SO47024_26 | F254-4053-A3 | PO3654136382 | 100 | 283 | 289 | 435 | 4 | 2022-10-04 | 744.27 | 18.61 | 2022-09-22 | 1 | 660.91 | 1 | 744.27 | 26 | SO47024 | 2022-09-29 | 59.54 | 660.91 | 744.27 | |||
SO51809_50 | F690-4F1D-B1 | PO6438145374 | 100 | 281 | 472 | 309 | 4 | 2023-10-04 | 266.70 | 6.67 | 2023-09-22 | 7 | 23.75 | 1 | 266.70 | 50 | SO51809 | 2023-09-29 | 21.34 | 166.24 | 38.10 | |||
SO46038_14 | D7B6-499A-87 | PO17748117802 | 19 | 284 | 316 | 102 | 6 | 2022-07-04 | 874.79 | 21.87 | 2022-06-22 | 1 | 884.71 | 1 | 874.79 | 14 | SO46038 | 2022-06-29 | 69.98 | 884.71 | 874.79 | |||
SO48001_35 | 02F1-4434-99 | PO14442151969 | 100 | 293 | 448 | 127 | 1 | 2023-01-04 | 47.98 | 1.20 | 2022-12-23 | 4 | 8.25 | 1 | 47.98 | 35 | SO48001 | 2022-12-30 | 3.84 | 32.98 | 11.99 | |||
SO53539_17 | 2B21-4FAC-8C | PO18763121730 | 100 | 287 | 586 | 13 | 59 | 4 | 100.22 | 2023-11-04 | 668.12 | 14.20 | 2023-10-23 | 2 | 461.44 | 1 | 567.90 | 17 | SO53539 | 2023-10-30 | 45.43 | 922.89 | 334.06 | 0.15 |
Generated 2024-09-21 16:51:28.535 UTC