[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 969 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO65160_17 | 9375-44FE-94 | PO19343172976 | 100 | 282 | 463 | 24 | 4 | 2024-06-23 | 44.08 | 1.10 | 2024-06-11 | 3 | 9.16 | 1 | 44.08 | 17 | SO65160 | 2024-06-18 | 3.53 | 27.48 | 14.69 | |||
SO69514_1 | 587C-4C47-B9 | PO4553146799 | 100 | 282 | 605 | 313 | 4 | 2024-08-23 | 323.99 | 8.10 | 2024-08-11 | 1 | 343.65 | 1 | 323.99 | 1 | SO69514 | 2024-08-18 | 25.92 | 343.65 | 323.99 | |||
SO45571_4 | BAA6-412D-87 | PO7569141774 | 100 | 287 | 292 | 608 | 4 | 2022-06-23 | 2456.10 | 61.40 | 2022-06-11 | 3 | 706.81 | 1 | 2456.10 | 4 | SO45571 | 2022-06-18 | 196.49 | 2120.43 | 818.70 | |||
SO65291_1 | 2AB3-4C43-94 | PO725188489 | 100 | 281 | 353 | 291 | 4 | 2024-06-23 | 2783.99 | 69.60 | 2024-06-11 | 2 | 1265.62 | 1 | 2783.99 | 1 | SO65291 | 2024-06-18 | 222.72 | 2531.24 | 1391.99 | |||
SO59027_26 | C142-4AAA-AB | PO6757122081 | 100 | 281 | 355 | 21 | 4 | 2024-03-24 | 4175.98 | 104.40 | 2024-03-12 | 3 | 1265.62 | 1 | 4175.98 | 26 | SO59027 | 2024-03-19 | 334.08 | 3796.86 | 1391.99 | |||
SO50292_24 | E329-4164-85 | PO3654177485 | 100 | 281 | 289 | 435 | 4 | 2023-08-23 | 2232.82 | 55.82 | 2023-08-11 | 3 | 660.91 | 1 | 2232.82 | 24 | SO50292 | 2023-08-18 | 178.63 | 1982.74 | 744.27 | |||
SO67287_38 | 3F1F-44DB-96 | PO10730119334 | 100 | 287 | 583 | 491 | 4 | 2024-07-24 | 5102.97 | 127.57 | 2024-07-12 | 5 | 1082.51 | 1 | 5102.97 | 38 | SO67287 | 2024-07-19 | 408.24 | 5412.55 | 1020.59 | |||
SO65184_6 | B75D-4335-96 | PO16153178099 | 100 | 282 | 568 | 186 | 4 | 2024-06-23 | 445.41 | 11.14 | 2024-06-11 | 1 | 461.44 | 1 | 445.41 | 6 | SO65184 | 2024-06-18 | 35.63 | 461.44 | 445.41 | |||
SO67305_18 | CBB5-42BF-9E | PO16298111473 | 100 | 287 | 471 | 599 | 4 | 2024-07-24 | 114.30 | 2.86 | 2024-07-12 | 3 | 23.75 | 1 | 114.30 | 18 | SO67305 | 2024-07-19 | 9.14 | 71.25 | 38.10 | |||
SO45321_11 | C4E4-4F04-B1 | PO3799119166 | 100 | 282 | 218 | 3 | 312 | 4 | 4.96 | 2022-05-26 | 99.28 | 2.36 | 2022-05-14 | 19 | 3.40 | 1 | 94.31 | 11 | SO45321 | 2022-05-21 | 7.54 | 64.53 | 5.23 | 0.05 |
SO48769_29 | A39E-4380-A6 | PO7859190388 | 100 | 287 | 286 | 221 | 4 | 2023-04-25 | 551.81 | 13.80 | 2023-04-13 | 3 | 170.14 | 1 | 551.81 | 29 | SO48769 | 2023-04-20 | 44.15 | 510.43 | 183.94 | |||
SO47984_2 | 57E5-4CB3-B1 | PO16762171139 | 100 | 282 | 325 | 259 | 4 | 2023-02-23 | 1409.38 | 35.23 | 2023-02-11 | 3 | 486.71 | 1 | 1409.38 | 2 | SO47984 | 2023-02-18 | 112.75 | 1460.12 | 469.79 | |||
SO51808_1 | 92BB-45C4-89 | PO7540152834 | 100 | 281 | 579 | 607 | 4 | 2023-11-23 | 728.91 | 18.22 | 2023-11-11 | 1 | 755.15 | 1 | 728.91 | 1 | SO51808 | 2023-11-18 | 58.31 | 755.15 | 728.91 | |||
SO50272_2 | E0A6-4CFA-90 | PO11745174916 | 100 | 282 | 385 | 97 | 4 | 2023-08-23 | 1800.79 | 45.02 | 2023-08-11 | 3 | 605.65 | 1 | 1800.79 | 2 | SO50272 | 2023-08-18 | 144.06 | 1816.95 | 600.26 | |||
SO48397_15 | A1DC-424B-A8 | PO9686169278 | 100 | 282 | 397 | 457 | 4 | 2023-03-25 | 24.29 | 0.61 | 2023-03-13 | 1 | 17.98 | 1 | 24.29 | 15 | SO48397 | 2023-03-20 | 1.94 | 17.98 | 24.29 | |||
SO53580_29 | FFE9-4F36-B2 | PO4640164085 | 100 | 287 | 516 | 648 | 4 | 2023-12-24 | 70.45 | 1.76 | 2023-12-12 | 3 | 17.38 | 1 | 70.45 | 29 | SO53580 | 2023-12-19 | 5.64 | 52.13 | 23.48 | |||
SO49841_3 | 35A1-40DC-99 | PO10817181706 | 100 | 287 | 216 | 203 | 4 | 2023-07-24 | 80.75 | 2.02 | 2023-07-12 | 4 | 13.88 | 1 | 80.75 | 3 | SO49841 | 2023-07-19 | 6.46 | 55.51 | 20.19 | |||
SO55282_11 | A72A-4D3A-BA | PO16298125578 | 100 | 287 | 483 | 599 | 4 | 2024-01-23 | 720.00 | 18.00 | 2024-01-11 | 10 | 44.88 | 1 | 720.00 | 11 | SO55282 | 2024-01-18 | 57.60 | 448.80 | 72.00 | |||
SO63252_25 | 4233-41A9-B7 | PO6438150148 | 100 | 281 | 476 | 309 | 4 | 2024-05-25 | 167.98 | 4.20 | 2024-05-13 | 4 | 26.18 | 1 | 167.98 | 25 | SO63252 | 2024-05-20 | 13.44 | 104.71 | 41.99 | |||
SO49523_30 | 852E-47A8-A9 | PO3915144057 | 100 | 281 | 286 | 130 | 4 | 2023-06-23 | 735.75 | 18.39 | 2023-06-11 | 4 | 170.14 | 1 | 735.75 | 30 | SO49523 | 2023-06-18 | 58.86 | 680.57 | 183.94 | |||
SO44566_9 | 482A-4537-98 | PO7830134580 | 100 | 283 | 350 | 40 | 4 | 2022-02-23 | 4049.99 | 101.25 | 2022-02-11 | 2 | 1898.09 | 1 | 4049.99 | 9 | SO44566 | 2022-02-18 | 324.00 | 3796.19 | 2024.99 | |||
SO50310_3 | FCBD-48EE-A9 | PO6438126969 | 100 | 281 | 428 | 309 | 4 | 2023-08-23 | 1464.79 | 36.62 | 2023-08-11 | 7 | 185.82 | 1 | 1464.79 | 3 | SO50310 | 2023-08-18 | 117.18 | 1300.74 | 209.26 | |||
SO48043_31 | BA6F-4F1F-B7 | PO2523167437 | 100 | 287 | 335 | 167 | 4 | 2023-02-23 | 1879.18 | 46.98 | 2023-02-11 | 4 | 486.71 | 1 | 1879.18 | 31 | SO48043 | 2023-02-18 | 150.33 | 1946.83 | 469.79 | |||
SO51844_9 | DE76-4481-AA | PO4553182082 | 100 | 282 | 471 | 313 | 4 | 2023-11-23 | 114.30 | 2.86 | 2023-11-11 | 3 | 23.75 | 1 | 114.30 | 9 | SO51844 | 2023-11-18 | 9.14 | 71.25 | 38.10 | |||
SO61184_16 | F33C-4C57-BD | PO16298116527 | 100 | 287 | 477 | 599 | 4 | 2024-04-24 | 14.97 | 0.37 | 2024-04-12 | 5 | 1.87 | 1 | 14.97 | 16 | SO61184 | 2024-04-19 | 1.20 | 9.33 | 2.99 | |||
SO50748_41 | 5FBE-4B52-B2 | PO6786143310 | 100 | 281 | 368 | 3 | 4 | 2023-09-23 | 2932.02 | 73.30 | 2023-09-11 | 2 | 1518.79 | 1 | 2932.02 | 41 | SO50748 | 2023-09-18 | 234.56 | 3037.57 | 1466.01 | |||
SO48069_39 | 60CF-43B6-82 | PO6438117188 | 100 | 283 | 230 | 309 | 4 | 2023-02-23 | 115.36 | 2.88 | 2023-02-11 | 4 | 29.08 | 1 | 115.36 | 39 | SO48069 | 2023-02-18 | 9.23 | 116.32 | 28.84 | |||
SO46048_6 | DDA0-4A8A-9C | PO16037150345 | 100 | 282 | 218 | 384 | 4 | 2022-08-23 | 17.10 | 0.43 | 2022-08-11 | 3 | 3.40 | 1 | 17.10 | 6 | SO46048 | 2022-08-18 | 1.37 | 10.19 | 5.70 | |||
SO48043_42 | BA6F-4F1F-B7 | PO2523167437 | 100 | 287 | 341 | 167 | 4 | 2023-02-23 | 1409.38 | 35.23 | 2023-02-11 | 3 | 486.71 | 1 | 1409.38 | 42 | SO48043 | 2023-02-18 | 112.75 | 1460.12 | 469.79 | |||
SO67325_25 | 981F-41CE-8A | PO7859144943 | 100 | 287 | 382 | 221 | 4 | 2024-07-24 | 1344.59 | 33.61 | 2024-07-12 | 2 | 713.08 | 1 | 1344.59 | 25 | SO67325 | 2024-07-19 | 107.57 | 1426.16 | 672.29 |
Generated 2024-11-10 13:09:54.099 UTC