PO_POROLL2_AET

(SQL Table)
Index Back

Run Control for POROLL2

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
3 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
4 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
5 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
6 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
7 RUN_DT Date(10) DATE Run Date
8 ROLL_ENC_OPTION Character(1) VARCHAR2(1) NOT NULL Roll Encumbrance
B=Roll Business Unit
E=Roll Encumbrance
9 PROCESS_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Process Frequency
A=Always Process
N=Don't Run
O=Process Once
10 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_PM_NONVW

11 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
12 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
13 ASOFDATE Date(10) DATE As of Date
14 FROM_DATE Date(10) DATE From Date
15 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
16 SEQ_NUM_TO Number(3,0) SMALLINT NOT NULL Sequence
17 BUDGET_DT Date(10) DATE Budget Date
18 BUDGET_DT_FROM Date(10) DATE Budget Date
19 BUDGET_DT_TO Date(10) DATE Budget Date
20 SETID Character(5) VARCHAR2(5) NOT NULL SetID
21 KK_ROLLED_SEQ Number(3,0) SMALLINT NOT NULL PO Rolled Sequence
22 RECNAME_SIBL Character(15) VARCHAR2(15) NOT NULL KK Source Header Record