PeopleSoft 9
Account Payables

Table Name CCR_VNDR_ADDR

Table Description
CCR_VNDR_ADDR
Columns
Name Datatype Is PK Is FK
DUNS_NUMBER VARCHAR(9) Yes Yes
CCR_DUNS_PLUS4 VARCHAR(4) Yes Yes
CCR_ADDR_TYPE VARCHAR(3) Yes No
OPERATIONNAME VARCHAR(60) No No
ADDRESS1 VARCHAR(55) No No
ADDRESS2 VARCHAR(55) No No
ADDRESS5 VARCHAR(35) No No
ADDRESS6 VARCHAR(35) No No
COUNTRY VARCHAR(3) No No
STATE VARCHAR(6) No No
CPARTY_PHONE_NBR VARCHAR(30) No No
EXT_REF_NBR DECIMAL(10) No No
PHONE_SUFFIX VARCHAR(40) No No
CPARTY_FAX_NBR VARCHAR(30) No No
EMAIL_TO VARCHAR(254) No No
CC_PARENT_DUNS VARCHAR(13) No No
Index
Name Type Unique Member
PS_CCR_VNDR_ADDR PK Yes
Member(s) of "PS_CCR_VNDR_ADDR" Index
DUNS_NUMBER
CCR_DUNS_PLUS4
CCR_ADDR_TYPE

Published June 06, 2007