SSO_LINE_VNDR

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance

2 SSO_BIDLN_INDEX Number(10,0) DECIMAL(10) NOT NULL Bid Line Index

3 SSO_VNDR_INDEX Number(10,0) DECIMAL(10) NOT NULL Supplier Index

4 SSO_LINE_COST Signed Number(18,6) DECIMAL(16,6) NOT NULL line cost

5 SSO_COST Signed Number(18,6) DECIMAL(16,6) NOT NULL Cost

6 AUC_SCORE Number(9,5) DECIMAL(8,5) NOT NULL Score

7 AUC_TIER_NBR Number(5,0) INTEGER NOT NULL Tier Number

8 SSO_BID_MULTIPLE Number(17,6) DECIMAL(16,6) NOT NULL Bid multiplier

9 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROBINST	Character(20)	VARCHAR2(20) NOT NULL	Optimization Problem Instance
2	SSO_BIDLN_INDEX	Number(10,0)	DECIMAL(10) NOT NULL	Bid Line Index
3	SSO_VNDR_INDEX	Number(10,0)	DECIMAL(10) NOT NULL	Supplier Index
4	SSO_LINE_COST	Signed Number(18,6)	DECIMAL(16,6) NOT NULL	line cost
5	SSO_COST	Signed Number(18,6)	DECIMAL(16,6) NOT NULL	Cost
6	AUC_SCORE	Number(9,5)	DECIMAL(8,5) NOT NULL	Score
7	AUC_TIER_NBR	Number(5,0)	INTEGER NOT NULL	Tier Number
8	SSO_BID_MULTIPLE	Number(17,6)	DECIMAL(16,6) NOT NULL	Bid multiplier
9	VERSION	Number(10,0)	DECIMAL(10) NOT NULL	Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference