Skip Headers

Oracle Credit Management User Guide
Release 12.1
Part Number E13502-04
Go to Table of Contents
Contents
Go to previous page
Previous
Go to next page
Next

Oracle Credit Management Data Points

This appendix describes the seeded data points in Oracle Credit Management.

This appendix covers the following topics:

Oracle Credit Management Data Points

This appendix includes a list of the seeded data points that Oracle Credit Management provides:

Business Information and Credit Data Points

This table includes the Business Information and Credit data points. The data point category is Credit.

Data Point Scorable? Checklist Setup Source Table Source Column User-entered, Automatic, or D&B If Automatic, Time-Sensitive?
Transaction Credit Limit Yes No hz_credit_profile_amounts trx_credit_limit Automatic No
Overall Credit Limit Yes No hz_credit_profile_amounts overall_credit_limit Automatic No
Tax Name No Yes hz_parties tax_name Automatic No
Business Entity Type No Yes ar_lookups lookup_code User-entered  
Year Established No Yes hz_parties year_established Automatic No
Industrial Code No Yes hz_parties sic_code_type Automatic No
Industrial Code Number No Yes hz_parties sic_code Automatic No
Bond Rating No Yes ar_cmgt_credit_requests bond_rating User-entered  
Count of Pending Litigations Yes Yes ar_cmgt_credit_requests pending_litigation_count User-entered  
Stock Symbol No Yes ar_cmgt_credit_requests   User-entered  
Stock Exchange No Yes ar_cmgt_credit_requests stock_exchange User-entered  
Current Stock Price No Yes ar_cmgt_credit_requests   User-entered  
Market Capitalization Yes Yes ar_cmgt_credit_requests   User-entered  
URL No Yes hz_parties url Automatic No
Number of Employees Yes Yes hz_parties employees_total Automatic No
Order Amount On Credit Hold Yes Yes OM_API      
High Credit Amount Yes Yes ar_trx_summary op_bal_high_water_mark Automatic Yes
High Credit Date No Yes ar_trx_summary op_bal_high_water-mark_date Automatic Yes
Last Credit Review Date No Yes ar_cmgt_case_folders   Automatic No
Last Calculated Credit Score Yes Yes ar_cmgt_case_folders   Automatic No
Last Case Folder No Yes ar_cmgt_case_folders   Automatic No
Last Checklist Used No Yes ar_cmgt_case_folders   Automatic No
Requested Amount Yes No ar_cmgt_case_folders   User-entered  
Current Receivables Balance Yes Done ar_trx_bal_summary OP_INVOICE_VALUE +OP_DEBIT_MEMOS_VALUE +OP_BILLS_RECEIVABLES_VALUE +OP_CHARGEBACK_VALUE +OPEN_CREDIT_MEMOS_VALUE +UNRESOLVED_CASH_VALUE Automatic No
VAT Registration Number No Yes        

Related Topics

Oracle Credit Management Data Points

Financial Data Data Points

This table includes the Financial Data data points. The data point category is Credit. All data points are user-entered and none are time-sensitive.

Data Point Scorable? Checklist Setup Source Table Source Column
Reporting Currency No Yes AR_CMGT_FINANCIAL_DATA reporting_currency
Monetary Unit No Yes AR_CMGT_FINANCIAL_DATA monetary_unit
Financial Statement Date No Yes AR_CMGT_FINANCIAL_DATA curr_fin_st_date
Reporting Period No Yes AR_CMGT_FINANCIAL_DATA reporting_period
Cash Yes Yes AR_CMGT_FINANCIAL_DATA cash
Net Receivables Yes Yes AR_CMGT_FINANCIAL_DATA net_receivables
Inventories Yes Yes AR_CMGT_FINANCIAL_DATA inventories
Other Current Assets Yes Yes AR_CMGT_FINANCIAL_DATA other_curr_assets
Total Current Assets Yes Yes AR_CMGT_FINANCIAL_DATA total_cur_assets
Net Fixed Assets Yes Yes AR_CMGT_FINANCIAL_DATA net_fixed_assets
Short-Term Investments No No    
Intangible Assets No No    
Goodwill No No    
Retained Earnings No No    
Common Stock No No    
Preferred Stock No No    
Other Noncurrent Assets Yes Yes AR_CMGT_FINANCIAL_DATA other_non_cur_assets
Total Assets Yes Yes AR_CMGT_FINANCIAL_DATA total_assets
Accounts Payable Yes Yes AR_CMGT_FINANCIAL_DATA accounts_payable
Short-Term Debt Yes Yes AR_CMGT_FINANCIAL_DATA short_term_debt
Other Current Liabilities Yes Yes AR_CMGT_FINANCIAL_DATA other_cur_liabilities
Total Current Liabilities Yes Yes AR_CMGT_FINANCIAL_DATA total_cur_liabilities
Long-Term Debt Yes Yes AR_CMGT_FINANCIAL_DATA long_term_debt
Other Noncurrent Liabilities Yes Yes AR_CMGT_FINANCIAL_DATA other_non_cur_liabilities
Total Liabilities Yes Yes AR_CMGT_FINANCIAL_DATA total_liabilities
Stockholder's Equity Yes Yes AR_CMGT_FINANCIAL_DATA stockholder_equity
Total Liabilities and Equity Yes Yes AR_CMGT_FINANCIAL_DATA total_liabilities_equity
Revenue Yes Yes AR_CMGT_FINANCIAL_DATA revenue
Cost of Goods Sold Yes Yes AR_CMGT_FINANCIAL_DATA cost_of_goods_sold
General & Administrative Expense Yes Yes AR_CMGT_FINANCIAL_DATA sga_expenses
Operating Income Yes Yes AR_CMGT_FINANCIAL_DATA operating_income
Operating Margin Yes Yes AR_CMGT_FINANCIAL_DATA operating_margin
Nonoperating Income Yes Yes AR_CMGT_FINANCIAL_DATA non_operating_income
Nonoperating Expenses Yes Yes AR_CMGT_FINANCIAL_DATA non_operating_expenses
Income Before Taxes Yes Yes AR_CMGT_FINANCIAL_DATA pre_tax_net_income
Income Taxes Yes Yes AR_CMGT_FINANCIAL_DATA income_taxes
Net Income Yes Yes AR_CMGT_FINANCIAL_DATA net_income
Earnings Per Share Yes Yes AR_CMGT_FINANCIAL_DATA earnings_per_share
Depreciation Expense No No    
Amortization Expense No No    
Extraordinary Gains No No    
Extraordinary Losses No No    
Interest Income No No    
Interest Expense No No    
Dividends No No    
Cash Flow from Operations No No    
Current Ratio No No    
Quick Ratio No No    
Net working capital No No    
Gross Profit No No    
Operating Profit No No    
Profit Margin No No    

Related Topics

Oracle Credit Management Data Points

References Data Points

This table includes the References data points. The data point category is Reference. All data points are user-entered and none are time-sensitive.

Data Point Scorable? Checklist Setup
Number of Bank References No Yes
Number of Trade References No Yes
Guarantors No Yes
Venture Funding No Yes
Collateral No Yes

Bank References Data Points

This table includes the Bank References data points. The data point category is Reference and all data points are displayed in the case folder. All data points are user-entered and none are time-sensitive.

Data Point Scorable? Checklist Setup Source Table Source Column
Bank Name No Yes ar_cmgt_bank_ref_data bank_name
Bank Address No Yes ar_cmgt_bank_ref_data address
City No Yes ar_cmgt_bank_ref_data city
State No Yes ar_cmgt_bank_ref_data state
Postal Code No Yes ar_cmgt_bank_ref_data postal_code
Province No Yes ar_cmgt_bank_ref_data province
Bank Routing Number No Yes ar_cmgt_bank_ref_data bank_routing_number
Country No Yes ar_cmgt_bank_ref_data country
Contact No Yes ar_cmgt_bank_ref_data contact_name
Contact Telephone No Yes ar_cmgt_bank_ref_data phone
Account Number No Yes ar_cmgt_bank_ref_accts account_number
Account Type No Yes ar_lookups lookup_code = account_type
Date Opened No Yes ar_cmgt_bank_ref_accts date_opened
Balance Date No Yes ar_cmgt_bank_ref_accts balance_date
Current Balance Yes No ar_cmgt_bank_ref_accts current_balance
Average Balance Yes No ar_cmgt_bank_ref_accts average_balance

Trade References Data Points

This table includes the Trade References data points. The data point category is Reference and all data points are displayed in the case folder. All data points are user-entered and none are time-sensitive.

Data Point Scorable? Checklist Setup Source Table Source Column
Reference Name No Yes ar_cmgt_trade_ref_data reference_name
Last Transaction Date No Yes ar_cmgt_trade_ref_data last_transaction_date
Payment Terms No Yes ar_cmgt_trade_ref_data payment_terms
Number of Years in Trade No Yes ar_cmgt_trade_ref_data number_of_years_in_trade
Credit Currency No Yes ar_cmgt_trade_ref_data currency
Report Date No Yes ar_cmgt_trade_ref_data report_date
Credit Type No Yes ar_cmgt_trade_ref_data credit_type
Credit Limit Yes No ar_cmgt_trade_ref_data credit_limit
Credit Balance Yes No ar_cmgt_trade_ref_data credit_balance
Amount Owed Yes No ar_cmgt_trade_ref_data amount_owed
Past Due Amount Yes No ar_cmgt_trade_ref_data past_due_amount
Address No Yes ar_cmgt_trade_ref_data address
City No Yes ar_cmgt_trade_ref_data city
State No Yes ar_cmgt_trade_ref_data state
Postal Code No Yes ar_cmgt_trade_ref_data postal_code
Country No Yes ar_cmgt_trade_ref_data country
Province No Yes ar_cmgt_trade_ref_data province
Tax Number No Yes ar_cmgt_trade_ref_data tax_number
Contact No Yes ar_cmgt_trade_ref_data contact_name
Phone No Yes ar_cmgt_trade_ref_data phone_number
Fax No Yes ar_cmgt_trade_ref_data fax_number
Email No Yes ar_cmgt_trade_ref_data email
URL No Yes ar_cmgt_trade_ref_data url

Related Topics

Oracle Credit Management Data Points

Guarantors Data Points

This table includes the Guarantors data points. The data point category is Reference and all data points are displayed in the case folder. All data points are user-entered and none are time-sensitive.

Data Point Scorable? Checklist Setup Source Table Source Column
Order Identifier No No ar_cmgt_guarantor_data  
Currency No No ar_cmgt_guarantor_data currency
Guarantee Available From Date No No ar_cmgt_guarantor_data funding_available_from
Guarantee Available To Date No No ar_cmgt_guarantor_data funding_available_to
Primary Flag No No ar_cmgt_guarantor_data  
Guaranteed Amount Yes No ar_cmgt_guarantor_data guaranteed_amount
Order Amount Yes No ar_cmgt_guarantor_data  

Related Topics

Oracle Credit Management Data Points

Venture Funding Data Points

This table includes the Venture Funding data points. The data point category is Reference and all data points are displayed in the case folder. All data points are user-entered and none are time-sensitive.

Data Point Scorable? Checklist Setup
Country No No
Venture Capital Name No No, Required
Address No No
Province/State No No
Postal Code No No
Key Executive No No
Contact No No
Phone No No
Fax No No
Email No No
Funding Amount Yes No
Burn Rate Yes No
Currency No No
Percent Invested Yes No
Describe Future Funding Plans No No
Notes No No
Capital Stage No No
Balance Yes Yes

Related Topics

Oracle Credit Management Data Points

Collateral Data Points

This table includes the Collateral data points. The data point category is Reference and all data points are displayed in the case folder. All data points are user-entered and none are time-sensitive.

Data Point Scorable? Checklist Setup Source Table Source Column
Description No Yes, Required ar_cmgt_collateral_data description
Category No Yes, Required ar_cmgt_collateral_data category
Value of Collateral Yes Yes, Required ar_cmgt_collateral_data value
Currency No Yes, Required ar_cmgt_collateral_data currency
Valuation Type No No ar_cmgt_collateral_data type
Valuation Date No No ar_cmgt_collateral_data valuation_date
Previous Valuation Date No No ar_cmgt_collateral_data previous_valuation_date
Appraiser No No ar_cmgt_collateral_data appraiser
Appraiser Phone Number No No ar_cmgt_collateral_data appraiser_phone
Location of Collateral No No ar_cmgt_collateral_data location
Notes No No ar_cmgt_collateral_data notes

Related Topics

Oracle Credit Management Data Points

Billing and Payments Data Points

This table includes the Billing and Payments data points that are not time-sensitive. All data points are automatically derived. The data point category is Invoice.

Data Point Scorable? Checklist Setup Source Table Source Column Calculations
Days Sales Outstanding Yes Yes ar_trx_bal_summary (sum(current_receivables) * cer_dso_days)/sum(total_dso_days_credit) FROM SYSTEM OPTIONS SETUP. (Sum of all opening Balances * Number of days Days Sales Outstanding from ar_cmgt_setup_options ) / Sum of all transactions based on DSO days(from ar_cmgt_setup_options) from ar_trx_summary
Delinquent Days Sales Outstanding Yes Yes ar_trx_bal_summary SUM(DSO) - SUM(BEST_DSO) SAME PERIOD AS DSO. ((Sum of all opening Balances - amount_due_remaining on open payment schedules (installments) of all transactions )* Number of days Days Sales Outstanding from ar_cmgt_setup_options ) / Sum of all transactions based on DSO days(from ar_cmgt_setup_options) from ar_trx_summary
Unapplied Cash Amount Yes Yes ar_trx_bal_summary unresolved_cash_value sum of unresolved cash available on all the Cash Receipts
Unapplied Cash Count Yes Yes ar_trx_bal_summary unresolved_cash_count count of unresolved cash available on all the Cash Receipts

This table includes the Billing and Payments data points that are time-sensitive. All data points are automatically derived. The data point category is Invoice.

Data Point Scorable? Checklist Setup Source Table Source Column Calculations
Weighted Average Days Paid Yes Yes ar_trx_summary sum(inv_inst_pmt_days_sum)/sum(COUNT_OF_TOT_INV_INST_PAID) Summation of the product of number of days to make payments against invoice installments / Sum of the amount applied against the closed payment schedules (installments) of all the Invoices
Weighted Average Days Paid Late Yes Yes ar_trx_summary sum(sum_app_amt_days_late)/sum(sum_of_app_amt) Summation of the product of amount applied and the difference in apply date and due date for all cash receipt applications against the Invoices Installments / Sum of the amount applied against the closed payment schedules (installments) of all the Invoices
High Credit Amount Yes Yes ar_trx_summary op_bal_high_watermark This column value contains the highest Open Receivables Balance for the specific Account, Site, Currency and date (identified by as_of_date).
High Credit Date No Yes ar_trx_summary op_bal_high_watermark_date Highest Open receivables date
Weighted Days Credit Granted Yes Yes ar_trx_summary sum(days_credit_granted_sum)/sum(COUNT_OF_TOT_INV_INST_PAID) Summation of the product of amount_due_original and difference of the due_date and trx_date / Sum of the amount_due_original on payment schedules (installments) of all Invoices
Last Payment Amount Yes Yes ar_trx_summary last_payment_amount Amount of the most recent cash receipt (based on receipt date)
Last Payment Date No Yes ar_trx_summary last_payment_date Date of the most recent cash receipt (based on receipt date)
Cash Receipts Amount Yes Yes ar_trx_summary total_cash_receipts_value Sum of the amounts of all Cash Receipts
Cash Receipts Count Yes Yes ar_trx_summary total_cash_receipts_count Count of payment schedules (installments) of all cash receipts
Invoices Amount Yes Yes ar_trx_summary total_invoices_value Sum of the amount_due_original on payment schedules (installments) of all Invoices
Invoices Count Yes Yes ar_trx_summary total_invoices_count Count of the payment schedules (installments) of all Invoices
Bills Receivables Amount Yes Yes ar_trx_summary total_bills_receivables_value Sum of the amount_due_original on payment schedules (installments) of all Bills Receivables
Bills Receivables Count Yes Yes ar_trx_summary total_bills_receivables_count Count of payment schedules (installments) of all Bills Receivables
Debit Memos Amount Yes Yes ar_trx_summary total_debit_memos_value Sum of the amount_due_original on payment schedules (installments) of all Debit Memos
Debit Memos Count Yes Yes ar_trx_summary total_debit_memos_count Count of payment schedules (installments) of all Debit Memos
Chargebacks Amount Yes Yes ar_trx_summary total_chargeback_value Sum of the amount_due_original on payment schedules (installments) of all Chargebacks
Chargebacks Count Yes Yes ar_trx_summary total_chargeback_count Count of payment schedules (installments) of all Chargebacks
Adjustments Amount Yes Yes ar_trx_summary total_adjustments_value Sum of the adjustment amounts on the payment schedules of all the debit items
Adjustments Count Yes Yes ar_trx_summary total_adjustments_count Count of the adjustments on the payment schedules of all the debit items
Deposits Amount Yes Yes ar_trx_summary total_deposits_value Sum of the amount_due_original on payment schedules (installments) of all Deposits
Deposits Count Yes Yes ar_trx_summary total_deposits_count Count of payment schedules (installments) of all Deposits
NSF/Stop Payment Count Yes Yes ar_trx_summary nsf_stop_payment_count Count of all cash receipts having a status of Reversed with a Reversal Category of Non Sufficient Funds
NSF/Stop Payment Amount Yes Yes ar_trx_summary nsf_stop_payment_amount Sum of the amount on all Cash Receipts having a status of Reversed with a Reversal Category of Non Sufficient Funds
Pending Orders Amount Yes Yes ar_trx_summary    
Credit Memos Amount Yes Yes ar_trx_summary total_credit_memos_value Sum of the amount_due_original on payment schedules (installments) of all Credit Memos
Credit Memos Count Yes Yes ar_trx_summary total_credit_memos_count Count of payment schedules (installments) of all Credit Memos
Largest Invoice Amount Yes Yes ar_trx_summary largest_inv_amount Transaction amount corresponding to the largest invoice
Largest Invoice Date No Yes ar_trx_summary largest_inv_date Transaction date corresponding to the largest invoice
Percentages Of Invoices Paid Promptly Yes Yes ar_trx_summary ((count_of_inv_inst_paid - count_of_inst_inv_inst_paid_late)/count_of_inv_inst_paid)*100 (Count of the payment schedules (installments), that have been paid off completely - Count of the payment schedules (installments) that have been paid late) * 100 / Count of the payment schedules (installments), that have been paid off completely
Percentages Of Invoices Paid Late Yes Yes ar_trx_summary (count_of_inst_inv_inst_paid_late/count_of_inv_inst_paid)*100 (Count of the payment schedules (installments) that have been paid late * 100) / Count of the payment schedules (installments), that have been paid off completely
Percentage of Invoices with Discount Taken Yes Yes ar_trx_summary count_of_disc_inv_inst (Count of the payment schedules (installments) with earned or unearned discounts applied to Invoices * 100)/Count of the payment schedules (installments), that have been paid off completely
Invoices paid Amount Yes Yes ar_trx_summary inv_paid_amount Sum of the total amount paid against closed invoices
Installment Invoices Paid Count Yes Yes ar_trx_summary count_of_tot_inst_inv_paid Count of the payment schedules (installments), that have been paid off completely
Earned Discount Amount Yes Yes ar_trx_summary total_earned_disc_value Sum of the Earned Discounts that were given on the closed payment schedules (installments) of all invoices
Earned Discount Count Yes Yes ar_trx_summary total_earned_disc_count Count of the Earned Discounts that were given on the closed payment schedules (installments) of all invoices
Unearned Discount Amount Yes Yes ar_trx_summary total_unearned_disc_value Sum of the Unearned Discounts that was given on the closed payment schedules (installments) of all invoices
Unearned Discount Count Yes Yes ar_trx_summary total_unearned_disc_count Count of the Unearned Discounts that were given on the closed payment schedules (installments) of all invoices

Related Topics

Oracle Credit Management Data Points

Aging Data Points

This table includes the Aging data points that are not time-sensitive. All data points are automatically derived. The data point category is Aging.

Note: Aging buckets and their values are available for the checklist, but the bucket names and the number of buckets are based upon Credit Management system option settings.

Data Point Scorable? Checklist Setup Source Table Source Column Calculations
Total Past Due Yes Yes ar_trx_bal_summary    
Open Invoices Amount Yes Yes ar_trx_bal_summary op_invoices_value sum of amount_due_remaining on open payment schedules (installments) of all the Invoices
Open Invoices Count Yes Yes ar_trx_bal_summary op_invoices_count count of the open payments schedules (installments) of all the Invoices
Open Debit Memos Amount Yes Yes ar_trx_bal_summary op_debit_memos_value sum of amount_due_remaining on open payment schedules (installments) of all the Debit Memos
Open Debit Memos Count Yes Yes ar_trx_bal_summary op_debit_memos_count count of the open payments schedules (installments) of all the Debit Memos
Open Deposits Amount Yes Yes ar_trx_bal_summary op_deposits_value sum of amount_due_remaining on open payment schedules (installments) of all the Deposits
Open Deposits Count Yes Yes ar_trx_bal_summary op_deposits_count count of the open payments schedules (installments) of all the Deposits
Open Bills Receivables Amount Yes Yes ar_trx_bal_summary op_bills_receivables_value sum of amount_due_remaining on open payment schedules (installments) of all the Bills Receivables
Open Bills Receivables Count Yes Yes ar_trx_bal_summary op_bills_receivables_count count of the open payments schedules (installments) of all the Bills Receivables
Open Chargeback Amount Yes Yes ar_trx_bal_summary op_chargeback_value sum of amount_due_remaining on open payment schedules (installments) of all the Chargebacks
Open Chargeback Count Yes Yes ar_trx_bal_summary op_chargeback_count count of the open payments schedules (installments) of all the Chargebacks
Open Credit Memos Amount Yes Yes ar_trx_bal_summary op_credit_memos_value sum of amount_due_remaining on open payment schedules (installments) of all the Credit Memos
Open Credit Memos Count Yes Yes ar_trx_bal_summary op_credit_memos_count count of the open payments schedules (installments) of all the Credit Memos
Past Due Invoice Amount Yes Yes ar_trx_bal_summary past_due_inv_value sum of the amount_due_remaining of the open payments schedules (installments) of all the Invoices
Past Due Invoice Count Yes Yes ar_trx_bal_summary past_due_inv_inst_count count of the open payments schedules (installments) of all the Invoices
Disputed Invoice Amount Yes Yes ar_trx_bal_summary inv_amt_in_dispute sum of the amount in dispute on open payment schedules (installments) of all the invoices
Disputed Invoice Count Yes Yes ar_trx_bal_summary disputed_inv_count count of open payment schedules (installments) of all Invoices
Last Interest Invoice Amount Yes Yes     transaction type = 'Interest Invoice'
Last interest Invoice Count Yes Yes     transaction type = 'Interest Invoice'
Interest Paid Yes Yes     sum(amount_due_original - amount_due_remaining) where transaction type = 'Interest Invoice'
Last Interest invoice Date No Yes     transaction type = 'Interest Invoice'
Pending Adjustments Amount Yes Yes ar_trx_bal_summary pending_adj_value sum of the adjustment amounts on all debit items
Last Dunning Letter Date No Yes ar_trx_bal_summary last_dunning_date Max. Corrrespondence_date for correspondence_type='DUNNING'
Receipts at risk amount Yes Yes ar_trx_bal_summary receipts_at_risk_value sum of cash receipt amounts
Dunning letter count No Yes ar_trx_bal_summary dunning_count Count of Correspondence type = 'DUNNING'

Related Topics

Oracle Credit Management Data Points