[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | RA_CUSTOMER_PROFILES_INT_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | AR |
| FND Design Data: |  AR.RA_CUSTOMER_PROFILES_INT_ALL
|
| Subobject Name: | |
| Status: | VALID |
The RA_CUSTOMER_PROFILES_INT_ALL table is used by the Customer Interface program to store customer profile information. If you enter a new customer, you must either pass a customer profile class that already exists in Oracle Receivables, or pass customer profile values. Values in this table are not required if you are not entering a new customer or assigning customer profile information to customer addresses.
.
Please refer to the Oracle Trading Community Architecture Reference Guide for more detailed information on Open Interface table columns, including import validation and destination columns.
Scope: public
Product: HZ
Lifecycle: active
Display Name: Customer Profile
Category: BUSINESS_ENTITY HZ_CUSTOMER_ACCOUNT
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 40 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| RA_CUST_PROFILES_INTERFACE_N1 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
 ORIG_SYSTEM_CUSTOMER_REF
|
| RA_CUST_PROFILES_INTERFACE_N2 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
ORIG_SYSTEM_ADDRESS_REF
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| INTERFACE_STATUS | VARCHAR2 | (240) | Populated with error codes resulting from validation | |
| REQUEST_ID | NUMBER | (15) | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | |
| INSERT_UPDATE_FLAG | VARCHAR2 | (1) | Yes | Indicates whether the record is for insert or for update |
| VALIDATED_FLAG | VARCHAR2 | (1) | Indicates if this record was already validated. Y for yes, N otherwise. | |
| ORIG_SYSTEM_CUSTOMER_REF | VARCHAR2 | (240) | Yes | Unique customer identifier from foreign system |
| ORIG_SYSTEM_ADDRESS_REF | VARCHAR2 | (240) | Unique address identifier from foreign system | |
| CUSTOMER_PROFILE_CLASS_NAME | VARCHAR2 | (30) | Name of customer profile class assigned to customer or business purpose | |
| COLLECTOR_NAME | VARCHAR2 | (30) | Collector assigned to this customer profile | |
| CREDIT_BALANCE_STATEMENTS | VARCHAR2 | (1) | Indicates whether to send statements to customer with credit balances. Y for Yes, N otherwise. | |
| CREDIT_CHECKING | VARCHAR2 | (1) | Indicates whether to check credit. Y to check, N not to check. | |
| CREDIT_HOLD | VARCHAR2 | (1) | Yes | Indicates whether to put a hold on a customer's credit. Y to put a hold, N not to put a hold. |
| DISCOUNT_TERMS | VARCHAR2 | (1) | Indicates whether to assign discount terms associated with this customer profile class to this customer. Y to assign a discount term, N not to assign a discount term. | |
| DUNNING_LETTERS | VARCHAR2 | (1) | Indicates whether to send dunning letters to this customer. Y to send dunning letters, No not to send dunning letters. | |
| INTEREST_CHARGES | VARCHAR2 | (1) | Indicates if late charges are enabled | |
| STATEMENTS | VARCHAR2 | (1) | Indicates whether to send statements to this customer. Y to send statements, N not to send statements. | |
| TOLERANCE | NUMBER | (15) | Percent over the credit limit that this customer can exceed before collection action is taken | |
| TAX_PRINTING_OPTION | VARCHAR2 | (30) | List of values choice to indicate how to print tax information for this customer | |
| ACCOUNT_STATUS | VARCHAR2 | (30) | Customer's account status | |
| AUTOCASH_HIERARCHY_NAME | VARCHAR2 | (30) | AutoCash rule set assigned to this customer | |
| CREDIT_RATING | VARCHAR2 | (30) | Credit rating for this customer (LOV) | |
| DISCOUNT_GRACE_DAYS | NUMBER | (15) | Number of days after discount date customer is still allowed discount | |
| DUNNING_LETTER_SET_NAME | VARCHAR2 | (30) | No Longer Used | |
| INTEREST_PERIOD_DAYS | NUMBER | (15) | Number of days used with interest date to calculate interest charges | |
| OVERRIDE_TERMS | VARCHAR2 | (1) | Indicates if the customer can enter payment terms different from the standard payment terms. Y for yes, N otherwise. | |
| PAYMENT_GRACE_DAYS | NUMBER | (15) | Number of days a customer's receipt may be past due before collection action is taken | |
| PERCENT_COLLECTABLE | NUMBER | (15) | Estimated percent of customer's account balance you expect to collect regularly | |
| RISK_CODE | VARCHAR2 | (30) | List of values choice for customer credit risk | |
| STANDARD_TERM_NAME | VARCHAR2 | (15) | Standard Payment Terms for this customer | |
| STATEMENT_CYCLE_NAME | VARCHAR2 | (15) | Statement cycle assigned to this customer | |
| CHARGE_ON_FINANCE_CHARGE_FLAG | VARCHAR2 | (1) | Formula used to compute late charges. Possible values are simple, compound or flat rate. Validated against lookup type AR_FORMULAE. | |
| GROUPING_RULE_NAME | VARCHAR2 | (40) | Grouping rule assigned to this customer | |
| CURRENCY_CODE | VARCHAR2 | (15) | Currency code to define customer profile amount for this customer | |
| AUTO_REC_MIN_RECEIPT_AMOUNT | NUMBER | Set minimum receipt amount for this customer used when you create automatic receipts | ||
| INTEREST_RATE | NUMBER | Interest rate charged this customer for this currency | ||
| MAX_INTEREST_CHARGE | NUMBER | Maximum amount of interest you want to charge this customer for this currency | ||
| MIN_DUNNING_AMOUNT | NUMBER | Minimum amount that must be past due before dunning in this currency | ||
| MIN_DUNNING_INVOICE_AMOUNT | NUMBER | Minimum invoice amount that must be past due before dunning in this currency | ||
| MIN_FC_BALANCE_AMOUNT | NUMBER | Minimum customer balance required to assess finance charges for past due items in this currency | ||
| MIN_FC_INVOICE_AMOUNT | NUMBER | Late charges should not be calculated if individual transaction balance is below this threshold. | ||
| MIN_STATEMENT_AMOUNT | NUMBER | Minimum outstanding balance in this currency the customer must exceed for a statement to be generated | ||
| OVERALL_CREDIT_LIMIT | NUMBER | Total amount of credit for customer in this currency | ||
| TRX_CREDIT_LIMIT | NUMBER | Amount of credit allowed per order for this customer | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| AMOUNT_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield category for amount | |
| AMOUNT_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield value for amount | |
| AMOUNT_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield value for amount | |
| AMOUNT_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield value for amount | |
| AMOUNT_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield value for amount | |
| AMOUNT_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield value for amount | |
| AMOUNT_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield value for amount | |
| AMOUNT_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield value for amount | |
| AMOUNT_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield value for amount | |
| AMOUNT_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield value for amount | |
| AMOUNT_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield value for amount | |
| AMOUNT_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield value for amount | |
| AMOUNT_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield value for amount | |
| AMOUNT_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield value for amount | |
| AMOUNT_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield value for amount | |
| AMOUNT_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield value for amount | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
| CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
| CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| AUTO_REC_INCL_DISPUTED_FLAG | VARCHAR2 | (1) | Indicates whether to include debit items in dispute when creating Automatic receipts. Y to include debit items in dispute, N not to include debit items in dispute. | |
| CLEARING_DAYS | NUMBER | (5) | Number of clearing days for remitted receipts | |
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| ORG_ID | NUMBER | (15) | Organization identifier | |
| CONS_INV_FLAG | VARCHAR2 | (1) | Indicates if balance forward bill is generated and sent to customer. Y for yes, N or null | |
| CONS_INV_TYPE | VARCHAR2 | (30) | Format of balance forward bill. SUMMARY, DETAIL, or IMPORTED. Validated against HZ_CONS_INV_TYPE lookup type. | |
| GDF_CUST_PROF_ATTR_CAT | VARCHAR2 | (30) | Reserved for country-specific functionality related to customer profiles | |
| GDF_CUST_PROF_ATTRIBUTE1 | VARCHAR2 | (150) | Reserved for country-specific functionality related to addresses | |
| GDF_CUST_PROF_ATTRIBUTE2 | VARCHAR2 | (150) | Reserved for country-specific functionality related to addresses | |
| GDF_CUST_PROF_ATTRIBUTE3 | VARCHAR2 | (150) | Reserved for country-specific functionality related to addresses | |
| GDF_CUST_PROF_ATTRIBUTE4 | VARCHAR2 | (150) | Reserved for country-specific functionality related to addresses | |
| GDF_CUST_PROF_ATTRIBUTE5 | VARCHAR2 | (150) | Reserved for country-specific functionality related to addresses | |
| GDF_CUST_PROF_ATTRIBUTE6 | VARCHAR2 | (150) | Reserved for country-specific functionality related to addresses | |
| GDF_CUST_PROF_ATTRIBUTE7 | VARCHAR2 | (150) | Reserved for country-specific functionality related to addresses | |
| GDF_CUST_PROF_ATTRIBUTE8 | VARCHAR2 | (150) | Reserved for country-specific functionality related to addresses | |
| GDF_CUST_PROF_ATTRIBUTE9 | VARCHAR2 | (150) | Reserved for country-specific functionality related to addresses | |
| GDF_CUST_PROF_ATTRIBUTE10 | VARCHAR2 | (150) | Reserved for country-specific functionality related to addresses | |
| GDF_CUST_PROF_ATTRIBUTE11 | VARCHAR2 | (150) | Reserved for country-specific functionality related to addresses | |
| GDF_CUST_PROF_ATTRIBUTE12 | VARCHAR2 | (150) | Reserved for country-specific functionality related to addresses | |
| GDF_CUST_PROF_ATTRIBUTE13 | VARCHAR2 | (150) | Reserved for country-specific functionality related to addresses | |
| GDF_CUST_PROF_ATTRIBUTE14 | VARCHAR2 | (150) | Reserved for country-specific functionality related to addresses | |
| GDF_CUST_PROF_ATTRIBUTE15 | VARCHAR2 | (150) | Reserved for country-specific functionality related to addresses | |
| GDF_CUST_PROF_ATTRIBUTE16 | VARCHAR2 | (150) | Reserved for country-specific functionality related to addresses | |
| GDF_CUST_PROF_ATTRIBUTE17 | VARCHAR2 | (150) | Reserved for country-specific functionality related to addresses | |
| GDF_CUST_PROF_ATTRIBUTE18 | VARCHAR2 | (150) | Reserved for country-specific functionality related to addresses | |
| GDF_CUST_PROF_ATTRIBUTE19 | VARCHAR2 | (150) | Reserved for country-specific functionality related to addresses | |
| GDF_CUST_PROF_ATTRIBUTE20 | VARCHAR2 | (150) | Reserved for country-specific functionality related to addresses | |
| LOCKBOX_MATCHING_OPTION | VARCHAR2 | (30) | Lockbox Matching Option (typically INVOICE, SALES_ORDER, PURCHASE_ORDER) | |
| AUTOCASH_HIERARCHY_NAME_ADR | VARCHAR2 | (30) | Autocash rule set assigned to this customer | |
| CREDIT_CLASSIFICATION | VARCHAR2 | (30) | Credit Classification | |
| CONS_BILL_LEVEL | VARCHAR2 | (30) | Level at which balance forward billing is done, ACCOUNT or SITE. Validated against HZ_CONS_BILL_LEVEL lookup type. | |
| LATE_CHARGE_CALCULATION_TRX | VARCHAR2 | (30) | Indicates whether late charges should be calculated on overdue invoices and or late payments. Validated against lookup type AR_MANDATORY_LATE_CHARGES. | |
| CREDIT_ITEMS_FLAG | VARCHAR2 | (1) | Indicates if credit items such as unapplied or on-account receipts, can be offset against the overdue balance to reduce the amount liable for late charges. | |
| DISPUTED_TRANSACTIONS_FLAG | VARCHAR2 | (1) | Indicates if late charges can be calculated on disputed transactions | |
| LATE_CHARGE_TYPE | VARCHAR2 | (30) | Determines if late charges should be recorded as an adjustment, debit memo or interest invoice. Validated against lookup type AR_LATE_CHARGE_TYPE. | |
| LATE_CHARGE_TERM_ID | NUMBER | Payment term used when an invoice or debit memo is created for late charges. Foreign key to RA_TERMS.PAYMENT_TERM_ID. | ||
| INTEREST_CALCULATION_PERIOD | VARCHAR2 | (30) | Indicates if interest calculation period for late charges is daily or monthly. Validated against lookup type AR_CALCULATION_PERIOD. | |
| HOLD_CHARGED_INVOICES_FLAG | VARCHAR2 | (1) | Indicates if late charges can be calculated more than once for a transaction | |
| MESSAGE_TEXT_ID | NUMBER | Message text printed on the late charge transaction. Applies only to late charges recorded as invoices or debit memos. Foreign key to AR_STANDARD_TEXT.STANDARD_TEXT_ID. | ||
| MULTIPLE_INTEREST_RATES_FLAG | VARCHAR2 | (1) | Indicates if interest and penalty charges can be calculated using multiple rates for a single late charge period | |
| CHARGE_BEGIN_DATE | DATE | Optional value that indicates the date late charges begin. | ||
| EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | Exchange rate type for late charges. Validated against the table GL_DAILY_CONVERSION_TYPES. The type USER is excluded. | |
| MIN_FC_INVOICE_OVERDUE_TYPE | VARCHAR2 | (30) | Indicates whether the minimum invoice balance overdue is expressed as a fixed amount or a percentage | |
| MIN_FC_INVOICE_PERCENT | NUMBER | Invoice balance threshold percentage below which late charges can not be charged | ||
| MIN_FC_BALANCE_OVERDUE_TYPE | VARCHAR2 | (30) | Indicates whether the minimum customer balance amount overdue is expressed as a fixed amount or a percentage | |
| MIN_FC_BALANCE_PERCENT | NUMBER | Customer balance percentage threshold below which the late charge cannot be charged | ||
| INTEREST_TYPE | VARCHAR2 | (30) | Refers to the interest portion of the charge to be calculated on late invoices. Can be a fixed amount, a percentage or based on a charges schedule. Validated against lookup type AR_INTEREST_PENALTY_TYPE. | |
| INTEREST_FIXED_AMOUNT | NUMBER | The flat amount to be charged on all overdue invoices. Used when interest type is fixed amount. | ||
| INTEREST_SCHEDULE_ID | NUMBER | (15) | Charge based on a tiered schedule. Used when interest type is charges schedule. Foreign key to AR_CHARGES_SCHEDULES.SCHEDULE_ID | |
| PENALTY_TYPE | VARCHAR2 | (30) | Refers to any additional penalties to be added to late charges. Can be a fixed amount, a percentage or based on a charges schedule. Validated against lookup type AR_INTEREST_PENALTY_TYPE. | |
| PENALTY_RATE | NUMBER | The penalty will be calculated as a fixed percentage of the late charge. Used when penalty type is percentage. | ||
| MIN_INTEREST_CHARGE | NUMBER | Minimum late charge amount. | ||
| PENALTY_FIXED_AMOUNT | NUMBER | The penalty will be a flat fee applied to the late charge. Used when penalty type is fixed amount. | ||
| PENALTY_SCHEDULE_ID | NUMBER | (15) | Charge based on a tiered schedule. Used when penalty type is charges schedule. Foreign key to AR_CHARGES_SCHEDULES.SCHEDULE_ID | |
| AUTOMATCH_SET_NAME | VARCHAR2 | (30) | AutoMatch Rule Set Name(Foreign Key to AR_CASH_AUTO_RULE_SETS_TL.automatch_set_name) |
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;
AR.RA_CUSTOMER_PROFILES_INT_ALL does not reference any database object
AR.RA_CUSTOMER_PROFILES_INT_ALL is referenced by following:
AR
RA_CUSTOMER_PROFILES_INT_ALL#
|
|
|
|