PO_ROLLOVER_TBL

(SQL Table)
Index Back

PO Rollover Selected PO

607162 - 03/17/2005- Modified field CURRENCY_CD_BASE as a key field

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 SEARCH_ID Character(10) VARCHAR2(10) NOT NULL Search ID
4 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
5 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
6 PO_DT Date(10) DATE Date
7 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
8 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
9 BUDGET_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Budget Checking Header Status
E=Error in Budget Check
I=Document In Processing
N=Not Budget Checked
P=Provisionally Valid
V=Valid
10 PO_ENCUM_NET Signed Number(28,3) DECIMAL(26,3) NOT NULL Outstanding PO Encumbrance
11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
12 PO_ENCUM_NET_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Outstanding PO Encumbrance Bse
13 OPRID_LAST_UPDT Character(30) VARCHAR2(30) NOT NULL Last User to Update
14 LINE_SELECT Character(1) VARCHAR2(1) NOT NULL Line Selection
N=No
Y=Yes
15 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
16 ENCUMB_OPEN_FLG Character(1) VARCHAR2(1) NOT NULL Keep PY Encumbrances Open
17 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp