| # |
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
Prompt Table:
SP_BU_PM_NONVW
|
| 2 |
WORKBENCH_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
WorkBench ID
|
| 3 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 4 |
FROM_REQ |
Character(10) |
VARCHAR2(10) NOT NULL |
From Req
Prompt Table:
REQ_HDR_RC_WB_V
|
| 5 |
TO_REQ |
Character(10) |
VARCHAR2(10) NOT NULL |
To Req
Prompt Table:
REQ_HDR_RC_WB_V
|
| 6 |
REQ_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Requisition Name
Prompt Table:
REQNM_RC_WB_V
|
| 7 |
REQ_DT_FROM |
Date(10) |
DATE |
Requisition Date
|
| 8 |
REQ_DT_TO |
Date(10) |
DATE |
Requisition Date
|
| 9 |
ACT_TO_DATE |
Date(10) |
DATE |
To Activity Date
|
| 10 |
ACT_FROM_DATE |
Date(10) |
DATE |
From Activity Date
|
| 11 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table:
VENDOR_VW
|
| 12 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
Prompt Table:
ITM_PURCH_VW
|
| 13 |
OPEN_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Open
Y/N Table Edit
Default Value: N
|
| 14 |
APPROVAL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Item Definition Approved
A=Approved
D=Denied
P=Pending
Y/N Table Edit
Default Value: N
|
| 15 |
CANCEL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel PO
B=Both
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 16 |
DENY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Denied
Y/N Table Edit
|
| 17 |
LINE_APPROVED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Lines Approved
Y/N Table Edit
Default Value: N
|
| 18 |
SOURCE_OPTIONS |
Character(1) |
VARCHAR2(1) NOT NULL |
Source
A=Available
C=Complete
Default Value: A
|
| 19 |
DUE_DT |
Date(10) |
DATE |
Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
|
| 20 |
DUE_DT_END |
Date(10) |
DATE |
End Due Date
|
| 21 |
PO_OPEN_ENC_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Open Encumbrances
Y/N Table Edit
|
| 22 |
REQUESTOR_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Requestor id
Prompt Table:
RQSTR_ACTIVE_VW
|
| 23 |
CC_SECURITY_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Procurement Card Number
|
| 24 |
CC_USE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Procurement Card
Y/N Table Edit
Default Value: N
|
| 25 |
PEND_APPR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
PENDING APPROVAL FLAG
Y/N Table Edit
Default Value: N
|
| 26 |
NO_OF_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Used as criteria for the number of daily route scheduling option on the Route Calendar Maintenance Panel to determine every how many days calendar dates will be generated for the daily option.
|