PRCR_INQ_TYPEPH=Procurement History List
PL=PO Schedule List
QL=Requisition List
RL=Receiver Schedule List
VL=Voucher List
Default Value: PH
COL_HEADINGPrompt Table: %EDITTABLE
C=Character
D=Date
N=Numeric
X=Character Extended
PRCR_FLDCAN_TBL(SQL Table) |
Index Back |
|---|---|
Procurement Field Candidates |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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 |
| 2 | COL_HEADING |
Character(20) | VARCHAR2(20) NOT NULL | Field Heading |
| 3 | FLD_NAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name
Prompt Table: %EDITTABLE |
| 4 | FLD_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Field Type
C=Character D=Date N=Numeric X=Character Extended |