PV_VCHR_REQ_WL(SQL Table) |
Index Back |
|---|---|
Receipt notification WL8/30/07 - JK - Added Record Description. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSPROCNAME |
Character(30) | VARCHAR2(30) NOT NULL |
Business Process Name (see PSBUSPROCDEFN).
Prompt Table: PSBUSPROCDEFN |
| 2 | ACTIVITYNAME |
Character(30) | VARCHAR2(30) NOT NULL |
Name of a Business Process Activity (see PSACTIVITYDEFN).
Prompt Table: ACTIVITY_PROMPT |
| 3 | EVENTNAME |
Character(30) | VARCHAR2(30) NOT NULL |
Defines a routing event for PS Workflow
Prompt Table: PSEVENTDEFN |
| 4 | WORKLISTNAME |
Character(30) | VARCHAR2(30) NOT NULL |
Worklist Name
Prompt Table: WORKLIST_PRMPT |
| 5 | INSTANCEID |
Number(10,0) | DECIMAL(10) NOT NULL |
For a given worklist the unique number of rows in PSWORKLIST
Default Value: 999999999 |
| 6 | TRANSACTIONID |
Number(10,0) | DECIMAL(10) NOT NULL | Transaction Identifier |
| 7 | BUSINESS_UNIT_PO |
Character(5) | VARCHAR2(5) NOT NULL | PO Business Unit |
| 8 | BUSINESS_UNIT_REQ |
Character(5) | VARCHAR2(5) NOT NULL | Requesting Business Unit |
| 9 | PO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 10 | REQ_ID |
Character(10) | VARCHAR2(10) NOT NULL | Requisition ID |
| 11 | DUE_DT | Date(10) | DATE | Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received. |