[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > SHUFFLE < SKIP 359 > < TAKE 32 >
32 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO45075_3 | 8934-44C4-A1 | PO8120124936 | 100 | 281 | 346 | 485 | 5 | 2022-04-25 | 4079.99 | 102.00 | 2022-04-13 | 2 | 1912.15 | 1 | 4079.99 | 3 | SO45075 | 2022-04-20 | 326.40 | 3824.31 | 2039.99 | |||
SO53530_24 | A31D-483D-A1 | PO2813121313 | 100 | 283 | 480 | 90 | 5 | 2023-12-24 | 5.50 | 0.14 | 2023-12-12 | 4 | 0.86 | 1 | 5.50 | 24 | SO53530 | 2023-12-19 | 0.44 | 3.43 | 1.37 | |||
SO49869_7 | A2BD-4A89-93 | PO9657193666 | 100 | 285 | 428 | 315 | 5 | 2023-07-24 | 418.51 | 10.46 | 2023-07-12 | 2 | 185.82 | 1 | 418.51 | 7 | SO49869 | 2023-07-19 | 33.48 | 371.64 | 209.26 | |||
SO46995_4 | 9CEA-4AC3-95 | PO11542113352 | 100 | 285 | 323 | 62 | 5 | 2022-11-23 | 469.79 | 11.74 | 2022-11-11 | 1 | 486.71 | 1 | 469.79 | 4 | SO46995 | 2022-11-18 | 37.58 | 486.71 | 469.79 | |||
SO49822_17 | 191D-4AD7-93 | PO522119337 | 100 | 285 | 460 | 676 | 5 | 2023-07-24 | 269.97 | 6.75 | 2023-07-12 | 5 | 37.12 | 1 | 269.97 | 17 | SO49822 | 2023-07-19 | 21.60 | 185.60 | 53.99 | |||
SO48015_2 | AA12-417E-B1 | PO11803141907 | 100 | 285 | 360 | 513 | 5 | 2023-02-23 | 1229.46 | 30.74 | 2023-02-11 | 1 | 1105.81 | 1 | 1229.46 | 2 | SO48015 | 2023-02-18 | 98.36 | 1105.81 | 1229.46 | |||
SO69474_10 | 2DD3-46CB-BD | PO18560139140 | 100 | 285 | 580 | 531 | 5 | 2024-08-23 | 5102.97 | 127.57 | 2024-08-11 | 5 | 1082.51 | 1 | 5102.97 | 10 | SO69474 | 2024-08-18 | 408.24 | 5412.55 | 1020.59 | |||
SO51110_5 | 2713-42DF-AC | PO11861142261 | 100 | 283 | 484 | 17 | 5 | 2023-10-23 | 14.31 | 0.36 | 2023-10-11 | 3 | 2.97 | 1 | 14.31 | 5 | SO51110 | 2023-10-18 | 1.14 | 8.92 | 4.77 | |||
SO46654_8 | 2FEC-47CC-84 | PO3741124832 | 100 | 285 | 433 | 404 | 5 | 2022-10-23 | 973.36 | 24.33 | 2022-10-11 | 3 | 300.12 | 1 | 973.36 | 8 | SO46654 | 2022-10-18 | 77.87 | 900.36 | 324.45 | |||
SO44801_3 | 4DBD-4E98-A7 | PO9599152040 | 100 | 285 | 324 | 170 | 5 | 2022-03-25 | 2097.29 | 52.43 | 2022-03-13 | 5 | 413.15 | 1 | 2097.29 | 3 | SO44801 | 2022-03-20 | 167.78 | 2065.73 | 419.46 | |||
SO46933_28 | 4D88-4B51-BF | PO19546168601 | 100 | 285 | 385 | 206 | 5 | 2022-11-23 | 1800.79 | 45.02 | 2022-11-11 | 3 | 605.65 | 1 | 1800.79 | 28 | SO46933 | 2022-11-18 | 144.06 | 1816.95 | 600.26 | |||
SO46387_11 | 5AA4-4F68-A1 | PO9599173396 | 100 | 285 | 313 | 170 | 5 | 2022-09-23 | 4293.92 | 107.35 | 2022-09-11 | 2 | 2171.29 | 1 | 4293.92 | 11 | SO46387 | 2022-09-18 | 343.51 | 4342.59 | 2146.96 | |||
SO44488_8 | 18BD-4C15-81 | PO19546136242 | 100 | 285 | 232 | 206 | 5 | 2022-02-23 | 57.68 | 1.44 | 2022-02-11 | 2 | 31.72 | 1 | 57.68 | 8 | SO44488 | 2022-02-18 | 4.61 | 63.45 | 28.84 | |||
SO47416_5 | 6B45-44AB-84 | PO2813155355 | 100 | 281 | 230 | 90 | 5 | 2022-12-24 | 86.52 | 2.16 | 2022-12-12 | 3 | 29.08 | 1 | 86.52 | 5 | SO47416 | 2022-12-19 | 6.92 | 87.24 | 28.84 | |||
SO44306_11 | 464C-43BA-9F | PO1189114917 | 100 | 285 | 229 | 423 | 5 | 2022-01-23 | 86.52 | 2.16 | 2022-01-11 | 3 | 31.72 | 1 | 86.52 | 11 | SO44306 | 2022-01-18 | 6.92 | 95.17 | 28.84 | |||
SO59071_27 | EFC3-4244-A6 | PO9599176835 | 100 | 285 | 380 | 170 | 5 | 2024-03-24 | 4398.03 | 109.95 | 2024-03-12 | 3 | 1554.95 | 1 | 4398.03 | 27 | SO59071 | 2024-03-19 | 351.84 | 4664.84 | 1466.01 | |||
SO53530_25 | A31D-483D-A1 | PO2813121313 | 100 | 283 | 471 | 3 | 90 | 5 | 31.43 | 2023-12-24 | 628.65 | 14.93 | 2023-12-12 | 18 | 23.75 | 1 | 597.22 | 25 | SO53530 | 2023-12-19 | 47.78 | 427.48 | 34.93 | 0.05 |
SO53563_8 | C955-44BD-A8 | PO9599165865 | 100 | 285 | 584 | 170 | 5 | 2023-12-24 | 1943.96 | 48.60 | 2023-12-12 | 6 | 343.65 | 1 | 1943.96 | 8 | SO53563 | 2023-12-19 | 155.52 | 2061.90 | 323.99 | |||
SO65220_11 | 6D87-4C24-98 | PO15457146892 | 100 | 285 | 573 | 297 | 5 | 2024-06-23 | 1430.44 | 35.76 | 2024-06-11 | 1 | 1481.94 | 1 | 1430.44 | 11 | SO65220 | 2024-06-18 | 114.44 | 1481.94 | 1430.44 | |||
SO63281_7 | 6B19-4C4E-92 | PO3596158829 | 100 | 285 | 600 | 476 | 5 | 2024-05-25 | 323.99 | 8.10 | 2024-05-13 | 1 | 294.58 | 1 | 323.99 | 7 | SO63281 | 2024-05-20 | 25.92 | 294.58 | 323.99 | |||
SO49878_2 | 3EF0-4F28-B3 | PO3741190259 | 100 | 285 | 323 | 404 | 5 | 2023-07-24 | 939.59 | 23.49 | 2023-07-12 | 2 | 486.71 | 1 | 939.59 | 2 | SO49878 | 2023-07-19 | 75.17 | 973.41 | 469.79 | |||
SO45802_1 | 8C6D-42B3-AA | PO1189157476 | 100 | 285 | 253 | 423 | 5 | 2022-07-24 | 178.58 | 4.46 | 2022-07-12 | 1 | 176.20 | 1 | 178.58 | 1 | SO45802 | 2022-07-19 | 14.29 | 176.20 | 178.58 | |||
SO46349_1 | C053-4BA7-A1 | PO11977118598 | 100 | 285 | 238 | 675 | 5 | 2022-09-23 | 758.08 | 18.95 | 2022-09-11 | 1 | 747.97 | 1 | 758.08 | 1 | SO46349 | 2022-09-18 | 60.65 | 747.97 | 758.08 | |||
SO46654_10 | 2FEC-47CC-84 | PO3741124832 | 100 | 285 | 327 | 9 | 404 | 5 | 140.94 | 2022-10-23 | 469.79 | 8.22 | 2022-10-11 | 2 | 486.71 | 1 | 328.86 | 10 | SO46654 | 2022-10-18 | 26.31 | 973.41 | 234.90 | 0.30 |
SO45805_8 | 4E35-406B-B7 | PO3393138494 | 100 | 285 | 270 | 549 | 5 | 2022-07-24 | 367.88 | 9.20 | 2022-07-12 | 2 | 181.49 | 1 | 367.88 | 8 | SO45805 | 2022-07-19 | 29.43 | 362.97 | 183.94 | |||
SO45802_3 | 8C6D-42B3-AA | PO1189157476 | 100 | 285 | 270 | 423 | 5 | 2022-07-24 | 551.81 | 13.80 | 2022-07-12 | 3 | 181.49 | 1 | 551.81 | 3 | SO45802 | 2022-07-19 | 44.15 | 544.46 | 183.94 | |||
SO65229_6 | 7557-4EA8-AD | PO11977163025 | 100 | 285 | 482 | 675 | 5 | 2024-06-23 | 10.79 | 0.27 | 2024-06-11 | 2 | 3.36 | 1 | 10.79 | 6 | SO65229 | 2024-06-18 | 0.86 | 6.72 | 5.39 | |||
SO44549_5 | 2479-4173-87 | PO5568135148 | 100 | 285 | 350 | 422 | 5 | 2022-02-23 | 8099.98 | 202.50 | 2022-02-11 | 4 | 1898.09 | 1 | 8099.98 | 5 | SO44549 | 2022-02-18 | 648.00 | 7592.38 | 2024.99 | |||
SO46673_28 | 578D-4F7B-A6 | PO9657163155 | 100 | 285 | 352 | 315 | 5 | 2022-10-23 | 2485.70 | 62.14 | 2022-10-11 | 2 | 1117.86 | 1 | 2485.70 | 28 | SO46673 | 2022-10-18 | 198.86 | 2235.71 | 1242.85 | |||
SO55234_1 | C6FC-46EE-88 | PO522140495 | 100 | 285 | 590 | 676 | 5 | 2024-01-23 | 461.69 | 11.54 | 2024-01-11 | 1 | 419.78 | 1 | 461.69 | 1 | SO55234 | 2024-01-18 | 36.94 | 419.78 | 461.69 | |||
SO44098_6 | AB18-4E5B-98 | PO13746121367 | 100 | 285 | 350 | 567 | 5 | 2021-12-24 | 6074.98 | 151.87 | 2021-12-12 | 3 | 1898.09 | 1 | 6074.98 | 6 | SO44098 | 2021-12-19 | 486.00 | 5694.28 | 2024.99 | |||
SO48393_20 | 5B6A-41B6-BF | PO9599137631 | 100 | 285 | 407 | 170 | 5 | 2023-03-25 | 196.81 | 4.92 | 2023-03-13 | 3 | 48.55 | 1 | 196.81 | 20 | SO48393 | 2023-03-20 | 15.74 | 145.64 | 65.60 |
Generated 2024-11-10 23:00:22.076 UTC