PeopleSoft 9
Account Payables

Table Name VENDOR_ADDR_PHN

Table Description
VENDOR_ADDR_PHN
Columns
Name Datatype Is PK Is FK
SETID VARCHAR(5) Yes Yes
VENDOR_ID VARCHAR(10) Yes Yes
ADDRESS_SEQ_NUM INT Yes Yes
EFFDT PSDATE Yes Yes
PHONE_TYPE VARCHAR(4) Yes No
COUNTRY_CODE VARCHAR(3) No No
PHONE VARCHAR(24) No No
EXTENSION VARCHAR(6) No No
Index
Name Type Unique Member
PS_VENDOR_ADDR_PHN PK Yes
Member(s) of "PS_VENDOR_ADDR_PHN" Index
SETID
VENDOR_ID
ADDRESS_SEQ_NUM
EFFDT
PHONE_TYPE

Published June 06, 2007