Overview
The commodity 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.
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 |
| Deductibility |
Deductibility |
FALSE |
FALSE |
string(255) |
fully_deductible, partially_deductible, not_deductible |
| Category |
Category |
FALSE |
FALSE |
string(255) |
goods, services |
| Subcategory |
Subcategory |
FALSE |
FALSE |
string(255) |
raw_materials, investment_goods, services_exceptions |
| Acct |
GL Account (for defaulting) |
FALSE |
FALSE |
string(1024) |
any |
