[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE SKIP 2468 < SKIP 1062 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO58914_14 | 8547-437A-B2 | PO17545129441 | 19 | 291 | 436 | 155 | 6 | 2024-02-03 | 356.90 | 8.92 | 2024-01-22 | 1 | 360.94 | 1 | 356.90 | 14 | SO58914 | 2024-01-29 | 28.55 | 360.94 | 356.90 | |||
SO46616_55 | 1264-43E6-B7 | PO14732122562 | 19 | 291 | 239 | 514 | 6 | 2022-09-03 | 2342.45 | 58.56 | 2022-08-22 | 3 | 722.26 | 1 | 2342.45 | 55 | SO46616 | 2022-08-29 | 187.40 | 2166.77 | 780.82 | |||
SO45315_14 | A83F-4F76-BA | PO2146148184 | 19 | 284 | 300 | 354 | 6 | 2022-04-06 | 3239.04 | 80.98 | 2022-03-25 | 4 | 699.09 | 1 | 3239.04 | 14 | SO45315 | 2022-04-01 | 259.12 | 2796.37 | 809.76 | |||
SO48037_11 | D0D4-4B5F-84 | PO1827138439 | 19 | 291 | 466 | 317 | 6 | 2023-01-04 | 14.13 | 0.35 | 2022-12-23 | 1 | 9.71 | 1 | 14.13 | 11 | SO48037 | 2022-12-30 | 1.13 | 9.71 | 14.13 | |||
SO47380_27 | EF71-4036-91 | PO14790123967 | 19 | 291 | 365 | 497 | 6 | 2022-11-04 | 3887.96 | 97.20 | 2022-10-23 | 6 | 598.44 | 1 | 3887.96 | 27 | SO47380 | 2022-10-30 | 311.04 | 3590.61 | 647.99 | |||
SO46940_13 | 6ADC-4363-B3 | PO18705126181 | 19 | 291 | 377 | 479 | 6 | 2022-10-04 | 2617.88 | 65.45 | 2022-09-22 | 2 | 1320.68 | 1 | 2617.88 | 13 | SO46940 | 2022-09-29 | 209.43 | 2641.37 | 1308.94 | |||
SO63239_26 | AF5E-48ED-A4 | PO4901178462 | 19 | 284 | 491 | 84 | 6 | 2024-04-05 | 259.15 | 6.48 | 2024-03-24 | 8 | 41.57 | 1 | 259.15 | 26 | SO63239 | 2024-03-31 | 20.73 | 332.58 | 32.39 | |||
SO47411_21 | 4BDD-4511-AC | PO1798140269 | 19 | 291 | 356 | 10 | 6 | 2022-11-04 | 3728.56 | 93.21 | 2022-10-23 | 3 | 1117.86 | 1 | 3728.56 | 21 | SO47411 | 2022-10-30 | 298.28 | 3353.57 | 1242.85 | |||
SO51116_17 | B371-45B5-B0 | PO10527115387 | 19 | 284 | 482 | 3 | 480 | 6 | 4.45 | 2023-09-03 | 89.00 | 2.11 | 2023-08-22 | 18 | 3.36 | 1 | 84.55 | 17 | SO51116 | 2023-08-29 | 6.76 | 60.52 | 4.94 | 0.05 |
SO69478_9 | E63C-4ABF-83 | PO18705185140 | 19 | 291 | 418 | 479 | 6 | 2024-07-04 | 1070.69 | 26.77 | 2024-06-22 | 3 | 360.94 | 1 | 1070.69 | 9 | SO69478 | 2024-06-29 | 85.66 | 1082.83 | 356.90 | |||
SO63239_9 | AF5E-48ED-A4 | PO4901178462 | 19 | 284 | 477 | 84 | 6 | 2024-04-05 | 17.96 | 0.45 | 2024-03-24 | 6 | 1.87 | 1 | 17.96 | 9 | SO63239 | 2024-03-31 | 1.44 | 11.20 | 2.99 | |||
SO50689_26 | 20BC-4161-86 | PO10614135588 | 19 | 291 | 335 | 461 | 6 | 2023-08-04 | 469.79 | 11.74 | 2023-07-23 | 1 | 486.71 | 1 | 469.79 | 26 | SO50689 | 2023-07-30 | 37.58 | 486.71 | 469.79 | |||
SO65174_40 | E2AA-4EEC-93 | PO17574133893 | 19 | 291 | 306 | 678 | 6 | 2024-05-04 | 2429.28 | 60.73 | 2024-04-22 | 3 | 739.04 | 1 | 2429.28 | 40 | SO65174 | 2024-04-29 | 194.34 | 2217.12 | 809.76 | |||
SO50265_48 | 6C30-435D-9D | PO18705169014 | 19 | 291 | 325 | 479 | 6 | 2023-07-04 | 1879.18 | 46.98 | 2023-06-22 | 4 | 486.71 | 1 | 1879.18 | 48 | SO50265 | 2023-06-29 | 150.33 | 1946.83 | 469.79 | |||
SO57019_5 | D018-44A0-BF | PO18879140423 | 19 | 291 | 575 | 64 | 6 | 2024-01-04 | 2860.88 | 71.52 | 2023-12-23 | 2 | 1481.94 | 1 | 2860.88 | 5 | SO57019 | 2023-12-30 | 228.87 | 2963.88 | 1430.44 | |||
SO51699_13 | 31D5-494C-BA | PO18879118606 | 19 | 291 | 576 | 64 | 6 | 2023-10-04 | 1430.44 | 35.76 | 2023-09-22 | 1 | 1481.94 | 1 | 1430.44 | 13 | SO51699 | 2023-09-29 | 114.44 | 1481.94 | 1430.44 | |||
SO58956_8 | 36A4-4154-AB | PO11194174095 | 19 | 284 | 572 | 48 | 6 | 2024-02-03 | 4454.10 | 111.35 | 2024-01-22 | 10 | 461.44 | 1 | 4454.10 | 8 | SO58956 | 2024-01-29 | 356.33 | 4614.45 | 445.41 | |||
SO47362_5 | 41E3-4BA0-99 | PO17690189228 | 19 | 291 | 356 | 47 | 6 | 2022-11-04 | 2485.70 | 62.14 | 2022-10-23 | 2 | 1117.86 | 1 | 2485.70 | 5 | SO47362 | 2022-10-30 | 198.86 | 2235.71 | 1242.85 | |||
SO69522_1 | 28C3-4615-8B | PO4901187436 | 19 | 284 | 237 | 84 | 6 | 2024-07-04 | 119.98 | 3.00 | 2024-06-22 | 4 | 38.49 | 1 | 119.98 | 1 | SO69522 | 2024-06-29 | 9.60 | 153.97 | 29.99 | |||
SO71853_1 | C03F-40A4-B6 | PO18531164420 | 19 | 284 | 474 | 613 | 6 | 2024-08-04 | 251.96 | 6.30 | 2024-07-23 | 6 | 26.18 | 1 | 251.96 | 1 | SO71853 | 2024-07-30 | 20.16 | 157.06 | 41.99 | |||
SO65235_8 | 0A92-4A75-90 | PO10962154595 | 19 | 284 | 587 | 685 | 6 | 2024-05-04 | 461.69 | 11.54 | 2024-04-22 | 1 | 419.78 | 1 | 461.69 | 8 | SO65235 | 2024-04-29 | 36.94 | 419.78 | 461.69 | |||
SO63127_3 | BC04-42FB-8F | PO19227167253 | 19 | 284 | 605 | 210 | 6 | 2024-04-05 | 647.99 | 16.20 | 2024-03-24 | 2 | 343.65 | 1 | 647.99 | 3 | SO63127 | 2024-03-31 | 51.84 | 687.30 | 323.99 | |||
SO48754_37 | FC6A-4A9E-83 | PO18473150383 | 19 | 291 | 221 | 442 | 6 | 2023-03-06 | 80.75 | 2.02 | 2023-02-22 | 4 | 13.88 | 1 | 80.75 | 37 | SO48754 | 2023-03-01 | 6.46 | 55.51 | 20.19 | |||
SO51793_12 | D763-4929-9B | PO18705168707 | 19 | 291 | 408 | 479 | 6 | 2023-10-04 | 144.32 | 3.61 | 2023-09-22 | 2 | 53.40 | 1 | 144.32 | 12 | SO51793 | 2023-09-29 | 11.55 | 106.80 | 72.16 | |||
SO50284_29 | F8D1-49E1-A5 | PO4901178867 | 19 | 284 | 448 | 84 | 6 | 2023-07-04 | 83.96 | 2.10 | 2023-06-22 | 7 | 8.25 | 1 | 83.96 | 29 | SO50284 | 2023-06-29 | 6.72 | 57.72 | 11.99 | |||
SO55280_6 | B925-404B-8B | PO18444178908 | 19 | 291 | 440 | 227 | 6 | 2023-12-04 | 858.90 | 21.47 | 2023-11-22 | 1 | 868.63 | 1 | 858.90 | 6 | SO55280 | 2023-11-29 | 68.71 | 868.63 | 858.90 | |||
SO47960_8 | 04C4-49AA-9A | PO20039187120 | 19 | 291 | 356 | 65 | 6 | 2023-01-04 | 3728.56 | 93.21 | 2022-12-23 | 3 | 1117.86 | 1 | 3728.56 | 8 | SO47960 | 2022-12-30 | 298.28 | 3353.57 | 1242.85 | |||
SO51850_32 | 57A9-4C32-8B | PO1856170170 | 19 | 291 | 472 | 263 | 6 | 2023-10-04 | 76.20 | 1.91 | 2023-09-22 | 2 | 23.75 | 1 | 76.20 | 32 | SO51850 | 2023-09-29 | 6.10 | 47.50 | 38.10 | |||
SO71851_40 | AABE-4443-91 | PO18299133687 | 19 | 291 | 490 | 118 | 6 | 2024-08-04 | 129.58 | 3.24 | 2024-07-23 | 4 | 41.57 | 1 | 129.58 | 40 | SO71851 | 2024-07-30 | 10.37 | 166.29 | 32.39 | |||
SO71806_19 | 26A7-4E95-9B | PO14790111844 | 19 | 291 | 309 | 497 | 6 | 2024-08-04 | 818.70 | 20.47 | 2024-07-23 | 1 | 747.20 | 1 | 818.70 | 19 | SO71806 | 2024-07-30 | 65.50 | 747.20 | 818.70 | |||
SO47354_13 | 6E1C-48C6-89 | PO19401144959 | 19 | 291 | 369 | 173 | 6 | 2022-11-04 | 4398.03 | 109.95 | 2022-10-23 | 3 | 1518.79 | 1 | 4398.03 | 13 | SO47354 | 2022-10-30 | 351.84 | 4556.36 | 1466.01 |
Generated 2024-09-21 12:50:05.339 UTC