| DB | Areas | X-idx | Tables | Sequences | <- inv-comboitem | inv-commodity -> | HtmlDict 11 |
Std defaults for commodities in a business unit
| Area | ProdData |
|---|---|
| Dumpname | commbu |
| Label | Std defaults for commodities in a business unit |
| Val.exp | ? |
| Val.msg |
| Order | Field Name | x | Label | Datatype | Format | Initial | Mand | Description |
|---|---|---|---|---|---|---|---|---|
| 44 | alpha-fct | X | Alpha Factor | decimal-3 | .999 | 0 | ||
| 20 | area-cde | X | Area Code | character | x(3) | |||
| 48 | avg-no-prd | X | Average No Periods | integer | >9 | 0 | ||
| 46 | beta-fct | X | Beta Factor | decimal-3 | .999 | 0 | ||
| 140 | bonus-policy | X | Bonus Policy | character | ! | N | ||
| 54 | bucket-size | X | Bucket Size | integer | 9 | 0 | ||
| 100 | buyer-cde | X | Buyer Code | character | x(2) | |||
| 10 | commodity-cde | X | Category | character | X(6) | |||
| 30 | cost-cde | X | Cost Code | character | x(4) | |||
| 110 | cost-prc-policy | X | Cost Prc Policy | character | ! | |||
| 36 | deliv-lt | X | Deliv Lt | integer | >>9 | 0 | ||
| 150 | disc-perc | X | Discount Percentage | decimal-1 | >>9.9 | 0 | ||
| 42 | fc-policy | X | F/C Policy | integer | 9 | 0 | ||
| 56 | fc-prd | X | F/C Periods | integer | >9 | 0 | ||
| 49 | fc-wgt | X | F/C Weight | decimal-2 [12] | 9.99 | 0 | ||
| 120 | list-prc-policy | X | List Prc Policy | character | ! | |||
| 160 | markup-perc | X | Markup Perc | decimal-2 | >>9.99 | 0 | ||
| 32 | ord-lt | X | Order Lt | integer | >>9 | 0 | ||
| 50 | ord-policy | X | Order Policy | integer | 9 | 0 | ||
| 52 | ord-qty | X | No of Prd | decimal-0 | >>9 | 0 | ||
| 51 | ord-qty-ind | X | Qty/Prd Ind | logical | Qty/Prd | Qty | ||
| 165 | primary-loc | X | Prime Loc | character | X(3) | |||
| 34 | prom-lt | X | Promised Lt | integer | >>9 | 0 | ||
| 200 | segment-cde | X | Segment Code | character | x(12) | |||
| 130 | sls-prc-policy | X | Sls Prc Policy | character | ! | |||
| 180 | upd-date | X | Updated | date | 99/99/9999 | ? | ||
| 190 | upd-time | X | At | integer | 99999 | 0 | ||
| 170 | upd-user-id | X | By | character | x(12) |
| Index name | Flags | Fields | Datatype |
|---|---|---|---|
| commodity-bu | P U | commodity-cde (+) | character |
| area-cde (+) | character | ||
| cost-cde (+) | character |
| + = Ascending | - = Descending | P = Primary | U = Unique | I = Inactive | W = Wordindex |
| Parent tables |
|---|
| inv-combocom inv-comboitem inv-commodity inv-segmentbu pur-buyerrel |
| generated 24-6-2026 08:25 |