Table STOJOU
| 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 |