BUSINESS_UNITPO_IDN=No
Y=Yes
Y/N Table Edit
B=Both Pending
D=Disqualified
H=Hold From Rollover
M=Mid Roll
P=Pending
R=Roll Completed
V=One Receipt partially vchrd
Y/N Table Edit
PO_ROLL_SELECT(SQL Table) |
Index Back |
|---|---|
PO Rollover Selection |
| # | 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 | SEARCH_ID | Character(10) | VARCHAR2(10) NOT NULL | Search ID |
| 4 | OPRID_LAST_UPDT | Character(30) | VARCHAR2(30) NOT NULL | Last User to Update |
| 5 | LINE_SELECT | Character(1) | VARCHAR2(1) NOT NULL |
Line Selection
N=No Y=Yes Y/N Table Edit |
| 6 | ROLL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Roll Status
B=Both Pending D=Disqualified H=Hold From Rollover M=Mid Roll P=Pending R=Roll Completed V=One Receipt partially vchrd |
| 7 | ENCUMB_OPEN_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Keep PY Encumbrances Open
Y/N Table Edit |
| 8 | DT_TIMESTAMP | DateTime(26) | TIMESTAMP | Date Timestamp |