This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
business:importcommoditycodes [2019/08/14 18:26] – emoreno | business:importcommoditycodes [2022/09/30 15:32] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 2: | Line 2: | ||
<WRAP round intro> | <WRAP round intro> | ||
- | This file layout is used to import a list of commodity codes. | + | This file layout is used to import a list of commodity codes using a tab-delimited file. |
</ | </ | ||
Line 8: | Line 8: | ||
|Group ID|3|Char |If the value is zero (0, 00, or 000), then the column defaults to blank in the database.| | |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.| | |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.| | + | |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.| | |Threshold|999999999.99|Numeric|The value must be positive. If not supplied, the column defaults to zero in the database.| | ||