RUN_CNTL_PORO2

(SQL Table)
 Index Back

Run Control for POROLLVW

Date Initials Reference # Description 08/29/2007 PKL F-AHAYT-01P75 9.1 PO Rollover Enhancement

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_PM_NONVW

4 SEARCH_ID Character(10) VARCHAR2(10) NOT NULL Search ID
5 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer

Prompt Table: BUYER_TBL

6 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VENDOR_PO_VW

7 PO_ID_FROM Character(10) VARCHAR2(10) NOT NULL From PO

Prompt Table: PO_HDR_ROLLVW

8 PO_ID_TO Character(10) VARCHAR2(10) NOT NULL PO_ID in a range

Prompt Table: PO_HDR_ROLLVW

9 FROM_DATE Date(10) DATE From Date
10 TO_DATE Date(10) DATE To Date
11 ROLL_STAT_N Character(1) VARCHAR2(1) NOT NULL None

Default Value: Y

12 ROLL_STAT_P Character(1) VARCHAR2(1) NOT NULL Pending

Default Value: Y

13 ROLL_STAT_M Character(1) VARCHAR2(1) NOT NULL Mid Roll
14 ROLL_STAT_R Character(1) VARCHAR2(1) NOT NULL Rolled
15 ROLL_STAT_D Character(1) VARCHAR2(1) NOT NULL Disqualified

Y/N Table Edit

Default Value: Y

16 ROLL_STAT_H Character(1) VARCHAR2(1) NOT NULL Hold from Rollover
17 PO_BUGL_FROM Character(5) VARCHAR2(5) NOT NULL GL Business Unit

Prompt Table: SP_BUPRCR_NONVW

18 PO_BUGL_TO Character(5) VARCHAR2(5) NOT NULL Business Unit GL

Prompt Table: SP_BUPRCR_NONVW

19 PO_ACCOUNT_FROM Character(10) VARCHAR2(10) NOT NULL Account

Prompt Table: %EDIT_ACCOUNT

20 PO_ACCOUNT_TO Character(10) VARCHAR2(10) NOT NULL Account

Prompt Table: %EDIT_ACCOUNT

21 PO_DEPTID_FROM Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: %EDIT_DEPT

22 PO_DEPTID_TO Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: %EDIT_DEPT

23 PO_OPER_UNIT_FROM Character(8) VARCHAR2(8) NOT NULL Operating Unit

Prompt Table: %EDIT_OPER_UNIT

24 PO_OPER_UNIT_TO Character(8) VARCHAR2(8) NOT NULL Operating Unit

Prompt Table: %EDIT_OPER_UNIT

25 PO_PRODUCT_FROM Character(6) VARCHAR2(6) NOT NULL Product

Prompt Table: %EDIT_PRODUCT

26 PO_PRODUCT_TO Character(6) VARCHAR2(6) NOT NULL Product

Prompt Table: %EDIT_PRODUCT

27 PO_FUND_CODE_FROM Character(5) VARCHAR2(5) NOT NULL Fund Code

Prompt Table: %EDIT_FUND_CODE

28 PO_FUND_CODE_TO Character(5) VARCHAR2(5) NOT NULL Fund Code

Prompt Table: %EDIT_FUND_CODE

29 PO_CLASS_FLD_FROM Character(5) VARCHAR2(5) NOT NULL Class Field

Prompt Table: %EDIT_CLASS_FLD

30 PO_CLASS_FLD_TO Character(5) VARCHAR2(5) NOT NULL Class Field

Prompt Table: %EDIT_CLASS_FLD

31 PO_PROG_CODE_FROM Character(5) VARCHAR2(5) NOT NULL Program Code ChartField

Prompt Table: %EDIT_PROG_CODE

32 PO_PROG_CODE_TO Character(5) VARCHAR2(5) NOT NULL Program Code ChartField

Prompt Table: %EDIT_PROG_CODE

33 GL_BU_OPER Character(1) VARCHAR2(1) NOT NULL GL Business Unit
1==
2=<>
3=>
4=<
5=>=
6=<=
7=begins with
8=not begins with
9=is empty
A=between
B=not between
C=in
D=Contains
E=Not In
F=Is not empty

Default Value: 7

34 ACC_OPER Character(1) VARCHAR2(1) NOT NULL Account
1==
2=<>
3=>
4=<
5=>=
6=<=
7=begins with
8=not begins with
9=is empty
A=between
B=not between
C=in
D=Contains
E=Not In
F=Is not empty

Default Value: 7

35 DEPT_OPER Character(1) VARCHAR2(1) NOT NULL Department
1==
2=<>
3=>
4=<
5=>=
6=<=
7=begins with
8=not begins with
9=is empty
A=between
B=not between
C=in
D=Contains
E=Not In
F=Is not empty

Default Value: 7

36 OP_UNIT_OPER Character(1) VARCHAR2(1) NOT NULL Operating Unit
1==
2=<>
3=>
4=<
5=>=
6=<=
7=begins with
8=not begins with
9=is empty
A=between
B=not between
C=in
D=Contains
E=Not In
F=Is not empty

Default Value: 7

37 PROD_OPER Character(1) VARCHAR2(1) NOT NULL Product
1==
2=<>
3=>
4=<
5=>=
6=<=
7=begins with
8=not begins with
9=is empty
A=between
B=not between
C=in
D=Contains
E=Not In
F=Is not empty

Default Value: 7

38 FUND_OPER Character(1) VARCHAR2(1) NOT NULL Fund
1==
2=<>
3=>
4=<
5=>=
6=<=
7=begins with
8=not begins with
9=is empty
A=between
B=not between
C=in
D=Contains
E=Not In
F=Is not empty

Default Value: 7

39 CLASS_OPER Character(1) VARCHAR2(1) NOT NULL Class
1==
2=<>
3=>
4=<
5=>=
6=<=
7=begins with
8=not begins with
9=is empty
A=between
B=not between
C=in
D=Contains
E=Not In
F=Is not empty

Default Value: 7

40 PROG_OPER Character(1) VARCHAR2(1) NOT NULL Program
1==
2=<>
3=>
4=<
5=>=
6=<=
7=begins with
8=not begins with
9=is empty
A=between
B=not between
C=in
D=Contains
E=Not In
F=Is not empty

Default Value: 7

41 GLBUIN Character(254) VARCHAR2(254) NOT NULL IN
42 ACCIN Character(254) VARCHAR2(254) NOT NULL IN
43 CLASSIN Character(254) VARCHAR2(254) NOT NULL IN
44 DEPIN Character(254) VARCHAR2(254) NOT NULL IN
45 FUNDIN Character(254) VARCHAR2(254) NOT NULL IN
46 OPUNITIN Character(254) VARCHAR2(254) NOT NULL IN
47 PRODIN Character(254) VARCHAR2(254) NOT NULL IN
48 PROGIN Character(254) VARCHAR2(254) NOT NULL IN
49 PO_ACC_PB Character(1) VARCHAR2(1) NOT NULL ACC
50 PO_CLASS_PB Character(1) VARCHAR2(1) NOT NULL CLASS
51 PO_DEPT_PB Character(1) VARCHAR2(1) NOT NULL GLBU
52 PO_FUND_PB Character(1) VARCHAR2(1) NOT NULL GLBU
53 PO_GL_BU_PB Character(1) VARCHAR2(1) NOT NULL GLBU
54 PO_OPUNIT_PB Character(1) VARCHAR2(1) NOT NULL GLBU
55 PO_PROD_PB Character(1) VARCHAR2(1) NOT NULL GLBU
56 PO_PROG_PB Character(1) VARCHAR2(1) NOT NULL GLBU
57 PO_ALTACCT_FROM Character(10) VARCHAR2(10) NOT NULL Alternate Account

Prompt Table: %EDIT_ALTACCT

58 PO_ALTACCT_PB Character(1) VARCHAR2(1) NOT NULL altacct
59 PO_ALTACCT_TO Character(10) VARCHAR2(10) NOT NULL Alternate Account

Prompt Table: %EDIT_ALTACCT

60 ALTACCTIN Character(254) VARCHAR2(254) NOT NULL IN
61 ALT_ACC_OPER Character(1) VARCHAR2(1) NOT NULL Alternate Account
1==
2=<>
3=>
4=<
5=>=
6=<=
7=begins with
8=not begins with
9=is empty
A=between
B=not between
C=in
D=Contains
E=Not In
F=Is not empty

Default Value: 7

62 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
63 RUN_EXCEP Character(1) VARCHAR2(1) NOT NULL Run Exception Report

Y/N Table Edit

64 RUN_EXCEP_ORDER Character(1) VARCHAR2(1) NOT NULL Report Sort Order
E=Exception Type
P=Purchase Order

Default Value: E

65 WHERE_CF Long Character CLOB CF Where
66 BUDGET_DT_OPER Character(1) VARCHAR2(1) NOT NULL Budget Date
1==
2=<>
3=>
4=<
5=>=
6=<=
A=between

Default Value: 1

67 BUDGET_DT_FROM Date(10) DATE Budget Date
68 BUDGET_DT_TO Date(10) DATE Budget Date