[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SHUFFLE < SKIP 238 > < TAKE 28 >
28 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO63156_4 | B5C5-474E-8D | PO14587116412 | 100 | 293 | 493 | 199 | 1 | 2024-04-05 | 200.05 | 5.00 | 2024-03-24 | 1 | 199.85 | 1 | 200.05 | 4 | SO63156 | 2024-03-31 | 16.00 | 199.85 | 200.05 | |||
SO63148_7 | 00FA-42B1-88 | PO16675153915 | 100 | 293 | 563 | 361 | 1 | 2024-04-05 | 4291.33 | 107.28 | 2024-03-24 | 3 | 1481.94 | 1 | 4291.33 | 7 | SO63148 | 2024-03-31 | 343.31 | 4445.81 | 1430.44 | |||
SO61207_2 | 7864-4908-A8 | PO14123129987 | 100 | 289 | 298 | 578 | 1 | 2024-03-05 | 809.76 | 20.24 | 2024-02-22 | 1 | 739.04 | 1 | 809.76 | 2 | SO61207 | 2024-02-29 | 64.78 | 739.04 | 809.76 | |||
SO45808_1 | 88ED-4DC3-89 | PO5075188229 | 100 | 289 | 342 | 344 | 1 | 2022-06-04 | 838.92 | 20.97 | 2022-05-23 | 2 | 413.15 | 1 | 838.92 | 1 | SO45808 | 2022-05-30 | 67.11 | 826.29 | 419.46 | |||
SO46077_7 | A8E4-4A99-91 | PO2900126524 | 100 | 286 | 349 | 469 | 1 | 2022-07-04 | 6074.98 | 151.87 | 2022-06-22 | 3 | 1898.09 | 1 | 6074.98 | 7 | SO46077 | 2022-06-29 | 486.00 | 5694.28 | 2024.99 | |||
SO55277_7 | E9AB-453F-BA | PO2552111630 | 100 | 286 | 476 | 3 | 506 | 1 | 38.49 | 2023-12-04 | 769.89 | 18.28 | 2023-11-22 | 20 | 26.18 | 1 | 731.40 | 7 | SO55277 | 2023-11-29 | 58.51 | 523.53 | 38.49 | 0.05 |
SO65234_17 | 3BB7-4A9F-AF | PO10411160249 | 100 | 289 | 577 | 182 | 1 | 2024-05-04 | 3644.55 | 91.11 | 2024-04-22 | 5 | 755.15 | 1 | 3644.55 | 17 | SO65234 | 2024-04-29 | 291.56 | 3775.75 | 728.91 | |||
SO58963_3 | 6ADC-4485-8C | PO841129336 | 100 | 286 | 298 | 254 | 1 | 2024-02-03 | 4858.56 | 121.46 | 2024-01-22 | 6 | 739.04 | 1 | 4858.56 | 3 | SO58963 | 2024-01-29 | 388.68 | 4434.25 | 809.76 | |||
SO59010_9 | 2350-42CD-B1 | PO6815132533 | 100 | 293 | 487 | 109 | 1 | 2024-02-03 | 230.96 | 5.77 | 2024-01-22 | 7 | 20.57 | 1 | 230.96 | 9 | SO59010 | 2024-01-29 | 18.48 | 143.96 | 32.99 | |||
SO51838_19 | 8AB1-478C-86 | PO4727199391 | 100 | 293 | 404 | 343 | 1 | 2023-10-04 | 53.45 | 1.34 | 2023-09-22 | 2 | 19.78 | 1 | 53.45 | 19 | SO51838 | 2023-09-29 | 4.28 | 39.55 | 26.72 | |||
SO49849_1 | C8F3-4DDE-A6 | PO2552190786 | 100 | 286 | 362 | 506 | 1 | 2023-06-04 | 2458.92 | 61.47 | 2023-05-23 | 2 | 1105.81 | 1 | 2458.92 | 1 | SO49849 | 2023-05-30 | 196.71 | 2211.62 | 1229.46 | |||
SO65270_1 | E73B-4A64-B4 | PO7192196898 | 100 | 289 | 474 | 20 | 1 | 2024-05-04 | 83.99 | 2.10 | 2024-04-22 | 2 | 26.18 | 1 | 83.99 | 1 | SO65270 | 2024-04-29 | 6.72 | 52.35 | 41.99 | |||
SO57105_37 | 3AE1-4A72-91 | PO18676113963 | 100 | 282 | 542 | 697 | 1 | 2024-01-04 | 72.88 | 1.82 | 2023-12-23 | 3 | 17.98 | 1 | 72.88 | 37 | SO57105 | 2023-12-30 | 5.83 | 53.93 | 24.29 | |||
SO49844_29 | 84A1-4FF2-A9 | PO899181442 | 100 | 289 | 433 | 290 | 1 | 2023-06-04 | 1622.26 | 40.56 | 2023-05-23 | 5 | 300.12 | 1 | 1622.26 | 29 | SO49844 | 2023-05-30 | 129.78 | 1500.59 | 324.45 | |||
SO51726_26 | 9BC5-4281-AF | PO14587157005 | 100 | 293 | 574 | 199 | 1 | 2023-10-04 | 4291.33 | 107.28 | 2023-09-22 | 3 | 1481.94 | 1 | 4291.33 | 26 | SO51726 | 2023-09-29 | 343.31 | 4445.81 | 1430.44 | |||
SO51800_6 | A082-4BC8-96 | PO14181145795 | 100 | 293 | 542 | 307 | 1 | 2023-10-04 | 24.29 | 0.61 | 2023-09-22 | 1 | 17.98 | 1 | 24.29 | 6 | SO51800 | 2023-09-29 | 1.94 | 17.98 | 24.29 | |||
SO44513_3 | A881-41E7-AD | PO14471116260 | 100 | 286 | 215 | 145 | 1 | 2022-01-04 | 141.31 | 3.53 | 2021-12-23 | 7 | 12.03 | 1 | 141.31 | 3 | SO44513 | 2021-12-30 | 11.30 | 84.19 | 20.19 | |||
SO50218_41 | B8E9-4FE2-8B | PO14442144367 | 100 | 293 | 464 | 127 | 1 | 2023-07-04 | 56.52 | 1.41 | 2023-06-22 | 4 | 9.71 | 1 | 56.52 | 41 | SO50218 | 2023-06-29 | 4.52 | 38.85 | 14.13 | |||
SO59066_5 | 9FAA-410F-AB | PO9309141643 | 100 | 293 | 565 | 55 | 1 | 2024-02-03 | 445.41 | 11.14 | 2024-01-22 | 1 | 461.44 | 1 | 445.41 | 5 | SO59066 | 2024-01-29 | 35.63 | 461.44 | 445.41 | |||
SO57046_53 | 52CC-460F-B3 | PO14500161818 | 100 | 282 | 594 | 650 | 1 | 2024-01-04 | 1016.98 | 25.42 | 2023-12-23 | 3 | 308.22 | 1 | 1016.98 | 53 | SO57046 | 2023-12-30 | 81.36 | 924.65 | 338.99 | |||
SO45338_8 | EA29-4912-A1 | PO7627114520 | 100 | 286 | 313 | 433 | 1 | 2022-04-06 | 10734.81 | 268.37 | 2022-03-25 | 5 | 2171.29 | 1 | 10734.81 | 8 | SO45338 | 2022-04-01 | 858.78 | 10856.47 | 2146.96 | |||
SO44570_2 | 4132-4AE3-99 | PO8816195785 | 100 | 289 | 322 | 218 | 1 | 2022-01-04 | 838.92 | 20.97 | 2021-12-23 | 2 | 413.15 | 1 | 838.92 | 2 | SO44570 | 2021-12-30 | 67.11 | 826.29 | 419.46 | |||
SO51721_47 | 9429-430D-89 | PO14500124798 | 100 | 282 | 480 | 650 | 1 | 2023-10-04 | 4.12 | 0.10 | 2023-09-22 | 3 | 0.86 | 1 | 4.12 | 47 | SO51721 | 2023-09-29 | 0.33 | 2.57 | 1.37 | |||
SO45342_1 | 9E99-4922-A4 | PO7917111421 | 100 | 287 | 350 | 401 | 1 | 2022-04-06 | 8099.98 | 202.50 | 2022-03-25 | 4 | 1898.09 | 1 | 8099.98 | 1 | SO45342 | 2022-04-01 | 648.00 | 7592.38 | 2024.99 | |||
SO46944_14 | 7854-48E8-92 | PO18676186070 | 100 | 282 | 409 | 697 | 1 | 2022-10-04 | 837.02 | 20.93 | 2022-09-22 | 4 | 185.82 | 1 | 837.02 | 14 | SO46944 | 2022-09-29 | 66.96 | 743.28 | 209.26 | |||
SO63148_26 | 00FA-42B1-88 | PO16675153915 | 100 | 293 | 570 | 361 | 1 | 2024-04-05 | 890.82 | 22.27 | 2024-03-24 | 2 | 461.44 | 1 | 890.82 | 26 | SO63148 | 2024-03-31 | 71.27 | 922.89 | 445.41 | |||
SO44762_14 | 553E-437E-92 | PO13543176259 | 100 | 287 | 345 | 293 | 1 | 2022-02-03 | 4079.99 | 102.00 | 2022-01-22 | 2 | 1912.15 | 1 | 4079.99 | 14 | SO44762 | 2022-01-29 | 326.40 | 3824.31 | 2039.99 | |||
SO45782_18 | D609-4F2A-9B | PO16588186502 | 100 | 289 | 235 | 146 | 1 | 2022-06-04 | 28.84 | 0.72 | 2022-05-23 | 1 | 31.72 | 1 | 28.84 | 18 | SO45782 | 2022-05-30 | 2.31 | 31.72 | 28.84 |
Generated 2024-09-21 09:49:02.082 UTC