Alias: DLN#

Unique Keys: _
Child Table: _
Parent Table: _

Location information

Table Columns#

Column name	Data Type / Size	Domain	Mand.	Notes
ID	Number(10)	ID	Y
LOCATION_CODE	Varchar2(16)	CODE	Y
DSP_ID_ADDRESS	Number(10)	ID	Y	link to P2K_CM_STATE_PROVINCES
DSP_ID_MAIL	Number(10)	ID		link to P2K_CM_STATE_PROVINCES
DTX_ID	Number(10)	ID		link to P2K_CM_TAX_JURISDICTIONS
DLN_ID	Number(10)	ID		link to P2K_CM_LOCATIONS
CREATE_DATE	Date()	DATE	Y
CREATE_USER	Varchar2(30)	VARCHAR30	Y
CHANGE_DATE	Date()	DATE	Y
CHANGE_USER	Varchar2(30)	VARCHAR30	Y
DESCRIPTION	Varchar2(50)	DESCRIPTION
FONT_HTML	Varchar2(2000)	VARCHAR2000
LANGUAGE_CODE	Varchar2(3)	X_LANGUAGE_CODE
ADDRESS_LINE_1	Varchar2(50)	ADDRESS
ADDRESS_LINE_2	Varchar2(50)	ADDRESS
LOCALITY	Varchar2(50)	ADDRESS
ZIP_POSTAL	Varchar2(16)	POSTAL CODE
MAIL_ADDRESS_LINE_1	Varchar2(50)	ADDRESS
MAIL_ADDRESS_LINE_2	Varchar2(50)	ADDRESS
MAIL_LOCALITY	Varchar2(50)	ADDRESS
MAIL_ZIP_POSTAL	Varchar2(16)	POSTAL CODE
PHONE_NUMBER	Varchar2(20)	TELEPHONE
PHONE_EXTENSION	Varchar2(16)	VARCHAR16
ALT_PHONE_NUMBER	Varchar2(20)	TELEPHONE
ALT_PHONE_EXTN	Varchar2(16)	VARCHAR16
FAX_NUMBER	Varchar2(20)	TELEPHONE
EMAIL_ADDRESS(Field)	Varchar2(100)	EMAIL
BILINGUAL_REGION	Varchar2(2)	X_BILINGUAL_REGION
BILINGUAL_LOCATION	Varchar2(1)	TOGGLE
CMA_CODE	Varchar2(2)	X_CMA_CODES
INCLUDE_ALL_IN_UEHN	Varchar2(1)	TOGGLE

User Fields: Allowed
Audit Logging: Allowed

---

Notes #

Click to create a new notes page