Table SUPPORTL
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| SUPPORTL | SPL | Support | Geode GX | SPM |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| SPL0 | AUUID | No | |
| SPL1 | FCY+DEP+INPNUM+INPLIN+MVTNUM | Yes | |
| SPL2 | FCY+RCPNUM+RCPLIN | Yes | |
| SPL3 | FCY+RCPNUM+RCPLIN+MVTLIN | Yes | |
| SPL4 | FCY+SPRNUM | Yes | |
| SPL5 | FCY+DEP+INPNUM+INPLIN | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[SPL]CREUSR | Other | ||||
| CTR | Container | ITC | [ITC]ITC0=FCY;DEP;ITM;CTR | Block | ||||
| DEP | Depositor | DEP | [DEP]DEP0=FCY;DEP | Block | ||||
| DLOLIN | Line no. | C | 4 | |||||
| DLONUM | DO number | DLO | [DOH]DOH0=FCY;DEP;DLONUM | Delete | ||||
| FCY | Site | FCY | [FCY]FCY0=FCY | Block | ||||
| INPLIN | Line no. | C | 4 | |||||
| INPNUM | Input no | INP | [INH]INH0=FCY;DEP;INPNUM | Delete | ||||
| INPSKIP | M | 4 | 1 | |||||
| ITM | Product | ITM | [ITM]ITM0=[SPL]ITM | BSRA | ||||
| LIN | Line no. | C | 4 | |||||
| LOT | Lot no. | A | 20 | |||||
| MVTLIN | Receipt mvt. no. | C | 4 | |||||
| MVTNUM | Movement no | INM | ||||||
| MVTONUM | Output mvt. issue | OUP | [OUM]OUM0=FCY;DEP;MVTNUM | Delete | ||||
| QTY | Quantity | QTA | ||||||
| RCPLIN | Receipt line no | C | 4 | |||||
| RCPNUM | Receipt | RCP | [RCH]RCH0=FCY;RCPNUM | Delete | ||||
| SKONUM | Number | SKO | [SKO]SKO0=FCY;SKONUM | Delete | ||||
| SPRLVL | Level | C | 4 | |||||
| SPRNUM | SPR | [SPH]SPR0=FCY;SPRNUM | Block | |||||
| SRN | Serial number | SRN | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[SPL]UPDUSR | Other |