This appendix describes the seeded data points in Oracle Credit Management.
This appendix covers the following topics:
This appendix includes a list of the seeded data points that Oracle Credit Management provides:
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? |
---|---|---|---|---|---|---|
Bond Rating | No | Yes | ar_cmgt_credit_requests | bond_rating | User-entered | |
Business Entity Type | No | Yes | ar_lookups | lookup_code | User-entered | |
Count of Pending Litigations | No | Yes | ar_cmgt_credit_requests | pending_litigation_count | User-entered | |
Credit Exposure | ? | ? | ? | ? | ||
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 |
Current Stock Price | No | Yes | ar_cmgt_credit_requests | User-entered | ||
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 |
Industrial Code | No | Yes | hz_parties | sic_code_type | Automatic | No |
Industrial Code Number | No | Yes | hz_parties | sic_code | Automatic | No |
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 | |
Market Capitalization | No | Yes | ar_cmgt_credit_requests | User-entered | ||
Number of Employees | Yes | Yes | hz_parties | employees_total | Automatic | No |
Order Amount On Credit Hold | Yes | Yes | OM_API | |||
Overall Credit Limit | Yes | No | hz_credit_profile_amounts | overall_credit_limit | Automatic | No |
Requested Amount | Yes | No | ar_cmgt_case_folders | User-entered | ||
Stock Exchange | No | Yes | ar_cmgt_credit_requests | stock_exchange | User-entered | |
Stock Symbol | No | Yes | ar_cmgt_credit_requests | User-entered | ||
Tax Name | No | Yes | hz_parties | tax_name | Automatic | No |
Transaction Credit Limit | Yes | No | hz_credit_profile_amounts | trx_credit_limit | Automatic | No |
URL | No | Yes | hz_parties | URL | Automatic | No |
VAT Registration Number | No | Yes | ||||
Year Established | Yes | Yes | hz_parties | year_established | Automatic | No |
Related Topics
Oracle Credit Management Data Points
This table includes the Financial 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
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 |
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 |
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 |
No | Yes | ar_cmgt_trade_ref_data | ||
URL | No | Yes | ar_cmgt_trade_ref_data | URL |
Related Topics
Oracle Credit Management 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
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 |
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
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
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
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