SPF_BID_HDR

#	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_BU_SP_NONVW
2	BID_ID	Number(10,0)	DECIMAL(10) NOT NULL	Bid Id
3	SP_REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Service Request ID
4	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
5	WORK_ORDER_ID	Character(15)	VARCHAR2(15) NOT NULL	Work Order ID
6	SEQNBR	Number(5,0)	INTEGER NOT NULL	Sequence Number
7	REQUESTOR_ID	Character(30)	VARCHAR2(30) NOT NULL	Requestor id
8	SRVC_PROVIDER_ID	Character(15)	VARCHAR2(15) NOT NULL	Service Provider Prompt Table: SPF_CNDIDATE_VW Set Control Field: BUSINESS_UNIT
9	PROVIDER_CONTACT	Character(15)	VARCHAR2(15) NOT NULL	PROVIDER CONTACT
10	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive
11	ROW_CREATE_DATE	DateTime(26)	TIMESTAMP	Row Creation Date Time Default Value: %DateTime
12	ROW_MODIFY_DATE	DateTime(26)	TIMESTAMP	Modified Date Time Default Value: %DateTime
13	ROW_CREATE_USER	Character(30)	VARCHAR2(30) NOT NULL	Row Added By
14	ROW_MODIFY_USER	Character(30)	VARCHAR2(30) NOT NULL	Modified User
15	INTERVIEWSCHEDULED	Character(1)	VARCHAR2(1) NOT NULL	Flag that indicates if an interview has been scheduled Default Value: N
16	BIDNUM	Signed Number(6,0)	DECIMAL(5) NOT NULL	Bid ID
17	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
18	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
19	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location Prompt Table: SPF_VNDR_LOC_VW Set Control Field: BUSINESS_UNIT
20	TEAM_ID	Character(15)	VARCHAR2(15) NOT NULL	Team ID
21	LINKEDWORDER	Character(15)	VARCHAR2(15) NOT NULL	Linked Work Order