PeopleSoft 9
Account Payables

Table Name VNDR_CNTCT_PHN

Table Description
VNDR_CNTCT_PHN
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 Yes
PHONE_TYPE VARCHAR(4) Yes No
COUNTRY_CODE VARCHAR(3) Yes No
PHONE VARCHAR(24) Yes No
EXTENSION VARCHAR(6) Yes No
Index
Name Type Unique Member
PS_VNDR_CNTCT_PHN PK Yes
Member(s) of "PS_VNDR_CNTCT_PHN" Index
SETID
VENDOR_ID
CNTCT_SEQ_NUM
EFFDT
PHONE_TYPE
COUNTRY_CODE
PHONE
EXTENSION

Published June 06, 2007