ITM_SETIDUPN_TYPE_CDWM_IN_UPNTP_VW(SQL View) |
Index Back |
|---|---|
WM Inventory UPN Type CodesNote: used in Sched PO Supplier Item Search |
| SELECT SETID AS ITM_SETID , UPN_TYPE_CD , DESCR , DESCRSHORT FROM PS_UPN_TYPE_FS |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ITM_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Item SetID |
| 2 | UPN_TYPE_CD |
Character(4) | VARCHAR2(4) NOT NULL | Universal Product Number Format Type |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |