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


VIEW: AR.RA_CUSTOMER_PROFILES_INT_ALL#

Object Details
Object Name: RA_CUSTOMER_PROFILES_INT_ALL#
Object Type: VIEW
Owner: AR
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
INTERFACE_STATUS VARCHAR2 (240)
REQUEST_ID NUMBER (15)
INSERT_UPDATE_FLAG VARCHAR2 (1) Yes
VALIDATED_FLAG VARCHAR2 (1)
ORIG_SYSTEM_CUSTOMER_REF VARCHAR2 (240) Yes
ORIG_SYSTEM_ADDRESS_REF VARCHAR2 (240)
CUSTOMER_PROFILE_CLASS_NAME VARCHAR2 (30)
COLLECTOR_NAME VARCHAR2 (30)
CREDIT_BALANCE_STATEMENTS VARCHAR2 (1)
CREDIT_CHECKING VARCHAR2 (1)
CREDIT_HOLD VARCHAR2 (1) Yes
DISCOUNT_TERMS VARCHAR2 (1)
DUNNING_LETTERS VARCHAR2 (1)
INTEREST_CHARGES VARCHAR2 (1)
STATEMENTS VARCHAR2 (1)
TOLERANCE NUMBER (15)
TAX_PRINTING_OPTION VARCHAR2 (30)
ACCOUNT_STATUS VARCHAR2 (30)
AUTOCASH_HIERARCHY_NAME VARCHAR2 (30)
CREDIT_RATING VARCHAR2 (30)
DISCOUNT_GRACE_DAYS NUMBER (15)
DUNNING_LETTER_SET_NAME VARCHAR2 (30)
INTEREST_PERIOD_DAYS NUMBER (15)
OVERRIDE_TERMS VARCHAR2 (1)
PAYMENT_GRACE_DAYS NUMBER (15)
PERCENT_COLLECTABLE NUMBER (15)
RISK_CODE VARCHAR2 (30)
STANDARD_TERM_NAME VARCHAR2 (15)
STATEMENT_CYCLE_NAME VARCHAR2 (15)
CHARGE_ON_FINANCE_CHARGE_FLAG VARCHAR2 (1)
GROUPING_RULE_NAME VARCHAR2 (40)
CURRENCY_CODE VARCHAR2 (15)
AUTO_REC_MIN_RECEIPT_AMOUNT NUMBER

INTEREST_RATE NUMBER

MAX_INTEREST_CHARGE NUMBER

MIN_DUNNING_AMOUNT NUMBER

MIN_DUNNING_INVOICE_AMOUNT NUMBER

MIN_FC_BALANCE_AMOUNT NUMBER

MIN_FC_INVOICE_AMOUNT NUMBER

MIN_STATEMENT_AMOUNT NUMBER

OVERALL_CREDIT_LIMIT NUMBER

TRX_CREDIT_LIMIT NUMBER

ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
AMOUNT_ATTRIBUTE_CATEGORY VARCHAR2 (30)
AMOUNT_ATTRIBUTE1 VARCHAR2 (150)
AMOUNT_ATTRIBUTE10 VARCHAR2 (150)
AMOUNT_ATTRIBUTE11 VARCHAR2 (150)
AMOUNT_ATTRIBUTE12 VARCHAR2 (150)
AMOUNT_ATTRIBUTE13 VARCHAR2 (150)
AMOUNT_ATTRIBUTE14 VARCHAR2 (150)
AMOUNT_ATTRIBUTE15 VARCHAR2 (150)
AMOUNT_ATTRIBUTE2 VARCHAR2 (150)
AMOUNT_ATTRIBUTE3 VARCHAR2 (150)
AMOUNT_ATTRIBUTE4 VARCHAR2 (150)
AMOUNT_ATTRIBUTE5 VARCHAR2 (150)
AMOUNT_ATTRIBUTE6 VARCHAR2 (150)
AMOUNT_ATTRIBUTE7 VARCHAR2 (150)
AMOUNT_ATTRIBUTE8 VARCHAR2 (150)
AMOUNT_ATTRIBUTE9 VARCHAR2 (150)
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
AUTO_REC_INCL_DISPUTED_FLAG VARCHAR2 (1)
CLEARING_DAYS NUMBER (5)
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (30)
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
ORG_ID NUMBER (15)
CONS_INV_FLAG VARCHAR2 (1)
CONS_INV_TYPE VARCHAR2 (30)
GDF_CUST_PROF_ATTR_CAT VARCHAR2 (30)
GDF_CUST_PROF_ATTRIBUTE1 VARCHAR2 (150)
GDF_CUST_PROF_ATTRIBUTE2 VARCHAR2 (150)
GDF_CUST_PROF_ATTRIBUTE3 VARCHAR2 (150)
GDF_CUST_PROF_ATTRIBUTE4 VARCHAR2 (150)
GDF_CUST_PROF_ATTRIBUTE5 VARCHAR2 (150)
GDF_CUST_PROF_ATTRIBUTE6 VARCHAR2 (150)
GDF_CUST_PROF_ATTRIBUTE7 VARCHAR2 (150)
GDF_CUST_PROF_ATTRIBUTE8 VARCHAR2 (150)
GDF_CUST_PROF_ATTRIBUTE9 VARCHAR2 (150)
GDF_CUST_PROF_ATTRIBUTE10 VARCHAR2 (150)
GDF_CUST_PROF_ATTRIBUTE11 VARCHAR2 (150)
GDF_CUST_PROF_ATTRIBUTE12 VARCHAR2 (150)
GDF_CUST_PROF_ATTRIBUTE13 VARCHAR2 (150)
GDF_CUST_PROF_ATTRIBUTE14 VARCHAR2 (150)
GDF_CUST_PROF_ATTRIBUTE15 VARCHAR2 (150)
GDF_CUST_PROF_ATTRIBUTE16 VARCHAR2 (150)
GDF_CUST_PROF_ATTRIBUTE17 VARCHAR2 (150)
GDF_CUST_PROF_ATTRIBUTE18 VARCHAR2 (150)
GDF_CUST_PROF_ATTRIBUTE19 VARCHAR2 (150)
GDF_CUST_PROF_ATTRIBUTE20 VARCHAR2 (150)
LOCKBOX_MATCHING_OPTION VARCHAR2 (30)
AUTOCASH_HIERARCHY_NAME_ADR VARCHAR2 (30)
CREDIT_CLASSIFICATION VARCHAR2 (30)
CONS_BILL_LEVEL VARCHAR2 (30)
LATE_CHARGE_CALCULATION_TRX VARCHAR2 (30)
CREDIT_ITEMS_FLAG VARCHAR2 (1)
DISPUTED_TRANSACTIONS_FLAG VARCHAR2 (1)
LATE_CHARGE_TYPE VARCHAR2 (30)
LATE_CHARGE_TERM_ID NUMBER

INTEREST_CALCULATION_PERIOD VARCHAR2 (30)
HOLD_CHARGED_INVOICES_FLAG VARCHAR2 (1)
MESSAGE_TEXT_ID NUMBER

MULTIPLE_INTEREST_RATES_FLAG VARCHAR2 (1)
CHARGE_BEGIN_DATE DATE

EXCHANGE_RATE_TYPE VARCHAR2 (30)
MIN_FC_INVOICE_OVERDUE_TYPE VARCHAR2 (30)
MIN_FC_INVOICE_PERCENT NUMBER

MIN_FC_BALANCE_OVERDUE_TYPE VARCHAR2 (30)
MIN_FC_BALANCE_PERCENT NUMBER

INTEREST_TYPE VARCHAR2 (30)
INTEREST_FIXED_AMOUNT NUMBER

INTEREST_SCHEDULE_ID NUMBER (15)
PENALTY_TYPE VARCHAR2 (30)
PENALTY_RATE NUMBER

MIN_INTEREST_CHARGE NUMBER

PENALTY_FIXED_AMOUNT NUMBER

PENALTY_SCHEDULE_ID NUMBER (15)
AUTOMATCH_SET_NAME VARCHAR2 (30)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INTERFACE_STATUS
,      REQUEST_ID
,      INSERT_UPDATE_FLAG
,      VALIDATED_FLAG
,      ORIG_SYSTEM_CUSTOMER_REF
,      ORIG_SYSTEM_ADDRESS_REF
,      CUSTOMER_PROFILE_CLASS_NAME
,      COLLECTOR_NAME
,      CREDIT_BALANCE_STATEMENTS
,      CREDIT_CHECKING
,      CREDIT_HOLD
,      DISCOUNT_TERMS
,      DUNNING_LETTERS
,      INTEREST_CHARGES
,      STATEMENTS
,      TOLERANCE
,      TAX_PRINTING_OPTION
,      ACCOUNT_STATUS
,      AUTOCASH_HIERARCHY_NAME
,      CREDIT_RATING
,      DISCOUNT_GRACE_DAYS
,      DUNNING_LETTER_SET_NAME
,      INTEREST_PERIOD_DAYS
,      OVERRIDE_TERMS
,      PAYMENT_GRACE_DAYS
,      PERCENT_COLLECTABLE
,      RISK_CODE
,      STANDARD_TERM_NAME
,      STATEMENT_CYCLE_NAME
,      CHARGE_ON_FINANCE_CHARGE_FLAG
,      GROUPING_RULE_NAME
,      CURRENCY_CODE
,      AUTO_REC_MIN_RECEIPT_AMOUNT
,      INTEREST_RATE
,      MAX_INTEREST_CHARGE
,      MIN_DUNNING_AMOUNT
,      MIN_DUNNING_INVOICE_AMOUNT
,      MIN_FC_BALANCE_AMOUNT
,      MIN_FC_INVOICE_AMOUNT
,      MIN_STATEMENT_AMOUNT
,      OVERALL_CREDIT_LIMIT
,      TRX_CREDIT_LIMIT
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      AMOUNT_ATTRIBUTE_CATEGORY
,      AMOUNT_ATTRIBUTE1
,      AMOUNT_ATTRIBUTE10
,      AMOUNT_ATTRIBUTE11
,      AMOUNT_ATTRIBUTE12
,      AMOUNT_ATTRIBUTE13
,      AMOUNT_ATTRIBUTE14
,      AMOUNT_ATTRIBUTE15
,      AMOUNT_ATTRIBUTE2
,      AMOUNT_ATTRIBUTE3
,      AMOUNT_ATTRIBUTE4
,      AMOUNT_ATTRIBUTE5
,      AMOUNT_ATTRIBUTE6
,      AMOUNT_ATTRIBUTE7
,      AMOUNT_ATTRIBUTE8
,      AMOUNT_ATTRIBUTE9
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      CREATED_BY
,      AUTO_REC_INCL_DISPUTED_FLAG
,      CLEARING_DAYS
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      ORG_ID
,      CONS_INV_FLAG
,      CONS_INV_TYPE
,      GDF_CUST_PROF_ATTR_CAT
,      GDF_CUST_PROF_ATTRIBUTE1
,      GDF_CUST_PROF_ATTRIBUTE2
,      GDF_CUST_PROF_ATTRIBUTE3
,      GDF_CUST_PROF_ATTRIBUTE4
,      GDF_CUST_PROF_ATTRIBUTE5
,      GDF_CUST_PROF_ATTRIBUTE6
,      GDF_CUST_PROF_ATTRIBUTE7
,      GDF_CUST_PROF_ATTRIBUTE8
,      GDF_CUST_PROF_ATTRIBUTE9
,      GDF_CUST_PROF_ATTRIBUTE10
,      GDF_CUST_PROF_ATTRIBUTE11
,      GDF_CUST_PROF_ATTRIBUTE12
,      GDF_CUST_PROF_ATTRIBUTE13
,      GDF_CUST_PROF_ATTRIBUTE14
,      GDF_CUST_PROF_ATTRIBUTE15
,      GDF_CUST_PROF_ATTRIBUTE16
,      GDF_CUST_PROF_ATTRIBUTE17
,      GDF_CUST_PROF_ATTRIBUTE18
,      GDF_CUST_PROF_ATTRIBUTE19
,      GDF_CUST_PROF_ATTRIBUTE20
,      LOCKBOX_MATCHING_OPTION
,      AUTOCASH_HIERARCHY_NAME_ADR
,      CREDIT_CLASSIFICATION
,      CONS_BILL_LEVEL
,      LATE_CHARGE_CALCULATION_TRX
,      CREDIT_ITEMS_FLAG
,      DISPUTED_TRANSACTIONS_FLAG
,      LATE_CHARGE_TYPE
,      LATE_CHARGE_TERM_ID
,      INTEREST_CALCULATION_PERIOD
,      HOLD_CHARGED_INVOICES_FLAG
,      MESSAGE_TEXT_ID
,      MULTIPLE_INTEREST_RATES_FLAG
,      CHARGE_BEGIN_DATE
,      EXCHANGE_RATE_TYPE
,      MIN_FC_INVOICE_OVERDUE_TYPE
,      MIN_FC_INVOICE_PERCENT
,      MIN_FC_BALANCE_OVERDUE_TYPE
,      MIN_FC_BALANCE_PERCENT
,      INTEREST_TYPE
,      INTEREST_FIXED_AMOUNT
,      INTEREST_SCHEDULE_ID
,      PENALTY_TYPE
,      PENALTY_RATE
,      MIN_INTEREST_CHARGE
,      PENALTY_FIXED_AMOUNT
,      PENALTY_SCHEDULE_ID
,      AUTOMATCH_SET_NAME
FROM AR.RA_CUSTOMER_PROFILES_INT_ALL#;

Dependencies

[top of page]

AR.RA_CUSTOMER_PROFILES_INT_ALL# references the following:

SchemaAR
TableRA_CUSTOMER_PROFILES_INT_ALL
AR.RA_CUSTOMER_PROFILES_INT_ALL# is referenced by following:

SchemaAPPS
SynonymRA_CUSTOMER_PROFILES_INTERFACE
SynonymRA_CUSTOMER_PROFILES_INT_ALL