[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > < SKIP 484 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO47670_50 | 0CD2-463E-8F | PO14732184884 | 19 | 291 | 433 | 514 | 6 | 2022-12-03 | 648.91 | 16.22 | 2022-11-21 | 2 | 300.12 | 1 | 648.91 | 50 | SO47670 | 2022-11-28 | 51.91 | 600.24 | 324.45 | |||
SO51113_17 | C890-4CA6-90 | PO11136135505 | 19 | 284 | 231 | 120 | 6 | 2023-09-02 | 29.99 | 0.75 | 2023-08-21 | 1 | 38.49 | 1 | 29.99 | 17 | SO51113 | 2023-08-28 | 2.40 | 38.49 | 29.99 | |||
SO43880_13 | 3269-4442-87 | PO11020127453 | 19 | 284 | 338 | 336 | 6 | 2021-10-03 | 419.46 | 10.49 | 2021-09-21 | 1 | 413.15 | 1 | 419.46 | 13 | SO43880 | 2021-09-28 | 33.56 | 413.15 | 419.46 | |||
SO47670_51 | 0CD2-463E-8F | PO14732184884 | 19 | 291 | 343 | 514 | 6 | 2022-12-03 | 3288.56 | 82.21 | 2022-11-21 | 7 | 486.71 | 1 | 3288.56 | 51 | SO47670 | 2022-11-28 | 263.08 | 3406.95 | 469.79 | |||
SO51113_18 | C890-4CA6-90 | PO11136135505 | 19 | 284 | 565 | 13 | 120 | 6 | 50.11 | 2023-09-02 | 334.06 | 7.10 | 2023-08-21 | 1 | 461.44 | 1 | 283.95 | 18 | SO51113 | 2023-08-28 | 22.72 | 461.44 | 334.06 | 0.15 |
SO43882_1 | 8137-47B8-9B | PO10469165208 | 19 | 288 | 351 | 335 | 6 | 2021-10-03 | 2024.99 | 50.62 | 2021-09-21 | 1 | 1898.09 | 1 | 2024.99 | 1 | SO43882 | 2021-09-28 | 162.00 | 1898.09 | 2024.99 | |||
SO47670_52 | 0CD2-463E-8F | PO14732184884 | 19 | 291 | 454 | 514 | 6 | 2022-12-03 | 107.98 | 2.70 | 2022-11-21 | 3 | 24.75 | 1 | 107.98 | 52 | SO47670 | 2022-11-28 | 8.64 | 74.24 | 35.99 | |||
SO51113_19 | C890-4CA6-90 | PO11136135505 | 19 | 284 | 568 | 13 | 120 | 6 | 50.11 | 2023-09-02 | 334.06 | 7.10 | 2023-08-21 | 1 | 461.44 | 1 | 283.95 | 19 | SO51113 | 2023-08-28 | 22.72 | 461.44 | 334.06 | 0.15 |
SO43886_1 | CE58-49B5-82 | PO1827149671 | 19 | 288 | 315 | 317 | 6 | 2021-10-03 | 1749.59 | 43.74 | 2021-09-21 | 2 | 884.71 | 1 | 1749.59 | 1 | SO43886 | 2021-09-28 | 139.97 | 1769.42 | 874.79 | |||
SO47670_53 | 0CD2-463E-8F | PO14732184884 | 19 | 291 | 456 | 514 | 6 | 2022-12-03 | 179.98 | 4.50 | 2022-11-21 | 4 | 30.93 | 1 | 179.98 | 53 | SO47670 | 2022-11-28 | 14.40 | 123.73 | 44.99 | |||
SO51114_1 | 27F4-4785-B5 | PO11049111057 | 19 | 284 | 384 | 679 | 6 | 2023-09-02 | 672.29 | 16.81 | 2023-08-21 | 1 | 713.08 | 1 | 672.29 | 1 | SO51114 | 2023-08-28 | 53.78 | 713.08 | 672.29 | |||
SO43886_2 | CE58-49B5-82 | PO1827149671 | 19 | 288 | 328 | 317 | 6 | 2021-10-03 | 419.46 | 10.49 | 2021-09-21 | 1 | 413.15 | 1 | 419.46 | 2 | SO43886 | 2021-09-28 | 33.56 | 413.15 | 419.46 | |||
SO47670_54 | 0CD2-463E-8F | PO14732184884 | 19 | 291 | 466 | 514 | 6 | 2022-12-03 | 14.13 | 0.35 | 2022-11-21 | 1 | 9.71 | 1 | 14.13 | 54 | SO47670 | 2022-11-28 | 1.13 | 9.71 | 14.13 | |||
SO51116_1 | B371-45B5-B0 | PO10527115387 | 19 | 284 | 490 | 480 | 6 | 2023-09-02 | 194.36 | 4.86 | 2023-08-21 | 6 | 41.57 | 1 | 194.36 | 1 | SO51116 | 2023-08-28 | 15.55 | 249.43 | 32.39 | |||
SO43886_3 | CE58-49B5-82 | PO1827149671 | 19 | 288 | 264 | 317 | 6 | 2021-10-03 | 367.88 | 9.20 | 2021-09-21 | 2 | 181.49 | 1 | 367.88 | 3 | SO43886 | 2021-09-28 | 29.43 | 362.97 | 183.94 | |||
SO47670_55 | 0CD2-463E-8F | PO14732184884 | 19 | 291 | 445 | 514 | 6 | 2022-12-03 | 143.98 | 3.60 | 2022-11-21 | 4 | 24.75 | 1 | 143.98 | 55 | SO47670 | 2022-11-28 | 11.52 | 98.98 | 35.99 | |||
SO51116_2 | B371-45B5-B0 | PO10527115387 | 19 | 284 | 214 | 11 | 480 | 6 | 14.17 | 2023-09-02 | 94.47 | 2.01 | 2023-08-21 | 6 | 13.09 | 1 | 80.30 | 2 | SO51116 | 2023-08-28 | 6.42 | 78.52 | 15.75 | 0.15 |
SO43886_4 | CE58-49B5-82 | PO1827149671 | 19 | 288 | 338 | 317 | 6 | 2021-10-03 | 419.46 | 10.49 | 2021-09-21 | 1 | 413.15 | 1 | 419.46 | 4 | SO43886 | 2021-09-28 | 33.56 | 413.15 | 419.46 | |||
SO47670_56 | 0CD2-463E-8F | PO14732184884 | 19 | 291 | 457 | 514 | 6 | 2022-12-03 | 179.98 | 4.50 | 2022-11-21 | 4 | 30.93 | 1 | 179.98 | 56 | SO47670 | 2022-11-28 | 14.40 | 123.73 | 44.99 | |||
SO51116_3 | B371-45B5-B0 | PO10527115387 | 19 | 284 | 472 | 480 | 6 | 2023-09-02 | 152.40 | 3.81 | 2023-08-21 | 4 | 23.75 | 1 | 152.40 | 3 | SO51116 | 2023-08-28 | 12.19 | 95.00 | 38.10 | |||
SO43886_5 | CE58-49B5-82 | PO1827149671 | 19 | 288 | 317 | 317 | 6 | 2021-10-03 | 1749.59 | 43.74 | 2021-09-21 | 2 | 884.71 | 1 | 1749.59 | 5 | SO43886 | 2021-09-28 | 139.97 | 1769.42 | 874.79 | |||
SO47670_57 | 0CD2-463E-8F | PO14732184884 | 19 | 291 | 280 | 514 | 6 | 2022-12-03 | 735.75 | 18.39 | 2022-11-21 | 4 | 170.14 | 1 | 735.75 | 57 | SO47670 | 2022-11-28 | 58.86 | 680.57 | 183.94 | |||
SO51116_4 | B371-45B5-B0 | PO10527115387 | 19 | 284 | 231 | 480 | 6 | 2023-09-02 | 89.98 | 2.25 | 2023-08-21 | 3 | 38.49 | 1 | 89.98 | 4 | SO51116 | 2023-08-28 | 7.20 | 115.48 | 29.99 | |||
SO43886_6 | CE58-49B5-82 | PO1827149671 | 19 | 288 | 220 | 317 | 6 | 2021-10-03 | 60.56 | 1.51 | 2021-09-21 | 3 | 12.03 | 1 | 60.56 | 6 | SO43886 | 2021-09-28 | 4.84 | 36.08 | 20.19 | |||
SO47673_1 | AFCF-4DA6-99 | PO13862175462 | 19 | 291 | 412 | 119 | 6 | 2022-12-03 | 180.13 | 4.50 | 2022-11-21 | 1 | 133.30 | 1 | 180.13 | 1 | SO47673 | 2022-11-28 | 14.41 | 133.30 | 180.13 | |||
SO51116_5 | B371-45B5-B0 | PO10527115387 | 19 | 284 | 222 | 11 | 480 | 6 | 14.17 | 2023-09-02 | 94.47 | 2.01 | 2023-08-21 | 6 | 13.09 | 1 | 80.30 | 5 | SO51116 | 2023-08-28 | 6.42 | 78.52 | 15.75 | 0.15 |
SO43886_7 | CE58-49B5-82 | PO1827149671 | 19 | 288 | 223 | 317 | 6 | 2021-10-03 | 31.12 | 0.78 | 2021-09-21 | 6 | 5.71 | 1 | 31.12 | 7 | SO43886 | 2021-09-28 | 2.49 | 34.23 | 5.19 | |||
SO47673_2 | AFCF-4DA6-99 | PO13862175462 | 19 | 291 | 468 | 119 | 6 | 2022-12-03 | 22.79 | 0.57 | 2022-11-21 | 1 | 15.67 | 1 | 22.79 | 2 | SO47673 | 2022-11-28 | 1.82 | 15.67 | 22.79 | |||
SO51116_6 | B371-45B5-B0 | PO10527115387 | 19 | 284 | 546 | 480 | 6 | 2023-09-02 | 37.25 | 0.93 | 2023-08-21 | 1 | 27.57 | 1 | 37.25 | 6 | SO51116 | 2023-08-28 | 2.98 | 27.57 | 37.25 | |||
SO43886_8 | CE58-49B5-82 | PO1827149671 | 19 | 288 | 215 | 317 | 6 | 2021-10-03 | 20.19 | 0.50 | 2021-09-21 | 1 | 12.03 | 1 | 20.19 | 8 | SO43886 | 2021-09-28 | 1.61 | 12.03 | 20.19 |
Generated 2024-09-20 21:35:37.767 UTC