PeopleSoft 9
Account Payables

Table Name CAEDD_VENDOR

Table Description
CAEDD_VENDOR
Columns
Name Datatype Is PK Is FK
FEDERAL_EIN int Yes Yes
RPT_FEDERAL_EIN int Yes Yes
EDD_ACCOUNT_NUM int Yes Yes
SETID VARCHAR(5) Yes Yes
VENDOR_ID VARCHAR(10) Yes Yes
SSN VARCHAR(9) No No
FIRST_NAME VARCHAR(30) No No
MIDDLE_INITIAL VARCHAR(1) No No
LAST_NAME VARCHAR(30) No No
Index
Name Type Unique Member
PS_CAEDD_VENDOR PK Yes
Member(s) of "PS_CAEDD_VENDOR" Index
FEDERAL_EIN
RPT_FEDERAL_EIN
EDD_ACCOUNT_NUM
SETID
VENDOR_ID

Published June 06, 2007