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 |