| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
|
| 2 |
BUSPROCNAME_REQ |
Character(30) |
VARCHAR2(30) NOT NULL |
Req Approval Business Process
Prompt Table:
BUSPROCNAME_VW
|
| 3 |
REQ_AMT_APPR_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Req Amount Approval Needed
Y/N Table Edit
Default Value: N
|
| 4 |
APPR_RULE_REQ_AMT |
Character(30) |
VARCHAR2(30) NOT NULL |
Req Amount Approval Rule
Prompt Table:
REQ_APPR_RUL_VW
|
| 5 |
REQ_CF_APPR_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Req ChartField Approval Needed
Y/N Table Edit
Default Value: N
|
| 6 |
APPR_RULE_REQ_CF |
Character(30) |
VARCHAR2(30) NOT NULL |
Req ChartField Approval Rule
Prompt Table:
REQ_APPR_RUL_VW
|
| 7 |
PV_COMM_APPR_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Comm Approval Required
Y/N Table Edit
Default Value: N
|
| 8 |
REQ_RESUBMIT_DECR |
Character(1) |
VARCHAR2(1) NOT NULL |
Resubmit Requisition
Y/N Table Edit
Default Value: N
|
| 9 |
RESUBMIT_LINE |
Character(1) |
VARCHAR2(1) NOT NULL |
Resubmit Line for Approval
Y/N Table Edit
Default Value: N
|
| 10 |
PV_APPR_RULE_COMM |
Character(30) |
VARCHAR2(30) NOT NULL |
Approval Rule
Prompt Table:
REQ_APPR_RUL_VW
|
| 11 |
PV_SCHED_APPR_PROC |
Character(1) |
VARCHAR2(1) NOT NULL |
Schedule Approval Process
Y/N Table Edit
Default Value: N
|
| 12 |
PV_CAT_SRC_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Item Source Option
1=Master Items Only
2=Master and Express Items
3=Express Items Only
Default Value: 1
|
| 13 |
ALLOW_REQ_CHANGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Req Change in Purchasing
Y/N Table Edit
Default Value: Y
|
| 14 |
PV_SHOW_POACK_ICN |
Character(1) |
VARCHAR2(1) NOT NULL |
Show PO acknowledgement icon in the ePro Requisition Cycle.
Y/N Table Edit
Default Value: N
|
| 15 |
PV_SHOW_ASN_ICN |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Advance Shipment Notice icon in the ePro Requisition Cycle.
Y/N Table Edit
Default Value: N
|
| 16 |
REGION_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Req Region Security
Y/N Table Edit
Default Value: N
|
| 17 |
ALLOW_CHNG_DPO |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Changes to Dispatched PO
Y/N Table Edit
Default Value: Y
|
| 18 |
CATEGORY_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Category ID
|
| 19 |
DFLT_UNIT_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Default Unit of Measure
Prompt Table:
UNITS_TBL
|