BID_FACTOR_LINE

(SQL Table)
Index Back

Bid Factor Categories

# 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 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID

Prompt Table: ITM_CAT_VW

5 BID_INCREMENT Number(13,2) DECIMAL(12,2) NOT NULL Bid Increment
6 MIN_QTY Signed Number(20,6) DECIMAL(18,6) NOT NULL Minimum Quantity
7 MAX_QTY Signed Number(20,6) DECIMAL(18,6) NOT NULL Maximum Quantity
8 IDEAL_QTY Signed Number(20,6) DECIMAL(18,6) NOT NULL Ideal Quantity
9 MIN_DT Date(10) DATE Minimum Date
10 MAX_DT Date(10) DATE Max Date
11 IDEAL_DT Date(10) DATE Ideal DateTime
12 IDEAL_TXT Character(254) VARCHAR2(254) NOT NULL Ideal Text
13 IDEAL_YN Character(1) VARCHAR2(1) NOT NULL Ideal Yes/No

Y/N Table Edit

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