BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_PM_NONVW
RFQ_IDA=Approved
C=Closed
H=On Hold
O=Open
X=Canceled
Default Value: OPR_DEF_TBL_PM.RFQ_STATUS
Prompt Table: BUYER_ACTIVE_VW
Default Value: %date
RFQ_HDR_VW(SQL View) |
Index Back |
|---|---|
Approved RFQ View |
| select business_unit, rfq_id, rfq_status, rfq_ref, buyer_id, request_date from PS_RFQ_HDR where rfq_status = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_PM_NONVW |
| 2 | RFQ_ID |
Character(10) | VARCHAR2(10) NOT NULL | RFQ ID |
| 3 | RFQ_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
RFQ Status
A=Approved C=Closed H=On Hold O=Open X=Canceled Default Value: OPR_DEF_TBL_PM.RFQ_STATUS |
| 4 | RFQ_REF | Character(30) | VARCHAR2(30) NOT NULL | RFQ Reference |
| 5 | BUYER_ID | Character(30) | VARCHAR2(30) NOT NULL |
Buyer
Prompt Table: BUYER_ACTIVE_VW |
| 6 | REQUEST_DATE | Date(10) | DATE |
Requested
Default Value: %date |