Table SUPPORTH
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| SUPPORTH | SPH | Support | Geode GX | SPM |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| SPR0 | FCY+SPRNUM | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ADD | Address | SLO | [SLO]SLO0=FCY;STO;ADD | Block | ||||
| AUUID | Single identifier | AUUID | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[SPH]CREUSR | Other | ||||
| ENAFLG | Active | M | 4 | 1 | ||||
| FCY | Site | FCY | [FCY]FCY0=[SPH]FCY | Block | ||||
| ITM | Product | ITM | [ITM]ITM0=[SPH]ITM | BSRA | ||||
| LOT | Lot no. | A | 20 | |||||
| OWNCPY | Company | CPY | [CPY]CPY0=[SPH]OWNCPY | Block | ||||
| OWNDVR | Supplier | DVR | [DVR]DVR0=FCY;OWNDVR | Block | ||||
| OWNFCY | Site | FCY | [FCY]FCY0=[SPH]OWNFCY | Block | ||||
| SNGITMMGT | Single item | M | 4 | 1 | ||||
| SNGLOTMGT | Single lot | M | 4 | 1 | ||||
| SPRNUM | SPR | [SPH]SPR0=FCY;SPRNUM | Delete | |||||
| SPROWNTYP | M | 15 | 484 | |||||
| SPRPARENT | Relative | SPR | [SPH]SPR0=FCY;SPRPARENT | Block | ||||
| SPRPERM | Permanent | M | 4 | 1 | ||||
| SPRSKIND | Undifferentiated stock | M | 4 | 1 | ||||
| SPRSTATUS | M | 15 | 485 | |||||
| SPRT | SPRT | [SPRT]SPRT0=FCY;SPRT | Block | |||||
| STO | Store | STO | [STO]STO0=FCY;STO | Block | ||||
| UFTPIC | Undifferentiated picking | M | 4 | 1 | ||||
| UFTSKO | Undifferentiated stock | M | 4 | 1 | ||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[SPH]UPDUSR | Other |