[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > < SKIP 1939 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO48295_22 | 12F9-466B-B0 | PO19343197973 | 100 | 282 | 242 | 24 | 4 | 2023-02-03 | 1561.64 | 39.04 | 2023-01-22 | 2 | 722.26 | 1 | 1561.64 | 22 | SO48295 | 2023-01-29 | 124.93 | 1444.51 | 780.82 | |||
SO51102_15 | F2B1-4561-84 | PO13659193365 | 100 | 287 | 357 | 437 | 4 | 2023-09-03 | 4175.98 | 104.40 | 2023-08-22 | 3 | 1265.62 | 1 | 4175.98 | 15 | SO51102 | 2023-08-29 | 334.08 | 3796.86 | 1391.99 | |||
SO44777_7 | CCD0-4777-A4 | PO3248124126 | 100 | 282 | 300 | 366 | 4 | 2022-02-03 | 809.76 | 20.24 | 2022-01-22 | 1 | 699.09 | 1 | 809.76 | 7 | SO44777 | 2022-01-29 | 64.78 | 699.09 | 809.76 | |||
SO48295_23 | 12F9-466B-B0 | PO19343197973 | 100 | 282 | 265 | 24 | 4 | 2023-02-03 | 809.33 | 20.23 | 2023-01-22 | 4 | 187.16 | 1 | 809.33 | 23 | SO48295 | 2023-01-29 | 64.75 | 748.63 | 202.33 | |||
SO51102_16 | F2B1-4561-84 | PO13659193365 | 100 | 287 | 524 | 437 | 4 | 2023-09-03 | 475.29 | 11.88 | 2023-08-22 | 3 | 144.59 | 1 | 475.29 | 16 | SO51102 | 2023-08-29 | 38.02 | 433.78 | 158.43 | |||
SO44777_8 | CCD0-4777-A4 | PO3248124126 | 100 | 282 | 304 | 366 | 4 | 2022-02-03 | 714.70 | 17.87 | 2022-01-22 | 1 | 617.03 | 1 | 714.70 | 8 | SO44777 | 2022-01-29 | 57.18 | 617.03 | 714.70 | |||
SO48295_24 | 12F9-466B-B0 | PO19343197973 | 100 | 282 | 448 | 24 | 4 | 2023-02-03 | 83.96 | 2.10 | 2023-01-22 | 7 | 8.25 | 1 | 83.96 | 24 | SO48295 | 2023-01-29 | 6.72 | 57.72 | 11.99 | |||
SO51102_17 | F2B1-4561-84 | PO13659193365 | 100 | 287 | 596 | 437 | 4 | 2023-09-03 | 323.99 | 8.10 | 2023-08-22 | 1 | 294.58 | 1 | 323.99 | 17 | SO51102 | 2023-08-29 | 25.92 | 294.58 | 323.99 | |||
SO44777_9 | CCD0-4777-A4 | PO3248124126 | 100 | 282 | 307 | 366 | 4 | 2022-02-03 | 2890.38 | 72.26 | 2022-01-22 | 4 | 623.84 | 1 | 2890.38 | 9 | SO44777 | 2022-01-29 | 231.23 | 2495.36 | 722.59 | |||
SO48295_25 | 12F9-466B-B0 | PO19343197973 | 100 | 282 | 445 | 2 | 24 | 4 | 8.35 | 2023-02-03 | 417.53 | 10.23 | 2023-01-22 | 12 | 24.75 | 1 | 409.18 | 25 | SO48295 | 2023-01-29 | 32.73 | 296.95 | 34.79 | 0.02 |
SO51102_18 | F2B1-4561-84 | PO13659193365 | 100 | 287 | 532 | 437 | 4 | 2023-09-03 | 449.62 | 11.24 | 2023-08-22 | 3 | 136.79 | 1 | 449.62 | 18 | SO51102 | 2023-08-29 | 35.97 | 410.36 | 149.87 | |||
SO44777_10 | CCD0-4777-A4 | PO3248124126 | 100 | 282 | 346 | 366 | 4 | 2022-02-03 | 10199.97 | 255.00 | 2022-01-22 | 5 | 1912.15 | 1 | 10199.97 | 10 | SO44777 | 2022-01-29 | 816.00 | 9560.77 | 2039.99 | |||
SO48295_26 | 12F9-466B-B0 | PO19343197973 | 100 | 282 | 389 | 24 | 4 | 2023-02-03 | 1200.53 | 30.01 | 2023-01-22 | 2 | 605.65 | 1 | 1200.53 | 26 | SO48295 | 2023-01-29 | 96.04 | 1211.30 | 600.26 | |||
SO51102_19 | F2B1-4561-84 | PO13659193365 | 100 | 287 | 597 | 437 | 4 | 2023-09-03 | 971.98 | 24.30 | 2023-08-22 | 3 | 294.58 | 1 | 971.98 | 19 | SO51102 | 2023-08-29 | 77.76 | 883.74 | 323.99 | |||
SO44777_11 | CCD0-4777-A4 | PO3248124126 | 100 | 282 | 347 | 366 | 4 | 2022-02-03 | 8159.98 | 204.00 | 2022-01-22 | 4 | 1912.15 | 1 | 8159.98 | 11 | SO44777 | 2022-01-29 | 652.80 | 7648.62 | 2039.99 | |||
SO48295_27 | 12F9-466B-B0 | PO19343197973 | 100 | 282 | 273 | 24 | 4 | 2023-02-03 | 809.33 | 20.23 | 2023-01-22 | 4 | 187.16 | 1 | 809.33 | 27 | SO48295 | 2023-01-29 | 64.75 | 748.63 | 202.33 | |||
SO51102_20 | F2B1-4561-84 | PO13659193365 | 100 | 287 | 474 | 437 | 4 | 2023-09-03 | 335.95 | 8.40 | 2023-08-22 | 8 | 26.18 | 1 | 335.95 | 20 | SO51102 | 2023-08-29 | 26.88 | 209.41 | 41.99 | |||
SO44777_12 | CCD0-4777-A4 | PO3248124126 | 100 | 282 | 235 | 366 | 4 | 2022-02-03 | 86.52 | 2.16 | 2022-01-22 | 3 | 31.72 | 1 | 86.52 | 12 | SO44777 | 2022-01-29 | 6.92 | 95.17 | 28.84 | |||
SO48295_28 | 12F9-466B-B0 | PO19343197973 | 100 | 282 | 369 | 24 | 4 | 2023-02-03 | 1466.01 | 36.65 | 2023-01-22 | 1 | 1518.79 | 1 | 1466.01 | 28 | SO48295 | 2023-01-29 | 117.28 | 1518.79 | 1466.01 | |||
SO51102_21 | F2B1-4561-84 | PO13659193365 | 100 | 287 | 587 | 437 | 4 | 2023-09-03 | 923.39 | 23.08 | 2023-08-22 | 2 | 419.78 | 1 | 923.39 | 21 | SO51102 | 2023-08-29 | 73.87 | 839.56 | 461.69 | |||
SO44777_13 | CCD0-4777-A4 | PO3248124126 | 100 | 282 | 296 | 366 | 4 | 2022-02-03 | 2144.11 | 53.60 | 2022-01-22 | 3 | 617.03 | 1 | 2144.11 | 13 | SO44777 | 2022-01-29 | 171.53 | 1851.08 | 714.70 | |||
SO48295_29 | 12F9-466B-B0 | PO19343197973 | 100 | 282 | 456 | 3 | 24 | 4 | 33.00 | 2023-02-03 | 659.91 | 15.67 | 2023-01-22 | 16 | 30.93 | 1 | 626.92 | 29 | SO48295 | 2023-01-29 | 50.15 | 494.93 | 41.24 | 0.05 |
SO51102_22 | F2B1-4561-84 | PO13659193365 | 100 | 287 | 359 | 437 | 4 | 2023-09-03 | 8261.96 | 206.55 | 2023-08-22 | 6 | 1251.98 | 1 | 8261.96 | 22 | SO51102 | 2023-08-29 | 660.96 | 7511.89 | 1376.99 | |||
SO44777_14 | CCD0-4777-A4 | PO3248124126 | 100 | 282 | 212 | 366 | 4 | 2022-02-03 | 80.75 | 2.02 | 2022-01-22 | 4 | 12.03 | 1 | 80.75 | 14 | SO44777 | 2022-01-29 | 6.46 | 48.11 | 20.19 | |||
SO48295_30 | 12F9-466B-B0 | PO19343197973 | 100 | 282 | 429 | 24 | 4 | 2023-02-03 | 324.45 | 8.11 | 2023-01-22 | 1 | 300.12 | 1 | 324.45 | 30 | SO48295 | 2023-01-29 | 25.96 | 300.12 | 324.45 | |||
SO51102_23 | F2B1-4561-84 | PO13659193365 | 100 | 287 | 543 | 437 | 4 | 2023-09-03 | 111.76 | 2.79 | 2023-08-22 | 3 | 27.57 | 1 | 111.76 | 23 | SO51102 | 2023-08-29 | 8.94 | 82.70 | 37.25 | |||
SO44777_15 | CCD0-4777-A4 | PO3248124126 | 100 | 282 | 215 | 366 | 4 | 2022-02-03 | 60.56 | 1.51 | 2022-01-22 | 3 | 12.03 | 1 | 60.56 | 15 | SO44777 | 2022-01-29 | 4.84 | 36.08 | 20.19 | |||
SO48295_31 | 12F9-466B-B0 | PO19343197973 | 100 | 282 | 230 | 2 | 24 | 4 | 7.81 | 2023-02-03 | 390.31 | 9.56 | 2023-01-22 | 14 | 29.08 | 1 | 382.50 | 31 | SO48295 | 2023-01-29 | 30.60 | 407.13 | 27.88 | 0.02 |
SO51102_24 | F2B1-4561-84 | PO13659193365 | 100 | 287 | 600 | 437 | 4 | 2023-09-03 | 647.99 | 16.20 | 2023-08-22 | 2 | 294.58 | 1 | 647.99 | 24 | SO51102 | 2023-08-29 | 51.84 | 589.16 | 323.99 | |||
SO44777_16 | CCD0-4777-A4 | PO3248124126 | 100 | 282 | 350 | 366 | 4 | 2022-02-03 | 12149.96 | 303.75 | 2022-01-22 | 6 | 1898.09 | 1 | 12149.96 | 16 | SO44777 | 2022-01-29 | 972.00 | 11388.57 | 2024.99 |
Generated 2024-09-21 08:32:44.084 UTC