BUSINESS_UNITRFQ_IDVENDOR_IDVNDR_LOCE=Error
H=Hold
L=New/Reprocess
P=Processed
X=Cancelled
PO_RFQR_HDR_EVW(SQL View) |
Index Back |
|---|---|
RFQR Message HDR ViewSELECT BUSINESS_UNIT , RFQ_ID , VENDOR_ID , VNDR_LOC , PO_EDI_STATUS , DTTM_RESP , PYMNT_TERMS_CD , CURRENCY_CD , VENDOR_REF_ID FROM PS_RFQ_RESP_HDR_EC |
| SELECT BUSINESS_UNIT , RFQ_ID , VENDOR_ID , VNDR_LOC , PO_EDI_STATUS , DTTM_RESP , PYMNT_TERMS_CD , CURRENCY_CD , VENDOR_REF_ID FROM PS_RFQ_RESP_HDR_EC |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | RFQ_ID |
Character(10) | VARCHAR2(10) NOT NULL | RFQ ID |
| 3 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 4 | VNDR_LOC |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 5 | PO_EDI_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Purchasing EDI Status
E=Error H=Hold L=New/Reprocess P=Processed X=Cancelled |
| 6 | DTTM_RESP | DateTime(26) | TIMESTAMP | Date Time Responded |
| 7 | PYMNT_TERMS_CD | Character(5) | VARCHAR2(5) NOT NULL | Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers. |
| 8 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 9 | VENDOR_REF_ID | Character(20) | VARCHAR2(20) NOT NULL | Vendor reference quote number |