[Home] [Help] [Dependency Information]
Object Name: | AMS_DM_PARTY_DETAILS |
---|---|
Object Type: | TABLE |
Owner: | AMS |
FND Design Data: | AMS.AMS_DM_PARTY_DETAILS |
Subobject Name: | |
Status: | VALID |
AMS_DM_GEN_STG table is populated by the OMO Mining Collection pack. The table is truncated after each run. When populated the table contains generic details for parties in the AMS_DM_DRV_STG table.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AMS_DM_PARTY_DETAILS_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY | PARTY_ID |
AMS_DM_PARTY_DETAILS_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | PARTY_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PARTY_ID | NUMBER | Yes | Party identifier. | |
CREATED_BY | NUMBER | Standard WHO column. | ||
CREATION_DATE | DATE | Standard WHO column. | ||
LAST_UPDATED_BY | NUMBER | Standard WHO column. | ||
LAST_UPDATE_DATE | DATE | Standard WHO column. | ||
LAST_UPDATE_LOGIN | NUMBER | Standard WHO column. | ||
OBJECT_VERSION_NUMBER | NUMBER | This column is used for locking purposes. | ||
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
PARTY_TYPE | VARCHAR2 | (30) | Party type. | |
GENDER | VARCHAR2 | (30) | Gender. | |
ETHNICITY | VARCHAR2 | (60) | Ethnicity. | |
MARITAL_STATUS | VARCHAR2 | (30) | Marital status. | |
PERSONAL_INCOME | NUMBER | Personal income. | ||
HOH_FLAG | VARCHAR2 | (1) | Head of household indicator. | |
HOUSEHOLD_INCOME | NUMBER | Household income. | ||
HOUSEHOLD_SIZE | NUMBER | Household size. | ||
APARTMENT_FLAG | VARCHAR2 | (1) | Apartment indicator. | |
RENT_FLAG | VARCHAR2 | (1) | Rent indicator. | |
DEGREE_RECEIVED | VARCHAR2 | (1) | Degree received. | |
SCHOOL_TYPE | VARCHAR2 | (60) | School type. | |
INTEREST_ART_FLAG | VARCHAR2 | (1) | Interest in art indicator. | |
INTEREST_BOOKS_FLAG | VARCHAR2 | (1) | Interest in books indicator. | |
INTEREST_MOVIES_FLAG | VARCHAR2 | (1) | Interest in movies indicator. | |
INTEREST_MUSIC_FLAG | VARCHAR2 | (1) | Interest in music indicator. | |
INTEREST_THEATER_FLAG | VARCHAR2 | (1) | Interest in theater indicator. | |
INTEREST_TRAVEL_FLAG | VARCHAR2 | (1) | Interest in travel indicator. | |
INTEREST_DRINK_FLAG | VARCHAR2 | (1) | Interest in drinking indicator. | |
INTEREST_SMOKE_FLAG | VARCHAR2 | (1) | Interest in smoking indicator. | |
INTEREST_OTHER_FLAG | VARCHAR2 | (1) | Other interests indicator. | |
LEVEL_OF_INTEREST | VARCHAR2 | (30) | Level of interest. | |
INTEREST_TYPE_CODE | VARCHAR2 | (30) | Interest type code. | |
HOBBIES | VARCHAR2 | (240) | Hobbies. | |
EXPERIENCE_LEVEL | VARCHAR2 | (60) | Experience level. | |
WORK_CLASS_NAME | VARCHAR2 | (240) | Work class name. | |
EMPLOYED_FLAG | VARCHAR2 | (1) | Employed indicator. | |
YEARS_EMPLOYED | NUMBER | Number of years employed. | ||
OCCUPATION | VARCHAR2 | (60) | Occupation. | |
MILITARY_BRANCH | VARCHAR2 | (80) | Military branch served. | |
RESIDENCE_TYPE | VARCHAR2 | (30) | Residence type. | |
RESIDENT_LENGTH | NUMBER | Number of years stayed at current residence. | ||
SECOND_HOME_TYPE | VARCHAR2 | (30) | Second home type. | |
PRESENCE_OF_CHILDREN | NUMBER | Presence of children indicator. | ||
COUNTRY | VARCHAR2 | (60) | Country. | |
STATE | VARCHAR2 | (60) | State. | |
PROVINCE | VARCHAR2 | (60) | Province. | |
COUNTY | VARCHAR2 | (60) | County. | |
ZIP_CODE | VARCHAR2 | (60) | Zip code. | |
AVG_NUM_LIFE_CYCLE_SEGS | NUMBER | Average number of life cycle segments. | ||
CONTACT_TYPE | VARCHAR2 | (30) | Contact type. | |
CATEGORY_CODE | VARCHAR2 | (30) | Category code. | |
REFERENCE_USE_FLAG | VARCHAR2 | (1) | Use as a reference indicator. | |
SUBCATEGORY_CODE | VARCHAR2 | (30) | Subcategory code. | |
RETURN_TYPE | VARCHAR2 | (30) | Return type. | |
RETURN_REASON_CODE | VARCHAR2 | (30) | Reason for the return. | |
REFUND_PRICE | NUMBER | Refund price. | ||
REFUND_TYPE | VARCHAR2 | (30) | Refund type. | |
RETURNED_REASON | VARCHAR2 | (120) | Reason for the return. | |
GROSS_ANNUAL_INCOME | NUMBER | Gross annual income. | ||
DEBT_TO_INCOME_RATIO | NUMBER | Deb to income ratio. | ||
NUM_CREDIT_LINES | NUMBER | Number of credit lines. | ||
NUM_TRADE_LINES | NUMBER | Number of trade lines. | ||
NET_WORTH | NUMBER | Net worth. | ||
TOTAL_ASSETS | NUMBER | Total assets. | ||
TOT_DEBT_OUTSTANDING | NUMBER | Total debt outstanding. | ||
BANKRUPTCY_FLAG | VARCHAR2 | (1) | Bankruptcy indicator. | |
HIGH_RISK_FRAUD_FLAG | VARCHAR2 | (1) | High risk of fraud indicator. | |
GROSS_ANNUAL_SALES | NUMBER | Gross annual sales. | ||
GROWTH_RATE_SALES_YEAR | NUMBER | Growth rate of sales for the past year. | ||
GROWTH_RATE_NET_PROF_YEAR | NUMBER | Growth rate of net profit for the past year. | ||
CURRENT_ASSETS | NUMBER | Current assets. | ||
CURRENT_LIABILITIES | NUMBER | Current liabilities. | ||
TOTAL_DEBTS | NUMBER | Total debts. | ||
NET_PROFIT | NUMBER | Net profit. | ||
TANGIBLE_NET_PROFIT | NUMBER | Tangible net profit. | ||
CAPITAL_AMOUNT | NUMBER | Capital amount. | ||
CAPITAL_TYPE_INDICATOR | VARCHAR2 | (30) | Capital type indicator. | |
ACCOUNTS_RECEIVABLE | NUMBER | Accounts receivable. | ||
RETAINED_EARNINGS | NUMBER | Retained earnings. | ||
PAYDEX_SCORE_YEAR | NUMBER | Paydex score for the past year. | ||
PAYDEX_SCORE_3_MONTH_AGO | NUMBER | Paydex score 3 months ago. | ||
INDUSTRY_PAYDEX_MEDIAN | NUMBER | Industry paydex score median. | ||
AVG_HIGH_CREDIT | NUMBER | Average high credit. | ||
HIGH_CREDIT | NUMBER | High credit. | ||
TOT_PAYMENT_EXP | NUMBER | Total payments. | ||
NUM_NEGATIVE_PAYMENT | NUMBER | Number of negative payments. | ||
AVG_PAYMENT_SIZE | NUMBER | Average payment size. | ||
NUM_SLOW_PAYMENTS | NUMBER | Number of slow payments. | ||
FAILURE_SCORE | NUMBER | Failure score. | ||
FAILURE_SCORE_OVER_CODE | VARCHAR2 | (30) | Not used. | |
FAILURE_SCORE_INDUSTRY_PCT | NUMBER | Not used. | ||
FAILURE_SCORE_6_MONTHS | NUMBER | Not used. | ||
GLOBAL_FAILURE_SCORE | VARCHAR2 | (5) | Global failure score. | |
DNB_SCORE | VARCHAR2 | (5) | Dunn and Bradstreet score. | |
BUSINESS_FAILURE | VARCHAR2 | (120) | Business failure indicator. | |
OUT_OF_BUSINESS_FLAG | VARCHAR2 | (1) | Out of business indicator. | |
CUSTOMER_QUALITY_RANK | NUMBER | Customer quality rank. | ||
FORTUNE_500_RANK | NUMBER | Fortune 500 rank. | ||
NUM_OF_EMPLOYEES | NUMBER | Number of employees. | ||
LEGAL_STATUS | VARCHAR2 | (30) | Legal status. | |
ENTITY_TYPE | VARCHAR2 | (30) | Entity type. | |
YEAR_ESTABLISHED | NUMBER | Year established. | ||
LINE_OF_BUSINESS | VARCHAR2 | (30) | Line of business. | |
SIC_CODE1 | VARCHAR2 | (30) | Industry SIC code. | |
SIC_CODE2 | VARCHAR2 | (30) | Industry SIC code. | |
MARKET_SEGMENT_NAME | VARCHAR2 | (120) | Market segment name. | |
MARKET_SEGMENT_ID | NUMBER | Market segment identifier. | ||
SITE_NAME | VARCHAR2 | (120) | Site name. | |
SITE_DUNS_NUMBER | NUMBER | Site DUNS number. | ||
NUM_EMPLOYEES_AT_SITE | NUMBER | Number of employees at site. | ||
MINORITY_BUSINESS_FLAG | VARCHAR2 | (1) | Minority business indicator. | |
SMALL_BUSINESS_FLAG | VARCHAR2 | (1) | Small business indicator. | |
WOMEN_OWNED_BUS_FLAG | VARCHAR2 | (1) | Women owned business indicator. | |
GOV_ORG_FLAG | VARCHAR2 | (1) | Government organization indicator. | |
HQ_SUBSIDIARY_FLAG | VARCHAR2 | (1) | HQ subsidiary indicator. | |
FOREIGN_OWNED_FLAG | VARCHAR2 | (1) | Foreign owned indicator. | |
IMPORT_EXPORT_BUS_FLAG | VARCHAR2 | (1) | Import-Export business indicator. | |
CREDIT_CHECK_FLAG | VARCHAR2 | (1) | Credit check indicator. | |
TOLERANCE | NUMBER | Tolerance. | ||
DISCOUNT_TERMS_FLAG | VARCHAR2 | (1) | Discount terms indicator. | |
DUNNING_LETTERS_FLAG | VARCHAR2 | (1) | Dunning letters indicator. | |
INTEREST_CHARGES_FLAG | VARCHAR2 | (1) | Interest charges indicator. | |
SEND_STATEMENTS_FLAG | VARCHAR2 | (1) | Send statement indicator. | |
CREDIT_HOLD_FLAG | VARCHAR2 | (1) | Credit hold indicator. | |
CREDIT_RATING | VARCHAR2 | (60) | Credit rating. | |
RISK_CODE | VARCHAR2 | (60) | Risk code. | |
INTEREST_PERIOD_DAYS | NUMBER | Number of days in interest period. | ||
PAYMENT_GRACE_DAYS | NUMBER | Number of payment grace days. | ||
BUSINESS_SCOPE | VARCHAR2 | (240) | The physical class of business in which a business participates. For example, local, national, or international. | |
EMAIL_ADDRESS | VARCHAR2 | (240) | E-mail address. | |
ADDRESS1 | VARCHAR2 | (240) | First line of address. | |
ADDRESS2 | VARCHAR2 | (240) | Second line of address. | |
COMPETITOR_FLAG | VARCHAR2 | (240) | Indicates if a party is a competitor. | |
THIRD_PARTY_FLAG | VARCHAR2 | (240) | Tracks if a party has a direct relationship with the organization using Oracle Receivables or through a third party vendor. | |
PERSON_FIRST_NAME | VARCHAR2 | (240) | First name of the person. | |
PERSON_MIDDLE_NAME | VARCHAR2 | (240) | Middle name of the person. | |
PERSON_LAST_NAME | VARCHAR2 | (240) | Last or surname of the person. | |
PERSON_NAME_SUFFIX | VARCHAR2 | (240) | Indicates the place in a family structure. For example, in Tom Jones III, the "III" is the suffix. | |
PERSON_TITLE | VARCHAR2 | (240) | A professional or family title. | |
PERSON_ACADEMIC_TITLE | VARCHAR2 | (240) | Academic title that is part of a person's name. | |
PERSON_PRE_NAME_ADJUNCT | VARCHAR2 | (240) | Salutary introduction. | |
CONTROL_YR | NUMBER | Year when current ownership gained control. | ||
CONG_DIST_CODE | VARCHAR2 | (240) | U.S. Congressional District. | |
LABOR_SURPLUS_FLAG | VARCHAR2 | (240) | Indicates if this company operates in an area with a labor surplu. | |
DEBARMENT_FLAG | VARCHAR2 | (240) | Indicates if this party is prohibited from entering into contracts or transactions with a government agency in the United States. | |
DISADV_8A_FLAG | VARCHAR2 | (240) | Indicates if this company is considered disadvantaged by the US governement under Title 8A. | |
DEBARMENTS_COUNT | NUMBER | Count of filings by government agencies in the United States that prohibit the party from entering into contracts or transactions with those agencies. | ||
MONTHS_SINCE_LAST_DEBARMENT | NUMBER | Months since the most recent filing to prohibit the party from entering into contracts or transactions with a government agency in the United States. | ||
GSA_INDICATOR_FLAG | VARCHAR2 | (240) | Indicates if this is a US federal agency supported by the General Services Administration (GSA). | |
ANALYSIS_FY | VARCHAR2 | (240) | Fiscal year used as the source for financial information. | |
FISCAL_YEAREND_MONTH | VARCHAR2 | (240) | Month in which fiscal year ends for organization. | |
CURR_FY_POTENTIAL_REVENUE | NUMBER | Organization's potential revenue for this fiscal year. | ||
NEXT_FY_POTENTIAL_REVENUE | NUMBER | Organization's potential revenue for next fiscal year. | ||
ORGANIZATION_TYPE | VARCHAR2 | (240) | User-defined organization types such as region, division, and department. | |
CORPORATION_CLASS | VARCHAR2 | (240) | Taxation classification for corporation entities. For example, Chapter S in the US. | |
REGISTRATION_TYPE | VARCHAR2 | (240) | Lookup for type of registration, such as nonprofit. | |
INCORP_YEAR | NUMBER | Year that the business was incorporated. | ||
PUBLIC_PRIVATE_OWNERSHIP_FLAG | VARCHAR2 | (240) | Indicates if the organization is privately owned. | |
INTERNAL_FLAG | VARCHAR2 | (240) | Indicates if this is an internal organization. | |
TOTAL_PAYMENTS | NUMBER | Total number of payment experiences. | ||
CREDIT_SCORE_CLASS | NUMBER | Measures the risk of severe delinquency by a customer account. The value ranges from 1 for the greatest risk and 5 for the least risk. | ||
CREDIT_SCORE_NATL_PERCENTILE | NUMBER | Indicates the relative credit rating of a business compared to all businesses whose credit ratings are included in the local country database. | ||
CREDIT_SCORE_INCD_DEFAULT | NUMBER | Indicates the probability, expressed as a percentage, of delinquency for a score range or class. | ||
CREDIT_SCORE_AGE | NUMBER | Indicates the age of the credit score, expressed in months. | ||
FAILURE_SCORE_CLASS | NUMBER | The failure score class value measures the risk of financial stress for a customer account. The value range is from 1 to 5. A value of 1 indicates a business that has the greatest risk, and a value of 5 indicates a business that has the least risk. | ||
FAILURE_SCORE_INCD_DEFAULT | NUMBER | The failure score incident value states the probability, expressed as a percentage, of failure for a score range or class. | ||
FAILURE_SCORE_AGE | NUMBER | The failure score age value states the age of the failure score, expressed in months. | ||
MAXIMUM_CREDIT_RECOMMENDATION | NUMBER | Maximum credit limit recommended for a specific currency. | ||
MAXIMUM_CREDIT_CURRENCY_CODE | VARCHAR2 | (240) | Currency used to state the MAXIMUM_CREDIT_RECOMMENDATION column. | |
PARTY_NAME | VARCHAR2 | (360) | Name of this party. | |
CITY | VARCHAR2 | (120) | The city of the party's registered location. |
Cut, paste (and edit) the following text to query this object:
SELECT PARTY_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, SECURITY_GROUP_ID
, PARTY_TYPE
, GENDER
, ETHNICITY
, MARITAL_STATUS
, PERSONAL_INCOME
, HOH_FLAG
, HOUSEHOLD_INCOME
, HOUSEHOLD_SIZE
, APARTMENT_FLAG
, RENT_FLAG
, DEGREE_RECEIVED
, SCHOOL_TYPE
, INTEREST_ART_FLAG
, INTEREST_BOOKS_FLAG
, INTEREST_MOVIES_FLAG
, INTEREST_MUSIC_FLAG
, INTEREST_THEATER_FLAG
, INTEREST_TRAVEL_FLAG
, INTEREST_DRINK_FLAG
, INTEREST_SMOKE_FLAG
, INTEREST_OTHER_FLAG
, LEVEL_OF_INTEREST
, INTEREST_TYPE_CODE
, HOBBIES
, EXPERIENCE_LEVEL
, WORK_CLASS_NAME
, EMPLOYED_FLAG
, YEARS_EMPLOYED
, OCCUPATION
, MILITARY_BRANCH
, RESIDENCE_TYPE
, RESIDENT_LENGTH
, SECOND_HOME_TYPE
, PRESENCE_OF_CHILDREN
, COUNTRY
, STATE
, PROVINCE
, COUNTY
, ZIP_CODE
, AVG_NUM_LIFE_CYCLE_SEGS
, CONTACT_TYPE
, CATEGORY_CODE
, REFERENCE_USE_FLAG
, SUBCATEGORY_CODE
, RETURN_TYPE
, RETURN_REASON_CODE
, REFUND_PRICE
, REFUND_TYPE
, RETURNED_REASON
, GROSS_ANNUAL_INCOME
, DEBT_TO_INCOME_RATIO
, NUM_CREDIT_LINES
, NUM_TRADE_LINES
, NET_WORTH
, TOTAL_ASSETS
, TOT_DEBT_OUTSTANDING
, BANKRUPTCY_FLAG
, HIGH_RISK_FRAUD_FLAG
, GROSS_ANNUAL_SALES
, GROWTH_RATE_SALES_YEAR
, GROWTH_RATE_NET_PROF_YEAR
, CURRENT_ASSETS
, CURRENT_LIABILITIES
, TOTAL_DEBTS
, NET_PROFIT
, TANGIBLE_NET_PROFIT
, CAPITAL_AMOUNT
, CAPITAL_TYPE_INDICATOR
, ACCOUNTS_RECEIVABLE
, RETAINED_EARNINGS
, PAYDEX_SCORE_YEAR
, PAYDEX_SCORE_3_MONTH_AGO
, INDUSTRY_PAYDEX_MEDIAN
, AVG_HIGH_CREDIT
, HIGH_CREDIT
, TOT_PAYMENT_EXP
, NUM_NEGATIVE_PAYMENT
, AVG_PAYMENT_SIZE
, NUM_SLOW_PAYMENTS
, FAILURE_SCORE
, FAILURE_SCORE_OVER_CODE
, FAILURE_SCORE_INDUSTRY_PCT
, FAILURE_SCORE_6_MONTHS
, GLOBAL_FAILURE_SCORE
, DNB_SCORE
, BUSINESS_FAILURE
, OUT_OF_BUSINESS_FLAG
, CUSTOMER_QUALITY_RANK
, FORTUNE_500_RANK
, NUM_OF_EMPLOYEES
, LEGAL_STATUS
, ENTITY_TYPE
, YEAR_ESTABLISHED
, LINE_OF_BUSINESS
, SIC_CODE1
, SIC_CODE2
, MARKET_SEGMENT_NAME
, MARKET_SEGMENT_ID
, SITE_NAME
, SITE_DUNS_NUMBER
, NUM_EMPLOYEES_AT_SITE
, MINORITY_BUSINESS_FLAG
, SMALL_BUSINESS_FLAG
, WOMEN_OWNED_BUS_FLAG
, GOV_ORG_FLAG
, HQ_SUBSIDIARY_FLAG
, FOREIGN_OWNED_FLAG
, IMPORT_EXPORT_BUS_FLAG
, CREDIT_CHECK_FLAG
, TOLERANCE
, DISCOUNT_TERMS_FLAG
, DUNNING_LETTERS_FLAG
, INTEREST_CHARGES_FLAG
, SEND_STATEMENTS_FLAG
, CREDIT_HOLD_FLAG
, CREDIT_RATING
, RISK_CODE
, INTEREST_PERIOD_DAYS
, PAYMENT_GRACE_DAYS
, BUSINESS_SCOPE
, EMAIL_ADDRESS
, ADDRESS1
, ADDRESS2
, COMPETITOR_FLAG
, THIRD_PARTY_FLAG
, PERSON_FIRST_NAME
, PERSON_MIDDLE_NAME
, PERSON_LAST_NAME
, PERSON_NAME_SUFFIX
, PERSON_TITLE
, PERSON_ACADEMIC_TITLE
, PERSON_PRE_NAME_ADJUNCT
, CONTROL_YR
, CONG_DIST_CODE
, LABOR_SURPLUS_FLAG
, DEBARMENT_FLAG
, DISADV_8A_FLAG
, DEBARMENTS_COUNT
, MONTHS_SINCE_LAST_DEBARMENT
, GSA_INDICATOR_FLAG
, ANALYSIS_FY
, FISCAL_YEAREND_MONTH
, CURR_FY_POTENTIAL_REVENUE
, NEXT_FY_POTENTIAL_REVENUE
, ORGANIZATION_TYPE
, CORPORATION_CLASS
, REGISTRATION_TYPE
, INCORP_YEAR
, PUBLIC_PRIVATE_OWNERSHIP_FLAG
, INTERNAL_FLAG
, TOTAL_PAYMENTS
, CREDIT_SCORE_CLASS
, CREDIT_SCORE_NATL_PERCENTILE
, CREDIT_SCORE_INCD_DEFAULT
, CREDIT_SCORE_AGE
, FAILURE_SCORE_CLASS
, FAILURE_SCORE_INCD_DEFAULT
, FAILURE_SCORE_AGE
, MAXIMUM_CREDIT_RECOMMENDATION
, MAXIMUM_CREDIT_CURRENCY_CODE
, PARTY_NAME
, CITY
FROM AMS.AMS_DM_PARTY_DETAILS;
AMS.AMS_DM_PARTY_DETAILS does not reference any database object
AMS.AMS_DM_PARTY_DETAILS is referenced by following:
|
|
|