| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_FS.OPRID
Prompt Table:
OPR_DEF_TBL_PM
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
REQUEST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Request ID
Default Value: 1
|
| 4 |
CHECK_BOX_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Check Box Indicator
N=Unchecked
Y=Checked
|
| 5 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 6 |
FILE_NAME |
Character(80) |
VARCHAR2(80) NOT NULL |
File Name
|
| 7 |
REVIEWED |
Character(1) |
VARCHAR2(1) NOT NULL |
Review Complete
N=No
Y=Yes
Y/N Table Edit
|
| 8 |
EXCEPTION_LBL |
Character(1) |
VARCHAR2(1) NOT NULL |
Exception
Y/N Table Edit
|
| 9 |
SORT_BY_VEND_BUYER |
Character(1) |
VARCHAR2(1) NOT NULL |
Sort By Supplier or Buyer
B=Buyer Name
V=Supplier Name
Default Value: V
|
| 10 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_PM_NONVW
|
| 11 |
CANCELLED_PO_FL |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Cancelled POs?
Y/N Table Edit
|
| 12 |
OPEN_PO_FL |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Open/Pending Appr POs?
Y/N Table Edit
|
| 13 |
VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor SetID
Prompt Table:
SP_SETVND_NONVW
|
| 14 |
INCLUDE_BACKORDERS |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Backorders Received
Y/N Table Edit
Default Value: Y
|
| 15 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table:
VENDOR_IST_VW
Set Control Field: VENDOR_SETID
|
| 16 |
FROM_DATE |
Date(10) |
DATE |
From Date
|
| 17 |
THRU_DATE |
Date(10) |
DATE |
Through Date
|
| 18 |
AS_OF_DATE |
Date(10) |
DATE |
As of Date
|
| 19 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table:
SP_SETID_NONVW
|
| 20 |
CART_SORT_OPTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Par Location Sort Option
01=Sort by Item
02=Sort by Compartment
03=Sort by Count Order
Default Value: 01
|
| 21 |
PO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Purchase Order
Prompt Table:
PO_HDR_VW
|
| 22 |
BUYER_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Buyer
Prompt Table:
BUYER_ACTIVE_VW
|
| 23 |
REQ_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Requisition ID
Prompt Table:
%EDITTABLE2
|
| 24 |
REQUESTOR_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Requestor id
Prompt Table:
REQUESTOR_TBL
|
| 25 |
DATE_SEL_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Date Selection
C=Current Date
M=Current Date Minus Days
N=No Selection by Date
P=Current Date Plus Days
S=Specified Date
|
| 26 |
DATE_SEL_DT |
Date(10) |
DATE |
03/23/2004 SFC Added PROD_COST_EFF_DT label
|
| 27 |
DATE_SEL_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Date Selection Number of Days
|
| 28 |
RECEIVER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Receiver number
Prompt Table:
RECV_HDR_BU_VW
|
| 29 |
CATEGORY_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Category Option
A=All
S=Specific
Default Value: A
|
| 30 |
CATEGORY_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Category SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table:
SP_SETID_NONVW
|
| 31 |
CATEGORY_CD |
Character(18) |
VARCHAR2(18) NOT NULL |
Category Code
Prompt Table:
%EDITTABLE3
|
| 32 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
Prompt Table:
%EDIT_ITEM_ID
|
| 33 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
%EDITTABLE2
|
| 34 |
DEPTID_2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Department ID
Prompt Table:
%EDITTABLE2
|
| 35 |
DEPTID_TO |
Character(10) |
VARCHAR2(10) NOT NULL |
To Department
Prompt Table:
%EDITTABLE2
|
| 36 |
DATE_SEL_DAYS2 |
Number(3,0) |
SMALLINT NOT NULL |
Date Selection Number of Days
|
| 37 |
DATE_SEL_DT2 |
Date(10) |
DATE |
Date Sel Date
|
| 38 |
DATE_SEL_OPT2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Date Selection
C=Current Date
M=Current Date Minus Days
N=No Selection by Date
P=Current Date Plus Days
S=Specified Date
|
| 39 |
TO_ITEMID |
Character(18) |
VARCHAR2(18) NOT NULL |
To Item ID
Prompt Table:
%EDIT_ITEM_ID
|
| 40 |
FROM_ITEMID |
Character(18) |
VARCHAR2(18) NOT NULL |
04/10/00 SCC (Internet Architecture): Add label ITEM_ID
Prompt Table:
%EDIT_ITEM_ID
|
| 41 |
INV_ITEM_LIST_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Item List Option
A=All Items
C=Category
F=Item Family
G=Item Group
R=Range of Items
S=Single Item
Default Value: A
|
| 42 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
Prompt Table:
%EDIT_BU_IN
|
| 43 |
BUSINESS_UNIT_RECV |
Character(5) |
VARCHAR2(5) NOT NULL |
Receiving Business Unit
Prompt Table:
%EDITTABLE2
|
| 44 |
INCLUDE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Landed Costs
Y/N Table Edit
Default Value: Y
|
| 45 |
RECPT_ACCRL_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Accrual Reporting Options
A=All
E=Expenses Only
I=Inventory Only
Default Value: A
|
| 46 |
DEPT_LIST_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Dept List Option
A=All Depts
R=Range Of Depts
S=Specific Dept
Default Value: A
|
| 47 |
BUS_UNIT_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Business Unit Option
A=All
S=Specific
Default Value: A
|
| 48 |
CART_OPTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Par Location Option
01=All Par Locations for Unit
02=Specific Par Location for Unit
03=All for Par Location Group
04=All Par Locations
Default Value: 04
|
| 49 |
INV_CART_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Par Location ID
Prompt Table:
CART_ATTRIB_INV
Set Control Field: BUSINESS_UNIT
|
| 50 |
CART_GROUP |
Character(5) |
VARCHAR2(5) NOT NULL |
Par Location Group
Prompt Table:
CART_GROUP_INV
|
| 51 |
AVG_DFLT_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Average Count as Default
Y/N Table Edit
Default Value: N
|
| 52 |
ROUND_OPTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Rounding Option
01=Do Not Round
02=Round to Nearest Integer
03=Round Down to Prior Integer
04=Round Up to Next Integer
Default Value: 02
|
| 53 |
DOWNLOAD_TO_FILE |
Character(1) |
VARCHAR2(1) NOT NULL |
Create File
Y/N Table Edit
|
| 54 |
PRINT_LISTING |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Listing
Y/N Table Edit
|
| 55 |
DATE_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Date Option
A=As of Date
R=Range
T=Today
Default Value: A
|
| 56 |
VENDOR_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Supplier Option
A=All
S=Specific
Default Value: A
|
| 57 |
VENDOR_NAME_SHORT |
Character(14) |
VARCHAR2(14) NOT NULL |
Short Vendor Name
Prompt Table:
VENDOR_SHRT_DV2
|
| 58 |
REP_LAYOUT |
Character(1) |
VARCHAR2(1) NOT NULL |
Report Layout
C=Category/Supplier
V=Supplier/Category
Default Value: C
|
| 59 |
CALENDAR_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Calendar Year
|
| 60 |
USAGE_ITEM_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Run Usage Desktop for Specific Item, All Items, or a Category
1=All Items
2=Item Category
3=Specific Item
A=All Items
C=Item Category
S=Specific Item
Default Value: S
|
| 61 |
PERIOD_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Option to run for Period or Month
C=Calendar Month
P=Fiscal Period
Default Value: C
|
| 62 |
MFG_ID |
Character(50) |
VARCHAR2(50) NOT NULL |
Manufacturer ID
Prompt Table:
%EDITTABLE4
|
| 63 |
ATP_INCL_CO_BY |
Character(1) |
VARCHAR2(1) NOT NULL |
This is a Y/N field that determines whether co-products and by-products (from a production order) should be included as supply in the ATP calculation.
Y/N Table Edit
|
| 64 |
ATP_INCL_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
This is a Y/N field that determines whether approved PO requisitions should be included as supply in the ATP calculation.
Y/N Table Edit
|
| 65 |
MONTHCD |
Character(2) |
VARCHAR2(2) NOT NULL |
Month
01=01 - January
02=02 - February
03=03 - March
04=04 - April
05=05 - May
06=06 - June
07=07 - July
08=08 - August
09=09 - September
10=10 - October
11=11 - November
12=12 - December
|
| 66 |
PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Period
Prompt Table:
IN_BU_CALNDR_VW
|
| 67 |
ITM_STATUS_CURRENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Item Status Current
1=Active
2=Hold
3=Discontinue
4=Inactive
5=Pending Approval
6=Denied Approval
7=Under Initialization
Default Value: 1
|
| 68 |
FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
|
| 69 |
GPO_CNTRCT_NBR |
Character(25) |
VARCHAR2(25) NOT NULL |
GPO Contract Number
Prompt Table:
MFG_GPO
|
| 70 |
GPO_SORT_BY |
Character(1) |
VARCHAR2(1) NOT NULL |
Sort Selection
C=Sort by Category Code
D=Sort by Distributor
I=Sort by Item Id
M=Sort by Mfg Category
Default Value: D
|
| 71 |
CATEGORY_TOTALS |
Character(1) |
VARCHAR2(1) NOT NULL |
Category Totals
Y/N Table Edit
|
| 72 |
VENDOR_ID_DISTRIB |
Character(10) |
VARCHAR2(10) NOT NULL |
Distributor Supplier ID
|
| 73 |
DISTRIB_CURRENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Distributor Currency
Y/N Table Edit
|
| 74 |
DISTRIB_MARKUP |
Character(1) |
VARCHAR2(1) NOT NULL |
Distributor Markup
Y/N Table Edit
|
| 75 |
CNTRCT_ID_DISTRIB |
Character(25) |
VARCHAR2(25) NOT NULL |
Distributor Contract ID
|
| 76 |
CNTRCT_BEGIN_DT |
Date(10) |
DATE |
Contract Begin Date
|
| 77 |
CNTRCT_EXPIRE_DT |
Date(10) |
DATE |
Expire Date
|
| 78 |
GPO_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
GPO ID
Prompt Table:
MFG_GPO_VW
|
| 79 |
CATEGORY_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Category ID
|
| 80 |
MFG_ID_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Manufacturer Option
A=All
S=Specific
Default Value: A
|
| 81 |
CONTRACT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Contract ID
Prompt Table:
CNTRCT_HDR
|
| 82 |
CNTRCT_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Buying Agreement ID
Prompt Table:
CNTRCT_GPO_VW
|