[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '2' > SHUFFLE SKIP 2000 < SKIP 375 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO61219_18 | A4CD-46F5-9E | PO11687126732 | 100 | 283 | 573 | 691 | 2 | 2024-03-03 | 2860.88 | 71.52 | 2024-02-20 | 2 | 1481.94 | 1 | 2860.88 | 18 | SO61219 | 2024-02-27 | 228.87 | 2963.88 | 1430.44 | |||
SO53560_43 | 3D25-4203-A4 | PO7685199983 | 100 | 283 | 568 | 13 | 539 | 2 | 100.22 | 2023-11-02 | 668.12 | 14.20 | 2023-10-21 | 2 | 461.44 | 1 | 567.90 | 43 | SO53560 | 2023-10-28 | 45.43 | 922.89 | 334.06 | 0.15 |
SO50683_23 | 8EBE-4D2C-AB | PO11455112273 | 100 | 283 | 368 | 72 | 2 | 2023-08-02 | 5864.04 | 146.60 | 2023-07-21 | 4 | 1518.79 | 1 | 5864.04 | 23 | SO50683 | 2023-07-28 | 469.12 | 6075.15 | 1466.01 | |||
SO47395_34 | 98F1-44B4-97 | PO11455133549 | 100 | 281 | 341 | 72 | 2 | 2022-11-02 | 2818.76 | 70.47 | 2022-10-21 | 6 | 486.71 | 1 | 2818.76 | 34 | SO47395 | 2022-10-28 | 225.50 | 2920.24 | 469.79 | |||
SO57140_7 | 5E5D-46A1-94 | PO3161152145 | 100 | 283 | 482 | 359 | 2 | 2024-01-02 | 21.58 | 0.54 | 2023-12-21 | 4 | 3.36 | 1 | 21.58 | 7 | SO57140 | 2023-12-28 | 1.73 | 13.45 | 5.39 | |||
SO49888_31 | 01BB-49D0-BD | PO6699147895 | 100 | 283 | 286 | 234 | 2 | 2023-06-02 | 1103.63 | 27.59 | 2023-05-21 | 6 | 170.14 | 1 | 1103.63 | 31 | SO49888 | 2023-05-28 | 88.29 | 1020.86 | 183.94 | |||
SO47450_13 | 7E50-416D-A2 | PO9483124566 | 100 | 281 | 236 | 54 | 2 | 2022-11-02 | 173.04 | 4.33 | 2022-10-21 | 6 | 29.08 | 1 | 173.04 | 13 | SO47450 | 2022-10-28 | 13.84 | 174.48 | 28.84 | |||
SO46994_33 | 5E92-4A19-9E | PO11629171210 | 100 | 281 | 411 | 396 | 2 | 2022-10-02 | 125.42 | 3.14 | 2022-09-20 | 1 | 92.81 | 1 | 125.42 | 33 | SO46994 | 2022-09-27 | 10.03 | 92.81 | 125.42 | |||
SO45793_16 | 0B18-49B2-96 | PO13775113238 | 100 | 281 | 324 | 618 | 2 | 2022-06-02 | 419.46 | 10.49 | 2022-05-21 | 1 | 413.15 | 1 | 419.46 | 16 | SO45793 | 2022-05-28 | 33.56 | 413.15 | 419.46 | |||
SO57087_20 | 423C-428C-BB | PO2871167176 | 100 | 283 | 579 | 522 | 2 | 2024-01-02 | 2186.73 | 54.67 | 2023-12-21 | 3 | 755.15 | 1 | 2186.73 | 20 | SO57087 | 2023-12-28 | 174.94 | 2265.45 | 728.91 | |||
SO51157_45 | 927E-4DB1-A3 | PO3828155781 | 100 | 283 | 556 | 414 | 2 | 2023-09-01 | 210.59 | 5.26 | 2023-08-20 | 2 | 77.92 | 1 | 210.59 | 45 | SO51157 | 2023-08-27 | 16.85 | 155.84 | 105.29 | |||
SO47432_1 | 781D-4AED-A2 | PO4756164192 | 100 | 281 | 456 | 126 | 2 | 2022-11-02 | 89.99 | 2.25 | 2022-10-21 | 2 | 30.93 | 1 | 89.99 | 1 | SO47432 | 2022-10-28 | 7.20 | 61.87 | 44.99 | |||
SO57065_19 | B68A-407E-99 | PO11658151711 | 100 | 283 | 353 | 233 | 2 | 2024-01-02 | 8351.96 | 208.80 | 2023-12-21 | 6 | 1265.62 | 1 | 8351.96 | 19 | SO57065 | 2023-12-28 | 668.16 | 7593.72 | 1391.99 | |||
SO46095_11 | A60D-4721-BF | PO6641179809 | 100 | 281 | 253 | 342 | 2 | 2022-07-02 | 357.16 | 8.93 | 2022-06-20 | 2 | 176.20 | 1 | 357.16 | 11 | SO46095 | 2022-06-27 | 28.57 | 352.40 | 178.58 | |||
SO53570_42 | 412A-483A-A3 | PO9483124574 | 100 | 283 | 465 | 2 | 54 | 2 | 3.69 | 2023-11-02 | 184.65 | 4.52 | 2023-10-21 | 13 | 9.16 | 1 | 180.96 | 42 | SO53570 | 2023-10-28 | 14.48 | 119.07 | 14.20 | 0.02 |
SO47664_20 | 4F8A-4646-B5 | PO17197195500 | 100 | 281 | 412 | 125 | 2 | 2022-12-02 | 360.26 | 9.01 | 2022-11-20 | 2 | 133.30 | 1 | 360.26 | 20 | SO47664 | 2022-11-27 | 28.82 | 266.59 | 180.13 | |||
SO44789_2 | D918-4308-9F | PO6322139904 | 100 | 281 | 322 | 503 | 2 | 2022-02-01 | 419.46 | 10.49 | 2022-01-20 | 1 | 413.15 | 1 | 419.46 | 2 | SO44789 | 2022-01-27 | 33.56 | 413.15 | 419.46 | |||
SO69526_20 | E43D-4369-A8 | PO7453115394 | 100 | 283 | 217 | 108 | 2 | 2024-07-02 | 146.96 | 3.67 | 2024-06-20 | 7 | 13.09 | 1 | 146.96 | 20 | SO69526 | 2024-06-27 | 11.76 | 91.60 | 20.99 | |||
SO69493_5 | FA5D-44EF-A7 | PO12383119310 | 100 | 283 | 482 | 3 | 89 | 2 | 4.94 | 2024-07-02 | 98.89 | 2.35 | 2024-06-20 | 20 | 3.36 | 1 | 93.95 | 5 | SO69493 | 2024-06-27 | 7.52 | 67.25 | 4.94 | 0.05 |
SO71894_30 | 8013-4FC0-B4 | PO7685115663 | 100 | 283 | 568 | 539 | 2 | 2024-08-02 | 1336.23 | 33.41 | 2024-07-21 | 3 | 461.44 | 1 | 1336.23 | 30 | SO71894 | 2024-07-28 | 106.90 | 1384.33 | 445.41 | |||
SO67263_8 | EFEC-4A80-8F | PO17197178016 | 100 | 283 | 587 | 125 | 2 | 2024-06-02 | 923.39 | 23.08 | 2024-05-21 | 2 | 419.78 | 1 | 923.39 | 8 | SO67263 | 2024-05-28 | 73.87 | 839.56 | 461.69 | |||
SO47664_19 | 4F8A-4646-B5 | PO17197195500 | 100 | 281 | 420 | 125 | 2 | 2022-12-02 | 141.62 | 3.54 | 2022-11-20 | 1 | 104.80 | 1 | 141.62 | 19 | SO47664 | 2022-11-27 | 11.33 | 104.80 | 141.62 | |||
SO55248_7 | 8E6C-4F5E-92 | PO13775186264 | 100 | 283 | 231 | 618 | 2 | 2023-12-02 | 89.98 | 2.25 | 2023-11-20 | 3 | 38.49 | 1 | 89.98 | 7 | SO55248 | 2023-11-27 | 7.20 | 115.48 | 29.99 | |||
SO50727_17 | 5DD5-4A9A-B1 | PO9483181443 | 100 | 283 | 333 | 54 | 2 | 2023-08-02 | 469.79 | 11.74 | 2023-07-21 | 1 | 486.71 | 1 | 469.79 | 17 | SO50727 | 2023-07-28 | 37.58 | 486.71 | 469.79 | |||
SO49157_20 | 9DDB-4852-A8 | PO7424122254 | 100 | 283 | 233 | 642 | 2 | 2023-04-04 | 115.36 | 2.88 | 2023-03-23 | 4 | 29.08 | 1 | 115.36 | 20 | SO49157 | 2023-03-30 | 9.23 | 116.32 | 28.84 | |||
SO46948_53 | B040-4261-B3 | PO18386128096 | 100 | 281 | 216 | 558 | 2 | 2022-10-02 | 100.93 | 2.52 | 2022-09-20 | 5 | 13.88 | 1 | 100.93 | 53 | SO46948 | 2022-09-27 | 8.07 | 69.39 | 20.19 | |||
SO69450_19 | 7050-466D-9B | PO10121172172 | 100 | 283 | 440 | 684 | 2 | 2024-07-02 | 858.90 | 21.47 | 2024-06-20 | 1 | 868.63 | 1 | 858.90 | 19 | SO69450 | 2024-06-27 | 68.71 | 868.63 | 858.90 | |||
SO49864_33 | D282-4C24-9B | PO13775121562 | 100 | 283 | 335 | 618 | 2 | 2023-06-02 | 939.59 | 23.49 | 2023-05-21 | 2 | 486.71 | 1 | 939.59 | 33 | SO49864 | 2023-05-28 | 75.17 | 973.41 | 469.79 | |||
SO47730_22 | 4D13-42BB-90 | PO10092115748 | 100 | 272 | 469 | 252 | 2 | 2022-12-02 | 91.18 | 2.28 | 2022-11-20 | 4 | 15.67 | 1 | 91.18 | 22 | SO47730 | 2022-11-27 | 7.29 | 62.68 | 22.79 | |||
SO48392_9 | B9C7-4F4D-82 | PO9483147187 | 100 | 281 | 433 | 54 | 2 | 2023-02-01 | 648.91 | 16.22 | 2023-01-20 | 2 | 300.12 | 1 | 648.91 | 9 | SO48392 | 2023-01-27 | 51.91 | 600.24 | 324.45 |
Generated 2024-09-20 02:43:47.472 UTC