[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE < SKIP 3315 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO47988_40 | 3979-4615-A9 | PO16733190266 | 19 | 291 | 339 | 533 | 6 | 2023-01-04 | 939.59 | 23.49 | 2022-12-23 | 2 | 486.71 | 1 | 939.59 | 40 | SO47988 | 2022-12-30 | 75.17 | 973.41 | 469.79 | |||
SO44288_4 | 6F5C-4E3C-B5 | PO14732190246 | 19 | 288 | 235 | 514 | 6 | 2021-12-04 | 28.84 | 0.72 | 2021-11-22 | 1 | 31.72 | 1 | 28.84 | 4 | SO44288 | 2021-11-29 | 2.31 | 31.72 | 28.84 | |||
SO51703_38 | 53F7-4B59-AA | PO17603160217 | 19 | 284 | 583 | 2 | 12 | 6 | 236.78 | 2023-10-04 | 11838.89 | 290.05 | 2023-09-22 | 12 | 1082.51 | 1 | 11602.11 | 38 | SO51703 | 2023-09-29 | 928.17 | 12990.12 | 986.57 | 0.02 |
SO50245_32 | 28E4-4CC9-BF | PO1914152990 | 19 | 284 | 335 | 66 | 6 | 2023-07-04 | 469.79 | 11.74 | 2023-06-22 | 1 | 486.71 | 1 | 469.79 | 32 | SO50245 | 2023-06-29 | 37.58 | 486.71 | 469.79 | |||
SO51132_19 | D4A8-472C-A4 | PO18444136544 | 19 | 291 | 580 | 3 | 227 | 6 | 1029.10 | 2023-09-03 | 20581.98 | 488.82 | 2023-08-22 | 22 | 1082.51 | 1 | 19552.88 | 19 | SO51132 | 2023-08-29 | 1564.23 | 23815.22 | 935.54 | 0.05 |
SO51755_17 | 46F4-477C-A7 | PO11020169365 | 19 | 284 | 376 | 336 | 6 | 2023-10-04 | 2932.02 | 73.30 | 2023-09-22 | 2 | 1554.95 | 1 | 2932.02 | 17 | SO51755 | 2023-09-29 | 234.56 | 3109.90 | 1466.01 | |||
SO47663_12 | 1B17-4C63-B6 | PO18444192283 | 19 | 291 | 335 | 227 | 6 | 2022-12-04 | 2348.97 | 58.72 | 2022-11-22 | 5 | 486.71 | 1 | 2348.97 | 12 | SO47663 | 2022-11-29 | 187.92 | 2433.53 | 469.79 | |||
SO48768_6 | 590A-4550-A0 | PO13862146668 | 19 | 291 | 366 | 119 | 6 | 2023-03-06 | 2591.98 | 64.80 | 2023-02-22 | 4 | 598.44 | 1 | 2591.98 | 6 | SO48768 | 2023-03-01 | 207.36 | 2393.74 | 647.99 | |||
SO53542_4 | D309-4C20-A5 | PO18531154951 | 19 | 284 | 359 | 613 | 6 | 2023-11-04 | 4130.98 | 103.27 | 2023-10-23 | 3 | 1251.98 | 1 | 4130.98 | 4 | SO53542 | 2023-10-30 | 330.48 | 3755.94 | 1376.99 | |||
SO45522_12 | DB6E-40EF-A4 | PO19401195812 | 19 | 288 | 310 | 173 | 6 | 2022-05-04 | 2146.96 | 53.67 | 2022-04-22 | 1 | 2171.29 | 1 | 2146.96 | 12 | SO45522 | 2022-04-29 | 171.76 | 2171.29 | 2146.96 | |||
SO48324_2 | 54D6-44D8-9F | PO14210149595 | 19 | 284 | 381 | 30 | 6 | 2023-02-03 | 1200.53 | 30.01 | 2023-01-22 | 2 | 605.65 | 1 | 1200.53 | 2 | SO48324 | 2023-01-29 | 96.04 | 1211.30 | 600.26 | |||
SO57188_16 | BA1D-4480-AA | PO9077120275 | 19 | 291 | 513 | 100 | 6 | 2024-01-04 | 218.45 | 5.46 | 2023-12-23 | 1 | 199.38 | 1 | 218.45 | 16 | SO57188 | 2023-12-30 | 17.48 | 199.38 | 218.45 | |||
SO46607_4 | C1B5-40D6-8D | PO18444137892 | 19 | 291 | 373 | 227 | 6 | 2022-09-03 | 13089.38 | 327.23 | 2022-08-22 | 10 | 1320.68 | 1 | 13089.38 | 4 | SO46607 | 2022-08-29 | 1047.15 | 13206.84 | 1308.94 | |||
SO71825_1 | 13EC-4324-90 | PO11165197222 | 19 | 291 | 476 | 586 | 6 | 2024-08-04 | 335.95 | 8.40 | 2024-07-23 | 8 | 26.18 | 1 | 335.95 | 1 | SO71825 | 2024-07-30 | 26.88 | 209.41 | 41.99 | |||
SO57070_1 | A915-448D-82 | PO11020121552 | 19 | 284 | 581 | 336 | 6 | 2024-01-04 | 1020.59 | 25.51 | 2023-12-23 | 1 | 1082.51 | 1 | 1020.59 | 1 | SO57070 | 2023-12-30 | 81.65 | 1082.51 | 1020.59 | |||
SO49496_24 | 1BAD-4D34-B0 | PO10614179686 | 19 | 291 | 368 | 461 | 6 | 2023-05-04 | 2932.02 | 73.30 | 2023-04-22 | 2 | 1518.79 | 1 | 2932.02 | 24 | SO49496 | 2023-04-29 | 234.56 | 3037.57 | 1466.01 | |||
SO46959_16 | 9007-4F97-9C | PO16733197949 | 19 | 291 | 415 | 533 | 6 | 2022-10-04 | 792.14 | 19.80 | 2022-09-22 | 4 | 146.55 | 1 | 792.14 | 16 | SO46959 | 2022-09-29 | 63.37 | 586.19 | 198.04 | |||
SO53484_31 | CEC0-499D-80 | PO14790120337 | 19 | 291 | 402 | 497 | 6 | 2023-11-04 | 216.49 | 5.41 | 2023-10-23 | 3 | 53.40 | 1 | 216.49 | 31 | SO53484 | 2023-10-30 | 17.32 | 160.20 | 72.16 | |||
SO49856_31 | 6ADC-4789-8A | PO18444116791 | 19 | 291 | 439 | 227 | 6 | 2023-06-04 | 2342.45 | 58.56 | 2023-05-23 | 3 | 722.26 | 1 | 2342.45 | 31 | SO49856 | 2023-05-30 | 187.40 | 2166.77 | 780.82 | |||
SO55283_37 | 8D6B-460A-83 | PO18473174493 | 19 | 291 | 594 | 442 | 6 | 2023-12-04 | 1016.98 | 25.42 | 2023-11-22 | 3 | 308.22 | 1 | 1016.98 | 37 | SO55283 | 2023-11-29 | 81.36 | 924.65 | 338.99 | |||
SO44765_7 | 54D5-4FF7-BB | PO11107155025 | 19 | 284 | 315 | 156 | 6 | 2022-02-03 | 874.79 | 21.87 | 2022-01-22 | 1 | 884.71 | 1 | 874.79 | 7 | SO44765 | 2022-01-29 | 69.98 | 884.71 | 874.79 | |||
SO58958_23 | BC3F-443F-B5 | PO10875118816 | 19 | 291 | 569 | 281 | 6 | 2024-02-03 | 2672.46 | 66.81 | 2024-01-22 | 6 | 461.44 | 1 | 2672.46 | 23 | SO58958 | 2024-01-29 | 213.80 | 2768.67 | 445.41 | |||
SO51698_2 | C8C8-43A4-AC | PO19227173300 | 19 | 284 | 234 | 210 | 6 | 2023-10-04 | 89.98 | 2.25 | 2023-09-22 | 3 | 38.49 | 1 | 89.98 | 2 | SO51698 | 2023-09-29 | 7.20 | 115.48 | 29.99 | |||
SO57079_6 | 1CB1-4EC7-8E | PO638182054 | 19 | 291 | 361 | 280 | 6 | 2024-01-04 | 2753.99 | 68.85 | 2023-12-23 | 2 | 1251.98 | 1 | 2753.99 | 6 | SO57079 | 2023-12-30 | 220.32 | 2503.96 | 1376.99 | |||
SO69478_29 | E63C-4ABF-83 | PO18705185140 | 19 | 291 | 604 | 479 | 6 | 2024-07-04 | 323.99 | 8.10 | 2024-06-22 | 1 | 343.65 | 1 | 323.99 | 29 | SO69478 | 2024-06-29 | 25.92 | 343.65 | 323.99 | |||
SO45310_2 | E43D-4178-B9 | PO10469159835 | 19 | 288 | 350 | 335 | 6 | 2022-04-06 | 2024.99 | 50.62 | 2022-03-25 | 1 | 1898.09 | 1 | 2024.99 | 2 | SO45310 | 2022-04-01 | 162.00 | 1898.09 | 2024.99 | |||
SO65238_22 | 896A-4ED1-B1 | PO10875188169 | 19 | 291 | 463 | 2 | 281 | 6 | 3.12 | 2024-05-04 | 156.25 | 3.83 | 2024-04-22 | 11 | 9.16 | 1 | 153.12 | 22 | SO65238 | 2024-04-29 | 12.25 | 100.75 | 14.20 | 0.02 |
SO47359_3 | 8BC9-458A-82 | PO18299145297 | 19 | 291 | 308 | 118 | 6 | 2022-11-04 | 2232.82 | 55.82 | 2022-10-23 | 3 | 660.91 | 1 | 2232.82 | 3 | SO47359 | 2022-10-30 | 178.63 | 1982.74 | 744.27 | |||
SO65206_19 | 6CD1-4BEC-A0 | PO1798192797 | 19 | 291 | 524 | 10 | 6 | 2024-05-04 | 475.29 | 11.88 | 2024-04-22 | 3 | 144.59 | 1 | 475.29 | 19 | SO65206 | 2024-04-29 | 38.02 | 433.78 | 158.43 | |||
SO45315_3 | A83F-4F76-BA | PO2146148184 | 19 | 284 | 347 | 354 | 6 | 2022-04-06 | 4079.99 | 102.00 | 2022-03-25 | 2 | 1912.15 | 1 | 4079.99 | 3 | SO45315 | 2022-04-01 | 326.40 | 3824.31 | 2039.99 | |||
SO67268_31 | 9708-4E22-A4 | PO15312122688 | 19 | 291 | 418 | 299 | 6 | 2024-06-04 | 713.80 | 17.84 | 2024-05-23 | 2 | 360.94 | 1 | 713.80 | 31 | SO67268 | 2024-05-30 | 57.10 | 721.89 | 356.90 |
Generated 2024-09-21 09:48:52.433 UTC