CS_DOC_PUR_L_VW

(SQL View)
 Index Back

Purchase Order Line View

6/18/07 F-AHAYT-748L7 new record to add POs to

SELECT DISTINCT '0008' ,PO.CS_DOC_ID ,PO.BUSINESS_UNIT ,PO.PO_ID ,F.CS_DOC_TYPE ,F.SCM_ATTACH_ID ,F.ATT_VERSION ,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_CS_DOC_ATT_TBL F ,PS_PO_LINE POLINE WHERE PO.CS_DOC_ID = H.CS_DOC_ID AND H.CS_DOC_ID = F.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 CS_DOC_TYPE Character(3) VARCHAR2(3) NOT NULL stores the file type -- main file, amendment, preview, throwaway Date Initials Issue Description ========================================== 06/2007 CEL F-AHAYT-25EQ8 added the external main and amendment types 7/2008 cel Added new executive summary file type. 9/30/2008 RMK Changed values 005 and 006 to 095 and 096, and added 010 for executive summary. This change is due to the search on file type using range (001-010 for non-attachment search, and 001-096 for attachment search)
001=Main Document
002=Amendment
003=Preview Document
004=Compare File
005=Document Attachment
006=Transaction Attachment
007=Config Selector
008=Main Signature Document
009=Amendment Signature File
010=Executive Summary
011=Exec-Sign
095=Document Attachment
096=Transaction Attachment
101=Main Document
102=Amendment Document
998=Main Document - ext collab
999=Amendment External Collab
6 SCM_ATTACH_ID Character(64) VARCHAR2(64) NOT NULL The unique ID of each file whose attachment was handled by the attachment utility. Unique across all attachments, all applications.
7 ATT_VERSION Number(3,0) SMALLINT NOT NULL The version of the attached file. Currently always 1, this field will find more use once the attachment utitlity starts supporting versioning of files.
8 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

Default Value: 1

9 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

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

Default Value: U

11 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
12 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: %EDITTABLE13

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