[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE < SKIP 7159 > < TAKE 24 >
24 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO49827_13 | E4F0-4B91-84 | PO15312199090 | 19 | 291 | 325 | 299 | 6 | 2023-06-04 | 1409.38 | 35.23 | 2023-05-23 | 3 | 486.71 | 1 | 1409.38 | 13 | SO49827 | 2023-05-30 | 112.75 | 1460.12 | 469.79 | |||
SO47670_34 | 0CD2-463E-8F | PO14732184884 | 19 | 291 | 385 | 514 | 6 | 2022-12-04 | 600.26 | 15.01 | 2022-11-22 | 1 | 605.65 | 1 | 600.26 | 34 | SO47670 | 2022-11-29 | 48.02 | 605.65 | 600.26 | |||
SO47988_30 | 3979-4615-A9 | PO16733190266 | 19 | 291 | 335 | 533 | 6 | 2023-01-04 | 1409.38 | 35.23 | 2022-12-23 | 3 | 486.71 | 1 | 1409.38 | 30 | SO47988 | 2022-12-30 | 112.75 | 1460.12 | 469.79 | |||
SO49828_7 | 8223-49DF-83 | PO14732189078 | 19 | 291 | 422 | 514 | 6 | 2023-06-04 | 202.62 | 5.07 | 2023-05-23 | 3 | 49.98 | 1 | 202.62 | 7 | SO49828 | 2023-05-30 | 16.21 | 149.94 | 67.54 | |||
SO69520_16 | 654B-484B-8F | PO4466144794 | 19 | 291 | 542 | 352 | 6 | 2024-07-04 | 48.59 | 1.21 | 2024-06-22 | 2 | 17.98 | 1 | 48.59 | 16 | SO69520 | 2024-06-29 | 3.89 | 35.96 | 24.29 | |||
SO65188_5 | 86B3-49B3-A1 | PO14790112162 | 19 | 291 | 474 | 497 | 6 | 2024-05-04 | 377.95 | 9.45 | 2024-04-22 | 9 | 26.18 | 1 | 377.95 | 5 | SO65188 | 2024-04-29 | 30.24 | 235.59 | 41.99 | |||
SO67316_17 | 6F7E-4455-9E | PO4495115494 | 19 | 291 | 355 | 496 | 6 | 2024-06-04 | 8351.96 | 208.80 | 2024-05-23 | 6 | 1265.62 | 1 | 8351.96 | 17 | SO67316 | 2024-05-30 | 668.16 | 7593.72 | 1391.99 | |||
SO46645_13 | F857-4A6D-9C | PO1711132491 | 19 | 291 | 362 | 245 | 6 | 2022-09-03 | 6147.29 | 153.68 | 2022-08-22 | 5 | 1105.81 | 1 | 6147.29 | 13 | SO46645 | 2022-08-29 | 491.78 | 5529.05 | 1229.46 | |||
SO51160_22 | 3F3F-4135-B0 | PO4495157262 | 19 | 291 | 513 | 496 | 6 | 2023-09-03 | 1310.72 | 32.77 | 2023-08-22 | 6 | 199.38 | 1 | 1310.72 | 22 | SO51160 | 2023-08-29 | 104.86 | 1196.25 | 218.45 | |||
SO48025_2 | AE8D-4A49-83 | PO10469118037 | 19 | 291 | 469 | 335 | 6 | 2023-01-04 | 45.59 | 1.14 | 2022-12-23 | 2 | 15.67 | 1 | 45.59 | 2 | SO48025 | 2022-12-30 | 3.65 | 31.34 | 22.79 | |||
SO51703_26 | 53F7-4B59-AA | PO17603160217 | 19 | 284 | 490 | 12 | 6 | 2023-10-04 | 226.76 | 5.67 | 2023-09-22 | 7 | 41.57 | 1 | 226.76 | 26 | SO51703 | 2023-09-29 | 18.14 | 291.01 | 32.39 | |||
SO58981_22 | 2B52-4247-AF | PO18299143459 | 19 | 291 | 295 | 118 | 6 | 2024-02-03 | 818.70 | 20.47 | 2024-01-22 | 1 | 747.20 | 1 | 818.70 | 22 | SO58981 | 2024-01-29 | 65.50 | 747.20 | 818.70 | |||
SO46352_3 | A467-4700-9C | PO10585133264 | 19 | 284 | 350 | 7 | 498 | 6 | 885.93 | 2022-08-04 | 2531.24 | 41.13 | 2022-07-23 | 3 | 1898.09 | 1 | 1645.31 | 3 | SO46352 | 2022-07-30 | 131.62 | 5694.28 | 843.75 | 0.35 |
SO57093_14 | 2F7C-4AF6-8B | PO18705165751 | 19 | 291 | 225 | 479 | 6 | 2024-01-04 | 21.58 | 0.54 | 2023-12-23 | 4 | 6.92 | 1 | 21.58 | 14 | SO57093 | 2023-12-30 | 1.73 | 27.69 | 5.39 | |||
SO50261_1 | 6142-4396-B8 | PO20039145643 | 19 | 291 | 470 | 65 | 6 | 2023-07-04 | 205.15 | 5.13 | 2023-06-22 | 9 | 15.67 | 1 | 205.15 | 1 | SO50261 | 2023-06-29 | 16.41 | 141.04 | 22.79 | |||
SO48764_8 | B2E5-4B83-BC | PO18444188685 | 19 | 291 | 273 | 227 | 6 | 2023-03-06 | 607.00 | 15.17 | 2023-02-22 | 3 | 187.16 | 1 | 607.00 | 8 | SO48764 | 2023-03-01 | 48.56 | 561.47 | 202.33 | |||
SO46065_2 | 4002-48B7-BF | PO10469188321 | 19 | 288 | 350 | 335 | 6 | 2022-07-04 | 2024.99 | 50.62 | 2022-06-22 | 1 | 1898.09 | 1 | 2024.99 | 2 | SO46065 | 2022-06-29 | 162.00 | 1898.09 | 2024.99 | |||
SO57159_2 | DDBB-4887-AA | PO2262133775 | 19 | 291 | 494 | 629 | 6 | 2024-01-04 | 1204.69 | 30.12 | 2023-12-23 | 2 | 601.74 | 1 | 1204.69 | 2 | SO57159 | 2023-12-30 | 96.38 | 1203.49 | 602.35 | |||
SO57122_25 | 048F-465A-A8 | PO4901112587 | 19 | 284 | 255 | 84 | 6 | 2024-01-04 | 809.33 | 20.23 | 2023-12-23 | 4 | 204.63 | 1 | 809.33 | 25 | SO57122 | 2023-12-30 | 64.75 | 818.50 | 202.33 | |||
SO51850_18 | 57A9-4C32-8B | PO1856170170 | 19 | 291 | 496 | 263 | 6 | 2023-10-04 | 4818.77 | 120.47 | 2023-09-22 | 8 | 601.74 | 1 | 4818.77 | 18 | SO51850 | 2023-09-29 | 385.50 | 4813.95 | 602.35 | |||
SO46959_12 | 9007-4F97-9C | PO16733197949 | 19 | 291 | 435 | 533 | 6 | 2022-10-04 | 1946.72 | 48.67 | 2022-09-22 | 6 | 300.12 | 1 | 1946.72 | 12 | SO46959 | 2022-09-29 | 155.74 | 1800.71 | 324.45 | |||
SO43879_23 | EDC5-4BD5-8F | PO11600128380 | 19 | 288 | 220 | 569 | 6 | 2021-10-04 | 100.93 | 2.52 | 2021-09-22 | 5 | 12.03 | 1 | 100.93 | 23 | SO43879 | 2021-09-29 | 8.07 | 60.14 | 20.19 | |||
SO50295_14 | 575E-4F7A-9C | PO4466165095 | 19 | 291 | 410 | 352 | 6 | 2023-07-04 | 72.89 | 1.82 | 2023-06-22 | 2 | 26.97 | 1 | 72.89 | 14 | SO50295 | 2023-06-29 | 5.83 | 53.94 | 36.45 | |||
SO46639_13 | 7CDF-4BF8-8E | PO10527141970 | 19 | 284 | 271 | 480 | 6 | 2022-09-03 | 202.33 | 5.06 | 2022-08-22 | 1 | 187.16 | 1 | 202.33 | 13 | SO46639 | 2022-08-29 | 16.19 | 187.16 | 202.33 |
Generated 2024-09-21 08:49:31.485 UTC