INSTALLATION_MG(SQL Table) |
Index Back |
|---|---|
INSTALLATION OPTIONS FOR MG11/5/97, EYZ CN# MG750-6.0, added QPA_ROUNDING to the table, identifying the QPA rounding precisions. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | QPA_ROUNDING | Number(2,0) | SMALLINT NOT NULL |
QPA Rounding Precision
Default Value: 4 |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BUMGOP_NONVW |
| 3 | UNIT_MEASURE_STD | Character(3) | VARCHAR2(3) NOT NULL |
Standard Unit of Measure
Prompt Table: UNITS_TBL |
| 4 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 5 | EN_ITMSTAT_ACTIVE | Character(254) | VARCHAR2(254) NOT NULL | Created on 11/19/2002 Used by BOM_SYNC and ITEM_SYNC messages to import Agile items and BOM; map item status to Agile Life Cycle Phase code. |
| 6 | EN_ITMSTAT_DISCONT | Character(254) | VARCHAR2(254) NOT NULL | Created on 11/19/2002 Used by BOM_SYNC and ITEM_SYNC messages to import Agile items and BOM; map item status to Agile Life Cycle Phase code. |
| 7 | EN_ITMSTAT_INACTIV | Character(254) | VARCHAR2(254) NOT NULL | Created on 11/19/2002 Used by BOM_SYNC and ITEM_SYNC messages to import Agile items and BOM; map item status to Agile Life Cycle Phase code. |
| 8 | EN_ITMSTAT_HOLD | Character(254) | VARCHAR2(254) NOT NULL | Created on 11/19/2002 Used by BOM_SYNC and ITEM_SYNC messages to import Agile items and BOM; map item status to Agile Life Cycle Phase code. |