[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > SKIP 2875 SHUFFLE < SKIP 783 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO49865_18 | E9A6-42D3-91 | PO9831136904 | 100 | 285 | 454 | 81 | 5 | 2023-07-25 | 179.97 | 4.50 | 2023-07-13 | 5 | 24.75 | 1 | 179.97 | 18 | SO49865 | 2023-07-20 | 14.40 | 123.73 | 35.99 | |||
SO53530_26 | A31D-483D-A1 | PO2813121313 | 100 | 283 | 234 | 2 | 90 | 5 | 7.54 | 2023-12-25 | 376.92 | 9.23 | 2023-12-13 | 13 | 38.49 | 1 | 369.39 | 26 | SO53530 | 2023-12-20 | 29.55 | 500.40 | 28.99 | 0.02 |
SO50276_3 | BB3F-4E95-B8 | PO9512139148 | 100 | 285 | 343 | 135 | 5 | 2023-08-24 | 3758.35 | 93.96 | 2023-08-12 | 8 | 486.71 | 1 | 3758.35 | 3 | SO50276 | 2023-08-19 | 300.67 | 3893.65 | 469.79 | |||
SO53474_14 | E5B6-4103-8D | PO15457187993 | 100 | 285 | 578 | 297 | 5 | 2023-12-25 | 728.91 | 18.22 | 2023-12-13 | 1 | 755.15 | 1 | 728.91 | 14 | SO53474 | 2023-12-20 | 58.31 | 755.15 | 728.91 | |||
SO69452_4 | 5ADC-4093-86 | PO10150198555 | 100 | 285 | 361 | 9 | 5 | 2024-08-24 | 2753.99 | 68.85 | 2024-08-12 | 2 | 1251.98 | 1 | 2753.99 | 4 | SO69452 | 2024-08-19 | 220.32 | 2503.96 | 1376.99 | |||
SO47053_2 | 686D-414B-82 | PO7598127510 | 100 | 285 | 257 | 45 | 5 | 2022-11-24 | 735.75 | 18.39 | 2022-11-12 | 4 | 170.14 | 1 | 735.75 | 2 | SO47053 | 2022-11-19 | 58.86 | 680.57 | 183.94 | |||
SO69518_16 | 96AA-48F8-80 | PO5800191682 | 100 | 285 | 309 | 63 | 5 | 2024-08-24 | 2456.10 | 61.40 | 2024-08-12 | 3 | 747.20 | 1 | 2456.10 | 16 | SO69518 | 2024-08-19 | 196.49 | 2241.60 | 818.70 | |||
SO58924_25 | D17F-4E31-90 | PO15457121920 | 100 | 285 | 567 | 297 | 5 | 2024-03-25 | 1336.23 | 33.41 | 2024-03-13 | 3 | 461.44 | 1 | 1336.23 | 25 | SO58924 | 2024-03-20 | 106.90 | 1384.33 | 445.41 | |||
SO50234_4 | 97E1-4282-8B | PO10150134950 | 100 | 285 | 454 | 9 | 5 | 2023-08-24 | 71.99 | 1.80 | 2023-08-12 | 2 | 24.75 | 1 | 71.99 | 4 | SO50234 | 2023-08-19 | 5.76 | 49.49 | 35.99 | |||
SO63181_15 | CB4E-4CF5-87 | PO2842135731 | 100 | 285 | 390 | 700 | 5 | 2024-05-26 | 2016.88 | 50.42 | 2024-05-14 | 3 | 713.08 | 1 | 2016.88 | 15 | SO63181 | 2024-05-21 | 161.35 | 2139.24 | 672.29 | |||
SO65207_16 | B20E-440F-A3 | PO1537156240 | 100 | 285 | 488 | 611 | 5 | 2024-06-24 | 129.58 | 3.24 | 2024-06-12 | 4 | 41.57 | 1 | 129.58 | 16 | SO65207 | 2024-06-19 | 10.37 | 166.29 | 32.39 | |||
SO50231_20 | B2CA-498D-9B | PO11571129150 | 100 | 285 | 368 | 512 | 5 | 2023-08-24 | 7330.05 | 183.25 | 2023-08-12 | 5 | 1518.79 | 1 | 7330.05 | 20 | SO50231 | 2023-08-19 | 586.40 | 7593.93 | 1466.01 | |||
SO50293_10 | D649-4CE8-91 | PO3596144572 | 100 | 285 | 469 | 3 | 476 | 5 | 22.98 | 2023-08-24 | 459.68 | 10.92 | 2023-08-12 | 22 | 15.67 | 1 | 436.70 | 10 | SO50293 | 2023-08-19 | 34.94 | 344.76 | 20.89 | 0.05 |
SO48063_23 | AEA4-4489-90 | PO5858143254 | 100 | 285 | 358 | 566 | 5 | 2023-02-24 | 6147.29 | 153.68 | 2023-02-12 | 5 | 1105.81 | 1 | 6147.29 | 23 | SO48063 | 2023-02-19 | 491.78 | 5529.05 | 1229.46 | |||
SO55253_39 | C58B-49D8-9F | PO12644132539 | 100 | 285 | 214 | 530 | 5 | 2024-01-24 | 83.98 | 2.10 | 2024-01-12 | 4 | 13.09 | 1 | 83.98 | 39 | SO55253 | 2024-01-19 | 6.72 | 52.35 | 20.99 | |||
SO47449_2 | 65DE-4129-86 | PO9048199215 | 100 | 285 | 399 | 652 | 5 | 2022-12-25 | 33.77 | 0.84 | 2022-12-13 | 1 | 24.99 | 1 | 33.77 | 2 | SO47449 | 2022-12-20 | 2.70 | 24.99 | 33.77 | |||
SO55253_41 | C58B-49D8-9F | PO12644132539 | 100 | 285 | 234 | 530 | 5 | 2024-01-24 | 119.98 | 3.00 | 2024-01-12 | 4 | 38.49 | 1 | 119.98 | 41 | SO55253 | 2024-01-19 | 9.60 | 153.97 | 29.99 | |||
SO49149_30 | D41E-4EFF-A5 | PO5858123072 | 100 | 285 | 459 | 566 | 5 | 2023-05-27 | 53.99 | 1.35 | 2023-05-15 | 1 | 37.12 | 1 | 53.99 | 30 | SO49149 | 2023-05-22 | 4.32 | 37.12 | 53.99 | |||
SO53524_1 | 2B2B-440F-8B | PO1537151724 | 100 | 285 | 523 | 611 | 5 | 2023-12-25 | 126.34 | 3.16 | 2023-12-13 | 4 | 23.37 | 1 | 126.34 | 1 | SO53524 | 2023-12-20 | 10.11 | 93.49 | 31.58 | |||
SO48730_21 | C918-466B-B1 | PO522152463 | 100 | 285 | 224 | 676 | 5 | 2023-04-26 | 15.56 | 0.39 | 2023-04-14 | 3 | 5.23 | 1 | 15.56 | 21 | SO48730 | 2023-04-21 | 1.24 | 15.69 | 5.19 | |||
SO69394_14 | A04D-4E1B-B4 | PO19546195663 | 100 | 285 | 606 | 206 | 5 | 2024-08-24 | 323.99 | 8.10 | 2024-08-12 | 1 | 343.65 | 1 | 323.99 | 14 | SO69394 | 2024-08-19 | 25.92 | 343.65 | 323.99 | |||
SO63245_8 | 1025-4AD1-A1 | PO5800120355 | 100 | 285 | 363 | 63 | 5 | 2024-05-26 | 1376.99 | 34.42 | 2024-05-14 | 1 | 1251.98 | 1 | 1376.99 | 8 | SO63245 | 2024-05-21 | 110.16 | 1251.98 | 1376.99 | |||
SO69533_3 | AC2B-4C39-84 | PO3596133486 | 100 | 285 | 357 | 476 | 5 | 2024-08-24 | 4175.98 | 104.40 | 2024-08-12 | 3 | 1265.62 | 1 | 4175.98 | 3 | SO69533 | 2024-08-19 | 334.08 | 3796.86 | 1391.99 | |||
SO69465_17 | B8B2-4B14-99 | PO2842153886 | 100 | 285 | 388 | 700 | 5 | 2024-08-24 | 2016.88 | 50.42 | 2024-08-12 | 3 | 713.08 | 1 | 2016.88 | 17 | SO69465 | 2024-08-19 | 161.35 | 2139.24 | 672.29 | |||
SO48766_31 | A56F-4A7B-AD | PO9831126274 | 100 | 285 | 461 | 81 | 5 | 2023-04-26 | 107.99 | 2.70 | 2023-04-14 | 2 | 37.12 | 1 | 107.99 | 31 | SO48766 | 2023-04-21 | 8.64 | 74.24 | 53.99 | |||
SO55253_47 | C58B-49D8-9F | PO12644132539 | 100 | 285 | 515 | 530 | 5 | 2024-01-24 | 16.27 | 0.41 | 2024-01-12 | 1 | 12.04 | 1 | 16.27 | 47 | SO55253 | 2024-01-19 | 1.30 | 12.04 | 16.27 | |||
SO67277_47 | 9AB3-4F34-85 | PO12644174121 | 100 | 272 | 222 | 530 | 5 | 2024-07-25 | 62.98 | 1.57 | 2024-07-13 | 3 | 13.09 | 1 | 62.98 | 47 | SO67277 | 2024-07-20 | 5.04 | 39.26 | 20.99 | |||
SO49088_1 | ED04-4B44-9B | PO11542199639 | 100 | 285 | 323 | 62 | 5 | 2023-05-27 | 1409.38 | 35.23 | 2023-05-15 | 3 | 486.71 | 1 | 1409.38 | 1 | SO49088 | 2023-05-22 | 112.75 | 1460.12 | 469.79 | |||
SO67260_13 | 6224-4229-B8 | PO522163557 | 100 | 285 | 524 | 676 | 5 | 2024-07-25 | 158.43 | 3.96 | 2024-07-13 | 1 | 144.59 | 1 | 158.43 | 13 | SO67260 | 2024-07-20 | 12.67 | 144.59 | 158.43 | |||
SO49865_6 | E9A6-42D3-91 | PO9831136904 | 100 | 285 | 381 | 81 | 5 | 2023-07-25 | 4201.84 | 105.05 | 2023-07-13 | 7 | 605.65 | 1 | 4201.84 | 6 | SO49865 | 2023-07-20 | 336.15 | 4239.54 | 600.26 | |||
SO53625_5 | 98EA-458A-B9 | PO9744185498 | 100 | 285 | 542 | 98 | 5 | 2023-12-25 | 48.59 | 1.21 | 2023-12-13 | 2 | 17.98 | 1 | 48.59 | 5 | SO53625 | 2023-12-20 | 3.89 | 35.96 | 24.29 |
Generated 2024-11-11 04:18:10.678 UTC