PeopleSoft 9
Account Payables

Table Name COUNTRY_TBL

Table Description
COUNTRY_TBL
Columns
Name Datatype Is PK Is FK
COUNTRY VARCHAR(3) Yes No
DESCR VARCHAR(30) No No
DESCRSHORT VARCHAR(10) No No
COUNTRY_2CHAR VARCHAR(2) No No
EU_MEMBER_STATE VARCHAR(1) No No
ADDR1_LBL VARCHAR(15) No No
ADDR1_AVAIL VARCHAR(1) No No
ADDR2_LBL VARCHAR(15) No No
ADDR2_AVAIL VARCHAR(1) No No
ADDR3_LBL VARCHAR(15) No No
ADDR3_AVAIL VARCHAR(1) No No
ADDR4_LBL VARCHAR(15) No No
ADDR4_AVAIL VARCHAR(1) No No
CITY_LBL VARCHAR(15) No No
CITY_AVAIL VARCHAR(1) No No
NUM1_LBL VARCHAR(15) No No
NUM1_AVAIL VARCHAR(1) No No
NUM2_LBL VARCHAR(15) No No
NUM2_AVAIL VARCHAR(1) No No
HOUSE_TYPE_LBL VARCHAR(15) No No
HOUSE_TYPE_AVAIL VARCHAR(1) No No
ADDR_FIELD1_LBL VARCHAR(15) No No
ADDR_FIELD1_AVAIL VARCHAR(1) No No
ADDR_FIELD2_LBL VARCHAR(15) No No
ADDR_FIELD2_AVAIL VARCHAR(1) No No
ADDR_FIELD3_LBL VARCHAR(15) No No
ADDR_FIELD3_AVAIL VARCHAR(1) No No
COUNTY_LBL VARCHAR(15) No No
COUNTY_AVAIL VARCHAR(1) No No
STATE_LBL VARCHAR(15) No No
STATE_AVAIL VARCHAR(1) No No
POSTAL_LBL VARCHAR(15) No No
POSTAL_AVAIL VARCHAR(1) No No
IN_CITY_LIM_AVAIL VARCHAR(1) No No
IN_CITY_LIM_LBL VARCHAR(15) No No
GEO_CODE_AVAIL VARCHAR(1) No No
GEO_CODE_LBL VARCHAR(15) No No
POST_SRCH_AVAIL VARCHAR(1) No No
GBSYS_NRPATH_UK VARCHAR(254) No No
GBSYS_CFGPATH_UK VARCHAR(254) No No
SYNCID int No No
SYNCDTTM PSDATETIME No No
Index
Name Type Unique Member
PS_COUNTRY_TBL PK Yes
PSACOUNTRY_TBL IE2 No
PS0COUNTRY_TBL IE4 No
Member(s) of "PS_COUNTRY_TBL" Index
COUNTRY
Member(s) of "PSACOUNTRY_TBL" Index
SYNCID
Member(s) of "PS0COUNTRY_TBL" Index
DESCR
COUNTRY

Published June 06, 2007