| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 2 |
BID_FACTOR_CD |
Character(18) |
VARCHAR2(18) NOT NULL |
Bid Factor Code
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
BID_FCTR_RULE |
Number(3,0) |
SMALLINT NOT NULL |
Bid Factor Rule
|
| 5 |
BID_FCTR_RULE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Bid Factor Rule Type
H=Header Rule
L=Line Rule
Default Value: L
|
| 6 |
BID_INCREMENT |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
Bid Increment
|
| 7 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 8 |
AUC_CAT_OPERAND |
Character(2) |
VARCHAR2(2) NOT NULL |
Category Operand
EQ=Equal To
NE=Not Equal To
Default Value: EQ
|
| 9 |
CATEGORY_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Category ID
|
| 10 |
AUC_EXT_PRICE |
Number(18,5) |
DECIMAL(17,5) NOT NULL |
Auction Extended Price
|
| 11 |
AUC_EXTPRC_OPERAND |
Character(2) |
VARCHAR2(2) NOT NULL |
Extended Price Operand
EQ=Equal To
GE=Greater Than or Equal To
LE=Less Than or Equal To
NE=Not Equal To
Default Value: EQ
|
| 12 |
AUC_ITEM_OPERAND |
Character(2) |
VARCHAR2(2) NOT NULL |
Item Operand
EQ=Equal To
NE=Not Equal To
Default Value: EQ
|
| 13 |
AUC_PRICE |
Number(17,5) |
DECIMAL(16,5) NOT NULL |
Event Start price
|
| 14 |
AUC_PRICE_OPERAND |
Character(2) |
VARCHAR2(2) NOT NULL |
Price Operand
EQ=Equal To
GE=Greater Than or Equal To
LE=Less Than or Equal To
NE=Not Equal To
Default Value: EQ
|
| 15 |
AUC_QTY_OPERAND |
Character(2) |
VARCHAR2(2) NOT NULL |
Quantity Operand
EQ=Equal To
GE=Greater Than or Equal To
LE=Less Than or Equal To
NE=Not Equal To
Default Value: EQ
|
| 16 |
IDEAL_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Mandatory Response
Y/N Table Edit
Default Value: N
|
| 17 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
Prompt Table:
ITM_PURCH_VW
|
| 18 |
MIN_QTY |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Minimum Quantity
|
| 19 |
MAX_QTY |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Maximum Quantity
|
| 20 |
IDEAL_QTY |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Ideal Quantity
|
| 21 |
MIN_DT |
Date(10) |
DATE |
Minimum Date
|
| 22 |
MAX_DT |
Date(10) |
DATE |
Max Date
|
| 23 |
IDEAL_DT |
Date(10) |
DATE |
Ideal DateTime
|
| 24 |
IDEAL_TXT |
Character(254) |
VARCHAR2(254) NOT NULL |
Ideal Text
|
| 25 |
IDEAL_YN |
Character(1) |
VARCHAR2(1) NOT NULL |
Ideal Yes/No
Y/N Table Edit
Default Value: N
|
| 26 |
QTY_AUC |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Event Quantity
|
| 27 |
REQUIRED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Required Flag
N=No
Y=Yes
Y/N Table Edit
Default Value: Y
|
| 28 |
WEIGHTING |
Signed Number(10,5) |
DECIMAL(8,5) NOT NULL |
Used for applying a weighting to totals.
e.g. Limit Utilisation totals
|
| 29 |
AUC_COST_BASE |
Character(1) |
VARCHAR2(1) NOT NULL |
Sourcing Costing Base
F=Fixed Cost
N=N\A
P=Bid Price
Q=Bid Quantity
R=Cost Range
U=User Defined
Default Value: N
|
| 30 |
AUC_COST_APPLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Sourcing Costing
C=Total Cost
N=N\A
U=Per Unit
Default Value: N
|
| 31 |
AUC_COST_UNIT |
Signed Number(14,2) |
DECIMAL(12,2) NOT NULL |
Sourcing Costing Unit Field
|
| 32 |
AUC_COST_VAL1 |
Signed Number(14,2) |
DECIMAL(12,2) NOT NULL |
Sourcing Costing Field
|
| 33 |
AUC_COST_VAL2 |
Signed Number(14,2) |
DECIMAL(12,2) NOT NULL |
Sourcing Costing Field
|
| 34 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|