AUC_CONTACT_HDR

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	BIDDER_ID	Character(15)	VARCHAR2(15) NOT NULL	Bidder ID
3	CONTACT_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	A numeric key value utilized to sequence multiple contact people for a given bank/counterpar
4	ADDR_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number Prompt Table: AUC_ADDRESS_HDR
5	CONTACT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	An attribute that describes the specific purpose of a given bank/counterparty contact person. B=Billing Contact C=Contract Collaborator D=Commercial Paper Contact E=External Contact F=Cash Forecast G=General I=Internal Corporate Contact L=Line of Credit Contact M=Executive Management O=Investment Pool Contact P=Accounts Payable R=Broker S=Sales Contact V=Service Contact W=Warehousing/Shipping Contact
6	DESCR1	Character(30)	VARCHAR2(30) NOT NULL	Descr
7	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
8	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
9	TITLE	Character(35)	VARCHAR2(35) NOT NULL	Title
10	EMAILID	Character(70)	VARCHAR2(70) NOT NULL	A user's E-mail address
11	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
12	EXTENSION	Character(6)	VARCHAR2(6) NOT NULL	Phone Extension
13	FAX	Character(24)	VARCHAR2(24) NOT NULL	Fax Number
14	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
15	PRIMARY_FLG	Character(1)	VARCHAR2(1) NOT NULL	10/18/99 SCC CN#IC800: Add label PRIMARY N=No Y=Yes
16	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
17	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
18	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. Prompt Table: RT_TYPE_TBL