PO_ROLLVW_ENC

(SQL Table)
Index Back

PO_POROLLVW Table

PO_POROLLVW Table

# 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 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
4 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
5 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
6 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
7 PO_ENCUM_NET Signed Number(28,3) DECIMAL(26,3) NOT NULL Outstanding PO Encumbrance
8 PO_ENCUM_NET_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Outstanding PO Encumbrance Bse
9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
10 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency