| # |
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 |
PO_ID_FROM |
Character(10) |
VARCHAR2(10) NOT NULL |
From/To
Prompt Table:
PO_HDR_RC_WB_VW
|
| 5 |
PO_ID_TO |
Character(10) |
VARCHAR2(10) NOT NULL |
PO_ID in a range
Prompt Table:
PO_HDR_RC_WB_VW
|
| 6 |
PO_DT_FROM |
Date(10) |
DATE |
From/To
|
| 7 |
PO_DT_TO |
Date(10) |
DATE |
Purchase Order Date
|
| 8 |
ACT_TO_DATE |
Date(10) |
DATE |
To Activity Date
|
| 9 |
ACT_FROM_DATE |
Date(10) |
DATE |
From Activity Date
|
| 10 |
DUE_DATE |
Date(10) |
DATE |
Delivery Due Date from PO
|
| 11 |
DUE_DT_END |
Date(10) |
DATE |
End Due Date
|
| 12 |
RECV_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Receiving Required
N=Optional
X=Do Not
Y=Required
Default Value: N
|
| 13 |
RECV_NOT_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Receiving Not Required
Y/N Table Edit
Default Value: N
|
| 14 |
RECV_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Receipt Option
A=All
F=Fully Received
N=Not Received
P=Partially Received
|
| 15 |
PO_RC_MATCH_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Match Status
A=All
F=Fully Matched
N=None
P=Partial Match
|
| 16 |
MATCH_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Requires Matching
Y/N Table Edit
Default Value: N
|
| 17 |
PO_MATCH_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Matching Not Required
Y/N Table Edit
Default Value: N
|
| 18 |
CANCEL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel PO
B=Both
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 19 |
APPROVAL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Item Definition Approved
A=Approved
D=Denied
P=Pending
Y/N Table Edit
Default Value: N
|
| 20 |
OPEN_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Open
Y/N Table Edit
Default Value: N
|
| 21 |
DISPATCH_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Dispatch Flag
Y/N Table Edit
Default Value: N
|
| 22 |
BUSINESS_UNIT_REQ |
Character(5) |
VARCHAR2(5) NOT NULL |
Requesting Business Unit
Prompt Table:
SP_BU_PM_NONVW
|
| 23 |
REQ_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Requisition ID
Prompt Table:
REQ_HDR
|
| 24 |
BUYER_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Buyer
Prompt Table:
BUYER_ALL_VW
|
| 25 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
Prompt Table:
ITM_PURCH_VW
|
| 26 |
PO_OPEN_ENC_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Open Encumbrances
Y/N Table Edit
|
| 27 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table:
VENDOR_VW
|
| 28 |
CNTRCT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SP_SETID_NONVW
|
| 29 |
CNTRCT_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Buying Agreement ID
Prompt Table:
PO_L1_CNTRCT_VW
|
| 30 |
VERSION_NBR |
Number(5,0) |
INTEGER NOT NULL |
Contract Version number
Prompt Table:
PO_L3_CNTRCT_VW
|
| 31 |
RELEASE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Release Number
Prompt Table:
PO_L2_CNTRCT_VW
|
| 32 |
GPO_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
GPO ID
Prompt Table:
GPO_TBL_VW
|
| 33 |
GPO_CNTRCT_NBR |
Character(25) |
VARCHAR2(25) NOT NULL |
GPO Contract Number
|
| 34 |
CC_SECURITY_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Procurement Card Number
|
| 35 |
CC_USE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Procurement Card
Y/N Table Edit
Default Value: N
|
| 36 |
PEND_APPR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
PENDING APPROVAL FLAG
Y/N Table Edit
Default Value: N
|
| 37 |
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.
|
| 38 |
DENY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Denied
Y/N Table Edit
Default Value: N
|