CS_AUC_HDR_VW

(SQL View)
 Index Back

RFX Events Bind Mapping

Bind mapping Record for RFX Events

SELECT A.BUSINESS_UNIT , A.AUC_ID ,A.AUC_ROUND ,A.AUC_VERSION ,A.AUC_FORMAT ,A.AUC_TYPE ,A.AUC_NAME ,A.AUC_STATUS ,A.TIMEZONE ,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.AUC_EXTENDED_DTTM ,A.AUC_EXTENDED_QTY ,A.AUC_ORIGINAL_ENDDT ,A.BLIND_FLG ,A.AUC_ALL_LINES_FLG ,A.MULTIPLE_BIDS_FLG ,A.OPRID_ENTERED_BY ,A.OPRID_MODIFIED_BY ,A.AUC_TMPLTE_FLG ,A.AUC_TMPLTE_ID ,A.AUC_TMPLTE_DESCR ,A.AUC_TMPLTE_TYPE ,A.AUC_TMPLTE_STATUS ,A.RATE_DATE ,A.RT_TYPE ,A.NAME1 ,A.PHONE ,A.EMAILID ,A.AUC_MULTI_CUR_FLG ,A.AUC_DISP_WEIGHTING ,A.AUC_PRELIM_BID ,A.AUC_EDIT_RESP ,A.AUC_SCORE_RFI ,A.CATEGORY_ID ,A.BID_CNTR_BINDING ,A.AUC_AWD_COL_STATUS ,A.AUC_AWD_COL_DUEDT ,A.AUC_AWD_COL_SHWBID ,A.AUC_DISP_SCORE_DEF ,A.WEIGHTING ,A.DESCRLONG FROM PS_AUC_HDR A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_AUC_BU_NONVW

2 AUC_ID Character(10) VARCHAR2(10) NOT NULL Event ID

Default Value: NEXT

3 AUC_ROUND Number(5,0) INTEGER NOT NULL Event Round

Default Value: 1

4 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version

Default Value: 1

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

9 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone

Prompt Table: PSTIMEZONE

10 AUC_DTTM_PREVIEW DateTime(26) TIMESTAMP Date Time Preview
11 AUC_DTTM_START DateTime(26) TIMESTAMP NOT NULL Date Time Start
12 AUC_DTTM_FINISH DateTime(26) TIMESTAMP NOT NULL Date Time Finish
13 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

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

Default Value: BUS_UNIT_TBL_A1.CURRENCY_CD

Prompt Table: CURRENCY_CD_TBL

15 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin
16 TAX_EXEMPT Character(1) VARCHAR2(1) NOT NULL Tax Exempt Flag

Y/N Table Edit

Default Value: BUS_UNIT_TBL_A1.TAX_EXEMPT

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

Default Value: BUS_UNIT_TBL_A1.TAX_EXEMPT_ID

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

Default Value: BUS_UNIT_TBL_A1.BILL_LOCATION

Prompt Table: LOCATION_TBL

19 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
20 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id

Prompt Table: RQSTR_ACTIVE_VW

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

Prompt Table: %EDIT_BUYER

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

Y/N Table Edit

Default Value: N

23 AUC_EXTENSION_LAST Number(10,0) DECIMAL(10) NOT NULL Last Bid
24 AUC_EXTENSION_TYPE Character(1) VARCHAR2(1) NOT NULL Extension Type
D=Days
H=Hours
M=Minutes
25 AUC_EXTENSION_QTY Number(10,0) DECIMAL(10) NOT NULL Number of extensions
26 AUC_EXTENSION_LEN Number(10,0) DECIMAL(10) NOT NULL Length of Extension
27 EXTENSION_LEN_TYPE Character(1) VARCHAR2(1) NOT NULL Extension Length Type
D=Days
H=Hours
M=Minutes
28 AUC_EXTENDED_DTTM DateTime(26) TIMESTAMP Date Time extension
29 AUC_EXTENDED_QTY Number(3,0) SMALLINT NOT NULL Number of Times Extended
30 AUC_ORIGINAL_ENDDT DateTime(26) TIMESTAMP Original End Date
31 BLIND_FLG Character(1) VARCHAR2(1) NOT NULL Sealed Event

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Default Value: Y

34 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
35 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.
36 AUC_TMPLTE_FLG Character(1) VARCHAR2(1) NOT NULL Auction Template

Y/N Table Edit

37 AUC_TMPLTE_ID Character(10) VARCHAR2(10) NOT NULL Template ID
38 AUC_TMPLTE_DESCR Character(25) VARCHAR2(25) NOT NULL Template Description
39 AUC_TMPLTE_TYPE Character(1) VARCHAR2(1) NOT NULL Template Type
B=Business Unit
D=Department
P=Personal
40 AUC_TMPLTE_STATUS Character(1) VARCHAR2(1) NOT NULL Template Status
A=Active
I=Inactive

Default Value: A

41 RATE_DATE Date(10) DATE Exchange Rate Date
42 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

43 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
44 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
45 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
46 AUC_MULTI_CUR_FLG Character(1) VARCHAR2(1) NOT NULL Allow MultiCurrency Events
N=No
Y=Yes

Default Value: N

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

Y/N Table Edit

Default Value: Y

48 AUC_PRELIM_BID Character(1) VARCHAR2(1) NOT NULL Allow Preliminary Bids

Y/N Table Edit

Default Value: N

49 AUC_EDIT_RESP Character(1) VARCHAR2(1) NOT NULL Edit Posted Response

Y/N Table Edit

Default Value: N

50 AUC_SCORE_RFI Character(1) VARCHAR2(1) NOT NULL Score RFI Event

Y/N Table Edit

Default Value: N

51 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
52 BID_CNTR_BINDING Character(1) VARCHAR2(1) NOT NULL Counter Offer Binding

Y/N Table Edit

Default Value: N

53 AUC_AWD_COL_STATUS Character(1) VARCHAR2(1) NOT NULL Collaboration Status
A=Available
C=Completed
N=No Collaboration
O=Checked Out

Default Value: N

54 AUC_AWD_COL_DUEDT DateTime(26) TIMESTAMP Collaboration Due Date
55 AUC_AWD_COL_SHWBID Character(1) VARCHAR2(1) NOT NULL Award Collaboration Show Bid

Y/N Table Edit

Default Value: N

56 AUC_DISP_SCORE_DEF Character(1) VARCHAR2(1) NOT NULL Display Scoring Algorithm

Y/N Table Edit

Default Value: N

57 WEIGHTING Signed Number(10,5) DECIMAL(8,5) NOT NULL Used for applying a weighting to totals. e.g. Limit Utilisation totals
58 DESCRLONG Long Character CLOB Long Description