CS_DOC_PURL_SVW

(SQL View)
 Index Back

Purchase Order Line View

Purchase Order Lines view for PTSF

SELECT DISTINCT '0008' ,PO.CS_DOC_ID ,PO.BUSINESS_UNIT ,PO.PO_ID ,POLINE.LINE_NBR ,POLINE.CANCEL_STATUS ,POLINE.CHANGE_STATUS ,POLINE.ITM_SETID ,POLINE.INV_ITEM_ID ,POLINE.CATEGORY_ID ,POLINE.DESCR254_MIXED ,%subrec(PUR_USR_LIN_SBR, POLINE) FROM PS_CS_DOC_PUR_KEYS PO ,PS_CS_DOC_HDR H ,PS_PO_LINE POLINE WHERE PO.CS_DOC_ID = H.CS_DOC_ID AND PO.BUSINESS_UNIT = POLINE.BUSINESS_UNIT AND PO.PO_ID = POLINE.PO_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CS_CONTENT_TYPE Character(4) VARCHAR2(4) NOT NULL 06/08/09 F-AHAYT-XOES6 Add capability to use binds in headers and/or footers of contract document; new translate value added to support Where Used from Document Templates and Styles 06/25/07 F-AHAYT-XOES6 Added 0016 for Document Format and Options; this type is only used when displayed where a word template is used with doc options. We do not search doc format and options.
0001=Clause
0002=Section
0003=Ad Hoc Clause
0004=Rule
0005=Bind Variables
0006=Wizard Definition
0007=Document Configurator
0008=Document
0009=Contract Agreement
0010=Bid Factor
0011=Contract
0012=Sourcing Event
0013=Question Group
0014=Document Type
0015=Word Template
0016=Document Format and Options
2 CS_DOC_ID Character(25) VARCHAR2(25) NOT NULL Document ID
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 CS_CONTENT_ID Character(30) VARCHAR2(30) NOT NULL Content ID
5 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

Default Value: 1

6 CANCEL_STATUS Character(1) VARCHAR2(1) NOT NULL Cancel Status
A=Active
C=Closed
D=Denied
H=Hold
O=Open
P=Pending Approval
X=Canceled

Default Value: A

7 CHANGE_STATUS Character(1) VARCHAR2(1) NOT NULL Change Order Status
C=Changed
U=Unchanged

Default Value: U

8 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
9 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: %EDITTABLE13

10 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
11 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
12 USER_LINE_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1
13 CUSTOM_C100_B1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1
14 CUSTOM_C100_B2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2
15 CUSTOM_C100_B3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3
16 CUSTOM_C100_B4 Character(100) VARCHAR2(100) NOT NULL Custom Field 4
17 CUSTOM_DATE_B Date(10) DATE Custom Date
18 CUSTOM_C1_B Character(1) VARCHAR2(1) NOT NULL Custom Character 2