RA_CUSTOMER_PROFILES_INT_ALL
This is part of customer import program. This is the open interface table for the Customer profiles while importing customers
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INTERFACE_STATUS | VARCHAR2 | 240 | Oracle internal use only. Interface status. | ||
| BATCH_ID | NUMBER | 18 | Yes | Unique batch identifier. Free text field. | |
| INSERT_UPDATE_FLAG | VARCHAR2 | 1 | Yes | Insert update indicator. Possible values: I, U. I means customer does not exist. Import customer information for the first time. U means customer exists. Specific customer information must be updated. | |
| VALIDATED_FLAG | VARCHAR2 | 1 | Oracle internal use only. Validated indicator. | ||
| CUST_ORIG_SYSTEM | VARCHAR2 | 240 | Original source system of customer data. Use Manage Source Systems task to identify valid values. Examples: Siebel, Dun and Bradstreet. | ||
| CUST_ORIG_SYSTEM_REFERENCE | VARCHAR2 | 240 | Uniquely identifies customer in original source system. Must be unique if INSERT_UPDATE_FLAG is I. Must be an existing value if INSERT_UPDATE_FLAG is U. | ||
| CUST_SITE_ORIG_SYSTEM | VARCHAR2 | 240 | Original source system of customer site data. Use Manage Source Systems task to identify valid values. Examples: Siebel, Dun and Bradstreet. | ||
| CUST_SITE_ORIG_SYS_REF | VARCHAR2 | 240 | Uniquely identifies customer site in original source system. Must be unique if INSERT_UPDATE_FLAG is I. Must be an existing value if INSERT_UPDATE_FLAG is U. | ||
| CUSTOMER_PROFILE_CLASS_NAME | VARCHAR2 | 30 | Customer profile class. Use Manage Receivables Customer Profile Classes task to identify valid values. | ||
| COLLECTOR_NAME | VARCHAR2 | 30 | Collector name. Use Manage Collectors task to identify valid values. Mandatory if CUSTOMER_PROFILE_CLASS_NAME is NULL. | ||
| CREDIT_BALANCE_STATEMENTS | VARCHAR2 | 1 | Statement with credit balance can be sent to customer. Valid values: Y, N. | ||
| CREDIT_CHECKING | VARCHAR2 | 1 | Credit check enabled for customer account. Valid values: Y, N. | ||
| CREDIT_HOLD | VARCHAR2 | 1 | Yes | Customer on credit hold. Valid values: Y, N. | |
| DISCOUNT_TERMS | VARCHAR2 | 1 | Discount allowed. Valid values: Y, N. | ||
| DUNNING_LETTERS | VARCHAR2 | 1 | Send dunning letter to customer account or site. Valid values: Y, N. | ||
| INTEREST_CHARGES | VARCHAR2 | 1 | Late charges enabled indicator. Valid values: Y, N. | ||
| STATEMENTS | VARCHAR2 | 1 | Create statements for customer account or site. Valid values: Y, N. | ||
| TOLERANCE | NUMBER | Credit limit over tolerance amount. Credit check tolerance amount over the credit limit. Must be between -100 and 100. Use comma for thousands separator. Use either comma or period as decimal separator. | |||
| TAX_PRINTING_OPTION | VARCHAR2 | 30 | Indicates how to print tax information on invoices. Use Manage Receivables lookups, lookup type TAX_PRINTING_OPTION to identify valid values. | ||
| ACCOUNT_STATUS | VARCHAR2 | 30 | Customer account status. Use Manage Receivables Lookups, lookup type ACCOUNT_STATUS to identify valid values. | ||
| AUTOCASH_HIERARCHY_NAME | VARCHAR2 | 30 | Autocash rule set name. Use Manage Autocash Rule Sets task to identify valid values. | ||
| CREDIT_RATING | VARCHAR2 | 30 | Customer credit rating. Use Manage Receivables lookups, lookup type CREDIT_RATING to identify valid values. | ||
| DISCOUNT_GRACE_DAYS | NUMBER | Discount grace days. Use comma for thousands separator. Whole numbers only. | |||
| DUNNING_LETTER_SET_NAME | VARCHAR2 | 30 | Oracle internal use only. | ||
| INTEREST_PERIOD_DAYS | NUMBER | Number of days used in the interest period for calculating late charges. Use comma for thousands separator. Whole numbers only. | |||
| OVERRIDE_TERMS | VARCHAR2 | 1 | Override terms when creating invoices allowed. Valid values: Y, N. | ||
| PAYMENT_GRACE_DAYS | NUMBER | Payment grace days before interest may be charged. Use comma for thousands separator. Whole numbers only. | |||
| PERCENT_COLLECTABLE | NUMBER | Collectible percentage of customer balance. Must be between 0 and 100. Use comma for thousands separator. Use either comma or period as decimal separator. | |||
| RISK_CODE | VARCHAR2 | 30 | Risk code. Use Manage Receivables lookups, lookup type RISK_CODE to identify valid values. | ||
| STANDARD_TERM_NAME | VARCHAR2 | 15 | Payment terms name. Use Manage Receivables Payment Terms task to identify valid values. | ||
| STATEMENT_CYCLE_NAME | VARCHAR2 | 15 | Statement cycle name. Determines when to send statements to customers. Use Manage Statement Cycles task to identify valid values. | ||
| CHARGE_ON_FINANCE_CHARGE_FLAG | VARCHAR2 | 1 | Indicates whether to compound interest when calculating late charges. Possible values: Y, N.Mandatory if INTEREST_CHARGES is Y. Do not use if INTEREST_CHARGES is N or NULL. | ||
| GROUPING_RULE_NAME | VARCHAR2 | 40 | Invoice line grouping rule name. Use Manage AutoInvoice Grouping Rules task to identify valid values. | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Currency code for profile amounts. Use Manage Currencies task to identify valid values. Use three character ISO code. Example: US Dollars is USD. | ||
| AUTO_REC_MIN_RECEIPT_AMOUNT | NUMBER | Minimum receipt amount for automatic receipts. Enter amount based on currency value from CURRENCY_CODE. Currency precision is enforced. Must be greater than 0. | |||
| INTEREST_RATE | NUMBER | Interest calculation percentage rate. Enter as a percentage. Use comma for thousands separator. Use either comma or period as decimal separator. Must be between 0 and 100. | |||
| MAX_INTEREST_CHARGE | NUMBER | Maximum interest charge. Enter amount based on currency value from CURRENCY_CODE. Use comma for thousands separator. Use either comma or period as decimal separator. Currency precision is enforced. Must be greater than 0. | |||
| MIN_DUNNING_AMOUNT | NUMBER | Minimum amount past due for the customer account or site to send dunning letter. Enter amount based on currency value from CURRENCY_CODE. Use comma for thousands separator. Use either comma or period as decimal separator. Currency precision is enforced. Must be greater than 0. | |||
| MIN_DUNNING_INVOICE_AMOUNT | NUMBER | Minimum amount on an invoice that is past due to send dunning letter. Enter amount based on currency value from CURRENCY_CODE. Use comma for thousands separator. Use either comma or period as decimal separator. Currency precision is enforced. Must be greater than 0. | |||
| MIN_FC_BALANCE_AMOUNT | NUMBER | Minimum balance required for late charges calculation. Enter amount based on currency value from CURRENCY_CODE. Use comma for thousands separator. Use either comma or period as decimal separator. Currency precision is enforced. Must be greater than 0. | |||
| MIN_FC_INVOICE_AMOUNT | NUMBER | Minimum invoice amount for late charges calculation. Enter amount based on currency value from CURRENCY_CODE. Use comma for thousands separator. Use either comma or period as decimal separator. Currency precision is enforced. Must be greater than 0. | |||
| MIN_STATEMENT_AMOUNT | NUMBER | Minimum outstanding amount to generate statement. Use comma for thousands separator. Use either comma or period as decimal separator. Currency precision is enforced. Must be greater than 0. | |||
| OVERALL_CREDIT_LIMIT | NUMBER | Customer account overall credit limit. Enter amount based on currency value from CURRENCY_CODE. Use comma for thousands separator. Use either comma or period as decimal separator. Currency precision is enforced. Must be greater than 0. | |||
| TRX_CREDIT_LIMIT | NUMBER | Sales order credit limit. Enter amount based on currency value from CURRENCY_CODE. Use comma for thousands separator. Use either comma or period as decimal separator. Currency precision is enforced. Must be greater than 0. | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Oracle internal use only. Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Oracle internal use only. Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Oracle internal use only. Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Oracle internal use only. Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Oracle internal use only. Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Oracle internal use only. Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Oracle internal use only. Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Oracle internal use only. Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Oracle internal use only. Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Oracle internal use only. Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Oracle internal use only. Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Oracle internal use only. Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Oracle internal use only. Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Oracle internal use only. Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Oracle internal use only. Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Oracle internal use only. Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| AMOUNT_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Oracle internal use only. Customer profile descriptive flexfield category. | ||
| AMOUNT_ATTRIBUTE1 | VARCHAR2 | 150 | Oracle internal use only. Customer profile descriptive flexfield column. | ||
| AMOUNT_ATTRIBUTE10 | VARCHAR2 | 150 | Oracle internal use only. Customer profile descriptive flexfield column. | ||
| AMOUNT_ATTRIBUTE11 | VARCHAR2 | 150 | Oracle internal use only. Customer profile descriptive flexfield column. | ||
| AMOUNT_ATTRIBUTE12 | VARCHAR2 | 150 | Oracle internal use only. Customer profile descriptive flexfield column. | ||
| AMOUNT_ATTRIBUTE13 | VARCHAR2 | 150 | Oracle internal use only. Customer profile descriptive flexfield column. | ||
| AMOUNT_ATTRIBUTE14 | VARCHAR2 | 150 | Oracle internal use only. Customer profile descriptive flexfield column. | ||
| AMOUNT_ATTRIBUTE15 | VARCHAR2 | 150 | Oracle internal use only. Customer profile descriptive flexfield column. | ||
| AMOUNT_ATTRIBUTE2 | VARCHAR2 | 150 | Oracle internal use only. Customer profile descriptive flexfield column. | ||
| AMOUNT_ATTRIBUTE3 | VARCHAR2 | 150 | Oracle internal use only. Customer profile descriptive flexfield column. | ||
| AMOUNT_ATTRIBUTE4 | VARCHAR2 | 150 | Oracle internal use only. Customer profile descriptive flexfield column. | ||
| AMOUNT_ATTRIBUTE5 | VARCHAR2 | 150 | Oracle internal use only. Customer profile descriptive flexfield column. | ||
| AMOUNT_ATTRIBUTE6 | VARCHAR2 | 150 | Oracle internal use only. Customer profile descriptive flexfield column. | ||
| AMOUNT_ATTRIBUTE7 | VARCHAR2 | 150 | Oracle internal use only. Customer profile descriptive flexfield column. | ||
| AMOUNT_ATTRIBUTE8 | VARCHAR2 | 150 | Oracle internal use only. Customer profile descriptive flexfield column. | ||
| AMOUNT_ATTRIBUTE9 | VARCHAR2 | 150 | Oracle internal use only. Customer profile descriptive flexfield column. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| PARTY_ORIG_SYSTEM | VARCHAR2 | 240 | Original source system of party data. Use Manage Source Systems task to identify valid values. Examples: Siebel, Dun, and Bradstreet. | ||
| PARTY_ORIG_SYSTEM_REFERENCE | VARCHAR2 | 240 | Uniquely identifies party in original source system. Must be unique if INSERT_UPDATE_FLAG is I. Must be an existing value if INSERT_UPDATE_FLAG is U | ||
| AUTO_REC_INCL_DISPUTED_FLAG | VARCHAR2 | 1 | Automatic receipts include disputed items. Valid values: Y, N. | ||
| CLEARING_DAYS | NUMBER | Number of days before receipts can be cleared by Automatic Clearing House. Whole numbers only. Use comma for thousands separator. | |||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Oracle internal use only. Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Oracle internal use only. Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | 150 | Oracle internal use only. Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | 150 | Oracle internal use only. Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | 150 | Oracle internal use only. Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | 150 | Oracle internal use only. Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | 150 | Oracle internal use only. Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | 150 | Oracle internal use only. Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | 150 | Oracle internal use only. Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | 150 | Oracle internal use only. Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | 150 | Oracle internal use only. Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | 150 | Oracle internal use only. Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | 150 | Oracle internal use only. Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | 150 | Oracle internal use only. Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | 150 | Oracle internal use only. Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | 150 | Oracle internal use only. Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | 150 | Oracle internal use only. Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | 150 | Oracle internal use only. Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | 150 | Oracle internal use only. Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | 150 | Oracle internal use only. Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | 150 | Oracle internal use only. Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| ORG_ID | NUMBER | 18 | Yes | Business unit identifier. Use Manage Business units task to identify valid values. | |
| CONS_INV_FLAG | VARCHAR2 | 1 | Balance forward billing enabled. Valid values: Y, N. | ||
| CONS_INV_TYPE | VARCHAR2 | 30 | Balance forward bill format. Valid values: SUMMARY, DETAIL, IMPORTED. Required if CONS_INV_FLAG is Y. | ||
| GDF_CUST_PROF_ATTR_CAT | VARCHAR2 | 30 | Oracle internal use only. Global descriptive Flexfield Category for Customer profiles. | ||
| GDF_CUST_PROF_ATTRIBUTE1 | VARCHAR2 | 150 | Oracle internal use only. Global descriptive Flexfield Column for Customer profiles. | ||
| GDF_CUST_PROF_ATTRIBUTE2 | VARCHAR2 | 150 | Oracle internal use only. Global descriptive Flexfield Column for Customer profiles. | ||
| GDF_CUST_PROF_ATTRIBUTE3 | VARCHAR2 | 150 | Oracle internal use only. Global descriptive Flexfield Column for Customer profiles. | ||
| GDF_CUST_PROF_ATTRIBUTE4 | VARCHAR2 | 150 | Oracle internal use only. Global descriptive Flexfield Column for Customer profiles. | ||
| GDF_CUST_PROF_ATTRIBUTE5 | VARCHAR2 | 150 | Oracle internal use only. Global descriptive Flexfield Column for Customer profiles. | ||
| GDF_CUST_PROF_ATTRIBUTE6 | VARCHAR2 | 150 | Oracle internal use only. Global descriptive Flexfield Column for Customer profiles. | ||
| GDF_CUST_PROF_ATTRIBUTE7 | VARCHAR2 | 150 | Oracle internal use only. Global descriptive Flexfield Column for Customer profiles. | ||
| GDF_CUST_PROF_ATTRIBUTE8 | VARCHAR2 | 150 | Oracle internal use only. Global descriptive Flexfield Column for Customer profiles. | ||
| GDF_CUST_PROF_ATTRIBUTE9 | VARCHAR2 | 150 | Oracle internal use only. Global descriptive Flexfield Column for Customer profiles. | ||
| GDF_CUST_PROF_ATTRIBUTE10 | VARCHAR2 | 150 | Oracle internal use only. Global descriptive Flexfield Column for Customer profiles. | ||
| GDF_CUST_PROF_ATTRIBUTE11 | VARCHAR2 | 150 | Oracle internal use only. Global descriptive Flexfield Column for Customer profiles. | ||
| GDF_CUST_PROF_ATTRIBUTE12 | VARCHAR2 | 150 | Oracle internal use only. Global descriptive Flexfield Column for Customer profiles. | ||
| GDF_CUST_PROF_ATTRIBUTE13 | VARCHAR2 | 150 | Oracle internal use only. Global descriptive Flexfield Column for Customer profiles. | ||
| GDF_CUST_PROF_ATTRIBUTE14 | VARCHAR2 | 150 | Oracle internal use only. Global descriptive Flexfield Column for Customer profiles. | ||
| GDF_CUST_PROF_ATTRIBUTE15 | VARCHAR2 | 150 | Oracle internal use only. Global descriptive Flexfield Column for Customer profiles. | ||
| GDF_CUST_PROF_ATTRIBUTE16 | VARCHAR2 | 150 | Oracle internal use only. Global descriptive Flexfield Column for Customer profiles. | ||
| GDF_CUST_PROF_ATTRIBUTE17 | VARCHAR2 | 150 | Oracle internal use only. Global descriptive Flexfield Column for Customer profiles. | ||
| GDF_CUST_PROF_ATTRIBUTE18 | VARCHAR2 | 150 | Oracle internal use only. Global descriptive Flexfield Column for Customer profiles. | ||
| GDF_CUST_PROF_ATTRIBUTE19 | VARCHAR2 | 150 | Oracle internal use only. Global descriptive Flexfield Column for Customer profiles. | ||
| GDF_CUST_PROF_ATTRIBUTE20 | VARCHAR2 | 150 | Oracle internal use only. Global descriptive Flexfield Column for Customer profiles. | ||
| LOCKBOX_MATCHING_OPTION | VARCHAR2 | 30 | Lockbox matching option. Use Manage Receivables Lookups task, lookup type ARLPLB_MATCHING_OPTION to identify valid values. | ||
| AUTOCASH_HIERARCHY_NAME_ADR | VARCHAR2 | 30 | Autocash rule set name for remainder balance. Use Manage Autocash Rule Sets task to identify valid values. | ||
| CREDIT_CLASSIFICATION | VARCHAR2 | 30 | Measure of customer credit worthiness. Use Manage Receivables Customer Profile Classes to identify valid values. | ||
| CONS_BILL_LEVEL | VARCHAR2 | 30 | Balance forward bill level. Valid values: ACCOUNT, SITE. Required if CONS_INV_FLAG is Y. | ||
| LATE_CHARGE_CALCULATION_TRX | VARCHAR2 | 30 | Late charges for overdue invoices and late payments. Use Manage Receivables Lookups task, lookup type AR_MANDATORY_LATE_CHARGES to identify valid values. Required if CONS_INV_FLAG is Y. | ||
| CREDIT_ITEMS_FLAG | VARCHAR2 | 1 | Apply credit items to overdue balances and late charges. Valid values: Y, N. | ||
| DISPUTED_TRANSACTIONS_FLAG | VARCHAR2 | 1 | Late charges for disputed items. Valid values: Y, N. | ||
| LATE_CHARGE_TYPE | VARCHAR2 | 30 | Late charges calculation type. Use Manage Receivables Lookups, lookup type AR_LATE_CHARGE_TYPE to identify valid values. | ||
| LATE_CHARGE_TERM_ID | NUMBER | 18 | Oracle internal use only. Late charge transaction payment term identifier. | ||
| INTEREST_CALCULATION_PERIOD | VARCHAR2 | 30 | Period used to calculate late charges. Use Manage Receivables Lookups, lookup type AR_CALCULATION_PERIOD to identify valid values. | ||
| HOLD_CHARGED_INVOICES_FLAG | VARCHAR2 | 1 | Late charges can be calculated more than once. Valid values: Y, N. | ||
| MESSAGE_TEXT_ID | NUMBER | 18 | Oracle internal use only. | ||
| MULTIPLE_INTEREST_RATES_FLAG | VARCHAR2 | 1 | Interest and penalty charges can be calculated using multiple rates for a single late charge period. Valid values: Y, N. | ||
| CHARGE_BEGIN_DATE | DATE | Late charges start date. Date format: YYYY/MM/DD. | |||
| EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Conversion rate type. Use Manage Conversion Rate Types task to identify valid values. | ||
| MIN_FC_INVOICE_OVERDUE_TYPE | VARCHAR2 | 30 | Minimum invoice balance overdue type. Use Manage Receivables Lookups task, lookup type AR_AMOUNT_PERCENT to identify valid values. | ||
| MIN_FC_INVOICE_PERCENT | NUMBER | Minimum invoice balance overdue percent. Use comma as thousands separator. Use either comma or period as decimal separator. Must be between 0 and 100. | |||
| MIN_FC_BALANCE_OVERDUE_TYPE | VARCHAR2 | 30 | Minimum customer balance overdue type. Use Manage Receivables Lookups task, lookup type AR_AMOUNT_PERCENT to identify valid values. | ||
| MIN_FC_BALANCE_PERCENT | NUMBER | Minimum customer balance overdue percent. Use comma as thousands separator. Use either comma or period as decimal separator. Must be between 0 and 100. | |||
| INTEREST_TYPE | VARCHAR2 | 30 | Interest charge type. Use Manage Receivables Lookups, lookup type AR_INTEREST_PENALTY_TYPE to identify valid values. | ||
| INTEREST_FIXED_AMOUNT | NUMBER | Interest charge amount. Use comma as thousands separator. Use either comma or period as decimal separator. Must be greater than 0. | |||
| INTEREST_SCHEDULE_ID | NUMBER | 18 | Interest charge schedule identifier. Use Manage Charge Schedules task to identify valid values. | ||
| PENALTY_TYPE | VARCHAR2 | 30 | Penalty calculation type. Use Manage Receivables Lookups, lookup type AR_INTEREST_PENALTY_TYPE to identify valid values. | ||
| PENALTY_RATE | NUMBER | Penalty rate. Use if FIXED_RATE is RATE. Must be between 0 and 100. | |||
| MIN_INTEREST_CHARGE | NUMBER | Minimum amount below which late charge must not be charged. Enter amount based on currency value from CURRENCY_CODE. Must be greater than 0. | |||
| PENALTY_FIXED_AMOUNT | NUMBER | Penalty charge amount. Must be greater than 0. | |||
| PENALTY_SCHEDULE_ID | NUMBER | 18 | Penalty charge schedule identifier. Use Manage Charge Schedules task to identify valid values. | ||
| EXCEPTION_RULE_NAME | VARCHAR2 | 30 | Set of rules that determines how to manage remaining over and under application amounts after Lockbox processes receipts | ||
| AUTOMATCH_RULE_NAME | VARCHAR2 | 30 | Set of rules that determines how receipts are matched automatically for the customer | ||
| MATCH_BY_AUTOUPDATE_FLAG | VARCHAR2 | 1 | Indicates if AutoApply process can update the Match Receipt By value for the customer | ||
| PREF_CONTACT_METHOD | VARCHAR2 | 30 | Preferred correspondence method for the customer interaction. Valid system predefined values are PRINT, EMAIL, and FAX. Default value is PRINT | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| LOAD_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID for the Customer Import job that created the row. | ||
| FILE_RECORD_NUM | NUMBER | 10 | This column is used by the import wizard to relate a record in the interface table to the file row. | ||
| CREDIT_ANALYST_NAME | VARCHAR2 | 240 | Name of the credit analyst associated with this customer profile. | ||
| CREDIT_REVIEW_CYCLE | VARCHAR2 | 20 | The period of a customer credit review cycle. It is based on a list of values from the Lookup to user defined values in AR_LOOKUPS table. Review Cycle must be predefined in the lookup type ORA_AR_CMGT_REVIEW_PERIOD. | ||
| LAST_CREDIT_REVIEW_DATE | DATE | Date of last customer profile data review. | |||
| NEXT_CREDIT_REVIEW_DATE | DATE | The next date that credit will be reviewed. | |||
| B2B_TP_CODE | VARCHAR2 | 80 | Identifies the customer with a trading partner in a business-to-business relationship | ||
| OFFSET_DAYS | NUMBER | 18 | Number of days that used to calculate the expiration date of the authorization, default value is 5. | ||
| PRINTING_OPTION_CODE | VARCHAR2 | 30 | Code that indicates if customer receives printed transactions. | ||
| STMT_DELIVERY_METHOD | VARCHAR2 | 30 | Method of delivering statements to the customer. Valid values are E-Mail,PRINT and XML. | ||
| TXN_DELIVERY_METHOD | VARCHAR2 | 30 | Method of delivering transactions to the customer. Valid values are PRINT and XML. | ||
| XML_CB_FLAG | VARCHAR2 | 1 | Option to send chargebacks to customers in XML format. | ||
| XML_CM_FLAG | VARCHAR2 | 1 | Option to send credit memos to customers in XML format. | ||
| XML_DM_FLAG | VARCHAR2 | 1 | Option to send debit memos to customers in XML format. | ||
| XML_INV_FLAG | VARCHAR2 | 1 | Option to send invoices to customers in XML format. | ||
| SERVICE_PROVIDER_NAME | VARCHAR2 | 256 | Name of the B2B messaging service provider. | ||
| PARTNER_ID | VARCHAR2 | 100 | User-defined code that identifies a customer account as a trading partner to receive XML transactions. You must also use the PARTNER_ID_TYPE_CODE attribute to indicate which category this identifier belongs to. | ||
| PARTNER_ID_TYPE_CODE | VARCHAR2 | 100 | Labeling category for the identifier that you used to define the trading partner in the PARTNER_ID attribute. Valid values are: DUNS, Generic (typically the customer account number), GLN, MISC, PHONE, TAXID, Name (typically the customer account name). | ||
| AR_OUTBOUND_TRANSACTION_FLAG | VARCHAR2 | 1 | Option that indicates whether the trading partner is enabled to receive Receivables transactions in XML format. | ||
| AR_INBOUND_CONFIRM_BOD_FLAG | VARCHAR2 | 1 | Option that indicates whether the trading partner is enabled to send back a confirmation business object document after receiving an XML transaction. | ||
| CMK_CONFIG_FLAG | VARCHAR2 | 1 | Option that indicates whether the customer import includes the collaboration messaging configuration for the customer account. | ||
| CMK_REQUEST_ID | NUMBER | 18 | Request ID generated by a run of the Import Collaboration Messaging Setup Data program invoked by the collaboration messaging framework. | ||
| ACCOUNT_NUMBER | VARCHAR2 | 30 | Account Number | ||
| PARTY_NUMBER | VARCHAR2 | 30 | Unique identification number for a party. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| RA_CUST_PROFILES_INTERFACE_N1 | Non Unique | Default | CUST_ORIG_SYSTEM, CUST_ORIG_SYSTEM_REFERENCE |
| RA_CUST_PROFILES_INTERFACE_N2 | Non Unique | Default | CUST_SITE_ORIG_SYSTEM, CUST_SITE_ORIG_SYS_REF |
| RA_CUST_PROFILES_INTERFACE_N3 | Non Unique | Default | BATCH_ID, INTERFACE_STATUS, FILE_RECORD_NUM |