IVDLN
Back to current versionRestore this version

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.

IDNumber(10) Used internally to define a unique identification for the record. This field would not be loaded.
LOCATION_CODEVarchar2(16)YValidation: Must be a unique location code.
PARENT_LOCATIONVarchar2(16) Validation: This department code must have been previously defined.
DESCRIPTIONVarchar2(50)
LANGUAGE_CODEVarchar2(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_1Varchar2(50) Derivation: Will be derived from the ADDRESS_LINE_1 for the PARENT_LOCATION, if a PARENT_LOCATION has been defined.
ADDRESS_LINE_2Varchar2(50) Derivation: Will be derived from the ADDRESS_LINE_2 for the PARENT_LOCATION, if a PARENT_LOCATION has been defined.
LOCALITYVarchar2(50) Derivation: Will be derived from the LOCALITY for the PARENT_LOCATION, if a PARENT_LOCATION has been defined.
STATE_PROVINCE_CODEVarchar2(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_CODEVarchar2(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_POSTALVarchar2(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_1Varchar2(50)
MAIL_ADDRESS_LINE_2Varchar2(50)
MAIL_LOCALITYVarchar2(50)
MAIL_STATE_PROVINCE_CODEVarchar2(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_CODEVarchar2(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_POSTALVarchar2(16) Validation: Must be formatted in the correct format, for the country indicated for the mailing address
PHONE_NUMBERVarchar2(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_EXTENSIONVarchar2(16) Derivation: Will be derived from the PHONE_EXTENSION for the PARENT_LOCATION, if a PARENT_LOCATION has been defined
ALT_PHONE_NUMBERVarchar2(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_EXTNVarchar2(16) Derivation: Will be derived from the ALT_PHONE_EXTN for the PARENT_LOCATION, if a PARENT_LOCATION has been defined.
FAX_NUMBERVarchar2(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_ADDRESSVarchar2(50) Derivation: Will be derived from the EMAIL_ADDRESS for the PARENT_LOCATION, if a PARENT_LOCATION has been defined.
GEO_CODEVarchar2(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_REGIONVarchar2(30)
BILINGUAL_LOCATIONVarchar2(4)
CMA_CODEVarchar2(30)
INCLUDE_ALL_IN_UENHVarchar2(4)