BUSINESS_UNITECO_IDINV_ITEM_IDBOM_CODEEG_BOM_AUDIT_VW(SQL View) |
Index Back |
|---|---|
ECO BOM Time stamped audit VWCN# EN800-3.0, Sep 21 98, Anna Added field BomCode |
| select business_unit, eco_id, inv_item_id, bom_code, eg_datetime, oprid from PS_EG_BOM_AUDIT where copy_direction='EM' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | ECO_ID |
Character(10) | VARCHAR2(10) NOT NULL | ECO Number |
| 3 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 4 | BOM_CODE |
Number(2,0) | SMALLINT NOT NULL | CN# EN800-3.0, anna 09/21 added new field to database |
| 5 | EG_DATETIME | DateTime(26) | TIMESTAMP NOT NULL | Copy Date / Time |
| 6 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |