| DB | Areas | X-idx | Tables | Sequences | <- | inv-imcde -> | HtmlDict 11 |
Commodity Code Categories
| Area | ProdData |
|---|---|
| Dumpname | commodit |
| Label | Commodity Code Categories |
| Val.exp | ? |
| Val.msg |
| Event | Procedure | Overr | CRC |
|---|---|---|---|
| DELETE | trigs/decommodit.t | ||
| WRITE | trigs/wrcommodit.t |
| Order | Field Name | x | Label | Datatype | Format | Initial | Mand | Description |
|---|---|---|---|---|---|---|---|---|
| 64 | alpha-fct | X | Alpha Factor | decimal-3 | .999 | 0 | ||
| 68 | avg-no-prd | X | Average No Periods | integer | >9 | 0 | ||
| 66 | beta-fct | X | Beta Factor | decimal-3 | .999 | 0 | ||
| 74 | bucket-size | X | Bucket Size | integer | 9 | 0 | ||
| 10 | commodity-cde | X | Category | character | X(6) | |||
| 250 | def-disc-perc | X | Default Discount Percent | decimal-2 [5] | >>9.99 | 0 | ||
| 62 | fc-policy | X | F/C Policy | integer | 9 | 0 | ||
| 76 | fc-prd | X | F/C Periods | integer | >9 | 0 | ||
| 69 | fc-wgt | X | F/C Weight | decimal-2 [12] | 9.99 | 0 | ||
| 280 | gp-perc | X | GP Perc | decimal-2 | >>9.99 | 0 | ||
| 110 | inv-acct | X | Department | character | x(4) | 0 | ||
| 40 | lot-ctrl | X | default Batch Control | logical | Yes/No | No | ||
| 310 | lot-days | X | Lot Days | integer | >>9 | 0 | ||
| 270 | markup-perc | X | Markup Perc | decimal-2 | >>9.99 | 0 | ||
| 150 | max-markup-perc | X | Max Markup Perc | decimal-2 | >>9.99 | 0 | ||
| 140 | min-markup-perc | X | Min Markup Perc | decimal-2 | >>9.99 | 0 | ||
| 60 | neg-cde | X | Negotiator Code | character | x(3) | |||
| 70 | ord-policy | X | Default Ord Policy | integer | 9 | 0 | ||
| 72 | ord-qty | X | No of Prd | decimal-0 | >>9 | 0 | ||
| 71 | ord-qty-ind | X | Qty/Prd Ind | logical | Qty/Prd | Qty | ||
| 290 | prod-unit | X | Production Unit | integer | 99999 | 0 | ||
| 300 | reord-perc | X | Reord Level | decimal-2 | >>9.99 | 0 | ||
| 260 | sell-by-days | X | Sell By Days | integer | >>9 | 0 | ||
| 20 | short-desc | X | Description | character | X(30) | |||
| 30 | source | X | Default Source | character | ! | |||
| 50 | stat-ctrl | X | Default Stat Ctrl | logical | Yes/No | No | ||
| 220 | upd-date | X | Updated | date | 99/99/9999 | ? | ||
| 230 | upd-time | X | At | integer | 99999 | 0 | ||
| 240 | upd-user-id | X | By | character | x(12) |
| Index name | Flags | Fields | Datatype |
|---|---|---|---|
| commodity-cde | P U | commodity-cde (+) | character |
| inv-acct | inv-acct (+) | character | |
| short-desc (+) | character | ||
| short-desc | short-desc (+) | character |
| + = Ascending | - = Descending | P = Primary | U = Unique | I = Inactive | W = Wordindex |
| Parent tables |
|---|
| inv-invacct |
| Child tables |
|---|
| inv-item pur-item-vend |
| generated 24-6-2026 08:40 |