(INF_CV_LOCATIONS) The INF_CV_LOCATIONS table is used to import location codes and their attendant data into the software data structures. Locations are user defined codes that uniquely identifies the location to the organization. Tables loaded: [P2K_CM_LOCATIONS] !!Table Columns \\ ||Column name||Data Type / Size||Mand.||Notes |[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'}] }]