Credit Rating
The trading community member's credit rating information.
QName: {http://xmlns.oracle.com/apps/cdm/foundation/parties/partyService/}CreditRating
Relationships
The following table describes how this service data object is related to other service data objects or business object services.
| Relationship Type | Object or Service |
|---|---|
|
Contains |
|
|
Contained by |
|
|
Contained by |
|
|
Handled by |
|
|
Handled by |
|
|
Handled by |
|
|
Handled by |
|
|
Handled by |
|
|
Handled by |
|
|
Handled by |
|
|
Handled by |
Attributes
The following table describes attributes in the service data object.
| Name | Type | Description |
|---|---|---|
|
AverageHighCredit |
decimal |
The average of all the high credit experiences. |
|
BankruptcyInd |
string |
Indicates if open bankruptcy exists. Y stands for any open bankruptcy that exists and N stands for no open bankruptcy. |
|
BusinessDiscontinued |
string |
The business discontinued at the listed location. Prompts reader to contact D and B customer service center if any business is operating. |
|
ClaimsInd |
string |
Indicates if open claims, legal claims, liens, protested bills, or any equivalent information exists. Y stands for availability of information and N stands for no information. |
|
Comments |
string |
The comments for the record. |
|
CreatedBy |
string |
The user who created the record. |
|
CreatedByModule |
string |
The module that created the record. |
|
CreationDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The date when the record was created. |
|
CreditRatingId |
long |
The unique identifier of the credit rating.
|
|
CreditRiskScoreExplain |
string |
Explains numeric credit risk score that estimates the risk of delinquent payment over the next 12 months. |
|
CreditScore |
string |
Indicates the risk of delinquent payments. |
|
CreditScoreAge |
decimal |
Indicates the age of the credit score expressed in months. |
|
CreditScoreClass |
decimal |
The date when the credit score was calculated. |
|
CreditScoreCommentary |
string |
The lookup for explanation codes in the CREDIT_SCORE column. |
|
CreditScoreCommentary10 |
string |
Indicates comments about the credit score. |
|
CreditScoreCommentary2 |
string |
Indicates comments about the credit score. |
|
CreditScoreCommentary3 |
string |
Indicates comments about the credit score. |
|
CreditScoreCommentary4 |
string |
Indicates comments about the credit score. |
|
CreditScoreCommentary5 |
string |
Indicates comments about the credit score. |
|
CreditScoreCommentary6 |
string |
Indicates comments about the credit score. |
|
CreditScoreCommentary7 |
string |
Indicates comments about the credit score. |
|
CreditScoreCommentary8 |
string |
Indicates comments about the credit score. |
|
CreditScoreCommentary9 |
string |
Indicates comments about the credit score. |
|
CreditScoreDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The date when the credit score was calculated. |
|
CreditScoreIncdDefault |
decimal |
Indicates the probability expressed as a percentage of delinquency for a score range or class. |
|
CreditScoreNatlPercentile |
decimal |
Indicates the relative credit rating of a business compared to all businesses whose credit ratings are included in the local country database. |
|
CreditScoreOverrideCode |
string |
Indicates why no score was calculated or why score is equal to zero in the US. |
|
CriminalProceedingInd |
string |
Indicates if criminal proceedings exist. Y stands for availability of information and N stands for no information. |
|
DebarmentInd |
string |
Indicates whether the company is debarred from doing business with government agencies. Y stands for company debarred and N stands for not debarred. |
|
DebarmentsCount |
decimal |
The count of filings by government agencies in the United States that prohibit the party from entering into contracts or transactions with those agencies. |
|
DebarmentsDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The date of the most recent filing to prohibit the party from entering into contracts or transactions with a government agency in the United States. |
|
DelqPmtPctgForAllFirms |
decimal |
Specifies a delinquency percentage for all firms. |
|
DelqPmtRngPrcnt |
decimal |
Specifies a delinquency percentage for credit score range. |
|
Description |
string |
The free text description of the record. |
|
DetHistoryInd |
string |
The code that indicates if detrimental information exists for the party and whether complete details exist on management and party. Y stands for availability of information and N stands for no information. |
|
DisasterInd |
string |
Indicates if information exists about disasters such as fires, hurricanes, and so on. Y stands for availability of information and N stands for no information. |
|
FailureScore |
string |
For US, the failure risk class, 1 through 5. For Canada , the stability score that indicates risk of business closure, 1 through 10. For Australia, the percentile failure score. |
|
FailureScoreAge |
decimal |
The failure score age in months. |
|
FailureScoreClass |
decimal |
1 through 5 to indicate risk of financial stress for a customer account. 1 for a business with greatest risk and 5 for a business with least risk. |
|
FailureScoreCommentary |
string |
The comments related to failure score. |
|
FailureScoreCommentary10 |
string |
The comments related to failure score. |
|
FailureScoreCommentary2 |
string |
The comments related to failure score. |
|
FailureScoreCommentary3 |
string |
The comments related to failure score. |
|
FailureScoreCommentary4 |
string |
The comments related to failure score. |
|
FailureScoreCommentary5 |
string |
The comments related to failure score. |
|
FailureScoreCommentary6 |
string |
The comments related to failure score. |
|
FailureScoreCommentary7 |
string |
The comments related to failure score. |
|
FailureScoreCommentary8 |
string |
The comments related to failure score. |
|
FailureScoreCommentary9 |
string |
The comments related to failure score. |
|
FailureScoreDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The date when the failure score was calculated. |
|
FailureScoreIncdDefault |
decimal |
Probability, in percentage, of failure for score range of class. |
|
FailureScoreNatnlPercentile |
decimal |
The national percentile that reflects the relative ranking of a company among all scored companies in the local country database. |
|
FailureScoreOverrideCode |
string |
In Europe, code for the reason for variance between the D and B rating and the failure score. In the US, code for the reason why no score was calculated, or why the score is zero. |
|
FinclEmbtInd |
string |
Indicates if open bankruptcy, receivership liquidation, or any equivalent information exists. Y stands for availability of information and N stands for no information. |
|
FinclLglEventInd |
string |
Indicates if special events such as financial embarrassment and legal filings exist. Y stands for availability of information and N stands for no information. |
|
GlobalFailureScore |
string |
The global score for the risk of business default. |
|
HighCredit |
decimal |
Maximum credit ever extended to the organization. |
|
HighRngDelqScr |
decimal |
Specifies the high end of the range of the commercial credit score. |
|
JudgementInd |
string |
Indicates if open judgments exist. Y stands for any open judgment that exists and N stands for no open judgments. |
|
LastUpdateDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The date when the record was last updated. |
|
LastUpdateLogin |
string |
The login of the user who last updated the record. |
|
LastUpdatedBy |
string |
The user who last updated the record. |
|
LienInd |
string |
Indicates if open liens exist. Y stands for any open lien that exists and N stands for no open liens. |
|
LowRngDelqScr |
decimal |
Specifies the low end of the range of the commercial credit score. |
|
MaximumCreditCurrencyCode |
string |
The currency used to denominate the MAXIMUM_CREDIT_RECOMMENDATION column. |
|
MaximumCreditRecommendationAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
Maximum credit limit recommended for the currency specified in the MAXIMUM_CREDIT_CURRENCY_CODE column. |
|
NegvPmtExpl |
string |
The conditional comment generated when negative payments are present. |
|
NoTradeInd |
string |
Indicates that no trade experiences exist. Y stands for any trade experience that exists and N stands for no trade experience. |
|
NumberParentBankruptcyConversions |
decimal |
The number of bankruptcy conversions by the parent. |
|
NumberParentBankruptcyFiling |
decimal |
The number of bankruptcies filed by the parent. |
|
NumberSpecialEvent |
decimal |
The number of occurrences of the special events. |
|
NumberTradeExperiences |
decimal |
The number of trade experiences. |
|
ObjectVersionNumber |
int |
The number used to implement 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 determine whether another session has updated the row. |
|
OprgSpecificationEvntInd |
string |
Indicates if information exists about operational changes such as name changes, management changes, change of control, moves, and so on. Y stands for availability of information and N stands for no information. |
|
OriginalSystemReference |
The identifier for the record from the original system. |
|
|
OtherSpecificationEvntInd |
string |
Indicates if special events exist that are not otherwise specified. |
|
ParentHQBankruptcyInd |
string |
Indicates if parent (P) or headquarters (H) are entered into bankruptcy. |
|
PartyId |
long |
The unique identifier of the contact party. |
|
PaydexComment |
string |
Additional paydex information. |
|
PaydexFirmComment |
string |
Comment on the paydex score for the organization. |
|
PaydexFirmDays |
string |
The number of days used in the paydex score. |
|
PaydexIndustryComment |
string |
Comment on the paydex score for the industry. |
|
PaydexIndustryDays |
string |
The number of days used in the paydex score for the industry. |
|
PaydexNorm |
string |
Median or average Paydex score for the industry. |
|
PaydexScore |
string |
Paydex score for the previous 12 months payment history. |
|
PaydexThreeMonthsAgo |
string |
Paydex score three months ago. |
|
PrntBkcyChapterConv |
string |
The change of bankruptcy type. |
|
PrntBkcyConvDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The date when the bankruptcy converted from one type to another. |
|
PrntBkcyFilgChapter |
decimal |
The chapter number of the bankruptcy filed by the parent under the US uniform commercial code. |
|
PrntBkcyFilgDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The bankruptcy filing date of the parent. |
|
PrntBkcyFilgType |
string |
The type of bankruptcy filed by the parent. |
|
PubRecExpl |
string |
The conditional comment generated if suits, liens, and judgments exist. |
|
RatedAsOfDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The date when the rating was acquired. |
|
Rating |
string |
The rating number or code of the rating company. |
|
RatingOrganization |
string |
The name of the credit rating organization. |
|
RequestId |
long |
A system-generated read-only attribute used by the application framework. |
|
SecuredFlngInd |
string |
Indicates if open secured filings such as UCC filings, secured charges or mortgages pledging, or any equivalent information exists. Y stands for availability of information and N stands for no information. |
|
SlowTradeExpl |
string |
The conditional comment generated when paydex score indicates that slow trade experiences are present. |
|
SpecialEventComment |
string |
The comment generated if special event section exists. |
|
SpecialEventText |
string |
The narrative of the special event. |
|
SpecialEventUpdateDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The date when the special event was updated. |
|
Status |
string |
The status of the record. |
|
SuitInd |
string |
Indicates if open suits exist. Y stands for any open suit that exists and N stands for no open suits. |