[Home] [Help] [Dependency Information]
Object Name: | EDW_DUNS_M |
---|---|
Object Type: | TABLE |
Owner: | POA |
FND Design Data: | POA.EDW_DUNS_M |
Subobject Name: | |
Status: | VALID |
This is the denormalized star table for the DUNS dimension. It contains records for the lowest level of the DUNS dimension and their parentage up to the top level, across all hierarchies.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 30 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_DUNS_M_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY |
DNMR_DUNS_NUM_PK
DNMR_DUNS_NUM_PK_KEY |
EDW_DUNS_M_U2 | NORMAL | UNIQUE | APPS_TS_SUMMARY | DNMR_DUNS_NUM_PK_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DNMR_DUNS_NUM_PK_KEY | NUMBER | Yes | System generated unique identifier for DUNS Number | |
GLBL_GLOBAL_ULT_PK_KEY | NUMBER | System generated unique identifier for Global Ultimate DUNS Number | ||
DOME_DOMESTIC_ULT_PK_KEY | NUMBER | System generated unique identifier for Domestic Ultimate DUNS Number | ||
PRNT_PARENT_PK_KEY | NUMBER | System generated unique identifier for Parent DUNS Number | ||
HQTR_HQ_PK_KEY | NUMBER | System generated unique identifier for Headquarters DUNS Number | ||
ALL_ALL_PK_KEY | NUMBER | System generated unique identifier | ||
DNMR_DOMESTIC_ULT_POSTAL_CODE | VARCHAR2 | (40) | Domestic ultimate postal code | |
DNMR_DOMESTIC_ULT_NAME | VARCHAR2 | (160) | Domestic ultimate name | |
DNMR_DOMESTIC_ULT_DUNS | VARCHAR2 | (40) | Domestic ultimate DUNS number | |
DNMR_DOMESTIC_ULT_COUNTRY | VARCHAR2 | (40) | Domestic ultimate country of record | |
DNMR_DOMESTIC_ULT_CITY | VARCHAR2 | (60) | Domestic ultimate city of record | |
DNMR_DOMESTIC_ULT_ADDRESS | VARCHAR2 | (80) | Domestic ultimate address of record | |
DNMR_DNB_RATING | VARCHAR2 | (80) | Business rating assigned by D&B | |
DNMR_DISADVANTAGED_FLAG | VARCHAR2 | (80) | D&B identified business as disadvantaged (US) | |
DNMR_DELINQUENCY_SCORE | VARCHAR2 | (80) | D&B indicates risk of delinquent payments | |
DNMR_DEBARMENT_FLAG | VARCHAR2 | (80) | D&B indicates business debarred from doing business with the US government | |
DNMR_CURRENT_STATEMENT_TYPE | VARCHAR2 | (80) | Audited or unaudited | |
DNMR_TOTAL_ASSETS | VARCHAR2 | (40) | Total current and long term assets. | |
DNMR_TELEPHONE | VARCHAR2 | (40) | Telephone number of record | |
DNMR_SUITS_COUNT | VARCHAR2 | (40) | Number of law suits | |
DNMR_STATE_PROV | VARCHAR2 | (60) | State or Provence of record | |
DNMR_SMALL_BUSINESS_FLAG | VARCHAR2 | (80) | D&B identified business as a small business (US) | |
DNMR_SLOW_PAYMENTS | VARCHAR2 | (40) | Slow payments | |
DNMR_SIC_CODE2 | VARCHAR2 | (40) | Secondary standard industry classification | |
DNMR_SIC_CODE1 | VARCHAR2 | (40) | Primary standard industry classification | |
DNMR_SIC1_DESCRIPTION | VARCHAR2 | (40) | Primary standard industry classification description | |
DNMR_SALES | VARCHAR2 | (40) | Total sales for the business site | |
DNMR_CURRENT_LIABILITIES | VARCHAR2 | (40) | Current liabilities for the business site | |
DNMR_CURRENT_ASSETS | VARCHAR2 | (40) | Current assets for the business site | |
DNMR_CRIMINAL_PROCEEDINGS_IND | VARCHAR2 | (80) | D&B indicates criminal proceedings exist | |
DNMR_COUNTRY | VARCHAR2 | (80) | Country of record for the business site | |
DNMR_CONTROL_YEAR | VARCHAR2 | (40) | Year current control was assumed | |
DNMR_CONG_DIST_CODE3 | VARCHAR2 | (80) | Congressional District Code 3 (US) | |
DNMR_CONG_DIST_CODE2 | VARCHAR2 | (80) | Congressional District Code 2 (US) | |
DNMR_CONG_DIST_CODE1 | VARCHAR2 | (80) | Congressional District Code 1 (US) | |
DNMR_COMPANY_NAME | VARCHAR2 | (120) | Company name of record | |
DNMR_CITY | VARCHAR2 | (60) | City of record | |
DNMR_CEO_TITLE | VARCHAR2 | (40) | Title of the Chief Executive Officer | |
DNMR_PREV_TOTAL_ASSETS | VARCHAR2 | (40) | Total current and long term assets of the previous period | |
DNMR_PREV_STATEMENT_TYPE | VARCHAR2 | (80) | Audited or unaudited during the previous period | |
DNMR_PREV_SALES | VARCHAR2 | (40) | Total sales for the business site in the previous period | |
DNMR_PREV_NET_WORTH | VARCHAR2 | (40) | Total net worth in the previous period | |
DNMR_PREV_CURRENT_LIABILITIES | VARCHAR2 | (40) | Current liabilities for the business site in the previous period | |
DNMR_PREV_CURRENT_ASSETS | VARCHAR2 | (40) | Current assets for the business site in the previous period | |
DNMR_PAYDEX_PRIOR_Q3 | VARCHAR2 | (80) | Paydex score 3 quarters ago | |
DNMR_PAYDEX_PRIOR_Q2 | VARCHAR2 | (80) | Paydex score 2 quarters ago | |
DNMR_PAYDEX_PRIOR_Q1 | VARCHAR2 | (80) | Paydex score prior quarter | |
DNMR_PAYDEX_NORM | VARCHAR2 | (80) | Normal paydex score for similar businesses | |
DNMR_CEO_NAME | VARCHAR2 | (60) | Name of the Chief Executive Officer | |
DNMR_CASH | VARCHAR2 | (40) | Cash on hand and liquid assets | |
DNMR_BUSINESS_MOVED_IND | VARCHAR2 | (80) | D&B indicates that business moved | |
DNMR_BANKRUPTCY_IND | VARCHAR2 | (80) | D&B indicates that business has filed for bankruptcy | |
DNMR_AVERAGE_HIGH_CREDIT | VARCHAR2 | (40) | Maximum credit of any payment period | |
DNMR_ADDRESS | VARCHAR2 | (80) | Address of record | |
DNMR_ACCOUNTS_RECEIVABLES | VARCHAR2 | (40) | Accounts receivable; amount of sales made and billed to customers on credit terms | |
DNMR_PAYDEX_CURRENT | VARCHAR2 | (80) | Current paydex score | |
DNMR_PARENT_TELEPHONE | VARCHAR2 | (40) | Telephone number of record for the Parent | |
DNMR_PARENT_STATE_PROV | VARCHAR2 | (60) | State or Provence on record for the Parent | |
DNMR_PARENT_POSTAL_CODE | VARCHAR2 | (40) | Postal code on record for the Parent | |
DNMR_PARENT_NAME | VARCHAR2 | (160) | Name on record for the Parent | |
DNMR_PARENT_DUNS | VARCHAR2 | (40) | DUNS number of the Parent | |
DNMR_PARENT_COUNTRY | VARCHAR2 | (40) | Country of record for the Parent | |
DNMR_PARENT_CITY | VARCHAR2 | (60) | City of record for the Parent | |
DNMR_PARENT_ADDRESS | VARCHAR2 | (80) | Address of record for the Parent | |
DNMR_OWNS_RENTS_IND | VARCHAR2 | (80) | Indicates if the business site rents or owns the site | |
DNMR_OOB_IND | VARCHAR2 | (80) | D&B indicates site is out-of -business. | |
DNMR_NET_WORTH | VARCHAR2 | (40) | Net worth | |
DNMR_NET_PROFIT | VARCHAR2 | (40) | Net profit | |
GLBL_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User defined attribute | |
GLBL_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User defined attribute | |
GLBL_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User defined attribute | |
GLBL_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User defined attribute | |
GLBL_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User defined attribute | |
GLBL_TELEPHONE | VARCHAR2 | (40) | Telephone number of record for the Global Ultimate | |
GLBL_STATE_PROV | VARCHAR2 | (60) | State or Provence of record for the Global Ultimate | |
GLBL_POSTAL_CODE | VARCHAR2 | (40) | Postal code on record for the Global Ultimate | |
GLBL_NAME | VARCHAR2 | (160) | Name of record for the Global Ultimate | |
GLBL_INSTANCE | VARCHAR2 | (40) | Source database instance | |
GLBL_GLOBAL_ULT_PK | VARCHAR2 | (40) | Unique identifier for the Global Ultimate | |
GLBL_GLOBAL_ULT_DP | VARCHAR2 | (160) | Unique Global Ultimate name | |
GLBL_DUNS_NUMBER | VARCHAR2 | (40) | DUNS number of the Global Ultimate | |
GLBL_COUNTRY | VARCHAR2 | (40) | Country of record for the Global Ultimate | |
GLBL_CITY | VARCHAR2 | (60) | City of record for the Global Ultimate | |
GLBL_ADDRESS | VARCHAR2 | (80) | Address of record for the Global Ultimate | |
DOME_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User defined attribute | |
DOME_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User defined attribute | |
DOME_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User defined attribute | |
DOME_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User defined attribute | |
DOME_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User defined attribute | |
DOME_TELEPHONE | VARCHAR2 | (40) | Telephone of record for the Domestic Ultimate | |
DOME_STATE_PROV | VARCHAR2 | (60) | State or provence of record for the Domestic Ultimate | |
DOME_POSTAL_CODE | VARCHAR2 | (40) | Postal code on record for the Domestic Ultimate | |
DOME_NAME | VARCHAR2 | (160) | Name of record for the Domestic Ultimate | |
DOME_INSTANCE | VARCHAR2 | (40) | Source database instance | |
DOME_DUNS_NUMBER | VARCHAR2 | (40) | DUNS number of the Domestic Ultimate | |
DOME_DOMESTIC_ULT_PK | VARCHAR2 | (40) | Unique identifier for the Domestic Ultimate | |
DOME_DOMESTIC_ULT_DP | VARCHAR2 | (160) | Unique name for the Domestic Ultimate | |
DOME_COUNTRY | VARCHAR2 | (40) | Country of record for the Domestic Ultimate | |
DOME_CITY | VARCHAR2 | (60) | City of record for the Domestic Ultimate | |
DOME_ADDRESS | VARCHAR2 | (80) | Address of record for the Domestic Ultimate | |
PRNT_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User defined attribute | |
PRNT_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User defined attribute | |
PRNT_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User defined attribute | |
PRNT_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User defined attribute | |
PRNT_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User defined attribute | |
PRNT_TELEPHONE | VARCHAR2 | (40) | Telephone of record for the Parent | |
PRNT_STATE_PROV | VARCHAR2 | (60) | State or provence of record for the Parent | |
PRNT_POSTAL_CODE | VARCHAR2 | (40) | Postal code on record for the Parent | |
PRNT_PARENT_PK | VARCHAR2 | (40) | Unique identifier for the Parent | |
PRNT_PARENT_DP | VARCHAR2 | (160) | Unique name for the Parent | |
PRNT_NAME | VARCHAR2 | (160) | Name of record for the Parent | |
PRNT_INSTANCE | VARCHAR2 | (40) | Source database instance | |
PRNT_DUNS_NUMBER | VARCHAR2 | (40) | DUNS number of the Parent | |
PRNT_COUNTRY | VARCHAR2 | (40) | Country of record for the Parent | |
PRNT_CITY | VARCHAR2 | (60) | City of record for the Parent | |
PRNT_ADDRESS | VARCHAR2 | (80) | Address of record for the Parent | |
HQTR_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User defined attribute | |
HQTR_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User defined attribute | |
HQTR_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User defined attribute | |
HQTR_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User defined attribute | |
HQTR_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User defined attribute | |
HQTR_TELEPHONE | VARCHAR2 | (40) | Telephone of record for the Headquarters | |
HQTR_STATE_PROV | VARCHAR2 | (60) | State or provence of record for the Headquarters | |
HQTR_POSTAL_CODE | VARCHAR2 | (40) | Postal code on record for the Headquarters | |
HQTR_NAME | VARCHAR2 | (160) | Name of record for the Headquarters | |
DNMR_NEGATIVE_PAYMENTS | VARCHAR2 | (40) | Number of negative payment experiences | |
DNMR_NAME | VARCHAR2 | (160) | Name of record for the business site | |
DNMR_MINORITY_OWNED_TYPE | VARCHAR2 | (80) | D&B Minority Owned Business type | |
DNMR_MINORITY_OWNED_FLAG | VARCHAR2 | (80) | D&B indicator that business is minority owned | |
DNMR_LOCATION_STATUS | VARCHAR2 | (80) | D&B indicates if business is a headquarters, branch/division, or single location | |
DNMR_LIENS_COUNT | VARCHAR2 | (40) | Number of liens against the business site | |
DNMR_LEGAL_STATUS | VARCHAR2 | (80) | Legal status | |
DNMR_LABOR_SURPLUS_FLAG | VARCHAR2 | (80) | D&B indicates area of labor surplus as defined by US Department of Labor | |
DNMR_JUDGMENTS_COUNT | VARCHAR2 | (40) | Number of judgements with the business site | |
DNMR_ISO9000_REGISTRATION | VARCHAR2 | (40) | D&B indicates ISO 9000 registration | |
DNMR_INVENTORY | VARCHAR2 | (40) | Inventory value | |
DNMR_INSTANCE | VARCHAR2 | (40) | Source database instance | |
HQTR_INSTANCE | VARCHAR2 | (40) | Source database instance | |
HQTR_HQ_PK | VARCHAR2 | (40) | Unique Identifier Headquarters | |
HQTR_HQ_DP | VARCHAR2 | (160) | Unique Headquarter name | |
HQTR_DUNS_NUMBER | VARCHAR2 | (40) | Headquarters DUNS number | |
HQTR_COUNTRY | VARCHAR2 | (40) | Country of record for the Headquarters | |
HQTR_CITY | VARCHAR2 | (60) | CIty of record for the Headquarters | |
HQTR_ADDRESS | VARCHAR2 | (80) | Address of location for the Headquarters | |
ALL_NAME | VARCHAR2 | (80) | Unique All Level name | |
ALL_ALL_PK | VARCHAR2 | (40) | Unique Identifier | |
DNMR_IMPORT_FLAG | VARCHAR2 | (80) | D&B identifies business as an importer | |
DNMR_HQ_TELEPHONE | VARCHAR2 | (40) | Telephone of record for the Headquarters | |
DNMR_HQ_STATE_PROV | VARCHAR2 | (60) | State or provence of record for the Headquarters | |
DNMR_HQ_POSTAL_CODE | VARCHAR2 | (40) | Postal code on record for the Headquarters | |
DNMR_HQ_NAME | VARCHAR2 | (160) | Name of record for the Headquarters | |
DNMR_HQ_FLAG | VARCHAR2 | (80) | D&B flag identifying site as a Headquarter location | |
DNMR_HQ_DUNS | VARCHAR2 | (40) | Headquarters DUNS Number | |
DNMR_HQ_COUNTRY | VARCHAR2 | (40) | Country of record for the Headquarter | |
DNMR_HQ_CITY | VARCHAR2 | (60) | City of record for the Headquarter | |
DNMR_HQ_ADDRESS | VARCHAR2 | (80) | Address of record for the Headquarter | |
DNMR_HISTORY | VARCHAR2 | (80) | D&B code indicating that detrimental information exists for the company | |
DNMR_HIGH_RISK_IND | VARCHAR2 | (80) | High risk indicator | |
DNMR_ZIP_CODE | VARCHAR2 | (40) | ZIP or postal code of record | |
DNMR_WOMAN_OWNED_FLAG | VARCHAR2 | (80) | D&B indicates business as woman-owned (US) | |
DNMR_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User defined attribute | |
DNMR_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User defined attribute | |
DNMR_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User defined attribute | |
DNMR_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User defined attribute | |
DNMR_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User defined attribute | |
DNMR_TRADE_STYLE | VARCHAR2 | (160) | Trade style used by the business | |
DNMR_TOTAL_PAYMENTS | VARCHAR2 | (40) | Total number of payment experiences | |
DNMR_TOTAL_DEBT | VARCHAR2 | (40) | Total debt | |
DNMR_HIGH_CREDIT | VARCHAR2 | (40) | Maxmum credit of any payment experience | |
DNMR_GLOBAL_ULT_TELEPHONE | VARCHAR2 | (40) | Telephone number of record for the Global Ultimate | |
DNMR_GLOBAL_ULT_STATE_PROV | VARCHAR2 | (60) | State or Provence of record for the Global Ultimate | |
DNMR_GLOBAL_ULT_POSTAL_CODE | VARCHAR2 | (40) | Postal code of record for the Global Ultimate | |
DNMR_GLOBAL_ULT_NAME | VARCHAR2 | (160) | Name of record for the Global Ultimate | |
DNMR_GLOBAL_ULT_DUNS | VARCHAR2 | (40) | DUNS number for the Global Ultimate | |
DNMR_GLOBAL_ULT_COUNTRY | VARCHAR2 | (40) | Country of record for the Global Ultimate | |
DNMR_GLOBAL_ULT_CITY | VARCHAR2 | (60) | City of record for the Global Ultimate | |
DNMR_GLOBAL_ULT_ADDRESS | VARCHAR2 | (80) | Address of record for the GLobal Ultimate | |
DNMR_FIRE_DISASTER_IND | VARCHAR2 | (80) | D&B indicates catestrophic event occurred | |
DNMR_FEDERAL_TAX_ID | VARCHAR2 | (40) | Federal tax identifier | |
DNMR_FAILURE_SCORE | VARCHAR2 | (80) | D&B indicates risk of failure on a scale of 1-5 for US companies and 1-10 for Canadian companies. | |
DNMR_FAILURE_NATL_PCNT_RANK | VARCHAR2 | (80) | Relative ranking of a company among scorable companies in the local country database | |
DNMR_FAILURE_NATL_INCE_DFT | VARCHAR2 | (80) | Number of national incidence of default | |
DNMR_FAILURE_INDU_PCNT_RANK | VARCHAR2 | (80) | Relative ranking of a company among scorable companies in the industry database | |
DNMR_FAILURE_INDU_INCE_DFT | VARCHAR2 | (80) | Number of national incidence of default | |
DNMR_FAILURE_IND | VARCHAR2 | (80) | D&B indicates company has defaulted | |
DNMR_EXPORT_FLAG | VARCHAR2 | (80) | D&B indicates business exports | |
DNMR_EMPLOYEES_TOTAL | VARCHAR2 | (40) | Total number of employees | |
DNMR_DUNS_NUM_PK | VARCHAR2 | (40) | Unique identifier for the DUNS number | |
DNMR_DUNS_NUM_DP | VARCHAR2 | (160) | Unique Name for the DUNS number | |
DNMR_DUNS_NUMBER | VARCHAR2 | (40) | DUNS Number of record | |
DNMR_DOMESTIC_ULT_TELEPHONE | VARCHAR2 | (40) | Telephone number of record for the Domestic Ultimate | |
DNMR_DOMESTIC_ULT_STATE_PROV | VARCHAR2 | (60) | State or Provence of record for the Domestic Ultimate | |
DNMR_DNB_LAST_UPDATE_DATE | DATE | Last date the record was updated from D&B | ||
DNMR_SDB_EXIT_DATE | DATE | Date at which point the business no longer classified as a small or disadvantaged business | ||
DNMR_SDB_ENTRANCE_DATE | DATE | Date at which point the business is classified as a small or disadvantaged business | ||
DNMR_CURRENT_STATEMENT_DATE | DATE | Date of the income, profit and loss statement | ||
DNMR_REPORT_BASE_DATE | DATE | D&B Date basis for the report | ||
DNMR_PREV_STATEMENT_DATE | DATE | Date of the income, profit and loss statement for the previous period | ||
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT DNMR_DUNS_NUM_PK_KEY
, GLBL_GLOBAL_ULT_PK_KEY
, DOME_DOMESTIC_ULT_PK_KEY
, PRNT_PARENT_PK_KEY
, HQTR_HQ_PK_KEY
, ALL_ALL_PK_KEY
, DNMR_DOMESTIC_ULT_POSTAL_CODE
, DNMR_DOMESTIC_ULT_NAME
, DNMR_DOMESTIC_ULT_DUNS
, DNMR_DOMESTIC_ULT_COUNTRY
, DNMR_DOMESTIC_ULT_CITY
, DNMR_DOMESTIC_ULT_ADDRESS
, DNMR_DNB_RATING
, DNMR_DISADVANTAGED_FLAG
, DNMR_DELINQUENCY_SCORE
, DNMR_DEBARMENT_FLAG
, DNMR_CURRENT_STATEMENT_TYPE
, DNMR_TOTAL_ASSETS
, DNMR_TELEPHONE
, DNMR_SUITS_COUNT
, DNMR_STATE_PROV
, DNMR_SMALL_BUSINESS_FLAG
, DNMR_SLOW_PAYMENTS
, DNMR_SIC_CODE2
, DNMR_SIC_CODE1
, DNMR_SIC1_DESCRIPTION
, DNMR_SALES
, DNMR_CURRENT_LIABILITIES
, DNMR_CURRENT_ASSETS
, DNMR_CRIMINAL_PROCEEDINGS_IND
, DNMR_COUNTRY
, DNMR_CONTROL_YEAR
, DNMR_CONG_DIST_CODE3
, DNMR_CONG_DIST_CODE2
, DNMR_CONG_DIST_CODE1
, DNMR_COMPANY_NAME
, DNMR_CITY
, DNMR_CEO_TITLE
, DNMR_PREV_TOTAL_ASSETS
, DNMR_PREV_STATEMENT_TYPE
, DNMR_PREV_SALES
, DNMR_PREV_NET_WORTH
, DNMR_PREV_CURRENT_LIABILITIES
, DNMR_PREV_CURRENT_ASSETS
, DNMR_PAYDEX_PRIOR_Q3
, DNMR_PAYDEX_PRIOR_Q2
, DNMR_PAYDEX_PRIOR_Q1
, DNMR_PAYDEX_NORM
, DNMR_CEO_NAME
, DNMR_CASH
, DNMR_BUSINESS_MOVED_IND
, DNMR_BANKRUPTCY_IND
, DNMR_AVERAGE_HIGH_CREDIT
, DNMR_ADDRESS
, DNMR_ACCOUNTS_RECEIVABLES
, DNMR_PAYDEX_CURRENT
, DNMR_PARENT_TELEPHONE
, DNMR_PARENT_STATE_PROV
, DNMR_PARENT_POSTAL_CODE
, DNMR_PARENT_NAME
, DNMR_PARENT_DUNS
, DNMR_PARENT_COUNTRY
, DNMR_PARENT_CITY
, DNMR_PARENT_ADDRESS
, DNMR_OWNS_RENTS_IND
, DNMR_OOB_IND
, DNMR_NET_WORTH
, DNMR_NET_PROFIT
, GLBL_USER_ATTRIBUTE5
, GLBL_USER_ATTRIBUTE4
, GLBL_USER_ATTRIBUTE3
, GLBL_USER_ATTRIBUTE2
, GLBL_USER_ATTRIBUTE1
, GLBL_TELEPHONE
, GLBL_STATE_PROV
, GLBL_POSTAL_CODE
, GLBL_NAME
, GLBL_INSTANCE
, GLBL_GLOBAL_ULT_PK
, GLBL_GLOBAL_ULT_DP
, GLBL_DUNS_NUMBER
, GLBL_COUNTRY
, GLBL_CITY
, GLBL_ADDRESS
, DOME_USER_ATTRIBUTE5
, DOME_USER_ATTRIBUTE4
, DOME_USER_ATTRIBUTE3
, DOME_USER_ATTRIBUTE2
, DOME_USER_ATTRIBUTE1
, DOME_TELEPHONE
, DOME_STATE_PROV
, DOME_POSTAL_CODE
, DOME_NAME
, DOME_INSTANCE
, DOME_DUNS_NUMBER
, DOME_DOMESTIC_ULT_PK
, DOME_DOMESTIC_ULT_DP
, DOME_COUNTRY
, DOME_CITY
, DOME_ADDRESS
, PRNT_USER_ATTRIBUTE5
, PRNT_USER_ATTRIBUTE4
, PRNT_USER_ATTRIBUTE3
, PRNT_USER_ATTRIBUTE2
, PRNT_USER_ATTRIBUTE1
, PRNT_TELEPHONE
, PRNT_STATE_PROV
, PRNT_POSTAL_CODE
, PRNT_PARENT_PK
, PRNT_PARENT_DP
, PRNT_NAME
, PRNT_INSTANCE
, PRNT_DUNS_NUMBER
, PRNT_COUNTRY
, PRNT_CITY
, PRNT_ADDRESS
, HQTR_USER_ATTRIBUTE5
, HQTR_USER_ATTRIBUTE4
, HQTR_USER_ATTRIBUTE3
, HQTR_USER_ATTRIBUTE2
, HQTR_USER_ATTRIBUTE1
, HQTR_TELEPHONE
, HQTR_STATE_PROV
, HQTR_POSTAL_CODE
, HQTR_NAME
, DNMR_NEGATIVE_PAYMENTS
, DNMR_NAME
, DNMR_MINORITY_OWNED_TYPE
, DNMR_MINORITY_OWNED_FLAG
, DNMR_LOCATION_STATUS
, DNMR_LIENS_COUNT
, DNMR_LEGAL_STATUS
, DNMR_LABOR_SURPLUS_FLAG
, DNMR_JUDGMENTS_COUNT
, DNMR_ISO9000_REGISTRATION
, DNMR_INVENTORY
, DNMR_INSTANCE
, HQTR_INSTANCE
, HQTR_HQ_PK
, HQTR_HQ_DP
, HQTR_DUNS_NUMBER
, HQTR_COUNTRY
, HQTR_CITY
, HQTR_ADDRESS
, ALL_NAME
, ALL_ALL_PK
, DNMR_IMPORT_FLAG
, DNMR_HQ_TELEPHONE
, DNMR_HQ_STATE_PROV
, DNMR_HQ_POSTAL_CODE
, DNMR_HQ_NAME
, DNMR_HQ_FLAG
, DNMR_HQ_DUNS
, DNMR_HQ_COUNTRY
, DNMR_HQ_CITY
, DNMR_HQ_ADDRESS
, DNMR_HISTORY
, DNMR_HIGH_RISK_IND
, DNMR_ZIP_CODE
, DNMR_WOMAN_OWNED_FLAG
, DNMR_USER_ATTRIBUTE5
, DNMR_USER_ATTRIBUTE4
, DNMR_USER_ATTRIBUTE3
, DNMR_USER_ATTRIBUTE2
, DNMR_USER_ATTRIBUTE1
, DNMR_TRADE_STYLE
, DNMR_TOTAL_PAYMENTS
, DNMR_TOTAL_DEBT
, DNMR_HIGH_CREDIT
, DNMR_GLOBAL_ULT_TELEPHONE
, DNMR_GLOBAL_ULT_STATE_PROV
, DNMR_GLOBAL_ULT_POSTAL_CODE
, DNMR_GLOBAL_ULT_NAME
, DNMR_GLOBAL_ULT_DUNS
, DNMR_GLOBAL_ULT_COUNTRY
, DNMR_GLOBAL_ULT_CITY
, DNMR_GLOBAL_ULT_ADDRESS
, DNMR_FIRE_DISASTER_IND
, DNMR_FEDERAL_TAX_ID
, DNMR_FAILURE_SCORE
, DNMR_FAILURE_NATL_PCNT_RANK
, DNMR_FAILURE_NATL_INCE_DFT
, DNMR_FAILURE_INDU_PCNT_RANK
, DNMR_FAILURE_INDU_INCE_DFT
, DNMR_FAILURE_IND
, DNMR_EXPORT_FLAG
, DNMR_EMPLOYEES_TOTAL
, DNMR_DUNS_NUM_PK
, DNMR_DUNS_NUM_DP
, DNMR_DUNS_NUMBER
, DNMR_DOMESTIC_ULT_TELEPHONE
, DNMR_DOMESTIC_ULT_STATE_PROV
, DNMR_DNB_LAST_UPDATE_DATE
, DNMR_SDB_EXIT_DATE
, DNMR_SDB_ENTRANCE_DATE
, DNMR_CURRENT_STATEMENT_DATE
, DNMR_REPORT_BASE_DATE
, DNMR_PREV_STATEMENT_DATE
, CREATION_DATE
, LAST_UPDATE_DATE
FROM POA.EDW_DUNS_M;
POA.EDW_DUNS_M does not reference any database object
POA.EDW_DUNS_M is referenced by following:
|
|
|