PRCR_VIEW_NAMEPrompt Table: PRCR_VALID_VIEW
PH=Procurement History List
PL=PO Schedule List
QL=Requisition List
RL=Receiver Schedule List
VL=Voucher List
Default Value: PH
PRCR_VIEW_CAN(SQL Table) |
Index Back |
|---|---|
Procurement INQ View Canidates |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PRCR_VIEW_NAME |
Character(30) | VARCHAR2(30) NOT NULL | View By |
| 2 | PRCR_VIEW_ID | Character(15) | VARCHAR2(15) NOT NULL |
View ID
Prompt Table: PRCR_VALID_VIEW |
| 3 | PRCR_INQ_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Inquiry Type
PH=Procurement History List PL=PO Schedule List QL=Requisition List RL=Receiver Schedule List VL=Voucher List Default Value: PH |