RUN_CNTL_PUR

#	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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	RPT_DEST	Character(50)	VARCHAR2(50) NOT NULL	File Destination
5	FILE_NAME	Character(80)	VARCHAR2(80) NOT NULL	File Name
6	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: %EDITTABLE Set Control Field: EMPLID
7	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
8	CREDIT_CARD_VENDOR	Character(5)	VARCHAR2(5) NOT NULL	Corporate Card Vendor Prompt Table: CC_SEC_CCV_VW Set Control Field: CREDIT_CARD_VENDOR
9	CRDMEM_ACCT_NBR	Character(44)	VARCHAR2(44) NOT NULL	Cardmember Number
10	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
11	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_PM_NONVW
12	SORT_SEQUENCE	Character(1)	VARCHAR2(1) NOT NULL	Sort Sequence I=Sort by Supplier ID N=Sort by Supplier Name Default Value: N
13	GRP_PUR_ID	Character(6)	VARCHAR2(6) NOT NULL	Control Group Id
14	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID Prompt Table: SP_SETVC_NONVW
15	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Prompt Table: VENDOR_VW6
16	VENDOR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Vendor Status A=Approved D=Denied E=Unapproved I=Inactive X=To Be Archived Default Value: A
17	CATEGORY_CD	Character(18)	VARCHAR2(18) NOT NULL	Category Code Prompt Table: ITM_CAT_SET_VW
18	FROM_DATE	Date(10)	DATE	From Date
19	THRU_DATE	Date(10)	DATE	Through Date
20	AS_OF_DATE	Date(10)	DATE	As of Date Default Value: %date
21	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
22	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
23	DESCRLONG	Long Character	CLOB	Long Description
24	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order Prompt Table: %EDITTABLE2
25	PRT_PENDING	Character(1)	VARCHAR2(1) NOT NULL	*** 07/19/2000 *** The following pages use the second label - PRT_PENDING1: 1. RUN_PORFQ01 (RFQ - Dispatch Quote Forms) 2. RUN_PO_RTVDISP (RTV - Dispatch RTVs) Y/N Table Edit Default Value: N
26	PRT_OPEN	Character(1)	VARCHAR2(1) NOT NULL	Print Open Records Y/N Table Edit Default Value: N
27	PRT_DISPATCHED	Character(1)	VARCHAR2(1) NOT NULL	Print Dispatched POs Y/N Table Edit Default Value: N
28	PRT_APPR	Character(1)	VARCHAR2(1) NOT NULL	Print Approved Records Y/N Table Edit Default Value: N
29	PRT_COMPLETED	Character(1)	VARCHAR2(1) NOT NULL	Print Completed Records Y/N Table Edit Default Value: N
30	PRT_RECYCLE_CF	Character(1)	VARCHAR2(1) NOT NULL	Recycled Chartfield Records B=Recycled AND Valid Chartfields N=Valid Chartfields Y=Recycled Chartfields Default Value: N
31	PRT_HELD	Character(1)	VARCHAR2(1) NOT NULL	Print Held Records B=On Hold AND Not On Hold N=NOT On Hold Y=On Hold Default Value: N
32	PRT_CLOSED	Character(1)	VARCHAR2(1) NOT NULL	Print Closed Records Y/N Table Edit Default Value: N
33	PRT_SHIPPED	Character(1)	VARCHAR2(1) NOT NULL	Print Shipped Records Y/N Table Edit Default Value: N
34	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer Prompt Table: BUYER_ACTIVE_VW
35	PRT_CHNG_ORDERS	Character(1)	VARCHAR2(1) NOT NULL	Print Change Orders B=Changed and UnChanged Orders N=UnChanged Orders Y=Changed Orders Default Value: N
36	PRT_CANCELLED	Character(1)	VARCHAR2(1) NOT NULL	Print Canceled POs Y/N Table Edit Default Value: N
37	PRT_CHGS_ONLY	Character(1)	VARCHAR2(1) NOT NULL	Print Changes Only Y/N Table Edit Default Value: N
38	PRT_ONLY	Character(1)	VARCHAR2(1) NOT NULL	Print Only Y/N Table Edit Default Value: N
39	PRT_DUP	Character(1)	VARCHAR2(1) NOT NULL	Print Duplicate on PO Y/N Table Edit Default Value: N
40	PRT_POL_DESCR	Character(1)	VARCHAR2(1) NOT NULL	Print PO Item Description Y/N Table Edit Default Value: Y
41	REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID Prompt Table: REQ_HDR_VW
42	REQUESTOR_ID	Character(30)	VARCHAR2(30) NOT NULL	Requestor id Prompt Table: RQSTR_ACTIVE_VW
43	PO_STATUS	Character(2)	VARCHAR2(2) NOT NULL	PO Status A=Approved C=Complete D=Dispatched DA=Denied I=Initial LD=Line Denied O=Open PA=Pending Approval/Approved PX=Pending Cancel X=Canceled
44	PO_PRINT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	PO Print Status C=PO Print Process Completed F=PO Print Process Formatted S=PO Print Process Selected U=PO Print Process Uninitiated Default Value: U
45	FAX_SERVER_NAME	Character(8)	VARCHAR2(8) NOT NULL	Fax Server Name - Network ID
46	FAX_SERVER_DIR	Character(80)	VARCHAR2(80) NOT NULL	Fax Server Directory
47	COVER_FILE_NAME	Character(12)	VARCHAR2(12) NOT NULL	Fax Cover Page Prompt Table: PO_FAX_COV_VW
48	TEST_IND	Character(1)	VARCHAR2(1) NOT NULL	Date Initial Issue # Description 12/07/00 JJM R-JMESER-JM6J2 Added label ID "History" Y/N Table Edit Default Value: N
49	PRINT_IND	Character(1)	VARCHAR2(1) NOT NULL	Print Copy Y/N Table Edit
50	NUM_OF_COPIES	Number(3,0)	SMALLINT NOT NULL	Number Of Copies
51	EDI_SERVER_DIR	Character(50)	VARCHAR2(50) NOT NULL	EDI Server Directory
52	RFQ_ID	Character(10)	VARCHAR2(10) NOT NULL	RFQ ID Prompt Table: RFQ_HDR
53	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 Default Value: N
54	DATE_SEL_OPR	Character(2)	VARCHAR2(2) NOT NULL	Date Selection Oper <=Less Than Select Date <==Less Than or Equal To Sel Date <>=Not Equal to Selection Date ==Equal to Selection Date >=Greater Than Selection Date >==Greater Than or Eq to Sel Date
55	DATE_SEL_DT	Date(10)	DATE	03/23/2004 SFC Added PROD_COST_EFF_DT label
56	DATE_SEL_DAYS	Number(3,0)	SMALLINT NOT NULL	Date Selection Number of Days
57	RECEIVER_ID	Character(10)	VARCHAR2(10) NOT NULL	Receiver number Prompt Table: RECV_HDR_FS
58	RTV_ID	Character(10)	VARCHAR2(10) NOT NULL	Return To Vendor ID Prompt Table: RTV_HDR
59	RTV_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Return Status C=Closed O=Open S=Shipped X=Cancelled
60	CNTRCT_SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SP_SETID_NONVW
61	CNTRCT_ID	Character(25)	VARCHAR2(25) NOT NULL	Buying Agreement ID Prompt Table: %EDITTABLE Set Control Field: CNTRCT_SETID
62	CNTRCT_ID_TO	Character(25)	VARCHAR2(25) NOT NULL	Contract ID To Prompt Table: %EDITTABLE Set Control Field: CNTRCT_SETID
63	VRBT_ID	Character(25)	VARCHAR2(25) NOT NULL	Vendor Rebate ID Prompt Table: VRBT_SRCH_VW2
64	VRBT_ID_TO	Character(25)	VARCHAR2(25) NOT NULL	To Vendor Rebate ID Prompt Table: VRBT_SRCH_VW2
65	PRINT_SORTBY	Character(1)	VARCHAR2(1) NOT NULL	PO Print Sort By L=Sort by Line Number S=Sort by ShipTo Id Default Value: L
66	PRINT_TERMS	Character(1)	VARCHAR2(1) NOT NULL	Print Terms N=Do not print PO Terms Y=Print PO Terms
67	VENDOR_ID_TO	Character(10)	VARCHAR2(10) NOT NULL	Created 07/99 KDN CN# CM800-2.0 - Landed Cost Reports - CMS3010 Prompt Table: VENDOR_VW6
68	PRINT_SCHED	Character(1)	VARCHAR2(1) NOT NULL	Print Schedules
69	RECV_ASN_SORT	Character(1)	VARCHAR2(1) NOT NULL	Receiving Sort Sequence A=ASR Transaction Id D=Due Date S=Shipment Number
70	SHIP_TYPE_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship Via Code
71	EDI_DISP	Character(1)	VARCHAR2(1) NOT NULL	EDX Method Y/N Table Edit Default Value: Y
72	FAX_DISP	Character(1)	VARCHAR2(1) NOT NULL	FAX Method Y/N Table Edit Default Value: Y
73	PHONE_DISP	Character(1)	VARCHAR2(1) NOT NULL	Phone Method Y/N Table Edit Default Value: Y
74	PRINT_DISP	Character(1)	VARCHAR2(1) NOT NULL	Print Method Y/N Table Edit Default Value: Y
75	EMAIL_DISP	Character(1)	VARCHAR2(1) NOT NULL	E-Mail Method Y/N Table Edit Default Value: Y
76	MASS_LIQUIDATE_ID	Character(10)	VARCHAR2(10) NOT NULL	Mass Liquidate ID
77	EMAIL_SERVER_DIR	Character(80)	VARCHAR2(80) NOT NULL	E-Mail Server Directory
78	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
79	PO_ID_PAGE_BREAK	Character(1)	VARCHAR2(1) NOT NULL	PO id Pg Break within Supplier
80	RELEASE_NBR	Number(5,0)	INTEGER NOT NULL	Release Number Prompt Table: PO_L2_CNTRCT_VW
81	MSTR_CNTRCT_ID	Character(10)	VARCHAR2(10) NOT NULL	Master Contract ID Prompt Table: CNTRCT_MSTR
82	URL	Character(254)	VARCHAR2(254) NOT NULL	Internet URL (Universal Resource Locator)
83	TO_BU	Character(5)	VARCHAR2(5) NOT NULL	To Business Unit Prompt Table: SP_BU_PM_NONVW
84	CNTRCT_PROC_OPT	Character(4)	VARCHAR2(4) NOT NULL	Contract Process Option AP=Recurring Voucher BPO=Release to Single PO Only DST=Distributor GN=General Contract GRPM=Group Multi Supplier GRPS=Group Single Supplier MFG=Manufacturer PADV=Prepaid Voucher w/ Advance PO PO=Purchase Order PPAY=Prepaid Voucher RPOV=Recurring PO Voucher SPP=Special Purpose
85	CNTRCT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Contract Status A=Approved C=Closed H=On-Hold O=Open P=Pre-Approved X=Canceled
86	CC_MASK_OPT	Character(1)	VARCHAR2(1) NOT NULL	Display Unmasked Card Number Y/N Table Edit Default Value: N
87	ROLENAME	Character(30)	VARCHAR2(30) NOT NULL	The name of a Role in the Role Definition Table (see PSROLEDEFN). Prompt Table: CC_SEC_ROLE_VW
88	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
89	OPRDEFNDESC	Character(30)	VARCHAR2(30) NOT NULL	Description field for a user
90	TMPLDEFN_ID	Character(30)	VARCHAR2(30) NOT NULL	Template ID (see PSXPTMPLDEFN). Prompt Table: PO_XMLP_TMPL_VW
91	CS_EXCL_DOCS	Character(1)	VARCHAR2(1) NOT NULL	Exclude POs tied to Documents Y/N Table Edit Default Value: N
92	PRT_CLOSE_LN_AMT	Character(1)	VARCHAR2(1) NOT NULL	Print Closed Line Amount Y/N Table Edit Default Value: N