Table Abbreviation Description Module Activity code
STOJOU STJ Stock journal Stock  

Key Description Duplicates Activity code
STJ0 STOFCY+UPDCOD+ITMREF-IPTDAT+MVTSEQ+MVTIND No  
STJ1 STOFCY+VCRTYP+VCRNUM+VCRLIN Yes  
STJ2 UPDCOD+ITMREF-IPTDAT+MVTSEQ+MVTIND Yes  
STJ3 UPDCOD-CREDAT-CRETIM+ITMREF Yes  
STJ4 ITMREF+IPTDAT+CREMVTDAT+CREMVTTIM+CREMVTSEQ Yes  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
ACCDAT Accounting date   D          
ACT IU potency   DCB 5.4        
ACTQTY Active quantity   QTY          
AGGIFAFLG Interface aggregation   M 4 1      
AMTDEV Variance not absorbed   MD1          
AMTDEV2 Variance not absorbed   MD1         VLT
AMTORD Order amount   MD5          
AMTVAL Movement value   MD5          
AMTVAL2 Movement value   MD5         VLT
AUUID Single identifier   AUUID          
BETCPY Intercompany   M 4 1      
BPRNUM BP   BPR     [BPR]BPR0=[STJ]BPRNUM Block  
BPSLOT Supplier lot   LOT          
CCE Analytical dimension   CCE     [CCE]CCE0=DIE(indice);CCE(indice) Block ANA
CREDAT Date created   D          
CREDATTIM Date time   ADATIM          
CREMVTDAT Date created   D          
CREMVTSEQ Source sequence   L 8        
CREMVTTIM Time   HS          
CRETIM Time   HM          
CREUSR Creation user   A 5        
CSTCOU Chronological FIFO costs   DCB 10        
CSTDAT FIFO date   D          
CSTTIM FIFO time   HS          
CTRNUM Identifier 2   CTR          
DIE Dimension type code   DIE     [DIE]DIE0=[STJ]DIE Block ANA
DLUDAT UBD   D          
ECCVALMAJ Major version   ECS         ECC
ECCVALMIN Minor version   EVL         ECC
ENTCOD Auto journal code   GAU     [GAU]GAU0=[STJ]ENTCOD Block  
EXPNUM Export number   L 8        
FINRSPFCY Financial site   FCY     [FCY]FCY0=[STJ]FINRSPFCY Block  
GTE Entry type   GTE     [GTE]GTE0=GTE;[V]GSUPCLE Block  
IPTDAT Allocation date   D          
ITMREF Product   ITM     [ITM]ITM0=[STJ]ITMREF Block  
LBEFMT Label format   ARP     [ARP]ARP0=[STJ]LBEFMT Block  
LBENBR Number of labels   C 4        
LOC Location   LOC     [STC]STC0=STOFCY;LOC Other  
LOT Lot   LOT          
LPNNUM License plate number   LPN     [LPN]LPN0=LPNNUM Other LPN
MVTDES Movement description   DES          
MVTIND Index   L 8        
MVTSEQ Sequence   L 8        
NEWLTIDAT Recontrol date   D          
NUMVCR Accounting document   VCR          
OWNER Owner   BPF          
PALNUM Identifier 1   PAL          
PCU Unit   UOM     [TUN]TUN0=[STJ]PCU Block  
PCUORI Original PAC   UOM     [TUN]TUN0=[STJ]PCUORI Block  
PCUSTUCOE Coefficient   COE          
PCUSTUORI Original coef.   COE          
PITVALFLG Aggregated   M 4 1      
PITVALFLG2 Aggregated   M 4 1     VLT
PJT Project   PJT     [PIM]PIM0=[STJ]PJT Block  
POT Potency   DCB 5.4        
PRINAT Cost source   M 15 705      
PRINAT2 Cost source   M 15 705     VLT
PRIORD Order price   MD5          
PRIREGFLG Adjustment flag   M 4 1      
PRIVAL Valued price   MD5          
PRIVAL2 Valued price   MD5         VLT
PRNFLG Printed   M 4 1      
PRONUM Process number   L 8        
QLYCTLDEM Analysis request   VCR          
QTYPCU Quantity   QTY          
QTYSTU STK quantity   QTY          
REGFLG Adjusted movement   M 4 1      
SERDEB Starting serial number   SER          
SERFIN Ending serial number   SER          
SERNUM Serial number   SER          
SHLDAT Expiration date   D          
SLO Sublot   SLO          
STA Status   A 3        
STOFCY Storage site   FCY     [FCY]FCY0=[STJ]STOFCY Block  
STOFLD1 Custom field 1   SF1         SFD
STOFLD2 Custom field 2   SF2         SFD
STU Stock unit   UOM     [TUN]TUN0=[STJ]STU Block  
TRSFAM Transaction group   ADI     [ADI]CODE=9;TRSFAM Block  
TRSTYP Transaction type   M 15 704      
UPDCOD Update   M 4 1      
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          
VARORD Order variance   MD5          
VARVAL Movement variance   MD5          
VARVAL2 Movement variance   MD5         VLT
VCRLIN Entry line no.   L 8        
VCRLINORI Source document line   L 8        
VCRLINREG Journal line no. adjusted   L 8        
VCRNUM Entry   VCR          
VCRNUMORI Original document   VCR          
VCRNUMREG Journal adjustment   VCR          
VCRSEQORI Source document sequence no.   L 8        
VCRTYP Entry type   M 15 701      
VCRTYPORI Source document type   M 15 701      
VCRTYPREG Journal adjustm type   M 15 701      
WRH Warehouse   WRH     [WRH]WRH0=WRH Other WRH