Table NPIHEADER
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| NPIHEADER | NPIH | Product design header | Common Data | NPI |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| NPIH0 | NPICOD+NPIREV+MFGFCY | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ACSCOD | Access code | ACS | [ACS]ACS0=[NPIH]ACSCOD | Other | ||||
| APPDAT | Approval date | D | ||||||
| APPSTA | Approval status | M | 20 | 3510 | ||||
| APPTEXID | Additional text | TXC | ||||||
| APPUSR | Approver | AUS | [AUS]CODUSR=[NPIH]APPUSR | Other | ||||
| AUUID | Single identifier | AUUID | ||||||
| BASQTY | Base quantity | QTY | ||||||
| BOMALT | BOM code | TBO | [TBO]TBO0=BOMALTTYP;BOMALT | Other | ||||
| BOMECCMAJ | Major version | ICVVAL | ECC | |||||
| BOMECCMIN | Minor version | ICVVAL | ECC | |||||
| BOMSTU | UOM | [TUN]TUN0=[NPIH]BOMSTU | Other | |||||
| BOMUPDDAT | BOM | D | ||||||
| BOMUPDFLG | BOM | C | 4 | |||||
| BOMUPDUSR | BOM | AUS | [AUS]CODUSR=[NPIH]BOMUPDUSR | Other | ||||
| BPCNUM | Customer | BPR | [BPR]BPR0=[NPIH]BPCNUM | Other | ||||
| BRAND | Brand | A | 30 | |||||
| CLCSTA | Calculation status | M | 24 | 593 | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[NPIH]CREUSR | Other | ||||
| CSTCUR | Currency | CUR | [TCU]TCU0=[NPIH]CSTCUR | Other | ||||
| CSTFCY | Site | FCY | [FCY]FCY0=[NPIH]CSTFCY | Other | ||||
| CSTNET | Net cost | MD0 | ||||||
| CSTTOT | MD0 | |||||||
| CSTTYP | Cost type | M | 15 | 219 | ||||
| DTYTHE | Density | COE | ||||||
| EFF | % efficiency | DCB | 3.3 | |||||
| EFFCLC | Calculated val | DCB | 3.3 | |||||
| EFFUPD | Update | M | 4 | 1 | ||||
| FEAUPDDAT | Product | D | ||||||
| FEAUPDUSR | Properties | AUS | [AUS]CODUSR=[NPIH]FEAUPDUSR | Other | ||||
| HEATEX | Header text | TXC | ||||||
| MFGFCY | Production site | A | 10 | |||||
| NEXFMLDAT | Operation date | D | ||||||
| NPIBOMREFPUB | Published | M | 4 | 1 | ||||
| NPICLCQTY | Calculation qty. | DCB | 9.6 | |||||
| NPICOD | Code | A | 20 | |||||
| NPIDES | Description | DES | ||||||
| NPIITMREF | Design product | A | 20 | |||||
| NPIITMREFPUB | Published | M | 4 | 1 | ||||
| NPILABTOT | Labor cost | DCB | 9.4 | |||||
| NPIMACTOT | Machine cost | DCB | 9.4 | |||||
| NPIMATLEV0 | Material cost | DCB | 9.4 | |||||
| NPIMATTOT | Component cost | DCB | 9.4 | |||||
| NPIOVETOT | Overhead cost | DCB | 9.4 | |||||
| NPIREV | Revision | A | 8 | |||||
| NPIREV2 | Revision | A | 8 | |||||
| NPIREV3 | Revision | A | 8 | |||||
| NPISCOTOT | Subcontract cost | DCB | 9.4 | |||||
| NPISTA | Status | M | 20 | 3511 | ||||
| NPIUOM | Design UOM | UOM | [TUN]TUN0=[NPIH]NPIUOM | Block | ||||
| NPIVLTTOT | Cost (STK) | DCB | 9.4 | |||||
| PJT | Project | PJT | [PIM]PIM0=[NPIH]PJT | Other | ||||
| QTYCOD | Management unit | M | 15 | 225 | ||||
| QTYMAX | Maximum quantity | QTY | ||||||
| QTYMAXUOM | UOM | UOM | [TUN]TUN0=[NPIH]QTYMAXUOM | Other | ||||
| QUATEX | Notes | TXC | ||||||
| RELDAT | Release date | D | ||||||
| RELSTA | Release status | M | 15 | 3517 | ||||
| TECCRDDAT | Technical sheet | D | ||||||
| TECCRDUSR | Technical sheet | AUS | [AUS]CODUSR=[NPIH]TECCRDUSR | Other | ||||
| TOTBOMUOMCST | Total cost (UOM) | MD8 | ||||||
| TOTCSTSTU | Total cost (STK) | MD8 | ||||||
| TOTEXTCST | Total cost | MD8 | ||||||
| TOTLIKQTY | Total link quantity | QTY | ||||||
| TOTNETCST | Net cost | MD8 | ||||||
| TOTQTY | Tot. design link qty. | QTY | ||||||
| TOTQTYNET | Net quantity | MD8 | ||||||
| TOTUNTCST | Unit cost | MD8 | ||||||
| TSICOD | Statistical group | ADI | [ADI]CODE=indice+20;TSICOD(indice) | Other | STI | |||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[NPIH]UPDUSR | Other | ||||
| WHPPCTBASIS | L | 5 |