[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '2' > SKIP 0 SHUFFLE < SKIP 1141 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO51112_11 | 6C36-4086-8D | PO11687117332 | 100 | 283 | 577 | 691 | 2 | 2023-09-03 | 1457.82 | 36.45 | 2023-08-22 | 2 | 755.15 | 1 | 1457.82 | 11 | SO51112 | 2023-08-29 | 116.63 | 1510.30 | 728.91 | |||
SO48392_37 | B9C7-4F4D-82 | PO9483147187 | 100 | 281 | 439 | 54 | 2 | 2023-02-03 | 780.82 | 19.52 | 2023-01-22 | 1 | 722.26 | 1 | 780.82 | 37 | SO48392 | 2023-01-29 | 62.47 | 722.26 | 780.82 | |||
SO51770_3 | 9F77-4259-BE | PO1769187686 | 100 | 283 | 434 | 540 | 2 | 2023-10-04 | 713.80 | 17.84 | 2023-09-22 | 2 | 360.94 | 1 | 713.80 | 3 | SO51770 | 2023-09-29 | 57.10 | 721.89 | 356.90 | |||
SO69467_14 | A38D-4E1B-93 | PO2871181396 | 100 | 283 | 560 | 522 | 2 | 2024-07-04 | 2186.73 | 54.67 | 2024-06-22 | 3 | 755.15 | 1 | 2186.73 | 14 | SO69467 | 2024-06-29 | 174.94 | 2265.45 | 728.91 | |||
SO47001_39 | DD9D-4987-9E | PO10121150577 | 100 | 281 | 433 | 684 | 2 | 2022-10-04 | 2595.62 | 64.89 | 2022-09-22 | 8 | 300.12 | 1 | 2595.62 | 39 | SO47001 | 2022-09-29 | 207.65 | 2400.95 | 324.45 | |||
SO48770_14 | 28CC-48AC-B8 | PO11484112888 | 100 | 283 | 420 | 594 | 2 | 2023-03-06 | 566.46 | 14.16 | 2023-02-22 | 4 | 104.80 | 1 | 566.46 | 14 | SO48770 | 2023-03-01 | 45.32 | 419.18 | 141.62 | |||
SO44114_4 | 3082-4C08-AA | PO3190199320 | 100 | 281 | 275 | 575 | 2 | 2021-11-04 | 713.80 | 17.84 | 2021-10-23 | 2 | 352.14 | 1 | 713.80 | 4 | SO44114 | 2021-10-30 | 57.10 | 704.28 | 356.90 | |||
SO48077_11 | 02FD-483D-8C | PO7453110437 | 100 | 281 | 273 | 108 | 2 | 2023-01-04 | 404.66 | 10.12 | 2022-12-23 | 2 | 187.16 | 1 | 404.66 | 11 | SO48077 | 2022-12-30 | 32.37 | 374.31 | 202.33 | |||
SO51141_1 | 50A2-4F77-84 | PO10092119028 | 100 | 283 | 290 | 252 | 2 | 2023-09-03 | 818.70 | 20.47 | 2023-08-22 | 1 | 747.20 | 1 | 818.70 | 1 | SO51141 | 2023-08-29 | 65.50 | 747.20 | 818.70 | |||
SO47975_39 | 5E8C-4BD8-B5 | PO18386179371 | 100 | 281 | 265 | 558 | 2 | 2023-01-04 | 607.00 | 15.17 | 2022-12-23 | 3 | 187.16 | 1 | 607.00 | 39 | SO47975 | 2022-12-30 | 48.56 | 561.47 | 202.33 | |||
SO51794_3 | 8FDF-461F-8D | PO18792199024 | 100 | 283 | 513 | 378 | 2 | 2023-10-04 | 873.82 | 21.85 | 2023-09-22 | 4 | 199.38 | 1 | 873.82 | 3 | SO51794 | 2023-09-29 | 69.91 | 797.50 | 218.45 | |||
SO44293_23 | A1AE-48E7-A4 | PO13775127212 | 100 | 281 | 332 | 618 | 2 | 2021-12-04 | 838.92 | 20.97 | 2021-11-22 | 2 | 413.15 | 1 | 838.92 | 23 | SO44293 | 2021-11-29 | 67.11 | 826.29 | 419.46 | |||
SO46948_11 | B040-4261-B3 | PO18386128096 | 100 | 281 | 327 | 9 | 558 | 2 | 70.47 | 2022-10-04 | 234.90 | 4.11 | 2022-09-22 | 1 | 486.71 | 1 | 164.43 | 11 | SO46948 | 2022-09-29 | 13.15 | 486.71 | 234.90 | 0.30 |
SO47685_24 | CC2F-4D47-8C | PO11484129630 | 100 | 281 | 352 | 594 | 2 | 2022-12-04 | 8699.96 | 217.50 | 2022-11-22 | 7 | 1117.86 | 1 | 8699.96 | 24 | SO47685 | 2022-11-29 | 696.00 | 7824.99 | 1242.85 | |||
SO51112_18 | 6C36-4086-8D | PO11687117332 | 100 | 283 | 548 | 691 | 2 | 2023-09-03 | 97.19 | 2.43 | 2023-08-22 | 2 | 35.96 | 1 | 97.19 | 18 | SO51112 | 2023-08-29 | 7.78 | 71.92 | 48.59 | |||
SO46994_24 | 5E92-4A19-9E | PO11629171210 | 100 | 281 | 468 | 396 | 2 | 2022-10-04 | 45.59 | 1.14 | 2022-09-22 | 2 | 15.67 | 1 | 45.59 | 24 | SO46994 | 2022-09-29 | 3.65 | 31.34 | 22.79 | |||
SO49864_17 | D282-4C24-9B | PO13775121562 | 100 | 283 | 456 | 618 | 2 | 2023-06-04 | 134.98 | 3.37 | 2023-05-23 | 3 | 30.93 | 1 | 134.98 | 17 | SO49864 | 2023-05-30 | 10.80 | 92.80 | 44.99 | |||
SO49864_16 | D282-4C24-9B | PO13775121562 | 100 | 283 | 433 | 618 | 2 | 2023-06-04 | 1622.26 | 40.56 | 2023-05-23 | 5 | 300.12 | 1 | 1622.26 | 16 | SO49864 | 2023-05-30 | 129.78 | 1500.59 | 324.45 | |||
SO47975_19 | 5E8C-4BD8-B5 | PO18386179371 | 100 | 281 | 458 | 558 | 2 | 2023-01-04 | 44.99 | 1.12 | 2022-12-23 | 1 | 30.93 | 1 | 44.99 | 19 | SO47975 | 2022-12-30 | 3.60 | 30.93 | 44.99 | |||
SO47395_40 | 98F1-44B4-97 | PO11455133549 | 100 | 281 | 460 | 72 | 2 | 2022-11-04 | 323.96 | 8.10 | 2022-10-23 | 6 | 37.12 | 1 | 323.96 | 40 | SO47395 | 2022-10-30 | 25.92 | 222.73 | 53.99 | |||
SO47976_3 | 1D33-4555-83 | PO18183173367 | 100 | 281 | 401 | 667 | 2 | 2023-01-04 | 131.20 | 3.28 | 2022-12-23 | 2 | 48.55 | 1 | 131.20 | 3 | SO47976 | 2022-12-30 | 10.50 | 97.09 | 65.60 | |||
SO45803_1 | 6F0B-4638-93 | PO1566112039 | 100 | 281 | 315 | 486 | 2 | 2022-06-04 | 2624.38 | 65.61 | 2022-05-23 | 3 | 884.71 | 1 | 2624.38 | 1 | SO45803 | 2022-05-30 | 209.95 | 2654.12 | 874.79 | |||
SO50683_4 | 8EBE-4D2C-AB | PO11455112273 | 100 | 283 | 407 | 72 | 2 | 2023-08-04 | 65.60 | 1.64 | 2023-07-23 | 1 | 48.55 | 1 | 65.60 | 4 | SO50683 | 2023-07-30 | 5.25 | 48.55 | 65.60 | |||
SO47395_35 | 98F1-44B4-97 | PO11455133549 | 100 | 281 | 331 | 72 | 2 | 2022-11-04 | 2818.76 | 70.47 | 2022-10-23 | 6 | 486.71 | 1 | 2818.76 | 35 | SO47395 | 2022-10-30 | 225.50 | 2920.24 | 469.79 | |||
SO47450_51 | 7E50-416D-A2 | PO9483124566 | 100 | 281 | 375 | 54 | 2 | 2022-11-04 | 2617.88 | 65.45 | 2022-10-23 | 2 | 1320.68 | 1 | 2617.88 | 51 | SO47450 | 2022-10-30 | 209.43 | 2641.37 | 1308.94 | |||
SO46610_15 | B7D1-4895-B6 | PO17197125590 | 100 | 281 | 354 | 125 | 2 | 2022-09-03 | 9942.81 | 248.57 | 2022-08-22 | 8 | 1117.86 | 1 | 9942.81 | 15 | SO46610 | 2022-08-29 | 795.43 | 8942.85 | 1242.85 | |||
SO67282_25 | 50CB-4642-B1 | PO11687162635 | 100 | 283 | 577 | 691 | 2 | 2024-06-04 | 1457.82 | 36.45 | 2024-05-23 | 2 | 755.15 | 1 | 1457.82 | 25 | SO67282 | 2024-05-30 | 116.63 | 1510.30 | 728.91 | |||
SO46994_5 | 5E92-4A19-9E | PO11629171210 | 100 | 281 | 410 | 396 | 2 | 2022-10-04 | 72.89 | 1.82 | 2022-09-22 | 2 | 26.97 | 1 | 72.89 | 5 | SO46994 | 2022-09-29 | 5.83 | 53.94 | 36.45 | |||
SO45335_2 | CF69-4308-92 | PO6641155631 | 100 | 281 | 223 | 342 | 2 | 2022-04-06 | 25.93 | 0.65 | 2022-03-25 | 5 | 5.71 | 1 | 25.93 | 2 | SO45335 | 2022-04-01 | 2.07 | 28.53 | 5.19 | |||
SO49518_33 | AF02-4E4D-BA | PO9483189305 | 100 | 283 | 373 | 54 | 2 | 2023-05-04 | 3926.81 | 98.17 | 2023-04-22 | 3 | 1320.68 | 1 | 3926.81 | 33 | SO49518 | 2023-04-29 | 314.15 | 3962.05 | 1308.94 |
Generated 2024-09-21 07:32:42.106 UTC