[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '2' > SHUFFLE SKIP 0 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO48026_14 | E497-4BCF-A5 | PO10121196875 | 100 | 281 | 439 | 684 | 2 | 2022-10-21 | 780.82 | 19.52 | 2022-10-09 | 1 | 722.26 | 1 | 780.82 | 14 | SO48026 | 2022-10-16 | 62.47 | 722.26 | 780.82 | |||
SO50727_7 | 5DD5-4A9A-B1 | PO9483181443 | 100 | 283 | 369 | 54 | 2 | 2023-05-21 | 2932.02 | 73.30 | 2023-05-09 | 2 | 1518.79 | 1 | 2932.02 | 7 | SO50727 | 2023-05-16 | 234.56 | 3037.57 | 1466.01 | |||
SO59075_43 | 1ED6-419E-AF | PO9628136689 | 100 | 283 | 463 | 179 | 2 | 2023-11-20 | 44.08 | 1.10 | 2023-11-08 | 3 | 9.16 | 1 | 44.08 | 43 | SO59075 | 2023-11-15 | 3.53 | 27.48 | 14.69 | |||
SO48753_9 | 1DDA-42B2-AF | PO17197151135 | 100 | 283 | 420 | 125 | 2 | 2022-12-21 | 141.62 | 3.54 | 2022-12-09 | 1 | 104.80 | 1 | 141.62 | 9 | SO48753 | 2022-12-16 | 11.33 | 104.80 | 141.62 | |||
SO59012_43 | 6620-4CEA-A0 | PO7685122244 | 100 | 283 | 558 | 539 | 2 | 2023-11-20 | 971.98 | 24.30 | 2023-11-08 | 4 | 179.82 | 1 | 971.98 | 43 | SO59012 | 2023-11-15 | 77.76 | 719.26 | 242.99 | |||
SO50258_1 | 838F-4C0C-86 | PO3161121594 | 100 | 283 | 224 | 359 | 2 | 2023-04-20 | 10.37 | 0.26 | 2023-04-08 | 2 | 5.23 | 1 | 10.37 | 1 | SO50258 | 2023-04-15 | 0.83 | 10.46 | 5.19 | |||
SO46385_6 | F727-48F0-AF | PO9483110086 | 100 | 281 | 342 | 2 | 54 | 2 | 113.53 | 2022-05-21 | 5676.68 | 139.08 | 2022-05-09 | 14 | 413.15 | 1 | 5563.14 | 6 | SO46385 | 2022-05-16 | 445.05 | 5784.05 | 405.48 | 0.02 |
SO46095_9 | A60D-4721-BF | PO6641179809 | 100 | 281 | 215 | 342 | 2 | 2022-04-20 | 100.93 | 2.52 | 2022-04-08 | 5 | 12.03 | 1 | 100.93 | 9 | SO46095 | 2022-04-15 | 8.07 | 60.14 | 20.19 | |||
SO49068_5 | 8B30-4893-8C | PO1769149811 | 100 | 283 | 323 | 540 | 2 | 2023-01-21 | 3288.56 | 82.21 | 2023-01-09 | 7 | 486.71 | 1 | 3288.56 | 5 | SO49068 | 2023-01-16 | 263.08 | 3406.95 | 469.79 | |||
SO49843_29 | D3CA-4A51-B6 | PO11484175391 | 100 | 283 | 410 | 594 | 2 | 2023-03-21 | 182.24 | 4.56 | 2023-03-09 | 5 | 26.97 | 1 | 182.24 | 29 | SO49843 | 2023-03-16 | 14.58 | 134.85 | 36.45 | |||
SO45277_1 | 0ED8-411E-88 | PO18386174353 | 100 | 281 | 313 | 558 | 2 | 2022-01-21 | 2146.96 | 53.67 | 2022-01-09 | 1 | 2171.29 | 1 | 2146.96 | 1 | SO45277 | 2022-01-16 | 171.76 | 2171.29 | 2146.96 | |||
SO45302_10 | 485F-48BA-86 | PO12006146340 | 100 | 281 | 326 | 270 | 2 | 2022-01-21 | 419.46 | 10.49 | 2022-01-09 | 1 | 413.15 | 1 | 419.46 | 10 | SO45302 | 2022-01-16 | 33.56 | 413.15 | 419.46 | |||
SO45809_8 | D8A0-4462-8A | PO5365154898 | 100 | 281 | 262 | 161 | 2 | 2022-03-21 | 183.94 | 4.60 | 2022-03-09 | 1 | 181.49 | 1 | 183.94 | 8 | SO45809 | 2022-03-16 | 14.72 | 181.49 | 183.94 | |||
SO53567_30 | 2385-4ADE-B6 | PO9628113784 | 100 | 283 | 231 | 179 | 2 | 2023-08-21 | 179.96 | 4.50 | 2023-08-09 | 6 | 38.49 | 1 | 179.96 | 30 | SO53567 | 2023-08-16 | 14.40 | 230.95 | 29.99 | |||
SO45807_1 | EA8F-4F7A-AA | PO4959174388 | 100 | 281 | 238 | 269 | 2 | 2022-03-21 | 1516.15 | 37.90 | 2022-03-09 | 2 | 747.97 | 1 | 1516.15 | 1 | SO45807 | 2022-03-16 | 121.29 | 1495.94 | 758.08 | |||
SO47730_10 | 4D13-42BB-90 | PO10092115748 | 100 | 272 | 470 | 252 | 2 | 2022-09-20 | 136.76 | 3.42 | 2022-09-08 | 6 | 15.67 | 1 | 136.76 | 10 | SO47730 | 2022-09-15 | 10.94 | 94.03 | 22.79 | |||
SO48781_1 | 6591-47F7-B9 | PO4959133095 | 100 | 283 | 454 | 269 | 2 | 2022-12-21 | 35.99 | 0.90 | 2022-12-09 | 1 | 24.75 | 1 | 35.99 | 1 | SO48781 | 2022-12-16 | 2.88 | 24.75 | 35.99 | |||
SO63200_9 | E73D-4A02-88 | PO11658161535 | 100 | 283 | 475 | 233 | 2 | 2024-01-21 | 41.99 | 1.05 | 2024-01-09 | 1 | 26.18 | 1 | 41.99 | 9 | SO63200 | 2024-01-16 | 3.36 | 26.18 | 41.99 | |||
SO51748_64 | 1D77-486A-86 | PO11658169327 | 100 | 283 | 487 | 2 | 233 | 2 | 8.93 | 2023-07-21 | 446.52 | 10.94 | 2023-07-09 | 14 | 20.57 | 1 | 437.59 | 64 | SO51748 | 2023-07-16 | 35.01 | 287.93 | 31.89 | 0.02 |
SO44129_16 | CE0D-4824-A6 | PO9483186106 | 100 | 281 | 212 | 54 | 2 | 2021-08-21 | 40.37 | 1.01 | 2021-08-09 | 2 | 12.03 | 1 | 40.37 | 16 | SO44129 | 2021-08-16 | 3.23 | 24.06 | 20.19 | |||
SO67271_16 | E734-4CEC-A8 | PO13775181029 | 100 | 283 | 390 | 618 | 2 | 2024-03-21 | 2016.88 | 50.42 | 2024-03-09 | 3 | 713.08 | 1 | 2016.88 | 16 | SO67271 | 2024-03-16 | 161.35 | 2139.24 | 672.29 | |||
SO46666_34 | 1A94-4D1F-AF | PO6699130779 | 100 | 281 | 383 | 234 | 2 | 2022-06-20 | 6002.63 | 150.07 | 2022-06-08 | 10 | 605.65 | 1 | 6002.63 | 34 | SO46666 | 2022-06-15 | 480.21 | 6056.49 | 600.26 | |||
SO50727_33 | 5DD5-4A9A-B1 | PO9483181443 | 100 | 283 | 343 | 54 | 2 | 2023-05-21 | 2818.76 | 70.47 | 2023-05-09 | 6 | 486.71 | 1 | 2818.76 | 33 | SO50727 | 2023-05-16 | 225.50 | 2920.24 | 469.79 | |||
SO44502_2 | 5EC5-4410-9C | PO16791147707 | 100 | 281 | 253 | 36 | 2 | 2021-10-21 | 178.58 | 4.46 | 2021-10-09 | 1 | 176.20 | 1 | 178.58 | 2 | SO44502 | 2021-10-16 | 14.29 | 176.20 | 178.58 | |||
SO65245_4 | 80F6-437F-84 | PO9628129233 | 100 | 283 | 577 | 179 | 2 | 2024-02-19 | 1457.82 | 36.45 | 2024-02-07 | 2 | 755.15 | 1 | 1457.82 | 4 | SO65245 | 2024-02-14 | 116.63 | 1510.30 | 728.91 | |||
SO67282_4 | 50CB-4642-B1 | PO11687162635 | 100 | 283 | 578 | 691 | 2 | 2024-03-21 | 1457.82 | 36.45 | 2024-03-09 | 2 | 755.15 | 1 | 1457.82 | 4 | SO67282 | 2024-03-16 | 116.63 | 1510.30 | 728.91 | |||
SO61219_20 | A4CD-46F5-9E | PO11687126732 | 100 | 283 | 578 | 691 | 2 | 2023-12-21 | 1457.82 | 36.45 | 2023-12-09 | 2 | 755.15 | 1 | 1457.82 | 20 | SO61219 | 2023-12-16 | 116.63 | 1510.30 | 728.91 | |||
SO67263_1 | EFEC-4A80-8F | PO17197178016 | 100 | 283 | 357 | 125 | 2 | 2024-03-21 | 9743.96 | 243.60 | 2024-03-09 | 7 | 1265.62 | 1 | 9743.96 | 1 | SO67263 | 2024-03-16 | 779.52 | 8859.34 | 1391.99 | |||
SO57076_9 | 4D9A-45E4-88 | PO10121190262 | 100 | 283 | 440 | 684 | 2 | 2023-10-21 | 858.90 | 21.47 | 2023-10-09 | 1 | 868.63 | 1 | 858.90 | 9 | SO57076 | 2023-10-16 | 68.71 | 868.63 | 858.90 | |||
SO53570_6 | 412A-483A-A3 | PO9483124574 | 100 | 283 | 386 | 54 | 2 | 2023-08-21 | 1344.59 | 33.61 | 2023-08-09 | 2 | 713.08 | 1 | 1344.59 | 6 | SO53570 | 2023-08-16 | 107.57 | 1426.16 | 672.29 | |||
SO50311_17 | E09E-4D02-9F | PO7453115958 | 100 | 283 | 230 | 108 | 2 | 2023-04-20 | 144.20 | 3.61 | 2023-04-08 | 5 | 29.08 | 1 | 144.20 | 17 | SO50311 | 2023-04-15 | 11.54 | 145.40 | 28.84 |
Generated 2024-07-08 16:32:41.973 UTC