AUC_AWE_PC_VW

(SQL View)
 Index Back

Fluid Approval View


SELECT HDR.BUSINESS_UNIT , HDR.AUC_ID , HDR.AUC_ROUND , HDR.AUC_VERSION ,HDR.AUC_NAME ,LIN.LINE_NBR ,LIN.SEQ_NBR , HDR.CURRENCY_CD ,LIN.UNIT_OF_MEASURE ,LIN.QTY_AUC ,LIN.AUC_PRICE ,LIN.AUC_LINE_STATUS ,LIN.AUC_EXT_PRICE ,HDR.RATE_DATE ,HDR.RT_TYPE ,' ' ,' ' ,HDR.AUC_ID || ' / ' || HDR.AUC_NAME FROM PS_AUC_LINE LIN ,PS_AUC_HDR HDR WHERE HDR.BUSINESS_UNIT =LIN.BUSINESS_UNIT AND HDR.AUC_ID = LIN.AUC_ID AND HDR.AUC_ROUND = LIN.AUC_ROUND AND HDR.AUC_VERSION =LIN.AUC_VERSION

# 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_NAME Character(50) VARCHAR2(50) NOT NULL Event Name
6 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
7 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
9 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

Prompt Table: %EDIT_UOM

10 QTY_AUC Number(16,4) DECIMAL(15,4) NOT NULL Event Quantity
11 AUC_PRICE Number(17,5) DECIMAL(16,5) NOT NULL Event Start price
12 AUC_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL Event Line Status
C=Closed
O=Open

Default Value: O

13 AUC_EXT_PRICE Number(18,5) DECIMAL(17,5) NOT NULL Auction Extended Price
14 RATE_DATE Date(10) DATE Exchange Rate Date
15 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
16 FIELD2 Character(50) VARCHAR2(50) NOT NULL Fieldname 2
17 FIELD3 Character(50) VARCHAR2(50) NOT NULL Fieldname 3
18 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description