[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SKIP 4000 SHUFFLE < SKIP 29 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO50748_19 | 5FBE-4B52-B2 | PO6786143310 | 100 | 281 | 271 | 3 | 4 | 2023-08-03 | 607.00 | 15.17 | 2023-07-22 | 3 | 187.16 | 1 | 607.00 | 19 | SO50748 | 2023-07-29 | 48.56 | 561.47 | 202.33 | |||
SO50727_38 | 5DD5-4A9A-B1 | PO9483181443 | 100 | 283 | 233 | 54 | 2 | 2023-08-03 | 230.72 | 5.77 | 2023-07-22 | 8 | 29.08 | 1 | 230.72 | 38 | SO50727 | 2023-07-29 | 18.46 | 232.65 | 28.84 | |||
SO71795_34 | 5843-4E7D-8D | PO17371184627 | 6 | 296 | 492 | 688 | 9 | 2024-08-03 | 602.35 | 15.06 | 2024-07-22 | 1 | 601.74 | 1 | 602.35 | 34 | SO71795 | 2024-07-29 | 48.19 | 601.74 | 602.35 | |||
SO53613_44 | 4A10-4F98-84 | PO6815195063 | 100 | 293 | 217 | 109 | 1 | 2023-11-03 | 104.97 | 2.62 | 2023-10-22 | 5 | 13.09 | 1 | 104.97 | 44 | SO53613 | 2023-10-29 | 8.40 | 65.43 | 20.99 | |||
SO47409_39 | FC23-4384-86 | PO1624119173 | 100 | 283 | 435 | 579 | 3 | 2022-11-03 | 973.36 | 24.33 | 2022-10-22 | 3 | 300.12 | 1 | 973.36 | 39 | SO47409 | 2022-10-29 | 77.87 | 900.36 | 324.45 | |||
SO51766_10 | 1118-4A2A-80 | PO638122353 | 19 | 291 | 472 | 280 | 6 | 2023-10-03 | 190.50 | 4.76 | 2023-09-21 | 5 | 23.75 | 1 | 190.50 | 10 | SO51766 | 2023-09-28 | 15.24 | 118.75 | 38.10 | |||
SO58989_4 | 0A23-4D44-A4 | PO11977137958 | 100 | 285 | 408 | 675 | 5 | 2024-02-02 | 144.32 | 3.61 | 2024-01-21 | 2 | 53.40 | 1 | 144.32 | 4 | SO58989 | 2024-01-28 | 11.55 | 106.80 | 72.16 | |||
SO65207_28 | B20E-440F-A3 | PO1537156240 | 100 | 285 | 225 | 611 | 5 | 2024-05-03 | 32.36 | 0.81 | 2024-04-21 | 6 | 6.92 | 1 | 32.36 | 28 | SO65207 | 2024-04-28 | 2.59 | 41.53 | 5.39 | |||
SO53534_5 | F0B1-423E-8B | PO20213153510 | 100 | 283 | 222 | 216 | 2 | 2023-11-03 | 83.98 | 2.10 | 2023-10-22 | 4 | 13.09 | 1 | 83.98 | 5 | SO53534 | 2023-10-29 | 6.72 | 52.35 | 20.99 | |||
SO69525_20 | 9DCD-4F42-9E | PO4727119266 | 100 | 293 | 545 | 343 | 1 | 2024-07-03 | 97.18 | 2.43 | 2024-06-21 | 4 | 17.98 | 1 | 97.18 | 20 | SO69525 | 2024-06-28 | 7.77 | 71.91 | 24.29 | |||
SO63136_11 | 0873-484A-AE | PO18328125904 | 19 | 284 | 471 | 552 | 6 | 2024-04-04 | 304.80 | 7.62 | 2024-03-23 | 8 | 23.75 | 1 | 304.80 | 11 | SO63136 | 2024-03-30 | 24.38 | 189.99 | 38.10 | |||
SO51720_8 | E39F-4680-AC | PO15370128892 | 100 | 281 | 543 | 381 | 3 | 2023-10-03 | 74.51 | 1.86 | 2023-09-21 | 2 | 27.57 | 1 | 74.51 | 8 | SO51720 | 2023-09-28 | 5.96 | 55.14 | 37.25 | |||
SO69518_18 | 96AA-48F8-80 | PO5800191682 | 100 | 285 | 601 | 63 | 5 | 2024-07-03 | 32.39 | 0.81 | 2024-06-21 | 1 | 23.97 | 1 | 32.39 | 18 | SO69518 | 2024-06-28 | 2.59 | 23.97 | 32.39 | |||
SO44293_8 | A1AE-48E7-A4 | PO13775127212 | 100 | 281 | 328 | 618 | 2 | 2021-12-03 | 838.92 | 20.97 | 2021-11-21 | 2 | 413.15 | 1 | 838.92 | 8 | SO44293 | 2021-11-28 | 67.11 | 826.29 | 419.46 | |||
SO57013_3 | E12C-431B-BD | PO19691121735 | 19 | 291 | 359 | 353 | 6 | 2024-01-03 | 4130.98 | 103.27 | 2023-12-22 | 3 | 1251.98 | 1 | 4130.98 | 3 | SO57013 | 2023-12-29 | 330.48 | 3755.94 | 1376.99 | |||
SO45333_3 | 5BB5-4C37-92 | PO6670131417 | 100 | 281 | 253 | 432 | 2 | 2022-04-05 | 178.58 | 4.46 | 2022-03-24 | 1 | 176.20 | 1 | 178.58 | 3 | SO45333 | 2022-03-31 | 14.29 | 176.20 | 178.58 | |||
SO58928_37 | 6C1A-4E73-97 | PO15341119997 | 100 | 281 | 472 | 327 | 3 | 2024-02-02 | 381.00 | 9.53 | 2024-01-21 | 10 | 23.75 | 1 | 381.00 | 37 | SO58928 | 2024-01-28 | 30.48 | 237.49 | 38.10 | |||
SO57051_13 | 0E3B-4DB5-83 | PO13427178709 | 100 | 292 | 384 | 638 | 7 | 2024-01-03 | 4033.76 | 100.84 | 2023-12-22 | 6 | 713.08 | 1 | 4033.76 | 13 | SO57051 | 2023-12-29 | 322.70 | 4278.48 | 672.29 | |||
SO53514_9 | 8580-40F8-81 | PO10411179199 | 100 | 289 | 585 | 13 | 182 | 1 | 100.22 | 2023-11-03 | 668.12 | 14.20 | 2023-10-22 | 2 | 461.44 | 1 | 567.90 | 9 | SO53514 | 2023-10-29 | 45.43 | 922.89 | 334.06 | 0.15 |
SO44121_1 | FE2E-4885-B3 | PO5220129819 | 100 | 282 | 293 | 169 | 1 | 2021-11-03 | 722.59 | 18.06 | 2021-10-22 | 1 | 623.84 | 1 | 722.59 | 1 | SO44121 | 2021-10-29 | 57.81 | 623.84 | 722.59 | |||
SO53520_6 | 7FFF-4635-B3 | PO1131160733 | 36 | 295 | 560 | 536 | 8 | 2023-11-03 | 728.91 | 18.22 | 2023-10-22 | 1 | 755.15 | 1 | 728.91 | 6 | SO53520 | 2023-10-29 | 58.31 | 755.15 | 728.91 | |||
SO51836_23 | 8AA7-498C-8C | PO6351139034 | 100 | 281 | 606 | 255 | 4 | 2023-10-03 | 323.99 | 8.10 | 2023-09-21 | 1 | 343.65 | 1 | 323.99 | 23 | SO51836 | 2023-09-28 | 25.92 | 343.65 | 323.99 | |||
SO69412_8 | 14B1-47FE-BF | PO15689112657 | 100 | 281 | 384 | 328 | 4 | 2024-07-03 | 2016.88 | 50.42 | 2024-06-21 | 3 | 713.08 | 1 | 2016.88 | 8 | SO69412 | 2024-06-28 | 161.35 | 2139.24 | 672.29 | |||
SO51090_58 | EBDE-4A71-8E | PO13688110947 | 100 | 282 | 471 | 3 | 475 | 4 | 26.19 | 2023-09-02 | 523.88 | 12.44 | 2023-08-21 | 15 | 23.75 | 1 | 497.68 | 58 | SO51090 | 2023-08-28 | 39.81 | 356.24 | 34.93 | 0.05 |
SO71877_1 | 7428-4791-8C | PO10904138732 | 19 | 291 | 390 | 244 | 6 | 2024-08-03 | 672.29 | 16.81 | 2024-07-22 | 1 | 713.08 | 1 | 672.29 | 1 | SO71877 | 2024-07-29 | 53.78 | 713.08 | 672.29 | |||
SO50688_25 | C55C-41B0-92 | PO10701178438 | 100 | 282 | 305 | 133 | 4 | 2023-08-03 | 2944.58 | 73.61 | 2023-07-22 | 4 | 653.70 | 1 | 2944.58 | 25 | SO50688 | 2023-07-29 | 235.57 | 2614.79 | 736.15 | |||
SO45049_3 | 9952-4AC1-92 | PO13978117499 | 100 | 289 | 334 | 200 | 1 | 2022-03-05 | 419.46 | 10.49 | 2022-02-21 | 1 | 413.15 | 1 | 419.46 | 3 | SO45049 | 2022-02-28 | 33.56 | 413.15 | 419.46 | |||
SO58948_16 | 1534-4AB5-81 | PO11774195497 | 6 | 296 | 601 | 682 | 9 | 2024-02-02 | 32.39 | 0.81 | 2024-01-21 | 1 | 23.97 | 1 | 32.39 | 16 | SO58948 | 2024-01-28 | 2.59 | 23.97 | 32.39 |
Generated 2024-09-20 15:21:01.843 UTC