[{TableOfContents }]
!!!Location INTERFACE FILE

The Location Interface File screen is used to import location codes into the software data structures.

Location Interface File data is maintained on the [INF_CV_LOCATIONS] table.

|[ID]|Number(10)| |Used internally to define a unique identification for the record. This field would not be loaded.
|[LOCATION_CODE]|Varchar2(16)|Y|Validation:	Must be a unique location code.
|[PARENT_LOCATION|LOCATION_CODE]|Varchar2(16)| |Validation:	This department code must have been previously defined.
|[DESCRIPTION]|Varchar2(50)| |
|[LANGUAGE_CODE]|Varchar2(30)| |Validation:	Must be either a valid lexicon code, or a valid lexicon description from [X_LANGUAGE_CODE]. Derivation:	Will be derived from the [LANGUAGE_CODE] for the [PARENT_LOCATION|LOCATION_CODE], if a [PARENT_LOCATION|LOCATION_CODE] has been defined. Suggestion:	Most users will load this field with “ENG” for English. 
|[ADDRESS_LINE_1]|Varchar2(50)| |Derivation:	Will be derived from the [ADDRESS_LINE_1] for the [PARENT_LOCATION|LOCATION_CODE], if a [PARENT_LOCATION|LOCATION_CODE] has been defined.
|[ADDRESS_LINE_2]|Varchar2(50)| |Derivation:	Will be derived from the [ADDRESS_LINE_2] for the [PARENT_LOCATION|LOCATION_CODE], if a [PARENT_LOCATION|LOCATION_CODE] has been defined.
|[LOCALITY]|Varchar2(50)| |Derivation:	Will be derived from the [LOCALITY] for the [PARENT_LOCATION|LOCATION_CODE], if a [PARENT_LOCATION|LOCATION_CODE] has been defined.
|[STATE_PROVINCE_CODE]|Varchar2(16)| |Validation:	Must be a valid state code or province code, for the [COUNTRY_CODE] indicated on [P2K_CM_STATE_PROVINCES].  If you provide a [STATE_PROVINCE_CODE], then you must provide a [COUNTRY_CODE]. Derivation:	Will be derived from the [STATE_PROVINCE_CODE] for the [PARENT_LOCATION|LOCATION_CODE], if a [PARENT_LOCATION|LOCATION_CODE] has been defined.
|[COUNTRY_CODE]|Varchar2(16)| |Validation:	Must be a valid country code on [P2K_CM_COUNTRIES].  If you provide a [STATE_PROVINCE_CODE], then you must provide a [COUNTRY_CODE].  
|[ZIP_POSTAL]|Varchar2(16)| |Validation:	Must be formatted in the correct format, for the country indicated. Derivation:	Will be derived from the [ZIP_POSTAL] for the [PARENT_LOCATION|LOCATION_CODE], if a [PARENT_LOCATION|LOCATION_CODE] has been defined.
|[MAIL_ADDRESS_LINE_1]|Varchar2(50)| |
|[MAIL_ADDRESS_LINE_2]|Varchar2(50)| |
|[MAIL_LOCALITY]|Varchar2(50)| |
|[MAIL_STATE_PROVINCE_CODE]|Varchar2(16)| |Validation:	Must be a valid state code or province code, for the [COUNTRY_CODE] indicated on [P2K_CM_STATE_PROVINCES].  If you provide a [STATE_PROVINCE_CODE], then you must provide a [COUNTRY_CODE].
|[MAIL_COUNTRY_CODE]|Varchar2(16)| |Validation:	Must be a valid country code on [P2K_CM_COUNTRIES].  If you provide a [STATE_PROVINCE_CODE], then you must provide a [COUNTRY_CODE].  
|[MAIL_ZIP_POSTAL]|Varchar2(16)| |Validation:	Must be formatted in the correct format, for the country indicated for the mailing address
|[PHONE_NUMBER]|Varchar2(20)| |Validation:	Must be formatted in the correct format, for the country indicated by the physical location. Derivation:	Will be derived from the [PHONE_NUMBER] for the [PARENT_LOCATION|LOCATION_CODE], if a [PARENT_LOCATION|LOCATION_CODE] has been defined
|[PHONE_EXTENSION]|Varchar2(16)| |Derivation:	Will be derived from the [PHONE_EXTENSION] for the [PARENT_LOCATION|LOCATION_CODE], if a [PARENT_LOCATION|LOCATION_CODE] has been defined
|[ALT_PHONE_NUMBER]|Varchar2(20)| |Validation:	Must be formatted in the correct format, for the country indicated by the physical location.  Derivation:	Will be derived from the [ALT_PHONE_NUMBER] for the [PARENT_LOCATION|LOCATION_CODE], if a [PARENT_LOCATION|LOCATION_CODE] has been defined.
|[ALT_PHONE_EXTN]|Varchar2(16)| |Derivation:	Will be derived from the [ALT_PHONE_EXTN] for the [PARENT_LOCATION|LOCATION_CODE], if a [PARENT_LOCATION|LOCATION_CODE] has been defined.
|[FAX_NUMBER]|Varchar2(20)| |Validation:	Must be formatted in the correct format, for the country indicated by the physical location.  Derivation:	Will be derived from the [FAX_NUMBER] for the [PARENT_LOCATION|LOCATION_CODE], if a [PARENT_LOCATION|LOCATION_CODE] has been defined.
|[EMAIL_ADDRESS]|Varchar2(50)| |Derivation:	Will be derived from the [EMAIL_ADDRESS] for the [PARENT_LOCATION|LOCATION_CODE], if a [PARENT_LOCATION|LOCATION_CODE] has been defined.
|[GEO_CODE]|Varchar2(16)| |Validation:	The GEO Code must be a valid GEO code on the [P2K_CM_TAX_JURISDICTIONS] table.  If the [STATE_PROVINCE_CODE] is provided, then the [GEO_CODE] must be within that specific state, as well. Derivation:	Will be derived from the [DTX_ID] for the [PARENT_LOCATION|LOCATION_CODE], if a [PARENT_LOCATION|LOCATION_CODE] has been defined.
|[BILINGUAL_REGION]|Varchar2(30)| |
|[BILINGUAL_LOCATION]|Varchar2(4)| |
|[CMA_CODE]|Varchar2(30)| |
|[INCLUDE_ALL_IN_UENH|INCLUDE_ALL_IN_UEHN]|Varchar2(4)| |

[{If var='loginstatus' contains 'authenticated'

----
![Discussion|Edit:Internal.IVDLN] 	
[{InsertPage page='Internal.IVDLN' default='Click to create a new discussion page'}] 	

}]