Meta data (trigger file)

File name	control.csv
Importance	Required
Description	Information about the interface and data extraction. This data must be artificially constructed. To ensure that Netstock does not begin the batch process before complete files are available, it is necessary to provide either MD5 checksums (preferable) 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 relating to the Key field

Key	Importance	Value
INTERFACE_VERSION	Required	The data interface version Current version is 2.0.8
EXTRACTION_DATE	Required	The date when the data is extracted YYYY/MM/DD FORMAT
EXTRACTION_TIME	Required	The time (in 24-hour format) when the data is extracted
MD5_SALES	Preferred	MD5 checksum value for the sales.csv file
MD5_STOCK	Preferred	MD5 checksum for the stock.csv file
MD5_LOCATION MD5_SUPPLIER MD5_MASTER MD5_GROUP MD5_PO MD5_CO MD5_TRANSFER MD5_POHIST MD5_BOM MD5_SUPERSESSIONS	Preferred	MD5 checksum for each of the other files that are being supplied IF MD5 VALUES CANNOT BE PROVIDED, USE VALIDATION TOTALS INSTEAD
VALIDATION_STOCK	If Applicable	Sum of "Stock on Hand" (column 7) in stock.csv Only required if MD5 values cannot be provided. Sum value must precisely match the data in the referenced file.
VALIDATION_SALES	If Applicable	Sum of "Sales Quantity" (column 4, summary format) in sales.csv Only required if MD5 values cannot be provided. Sum value must precisely match the data in the referenced file.
HOST_SYSTEM_NAME	Preferred	The name of the host system (e.g. ACCPAC) Netstock will advise of the precise value to use for each system
HOST_SYSTEM_VERSION	Preferred	The version of the host system