Table SFTTXN
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| SFTTXN | SFTX | Shop floor transactions | Manufacturing |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| SFT0 | EMPNUM+SFTTYP+VCRNUM+SFTSEQ | No | |
| SFT1 | VCRNUM+OPENUM+CLEFLG | Yes | |
| SFT2 | UTCENDDATTIM+VCRNUM+OPENUM+EMPNUM+SFTTYP | Yes | |
| SFT3 | UTCSTRDATTIM+VCRNUM+OPENUM+MACFLG | Yes | |
| SFT4 | VCRNUM+OPENUM | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ACTENDDATTIM | End | ADATIM | ||||||
| ACTSTRDATTIM | Start | ADATIM | ||||||
| AUUID | Single identifier | AUUID | ||||||
| BRKTXN | Break code | AUUID | ||||||
| CLEFLG | Closed | M | 4 | 1 | ||||
| CPLQTY | Completed qty. | QTY | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[SFTX]CREUSR | Other | ||||
| DURATION | Duration | DCB | 9.2 | |||||
| EMPNUM | Employee ID | TMA | 4 | [TMA]TMA0=[SFTX]EMPNUM | Block | |||
| ERRFLG | Error | M | 4 | 1 | ||||
| ERRMSG | Error msg | A | 200 | |||||
| FCY | Site | FCY | [FCY]FCY0=[SFTX]FCY | Block | ||||
| INDREF | Indirect references | A | 3 | |||||
| INDTYP | Category type | M | 15 | 2417 | ||||
| LCENTER | Labor center | WST | ||||||
| MACFLG | Machine | M | 4 | 1 | ||||
| NUMJOBS | Number of activities | L | 8 | |||||
| NUMMAC | Machine included | M | 4 | 1 | ||||
| OPENUM | Operation number | OPE | ||||||
| OPEUOM | Entry unit | UOM | [TUN]TUN0=[SFTX]OPEUOM | Block | ||||
| REJCPLQTY | Rejected qty. | QTY | ||||||
| SCANUM | Rejection | C | 4 | |||||
| SETUPSTOP | Setup stop | C | 1 | |||||
| SFTSEQ | Sequence | L | 4 | |||||
| SFTTYP | Type | M | 4 | 2416 | ||||
| SHIFT | Shift code | SHFT | [SFTS]SHF0=[SFTX]SHIFT | Block | ||||
| SHIFTDAT | Shift date | D | ||||||
| STRTXNUUID | Transaction code | AUUID | ||||||
| SUMEMP | Number of employees | L | 8 | |||||
| TEAMNUM | Team | TMA | [TMA]TMA0=[SFTX]TEAMNUM | Block | ||||
| TXNUUID | Transaction code | AUUID | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[SFTX]UPDUSR | Other | ||||
| UTCENDDATTIM | End | ADATIM | ||||||
| UTCOFFSET | Time zone difference | DCB | 9.2 | |||||
| UTCSTRDATTIM | Start | ADATIM | ||||||
| VCRNUM | Document | VCR | ||||||
| WCENTER | Work center | WST |