RUN_CNTL_PUR_VW

(SQL View)
 Index Back

Purchasing Process Run Control

Purchasing Process Run Control

SELECT A.OPRID , A.RUN_CNTL_ID , A.LANGUAGE_CD , A.RPT_DEST , A.FILE_NAME , A.EMPLID , A.NAME , A.CREDIT_CARD_VENDOR , A.CRDMEM_ACCT_NBR , A.CURRENCY_CD , A.BUSINESS_UNIT , A.SORT_SEQUENCE , A.GRP_PUR_ID , A.VENDOR_SETID , A.VENDOR_ID , A.VENDOR_STATUS , A.CATEGORY_CD , A.FROM_DATE , A.THRU_DATE , A.AS_OF_DATE , A.DESCR50 , A.SETID , A.DESCRLONG , A.PO_ID , A.PRT_OPEN , A.PRT_PENDING , A.PRT_DISPATCHED , A.PRT_APPR , A.PRT_COMPLETED , A.PRT_RECYCLE_CF , A.PRT_HELD , A.PRT_CLOSED , A.PRT_SHIPPED , A.BUYER_ID , A.PRT_CHNG_ORDERS , A.PRT_CANCELLED , A.PRT_CHGS_ONLY , A.PRT_ONLY , A.PRT_DUP , A.PRT_POL_DESCR , A.REQ_ID , A.REQUESTOR_ID , A.PO_STATUS , A.PO_PRINT_STATUS , A.FAX_SERVER_NAME , A.FAX_SERVER_DIR , A.COVER_FILE_NAME , A.TEST_IND , A.PRINT_IND , A.NUM_OF_COPIES , A.EDI_SERVER_DIR , A.RFQ_ID , A.DATE_SEL_OPT , A.DATE_SEL_OPR , A.DATE_SEL_DT , A.DATE_SEL_DAYS , A.RECEIVER_ID , A.RTV_ID , A.RTV_STATUS , A.CNTRCT_SETID , A.CNTRCT_ID , A.CNTRCT_ID_TO , A.PRINT_SORTBY , A.PRINT_TERMS , A.VENDOR_ID_TO , A.PRINT_SCHED , A.RECV_ASN_SORT , A.SHIP_TYPE_ID , A.EDI_DISP , A.FAX_DISP , A.PHONE_DISP , A.PRINT_DISP , A.EMAIL_DISP , A.MASS_LIQUIDATE_ID , A.EMAIL_SERVER_DIR , A.LOCATION , A.PO_ID_PAGE_BREAK , A.RELEASE_NBR , A.MSTR_CNTRCT_ID , A.URL , A.TO_BU , A.CNTRCT_PROC_OPT , A.CNTRCT_STATUS FROM PS_RUN_CNTL_PUR A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
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
7 NAME Character(50) VARCHAR2(50) NOT NULL Name
8 CREDIT_CARD_VENDOR Character(5) VARCHAR2(5) NOT NULL Corporate 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
11 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
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
15 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
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
23 DESCRLONG Long Character CLOB Long Description
24 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
25 PRT_OPEN Character(1) VARCHAR2(1) NOT NULL Print Open Records

Y/N Table Edit

Default Value: N

26 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

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

Y/N Table Edit

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

Y/N Table Edit

Default Value: N

32 PRT_CLOSED Character(1) VARCHAR2(1) NOT NULL Print Closed Records
33 PRT_SHIPPED Character(1) VARCHAR2(1) NOT NULL Print Shipped Records
34 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
35 PRT_CHNG_ORDERS Character(1) VARCHAR2(1) NOT NULL Print Change Orders
B=Changed and UnChanged Orders
N=UnChanged Orders
Y=Changed Orders

Y/N Table Edit

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
42 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id
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
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: Y

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
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
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
58 RTV_ID Character(10) VARCHAR2(10) NOT NULL Return To Vendor ID
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
61 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
62 CNTRCT_ID_TO Character(25) VARCHAR2(25) NOT NULL Contract ID To
63 PRINT_SORTBY Character(1) VARCHAR2(1) NOT NULL PO Print Sort By
L=Sort by Line Number
S=Sort by ShipTo Id
64 PRINT_TERMS Character(1) VARCHAR2(1) NOT NULL Print Terms
N=Do not print PO Terms
Y=Print PO Terms
65 VENDOR_ID_TO Character(10) VARCHAR2(10) NOT NULL Created 07/99 KDN CN# CM800-2.0 - Landed Cost Reports - CMS3010
66 PRINT_SCHED Character(1) VARCHAR2(1) NOT NULL Print Schedules
67 RECV_ASN_SORT Character(1) VARCHAR2(1) NOT NULL Receiving Sort Sequence
A=ASR Transaction Id
D=Due Date
S=Shipment Number
68 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
69 EDI_DISP Character(1) VARCHAR2(1) NOT NULL EDX Method

Y/N Table Edit

Default Value: Y

70 FAX_DISP Character(1) VARCHAR2(1) NOT NULL FAX Method

Y/N Table Edit

Default Value: Y

71 PHONE_DISP Character(1) VARCHAR2(1) NOT NULL Phone Method

Y/N Table Edit

Default Value: Y

72 PRINT_DISP Character(1) VARCHAR2(1) NOT NULL Print Method

Y/N Table Edit

Default Value: Y

73 EMAIL_DISP Character(1) VARCHAR2(1) NOT NULL E-Mail Method
74 MASS_LIQUIDATE_ID Character(10) VARCHAR2(10) NOT NULL Mass Liquidate ID
75 EMAIL_SERVER_DIR Character(80) VARCHAR2(80) NOT NULL E-Mail Server Directory
76 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
77 PO_ID_PAGE_BREAK Character(1) VARCHAR2(1) NOT NULL PO id Pg Break within Supplier
78 RELEASE_NBR Number(5,0) INTEGER NOT NULL Release Number
79 MSTR_CNTRCT_ID Character(10) VARCHAR2(10) NOT NULL Master Contract ID

Prompt Table: CNTRCT_MSTR

80 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
81 TO_BU Character(5) VARCHAR2(5) NOT NULL To Business Unit
82 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
83 CNTRCT_STATUS Character(1) VARCHAR2(1) NOT NULL Contract Status
A=Approved
C=Closed
H=On-Hold
O=Open
P=Pre-Approved
X=Canceled