Table CUNLISDET
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| CUNLISDET | CUD | Counts | Stock |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| CUD0 | CUNSSSNUM+CUNLISNUM+ITMLISNUM | No | |
| CUD1 | STOFCY+ITMREF+CUNLISNUM | Yes | |
| CUD2 | STOFCY+ITMREF+LOC | Yes | |
| CUD3 | STOFCY+CUNSSSNUM+CUNLISNUM+ITMREF | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ABCCLS | ABC class | M | 15 | 212 | ||||
| AUUID | Single identifier | AUUID | ||||||
| CCE | Analytical dimension | CCE | [CCE]CCE0=DIE(indice);CCE(indice) | Block | ANA | |||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| CTRNUM | Identifier 2 | CTR | ||||||
| CUNCST | Unit val. | MD8 | ||||||
| CUNCSTCOD | Costing mode | M | 15 | 705 | ||||
| CUNDAT | Count date | D | ||||||
| CUNLISNUM | Count worksheet | VCR | ||||||
| CUNLISSTA | Status | M | 15 | 2729 | ||||
| CUNLOKFLG | Blocked stock | M | 15 | 2724 | ||||
| CUNSSSNUM | Stock count session | VCR | ||||||
| CUR | Currency | CUR | [TCU]TCU0=[CUD]CUR | Block | ||||
| DEPAMT | Revaluation amt | MD1 | ||||||
| DEPRAT | Revaluation rate | RAT | ||||||
| DIE | Dimension type code | DIE | [DIE]DIE0=[CUD]DIE | Block | ANA | |||
| DLUDAT | Use-by date | D | ||||||
| ECCVALMAJ | Major version | ECS | ECC | |||||
| ECCVALMIN | Minor version | EVL | ECC | |||||
| EXPNUM | Export number | L | 8 | |||||
| INVDTACST | Invoicing element | MD7 | SPD | |||||
| IPTDAT | Allocation date | D | ||||||
| ITMLISNUM | Product rank | L | 8 | |||||
| ITMREF | Product | ITM | [ITM]ITM0=[CUD]ITMREF | Block | ||||
| LABCST | Labor cost | MD7 | LAB | |||||
| LINFLG | Notes | M | 15 | 715 | ||||
| LOC | Location | LOC | [STC]STC0=STOFCY;LOC | Other | ||||
| LOT | Lot | LOT | ||||||
| LPNNUM | License plate number | LPN | [LPN]LPN0=LPNNUM | Other | LPN | |||
| MACCST | Machine cost | MD7 | MAC | |||||
| MATCST | Material cost | MD7 | MAT | |||||
| NETCUNCST | Net unit value | MD8 | ||||||
| NEWLTIDAT | Recontrol date | D | ||||||
| OVELABCST | Labor OH | MD7 | SPD | |||||
| OVEMACCST | Machine OH | MD7 | SPD | |||||
| OVEMATCST | Mat. OH | MD7 | SPD | |||||
| OVESCOCST | Sub-con OH | MD7 | SPD | |||||
| OWNER | Owner | BPF | ||||||
| PALNUM | Identifier 1 | PAL | ||||||
| PCU | Unit | UOM | [TUN]TUN0=[CUD]PCU | Block | ||||
| PCUSTUCOE | PAC-STK conv. | COE | ||||||
| POT | Potency | DCB | 5.4 | |||||
| PRIORD | Order price | MD5 | ||||||
| QLYCTLDEM | Analysis request | VCR | ||||||
| QTYPCU | PAC quantity | QTY | ||||||
| QTYPCUNEW | Counted stock PAC | QTY | ||||||
| QTYPCUNEW1 | Counted stock PAC 1 | QTY | ||||||
| QTYPCUNEW2 | Counted stock PAC 2 | QTY | ||||||
| QTYSTU | STK quantity | QTY | ||||||
| QTYSTUNEW | Counted STK stock | QTY | ||||||
| QTYSTUNEW1 | Counted stock STK 1 | QTY | ||||||
| QTYSTUNEW2 | Counted stock STK 2 | QTY | ||||||
| REFPER | Expiration reference | D | ||||||
| SCOCST | Total subcontracted | MD7 | SPD | |||||
| SERNUM | Serial number | SER | ||||||
| SERSEQ | Sequence | L | 8 | |||||
| SHLDAT | Expiration date | D | ||||||
| SLO | Sublot | SLO | ||||||
| STA | Stock status | A | 3 | |||||
| STOCOU | Chronological stock | DCB | 10 | |||||
| STOFCY | Storage site | FCY | [FCY]FCY0=[CUD]STOFCY | Block | ||||
| STOFLD1 | Custom field 1 | SF1 | SFD | |||||
| STOFLD2 | Custom field 2 | SF2 | SFD | |||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 | |||||
| WRH | Warehouse | WRH | [WRH]WRH0=WRH | Block | WRH | |||
| ZERSTOFLG | Zero stock | M | 4 | 1 | ||||
| ZERSTOFLG1 | Null stock 1 | M | 4 | 1 | ||||
| ZERSTOFLG2 | Null stock 2 | M | 4 | 1 |