Meta Data (Trigger File)

File name	`control.csv`
Importance	Required
Description	Contains meta information about the interface and data extraction. ⚠️ This file must be artificially constructed. To ensure Netstock does not begin processing before complete files are available, you must provide either MD5 checksums (preferred) or validation totals.
Example data	`INTERFACE_VERSION,2.0.8` `EXTRACTION_DATE,2014/11/06` `EXTRACTION_TIME,13:32:59` `HOST_SYSTEM_NAME,TheERPname` `HOST_SYSTEM_VERSION,36A` `MD5_STOCK,07f7251c325609f41dddec3a948e06a0` `MD5_SALES,7070be3d7c8196bd958b35254d3732ba`

Columns

Pos.	Name	Type	Importance	Description
1	Key	Char	Required	A name to identify the type of data in the Value field
2	Value	Char	Required	The value corresponding to the Key field

Key	Importance	Value
INTERFACE_VERSION	Required	Data interface version. Current version = 2.0.8
EXTRACTION_DATE	Required	Date of data extraction (`YYYY/MM/DD`)
EXTRACTION_TIME	Required	Time of extraction in 24-hour format
MD5_SALES	Preferred	MD5 checksum for `sales.csv`
MD5_STOCK	Preferred	MD5 checksum for `stock.csv`
MD5_LOCATION	Preferred	MD5 checksum for `location.csv`
MD5_SUPPLIER	Preferred	MD5 checksum for `supplier.csv`
MD5_MASTER	Preferred	MD5 checksum for `master.csv`
MD5_GROUP	Preferred	MD5 checksum for `group.csv`
MD5_PO	Preferred	MD5 checksum for `po.csv`
MD5_CO	Preferred	MD5 checksum for `co.csv`
MD5_TRANSFER	Preferred	MD5 checksum for `transfer.csv`
MD5_POHIST	Preferred	MD5 checksum for `pohist.csv`
MD5_BOM	Preferred	MD5 checksum for `bom.csv`
MD5_SUPERSESSIONS	Preferred	MD5 checksum for `supersessions.csv`
VALIDATION_STOCK	If Applicable	Sum of Stock on Hand (col 7) in `stock.csv`. Only required if MD5 values cannot be provided.
VALIDATION_SALES	If Applicable	Sum of Sales Quantity (col 4, summary format) in `sales.csv`. Only required if MD5 values cannot be provided.
HOST_SYSTEM_NAME	Preferred	The host system name (e.g., ACCPAC). Netstock will advise the exact value to use.
HOST_SYSTEM_VERSION	Preferred	The host system version.

Forget about these 👇 😞 😐 😃 Have your say here!