EN_BOM_HDM_LVW(SQL View) |
Index Back |
---|---|
BOM Header Maint Rel Lang VwBOM Header view including Item ID, BOM State, BOM Type, BOM Code Language Code and Description fields. |
SELECT a.setid , a.inv_item_id , a.bom_state , a.bom_type , a.bom_code , a.language_cd , a.descr , a.descrshort , a.text254 FROM PS_EN_BOM_HDR_LANG a WHERE a.bom_state = 'PR' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
Default Value: OPR_DEF_TBL_RB.SETID Prompt Table: SP_SETID_NONVW |
2 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: MASTER_ITEM_TBL |
3 | BOM_STATE | Character(2) | VARCHAR2(2) NOT NULL |
BOM State
EN=Engineering PR=Manufacturing |
4 | BOM_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
03/26/00 RML Added a label "Type"
PR=Production RW=Rework SV=Service |
5 | BOM_CODE | Number(2,0) | SMALLINT NOT NULL | CN# EN800-3.0, anna 09/21 added new field to database |
6 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
8 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
9 | TEXT254 | Character(254) | VARCHAR2(254) NOT NULL | Text |