Table CUNSESSION
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| CUNSESSION | CUN | Stock count session | Stock |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| CUN0 | CUNSSSNUM | No | |
| CUN1 | STOFCY+CUNSSSNUM | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ABCCLSA | Class 'A' | M | 4 | 1 | ||||
| ABCCLSB | Class 'B' | M | 4 | 1 | ||||
| ABCCLSC | Class 'C' | M | 4 | 1 | ||||
| ABCCLSD | Class 'D' | M | 4 | 1 | ||||
| AUUID | Single identifier | AUUID | ||||||
| BPRNUMEND | To BP | BPR | [BPR]BPR0=[CUN]BPRNUMEND | Other | ||||
| BPRNUMSTR | From BP | BPR | [BPR]BPR0=[CUN]BPRNUMSTR | Other | ||||
| BUYEND | To buyer | AUS | [AUS]CODUSR=[CUN]BUYEND | Other | ||||
| BUYSTR | From buyer | AUS | [AUS]CODUSR=[CUN]BUYSTR | Other | ||||
| CPLCUNNBRA | A product physical counts | L | 8 | |||||
| CPLCUNNBRB | B product physical counts | L | 8 | |||||
| CPLCUNNBRC | C product physical counts | L | 8 | |||||
| CPLCUNNBRD | D product stock cts | L | 8 | |||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| CUNITMWRH | Products-warehouses | M | 4 | 1 | ||||
| CUNLASFLG | Global | M | 4 | 1 | ||||
| CUNNBRA | A requested physical count | L | 8 | |||||
| CUNNBRB | B requested physical count | L | 8 | |||||
| CUNNBRC | C requested physical counts | L | 8 | |||||
| CUNNBRD | D req stock count | L | 8 | |||||
| CUNNULSTK | Products without stock | M | 4 | 1 | ||||
| CUNSRTCOD | Count sort | M | 15 | 796 | ||||
| CUNSSSDAT | Count date | D | ||||||
| CUNSSSDES | Description | DES | ||||||
| CUNSSSMOD | Processing selection | M | 15 | 756 | ||||
| CUNSSSNUM | Stock count session | VCR | ||||||
| CUNSSSSTA | Status | M | 15 | 2722 | ||||
| CUNSSSTYP | Stock count type | M | 20 | 2717 | ||||
| EXPNUM | Export number | L | 8 | |||||
| ITMNBR | Number of products | C | 4 | |||||
| ITMREFEND | To product | ITM | [ITM]ITM0=[CUN]ITMREFEND | Other | ||||
| ITMREFSTR | From product | ITM | [ITM]ITM0=[CUN]ITMREFSTR | Other | ||||
| ITMSTA006 | Usable | M | 4 | 1 | ||||
| LOCEND | To location | LOC | [STC]STC0=STOFCY;LOCEND | Other | ||||
| LOCPOS | Location position | C | 2 | |||||
| LOCSTR | From location | LOC | [STC]STC0=STOFCY;LOCSTR | Other | ||||
| LOCTYPEND | To locn type | TLO | [TLO]TLO0=STOFCY;LOCTYPEND | Other | ||||
| LOCTYPSTR | From locn type | TLO | [TLO]TLO0=STOFCY;LOCTYPSTR | Other | ||||
| LOTEND | To lot | LOT | ||||||
| LOTSTR | From lot | LOT | ||||||
| MAGLOCFLG | Shop location | M | 4 | 1 | ||||
| MAXLIG | Maximum lines | C | 4 | |||||
| MULCTGFLG | Multiple counts | M | 4 | 1 | ||||
| MULLISFLG | Multilists | M | 4 | 1 | ||||
| PICLOCFLG | Picking location | M | 4 | 1 | ||||
| PRCLIG | % limit | C | 4 | |||||
| QUALOCFLG | Dock location | M | 4 | 1 | ||||
| RCPLOCFLG | Receipt loc. | M | 4 | 1 | ||||
| RETLOCFLG | Return location | M | 4 | 1 | ||||
| SELFOR | Product formula | FOR | [TFO]TFO0=18;SELFOR | Block | ||||
| SELFOR0 | Product formula | FOR | [TFO]TFO0=29;SELFOR0 | Block | ||||
| SELFOR00 | Prod-whs for. | FOR | [TFO]TFO0=42;SELFOR00 | Block | ||||
| SELFOR1 | Stock formula | FOR | [TFO]TFO0=27;SELFOR1 | Block | ||||
| SELFOR2 | Location formula | FOR | [TFO]TFO0=28;SELFOR2 | Block | ||||
| SELFOR3 | Warehouse formula | FOR | [TFO]TFO0=43;SELFOR3 | Block | ||||
| STOFCY | Storage site | FCY | [FCY]FCY0=[CUN]STOFCY | Block | ||||
| STOLOCFLG | Storage location | M | 4 | 1 | ||||
| TCLCODEND | Last category | ITG | [ITG]ITG0=STOFCY;TCLCODEND | Other | ||||
| TCLCODSTR | First category | ITG | [ITG]ITG0=STOFCY;TCLCODSTR | Other | ||||
| TRALOCFLG | Work station locn | M | 4 | 1 | ||||
| TSICODEND | To stat grp | ADI | [ADI]CODE=indice+40;TSICODEND(indice) | Other | STI | |||
| TSICODSTR | From stat grp | ADI | [ADI]CODE=indice+40;TSICODSTR(indice) | Other | STI | |||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 | |||||
| WRHEND | To warehouse | WRH | [WRH]WRH0=[CUN]WRHEND | Other | ||||
| WRHSTR | From warehouse | WRH | [WRH]WRH0=[CUN]WRHSTR | Other |