Table SFTTXNH
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| SFTTXNH | SFTH | Shop floor trans. history | Manufacturing |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| SFT0 | EMPNUM+SFTTYP+VCRNUM+SFTSEQ+HISSEQ | No | |
| SFT1 | UTCSTRDATTIM+VCRNUM+OPENUM+MACFLG | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ACTENDDATTIM | End | ADATIM | ||||||
| ACTSTRDATTIM | Start | ADATIM | ||||||
| AUUID | Single identifier | AUUID | ||||||
| CHGRAT | Labor rate | DCB | 12.2 | |||||
| CLEFLG | Closed | M | 4 | 1 | ||||
| CPLLAB | Actual labor W/C | WST | ||||||
| CPLQTY | Completed qty. | QTY | ||||||
| CPLWST | Actual work center | WST | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[SFTH]CREUSR | Other | ||||
| DURATION | Duration | DCB | 9.2 | |||||
| EMPNUM | Employee ID | TMA | [TMA]TMA0=[SFTH]EMPNUM | Block | ||||
| HISSEQ | History sequence | L | 8 | |||||
| INDREF | Indirect references | INDREF | [SFTIR]SFTAG0=[SFTH]INDREF | Block | ||||
| INDTYP | Category type | M | 15 | 2417 | ||||
| LABCOE | Labor factor | DCB | 3.3 | |||||
| LCENTER | Labor center | WST | ||||||
| MACFLG | Machine | M | 4 | 1 | ||||
| MFGCREDAT | Date created | D | ||||||
| MFGFCY | Production site | FCY | [FCY]FCY0=[SFTH]MFGFCY | Block | ||||
| MFGTRKNUM | Tracking number | VCR | ||||||
| NUMJOBS | Number of activities | L | 8 | |||||
| NUMMAC | Machine included | M | 4 | 1 | ||||
| OPENUM | Operation number | OPE | ||||||
| OPEUOM | Entry unit | UOM | [TUN]TUN0=[SFTH]OPEUOM | Block | ||||
| REJCPLQTY | Actual rejected qty. | QTY | ||||||
| SCANUM | Rejection | C | 4 | |||||
| SFTSEQ | Sequence | L | 4 | |||||
| SFTTYP | Type | M | 4 | 2416 | ||||
| SFTWSTTYP | Work center type | M | 3 | 2423 | ||||
| SHIFT | Shift code | SHFT | [SFTS]SHF0=[SFTH]SHIFT | Block | ||||
| SHIFTDAT | Shift date | D | ||||||
| STRTXNUUID | Transaction code | AUUID | ||||||
| SUMEMP | Number of employees | L | 8 | |||||
| TEAMNUM | Team | TMA | [TMA]TMA0=[SFTH]TEAMNUM | Block | ||||
| TXNUUID | Transaction code | AUUID | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[SFTH]UPDUSR | Other | ||||
| UTCENDDATTIM | End | ADATIM | ||||||
| UTCOFFSET | Time zone difference | DCB | 9.2 | |||||
| UTCSTRDATTIM | Start | ADATIM | ||||||
| VCRNUM | Document | VCR | ||||||
| WCENTER | Work center | WST |