[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SHUFFLE SKIP 169 < SKIP 1500 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46967_41 | 6486-4AF8-A6 | PO15573116583 | 100 | 286 | 397 | 487 | 1 | 2022-10-04 | 97.18 | 2.43 | 2022-09-22 | 4 | 17.98 | 1 | 97.18 | 41 | SO46967 | 2022-09-29 | 7.77 | 71.91 | 24.29 | |||
SO46055_12 | DDC5-498B-87 | PO13572168536 | 100 | 287 | 262 | 527 | 3 | 2022-07-04 | 183.94 | 4.60 | 2022-06-22 | 1 | 181.49 | 1 | 183.94 | 12 | SO46055 | 2022-06-29 | 14.72 | 181.49 | 183.94 | |||
SO48758_9 | 709A-4AE0-B1 | PO13688180139 | 100 | 282 | 447 | 475 | 4 | 2023-03-06 | 45.00 | 1.13 | 2023-02-22 | 3 | 10.31 | 1 | 45.00 | 9 | SO48758 | 2023-03-01 | 3.60 | 30.94 | 15.00 | |||
SO61230_15 | B9F1-4FF8-B4 | PO12644163346 | 100 | 285 | 594 | 530 | 5 | 2024-03-05 | 338.99 | 8.47 | 2024-02-22 | 1 | 308.22 | 1 | 338.99 | 15 | SO61230 | 2024-02-29 | 27.12 | 308.22 | 338.99 | |||
SO53573_21 | F674-4899-B9 | PO8671117198 | 98 | 288 | 515 | 502 | 10 | 2023-11-04 | 65.09 | 1.63 | 2023-10-23 | 4 | 12.04 | 1 | 65.09 | 21 | SO53573 | 2023-10-30 | 5.21 | 48.17 | 16.27 | |||
SO69451_14 | EE16-4615-B7 | PO9918189570 | 100 | 285 | 503 | 260 | 5 | 2024-07-04 | 400.10 | 10.00 | 2024-06-22 | 2 | 199.85 | 1 | 400.10 | 14 | SO69451 | 2024-06-29 | 32.01 | 399.70 | 200.05 | |||
SO53527_2 | 0EBE-4ACB-B5 | PO1798140946 | 19 | 291 | 512 | 10 | 6 | 2023-11-04 | 1310.72 | 32.77 | 2023-10-23 | 6 | 199.38 | 1 | 1310.72 | 2 | SO53527 | 2023-10-30 | 104.86 | 1196.25 | 218.45 | |||
SO65246_4 | 0818-4676-89 | PO9744127225 | 100 | 285 | 359 | 98 | 5 | 2024-05-04 | 2753.99 | 68.85 | 2024-04-22 | 2 | 1251.98 | 1 | 2753.99 | 4 | SO65246 | 2024-04-29 | 220.32 | 2503.96 | 1376.99 | |||
SO45305_8 | AC1B-4242-9C | PO11600132440 | 19 | 288 | 338 | 569 | 6 | 2022-04-06 | 419.46 | 10.49 | 2022-03-25 | 1 | 413.15 | 1 | 419.46 | 8 | SO45305 | 2022-04-01 | 33.56 | 413.15 | 419.46 | |||
SO46610_13 | B7D1-4895-B6 | PO17197125590 | 100 | 281 | 411 | 125 | 2 | 2022-09-03 | 501.66 | 12.54 | 2022-08-22 | 4 | 92.81 | 1 | 501.66 | 13 | SO46610 | 2022-08-29 | 40.13 | 371.23 | 125.42 | |||
SO47351_19 | E79A-4588-B4 | PO20213129467 | 100 | 281 | 216 | 216 | 2 | 2022-11-04 | 60.56 | 1.51 | 2022-10-23 | 3 | 13.88 | 1 | 60.56 | 19 | SO47351 | 2022-10-30 | 4.84 | 41.63 | 20.19 | |||
SO51836_3 | 8AA7-498C-8C | PO6351139034 | 100 | 281 | 287 | 255 | 4 | 2023-10-04 | 607.00 | 15.17 | 2023-09-22 | 3 | 204.63 | 1 | 607.00 | 3 | SO51836 | 2023-09-29 | 48.56 | 613.88 | 202.33 | |||
SO49859_4 | C69C-4337-A7 | PO13949161597 | 100 | 283 | 323 | 643 | 3 | 2023-06-04 | 469.79 | 11.74 | 2023-05-23 | 1 | 486.71 | 1 | 469.79 | 4 | SO49859 | 2023-05-30 | 37.58 | 486.71 | 469.79 | |||
SO47033_15 | 2797-46ED-BB | PO4727113716 | 100 | 286 | 375 | 343 | 1 | 2022-10-04 | 2617.88 | 65.45 | 2022-09-22 | 2 | 1320.68 | 1 | 2617.88 | 15 | SO47033 | 2022-09-29 | 209.43 | 2641.37 | 1308.94 | |||
SO47415_8 | 4C47-41C8-B0 | PO2233131382 | 19 | 291 | 233 | 262 | 6 | 2022-11-04 | 57.68 | 1.44 | 2022-10-23 | 2 | 29.08 | 1 | 57.68 | 8 | SO47415 | 2022-10-30 | 4.61 | 58.16 | 28.84 | |||
SO51169_27 | 995D-4C3D-86 | PO5452173982 | 36 | 295 | 570 | 13 | 320 | 8 | 200.43 | 2023-09-03 | 1336.23 | 28.39 | 2023-08-22 | 4 | 461.44 | 1 | 1135.80 | 27 | SO51169 | 2023-08-29 | 90.86 | 1845.78 | 334.06 | 0.15 |
SO71844_20 | 410D-4079-9E | PO2813198985 | 100 | 283 | 580 | 90 | 5 | 2024-08-04 | 7144.16 | 178.60 | 2024-07-23 | 7 | 1082.51 | 1 | 7144.16 | 20 | SO71844 | 2024-07-30 | 571.53 | 7577.57 | 1020.59 | |||
SO63223_13 | 70F5-4AD9-A9 | PO13427118669 | 100 | 292 | 231 | 638 | 7 | 2024-04-05 | 299.94 | 7.50 | 2024-03-24 | 10 | 38.49 | 1 | 299.94 | 13 | SO63223 | 2024-03-31 | 24.00 | 384.92 | 29.99 | |||
SO49515_20 | 52D0-4584-BC | PO9715144044 | 100 | 281 | 297 | 490 | 4 | 2023-05-04 | 736.15 | 18.40 | 2023-04-22 | 1 | 653.70 | 1 | 736.15 | 20 | SO49515 | 2023-04-29 | 58.89 | 653.70 | 736.15 | |||
SO50242_17 | A651-4343-86 | PO1595193228 | 19 | 284 | 445 | 426 | 6 | 2023-07-04 | 143.98 | 3.60 | 2023-06-22 | 4 | 24.75 | 1 | 143.98 | 17 | SO50242 | 2023-06-29 | 11.52 | 98.98 | 35.99 | |||
SO47365_23 | 4535-457B-B0 | PO17574153673 | 19 | 291 | 464 | 678 | 6 | 2022-11-04 | 42.39 | 1.06 | 2022-10-23 | 3 | 9.71 | 1 | 42.39 | 23 | SO47365 | 2022-10-30 | 3.39 | 29.14 | 14.13 | |||
SO63173_11 | CE32-441D-BF | PO1508158507 | 98 | 290 | 384 | 430 | 10 | 2024-04-05 | 2689.18 | 67.23 | 2024-03-24 | 4 | 713.08 | 1 | 2689.18 | 11 | SO63173 | 2024-03-31 | 215.13 | 2852.32 | 672.29 | |||
SO51845_20 | 6AB8-4CEA-A9 | PO3799111961 | 100 | 282 | 595 | 312 | 4 | 2023-10-04 | 338.99 | 8.47 | 2023-09-22 | 1 | 308.22 | 1 | 338.99 | 20 | SO51845 | 2023-09-29 | 27.12 | 308.22 | 338.99 | |||
SO71859_3 | 326E-4365-A3 | PO16182112142 | 100 | 287 | 475 | 23 | 4 | 2024-08-04 | 83.99 | 2.10 | 2024-07-23 | 2 | 26.18 | 1 | 83.99 | 3 | SO71859 | 2024-07-30 | 6.72 | 52.35 | 41.99 | |||
SO48075_2 | DB59-481D-87 | PO7598114627 | 100 | 285 | 239 | 45 | 5 | 2023-01-04 | 2342.45 | 58.56 | 2022-12-23 | 3 | 722.26 | 1 | 2342.45 | 2 | SO48075 | 2022-12-30 | 187.40 | 2166.77 | 780.82 | |||
SO55328_28 | 577D-4DE9-B6 | PO9831188161 | 100 | 285 | 390 | 81 | 5 | 2023-12-04 | 1344.59 | 33.61 | 2023-11-22 | 2 | 713.08 | 1 | 1344.59 | 28 | SO55328 | 2023-11-29 | 107.57 | 1426.16 | 672.29 | |||
SO57028_7 | E080-4171-A4 | PO16704183706 | 100 | 292 | 225 | 680 | 7 | 2024-01-04 | 16.18 | 0.40 | 2023-12-23 | 3 | 6.92 | 1 | 16.18 | 7 | SO57028 | 2023-12-30 | 1.29 | 20.77 | 5.39 | |||
SO58973_1 | DB2C-4D5F-86 | PO1740110032 | 19 | 291 | 481 | 460 | 6 | 2024-02-03 | 16.18 | 0.40 | 2024-01-22 | 3 | 3.36 | 1 | 16.18 | 1 | SO58973 | 2024-01-29 | 1.29 | 10.09 | 5.39 | |||
SO44127_11 | E778-471D-8A | PO7569162058 | 100 | 287 | 350 | 608 | 4 | 2021-11-04 | 12149.96 | 303.75 | 2021-10-23 | 6 | 1898.09 | 1 | 12149.96 | 11 | SO44127 | 2021-10-30 | 972.00 | 11388.57 | 2024.99 | |||
SO61226_8 | 4E9F-42F5-AC | PO9454118602 | 6 | 296 | 234 | 591 | 9 | 2024-03-05 | 209.96 | 5.25 | 2024-02-22 | 7 | 38.49 | 1 | 209.96 | 8 | SO61226 | 2024-02-29 | 16.80 | 269.45 | 29.99 | |||
SO51856_32 | E170-419C-92 | PO3654183134 | 100 | 281 | 476 | 435 | 4 | 2023-10-04 | 251.96 | 6.30 | 2023-09-22 | 6 | 26.18 | 1 | 251.96 | 32 | SO51856 | 2023-09-29 | 20.16 | 157.06 | 41.99 |
Generated 2024-09-21 05:43:47.285 UTC