[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > SKIP 0 SHUFFLE < SKIP 1281 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO69513_5 | 21F8-4626-B9 | PO7598121355 | 100 | 285 | 436 | 45 | 5 | 2024-07-02 | 356.90 | 8.92 | 2024-06-20 | 1 | 360.94 | 1 | 356.90 | 5 | SO69513 | 2024-06-27 | 28.55 | 360.94 | 356.90 | |||
SO45062_18 | 017E-486E-BC | PO1189166374 | 100 | 285 | 319 | 423 | 5 | 2022-03-04 | 1749.59 | 43.74 | 2022-02-20 | 2 | 884.71 | 1 | 1749.59 | 18 | SO45062 | 2022-02-27 | 139.97 | 1769.42 | 874.79 | |||
SO51693_30 | 6FEB-4D5B-92 | PO19546179477 | 100 | 285 | 287 | 206 | 5 | 2023-10-02 | 607.00 | 15.17 | 2023-09-20 | 3 | 204.63 | 1 | 607.00 | 30 | SO51693 | 2023-09-27 | 48.56 | 613.88 | 202.33 | |||
SO47026_16 | 123B-481F-8F | PO3596190739 | 100 | 285 | 401 | 476 | 5 | 2022-10-02 | 196.81 | 4.92 | 2022-09-20 | 3 | 48.55 | 1 | 196.81 | 16 | SO47026 | 2022-09-27 | 15.74 | 145.64 | 65.60 | |||
SO48063_22 | AEA4-4489-90 | PO5858143254 | 100 | 285 | 396 | 566 | 5 | 2023-01-02 | 74.84 | 1.87 | 2022-12-21 | 1 | 55.38 | 1 | 74.84 | 22 | SO48063 | 2022-12-28 | 5.99 | 55.38 | 74.84 | |||
SO49836_33 | 0E32-48F7-89 | PO12644185975 | 100 | 285 | 410 | 530 | 5 | 2023-06-02 | 109.34 | 2.73 | 2023-05-21 | 3 | 26.97 | 1 | 109.34 | 33 | SO49836 | 2023-05-28 | 8.75 | 80.91 | 36.45 | |||
SO50302_9 | 11AB-4878-A8 | PO5568123194 | 100 | 285 | 470 | 2 | 422 | 5 | 5.29 | 2023-07-02 | 264.41 | 6.48 | 2023-06-20 | 12 | 15.67 | 1 | 259.12 | 9 | SO50302 | 2023-06-27 | 20.73 | 188.05 | 22.03 | 0.02 |
SO47681_25 | 0580-4A09-A8 | PO12644124767 | 100 | 285 | 411 | 530 | 5 | 2022-12-02 | 125.42 | 3.14 | 2022-11-20 | 1 | 92.81 | 1 | 125.42 | 25 | SO47681 | 2022-11-27 | 10.03 | 92.81 | 125.42 | |||
SO69518_2 | 96AA-48F8-80 | PO5800191682 | 100 | 285 | 511 | 63 | 5 | 2024-07-02 | 1310.72 | 32.77 | 2024-06-20 | 6 | 199.38 | 1 | 1310.72 | 2 | SO69518 | 2024-06-27 | 104.86 | 1196.25 | 218.45 | |||
SO67260_13 | 6224-4229-B8 | PO522163557 | 100 | 285 | 524 | 676 | 5 | 2024-06-02 | 158.43 | 3.96 | 2024-05-21 | 1 | 144.59 | 1 | 158.43 | 13 | SO67260 | 2024-05-28 | 12.67 | 144.59 | 158.43 | |||
SO47042_38 | 42DB-4E2E-B9 | PO5858114009 | 100 | 285 | 213 | 566 | 5 | 2022-10-02 | 161.49 | 4.04 | 2022-09-20 | 8 | 13.88 | 1 | 161.49 | 38 | SO47042 | 2022-09-27 | 12.92 | 111.03 | 20.19 | |||
SO50703_34 | 4A3D-44CB-B3 | PO2813140706 | 100 | 283 | 230 | 90 | 5 | 2023-08-02 | 115.36 | 2.88 | 2023-07-21 | 4 | 29.08 | 1 | 115.36 | 34 | SO50703 | 2023-07-28 | 9.23 | 116.32 | 28.84 | |||
SO45329_12 | CFFE-4184-BD | PO5858128971 | 100 | 285 | 307 | 566 | 5 | 2022-04-04 | 1445.19 | 36.13 | 2022-03-23 | 2 | 623.84 | 1 | 1445.19 | 12 | SO45329 | 2022-03-30 | 115.62 | 1247.68 | 722.59 | |||
SO43875_11 | CE1F-4E31-89 | PO12586178184 | 100 | 285 | 300 | 278 | 5 | 2021-10-02 | 809.76 | 20.24 | 2021-09-20 | 1 | 699.09 | 1 | 809.76 | 11 | SO43875 | 2021-09-27 | 64.78 | 699.09 | 809.76 | |||
SO47965_13 | 953F-437D-84 | PO19546111394 | 100 | 285 | 331 | 206 | 5 | 2023-01-02 | 469.79 | 11.74 | 2022-12-21 | 1 | 486.71 | 1 | 469.79 | 13 | SO47965 | 2022-12-28 | 37.58 | 486.71 | 469.79 | |||
SO69533_31 | AC2B-4C39-84 | PO3596133486 | 100 | 285 | 544 | 476 | 5 | 2024-07-02 | 48.59 | 1.21 | 2024-06-20 | 1 | 35.96 | 1 | 48.59 | 31 | SO69533 | 2024-06-27 | 3.89 | 35.96 | 48.59 | |||
SO57162_3 | 83B5-43A6-BD | PO3596174424 | 100 | 285 | 511 | 476 | 5 | 2024-01-02 | 436.91 | 10.92 | 2023-12-21 | 2 | 199.38 | 1 | 436.91 | 3 | SO57162 | 2023-12-28 | 34.95 | 398.75 | 218.45 | |||
SO48734_1 | F5F8-4E2A-98 | PO12644188680 | 100 | 285 | 356 | 530 | 5 | 2023-03-04 | 3728.56 | 93.21 | 2023-02-20 | 3 | 1117.86 | 1 | 3728.56 | 1 | SO48734 | 2023-02-27 | 298.28 | 3353.57 | 1242.85 | |||
SO47965_31 | 953F-437D-84 | PO19546111394 | 100 | 285 | 415 | 206 | 5 | 2023-01-02 | 792.14 | 19.80 | 2022-12-21 | 4 | 146.55 | 1 | 792.14 | 31 | SO47965 | 2022-12-28 | 63.37 | 586.19 | 198.04 | |||
SO47681_32 | 0580-4A09-A8 | PO12644124767 | 100 | 285 | 213 | 530 | 5 | 2022-12-02 | 80.75 | 2.02 | 2022-11-20 | 4 | 13.88 | 1 | 80.75 | 32 | SO47681 | 2022-11-27 | 6.46 | 55.51 | 20.19 | |||
SO46943_11 | 6F43-4A10-80 | PO18560122957 | 100 | 285 | 216 | 531 | 5 | 2022-10-02 | 20.19 | 0.50 | 2022-09-20 | 1 | 13.88 | 1 | 20.19 | 11 | SO46943 | 2022-09-27 | 1.61 | 13.88 | 20.19 | |||
SO44506_13 | CD67-4B07-B6 | PO16327113845 | 100 | 285 | 235 | 584 | 5 | 2022-01-02 | 86.52 | 2.16 | 2021-12-21 | 3 | 31.72 | 1 | 86.52 | 13 | SO44506 | 2021-12-28 | 6.92 | 95.17 | 28.84 | |||
SO53540_7 | 1C52-4046-BA | PO18241135767 | 100 | 285 | 565 | 13 | 477 | 5 | 50.11 | 2023-11-02 | 334.06 | 7.10 | 2023-10-21 | 1 | 461.44 | 1 | 283.95 | 7 | SO53540 | 2023-10-28 | 22.72 | 461.44 | 334.06 | 0.15 |
SO47067_26 | DDEC-4319-8A | PO9512118933 | 100 | 285 | 458 | 135 | 5 | 2022-10-02 | 224.97 | 5.62 | 2022-09-20 | 5 | 30.93 | 1 | 224.97 | 26 | SO47067 | 2022-09-27 | 18.00 | 154.67 | 44.99 | |||
SO45062_20 | 017E-486E-BC | PO1189166374 | 100 | 285 | 315 | 423 | 5 | 2022-03-04 | 1749.59 | 43.74 | 2022-02-20 | 2 | 884.71 | 1 | 1749.59 | 20 | SO45062 | 2022-02-27 | 139.97 | 1769.42 | 874.79 | |||
SO46045_25 | 9345-48CB-A5 | PO16327127643 | 100 | 285 | 324 | 584 | 5 | 2022-07-02 | 2516.75 | 62.92 | 2022-06-20 | 6 | 413.15 | 1 | 2516.75 | 25 | SO46045 | 2022-06-27 | 201.34 | 2478.88 | 419.46 | |||
SO46654_18 | 2FEC-47CC-84 | PO3741124832 | 100 | 285 | 213 | 8 | 404 | 5 | 5.05 | 2022-09-01 | 50.47 | 1.14 | 2022-08-20 | 3 | 13.88 | 1 | 45.42 | 18 | SO46654 | 2022-08-27 | 3.63 | 41.63 | 16.82 | 0.10 |
SO47042_7 | 42DB-4E2E-B9 | PO5858114009 | 100 | 285 | 453 | 566 | 5 | 2022-10-02 | 323.95 | 8.10 | 2022-09-20 | 9 | 24.75 | 1 | 323.95 | 7 | SO47042 | 2022-09-27 | 25.92 | 222.71 | 35.99 | |||
SO58974_18 | FB64-4792-81 | PO2813115918 | 100 | 283 | 467 | 90 | 5 | 2024-02-01 | 58.78 | 1.47 | 2024-01-20 | 4 | 9.16 | 1 | 58.78 | 18 | SO58974 | 2024-01-27 | 4.70 | 36.64 | 14.69 | |||
SO50212_5 | BDB8-4FEA-94 | PO15051162285 | 100 | 285 | 470 | 2 | 207 | 5 | 5.29 | 2023-07-02 | 264.41 | 6.48 | 2023-06-20 | 12 | 15.67 | 1 | 259.12 | 5 | SO50212 | 2023-06-27 | 20.73 | 188.05 | 22.03 | 0.02 |
SO49509_25 | 1105-4F75-BE | PO9599181538 | 100 | 285 | 339 | 170 | 5 | 2023-05-02 | 2348.97 | 58.72 | 2023-04-20 | 5 | 486.71 | 1 | 2348.97 | 25 | SO49509 | 2023-04-27 | 187.92 | 2433.53 | 469.79 |
Generated 2024-09-20 00:04:20.937 UTC