[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SHUFFLE < SKIP 885 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO69528_9 | 2644-4747-86 | PO6438163496 | 100 | 272 | 225 | 309 | 4 | 2024-07-03 | 16.18 | 0.40 | 2024-06-21 | 3 | 6.92 | 1 | 16.18 | 9 | SO69528 | 2024-06-28 | 1.29 | 20.77 | 5.39 | |||
SO69521_10 | EAFC-4D00-94 | PO6148143676 | 100 | 289 | 500 | 693 | 1 | 2024-07-03 | 602.35 | 15.06 | 2024-06-21 | 1 | 601.74 | 1 | 602.35 | 10 | SO69521 | 2024-06-28 | 48.19 | 601.74 | 602.35 | |||
SO71805_27 | 99FD-47B9-97 | PO14703194514 | 6 | 296 | 576 | 573 | 9 | 2024-08-03 | 5721.77 | 143.04 | 2024-07-22 | 4 | 1481.94 | 1 | 5721.77 | 27 | SO71805 | 2024-07-29 | 457.74 | 5927.75 | 1430.44 | |||
SO50313_15 | B452-44E9-91 | PO7656143984 | 100 | 282 | 339 | 403 | 4 | 2023-07-03 | 1409.38 | 35.23 | 2023-06-21 | 3 | 486.71 | 1 | 1409.38 | 15 | SO50313 | 2023-06-28 | 112.75 | 1460.12 | 469.79 | |||
SO58984_4 | 5D72-43BF-AB | PO16153135798 | 100 | 282 | 576 | 186 | 4 | 2024-02-02 | 2860.88 | 71.52 | 2024-01-21 | 2 | 1481.94 | 1 | 2860.88 | 4 | SO58984 | 2024-01-28 | 228.87 | 2963.88 | 1430.44 | |||
SO65245_2 | 80F6-437F-84 | PO9628129233 | 100 | 283 | 575 | 179 | 2 | 2024-05-03 | 2860.88 | 71.52 | 2024-04-21 | 2 | 1481.94 | 1 | 2860.88 | 2 | SO65245 | 2024-04-28 | 228.87 | 2963.88 | 1430.44 | |||
SO55257_23 | 979F-4AAF-9E | PO12412154112 | 100 | 281 | 374 | 670 | 3 | 2023-12-03 | 8796.06 | 219.90 | 2023-11-21 | 6 | 1554.95 | 1 | 8796.06 | 23 | SO55257 | 2023-11-28 | 703.68 | 9329.69 | 1466.01 | |||
SO51157_49 | 927E-4DB1-A3 | PO3828155781 | 100 | 283 | 480 | 414 | 2 | 2023-09-02 | 1.37 | 0.03 | 2023-08-21 | 1 | 0.86 | 1 | 1.37 | 49 | SO51157 | 2023-08-28 | 0.11 | 0.86 | 1.37 | |||
SO48001_8 | 02F1-4434-99 | PO14442151969 | 100 | 293 | 362 | 127 | 1 | 2023-01-03 | 1229.46 | 30.74 | 2022-12-22 | 1 | 1105.81 | 1 | 1229.46 | 8 | SO48001 | 2022-12-29 | 98.36 | 1105.81 | 1229.46 | |||
SO47422_10 | 9D8D-4481-B6 | PO3915123127 | 100 | 283 | 230 | 130 | 4 | 2022-11-03 | 259.56 | 6.49 | 2022-10-22 | 9 | 29.08 | 1 | 259.56 | 10 | SO47422 | 2022-10-29 | 20.77 | 261.73 | 28.84 | |||
SO46101_17 | FAFC-4F06-B2 | PO7656119075 | 100 | 282 | 324 | 403 | 4 | 2022-07-03 | 838.92 | 20.97 | 2022-06-21 | 2 | 413.15 | 1 | 838.92 | 17 | SO46101 | 2022-06-28 | 67.11 | 826.29 | 419.46 | |||
SO53569_34 | 113E-43AD-94 | PO9309141312 | 100 | 293 | 571 | 13 | 55 | 1 | 150.33 | 2023-11-03 | 1002.17 | 21.30 | 2023-10-22 | 3 | 461.44 | 1 | 851.85 | 34 | SO53569 | 2023-10-29 | 68.15 | 1384.33 | 334.06 | 0.15 |
SO63224_5 | 668F-4A18-A0 | PO7627111844 | 100 | 293 | 583 | 433 | 1 | 2024-04-04 | 6123.56 | 153.09 | 2024-03-23 | 6 | 1082.51 | 1 | 6123.56 | 5 | SO63224 | 2024-03-30 | 489.89 | 6495.06 | 1020.59 | |||
SO49139_6 | 2662-4BFD-96 | PO4843131080 | 100 | 287 | 462 | 257 | 4 | 2023-04-05 | 14.13 | 0.35 | 2023-03-24 | 1 | 9.71 | 1 | 14.13 | 6 | SO49139 | 2023-03-31 | 1.13 | 9.71 | 14.13 | |||
SO46611_38 | 93A4-4A4D-99 | PO16588117269 | 100 | 289 | 470 | 4 | 146 | 1 | 64.58 | 2022-09-02 | 645.83 | 14.53 | 2022-08-21 | 34 | 15.67 | 1 | 581.25 | 38 | SO46611 | 2022-08-28 | 46.50 | 532.81 | 19.00 | 0.10 |
SO48326_3 | C7D9-4798-BF | PO14065114327 | 100 | 293 | 265 | 379 | 1 | 2023-02-02 | 202.33 | 5.06 | 2023-01-21 | 1 | 187.16 | 1 | 202.33 | 3 | SO48326 | 2023-01-28 | 16.19 | 187.16 | 202.33 | |||
SO69397_26 | 1339-46CA-AC | PO18879152551 | 19 | 291 | 562 | 64 | 6 | 2024-07-03 | 1430.44 | 35.76 | 2024-06-21 | 1 | 1481.94 | 1 | 1430.44 | 26 | SO69397 | 2024-06-28 | 114.44 | 1481.94 | 1430.44 | |||
SO45038_10 | 2001-401A-83 | PO18473129920 | 19 | 288 | 292 | 442 | 6 | 2022-03-05 | 1637.40 | 40.94 | 2022-02-21 | 2 | 706.81 | 1 | 1637.40 | 10 | SO45038 | 2022-02-28 | 130.99 | 1413.62 | 818.70 | |||
SO50676_33 | 66F1-4A9A-97 | PO14790188963 | 19 | 291 | 428 | 497 | 6 | 2023-08-03 | 418.51 | 10.46 | 2023-07-22 | 2 | 185.82 | 1 | 418.51 | 33 | SO50676 | 2023-07-29 | 33.48 | 371.64 | 209.26 | |||
SO48075_10 | DB59-481D-87 | PO7598114627 | 100 | 285 | 466 | 45 | 5 | 2023-01-03 | 14.13 | 0.35 | 2022-12-22 | 1 | 9.71 | 1 | 14.13 | 10 | SO48075 | 2022-12-29 | 1.13 | 9.71 | 14.13 | |||
SO61217_14 | 9B9A-4C8B-93 | PO9889149314 | 100 | 285 | 532 | 494 | 5 | 2024-03-04 | 749.37 | 18.73 | 2024-02-21 | 5 | 136.79 | 1 | 749.37 | 14 | SO61217 | 2024-02-28 | 59.95 | 683.93 | 149.87 | |||
SO49501_21 | EF67-4713-BD | PO17574111786 | 19 | 291 | 365 | 678 | 6 | 2023-05-03 | 1943.98 | 48.60 | 2023-04-21 | 3 | 598.44 | 1 | 1943.98 | 21 | SO49501 | 2023-04-28 | 155.52 | 1795.31 | 647.99 | |||
SO46620_46 | FEE3-4994-8E | PO13775143788 | 100 | 281 | 286 | 618 | 2 | 2022-09-02 | 183.94 | 4.60 | 2022-08-21 | 1 | 170.14 | 1 | 183.94 | 46 | SO46620 | 2022-08-28 | 14.72 | 170.14 | 183.94 | |||
SO50272_22 | E0A6-4CFA-90 | PO11745174916 | 100 | 282 | 377 | 97 | 4 | 2023-07-03 | 5235.75 | 130.89 | 2023-06-21 | 4 | 1320.68 | 1 | 5235.75 | 22 | SO50272 | 2023-06-28 | 418.86 | 5282.74 | 1308.94 | |||
SO61239_31 | 6459-4F99-96 | PO3828136274 | 100 | 283 | 214 | 414 | 2 | 2024-03-04 | 62.98 | 1.57 | 2024-02-21 | 3 | 13.09 | 1 | 62.98 | 31 | SO61239 | 2024-02-28 | 5.04 | 39.26 | 20.99 | |||
SO51165_4 | 0B97-482F-AD | PO2436165847 | 100 | 282 | 586 | 13 | 241 | 4 | 50.11 | 2023-09-02 | 334.06 | 7.10 | 2023-08-21 | 1 | 461.44 | 1 | 283.95 | 4 | SO51165 | 2023-08-28 | 22.72 | 461.44 | 334.06 | 0.15 |
SO48389_24 | 304D-46A7-8E | PO8671159284 | 98 | 288 | 421 | 502 | 10 | 2023-02-02 | 1177.97 | 29.45 | 2023-01-21 | 6 | 145.28 | 1 | 1177.97 | 24 | SO48389 | 2023-01-28 | 94.24 | 871.70 | 196.33 | |||
SO51824_27 | A1F7-477E-BA | PO5800114202 | 100 | 285 | 398 | 63 | 5 | 2023-10-03 | 53.45 | 1.34 | 2023-09-21 | 2 | 19.78 | 1 | 53.45 | 27 | SO51824 | 2023-09-28 | 4.28 | 39.55 | 26.72 |
Generated 2024-09-20 06:39:13.017 UTC