PeopleSoft 9
Account Payables

Table Name VNDR_LOC_ID_NBR

Table Description
VNDR_LOC_ID_NBR
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
STD_ID_NUM_QUAL VARCHAR(3) Yes No
STD_ID_NUM VARCHAR(20) No No
STD_ID_SETID VARCHAR(5) No No
CREDIT_FLG VARCHAR(1) No No
Index
Name Type Unique Member
PS_VNDR_LOC_ID_NBR PK Yes
Member(s) of "PS_VNDR_LOC_ID_NBR" Index
SETID
VENDOR_ID
VNDR_LOC
EFFDT
STD_ID_NUM_QUAL

Published June 06, 2007