[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SHUFFLE < SKIP 60 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO51838_27 | 8AB1-478C-86 | PO4727199391 | 100 | 293 | 434 | 343 | 1 | 2023-10-03 | 356.90 | 8.92 | 2023-09-21 | 1 | 360.94 | 1 | 356.90 | 27 | SO51838 | 2023-09-28 | 28.55 | 360.94 | 356.90 | |||
SO53566_23 | 3543-47B0-87 | PO8033117470 | 6 | 296 | 361 | 15 | 9 | 2023-11-03 | 11015.95 | 275.40 | 2023-10-22 | 8 | 1251.98 | 1 | 11015.95 | 23 | SO53566 | 2023-10-29 | 881.28 | 10015.85 | 1376.99 | |||
SO53576_10 | 7638-4151-96 | PO7395119515 | 100 | 286 | 551 | 542 | 1 | 2023-11-03 | 316.86 | 7.92 | 2023-10-22 | 2 | 144.59 | 1 | 316.86 | 10 | SO53576 | 2023-10-29 | 25.35 | 289.19 | 158.43 | |||
SO58921_2 | DB78-489E-8E | PO16994165104 | 100 | 283 | 481 | 306 | 3 | 2024-02-02 | 32.36 | 0.81 | 2024-01-21 | 6 | 3.36 | 1 | 32.36 | 2 | SO58921 | 2024-01-28 | 2.59 | 20.17 | 5.39 | |||
SO47976_18 | 1D33-4555-83 | PO18183173367 | 100 | 281 | 421 | 667 | 2 | 2023-01-03 | 588.99 | 14.72 | 2022-12-22 | 3 | 145.28 | 1 | 588.99 | 18 | SO47976 | 2022-12-29 | 47.12 | 435.85 | 196.33 | |||
SO44762_7 | 553E-437E-92 | PO13543176259 | 100 | 287 | 223 | 293 | 1 | 2022-02-02 | 41.49 | 1.04 | 2022-01-21 | 8 | 5.71 | 1 | 41.49 | 7 | SO44762 | 2022-01-28 | 3.32 | 45.64 | 5.19 | |||
SO69522_21 | 28C3-4615-8B | PO4901187436 | 19 | 284 | 487 | 2 | 84 | 6 | 7.02 | 2024-07-03 | 350.84 | 8.60 | 2024-06-21 | 11 | 20.57 | 1 | 343.82 | 21 | SO69522 | 2024-06-28 | 27.51 | 226.23 | 31.89 | 0.02 |
SO69554_1 | 7525-4F6A-93 | PO8584128240 | 98 | 288 | 490 | 592 | 10 | 2024-07-03 | 64.79 | 1.62 | 2024-06-21 | 2 | 41.57 | 1 | 64.79 | 1 | SO69554 | 2024-06-28 | 5.18 | 83.14 | 32.39 | |||
SO69449_14 | 457F-4A9C-96 | PO10266117370 | 6 | 296 | 566 | 393 | 9 | 2024-07-03 | 890.82 | 22.27 | 2024-06-21 | 2 | 461.44 | 1 | 890.82 | 14 | SO69449 | 2024-06-28 | 71.27 | 922.89 | 445.41 | |||
SO44547_13 | 801C-4288-87 | PO4901179982 | 19 | 284 | 253 | 84 | 6 | 2022-01-03 | 357.16 | 8.93 | 2021-12-22 | 2 | 176.20 | 1 | 357.16 | 13 | SO44547 | 2021-12-29 | 28.57 | 352.40 | 178.58 | |||
SO63240_18 | AC0A-4F08-91 | PO4611157476 | 100 | 287 | 579 | 131 | 4 | 2024-04-04 | 1457.82 | 36.45 | 2024-03-23 | 2 | 755.15 | 1 | 1457.82 | 18 | SO63240 | 2024-03-30 | 116.63 | 1510.30 | 728.91 | |||
SO55248_26 | 8E6C-4F5E-92 | PO13775186264 | 100 | 283 | 225 | 618 | 2 | 2023-12-03 | 21.58 | 0.54 | 2023-11-21 | 4 | 6.92 | 1 | 21.58 | 26 | SO55248 | 2023-11-28 | 1.73 | 27.69 | 5.39 | |||
SO47366_49 | DD3E-4DAA-BA | PO17545115575 | 19 | 291 | 377 | 155 | 6 | 2022-11-03 | 7853.63 | 196.34 | 2022-10-22 | 6 | 1320.68 | 1 | 7853.63 | 49 | SO47366 | 2022-10-29 | 628.29 | 7924.10 | 1308.94 | |||
SO53536_48 | 5C09-4051-92 | PO18299189909 | 19 | 291 | 488 | 118 | 6 | 2023-11-03 | 259.15 | 6.48 | 2023-10-22 | 8 | 41.57 | 1 | 259.15 | 48 | SO53536 | 2023-10-29 | 20.73 | 332.58 | 32.39 | |||
SO46968_9 | 280B-4350-80 | PO15254133264 | 100 | 281 | 263 | 377 | 3 | 2022-10-03 | 809.33 | 20.23 | 2022-09-21 | 4 | 187.16 | 1 | 809.33 | 9 | SO46968 | 2022-09-28 | 64.75 | 748.63 | 202.33 | |||
SO46648_8 | 2073-4051-9E | PO2494191557 | 100 | 283 | 236 | 184 | 4 | 2022-09-02 | 230.72 | 5.77 | 2022-08-21 | 8 | 29.08 | 1 | 230.72 | 8 | SO46648 | 2022-08-28 | 18.46 | 232.65 | 28.84 | |||
SO53464_34 | E113-419B-8F | PO17545119283 | 19 | 291 | 390 | 155 | 6 | 2023-11-03 | 672.29 | 16.81 | 2023-10-22 | 1 | 713.08 | 1 | 672.29 | 34 | SO53464 | 2023-10-29 | 53.78 | 713.08 | 672.29 | |||
SO65235_9 | 0A92-4A75-90 | PO10962154595 | 19 | 284 | 589 | 685 | 6 | 2024-05-03 | 1385.08 | 34.63 | 2024-04-21 | 3 | 419.78 | 1 | 1385.08 | 9 | SO65235 | 2024-04-28 | 110.81 | 1259.34 | 461.69 | |||
SO57122_33 | 048F-465A-A8 | PO4901112587 | 19 | 284 | 484 | 84 | 6 | 2024-01-03 | 19.08 | 0.48 | 2023-12-22 | 4 | 2.97 | 1 | 19.08 | 33 | SO57122 | 2023-12-29 | 1.53 | 11.89 | 4.77 | |||
SO47384_33 | 8780-4D54-85 | PO14268113342 | 100 | 283 | 433 | 418 | 3 | 2022-11-03 | 973.36 | 24.33 | 2022-10-22 | 3 | 300.12 | 1 | 973.36 | 33 | SO47384 | 2022-10-29 | 77.87 | 900.36 | 324.45 | |||
SO48080_44 | 4DC7-4772-87 | PO7656157590 | 100 | 282 | 343 | 403 | 4 | 2023-01-03 | 469.79 | 11.74 | 2022-12-22 | 1 | 486.71 | 1 | 469.79 | 44 | SO48080 | 2022-12-29 | 37.58 | 486.71 | 469.79 | |||
SO44298_20 | 960B-4C26-9F | PO11049118093 | 19 | 284 | 272 | 679 | 6 | 2021-12-03 | 183.94 | 4.60 | 2021-11-21 | 1 | 181.49 | 1 | 183.94 | 20 | SO44298 | 2021-11-28 | 14.72 | 181.49 | 183.94 | |||
SO46609_3 | 87E3-4F5C-AC | PO17458117152 | 100 | 286 | 439 | 577 | 1 | 2022-09-02 | 780.82 | 19.52 | 2022-08-21 | 1 | 722.26 | 1 | 780.82 | 3 | SO46609 | 2022-08-28 | 62.47 | 722.26 | 780.82 | |||
SO46959_18 | 9007-4F97-9C | PO16733197949 | 19 | 291 | 325 | 533 | 6 | 2022-10-03 | 1409.38 | 35.23 | 2022-09-21 | 3 | 486.71 | 1 | 1409.38 | 18 | SO46959 | 2022-09-28 | 112.75 | 1460.12 | 469.79 | |||
SO51763_15 | CDB1-4311-8D | PO957124084 | 98 | 288 | 480 | 376 | 10 | 2023-10-03 | 1.37 | 0.03 | 2023-09-21 | 1 | 0.86 | 1 | 1.37 | 15 | SO51763 | 2023-09-28 | 0.11 | 0.86 | 1.37 | |||
SO69508_21 | 387A-4EC2-A7 | PO7627176234 | 100 | 293 | 484 | 433 | 1 | 2024-07-03 | 23.85 | 0.60 | 2024-06-21 | 5 | 2.97 | 1 | 23.85 | 21 | SO69508 | 2024-06-28 | 1.91 | 14.87 | 4.77 | |||
SO47066_19 | 5E42-48DE-80 | PO8816154123 | 100 | 289 | 435 | 218 | 1 | 2022-10-03 | 648.91 | 16.22 | 2022-09-21 | 2 | 300.12 | 1 | 648.91 | 19 | SO47066 | 2022-09-28 | 51.91 | 600.24 | 324.45 | |||
SO71929_1 | 3A89-4B15-B2 | PO6322150008 | 100 | 283 | 547 | 503 | 2 | 2024-08-03 | 48.59 | 1.21 | 2024-07-22 | 1 | 35.96 | 1 | 48.59 | 1 | SO71929 | 2024-07-29 | 3.89 | 35.96 | 48.59 | |||
SO48356_7 | 3E64-467F-90 | PO2697152207 | 100 | 282 | 308 | 187 | 4 | 2023-02-02 | 2232.82 | 55.82 | 2023-01-21 | 3 | 660.91 | 1 | 2232.82 | 7 | SO48356 | 2023-01-28 | 178.63 | 1982.74 | 744.27 | |||
SO59049_3 | 7571-4CB5-B6 | PO174156394 | 100 | 282 | 545 | 277 | 4 | 2024-02-02 | 121.47 | 3.04 | 2024-01-21 | 5 | 17.98 | 1 | 121.47 | 3 | SO59049 | 2024-01-28 | 9.72 | 89.89 | 24.29 |
Generated 2024-09-20 12:28:02.842 UTC