AUC_HDR_LN_VW (SQL View)	Index Back
Header record for Event Create Header record for Event Create

AUC_HDR_LN_VW

(SQL View)

Header record for Event Create

SELECT b.business_unit , b.auc_id , b.auc_round , b.auc_version , b.line_nbr , a.auc_format , a.auc_type , a.auc_name , a.auc_status , a.descrlong , a.timezone , a.auc_dttm_preview , a.auc_dttm_start , a.auc_dttm_finish , a.pymnt_terms_cd , a.origin , a.buyer_id , a.blind_flg , a.oprid_entered_by , a.oprid_modified_by , a.auc_score_rfi , a.category_id , a.bid_cntr_binding , a.auc_collab_status , a.auc_collab_oprid , a.auc_awd_col_status , a.auc_awd_col_duedt , a.auc_awd_col_shwbid , a.auc_disp_score_def , a.auc_disp_weighting , a.auc_disp_bid_fctr , a.auc_disp_bid_score , auc_start_prc_rl , a.auc_score_fctr , a.auc_comp_bid , b.required_flag , b.auc_line_type , b.auc_group_id , b.itm_setid , b.business_unit_am , b.inv_item_id , b.unit_of_measure , b.mfg_id , b.mfg_itm_id , b.serial_id , b.descr254_mixed , b.price_reserve , b.price_close , b.qty_auc_min , b.qty_auc_max , b.qty_auc , b.auc_price , b.auc_ext_price , b.weighting , b.auc_line_status , b.auc_qty_awarded , b.auc_qty_posted , b.auc_user_prc_brk , b.auc_bidder_prc_brk , b.auc_dsp_start_prc , b.prev_line_nbr , b.auc_alt_uom , b.auc_bid_grp_only , b.auc_bid_qty_rule , b.auc_amt_only_req FROM PS_AUC_HDR a , ps_auc_line b WHERE b.business_unit = a.business_unit AND b.auc_id = a.auc_id AND b.auc_round = a.auc_round AND b.auc_version = a.auc_version

# 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 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

6 AUC_FORMAT Character(1) VARCHAR2(1) NOT NULL Event Format
F=Sell
I=RFI
R=Buy
S=Service

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

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

9 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

10 DESCRLONG Long Character CLOB Long Description

11 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone
Prompt Table: PSTIMEZONE

12 AUC_DTTM_PREVIEW DateTime(26) TIMESTAMP Date Time Preview

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

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

15 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

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

17 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
Prompt Table: %EDIT_BUYER

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

19 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

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

21 AUC_SCORE_RFI Character(1) VARCHAR2(1) NOT NULL Score RFI Event
Y/N Table Edit
Default Value: N

22 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID

23 BID_CNTR_BINDING Character(1) VARCHAR2(1) NOT NULL Counter Offer Binding
Y/N Table Edit
Default Value: N

24 AUC_COLLAB_STATUS Character(1) VARCHAR2(1) NOT NULL Collaboration Status
A=Available
C=Checked Out
N=No Collaboration
X=Collaboration Cancelled
Default Value: N

25 AUC_COLLAB_OPRID Character(30) VARCHAR2(30) NOT NULL Collaborator OPRID

26 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

27 AUC_AWD_COL_DUEDT DateTime(26) TIMESTAMP Collaboration Due Date

28 AUC_AWD_COL_SHWBID Character(1) VARCHAR2(1) NOT NULL Award Collaboration Show Bid
Y/N Table Edit
Default Value: N

29 AUC_DISP_SCORE_DEF Character(1) VARCHAR2(1) NOT NULL Display Scoring Algorithm
Y/N Table Edit
Default Value: N

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

31 AUC_DISP_BID_FCTR Character(1) VARCHAR2(1) NOT NULL Display Bid Factors

32 AUC_DISP_BID_SCORE Character(1) VARCHAR2(1) NOT NULL Display Bid Scores

33 AUC_START_PRC_RL Character(1) VARCHAR2(1) NOT NULL Start Price
D=Display - Not Required to Beat
N=Do Not Display
Y=Display and Also Must Beat

34 AUC_SCORE_FCTR Character(1) VARCHAR2(1) NOT NULL Score Factor
B=Line Score and Total Score
L=Line Score
T=Total Score
Default Value: T

35 AUC_COMP_BID Character(1) VARCHAR2(1) NOT NULL Competitor Bids
X=Do Not Display
Y=Display and Show Identity
Z=Display but Hide Identity
Default Value: Z

36 REQUIRED_FLAG Character(1) VARCHAR2(1) NOT NULL Required Flag
N=No
Y=Yes
Y/N Table Edit

37 AUC_LINE_TYPE Character(1) VARCHAR2(1) NOT NULL Event Line Type
G=Group Line
L=Line Item
Default Value: L

38 AUC_GROUP_ID Character(18) VARCHAR2(18) NOT NULL GroupID

39 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID

40 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
Prompt Table: SP_BU_AM_NONVW

41 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
Prompt Table: %EDITTABLE26

42 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: %EDIT_UOM

43 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID
Prompt Table: MANUFACTURER

44 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID
Prompt Table: ITEM_MFG_ID_VW

45 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID

46 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description

47 PRICE_RESERVE Number(16,5) DECIMAL(15,5) NOT NULL Reserve Price

48 PRICE_CLOSE Number(16,5) DECIMAL(15,5) NOT NULL Close Price

49 QTY_AUC_MIN Number(16,4) DECIMAL(15,4) NOT NULL Minimum Event Quantity

50 QTY_AUC_MAX Number(16,4) DECIMAL(15,4) NOT NULL Quantity Max

51 QTY_AUC Number(16,4) DECIMAL(15,4) NOT NULL Event Quantity

52 AUC_PRICE Number(17,5) DECIMAL(16,5) NOT NULL Event Start price

53 AUC_EXT_PRICE Number(18,5) DECIMAL(17,5) NOT NULL Auction Extended Price

54 WEIGHTING Signed Number(10,5) DECIMAL(8,5) NOT NULL Used for applying a weighting to totals. e.g. Limit Utilisation totals

55 AUC_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL Event Line Status
C=Closed
O=Open
Default Value: O

56 AUC_QTY_AWARDED Number(16,4) DECIMAL(15,4) NOT NULL Event Line Quantity Awarded
Default Value: 0

57 AUC_QTY_POSTED Number(16,4) DECIMAL(15,4) NOT NULL Event Line Quantity Posted
Default Value: 0

58 AUC_USER_PRC_BRK Character(1) VARCHAR2(1) NOT NULL User Defined Price Breaks
Y/N Table Edit
Default Value: N

59 AUC_BIDDER_PRC_BRK Character(1) VARCHAR2(1) NOT NULL Bidder defined price breaks
Y/N Table Edit
Default Value: N

60 AUC_DSP_START_PRC Character(1) VARCHAR2(1) NOT NULL Display Start Price
Y/N Table Edit

61 PREV_LINE_NBR Number(5,0) INTEGER NOT NULL Previous Line Number

62 AUC_ALT_UOM Character(1) VARCHAR2(1) NOT NULL Alternate Units of Measure
A=Any UOM
I=Only existing item/uom's
N=Not Allowed

63 AUC_BID_GRP_ONLY Character(1) VARCHAR2(1) NOT NULL Item Biddable Only if Grouped
Y/N Table Edit
Default Value: N

64 AUC_BID_QTY_RULE Character(2) VARCHAR2(2) NOT NULL Bid Quantity Rule
MQ=Bid Up to Maximum Quantity
NA=Quantity Not Applicable
RQ=Requested Quantity Required
XQ=Allow Extra Quantity to be Bid

65 AUC_AMT_ONLY_REQ Character(1) VARCHAR2(1) NOT NULL Amount Only Requistion reference - sourcing line originating from requisition.
Y/N Table Edit
Default Value: N

#	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	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
6	AUC_FORMAT	Character(1)	VARCHAR2(1) NOT NULL	Event Format F=Sell I=RFI R=Buy S=Service
7	AUC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Event Type E=Auction S=RFx
8	AUC_NAME	Character(50)	VARCHAR2(50) NOT NULL	Event Name
9	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
10	DESCRLONG	Long Character	CLOB	Long Description
11	TIMEZONE	Character(9)	VARCHAR2(9) NOT NULL	Time Zone Prompt Table: PSTIMEZONE
12	AUC_DTTM_PREVIEW	DateTime(26)	TIMESTAMP	Date Time Preview
13	AUC_DTTM_START	DateTime(26)	TIMESTAMP NOT NULL	Date Time Start
14	AUC_DTTM_FINISH	DateTime(26)	TIMESTAMP NOT NULL	Date Time Finish
15	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
16	ORIGIN	Character(3)	VARCHAR2(3) NOT NULL	Origin
17	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer Prompt Table: %EDIT_BUYER
18	BLIND_FLG	Character(1)	VARCHAR2(1) NOT NULL	Sealed Event Y/N Table Edit Default Value: N
19	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
20	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.
21	AUC_SCORE_RFI	Character(1)	VARCHAR2(1) NOT NULL	Score RFI Event Y/N Table Edit Default Value: N
22	CATEGORY_ID	Character(5)	VARCHAR2(5) NOT NULL	Category ID
23	BID_CNTR_BINDING	Character(1)	VARCHAR2(1) NOT NULL	Counter Offer Binding Y/N Table Edit Default Value: N
24	AUC_COLLAB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Collaboration Status A=Available C=Checked Out N=No Collaboration X=Collaboration Cancelled Default Value: N
25	AUC_COLLAB_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Collaborator OPRID
26	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
27	AUC_AWD_COL_DUEDT	DateTime(26)	TIMESTAMP	Collaboration Due Date
28	AUC_AWD_COL_SHWBID	Character(1)	VARCHAR2(1) NOT NULL	Award Collaboration Show Bid Y/N Table Edit Default Value: N
29	AUC_DISP_SCORE_DEF	Character(1)	VARCHAR2(1) NOT NULL	Display Scoring Algorithm Y/N Table Edit Default Value: N
30	AUC_DISP_WEIGHTING	Character(1)	VARCHAR2(1) NOT NULL	Display Weights
31	AUC_DISP_BID_FCTR	Character(1)	VARCHAR2(1) NOT NULL	Display Bid Factors
32	AUC_DISP_BID_SCORE	Character(1)	VARCHAR2(1) NOT NULL	Display Bid Scores
33	AUC_START_PRC_RL	Character(1)	VARCHAR2(1) NOT NULL	Start Price D=Display - Not Required to Beat N=Do Not Display Y=Display and Also Must Beat
34	AUC_SCORE_FCTR	Character(1)	VARCHAR2(1) NOT NULL	Score Factor B=Line Score and Total Score L=Line Score T=Total Score Default Value: T
35	AUC_COMP_BID	Character(1)	VARCHAR2(1) NOT NULL	Competitor Bids X=Do Not Display Y=Display and Show Identity Z=Display but Hide Identity Default Value: Z
36	REQUIRED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Required Flag N=No Y=Yes Y/N Table Edit
37	AUC_LINE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Event Line Type G=Group Line L=Line Item Default Value: L
38	AUC_GROUP_ID	Character(18)	VARCHAR2(18) NOT NULL	GroupID
39	ITM_SETID	Character(5)	VARCHAR2(5) NOT NULL	Item SetID
40	BUSINESS_UNIT_AM	Character(5)	VARCHAR2(5) NOT NULL	AM Business Unit Prompt Table: SP_BU_AM_NONVW
41	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID Prompt Table: %EDITTABLE26
42	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: %EDIT_UOM
43	MFG_ID	Character(50)	VARCHAR2(50) NOT NULL	Manufacturer ID Prompt Table: MANUFACTURER
44	MFG_ITM_ID	Character(50)	VARCHAR2(50) NOT NULL	Manufacturer's Item ID Prompt Table: ITEM_MFG_ID_VW
45	SERIAL_ID	Character(20)	VARCHAR2(20) NOT NULL	Serial ID
46	DESCR254_MIXED	Character(254)	VARCHAR2(254) NOT NULL	Description
47	PRICE_RESERVE	Number(16,5)	DECIMAL(15,5) NOT NULL	Reserve Price
48	PRICE_CLOSE	Number(16,5)	DECIMAL(15,5) NOT NULL	Close Price
49	QTY_AUC_MIN	Number(16,4)	DECIMAL(15,4) NOT NULL	Minimum Event Quantity
50	QTY_AUC_MAX	Number(16,4)	DECIMAL(15,4) NOT NULL	Quantity Max
51	QTY_AUC	Number(16,4)	DECIMAL(15,4) NOT NULL	Event Quantity
52	AUC_PRICE	Number(17,5)	DECIMAL(16,5) NOT NULL	Event Start price
53	AUC_EXT_PRICE	Number(18,5)	DECIMAL(17,5) NOT NULL	Auction Extended Price
54	WEIGHTING	Signed Number(10,5)	DECIMAL(8,5) NOT NULL	Used for applying a weighting to totals. e.g. Limit Utilisation totals
55	AUC_LINE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Event Line Status C=Closed O=Open Default Value: O
56	AUC_QTY_AWARDED	Number(16,4)	DECIMAL(15,4) NOT NULL	Event Line Quantity Awarded Default Value: 0
57	AUC_QTY_POSTED	Number(16,4)	DECIMAL(15,4) NOT NULL	Event Line Quantity Posted Default Value: 0
58	AUC_USER_PRC_BRK	Character(1)	VARCHAR2(1) NOT NULL	User Defined Price Breaks Y/N Table Edit Default Value: N
59	AUC_BIDDER_PRC_BRK	Character(1)	VARCHAR2(1) NOT NULL	Bidder defined price breaks Y/N Table Edit Default Value: N
60	AUC_DSP_START_PRC	Character(1)	VARCHAR2(1) NOT NULL	Display Start Price Y/N Table Edit
61	PREV_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Previous Line Number
62	AUC_ALT_UOM	Character(1)	VARCHAR2(1) NOT NULL	Alternate Units of Measure A=Any UOM I=Only existing item/uom's N=Not Allowed
63	AUC_BID_GRP_ONLY	Character(1)	VARCHAR2(1) NOT NULL	Item Biddable Only if Grouped Y/N Table Edit Default Value: N
64	AUC_BID_QTY_RULE	Character(2)	VARCHAR2(2) NOT NULL	Bid Quantity Rule MQ=Bid Up to Maximum Quantity NA=Quantity Not Applicable RQ=Requested Quantity Required XQ=Allow Extra Quantity to be Bid
65	AUC_AMT_ONLY_REQ	Character(1)	VARCHAR2(1) NOT NULL	Amount Only Requistion reference - sourcing line originating from requisition. Y/N Table Edit Default Value: N