AUC_HDR_LINE_VW

(SQL View)
 Index Back

SELECT B.BUSINESS_UNIT , B.AUC_ID , B.AUC_ROUND , B.AUC_VERSION , B.LINE_NBR , B.REQUIRED_FLAG , B.AUC_LINE_TYPE , B.ITM_SETID , B.BUSINESS_UNIT_AM , CASE WHEN B.AUC_LINE_TYPE = 'G' THEN B.AUC_GROUP_ID ELSE B.INV_ITEM_ID END , B.CATEGORY_ID , B.UNIT_OF_MEASURE , B.MFG_ID , B.MFG_ITM_ID , B.SERIAL_ID , B.CURRENCY_CD , B.DESCR254_MIXED , B.PRICE_RESERVE , B.PRICE_CLOSE , B.QTY_AUC_MIN , B.QTY_AUC_MAX , B.QTY_AUC , B.AUC_PRICE , B.AUC_EXT_PRICE , B.AUC_ITEM_LENGTH , B.AUC_ITEM_WIDTH , B.AUC_ITEM_WEIGHT , B.AUC_ITEM_VOLUME , B.AUC_ITEM_SIZE , B.AUC_ITEM_COLOR , B.AUC_ITEM_HEIGHT , B.AUC_WEIGHT_UOM , B.AUC_VOLUME_UOM , B.AUC_DIMENSION_UOM , B.WEIGHTING , B.AUC_LINE_STATUS , B.AUC_QTY_AWARDED , B.AUC_QTY_POSTED , B.AUC_USER_PRC_BRK , B.AUC_BIDDER_PRC_BRK , B.PREV_LINE_NBR , A.AUC_START_PRC_RL , A.AUC_FORMAT , A.AUC_TYPE , A.AUC_NAME , A.AUC_STATUS , B.AUC_BID_QTY_RULE FROM PS_AUC_HDR 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

# 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 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
6 REQUIRED_FLAG Character(1) VARCHAR2(1) NOT NULL Required Flag
N=No
Y=Yes
7 AUC_LINE_TYPE Character(1) VARCHAR2(1) NOT NULL Event Line Type
G=Group Line
L=Line Item
8 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
9 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

Prompt Table: SP_BU_AM_NONVW

10 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: %EDITTABLE26

11 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
12 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: UNITS_TBL

13 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID

Prompt Table: MANUFACTURER

14 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID

Prompt Table: ITEM_MFG_ID_VW

15 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
16 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

17 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
18 PRICE_RESERVE Number(16,5) DECIMAL(15,5) NOT NULL Reserve Price
19 PRICE_CLOSE Number(16,5) DECIMAL(15,5) NOT NULL Close Price
20 QTY_AUC_MIN Number(16,4) DECIMAL(15,4) NOT NULL Minimum Event Quantity
21 QTY_AUC_MAX Number(16,4) DECIMAL(15,4) NOT NULL Quantity Max
22 QTY_AUC Number(16,4) DECIMAL(15,4) NOT NULL Event Quantity
23 AUC_PRICE Number(17,5) DECIMAL(16,5) NOT NULL Event Start price
24 AUC_EXT_PRICE Number(18,5) DECIMAL(17,5) NOT NULL Auction Extended Price
25 AUC_ITEM_LENGTH Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Length
26 AUC_ITEM_WIDTH Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Width
27 AUC_ITEM_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Weight
28 AUC_ITEM_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Volume
29 AUC_ITEM_SIZE Character(5) VARCHAR2(5) NOT NULL Item Size
30 AUC_ITEM_COLOR Character(15) VARCHAR2(15) NOT NULL Sourcing Item Color
31 AUC_ITEM_HEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Height
32 AUC_WEIGHT_UOM Character(3) VARCHAR2(3) NOT NULL Weight UOM
33 AUC_VOLUME_UOM Character(3) VARCHAR2(3) NOT NULL Volume UOM
34 AUC_DIMENSION_UOM Character(3) VARCHAR2(3) NOT NULL Dimension UOM
35 WEIGHTING Signed Number(10,5) DECIMAL(8,5) NOT NULL Used for applying a weighting to totals. e.g. Limit Utilisation totals
36 AUC_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL Event Line Status
C=Closed
O=Open
37 AUC_QTY_AWARDED Number(16,4) DECIMAL(15,4) NOT NULL Event Line Quantity Awarded
38 AUC_QTY_POSTED Number(16,4) DECIMAL(15,4) NOT NULL Event Line Quantity Posted
39 AUC_USER_PRC_BRK Character(1) VARCHAR2(1) NOT NULL User Defined Price Breaks

Y/N Table Edit

Default Value: N

40 AUC_BIDDER_PRC_BRK Character(1) VARCHAR2(1) NOT NULL Bidder defined price breaks

Y/N Table Edit

Default Value: N

41 PREV_LINE_NBR Number(5,0) INTEGER NOT NULL Previous Line Number
42 AUC_START_PRC_RL Character(1) VARCHAR2(1) NOT NULL Start Price
D=Display - Not Required to Beat
N=Do Not Display
Y=Display and Also Must Beat
43 AUC_FORMAT Character(1) VARCHAR2(1) NOT NULL Event Format
F=Sell
I=RFI
R=Buy
S=Service
44 AUC_TYPE Character(1) VARCHAR2(1) NOT NULL Event Type
E=Auction
S=RFx
45 AUC_NAME Character(50) VARCHAR2(50) NOT NULL Event Name
46 AUC_STATUS Character(1) VARCHAR2(1) NOT NULL Event Status
A=Awarded
C=Collaborating Event
D=Collaborating Bid Analysis
E=Evaluating
F=RFI Reviewed
I=Pending RFI Review
N=Not Awarded
O=Open
P=Posted
Q=Paused
R=Pending Scheduled Review
S=Pending Post Approval
T=Pending Award
U=Pending Award Approval
W=Post to Third Party Failed
X=Cancelled
Z=Inactive Version

Default Value: O

47 AUC_BID_QTY_RULE Character(2) VARCHAR2(2) NOT NULL Bid Quantity Rule
MQ=Bid Up to Maximum Quantity
NA=Quantity Not Applicable
RQ=Requested Quantity Required
XQ=Allow Extra Quantity to be Bid