business:importcommoditycodes
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
| business:importcommoditycodes [2019/08/14 18:26] – emoreno | business:importcommoditycodes [2019/08/14 20:45] – emoreno | ||
|---|---|---|---|
| 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.| | ||
business/importcommoditycodes.txt · Last modified: 2022/09/30 15:32 by 127.0.0.1