| # |
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 |
ACTIVITY_DATE |
Date(10) |
DATE |
Last Activity
|
| 4 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_PM_NONVW
|
| 5 |
PO_POST_RUN_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
/* 615584 05/05/2005 - Added a new label for RTV Recon Process */
A=All BUs
B=1 Bus Unit
D=1 Document
Default Value: B
|
| 6 |
REQ_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Requisition ID
Prompt Table:
%EDITTABLE
|
| 7 |
PO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Purchase Order
Prompt Table:
%EDITTABLE2
|
| 8 |
PRCS_OPTION_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Processing Option ID
Default Value: 00001
|
| 9 |
MASS_LIQUIDATE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Mass Liquidate ID
|
| 10 |
PO_LIQUIDATE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
PO Liquidate Options
A=All
P=Partial
|
| 11 |
BUDGET_PERIOD |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Period
|
| 12 |
WORKBENCH_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
WorkBench ID
|
| 13 |
BATCH_LOCATION |
Character(1) |
VARCHAR2(1) NOT NULL |
Batch Location
R=Run Control Page
W=WorkBench Page
Default Value: R
|
| 14 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|
| 15 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 16 |
RTV_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Return To Vendor ID
Prompt Table:
RTV_HDR_VW
|
| 17 |
BUDGET_DT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Budget Date
|
| 18 |
USE_CURRENT_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to determine if the current date should be used as the To date when running a process. Used for scheduled processes.
|
| 19 |
REOPEN_RUN_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Reopen Request Parameters
B=Specific Business Unit
D=Specific Document
R=Range of Documents
Default Value: D
|
| 20 |
PO_ID_FROM |
Character(10) |
VARCHAR2(10) NOT NULL |
From/To
Prompt Table:
PO_RC_HDR_VW
|
| 21 |
PO_ID_TO |
Character(10) |
VARCHAR2(10) NOT NULL |
PO_ID in a range
Prompt Table:
PO_RC_HDR_VW
|
| 22 |
PO_DT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
PO Date Option
A=All
R=Range
S=Some
V=Value
Default Value: A
|
| 23 |
PO_DT_FROM |
Date(10) |
DATE |
From/To
|
| 24 |
PO_DT_TO |
Date(10) |
DATE |
Purchase Order Date
|
| 25 |
ACTIVITY_DT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Activity Date Option
A=All
R=Range
V=Value
Default Value: A
|
| 26 |
VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor SetID
|
| 27 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table:
VENDOR_VW
|
| 28 |
BUYER_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Buyer
Prompt Table:
BUYER_ALL_VW
|
| 29 |
PO_REF |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the purchase order number associated with a receivables item.
|
| 30 |
REOPEN_LAST_CLOSE |
Character(1) |
VARCHAR2(1) NOT NULL |
Reopen Last PO/Req Close Run
Y/N Table Edit
Default Value: N
|
| 31 |
USE_ACCTNG_DT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Open with Accounting Date Option used in ReOpen PO/REq WB and Run Control Pages
E=Existing Accounting Date
S=Specify Accounting Date
Default Value: S
|
| 32 |
REOPEN_REQ_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Reopen AssociatedRequisitions?
Y/N Table Edit
Default Value: N
|
| 33 |
REQ_ID_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Req ID Option
A=All
R=Range
V=Value
Default Value: A
|
| 34 |
REQ_ID_FROM |
Character(10) |
VARCHAR2(10) NOT NULL |
Requisition ID From
Prompt Table:
REQ_RC_HDR
|
| 35 |
REQ_ID_TO |
Character(10) |
VARCHAR2(10) NOT NULL |
Requisition ID To
Prompt Table:
REQ_RC_HDR
|
| 36 |
REQ_DT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Req Date Option
A=All
R=Range
V=Value
Default Value: A
|
| 37 |
REQ_DT_FROM |
Date(10) |
DATE |
Requisition Date
|
| 38 |
REQ_DT_TO |
Date(10) |
DATE |
Requisition Date
|
| 39 |
REQUESTOR_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Requestor id
Prompt Table:
RQSTR_ACTIVE_VW
|