PV_REQ_POA_VW

(SQL View)
 Index Back

ePro Req Voucher View


SELECT CC.BUSINESS_UNIT_REQ , CC.REQ_ID , CC.BUSINESS_UNIT , CC.PO_ID , CC.VENDOR_SETID , CC.VENDOR_ID , CC.PO_DT , CC.DATETIME_CREATE , CC.EIP_CTL_ID , CC.PO_POA_STATUS , CC.PO_ACK_SOURCE , CC.ACK_STATUS , CC.ACKNOWLEGE_DT , CC.CHNG_ORD_BATCH , CC.CNTCT_SEQ_NUM , CC.CURRENCY_CD , CC.RT_TYPE , CC.PO_REF , CC.PYMNT_TERMS_CD , A.COMMENTS FROM PS_PV_REQ_POA_VW1 CC , PS_PO_HDR_EC A WHERE CC.BUSINESS_UNIT = A.BUSINESS_UNIT AND CC.PO_ID = A.PO_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_REQ Character(5) VARCHAR2(5) NOT NULL Requesting Business Unit
2 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
5 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
6 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
7 PO_DT Date(10) DATE Date
8 DATETIME_CREATE DateTime(26) TIMESTAMP 02/2001 cel WV-802-1.0.
9 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
10 PO_POA_STATUS Character(3) VARCHAR2(3) NOT NULL 08/07/01 RML Created for Supplier Portal Acknowledgment
BAC=Buyer Accepted
CMP=EDX compare needed
NEW=New
SRP=Supplier Responded
SRV=Supplier Review
11 PO_ACK_SOURCE Character(3) VARCHAR2(3) NOT NULL Created on 08/09/01 CN#WV840-4.0 - Purchase Order Acknowledgment source used in PO_HDR_EC
BUY=Online (Buyer)
EDI=EDX
SUP=Online (Supplier)
12 ACK_STATUS Character(3) VARCHAR2(3) NOT NULL Acknowledgement Status
AC=Ack - With Detail and Change
AD=Ack - With Detail, No Change
AE=Ack - Exception Detail Only
AH=Acknowledge - Hold Status
AK=Ack - No Detail or Change
AT=Accepted
BP=Accepted - Partial Shipment
DR=Accepted - Date Rescheduled
IA=Accepted - Price Pending
IB=Backordered
IC=Accepted - Changes Made
ID=Deleted
IF=On Hold-Incomplete Description
IH=On Hold
IP=Accepted - Price Changed
IQ=Accepted - Quantity Changed
IS=Accepted - Substitution Made
IW=On Hold - Waiver Required
RD=Rejected With Detail
RF=Rej - Exception Detail Only
RJ=Rejected - No Detail
RO=Rejected With Counter Offer
SP=Accpted-Schedule Date Pending
ZZ=Mutually Defined Value
13 ACKNOWLEGE_DT Date(10) DATE Acknowledge Date
14 CHNG_ORD_BATCH Number(3,0) SMALLINT NOT NULL Change Order Number
15 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number

Prompt Table: VENDOR_CNTCT_VW

16 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

17 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.

Prompt Table: RT_TYPE_TBL

18 PO_REF Character(30) VARCHAR2(30) NOT NULL Specifies the purchase order number associated with a receivables item.
19 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.

Prompt Table: PYMT_TR_EFF_VW

20 COMMENTS Long Character CLOB Comment