AUC_BID_ACTM_VW

(SQL View)

SELECT DISTINCT A.BUSINESS_UNIT , A.AUC_ID , A.AUC_ROUND , 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 , 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 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 )

# 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_FORMAT Character(1) VARCHAR2(1) NOT NULL Event Format
F=Sell
I=RFI
R=Buy
S=Service

5 AUC_TYPE Character(1) VARCHAR2(1) NOT NULL Event Type
E=Auction
S=RFx

6 AUC_NAME Character(50) VARCHAR2(50) NOT NULL Event Name

7 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

8 AUC_DTTM_PREVIEW DateTime(26) TIMESTAMP Date Time Preview

9 AUC_DTTM_START DateTime(26) TIMESTAMP NOT NULL Date Time Start

10 AUC_DTTM_FINISH DateTime(26) TIMESTAMP NOT NULL Date Time Finish

11 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

12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Default Value: BUS_UNIT_TBL_A1.CURRENCY_CD
Prompt Table: CURRENCY_CD_TBL

13 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin

14 TAX_EXEMPT Character(1) VARCHAR2(1) NOT NULL Tax Exempt Flag
Y/N Table Edit
Default Value: BUS_UNIT_TBL_A1.TAX_EXEMPT

15 TAX_EXEMPT_ID Character(30) VARCHAR2(30) NOT NULL Tax Exempt ID
Default Value: BUS_UNIT_TBL_A1.TAX_EXEMPT_ID

16 BILL_LOCATION Character(10) VARCHAR2(10) NOT NULL Billing Location
Default Value: BUS_UNIT_TBL_A1.BILL_LOCATION
Prompt Table: LOCATION_TBL

17 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

18 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id
Prompt Table: RQSTR_ACTIVE_VW

19 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
Prompt Table: BUYER_ACTIVE_VW

20 AUC_EXTENSION_FLAG Character(1) VARCHAR2(1) NOT NULL Allow Extension
Y/N Table Edit
Default Value: N

21 AUC_EXTENSION_LAST Number(10,0) DECIMAL(10) NOT NULL Last Bid

22 AUC_EXTENSION_TYPE Character(1) VARCHAR2(1) NOT NULL Extension Type
D=Days
H=Hours
M=Minutes

23 AUC_EXTENSION_QTY Number(10,0) DECIMAL(10) NOT NULL Number of extensions

24 AUC_EXTENSION_LEN Number(10,0) DECIMAL(10) NOT NULL Length of Extension

25 EXTENSION_LEN_TYPE Character(1) VARCHAR2(1) NOT NULL Extension Length Type
D=Days
H=Hours
M=Minutes

26 BLIND_FLG Character(1) VARCHAR2(1) NOT NULL Sealed Event
Y/N Table Edit
Default Value: N

27 AUC_ALL_LINES_FLG Character(1) VARCHAR2(1) NOT NULL Bid Required on all lines
Y/N Table Edit
Default Value: N

28 MULTIPLE_BIDS_FLG Character(1) VARCHAR2(1) NOT NULL Multiple Bids Allowed
N=Not Allowed
Y=Allowed
Y/N Table Edit
Default Value: Y

29 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.

30 AUC_TMPLTE_FLG Character(1) VARCHAR2(1) NOT NULL Auction Template
Y/N Table Edit
Default Value: N

31 RATE_DATE Date(10) DATE Exchange Rate Date

32 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

33 AUC_DISP_WEIGHTING Character(1) VARCHAR2(1) NOT NULL Display Weights
Y/N Table Edit
Default Value: Y

34 AUC_DSP_RNDVER Character(1) VARCHAR2(1) NOT NULL Display Round/Version
N=Do Not Display
R=Display Round
V=Display Round and 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_FORMAT	Character(1)	VARCHAR2(1) NOT NULL	Event Format F=Sell I=RFI R=Buy S=Service
5	AUC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Event Type E=Auction S=RFx
6	AUC_NAME	Character(50)	VARCHAR2(50) NOT NULL	Event Name
7	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
8	AUC_DTTM_PREVIEW	DateTime(26)	TIMESTAMP	Date Time Preview
9	AUC_DTTM_START	DateTime(26)	TIMESTAMP NOT NULL	Date Time Start
10	AUC_DTTM_FINISH	DateTime(26)	TIMESTAMP NOT NULL	Date Time Finish
11	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
12	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: BUS_UNIT_TBL_A1.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL
13	ORIGIN	Character(3)	VARCHAR2(3) NOT NULL	Origin
14	TAX_EXEMPT	Character(1)	VARCHAR2(1) NOT NULL	Tax Exempt Flag Y/N Table Edit Default Value: BUS_UNIT_TBL_A1.TAX_EXEMPT
15	TAX_EXEMPT_ID	Character(30)	VARCHAR2(30) NOT NULL	Tax Exempt ID Default Value: BUS_UNIT_TBL_A1.TAX_EXEMPT_ID
16	BILL_LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Billing Location Default Value: BUS_UNIT_TBL_A1.BILL_LOCATION Prompt Table: LOCATION_TBL
17	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
18	REQUESTOR_ID	Character(30)	VARCHAR2(30) NOT NULL	Requestor id Prompt Table: RQSTR_ACTIVE_VW
19	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer Prompt Table: BUYER_ACTIVE_VW
20	AUC_EXTENSION_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Allow Extension Y/N Table Edit Default Value: N
21	AUC_EXTENSION_LAST	Number(10,0)	DECIMAL(10) NOT NULL	Last Bid
22	AUC_EXTENSION_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Extension Type D=Days H=Hours M=Minutes
23	AUC_EXTENSION_QTY	Number(10,0)	DECIMAL(10) NOT NULL	Number of extensions
24	AUC_EXTENSION_LEN	Number(10,0)	DECIMAL(10) NOT NULL	Length of Extension
25	EXTENSION_LEN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Extension Length Type D=Days H=Hours M=Minutes
26	BLIND_FLG	Character(1)	VARCHAR2(1) NOT NULL	Sealed Event Y/N Table Edit Default Value: N
27	AUC_ALL_LINES_FLG	Character(1)	VARCHAR2(1) NOT NULL	Bid Required on all lines Y/N Table Edit Default Value: N
28	MULTIPLE_BIDS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Multiple Bids Allowed N=Not Allowed Y=Allowed Y/N Table Edit Default Value: Y
29	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.
30	AUC_TMPLTE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Auction Template Y/N Table Edit Default Value: N
31	RATE_DATE	Date(10)	DATE	Exchange Rate Date
32	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
33	AUC_DISP_WEIGHTING	Character(1)	VARCHAR2(1) NOT NULL	Display Weights Y/N Table Edit Default Value: Y
34	AUC_DSP_RNDVER	Character(1)	VARCHAR2(1) NOT NULL	Display Round/Version N=Do Not Display R=Display Round V=Display Round and Version