[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '7' > SHUFFLE < SKIP 156 > < TAKE 14 >
14 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO61216_6 | B500-4250-B9 | PO13340173082 | 100 | 292 | 475 | 355 | 7 | 2024-03-04 | 209.97 | 5.25 | 2024-02-21 | 5 | 26.18 | 1 | 209.97 | 6 | SO61216 | 2024-02-28 | 16.80 | 130.88 | 41.99 | |||
SO67339_18 | E214-4902-AC | PO3509143630 | 36 | 292 | 467 | 139 | 7 | 2024-06-03 | 73.47 | 1.84 | 2024-05-22 | 5 | 9.16 | 1 | 73.47 | 18 | SO67339 | 2024-05-29 | 5.88 | 45.80 | 14.69 | |||
SO69426_41 | 4194-45D7-B6 | PO13427130433 | 100 | 292 | 463 | 638 | 7 | 2024-07-03 | 102.86 | 2.57 | 2024-06-21 | 7 | 9.16 | 1 | 102.86 | 41 | SO69426 | 2024-06-28 | 8.23 | 64.12 | 14.69 | |||
SO51735_5 | 6E95-4EE8-92 | PO13456167695 | 36 | 292 | 506 | 614 | 7 | 2023-10-03 | 1400.36 | 35.01 | 2023-09-21 | 7 | 199.85 | 1 | 1400.36 | 5 | SO51735 | 2023-09-28 | 112.03 | 1398.96 | 200.05 | |||
SO46987_4 | 60CF-4768-AF | PO12702179544 | 100 | 292 | 221 | 175 | 7 | 2022-10-03 | 161.49 | 4.04 | 2022-09-21 | 8 | 13.88 | 1 | 161.49 | 4 | SO46987 | 2022-09-28 | 12.92 | 111.03 | 20.19 | |||
SO63179_34 | F2C5-4376-B7 | PO2668147145 | 100 | 292 | 237 | 535 | 7 | 2024-04-04 | 59.99 | 1.50 | 2024-03-23 | 2 | 38.49 | 1 | 59.99 | 34 | SO63179 | 2024-03-30 | 4.80 | 76.98 | 29.99 | |||
SO57068_28 | 0E44-4044-B3 | PO11223190191 | 100 | 292 | 398 | 632 | 7 | 2024-01-03 | 80.17 | 2.00 | 2023-12-22 | 3 | 19.78 | 1 | 80.17 | 28 | SO57068 | 2023-12-29 | 6.41 | 59.33 | 26.72 | |||
SO69447_9 | 1C7A-4B97-AA | PO11223139140 | 100 | 292 | 476 | 632 | 7 | 2024-07-03 | 125.98 | 3.15 | 2024-06-21 | 3 | 26.18 | 1 | 125.98 | 9 | SO69447 | 2024-06-28 | 10.08 | 78.53 | 41.99 | |||
SO51733_15 | 5E45-4EBB-89 | PO13108175772 | 100 | 292 | 501 | 103 | 7 | 2023-10-03 | 145.75 | 3.64 | 2023-09-21 | 2 | 53.93 | 1 | 145.75 | 15 | SO51733 | 2023-09-28 | 11.66 | 107.86 | 72.88 | |||
SO69426_22 | 4194-45D7-B6 | PO13427130433 | 100 | 292 | 480 | 638 | 7 | 2024-07-03 | 5.50 | 0.14 | 2024-06-21 | 4 | 0.86 | 1 | 5.50 | 22 | SO69426 | 2024-06-28 | 0.44 | 3.43 | 1.37 | |||
SO48010_29 | 81A7-4B68-B2 | PO12702168891 | 100 | 292 | 469 | 175 | 7 | 2023-01-03 | 136.76 | 3.42 | 2022-12-22 | 6 | 15.67 | 1 | 136.76 | 29 | SO48010 | 2022-12-29 | 10.94 | 94.03 | 22.79 | |||
SO51733_24 | 5E45-4EBB-89 | PO13108175772 | 100 | 292 | 565 | 13 | 103 | 7 | 150.33 | 2023-10-03 | 1002.17 | 21.30 | 2023-09-21 | 3 | 461.44 | 1 | 851.85 | 24 | SO51733 | 2023-09-28 | 68.15 | 1384.33 | 334.06 | 0.15 |
SO57054_23 | 8D1A-4AF0-91 | PO13456189029 | 36 | 292 | 548 | 614 | 7 | 2024-01-03 | 97.19 | 2.43 | 2023-12-22 | 2 | 35.96 | 1 | 97.19 | 23 | SO57054 | 2023-12-29 | 7.78 | 71.92 | 48.59 | |||
SO48763_16 | 06A5-45C0-A2 | PO3509163189 | 36 | 292 | 453 | 139 | 7 | 2023-03-05 | 251.96 | 6.30 | 2023-02-21 | 7 | 24.75 | 1 | 251.96 | 16 | SO48763 | 2023-02-28 | 20.16 | 173.22 | 35.99 |
Generated 2024-09-20 14:55:45.973 UTC