SCP_AUC_AWRD_VW

(SQL View)
 Index Back

SELECT DISTINCT A.BUSINESS_UNIT ,BU.DESCR ,BU.DESCRSHORT , A.AUC_ID , A.AUC_ROUND , A.AUC_VERSION , A.AUC_FORMAT , A.AUC_TYPE , B.BIDDER_SETID , B.BIDDER_ID , B.BIDDER_TYPE , B.BIDDER_LOC , A.AUC_NAME , A.AUC_STATUS , A.AUC_DTTM_PREVIEW , A.AUC_DTTM_START , A.AUC_DTTM_FINISH , A.PYMNT_TERMS_CD , A.CURRENCY_CD , A.ORIGIN , A.TAX_EXEMPT , A.TAX_EXEMPT_ID , A.BILL_LOCATION , A.PAYMENT_METHOD , A.REQUESTOR_ID , A.BUYER_ID , A.AUC_EXTENSION_FLAG , A.AUC_EXTENSION_LAST , A.AUC_EXTENSION_TYPE , A.AUC_EXTENSION_QTY , A.AUC_EXTENSION_LEN , A.EXTENSION_LEN_TYPE , A.BLIND_FLG , A.AUC_ALL_LINES_FLG , A.MULTIPLE_BIDS_FLG , A.OPRID_MODIFIED_BY , A.AUC_TMPLTE_FLG , A.RATE_DATE , A.RT_TYPE , A.AUC_DISP_WEIGHTING , A.AUC_DSP_RNDVER , ' ' FROM PS_AUC_HDR A , PS_AUC_DISP_ADDR B , PS_BUS_UNIT_TBL_FS BU WHERE A.AUC_ROUND = ( SELECT MAX(AUC_ROUND) FROM PS_AUC_HDR X WHERE X.BUSINESS_UNIT = A.BUSINESS_UNIT AND X.AUC_ID = A.AUC_ID) AND A.AUC_VERSION = ( SELECT MAX(AUC_VERSION) FROM PS_AUC_HDR Y WHERE Y.BUSINESS_UNIT = A.BUSINESS_UNIT AND Y.AUC_ID = A.AUC_ID AND Y.AUC_ROUND = A.AUC_ROUND ) AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.AUC_ID = B.AUC_ID AND A.AUC_VERSION = B.AUC_VERSION AND A.AUC_ROUND= B.AUC_ROUND AND A.BUSINESS_UNIT = BU.BUSINESS_UNIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
4 AUC_ID Character(10) VARCHAR2(10) NOT NULL Event ID
5 AUC_ROUND Number(5,0) INTEGER NOT NULL Event Round
6 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version
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 BIDDER_SETID Character(5) VARCHAR2(5) NOT NULL Bidder Setid
10 BIDDER_ID Character(15) VARCHAR2(15) NOT NULL Bidder ID
11 BIDDER_TYPE Character(1) VARCHAR2(1) NOT NULL Bidder Type
B=Bidder
C=Customer
P=Public
U=Uploaded
V=Supplier
12 BIDDER_LOC Character(10) VARCHAR2(10) NOT NULL Bidder Location
13 AUC_NAME Character(50) VARCHAR2(50) NOT NULL Event Name
14 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

15 AUC_DTTM_PREVIEW DateTime(26) TIMESTAMP Date Time Preview
16 AUC_DTTM_START DateTime(26) TIMESTAMP NOT NULL Date Time Start
17 AUC_DTTM_FINISH DateTime(26) TIMESTAMP NOT NULL Date Time Finish
18 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

19 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: BUS_UNIT_TBL_A1.CURRENCY_CD

Prompt Table: CURRENCY_CD_TBL

20 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin
21 TAX_EXEMPT Character(1) VARCHAR2(1) NOT NULL Tax Exempt Flag

Y/N Table Edit

Default Value: BUS_UNIT_TBL_A1.TAX_EXEMPT

22 TAX_EXEMPT_ID Character(30) VARCHAR2(30) NOT NULL Tax Exempt ID

Default Value: BUS_UNIT_TBL_A1.TAX_EXEMPT_ID

23 BILL_LOCATION Character(10) VARCHAR2(10) NOT NULL Billing Location

Default Value: BUS_UNIT_TBL_A1.BILL_LOCATION

Prompt Table: LOCATION_TBL

24 PAYMENT_METHOD Character(3) VARCHAR2(3) NOT NULL Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft. 10/28/2003 edw 655070000 - Removed LTC and CSH xlats.
ACH=ACH
CC=Credit Card
CHK=Check
CSH=Cash
DD=Direct Debit
DR=Draft
EC=Electronic Check
EFT=Electronic Fund Transfer
GE=Giro - EFT
PL=PayPal
WIR=Wire Report
25 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id

Prompt Table: RQSTR_ACTIVE_VW

26 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer

Prompt Table: BUYER_ACTIVE_VW

27 AUC_EXTENSION_FLAG Character(1) VARCHAR2(1) NOT NULL Allow Extension

Y/N Table Edit

Default Value: N

28 AUC_EXTENSION_LAST Number(10,0) DECIMAL(10) NOT NULL Last Bid
29 AUC_EXTENSION_TYPE Character(1) VARCHAR2(1) NOT NULL Extension Type
D=Days
H=Hours
M=Minutes
30 AUC_EXTENSION_QTY Number(10,0) DECIMAL(10) NOT NULL Number of extensions
31 AUC_EXTENSION_LEN Number(10,0) DECIMAL(10) NOT NULL Length of Extension
32 EXTENSION_LEN_TYPE Character(1) VARCHAR2(1) NOT NULL Extension Length Type
D=Days
H=Hours
M=Minutes
33 BLIND_FLG Character(1) VARCHAR2(1) NOT NULL Sealed Event

Y/N Table Edit

Default Value: N

34 AUC_ALL_LINES_FLG Character(1) VARCHAR2(1) NOT NULL Bid Required on all lines

Y/N Table Edit

Default Value: N

35 MULTIPLE_BIDS_FLG Character(1) VARCHAR2(1) NOT NULL Multiple Bids Allowed
N=Not Allowed
Y=Allowed

Y/N Table Edit

Default Value: Y

36 OPRID_MODIFIED_BY Character(30) VARCHAR2(30) NOT NULL Last User to Modify Entered By 07/25/2011:Ensured that OPRID_MODIFIED_BY is set with format type of MixedCase.
37 AUC_TMPLTE_FLG Character(1) VARCHAR2(1) NOT NULL Auction Template

Y/N Table Edit

Default Value: N

38 RATE_DATE Date(10) DATE Exchange Rate Date
39 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.

Default Value: BUS_UNIT_TBL_A1.RT_TYPE

Prompt Table: RT_TYPE_TBL

40 AUC_DISP_WEIGHTING Character(1) VARCHAR2(1) NOT NULL Display Weights

Y/N Table Edit

Default Value: Y

41 AUC_DSP_RNDVER Character(1) VARCHAR2(1) NOT NULL Display Round/Version
N=Do Not Display
R=Display Round
V=Display Round and Version
42 AUC_AWARD_TYPE Character(1) VARCHAR2(1) NOT NULL Award Type
C=PO Contract
E=Procurement Contract
G=General Contract
P=Purchase Order
S=Single Release PO Contract
V=Recurring Voucher Contract