(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 | 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) |
