AUC_COPYXREF_VW

(SQL View)
Index Back

Sourcing summarized Xref Log

Cross reference table to all source transactions copied into the Strategic Sourcing event.

SELECT DISTINCT BUSINESS_UNIT , AUC_ID , AUC_ROUND , AUC_VERSION , AUC_SOURCE , AUC_SOURCE_BUSETID , AUC_SOURCE_ID , AUC_SOURCE_RND , AUC_SOURCE_VER FROM PS_AUC_COPY_XREF

# 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 AUC_ROUND Number(5,0) INTEGER NOT NULL Event Round
4 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version
5 AUC_SOURCE Character(1) VARCHAR2(1) NOT NULL Source Type
A=Event
B=MBOM
C=Contract
E=EBOM
I=RFI
L=Planning
P=PO
R=Req
T=Template
W=WO Replace
6 AUC_SOURCE_BUSETID Character(5) VARCHAR2(5) NOT NULL Business Unit Setid
7 AUC_SOURCE_ID Character(25) VARCHAR2(25) NOT NULL Source ID
8 AUC_SOURCE_RND Number(5,0) INTEGER NOT NULL Event Round
9 AUC_SOURCE_VER Number(5,0) INTEGER NOT NULL Event Version