Transfer Purchase Orders

This schema allows you to import purchase orders so that you can reflect purchase orders from your system to your account of Inspectorio QRM. Purchase orders include information about styles, items/products, cartons, quantities, etc. Your end-users can then use them on the Platform. Here is the provided information formatted as a Markdown table:

General Information

Attribute	Properties	Description	Example
PO_Number	Required, Unique	Unique identifier of a Purchase Order in your account of Inspectorio SIGHT. Note that the same PO Number can be created via different data sources (Manual, API Integration, etc.).	123-1
OPO_Number		Secondary PO Number for your own purpose. It can be used as the PO Number provided by your client, or the one registered in another system of yours, etc.	123
Shipment_Date		Format must be yyyy-mm-ddThh:mm:ssZ (UTC format) or HH:mm:ss p.	2018-01-15T01:12:55Z 8/22/2018 12:00:00 AM
Shipment_End_Date		This field can be blank, but if it is not blank, then it must follow DateTime format: yyyy-mm-ddThh:mm:ssZ.	2019-06-03T20:15:01Z
Data_Provider_ID		Organization ID of the data provider. The value will be retrieved in your organizations on Inspectorio Sight Platform and validated from the account of the specified data provider. In order to make your own organization the data provider of a purchase order, you can specify the value "data_provider".	R123456 V654321 data_provider
Brand_Retailer_ID		Precondition: must be configured in your Inspectorio's account.	retailer_1
Supplier_ID	Required	Precondition: must be configured in your Inspectorio's account.	supplier_1
Factory_ID		Precondition: must be configured in your Inspectorio's account.	factory_1
PO_Type		Precondition: must be configured in your Inspectorio's account.	Replenishment
PO_Source		Indicate the source of materials (produced by domestic vendors or imported from vendors outside the country).	Domestic
PO_Status		Status of a purchase order. Possible values: canceled	canceled
PO_ClientCreatedDate		Format must be yyyy-mm-dd.	2019-06-03
PO_EventName		The corresponding event's name of the purchase order.

Items

Attribute	Properties	Description	Example
Item_ID	Required	Validation: must be unique for a combination of Color and Size.	123-Blue-S 123-01-02
Style_ID	Required	Identifier of a style that belongs to an item.	321-123
Product_Line_ID	Required	Precondition: must be configured in your Inspectorio's account.	product_line_1
Product_Category_ID	Required	Precondition: must be configured in your Inspectorio's account.	product_category_1
Color	Required	The color of the item.	Blue
Size	Required	The size of the item.	S
Brand_ID	Precondition: must be configured in your Inspectorio's account.		brand_1
Order_Quantity	Required	The ordered quantity of the item.	107
Shipment_Term		Shipment_Term is an optional field enabling the possibility to specify the division of responsibilities, costs, and risks for transporting goods between buyer and seller in the client's Purchase Order system. This field follows string format.

Cartons

Attribute	Properties	Description	Example
Packing_Type	Required	Possible values: SOLID, ASSORTMENT.	ASSORTMENT
Case_Pack	If Packing_Type = SOLID	Number of items per Solid carton.	6
Packing_Type_ID	Required if Packing_Type = ASSORTMENT	Unique identifier of an assortment carton.	ASTMT-1231
Order_Carton_Quantity	Required if Packing_Type = ASSORTMENT	Quantity of ordered cartons.	1
Configuration	Required if Packing_Type = ASSORTMENT	Number of items per Assortment carton.	35