PeopleSoft 9
Account Payables

Table Name LOCATION_TBL

Table Description
LOCATION_TBL
Columns
Name Datatype Is PK Is FK
SETID VARCHAR(5) Yes No
LOCATION VARCHAR(10) Yes No
EFFDT PSDATE Yes No
EFF_STATUS VARCHAR(1) No No
DESCR VARCHAR(30) No No
DESCR_AC VARCHAR(30) No No
DESCRSHORT VARCHAR(10) No No
BUILDING VARCHAR(10) No No
FLOOR VARCHAR(10) No No
SECTOR VARCHAR(10) No No
JURISDICTION VARCHAR(5) No No
ATTN_TO VARCHAR(30) 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
COUNTRY_CODE VARCHAR(3) No No
PHONE VARCHAR(24) No No
EXTENSION VARCHAR(6) No No
FAX VARCHAR(24) No No
SETID_SALARY VARCHAR(5) No No
SAL_ADMIN_PLAN VARCHAR(4) No No
LANG_CD VARCHAR(3) No No
HOLIDAY_SCHEDULE VARCHAR(6) No No
ESTABID VARCHAR(12) No No
LOCALITY VARCHAR(10) No No
CAN_CMA VARCHAR(2) No No
CAN_OEE_AREACD VARCHAR(2) No No
GEOLOC_CODE VARCHAR(10) No No
OFFICE_TYPE VARCHAR(1) No No
NCR_SW_CAN VARCHAR(1) No No
TBS_OFFICE_CD_CAN VARCHAR(10) No No
WRKS_CNCL_ID_LCL VARCHAR(9) No No
SPK_COMM_ID_GER VARCHAR(9) No No
TARIFF_AREA_GER VARCHAR(3) No No
TARIFF_GER VARCHAR(2) No No
INDUST_INSP_ID_GER VARCHAR(4) No No
NI_REPORT_SW_UK VARCHAR(1) No No
GVT_GEOLOC_CD VARCHAR(9) No No
GVT_DESIG_AGENT VARCHAR(4) No No
SOC_SEC_WRK_CTR VARCHAR(3) No No
MATRICULA_NBR SMALLINT No No
LABEL_FORMAT_ID2 VARCHAR(30) No No
LABEL_FORMAT_ID3 VARCHAR(30) No No
USG_LBL_FORMAT_ID VARCHAR(30) No No
REG_REGION VARCHAR(5) No No
COMMENTS_2000 CLOB No No
Index
Name Type Unique Member
PS_LOCATION_TBL PK Yes
PS0LOCATION_TBL IE1 No
PSALOCATION_TBL IE2 No
Member(s) of "PS_LOCATION_TBL" Index
SETID
LOCATION
EFFDT
Member(s) of "PS0LOCATION_TBL" Index
DESCR
SETID
LOCATION
EFFDT
Member(s) of "PSALOCATION_TBL" Index
LOCATION

Published June 06, 2007