[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > SHUFFLE < SKIP 283 > < TAKE 30 >
30 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO43694_9 | EC3D-48E0-A6 | PO9657130250 | 100 | 285 | 346 | 315 | 5 | 2021-10-23 | 4079.99 | 102.00 | 2021-10-11 | 2 | 1912.15 | 1 | 4079.99 | 9 | SO43694 | 2021-10-18 | 326.40 | 3824.31 | 2039.99 | |||
SO58971_30 | 319A-4CAC-B1 | PO1537134870 | 100 | 285 | 498 | 611 | 5 | 2024-03-24 | 3614.08 | 90.35 | 2024-03-12 | 6 | 601.74 | 1 | 3614.08 | 30 | SO58971 | 2024-03-19 | 289.13 | 3610.46 | 602.35 | |||
SO51081_24 | EDBF-4FE1-8F | PO522116846 | 100 | 285 | 471 | 676 | 5 | 2023-10-23 | 304.80 | 7.62 | 2023-10-11 | 8 | 23.75 | 1 | 304.80 | 24 | SO51081 | 2023-10-18 | 24.38 | 189.99 | 38.10 | |||
SO48359_32 | BFAE-4CA5-83 | PO2813116854 | 100 | 272 | 236 | 90 | 5 | 2023-03-25 | 115.36 | 2.88 | 2023-03-13 | 4 | 29.08 | 1 | 115.36 | 32 | SO48359 | 2023-03-20 | 9.23 | 116.32 | 28.84 | |||
SO48365_4 | F100-46F1-98 | PO4089137383 | 100 | 285 | 358 | 368 | 5 | 2023-03-25 | 3688.38 | 92.21 | 2023-03-13 | 3 | 1105.81 | 1 | 3688.38 | 4 | SO48365 | 2023-03-20 | 295.07 | 3317.43 | 1229.46 | |||
SO53524_41 | 2B2B-440F-8B | PO1537151724 | 100 | 285 | 493 | 611 | 5 | 2023-12-24 | 400.10 | 10.00 | 2023-12-12 | 2 | 199.85 | 1 | 400.10 | 41 | SO53524 | 2023-12-19 | 32.01 | 399.70 | 200.05 | |||
SO44801_11 | 4DBD-4E98-A7 | PO9599152040 | 100 | 285 | 328 | 170 | 5 | 2022-03-25 | 838.92 | 20.97 | 2022-03-13 | 2 | 413.15 | 1 | 838.92 | 11 | SO44801 | 2022-03-20 | 67.11 | 826.29 | 419.46 | |||
SO53563_27 | C955-44BD-A8 | PO9599165865 | 100 | 285 | 482 | 2 | 170 | 5 | 1.46 | 2023-12-24 | 73.00 | 1.79 | 2023-12-12 | 14 | 3.36 | 1 | 71.54 | 27 | SO53563 | 2023-12-19 | 5.72 | 47.07 | 5.21 | 0.02 |
SO49822_33 | 191D-4AD7-93 | PO522119337 | 100 | 285 | 447 | 676 | 5 | 2023-07-24 | 90.00 | 2.25 | 2023-07-12 | 6 | 10.31 | 1 | 90.00 | 33 | SO49822 | 2023-07-19 | 7.20 | 61.88 | 15.00 | |||
SO44801_6 | 4DBD-4E98-A7 | PO9599152040 | 100 | 285 | 270 | 170 | 5 | 2022-03-25 | 735.75 | 18.39 | 2022-03-13 | 4 | 181.49 | 1 | 735.75 | 6 | SO44801 | 2022-03-20 | 58.86 | 725.94 | 183.94 | |||
SO45578_3 | CF5F-44F3-B2 | PO9802194761 | 100 | 285 | 319 | 26 | 5 | 2022-06-23 | 2624.38 | 65.61 | 2022-06-11 | 3 | 884.71 | 1 | 2624.38 | 3 | SO45578 | 2022-06-18 | 209.95 | 2654.12 | 874.79 | |||
SO51147_4 | C4D7-458D-A6 | PO9831167474 | 100 | 285 | 258 | 81 | 5 | 2023-10-23 | 202.33 | 5.06 | 2023-10-11 | 1 | 204.63 | 1 | 202.33 | 4 | SO51147 | 2023-10-18 | 16.19 | 204.63 | 202.33 | |||
SO57175_1 | 8997-4142-90 | PO7714123713 | 100 | 285 | 580 | 495 | 5 | 2024-02-23 | 1020.59 | 25.51 | 2024-02-11 | 1 | 1082.51 | 1 | 1020.59 | 1 | SO57175 | 2024-02-18 | 81.65 | 1082.51 | 1020.59 | |||
SO46673_27 | 578D-4F7B-A6 | PO9657163155 | 100 | 285 | 453 | 315 | 5 | 2022-10-23 | 35.99 | 0.90 | 2022-10-11 | 1 | 24.75 | 1 | 35.99 | 27 | SO46673 | 2022-10-18 | 2.88 | 24.75 | 35.99 | |||
SO51158_4 | 0C39-4657-B5 | PO3741166917 | 100 | 285 | 287 | 404 | 5 | 2023-10-23 | 202.33 | 5.06 | 2023-10-11 | 1 | 204.63 | 1 | 202.33 | 4 | SO51158 | 2023-10-18 | 16.19 | 204.63 | 202.33 | |||
SO50293_2 | D649-4CE8-91 | PO3596144572 | 100 | 285 | 358 | 476 | 5 | 2023-08-23 | 2458.92 | 61.47 | 2023-08-11 | 2 | 1105.81 | 1 | 2458.92 | 2 | SO50293 | 2023-08-18 | 196.71 | 2211.62 | 1229.46 | |||
SO48393_32 | 5B6A-41B6-BF | PO9599137631 | 100 | 285 | 370 | 170 | 5 | 2023-03-25 | 10262.07 | 256.55 | 2023-03-13 | 7 | 1518.79 | 1 | 10262.07 | 32 | SO48393 | 2023-03-20 | 820.97 | 10631.50 | 1466.01 | |||
SO57017_8 | 4C6E-47EA-AD | PO19546126186 | 100 | 285 | 606 | 206 | 5 | 2024-02-23 | 1619.97 | 40.50 | 2024-02-11 | 5 | 343.65 | 1 | 1619.97 | 8 | SO57017 | 2024-02-18 | 129.60 | 1718.25 | 323.99 | |||
SO45802_7 | 8C6D-42B3-AA | PO1189157476 | 100 | 285 | 326 | 423 | 5 | 2022-07-24 | 2097.29 | 52.43 | 2022-07-12 | 5 | 413.15 | 1 | 2097.29 | 7 | SO45802 | 2022-07-19 | 167.78 | 2065.73 | 419.46 | |||
SO49836_39 | 0E32-48F7-89 | PO12644185975 | 100 | 285 | 419 | 530 | 5 | 2023-07-24 | 105.29 | 2.63 | 2023-07-12 | 2 | 38.96 | 1 | 105.29 | 39 | SO49836 | 2023-07-19 | 8.42 | 77.92 | 52.65 | |||
SO53551_24 | 8593-405C-AB | PO14297167079 | 100 | 285 | 601 | 627 | 5 | 2023-12-24 | 32.39 | 0.81 | 2023-12-12 | 1 | 23.97 | 1 | 32.39 | 24 | SO53551 | 2023-12-19 | 2.59 | 23.97 | 32.39 | |||
SO50703_19 | 4A3D-44CB-B3 | PO2813140706 | 100 | 283 | 335 | 90 | 5 | 2023-09-23 | 1409.38 | 35.23 | 2023-09-11 | 3 | 486.71 | 1 | 1409.38 | 19 | SO50703 | 2023-09-18 | 112.75 | 1460.12 | 469.79 | |||
SO47416_17 | 6B45-44AB-84 | PO2813155355 | 100 | 281 | 216 | 90 | 5 | 2022-12-24 | 161.49 | 4.04 | 2022-12-12 | 8 | 13.88 | 1 | 161.49 | 17 | SO47416 | 2022-12-19 | 12.92 | 111.03 | 20.19 | |||
SO44122_1 | C57E-4294-AE | PO5307162091 | 100 | 285 | 350 | 369 | 5 | 2021-12-24 | 2024.99 | 50.62 | 2021-12-12 | 1 | 1898.09 | 1 | 2024.99 | 1 | SO44122 | 2021-12-19 | 162.00 | 1898.09 | 2024.99 | |||
SO46045_4 | 9345-48CB-A5 | PO16327127643 | 100 | 285 | 253 | 584 | 5 | 2022-08-23 | 357.16 | 8.93 | 2022-08-11 | 2 | 176.20 | 1 | 357.16 | 4 | SO46045 | 2022-08-18 | 28.57 | 352.40 | 178.58 | |||
SO50231_18 | B2CA-498D-9B | PO11571129150 | 100 | 285 | 265 | 512 | 5 | 2023-08-23 | 202.33 | 5.06 | 2023-08-11 | 1 | 187.16 | 1 | 202.33 | 18 | SO50231 | 2023-08-18 | 16.19 | 187.16 | 202.33 | |||
SO51147_30 | C4D7-458D-A6 | PO9831167474 | 100 | 285 | 418 | 81 | 5 | 2023-10-23 | 356.90 | 8.92 | 2023-10-11 | 1 | 360.94 | 1 | 356.90 | 30 | SO51147 | 2023-10-18 | 28.55 | 360.94 | 356.90 | |||
SO50756_35 | C414-447C-84 | PO9570119689 | 100 | 285 | 459 | 585 | 5 | 2023-09-23 | 215.98 | 5.40 | 2023-09-11 | 4 | 37.12 | 1 | 215.98 | 35 | SO50756 | 2023-09-18 | 17.28 | 148.48 | 53.99 | |||
SO69465_26 | B8B2-4B14-99 | PO2842153886 | 100 | 285 | 471 | 700 | 5 | 2024-08-23 | 381.00 | 9.53 | 2024-08-11 | 10 | 23.75 | 1 | 381.00 | 26 | SO69465 | 2024-08-18 | 30.48 | 237.49 | 38.10 | |||
SO53524_21 | 2B2B-440F-8B | PO1537151724 | 100 | 285 | 225 | 2 | 611 | 5 | 1.25 | 2023-12-24 | 62.57 | 1.53 | 2023-12-12 | 12 | 6.92 | 1 | 61.32 | 21 | SO53524 | 2023-12-19 | 4.91 | 83.07 | 5.21 | 0.02 |
Generated 2024-11-10 09:40:54.731 UTC