PeopleSoft 9
Account Payables

Table Name VENDOR_CNTCT

Table Description
VENDOR_CNTCT
Columns
Name Datatype Is PK Is FK
SETID VARCHAR(5) Yes Yes
VENDOR_ID VARCHAR(10) Yes Yes
CNTCT_SEQ_NUM INT Yes Yes
EFFDT PSDATE Yes No
ADDRESS_SEQ_NUM INT No No
EFF_STATUS VARCHAR(1) No No
CONTACT_NAME VARCHAR(50) No No
CONTACT_TYPE VARCHAR(1) No No
CONTACT_TITLE VARCHAR(35) No No
PREFERRED_LANGUAGE VARCHAR(3) No No
URL VARCHAR(254) No No
DESCR VARCHAR(30) No No
EMAILID VARCHAR(70) No No
Index
Name Type Unique Member
PS_VENDOR_CNTCT PK Yes
Member(s) of "PS_VENDOR_CNTCT" Index
SETID
VENDOR_ID
CNTCT_SEQ_NUM
EFFDT

Published June 06, 2007