[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL < SKIP 3003 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO43917_12 | 9EDA-4CDB-A8 | PO8816199739 | 100 | 289 | 232 | 218 | 1 | 2021-10-03 | 173.04 | 4.33 | 2021-09-21 | 6 | 31.72 | 1 | 173.04 | 12 | SO43917 | 2021-09-28 | 13.84 | 190.35 | 28.84 | |||
SO47694_26 | 8253-4E13-9D | PO899122764 | 100 | 289 | 265 | 290 | 1 | 2022-12-03 | 607.00 | 15.17 | 2022-11-21 | 3 | 187.16 | 1 | 607.00 | 26 | SO47694 | 2022-11-28 | 48.56 | 561.47 | 202.33 | |||
SO51132_11 | D4A8-472C-A4 | PO18444136544 | 19 | 291 | 520 | 227 | 6 | 2023-09-02 | 126.34 | 3.16 | 2023-08-21 | 4 | 23.37 | 1 | 126.34 | 11 | SO51132 | 2023-08-28 | 10.11 | 93.49 | 31.58 | |||
SO43917_13 | 9EDA-4CDB-A8 | PO8816199739 | 100 | 289 | 262 | 218 | 1 | 2021-10-03 | 367.88 | 9.20 | 2021-09-21 | 2 | 181.49 | 1 | 367.88 | 13 | SO43917 | 2021-09-28 | 29.43 | 362.97 | 183.94 | |||
SO47694_27 | 8253-4E13-9D | PO899122764 | 100 | 289 | 433 | 290 | 1 | 2022-12-03 | 1622.26 | 40.56 | 2022-11-21 | 5 | 300.12 | 1 | 1622.26 | 27 | SO47694 | 2022-11-28 | 129.78 | 1500.59 | 324.45 | |||
SO51132_12 | D4A8-472C-A4 | PO18444136544 | 19 | 291 | 382 | 227 | 6 | 2023-09-02 | 2016.88 | 50.42 | 2023-08-21 | 3 | 713.08 | 1 | 2016.88 | 12 | SO51132 | 2023-08-28 | 161.35 | 2139.24 | 672.29 | |||
SO43917_14 | 9EDA-4CDB-A8 | PO8816199739 | 100 | 289 | 342 | 218 | 1 | 2021-10-03 | 838.92 | 20.97 | 2021-09-21 | 2 | 413.15 | 1 | 838.92 | 14 | SO43917 | 2021-09-28 | 67.11 | 826.29 | 419.46 | |||
SO47694_28 | 8253-4E13-9D | PO899122764 | 100 | 289 | 383 | 290 | 1 | 2022-12-03 | 600.26 | 15.01 | 2022-11-21 | 1 | 605.65 | 1 | 600.26 | 28 | SO47694 | 2022-11-28 | 48.02 | 605.65 | 600.26 | |||
SO51132_13 | D4A8-472C-A4 | PO18444136544 | 19 | 291 | 581 | 3 | 227 | 6 | 701.66 | 2023-09-02 | 14033.17 | 333.29 | 2023-08-21 | 15 | 1082.51 | 1 | 13331.51 | 13 | SO51132 | 2023-08-28 | 1066.52 | 16237.65 | 935.54 | 0.05 |
SO44074_1 | 7C63-420E-97 | PO20213115982 | 100 | 281 | 326 | 216 | 2 | 2021-11-03 | 419.46 | 10.49 | 2021-10-22 | 1 | 413.15 | 1 | 419.46 | 1 | SO44074 | 2021-10-29 | 33.56 | 413.15 | 419.46 | |||
SO47694_29 | 8253-4E13-9D | PO899122764 | 100 | 289 | 375 | 290 | 1 | 2022-12-03 | 1308.94 | 32.72 | 2022-11-21 | 1 | 1320.68 | 1 | 1308.94 | 29 | SO47694 | 2022-11-28 | 104.72 | 1320.68 | 1308.94 | |||
SO51132_14 | D4A8-472C-A4 | PO18444136544 | 19 | 291 | 605 | 227 | 6 | 2023-09-02 | 971.98 | 24.30 | 2023-08-21 | 3 | 343.65 | 1 | 971.98 | 14 | SO51132 | 2023-08-28 | 77.76 | 1030.95 | 323.99 | |||
SO44074_2 | 7C63-420E-97 | PO20213115982 | 100 | 281 | 223 | 216 | 2 | 2021-11-03 | 5.19 | 0.13 | 2021-10-22 | 1 | 5.71 | 1 | 5.19 | 2 | SO44074 | 2021-10-29 | 0.41 | 5.71 | 5.19 | |||
SO47694_30 | 8253-4E13-9D | PO899122764 | 100 | 289 | 435 | 290 | 1 | 2022-12-03 | 324.45 | 8.11 | 2022-11-21 | 1 | 300.12 | 1 | 324.45 | 30 | SO47694 | 2022-11-28 | 25.96 | 300.12 | 324.45 | |||
SO51132_15 | D4A8-472C-A4 | PO18444136544 | 19 | 291 | 376 | 227 | 6 | 2023-09-02 | 4398.03 | 109.95 | 2023-08-21 | 3 | 1554.95 | 1 | 4398.03 | 15 | SO51132 | 2023-08-28 | 351.84 | 4664.84 | 1466.01 | |||
SO44074_3 | 7C63-420E-97 | PO20213115982 | 100 | 281 | 342 | 216 | 2 | 2021-11-03 | 419.46 | 10.49 | 2021-10-22 | 1 | 413.15 | 1 | 419.46 | 3 | SO44074 | 2021-10-29 | 33.56 | 413.15 | 419.46 | |||
SO47695_1 | C4BE-499D-BE | PO1421122834 | 100 | 286 | 468 | 325 | 1 | 2022-12-03 | 113.97 | 2.85 | 2022-11-21 | 5 | 15.67 | 1 | 113.97 | 1 | SO47695 | 2022-11-28 | 9.12 | 78.35 | 22.79 | |||
SO51132_16 | D4A8-472C-A4 | PO18444136544 | 19 | 291 | 546 | 227 | 6 | 2023-09-02 | 149.02 | 3.73 | 2023-08-21 | 4 | 27.57 | 1 | 149.02 | 16 | SO51132 | 2023-08-28 | 11.92 | 110.27 | 37.25 | |||
SO44075_1 | 2920-4332-89 | PO20155139653 | 100 | 289 | 346 | 92 | 1 | 2021-11-03 | 2039.99 | 51.00 | 2021-10-22 | 1 | 1912.15 | 1 | 2039.99 | 1 | SO44075 | 2021-10-29 | 163.20 | 1912.15 | 2039.99 | |||
SO47696_1 | B251-4D0B-9C | PO1711162591 | 19 | 291 | 365 | 245 | 6 | 2022-12-03 | 647.99 | 16.20 | 2022-11-21 | 1 | 598.44 | 1 | 647.99 | 1 | SO47696 | 2022-11-28 | 51.84 | 598.44 | 647.99 | |||
SO51132_17 | D4A8-472C-A4 | PO18444136544 | 19 | 291 | 374 | 227 | 6 | 2023-09-02 | 8796.06 | 219.90 | 2023-08-21 | 6 | 1554.95 | 1 | 8796.06 | 17 | SO51132 | 2023-08-28 | 703.68 | 9329.69 | 1466.01 | |||
SO44075_2 | 2920-4332-89 | PO20155139653 | 100 | 289 | 344 | 92 | 1 | 2021-11-03 | 8159.98 | 204.00 | 2021-10-22 | 4 | 1912.15 | 1 | 8159.98 | 2 | SO44075 | 2021-10-29 | 652.80 | 7648.62 | 2039.99 | |||
SO47696_2 | B251-4D0B-9C | PO1711162591 | 19 | 291 | 354 | 245 | 6 | 2022-12-03 | 9942.81 | 248.57 | 2022-11-21 | 8 | 1117.86 | 1 | 9942.81 | 2 | SO47696 | 2022-11-28 | 795.43 | 8942.85 | 1242.85 | |||
SO51132_18 | D4A8-472C-A4 | PO18444136544 | 19 | 291 | 442 | 227 | 6 | 2023-09-02 | 4294.50 | 107.36 | 2023-08-21 | 5 | 868.63 | 1 | 4294.50 | 18 | SO51132 | 2023-08-28 | 343.56 | 4343.17 | 858.90 | |||
SO44075_3 | 2920-4332-89 | PO20155139653 | 100 | 289 | 350 | 92 | 1 | 2021-11-03 | 2024.99 | 50.62 | 2021-10-22 | 1 | 1898.09 | 1 | 2024.99 | 3 | SO44075 | 2021-10-29 | 162.00 | 1898.09 | 2024.99 | |||
SO47696_3 | B251-4D0B-9C | PO1711162591 | 19 | 291 | 352 | 245 | 6 | 2022-12-03 | 4971.41 | 124.29 | 2022-11-21 | 4 | 1117.86 | 1 | 4971.41 | 3 | SO47696 | 2022-11-28 | 397.71 | 4471.42 | 1242.85 | |||
SO51132_19 | D4A8-472C-A4 | PO18444136544 | 19 | 291 | 580 | 3 | 227 | 6 | 1029.10 | 2023-09-02 | 20581.98 | 488.82 | 2023-08-21 | 22 | 1082.51 | 1 | 19552.88 | 19 | SO51132 | 2023-08-28 | 1564.23 | 23815.22 | 935.54 | 0.05 |
SO44075_4 | 2920-4332-89 | PO20155139653 | 100 | 289 | 351 | 92 | 1 | 2021-11-03 | 4049.99 | 101.25 | 2021-10-22 | 2 | 1898.09 | 1 | 4049.99 | 4 | SO44075 | 2021-10-29 | 324.00 | 3796.19 | 2024.99 | |||
SO47696_4 | B251-4D0B-9C | PO1711162591 | 19 | 291 | 409 | 245 | 6 | 2022-12-03 | 1255.54 | 31.39 | 2022-11-21 | 6 | 185.82 | 1 | 1255.54 | 4 | SO47696 | 2022-11-28 | 100.44 | 1114.92 | 209.26 | |||
SO51132_20 | D4A8-472C-A4 | PO18444136544 | 19 | 291 | 408 | 227 | 6 | 2023-09-02 | 216.49 | 5.41 | 2023-08-21 | 3 | 53.40 | 1 | 216.49 | 20 | SO51132 | 2023-08-28 | 17.32 | 160.20 | 72.16 |
Generated 2024-09-20 11:33:16.653 UTC