DARTS : LOCATION_TBL - Company Site Locations
Created by Corina C Larsen on Jun 02, 2021
| KEY | Record.Fieldname | Format | XLAT | Heading Text |
|---|
| ADDRESS1 - Address Line 1 | Char55 |
| Address 1 |
| ADDRESS2 - Address Line 2 | Char55 |
| Address 2 |
| ADDRESS3 - Address Line 3 | Char55 |
| Address 3 |
| ADDRESS4 - Address Line 4 | Char55 |
| Address 4 |
| ADDR_FIELD1 - Address Field 1 | Char2 | N | Address Field 1 |
| ADDR_FIELD2 - Address Field 2 | Char4 |
| Address Field 2 |
| ADDR_FIELD3 - Address Field 3 | Char4 |
| Address Field 3 |
| ATTN_TO - Attention | Char30 |
| Attn |
| BUILDING - Building # | Char10 |
| Building |
| CAN_CMA - Canadian Census Metropol Area | Char2 | N | CMA |
| CAN_OEE_AREACD - CEC Management Area | Char2 | N | Mgmnt Area |
| CITY - City | Char30 |
| City |
| COMMENTS_2000 - Comments Text | Text |
| Comments |
| COUNTRY - Country | Char3 |
| Country |
| COUNTRY_CODE - Country Code | Char3 |
| Country |
| COUNTY - County | Char30 |
| County |
| DESCR - Description | Char30 |
| Descr |
| DESCRSHORT - Short Description | Char10 |
| Short Desc |
| DESCR_AC - Alternate Char Description | Char30 |
| Description |
| → | EFFDT - Effective Date | Date |
| Eff Date |
| EFF_STATUS - Status as of Effective Date | Char1 | N | Status |
| ESTABID - Establishment ID | Char12 |
| Estab ID |
| EXTENSION - Phone Extension | Char6 |
| Ext |
| FAX - Fax Number | Char24 |
| Fax |
| FLOOR - Floor # | Char10 |
| Floor # |
| FON_ER_ID_MEX - Fonacot ID Number | Char12 |
| FONACOT ID |
| FON_OFFICE_MEX - FONACOT Office | Char12 |
| FONACOT Office |
| GEOLOC_CODE - Geographical Location Code | Char10 |
| Geoloc Cd |
| GEO_CODE - Tax Vendor Geographical Code | Char11 |
| Geo Code |
| GVT_DESIG_AGENT - Designated Agent Code | Char4 |
| Designated Agt |
| GVT_GEOLOC_CD - Geog Location Code | Char9 |
| Geoloc Cd |
| HOLIDAY_SCHEDULE - Holiday Schedule | Char6 |
| Hol Sched |
| HOUSE_TYPE - House Type | Char2 | N | House |
| INDUST_INSP_ID_GER - Industrial Inspection ID | Char4 |
| Indust Insp ID |
| IN_CITY_LIMIT - In City Limit | Char1 |
| In Cty Lmt |
| JURISDICTION - Jurisdiction | Char5 |
| Jurisdictn |
| LABEL_FORMAT_ID2 - Carton Label Format ID | Char30 |
| Carton Lbl Fmt |
| LABEL_FORMAT_ID3 - Ship Container Label Format ID | Char30 |
| Shp Cnt Lbl Fmt |
| LANG_CD - Language Code | Char3 | N | Lang Cd |
| LOCALITY - Locality | Char10 |
| Locality |
| → | LOCATION - Location Code | Char10 |
| Location |
| LOC_TAX_MEX - Local Tax | Char1 |
| Local Tax |
| LOC_TAX_SPCL_MEX - Special Local Tax | Char4 | N | Spcl Local Tax |
| MATRICULA_NBR - Matricula Number | Num5.0 |
| Matricula Nbr. |
| MESSAGE_TEXT2 - Check Cashing Location | Char100 |
| Check Cash Loc |
| NCR_SW_CAN - National Capital Region | Char1 |
| NCR |
| NI_REPORT_SW_UK - Northern Ireland report Locati | Char1 |
| NI Location |
| NUM1 - Number 1 | Char6 |
| Nbr 1 |
| NUM2 - Number 2 | Char6 |
| Nbr 2 |
| OFFICE_TYPE - Office Type | Char1 | N | Offc Type |
| PHONE - Telephone | Char24 |
| Phone |
| POSTAL - Postal Code | Char12 |
| Postal |
| REG_REGION - Regulatory Region | Char5 |
| Reg Region |
| SAL_ADMIN_PLAN - Salary Administration Plan | Char4 |
| Sal Plan |
| SECTOR - Sector | Char10 |
| Sector |
| → | SETID - SetID | Char5 |
| SetID |
| SETID_SALARY - Salary SetID | Char5 |
| Salary SetID |
| SPK_COMM_ID_GER - Spokesmen Committee ID | Char9 |
| Spokesmen Comm. |
| STATE - State | Char6 |
| State |
| TARIFF_AREA_GER - Tariff Area | Char3 |
| Tariff Area |
| TARIFF_GER - Tariff | Char2 | N | Tariff |
| TBS_OFFICE_CD_CAN - Treassury Board Office Code | Char10 |
| TBS Office Code |
| TELE_LOCATION - Telework Location | Char1 |
| Tele Location |
| USG_LBL_FORMAT_ID - Item Usage Label Format | Char30 |
| Usg Lbl Format |