PeopleSoft 9
Account Payables

Table Name VENDOR_ADDR

Table Description
VENDOR_ADDR
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 No
EFF_STATUS VARCHAR(1) No No
NAME1 VARCHAR(40) No No
NAME2 VARCHAR(40) No No
EMAILID VARCHAR(70) No No
COUNTRY VARCHAR(3) No No
ADDRESS1 VARCHAR(55) No No
ADDRESS2 VARCHAR(55) No No
ADDRESS3 VARCHAR(55) No No
ADDRESS4 VARCHAR(55) No No
CITY VARCHAR(30) No No
NUM1 VARCHAR(6) No No
NUM2 VARCHAR(4) No No
HOUSE_TYPE VARCHAR(2) No No
ADDR_FIELD1 VARCHAR(2) No No
ADDR_FIELD2 VARCHAR(4) No No
ADDR_FIELD3 VARCHAR(4) No No
COUNTY VARCHAR(30) No No
STATE VARCHAR(6) No No
POSTAL VARCHAR(12) No No
GEO_CODE VARCHAR(11) No No
IN_CITY_LIMIT VARCHAR(1) No No
NAME1_WTHD VARCHAR(40) No No
NAME2_WTHD VARCHAR(40) No No
Index
Name Type Unique Member
PS_VENDOR_ADDR PK Yes
PSAVENDOR_ADDR IE1 No
Member(s) of "PS_VENDOR_ADDR" Index
SETID
VENDOR_ID
ADDRESS_SEQ_NUM
EFFDT
Member(s) of "PSAVENDOR_ADDR" Index
NAME1

Published June 06, 2007