[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SKIP 0 SHUFFLE < SKIP 1116 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO53508_12 | 38E7-428D-9B | PO11194139565 | 19 | 284 | 495 | 48 | 6 | 2023-11-04 | 602.35 | 15.06 | 2023-10-23 | 1 | 601.74 | 1 | 602.35 | 12 | SO53508 | 2023-10-30 | 48.19 | 601.74 | 602.35 | |||
| SO71830_25 | DA2D-4B00-A4 | PO10875112195 | 19 | 291 | 565 | 281 | 6 | 2024-08-04 | 1781.64 | 44.54 | 2024-07-23 | 4 | 461.44 | 1 | 1781.64 | 25 | SO71830 | 2024-07-30 | 142.53 | 1845.78 | 445.41 | |||
| SO47696_7 | B251-4D0B-9C | PO1711162591 | 19 | 291 | 308 | 245 | 6 | 2022-12-04 | 744.27 | 18.61 | 2022-11-22 | 1 | 660.91 | 1 | 744.27 | 7 | SO47696 | 2022-11-29 | 59.54 | 660.91 | 744.27 | |||
| SO46953_7 | C650-4C32-BE | PO17603154442 | 19 | 284 | 466 | 12 | 6 | 2022-10-04 | 28.26 | 0.71 | 2022-09-22 | 2 | 9.71 | 1 | 28.26 | 7 | SO46953 | 2022-09-29 | 2.26 | 19.43 | 14.13 | |||
| SO50716_26 | 0B80-45BD-98 | PO18299117393 | 19 | 291 | 362 | 118 | 6 | 2023-08-04 | 3688.38 | 92.21 | 2023-07-23 | 3 | 1105.81 | 1 | 3688.38 | 26 | SO50716 | 2023-07-30 | 295.07 | 3317.43 | 1229.46 | |||
| SO50242_48 | A651-4343-86 | PO1595193228 | 19 | 284 | 448 | 426 | 6 | 2023-07-04 | 47.98 | 1.20 | 2023-06-22 | 4 | 8.25 | 1 | 47.98 | 48 | SO50242 | 2023-06-29 | 3.84 | 32.98 | 11.99 | |||
| SO46038_17 | D7B6-499A-87 | PO17748117802 | 19 | 284 | 332 | 102 | 6 | 2022-07-04 | 1677.84 | 41.95 | 2022-06-22 | 4 | 413.15 | 1 | 1677.84 | 17 | SO46038 | 2022-06-29 | 134.23 | 1652.59 | 419.46 | |||
| SO71830_33 | DA2D-4B00-A4 | PO10875112195 | 19 | 291 | 492 | 281 | 6 | 2024-08-04 | 1204.69 | 30.12 | 2024-07-23 | 2 | 601.74 | 1 | 1204.69 | 33 | SO71830 | 2024-07-30 | 96.38 | 1203.49 | 602.35 | |||
| SO44749_17 | 6F66-42B6-AB | PO17545111622 | 19 | 288 | 326 | 155 | 6 | 2022-02-03 | 1258.38 | 31.46 | 2022-01-22 | 3 | 413.15 | 1 | 1258.38 | 17 | SO44749 | 2022-01-29 | 100.67 | 1239.44 | 419.46 | |||
| SO53535_1 | 8195-45C7-93 | PO18502176746 | 19 | 291 | 562 | 14 | 154 | 6 | 953.63 | 2023-11-04 | 4768.14 | 95.36 | 2023-10-23 | 5 | 1481.94 | 1 | 3814.51 | 1 | SO53535 | 2023-10-30 | 305.16 | 7409.69 | 953.63 | 0.20 |
| SO58918_53 | C811-4D40-80 | PO17574131484 | 19 | 291 | 234 | 678 | 6 | 2024-02-03 | 299.94 | 7.50 | 2024-01-22 | 10 | 38.49 | 1 | 299.94 | 53 | SO58918 | 2024-01-29 | 24.00 | 384.92 | 29.99 | |||
| SO47365_41 | 4535-457B-B0 | PO17574153673 | 19 | 291 | 428 | 678 | 6 | 2022-11-04 | 418.51 | 10.46 | 2022-10-23 | 2 | 185.82 | 1 | 418.51 | 41 | SO47365 | 2022-10-30 | 33.48 | 371.64 | 209.26 | |||
| SO57100_5 | 7860-479F-BA | PO20039169403 | 19 | 291 | 483 | 65 | 6 | 2024-01-04 | 72.00 | 1.80 | 2023-12-23 | 1 | 44.88 | 1 | 72.00 | 5 | SO57100 | 2023-12-30 | 5.76 | 44.88 | 72.00 | |||
| SO46331_6 | 729B-498D-BD | PO17719139668 | 19 | 284 | 328 | 631 | 6 | 2022-08-04 | 419.46 | 10.49 | 2022-07-23 | 1 | 413.15 | 1 | 419.46 | 6 | SO46331 | 2022-07-30 | 33.56 | 413.15 | 419.46 | |||
| SO44496_8 | 6ADA-4A25-AA | PO18415194469 | 19 | 288 | 310 | 191 | 6 | 2022-01-04 | 2146.96 | 53.67 | 2021-12-23 | 1 | 2171.29 | 1 | 2146.96 | 8 | SO44496 | 2021-12-30 | 171.76 | 2171.29 | 2146.96 | |||
| SO57023_6 | EE6C-4089-A0 | PO17603140236 | 19 | 284 | 222 | 12 | 6 | 2024-01-04 | 167.95 | 4.20 | 2023-12-23 | 8 | 13.09 | 1 | 167.95 | 6 | SO57023 | 2023-12-30 | 13.44 | 104.69 | 20.99 | |||
| SO53510_16 | 8E8D-4B13-B1 | PO10962181057 | 19 | 284 | 594 | 685 | 6 | 2023-11-04 | 677.99 | 16.95 | 2023-10-23 | 2 | 308.22 | 1 | 677.99 | 16 | SO53510 | 2023-10-30 | 54.24 | 616.44 | 338.99 | |||
| SO61222_8 | 9C3C-4330-8A | PO13862196260 | 19 | 291 | 355 | 119 | 6 | 2024-03-05 | 2783.99 | 69.60 | 2024-02-22 | 2 | 1265.62 | 1 | 2783.99 | 8 | SO61222 | 2024-02-29 | 222.72 | 2531.24 | 1391.99 | |||
| SO50664_23 | 85F5-458B-8D | PO19401149024 | 19 | 291 | 422 | 173 | 6 | 2023-08-04 | 135.08 | 3.38 | 2023-07-23 | 2 | 49.98 | 1 | 135.08 | 23 | SO50664 | 2023-07-30 | 10.81 | 99.96 | 67.54 | |||
| SO57023_22 | EE6C-4089-A0 | PO17603140236 | 19 | 284 | 436 | 12 | 6 | 2024-01-04 | 2498.29 | 62.46 | 2023-12-23 | 7 | 360.94 | 1 | 2498.29 | 22 | SO57023 | 2023-12-30 | 199.86 | 2526.60 | 356.90 | |||
| SO46333_2 | B042-408B-A8 | PO17545158984 | 19 | 288 | 328 | 155 | 6 | 2022-08-04 | 1258.38 | 31.46 | 2022-07-23 | 3 | 413.15 | 1 | 1258.38 | 2 | SO46333 | 2022-07-30 | 100.67 | 1239.44 | 419.46 | |||
| SO69448_4 | 26BF-4CA1-97 | PO11020118669 | 19 | 284 | 606 | 336 | 6 | 2024-07-04 | 1619.97 | 40.50 | 2024-06-22 | 5 | 343.65 | 1 | 1619.97 | 4 | SO69448 | 2024-06-29 | 129.60 | 1718.25 | 323.99 | |||
| SO49073_2 | 9830-4E03-98 | PO2117174148 | 19 | 284 | 470 | 444 | 6 | 2023-04-06 | 45.59 | 1.14 | 2023-03-25 | 2 | 15.67 | 1 | 45.59 | 2 | SO49073 | 2023-04-01 | 3.65 | 31.34 | 22.79 | |||
| SO69448_1 | 26BF-4CA1-97 | PO11020118669 | 19 | 284 | 580 | 336 | 6 | 2024-07-04 | 1020.59 | 25.51 | 2024-06-22 | 1 | 1082.51 | 1 | 1020.59 | 1 | SO69448 | 2024-06-29 | 81.65 | 1082.51 | 1020.59 | |||
| SO47008_23 | FD36-4D89-AB | PO1595170889 | 19 | 284 | 280 | 426 | 6 | 2022-10-04 | 735.75 | 18.39 | 2022-09-22 | 4 | 170.14 | 1 | 735.75 | 23 | SO47008 | 2022-09-29 | 58.86 | 680.57 | 183.94 | |||
| SO48778_23 | 4F83-4D59-87 | PO4495173571 | 19 | 291 | 453 | 496 | 6 | 2023-03-06 | 71.99 | 1.80 | 2023-02-22 | 2 | 24.75 | 1 | 71.99 | 23 | SO48778 | 2023-03-01 | 5.76 | 49.49 | 35.99 | |||
| SO65171_1 | 9B7E-4D7A-B3 | PO17690122097 | 19 | 291 | 476 | 47 | 6 | 2024-05-04 | 83.99 | 2.10 | 2024-04-22 | 2 | 26.18 | 1 | 83.99 | 1 | SO65171 | 2024-04-29 | 6.72 | 52.35 | 41.99 | |||
| SO48754_8 | FC6A-4A9E-83 | PO18473150383 | 19 | 291 | 393 | 442 | 6 | 2023-03-06 | 275.39 | 6.88 | 2023-02-22 | 2 | 101.89 | 1 | 275.39 | 8 | SO48754 | 2023-03-01 | 22.03 | 203.79 | 137.69 |
Generated 2024-09-21 13:48:56.276 UTC