PO_REOPEN_AET(SQL Table) |
Index Back |
|---|---|
PO 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 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 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 | 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 |
| 10 | PO_ID_FROM | Character(10) | VARCHAR2(10) NOT NULL | From/To |
| 11 | PO_ID_TO | Character(10) | VARCHAR2(10) NOT NULL | PO_ID in a range |
| 12 | PO_DT_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
PO Date Option
A=All R=Range S=Some V=Value |
| 13 | PO_DT_FROM | Date(10) | DATE | From/To |
| 14 | PO_DT_TO | Date(10) | DATE | Purchase Order Date |
| 15 | ACTIVITY_DT_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Activity Date Option
A=All R=Range V=Value |
| 16 | ACTIVITY_DATE | Date(10) | DATE | Last Activity |
| 17 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 18 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 19 | BUYER_ID | Character(30) | VARCHAR2(30) NOT NULL | Buyer |
| 20 | PO_REF | Character(30) | VARCHAR2(30) NOT NULL | Specifies the purchase order number associated with a receivables item. |
| 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 | REOPEN_REQ_FLG | Character(1) | VARCHAR2(1) NOT NULL | Reopen AssociatedRequisitions? |
| 25 | REQ_ID | Character(10) | VARCHAR2(10) NOT NULL | Requisition ID |
| 26 | REQ_LINE_NBR | Number(5,0) | INTEGER NOT NULL | Requisition Line Number |
| 27 | REQ_SCHED_NBR | Number(3,0) | SMALLINT NOT NULL | Requisition Schedule Number |
| 28 | PC | Character(1) | VARCHAR2(1) NOT NULL | Projects |
| 29 | SELECT_PARM1 | Character(254) | VARCHAR2(254) NOT NULL | Dynamic Where Select Parms 1 |
| 30 | ROWS_ERROR | Number(10,0) | DECIMAL(10) NOT NULL | Total Rows with Error |
| 31 | TEMP_FLD | Character(1) | VARCHAR2(1) NOT NULL | Temporary Field for App Engine |
| 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 | SECURITY_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Type of Security
C=Permission List Level Security N=No Security O=User ID Level Security |
| 34 | BU_SECURITY | Character(1) | VARCHAR2(1) NOT NULL | Business Unit Security |