COUNTRYTBL_LANG
(SQL Table) |
Index Back |
|---|
Country Related Language
|
Related Language Record for
COUNTRY_TBL
Parent record: COUNTRY_TBL
| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 2 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 3 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 4 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|
| 5 |
ADDR1_LBL |
Character(15) |
VARCHAR2(15) NOT NULL |
Address 1 Label
|
| 6 |
ADDR2_LBL |
Character(15) |
VARCHAR2(15) NOT NULL |
Address 2 Label
|
| 7 |
ADDR3_LBL |
Character(15) |
VARCHAR2(15) NOT NULL |
Address 3 Label
|
| 8 |
ADDR4_LBL |
Character(15) |
VARCHAR2(15) NOT NULL |
Address 4 Label
|
| 9 |
NUM1_LBL |
Character(15) |
VARCHAR2(15) NOT NULL |
Number 1 Label
|
| 10 |
NUM2_LBL |
Character(15) |
VARCHAR2(15) NOT NULL |
Number 2 Label
|
| 11 |
HOUSE_TYPE_LBL |
Character(15) |
VARCHAR2(15) NOT NULL |
House Type Label
|
| 12 |
ADDR_FIELD1_LBL |
Character(15) |
VARCHAR2(15) NOT NULL |
Address Field 1 Label
|
| 13 |
ADDR_FIELD2_LBL |
Character(15) |
VARCHAR2(15) NOT NULL |
Address Field 2 Label
|
| 14 |
ADDR_FIELD3_LBL |
Character(15) |
VARCHAR2(15) NOT NULL |
Address Field 3 Label
|
| 15 |
CITY_LBL |
Character(15) |
VARCHAR2(15) NOT NULL |
City Label
|
| 16 |
COUNTY_LBL |
Character(15) |
VARCHAR2(15) NOT NULL |
County Label
|
| 17 |
STATE_LBL |
Character(15) |
VARCHAR2(15) NOT NULL |
State Label
|
| 18 |
POSTAL_LBL |
Character(15) |
VARCHAR2(15) NOT NULL |
Postal Label
|
| 19 |
IN_CITY_LIM_LBL |
Character(15) |
VARCHAR2(15) NOT NULL |
In City Limit Label
|
| 20 |
GEO_CODE_LBL |
Character(15) |
VARCHAR2(15) NOT NULL |
Geo Code Label
|