PeopleSoft 9
Account Payables

Table Name AGENCY_LOC_CD

Table Description
AGENCY_LOC_CD
Columns
Name Datatype Is PK Is FK
SETID VARCHAR(5) Yes No
ALC VARCHAR(8) Yes No
ALC_NON_DISBRSD VARCHAR(1) No No
AGENCY_NAME VARCHAR(30) No No
DESCRSHORT VARCHAR(10) No No
ALC_BUS_ACTIVITY VARCHAR(2) No No
COUNTRY VARCHAR(3) No No
ADDRESS1 VARCHAR(55) No No
ADDRESS2 VARCHAR(55) No No
ADDRESS3 VARCHAR(55) No No
ADDRESS4 VARCHAR(55) No No
CITY VARCHAR(30) No No
NUM1 VARCHAR(6) No No
NUM2 VARCHAR(4) No No
HOUSE_TYPE VARCHAR(2) No No
ADDR_FIELD1 VARCHAR(2) No No
ADDR_FIELD2 VARCHAR(4) No No
ADDR_FIELD3 VARCHAR(4) No No
COUNTY VARCHAR(30) No No
STATE VARCHAR(6) No No
POSTAL VARCHAR(12) No No
GEO_CODE VARCHAR(11) No No
IN_CITY_LIMIT VARCHAR(1) No No
PHONE VARCHAR(24) No No
Index
Name Type Unique Member
PS_AGENCY_LOC_CD PK Yes
PS0AGENCY_LOC_CD IE1 No
Member(s) of "PS_AGENCY_LOC_CD" Index
SETID
ALC
Member(s) of "PS0AGENCY_LOC_CD" Index
ALC_NON_DISBRSD
SETID
ALC

Published June 06, 2007