PV_PO_DIS_ERR(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EIP_CTL_ID |
Character(25) | VARCHAR2(25) NOT NULL | Enterprise Components EIP (enterprise integration point) control field |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | PO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 4 | PV_PO_STS | Character(1) | VARCHAR2(1) NOT NULL |
PO status
1=Sent to MarketPlace 2=Received by MarketPlace 3=Processing MarketPlace Order 4=Accepted MarketPlace Order 5=Not Accepted by MarketPlace 6=Cancelled by MarketPlace 7=Prepayment Required 8=Completed at MarketPlace 9=Other MarketPlace Order Status D=Dispatched E=Error P=Published R=Rejected |
| 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 | DATE_ADDED | Date(10) | DATE | Date Added |
| 7 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 8 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 9 | MESSAGE_TEXT | Character(100) | VARCHAR2(100) NOT NULL | Message Text This field refers to the Text for a particular Message Number in the Message Catalog. |
| 10 | PV_DATETIME_ADDED | DateTime(26) | TIMESTAMP | 03/16/2010 VR 1967264000 Ensure proper messages/status are displayed while dispatching using the ePro online page |