In this Master data element, all information regarding commodities is managed. An Agiboo consultant must help set up initial commodity Master data to insure that it is properly configured.
Data structure
Commodity Master data is kept in a database table called Commodities. Below the Commodities master table is a so-called child table, which shows the commodity properties. Under the commodity properties, commodity property values can be found. To visualize this:
Master: Commodity
Child: Commodity Properties
Value: Commodity property values
Examples
Master |
White sugar/ Cocoa beans / Coffee Arabica |
Child |
Properties are records which can be selected on a physical contract. These can be items such as: product quality grade screen origin crop year. |
Value |
These values will appear in the drop-down boxes as values which can be selected for a certain contract record. These value match the above child categories: product - EU no2 quality - Good grade - fermented main crop screen - 18 crop year - 2017-2018 |
Select the Add new record button from the Commodity Master data screen to add a new record.