Table TMPSRT
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| TMPSRT | SRTT | Serial log temporary table | Geode GX | SRN |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| SRT0 | IDENT+FCY+DEP+KEYORD | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ADD | Address | SLO | [SLO]SLO0=[SRTT]ADD | BSRA | ||||
| ADJNUM | Input adjustment | AJM | [AJM]AJM0=[SRTT]ADJNUM | BSRA | ||||
| AUUID | Single identifier | AUUID | ||||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| DBL | Double | C | 4 | |||||
| DEP | Depositor | DEP | [DEP]DEP0=FCY;DEP | Block | ||||
| DLOLIN | Line no. | C | 4 | |||||
| DLONUM | DO no | DLO | [DOH]DOH0=[SRTT]DLONUM | BSRA | ||||
| FCY | Site | FCY | [FCY]FCY0=FCY | Block | ||||
| GSNNUM | Serial group | GSN | [GSN]GSN0=[SRTT]GSNNUM | BSRA | ||||
| GSNPARENT | Parent group | GSN | [GSN]GSN0=[SRTT]GSNPARENT | BSRA | ||||
| HISPTR | Archive | L | 8 | |||||
| IDENT | Identifier | A | 15 | |||||
| INPDAT | Receipt date | D | ||||||
| INPLIN | Line no. | C | 4 | |||||
| INPNUM | Input no | INP | [INH]INH0=[SRTT]INPNUM | BSRA | ||||
| ITM | Product | ITM | [ITM]ITM0=[SRTT]ITM | BSRA | ||||
| KEYORD | Calculated sort key | A | 210 | |||||
| LIN | Occurrence | C | 4 | |||||
| MVTNUMI | Input mvt. | INM | ||||||
| MVTNUMO | Output mvt. | OUP | [OUM]OUM0=[SRTT]MVTNUMO | BSRA | ||||
| MVTNUMT | Transfer mvt. | TRM | [TRM]TRM0=[SRTT]MVTNUMT | BSRA | ||||
| NAM | Operator name | NAM | ||||||
| ORIADD | Origin address | SLO | [SLO]SLO0=[SRTT]ORIADD | BSRA | ||||
| ORISKO | Origin object | SKO | [SKO]SKO0=[SRTT]ORISKO | BSRA | ||||
| ORISTO | Origin store | STO | [STO]STO0=[SRTT]ORISTO | BSRA | ||||
| OUTADJNUM | Output adjustment | AJM | [AJM]AJM0=[SRTT]OUTADJNUM | BSRA | ||||
| OUTDAT | Output date | D | ||||||
| PKONUM | PO no | PKP | [PKO]PKO0=[SRTT]PKONUM | BSRA | ||||
| PRCNUM | Parcel no. | PRC | [PAC]PAC0=[SRTT]PRCNUM | BSRA | ||||
| RPNDAT | Transfer date | D | ||||||
| RPNNUM | Transfer no | RPN | [TRM]TRM0=[SRTT]RPNNUM | BSRA | ||||
| SKONUM | Stock object | SKO | [SKO]SKO0=[SRTT]SKONUM | BSRA | ||||
| SRN | Serial number | SRN | ||||||
| SRNDATTIM | Date time | ADATIM | ||||||
| SRNLIB1 | Free 1 | SRNLIB | ||||||
| SRNLIB2 | Free 2 | SRNLIB | ||||||
| SRNLIB3 | Free 3 | SRNLIB | ||||||
| SRNLIB4 | Free 4 | SRNLIB | ||||||
| SRNLIB5 | Free 5 | SRNLIB | ||||||
| SRTNUM | Operation log | SRT | [SRT]SRT0=[SRTT]SRTNUM | BSRA | ||||
| SRTTYP | Operation type | M | 15 | 508 | ||||
| STLNUM | SL no | STL | [STL]STL0=[SRTT]STLNUM | BSRA | ||||
| STO | Store | STO | [STO]STO0=[SRTT]STO | BSRA | ||||
| UPDATTIM | Date time | ADATIM | ||||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 | |||||
| VLDOPE | Valid operator | OPE | [OPE]OPE0=[SRTT]VLDOPE | BSRA |