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 |