This file layout is used to import a list of commodity codes using a tab-delimited file.
Field | Length | Type | Notes |
---|---|---|---|
Group ID | 3 | Char | If the value is zero (0, 00, or 000), then the column defaults to blank in the database. |
Commodity Type | 8 | Char | If the value is zero (0, 00, 000, 0000, 00000, 000000, 0000000, or 00000000), then the column defaults to blank in the database. |
Description | 30 | Char | If the value exceeds 30, the value is truncated to 30 when saved to the database. |
Threshold | 999999999.99 | Numeric | The value must be positive. If not supplied, the column defaults to zero in the database. |
Notes: