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 |