Dictionary >  Module Stock >  Table Stock resynch work  

Display all Hide all

Table Abbreviation Description Module Activity code
STOSYNW SYW Stock resynch work Stock  

Key Description Duplicates Activity code
SYW0 CUNLISNUM+STOFCY+ITMREF+SEQ No  
SYW1 STOFCY+ITMREF+LOT+SLO+LOC+STA Yes  
SYW2 STOFCY+ITMREF+SERNUM Yes  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
ACT IU potency   DCB 5.4        
AUUID Single identifier   AUUID          
BPRNUM BP   BPR     [BPR]BPR0=[SYW]BPRNUM Other  
BPSLOT Supplier lot   LOT          
CREDAT Date created   D          
CREDATTIM Date time   ADATIM          
CREUSR Creation user   A 5        
CTRNUM Identifier 2   CTR          
CUNLISNUM Count worksheet   VCR          
EXPNUM Export number   L 8        
ITMREF Product   ITM     [ITM]ITM0=[SYW]ITMREF Other  
LOC Location   LOC     [STC]STC0=STOFCY;LOC Other  
LOT Lot   LOT          
OWNER Owner   BPF          
PALNUM Identifier 1   PAL          
PCU Unit   UOM     [TUN]TUN0=[SYW]PCU Other  
PCUSTUCOE PAC-STK conv.   COE          
POT Potency   DCB 5.4        
QLYCTLDEM Analysis request   VCR          
QTYPCUNEW Counted stock PAC   QTY          
QTYPCUSTO Stock PAC   QTY          
QTYSTUNEW Counted STK stock   QTY          
QTYSTUSTO Stock STK   QTY          
SEQ Sequence   L 8        
SERNUM Serial number   SER          
SHLDAT Expiration date   D          
SLO Sublot   SLO          
STA Stock status   A 3        
STOCOU Chronological stock   DCB 10        
STOFCY Storage site   FCY     [FCY]FCY0=[SYW]STOFCY Other  
UPDDAT Change date   D          
UPDDATTIM Date time   ADATIM          
UPDUSR Change user   A 5        
USRFLD1 Stock custom field 1   A 20        
USRFLD2 Stock custom field 2   A 10        
USRFLD3 Stock custom field 3   DCB 10        
USRFLD4 Stock custom field 4   D