Commodity Import

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.

Note: Name is the key.

Commodity

Field Name Required Field Unique? Field Type Field Description Possible Values
Name Yes Yes string(255) Commodity Name
ID No No integer Commodity ID
Active Yes No boolean Is the commodity active? true, false
Parent commodity No No Parent Commodity Name (If using hierarchical commodities)
Deductibility No No string(255) Deductibility fully_deductible, partially_deductible, not_deductible
Category No No string(255) Category goods, services
Subcategory No No string(255) Subcategory raw_materials, investment_goods, services_exceptions
Preferred No No string(255) Preferred Yes, No, Automatic, Always, Never