[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AMS_DM_GEN_STG |
|---|---|
| Object Type: | TABLE |
| Owner: | AMS |
| FND Design Data: |  AMS.AMS_DM_GEN_STG
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| AMS_DM_GEN_STG_U1 | NORMAL | UNIQUE |
APPS_TS_INTERFACE
|
 PARTY_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PARTY_ID | NUMBER | Yes | Column used to join with AMS_DM_DRV_STG. | |
| 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. | |
| 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 | Length at current resident. | ||
| PRESENCE_OF_CHILDREN | NUMBER | Presence of children. | ||
| COUNTRY | VARCHAR2 | (60) | Country. | |
| STATE | VARCHAR2 | (60) | State. | |
| PROVINCE | VARCHAR2 | (60) | Province. | |
| COUNTY | VARCHAR2 | (60) | County. | |
| ZIP_CODE | VARCHAR2 | (60) | Zip code. | |
| REFERENCE_USE_FLAG | VARCHAR2 | (1) | Use as reference indicator. | |
| 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. | ||
| GLOBAL_FAILURE_SCORE | VARCHAR2 | (5) | Global failure score. | |
| DNB_SCORE | VARCHAR2 | (5) | Dunn and Bradstreet score. | |
| 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. | |
| YEAR_ESTABLISHED | NUMBER | Year established. | ||
| SIC_CODE1 | VARCHAR2 | (30) | Industry SIC code. | |
| 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) | Headquarter 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 letter indicator. | |
| INTEREST_CHARGES_FLAG | VARCHAR2 | (1) | Interest charges indicator. | |
| SEND_STATEMENTS_FLAG | VARCHAR2 | (1) | Send statements 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 | Interest period days. | ||
| PAYMENT_GRACE_DAYS | NUMBER | Payment grace days. | ||
| EMAIL_ADDRESS | VARCHAR2 | (2000) | E-mail address. | |
| ADDRESS1 | VARCHAR2 | (240) | First line of address. | |
| ADDRESS2 | VARCHAR2 | (240) | Second line of address. | |
| COMPETITOR_FLAG | VARCHAR2 | (1) | Indicates if a party is a competitor. | |
| THIRD_PARTY_FLAG | VARCHAR2 | (1) | Tracks if a party has a direct relationship with the organization using Oracle Receivables or through a third party vendor. | |
| PERSON_FIRST_NAME | VARCHAR2 | (150) | First name of the person. | |
| PERSON_MIDDLE_NAME | VARCHAR2 | (60) | Middle name of the person. | |
| PERSON_LAST_NAME | VARCHAR2 | (150) | Last or surname of the person. | |
| PERSON_NAME_SUFFIX | VARCHAR2 | (30) | Indicates the place in a family structure. For example, in Tom Jones III, the "III" is the suffix. | |
| PERSON_TITLE | VARCHAR2 | (60) | A professional or family title. | |
| PERSON_ACADEMIC_TITLE | VARCHAR2 | (30) | Academic title that is part of a person's name. | |
| PERSON_PRE_NAME_ADJUNCT | VARCHAR2 | (30) | Salutary introduction. | |
| CONTROL_YR | NUMBER | Year when current ownership gained control. | ||
| LINE_OF_BUSINESS | VARCHAR2 | (240) | Type of business activities performed at this site. | |
| CONG_DIST_CODE | VARCHAR2 | (2) | U.S. Congressional District. | |
| LABOR_SURPLUS_FLAG | VARCHAR2 | (1) | Indicates if this company operates in an area with a labor surplu. | |
| DEBARMENT_FLAG | VARCHAR2 | (1) | Indicates if this party is prohibited from entering into contracts or transactions with a government agency in the United States. | |
| DISADV_8A_FLAG | VARCHAR2 | (1) | 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 | (1) | Indicates if this is a US federal agency supported by the General Services Administration (GSA). | |
| ANALYSIS_FY | VARCHAR2 | (5) | Fiscal year used as the source for financial information. | |
| FISCAL_YEAREND_MONTH | VARCHAR2 | (30) | 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 | (30) | User-defined organization types such as region, division, and department. | |
| BUSINESS_SCOPE | VARCHAR2 | (20) | The physical class of business in which a business participates. For example, local, national, or international. | |
| CORPORATION_CLASS | VARCHAR2 | (60) | Taxation classification for corporation entities. For example, Chapter S in the US. | |
| REGISTRATION_TYPE | VARCHAR2 | (30) | Lookup for type of registration, such as nonprofit. | |
| INCORP_YEAR | NUMBER | Year that the business was incorporated. | ||
| PUBLIC_PRIVATE_OWNERSHIP_FLAG | VARCHAR2 | (1) | Indicates if the organization is privately owned. | |
| INTERNAL_FLAG | VARCHAR2 | (1) | Indicates if this is an internal organization. | |
| HIGH_CREDIT | NUMBER | Maximum credit ever extended to this organization | ||
| AVG_HIGH_CREDIT | NUMBER | Average of all high credit experiences. | ||
| 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
, PARTY_TYPE
, GENDER
, ETHNICITY
, MARITAL_STATUS
, PERSONAL_INCOME
, HOH_FLAG
, HOUSEHOLD_INCOME
, HOUSEHOLD_SIZE
, APARTMENT_FLAG
, RENT_FLAG
, DEGREE_RECEIVED
, SCHOOL_TYPE
, EMPLOYED_FLAG
, YEARS_EMPLOYED
, OCCUPATION
, MILITARY_BRANCH
, RESIDENCE_TYPE
, RESIDENT_LENGTH
, PRESENCE_OF_CHILDREN
, COUNTRY
, STATE
, PROVINCE
, COUNTY
, ZIP_CODE
, REFERENCE_USE_FLAG
, PAYDEX_SCORE_YEAR
, PAYDEX_SCORE_3_MONTH_AGO
, INDUSTRY_PAYDEX_MEDIAN
, GLOBAL_FAILURE_SCORE
, DNB_SCORE
, OUT_OF_BUSINESS_FLAG
, CUSTOMER_QUALITY_RANK
, FORTUNE_500_RANK
, NUM_OF_EMPLOYEES
, LEGAL_STATUS
, YEAR_ESTABLISHED
, SIC_CODE1
, 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
, 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
, LINE_OF_BUSINESS
, 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
, BUSINESS_SCOPE
, CORPORATION_CLASS
, REGISTRATION_TYPE
, INCORP_YEAR
, PUBLIC_PRIVATE_OWNERSHIP_FLAG
, INTERNAL_FLAG
, HIGH_CREDIT
, AVG_HIGH_CREDIT
, 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_GEN_STG;
AMS.AMS_DM_GEN_STG does not reference any database object
AMS.AMS_DM_GEN_STG is referenced by following:
APPS
AMS_DM_GEN_STG
|
|
|
|