[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '2' > SHUFFLE SKIP 2000 < SKIP 1125 > < TAKE 31 >
31 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO55248_3 | 8E6C-4F5E-92 | PO13775186264 | 100 | 283 | 465 | 618 | 2 | 2023-12-02 | 58.78 | 1.47 | 2023-11-20 | 4 | 9.16 | 1 | 58.78 | 3 | SO55248 | 2023-11-27 | 4.70 | 36.64 | 14.69 |
SO46993_12 | F652-4085-A4 | PO11658111433 | 100 | 272 | 399 | 233 | 2 | 2022-10-02 | 135.10 | 3.38 | 2022-09-20 | 4 | 24.99 | 1 | 135.10 | 12 | SO46993 | 2022-09-27 | 10.81 | 99.97 | 33.77 |
SO71852_11 | 4120-429D-94 | PO20213171866 | 100 | 283 | 491 | 216 | 2 | 2024-08-02 | 194.36 | 4.86 | 2024-07-21 | 6 | 41.57 | 1 | 194.36 | 11 | SO71852 | 2024-07-28 | 15.55 | 249.43 | 32.39 |
SO47730_7 | 4D13-42BB-90 | PO10092115748 | 100 | 272 | 412 | 252 | 2 | 2022-12-02 | 180.13 | 4.50 | 2022-11-20 | 1 | 133.30 | 1 | 180.13 | 7 | SO47730 | 2022-11-27 | 14.41 | 133.30 | 180.13 |
SO50243_10 | A9CB-4732-9E | PO1769116006 | 100 | 283 | 329 | 540 | 2 | 2023-07-02 | 3758.35 | 93.96 | 2023-06-20 | 8 | 486.71 | 1 | 3758.35 | 10 | SO50243 | 2023-06-27 | 300.67 | 3893.65 | 469.79 |
SO47450_18 | 7E50-416D-A2 | PO9483124566 | 100 | 281 | 216 | 54 | 2 | 2022-11-02 | 80.75 | 2.02 | 2022-10-21 | 4 | 13.88 | 1 | 80.75 | 18 | SO47450 | 2022-10-28 | 6.46 | 55.51 | 20.19 |
SO44129_28 | CE0D-4824-A6 | PO9483186106 | 100 | 281 | 262 | 54 | 2 | 2021-11-02 | 367.88 | 9.20 | 2021-10-21 | 2 | 181.49 | 1 | 367.88 | 28 | SO44129 | 2021-10-28 | 29.43 | 362.97 | 183.94 |
SO50290_11 | 241B-4766-8D | PO3625125287 | 100 | 283 | 370 | 666 | 2 | 2023-07-02 | 1466.01 | 36.65 | 2023-06-20 | 1 | 1518.79 | 1 | 1466.01 | 11 | SO50290 | 2023-06-27 | 117.28 | 1518.79 | 1466.01 |
SO46655_22 | F5D5-409B-94 | PO3828139841 | 100 | 281 | 360 | 414 | 2 | 2022-09-01 | 2458.92 | 61.47 | 2022-08-20 | 2 | 1105.81 | 1 | 2458.92 | 22 | SO46655 | 2022-08-27 | 196.71 | 2211.62 | 1229.46 |
SO49479_21 | 12BA-4BD1-BB | PO11455112131 | 100 | 283 | 331 | 72 | 2 | 2023-05-02 | 2348.97 | 58.72 | 2023-04-20 | 5 | 486.71 | 1 | 2348.97 | 21 | SO49479 | 2023-04-27 | 187.92 | 2433.53 | 469.79 |
SO63279_4 | 6869-4687-B7 | PO3625136290 | 100 | 283 | 583 | 666 | 2 | 2024-04-03 | 2041.19 | 51.03 | 2024-03-22 | 2 | 1082.51 | 1 | 2041.19 | 4 | SO63279 | 2024-03-29 | 163.30 | 2165.02 | 1020.59 |
SO51762_12 | E7DC-4AC1-AD | PO10121132749 | 100 | 283 | 281 | 684 | 2 | 2023-10-02 | 404.66 | 10.12 | 2023-09-20 | 2 | 204.63 | 1 | 404.66 | 12 | SO51762 | 2023-09-27 | 32.37 | 409.25 | 202.33 |
SO46363_10 | 29D0-4A7E-9E | PO3190140768 | 100 | 281 | 276 | 575 | 2 | 2022-08-02 | 713.80 | 17.84 | 2022-07-21 | 2 | 352.14 | 1 | 713.80 | 10 | SO46363 | 2022-07-28 | 57.10 | 704.28 | 356.90 |
SO43883_7 | E43E-40BF-9B | PO10121175623 | 100 | 281 | 322 | 684 | 2 | 2021-10-02 | 838.92 | 20.97 | 2021-09-20 | 2 | 413.15 | 1 | 838.92 | 7 | SO43883 | 2021-09-27 | 67.11 | 826.29 | 419.46 |
SO47718_3 | B391-4A07-98 | PO6699137967 | 100 | 281 | 407 | 234 | 2 | 2022-12-02 | 393.61 | 9.84 | 2022-11-20 | 6 | 48.55 | 1 | 393.61 | 3 | SO47718 | 2022-11-27 | 31.49 | 291.27 | 65.60 |
SO51157_12 | 927E-4DB1-A3 | PO3828155781 | 100 | 283 | 398 | 414 | 2 | 2023-09-01 | 53.45 | 1.34 | 2023-08-20 | 2 | 19.78 | 1 | 53.45 | 12 | SO51157 | 2023-08-27 | 4.28 | 39.55 | 26.72 |
SO43907_7 | 9CB1-46F4-8A | PO6641115253 | 100 | 281 | 314 | 342 | 2 | 2021-10-02 | 2146.96 | 53.67 | 2021-09-20 | 1 | 2171.29 | 1 | 2146.96 | 7 | SO43907 | 2021-09-27 | 171.76 | 2171.29 | 2146.96 |
SO50263_20 | 7D74-4A96-A3 | PO18183117532 | 100 | 283 | 420 | 667 | 2 | 2023-07-02 | 283.23 | 7.08 | 2023-06-20 | 2 | 104.80 | 1 | 283.23 | 20 | SO50263 | 2023-06-27 | 22.66 | 209.59 | 141.62 |
SO46620_28 | FEE3-4994-8E | PO13775143788 | 100 | 281 | 224 | 618 | 2 | 2022-09-01 | 20.75 | 0.52 | 2022-08-20 | 4 | 5.23 | 1 | 20.75 | 28 | SO46620 | 2022-08-27 | 1.66 | 20.92 | 5.19 |
SO46993_8 | F652-4085-A4 | PO11658111433 | 100 | 272 | 409 | 233 | 2 | 2022-10-02 | 627.77 | 15.69 | 2022-09-20 | 3 | 185.82 | 1 | 627.77 | 8 | SO46993 | 2022-09-27 | 50.22 | 557.46 | 209.26 |
SO59012_15 | 6620-4CEA-A0 | PO7685122244 | 100 | 283 | 561 | 539 | 2 | 2024-02-01 | 1430.44 | 35.76 | 2024-01-20 | 1 | 1481.94 | 1 | 1430.44 | 15 | SO59012 | 2024-01-27 | 114.44 | 1481.94 | 1430.44 |
SO51157_51 | 927E-4DB1-A3 | PO3828155781 | 100 | 283 | 544 | 414 | 2 | 2023-09-01 | 97.19 | 2.43 | 2023-08-20 | 2 | 35.96 | 1 | 97.19 | 51 | SO51157 | 2023-08-27 | 7.78 | 71.92 | 48.59 |
SO46059_16 | ECBE-4E0D-B9 | PO12006169607 | 100 | 281 | 322 | 270 | 2 | 2022-07-02 | 1258.38 | 31.46 | 2022-06-20 | 3 | 413.15 | 1 | 1258.38 | 16 | SO46059 | 2022-06-27 | 100.67 | 1239.44 | 419.46 |
SO49157_18 | 9DDB-4852-A8 | PO7424122254 | 100 | 283 | 421 | 642 | 2 | 2023-04-04 | 785.32 | 19.63 | 2023-03-23 | 4 | 145.28 | 1 | 785.32 | 18 | SO49157 | 2023-03-30 | 62.83 | 581.13 | 196.33 |
SO47976_10 | 1D33-4555-83 | PO18183173367 | 100 | 281 | 365 | 667 | 2 | 2023-01-02 | 2591.98 | 64.80 | 2022-12-21 | 4 | 598.44 | 1 | 2591.98 | 10 | SO47976 | 2022-12-28 | 207.36 | 2393.74 | 647.99 |
SO48017_14 | 40DA-4972-BB | PO11658177389 | 100 | 281 | 459 | 233 | 2 | 2023-01-02 | 53.99 | 1.35 | 2022-12-21 | 1 | 37.12 | 1 | 53.99 | 14 | SO48017 | 2022-12-28 | 4.32 | 37.12 | 53.99 |
SO48017_25 | 40DA-4972-BB | PO11658177389 | 100 | 281 | 366 | 233 | 2 | 2023-01-02 | 1295.99 | 32.40 | 2022-12-21 | 2 | 598.44 | 1 | 1295.99 | 25 | SO48017 | 2022-12-28 | 103.68 | 1196.87 | 647.99 |
SO57141_3 | 5DE1-45D6-8B | PO3625112721 | 100 | 283 | 384 | 666 | 2 | 2024-01-02 | 2016.88 | 50.42 | 2023-12-21 | 3 | 713.08 | 1 | 2016.88 | 3 | SO57141 | 2023-12-28 | 161.35 | 2139.24 | 672.29 |
SO45309_5 | 4B9D-4285-B7 | PO10121162847 | 100 | 281 | 332 | 684 | 2 | 2022-04-04 | 838.92 | 20.97 | 2022-03-23 | 2 | 413.15 | 1 | 838.92 | 5 | SO45309 | 2022-03-30 | 67.11 | 826.29 | 419.46 |
SO46368_9 | BF32-47A9-90 | PO4408111909 | 100 | 281 | 320 | 143 | 2 | 2022-08-02 | 419.46 | 10.49 | 2022-07-21 | 1 | 413.15 | 1 | 419.46 | 9 | SO46368 | 2022-07-28 | 33.56 | 413.15 | 419.46 |
SO47718_36 | B391-4A07-98 | PO6699137967 | 100 | 281 | 371 | 234 | 2 | 2022-12-02 | 3926.81 | 98.17 | 2022-11-20 | 3 | 1320.68 | 1 | 3926.81 | 36 | SO47718 | 2022-11-27 | 314.15 | 3962.05 | 1308.94 |
Generated 2024-09-20 02:36:06.998 UTC