[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > < SKIP 5847 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO55299_19 | 0B56-423B-B7 | PO6612171212 | 100 | 286 | 573 | 110 | 1 | 2024-01-23 | 4291.33 | 107.28 | 2024-01-11 | 3 | 1481.94 | 1 | 4291.33 | 19 | SO55299 | 2024-01-18 | 343.31 | 4445.81 | 1430.44 | |||
SO55299_20 | 0B56-423B-B7 | PO6612171212 | 100 | 286 | 514 | 110 | 1 | 2024-01-23 | 63.90 | 1.60 | 2024-01-11 | 1 | 47.29 | 1 | 63.90 | 20 | SO55299 | 2024-01-18 | 5.11 | 47.29 | 63.90 | |||
SO55299_21 | 0B56-423B-B7 | PO6612171212 | 100 | 286 | 579 | 110 | 1 | 2024-01-23 | 2915.64 | 72.89 | 2024-01-11 | 4 | 755.15 | 1 | 2915.64 | 21 | SO55299 | 2024-01-18 | 233.25 | 3020.60 | 728.91 | |||
SO55299_22 | 0B56-423B-B7 | PO6612171212 | 100 | 286 | 565 | 110 | 1 | 2024-01-23 | 890.82 | 22.27 | 2024-01-11 | 2 | 461.44 | 1 | 890.82 | 22 | SO55299 | 2024-01-18 | 71.27 | 922.89 | 445.41 | |||
SO55299_23 | 0B56-423B-B7 | PO6612171212 | 100 | 286 | 563 | 110 | 1 | 2024-01-23 | 4291.33 | 107.28 | 2024-01-11 | 3 | 1481.94 | 1 | 4291.33 | 23 | SO55299 | 2024-01-18 | 343.31 | 4445.81 | 1430.44 | |||
SO55299_24 | 0B56-423B-B7 | PO6612171212 | 100 | 286 | 548 | 110 | 1 | 2024-01-23 | 145.78 | 3.64 | 2024-01-11 | 3 | 35.96 | 1 | 145.78 | 24 | SO55299 | 2024-01-18 | 11.66 | 107.88 | 48.59 | |||
SO46957_26 | C98D-43A5-8A | PO16414179284 | 100 | 289 | 426 | 236 | 1 | 2022-11-23 | 209.26 | 5.23 | 2022-11-11 | 1 | 185.82 | 1 | 209.26 | 26 | SO46957 | 2022-11-18 | 16.74 | 185.82 | 209.26 | |||
SO46957_27 | C98D-43A5-8A | PO16414179284 | 100 | 289 | 356 | 236 | 1 | 2022-11-23 | 9942.81 | 248.57 | 2022-11-11 | 8 | 1117.86 | 1 | 9942.81 | 27 | SO46957 | 2022-11-18 | 795.43 | 8942.85 | 1242.85 | |||
SO46957_28 | C98D-43A5-8A | PO16414179284 | 100 | 289 | 448 | 236 | 1 | 2022-11-23 | 107.95 | 2.70 | 2022-11-11 | 9 | 8.25 | 1 | 107.95 | 28 | SO46957 | 2022-11-18 | 8.64 | 74.21 | 11.99 | |||
SO46957_29 | C98D-43A5-8A | PO16414179284 | 100 | 289 | 352 | 236 | 1 | 2022-11-23 | 2485.70 | 62.14 | 2022-11-11 | 2 | 1117.86 | 1 | 2485.70 | 29 | SO46957 | 2022-11-18 | 198.86 | 2235.71 | 1242.85 | |||
SO46957_30 | C98D-43A5-8A | PO16414179284 | 100 | 289 | 401 | 236 | 1 | 2022-11-23 | 196.81 | 4.92 | 2022-11-11 | 3 | 48.55 | 1 | 196.81 | 30 | SO46957 | 2022-11-18 | 15.74 | 145.64 | 65.60 | |||
SO46957_31 | C98D-43A5-8A | PO16414179284 | 100 | 289 | 224 | 3 | 236 | 1 | 3.57 | 2022-11-23 | 71.31 | 1.69 | 2022-11-11 | 15 | 5.23 | 1 | 67.75 | 31 | SO46957 | 2022-11-18 | 5.42 | 78.45 | 4.75 | 0.05 |
SO46957_32 | C98D-43A5-8A | PO16414179284 | 100 | 289 | 393 | 236 | 1 | 2022-11-23 | 826.16 | 20.65 | 2022-11-11 | 6 | 101.89 | 1 | 826.16 | 32 | SO46957 | 2022-11-18 | 66.09 | 611.36 | 137.69 | |||
SO46957_33 | C98D-43A5-8A | PO16414179284 | 100 | 289 | 396 | 236 | 1 | 2022-11-23 | 598.70 | 14.97 | 2022-11-11 | 8 | 55.38 | 1 | 598.70 | 33 | SO46957 | 2022-11-18 | 47.90 | 443.04 | 74.84 | |||
SO46957_34 | C98D-43A5-8A | PO16414179284 | 100 | 289 | 308 | 236 | 1 | 2022-11-23 | 2232.82 | 55.82 | 2022-11-11 | 3 | 660.91 | 1 | 2232.82 | 34 | SO46957 | 2022-11-18 | 178.63 | 1982.74 | 744.27 | |||
SO46957_35 | C98D-43A5-8A | PO16414179284 | 100 | 289 | 460 | 236 | 1 | 2022-11-23 | 107.99 | 2.70 | 2022-11-11 | 2 | 37.12 | 1 | 107.99 | 35 | SO46957 | 2022-11-18 | 8.64 | 74.24 | 53.99 | |||
SO46957_36 | C98D-43A5-8A | PO16414179284 | 100 | 289 | 454 | 236 | 1 | 2022-11-23 | 143.98 | 3.60 | 2022-11-11 | 4 | 24.75 | 1 | 143.98 | 36 | SO46957 | 2022-11-18 | 11.52 | 98.98 | 35.99 | |||
SO46957_37 | C98D-43A5-8A | PO16414179284 | 100 | 289 | 366 | 236 | 1 | 2022-11-23 | 6479.94 | 162.00 | 2022-11-11 | 10 | 598.44 | 1 | 6479.94 | 37 | SO46957 | 2022-11-18 | 518.40 | 5984.35 | 647.99 | |||
SO46957_38 | C98D-43A5-8A | PO16414179284 | 100 | 289 | 419 | 236 | 1 | 2022-11-23 | 263.24 | 6.58 | 2022-11-11 | 5 | 38.96 | 1 | 263.24 | 38 | SO46957 | 2022-11-18 | 21.06 | 194.79 | 52.65 | |||
SO46957_39 | C98D-43A5-8A | PO16414179284 | 100 | 289 | 397 | 236 | 1 | 2022-11-23 | 242.95 | 6.07 | 2022-11-11 | 10 | 17.98 | 1 | 242.95 | 39 | SO46957 | 2022-11-18 | 19.44 | 179.78 | 24.29 | |||
SO46957_40 | C98D-43A5-8A | PO16414179284 | 100 | 289 | 395 | 3 | 236 | 1 | 50.63 | 2022-11-23 | 1012.67 | 24.05 | 2022-11-11 | 18 | 45.42 | 1 | 962.04 | 40 | SO46957 | 2022-11-18 | 76.96 | 817.50 | 56.26 | 0.05 |
SO46957_41 | C98D-43A5-8A | PO16414179284 | 100 | 289 | 412 | 236 | 1 | 2022-11-23 | 540.39 | 13.51 | 2022-11-11 | 3 | 133.30 | 1 | 540.39 | 41 | SO46957 | 2022-11-18 | 43.23 | 399.89 | 180.13 | |||
SO46957_42 | C98D-43A5-8A | PO16414179284 | 100 | 289 | 411 | 236 | 1 | 2022-11-23 | 501.66 | 12.54 | 2022-11-11 | 4 | 92.81 | 1 | 501.66 | 42 | SO46957 | 2022-11-18 | 40.13 | 371.23 | 125.42 | |||
SO46957_43 | C98D-43A5-8A | PO16414179284 | 100 | 289 | 230 | 236 | 1 | 2022-11-23 | 230.72 | 5.77 | 2022-11-11 | 8 | 29.08 | 1 | 230.72 | 43 | SO46957 | 2022-11-18 | 18.46 | 232.65 | 28.84 | |||
SO46957_44 | C98D-43A5-8A | PO16414179284 | 100 | 289 | 461 | 236 | 1 | 2022-11-23 | 107.99 | 2.70 | 2022-11-11 | 2 | 37.12 | 1 | 107.99 | 44 | SO46957 | 2022-11-18 | 8.64 | 74.24 | 53.99 | |||
SO46957_45 | C98D-43A5-8A | PO16414179284 | 100 | 289 | 365 | 236 | 1 | 2022-11-23 | 5831.95 | 145.80 | 2022-11-11 | 9 | 598.44 | 1 | 5831.95 | 45 | SO46957 | 2022-11-18 | 466.56 | 5385.92 | 647.99 | |||
SO46957_46 | C98D-43A5-8A | PO16414179284 | 100 | 289 | 367 | 236 | 1 | 2022-11-23 | 3239.97 | 81.00 | 2022-11-11 | 5 | 598.44 | 1 | 3239.97 | 46 | SO46957 | 2022-11-18 | 259.20 | 2992.18 | 647.99 | |||
SO46957_47 | C98D-43A5-8A | PO16414179284 | 100 | 289 | 470 | 3 | 236 | 1 | 18.81 | 2022-11-23 | 376.10 | 8.93 | 2022-11-11 | 18 | 15.67 | 1 | 357.30 | 47 | SO46957 | 2022-11-18 | 28.58 | 282.08 | 20.89 | 0.05 |
SO46957_48 | C98D-43A5-8A | PO16414179284 | 100 | 289 | 399 | 236 | 1 | 2022-11-23 | 337.75 | 8.44 | 2022-11-11 | 10 | 24.99 | 1 | 337.75 | 48 | SO46957 | 2022-11-18 | 27.02 | 249.93 | 33.77 | |||
SO46957_49 | C98D-43A5-8A | PO16414179284 | 100 | 289 | 445 | 236 | 1 | 2022-11-23 | 107.98 | 2.70 | 2022-11-11 | 3 | 24.75 | 1 | 107.98 | 49 | SO46957 | 2022-11-18 | 8.64 | 74.24 | 35.99 | |||
SO46957_50 | C98D-43A5-8A | PO16414179284 | 100 | 289 | 233 | 236 | 1 | 2022-11-23 | 259.56 | 6.49 | 2022-11-11 | 9 | 29.08 | 1 | 259.56 | 50 | SO46957 | 2022-11-18 | 20.77 | 261.73 | 28.84 |
Generated 2024-11-11 00:01:54.607 UTC