# rpt_noon_finance (https://sellersheetai.com/docs/data/rpt_noon_finance)

> noon reports · NOON_FINANCE · Twice a day, at 04:00 and 16:00 UTC

- Family: noon
- Report type: `NOON_FINANCE`
- How fresh: Several times a day — Twice a day, at 04:00 and 16:00 UTC
- Need it right now: synced only
- Grain: region · sync: incremental

## Columns

| Column | Type | Key |
|---|---|---|
| `id` | INTEGER |  |
| `project_code` | VARCHAR(50) | key |
| `marketplace` | VARCHAR(16) |  |
| `report_date` | DATE |  |
| `contract` | VARCHAR(80) |  |
| `contract_title` | VARCHAR(255) |  |
| `reference_nr` | VARCHAR(80) | key |
| `order_nr` | VARCHAR(80) |  |
| `item_nr` | VARCHAR(80) | key |
| `order_date` | DATE |  |
| `transaction_date` | DATE |  |
| `title` | TEXT |  |
| `skus` | VARCHAR(200) |  |
| `partner_skus` | VARCHAR(200) |  |
| `transaction_type` | VARCHAR(80) | key |
| `currency` | VARCHAR(8) |  |
| `country_code` | VARCHAR(8) |  |
| `net_proceeds` | NUMERIC(16, 2) |  |
| `referral_fee` | NUMERIC(16, 2) |  |
| `fulfillment_logistics_fees` | NUMERIC(16, 2) |  |
| `shipping_credits` | NUMERIC(16, 2) |  |
| `other_order_fees` | NUMERIC(16, 2) |  |
| `order_subsidies` | NUMERIC(16, 2) |  |
| `non_order_fees` | NUMERIC(16, 2) |  |
| `non_order_subsidies` | NUMERIC(16, 2) |  |
| `others` | NUMERIC(16, 2) |  |
| `total` | NUMERIC(16, 2) |  |
| `extra` | JSON |  |

## Query it

```json
{
  "name": "query_report_data",
  "arguments": {
    "store": "myNoon-AE",
    "tables": [
      "rpt_noon_finance"
    ],
    "columns": [
      "rpt_noon_finance.project_code",
      "rpt_noon_finance.reference_nr",
      "rpt_noon_finance.item_nr",
      "rpt_noon_finance.transaction_type"
    ],
    "order_by": [
      {
        "column": "rpt_noon_finance.report_date",
        "dir": "desc"
      }
    ],
    "limit": 100
  }
}
```