RESP_INQA_VW

(SQL View)
 Index Back

SELECT A.BUSINESS_UNIT ,A.AUC_ID ,A.AUC_ROUND ,A.AUC_VERSION ,B.LINE_NBR ,A.BUSINESS_UNIT %Concat '-' %Concat A.AUC_ID ,A.AUC_FORMAT ,A.AUC_TYPE ,A.AUC_NAME ,A.AUC_STATUS ,A.AUC_DTTM_PREVIEW ,A.AUC_DTTM_START ,A.AUC_DTTM_FINISH ,A.PYMNT_TERMS_CD ,B.REQUIRED_FLAG ,B.AUC_LINE_TYPE ,B.ITM_SETID ,B.INV_ITEM_ID ,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 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 AUC_ID_BUS_UNIT Character(18) VARCHAR2(18) NOT NULL Bus Unit-Auction ID
7 AUC_FORMAT Character(1) VARCHAR2(1) NOT NULL Event Format
F=Sell
I=RFI
R=Buy
S=Service
8 AUC_TYPE Character(1) VARCHAR2(1) NOT NULL Event Type
E=Auction
S=RFx
9 AUC_NAME Character(50) VARCHAR2(50) NOT NULL Event Name
10 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
11 AUC_DTTM_PREVIEW DateTime(26) TIMESTAMP Date Time Preview
12 AUC_DTTM_START DateTime(26) TIMESTAMP NOT NULL Date Time Start
13 AUC_DTTM_FINISH DateTime(26) TIMESTAMP NOT NULL Date Time Finish
14 PYMNT_TERMS_CD Character(5) VARCHAR2(5) NOT NULL Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.

Prompt Table: PYMT_TR_EFF_VW

15 REQUIRED_FLAG Character(1) VARCHAR2(1) NOT NULL Required Flag
N=No
Y=Yes
16 AUC_LINE_TYPE Character(1) VARCHAR2(1) NOT NULL Event Line Type
G=Group Line
L=Line Item
17 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
18 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: %EDITTABLE26

19 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
20 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

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

Prompt Table: MANUFACTURER

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

Prompt Table: ITEM_MFG_ID_VW

23 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
24 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

25 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
26 PRICE_RESERVE Number(16,5) DECIMAL(15,5) NOT NULL Reserve Price
27 PRICE_CLOSE Number(16,5) DECIMAL(15,5) NOT NULL Close Price
28 QTY_AUC_MIN Number(16,4) DECIMAL(15,4) NOT NULL Minimum Event Quantity
29 QTY_AUC_MAX Number(16,4) DECIMAL(15,4) NOT NULL Quantity Max
30 QTY_AUC Number(16,4) DECIMAL(15,4) NOT NULL Event Quantity