[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SKIP 0 SHUFFLE < SKIP 1111 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO71880_18 | B0C7-4858-91 | PO7395117544 | 100 | 286 | 517 | 542 | 1 | 2024-08-04 | 63.17 | 1.58 | 2024-07-23 | 2 | 23.37 | 1 | 63.17 | 18 | SO71880 | 2024-07-30 | 5.05 | 46.74 | 31.58 | |||
SO43877_3 | 4ECF-42F2-A7 | PO11919119101 | 100 | 286 | 218 | 73 | 1 | 2021-10-04 | 28.50 | 0.71 | 2021-09-22 | 5 | 3.40 | 1 | 28.50 | 3 | SO43877 | 2021-09-29 | 2.28 | 16.98 | 5.70 | |||
SO51821_14 | 1CCD-45D4-80 | PO7917148134 | 100 | 287 | 483 | 401 | 1 | 2023-10-04 | 360.00 | 9.00 | 2023-09-22 | 5 | 44.88 | 1 | 360.00 | 14 | SO51821 | 2023-09-29 | 28.80 | 224.40 | 72.00 | |||
SO58961_39 | 0848-4E9B-81 | PO10411162031 | 100 | 289 | 579 | 182 | 1 | 2024-02-03 | 728.91 | 18.22 | 2024-01-22 | 1 | 755.15 | 1 | 728.91 | 39 | SO58961 | 2024-01-29 | 58.31 | 755.15 | 728.91 | |||
SO69475_41 | F74A-4967-BA | PO18618162557 | 100 | 286 | 490 | 605 | 1 | 2024-07-04 | 64.79 | 1.62 | 2024-06-22 | 2 | 41.57 | 1 | 64.79 | 41 | SO69475 | 2024-06-29 | 5.18 | 83.14 | 32.39 | |||
SO50209_20 | D138-4E7C-86 | PO15573136083 | 100 | 293 | 428 | 487 | 1 | 2023-07-04 | 837.02 | 20.93 | 2023-06-22 | 4 | 185.82 | 1 | 837.02 | 20 | SO50209 | 2023-06-29 | 66.96 | 743.28 | 209.26 | |||
SO57046_45 | 52CC-460F-B3 | PO14500161818 | 100 | 282 | 544 | 650 | 1 | 2024-01-04 | 291.56 | 7.29 | 2023-12-23 | 6 | 35.96 | 1 | 291.56 | 45 | SO57046 | 2023-12-30 | 23.33 | 215.76 | 48.59 | |||
SO69413_25 | E8F8-4282-9E | PO15631191114 | 100 | 282 | 400 | 43 | 1 | 2024-07-04 | 74.30 | 1.86 | 2024-06-22 | 2 | 27.49 | 1 | 74.30 | 25 | SO69413 | 2024-06-29 | 5.94 | 54.99 | 37.15 | |||
SO43869_2 | 96FA-4DF1-81 | PO14500145975 | 100 | 282 | 348 | 650 | 1 | 2021-10-04 | 10124.97 | 253.12 | 2021-09-22 | 5 | 1898.09 | 1 | 10124.97 | 2 | SO43869 | 2021-09-29 | 810.00 | 9490.47 | 2024.99 | |||
SO65252_18 | F817-49F6-A9 | PO12470159616 | 100 | 287 | 574 | 672 | 1 | 2024-05-04 | 1430.44 | 35.76 | 2024-04-22 | 1 | 1481.94 | 1 | 1430.44 | 18 | SO65252 | 2024-04-29 | 114.44 | 1481.94 | 1430.44 | |||
SO50210_5 | 6347-4C03-9B | PO15631112842 | 100 | 282 | 399 | 43 | 1 | 2023-07-04 | 67.55 | 1.69 | 2023-06-22 | 2 | 24.99 | 1 | 67.55 | 5 | SO50210 | 2023-06-29 | 5.40 | 49.99 | 33.77 | |||
SO51726_12 | 9BC5-4281-AF | PO14587157005 | 100 | 293 | 502 | 199 | 1 | 2023-10-04 | 800.21 | 20.01 | 2023-09-22 | 4 | 199.85 | 1 | 800.21 | 12 | SO51726 | 2023-09-29 | 64.02 | 799.41 | 200.05 | |||
SO63143_1 | BE9C-4497-AB | PO16878197422 | 100 | 282 | 475 | 115 | 1 | 2024-04-05 | 41.99 | 1.05 | 2024-03-24 | 1 | 26.18 | 1 | 41.99 | 1 | SO63143 | 2024-03-31 | 3.36 | 26.18 | 41.99 | |||
SO51789_45 | A5AF-4504-83 | PO18618169495 | 100 | 286 | 495 | 605 | 1 | 2023-10-04 | 602.35 | 15.06 | 2023-09-22 | 1 | 601.74 | 1 | 602.35 | 45 | SO51789 | 2023-09-29 | 48.19 | 601.74 | 602.35 | |||
SO50218_27 | B8E9-4FE2-8B | PO14442144367 | 100 | 293 | 216 | 2 | 127 | 1 | 5.46 | 2023-07-04 | 273.19 | 6.69 | 2023-06-22 | 14 | 13.88 | 1 | 267.73 | 27 | SO50218 | 2023-06-29 | 21.42 | 194.29 | 19.51 | 0.02 |
SO49548_1 | 0BD9-4A6D-8E | PO8903146134 | 100 | 293 | 329 | 235 | 1 | 2023-05-04 | 469.79 | 11.74 | 2023-04-22 | 1 | 486.71 | 1 | 469.79 | 1 | SO49548 | 2023-04-29 | 37.58 | 486.71 | 469.79 | |||
SO67294_1 | 85E2-46A1-BE | PO899165491 | 100 | 289 | 384 | 290 | 1 | 2024-06-04 | 2689.18 | 67.23 | 2024-05-23 | 4 | 713.08 | 1 | 2689.18 | 1 | SO67294 | 2024-05-30 | 215.13 | 2852.32 | 672.29 | |||
SO48057_31 | 53D7-4BA4-AB | PO4727174880 | 100 | 293 | 383 | 343 | 1 | 2023-01-04 | 4201.84 | 105.05 | 2022-12-23 | 7 | 605.65 | 1 | 4201.84 | 31 | SO48057 | 2022-12-30 | 336.15 | 4239.54 | 600.26 | |||
SO47992_28 | 3F55-4354-BD | PO15573158216 | 100 | 293 | 470 | 487 | 1 | 2023-01-04 | 136.76 | 3.42 | 2022-12-23 | 6 | 15.67 | 1 | 136.76 | 28 | SO47992 | 2022-12-30 | 10.94 | 94.03 | 22.79 | |||
SO48328_5 | 5992-4AF8-B1 | PO13543152596 | 100 | 287 | 395 | 293 | 1 | 2023-02-03 | 306.87 | 7.67 | 2023-01-22 | 5 | 45.42 | 1 | 306.87 | 5 | SO48328 | 2023-01-29 | 24.55 | 227.08 | 61.37 | |||
SO55299_6 | 0B56-423B-B7 | PO6612171212 | 100 | 286 | 571 | 110 | 1 | 2023-12-04 | 1781.64 | 44.54 | 2023-11-22 | 4 | 461.44 | 1 | 1781.64 | 6 | SO55299 | 2023-11-29 | 142.53 | 1845.78 | 445.41 | |||
SO47671_1 | 66D0-4A01-87 | PO14094155244 | 100 | 272 | 221 | 253 | 1 | 2022-12-04 | 40.37 | 1.01 | 2022-11-22 | 2 | 13.88 | 1 | 40.37 | 1 | SO47671 | 2022-11-29 | 3.23 | 27.76 | 20.19 | |||
SO51123_35 | E412-45DF-AE | PO899150137 | 100 | 289 | 490 | 2 | 290 | 1 | 8.14 | 2023-09-03 | 407.08 | 9.97 | 2023-08-22 | 13 | 41.57 | 1 | 398.94 | 35 | SO51123 | 2023-08-29 | 31.92 | 540.44 | 31.31 | 0.02 |
SO46667_4 | D3CD-4A6E-94 | PO7105131549 | 100 | 286 | 422 | 668 | 1 | 2022-09-03 | 405.23 | 10.13 | 2022-08-22 | 6 | 49.98 | 1 | 405.23 | 4 | SO46667 | 2022-08-29 | 32.42 | 299.87 | 67.54 | |||
SO47999_6 | DF06-4F6A-9D | PO14500121568 | 100 | 282 | 421 | 650 | 1 | 2023-01-04 | 392.66 | 9.82 | 2022-12-23 | 2 | 145.28 | 1 | 392.66 | 6 | SO47999 | 2022-12-30 | 31.41 | 290.57 | 196.33 | |||
SO57136_33 | 0031-4C10-84 | PO7627163680 | 100 | 272 | 584 | 433 | 1 | 2024-01-04 | 1943.96 | 48.60 | 2023-12-23 | 6 | 343.65 | 1 | 1943.96 | 33 | SO57136 | 2023-12-30 | 155.52 | 2061.90 | 323.99 | |||
SO45296_1 | 1FA6-4616-B7 | PO14471199142 | 100 | 286 | 220 | 145 | 1 | 2022-04-06 | 60.56 | 1.51 | 2022-03-25 | 3 | 12.03 | 1 | 60.56 | 1 | SO45296 | 2022-04-01 | 4.84 | 36.08 | 20.19 | |||
SO43849_8 | D0B8-4476-BA | PO18676186169 | 100 | 272 | 345 | 697 | 1 | 2021-10-04 | 2039.99 | 51.00 | 2021-09-22 | 1 | 1912.15 | 1 | 2039.99 | 8 | SO43849 | 2021-09-29 | 163.20 | 1912.15 | 2039.99 | |||
SO57026_17 | CD5A-4300-81 | PO16675118038 | 100 | 293 | 568 | 361 | 1 | 2024-01-04 | 445.41 | 11.14 | 2023-12-23 | 1 | 461.44 | 1 | 445.41 | 17 | SO57026 | 2023-12-30 | 35.63 | 461.44 | 445.41 | |||
SO50669_10 | CEEB-4329-BA | PO17487120000 | 100 | 293 | 333 | 692 | 1 | 2023-08-04 | 469.79 | 11.74 | 2023-07-23 | 1 | 486.71 | 1 | 469.79 | 10 | SO50669 | 2023-07-30 | 37.58 | 486.71 | 469.79 |
Generated 2024-09-21 05:29:57.268 UTC