This page (revision-17) was last changed on 26-Nov-2021 10:22 by rforbes

This page was created on 26-Nov-2021 10:22 by JMyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
17 26-Nov-2021 10:22 3 KB rforbes to previous
16 26-Nov-2021 10:22 3 KB jmyers to previous | to last
15 26-Nov-2021 10:22 3 KB jmyers to previous | to last EMAIL_ADDRESS ==> EMAIL_ADDRESS(Disambiguation)
14 26-Nov-2021 10:22 3 KB JMyers to previous | to last
13 26-Nov-2021 10:22 3 KB JMyers to previous | to last
12 26-Nov-2021 10:22 3 KB JMyers to previous | to last
11 26-Nov-2021 10:22 3 KB JMyers to previous | to last
10 26-Nov-2021 10:22 3 KB JMyers to previous | to last
9 26-Nov-2021 10:22 8 KB JMyers to previous | to last
8 26-Nov-2021 10:22 7 KB JMyers to previous | to last
7 26-Nov-2021 10:22 6 KB JMyers to previous | to last
6 26-Nov-2021 10:22 1 KB JMyers to previous | to last
5 26-Nov-2021 10:22 1 KB JMyers to previous | to last
4 26-Nov-2021 10:22 1 KB JMyers to previous | to last
3 26-Nov-2021 10:22 1 KB JMyers to previous | to last
2 26-Nov-2021 10:22 4 KB JMyers to previous | to last
1 26-Nov-2021 10:22 5 KB JMyers to last

Page References

Incoming links Outgoing links
IVDLN
IVDLN

Version management

Difference between version and

At line 8 changed 28 lines
|[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)| |
;[|ID]:
;[|LOCATION_CODE]:
;[|PARENT_LOCATION|LOCATION_CODE]:
;[|DESCRIPTION]:
;[|LANGUAGE_CODE]:
;[|ADDRESS_LINE_1]:
;[|ADDRESS_LINE_2]:
;[|LOCALITY]:
;[|STATE_PROVINCE_CODE]:
;[|COUNTRY_CODE]:
;[|ZIP_POSTAL]:
;[|MAIL_ADDRESS_LINE_1]:
;[|MAIL_ADDRESS_LINE_2]:
;[|MAIL_LOCALITY]:
;[|MAIL_STATE_PROVINCE_CODE]:
;[|MAIL_COUNTRY_CODE]:
;[|MAIL_ZIP_POSTAL]:
;[|PHONE_NUMBER]:
;[|PHONE_EXTENSION]:
;[|ALT_PHONE_NUMBER]:
;[|ALT_PHONE_EXTN]:
;[|FAX_NUMBER]:
;[|EMAIL_ADDRESS]:
;[|GEO_CODE]:
;[|BILINGUAL_REGION]:
;[|BILINGUAL_LOCATION]:
;[|CMA_CODE]:
;[|INCLUDE_ALL_IN_UEHN]:
This page (revision-17) was last changed on 26-Nov-2021 10:22 by rforbesTop