[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SKIP 4000 SHUFFLE < SKIP 43 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO47008_50 | FD36-4D89-AB | PO1595170889 | 19 | 284 | 433 | 426 | 6 | 2022-11-23 | 648.91 | 16.22 | 2022-11-11 | 2 | 300.12 | 1 | 648.91 | 50 | SO47008 | 2022-11-18 | 51.91 | 600.24 | 324.45 | |||
SO69397_7 | 1339-46CA-AC | PO18879152551 | 19 | 291 | 568 | 64 | 6 | 2024-08-23 | 445.41 | 11.14 | 2024-08-11 | 1 | 461.44 | 1 | 445.41 | 7 | SO69397 | 2024-08-18 | 35.63 | 461.44 | 445.41 | |||
SO48306_29 | EA27-471A-9D | PO17574166075 | 19 | 291 | 366 | 678 | 6 | 2023-03-25 | 1295.99 | 32.40 | 2023-03-13 | 2 | 598.44 | 1 | 1295.99 | 29 | SO48306 | 2023-03-20 | 103.68 | 1196.87 | 647.99 | |||
SO47357_14 | 3E93-4357-9B | PO18531126368 | 19 | 284 | 419 | 613 | 6 | 2022-12-24 | 105.29 | 2.63 | 2022-12-12 | 2 | 38.96 | 1 | 105.29 | 14 | SO47357 | 2022-12-19 | 8.42 | 77.92 | 52.65 | |||
SO71830_33 | DA2D-4B00-A4 | PO10875112195 | 19 | 291 | 492 | 281 | 6 | 2024-09-23 | 1204.69 | 30.12 | 2024-09-11 | 2 | 601.74 | 1 | 1204.69 | 33 | SO71830 | 2024-09-18 | 96.38 | 1203.49 | 602.35 | |||
SO48306_48 | EA27-471A-9D | PO17574166075 | 19 | 291 | 469 | 678 | 6 | 2023-03-25 | 227.94 | 5.70 | 2023-03-13 | 10 | 15.67 | 1 | 227.94 | 48 | SO48306 | 2023-03-20 | 18.24 | 156.71 | 22.79 | |||
SO55280_23 | B925-404B-8B | PO18444178908 | 19 | 291 | 481 | 227 | 6 | 2024-01-23 | 16.18 | 0.40 | 2024-01-11 | 3 | 3.36 | 1 | 16.18 | 23 | SO55280 | 2024-01-18 | 1.29 | 10.09 | 5.39 | |||
SO47012_21 | 5043-4C8B-B3 | PO1914167487 | 19 | 284 | 230 | 66 | 6 | 2022-11-23 | 230.72 | 5.77 | 2022-11-11 | 8 | 29.08 | 1 | 230.72 | 21 | SO47012 | 2022-11-18 | 18.46 | 232.65 | 28.84 | |||
SO51847_4 | 7E3E-4DB0-80 | PO2030165560 | 19 | 284 | 599 | 661 | 6 | 2023-11-23 | 647.99 | 16.20 | 2023-11-11 | 2 | 294.58 | 1 | 647.99 | 4 | SO51847 | 2023-11-18 | 51.84 | 589.16 | 323.99 | |||
SO47357_5 | 3E93-4357-9B | PO18531126368 | 19 | 284 | 224 | 613 | 6 | 2022-12-24 | 10.37 | 0.26 | 2022-12-12 | 2 | 5.23 | 1 | 10.37 | 5 | SO47357 | 2022-12-19 | 0.83 | 10.46 | 5.19 | |||
SO48072_5 | D4FC-4834-8F | PO6496174950 | 19 | 291 | 468 | 226 | 6 | 2023-02-23 | 22.79 | 0.57 | 2023-02-11 | 1 | 15.67 | 1 | 22.79 | 5 | SO48072 | 2023-02-18 | 1.82 | 15.67 | 22.79 | |||
SO53456_4 | 9F7E-451F-8E | PO19401178762 | 19 | 291 | 482 | 2 | 173 | 6 | 1.15 | 2023-12-24 | 57.36 | 1.41 | 2023-12-12 | 11 | 3.36 | 1 | 56.21 | 4 | SO53456 | 2023-12-19 | 4.50 | 36.99 | 5.21 | 0.02 |
SO47366_40 | DD3E-4DAA-BA | PO17545115575 | 19 | 291 | 286 | 155 | 6 | 2022-12-24 | 919.69 | 22.99 | 2022-12-12 | 5 | 170.14 | 1 | 919.69 | 40 | SO47366 | 2022-12-19 | 73.58 | 850.71 | 183.94 | |||
SO55283_5 | 8D6B-460A-83 | PO18473174493 | 19 | 291 | 512 | 442 | 6 | 2024-01-23 | 873.82 | 21.85 | 2024-01-11 | 4 | 199.38 | 1 | 873.82 | 5 | SO55283 | 2024-01-18 | 69.91 | 797.50 | 218.45 | |||
SO69401_5 | 5377-4B5B-80 | PO17603155358 | 19 | 284 | 547 | 12 | 6 | 2024-08-23 | 145.78 | 3.64 | 2024-08-11 | 3 | 35.96 | 1 | 145.78 | 5 | SO69401 | 2024-08-18 | 11.66 | 107.88 | 48.59 | |||
SO69560_16 | B1B6-43F4-BC | PO9077167302 | 19 | 291 | 544 | 100 | 6 | 2024-08-23 | 48.59 | 1.21 | 2024-08-11 | 1 | 35.96 | 1 | 48.59 | 16 | SO69560 | 2024-08-18 | 3.89 | 35.96 | 48.59 | |||
SO48768_7 | 590A-4550-A0 | PO13862146668 | 19 | 291 | 421 | 119 | 6 | 2023-04-25 | 196.33 | 4.91 | 2023-04-13 | 1 | 145.28 | 1 | 196.33 | 7 | SO48768 | 2023-04-20 | 15.71 | 145.28 | 196.33 | |||
SO47365_24 | 4535-457B-B0 | PO17574153673 | 19 | 291 | 354 | 678 | 6 | 2022-12-24 | 8699.96 | 217.50 | 2022-12-12 | 7 | 1117.86 | 1 | 8699.96 | 24 | SO47365 | 2022-12-19 | 696.00 | 7824.99 | 1242.85 | |||
SO50232_12 | 3919-46D4-A1 | PO11020171211 | 19 | 284 | 457 | 336 | 6 | 2023-08-23 | 89.99 | 2.25 | 2023-08-11 | 2 | 30.93 | 1 | 89.99 | 12 | SO50232 | 2023-08-18 | 7.20 | 61.87 | 44.99 | |||
SO51786_18 | CB32-4179-97 | PO18357130739 | 19 | 272 | 555 | 138 | 6 | 2023-11-23 | 127.80 | 3.20 | 2023-11-11 | 2 | 47.29 | 1 | 127.80 | 18 | SO51786 | 2023-11-18 | 10.22 | 94.57 | 63.90 | |||
SO71808_26 | 2E63-4616-B1 | PO14761198562 | 19 | 284 | 465 | 408 | 6 | 2024-09-23 | 58.78 | 1.47 | 2024-09-11 | 4 | 9.16 | 1 | 58.78 | 26 | SO71808 | 2024-09-18 | 4.70 | 36.64 | 14.69 | |||
SO53527_39 | 0EBE-4ACB-B5 | PO1798140946 | 19 | 291 | 398 | 10 | 6 | 2023-12-24 | 80.17 | 2.00 | 2023-12-12 | 3 | 19.78 | 1 | 80.17 | 39 | SO53527 | 2023-12-19 | 6.41 | 59.33 | 26.72 | |||
SO58918_14 | C811-4D40-80 | PO17574131484 | 19 | 291 | 491 | 678 | 6 | 2024-03-24 | 291.55 | 7.29 | 2024-03-12 | 9 | 41.57 | 1 | 291.55 | 14 | SO58918 | 2024-03-19 | 23.32 | 374.15 | 32.39 | |||
SO55283_6 | 8D6B-460A-83 | PO18473174493 | 19 | 291 | 591 | 442 | 6 | 2024-01-23 | 1355.98 | 33.90 | 2024-01-11 | 4 | 308.22 | 1 | 1355.98 | 6 | SO55283 | 2024-01-18 | 108.48 | 1232.87 | 338.99 | |||
SO69479_19 | 3D8D-4908-A6 | PO18328116976 | 19 | 284 | 477 | 552 | 6 | 2024-08-23 | 8.98 | 0.22 | 2024-08-11 | 3 | 1.87 | 1 | 8.98 | 19 | SO69479 | 2024-08-18 | 0.72 | 5.60 | 2.99 | |||
SO48339_16 | EAB2-42EA-9C | PO10614150674 | 19 | 291 | 273 | 461 | 6 | 2023-03-25 | 202.33 | 5.06 | 2023-03-13 | 1 | 187.16 | 1 | 202.33 | 16 | SO48339 | 2023-03-20 | 16.19 | 187.16 | 202.33 | |||
SO53477_5 | F1BC-4EF4-85 | PO15544120937 | 19 | 284 | 558 | 282 | 6 | 2023-12-24 | 1214.97 | 30.37 | 2023-12-12 | 5 | 179.82 | 1 | 1214.97 | 5 | SO53477 | 2023-12-19 | 97.20 | 899.08 | 242.99 | |||
SO50242_46 | A651-4343-86 | PO1595193228 | 19 | 284 | 454 | 426 | 6 | 2023-08-23 | 35.99 | 0.90 | 2023-08-11 | 1 | 24.75 | 1 | 35.99 | 46 | SO50242 | 2023-08-18 | 2.88 | 24.75 | 35.99 |
Generated 2024-11-10 22:45:58.579 UTC