[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '7' > SHUFFLE < SKIP 217 > < TAKE 24 >
24 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO69415_16 | 3D39-4844-B5 | PO15080175978 | 100 | 292 | 561 | 283 | 7 | 2024-07-03 | 4291.33 | 107.28 | 2024-06-21 | 3 | 1481.94 | 1 | 4291.33 | 16 | SO69415 | 2024-06-28 | 343.31 | 4445.81 | 1430.44 | |||
SO47377_5 | FA63-499A-AB | PO15515156459 | 100 | 292 | 422 | 481 | 7 | 2022-11-03 | 202.62 | 5.07 | 2022-10-22 | 3 | 49.98 | 1 | 202.62 | 5 | SO47377 | 2022-10-29 | 16.21 | 149.94 | 67.54 | |||
SO58968_3 | 6168-427B-B5 | PO1305182599 | 100 | 290 | 576 | 319 | 7 | 2024-02-02 | 1430.44 | 35.76 | 2024-01-21 | 1 | 1481.94 | 1 | 1430.44 | 3 | SO58968 | 2024-01-28 | 114.44 | 1481.94 | 1430.44 | |||
SO67276_30 | 9FD9-4B05-AA | PO13340158801 | 100 | 292 | 588 | 355 | 7 | 2024-06-03 | 923.39 | 23.08 | 2024-05-22 | 2 | 419.78 | 1 | 923.39 | 30 | SO67276 | 2024-05-29 | 73.87 | 839.56 | 461.69 | |||
SO69426_33 | 4194-45D7-B6 | PO13427130433 | 100 | 292 | 408 | 638 | 7 | 2024-07-03 | 288.65 | 7.22 | 2024-06-21 | 4 | 53.40 | 1 | 288.65 | 33 | SO69426 | 2024-06-28 | 23.09 | 213.60 | 72.16 | |||
SO51857_19 | 918B-493C-BA | PO3683131763 | 100 | 292 | 562 | 14 | 85 | 7 | 1335.08 | 2023-10-03 | 6675.40 | 133.51 | 2023-09-21 | 7 | 1481.94 | 1 | 5340.32 | 19 | SO51857 | 2023-09-28 | 427.23 | 10373.57 | 953.63 | 0.20 |
SO57061_41 | C48C-4776-A7 | PO12702183787 | 100 | 292 | 359 | 175 | 7 | 2024-01-03 | 13769.94 | 344.25 | 2023-12-22 | 10 | 1251.98 | 1 | 13769.94 | 41 | SO57061 | 2023-12-29 | 1101.60 | 12519.81 | 1376.99 | |||
SO50222_27 | 4FDE-4C03-A9 | PO13427181046 | 100 | 292 | 445 | 638 | 7 | 2023-07-03 | 71.99 | 1.80 | 2023-06-21 | 2 | 24.75 | 1 | 71.99 | 27 | SO50222 | 2023-06-28 | 5.76 | 49.49 | 35.99 | |||
SO58927_36 | BEF7-43AF-A2 | PO15515112432 | 100 | 292 | 487 | 481 | 7 | 2024-02-02 | 230.96 | 5.77 | 2024-01-21 | 7 | 20.57 | 1 | 230.96 | 36 | SO58927 | 2024-01-28 | 18.48 | 143.96 | 32.99 | |||
SO53525_18 | F162-4A87-B4 | PO1305155715 | 100 | 292 | 471 | 319 | 7 | 2023-11-03 | 342.90 | 8.57 | 2023-10-22 | 9 | 23.75 | 1 | 342.90 | 18 | SO53525 | 2023-10-29 | 27.43 | 213.74 | 38.10 | |||
SO57055_18 | 3CBC-4CD2-B1 | PO13369127604 | 100 | 292 | 388 | 391 | 7 | 2024-01-03 | 1344.59 | 33.61 | 2023-12-22 | 2 | 713.08 | 1 | 1344.59 | 18 | SO57055 | 2023-12-29 | 107.57 | 1426.16 | 672.29 | |||
SO69433_22 | C243-44BD-B7 | PO13456135245 | 36 | 292 | 493 | 614 | 7 | 2024-07-03 | 1200.31 | 30.01 | 2024-06-21 | 6 | 199.85 | 1 | 1200.31 | 22 | SO69433 | 2024-06-28 | 96.03 | 1199.11 | 200.05 | |||
SO69531_31 | 1871-4E54-BE | PO3683141039 | 100 | 292 | 563 | 85 | 7 | 2024-07-03 | 11443.54 | 286.09 | 2024-06-21 | 8 | 1481.94 | 1 | 11443.54 | 31 | SO69531 | 2024-06-28 | 915.48 | 11855.50 | 1430.44 | |||
SO48763_10 | 06A5-45C0-A2 | PO3509163189 | 36 | 292 | 230 | 139 | 7 | 2023-03-05 | 144.20 | 3.61 | 2023-02-21 | 5 | 29.08 | 1 | 144.20 | 10 | SO48763 | 2023-02-28 | 11.54 | 145.40 | 28.84 | |||
SO69535_22 | 0821-419A-83 | PO3567173828 | 100 | 292 | 494 | 193 | 7 | 2024-07-03 | 2409.38 | 60.23 | 2024-06-21 | 4 | 601.74 | 1 | 2409.38 | 22 | SO69535 | 2024-06-28 | 192.75 | 2406.97 | 602.35 | |||
SO57055_13 | 3CBC-4CD2-B1 | PO13369127604 | 100 | 292 | 604 | 391 | 7 | 2024-01-03 | 647.99 | 16.20 | 2023-12-22 | 2 | 343.65 | 1 | 647.99 | 13 | SO57055 | 2023-12-29 | 51.84 | 687.30 | 323.99 | |||
SO47377_1 | FA63-499A-AB | PO15515156459 | 100 | 292 | 429 | 481 | 7 | 2022-11-03 | 324.45 | 8.11 | 2022-10-22 | 1 | 300.12 | 1 | 324.45 | 1 | SO47377 | 2022-10-29 | 25.96 | 300.12 | 324.45 | |||
SO65208_1 | EC05-4765-B6 | PO1450163231 | 100 | 292 | 361 | 571 | 7 | 2024-05-03 | 1376.99 | 34.42 | 2024-04-21 | 1 | 1251.98 | 1 | 1376.99 | 1 | SO65208 | 2024-04-28 | 110.16 | 1251.98 | 1376.99 | |||
SO69415_13 | 3D39-4844-B5 | PO15080175978 | 100 | 292 | 552 | 283 | 7 | 2024-07-03 | 54.89 | 1.37 | 2024-06-21 | 1 | 40.62 | 1 | 54.89 | 13 | SO69415 | 2024-06-28 | 4.39 | 40.62 | 54.89 | |||
SO63179_26 | F2C5-4376-B7 | PO2668147145 | 100 | 292 | 517 | 535 | 7 | 2024-04-04 | 157.92 | 3.95 | 2024-03-23 | 5 | 23.37 | 1 | 157.92 | 26 | SO63179 | 2024-03-30 | 12.63 | 116.86 | 31.58 | |||
SO50222_19 | 4FDE-4C03-A9 | PO13427181046 | 100 | 292 | 422 | 638 | 7 | 2023-07-03 | 270.16 | 6.75 | 2023-06-21 | 4 | 49.98 | 1 | 270.16 | 19 | SO50222 | 2023-06-28 | 21.61 | 199.92 | 67.54 | |||
SO65213_3 | 67DD-478F-BE | PO15486173227 | 100 | 292 | 524 | 121 | 7 | 2024-05-03 | 158.43 | 3.96 | 2024-04-21 | 1 | 144.59 | 1 | 158.43 | 3 | SO65213 | 2024-04-28 | 12.67 | 144.59 | 158.43 | |||
SO57061_2 | C48C-4776-A7 | PO12702183787 | 100 | 292 | 594 | 175 | 7 | 2024-01-03 | 1694.97 | 42.37 | 2023-12-22 | 5 | 308.22 | 1 | 1694.97 | 2 | SO57061 | 2023-12-29 | 135.60 | 1541.09 | 338.99 | |||
SO71820_9 | D332-4AF2-A3 | PO12673129941 | 100 | 292 | 547 | 499 | 7 | 2024-08-03 | 194.38 | 4.86 | 2024-07-22 | 4 | 35.96 | 1 | 194.38 | 9 | SO71820 | 2024-07-29 | 15.55 | 143.84 | 48.59 |
Generated 2024-09-20 09:55:34.463 UTC