Table ITMMASTER
Table | Abbreviation | Description | Module | Activity code |
---|---|---|---|---|
ITMMASTER | ITM | Products | Common Data |
Key | Description | Duplicates | Activity code |
---|---|---|---|
ITM0 | ITMREF | No | |
ITM1 | ITMDES1 | Yes | |
ITM2 | SEAKEY+ITMREF | No | |
ITM3 | CFGLIN+ITMREF | No | |
ITM4 | CFGVCRNUM+ITMREF | No | CFG |
ITM5 | PLMITMREF+ITMREF | No | PLM |
Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
---|---|---|---|---|---|---|---|---|
ACCCOD | Accounting code | CAC | [CAC]CAC0=1;ACCCOD;[V]GSUPCLE | Block | ||||
ALG | Allergens | A | 20 | FOA | ||||
ALGBOM | Allergen BOM code | C | 2 | FOA | ||||
ALGDAT | Allergen change date | D | FOA | |||||
ALTBOMHDK | Code | TBO | [TBO]TBO0=1;ALTBOMHDK | RTZ | ||||
AUUID | Single identifier | AUUID | ||||||
BRDCOD | Cost group | M | 15 | 325 | ||||
BUY | Buyer | AUS | [AUS]CODUSR=[ITM]BUY | Block | ||||
CCE | Analytical dimension | CCE | [CCE]CCE0=DIE(indice);CCE(indice) | Block | ANA | |||
CFGBPRNUM | BP | BPR | [BPR]BPR0=[ITM]CFGBPRNUM | RTZ | CFG | |||
CFGBPRREF | BP reference | A | 20 | CFG | ||||
CFGDELDAT | Config purge date | D | CFG | |||||
CFGFLDALP1 | Alpha field 1 | A | 20 | |||||
CFGFLDALP2 | Alpha field 2 | A | 20 | |||||
CFGFLDALP3 | Alpha field 3 | A | 20 | |||||
CFGFLDALP4 | Alpha field 4 | A | 20 | |||||
CFGFLDALP5 | Alpha field 5 | A | 20 | |||||
CFGFLDALP6 | Alpha field 6 | A | 20 | |||||
CFGFLDNUM1 | Numeric field 1 | DCB | 15 | |||||
CFGFLDNUM2 | Numeric field 2 | DCB | 15 | |||||
CFGFLDNUM3 | Numeric field 3 | DCB | 15 | |||||
CFGFLDNUM4 | Numeric field 4 | DCB | 15 | |||||
CFGFLDNUM5 | Numeric field 5 | DCB | 15 | |||||
CFGFLDNUM6 | Numeric field 6 | DCB | 15 | |||||
CFGITMREF | Reference product | ITM | [ITM]ITM0=[ITM]CFGITMREF | Delete | CFG | |||
CFGLIN | Product line | TLP | [TLP]TLP0=[ITM]CFGLIN | Block | ||||
CFGVCRNUM | Journal number config | VCR | CFG | |||||
CPRAMT | Fixed cost per unit | MD5 | ||||||
CPRCOE | Landed cost coef. | COE | ||||||
CPY | Company | CPY | [CPY]CPY0=[ITM]CPY | Block | ||||
CREDAT | Date created | D | ||||||
CREDATTIM | Date time | ADATIM | ||||||
CREMAC | Creation of base | M | 4 | 1 | ||||
CREUSR | Creation user | A | 5 | |||||
CSTGRP | Cost group | A | 10 | |||||
CUSREF | Customs reference | INO | [INO]INO0=[ITM]CUSREF | Block | DEB | |||
DACPCUCOE | Factor authorized | M | 4 | 1 | NUC | |||
DACPUUCOE | Purchase factor entry | M | 4 | 1 | ||||
DACSAUCOE | Sales factor entry | M | 4 | 1 | ||||
DAYUOM | Unit for days | UOM | [TUN]TUN0=[ITM]DAYUOM | RTZ | ||||
DEFACT | Default title | DCB | 5.4 | |||||
DEFPOT | Default potency % | DCB | 5.4 | |||||
DES1AXX | Description 1 | AX3 | ||||||
DES2AXX | Description 2 | AX3 | ||||||
DES3AXX | Description 3 | AX3 | ||||||
DIE | Dimension type code | DIE | [DIE]DIE0=[ITM]DIE | Block | ANA | |||
DLU | UBD coefficient | COE | ||||||
DLVFLG | Deliverable | M | 4 | 1 | ||||
DTY | Density | COE | ||||||
EANCOD | UPC code | A | 20 | |||||
ECCBOMALT2 | Code | 2 | TBO | [TBO]TBO0=2;ECCBOMALT2(indice) | Block | ECC | ||
ECCBOMALT3 | Code | 2 | TBO | [TBO]TBO0=3;ECCBOMALT3(indice) | Block | ECC | ||
ECCFLG | Version management | M | 4 | 1 | ECC | |||
ECCMAJ | Major sequence | ICV | [ICV]ICV0=[ITM]ECCMAJ | Block | ECC | |||
ECCMIN | Minor sequence | ICV | [ICV]ICV0=[ITM]ECCMIN | Block | ECC | |||
ECCROUALT | Routing code | 2 | TRO | [TRO]TRO0=[ITM]ECCROUALT | Block | RVM | ||
ECCROUFLG | Routing version | M | 4 | 1 | RVM | |||
ECCSTO | Stock version | M | 20 | 2777 | ECC | |||
EECGES | Sub Intrastat | M | 4 | 1 | DEB | |||
EEU | Intrastat additional unit | UOM | [TUN]TUN0=[ITM]EEU | Block | ||||
EEUSTUCOE | EU-STK conv. | COE | ||||||
EXPNUM | Export number | L | 8 | |||||
EXYMGTCOD | Expiration management | M | 15 | 211 | ||||
EXYSTA | Expiration status | A | 1 | |||||
FIMHOR | Firm horizon | C | 4 | |||||
FIMHORUOM | Firm horizon time un | M | 15 | 291 | ||||
FLGFAS | Capitalizable | M | 4 | 1 | FAS | |||
FLYCAT | Voucher category | ADI | [ADI]CODE=450;FLYCAT | RTZ | ||||
FRTHOR | Planning horizon | C | 4 | |||||
FRTHORUOM | Planning horizon time unit | M | 15 | 291 | ||||
GENFLG | Generic | M | 4 | 1 | ||||
GTIN | GTIN | A | 14 | |||||
HDKITMTYP | Product type | M | 15 | 2984 | ||||
HOUUOM | Unit for hour | UOM | [TUN]TUN0=[ITM]HOUUOM | RTZ | ||||
INTFLG | Intermediary | M | 4 | 1 | ||||
INVPRODTYP | Product type | M | 25 | 2051 | KPO | |||
ITMDES1 | Description 1 | DES | ||||||
ITMDES2 | Description 2 | DES | ||||||
ITMDES3 | Description 3 | DES | ||||||
ITMEXNFLG | Exemption flag | A | 1 | |||||
ITMREF | Product | ITM | [ITM]ITM0=[ITM]ITMREF | Delete | ||||
ITMSFTTYP | SAF-T product type | M | 15 | 2273 | SAFT | |||
ITMSTA | Product status | M | 15 | 246 | ||||
ITMSTD | Standard | A | 20 | |||||
ITMVOU | STK volume | VOL | ||||||
ITMWEI | Item weight | WEI | ||||||
LBEFMT | Label format | ARP | [ARP]ARP0=[ITM]LBEFMT | Block | NUC | |||
LIFENDDAT | Service life end | D | ||||||
LIFSTRDAT | Service life start | D | ||||||
LOAECCFLG | Version preload | M | 4 | 1 | ECC | |||
LOTCOU | Lot sequence number | ANM | [ANM]ANM0=[ITM]LOTCOU | Block | ||||
LOTMGTCOD | Lot management | M | 15 | 2711 | ||||
MATTOL | Matching tolerance | MAT | [MAT]MAT0=[ITM]MATTOL | Block | ||||
MFGFLG | Manufactured | M | 4 | 1 | ||||
MFGTEX | Production text | TXC | ||||||
MINRMNPRC | Delivery tolerance % | RAT | ||||||
MNTUOM | Unit for minutes | UOM | [TUN]TUN0=[ITM]MNTUOM | RTZ | ||||
NEGSTO | Stock < 0 authorized | M | 4 | 1 | ||||
NEWLTISTA | Recontrol status | A | 1 | |||||
NPIPRO | Prototype | M | 4 | 1 | NPI | |||
OFS | Reorder LT | C | 4 | |||||
PCCCOD | Cost type | PJCC | [PJCC]PCC0=[ITM]PCCCOD | Block | PJM | |||
PCU | Packing unit | UOM | [TUN]TUN0=[ITM]PCU | Block | NUC | |||
PCURUL | Issuing PAC | M | 30 | 2706 | NUC | |||
PCUSTUCOE | PAC-STK conv. | COE | NUC | |||||
PHAFLG | Phantom | M | 4 | 1 | ||||
PITCDT | Tokens to be credited | L | 8 | |||||
PITCDTUOM | Credit unit | UOM | [TUN]TUN0=[ITM]PITCDTUOM | RTZ | ||||
PLAACS | User access | ACS | [ACS]ACS0=[ITM]PLAACS | Block | ||||
PLANNER | Planner | AUS | [AUS]CODUSR=[ITM]PLANNER | Block | ||||
PLMATTURL | Linked documents | A | 250 | |||||
PLMHISURL | PLM history | A | 250 | |||||
PLMITMREF | PLM product | PLM | ||||||
PRQFLG | Mandatory PO request | M | 4 | 1 | ||||
PURBASPRI | Base price | MD5 | ||||||
PURFLG | Bought | M | 4 | 1 | ||||
PURTEX | Purchase text | TXC | ||||||
PUU | Purchase unit | UOM | [TUN]TUN0=[ITM]PUU | Block | ||||
PUUSTUCOE | PUR-STK conv. | COE | ||||||
RCPFLG | Receipt code | M | 4 | 1 | ||||
RPLITM | Alternate product | ITM | [ITM]ITM0=[ITM]RPLITM | Block | ||||
SALFLG | Sold | M | 4 | 1 | ||||
SAU | Sales unit | UOM | [TUN]TUN0=[ITM]SAU | Block | ||||
SAUSTUCOE | SAL-STK conv. | COE | ||||||
SCPFLG | Subcontracted | M | 4 | 1 | ||||
SCSFLG | Subcontract | M | 4 | 1 | ||||
SEAKEY | Search key | A | 20 | |||||
SERCOU | Serial sequence | ANM | [ANM]ANM0=[ITM]SERCOU | Block | ||||
SERMGTCOD | Serial no. management | M | 15 | 210 | ||||
SHL | Shelf life | C | 4 | |||||
SHLLTI | Recontrol lead time | C | 4 | |||||
SHLLTIUOM | Rectrl time unit | M | 15 | 2759 | ||||
SHLUOM | Expir t unit | M | 15 | 2759 | ||||
SSTCOD | SST tax code | ADI | [ADI]CODE=203;SSTCOD | Block | LTA | |||
SSU | Statistical unit | UOM | [TUN]TUN0=[ITM]SSU | Block | ||||
SSUSTUCOE | STA-STK conv. | COE | ||||||
STAFED | Region/State | ADI | [ADI]CODE=80;STAFED | Block | DEBR | |||
STATAXFLG | Tax flag | A | 1 | |||||
STCNUM | Cost structure | VCR | ||||||
STDFLG | Management mode | M | 15 | 297 | ||||
STOCRD | Storage sheet | A | 8 | |||||
STOISSDEF | Stock issue | M | 4 | 1 | ||||
STOMGTCOD | Stock management | M | 15 | 215 | ||||
STU | Stock unit | UOM | [TUN]TUN0=[ITM]STU | Block | ||||
STULBEFMT | Label format | ARP | [ARP]ARP0=[ITM]STULBEFMT | Block | ||||
TCLCOD | Category | ITG | [ITG]ITG0="";TCLCOD | Block | ||||
TOOFLG | Tools | M | 4 | 1 | ||||
TPLCONGUA | Warranty contract | COT | [COT]COT0=[ITM]TPLCONGUA | RTZ | ||||
TPLCONLND | Loan contract | COT | [COT]COT0=[ITM]TPLCONLND | RTZ | ||||
TPLCONSRV | Service contract | COT | [COT]COT0=[ITM]TPLCONSRV | RTZ | ||||
TRKCOD | Traceability | M | 15 | 754 | ||||
TRKLEV | Traceability level | M | 15 | 2778 | ||||
TSICOD | Statistical group | ADI | [ADI]CODE=indice+20;TSICOD(indice) | Block | STI | |||
UNNBR | UN number | UNNBR | [TUNNB]TUNNB0=[ITM]UNNBR | Block | ||||
UPDDAT | Change date | D | ||||||
UPDDATTIM | Date time | ADATIM | ||||||
UPDUSR | Change user | A | 5 | |||||
VACITM | Tax level | 3 | TVI | [TVI]TVI0=VACITM(indice);[V]GSUPCLE | Block | |||
VOU | Volume unit | UOM | [TUN]TUN0=[ITM]VOU | Block | ||||
WEU | Weight unit | UOM | [TUN]TUN0=[ITM]WEU | Block |