PeopleSoft 9
Account Payables

Table Name CAEDD_VNDR_TRAN

Table Description
CAEDD_VNDR_TRAN
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
CALENDAR_YEAR SMALLINT Yes No
CNTRCT_BEGIN_DT PSDATE No No
CNTRCT_AMT decimal(13,2) No No
CNTRCT_EXPIRE_DT PSDATE No No
ONGOING_CONTRCT_SW VARCHAR(1) No No
DATE_LAST_PROCESS PSDATE No No
FILE_EXT SMALLINT No No
DESCR254 VARCHAR(254) No No
Index
Name Type Unique Member
PS_CAEDD_VNDR_TRAN PK Yes
Member(s) of "PS_CAEDD_VNDR_TRAN" Index
FEDERAL_EIN
RPT_FEDERAL_EIN
EDD_ACCOUNT_NUM
SETID
VENDOR_ID
CALENDAR_YEAR

Published June 06, 2007