Skip to content

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

VIEW: AMS.AMS_DM_PARTY_DETAILS#

Object Details
Object Name: AMS_DM_PARTY_DETAILS#
Object Type: VIEW
Owner: AMS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
PARTY_ID NUMBER
Yes
CREATED_BY NUMBER

CREATION_DATE DATE

LAST_UPDATED_BY NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATE_LOGIN NUMBER

OBJECT_VERSION_NUMBER NUMBER

SECURITY_GROUP_ID NUMBER

PARTY_TYPE VARCHAR2 (30)
GENDER VARCHAR2 (30)
ETHNICITY VARCHAR2 (60)
MARITAL_STATUS VARCHAR2 (30)
PERSONAL_INCOME NUMBER

HOH_FLAG VARCHAR2 (1)
HOUSEHOLD_INCOME NUMBER

HOUSEHOLD_SIZE NUMBER

APARTMENT_FLAG VARCHAR2 (1)
RENT_FLAG VARCHAR2 (1)
DEGREE_RECEIVED VARCHAR2 (1)
SCHOOL_TYPE VARCHAR2 (60)
INTEREST_ART_FLAG VARCHAR2 (1)
INTEREST_BOOKS_FLAG VARCHAR2 (1)
INTEREST_MOVIES_FLAG VARCHAR2 (1)
INTEREST_MUSIC_FLAG VARCHAR2 (1)
INTEREST_THEATER_FLAG VARCHAR2 (1)
INTEREST_TRAVEL_FLAG VARCHAR2 (1)
INTEREST_DRINK_FLAG VARCHAR2 (1)
INTEREST_SMOKE_FLAG VARCHAR2 (1)
INTEREST_OTHER_FLAG VARCHAR2 (1)
LEVEL_OF_INTEREST VARCHAR2 (30)
INTEREST_TYPE_CODE VARCHAR2 (30)
HOBBIES VARCHAR2 (240)
EXPERIENCE_LEVEL VARCHAR2 (60)
WORK_CLASS_NAME VARCHAR2 (240)
EMPLOYED_FLAG VARCHAR2 (1)
YEARS_EMPLOYED NUMBER

OCCUPATION VARCHAR2 (60)
MILITARY_BRANCH VARCHAR2 (80)
RESIDENCE_TYPE VARCHAR2 (30)
RESIDENT_LENGTH NUMBER

SECOND_HOME_TYPE VARCHAR2 (30)
PRESENCE_OF_CHILDREN NUMBER

COUNTRY VARCHAR2 (60)
STATE VARCHAR2 (60)
PROVINCE VARCHAR2 (60)
COUNTY VARCHAR2 (60)
ZIP_CODE VARCHAR2 (60)
AVG_NUM_LIFE_CYCLE_SEGS NUMBER

CONTACT_TYPE VARCHAR2 (30)
CATEGORY_CODE VARCHAR2 (30)
REFERENCE_USE_FLAG VARCHAR2 (1)
SUBCATEGORY_CODE VARCHAR2 (30)
RETURN_TYPE VARCHAR2 (30)
RETURN_REASON_CODE VARCHAR2 (30)
REFUND_PRICE NUMBER

REFUND_TYPE VARCHAR2 (30)
RETURNED_REASON VARCHAR2 (120)
GROSS_ANNUAL_INCOME NUMBER

DEBT_TO_INCOME_RATIO NUMBER

NUM_CREDIT_LINES NUMBER

NUM_TRADE_LINES NUMBER

NET_WORTH NUMBER

TOTAL_ASSETS NUMBER

TOT_DEBT_OUTSTANDING NUMBER

BANKRUPTCY_FLAG VARCHAR2 (1)
HIGH_RISK_FRAUD_FLAG VARCHAR2 (1)
GROSS_ANNUAL_SALES NUMBER

GROWTH_RATE_SALES_YEAR NUMBER

GROWTH_RATE_NET_PROF_YEAR NUMBER

CURRENT_ASSETS NUMBER

CURRENT_LIABILITIES NUMBER

TOTAL_DEBTS NUMBER

NET_PROFIT NUMBER

TANGIBLE_NET_PROFIT NUMBER

CAPITAL_AMOUNT NUMBER

CAPITAL_TYPE_INDICATOR VARCHAR2 (30)
ACCOUNTS_RECEIVABLE NUMBER

RETAINED_EARNINGS NUMBER

PAYDEX_SCORE_YEAR NUMBER

PAYDEX_SCORE_3_MONTH_AGO NUMBER

INDUSTRY_PAYDEX_MEDIAN NUMBER

AVG_HIGH_CREDIT NUMBER

HIGH_CREDIT NUMBER

TOT_PAYMENT_EXP NUMBER

NUM_NEGATIVE_PAYMENT NUMBER

AVG_PAYMENT_SIZE NUMBER

NUM_SLOW_PAYMENTS NUMBER

FAILURE_SCORE NUMBER

FAILURE_SCORE_OVER_CODE VARCHAR2 (30)
FAILURE_SCORE_INDUSTRY_PCT NUMBER

FAILURE_SCORE_6_MONTHS NUMBER

GLOBAL_FAILURE_SCORE VARCHAR2 (5)
DNB_SCORE VARCHAR2 (5)
BUSINESS_FAILURE VARCHAR2 (120)
OUT_OF_BUSINESS_FLAG VARCHAR2 (1)
CUSTOMER_QUALITY_RANK NUMBER

FORTUNE_500_RANK NUMBER

NUM_OF_EMPLOYEES NUMBER

ENTITY_TYPE VARCHAR2 (30)
YEAR_ESTABLISHED NUMBER

LINE_OF_BUSINESS VARCHAR2 (30)
SIC_CODE1 VARCHAR2 (30)
SIC_CODE2 VARCHAR2 (30)
MARKET_SEGMENT_NAME VARCHAR2 (120)
MARKET_SEGMENT_ID NUMBER

SITE_NAME VARCHAR2 (120)
SITE_DUNS_NUMBER NUMBER

NUM_EMPLOYEES_AT_SITE NUMBER

MINORITY_BUSINESS_FLAG VARCHAR2 (1)
SMALL_BUSINESS_FLAG VARCHAR2 (1)
WOMEN_OWNED_BUS_FLAG VARCHAR2 (1)
GOV_ORG_FLAG VARCHAR2 (1)
HQ_SUBSIDIARY_FLAG VARCHAR2 (1)
FOREIGN_OWNED_FLAG VARCHAR2 (1)
IMPORT_EXPORT_BUS_FLAG VARCHAR2 (1)
CREDIT_CHECK_FLAG VARCHAR2 (1)
TOLERANCE NUMBER

DISCOUNT_TERMS_FLAG VARCHAR2 (1)
DUNNING_LETTERS_FLAG VARCHAR2 (1)
INTEREST_CHARGES_FLAG VARCHAR2 (1)
SEND_STATEMENTS_FLAG VARCHAR2 (1)
CREDIT_HOLD_FLAG VARCHAR2 (1)
CREDIT_RATING VARCHAR2 (60)
RISK_CODE VARCHAR2 (60)
INTEREST_PERIOD_DAYS NUMBER

PAYMENT_GRACE_DAYS NUMBER

BUSINESS_SCOPE VARCHAR2 (240)
EMAIL_ADDRESS VARCHAR2 (240)
ADDRESS1 VARCHAR2 (240)
ADDRESS2 VARCHAR2 (240)
COMPETITOR_FLAG VARCHAR2 (240)
THIRD_PARTY_FLAG VARCHAR2 (240)
PERSON_FIRST_NAME VARCHAR2 (240)
PERSON_MIDDLE_NAME VARCHAR2 (240)
PERSON_LAST_NAME VARCHAR2 (240)
PERSON_NAME_SUFFIX VARCHAR2 (240)
PERSON_TITLE VARCHAR2 (240)
PERSON_ACADEMIC_TITLE VARCHAR2 (240)
PERSON_PRE_NAME_ADJUNCT VARCHAR2 (240)
CONTROL_YR NUMBER

CONG_DIST_CODE VARCHAR2 (240)
LABOR_SURPLUS_FLAG VARCHAR2 (240)
DEBARMENT_FLAG VARCHAR2 (240)
DISADV_8A_FLAG VARCHAR2 (240)
DEBARMENTS_COUNT NUMBER

MONTHS_SINCE_LAST_DEBARMENT NUMBER

GSA_INDICATOR_FLAG VARCHAR2 (240)
ANALYSIS_FY VARCHAR2 (240)
FISCAL_YEAREND_MONTH VARCHAR2 (240)
CURR_FY_POTENTIAL_REVENUE NUMBER

NEXT_FY_POTENTIAL_REVENUE NUMBER

ORGANIZATION_TYPE VARCHAR2 (240)
CORPORATION_CLASS VARCHAR2 (240)
REGISTRATION_TYPE VARCHAR2 (240)
INCORP_YEAR NUMBER

PUBLIC_PRIVATE_OWNERSHIP_FLAG VARCHAR2 (240)
INTERNAL_FLAG VARCHAR2 (240)
TOTAL_PAYMENTS NUMBER

CREDIT_SCORE_CLASS NUMBER

CREDIT_SCORE_NATL_PERCENTILE NUMBER

CREDIT_SCORE_INCD_DEFAULT NUMBER

CREDIT_SCORE_AGE NUMBER

FAILURE_SCORE_CLASS NUMBER

FAILURE_SCORE_INCD_DEFAULT NUMBER

FAILURE_SCORE_AGE NUMBER

MAXIMUM_CREDIT_RECOMMENDATION NUMBER

MAXIMUM_CREDIT_CURRENCY_CODE VARCHAR2 (240)
PARTY_NAME VARCHAR2 (360)
CITY VARCHAR2 (120)
Query Text

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#;

Dependencies

[top of page]

AMS.AMS_DM_PARTY_DETAILS# references the following:

SchemaAMS
TableAMS_DM_PARTY_DETAILS
AMS.AMS_DM_PARTY_DETAILS# is referenced by following:

SchemaAPPS
SynonymAMS_DM_PARTY_DETAILS