Table SERIALTRC
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| SERIALTRC | SRT | Serial traceability | Geode GX | SRN |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| SRT0 | FCY+DEP+SRTNUM+ITM+SRN+DBL+LIN | No | |
| SRT1 | FCY+DEP+ITM+SRN+DBL+LIN+SRTNUM | No | |
| SRT2 | FCY+DEP+INPNUM+INPLIN+ITM+SRN+DBL+LIN+SRTNUM | No | |
| SRT3 | FCY+DEP+DLONUM+DLOLIN+ITM+SRN+DBL+LIN+SRTNUM | No | |
| SRT4 | FCY+DEP+ADJNUM+ITM+SRN+DBL+LIN+SRTNUM | No | |
| SRT5 | FCY+DEP+OUTADJNUM+ITM+SRN+DBL+LIN+SRTNUM | No | |
| SRT6 | FCY+DEP+MVTNUMI+ITM+SRN+DBL+LIN+SRTNUM | No | |
| SRT7 | FCY+DEP+MVTNUMO+ITM+SRN+DBL+LIN+SRTNUM | No | |
| SRT8 | FCY+DEP+MVTNUMT+ITM+SRN+DBL+LIN+SRTNUM | No | |
| SRT9 | FCY+DEP+RPNNUM+ITM+SRN+DBL+LIN+SRTNUM | No | |
| SRT10 | FCY+DEP+SKONUM+ITM+SRN+DBL+LIN+SRTNUM | No | |
| SRT11 | FCY+DEP+GSNNUM+ITM+SRN+DBL+LIN+SRTNUM | No | |
| SRT12 | FCY+DEP+GSNPARENT+ITM+SRN+DBL+LIN+SRTNUM | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ADD | Address | SLO | [SLO]SLO0=[SRT]ADD | BSRA | ||||
| ADJNUM | Input adjustment | AJM | [AJM]AJM0=[SRT]ADJNUM | BSRA | ||||
| AUUID | Single identifier | AUUID | ||||||
| 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=[SRT]DLONUM | BSRA | ||||
| FCY | Site | FCY | [FCY]FCY0=FCY | Block | ||||
| GSNNUM | Serial group | GSN | [GSN]GSN0=[SRT]GSNNUM | BSRA | ||||
| GSNPARENT | Parent group | GSN | [GSN]GSN0=[SRT]GSNPARENT | BSRA | ||||
| HISPTR | Archive | L | 8 | |||||
| INPDAT | Receipt date | D | ||||||
| INPLIN | Line no. | C | 4 | |||||
| INPNUM | Input no | INP | [INH]INH0=[SRT]INPNUM | BSRA | ||||
| ITM | Product | ITM | [ITM]ITM0=[SRT]ITM | BSRA | ||||
| LIN | Occurrence | C | 4 | |||||
| MVTNUMI | Input mvt. | INM | ||||||
| MVTNUMO | Output mvt. | OUP | [OUM]OUM0=[SRT]MVTNUMO | BSRA | ||||
| MVTNUMT | Transfer mvt. | TRM | [TRM]TRM0=[SRT]MVTNUMT | BSRA | ||||
| ORIADD | Origin address | SLO | [SLO]SLO0=[SRT]ORIADD | BSRA | ||||
| ORISKO | Origin object | SKO | [SKO]SKO0=[SRT]ORISKO | BSRA | ||||
| ORISTO | Origin store | STO | [STO]STO0=[SRT]ORISTO | BSRA | ||||
| OUTADJNUM | Output adjustment | AJM | [AJM]AJM0=[SRT]OUTADJNUM | BSRA | ||||
| OUTDAT | Output date | D | ||||||
| PKONUM | PO no | PKP | [PKO]PKO0=[SRT]PKONUM | BSRA | ||||
| PRCNUM | Parcel no. | PRC | [PAC]PAC0=[SRT]PRCNUM | BSRA | ||||
| RPNDAT | Transfer date | D | ||||||
| RPNNUM | Transfer no | RPN | [TRM]TRM0=[SRT]RPNNUM | BSRA | ||||
| SKONUM | Stock object | SKO | [SKO]SKO0=[SRT]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=[SRT]SRTNUM | BSRA | ||||
| SRTTYP | Operation type | M | 15 | 508 | ||||
| STLNUM | SL no | STL | [STL]STL0=[SRT]STLNUM | BSRA | ||||
| STO | Store | STO | [STO]STO0=[SRT]STO | BSRA | ||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 | |||||
| VLDOPE | Valid operator | OPE | [OPE]OPE0=[SRT]VLDOPE | BSRA |