Commodity Import
Overview
The Approval chains Import process reads files from the ./Incoming/Commodity/ in the SFTP. These files will be moved to the archive folder located at ./Incoming/Archive/Commodity/ before being processed in Alpha-Numeric order.
Name is the key.
Commodity Columns
| Column Name | Description | Req'd | Unique | Type | Allowable Values |
|---|---|---|---|---|---|
| Name* | The name of the commodity | TRUE | TRUE | string(255) | any |
| ID | Commodity ID | FALSE | TRUE | integer(11) | any |
| Active* | If the commodity is active or not | TRUE | FALSE | boolean | true, false |
| Parent commodity | The name of the Parent Commodity. Can also be left blank if this commodity is not a child. | FALSE | FALSE | integer(11) | any |