[Home] [Help]
select PARTY_ID PARTY_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, SECURITY_GROUP_ID SECURITY_GROUP_ID, PARTY_TYPE PARTY_TYPE, GENDER GENDER, ETHNICITY ETHNICITY, MARITAL_STATUS MARITAL_STATUS, PERSONAL_INCOME PERSONAL_INCOME, HOH_FLAG HOH_FLAG, HOUSEHOLD_INCOME HOUSEHOLD_INCOME, HOUSEHOLD_SIZE HOUSEHOLD_SIZE, APARTMENT_FLAG APARTMENT_FLAG, RENT_FLAG RENT_FLAG, DEGREE_RECEIVED DEGREE_RECEIVED, SCHOOL_TYPE SCHOOL_TYPE, INTEREST_ART_FLAG INTEREST_ART_FLAG, INTEREST_BOOKS_FLAG INTEREST_BOOKS_FLAG, INTEREST_MOVIES_FLAG INTEREST_MOVIES_FLAG, INTEREST_MUSIC_FLAG INTEREST_MUSIC_FLAG, INTEREST_THEATER_FLAG INTEREST_THEATER_FLAG, INTEREST_TRAVEL_FLAG INTEREST_TRAVEL_FLAG, INTEREST_DRINK_FLAG INTEREST_DRINK_FLAG, INTEREST_SMOKE_FLAG INTEREST_SMOKE_FLAG, INTEREST_OTHER_FLAG INTEREST_OTHER_FLAG, LEVEL_OF_INTEREST LEVEL_OF_INTEREST, INTEREST_TYPE_CODE INTEREST_TYPE_CODE, HOBBIES HOBBIES, EXPERIENCE_LEVEL EXPERIENCE_LEVEL, WORK_CLASS_NAME WORK_CLASS_NAME, EMPLOYED_FLAG EMPLOYED_FLAG, YEARS_EMPLOYED YEARS_EMPLOYED, OCCUPATION OCCUPATION, MILITARY_BRANCH MILITARY_BRANCH, RESIDENCE_TYPE RESIDENCE_TYPE, RESIDENT_LENGTH RESIDENT_LENGTH, SECOND_HOME_TYPE SECOND_HOME_TYPE, PRESENCE_OF_CHILDREN PRESENCE_OF_CHILDREN, COUNTRY COUNTRY, STATE STATE, PROVINCE PROVINCE, COUNTY COUNTY, ZIP_CODE ZIP_CODE, AVG_NUM_LIFE_CYCLE_SEGS AVG_NUM_LIFE_CYCLE_SEGS, CONTACT_TYPE CONTACT_TYPE, CATEGORY_CODE CATEGORY_CODE, REFERENCE_USE_FLAG REFERENCE_USE_FLAG, SUBCATEGORY_CODE SUBCATEGORY_CODE, RETURN_TYPE RETURN_TYPE, RETURN_REASON_CODE RETURN_REASON_CODE, REFUND_PRICE REFUND_PRICE, REFUND_TYPE REFUND_TYPE, RETURNED_REASON RETURNED_REASON, GROSS_ANNUAL_INCOME GROSS_ANNUAL_INCOME, DEBT_TO_INCOME_RATIO DEBT_TO_INCOME_RATIO, NUM_CREDIT_LINES NUM_CREDIT_LINES, NUM_TRADE_LINES NUM_TRADE_LINES, NET_WORTH NET_WORTH, TOTAL_ASSETS TOTAL_ASSETS, TOT_DEBT_OUTSTANDING TOT_DEBT_OUTSTANDING, BANKRUPTCY_FLAG BANKRUPTCY_FLAG, HIGH_RISK_FRAUD_FLAG HIGH_RISK_FRAUD_FLAG, GROSS_ANNUAL_SALES GROSS_ANNUAL_SALES, GROWTH_RATE_SALES_YEAR GROWTH_RATE_SALES_YEAR, GROWTH_RATE_NET_PROF_YEAR GROWTH_RATE_NET_PROF_YEAR, CURRENT_ASSETS CURRENT_ASSETS, CURRENT_LIABILITIES CURRENT_LIABILITIES, TOTAL_DEBTS TOTAL_DEBTS, NET_PROFIT NET_PROFIT, TANGIBLE_NET_PROFIT TANGIBLE_NET_PROFIT, CAPITAL_AMOUNT CAPITAL_AMOUNT, CAPITAL_TYPE_INDICATOR CAPITAL_TYPE_INDICATOR, ACCOUNTS_RECEIVABLE ACCOUNTS_RECEIVABLE, RETAINED_EARNINGS RETAINED_EARNINGS, PAYDEX_SCORE_YEAR PAYDEX_SCORE_YEAR, PAYDEX_SCORE_3_MONTH_AGO PAYDEX_SCORE_3_MONTH_AGO, INDUSTRY_PAYDEX_MEDIAN INDUSTRY_PAYDEX_MEDIAN, AVG_HIGH_CREDIT AVG_HIGH_CREDIT, HIGH_CREDIT HIGH_CREDIT, TOT_PAYMENT_EXP TOT_PAYMENT_EXP, NUM_NEGATIVE_PAYMENT NUM_NEGATIVE_PAYMENT, AVG_PAYMENT_SIZE AVG_PAYMENT_SIZE, NUM_SLOW_PAYMENTS NUM_SLOW_PAYMENTS, FAILURE_SCORE FAILURE_SCORE, FAILURE_SCORE_OVER_CODE FAILURE_SCORE_OVER_CODE, FAILURE_SCORE_INDUSTRY_PCT FAILURE_SCORE_INDUSTRY_PCT, FAILURE_SCORE_6_MONTHS FAILURE_SCORE_6_MONTHS, GLOBAL_FAILURE_SCORE GLOBAL_FAILURE_SCORE, DNB_SCORE DNB_SCORE, BUSINESS_FAILURE BUSINESS_FAILURE, OUT_OF_BUSINESS_FLAG OUT_OF_BUSINESS_FLAG, CUSTOMER_QUALITY_RANK CUSTOMER_QUALITY_RANK, FORTUNE_500_RANK FORTUNE_500_RANK, NUM_OF_EMPLOYEES NUM_OF_EMPLOYEES, LEGAL_STATUS LEGAL_STATUS, ENTITY_TYPE ENTITY_TYPE, YEAR_ESTABLISHED YEAR_ESTABLISHED, LINE_OF_BUSINESS LINE_OF_BUSINESS, SIC_CODE1 SIC_CODE1, SIC_CODE2 SIC_CODE2, MARKET_SEGMENT_NAME MARKET_SEGMENT_NAME, MARKET_SEGMENT_ID MARKET_SEGMENT_ID, SITE_NAME SITE_NAME, SITE_DUNS_NUMBER SITE_DUNS_NUMBER, NUM_EMPLOYEES_AT_SITE NUM_EMPLOYEES_AT_SITE, MINORITY_BUSINESS_FLAG MINORITY_BUSINESS_FLAG, SMALL_BUSINESS_FLAG SMALL_BUSINESS_FLAG, WOMEN_OWNED_BUS_FLAG WOMEN_OWNED_BUS_FLAG, GOV_ORG_FLAG GOV_ORG_FLAG, HQ_SUBSIDIARY_FLAG HQ_SUBSIDIARY_FLAG, FOREIGN_OWNED_FLAG FOREIGN_OWNED_FLAG, IMPORT_EXPORT_BUS_FLAG IMPORT_EXPORT_BUS_FLAG, CREDIT_CHECK_FLAG CREDIT_CHECK_FLAG, TOLERANCE TOLERANCE, DISCOUNT_TERMS_FLAG DISCOUNT_TERMS_FLAG, DUNNING_LETTERS_FLAG DUNNING_LETTERS_FLAG, INTEREST_CHARGES_FLAG INTEREST_CHARGES_FLAG, SEND_STATEMENTS_FLAG SEND_STATEMENTS_FLAG, CREDIT_HOLD_FLAG CREDIT_HOLD_FLAG, CREDIT_RATING CREDIT_RATING, RISK_CODE RISK_CODE, INTEREST_PERIOD_DAYS INTEREST_PERIOD_DAYS, PAYMENT_GRACE_DAYS PAYMENT_GRACE_DAYS, BUSINESS_SCOPE BUSINESS_SCOPE, EMAIL_ADDRESS EMAIL_ADDRESS, ADDRESS1 ADDRESS1, ADDRESS2 ADDRESS2, COMPETITOR_FLAG COMPETITOR_FLAG, THIRD_PARTY_FLAG THIRD_PARTY_FLAG, PERSON_FIRST_NAME PERSON_FIRST_NAME, PERSON_MIDDLE_NAME PERSON_MIDDLE_NAME, PERSON_LAST_NAME PERSON_LAST_NAME, PERSON_NAME_SUFFIX PERSON_NAME_SUFFIX, PERSON_TITLE PERSON_TITLE, PERSON_ACADEMIC_TITLE PERSON_ACADEMIC_TITLE, PERSON_PRE_NAME_ADJUNCT PERSON_PRE_NAME_ADJUNCT, CONTROL_YR CONTROL_YR, CONG_DIST_CODE CONG_DIST_CODE, LABOR_SURPLUS_FLAG LABOR_SURPLUS_FLAG, DEBARMENT_FLAG DEBARMENT_FLAG, DISADV_8A_FLAG DISADV_8A_FLAG, DEBARMENTS_COUNT DEBARMENTS_COUNT, MONTHS_SINCE_LAST_DEBARMENT MONTHS_SINCE_LAST_DEBARMENT, GSA_INDICATOR_FLAG GSA_INDICATOR_FLAG, ANALYSIS_FY ANALYSIS_FY, FISCAL_YEAREND_MONTH FISCAL_YEAREND_MONTH, CURR_FY_POTENTIAL_REVENUE CURR_FY_POTENTIAL_REVENUE, NEXT_FY_POTENTIAL_REVENUE NEXT_FY_POTENTIAL_REVENUE, ORGANIZATION_TYPE ORGANIZATION_TYPE, CORPORATION_CLASS CORPORATION_CLASS, REGISTRATION_TYPE REGISTRATION_TYPE, INCORP_YEAR INCORP_YEAR, PUBLIC_PRIVATE_OWNERSHIP_FLAG PUBLIC_PRIVATE_OWNERSHIP_FLAG, INTERNAL_FLAG INTERNAL_FLAG, TOTAL_PAYMENTS TOTAL_PAYMENTS, CREDIT_SCORE_CLASS CREDIT_SCORE_CLASS, CREDIT_SCORE_NATL_PERCENTILE CREDIT_SCORE_NATL_PERCENTILE, CREDIT_SCORE_INCD_DEFAULT CREDIT_SCORE_INCD_DEFAULT, CREDIT_SCORE_AGE CREDIT_SCORE_AGE, FAILURE_SCORE_CLASS FAILURE_SCORE_CLASS, FAILURE_SCORE_INCD_DEFAULT FAILURE_SCORE_INCD_DEFAULT, FAILURE_SCORE_AGE FAILURE_SCORE_AGE, MAXIMUM_CREDIT_RECOMMENDATION MAXIMUM_CREDIT_RECOMMENDATION, MAXIMUM_CREDIT_CURRENCY_CODE MAXIMUM_CREDIT_CURRENCY_CODE, PARTY_NAME PARTY_NAME, CITY CITY from "AMS"."AMS_DM_PARTY_DETAILS"
SELECT PARTY_ID PARTY_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, PARTY_TYPE PARTY_TYPE
, GENDER GENDER
, ETHNICITY ETHNICITY
, MARITAL_STATUS MARITAL_STATUS
, PERSONAL_INCOME PERSONAL_INCOME
, HOH_FLAG HOH_FLAG
, HOUSEHOLD_INCOME HOUSEHOLD_INCOME
, HOUSEHOLD_SIZE HOUSEHOLD_SIZE
, APARTMENT_FLAG APARTMENT_FLAG
, RENT_FLAG RENT_FLAG
, DEGREE_RECEIVED DEGREE_RECEIVED
, SCHOOL_TYPE SCHOOL_TYPE
, INTEREST_ART_FLAG INTEREST_ART_FLAG
, INTEREST_BOOKS_FLAG INTEREST_BOOKS_FLAG
, INTEREST_MOVIES_FLAG INTEREST_MOVIES_FLAG
, INTEREST_MUSIC_FLAG INTEREST_MUSIC_FLAG
, INTEREST_THEATER_FLAG INTEREST_THEATER_FLAG
, INTEREST_TRAVEL_FLAG INTEREST_TRAVEL_FLAG
, INTEREST_DRINK_FLAG INTEREST_DRINK_FLAG
, INTEREST_SMOKE_FLAG INTEREST_SMOKE_FLAG
, INTEREST_OTHER_FLAG INTEREST_OTHER_FLAG
, LEVEL_OF_INTEREST LEVEL_OF_INTEREST
, INTEREST_TYPE_CODE INTEREST_TYPE_CODE
, HOBBIES HOBBIES
, EXPERIENCE_LEVEL EXPERIENCE_LEVEL
, WORK_CLASS_NAME WORK_CLASS_NAME
, EMPLOYED_FLAG EMPLOYED_FLAG
, YEARS_EMPLOYED YEARS_EMPLOYED
, OCCUPATION OCCUPATION
, MILITARY_BRANCH MILITARY_BRANCH
, RESIDENCE_TYPE RESIDENCE_TYPE
, RESIDENT_LENGTH RESIDENT_LENGTH
, SECOND_HOME_TYPE SECOND_HOME_TYPE
, PRESENCE_OF_CHILDREN PRESENCE_OF_CHILDREN
, COUNTRY COUNTRY
, STATE STATE
, PROVINCE PROVINCE
, COUNTY COUNTY
, ZIP_CODE ZIP_CODE
, AVG_NUM_LIFE_CYCLE_SEGS AVG_NUM_LIFE_CYCLE_SEGS
, CONTACT_TYPE CONTACT_TYPE
, CATEGORY_CODE CATEGORY_CODE
, REFERENCE_USE_FLAG REFERENCE_USE_FLAG
, SUBCATEGORY_CODE SUBCATEGORY_CODE
, RETURN_TYPE RETURN_TYPE
, RETURN_REASON_CODE RETURN_REASON_CODE
, REFUND_PRICE REFUND_PRICE
, REFUND_TYPE REFUND_TYPE
, RETURNED_REASON RETURNED_REASON
, GROSS_ANNUAL_INCOME GROSS_ANNUAL_INCOME
, DEBT_TO_INCOME_RATIO DEBT_TO_INCOME_RATIO
, NUM_CREDIT_LINES NUM_CREDIT_LINES
, NUM_TRADE_LINES NUM_TRADE_LINES
, NET_WORTH NET_WORTH
, TOTAL_ASSETS TOTAL_ASSETS
, TOT_DEBT_OUTSTANDING TOT_DEBT_OUTSTANDING
, BANKRUPTCY_FLAG BANKRUPTCY_FLAG
, HIGH_RISK_FRAUD_FLAG HIGH_RISK_FRAUD_FLAG
, GROSS_ANNUAL_SALES GROSS_ANNUAL_SALES
, GROWTH_RATE_SALES_YEAR GROWTH_RATE_SALES_YEAR
, GROWTH_RATE_NET_PROF_YEAR GROWTH_RATE_NET_PROF_YEAR
, CURRENT_ASSETS CURRENT_ASSETS
, CURRENT_LIABILITIES CURRENT_LIABILITIES
, TOTAL_DEBTS TOTAL_DEBTS
, NET_PROFIT NET_PROFIT
, TANGIBLE_NET_PROFIT TANGIBLE_NET_PROFIT
, CAPITAL_AMOUNT CAPITAL_AMOUNT
, CAPITAL_TYPE_INDICATOR CAPITAL_TYPE_INDICATOR
, ACCOUNTS_RECEIVABLE ACCOUNTS_RECEIVABLE
, RETAINED_EARNINGS RETAINED_EARNINGS
, PAYDEX_SCORE_YEAR PAYDEX_SCORE_YEAR
, PAYDEX_SCORE_3_MONTH_AGO PAYDEX_SCORE_3_MONTH_AGO
, INDUSTRY_PAYDEX_MEDIAN INDUSTRY_PAYDEX_MEDIAN
, AVG_HIGH_CREDIT AVG_HIGH_CREDIT
, HIGH_CREDIT HIGH_CREDIT
, TOT_PAYMENT_EXP TOT_PAYMENT_EXP
, NUM_NEGATIVE_PAYMENT NUM_NEGATIVE_PAYMENT
, AVG_PAYMENT_SIZE AVG_PAYMENT_SIZE
, NUM_SLOW_PAYMENTS NUM_SLOW_PAYMENTS
, FAILURE_SCORE FAILURE_SCORE
, FAILURE_SCORE_OVER_CODE FAILURE_SCORE_OVER_CODE
, FAILURE_SCORE_INDUSTRY_PCT FAILURE_SCORE_INDUSTRY_PCT
, FAILURE_SCORE_6_MONTHS FAILURE_SCORE_6_MONTHS
, GLOBAL_FAILURE_SCORE GLOBAL_FAILURE_SCORE
, DNB_SCORE DNB_SCORE
, BUSINESS_FAILURE BUSINESS_FAILURE
, OUT_OF_BUSINESS_FLAG OUT_OF_BUSINESS_FLAG
, CUSTOMER_QUALITY_RANK CUSTOMER_QUALITY_RANK
, FORTUNE_500_RANK FORTUNE_500_RANK
, NUM_OF_EMPLOYEES NUM_OF_EMPLOYEES
, LEGAL_STATUS LEGAL_STATUS
, ENTITY_TYPE ENTITY_TYPE
, YEAR_ESTABLISHED YEAR_ESTABLISHED
, LINE_OF_BUSINESS LINE_OF_BUSINESS
, SIC_CODE1 SIC_CODE1
, SIC_CODE2 SIC_CODE2
, MARKET_SEGMENT_NAME MARKET_SEGMENT_NAME
, MARKET_SEGMENT_ID MARKET_SEGMENT_ID
, SITE_NAME SITE_NAME
, SITE_DUNS_NUMBER SITE_DUNS_NUMBER
, NUM_EMPLOYEES_AT_SITE NUM_EMPLOYEES_AT_SITE
, MINORITY_BUSINESS_FLAG MINORITY_BUSINESS_FLAG
, SMALL_BUSINESS_FLAG SMALL_BUSINESS_FLAG
, WOMEN_OWNED_BUS_FLAG WOMEN_OWNED_BUS_FLAG
, GOV_ORG_FLAG GOV_ORG_FLAG
, HQ_SUBSIDIARY_FLAG HQ_SUBSIDIARY_FLAG
, FOREIGN_OWNED_FLAG FOREIGN_OWNED_FLAG
, IMPORT_EXPORT_BUS_FLAG IMPORT_EXPORT_BUS_FLAG
, CREDIT_CHECK_FLAG CREDIT_CHECK_FLAG
, TOLERANCE TOLERANCE
, DISCOUNT_TERMS_FLAG DISCOUNT_TERMS_FLAG
, DUNNING_LETTERS_FLAG DUNNING_LETTERS_FLAG
, INTEREST_CHARGES_FLAG INTEREST_CHARGES_FLAG
, SEND_STATEMENTS_FLAG SEND_STATEMENTS_FLAG
, CREDIT_HOLD_FLAG CREDIT_HOLD_FLAG
, CREDIT_RATING CREDIT_RATING
, RISK_CODE RISK_CODE
, INTEREST_PERIOD_DAYS INTEREST_PERIOD_DAYS
, PAYMENT_GRACE_DAYS PAYMENT_GRACE_DAYS
, BUSINESS_SCOPE BUSINESS_SCOPE
, EMAIL_ADDRESS EMAIL_ADDRESS
, ADDRESS1 ADDRESS1
, ADDRESS2 ADDRESS2
, COMPETITOR_FLAG COMPETITOR_FLAG
, THIRD_PARTY_FLAG THIRD_PARTY_FLAG
, PERSON_FIRST_NAME PERSON_FIRST_NAME
, PERSON_MIDDLE_NAME PERSON_MIDDLE_NAME
, PERSON_LAST_NAME PERSON_LAST_NAME
, PERSON_NAME_SUFFIX PERSON_NAME_SUFFIX
, PERSON_TITLE PERSON_TITLE
, PERSON_ACADEMIC_TITLE PERSON_ACADEMIC_TITLE
, PERSON_PRE_NAME_ADJUNCT PERSON_PRE_NAME_ADJUNCT
, CONTROL_YR CONTROL_YR
, CONG_DIST_CODE CONG_DIST_CODE
, LABOR_SURPLUS_FLAG LABOR_SURPLUS_FLAG
, DEBARMENT_FLAG DEBARMENT_FLAG
, DISADV_8A_FLAG DISADV_8A_FLAG
, DEBARMENTS_COUNT DEBARMENTS_COUNT
, MONTHS_SINCE_LAST_DEBARMENT MONTHS_SINCE_LAST_DEBARMENT
, GSA_INDICATOR_FLAG GSA_INDICATOR_FLAG
, ANALYSIS_FY ANALYSIS_FY
, FISCAL_YEAREND_MONTH FISCAL_YEAREND_MONTH
, CURR_FY_POTENTIAL_REVENUE CURR_FY_POTENTIAL_REVENUE
, NEXT_FY_POTENTIAL_REVENUE NEXT_FY_POTENTIAL_REVENUE
, ORGANIZATION_TYPE ORGANIZATION_TYPE
, CORPORATION_CLASS CORPORATION_CLASS
, REGISTRATION_TYPE REGISTRATION_TYPE
, INCORP_YEAR INCORP_YEAR
, PUBLIC_PRIVATE_OWNERSHIP_FLAG PUBLIC_PRIVATE_OWNERSHIP_FLAG
, INTERNAL_FLAG INTERNAL_FLAG
, TOTAL_PAYMENTS TOTAL_PAYMENTS
, CREDIT_SCORE_CLASS CREDIT_SCORE_CLASS
, CREDIT_SCORE_NATL_PERCENTILE CREDIT_SCORE_NATL_PERCENTILE
, CREDIT_SCORE_INCD_DEFAULT CREDIT_SCORE_INCD_DEFAULT
, CREDIT_SCORE_AGE CREDIT_SCORE_AGE
, FAILURE_SCORE_CLASS FAILURE_SCORE_CLASS
, FAILURE_SCORE_INCD_DEFAULT FAILURE_SCORE_INCD_DEFAULT
, FAILURE_SCORE_AGE FAILURE_SCORE_AGE
, MAXIMUM_CREDIT_RECOMMENDATION MAXIMUM_CREDIT_RECOMMENDATION
, MAXIMUM_CREDIT_CURRENCY_CODE MAXIMUM_CREDIT_CURRENCY_CODE
, PARTY_NAME PARTY_NAME
, CITY CITY
FROM "AMS"."AMS_DM_PARTY_DETAILS"
|
|
|
|