Table MATERIAL
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| MATERIAL | MAT | Materials | Geode GX |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| MAT0 | FCY+MAT | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| FCY | Site | FCY | [FCY]FCY0=[MAT]FCY | Block | ||||
| MAT | Material | MAT | [MAT]MAT0=FCY;MAT | Delete | ||||
| MATDESAXX | Description | AX3 | ||||||
| MATSHOAXX | Short description | AX1 | ||||||
| MATTYP | Material type | MTT | [MTT]MTT0=FCY;MATTYP | Block | ||||
| MAXCUQ | Max CU | L | 8 | |||||
| MAXVOL | Max volume | QTY | ||||||
| MAXWEI | Max.wght | QTY | ||||||
| TRFADD | Transfer address | SLO | [SLO]SLO0=FCY;TRFSTO;TRFADD | Block | ||||
| TRFSTO | Transfer store | STO | [STO]STO0=FCY;TRFSTO | Block | ||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 |