DBA Data[Home] [Help] [Dependency Information]

TABLE: DDR.DDR_I_ORG_BSNS_UNIT

Object Details
Object Name: DDR_I_ORG_BSNS_UNIT
Object Type: TABLE
Owner: DDR
Subobject Name:
Status: VALID


Interface table to populate data in DDR_R_ORG_BSNS_UNIT


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
DDR_I_ORG_BSNS_UNIT_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnREC_ID
Columns
Name Datatype Length Mandatory Comments
REC_ID NUMBER
Yes Record ID, uniquely identify each records.
ORG_CD VARCHAR2 (30)
Organization Code
BSNS_UNIT_CD VARCHAR2 (30)
Business Unit Code
GLBL_LOC_ID VARCHAR2 (30)
Universally Unique Global Location ID for a particular level of organization.
GLBL_LOC_ID_TYP VARCHAR2 (30)
An indicator of the identification scheme used to assign the global Location ID.
BSNS_UNIT_NAME VARCHAR2 (40)
Business Unit Name
SUB_RGN_CD VARCHAR2 (30)
Sub Region Code
RGN_CD VARCHAR2 (30)
Region Code
ADDR_TYP_CD VARCHAR2 (30)
Address Type Code
CHNL_TYP_CD VARCHAR2 (30)
Channel Type Code
TIME_ZN VARCHAR2 (30)
Time Zone
LONG_DESC VARCHAR2 (240)
Long Description
SCNDRY_DESC VARCHAR2 (240)
Secondary Description
ADDR_LINE VARCHAR2 (240)
Address
ADDR_USG VARCHAR2 (240)
Address Usage
CITY VARCHAR2 (40)
City
STATE VARCHAR2 (30)
State
CNTRY VARCHAR2 (30)
Country
POST_CD VARCHAR2 (30)
Zip Code
GEO_CD VARCHAR2 (30)
Geographic Code
ADDR_PHONE VARCHAR2 (240)
Address Phone
EMAIL_ADDR VARCHAR2 (240)
Email Address
CNSTRCTN_STATUS VARCHAR2 (30)
Construction Status
EXTRNL_NAME VARCHAR2 (40)
Extrernal Name
CNTCT_NBR VARCHAR2 (30)
Contract Number
CNTCT_TYP VARCHAR2 (30)
Contract Type
LOC_TYP_CD VARCHAR2 (30)
Location Type Code
PRMRY_TRD_AREA_CD VARCHAR2 (30)
Primary Trade Area Code
PRMRY_MKT_AREA_CD VARCHAR2 (30)
Primary Market Area Code
SHPNG_CNTR_TYP VARCHAR2 (30)
Shipping Center Type
BSNS_UNIT_CNCPT VARCHAR2 (240)
Business Unit Concept
TOT_LNR_DSTNC NUMBER

The total linear selling space of the location.
VAT_RGN VARCHAR2 (30)
The number of the Value Added Tax region
VAT_INCLD_IND VARCHAR2 (1)
Indicates whether or not Value Added Tax will be included in the retail prices for the store.
PRMRY_CRNCY_CD VARCHAR2 (30)
Primary Curreny Code
PRMRY_CLNDR_CD VARCHAR2 (30)
Primary Calendar Code
STORE_MGR VARCHAR2 (40)
Name of the store manager.
STORE_TYP VARCHAR2 (30)
Possible values can include, Specialty, Grocery, Super Market, Convinience etc.
STORE_OPEN_DT DATE

Date the store opened for business
STORE_CLOSE_DT DATE

Date the store closed for business
FRMT_CD VARCHAR2 (30)
Format Code
USABLE_AREA VARCHAR2 (40)
The size of the part of the built area that is available for use (in size units)
FRMT_DESC VARCHAR2 (240)
Format Description
DSGN_CNCPT VARCHAR2 (240)
Design Concept
USG_TYP_CD VARCHAR2 (30)
Usage Type Code
INV_AREA VARCHAR2 (40)
Total Area (in size units) available for inventory
SLNG_AREA VARCHAR2 (40)
Total Floor Area (in size units) available for selling. Showroom size.
SZ_UNIT VARCHAR2 (30)
Unit of measure used for area or size values
NBR_OF_LOAD_DCKS NUMBER

Number of Loading Docks
NBR_OF_UNLD_DCKS NUMBER

Number of Unloading Docks
NEW_STORE_IND VARCHAR2 (1)
The flag that indicates , Is this a new store.
REMDL_DT DATE

The date on which the store was last remodeled.
STORE_PRICE_INDX NUMBER

Price Index used in the store
NBR_OF_LVLS NUMBER

Number of Levels
NBR_OF_WNDW_DISP NUMBER

The total number of window displays available
AREA_OF_WNDW_DISP NUMBER

The total area reserved for window displays
FTNG_RMS_AVLBL VARCHAR2 (40)
Identifies if fitting rooms are available at the site
NBR_OF_EXTRNL_SIGN NUMBER

The total number of external signs for a given site that are owned and displayed by the retailer
RSTRMS_AVLBL_IND VARCHAR2 (1)
Identifies if restrooms are available
PRKNG_AVLBL_IND VARCHAR2 (1)
Identifies if restrooms are available
TYP_OF_PRKNG VARCHAR2 (30)
Type Of Parking, e.g Free, Metered, Paid
DSTNC_TO_NEARST_CROSS_STREET VARCHAR2 (40)
Distance from the cross street to the site
NAME_OF_NEARST_CROSS_STREET VARCHAR2 (40)
The cross street nearest to the site
STCKHLD_IND VARCHAR2 (1)
Indicates whether the location can hold stock
TRNSFR_ZN_CD VARCHAR2 (30)
The code that indicates the transfer zone for which this location is a member.
TRNSFR_ZN_DESC VARCHAR2 (240)
The description or name of the transfer zone code of this location.
PRMTN_ZN VARCHAR2 (240)
To signify the pricing promotion policy for a specific geographic zone.
TOT_BLT_UP_AREA NUMBER

The part of the total area on which constructed structures exits (including the walls and the carpet area)
TOT_SPR_BLT_UP_AREA NUMBER

Total area as inclusive of carpet and built-up area and all the area under common spaces like the lobby, staircase, elevators, escalators, security room, etc.
TERRAIN VARCHAR2 (240)
Terrain, Possible values can be, Mountain, Inland, Rolling Hills, Plains, Coastal, Island, Desert.
STATE_FIPS_CD VARCHAR2 (30)
Federal Information Processing Standards (FIPS) codes issued by the National Institute of Standards and Technology (NIST) that identify each area
CNTY_FIPS_CD VARCHAR2 (30)
Federal Information Processing Standards (FIPS) codes issued by the National Institute of Standards and Technology (NIST) that identify each area
STORE_VOL VARCHAR2 (40)
Store Volume
WEEKLY_VOL VARCHAR2 (40)
Weekly Volume
FULL_TIME_EMP_EQVLNTS NUMBER

Full Time Employee Equivalents
NBR_OF_CHECKOUTS NUMBER

Number fo Checkouts
WRHS_SPCLTY VARCHAR2 (240)
Specialty of the Warehouse
BRK_PAC_IND VARCHAR2 (1)
Indicates whether or not the warehouse is capable of distributing less than the supplier
HDR_CD VARCHAR2 (30)
Header code
BNR_CD VARCHAR2 (30)
The unique identifier of a banner.
HDR_NAME VARCHAR2 (40)
Header name of catalogue
NBR_OF_PGS NUMBER

Header name of catalogue
PUBLSH_DT DATE

The date of publish
VALID_TILL_DT DATE

To which date the Organization catalogue is valid
WEB_SITE_URL VARCHAR2 (240)
Web site URL of the Organization
WEB_SITE_VRSN NUMBER

Web site version of the Organization
REF_URL VARCHAR2 (240)
Reference website URL of the Organization
REF_NAME VARCHAR2 (40)
Name of the website from where the visitor has been redirected
DEMOG_ATTR_CD_1 VARCHAR2 (30)
Demography attribute code
DEMOG_GRP_CD_1 VARCHAR2 (30)
Demography group code
DEMOG_ATTR_VAL_1 VARCHAR2 (40)
Demography value
DEMOG_UOM_CD_1 VARCHAR2 (30)
Demography UOM code
DEMOG_ATTR_CD_2 VARCHAR2 (30)
Demography attribute code
DEMOG_GRP_CD_2 VARCHAR2 (30)
Demography group code
DEMOG_ATTR_VAL_2 VARCHAR2 (40)
Demography value
DEMOG_UOM_CD_2 VARCHAR2 (30)
Demography UOM code
DEMOG_ATTR_CD_3 VARCHAR2 (30)
Demography attribute code
DEMOG_GRP_CD_3 VARCHAR2 (30)
Demography group code
DEMOG_ATTR_VAL_3 VARCHAR2 (40)
Demography value
DEMOG_UOM_CD_3 VARCHAR2 (30)
Demography UOM code
INV_LOC_CD_1 VARCHAR2 (30)
Inventory Location Code
INV_LOC_TYP_CD_1 VARCHAR2 (30)
Inventory Location Type Code
INV_LOC_DESC_1 VARCHAR2 (240)
Inventory Location Description
LAYOUT_SHAPE_1 VARCHAR2 (40)
Inventory Layout Shape
LNR_SZ_1 NUMBER

The Linear floor size area of the Location.
SQR_SZ_1 NUMBER

The Square floor size area of the Location.
CUBIC_SZ_1 NUMBER

The Cubic floor size area of the Location.
LOC_CORDNT_X_1 NUMBER

X coordinate of the Location
LOC_CORDNT_Y_1 NUMBER

Y coordinate of the Location
LOC_CORDNT_Z_1 NUMBER

Z coordinate of the Location
INV_UOM_CD_1 VARCHAR2 (30)
The code used to specify the units in which a value is being expressed
SLNG_LOC_TYP_CD_1 VARCHAR2 (30)
Different types of selling location. These values can be, Shelf, Floor, Rack and so on.
NBR_OF_FCNGS_1 NUMBER

Number of Facings of the location
INV_LOC_CD_2 VARCHAR2 (30)
Inventory Location Code
INV_LOC_TYP_CD_2 VARCHAR2 (30)
Inventory Location Type Code
INV_LOC_DESC_2 VARCHAR2 (240)
Inventory Location Description
LAYOUT_SHAPE_2 VARCHAR2 (40)
Inventory Layout Shape
LNR_SZ_2 NUMBER

The Linear floor size area of the Location.
SQR_SZ_2 NUMBER

The Square floor size area of the Location.
CUBIC_SZ_2 NUMBER

The Cubic floor size area of the Location.
LOC_CORDNT_X_2 NUMBER

X coordinate of the Location
LOC_CORDNT_Y_2 NUMBER

Y coordinate of the Location
LOC_CORDNT_Z_2 NUMBER

Z coordinate of the Location
INV_UOM_CD_2 VARCHAR2 (30)
The code used to specify the units in which a value is being expressed
SLNG_LOC_TYP_CD_2 VARCHAR2 (30)
Different types of selling location. These values can be, Shelf, Floor, Rack and so on.
NBR_OF_FCNGS_2 NUMBER

Number of Facings of the location
INV_LOC_CD_3 VARCHAR2 (30)
Inventory Location Code
INV_LOC_TYP_CD_3 VARCHAR2 (30)
Inventory Location Type Code
INV_LOC_DESC_3 VARCHAR2 (240)
Inventory Location Description
LAYOUT_SHAPE_3 VARCHAR2 (40)
Inventory Layout Shape
LNR_SZ_3 NUMBER

The Linear floor size area of the Location.
SQR_SZ_3 NUMBER

The Square floor size area of the Location.
CUBIC_SZ_3 NUMBER

The Cubic floor size area of the Location.
LOC_CORDNT_X_3 NUMBER

X coordinate of the Location
LOC_CORDNT_Y_3 NUMBER

Y coordinate of the Location
LOC_CORDNT_Z_3 NUMBER

Z coordinate of the Location
INV_UOM_CD_3 VARCHAR2 (30)
The code used to specify the units in which a value is being expressed
SLNG_LOC_TYP_CD_3 VARCHAR2 (30)
Different types of selling location. These values can be, Shelf, Floor, Rack and so on.
NBR_OF_FCNGS_3 NUMBER

Number of Facings of the location
SRC_SYS_IDNT VARCHAR2 (40) Yes Source file name or system that provided the data. It can be used to cross-reference the data with the source system, mainly for auditing purpose
SRC_SYS_DT DATE
Yes The date that the data was created. It can be used to cross-reference the data with the source system, mainly for auditing purpose
BSNS_UNIT_TYP VARCHAR2 (30)
A unique dentifier for an Retail Store, Distribution Center or Administration Center that performed the transaction
DFLT_WHSE VARCHAR2 (30)
Indicates the defaults warehouse of the perticular business unit
Query Text

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
,      BSNS_UNIT_TYP
,      DFLT_WHSE
FROM DDR.DDR_I_ORG_BSNS_UNIT;

Dependencies

[top of page]

DDR.DDR_I_ORG_BSNS_UNIT does not reference any database object

DDR.DDR_I_ORG_BSNS_UNIT is referenced by following:

SchemaAPPS
SynonymDDR_I_ORG_BSNS_UNIT