[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SKIP 0 SHUFFLE < SKIP 1266 > < TAKE 28 >
28 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO43886_19 | CE58-49B5-82 | PO1827149671 | 19 | 288 | 326 | 317 | 6 | 2021-10-03 | 1258.38 | 31.46 | 2021-09-21 | 3 | 413.15 | 1 | 1258.38 | 19 | SO43886 | 2021-09-28 | 100.67 | 1239.44 | 419.46 | |||
SO69401_3 | 5377-4B5B-80 | PO17603155358 | 19 | 284 | 545 | 12 | 6 | 2024-07-03 | 145.76 | 3.64 | 2024-06-21 | 6 | 17.98 | 1 | 145.76 | 3 | SO69401 | 2024-06-28 | 11.66 | 107.87 | 24.29 | |||
SO50684_3 | 74E9-4949-91 | PO11165153787 | 19 | 291 | 470 | 586 | 6 | 2023-08-03 | 205.15 | 5.13 | 2023-07-22 | 9 | 15.67 | 1 | 205.15 | 3 | SO50684 | 2023-07-29 | 16.41 | 141.04 | 22.79 | |||
SO47973_6 | B9F1-47DA-87 | PO18705118148 | 19 | 291 | 339 | 479 | 6 | 2023-01-03 | 1409.38 | 35.23 | 2022-12-22 | 3 | 486.71 | 1 | 1409.38 | 6 | SO47973 | 2022-12-29 | 112.75 | 1460.12 | 469.79 | |||
SO49848_26 | 31E6-4A3B-9C | PO1711148241 | 19 | 291 | 470 | 2 | 245 | 6 | 6.17 | 2023-06-03 | 308.48 | 7.56 | 2023-05-22 | 14 | 15.67 | 1 | 302.31 | 26 | SO49848 | 2023-05-29 | 24.18 | 219.39 | 22.03 | 0.02 |
SO71847_8 | 3A74-467E-8B | PO18502143784 | 19 | 291 | 574 | 154 | 6 | 2024-08-03 | 5721.77 | 143.04 | 2024-07-22 | 4 | 1481.94 | 1 | 5721.77 | 8 | SO71847 | 2024-07-29 | 457.74 | 5927.75 | 1430.44 | |||
SO45278_11 | 7EE7-4F70-81 | PO18415191281 | 19 | 288 | 317 | 191 | 6 | 2022-04-05 | 4373.97 | 109.35 | 2022-03-24 | 5 | 884.71 | 1 | 4373.97 | 11 | SO45278 | 2022-03-31 | 349.92 | 4423.54 | 874.79 | |||
SO49501_25 | EF67-4713-BD | PO17574111786 | 19 | 291 | 294 | 678 | 6 | 2023-05-03 | 2232.82 | 55.82 | 2023-04-21 | 3 | 660.91 | 1 | 2232.82 | 25 | SO49501 | 2023-04-28 | 178.63 | 1982.74 | 744.27 | |||
SO45800_2 | 5B67-4FE2-B9 | PO10527156525 | 19 | 284 | 315 | 480 | 6 | 2022-06-03 | 3499.18 | 87.48 | 2022-05-22 | 4 | 884.71 | 1 | 3499.18 | 2 | SO45800 | 2022-05-29 | 279.93 | 3538.83 | 874.79 | |||
SO48750_37 | 9A71-449E-B6 | PO14732147398 | 19 | 291 | 435 | 514 | 6 | 2023-03-05 | 1297.81 | 32.45 | 2023-02-21 | 4 | 300.12 | 1 | 1297.81 | 37 | SO48750 | 2023-02-28 | 103.82 | 1200.48 | 324.45 | |||
SO50261_3 | 6142-4396-B8 | PO20039145643 | 19 | 291 | 358 | 65 | 6 | 2023-07-03 | 3688.38 | 92.21 | 2023-06-21 | 3 | 1105.81 | 1 | 3688.38 | 3 | SO50261 | 2023-06-28 | 295.07 | 3317.43 | 1229.46 | |||
SO59037_6 | 6750-45BB-93 | PO2233187258 | 19 | 291 | 477 | 262 | 6 | 2024-02-02 | 5.99 | 0.15 | 2024-01-21 | 2 | 1.87 | 1 | 5.99 | 6 | SO59037 | 2024-01-28 | 0.48 | 3.73 | 2.99 | |||
SO49855_32 | 0C94-4D84-A4 | PO18473166459 | 19 | 291 | 354 | 442 | 6 | 2023-06-03 | 3728.56 | 93.21 | 2023-05-22 | 3 | 1117.86 | 1 | 3728.56 | 32 | SO49855 | 2023-05-29 | 298.28 | 3353.57 | 1242.85 | |||
SO46959_33 | 9007-4F97-9C | PO16733197949 | 19 | 291 | 458 | 533 | 6 | 2022-10-03 | 89.99 | 2.25 | 2022-09-21 | 2 | 30.93 | 1 | 89.99 | 33 | SO46959 | 2022-09-28 | 7.20 | 61.87 | 44.99 | |||
SO47401_1 | A6AE-4ECA-BB | PO493192090 | 19 | 272 | 339 | 654 | 6 | 2022-11-03 | 469.79 | 11.74 | 2022-10-22 | 1 | 486.71 | 1 | 469.79 | 1 | SO47401 | 2022-10-29 | 37.58 | 486.71 | 469.79 | |||
SO47690_4 | B248-4AA7-92 | PO10527158850 | 19 | 284 | 343 | 480 | 6 | 2022-12-03 | 469.79 | 11.74 | 2022-11-21 | 1 | 486.71 | 1 | 469.79 | 4 | SO47690 | 2022-11-28 | 37.58 | 486.71 | 469.79 | |||
SO44086_19 | B4B4-44C7-84 | PO17574175064 | 19 | 288 | 235 | 678 | 6 | 2021-11-03 | 86.52 | 2.16 | 2021-10-22 | 3 | 31.72 | 1 | 86.52 | 19 | SO44086 | 2021-10-29 | 6.92 | 95.17 | 28.84 | |||
SO51100_21 | A159-4950-A0 | PO13862191766 | 19 | 291 | 511 | 119 | 6 | 2023-09-02 | 873.82 | 21.85 | 2023-08-21 | 4 | 199.38 | 1 | 873.82 | 21 | SO51100 | 2023-08-28 | 69.91 | 797.50 | 218.45 | |||
SO45780_15 | 1E49-4721-BA | PO18473162015 | 19 | 288 | 288 | 442 | 6 | 2022-06-03 | 722.59 | 18.06 | 2022-05-22 | 1 | 623.84 | 1 | 722.59 | 15 | SO45780 | 2022-05-29 | 57.81 | 623.84 | 722.59 | |||
SO47015_17 | 853D-4913-A7 | PO2117171072 | 19 | 284 | 410 | 444 | 6 | 2022-10-03 | 109.34 | 2.73 | 2022-09-21 | 3 | 26.97 | 1 | 109.34 | 17 | SO47015 | 2022-09-28 | 8.75 | 80.91 | 36.45 | |||
SO53484_25 | CEC0-499D-80 | PO14790120337 | 19 | 291 | 598 | 497 | 6 | 2023-11-03 | 971.98 | 24.30 | 2023-10-22 | 3 | 294.58 | 1 | 971.98 | 25 | SO53484 | 2023-10-29 | 77.76 | 883.74 | 323.99 | |||
SO61204_26 | E810-4164-82 | PO15312134209 | 19 | 291 | 374 | 299 | 6 | 2024-03-04 | 1466.01 | 36.65 | 2024-02-21 | 1 | 1554.95 | 1 | 1466.01 | 26 | SO61204 | 2024-02-28 | 117.28 | 1554.95 | 1466.01 | |||
SO58932_23 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 467 | 408 | 6 | 2024-02-02 | 29.39 | 0.73 | 2024-01-21 | 2 | 9.16 | 1 | 29.39 | 23 | SO58932 | 2024-01-28 | 2.35 | 18.32 | 14.69 | |||
SO53542_3 | D309-4C20-A5 | PO18531154951 | 19 | 284 | 475 | 613 | 6 | 2023-11-03 | 335.95 | 8.40 | 2023-10-22 | 8 | 26.18 | 1 | 335.95 | 3 | SO53542 | 2023-10-29 | 26.88 | 209.41 | 41.99 | |||
SO44773_6 | D4D3-4657-AC | PO1740125070 | 19 | 288 | 338 | 460 | 6 | 2022-02-02 | 419.46 | 10.49 | 2022-01-21 | 1 | 413.15 | 1 | 419.46 | 6 | SO44773 | 2022-01-28 | 33.56 | 413.15 | 419.46 | |||
SO50699_13 | FEA0-4613-AE | PO1885169186 | 19 | 284 | 470 | 2 | 588 | 6 | 5.29 | 2023-08-03 | 264.41 | 6.48 | 2023-07-22 | 12 | 15.67 | 1 | 259.12 | 13 | SO50699 | 2023-07-29 | 20.73 | 188.05 | 22.03 | 0.02 |
SO47008_3 | FD36-4D89-AB | PO1595170889 | 19 | 284 | 385 | 426 | 6 | 2022-10-03 | 1200.53 | 30.01 | 2022-09-21 | 2 | 605.65 | 1 | 1200.53 | 3 | SO47008 | 2022-09-28 | 96.04 | 1211.30 | 600.26 | |||
SO49513_11 | 1A8D-4D25-AE | PO10962181499 | 19 | 284 | 469 | 685 | 6 | 2023-05-03 | 68.38 | 1.71 | 2023-04-21 | 3 | 15.67 | 1 | 68.38 | 11 | SO49513 | 2023-04-28 | 5.47 | 47.01 | 22.79 |
Generated 2024-09-20 08:46:19.550 UTC