| # |
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 |
LINE_NBR_FROM |
Number(5,0) |
INTEGER NOT NULL |
Line Number From
|
| 7 |
LINE_NBR_TO |
Number(5,0) |
INTEGER NOT NULL |
Line number To
|
| 8 |
PO_DT_FROM |
Date(10) |
DATE |
From/To
|
| 9 |
PO_DT_TO |
Date(10) |
DATE |
Purchase Order Date
|
| 10 |
ACT_TO_DATE |
Date(10) |
DATE |
To Activity Date
|
| 11 |
ACT_FROM_DATE |
Date(10) |
DATE |
From Activity Date
|
| 12 |
DUE_DATE |
Date(10) |
DATE |
Delivery Due Date from PO
|
| 13 |
DUE_DT_END |
Date(10) |
DATE |
End Due Date
|
| 14 |
BUYER_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Buyer
Prompt Table:
BUYER_ALL_VW
|
| 15 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
Prompt Table:
ITM_PURCH_VW
|
| 16 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table:
VENDOR_VW
|
| 17 |
CNTRCT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SP_SETID_NONVW
|
| 18 |
CNTRCT_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Buying Agreement ID
Prompt Table:
PO_L1_CNTRCT_VW
|
| 19 |
GPO_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
GPO ID
Prompt Table:
GPO_TBL_VW
|
| 20 |
CLOSE_DELAY_DAYS |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
Close Processing Delay Days
|
| 21 |
RECV_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Receiving Required
N=Optional
X=Do Not
Y=Required
|
| 22 |
AMT_ONLY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Amount Only
N=No
Y=Yes
Y/N Table Edit
|
| 23 |
MATCH_LINE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Match Line Option
E=ERS
F=Full Match
N=Don't Match
|
| 24 |
MATCH_STATUS_LN_PO |
Character(1) |
VARCHAR2(1) NOT NULL |
Match Status
M=Matched
N=Not Matched
P=Partially Matched
|
| 25 |
SERVERNAME |
Character(8) |
VARCHAR2(8) NOT NULL |
Server Name
Prompt Table:
SERVERDEFN
|
| 26 |
RUNCNTLID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
Prompt Table:
RECV_RUN_CNTL
|
| 27 |
OUTDESTFORMAT_VR |
Character(3) |
VARCHAR2(3) NOT NULL |
Output Dest Format
2=Acrobat (*.pdf)
|
| 28 |
OUTDESTTYPE_VR |
Character(3) |
VARCHAR2(3) NOT NULL |
Output Dest Type
2=File
6=Web
|