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. |