Table of Contents
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 | 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, if a PARENT_LOCATION 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, if a PARENT_LOCATION has been defined. | |
ADDRESS_LINE_2 | Varchar2(50) | Derivation: Will be derived from the ADDRESS_LINE_2 for the PARENT_LOCATION, if a PARENT_LOCATION has been defined. | |
LOCALITY | Varchar2(50) | Derivation: Will be derived from the LOCALITY for the PARENT_LOCATION, if a PARENT_LOCATION 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, if a PARENT_LOCATION 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, if a PARENT_LOCATION 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, if a PARENT_LOCATION has been defined | |
PHONE_EXTENSION | Varchar2(16) | Derivation: Will be derived from the PHONE_EXTENSION for the PARENT_LOCATION, if a PARENT_LOCATION 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, if a PARENT_LOCATION has been defined. | |
ALT_PHONE_EXTN | Varchar2(16) | Derivation: Will be derived from the ALT_PHONE_EXTN for the PARENT_LOCATION, if a PARENT_LOCATION 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, if a PARENT_LOCATION has been defined. | |
EMAIL_ADDRESS | Varchar2(50) | Derivation: Will be derived from the EMAIL_ADDRESS for the PARENT_LOCATION, if a PARENT_LOCATION 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, if a PARENT_LOCATION has been defined. | |
BILINGUAL_REGION | Varchar2(30) | ||
BILINGUAL_LOCATION | Varchar2(4) | ||
CMA_CODE | Varchar2(30) | ||
INCLUDE_ALL_IN_UENH | Varchar2(4) |