[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > SKIP 0 SHUFFLE < SKIP 1096 > < TAKE 31 >
31 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO47026_9 | 123B-481F-8F | PO3596190739 | 100 | 285 | 397 | 476 | 5 | 2022-10-03 | 24.29 | 0.61 | 2022-09-21 | 1 | 17.98 | 1 | 24.29 | 9 | SO47026 | 2022-09-28 | 1.94 | 17.98 | 24.29 | |||
SO45288_16 | D4D0-4662-A9 | PO16327170541 | 100 | 285 | 324 | 584 | 5 | 2022-04-05 | 1677.84 | 41.95 | 2022-03-24 | 4 | 413.15 | 1 | 1677.84 | 16 | SO45288 | 2022-03-31 | 134.23 | 1652.59 | 419.46 | |||
SO65207_7 | B20E-440F-A3 | PO1537156240 | 100 | 285 | 222 | 611 | 5 | 2024-05-03 | 146.96 | 3.67 | 2024-04-21 | 7 | 13.09 | 1 | 146.96 | 7 | SO65207 | 2024-04-28 | 11.76 | 91.60 | 20.99 | |||
SO51081_25 | EDBF-4FE1-8F | PO522116846 | 100 | 285 | 217 | 11 | 676 | 5 | 14.17 | 2023-09-02 | 94.47 | 2.01 | 2023-08-21 | 6 | 13.09 | 1 | 80.30 | 25 | SO51081 | 2023-08-28 | 6.42 | 78.52 | 15.75 | 0.15 |
SO53540_2 | 1C52-4046-BA | PO18241135767 | 100 | 285 | 569 | 13 | 477 | 5 | 50.11 | 2023-11-03 | 334.06 | 7.10 | 2023-10-22 | 1 | 461.44 | 1 | 283.95 | 2 | SO53540 | 2023-10-29 | 22.72 | 461.44 | 334.06 | 0.15 |
SO61217_3 | 9B9A-4C8B-93 | PO9889149314 | 100 | 285 | 598 | 494 | 5 | 2024-03-04 | 647.99 | 16.20 | 2024-02-21 | 2 | 294.58 | 1 | 647.99 | 3 | SO61217 | 2024-02-28 | 51.84 | 589.16 | 323.99 | |||
SO49149_24 | D41E-4EFF-A5 | PO5858123072 | 100 | 285 | 233 | 566 | 5 | 2023-04-05 | 144.20 | 3.61 | 2023-03-24 | 5 | 29.08 | 1 | 144.20 | 24 | SO49149 | 2023-03-31 | 11.54 | 145.40 | 28.84 | |||
SO65248_13 | A7B5-4EE1-98 | PO9599164617 | 100 | 285 | 380 | 170 | 5 | 2024-05-03 | 7330.05 | 183.25 | 2024-04-21 | 5 | 1554.95 | 1 | 7330.05 | 13 | SO65248 | 2024-04-28 | 586.40 | 7774.74 | 1466.01 | |||
SO63181_26 | CB4E-4CF5-87 | PO2842135731 | 100 | 285 | 583 | 700 | 5 | 2024-04-04 | 2041.19 | 51.03 | 2024-03-23 | 2 | 1082.51 | 1 | 2041.19 | 26 | SO63181 | 2024-03-30 | 163.30 | 2165.02 | 1020.59 | |||
SO61217_12 | 9B9A-4C8B-93 | PO9889149314 | 100 | 285 | 353 | 494 | 5 | 2024-03-04 | 2783.99 | 69.60 | 2024-02-21 | 2 | 1265.62 | 1 | 2783.99 | 12 | SO61217 | 2024-02-28 | 222.72 | 2531.24 | 1391.99 | |||
SO51137_6 | A47F-4FEF-94 | PO9889144162 | 100 | 285 | 525 | 494 | 5 | 2023-09-02 | 475.29 | 11.88 | 2023-08-21 | 3 | 144.59 | 1 | 475.29 | 6 | SO51137 | 2023-08-28 | 38.02 | 433.78 | 158.43 | |||
SO55328_41 | 577D-4DE9-B6 | PO9831188161 | 100 | 285 | 382 | 81 | 5 | 2023-12-03 | 1344.59 | 33.61 | 2023-11-21 | 2 | 713.08 | 1 | 1344.59 | 41 | SO55328 | 2023-11-28 | 107.57 | 1426.16 | 672.29 | |||
SO57162_12 | 83B5-43A6-BD | PO3596174424 | 100 | 285 | 588 | 476 | 5 | 2024-01-03 | 461.69 | 11.54 | 2023-12-22 | 1 | 419.78 | 1 | 461.69 | 12 | SO57162 | 2023-12-29 | 36.94 | 419.78 | 461.69 | |||
SO71839_17 | 8F89-4B1E-A8 | PO1537119063 | 100 | 285 | 487 | 2 | 611 | 5 | 7.65 | 2024-08-03 | 382.73 | 9.38 | 2024-07-22 | 12 | 20.57 | 1 | 375.08 | 17 | SO71839 | 2024-07-29 | 30.01 | 246.80 | 31.89 | 0.02 |
SO47725_8 | 2501-4A1D-99 | PO9831133395 | 100 | 285 | 230 | 81 | 5 | 2022-12-03 | 28.84 | 0.72 | 2022-11-21 | 1 | 29.08 | 1 | 28.84 | 8 | SO47725 | 2022-11-28 | 2.31 | 29.08 | 28.84 | |||
SO48090_2 | E7D1-44A3-B2 | PO9512117066 | 100 | 285 | 325 | 135 | 5 | 2023-01-03 | 469.79 | 11.74 | 2022-12-22 | 1 | 486.71 | 1 | 469.79 | 2 | SO48090 | 2022-12-29 | 37.58 | 486.71 | 469.79 | |||
SO65229_7 | 7557-4EA8-AD | PO11977163025 | 100 | 285 | 436 | 675 | 5 | 2024-05-03 | 713.80 | 17.84 | 2024-04-21 | 2 | 360.94 | 1 | 713.80 | 7 | SO65229 | 2024-04-28 | 57.10 | 721.89 | 356.90 | |||
SO65210_19 | 08E4-4CC9-A7 | PO2813181442 | 100 | 283 | 471 | 2 | 90 | 5 | 8.84 | 2024-05-03 | 441.96 | 10.83 | 2024-04-21 | 12 | 23.75 | 1 | 433.12 | 19 | SO65210 | 2024-04-28 | 34.65 | 284.99 | 36.83 | 0.02 |
SO50726_39 | A80B-408E-B3 | PO9599192861 | 100 | 285 | 385 | 170 | 5 | 2023-08-03 | 3601.58 | 90.04 | 2023-07-22 | 6 | 605.65 | 1 | 3601.58 | 39 | SO50726 | 2023-07-29 | 288.13 | 3633.90 | 600.26 | |||
SO43693_1 | EC62-4BB3-9B | PO8120182325 | 100 | 281 | 235 | 485 | 5 | 2021-09-02 | 86.52 | 2.16 | 2021-08-21 | 3 | 31.72 | 1 | 86.52 | 1 | SO43693 | 2021-08-28 | 6.92 | 95.17 | 28.84 | |||
SO43659_3 | 4911-403C-98 | PO522145787 | 100 | 285 | 351 | 676 | 5 | 2021-09-02 | 2024.99 | 50.62 | 2021-08-21 | 1 | 1898.09 | 1 | 2024.99 | 3 | SO43659 | 2021-08-28 | 162.00 | 1898.09 | 2024.99 | |||
SO49865_16 | E9A6-42D3-91 | PO9831136904 | 100 | 285 | 447 | 81 | 5 | 2023-06-03 | 60.00 | 1.50 | 2023-05-22 | 4 | 10.31 | 1 | 60.00 | 16 | SO49865 | 2023-05-29 | 4.80 | 41.25 | 15.00 | |||
SO46991_14 | 6D99-4D79-AA | PO11803111101 | 100 | 285 | 221 | 513 | 5 | 2022-10-03 | 121.12 | 3.03 | 2022-09-21 | 6 | 13.88 | 1 | 121.12 | 14 | SO46991 | 2022-09-28 | 9.69 | 83.27 | 20.19 | |||
SO61228_19 | 06C7-43A1-85 | PO9831151400 | 100 | 285 | 231 | 81 | 5 | 2024-03-04 | 269.95 | 6.75 | 2024-02-21 | 9 | 38.49 | 1 | 269.95 | 19 | SO61228 | 2024-02-28 | 21.60 | 346.43 | 29.99 | |||
SO44761_12 | FD24-4EF8-9E | PO13746123317 | 100 | 285 | 348 | 567 | 5 | 2022-02-02 | 4049.99 | 101.25 | 2022-01-21 | 2 | 1898.09 | 1 | 4049.99 | 12 | SO44761 | 2022-01-28 | 324.00 | 3796.19 | 2024.99 | |||
SO48395_8 | 46D3-4C51-AD | PO9570174316 | 100 | 285 | 458 | 585 | 5 | 2023-02-02 | 134.98 | 3.37 | 2023-01-21 | 3 | 30.93 | 1 | 134.98 | 8 | SO48395 | 2023-01-28 | 10.80 | 92.80 | 44.99 | |||
SO71839_12 | 8F89-4B1E-A8 | PO1537119063 | 100 | 285 | 579 | 611 | 5 | 2024-08-03 | 7289.10 | 182.23 | 2024-07-22 | 10 | 755.15 | 1 | 7289.10 | 12 | SO71839 | 2024-07-29 | 583.13 | 7551.51 | 728.91 | |||
SO48020_3 | 3995-4B91-82 | PO11542110776 | 100 | 285 | 433 | 62 | 5 | 2023-01-03 | 324.45 | 8.11 | 2022-12-22 | 1 | 300.12 | 1 | 324.45 | 3 | SO48020 | 2022-12-29 | 25.96 | 300.12 | 324.45 | |||
SO49149_10 | D41E-4EFF-A5 | PO5858123072 | 100 | 285 | 365 | 566 | 5 | 2023-04-05 | 1295.99 | 32.40 | 2023-03-24 | 2 | 598.44 | 1 | 1295.99 | 10 | SO49149 | 2023-03-31 | 103.68 | 1196.87 | 647.99 | |||
SO65220_20 | 6D87-4C24-98 | PO15457146892 | 100 | 285 | 572 | 297 | 5 | 2024-05-03 | 890.82 | 22.27 | 2024-04-21 | 2 | 461.44 | 1 | 890.82 | 20 | SO65220 | 2024-04-28 | 71.27 | 922.89 | 445.41 | |||
SO69472_1 | 5046-456D-BE | PO18734123537 | 100 | 283 | 398 | 449 | 5 | 2024-07-03 | 26.72 | 0.67 | 2024-06-21 | 1 | 19.78 | 1 | 26.72 | 1 | SO69472 | 2024-06-28 | 2.14 | 19.78 | 26.72 |
Generated 2024-09-20 10:40:42.241 UTC