P 2 K_CM_LOCATIONS
Back to current versionRestore this version

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

Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor

All content © High Line Corporation