SCP_S_AUC_LN_VW

(SQL View)
 Index Back

AUC_LINE View


SELECT B.BUSINESS_UNIT , B.AUC_ID , B.AUC_ROUND , b.auc_version , A.AUC_TYPE , A.AUC_FORMAT , B.LINE_NBR , B.INV_ITEM_ID , B.AUC_GROUP_ID , B.DESCR254_MIXED , B.REQUIRED_FLAG , B.AUC_LINE_TYPE , B.UNIT_OF_MEASURE , B.CURRENCY_CD , B.QTY_AUC , B.AUC_PRICE , B.AUC_EXT_PRICE FROM PS_SCP_S_AUCDTL_VW A , PS_AUC_LINE B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.AUC_ID = B.AUC_ID AND A.AUC_ROUND = B.AUC_ROUND AND A.AUC_VERSION = B.AUC_VERSION AND B.AUC_LINE_TYPE IN( 'L' ,'G')

# 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_TYPE Character(1) VARCHAR2(1) NOT NULL Event Type
E=Auction
S=RFx
6 AUC_FORMAT Character(1) VARCHAR2(1) NOT NULL Event Format
F=Sell
I=RFI
R=Buy
S=Service
7 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
8 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
9 AUC_GROUP_ID Character(18) VARCHAR2(18) NOT NULL GroupID
10 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
11 REQUIRED_FLAG Character(1) VARCHAR2(1) NOT NULL Required Flag
N=No
Y=Yes
12 AUC_LINE_TYPE Character(1) VARCHAR2(1) NOT NULL Event Line Type
G=Group Line
L=Line Item
13 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
14 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
15 QTY_AUC Number(16,4) DECIMAL(15,4) NOT NULL Event Quantity
16 AUC_PRICE Number(17,5) DECIMAL(16,5) NOT NULL Event Start price
17 AUC_EXT_PRICE Number(18,5) DECIMAL(17,5) NOT NULL Auction Extended Price