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 |