[Home] [Help] [Dependency Information]
Object Name: | AMS_DM_PARTY_PROFILE_STG# |
---|---|
Object Type: | VIEW |
Owner: | AMS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PARTY_ID | NUMBER | Yes | ||
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 |
Cut, paste (and edit) the following text to query this object:
SELECT PARTY_ID
, 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
FROM AMS.AMS_DM_PARTY_PROFILE_STG#;
|
|
|