[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > SHUFFLE < SKIP 1626 > < TAKE 31 >
31 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO48766_21 | A56F-4A7B-AD | PO9831126274 | 100 | 285 | 373 | 81 | 5 | 2023-04-29 | 6544.69 | 163.62 | 2023-04-17 | 5 | 1320.68 | 1 | 6544.69 | 21 | SO48766 | 2023-04-24 | 523.58 | 6603.42 | 1308.94 | |||
SO63246_3 | 5008-4978-B3 | PO7598198768 | 100 | 285 | 581 | 45 | 5 | 2024-05-29 | 1020.59 | 25.51 | 2024-05-17 | 1 | 1082.51 | 1 | 1020.59 | 3 | SO63246 | 2024-05-24 | 81.65 | 1082.51 | 1020.59 | |||
SO44098_3 | AB18-4E5B-98 | PO13746121367 | 100 | 285 | 345 | 567 | 5 | 2021-12-28 | 2039.99 | 51.00 | 2021-12-16 | 1 | 1912.15 | 1 | 2039.99 | 3 | SO44098 | 2021-12-23 | 163.20 | 1912.15 | 2039.99 | |||
SO69513_10 | 21F8-4626-B9 | PO7598121355 | 100 | 285 | 378 | 45 | 5 | 2024-08-27 | 1466.01 | 36.65 | 2024-08-15 | 1 | 1554.95 | 1 | 1466.01 | 10 | SO69513 | 2024-08-22 | 117.28 | 1554.95 | 1466.01 | |||
SO50703_31 | 4A3D-44CB-B3 | PO2813140706 | 100 | 283 | 216 | 90 | 5 | 2023-09-27 | 141.31 | 3.53 | 2023-09-15 | 7 | 13.88 | 1 | 141.31 | 31 | SO50703 | 2023-09-22 | 11.30 | 97.15 | 20.19 | |||
SO51147_37 | C4D7-458D-A6 | PO9831167474 | 100 | 285 | 234 | 2 | 81 | 5 | 8.12 | 2023-10-27 | 405.92 | 9.95 | 2023-10-15 | 14 | 38.49 | 1 | 397.80 | 37 | SO51147 | 2023-10-22 | 31.82 | 538.89 | 28.99 | 0.02 |
SO69513_16 | 21F8-4626-B9 | PO7598121355 | 100 | 285 | 240 | 45 | 5 | 2024-08-27 | 4294.50 | 107.36 | 2024-08-15 | 5 | 868.63 | 1 | 4294.50 | 16 | SO69513 | 2024-08-22 | 343.56 | 4343.17 | 858.90 | |||
SO45802_6 | 8C6D-42B3-AA | PO1189157476 | 100 | 285 | 315 | 423 | 5 | 2022-07-28 | 3499.18 | 87.48 | 2022-07-16 | 4 | 884.71 | 1 | 3499.18 | 6 | SO45802 | 2022-07-23 | 279.93 | 3538.83 | 874.79 | |||
SO50756_1 | C414-447C-84 | PO9570119689 | 100 | 285 | 456 | 585 | 5 | 2023-09-27 | 134.98 | 3.37 | 2023-09-15 | 3 | 30.93 | 1 | 134.98 | 1 | SO50756 | 2023-09-22 | 10.80 | 92.80 | 44.99 | |||
SO46991_11 | 6D99-4D79-AA | PO11803111101 | 100 | 285 | 356 | 513 | 5 | 2022-11-27 | 2485.70 | 62.14 | 2022-11-15 | 2 | 1117.86 | 1 | 2485.70 | 11 | SO46991 | 2022-11-22 | 198.86 | 2235.71 | 1242.85 | |||
SO50191_12 | 1DDA-4B5A-95 | PO19546193423 | 100 | 285 | 453 | 206 | 5 | 2023-08-27 | 215.96 | 5.40 | 2023-08-15 | 6 | 24.75 | 1 | 215.96 | 12 | SO50191 | 2023-08-22 | 17.28 | 148.48 | 35.99 | |||
SO67277_36 | 9AB3-4F34-85 | PO12644174121 | 100 | 272 | 517 | 530 | 5 | 2024-07-28 | 63.17 | 1.58 | 2024-07-16 | 2 | 23.37 | 1 | 63.17 | 36 | SO67277 | 2024-07-23 | 5.05 | 46.74 | 31.58 | |||
SO45802_3 | 8C6D-42B3-AA | PO1189157476 | 100 | 285 | 270 | 423 | 5 | 2022-07-28 | 551.81 | 13.80 | 2022-07-16 | 3 | 181.49 | 1 | 551.81 | 3 | SO45802 | 2022-07-23 | 44.15 | 544.46 | 183.94 | |||
SO47681_8 | 0580-4A09-A8 | PO12644124767 | 100 | 285 | 464 | 530 | 5 | 2023-01-27 | 98.90 | 2.47 | 2023-01-15 | 7 | 9.71 | 1 | 98.90 | 8 | SO47681 | 2023-01-22 | 7.91 | 68.00 | 14.13 | |||
SO58924_25 | D17F-4E31-90 | PO15457121920 | 100 | 285 | 567 | 297 | 5 | 2024-03-28 | 1336.23 | 33.41 | 2024-03-16 | 3 | 461.44 | 1 | 1336.23 | 25 | SO58924 | 2024-03-23 | 106.90 | 1384.33 | 445.41 | |||
SO43875_8 | CE1F-4E31-89 | PO12586178184 | 100 | 285 | 212 | 278 | 5 | 2021-11-27 | 40.37 | 1.01 | 2021-11-15 | 2 | 12.03 | 1 | 40.37 | 8 | SO43875 | 2021-11-22 | 3.23 | 24.06 | 20.19 | |||
SO50315_1 | EDB3-4074-A9 | PO7598160779 | 100 | 285 | 429 | 45 | 5 | 2023-08-27 | 973.36 | 24.33 | 2023-08-15 | 3 | 300.12 | 1 | 973.36 | 1 | SO50315 | 2023-08-22 | 77.87 | 900.36 | 324.45 | |||
SO57190_3 | F86C-45A6-B4 | PO9773165531 | 100 | 285 | 564 | 8 | 5 | 2024-02-27 | 4291.33 | 107.28 | 2024-02-15 | 3 | 1481.94 | 1 | 4291.33 | 3 | SO57190 | 2024-02-22 | 343.31 | 4445.81 | 1430.44 | |||
SO50260_2 | 9FEF-4E9E-B1 | PO18560172242 | 100 | 285 | 343 | 531 | 5 | 2023-08-27 | 469.79 | 11.74 | 2023-08-15 | 1 | 486.71 | 1 | 469.79 | 2 | SO50260 | 2023-08-22 | 37.58 | 486.71 | 469.79 | |||
SO48766_37 | A56F-4A7B-AD | PO9831126274 | 100 | 285 | 286 | 81 | 5 | 2023-04-29 | 183.94 | 4.60 | 2023-04-17 | 1 | 170.14 | 1 | 183.94 | 37 | SO48766 | 2023-04-24 | 14.72 | 170.14 | 183.94 | |||
SO47455_17 | 41F3-48C2-B7 | PO9599169586 | 100 | 285 | 371 | 170 | 5 | 2022-12-28 | 3926.81 | 98.17 | 2022-12-16 | 3 | 1320.68 | 1 | 3926.81 | 17 | SO47455 | 2022-12-23 | 314.15 | 3962.05 | 1308.94 | |||
SO48777_3 | 6378-4AB9-80 | PO3741115378 | 100 | 285 | 327 | 404 | 5 | 2023-04-29 | 939.59 | 23.49 | 2023-04-17 | 2 | 486.71 | 1 | 939.59 | 3 | SO48777 | 2023-04-24 | 75.17 | 973.41 | 469.79 | |||
SO49865_34 | E9A6-42D3-91 | PO9831136904 | 100 | 285 | 242 | 81 | 5 | 2023-07-28 | 3123.27 | 78.08 | 2023-07-16 | 4 | 722.26 | 1 | 3123.27 | 34 | SO49865 | 2023-07-23 | 249.86 | 2889.03 | 780.82 | |||
SO69518_17 | 96AA-48F8-80 | PO5800191682 | 100 | 285 | 355 | 63 | 5 | 2024-08-27 | 2783.99 | 69.60 | 2024-08-15 | 2 | 1265.62 | 1 | 2783.99 | 17 | SO69518 | 2024-08-22 | 222.72 | 2531.24 | 1391.99 | |||
SO53530_5 | A31D-483D-A1 | PO2813121313 | 100 | 283 | 545 | 90 | 5 | 2023-12-28 | 121.47 | 3.04 | 2023-12-16 | 5 | 17.98 | 1 | 121.47 | 5 | SO53530 | 2023-12-23 | 9.72 | 89.89 | 24.29 | |||
SO47053_12 | 686D-414B-82 | PO7598127510 | 100 | 285 | 403 | 45 | 5 | 2022-11-27 | 97.18 | 2.43 | 2022-11-15 | 4 | 17.98 | 1 | 97.18 | 12 | SO47053 | 2022-11-22 | 7.77 | 71.91 | 24.29 | |||
SO44309_2 | F0DB-4889-AC | PO3393112350 | 100 | 285 | 310 | 549 | 5 | 2022-01-27 | 2146.96 | 53.67 | 2022-01-15 | 1 | 2171.29 | 1 | 2146.96 | 2 | SO44309 | 2022-01-22 | 171.76 | 2171.29 | 2146.96 | |||
SO57017_13 | 4C6E-47EA-AD | PO19546126186 | 100 | 285 | 378 | 206 | 5 | 2024-02-27 | 4398.03 | 109.95 | 2024-02-15 | 3 | 1554.95 | 1 | 4398.03 | 13 | SO57017 | 2024-02-22 | 351.84 | 4664.84 | 1466.01 | |||
SO47067_8 | DDEC-4319-8A | PO9512118933 | 100 | 285 | 323 | 135 | 5 | 2022-11-27 | 939.59 | 23.49 | 2022-11-15 | 2 | 486.71 | 1 | 939.59 | 8 | SO47067 | 2022-11-22 | 75.17 | 973.41 | 469.79 | |||
SO46991_8 | 6D99-4D79-AA | PO11803111101 | 100 | 285 | 354 | 513 | 5 | 2022-11-27 | 3728.56 | 93.21 | 2022-11-15 | 3 | 1117.86 | 1 | 3728.56 | 8 | SO46991 | 2022-11-22 | 298.28 | 3353.57 | 1242.85 | |||
SO50293_16 | D649-4CE8-91 | PO3596144572 | 100 | 285 | 356 | 476 | 5 | 2023-08-27 | 2485.70 | 62.14 | 2023-08-15 | 2 | 1117.86 | 1 | 2485.70 | 16 | SO50293 | 2023-08-22 | 198.86 | 2235.71 | 1242.85 |
Generated 2024-11-14 05:00:44.711 UTC