VENDOR_CNTCT (SQL Table)	Index Back
Supplier Contact Detail Supplier Contact Detail Date Initials Issue Description ============================================ 07/2007 CLibby F-AHAYT-25EQ8 Added new fields oprid_ext, ext_view_access, ext_primary_owner, cs_signer_flg, cs_signer_nbr, cs_sign_visible. Used only when the contact_type = 'c' contract collaborator. (For Supplier contract management)

VENDOR_CNTCT

(SQL Table)

Supplier Contact Detail

Supplier Contact Detail Date Initials Issue Description ============================================ 07/2007 CLibby F-AHAYT-25EQ8 Added new fields oprid_ext, ext_view_access, ext_primary_owner, cs_signer_flg, cs_signer_nbr, cs_sign_visible. Used only when the contact_type = 'c' contract collaborator. (For Supplier contract management)

Parent record: VNDR_CNTCT_SCR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

3 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number

4 EFFDT Date(10) DATE Effective Date
Default Value: %date

5 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
Prompt Table: VNDR_ADD3_AP_VW

6 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

7 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL The individual contact name associated with a given bank/counterparty.

8 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

9 CONTACT_TITLE Character(35) VARCHAR2(35) NOT NULL The professional title for a given bank/counterparty contact person.

10 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

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

12 DESCR Character(30) VARCHAR2(30) NOT NULL Description

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

14 OPRID_EXT Character(30) VARCHAR2(30) NOT NULL External user
Prompt Table: VENDOR_OPR_VW

15 EXT_VIEW_ACCESS Character(1) VARCHAR2(1) NOT NULL Document access bu external users
Y/N Table Edit
Default Value: Y

16 EXT_PRIMARY_OWNER Character(1) VARCHAR2(1) NOT NULL Primary owner for external collaboration
Y/N Table Edit
Default Value: N

17 CS_SIGNER_FLG Character(1) VARCHAR2(1) NOT NULL Contract Signer
Y/N Table Edit
Default Value: N

18 CS_SIGN_NBR Number(3,0) SMALLINT NOT NULL Order of signatures

19 CS_SIGN_VISIBLE Character(1) VARCHAR2(1) NOT NULL Visibile/invisible digital signatures
Y/N Table Edit
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
3	CNTCT_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Contact Sequence Number
4	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
5	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number Prompt Table: VNDR_ADD3_AP_VW
6	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
7	CONTACT_NAME	Character(50)	VARCHAR2(50) NOT NULL	The individual contact name associated with a given bank/counterparty.
8	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
9	CONTACT_TITLE	Character(35)	VARCHAR2(35) NOT NULL	The professional title for a given bank/counterparty contact person.
10	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
11	URL	Character(254)	VARCHAR2(254) NOT NULL	Internet URL (Universal Resource Locator)
12	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
13	EMAILID	Character(70)	VARCHAR2(70) NOT NULL	A user's E-mail address
14	OPRID_EXT	Character(30)	VARCHAR2(30) NOT NULL	External user Prompt Table: VENDOR_OPR_VW
15	EXT_VIEW_ACCESS	Character(1)	VARCHAR2(1) NOT NULL	Document access bu external users Y/N Table Edit Default Value: Y
16	EXT_PRIMARY_OWNER	Character(1)	VARCHAR2(1) NOT NULL	Primary owner for external collaboration Y/N Table Edit Default Value: N
17	CS_SIGNER_FLG	Character(1)	VARCHAR2(1) NOT NULL	Contract Signer Y/N Table Edit Default Value: N
18	CS_SIGN_NBR	Number(3,0)	SMALLINT NOT NULL	Order of signatures
19	CS_SIGN_VISIBLE	Character(1)	VARCHAR2(1) NOT NULL	Visibile/invisible digital signatures Y/N Table Edit Default Value: N