| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table:
OPRID_VW
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
PL_POST_DATA_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Data Type
010=Purchases
020=Production
030=Transfers
040=Planned Purchases
050=Planned Production
060=Planned Transfers
070=Stock Requests
080=Quotes
090=Sales Orders
100=Buying Agreements
110=Projected Useup
|
| 4 |
SELECT_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Select Option
Y/N Table Edit
Default Value: Y
|
| 5 |
PL_IGNORE_CUTOFF |
Character(1) |
VARCHAR2(1) NOT NULL |
Ignore Cutoff Fence
Y/N Table Edit
Default Value: N
|
| 6 |
PL_TOLERANCE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Inside Tolerance
1=Approve
2=Error
3=Ignore
4=Accept
Default Value: 4
|
| 7 |
PL_APPROVAL_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval Options
1=Manual
2=Auto All
3=Auto Horiz
Default Value: 1
|
| 8 |
SPL_PEG_APPRV_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Pegged Approval Option
1=Approve
2=Error
3=Ignore
4=Accept
Default Value: 4
|
| 9 |
PL_APPROVE_FDATE |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
From Days
|
| 10 |
PL_APPROVE_TDATE |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
To Days
Default Value: 365
|
| 11 |
PL_APPROVE_ODATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Based on
1=Order Start Date
2=Order End Date
3=Both
Default Value: 1
|
| 12 |
PL_APPROVE_SCHED |
Character(1) |
VARCHAR2(1) NOT NULL |
Approve Schedules
Y/N Table Edit
Default Value: N
|
| 13 |
PL_RCV_CHG_TIME |
Character(1) |
VARCHAR2(1) NOT NULL |
Track Time Changes
Y/N Table Edit
Default Value: Y
|
| 14 |
ALLOW_VLTN_APP |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Violation Approval
Y/N Table Edit
Default Value: N
|
| 15 |
PL_EXPEDITE_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
12/12/2007 JAA 9.1 Apply Planning Updates. Field used for PO expedite option in Post Update
1=Planning Time Fence
2=Supplier Lead Time
Default Value: 1
|