| # |
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
|
| 2 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 3 |
BUSINESS_UNIT_AP |
Character(5) |
VARCHAR2(5) NOT NULL |
AP Business Unit
Prompt Table:
%EDITTABLE
|
| 4 |
BUSINESS_UNIT_AM |
Character(5) |
VARCHAR2(5) NOT NULL |
AM Business Unit
Prompt Table:
%EDITTABLE10
|
| 5 |
BUSINESS_UNIT_BI |
Character(5) |
VARCHAR2(5) NOT NULL |
Billing Business Unit
Prompt Table:
%EDITTABLE
|
| 6 |
PRCS_OPTION_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Processing Option ID
Prompt Table:
BUS_UNIT_OPT_PM
|
| 7 |
BILL_SOURCE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Bill Source
Prompt Table:
BI_SRC_EF_VW
|
| 8 |
AUC_NUM_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Auctions
Y/N Table Edit
Default Value: Y
|
| 9 |
AUC_NUM_LAST_USED |
Number(10,0) |
DECIMAL(10) NOT NULL |
Last Auction ID Number
|
| 10 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 11 |
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
|
| 12 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
LOCATION_TBL
|
| 13 |
BILL_LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Billing Location
Prompt Table:
LOCATION_TBL
|
| 14 |
BUSPROCNAME_AUC |
Character(30) |
VARCHAR2(30) NOT NULL |
Auction Aprvl Business Process
Prompt Table:
BUSPROCNAME_VW
|
| 15 |
AUC_POST_APPR_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Auction Post Approval Required
Y/N Table Edit
Default Value: N
|
| 16 |
APPR_RULE_AUC_POST |
Character(30) |
VARCHAR2(30) NOT NULL |
Auction Post Approval Rule Set
|
| 17 |
AUC_AWD_APPR_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Auction Award Approval Needed
Y/N Table Edit
Default Value: N
|
| 18 |
APPR_RULE_AUC_AWD |
Character(30) |
VARCHAR2(30) NOT NULL |
Auction Award Approval RuleSet
|
| 19 |
TAX_EXEMPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exempt Flag
Y/N Table Edit
Default Value: N
|
| 20 |
TAX_EXEMPT_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Tax Exempt ID
|
| 21 |
ACCRUE_USE_TAX |
Character(1) |
VARCHAR2(1) NOT NULL |
Accrue Use Tax
Y/N Table Edit
Default Value: N
|
| 22 |
ALLOW_MC_AUC |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Multicurrency Auctions
|
| 23 |
ITEM_BU_ATTR |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Business Item Attributes
Y/N Table Edit
Default Value: N
|
| 24 |
AUC_MULTI_CUR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow MultiCurrency Events
N=No
Y=Yes
|
| 25 |
DD_PREVU_AMT |
Number(3,0) |
SMALLINT NOT NULL |
Defualt Date Preview Time
|
| 26 |
DD_PREVU_TYP |
Character(1) |
VARCHAR2(1) NOT NULL |
Defualt Date Preview Type
D=Days
H=Hours
M=Minutes
|
| 27 |
DD_START_AMT |
Number(3,0) |
SMALLINT NOT NULL |
Defualt Date Start Time
|
| 28 |
DD_START_TYP |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Date Start Type
D=Days
H=Hours
M=Minutes
|
| 29 |
DD_END_AMT |
Number(3,0) |
SMALLINT NOT NULL |
Defualt Date End Time
|
| 30 |
DD_END_TYP |
Character(1) |
VARCHAR2(1) NOT NULL |
Defualt Date End Type
D=Days
H=Hours
M=Minutes
|
| 31 |
AUC_DISPATCH_MTHD |
Character(1) |
VARCHAR2(1) NOT NULL |
Dispatch Method
E=Email
F=Fax
P=Print
Default Value: E
|
| 32 |
AUC_EVNTLOG_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Log History of Event Changes
Y/N Table Edit
Default Value: N
|
| 33 |
AUC_VERSION_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Require New Version for Edits
Y/N Table Edit
Default Value: N
|
| 34 |
AUC_AWD_PREV_RND |
Character(1) |
VARCHAR2(1) NOT NULL |
Permit Award to Previous Round
Y/N Table Edit
Default Value: N
|
| 35 |
AUC_DSP_ROUND |
Character(1) |
VARCHAR2(1) NOT NULL |
Display round
Y/N Table Edit
Default Value: Y
|
| 36 |
AUC_DSP_VERSION |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Version
Y/N Table Edit
Default Value: Y
|
| 37 |
AUC_DISP_SCORE_DEF |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Scoring Algorithm
Y/N Table Edit
Default Value: N
|
| 38 |
AUC_HDR_WEIGHT |
Signed Number(10,5) |
DECIMAL(8,5) NOT NULL |
Event Header Weighting
|
| 39 |
AUC_SOURCE_EIP |
Character(1) |
VARCHAR2(1) NOT NULL |
External PO Integration
N=No External Integration
P=PeopleSoft 8.4 Integration
Y=EnterpriseOne Integration
Default Value: N
|
| 40 |
AUC_EIP_NODE |
Character(30) |
VARCHAR2(30) NOT NULL |
Integration Node
Prompt Table:
PSNODEVW
|
| 41 |
AUC_PROXY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Proxy Flag
N=Disabled
Y=Enabled
Default Value: N
|
| 42 |
AUC_EVENT_BASE |
Character(1) |
VARCHAR2(1) NOT NULL |
Event Base
P=Price Based
S=Score Based
Default Value: S
|
| 43 |
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
Default Value: D
|
| 44 |
AUC_RANK_OPTIONS |
Character(3) |
VARCHAR2(3) NOT NULL |
Rank Options
BID=Display Rank\Total # of Bids
NON=Do Not Rank
RNK=Display Rank Only
Default Value: NON
|
| 45 |
AUC_BID_COMPETE |
Character(1) |
VARCHAR2(1) NOT NULL |
Bid Compete
L=Line Level
T=Event Level
Default Value: T
|
| 46 |
AUC_BID_SCORE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Bid Score Optimization
B=Own Bid
W=Winning Bid
Default Value: B
|
| 47 |
AUC_DSP_WIN_SCORE |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Winning Score
Y/N Table Edit
Default Value: N
|
| 48 |
AUC_DSP_RNDVER |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Round/Version
N=Do Not Display
R=Display Round
V=Display Round and Version
Default Value: V
|
| 49 |
AUC_SCORE_RFI |
Character(1) |
VARCHAR2(1) NOT NULL |
Score RFI Event
Y/N Table Edit
Default Value: N
|
| 50 |
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
|
| 51 |
BLIND_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Sealed Event
Y/N Table Edit
Default Value: N
|
| 52 |
AUC_DISP_WEIGHTING |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Weights
Y/N Table Edit
Default Value: Y
|
| 53 |
AUC_DISP_RFIWEIGHT |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Weights
Y/N Table Edit
Default Value: N
|
| 54 |
AUC_ALL_LINES_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Bid Required on all lines
Y/N Table Edit
Default Value: N
|
| 55 |
AUC_ALL_LINES_RFI |
Character(1) |
VARCHAR2(1) NOT NULL |
Bid Required on all lines
Y/N Table Edit
Default Value: N
|
| 56 |
AUC_EDIT_RESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Edit Posted Response
Y/N Table Edit
Default Value: N
|
| 57 |
AUC_EDIT_RESP_RFI |
Character(1) |
VARCHAR2(1) NOT NULL |
Edit Posted Response
Y/N Table Edit
Default Value: N
|
| 58 |
AUC_CREATE_XML_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Event PDF File Flag
Y/N Table Edit
Default Value: N
|
| 59 |
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: X
|
| 60 |
MULTIPLE_BIDS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Multiple Bids Allowed
N=Not Allowed
Y=Allowed
Y/N Table Edit
Default Value: N
|
| 61 |
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
Default Value: MQ
|
| 62 |
AUC_ALLOW_CONST |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Constraints
Y/N Table Edit
Default Value: Y
|
| 63 |
AUC_ALLOW_COST |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Cost Contribution
Y/N Table Edit
Default Value: Y
|
| 64 |
AUC_ALLOW_LNGRP |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Line Groups
Y/N Table Edit
Default Value: Y
|
| 65 |
AUC_ALLOW_PBRK |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Price Breaks
Y/N Table Edit
Default Value: Y
|
| 66 |
AUC_ALLOW_PCOMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Price Components
Y/N Table Edit
Default Value: Y
|
| 67 |
AUC_EVNT_INTEG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Integration of Events
Y/N Table Edit
Default Value: N
|
| 68 |
AUC_EVNT_NODE |
Character(30) |
VARCHAR2(30) NOT NULL |
Event Integration Node
Prompt Table:
PSNODEVW
|
| 69 |
AUC_INTEG_BUY |
Character(1) |
VARCHAR2(1) NOT NULL |
Buy Events
Y/N Table Edit
Default Value: Y
|
| 70 |
AUC_INTEG_RFI |
Character(1) |
VARCHAR2(1) NOT NULL |
RFI Events
Y/N Table Edit
Default Value: Y
|
| 71 |
AUC_INTEG_SELL |
Character(1) |
VARCHAR2(1) NOT NULL |
Sell Events
Y/N Table Edit
Default Value: Y
|
| 72 |
AUC_BUY_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
'Buy' Event Types
A=Auction
R=RFx
Z=Both RFx and Auction
Default Value: Z
|
| 73 |
AUC_SELL_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
'Sell' Event Types
A=Auction
R=RFx
Z=Both RFx and Auction
Default Value: Z
|
| 74 |
AUC_HD2LN_FCTR_WT |
Signed Number(10,5) |
DECIMAL(8,5) NOT NULL |
Line Factor Weighting
|
| 75 |
AUC_ALLOW_AUTO_VND |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Supplier Create at Award
Y/N Table Edit
Default Value: Y
|
| 76 |
AUC_PDF_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Create PDF on Event Post
Y/N Table Edit
Default Value: Y
|
| 77 |
AUC_SPLIT_ANAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Split Analysis Review
Y/N Table Edit
Default Value: N
|
| 78 |
AUC_VNDR_NOTIFY |
Character(1) |
VARCHAR2(1) NOT NULL |
Award Notification based upon
D=Days
F=When fully awarded
I=Immediate
|
| 79 |
AUC_NOTIFY_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Notify After Days
|
| 80 |
AUC_RND_ORIG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
New Round
Y/N Table Edit
Default Value: N
|
| 81 |
AUC_DISP_WORST |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Bid Factor Best/Worst
Y/N Table Edit
Default Value: Y
|
| 82 |
AUC_DISP_IDEAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Bid Factor Ideal Value
Y/N Table Edit
Default Value: Y
|
| 83 |
AUC_BID_ATCH_DWNLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow to Dwnld Bidder Atchmnts
N=Allow Download
Y=Allow Download
|
| 84 |
AUC_NOIA |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Send NOIA Notification
Y/N Table Edit
Default Value: N
|
| 85 |
AUC_BIDDER_FLG |
Character(4) |
VARCHAR2(4) NOT NULL |
Notification To be Sent
A=All Bidders
ORB=Only Responded Bidders
SB=Specific Bidders
Default Value: A
|
| 86 |
TMPLDEFN_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Template ID (see PSXPTMPLDEFN).
Prompt Table:
AUCNOIA_TMPL_VW
|
| 87 |
WL_TEMPLATE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Template Name
Prompt Table:
AUC_NOIA_GEN_VW
|
| 88 |
AUC_STD_COMM_TYPE1 |
Character(4) |
VARCHAR2(4) NOT NULL |
Standard Comment Type
Prompt Table:
AUC_STD_COM_TP1
|
| 89 |
AUC_STD_COMM_TYPE3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Standard Comment Type
Prompt Table:
AUC_STD_COM_TP3
|
| 90 |
AUC_STD_COMM_ID1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Standard Comment ID
Prompt Table:
AUC_STD_COM_1
|
| 91 |
AUC_STD_COMM_ID3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Standard Comment ID
Prompt Table:
AUC_STD_COM_3
|
| 92 |
AUC_NOA |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Send NOA Notification
N=Award Notification
Y=Allow Send NOA Notification
Default Value: N
|
| 93 |
AUC_NOA_BDR_FLG |
Character(4) |
VARCHAR2(4) NOT NULL |
Notification To be Sent
A=Only Awarded Bidders
AN=All Bidders
N=Only Non-Awarded Bidders
SB=Specific Bidders
Default Value: A
|
| 94 |
AUC_NOA_TMP_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Standard Email Template
Prompt Table:
AUC_NOA_GEN_VW
|
| 95 |
AUC_NOA_TMP_ID2 |
Character(30) |
VARCHAR2(30) NOT NULL |
NOA Report Template
Prompt Table:
AUCNOA_TMPL_VW
|
| 96 |
AUC_NOA_TMP_ID3 |
Character(30) |
VARCHAR2(30) NOT NULL |
*Non-Award Template
Prompt Table:
AUCNONA_TMP_VW
|
| 97 |
AUC_STD_COMM_TYPE4 |
Character(4) |
VARCHAR2(4) NOT NULL |
Standard Comment Type
Prompt Table:
AUC_STD_COM_TP4
|
| 98 |
AUC_STD_COMM_TYPE6 |
Character(4) |
VARCHAR2(4) NOT NULL |
Standard Comment Type
Prompt Table:
AUC_STD_COM_TP6
|
| 99 |
AUC_STD_COMM_ID4 |
Character(10) |
VARCHAR2(10) NOT NULL |
Standard Comment ID
Prompt Table:
AUC_STD_COM_4
|
| 100 |
AUC_STD_COMM_ID6 |
Character(10) |
VARCHAR2(10) NOT NULL |
Standard Comment ID
Prompt Table:
AUC_STD_COM_6
|
| 101 |
AUC_NOTICE_END |
Character(1) |
VARCHAR2(1) NOT NULL |
Award Only after Notice End
Y/N Table Edit
Default Value: N
|
| 102 |
EVENT_NOTIFY_MTHD |
Character(1) |
VARCHAR2(1) NOT NULL |
Notify Bidders On Posting
I=Immediate
P=On Preview Date
Default Value: I
|
| 103 |
AUC_EVNT_REMIND_FL |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Event Reminder Notificat
Y/N Table Edit
|
| 104 |
AUC_EC_NOTIFY_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Notification to Event Creator
Default Value: 0
|
| 105 |
AUC_EVTENDSOON_DAY |
Number(3,0) |
SMALLINT NOT NULL |
Event Ending Soon
Default Value: 0
|
| 106 |
AUC_BID_RESP_ERR |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Bid Response Errors
Y/N Table Edit
|