AUC_BIDDER_HDR (SQL Table)	Index Back
Strat Sourcing Bidder Header Used to store Strat Sourcing Bidder Header info

AUC_BIDDER_HDR

(SQL Table)

Strat Sourcing Bidder Header

Used to store Strat Sourcing Bidder Header info

Related Language Record: AUC_BIDDER_H_LG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SP_SETID_NONVW

2 BIDDER_ID Character(15) VARCHAR2(15) NOT NULL Bidder ID

3 SUP_OB_REG_ID Character(10) VARCHAR2(10) NOT NULL * Registration ID

4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

5 APPROVAL_STATUS Character(1) VARCHAR2(1) NOT NULL Approval Status
A=Approved
D=Denied
E=Sent Back for Revision
H=On Hold
I=Initial
M=Resubmitted
P=In Process
R=Rerouted
S=Submitted

6 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code

7 COMMENTS Long Character CLOB Comment

8 EMAIL_FLG Character(1) VARCHAR2(1) NOT NULL When the email flag is checked, the user will notified a specific user regarding an activity.
N=No
Y=Yes

9 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address

10 BID_CONTACT_TYPE Character(1) VARCHAR2(1) NOT NULL Bidder Type
B=Business
I=Individual

11 AUC_COMPANY_NAME Character(40) VARCHAR2(40) NOT NULL Company ID - Company Tax ID

12 ADDL_COMP_LBL Character(40) VARCHAR2(40) NOT NULL Additional Name

13 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)

14 MAIN_ADDR_SEQ_NUM Number(3,0) SMALLINT NOT NULL Address Sequence Number

15 BILL_ADDR_SEQ_NUM Number(3,0) SMALLINT NOT NULL Address Sequence Number

16 SHIP_ADDR_SEQ_NUM Number(3,0) SMALLINT NOT NULL Address Sequence Number

17 INV_ADDR_SEQ_NUM Number(3,0) SMALLINT NOT NULL Address Sequence Number

18 CREATEOPRID Character(30) VARCHAR2(30) NOT NULL A user's ID

19 CREATE_DTTM DateTime(26) TIMESTAMP Creation Datetime

20 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

21 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SP_SETID_NONVW
2	BIDDER_ID	Character(15)	VARCHAR2(15) NOT NULL	Bidder ID
3	SUP_OB_REG_ID	Character(10)	VARCHAR2(10) NOT NULL	* Registration ID
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
5	APPROVAL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Approval Status A=Approved D=Denied E=Sent Back for Revision H=On Hold I=Initial M=Resubmitted P=In Process R=Rerouted S=Submitted
6	REASON_CD	Character(10)	VARCHAR2(10) NOT NULL	Reason Code
7	COMMENTS	Long Character	CLOB	Comment
8	EMAIL_FLG	Character(1)	VARCHAR2(1) NOT NULL	When the email flag is checked, the user will notified a specific user regarding an activity. N=No Y=Yes
9	EMAILID	Character(70)	VARCHAR2(70) NOT NULL	A user's E-mail address
10	BID_CONTACT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Bidder Type B=Business I=Individual
11	AUC_COMPANY_NAME	Character(40)	VARCHAR2(40) NOT NULL	Company ID - Company Tax ID
12	ADDL_COMP_LBL	Character(40)	VARCHAR2(40) NOT NULL	Additional Name
13	URL	Character(254)	VARCHAR2(254) NOT NULL	Internet URL (Universal Resource Locator)
14	MAIN_ADDR_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Address Sequence Number
15	BILL_ADDR_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Address Sequence Number
16	SHIP_ADDR_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Address Sequence Number
17	INV_ADDR_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Address Sequence Number
18	CREATEOPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
19	CREATE_DTTM	DateTime(26)	TIMESTAMP	Creation Datetime
20	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
21	LAST_UPDATE_DTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.