[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SHUFFLE SKIP 2000 < SKIP 503 > < TAKE 14 >
14 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO49105_2 | B762-4BA5-A0 | PO14500175804 | 100 | 282 | 366 | 650 | 1 | 2023-04-05 | 1943.98 | 48.60 | 2023-03-24 | 3 | 598.44 | 1 | 1943.98 | 2 | SO49105 | 2023-03-31 | 155.52 | 1795.31 | 647.99 | |||
SO71880_35 | B0C7-4858-91 | PO7395117544 | 100 | 286 | 594 | 16 | 542 | 1 | 45.20 | 2024-08-03 | 113.00 | 1.70 | 2024-07-22 | 1 | 308.22 | 1 | 67.80 | 35 | SO71880 | 2024-07-29 | 5.42 | 308.22 | 113.00 | 0.40 |
SO46323_3 | 3AF8-4F1A-97 | PO20155112356 | 100 | 289 | 218 | 92 | 1 | 2022-08-03 | 17.10 | 0.43 | 2022-07-22 | 3 | 3.40 | 1 | 17.10 | 3 | SO46323 | 2022-07-29 | 1.37 | 10.19 | 5.70 | |||
SO71835_34 | EBBF-4B16-99 | PO870120974 | 100 | 286 | 555 | 621 | 1 | 2024-08-03 | 63.90 | 1.60 | 2024-07-22 | 1 | 47.29 | 1 | 63.90 | 34 | SO71835 | 2024-07-29 | 5.11 | 47.29 | 63.90 | |||
SO43866_2 | B6E8-4721-85 | PO14529112624 | 100 | 286 | 350 | 289 | 1 | 2021-10-03 | 2024.99 | 50.62 | 2021-09-21 | 1 | 1898.09 | 1 | 2024.99 | 2 | SO43866 | 2021-09-28 | 162.00 | 1898.09 | 2024.99 | |||
SO71836_13 | E41E-40C1-84 | PO841118259 | 100 | 286 | 533 | 254 | 1 | 2024-08-03 | 599.50 | 14.99 | 2024-07-22 | 4 | 136.79 | 1 | 599.50 | 13 | SO71836 | 2024-07-29 | 47.96 | 547.14 | 149.87 | |||
SO71833_33 | 8525-4645-AB | PO10411123072 | 100 | 289 | 577 | 182 | 1 | 2024-08-03 | 2915.64 | 72.89 | 2024-07-22 | 4 | 755.15 | 1 | 2915.64 | 33 | SO71833 | 2024-07-29 | 233.25 | 3020.60 | 728.91 | |||
SO67322_29 | 1881-4634-82 | PO6612121393 | 100 | 286 | 561 | 110 | 1 | 2024-06-03 | 5721.77 | 143.04 | 2024-05-22 | 4 | 1481.94 | 1 | 5721.77 | 29 | SO67322 | 2024-05-29 | 457.74 | 5927.75 | 1430.44 | |||
SO61267_8 | BCFD-47EE-BD | PO7076191943 | 100 | 293 | 506 | 505 | 1 | 2024-03-04 | 600.16 | 15.00 | 2024-02-21 | 3 | 199.85 | 1 | 600.16 | 8 | SO61267 | 2024-02-28 | 48.01 | 599.56 | 200.05 | |||
SO61185_1 | 1D4F-4639-97 | PO15022115307 | 100 | 289 | 588 | 560 | 1 | 2024-03-04 | 461.69 | 11.54 | 2024-02-21 | 1 | 419.78 | 1 | 461.69 | 1 | SO61185 | 2024-02-28 | 36.94 | 419.78 | 461.69 | |||
SO51711_54 | 5CB8-480D-A1 | PO16414129790 | 100 | 289 | 557 | 236 | 1 | 2023-10-03 | 615.58 | 15.39 | 2023-09-21 | 4 | 113.88 | 1 | 615.58 | 54 | SO51711 | 2023-09-28 | 49.25 | 455.53 | 153.89 | |||
SO47666_5 | 6551-4B29-BF | PO16588184420 | 100 | 289 | 456 | 146 | 1 | 2022-12-03 | 134.98 | 3.37 | 2022-11-21 | 3 | 30.93 | 1 | 134.98 | 5 | SO47666 | 2022-11-28 | 10.80 | 92.80 | 44.99 | |||
SO49114_4 | 354C-48D4-9B | PO15631175128 | 100 | 282 | 409 | 43 | 1 | 2023-04-05 | 627.77 | 15.69 | 2023-03-24 | 3 | 185.82 | 1 | 627.77 | 4 | SO49114 | 2023-03-31 | 50.22 | 557.46 | 209.26 | |||
SO69408_40 | 8DF5-4377-9D | PO16414161428 | 100 | 289 | 501 | 236 | 1 | 2024-07-03 | 291.50 | 7.29 | 2024-06-21 | 4 | 53.93 | 1 | 291.50 | 40 | SO69408 | 2024-06-28 | 23.32 | 215.71 | 72.88 |
Generated 2024-09-20 09:50:43.604 UTC