PeopleSoft 9
Account Payables

Table Name VNDR_URL

Table Description
VNDR_URL
Columns
Name Datatype Is PK Is FK
SETID VARCHAR(5) Yes Yes
VENDOR_ID VARCHAR(10) Yes Yes
VNDR_LOC VARCHAR(10) Yes Yes
EFFDT PSDATE Yes Yes
LINE_NBR int Yes No
URL VARCHAR(254) No No
DESCR VARCHAR(30) No No
Index
Name Type Unique Member
PS_VNDR_URL PK Yes
Member(s) of "PS_VNDR_URL" Index
SETID
VENDOR_ID
VNDR_LOC
EFFDT
LINE_NBR

Published June 06, 2007