PeopleSoft 9
Account Payables

Table Name VCHR_VNDR_INFO

Table Description
VCHR_VNDR_INFO
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT VARCHAR(5) Yes Yes
VOUCHER_ID VARCHAR(8) Yes Yes
NAME1 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
Index
Name Type Unique Member
PS_VCHR_VNDR_INFO PK Yes
PS0VCHR_VNDR_INFO IE1 No
Member(s) of "PS_VCHR_VNDR_INFO" Index
BUSINESS_UNIT
VOUCHER_ID
Member(s) of "PS0VCHR_VNDR_INFO" Index
NAME1
BUSINESS_UNIT
VOUCHER_ID

Published June 06, 2007