PROCESS_INSTANCEA=All BUs
B=1 Bus Unit
D=1 Document
B=Specific Business Unit
D=Specific Document
R=Range of Documents
Default Value: D
A=All
R=Range
V=Value
A=All
R=Range
V=Value
E=Existing Accounting Date
S=Specify Accounting Date
REQ_REOPEN_AET(SQL Table) |
Index Back |
|---|---|
REQ Reopen AET Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | RUN_DT | Date(10) | DATE | Run Date |
| 5 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 6 | REQ_ID | Character(10) | VARCHAR2(10) NOT NULL | Requisition ID |
| 7 | PO_POST_RUN_IND | Character(1) | VARCHAR2(1) NOT NULL |
/* 615584 05/05/2005 - Added a new label for RTV Recon Process */
A=All BUs B=1 Bus Unit D=1 Document |
| 8 | COMMITMENT_CNTL_PO | Character(1) | VARCHAR2(1) NOT NULL | Commitment Control on PO |
| 9 | FROM_DATE | Date(10) | DATE | From Date |
| 10 | TO_DATE | Date(10) | DATE | To Date |
| 11 | RECORD_COUNT | Number(7,0) | INTEGER NOT NULL | Count of Records |
| 12 | REQUESTOR_ID | Character(30) | VARCHAR2(30) NOT NULL | Requestor id |
| 13 | REOPEN_RUN_IND | Character(1) | VARCHAR2(1) NOT NULL |
Reopen Request Parameters
B=Specific Business Unit D=Specific Document R=Range of Documents Default Value: D |
| 14 | REQ_ID_FROM | Character(10) | VARCHAR2(10) NOT NULL | Requisition ID From |
| 15 | REQ_ID_TO | Character(10) | VARCHAR2(10) NOT NULL | Requisition ID To |
| 16 | REQ_DT_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Req Date Option
A=All R=Range V=Value |
| 17 | REQ_DT_FROM | Date(10) | DATE | Requisition Date |
| 18 | REQ_DT_TO | Date(10) | DATE | Requisition Date |
| 19 | ACTIVITY_DT_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Activity Date Option
A=All R=Range V=Value |
| 20 | ACTIVITY_DATE | Date(10) | DATE | Last Activity |
| 21 | REOPEN_LAST_CLOSE | Character(1) | VARCHAR2(1) NOT NULL | Reopen Last PO/Req Close Run |
| 22 | USE_ACCTNG_DT_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Open with Accounting Date Option used in ReOpen PO/REq WB and Run Control Pages
E=Existing Accounting Date S=Specify Accounting Date |
| 23 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 24 | PO_REOPEN_REQ_FLG | Character(1) | VARCHAR2(1) NOT NULL | Flag indicates if the Requisition Schedule should be reopen for the sourced PO Sched/Distirbution |
| 25 | REQ_LINE_NBR | Number(5,0) | INTEGER NOT NULL | Requisition Line Number |
| 26 | REQ_SCHED_NBR | Number(3,0) | SMALLINT NOT NULL | Requisition Schedule Number |
| 27 | SELECT_PARM1 | Character(254) | VARCHAR2(254) NOT NULL | Dynamic Where Select Parms 1 |
| 28 | SELECT_PARM2 | Character(254) | VARCHAR2(254) NOT NULL | Dynamic Where Select Parms 2 |
| 29 | SELECT_PARM3 | Character(254) | VARCHAR2(254) NOT NULL | Dynamic Where Select Parms 3 |
| 30 | ROWS_ERROR | Number(10,0) | DECIMAL(10) NOT NULL | Total Rows with Error |
| 31 | PC | Character(1) | VARCHAR2(1) NOT NULL | Projects |
| 32 | LAST_DTTM_UPDATE | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 33 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |