[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '3' > SKIP 0 SHUFFLE < SKIP 1065 > < TAKE 24 >
24 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO49492_14 | 8C0F-4EEC-81 | PO19633118522 | 100 | 287 | 469 | 149 | 3 | 2023-05-04 | 136.76 | 3.42 | 2023-04-22 | 6 | 15.67 | 1 | 136.76 | 14 | SO49492 | 2023-04-29 | 10.94 | 94.03 | 22.79 | |||
SO59005_1 | 1873-4FCC-AA | PO11890144892 | 100 | 281 | 515 | 472 | 3 | 2024-02-03 | 16.27 | 0.41 | 2024-01-22 | 1 | 12.04 | 1 | 16.27 | 1 | SO59005 | 2024-01-29 | 1.30 | 12.04 | 16.27 | |||
SO57121_11 | A796-4C1D-A6 | PO5771187733 | 100 | 282 | 481 | 2 | 79 | 3 | 1.15 | 2024-01-04 | 57.36 | 1.41 | 2023-12-23 | 11 | 3.36 | 1 | 56.21 | 11 | SO57121 | 2023-12-30 | 4.50 | 36.99 | 5.21 | 0.02 |
SO61240_15 | 16E9-4057-BF | PO6467181082 | 100 | 283 | 225 | 660 | 3 | 2024-03-05 | 21.58 | 0.54 | 2024-02-22 | 4 | 6.92 | 1 | 21.58 | 15 | SO61240 | 2024-02-29 | 1.73 | 27.69 | 5.39 | |||
SO50661_21 | CE6E-45C9-A1 | PO19633184648 | 100 | 287 | 360 | 149 | 3 | 2023-08-04 | 4917.84 | 122.95 | 2023-07-23 | 4 | 1105.81 | 1 | 4917.84 | 21 | SO50661 | 2023-07-30 | 393.43 | 4423.24 | 1229.46 | |||
SO58906_14 | 6BB0-48C1-BE | PO19633186598 | 100 | 287 | 357 | 149 | 3 | 2024-02-03 | 4175.98 | 104.40 | 2024-01-22 | 3 | 1265.62 | 1 | 4175.98 | 14 | SO58906 | 2024-01-29 | 334.08 | 3796.86 | 1391.99 | |||
SO51730_3 | 5526-465E-B8 | PO13572190190 | 100 | 287 | 440 | 527 | 3 | 2023-10-04 | 1717.80 | 42.95 | 2023-09-22 | 2 | 868.63 | 1 | 1717.80 | 3 | SO51730 | 2023-09-29 | 137.42 | 1737.27 | 858.90 | |||
SO45795_4 | EA72-4C1D-BB | PO12412125626 | 100 | 283 | 223 | 670 | 3 | 2022-06-04 | 10.37 | 0.26 | 2022-05-23 | 2 | 5.71 | 1 | 10.37 | 4 | SO45795 | 2022-05-30 | 0.83 | 11.41 | 5.19 | |||
SO69503_20 | 559D-4568-82 | PO5771124379 | 100 | 282 | 546 | 79 | 3 | 2024-07-04 | 186.27 | 4.66 | 2024-06-22 | 5 | 27.57 | 1 | 186.27 | 20 | SO69503 | 2024-06-29 | 14.90 | 137.84 | 37.25 | |||
SO48786_22 | D12C-42C5-83 | PO6467115913 | 100 | 283 | 329 | 660 | 3 | 2023-03-06 | 2348.97 | 58.72 | 2023-02-22 | 5 | 486.71 | 1 | 2348.97 | 22 | SO48786 | 2023-03-01 | 187.92 | 2433.53 | 469.79 | |||
SO46605_16 | 88F6-4172-B3 | PO19314112090 | 100 | 283 | 213 | 8 | 622 | 3 | 3.36 | 2022-09-03 | 33.64 | 0.76 | 2022-08-22 | 2 | 13.88 | 1 | 30.28 | 16 | SO46605 | 2022-08-29 | 2.42 | 27.76 | 16.82 | 0.10 |
SO45326_14 | 8C75-4F67-95 | PO5191186622 | 100 | 283 | 322 | 364 | 3 | 2022-04-06 | 419.46 | 10.49 | 2022-03-25 | 1 | 413.15 | 1 | 419.46 | 14 | SO45326 | 2022-04-01 | 33.56 | 413.15 | 419.46 | |||
SO48786_11 | D12C-42C5-83 | PO6467115913 | 100 | 283 | 445 | 660 | 3 | 2023-03-06 | 35.99 | 0.90 | 2023-02-22 | 1 | 24.75 | 1 | 35.99 | 11 | SO48786 | 2023-03-01 | 2.88 | 24.75 | 35.99 | |||
SO48735_14 | BFBE-46B9-A1 | PO12412161905 | 100 | 281 | 370 | 670 | 3 | 2023-03-06 | 7330.05 | 183.25 | 2023-02-22 | 5 | 1518.79 | 1 | 7330.05 | 14 | SO48735 | 2023-03-01 | 586.40 | 7593.93 | 1466.01 | |||
SO65309_1 | 2657-4F2D-AD | PO6902173230 | 100 | 281 | 476 | 543 | 3 | 2024-05-04 | 83.99 | 2.10 | 2024-04-22 | 2 | 26.18 | 1 | 83.99 | 1 | SO65309 | 2024-04-29 | 6.72 | 52.35 | 41.99 | |||
SO46662_37 | 07F7-472E-AC | PO6467187386 | 100 | 281 | 233 | 3 | 660 | 3 | 23.79 | 2022-09-03 | 475.87 | 11.30 | 2022-08-22 | 18 | 29.08 | 1 | 452.07 | 37 | SO46662 | 2022-08-29 | 36.17 | 523.45 | 26.44 | 0.05 |
SO46358_7 | 3BC7-40F4-99 | PO1624111969 | 100 | 283 | 324 | 579 | 3 | 2022-08-04 | 419.46 | 10.49 | 2022-07-23 | 1 | 413.15 | 1 | 419.46 | 7 | SO46358 | 2022-07-30 | 33.56 | 413.15 | 419.46 | |||
SO46081_2 | EAE7-4EEC-9A | PO3045173949 | 100 | 283 | 322 | 58 | 3 | 2022-07-04 | 419.46 | 10.49 | 2022-06-22 | 1 | 413.15 | 1 | 419.46 | 2 | SO46081 | 2022-06-29 | 33.56 | 413.15 | 419.46 | |||
SO47440_2 | 490D-4B3C-84 | PO7018185620 | 100 | 283 | 456 | 695 | 3 | 2022-11-04 | 224.97 | 5.62 | 2022-10-23 | 5 | 30.93 | 1 | 224.97 | 2 | SO47440 | 2022-10-30 | 18.00 | 154.67 | 44.99 | |||
SO69418_19 | D0CE-41AD-AA | PO15370180703 | 100 | 281 | 559 | 381 | 3 | 2024-07-04 | 85.01 | 2.13 | 2024-06-22 | 7 | 8.99 | 1 | 85.01 | 19 | SO69418 | 2024-06-29 | 6.80 | 62.91 | 12.14 | |||
SO44079_3 | A180-4128-A7 | PO19488118734 | 100 | 283 | 342 | 57 | 3 | 2021-11-04 | 838.92 | 20.97 | 2021-10-23 | 2 | 413.15 | 1 | 838.92 | 3 | SO44079 | 2021-10-30 | 67.11 | 826.29 | 419.46 | |||
SO53454_3 | 278D-445A-99 | PO19633151350 | 100 | 287 | 596 | 149 | 3 | 2023-11-04 | 971.98 | 24.30 | 2023-10-23 | 3 | 294.58 | 1 | 971.98 | 3 | SO53454 | 2023-10-30 | 77.76 | 883.74 | 323.99 | |||
SO57113_3 | 160E-42A8-97 | PO12122117991 | 100 | 281 | 434 | 22 | 3 | 2024-01-04 | 1427.59 | 35.69 | 2023-12-23 | 4 | 360.94 | 1 | 1427.59 | 3 | SO57113 | 2023-12-30 | 114.21 | 1443.77 | 356.90 | |||
SO46671_15 | 13F6-4858-8D | PO8787194061 | 100 | 282 | 267 | 523 | 3 | 2022-09-03 | 809.33 | 20.23 | 2022-08-22 | 4 | 187.16 | 1 | 809.33 | 15 | SO46671 | 2022-08-29 | 64.75 | 748.63 | 202.33 |
Generated 2024-09-21 05:30:57.757 UTC