[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE < SKIP 801 > < TAKE 30 >
30 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO58932_1 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 502 | 408 | 6 | 2024-03-24 | 600.16 | 15.00 | 2024-03-12 | 3 | 199.85 | 1 | 600.16 | 1 | SO58932 | 2024-03-19 | 48.01 | 599.56 | 200.05 | |||
SO50242_19 | A651-4343-86 | PO1595193228 | 19 | 284 | 389 | 426 | 6 | 2023-08-23 | 1200.53 | 30.01 | 2023-08-11 | 2 | 605.65 | 1 | 1200.53 | 19 | SO50242 | 2023-08-18 | 96.04 | 1211.30 | 600.26 | |||
SO51704_8 | 13FA-4729-A9 | PO17661178081 | 19 | 284 | 471 | 264 | 6 | 2023-11-23 | 228.60 | 5.72 | 2023-11-11 | 6 | 23.75 | 1 | 228.60 | 8 | SO51704 | 2023-11-18 | 18.29 | 142.49 | 38.10 | |||
SO46616_48 | 1264-43E6-B7 | PO14732122562 | 19 | 291 | 439 | 514 | 6 | 2022-10-23 | 3123.27 | 78.08 | 2022-10-11 | 4 | 722.26 | 1 | 3123.27 | 48 | SO46616 | 2022-10-18 | 249.86 | 2889.03 | 780.82 | |||
SO71891_2 | A2BC-4140-A6 | PO7366158003 | 19 | 284 | 494 | 372 | 6 | 2024-09-23 | 602.35 | 15.06 | 2024-09-11 | 1 | 601.74 | 1 | 602.35 | 2 | SO71891 | 2024-09-18 | 48.19 | 601.74 | 602.35 | |||
SO49120_1 | 071A-40CD-BB | PO10469124155 | 19 | 291 | 470 | 335 | 6 | 2023-05-26 | 45.59 | 1.14 | 2023-05-14 | 2 | 15.67 | 1 | 45.59 | 1 | SO49120 | 2023-05-21 | 3.65 | 31.34 | 22.79 | |||
SO51793_27 | D763-4929-9B | PO18705168707 | 19 | 291 | 487 | 479 | 6 | 2023-11-23 | 131.98 | 3.30 | 2023-11-11 | 4 | 20.57 | 1 | 131.98 | 27 | SO51793 | 2023-11-18 | 10.56 | 82.27 | 32.99 | |||
SO45314_14 | E3E6-417D-A7 | PO2088183646 | 19 | 288 | 317 | 136 | 6 | 2022-05-26 | 874.79 | 21.87 | 2022-05-14 | 1 | 884.71 | 1 | 874.79 | 14 | SO45314 | 2022-05-21 | 69.98 | 884.71 | 874.79 | |||
SO61186_12 | C662-487E-B0 | PO14732152217 | 19 | 291 | 382 | 514 | 6 | 2024-04-24 | 1344.59 | 33.61 | 2024-04-12 | 2 | 713.08 | 1 | 1344.59 | 12 | SO61186 | 2024-04-19 | 107.57 | 1426.16 | 672.29 | |||
SO53536_18 | 5C09-4051-92 | PO18299189909 | 19 | 291 | 472 | 118 | 6 | 2023-12-24 | 152.40 | 3.81 | 2023-12-12 | 4 | 23.75 | 1 | 152.40 | 18 | SO53536 | 2023-12-19 | 12.19 | 95.00 | 38.10 | |||
SO58981_44 | 2B52-4247-AF | PO18299143459 | 19 | 291 | 542 | 118 | 6 | 2024-03-24 | 72.88 | 1.82 | 2024-03-12 | 3 | 17.98 | 1 | 72.88 | 44 | SO58981 | 2024-03-19 | 5.83 | 53.93 | 24.29 | |||
SO46657_8 | CA71-4EDF-A1 | PO4495116659 | 19 | 291 | 365 | 496 | 6 | 2022-10-23 | 5183.95 | 129.60 | 2022-10-11 | 8 | 598.44 | 1 | 5183.95 | 8 | SO46657 | 2022-10-18 | 414.72 | 4787.48 | 647.99 | |||
SO48778_4 | 4F83-4D59-87 | PO4495173571 | 19 | 291 | 410 | 496 | 6 | 2023-04-25 | 145.79 | 3.64 | 2023-04-13 | 4 | 26.97 | 1 | 145.79 | 4 | SO48778 | 2023-04-20 | 11.66 | 107.88 | 36.45 | |||
SO46932_2 | DB58-4853-A1 | PO19691139503 | 19 | 291 | 420 | 353 | 6 | 2022-11-23 | 141.62 | 3.54 | 2022-11-11 | 1 | 104.80 | 1 | 141.62 | 2 | SO46932 | 2022-11-18 | 11.33 | 104.80 | 141.62 | |||
SO45314_15 | E3E6-417D-A7 | PO2088183646 | 19 | 288 | 342 | 136 | 6 | 2022-05-26 | 1677.84 | 41.95 | 2022-05-14 | 4 | 413.15 | 1 | 1677.84 | 15 | SO45314 | 2022-05-21 | 134.23 | 1652.59 | 419.46 | |||
SO47411_8 | 4BDD-4511-AC | PO1798140269 | 19 | 291 | 236 | 10 | 6 | 2022-12-24 | 115.36 | 2.88 | 2022-12-12 | 4 | 29.08 | 1 | 115.36 | 8 | SO47411 | 2022-12-19 | 9.23 | 116.32 | 28.84 | |||
SO55275_19 | 72C3-4048-BC | PO1711122362 | 19 | 291 | 559 | 245 | 6 | 2024-01-23 | 24.29 | 0.61 | 2024-01-11 | 2 | 8.99 | 1 | 24.29 | 19 | SO55275 | 2024-01-18 | 1.94 | 17.97 | 12.14 | |||
SO51847_12 | 7E3E-4DB0-80 | PO2030165560 | 19 | 284 | 593 | 661 | 6 | 2023-11-23 | 338.99 | 8.47 | 2023-11-11 | 1 | 308.22 | 1 | 338.99 | 12 | SO51847 | 2023-11-18 | 27.12 | 308.22 | 338.99 | |||
SO46657_52 | CA71-4EDF-A1 | PO4495116659 | 19 | 291 | 412 | 496 | 6 | 2022-10-23 | 900.65 | 22.52 | 2022-10-11 | 5 | 133.30 | 1 | 900.65 | 52 | SO46657 | 2022-10-18 | 72.05 | 666.48 | 180.13 | |||
SO61177_20 | DA64-4BC0-A0 | PO18473117778 | 19 | 291 | 398 | 442 | 6 | 2024-04-24 | 53.45 | 1.34 | 2024-04-12 | 2 | 19.78 | 1 | 53.45 | 20 | SO61177 | 2024-04-19 | 4.28 | 39.55 | 26.72 | |||
SO50716_22 | 0B80-45BD-98 | PO18299117393 | 19 | 291 | 453 | 118 | 6 | 2023-09-23 | 251.96 | 6.30 | 2023-09-11 | 7 | 24.75 | 1 | 251.96 | 22 | SO50716 | 2023-09-18 | 20.16 | 173.22 | 35.99 | |||
SO63128_1 | 9486-41CD-91 | PO18879146432 | 19 | 291 | 563 | 64 | 6 | 2024-05-25 | 1430.44 | 35.76 | 2024-05-13 | 1 | 1481.94 | 1 | 1430.44 | 1 | SO63128 | 2024-05-20 | 114.44 | 1481.94 | 1430.44 | |||
SO55287_27 | 4BBD-4DA3-AD | PO13862128497 | 19 | 291 | 593 | 119 | 6 | 2024-01-23 | 677.99 | 16.95 | 2024-01-11 | 2 | 308.22 | 1 | 677.99 | 27 | SO55287 | 2024-01-18 | 54.24 | 616.44 | 338.99 | |||
SO65243_13 | F88F-4FB2-85 | PO11194174051 | 19 | 284 | 496 | 48 | 6 | 2024-06-23 | 3011.73 | 75.29 | 2024-06-11 | 5 | 601.74 | 1 | 3011.73 | 13 | SO65243 | 2024-06-18 | 240.94 | 3008.72 | 602.35 | |||
SO58981_38 | 2B52-4247-AF | PO18299143459 | 19 | 291 | 544 | 118 | 6 | 2024-03-24 | 194.38 | 4.86 | 2024-03-12 | 4 | 35.96 | 1 | 194.38 | 38 | SO58981 | 2024-03-19 | 15.55 | 143.84 | 48.59 | |||
SO47362_6 | 41E3-4BA0-99 | PO17690189228 | 19 | 291 | 470 | 2 | 47 | 6 | 5.29 | 2022-12-24 | 264.41 | 6.48 | 2022-12-12 | 12 | 15.67 | 1 | 259.12 | 6 | SO47362 | 2022-12-19 | 20.73 | 188.05 | 22.03 | 0.02 |
SO65164_12 | 07B8-4AF8-8A | PO18299114573 | 19 | 291 | 516 | 118 | 6 | 2024-06-23 | 93.94 | 2.35 | 2024-06-11 | 4 | 17.38 | 1 | 93.94 | 12 | SO65164 | 2024-06-18 | 7.51 | 69.51 | 23.48 | |||
SO47365_46 | 4535-457B-B0 | PO17574153673 | 19 | 291 | 289 | 678 | 6 | 2022-12-24 | 2232.82 | 55.82 | 2022-12-12 | 3 | 660.91 | 1 | 2232.82 | 46 | SO47365 | 2022-12-19 | 178.63 | 1982.74 | 744.27 | |||
SO46622_3 | 1009-4D99-85 | PO13862155069 | 19 | 291 | 362 | 119 | 6 | 2022-10-23 | 6147.29 | 153.68 | 2022-10-11 | 5 | 1105.81 | 1 | 6147.29 | 3 | SO46622 | 2022-10-18 | 491.78 | 5529.05 | 1229.46 | |||
SO50668_6 | A5FC-4831-B4 | PO17574113752 | 19 | 291 | 454 | 678 | 6 | 2023-09-23 | 179.97 | 4.50 | 2023-09-11 | 5 | 24.75 | 1 | 179.97 | 6 | SO50668 | 2023-09-18 | 14.40 | 123.73 | 35.99 |
Generated 2024-11-10 08:18:34.024 UTC