AP_ARC_VND_CN_H

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
4	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
5	CNTCT_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Contact Sequence Number
6	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
7	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number Prompt Table: VNDR_CNTCADR_VW
8	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
9	CONTACT_NAME	Character(50)	VARCHAR2(50) NOT NULL	The individual contact name associated with a given bank/counterparty.
10	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
11	CONTACT_TITLE	Character(35)	VARCHAR2(35) NOT NULL	The professional title for a given bank/counterparty contact person.
12	PREFERRED_LANGUAGE	Character(3)	VARCHAR2(3) NOT NULL	Preferred Language ARA=Arabic CFR=Canadian French CZE=Czech DAN=Danish DUT=Dutch E=English ENG=English ESP=Spanish F=French FIN=Finnish FRA=French GER=German HUN=Hungarian INE=International English ITA=Italian JPN=Japanese KOR=Korean NOR=Norwegian POL=Polish POR=Portuguese RUS=Russian SVE=Swedish THA=Thai UKE=UK English ZHS=Simplified Chinese ZHT=Traditional Chinese
13	URL	Character(254)	VARCHAR2(254) NOT NULL	Internet URL (Universal Resource Locator)
14	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
15	EMAILID	Character(70)	VARCHAR2(70) NOT NULL	A user's E-mail address
16	OPRID_EXT	Character(30)	VARCHAR2(30) NOT NULL	External user
17	EXT_VIEW_ACCESS	Character(1)	VARCHAR2(1) NOT NULL	Document access bu external users
18	EXT_PRIMARY_OWNER	Character(1)	VARCHAR2(1) NOT NULL	Primary owner for external collaboration
19	CS_SIGNER_FLG	Character(1)	VARCHAR2(1) NOT NULL	Contract Signer
20	CS_SIGN_NBR	Number(3,0)	SMALLINT NOT NULL	Order of signatures
21	CS_SIGN_VISIBLE	Character(1)	VARCHAR2(1) NOT NULL	Visibile/invisible digital signatures