[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | POA_TPRT_INTERFACE |
|---|---|
| Object Type: | TABLE |
| Owner: | POA |
| FND Design Data: |  POA.POA_TPRT_INTERFACE
|
| Subobject Name: | |
| Status: | VALID |
An interface table for uploading DUNS dimension data into the warehouse.
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 5 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| POA_TPRT_INTERFACE_U1 | NORMAL | UNIQUE |
APPS_TS_INTERFACE
|
 TRADING_PARTNER_PK
|
| POA_TPRT_INTERFACE_N1 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
DOMESTIC_ULT_DUNS
|
| POA_TPRT_INTERFACE_N2 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
PARENT_DUNS
|
| POA_TPRT_INTERFACE_N3 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
DUNS
|
| POA_TPRT_INTERFACE_N4 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
HQ_DUNS
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| DUNS | VARCHAR2 | (40) | DUNS Number of record | |
| COMPANY_NAME | VARCHAR2 | (120) | Company name | |
| ADDRESS | VARCHAR2 | (80) | Address | |
| CITY | VARCHAR2 | (60) | City of record | |
| STATE | VARCHAR2 | (60) | State or Provence of record | |
| ZIP | VARCHAR2 | (40) | Postal code | |
| TELEPHONE | VARCHAR2 | (40) | Telephone number of record | |
| COUNTRY | VARCHAR2 | (80) | Country of record for the business site | |
| CEO_NAME | VARCHAR2 | (60) | CEO Name | |
| CEO_TITLE | VARCHAR2 | (40) | CEO Title | |
| LEGAL_STATUS | VARCHAR2 | (80) | Legal status | |
| LOCATION_STATUS_IND | VARCHAR2 | (80) | D&B indicates if business is a headquarters, branch/division, or single location | |
| HQ_IND | VARCHAR2 | (80) | D&B flag identifying site as a Headquarter location | |
| EMPLOYEES_TOTAL | VARCHAR2 | (40) | Total number of employees | |
| CONTROL_YEAR | VARCHAR2 | (40) | Year current control was assumed | |
| SIC_CODE_1 | VARCHAR2 | (40) | Primary standard industry classification | |
| SIC_CODE_2 | VARCHAR2 | (40) | Secondary standard industry classification | |
| SIC_1_DESCRIPTION | VARCHAR2 | (80) | Primary standard industry classification description | |
| OOB_IND | VARCHAR2 | (80) | D&B indicates site is out-of -business. | |
| CONG_DIST_CODE_1 | VARCHAR2 | (80) | Congressional District Code 1 (US) | |
| CONG_DIST_CODE_2 | VARCHAR2 | (80) | Congressional District Code 2 (US) | |
| CONG_DIST_CODE_3 | VARCHAR2 | (80) | Congressional District Code 3 (US) | |
| IMPORT_IND | VARCHAR2 | (80) | D&B identifies business as an importer | |
| EXPORT_IND | VARCHAR2 | (80) | D&B indicates business exports | |
| FAILURE_IND | VARCHAR2 | (80) | D&B indicates company has defaulted | |
| BANKRUPTCY_IND | VARCHAR2 | (80) | D&B indicates that business has filed for bankruptcy | |
| HIGH_RISK_INDCATOR | VARCHAR2 | (80) | High risk indicator | |
| SUITS_COUNT | VARCHAR2 | (40) | Number of law suits | |
| LIENS_COUNT | VARCHAR2 | (40) | Number of liens against the business site | |
| JUDGMENTS_COUNT | VARCHAR2 | (40) | Number of judgements with the business site | |
| HQ_DUNS | VARCHAR2 | (40) | Headquarters DUNS Number | |
| HQ_NAME | VARCHAR2 | (160) | Name of record for the Headquarters | |
| HQ_ADDRESS | VARCHAR2 | (80) | Address of record for the Headquarter | |
| HQ_CITY | VARCHAR2 | (60) | City of record for the Headquarter | |
| HQ_STATE | VARCHAR2 | (60) | State or provence of record for the Headquarters | |
| HQ_POSTAL_CODE | VARCHAR2 | (40) | Postal code on record for the Headquarters | |
| HQ_COUNTRY | VARCHAR2 | (40) | Country of record for the Headquarter | |
| HQ_TELEPHONE | VARCHAR2 | (40) | Telephone of record for the Headquarters | |
| PARENT_DUNS | VARCHAR2 | (40) | DUNS number of the Parent | |
| PARENT_NAME | VARCHAR2 | (160) | Name on record for the Parent | |
| PARENT_ADDRESS | VARCHAR2 | (80) | Address of record for the Parent | |
| PARENT_CITY | VARCHAR2 | (60) | City of record for the Parent | |
| PARENT_STATE | VARCHAR2 | (60) | State or Provence on record for the Parent | |
| PARENT_POSTAL_CODE | VARCHAR2 | (40) | Postal code on record for the Parent | |
| PARENT_COUNTRY | VARCHAR2 | (40) | Country of record for the Parent | |
| PARENT_TELEPHONE | VARCHAR2 | (40) | Telephone number of record for the Parent | |
| GLOBAL_ULT_DUNS | VARCHAR2 | (40) | DUNS number for the Global Ultimate | |
| GLOBAL_ULT_NAME | VARCHAR2 | (160) | Name of record for the Global Ultimate | |
| GLOBAL_ULT_ADDRESS | VARCHAR2 | (80) | Address of record for the GLobal Ultimate | |
| GLOBAL_ULT_CITY | VARCHAR2 | (60) | City of record for the Global Ultimate | |
| GLOBAL_ULT_STATE | VARCHAR2 | (60) | State or Provence of record for the Global Ultimate | |
| GLOBAL_ULT_POSTAL_CODE | VARCHAR2 | (40) | Postal code of record for the Global Ultimate | |
| GLOBAL_ULT_COUNTRY | VARCHAR2 | (40) | Country of record for the Global Ultimate | |
| GLOBAL_ULT_TELEPHONE | VARCHAR2 | (40) | Telephone number of record for the Global Ultimate | |
| DOMESTIC_ULT_DUNS | VARCHAR2 | (40) | Domestic ultimate DUNS number | |
| DOMESTIC_ULT_NAME | VARCHAR2 | (160) | Domestic ultimate name | |
| DOMESTIC_ULT_ADDRESS | VARCHAR2 | (80) | Domestic ultimate address of record | |
| DOMESTIC_ULT_CITY | VARCHAR2 | (60) | Domestic ultimate city of record | |
| DOMESTIC_ULT_STATE | VARCHAR2 | (60) | State or Provence of record for the Domestic Ultimate | |
| DOMESTIC_ULT_POSTAL_CODE | VARCHAR2 | (40) | Domestic ultimate postal code | |
| DOMESTIC_ULT_COUNTRY | VARCHAR2 | (40) | Domestic ultimate country of record | |
| DOMESTIC_ULT_TELEPHONE | VARCHAR2 | (40) | Telephone number of record for the Domestic Ultimate | |
| DNB_RATING | VARCHAR2 | (80) | Business rating assigned by D&B | |
| CREDIT_SCORE | VARCHAR2 | (80) | D&B credit score | |
| FSS_SER_SCORE | VARCHAR2 | (80) | D&B indicates risk of failure on a scale of 1-5 for US companies and 1-10 for Canadian companies. | |
| FSS_NATIONAL_RANK | VARCHAR2 | (80) | Relative ranking of a company among scorable companies in the local country database | |
| FSS_INDSTRY_RANK | VARCHAR2 | (80) | Relative ranking of a company among scorable companies in the industry database | |
| FSS_NATL_INC_OF_DEFAULT | VARCHAR2 | (80) | Number of national incidence of default | |
| FSS_IND_INC_OF_DEFAULT | VARCHAR2 | (80) | Number of national incidence of default | |
| PAYDEX_CURRENT | VARCHAR2 | (80) | Current paydex score | |
| LABOR_SURPLUS_IND | VARCHAR2 | (80) | D&B indicates area of labor surplus as defined by US Department of Labor | |
| DEBARMENT_IND | VARCHAR2 | (80) | D&B indicates business debarred from doing business with the US government | |
| MINORITY_OWNED_IND | VARCHAR2 | (80) | D&B indicator that business is minority owne | |
| MINORITY_OWNED_TYPE | VARCHAR2 | (80) | D&B Minority Owned Business type | |
| WOMAN_OWNED_IND | VARCHAR2 | (80) | D&B indicates business as woman-owned (US) | |
| DISADVANTAGED_IND | VARCHAR2 | (80) | D&B identified business as disadvantaged (US) | |
| SMALL_BUSINESS_IND | VARCHAR2 | (80) | D&B identified business as a small business (US) | |
| SDB_ENTRANCE_DATE | VARCHAR2 | (40) | Date at which point the business is classified as a small or disadvantaged business | |
| SDB_EXIT_DATE | VARCHAR2 | (40) | Date at which point the business no longer classified as a small or disadvantaged business | |
| ISO9000_REGISTRATION | VARCHAR2 | (40) | D&B indicates ISO 9000 registration | |
| FEDERAL_TAX_ID | VARCHAR2 | (40) | Federal tax identifier | |
| CURRENT_STATEMENT_DATE | VARCHAR2 | (40) | Date of the income, profit and loss statement | |
| CURRENT_STATEMENT_TYPE | VARCHAR2 | (40) | Audited or unaudited | |
| SALES | VARCHAR2 | (40) | Total sales for the business site | |
| CASH | VARCHAR2 | (40) | Cash on hand and liquid assets | |
| ACCOUNTS_REC | VARCHAR2 | (40) | Accounts receivable; amount of sales made and billed to customers on credit terms | |
| INVENTORY | VARCHAR2 | (40) | Inventory value | |
| CURRENT_ASSETS | VARCHAR2 | (40) | Current assets for the business site | |
| TOTAL_ASSETS | VARCHAR2 | (40) | Total current and long term assets. | |
| CURRENT_LIABILITIES | VARCHAR2 | (40) | Current liabilities for the business site | |
| TOTAL_DEBT | VARCHAR2 | (40) | Total debt | |
| NET_WORTH | VARCHAR2 | (40) | Net worth | |
| REPORT_BASE_DATE | VARCHAR2 | (40) | D&B Date basis for the report | |
| LAST_UPDATE_DATE | VARCHAR2 | (40) | Standard Who Column | |
| HIGH_CREDIT | VARCHAR2 | (40) | Maxmum credit of any payment experience | |
| AVERAGE_HIGH_CREDIT | VARCHAR2 | (40) | Maximum credit of any payment period | |
| BUSINESS_MOVED_IND | VARCHAR2 | (80) | D&B indicates that business moved | |
| CRIMINAL_PROCEEDINGS_IND | VARCHAR2 | (80) | D&B indicates criminal proceedings exist | |
| FIRE_DISASTER_IND | VARCHAR2 | (80) | D&B indicates catestrophic event occurred | |
| OWNS_RENTS_IND | VARCHAR2 | (80) | Indicates if the business site rents or owns the site | |
| HISTORY | VARCHAR2 | (80) | D&B code indicating that detrimental information exists for the company | |
| NEGATIVE_PAYMENTS | VARCHAR2 | (40) | Number of negative payment experiences | |
| PAYDEX_NORM | VARCHAR2 | (80) | Normal paydex score for similar businesses | |
| PAYDEX_PRIOR_Q1 | VARCHAR2 | (80) | Paydex score prior quarter | |
| PAYDEX_PRIOR_Q2 | VARCHAR2 | (80) | Paydex score 2 quarters ago | |
| PAYDEX_PRIOR_Q3 | VARCHAR2 | (80) | Paydex score 3 quarters ago | |
| SLOW_PAYMENTS | VARCHAR2 | (40) | Slow payments | |
| TOTAL_PAYMENTS | VARCHAR2 | (40) | Total number of payment experiences | |
| NET_PROFIT | VARCHAR2 | (40) | Net profit | |
| PREVIOUS_CURRENT_ASSETS | VARCHAR2 | (40) | Current assets for the business site in the previous period | |
| PREV_CURRENT_LIABILITIES | VARCHAR2 | (40) | Current liabilities for the business site in the previous period | |
| PREV_NET_WORTH | VARCHAR2 | (40) | Total net worth in the previous period | |
| PREV_SALES | VARCHAR2 | (40) | Total sales for the business site in the previous period | |
| PREV_STATEMENT_DATE | VARCHAR2 | (40) | Date of the income, profit and loss statement for the previous period | |
| PREV_STATEMENT_TYPE | VARCHAR2 | (80) | Audited or unaudited during the previous period | |
| PREV_TOTAL_ASSETS | VARCHAR2 | (40) | Total current and long term assets of the previous period | |
| TRADE_STYLE | VARCHAR2 | (160) | Trade style used by the business | |
| TRADING_PARTNER_PK | VARCHAR2 | (320) | Unique identifier Trading Partner | |
| TRADING_PARTNER_NAME | VARCHAR2 | (120) | Trading Partner Name | |
| ADDRESS_ID | VARCHAR2 | (40) | Address ID | |
| VENDOR_SITE_ID | VARCHAR2 | (120) | Vendor Site | |
| VENDOR_ORG_ID | VARCHAR2 | (120) | Vendor Organaiztion | |
| UPDATE_FACT_FLAG | VARCHAR2 | (10) | Flag to indicate update status of the fact table | |
| FAILURE_VALUE | VARCHAR2 | (120) | Failure value | |
| HIGH_RISK_VALUE | VARCHAR2 | (120) | High risk value | |
| MINORITY_OWNED_VALUE | VARCHAR2 | (120) | Minority owned value | |
| CURRENT_STATEMENT_VALUE | VARCHAR2 | (120) | Current statement value | |
| LEGAL_STATUS_VALUE | VARCHAR2 | (120) | Legal status value | |
| FIRE_DISASTER_VALUE | VARCHAR2 | (120) | Fire disaster value | |
| OWNS_RENTS_VALUE | VARCHAR2 | (120) | Owns or rents value | |
| HISTORY_VALUE | VARCHAR2 | (120) | History value | |
| LOCATION_STATUS_VALUE | VARCHAR2 | (120) | Location status value | |
| OOB_VALUE | VARCHAR2 | (120) | Out of business value | |
| CRIMINAL_PROCEEDINGS_VALUE | VARCHAR2 | (120) | Criminal proceedings value | |
| BANKRUPTCY_VALUE | VARCHAR2 | (120) | Bankruptcy Value | |
| BUSINESS_MOVED_VALUE | VARCHAR2 | (120) | Business Moved Value | |
| DNB_LAST_UPDATE_DATE | VARCHAR2 | (40) | Last date the record was updated from D&B | |
| CREATION_DATE | DATE | Standard Who Column | ||
| REQUEST_ID | NUMBER | Identifier used by collection program | ||
| OPERATION_CODE | VARCHAR2 | (30) | Code used by the collection program to determine whether to insert/update/delete this record | |
| ERROR_CODE | VARCHAR2 | (2000) | Code used to store error messages | |
| COLLECTION_STATUS | VARCHAR2 | (30) | Collection status code for the record. | |
| CUSTOMER_ACCOUNT | VARCHAR2 | (40) | Customer Account | |
| CUSTOMER_BUSINESS_NAME | VARCHAR2 | (120) | Customer Business Name | |
| CUSTOMER_ADDRESS_LINE_1 | VARCHAR2 | (120) | Customer Address Line 1 | |
| CUSTOMER_ADDRESS_LINE_2 | VARCHAR2 | (120) | Customer Address Line 2 | |
| CUSTOMER_ADDRESS_LINE_3 | VARCHAR2 | (120) | Customer Address Line 3 | |
| CUSTOMER_ADDRESS_LINE_4 | VARCHAR2 | (120) | Customer Address Line 4 | |
| CUSTOMER_CITY | VARCHAR2 | (80) | Customer City | |
| CUSTOMER_STATE | VARCHAR2 | (80) | Customer State | |
| CUSTOMER_ZIP | VARCHAR2 | (40) | Customer Zip | |
| CUSTOMER_COUNTRY | VARCHAR2 | (40) | Customer Country | |
| CUSTOMER_TELEPHONE_NUMBER | VARCHAR2 | (40) | Customer Telephone Number | |
| REGISTRATION_TYPE | VARCHAR2 | (40) | Registration Type | |
| FINANCIAL_EMBARASSMENT_IND | VARCHAR2 | (40) | Financial Embarassment Indicator | |
| DEBARMENT_COUNT | VARCHAR2 | (40) | Count of debarment | |
| DEBARMENT_DATE | VARCHAR2 | (40) | Date of Debarment | |
| MAXIMUM_CREDIT_RECOMMENDATION | VARCHAR2 | (40) | Maximum credit recommendation | |
| MAXIMUM_CREDIT_REC_CURRENCY | VARCHAR2 | (40) | Maximum credit rec currency |
Cut, paste (and edit) the following text to query this object:
SELECT DUNS
, COMPANY_NAME
, ADDRESS
, CITY
, STATE
, ZIP
, TELEPHONE
, COUNTRY
, CEO_NAME
, CEO_TITLE
, LEGAL_STATUS
, LOCATION_STATUS_IND
, HQ_IND
, EMPLOYEES_TOTAL
, CONTROL_YEAR
, SIC_CODE_1
, SIC_CODE_2
, SIC_1_DESCRIPTION
, OOB_IND
, CONG_DIST_CODE_1
, CONG_DIST_CODE_2
, CONG_DIST_CODE_3
, IMPORT_IND
, EXPORT_IND
, FAILURE_IND
, BANKRUPTCY_IND
, HIGH_RISK_INDCATOR
, SUITS_COUNT
, LIENS_COUNT
, JUDGMENTS_COUNT
, HQ_DUNS
, HQ_NAME
, HQ_ADDRESS
, HQ_CITY
, HQ_STATE
, HQ_POSTAL_CODE
, HQ_COUNTRY
, HQ_TELEPHONE
, PARENT_DUNS
, PARENT_NAME
, PARENT_ADDRESS
, PARENT_CITY
, PARENT_STATE
, PARENT_POSTAL_CODE
, PARENT_COUNTRY
, PARENT_TELEPHONE
, GLOBAL_ULT_DUNS
, GLOBAL_ULT_NAME
, GLOBAL_ULT_ADDRESS
, GLOBAL_ULT_CITY
, GLOBAL_ULT_STATE
, GLOBAL_ULT_POSTAL_CODE
, GLOBAL_ULT_COUNTRY
, GLOBAL_ULT_TELEPHONE
, DOMESTIC_ULT_DUNS
, DOMESTIC_ULT_NAME
, DOMESTIC_ULT_ADDRESS
, DOMESTIC_ULT_CITY
, DOMESTIC_ULT_STATE
, DOMESTIC_ULT_POSTAL_CODE
, DOMESTIC_ULT_COUNTRY
, DOMESTIC_ULT_TELEPHONE
, DNB_RATING
, CREDIT_SCORE
, FSS_SER_SCORE
, FSS_NATIONAL_RANK
, FSS_INDSTRY_RANK
, FSS_NATL_INC_OF_DEFAULT
, FSS_IND_INC_OF_DEFAULT
, PAYDEX_CURRENT
, LABOR_SURPLUS_IND
, DEBARMENT_IND
, MINORITY_OWNED_IND
, MINORITY_OWNED_TYPE
, WOMAN_OWNED_IND
, DISADVANTAGED_IND
, SMALL_BUSINESS_IND
, SDB_ENTRANCE_DATE
, SDB_EXIT_DATE
, ISO9000_REGISTRATION
, FEDERAL_TAX_ID
, CURRENT_STATEMENT_DATE
, CURRENT_STATEMENT_TYPE
, SALES
, CASH
, ACCOUNTS_REC
, INVENTORY
, CURRENT_ASSETS
, TOTAL_ASSETS
, CURRENT_LIABILITIES
, TOTAL_DEBT
, NET_WORTH
, REPORT_BASE_DATE
, LAST_UPDATE_DATE
, HIGH_CREDIT
, AVERAGE_HIGH_CREDIT
, BUSINESS_MOVED_IND
, CRIMINAL_PROCEEDINGS_IND
, FIRE_DISASTER_IND
, OWNS_RENTS_IND
, HISTORY
, NEGATIVE_PAYMENTS
, PAYDEX_NORM
, PAYDEX_PRIOR_Q1
, PAYDEX_PRIOR_Q2
, PAYDEX_PRIOR_Q3
, SLOW_PAYMENTS
, TOTAL_PAYMENTS
, NET_PROFIT
, PREVIOUS_CURRENT_ASSETS
, PREV_CURRENT_LIABILITIES
, PREV_NET_WORTH
, PREV_SALES
, PREV_STATEMENT_DATE
, PREV_STATEMENT_TYPE
, PREV_TOTAL_ASSETS
, TRADE_STYLE
, TRADING_PARTNER_PK
, TRADING_PARTNER_NAME
, ADDRESS_ID
, VENDOR_SITE_ID
, VENDOR_ORG_ID
, UPDATE_FACT_FLAG
, FAILURE_VALUE
, HIGH_RISK_VALUE
, MINORITY_OWNED_VALUE
, CURRENT_STATEMENT_VALUE
, LEGAL_STATUS_VALUE
, FIRE_DISASTER_VALUE
, OWNS_RENTS_VALUE
, HISTORY_VALUE
, LOCATION_STATUS_VALUE
, OOB_VALUE
, CRIMINAL_PROCEEDINGS_VALUE
, BANKRUPTCY_VALUE
, BUSINESS_MOVED_VALUE
, DNB_LAST_UPDATE_DATE
, CREATION_DATE
, REQUEST_ID
, OPERATION_CODE
, ERROR_CODE
, COLLECTION_STATUS
, CUSTOMER_ACCOUNT
, CUSTOMER_BUSINESS_NAME
, CUSTOMER_ADDRESS_LINE_1
, CUSTOMER_ADDRESS_LINE_2
, CUSTOMER_ADDRESS_LINE_3
, CUSTOMER_ADDRESS_LINE_4
, CUSTOMER_CITY
, CUSTOMER_STATE
, CUSTOMER_ZIP
, CUSTOMER_COUNTRY
, CUSTOMER_TELEPHONE_NUMBER
, REGISTRATION_TYPE
, FINANCIAL_EMBARASSMENT_IND
, DEBARMENT_COUNT
, DEBARMENT_DATE
, MAXIMUM_CREDIT_RECOMMENDATION
, MAXIMUM_CREDIT_REC_CURRENCY
FROM POA.POA_TPRT_INTERFACE;
POA.POA_TPRT_INTERFACE does not reference any database object
POA.POA_TPRT_INTERFACE is referenced by following:
APPS
POA_TPRT_INTERFACE
|
|
|
|