[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 938 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO48080_25 | 4DC7-4772-87 | PO7656157590 | 100 | 282 | 460 | 403 | 4 | 2023-01-03 | 215.98 | 5.40 | 2022-12-22 | 4 | 37.12 | 1 | 215.98 | 25 | SO48080 | 2022-12-29 | 17.28 | 148.48 | 53.99 | |||
SO53606_3 | 6A19-463C-B7 | PO5539128997 | 100 | 282 | 234 | 2 | 61 | 4 | 6.38 | 2023-11-03 | 318.94 | 7.81 | 2023-10-22 | 11 | 38.49 | 1 | 312.56 | 3 | SO53606 | 2023-10-29 | 25.00 | 423.42 | 28.99 | 0.02 |
SO58992_5 | 1646-48B2-8A | PO16182112796 | 100 | 287 | 477 | 23 | 4 | 2024-02-02 | 14.97 | 0.37 | 2024-01-21 | 5 | 1.87 | 1 | 14.97 | 5 | SO58992 | 2024-01-28 | 1.20 | 9.33 | 2.99 | |||
SO50208_6 | 6993-49B4-8B | PO15689114248 | 100 | 281 | 333 | 328 | 4 | 2023-07-03 | 1879.18 | 46.98 | 2023-06-21 | 4 | 486.71 | 1 | 1879.18 | 6 | SO50208 | 2023-06-28 | 150.33 | 1946.83 | 469.79 | |||
SO49890_16 | 9B22-4240-83 | PO7859114282 | 100 | 272 | 414 | 221 | 4 | 2023-06-03 | 298.06 | 7.45 | 2023-05-22 | 2 | 110.28 | 1 | 298.06 | 16 | SO49890 | 2023-05-29 | 23.85 | 220.57 | 149.03 | |||
SO47427_21 | 61AA-44CA-99 | PO4640137176 | 100 | 287 | 470 | 3 | 648 | 4 | 15.67 | 2022-11-03 | 313.42 | 7.44 | 2022-10-22 | 15 | 15.67 | 1 | 297.75 | 21 | SO47427 | 2022-10-29 | 23.82 | 235.06 | 20.89 | 0.05 |
SO71901_5 | A2D5-443F-A5 | PO3886195400 | 100 | 281 | 484 | 165 | 4 | 2024-08-03 | 14.31 | 0.36 | 2024-07-22 | 3 | 2.97 | 1 | 14.31 | 5 | SO71901 | 2024-07-29 | 1.14 | 8.92 | 4.77 | |||
SO46634_2 | 8EF9-46A8-AA | PO10730130024 | 100 | 287 | 327 | 9 | 491 | 4 | 70.47 | 2022-09-02 | 234.90 | 4.11 | 2022-08-21 | 1 | 486.71 | 1 | 164.43 | 2 | SO46634 | 2022-08-28 | 13.15 | 486.71 | 234.90 | 0.30 |
SO48384_12 | C99C-4AEC-9E | PO7569115185 | 100 | 287 | 399 | 608 | 4 | 2023-02-02 | 67.55 | 1.69 | 2023-01-21 | 2 | 24.99 | 1 | 67.55 | 12 | SO48384 | 2023-01-28 | 5.40 | 49.99 | 33.77 | |||
SO45286_1 | AE6F-4379-99 | PO16762133534 | 100 | 282 | 315 | 259 | 4 | 2022-04-05 | 874.79 | 21.87 | 2022-03-24 | 1 | 884.71 | 1 | 874.79 | 1 | SO45286 | 2022-03-31 | 69.98 | 884.71 | 874.79 | |||
SO45291_2 | 3865-4B93-A6 | PO15689110696 | 100 | 283 | 328 | 328 | 4 | 2022-04-05 | 419.46 | 10.49 | 2022-03-24 | 1 | 413.15 | 1 | 419.46 | 2 | SO45291 | 2022-03-31 | 33.56 | 413.15 | 419.46 | |||
SO48758_8 | 709A-4AE0-B1 | PO13688180139 | 100 | 282 | 356 | 475 | 4 | 2023-03-05 | 7457.11 | 186.43 | 2023-02-21 | 6 | 1117.86 | 1 | 7457.11 | 8 | SO48758 | 2023-02-28 | 596.57 | 6707.14 | 1242.85 | |||
SO44286_2 | 27D8-4398-9C | PO16008112311 | 100 | 282 | 314 | 511 | 4 | 2021-12-03 | 2146.96 | 53.67 | 2021-11-21 | 1 | 2171.29 | 1 | 2146.96 | 2 | SO44286 | 2021-11-28 | 171.76 | 2171.29 | 2146.96 | |||
SO65244_3 | 9913-4EA4-9F | PO12992138491 | 100 | 282 | 564 | 295 | 4 | 2024-05-03 | 1430.44 | 35.76 | 2024-04-21 | 1 | 1481.94 | 1 | 1430.44 | 3 | SO65244 | 2024-04-28 | 114.44 | 1481.94 | 1430.44 | |||
SO51855_28 | 8551-4CDF-A1 | PO3480115731 | 100 | 281 | 234 | 436 | 4 | 2023-10-03 | 119.98 | 3.00 | 2023-09-21 | 4 | 38.49 | 1 | 119.98 | 28 | SO51855 | 2023-09-28 | 9.60 | 153.97 | 29.99 | |||
SO45571_9 | BAA6-412D-87 | PO7569141774 | 100 | 287 | 293 | 608 | 4 | 2022-05-03 | 1445.19 | 36.13 | 2022-04-21 | 2 | 623.84 | 1 | 1445.19 | 9 | SO45571 | 2022-04-28 | 115.62 | 1247.68 | 722.59 | |||
SO51099_8 | FF5E-417D-8D | PO13833111492 | 100 | 287 | 564 | 14 | 95 | 4 | 381.45 | 2023-09-02 | 1907.26 | 38.15 | 2023-08-21 | 2 | 1481.94 | 1 | 1525.80 | 8 | SO51099 | 2023-08-28 | 122.06 | 2963.88 | 953.63 | 0.20 |
SO71863_7 | F39F-4A8F-B9 | PO16124166561 | 100 | 282 | 545 | 649 | 4 | 2024-08-03 | 48.59 | 1.21 | 2024-07-22 | 2 | 17.98 | 1 | 48.59 | 7 | SO71863 | 2024-07-29 | 3.89 | 35.96 | 24.29 | |||
SO71811_5 | F24F-44FF-A5 | PO13717180066 | 100 | 287 | 214 | 473 | 4 | 2024-08-03 | 20.99 | 0.52 | 2024-07-22 | 1 | 13.09 | 1 | 20.99 | 5 | SO71811 | 2024-07-29 | 1.68 | 13.09 | 20.99 | |||
SO44505_4 | 5D07-4BE7-A6 | PO16037162003 | 100 | 282 | 351 | 384 | 4 | 2022-01-03 | 4049.99 | 101.25 | 2021-12-22 | 2 | 1898.09 | 1 | 4049.99 | 4 | SO44505 | 2021-12-29 | 324.00 | 3796.19 | 2024.99 | |||
SO48066_10 | F00E-4B06-9D | PO5684167807 | 100 | 282 | 354 | 385 | 4 | 2023-01-03 | 3728.56 | 93.21 | 2022-12-22 | 3 | 1117.86 | 1 | 3728.56 | 10 | SO48066 | 2022-12-29 | 298.28 | 3353.57 | 1242.85 | |||
SO50266_9 | 5A1A-4C41-B9 | PO15921150902 | 100 | 287 | 224 | 77 | 4 | 2023-07-03 | 25.93 | 0.65 | 2023-06-21 | 5 | 5.23 | 1 | 25.93 | 9 | SO50266 | 2023-06-28 | 2.07 | 26.15 | 5.19 | |||
SO47024_10 | F254-4053-A3 | PO3654136382 | 100 | 283 | 395 | 435 | 4 | 2022-10-03 | 368.24 | 9.21 | 2022-09-21 | 6 | 45.42 | 1 | 368.24 | 10 | SO47024 | 2022-09-28 | 29.46 | 272.50 | 61.37 | |||
SO69501_28 | 8A65-4926-A6 | PO6525182870 | 100 | 281 | 601 | 345 | 4 | 2024-07-03 | 97.18 | 2.43 | 2024-06-21 | 3 | 23.97 | 1 | 97.18 | 28 | SO69501 | 2024-06-28 | 7.77 | 71.91 | 32.39 | |||
SO44509_22 | FAD7-4A4C-B0 | PO15689158248 | 100 | 283 | 285 | 328 | 4 | 2022-01-03 | 535.74 | 13.39 | 2021-12-22 | 3 | 176.20 | 1 | 535.74 | 22 | SO44509 | 2021-12-29 | 42.86 | 528.60 | 178.58 | |||
SO58982_7 | EEA8-4A3B-AF | PO18125159249 | 100 | 287 | 584 | 311 | 4 | 2024-02-02 | 323.99 | 8.10 | 2024-01-21 | 1 | 343.65 | 1 | 323.99 | 7 | SO58982 | 2024-01-28 | 25.92 | 343.65 | 323.99 | |||
SO50720_9 | 38E2-4AA6-B4 | PO9715181953 | 100 | 281 | 395 | 490 | 4 | 2023-08-03 | 368.24 | 9.21 | 2023-07-22 | 6 | 45.42 | 1 | 368.24 | 9 | SO50720 | 2023-07-29 | 29.46 | 272.50 | 61.37 | |||
SO47994_17 | 284B-45A1-94 | PO15196121630 | 100 | 282 | 321 | 258 | 4 | 2023-01-03 | 2348.97 | 58.72 | 2022-12-22 | 5 | 486.71 | 1 | 2348.97 | 17 | SO47994 | 2022-12-29 | 187.92 | 2433.53 | 469.79 | |||
SO43678_18 | FBD8-4CE4-8B | PO10817150168 | 100 | 287 | 220 | 203 | 4 | 2021-09-02 | 60.56 | 1.51 | 2021-08-21 | 3 | 12.03 | 1 | 60.56 | 18 | SO43678 | 2021-08-28 | 4.84 | 36.08 | 20.19 | |||
SO48066_1 | F00E-4B06-9D | PO5684167807 | 100 | 282 | 419 | 385 | 4 | 2023-01-03 | 105.29 | 2.63 | 2022-12-22 | 2 | 38.96 | 1 | 105.29 | 1 | SO48066 | 2022-12-29 | 8.42 | 77.92 | 52.65 | |||
SO59027_30 | C142-4AAA-AB | PO6757122081 | 100 | 281 | 398 | 21 | 4 | 2024-02-02 | 106.90 | 2.67 | 2024-01-21 | 4 | 19.78 | 1 | 106.90 | 30 | SO59027 | 2024-01-28 | 8.55 | 79.10 | 26.72 |
Generated 2024-09-20 05:30:32.283 UTC