PO_RC_WB_SRC_VW(SQL View) |
Index Back |
|---|
| SELECT A.BUSINESS_UNIT , A.PO_ID , A.ACTIVITY_DATE , A.PO_DT , A.PO_STATUS , A.BUYER_ID , A.VENDOR_ID , A.MATCH_ACTION , A.MATCH_STATUS_PO , A.RECV_STATUS , A.CHNG_ORD_BATCH , A.HOLD_STATUS , A.BACKORDER_STATUS , A.BUDGET_HDR_STATUS , A.BUDGET_HDR_STS_NP , A.DOC_TOL_HDR_STATUS , A.CC_SECURITY_ID , A.CC_USE_FLAG FROM PS_PO_HDR A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 3 | ACTIVITY_DATE | Date(10) | DATE | Last Activity |
| 4 | PO_DT | Date(10) | DATE | Date |
| 5 | PO_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
PO Status
A=Approved C=Complete D=Dispatched DA=Denied I=Initial LD=Line Denied O=Open PA=Pending Approval/Approved PX=Pending Cancel X=Canceled |
| 6 | BUYER_ID | Character(30) | VARCHAR2(30) NOT NULL | Buyer |
| 7 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 8 | MATCH_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Match Action
N=No Match Y=Standard |
| 9 | MATCH_STATUS_PO | Character(1) | VARCHAR2(1) NOT NULL |
Match Status
M=Matched N=Not Required P=Partially Matched T=To Match |
| 10 | RECV_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Receipt Status
C=Closed Receipt H=Hold Receipt M=Moved to Destination N=PO Not Received O=Open P=PO Partially Received R=Fully Received X=Canceled |
| 11 | CHNG_ORD_BATCH | Number(3,0) | SMALLINT NOT NULL | Change Order Number |
| 12 | HOLD_STATUS | Character(1) | VARCHAR2(1) NOT NULL | Hold From Further Processing |
| 13 | BACKORDER_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Back Order Status
1=Not Backordered 2=Backordered 3=Backordered Received |
| 14 | BUDGET_HDR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Budget Checking Header Status
E=Error in Budget Check I=Document In Processing N=Not Budget Checked P=Provisionally Valid V=Valid |
| 15 | BUDGET_HDR_STS_NP | Character(1) | VARCHAR2(1) NOT NULL |
Budget Ch'k Hdr Sts NonProrate
E=Error in Budget Check N=Not Budget Checked P=Provisionally Valid V=Valid Budget Check |
| 16 | DOC_TOL_HDR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Document Heade Document Tolerance Status
E=Error N=Not Checked R=Reset V=Valid |
| 17 | CC_SECURITY_ID | Number(10,0) | DECIMAL(10) NOT NULL | Procurement Card Number |
| 18 | CC_USE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Use Procurement Card
Y/N Table Edit Default Value: N |