{
	"name": "table/external/odoo/order/order-purchase.json",
	"table_name": "purchase_order",
	"odoo_model": "purchase.order",
	"table_prefix": "po",
	"record_type": ["purchase"],
	"local_table": "order",
	"local_record_type": "purchase",
	"field": [
		{
			"info": "Security Token",
			"field_name": "access_token",
			"local_field": "",
			"field_type": "varchar"
		},
		{
			"info": "Portal Access URL\nCustomer Portal URL",
			"field_name": "access_url",
			"local_field": "",
			"field_type": "varchar"
		},
		{
			"info": "Access warning",
			"field_name": "access_warning",
			"local_field": "",
			"field_type": "text"
		},
		{
			"info": "Acknowledged\nIt indicates that the vendor has acknowledged the receipt of the purchase order.",
			"field_name": "acknowledged",
			"local_field": "",
			"field_type": "boolean"
		},
		{
			"info": "Next Activity Calendar Event",
			"field_name": "activity_calendar_event_id",
			"local_field": "",
			"field_type": "integer",
			"type": "many2one",
			"json_tag": "[1]"
		},
		{
			"info": "Next Activity Deadline",
			"field_name": "activity_date_deadline",
			"local_field": "",
			"field_type": "date"
		},
		{
			"info": "Activity Exception Decoration\nType of the exception activity on record.",
			"field_name": "activity_exception_decoration",
			"local_field": "",
			"field_type": "text",
			"type": "selection"
		},
		{
			"info": "Icon\nIcon to indicate an exception activity.",
			"field_name": "activity_exception_icon",
			"local_field": "",
			"field_type": "varchar"
		},
		{
			"info": "Activities",
			"field_name": "activity_ids",
			"local_field": "",
			"field_type": "integer",
			"type": "one2many",
			"json_tag": "[1]"
		},
		{
			"info": "Activity State\nStatus based on activities\nOverdue: Due date is already passed\nToday: Activity date is today\nPlanned: Future activities.",
			"field_name": "activity_state",
			"local_field": "",
			"field_type": "text",
			"type": "selection"
		},
		{
			"info": "Next Activity Summary",
			"field_name": "activity_summary",
			"local_field": "",
			"field_type": "varchar"
		},
		{
			"info": "Activity Type Icon\nFont awesome icon e.g. fa-tasks",
			"field_name": "activity_type_icon",
			"local_field": "",
			"field_type": "varchar"
		},
		{
			"info": "Next Activity Type",
			"field_name": "activity_type_id",
			"local_field": "",
			"field_type": "integer",
			"type": "many2one",
			"json_tag": "[1]"
		},
		{
			"info": "Responsible User",
			"field_name": "activity_user_id",
			"local_field": "",
			"field_type": "integer",
			"type": "many2one",
			"json_tag": "[1]"
		},
		{
			"info": "Taxes",
			"field_name": "amount_tax",
			"local_field": "vat_price",
			"field_type": "double",
			"type": "monetary"
		},
		{
			"info": "Total",
			"field_name": "amount_total",
			"local_field": "price_with_vat",
			"field_type": "double",
			"type": "monetary"
		},
		{
			"info": "Company Total",
			"field_name": "amount_total_cc",
			"local_field": "",
			"field_type": "double",
			"type": "monetary"
		},
		{
			"info": "Untaxed Amount",
			"field_name": "amount_untaxed",
			"local_field": "price_without_vat",
			"field_type": "double",
			"type": "monetary"
		},
		{
			"info": "Company Currency",
			"field_name": "company_currency_id",
			"local_field": "",
			"field_type": "integer",
			"type": "many2one",
			"json_tag": "[1]"
		},
		{
			"info": "Company",
			"field_name": "company_id",
			"local_field": "company_id",
			"field_type": "integer",
			"type": "many2one",
			"json_tag": "[2]"
		},
		{
			"info": "Default Sales Price Include\nDefault on whether the sales price used on the product and invoices with this Company includes its taxes.",
			"field_name": "company_price_include",
			"local_field": "",
			"field_type": "text",
			"type": "selection"
		},
		{
			"info": "Country code\nThe ISO country code in two chars. \nYou can use this field for quick search.",
			"field_name": "country_code",
			"local_field": "",
			"field_type": "varchar"
		},
		{
			"info": "Created on",
			"field_name": "create_date",
			"local_field": "create_time",
			"field_type": "timestamp without time zone",
			"type": "datetime"
		},
		{
			"info": "Created by",
			"field_name": "create_uid",
			"local_field": "json_data.create_user",
			"field_type": "integer",
			"type": "many2one",
			"json_tag": "[1]"
		},
		{
			"info": "Currency",
			"field_name": "currency_id",
			"local_field": "currency_id",
			"field_type": "integer",
			"type": "many2one",
			"json_tag": "[2]"
		},
		{
			"info": "Currency Rate\nRatio between the purchase order currency and the company currency",
			"field_name": "currency_rate",
			"local_field": "exchange_rate",
			"field_type": "double",
			"type": "float"
		},
		{
			"info": "Confirmation Date",
			"field_name": "date_approve",
			"local_field": "confirmation_date",
			"field_type": "timestamp without time zone",
			"type": "datetime"
		},
		{
			"info": "Date Calendar Start",
			"field_name": "date_calendar_start",
			"local_field": "",
			"field_type": "timestamp without time zone",
			"type": "datetime"
		},
		{
			"info": "Order Deadline\nDepicts the date within which the Quotation should be confirmed and converted into a purchase order.",
			"field_name": "date_order",
			"local_field": "order_date",
			"field_type": "timestamp without time zone",
			"type": "datetime"
		},
		{
			"info": "Expected Arrival\nDelivery date promised by vendor. This date is used to determine expected arrival of products.",
			"field_name": "date_planned",
			"local_field": "",
			"field_type": "timestamp without time zone",
			"type": "datetime"
		},
		{
			"info": "Scheduled Date",
			"field_name": "date_planned_mps",
			"local_field": "",
			"field_type": "timestamp without time zone",
			"type": "datetime"
		},
		{
			"info": "Destination Location Type\nTechnical field used to display the Drop Ship Address",
			"field_name": "default_location_dest_id_usage",
			"local_field": "",
			"field_type": "text",
			"type": "selection"
		},
		{
			"info": "Dropship Address\nPut an address if you want to deliver directly from the vendor to the customer. Otherwise, keep empty to deliver to your own company.",
			"field_name": "dest_address_id",
			"local_field": "delivery_address",
			"field_type": "integer",
			"type": "many2one",
			"json_tag": "[1]"
		},
		{
			"info": "Display Name",
			"field_name": "display_name",
			"local_field": "order_id",
			"field_type": "varchar"
		},
		{
			"info": "Arrival\nCompletion date of the first receipt order.",
			"field_name": "effective_date",
			"local_field": "",
			"field_type": "timestamp without time zone",
			"type": "datetime"
		},
		{
			"info": "Fiscal Position",
			"field_name": "fiscal_position_id",
			"local_field": "",
			"field_type": "integer",
			"type": "many2one",
			"json_tag": "[1]"
		},
		{
			"info": "Procurement Group",
			"field_name": "group_id",
			"local_field": "",
			"field_type": "integer",
			"type": "many2one",
			"json_tag": "[1]"
		},
		{
			"info": "Has Message",
			"field_name": "has_message",
			"local_field": "",
			"field_type": "boolean"
		},
		{
			"info": "ID",
			"field_name": "id",
			"local_field": "order_id",
			"local_field2": ["record_id"],
			"field_type": "integer",
			"constraint": ["primary key"]
		},
		{
			"info": "Incoming Shipment count",
			"field_name": "incoming_picking_count",
			"local_field": "",
			"field_type": "integer"
		},
		{
			"info": "Incoterm\nInternational Commercial Terms are a series of predefined commercial terms used in international transactions.",
			"field_name": "incoterm_id",
			"local_field": "delivery_company_id",
			"field_type": "integer",
			"type": "many2one",
			"json_tag": "[1]"
		},
		{
			"info": "Incoterm Location",
			"field_name": "incoterm_location",
			"local_field": "",
			"field_type": "varchar"
		},
		{
			"info": "Bill Count",
			"field_name": "invoice_count",
			"local_field": "",
			"field_type": "integer"
		},
		{
			"info": "Bills",
			"field_name": "invoice_ids",
			"local_field": "",
			"field_type": "integer",
			"type": "many2many",
			"json_tag": "[1]"
		},
		{
			"info": "Billing Status",
			"field_name": "invoice_status",
			"local_field": "",
			"field_type": "text",
			"type": "selection"
		},
		{
			"info": "Is Above Budget",
			"field_name": "is_above_budget",
			"local_field": "",
			"field_type": "boolean"
		},
		{
			"info": "Is Analytic",
			"field_name": "is_analytic",
			"local_field": "",
			"field_type": "boolean"
		},
		{
			"info": "Is Late",
			"field_name": "is_late",
			"local_field": "",
			"field_type": "boolean"
		},
		{
			"info": "Is Shipped",
			"field_name": "is_shipped",
			"local_field": "",
			"field_type": "boolean"
		},
		{
			"info": "Reception Confirmed\nTrue if PO reception is confirmed by the vendor.",
			"field_name": "mail_reception_confirmed",
			"local_field": "",
			"field_type": "boolean"
		},
		{
			"info": "Reception Declined\nTrue if PO reception is declined by the vendor.",
			"field_name": "mail_reception_declined",
			"local_field": "",
			"field_type": "boolean"
		},
		{
			"info": "Reminder Confirmed\nTrue if the reminder email is confirmed by the vendor.",
			"field_name": "mail_reminder_confirmed",
			"local_field": "",
			"field_type": "boolean"
		},
		{
			"info": "Attachment Count",
			"field_name": "message_attachment_count",
			"local_field": "",
			"field_type": "integer"
		},
		{
			"info": "Followers",
			"field_name": "message_follower_ids",
			"local_field": "",
			"field_type": "integer",
			"type": "one2many",
			"json_tag": "[1]"
		},
		{
			"info": "Message Delivery error\nIf checked, some messages have a delivery error.",
			"field_name": "message_has_error",
			"local_field": "",
			"field_type": "boolean"
		},
		{
			"info": "Number of errors\nNumber of messages with delivery error",
			"field_name": "message_has_error_counter",
			"local_field": "",
			"field_type": "integer"
		},
		{
			"info": "SMS Delivery error\nIf checked, some messages have a delivery error.",
			"field_name": "message_has_sms_error",
			"local_field": "",
			"field_type": "boolean"
		},
		{
			"info": "Messages",
			"field_name": "message_ids",
			"local_field": "",
			"field_type": "integer",
			"type": "one2many",
			"json_tag": "[1]"
		},
		{
			"info": "Is Follower",
			"field_name": "message_is_follower",
			"local_field": "",
			"field_type": "boolean"
		},
		{
			"info": "Action Needed\nIf checked, new messages require your attention.",
			"field_name": "message_needaction",
			"local_field": "",
			"field_type": "boolean"
		},
		{
			"info": "Number of Actions\nNumber of messages requiring action",
			"field_name": "message_needaction_counter",
			"local_field": "",
			"field_type": "integer"
		},
		{
			"info": "Followers (Partners)",
			"field_name": "message_partner_ids",
			"local_field": "",
			"field_type": "integer",
			"type": "many2many",
			"json_tag": "[1]"
		},
		{
			"info": "Count of MO Source",
			"field_name": "mrp_production_count",
			"local_field": "",
			"field_type": "integer"
		},
		{
			"info": "My Activity Deadline",
			"field_name": "my_activity_date_deadline",
			"local_field": "",
			"field_type": "date"
		},
		{
			"info": "Order Reference",
			"field_name": "name",
			"local_field": "",
			"field_type": "varchar"
		},
		{
			"info": "Terms and Conditions",
			"field_name": "notes",
			"local_field": "info",
			"field_type": "text",
			"type": "html"
		},
		{
			"info": "On-Time Delivery Rate\nOver the past x days; the number of products received on time divided by the number of ordered products.x is either the System Parameter purchase_stock.on_time_delivery_days or the default 365",
			"field_name": "on_time_rate",
			"local_field": "",
			"field_type": "double",
			"type": "float"
		},
		{
			"info": "Order Lines",
			"field_name": "order_line",
			"local_field": "",
			"field_type": "integer",
			"type": "one2many",
			"json_tag": "[1]"
		},
		{
			"info": "Source Document\nReference of the document that generated this purchase order request (e.g. a sales order)",
			"field_name": "origin",
			"local_field": "",
			"field_type": "varchar"
		},
		{
			"info": "# Vendor Bills",
			"field_name": "partner_bill_count",
			"local_field": "",
			"field_type": "integer"
		},
		{
			"info": "Vendor\nYou can find a vendor by its Name, TIN, Email or Internal Reference.",
			"field_name": "partner_id",
			"local_field": "json_data.company_name",
			"field_type": "integer",
			"type": "many2one",
			"json_tag": "[1]"
		},
		{
			"info": "Vendor Reference\nReference of the sales order or bid sent by the vendor. It's used to do the matching when you receive the products as this reference is usually written on the delivery order sent by your vendor.",
			"field_name": "partner_ref",
			"local_field": "",
			"field_type": "varchar"
		},
		{
			"info": "Payment Terms",
			"field_name": "payment_term_id",
			"local_field": "",
			"field_type": "integer",
			"type": "many2one",
			"json_tag": "[1]"
		},
		{
			"info": "Receptions",
			"field_name": "picking_ids",
			"local_field": "",
			"field_type": "integer",
			"type": "many2many",
			"json_tag": "[1]"
		},
		{
			"info": "Deliver To\nThis will determine operation type of incoming shipment",
			"field_name": "picking_type_id",
			"local_field": "",
			"field_type": "integer",
			"type": "many2one",
			"json_tag": "[1]"
		},
		{
			"info": "Priority",
			"field_name": "priority",
			"local_field": "",
			"field_type": "text",
			"type": "selection"
		},
		{
			"info": "Product",
			"field_name": "product_id",
			"local_field": "",
			"field_type": "integer",
			"type": "many2one",
			"json_tag": "[1]"
		},
		{
			"info": "Project",
			"field_name": "project_id",
			"local_field": "",
			"field_type": "integer",
			"type": "many2one",
			"json_tag": "[1]"
		},
		{
			"info": "Ratings",
			"field_name": "rating_ids",
			"local_field": "",
			"field_type": "integer",
			"type": "one2many",
			"json_tag": "[1]"
		},
		{
			"info": "Receipt Reminder Email\nAutomatically send a confirmation email to the vendor X days before the expected receipt date, asking him to confirm the exact date.",
			"field_name": "receipt_reminder_email",
			"local_field": "",
			"field_type": "boolean"
		},
		{
			"info": "Receipt Status",
			"field_name": "receipt_status",
			"local_field": "",
			"field_type": "text",
			"type": "selection"
		},
		{
			"info": "Days Before Receipt\nNumber of days to send reminder email before the promised receipt date",
			"field_name": "reminder_date_before_receipt",
			"local_field": "",
			"field_type": "integer"
		},
		{
			"info": "Count of source repairs",
			"field_name": "repair_count",
			"local_field": "",
			"field_type": "integer"
		},
		{
			"info": "Number of Source Sale",
			"field_name": "sale_order_count",
			"local_field": "",
			"field_type": "integer"
		},
		{
			"info": "Show Comparison",
			"field_name": "show_comparison",
			"local_field": "",
			"field_type": "boolean"
		},
		{
			"info": "Status",
			"field_name": "state",
			"local_field": "order_state",
			"field_type": "text",
			"type": "selection"
		},
		{
			"info": "Count of Subcontracting Resupply\nCount of Subcontracting Resupply for component",
			"field_name": "subcontracting_resupply_picking_count",
			"local_field": "",
			"field_type": "integer"
		},
		{
			"info": "Tax calculation rounding method",
			"field_name": "tax_calculation_rounding_method",
			"local_field": "",
			"field_type": "text",
			"type": "selection"
		},
		{
			"info": "Tax Country\nTechnical field to filter the available taxes depending on the fiscal country and fiscal position.",
			"field_name": "tax_country_id",
			"local_field": "",
			"field_type": "integer",
			"type": "many2one",
			"json_tag": "[1]"
		},
		{
			"info": "Tax Totals",
			"field_name": "tax_totals",
			"local_field": "",
			"field_type": "blob",
			"type": "binary"
		},
		{
			"info": "Buyer",
			"field_name": "user_id",
			"local_field": "person_id",
			"field_type": "integer",
			"type": "many2one",
			"json_tag": "[1]"
		},
		{
			"info": "Website Messages\nWebsite communication history",
			"field_name": "website_message_ids",
			"local_field": "",
			"field_type": "integer",
			"type": "one2many",
			"json_tag": "[1]"
		},
		{
			"info": "Last Updated on",
			"field_name": "write_date",
			"local_field": "modify_time",
			"field_type": "timestamp without time zone",
			"type": "datetime"
		},
		{
			"info": "Last Updated by",
			"field_name": "write_uid",
			"local_field": "modify_user",
			"field_type": "integer",
			"type": "many2one",
			"json_tag": "[1]"
		}
	]
}
