SETIDMFG_IDMFG_ITM_IDGPO_CNTRCT_NBRPrompt Table: MFG_GPO
Prompt Table: GPO_TBL
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
Prompt Table: UNITS_TBL
Prompt Table: UNITS_TBL
Prompt Table: CURRENCY_CD_TBL
GPO_ITM_EVW(SQL View) |
Index Back |
|---|---|
GPO Item MFGGPO Item MFG |
| SELECT SETID , MFG_ID , MFG_ITM_ID , GPO_CNTRCT_NBR , GPO_ID , DESCR254 , MFG_ITM_CAT_CD , UNIT_OF_MEASURE , CONVERSION_RATE , BASE_UOM , PRICE , CURRENCY_CD , PRICE_EFFECTIVE_DT , PRICE_EXPRTN_DT FROM PS_GPO_ITM_EC |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | MFG_ID |
Character(50) | VARCHAR2(50) NOT NULL | Manufacturer ID |
| 3 | MFG_ITM_ID |
Character(50) | VARCHAR2(50) NOT NULL | Manufacturer's Item ID |
| 4 | GPO_CNTRCT_NBR |
Character(25) | VARCHAR2(25) NOT NULL |
GPO Contract Number
Prompt Table: MFG_GPO |
| 5 | GPO_ID | Character(18) | VARCHAR2(18) NOT NULL |
GPO ID
Prompt Table: GPO_TBL |
| 6 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 7 | MFG_ITM_CAT_CD | Character(18) | VARCHAR2(18) NOT NULL | Category |
| 8 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage Prompt Table: UNITS_TBL |
| 9 | CONVERSION_RATE | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Conversion Rate |
| 10 | BASE_UOM | Character(3) | VARCHAR2(3) NOT NULL |
Base Unit of Measure
Prompt Table: UNITS_TBL |
| 11 | PRICE | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | This is price per unit for calculating the service charge. |
| 12 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 13 | PRICE_EFFECTIVE_DT | Date(10) | DATE | Price Effective Date |
| 14 | PRICE_EXPRTN_DT | Date(10) | DATE | Price Expiration Date |