[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 7061 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46057_31 | 6F2B-45A4-9C | PO12499164653 | 100 | 282 | 212 | 78 | 4 | 2022-07-03 | 141.31 | 3.53 | 2022-06-21 | 7 | 12.03 | 1 | 141.31 | 31 | SO46057 | 2022-06-28 | 11.30 | 84.19 | 20.19 | |||
SO51856_32 | E170-419C-92 | PO3654183134 | 100 | 281 | 476 | 435 | 4 | 2023-10-03 | 251.96 | 6.30 | 2023-09-21 | 6 | 26.18 | 1 | 251.96 | 32 | SO51856 | 2023-09-28 | 20.16 | 157.06 | 41.99 | |||
SO44509_25 | FAD7-4A4C-B0 | PO15689158248 | 100 | 283 | 319 | 328 | 4 | 2022-01-03 | 2624.38 | 65.61 | 2021-12-22 | 3 | 884.71 | 1 | 2624.38 | 25 | SO44509 | 2021-12-29 | 209.95 | 2654.12 | 874.79 | |||
SO59011_24 | CAAD-4857-B7 | PO6786194654 | 100 | 281 | 217 | 3 | 4 | 2024-02-02 | 167.95 | 4.20 | 2024-01-21 | 8 | 13.09 | 1 | 167.95 | 24 | SO59011 | 2024-01-28 | 13.44 | 104.69 | 20.99 | |||
SO47676_19 | 5DD7-4A1E-9B | PO13659142296 | 100 | 272 | 356 | 437 | 4 | 2022-12-03 | 3728.56 | 93.21 | 2022-11-21 | 3 | 1117.86 | 1 | 3728.56 | 19 | SO47676 | 2022-11-28 | 298.28 | 3353.57 | 1242.85 | |||
SO67305_33 | CBB5-42BF-9E | PO16298111473 | 100 | 287 | 231 | 599 | 4 | 2024-06-03 | 89.98 | 2.25 | 2024-05-22 | 3 | 38.49 | 1 | 89.98 | 33 | SO67305 | 2024-05-29 | 7.20 | 115.48 | 29.99 | |||
SO63240_2 | AC0A-4F08-91 | PO4611157476 | 100 | 287 | 576 | 131 | 4 | 2024-04-04 | 1430.44 | 35.76 | 2024-03-23 | 1 | 1481.94 | 1 | 1430.44 | 2 | SO63240 | 2024-03-30 | 114.44 | 1481.94 | 1430.44 | |||
SO44090_1 | D65B-43FF-AD | PO15834170093 | 100 | 283 | 324 | 417 | 4 | 2021-11-03 | 419.46 | 10.49 | 2021-10-22 | 1 | 413.15 | 1 | 419.46 | 1 | SO44090 | 2021-10-29 | 33.56 | 413.15 | 419.46 | |||
SO48012_18 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 224 | 78 | 4 | 2023-01-03 | 46.68 | 1.17 | 2022-12-22 | 9 | 5.23 | 1 | 46.68 | 18 | SO48012 | 2022-12-29 | 3.73 | 47.07 | 5.19 | |||
SO44505_4 | 5D07-4BE7-A6 | PO16037162003 | 100 | 282 | 351 | 384 | 4 | 2022-01-03 | 4049.99 | 101.25 | 2021-12-22 | 2 | 1898.09 | 1 | 4049.99 | 4 | SO44505 | 2021-12-29 | 324.00 | 3796.19 | 2024.99 | |||
SO47028_33 | 8DA0-456D-8F | PO3799132728 | 100 | 282 | 233 | 312 | 4 | 2022-10-03 | 173.04 | 4.33 | 2022-09-21 | 6 | 29.08 | 1 | 173.04 | 33 | SO47028 | 2022-09-28 | 13.84 | 174.48 | 28.84 | |||
SO50736_6 | C13C-4FDC-8A | PO261148609 | 100 | 281 | 429 | 647 | 4 | 2023-08-03 | 324.45 | 8.11 | 2023-07-22 | 1 | 300.12 | 1 | 324.45 | 6 | SO50736 | 2023-07-29 | 25.96 | 300.12 | 324.45 | |||
SO44538_14 | E495-47A9-AD | PO2523126243 | 100 | 287 | 342 | 167 | 4 | 2022-01-03 | 2097.29 | 52.43 | 2021-12-22 | 5 | 413.15 | 1 | 2097.29 | 14 | SO44538 | 2021-12-29 | 167.78 | 2065.73 | 419.46 | |||
SO48378_37 | 2FD7-4721-9D | PO6786131738 | 100 | 283 | 389 | 3 | 4 | 2023-02-02 | 2401.05 | 60.03 | 2023-01-21 | 4 | 605.65 | 1 | 2401.05 | 37 | SO48378 | 2023-01-28 | 192.08 | 2422.60 | 600.26 | |||
SO47422_7 | 9D8D-4481-B6 | PO3915123127 | 100 | 283 | 242 | 130 | 4 | 2022-11-03 | 780.82 | 19.52 | 2022-10-22 | 1 | 722.26 | 1 | 780.82 | 7 | SO47422 | 2022-10-29 | 62.47 | 722.26 | 780.82 | |||
SO44768_5 | 18BD-48B8-95 | PO261164909 | 100 | 283 | 326 | 647 | 4 | 2022-02-02 | 2516.75 | 62.92 | 2022-01-21 | 6 | 413.15 | 1 | 2516.75 | 5 | SO44768 | 2022-01-28 | 201.34 | 2478.88 | 419.46 | |||
SO69532_49 | 27FB-4A86-85 | PO3799165791 | 100 | 282 | 225 | 312 | 4 | 2024-07-03 | 37.76 | 0.94 | 2024-06-21 | 7 | 6.92 | 1 | 37.76 | 49 | SO69532 | 2024-06-28 | 3.02 | 48.46 | 5.39 | |||
SO46338_4 | 0BAC-4D7E-AD | PO15834128897 | 100 | 283 | 272 | 417 | 4 | 2022-08-03 | 551.81 | 13.80 | 2022-07-22 | 3 | 181.49 | 1 | 551.81 | 4 | SO46338 | 2022-07-29 | 44.15 | 544.46 | 183.94 | |||
SO58935_4 | 19F2-4C39-93 | PO13717119913 | 100 | 287 | 287 | 473 | 4 | 2024-02-02 | 202.33 | 5.06 | 2024-01-21 | 1 | 204.63 | 1 | 202.33 | 4 | SO58935 | 2024-01-28 | 16.19 | 204.63 | 202.33 | |||
SO53546_1 | 57CF-465D-B2 | PO16269114010 | 100 | 287 | 580 | 624 | 4 | 2023-11-03 | 1020.59 | 25.51 | 2023-10-22 | 1 | 1082.51 | 1 | 1020.59 | 1 | SO53546 | 2023-10-29 | 81.65 | 1082.51 | 1020.59 | |||
SO71915_5 | F5D1-4554-94 | PO2349143275 | 100 | 282 | 547 | 6 | 4 | 2024-08-03 | 48.59 | 1.21 | 2024-07-22 | 1 | 35.96 | 1 | 48.59 | 5 | SO71915 | 2024-07-29 | 3.89 | 35.96 | 48.59 | |||
SO43689_16 | DCD9-4C9A-AB | PO5626159507 | 100 | 283 | 338 | 166 | 4 | 2021-09-02 | 838.92 | 20.97 | 2021-08-21 | 2 | 413.15 | 1 | 838.92 | 16 | SO43689 | 2021-08-28 | 67.11 | 826.29 | 419.46 | |||
SO46058_7 | FA37-4F46-97 | PO12557123934 | 100 | 282 | 316 | 240 | 4 | 2022-07-03 | 2624.38 | 65.61 | 2022-06-21 | 3 | 884.71 | 1 | 2624.38 | 7 | SO46058 | 2022-06-28 | 209.95 | 2654.12 | 874.79 | |||
SO44115_15 | 5360-4C42-90 | PO3248122509 | 100 | 282 | 292 | 366 | 4 | 2021-11-03 | 1637.40 | 40.94 | 2021-10-22 | 2 | 706.81 | 1 | 1637.40 | 15 | SO44115 | 2021-10-29 | 130.99 | 1413.62 | 818.70 | |||
SO49104_26 | 7F8C-4702-BB | PO11745119484 | 100 | 282 | 370 | 97 | 4 | 2023-04-05 | 1466.01 | 36.65 | 2023-03-24 | 1 | 1518.79 | 1 | 1466.01 | 26 | SO49104 | 2023-03-31 | 117.28 | 1518.79 | 1466.01 | |||
SO50310_20 | FCBD-48EE-A9 | PO6438126969 | 100 | 281 | 365 | 309 | 4 | 2023-07-03 | 1295.99 | 32.40 | 2023-06-21 | 2 | 598.44 | 1 | 1295.99 | 20 | SO50310 | 2023-06-28 | 103.68 | 1196.87 | 647.99 | |||
SO71848_1 | 7082-4BF5-AB | PO18763153352 | 100 | 287 | 576 | 59 | 4 | 2024-08-03 | 1430.44 | 35.76 | 2024-07-22 | 1 | 1481.94 | 1 | 1430.44 | 1 | SO71848 | 2024-07-29 | 114.44 | 1481.94 | 1430.44 | |||
SO46380_2 | C4E3-4894-81 | PO7569183330 | 100 | 287 | 350 | 7 | 608 | 4 | 2953.12 | 2022-08-03 | 8437.48 | 137.11 | 2022-07-22 | 10 | 1898.09 | 1 | 5484.36 | 2 | SO46380 | 2022-07-29 | 438.75 | 18980.94 | 843.75 | 0.35 |
SO69527_3 | A6FE-49DA-BE | PO4843110434 | 100 | 287 | 240 | 257 | 4 | 2024-07-03 | 2576.70 | 64.42 | 2024-06-21 | 3 | 868.63 | 1 | 2576.70 | 3 | SO69527 | 2024-06-28 | 206.14 | 2605.90 | 858.90 | |||
SO51722_21 | 735D-4C32-A1 | PO15196144426 | 100 | 282 | 243 | 258 | 4 | 2023-10-03 | 1717.80 | 42.95 | 2023-09-21 | 2 | 868.63 | 1 | 1717.80 | 21 | SO51722 | 2023-09-28 | 137.42 | 1737.27 | 858.90 | |||
SO45328_2 | 2212-4E8E-82 | PO5684113284 | 100 | 282 | 347 | 385 | 4 | 2022-04-05 | 2039.99 | 51.00 | 2022-03-24 | 1 | 1912.15 | 1 | 2039.99 | 2 | SO45328 | 2022-03-31 | 163.20 | 1912.15 | 2039.99 |
Generated 2024-09-20 13:23:03.340 UTC