AUC_CYCLE_VW

(SQL View)
 Index Back

SELECT BUSINESS_UNIT , AUC_ID , AUC_FORMAT , AUC_TYPE , AUC_NAME , DESCRLONG , AUC_STATUS , AUC_DTTM_PREVIEW , AUC_DTTM_START , AUC_DTTM_FINISH , PYMNT_TERMS_CD , CURRENCY_CD , ORIGIN , TAX_EXEMPT , TAX_EXEMPT_ID , BILL_LOCATION , PAYMENT_METHOD , REQUESTOR_ID , BUYER_ID , AUC_EXTENSION_FLAG , AUC_EXTENSION_LAST , AUC_EXTENSION_TYPE , AUC_EXTENSION_QTY , AUC_EXTENSION_LEN , EXTENSION_LEN_TYPE , BLIND_FLG , AUC_ALL_LINES_FLG , MULTIPLE_BIDS_FLG , OPRID_ENTERED_BY , OPRID_MODIFIED_BY , AUC_TMPLTE_FLG , RATE_DATE , RT_TYPE , NAME1 , PHONE , EMAILID FROM PS_AUC_HDR

# 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_FORMAT Character(1) VARCHAR2(1) NOT NULL Event Format
F=Sell
I=RFI
R=Buy
S=Service
4 AUC_TYPE Character(1) VARCHAR2(1) NOT NULL Event Type
E=Auction
S=RFx
5 AUC_NAME Character(50) VARCHAR2(50) NOT NULL Event Name
6 DESCRLONG Long Character CLOB Long Description
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
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

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

15 TAX_EXEMPT_ID Character(30) VARCHAR2(30) NOT NULL Tax Exempt ID
16 BILL_LOCATION Character(10) VARCHAR2(10) NOT NULL Billing 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

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

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

Y/N Table Edit

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

Y/N Table Edit

29 OPRID_ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes
30 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.
31 AUC_TMPLTE_FLG Character(1) VARCHAR2(1) NOT NULL Auction Template

Y/N Table Edit

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

Prompt Table: RT_TYPE_TBL

34 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
35 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
36 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address