VIEW: DDR.DDR_E_ORG_BSNS_UNIT#

Source

View Text - Preformatted

select REC_ID REC_ID, ORG_CD ORG_CD, BSNS_UNIT_CD BSNS_UNIT_CD, GLBL_LOC_ID GLBL_LOC_ID, GLBL_LOC_ID_TYP GLBL_LOC_ID_TYP, BSNS_UNIT_NAME BSNS_UNIT_NAME, SUB_RGN_CD SUB_RGN_CD, RGN_CD RGN_CD, ADDR_TYP_CD ADDR_TYP_CD, CHNL_TYP_CD CHNL_TYP_CD, TIME_ZN TIME_ZN, LONG_DESC LONG_DESC, SCNDRY_DESC SCNDRY_DESC, ADDR_LINE ADDR_LINE, ADDR_USG ADDR_USG, CITY CITY, STATE STATE, CNTRY CNTRY, POST_CD POST_CD, GEO_CD GEO_CD, ADDR_PHONE ADDR_PHONE, EMAIL_ADDR EMAIL_ADDR, CNSTRCTN_STATUS CNSTRCTN_STATUS, EXTRNL_NAME EXTRNL_NAME, CNTCT_NBR CNTCT_NBR, CNTCT_TYP CNTCT_TYP, LOC_TYP_CD LOC_TYP_CD, PRMRY_TRD_AREA_CD PRMRY_TRD_AREA_CD, PRMRY_MKT_AREA_CD PRMRY_MKT_AREA_CD, SHPNG_CNTR_TYP SHPNG_CNTR_TYP, BSNS_UNIT_CNCPT BSNS_UNIT_CNCPT, TOT_LNR_DSTNC TOT_LNR_DSTNC, VAT_RGN VAT_RGN, VAT_INCLD_IND VAT_INCLD_IND, PRMRY_CRNCY_CD PRMRY_CRNCY_CD, PRMRY_CLNDR_CD PRMRY_CLNDR_CD, STORE_MGR STORE_MGR, STORE_TYP STORE_TYP, STORE_OPEN_DT STORE_OPEN_DT, STORE_CLOSE_DT STORE_CLOSE_DT, FRMT_CD FRMT_CD, USABLE_AREA USABLE_AREA, FRMT_DESC FRMT_DESC, DSGN_CNCPT DSGN_CNCPT, USG_TYP_CD USG_TYP_CD, INV_AREA INV_AREA, SLNG_AREA SLNG_AREA, SZ_UNIT SZ_UNIT, NBR_OF_LOAD_DCKS NBR_OF_LOAD_DCKS, NBR_OF_UNLD_DCKS NBR_OF_UNLD_DCKS, NEW_STORE_IND NEW_STORE_IND, REMDL_DT REMDL_DT, STORE_PRICE_INDX STORE_PRICE_INDX, NBR_OF_LVLS NBR_OF_LVLS, NBR_OF_WNDW_DISP NBR_OF_WNDW_DISP, AREA_OF_WNDW_DISP AREA_OF_WNDW_DISP, FTNG_RMS_AVLBL FTNG_RMS_AVLBL, NBR_OF_EXTRNL_SIGN NBR_OF_EXTRNL_SIGN, RSTRMS_AVLBL_IND RSTRMS_AVLBL_IND, PRKNG_AVLBL_IND PRKNG_AVLBL_IND, TYP_OF_PRKNG TYP_OF_PRKNG, DSTNC_TO_NEARST_CROSS_STREET DSTNC_TO_NEARST_CROSS_STREET, NAME_OF_NEARST_CROSS_STREET NAME_OF_NEARST_CROSS_STREET, STCKHLD_IND STCKHLD_IND, TRNSFR_ZN_CD TRNSFR_ZN_CD, TRNSFR_ZN_DESC TRNSFR_ZN_DESC, PRMTN_ZN PRMTN_ZN, TOT_BLT_UP_AREA TOT_BLT_UP_AREA, TOT_SPR_BLT_UP_AREA TOT_SPR_BLT_UP_AREA, TERRAIN TERRAIN, STATE_FIPS_CD STATE_FIPS_CD, CNTY_FIPS_CD CNTY_FIPS_CD, STORE_VOL STORE_VOL, WEEKLY_VOL WEEKLY_VOL, FULL_TIME_EMP_EQVLNTS FULL_TIME_EMP_EQVLNTS, NBR_OF_CHECKOUTS NBR_OF_CHECKOUTS, WRHS_SPCLTY WRHS_SPCLTY, BRK_PAC_IND BRK_PAC_IND, HDR_CD HDR_CD, BNR_CD BNR_CD, HDR_NAME HDR_NAME, NBR_OF_PGS NBR_OF_PGS, PUBLSH_DT PUBLSH_DT, VALID_TILL_DT VALID_TILL_DT, WEB_SITE_URL WEB_SITE_URL, WEB_SITE_VRSN WEB_SITE_VRSN, REF_URL REF_URL, REF_NAME REF_NAME, DEMOG_ATTR_CD_1 DEMOG_ATTR_CD_1, DEMOG_GRP_CD_1 DEMOG_GRP_CD_1, DEMOG_ATTR_VAL_1 DEMOG_ATTR_VAL_1, DEMOG_UOM_CD_1 DEMOG_UOM_CD_1, DEMOG_ATTR_CD_2 DEMOG_ATTR_CD_2, DEMOG_GRP_CD_2 DEMOG_GRP_CD_2, DEMOG_ATTR_VAL_2 DEMOG_ATTR_VAL_2, DEMOG_UOM_CD_2 DEMOG_UOM_CD_2, DEMOG_ATTR_CD_3 DEMOG_ATTR_CD_3, DEMOG_GRP_CD_3 DEMOG_GRP_CD_3, DEMOG_ATTR_VAL_3 DEMOG_ATTR_VAL_3, DEMOG_UOM_CD_3 DEMOG_UOM_CD_3, INV_LOC_CD_1 INV_LOC_CD_1, INV_LOC_TYP_CD_1 INV_LOC_TYP_CD_1, INV_LOC_DESC_1 INV_LOC_DESC_1, LAYOUT_SHAPE_1 LAYOUT_SHAPE_1, LNR_SZ_1 LNR_SZ_1, SQR_SZ_1 SQR_SZ_1, CUBIC_SZ_1 CUBIC_SZ_1, LOC_CORDNT_X_1 LOC_CORDNT_X_1, LOC_CORDNT_Y_1 LOC_CORDNT_Y_1, LOC_CORDNT_Z_1 LOC_CORDNT_Z_1, INV_UOM_CD_1 INV_UOM_CD_1, SLNG_LOC_TYP_CD_1 SLNG_LOC_TYP_CD_1, NBR_OF_FCNGS_1 NBR_OF_FCNGS_1, INV_LOC_CD_2 INV_LOC_CD_2, INV_LOC_TYP_CD_2 INV_LOC_TYP_CD_2, INV_LOC_DESC_2 INV_LOC_DESC_2, LAYOUT_SHAPE_2 LAYOUT_SHAPE_2, LNR_SZ_2 LNR_SZ_2, SQR_SZ_2 SQR_SZ_2, CUBIC_SZ_2 CUBIC_SZ_2, LOC_CORDNT_X_2 LOC_CORDNT_X_2, LOC_CORDNT_Y_2 LOC_CORDNT_Y_2, LOC_CORDNT_Z_2 LOC_CORDNT_Z_2, INV_UOM_CD_2 INV_UOM_CD_2, SLNG_LOC_TYP_CD_2 SLNG_LOC_TYP_CD_2, NBR_OF_FCNGS_2 NBR_OF_FCNGS_2, INV_LOC_CD_3 INV_LOC_CD_3, INV_LOC_TYP_CD_3 INV_LOC_TYP_CD_3, INV_LOC_DESC_3 INV_LOC_DESC_3, LAYOUT_SHAPE_3 LAYOUT_SHAPE_3, LNR_SZ_3 LNR_SZ_3, SQR_SZ_3 SQR_SZ_3, CUBIC_SZ_3 CUBIC_SZ_3, LOC_CORDNT_X_3 LOC_CORDNT_X_3, LOC_CORDNT_Y_3 LOC_CORDNT_Y_3, LOC_CORDNT_Z_3 LOC_CORDNT_Z_3, INV_UOM_CD_3 INV_UOM_CD_3, SLNG_LOC_TYP_CD_3 SLNG_LOC_TYP_CD_3, NBR_OF_FCNGS_3 NBR_OF_FCNGS_3, SRC_SYS_IDNT SRC_SYS_IDNT, SRC_SYS_DT SRC_SYS_DT, ERR_REASON ERR_REASON, ACTION_FLAG ACTION_FLAG, LOAD_ID LOAD_ID, BSNS_UNIT_TYP BSNS_UNIT_TYP, DFLT_WHSE DFLT_WHSE, TDLINX_STR_CD TDLINX_STR_CD, STR_STATUS STR_STATUS, SUB_CHNL_CD SUB_CHNL_CD, CMPNY_SIZE CMPNY_SIZE, LAT LAT, LON LON, STR_ACV_RANGE STR_ACV_RANGE, FAMILY_CD FAMILY_CD, OWNER_OPER_NAME OWNER_OPER_NAME, MKTG_GRP_NAME MKTG_GRP_NAME, NON_CORP_OWNED NON_CORP_OWNED, GAS_SOLD_IND GAS_SOLD_IND, HIGH_VOL_CGRETTES_IND HIGH_VOL_CGRETTES_IND, PHARM_IN_STR_IND PHARM_IN_STR_IND, LIQ_IN_STR_IND LIQ_IN_STR_IND, WINE_IN_STR_IND WINE_IN_STR_IND, BEER_IN_STR_IND BEER_IN_STR_IND, SERVE_ALCOHOL_IND SERVE_ALCOHOL_IND, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20 from "DDR"."DDR_E_ORG_BSNS_UNIT"

View Text - HTML Formatted

SELECT REC_ID REC_ID
, ORG_CD ORG_CD
, BSNS_UNIT_CD BSNS_UNIT_CD
, GLBL_LOC_ID GLBL_LOC_ID
, GLBL_LOC_ID_TYP GLBL_LOC_ID_TYP
, BSNS_UNIT_NAME BSNS_UNIT_NAME
, SUB_RGN_CD SUB_RGN_CD
, RGN_CD RGN_CD
, ADDR_TYP_CD ADDR_TYP_CD
, CHNL_TYP_CD CHNL_TYP_CD
, TIME_ZN TIME_ZN
, LONG_DESC LONG_DESC
, SCNDRY_DESC SCNDRY_DESC
, ADDR_LINE ADDR_LINE
, ADDR_USG ADDR_USG
, CITY CITY
, STATE STATE
, CNTRY CNTRY
, POST_CD POST_CD
, GEO_CD GEO_CD
, ADDR_PHONE ADDR_PHONE
, EMAIL_ADDR EMAIL_ADDR
, CNSTRCTN_STATUS CNSTRCTN_STATUS
, EXTRNL_NAME EXTRNL_NAME
, CNTCT_NBR CNTCT_NBR
, CNTCT_TYP CNTCT_TYP
, LOC_TYP_CD LOC_TYP_CD
, PRMRY_TRD_AREA_CD PRMRY_TRD_AREA_CD
, PRMRY_MKT_AREA_CD PRMRY_MKT_AREA_CD
, SHPNG_CNTR_TYP SHPNG_CNTR_TYP
, BSNS_UNIT_CNCPT BSNS_UNIT_CNCPT
, TOT_LNR_DSTNC TOT_LNR_DSTNC
, VAT_RGN VAT_RGN
, VAT_INCLD_IND VAT_INCLD_IND
, PRMRY_CRNCY_CD PRMRY_CRNCY_CD
, PRMRY_CLNDR_CD PRMRY_CLNDR_CD
, STORE_MGR STORE_MGR
, STORE_TYP STORE_TYP
, STORE_OPEN_DT STORE_OPEN_DT
, STORE_CLOSE_DT STORE_CLOSE_DT
, FRMT_CD FRMT_CD
, USABLE_AREA USABLE_AREA
, FRMT_DESC FRMT_DESC
, DSGN_CNCPT DSGN_CNCPT
, USG_TYP_CD USG_TYP_CD
, INV_AREA INV_AREA
, SLNG_AREA SLNG_AREA
, SZ_UNIT SZ_UNIT
, NBR_OF_LOAD_DCKS NBR_OF_LOAD_DCKS
, NBR_OF_UNLD_DCKS NBR_OF_UNLD_DCKS
, NEW_STORE_IND NEW_STORE_IND
, REMDL_DT REMDL_DT
, STORE_PRICE_INDX STORE_PRICE_INDX
, NBR_OF_LVLS NBR_OF_LVLS
, NBR_OF_WNDW_DISP NBR_OF_WNDW_DISP
, AREA_OF_WNDW_DISP AREA_OF_WNDW_DISP
, FTNG_RMS_AVLBL FTNG_RMS_AVLBL
, NBR_OF_EXTRNL_SIGN NBR_OF_EXTRNL_SIGN
, RSTRMS_AVLBL_IND RSTRMS_AVLBL_IND
, PRKNG_AVLBL_IND PRKNG_AVLBL_IND
, TYP_OF_PRKNG TYP_OF_PRKNG
, DSTNC_TO_NEARST_CROSS_STREET DSTNC_TO_NEARST_CROSS_STREET
, NAME_OF_NEARST_CROSS_STREET NAME_OF_NEARST_CROSS_STREET
, STCKHLD_IND STCKHLD_IND
, TRNSFR_ZN_CD TRNSFR_ZN_CD
, TRNSFR_ZN_DESC TRNSFR_ZN_DESC
, PRMTN_ZN PRMTN_ZN
, TOT_BLT_UP_AREA TOT_BLT_UP_AREA
, TOT_SPR_BLT_UP_AREA TOT_SPR_BLT_UP_AREA
, TERRAIN TERRAIN
, STATE_FIPS_CD STATE_FIPS_CD
, CNTY_FIPS_CD CNTY_FIPS_CD
, STORE_VOL STORE_VOL
, WEEKLY_VOL WEEKLY_VOL
, FULL_TIME_EMP_EQVLNTS FULL_TIME_EMP_EQVLNTS
, NBR_OF_CHECKOUTS NBR_OF_CHECKOUTS
, WRHS_SPCLTY WRHS_SPCLTY
, BRK_PAC_IND BRK_PAC_IND
, HDR_CD HDR_CD
, BNR_CD BNR_CD
, HDR_NAME HDR_NAME
, NBR_OF_PGS NBR_OF_PGS
, PUBLSH_DT PUBLSH_DT
, VALID_TILL_DT VALID_TILL_DT
, WEB_SITE_URL WEB_SITE_URL
, WEB_SITE_VRSN WEB_SITE_VRSN
, REF_URL REF_URL
, REF_NAME REF_NAME
, DEMOG_ATTR_CD_1 DEMOG_ATTR_CD_1
, DEMOG_GRP_CD_1 DEMOG_GRP_CD_1
, DEMOG_ATTR_VAL_1 DEMOG_ATTR_VAL_1
, DEMOG_UOM_CD_1 DEMOG_UOM_CD_1
, DEMOG_ATTR_CD_2 DEMOG_ATTR_CD_2
, DEMOG_GRP_CD_2 DEMOG_GRP_CD_2
, DEMOG_ATTR_VAL_2 DEMOG_ATTR_VAL_2
, DEMOG_UOM_CD_2 DEMOG_UOM_CD_2
, DEMOG_ATTR_CD_3 DEMOG_ATTR_CD_3
, DEMOG_GRP_CD_3 DEMOG_GRP_CD_3
, DEMOG_ATTR_VAL_3 DEMOG_ATTR_VAL_3
, DEMOG_UOM_CD_3 DEMOG_UOM_CD_3
, INV_LOC_CD_1 INV_LOC_CD_1
, INV_LOC_TYP_CD_1 INV_LOC_TYP_CD_1
, INV_LOC_DESC_1 INV_LOC_DESC_1
, LAYOUT_SHAPE_1 LAYOUT_SHAPE_1
, LNR_SZ_1 LNR_SZ_1
, SQR_SZ_1 SQR_SZ_1
, CUBIC_SZ_1 CUBIC_SZ_1
, LOC_CORDNT_X_1 LOC_CORDNT_X_1
, LOC_CORDNT_Y_1 LOC_CORDNT_Y_1
, LOC_CORDNT_Z_1 LOC_CORDNT_Z_1
, INV_UOM_CD_1 INV_UOM_CD_1
, SLNG_LOC_TYP_CD_1 SLNG_LOC_TYP_CD_1
, NBR_OF_FCNGS_1 NBR_OF_FCNGS_1
, INV_LOC_CD_2 INV_LOC_CD_2
, INV_LOC_TYP_CD_2 INV_LOC_TYP_CD_2
, INV_LOC_DESC_2 INV_LOC_DESC_2
, LAYOUT_SHAPE_2 LAYOUT_SHAPE_2
, LNR_SZ_2 LNR_SZ_2
, SQR_SZ_2 SQR_SZ_2
, CUBIC_SZ_2 CUBIC_SZ_2
, LOC_CORDNT_X_2 LOC_CORDNT_X_2
, LOC_CORDNT_Y_2 LOC_CORDNT_Y_2
, LOC_CORDNT_Z_2 LOC_CORDNT_Z_2
, INV_UOM_CD_2 INV_UOM_CD_2
, SLNG_LOC_TYP_CD_2 SLNG_LOC_TYP_CD_2
, NBR_OF_FCNGS_2 NBR_OF_FCNGS_2
, INV_LOC_CD_3 INV_LOC_CD_3
, INV_LOC_TYP_CD_3 INV_LOC_TYP_CD_3
, INV_LOC_DESC_3 INV_LOC_DESC_3
, LAYOUT_SHAPE_3 LAYOUT_SHAPE_3
, LNR_SZ_3 LNR_SZ_3
, SQR_SZ_3 SQR_SZ_3
, CUBIC_SZ_3 CUBIC_SZ_3
, LOC_CORDNT_X_3 LOC_CORDNT_X_3
, LOC_CORDNT_Y_3 LOC_CORDNT_Y_3
, LOC_CORDNT_Z_3 LOC_CORDNT_Z_3
, INV_UOM_CD_3 INV_UOM_CD_3
, SLNG_LOC_TYP_CD_3 SLNG_LOC_TYP_CD_3
, NBR_OF_FCNGS_3 NBR_OF_FCNGS_3
, SRC_SYS_IDNT SRC_SYS_IDNT
, SRC_SYS_DT SRC_SYS_DT
, ERR_REASON ERR_REASON
, ACTION_FLAG ACTION_FLAG
, LOAD_ID LOAD_ID
, BSNS_UNIT_TYP BSNS_UNIT_TYP
, DFLT_WHSE DFLT_WHSE
, TDLINX_STR_CD TDLINX_STR_CD
, STR_STATUS STR_STATUS
, SUB_CHNL_CD SUB_CHNL_CD
, CMPNY_SIZE CMPNY_SIZE
, LAT LAT
, LON LON
, STR_ACV_RANGE STR_ACV_RANGE
, FAMILY_CD FAMILY_CD
, OWNER_OPER_NAME OWNER_OPER_NAME
, MKTG_GRP_NAME MKTG_GRP_NAME
, NON_CORP_OWNED NON_CORP_OWNED
, GAS_SOLD_IND GAS_SOLD_IND
, HIGH_VOL_CGRETTES_IND HIGH_VOL_CGRETTES_IND
, PHARM_IN_STR_IND PHARM_IN_STR_IND
, LIQ_IN_STR_IND LIQ_IN_STR_IND
, WINE_IN_STR_IND WINE_IN_STR_IND
, BEER_IN_STR_IND BEER_IN_STR_IND
, SERVE_ALCOHOL_IND SERVE_ALCOHOL_IND
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
FROM "DDR"."DDR_E_ORG_BSNS_UNIT"