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 | [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 |