[Home] [Help] [Dependency Information]
Object Name: | DDR_E_ORG_BSNS_UNIT# |
---|---|
Object Type: | VIEW |
Owner: | DDR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REC_ID | NUMBER | Yes | ||
ORG_CD | VARCHAR2 | (30) | ||
BSNS_UNIT_CD | VARCHAR2 | (30) | ||
GLBL_LOC_ID | VARCHAR2 | (30) | ||
GLBL_LOC_ID_TYP | VARCHAR2 | (30) | ||
BSNS_UNIT_NAME | VARCHAR2 | (240) | ||
SUB_RGN_CD | VARCHAR2 | (30) | ||
RGN_CD | VARCHAR2 | (30) | ||
ADDR_TYP_CD | VARCHAR2 | (30) | ||
CHNL_TYP_CD | VARCHAR2 | (30) | ||
TIME_ZN | VARCHAR2 | (30) | ||
LONG_DESC | VARCHAR2 | (240) | ||
SCNDRY_DESC | VARCHAR2 | (240) | ||
ADDR_LINE | VARCHAR2 | (240) | ||
ADDR_USG | VARCHAR2 | (240) | ||
CITY | VARCHAR2 | (40) | ||
STATE | VARCHAR2 | (30) | ||
CNTRY | VARCHAR2 | (30) | ||
POST_CD | VARCHAR2 | (30) | ||
GEO_CD | VARCHAR2 | (30) | ||
ADDR_PHONE | VARCHAR2 | (240) | ||
EMAIL_ADDR | VARCHAR2 | (240) | ||
CNSTRCTN_STATUS | VARCHAR2 | (30) | ||
EXTRNL_NAME | VARCHAR2 | (40) | ||
CNTCT_NBR | VARCHAR2 | (30) | ||
CNTCT_TYP | VARCHAR2 | (30) | ||
LOC_TYP_CD | VARCHAR2 | (30) | ||
PRMRY_TRD_AREA_CD | VARCHAR2 | (30) | ||
PRMRY_MKT_AREA_CD | VARCHAR2 | (30) | ||
SHPNG_CNTR_TYP | VARCHAR2 | (30) | ||
BSNS_UNIT_CNCPT | VARCHAR2 | (240) | ||
TOT_LNR_DSTNC | NUMBER | |||
VAT_RGN | VARCHAR2 | (30) | ||
VAT_INCLD_IND | VARCHAR2 | (1) | ||
PRMRY_CRNCY_CD | VARCHAR2 | (30) | ||
PRMRY_CLNDR_CD | VARCHAR2 | (30) | ||
STORE_MGR | VARCHAR2 | (40) | ||
STORE_TYP | VARCHAR2 | (30) | ||
STORE_OPEN_DT | DATE | |||
STORE_CLOSE_DT | DATE | |||
FRMT_CD | VARCHAR2 | (30) | ||
USABLE_AREA | VARCHAR2 | (40) | ||
FRMT_DESC | VARCHAR2 | (240) | ||
DSGN_CNCPT | VARCHAR2 | (240) | ||
USG_TYP_CD | VARCHAR2 | (30) | ||
INV_AREA | VARCHAR2 | (40) | ||
SLNG_AREA | VARCHAR2 | (40) | ||
SZ_UNIT | VARCHAR2 | (30) | ||
NBR_OF_LOAD_DCKS | NUMBER | |||
NBR_OF_UNLD_DCKS | NUMBER | |||
NEW_STORE_IND | VARCHAR2 | (1) | ||
REMDL_DT | DATE | |||
STORE_PRICE_INDX | NUMBER | |||
NBR_OF_LVLS | NUMBER | |||
NBR_OF_WNDW_DISP | NUMBER | |||
AREA_OF_WNDW_DISP | NUMBER | |||
FTNG_RMS_AVLBL | VARCHAR2 | (40) | ||
NBR_OF_EXTRNL_SIGN | NUMBER | |||
RSTRMS_AVLBL_IND | VARCHAR2 | (1) | ||
PRKNG_AVLBL_IND | VARCHAR2 | (1) | ||
TYP_OF_PRKNG | VARCHAR2 | (30) | ||
DSTNC_TO_NEARST_CROSS_STREET | VARCHAR2 | (40) | ||
NAME_OF_NEARST_CROSS_STREET | VARCHAR2 | (40) | ||
STCKHLD_IND | VARCHAR2 | (1) | ||
TRNSFR_ZN_CD | VARCHAR2 | (30) | ||
TRNSFR_ZN_DESC | VARCHAR2 | (240) | ||
PRMTN_ZN | VARCHAR2 | (240) | ||
TOT_BLT_UP_AREA | NUMBER | |||
TOT_SPR_BLT_UP_AREA | NUMBER | |||
TERRAIN | VARCHAR2 | (240) | ||
STATE_FIPS_CD | VARCHAR2 | (30) | ||
CNTY_FIPS_CD | VARCHAR2 | (30) | ||
STORE_VOL | VARCHAR2 | (40) | ||
WEEKLY_VOL | VARCHAR2 | (40) | ||
FULL_TIME_EMP_EQVLNTS | NUMBER | |||
NBR_OF_CHECKOUTS | NUMBER | |||
WRHS_SPCLTY | VARCHAR2 | (240) | ||
BRK_PAC_IND | VARCHAR2 | (1) | ||
HDR_CD | VARCHAR2 | (30) | ||
BNR_CD | VARCHAR2 | (32) | ||
HDR_NAME | VARCHAR2 | (40) | ||
NBR_OF_PGS | NUMBER | |||
PUBLSH_DT | DATE | |||
VALID_TILL_DT | DATE | |||
WEB_SITE_URL | VARCHAR2 | (240) | ||
WEB_SITE_VRSN | NUMBER | |||
REF_URL | VARCHAR2 | (240) | ||
REF_NAME | VARCHAR2 | (40) | ||
DEMOG_ATTR_CD_1 | VARCHAR2 | (30) | ||
DEMOG_GRP_CD_1 | VARCHAR2 | (30) | ||
DEMOG_ATTR_VAL_1 | VARCHAR2 | (40) | ||
DEMOG_UOM_CD_1 | VARCHAR2 | (30) | ||
DEMOG_ATTR_CD_2 | VARCHAR2 | (30) | ||
DEMOG_GRP_CD_2 | VARCHAR2 | (30) | ||
DEMOG_ATTR_VAL_2 | VARCHAR2 | (40) | ||
DEMOG_UOM_CD_2 | VARCHAR2 | (30) | ||
DEMOG_ATTR_CD_3 | VARCHAR2 | (30) | ||
DEMOG_GRP_CD_3 | VARCHAR2 | (30) | ||
DEMOG_ATTR_VAL_3 | VARCHAR2 | (40) | ||
DEMOG_UOM_CD_3 | VARCHAR2 | (30) | ||
INV_LOC_CD_1 | VARCHAR2 | (30) | ||
INV_LOC_TYP_CD_1 | VARCHAR2 | (30) | ||
INV_LOC_DESC_1 | VARCHAR2 | (240) | ||
LAYOUT_SHAPE_1 | VARCHAR2 | (40) | ||
LNR_SZ_1 | NUMBER | |||
SQR_SZ_1 | NUMBER | |||
CUBIC_SZ_1 | NUMBER | |||
LOC_CORDNT_X_1 | NUMBER | |||
LOC_CORDNT_Y_1 | NUMBER | |||
LOC_CORDNT_Z_1 | NUMBER | |||
INV_UOM_CD_1 | VARCHAR2 | (30) | ||
SLNG_LOC_TYP_CD_1 | VARCHAR2 | (30) | ||
NBR_OF_FCNGS_1 | NUMBER | |||
INV_LOC_CD_2 | VARCHAR2 | (30) | ||
INV_LOC_TYP_CD_2 | VARCHAR2 | (30) | ||
INV_LOC_DESC_2 | VARCHAR2 | (240) | ||
LAYOUT_SHAPE_2 | VARCHAR2 | (40) | ||
LNR_SZ_2 | NUMBER | |||
SQR_SZ_2 | NUMBER | |||
CUBIC_SZ_2 | NUMBER | |||
LOC_CORDNT_X_2 | NUMBER | |||
LOC_CORDNT_Y_2 | NUMBER | |||
LOC_CORDNT_Z_2 | NUMBER | |||
INV_UOM_CD_2 | VARCHAR2 | (30) | ||
SLNG_LOC_TYP_CD_2 | VARCHAR2 | (30) | ||
NBR_OF_FCNGS_2 | NUMBER | |||
INV_LOC_CD_3 | VARCHAR2 | (30) | ||
INV_LOC_TYP_CD_3 | VARCHAR2 | (30) | ||
INV_LOC_DESC_3 | VARCHAR2 | (240) | ||
LAYOUT_SHAPE_3 | VARCHAR2 | (40) | ||
LNR_SZ_3 | NUMBER | |||
SQR_SZ_3 | NUMBER | |||
CUBIC_SZ_3 | NUMBER | |||
LOC_CORDNT_X_3 | NUMBER | |||
LOC_CORDNT_Y_3 | NUMBER | |||
LOC_CORDNT_Z_3 | NUMBER | |||
INV_UOM_CD_3 | VARCHAR2 | (30) | ||
SLNG_LOC_TYP_CD_3 | VARCHAR2 | (30) | ||
NBR_OF_FCNGS_3 | NUMBER | |||
SRC_SYS_IDNT | VARCHAR2 | (40) | Yes | |
SRC_SYS_DT | DATE | Yes | ||
ERR_REASON | VARCHAR2 | (500) | Yes | |
ACTION_FLAG | VARCHAR2 | (1) | Yes | |
LOAD_ID | NUMBER | Yes | ||
BSNS_UNIT_TYP | VARCHAR2 | (30) | ||
DFLT_WHSE | VARCHAR2 | (30) | ||
TDLINX_STR_CD | VARCHAR2 | (7) | ||
STR_STATUS | VARCHAR2 | (1) | ||
SUB_CHNL_CD | VARCHAR2 | (30) | ||
CMPNY_SIZE | VARCHAR2 | (30) | ||
LAT | VARCHAR2 | (40) | ||
LON | VARCHAR2 | (40) | ||
STR_ACV_RANGE | VARCHAR2 | (30) | ||
FAMILY_CD | VARCHAR2 | (5) | ||
OWNER_OPER_NAME | VARCHAR2 | (32) | ||
MKTG_GRP_NAME | VARCHAR2 | (32) | ||
NON_CORP_OWNED | VARCHAR2 | (1) | ||
GAS_SOLD_IND | VARCHAR2 | (1) | ||
HIGH_VOL_CGRETTES_IND | VARCHAR2 | (1) | ||
PHARM_IN_STR_IND | VARCHAR2 | (1) | ||
LIQ_IN_STR_IND | VARCHAR2 | (1) | ||
WINE_IN_STR_IND | VARCHAR2 | (1) | ||
BEER_IN_STR_IND | VARCHAR2 | (1) | ||
SERVE_ALCOHOL_IND | VARCHAR2 | (1) | ||
ATTRIBUTE1 | VARCHAR2 | (240) | ||
ATTRIBUTE2 | VARCHAR2 | (240) | ||
ATTRIBUTE3 | VARCHAR2 | (240) | ||
ATTRIBUTE4 | VARCHAR2 | (240) | ||
ATTRIBUTE5 | VARCHAR2 | (240) | ||
ATTRIBUTE6 | VARCHAR2 | (240) | ||
ATTRIBUTE7 | VARCHAR2 | (240) | ||
ATTRIBUTE8 | VARCHAR2 | (240) | ||
ATTRIBUTE9 | VARCHAR2 | (240) | ||
ATTRIBUTE10 | VARCHAR2 | (240) | ||
ATTRIBUTE11 | NUMBER | |||
ATTRIBUTE12 | NUMBER | |||
ATTRIBUTE13 | NUMBER | |||
ATTRIBUTE14 | NUMBER | |||
ATTRIBUTE15 | NUMBER | |||
ATTRIBUTE16 | NUMBER | |||
ATTRIBUTE17 | NUMBER | |||
ATTRIBUTE18 | NUMBER | |||
ATTRIBUTE19 | NUMBER | |||
ATTRIBUTE20 | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT REC_ID
, ORG_CD
, BSNS_UNIT_CD
, GLBL_LOC_ID
, GLBL_LOC_ID_TYP
, BSNS_UNIT_NAME
, SUB_RGN_CD
, RGN_CD
, ADDR_TYP_CD
, CHNL_TYP_CD
, TIME_ZN
, LONG_DESC
, SCNDRY_DESC
, ADDR_LINE
, ADDR_USG
, CITY
, STATE
, CNTRY
, POST_CD
, GEO_CD
, ADDR_PHONE
, EMAIL_ADDR
, CNSTRCTN_STATUS
, EXTRNL_NAME
, CNTCT_NBR
, CNTCT_TYP
, LOC_TYP_CD
, PRMRY_TRD_AREA_CD
, PRMRY_MKT_AREA_CD
, SHPNG_CNTR_TYP
, BSNS_UNIT_CNCPT
, TOT_LNR_DSTNC
, VAT_RGN
, VAT_INCLD_IND
, PRMRY_CRNCY_CD
, PRMRY_CLNDR_CD
, STORE_MGR
, STORE_TYP
, STORE_OPEN_DT
, STORE_CLOSE_DT
, FRMT_CD
, USABLE_AREA
, FRMT_DESC
, DSGN_CNCPT
, USG_TYP_CD
, INV_AREA
, SLNG_AREA
, SZ_UNIT
, NBR_OF_LOAD_DCKS
, NBR_OF_UNLD_DCKS
, NEW_STORE_IND
, REMDL_DT
, STORE_PRICE_INDX
, NBR_OF_LVLS
, NBR_OF_WNDW_DISP
, AREA_OF_WNDW_DISP
, FTNG_RMS_AVLBL
, NBR_OF_EXTRNL_SIGN
, RSTRMS_AVLBL_IND
, PRKNG_AVLBL_IND
, TYP_OF_PRKNG
, DSTNC_TO_NEARST_CROSS_STREET
, NAME_OF_NEARST_CROSS_STREET
, STCKHLD_IND
, TRNSFR_ZN_CD
, TRNSFR_ZN_DESC
, PRMTN_ZN
, TOT_BLT_UP_AREA
, TOT_SPR_BLT_UP_AREA
, TERRAIN
, STATE_FIPS_CD
, CNTY_FIPS_CD
, STORE_VOL
, WEEKLY_VOL
, FULL_TIME_EMP_EQVLNTS
, NBR_OF_CHECKOUTS
, WRHS_SPCLTY
, BRK_PAC_IND
, HDR_CD
, BNR_CD
, HDR_NAME
, NBR_OF_PGS
, PUBLSH_DT
, VALID_TILL_DT
, WEB_SITE_URL
, WEB_SITE_VRSN
, REF_URL
, REF_NAME
, DEMOG_ATTR_CD_1
, DEMOG_GRP_CD_1
, DEMOG_ATTR_VAL_1
, DEMOG_UOM_CD_1
, DEMOG_ATTR_CD_2
, DEMOG_GRP_CD_2
, DEMOG_ATTR_VAL_2
, DEMOG_UOM_CD_2
, DEMOG_ATTR_CD_3
, DEMOG_GRP_CD_3
, DEMOG_ATTR_VAL_3
, DEMOG_UOM_CD_3
, INV_LOC_CD_1
, INV_LOC_TYP_CD_1
, INV_LOC_DESC_1
, LAYOUT_SHAPE_1
, LNR_SZ_1
, SQR_SZ_1
, CUBIC_SZ_1
, LOC_CORDNT_X_1
, LOC_CORDNT_Y_1
, LOC_CORDNT_Z_1
, INV_UOM_CD_1
, SLNG_LOC_TYP_CD_1
, NBR_OF_FCNGS_1
, INV_LOC_CD_2
, INV_LOC_TYP_CD_2
, INV_LOC_DESC_2
, LAYOUT_SHAPE_2
, LNR_SZ_2
, SQR_SZ_2
, CUBIC_SZ_2
, LOC_CORDNT_X_2
, LOC_CORDNT_Y_2
, LOC_CORDNT_Z_2
, INV_UOM_CD_2
, SLNG_LOC_TYP_CD_2
, NBR_OF_FCNGS_2
, INV_LOC_CD_3
, INV_LOC_TYP_CD_3
, INV_LOC_DESC_3
, LAYOUT_SHAPE_3
, LNR_SZ_3
, SQR_SZ_3
, CUBIC_SZ_3
, LOC_CORDNT_X_3
, LOC_CORDNT_Y_3
, LOC_CORDNT_Z_3
, INV_UOM_CD_3
, SLNG_LOC_TYP_CD_3
, NBR_OF_FCNGS_3
, SRC_SYS_IDNT
, SRC_SYS_DT
, ERR_REASON
, ACTION_FLAG
, LOAD_ID
, BSNS_UNIT_TYP
, DFLT_WHSE
, TDLINX_STR_CD
, STR_STATUS
, SUB_CHNL_CD
, CMPNY_SIZE
, LAT
, LON
, STR_ACV_RANGE
, FAMILY_CD
, OWNER_OPER_NAME
, MKTG_GRP_NAME
, NON_CORP_OWNED
, GAS_SOLD_IND
, HIGH_VOL_CGRETTES_IND
, PHARM_IN_STR_IND
, LIQ_IN_STR_IND
, WINE_IN_STR_IND
, BEER_IN_STR_IND
, SERVE_ALCOHOL_IND
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
FROM DDR.DDR_E_ORG_BSNS_UNIT#;
|
|
|