[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 281 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO53460_16 | 3BD9-47C3-94 | PO19343112747 | 100 | 282 | 258 | 24 | 4 | 2023-11-02 | 809.33 | 20.23 | 2023-10-21 | 4 | 204.63 | 1 | 809.33 | 16 | SO53460 | 2023-10-28 | 64.75 | 818.50 | 202.33 | |||
SO67273_19 | 9BAE-4E69-B9 | PO13688176638 | 100 | 282 | 524 | 475 | 4 | 2024-06-02 | 158.43 | 3.96 | 2024-05-21 | 1 | 144.59 | 1 | 158.43 | 19 | SO67273 | 2024-05-28 | 12.67 | 144.59 | 158.43 | |||
SO48048_27 | B414-46CB-BA | PO3480117933 | 100 | 283 | 447 | 436 | 4 | 2023-01-02 | 45.00 | 1.13 | 2022-12-21 | 3 | 10.31 | 1 | 45.00 | 27 | SO48048 | 2022-12-28 | 3.60 | 30.94 | 15.00 | |||
SO47018_3 | E622-43B1-98 | PO2523197473 | 100 | 287 | 377 | 167 | 4 | 2022-10-02 | 7853.63 | 196.34 | 2022-09-20 | 6 | 1320.68 | 1 | 7853.63 | 3 | SO47018 | 2022-09-27 | 628.29 | 7924.10 | 1308.94 | |||
SO51131_12 | D489-4DF3-A2 | PO16298169856 | 100 | 287 | 576 | 3 | 599 | 4 | 1376.80 | 2023-09-01 | 27536.01 | 653.98 | 2023-08-20 | 21 | 1481.94 | 1 | 26159.21 | 12 | SO51131 | 2023-08-27 | 2092.74 | 31120.70 | 1311.24 | 0.05 |
SO51106_14 | 3D96-4D27-92 | PO12528166058 | 100 | 282 | 575 | 331 | 4 | 2023-09-01 | 5721.77 | 143.04 | 2023-08-20 | 4 | 1481.94 | 1 | 5721.77 | 14 | SO51106 | 2023-08-27 | 457.74 | 5927.75 | 1430.44 | |||
SO46663_12 | 0EA2-42AA-A4 | PO6409112370 | 100 | 283 | 286 | 292 | 4 | 2022-09-01 | 551.81 | 13.80 | 2022-08-20 | 3 | 170.14 | 1 | 551.81 | 12 | SO46663 | 2022-08-27 | 44.15 | 510.43 | 183.94 | |||
SO71882_18 | D5D4-42D4-91 | PO5597123008 | 100 | 281 | 542 | 75 | 4 | 2024-08-02 | 48.59 | 1.21 | 2024-07-21 | 2 | 17.98 | 1 | 48.59 | 18 | SO71882 | 2024-07-28 | 3.89 | 35.96 | 24.29 | |||
SO61227_31 | 9006-4208-8F | PO10730172247 | 100 | 287 | 376 | 491 | 4 | 2024-03-03 | 5864.04 | 146.60 | 2024-02-20 | 4 | 1554.95 | 1 | 5864.04 | 31 | SO61227 | 2024-02-27 | 469.12 | 6219.79 | 1466.01 | |||
SO53621_16 | 9324-4A3D-83 | PO9715186811 | 100 | 281 | 551 | 490 | 4 | 2023-11-02 | 633.72 | 15.84 | 2023-10-21 | 4 | 144.59 | 1 | 633.72 | 16 | SO53621 | 2023-10-28 | 50.70 | 578.38 | 158.43 | |||
SO49146_4 | 273A-4635-9D | PO5684148238 | 100 | 282 | 428 | 385 | 4 | 2023-04-04 | 837.02 | 20.93 | 2023-03-23 | 4 | 185.82 | 1 | 837.02 | 4 | SO49146 | 2023-03-30 | 66.96 | 743.28 | 209.26 | |||
SO45555_3 | B11A-41CE-84 | PO3248155143 | 100 | 282 | 351 | 366 | 4 | 2022-05-02 | 16199.95 | 405.00 | 2022-04-20 | 8 | 1898.09 | 1 | 16199.95 | 3 | SO45555 | 2022-04-27 | 1296.00 | 15184.76 | 2024.99 | |||
SO71890_3 | D31D-413E-BB | PO5510169156 | 100 | 287 | 234 | 5 | 4 | 2024-08-02 | 179.96 | 4.50 | 2024-07-21 | 6 | 38.49 | 1 | 179.96 | 3 | SO71890 | 2024-07-28 | 14.40 | 230.95 | 29.99 | |||
SO48369_8 | 92AB-4468-B5 | PO4582138864 | 100 | 282 | 464 | 25 | 4 | 2023-02-01 | 42.39 | 1.06 | 2023-01-20 | 3 | 9.71 | 1 | 42.39 | 8 | SO48369 | 2023-01-27 | 3.39 | 29.14 | 14.13 | |||
SO67305_9 | CBB5-42BF-9E | PO16298111473 | 100 | 287 | 506 | 599 | 4 | 2024-06-02 | 400.10 | 10.00 | 2024-05-21 | 2 | 199.85 | 1 | 400.10 | 9 | SO67305 | 2024-05-28 | 32.01 | 399.70 | 200.05 | |||
SO46964_15 | B3E6-43CC-A2 | PO15689139014 | 100 | 283 | 263 | 328 | 4 | 2022-10-02 | 1213.99 | 30.35 | 2022-09-20 | 6 | 187.16 | 1 | 1213.99 | 15 | SO46964 | 2022-09-27 | 97.12 | 1122.94 | 202.33 | |||
SO43901_9 | 5FDB-4B73-97 | PO5684189260 | 100 | 282 | 212 | 385 | 4 | 2021-10-02 | 40.37 | 1.01 | 2021-09-20 | 2 | 12.03 | 1 | 40.37 | 9 | SO43901 | 2021-09-27 | 3.23 | 24.06 | 20.19 | |||
SO46049_4 | 2C79-41BD-8A | PO15689114654 | 100 | 283 | 313 | 328 | 4 | 2022-07-02 | 8587.85 | 214.70 | 2022-06-20 | 4 | 2171.29 | 1 | 8587.85 | 4 | SO46049 | 2022-06-27 | 687.03 | 8685.18 | 2146.96 | |||
SO55322_23 | D600-436A-B7 | PO7859118281 | 100 | 287 | 581 | 221 | 4 | 2023-12-02 | 6123.56 | 153.09 | 2023-11-20 | 6 | 1082.51 | 1 | 6123.56 | 23 | SO55322 | 2023-11-27 | 489.89 | 6495.06 | 1020.59 | |||
SO49884_9 | 822A-428D-94 | PO5626129805 | 100 | 281 | 323 | 166 | 4 | 2023-06-02 | 1409.38 | 35.23 | 2023-05-21 | 3 | 486.71 | 1 | 1409.38 | 9 | SO49884 | 2023-05-28 | 112.75 | 1460.12 | 469.79 | |||
SO63283_10 | 5DCA-44B0-BB | PO3799140598 | 100 | 282 | 222 | 312 | 4 | 2024-04-03 | 62.98 | 1.57 | 2024-03-22 | 3 | 13.09 | 1 | 62.98 | 10 | SO63283 | 2024-03-29 | 5.04 | 39.26 | 20.99 | |||
SO51714_36 | D33A-4EAE-B1 | PO15689195197 | 100 | 281 | 214 | 328 | 4 | 2023-10-02 | 41.99 | 1.05 | 2023-09-20 | 2 | 13.09 | 1 | 41.99 | 36 | SO51714 | 2023-09-27 | 3.36 | 26.17 | 20.99 | |||
SO47423_4 | 091B-4715-B2 | PO3886127119 | 100 | 283 | 213 | 165 | 4 | 2022-11-02 | 40.37 | 1.01 | 2022-10-21 | 2 | 13.88 | 1 | 40.37 | 4 | SO47423 | 2022-10-28 | 3.23 | 27.76 | 20.19 | |||
SO49160_26 | 60E2-486C-AE | PO7656113690 | 100 | 282 | 321 | 403 | 4 | 2023-04-04 | 2348.97 | 58.72 | 2023-03-23 | 5 | 486.71 | 1 | 2348.97 | 26 | SO49160 | 2023-03-30 | 187.92 | 2433.53 | 469.79 | |||
SO46970_39 | 01AF-420A-B9 | PO15196114472 | 100 | 282 | 370 | 258 | 4 | 2022-10-02 | 2932.02 | 73.30 | 2022-09-20 | 2 | 1518.79 | 1 | 2932.02 | 39 | SO46970 | 2022-09-27 | 234.56 | 3037.57 | 1466.01 | |||
SO47422_25 | 9D8D-4481-B6 | PO3915123127 | 100 | 283 | 343 | 130 | 4 | 2022-11-02 | 3288.56 | 82.21 | 2022-10-21 | 7 | 486.71 | 1 | 3288.56 | 25 | SO47422 | 2022-10-28 | 263.08 | 3406.95 | 469.79 | |||
SO48356_8 | 3E64-467F-90 | PO2697152207 | 100 | 282 | 397 | 187 | 4 | 2023-02-01 | 24.29 | 0.61 | 2023-01-20 | 1 | 17.98 | 1 | 24.29 | 8 | SO48356 | 2023-01-27 | 1.94 | 17.98 | 24.29 | |||
SO63213_1 | 1A10-4A9D-B4 | PO11745122074 | 100 | 282 | 581 | 97 | 4 | 2024-04-03 | 4082.38 | 102.06 | 2024-03-22 | 4 | 1082.51 | 1 | 4082.38 | 1 | SO63213 | 2024-03-29 | 326.59 | 4330.04 | 1020.59 | |||
SO58975_3 | 1BCF-4E62-A9 | PO2697145020 | 100 | 282 | 476 | 187 | 4 | 2024-02-01 | 125.98 | 3.15 | 2024-01-20 | 3 | 26.18 | 1 | 125.98 | 3 | SO58975 | 2024-01-27 | 10.08 | 78.53 | 41.99 | |||
SO44299_25 | AFF1-4CD9-9A | PO10817117580 | 100 | 287 | 317 | 203 | 4 | 2021-12-02 | 874.79 | 21.87 | 2021-11-20 | 1 | 884.71 | 1 | 874.79 | 25 | SO44299 | 2021-11-27 | 69.98 | 884.71 | 874.79 | |||
SO65279_2 | 17C0-4DFE-B8 | PO4582197027 | 100 | 282 | 222 | 25 | 4 | 2024-05-02 | 62.98 | 1.57 | 2024-04-20 | 3 | 13.09 | 1 | 62.98 | 2 | SO65279 | 2024-04-27 | 5.04 | 39.26 | 20.99 |
Generated 2024-09-19 21:25:51.130 UTC