Alias: DLN#

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

Location information

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
LOCATION_CODEVarchar2(16)CODEY
DSP_ID_ADDRESSNumber(10)IDYlink to P2K_CM_STATE_PROVINCES
DSP_ID_MAILNumber(10)ID link to P2K_CM_STATE_PROVINCES
DTX_IDNumber(10)ID link to P2K_CM_TAX_JURISDICTIONS
DLN_IDNumber(10)ID link to P2K_CM_LOCATIONS
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
DESCRIPTIONVarchar2(50)DESCRIPTION
FONT_HTMLVarchar2(2000)VARCHAR2000
LANGUAGE_CODEVarchar2(3)X_LANGUAGE_CODE
ADDRESS_LINE_1Varchar2(50)ADDRESS
ADDRESS_LINE_2Varchar2(50)ADDRESS
LOCALITYVarchar2(50)ADDRESS
ZIP_POSTALVarchar2(16)POSTAL CODE
MAIL_ADDRESS_LINE_1Varchar2(50)ADDRESS
MAIL_ADDRESS_LINE_2Varchar2(50)ADDRESS
MAIL_LOCALITYVarchar2(50)ADDRESS
MAIL_ZIP_POSTALVarchar2(16)POSTAL CODE
PHONE_NUMBERVarchar2(20)TELEPHONE
PHONE_EXTENSIONVarchar2(16)VARCHAR16
ALT_PHONE_NUMBERVarchar2(20)TELEPHONE
ALT_PHONE_EXTNVarchar2(16)VARCHAR16
FAX_NUMBERVarchar2(20)TELEPHONE
EMAIL_ADDRESSVarchar2(100)EMAIL
BILINGUAL_REGIONVarchar2(2)X_BILINGUAL_REGION
BILINGUAL_LOCATIONVarchar2(1)TOGGLE
CMA_CODEVarchar2(2)X_CMA_CODES
INCLUDE_ALL_IN_UEHNVarchar2(1)TOGGLE

User Fields: Allowed
Audit Logging: Allowed

Notes #

Click to create a new notes page
This particular version was published on 26-Nov-2021 10:22 by jaiken.Top