[Home] [Help] [Dependency Information]
Object Name: | AMS_DM_PARTY_DETAILS# |
---|---|
Object Type: | VIEW |
Owner: | AMS |
Subobject Name: | |
Status: | VALID |
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 | |||
LEGAL_STATUS | VARCHAR2 | (30) | ||
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) |
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#;
|
|
|