SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
CATEGORY_IDATTRNAMEPrompt Table: UNITS_TBL
PV_ITM_ATTR_SRH(SQL View) |
Index Back |
|---|
| SELECT DISTINCT A.SETID , B.CATEGORY_ID , A.ATTRNAME , A.UOM_ATTR FROM PS_PV_ITM_ATTR_TBL A , PS_MASTER_ITEM_TBL B WHERE A.SETID = B.SETID AND A.INV_ITEM_ID = B.INV_ITEM_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | CATEGORY_ID |
Character(5) | VARCHAR2(5) NOT NULL | Category ID |
| 3 | ATTRNAME |
Character(30) | VARCHAR2(30) NOT NULL | Pub/Sub Attribute Name |
| 4 | UOM_ATTR | Character(3) | VARCHAR2(3) NOT NULL |
Attribute Unit of Measure
Prompt Table: UNITS_TBL |