[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE < SKIP 2813 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO71792_2 | 5257-4FC4-A5 | PO17545115036 | 19 | 291 | 408 | 155 | 6 | 2024-09-23 | 144.32 | 3.61 | 2024-09-11 | 2 | 53.40 | 1 | 144.32 | 2 | SO71792 | 2024-09-18 | 11.55 | 106.80 | 72.16 | |||
SO48299_36 | ABFA-41A9-A7 | PO18299110324 | 19 | 291 | 221 | 118 | 6 | 2023-03-25 | 100.93 | 2.52 | 2023-03-13 | 5 | 13.88 | 1 | 100.93 | 36 | SO48299 | 2023-03-20 | 8.07 | 69.39 | 20.19 | |||
SO46071_7 | 1563-4F33-9D | PO1827148074 | 19 | 288 | 317 | 317 | 6 | 2022-08-23 | 874.79 | 21.87 | 2022-08-11 | 1 | 884.71 | 1 | 874.79 | 7 | SO46071 | 2022-08-18 | 69.98 | 884.71 | 874.79 | |||
SO58913_2 | 51C4-4C84-94 | PO17690130629 | 19 | 291 | 359 | 47 | 6 | 2024-03-24 | 4130.98 | 103.27 | 2024-03-12 | 3 | 1251.98 | 1 | 4130.98 | 2 | SO58913 | 2024-03-19 | 330.48 | 3755.94 | 1376.99 | |||
SO47673_21 | AFCF-4DA6-99 | PO13862175462 | 19 | 291 | 354 | 119 | 6 | 2023-01-23 | 2485.70 | 62.14 | 2023-01-11 | 2 | 1117.86 | 1 | 2485.70 | 21 | SO47673 | 2023-01-18 | 198.86 | 2235.71 | 1242.85 | |||
SO46614_32 | 0B65-4374-89 | PO15312137226 | 19 | 291 | 343 | 299 | 6 | 2022-10-23 | 3288.56 | 82.21 | 2022-10-11 | 7 | 486.71 | 1 | 3288.56 | 32 | SO46614 | 2022-10-18 | 263.08 | 3406.95 | 469.79 | |||
SO67316_2 | 6F7E-4455-9E | PO4495115494 | 19 | 291 | 214 | 2 | 496 | 6 | 5.28 | 2024-07-24 | 263.82 | 6.46 | 2024-07-12 | 13 | 13.09 | 1 | 258.55 | 2 | SO67316 | 2024-07-19 | 20.68 | 170.12 | 20.29 | 0.02 |
SO44765_6 | 54D5-4FF7-BB | PO11107155025 | 19 | 284 | 262 | 156 | 6 | 2022-03-25 | 183.94 | 4.60 | 2022-03-13 | 1 | 181.49 | 1 | 183.94 | 6 | SO44765 | 2022-03-20 | 14.72 | 181.49 | 183.94 | |||
SO67304_14 | 5E78-4926-A4 | PO18444191982 | 19 | 291 | 581 | 227 | 6 | 2024-07-24 | 3061.78 | 76.54 | 2024-07-12 | 3 | 1082.51 | 1 | 3061.78 | 14 | SO67304 | 2024-07-19 | 244.94 | 3247.53 | 1020.59 | |||
SO53507_2 | BFB2-4B71-9D | PO10933183052 | 19 | 291 | 559 | 407 | 6 | 2023-12-24 | 12.14 | 0.30 | 2023-12-12 | 1 | 8.99 | 1 | 12.14 | 2 | SO53507 | 2023-12-19 | 0.97 | 8.99 | 12.14 | |||
SO57154_9 | 464B-46A4-B6 | PO1856185040 | 19 | 291 | 507 | 263 | 6 | 2024-02-23 | 800.21 | 20.01 | 2024-02-11 | 4 | 199.85 | 1 | 800.21 | 9 | SO57154 | 2024-02-18 | 64.02 | 799.41 | 200.05 | |||
SO67286_6 | E11B-4F1E-80 | PO11136127520 | 19 | 272 | 555 | 120 | 6 | 2024-07-24 | 63.90 | 1.60 | 2024-07-12 | 1 | 47.29 | 1 | 63.90 | 6 | SO67286 | 2024-07-19 | 5.11 | 47.29 | 63.90 | |||
SO44283_7 | D5FF-488D-B7 | PO18444150042 | 19 | 288 | 342 | 2 | 227 | 6 | 97.31 | 2022-01-23 | 4865.72 | 119.21 | 2022-01-11 | 12 | 413.15 | 1 | 4768.41 | 7 | SO44283 | 2022-01-18 | 381.47 | 4957.76 | 405.48 | 0.02 |
SO65163_15 | 6062-4B82-A4 | PO18502160930 | 19 | 291 | 569 | 154 | 6 | 2024-06-23 | 1781.64 | 44.54 | 2024-06-11 | 4 | 461.44 | 1 | 1781.64 | 15 | SO65163 | 2024-06-18 | 142.53 | 1845.78 | 445.41 | |||
SO45792_3 | D5D3-43B4-A2 | PO13862173868 | 19 | 288 | 347 | 119 | 6 | 2022-07-24 | 4079.99 | 102.00 | 2022-07-12 | 2 | 1912.15 | 1 | 4079.99 | 3 | SO45792 | 2022-07-19 | 326.40 | 3824.31 | 2039.99 | |||
SO47663_11 | 1B17-4C63-B6 | PO18444192283 | 19 | 291 | 377 | 227 | 6 | 2023-01-23 | 1308.94 | 32.72 | 2023-01-11 | 1 | 1320.68 | 1 | 1308.94 | 11 | SO47663 | 2023-01-18 | 104.72 | 1320.68 | 1308.94 | |||
SO44103_2 | 5754-4536-B8 | PO11107175113 | 19 | 284 | 326 | 156 | 6 | 2021-12-24 | 1258.38 | 31.46 | 2021-12-12 | 3 | 413.15 | 1 | 1258.38 | 2 | SO44103 | 2021-12-19 | 100.67 | 1239.44 | 419.46 | |||
SO61222_3 | 9C3C-4330-8A | PO13862196260 | 19 | 291 | 591 | 119 | 6 | 2024-04-24 | 677.99 | 16.95 | 2024-04-12 | 2 | 308.22 | 1 | 677.99 | 3 | SO61222 | 2024-04-19 | 54.24 | 616.44 | 338.99 | |||
SO50203_22 | 821E-4862-9A | PO17603125956 | 19 | 284 | 417 | 12 | 6 | 2023-08-23 | 648.91 | 16.22 | 2023-08-11 | 2 | 300.12 | 1 | 648.91 | 22 | SO50203 | 2023-08-18 | 51.91 | 600.24 | 324.45 | |||
SO57188_3 | BA1D-4480-AA | PO9077120275 | 19 | 291 | 593 | 100 | 6 | 2024-02-23 | 677.99 | 16.95 | 2024-02-11 | 2 | 308.22 | 1 | 677.99 | 3 | SO57188 | 2024-02-18 | 54.24 | 616.44 | 338.99 | |||
SO63266_10 | 4D6E-4BF2-B9 | PO4466196255 | 19 | 291 | 596 | 352 | 6 | 2024-05-25 | 971.98 | 24.30 | 2024-05-13 | 3 | 294.58 | 1 | 971.98 | 10 | SO63266 | 2024-05-20 | 77.76 | 883.74 | 323.99 | |||
SO69522_34 | 28C3-4615-8B | PO4901187436 | 19 | 284 | 418 | 84 | 6 | 2024-08-23 | 356.90 | 8.92 | 2024-08-11 | 1 | 360.94 | 1 | 356.90 | 34 | SO69522 | 2024-08-18 | 28.55 | 360.94 | 356.90 | |||
SO49071_1 | D995-43BC-8E | PO2030137880 | 19 | 284 | 409 | 661 | 6 | 2023-05-26 | 418.51 | 10.46 | 2023-05-14 | 2 | 185.82 | 1 | 418.51 | 1 | SO49071 | 2023-05-21 | 33.48 | 371.64 | 209.26 | |||
SO47670_43 | 0CD2-463E-8F | PO14732184884 | 19 | 291 | 375 | 514 | 6 | 2023-01-23 | 2617.88 | 65.45 | 2023-01-11 | 2 | 1320.68 | 1 | 2617.88 | 43 | SO47670 | 2023-01-18 | 209.43 | 2641.37 | 1308.94 | |||
SO71851_38 | AABE-4443-91 | PO18299133687 | 19 | 291 | 225 | 2 | 118 | 6 | 1.25 | 2024-09-23 | 62.57 | 1.53 | 2024-09-11 | 12 | 6.92 | 1 | 61.32 | 38 | SO71851 | 2024-09-18 | 4.91 | 83.07 | 5.21 | 0.02 |
SO51160_20 | 3F3F-4135-B0 | PO4495157262 | 19 | 291 | 601 | 496 | 6 | 2023-10-23 | 226.76 | 5.67 | 2023-10-11 | 7 | 23.97 | 1 | 226.76 | 20 | SO51160 | 2023-10-18 | 18.14 | 167.80 | 32.39 | |||
SO45284_10 | 57F0-404F-97 | PO16733112744 | 19 | 288 | 312 | 533 | 6 | 2022-05-26 | 4293.92 | 107.35 | 2022-05-14 | 2 | 2171.29 | 1 | 4293.92 | 10 | SO45284 | 2022-05-21 | 343.51 | 4342.59 | 2146.96 | |||
SO47396_4 | 6B61-4DD9-AA | PO11165191815 | 19 | 291 | 399 | 586 | 6 | 2022-12-24 | 101.32 | 2.53 | 2022-12-12 | 3 | 24.99 | 1 | 101.32 | 4 | SO47396 | 2022-12-19 | 8.11 | 74.98 | 33.77 | |||
SO49484_17 | B25F-4DF4-8E | PO18299142683 | 19 | 291 | 236 | 118 | 6 | 2023-06-23 | 86.52 | 2.16 | 2023-06-11 | 3 | 29.08 | 1 | 86.52 | 17 | SO49484 | 2023-06-18 | 6.92 | 87.24 | 28.84 | |||
SO65189_19 | 985E-4937-94 | PO14761195376 | 19 | 284 | 560 | 408 | 6 | 2024-06-23 | 2186.73 | 54.67 | 2024-06-11 | 3 | 755.15 | 1 | 2186.73 | 19 | SO65189 | 2024-06-18 | 174.94 | 2265.45 | 728.91 | |||
SO69432_1 | A640-45AE-A5 | PO12789195722 | 19 | 291 | 483 | 677 | 6 | 2024-08-23 | 144.00 | 3.60 | 2024-08-11 | 2 | 44.88 | 1 | 144.00 | 1 | SO69432 | 2024-08-18 | 11.52 | 89.76 | 72.00 |
Generated 2024-11-10 07:46:16.564 UTC