{
  "name": "table/external/4d/manager/product/stock_event.json",
  "table_name": "stock_event",
  "table_prefix": "st",
  "table_number": 8,
  "table_name_local": "stock",
  "record_type_local": "",
  "field": [
  {
    "type": "double",
    "field_number": 8,
    "name": "amount__unit"
  },
  {
    "type": "double",
    "field_number": 18,
    "name": "average_balance"
  },
  {
    "type": "double",
    "field_number": 19,
    "name": "average_price"
  },
  {
    "type": "date",
    "field_number": 32,
    "name": "average_price_change_date"
  },
  {
    "type": "varchar",
    "length": 90,
    "field_number": 43,
    "name": "change_id"
  },
  {
    "field_number": 2,
    "nullable": true,
    "type": "varchar",
    "length": 24,
    "name": "company_id",
    "foreign_key": {
      "field": "company_id",
      "table": "company"
    }
  },
  {
    "type": "varchar",
    "length": 160,
    "field_number": 29,
    "name": "cost_center"
  },
  {
    "type": "double",
    "field_number": 20,
    "name": "cost_price__unit"
  },
  {
    "type": "varchar",
    "length": 40,
    "field_number": 44,
    "name": "creator_id"
  },
  {
    "field_number": 23,
    "nullable": true,
    "type": "varchar",
    "length": 12,
    "name": "currency_id",
    "foreign_key": {
      "field": "currency_id",
      "table": "currency"
    }
  },
  {
    "type": "varchar",
    "length": 80,
    "field_number": 41,
    "name": "customer_project"
  },
  {
    "type": "date",
    "field_number": 5,
    "name": "date_"
  },
  {
    "field_number": 7,
    "nullable": true,
    "type": "varchar",
    "length": 24,
    "name": "event_maker_id",
    "foreign_key": {
      "field": "employee_id",
      "table": "employee"
    }
  },
  {
    "type": "double",
    "field_number": 25,
    "name": "exchange_rate"
  },
  {
    "type": "integer",
    "field_number": 27,
    "name": "firm_id"
  },
  {
    "type": "date",
    "field_number": 30,
    "name": "foreign_price_change_date"
  },
  {
    "type": "double",
    "field_number": 22,
    "name": "foreign_purchase_price"
  },
  {
    "type": "varchar",
    "length": 0,
    "field_number": 12,
    "name": "info"
  },
  {
    "type": "varchar",
    "length": 70,
    "field_number": 21,
    "name": "manufacturing_lot"
  },
  {
    "type": "varchar",
    "length": 40,
    "field_number": 45,
    "name": "modifier_id"
  },
  {
    "type": "varchar",
    "length": 60,
    "field_number": 24,
    "name": "order_row"
  },
  {
    "type": "varchar",
    "length": 24,
    "field_number": 17,
    "name": "orderer_id"
  },
  {
    "type": "integer",
    "field_number": 26,
    "name": "price_confirmation"
  },
  {
    "field_number": 1,
    "nullable": true,
    "type": "varchar",
    "length": 88,
    "name": "product_id",
    "foreign_key": {
      "field": "product_id",
      "table": "product"
    }
  },
  {
    "type": "varchar",
    "length": 80,
    "field_number": 42,
    "name": "project_id"
  },
  {
    "type": "double",
    "field_number": 34,
    "name": "purch_avg_price_amount"
  },
  {
    "type": "date",
    "field_number": 35,
    "name": "purch_avg_price_change_date"
  },
  {
    "type": "double",
    "field_number": 33,
    "name": "purchase_average_price"
  },
  {
    "type": "double",
    "field_number": 36,
    "name": "purchase_costs"
  },
  {
    "type": "double",
    "field_number": 13,
    "name": "purchase_price__unit"
  },
  {
    "type": "date",
    "field_number": 31,
    "name": "purchase_price_change_date"
  },
  {
    "type": "double",
    "field_number": 10,
    "name": "purchase_price_total"
  },
  {
    "field_number": 28,
    "type": "varchar",
    "length": 90,
    "name": "record_id",
    "constraint": [
      "unique"
    ]
  },
  {
    "type": "double",
    "field_number": 15,
    "name": "sales_price__unit"
  },
  {
    "type": "double",
    "field_number": 14,
    "name": "sales_price_total"
  },
  {
    "type": "integer",
    "field_number": 47,
    "name": "state"
  },
  {
    "type": "double",
    "field_number": 16,
    "name": "stock_balance"
  },
  {
    "type": "double",
    "field_number": 37,
    "name": "stock_balance_wip"
  },
  {
    "field_number": 11,
    "type": "varchar",
    "length": 20,
    "name": "stock_event_id",
    "constraint": [
      "unique"
    ]
  },
  {
    "type": "varchar",
    "length": 60,
    "field_number": 9,
    "name": "storage_place"
  },
  {
    "field_number": 3,
    "nullable": true,
    "type": "varchar",
    "length": 24,
    "name": "supplier_id",
    "foreign_key": {
      "field": "supplier_id",
      "table": "supplier"
    }
  },
  {
    "type": "time without time zone",
    "field_number": 6,
    "name": "time_"
  },
  {
    "type": "varchar",
    "length": 120,
    "field_number": 40,
    "name": "transfer_id"
  },
  {
    "type": "integer",
    "field_number": 46,
    "name": "transfer_state"
  },
  {
    "type": "varchar",
    "length": 40,
    "field_number": 4,
    "name": "type_"
  },
  {
    "type": "varchar",
    "length": 20,
    "field_number": 38,
    "name": "unit"
  },
  {
    "type": "varchar",
    "length": 20,
    "field_number": 39,
    "name": "unit_2"
  }
]
}
