{
	"name": "query/manager/product/stock/stock_value_report_add_events.json",
	"table": [
		{
			"record_type": [""],
			"table": "stock"
		}
	],
	"database": "4d",
	"parameter": {
		"product_arr": [
				
			],
		"target_date": "",
		"type_arr": ["LI"]
	},
	"field": [
		"st.product_id",
		"st.create_time",
		"st.json_data.amount__unit",
		"st.stock_type",
		"st.json_data.purchase_price__unit",
		"st.json_data.cost_price__unit",
		"st.currency_id",
		"st.json_data.foreign_purchase_price"
	],
	"order": [
		"st.create_time",
		"<",
		"st.create_time",
		"<",
		"st.record_id",
		"<"
	],
	"query": [
		["st.create_time", "<=", "target_date"],
		"and",
		["st.product_id", "in", "product_arr"],
		"and",
		["st.stock_type", "in", "type_arr"]
	]
}