CS_AUC_DOC_V

(SQL View)
Index Back

Keys for Purchase Order

Keys for PO in Supply Contract Mgmt. 9/2007 CEL new view added for Purchase Order source

SELECT AUC.business_unit , AUC.AUC_ID , AUC.CS_DOC_ID , H.CS_DOC_STATUS , H.CS_VERSION , H.CS_AMENDMENT , H.CS_TEMPLATE_ID FROM PS_CS_DOC_AUC_KEYS AUC , PS_CS_DOC_HDR H , PS_CS_DOC_FILES F WHERE AUC.CS_DOC_ID = H.CS_DOC_ID AND H.CS_DOC_ID = F.CS_DOC_ID AND F.CS_DOC_TYPE = '001'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 AUC_ID Character(10) VARCHAR2(10) NOT NULL Event ID
3 CS_DOC_ID Character(25) VARCHAR2(25) NOT NULL Document ID
4 CS_DOC_STATUS Character(2) VARCHAR2(2) NOT NULL Document Status
AA=Approved
AD=Denied
AP=Pending Approval
CC=Collaborated
CP=Pending Collaboration
CR=Collaborated, Pending Review
DC=Complete
DR=Draft
DS=Dispatched
EC=Pending External Collaboration
EX=Executed
PI=Pending Internal Review
5 CS_VERSION Number(6,2) DECIMAL(5,2) NOT NULL Version
6 CS_AMENDMENT Number(3,0) SMALLINT NOT NULL Amendment
7 CS_TEMPLATE_ID Character(20) VARCHAR2(20) NOT NULL SCC 09/01/04