Payment Information - Detail

This product provides granular, monthly trade details (counts, averages, maximums, normalized totals, etc) across all supplier accounts for the Purchasing business. Provides increased visibility into recent and seasonal trade payment behavior, including month-to-month time-series view of their payment behaviors.

Requirements & Options

When requesting this D&B Direct product, a valid D-U-N-S Number for a company, a country code of "US" and the appropriate product code will be required. If this information is not available, refer to obtaining a company D-U-N-S Number for assistance. A trade up option exists to request data for the headquarters when the requested organization is a branch.

NOTE: The product code for Payment Information - Detail is PI_DTL. This product currently may not be included in the Monitoring process.

Business Elements

The following table is an alphabetical list of the unique items delivered in this data layer. Legend: [C] = may be included in a Custom Data product; [M] = may be referenced by the Monitoring process; [M+] = Monitored using an aggregate or attribute XPath.

NOTE: This product will return a set of standard elements (e.g. D-U-N-S Number, Organization Name, Trade Styles, Family Tree Role, Primary Address, Mailing Address, Telephone Number, Fax Number, et al.) along with the business elements listed. In addition, customers who compare the following table to the Data Primer should be advised of several intentional differences.

Name Description XML* JSON*
Account Quantity Total within 12 Months The number of trading relationships between the subject and its suppliers obtained by summing the number of unique accounts for the subject having reported activity (one or more valid experiences) in the 12 months ending in the Trade Data Year Month. SOAP REST
Account Quantity Total within 3 Months The number of trading relationships between the subject and its suppliers obtained by summing the number of unique accounts for the subject having reported activity (one or more valid experiences) in the 3 months ending in the Trade Data Year Month. SOAP REST
Aggregated Experience Date The year and month of the payment data which has been grouped and summarized here. SOAP REST
Average Monthly 30+ Days Past Due Amount within 12 Months A monetary figure summing the amount from each of a subject's accounts stating how much is 30 days or more beyond terms on average each month in a 12 month period. SOAP REST
Average Monthly 30+ Days Past Due Amount within 3 Months A monetary figure summing the amount from each of a subject's accounts stating how much is 30 days beyond terms on average each month in a 3 month period. SOAP REST
Average Monthly 60+ Days Past Due Amount within 12 Months A monetary figure summing the amount from each of a subject's accounts stating how much is 60 days or more beyond terms on average each month in a 12 month period. SOAP REST
Average Monthly 60+ Days Past Due Amount within 3 Months A monetary figure summing the amount from each of a subject's accounts stating how much is 60 days or more beyond terms on average each month in a 3 month period. SOAP REST
Average Monthly 90+ Days Past Due Amount within 12 Months A monetary figure summing the amount from each of a subject's accounts stating how much is 90 days or more beyond terms on average each month in a 12 month period. SOAP REST
Average Monthly 90+ Days Past Due Amount within 3 Months A monetary figure summing the amount from each of a subject's accounts stating how much is 90 days or more beyond terms on average each month in a 3 month period. SOAP REST
Average Monthly Amount Owed within 12 Months A monetary figure summing the amount from each of a subject's accounts stating how much is outstanding on average each month satisfying the criteria for this aggregation as of the Trade Data Year Month. For example if a subject has three accounts where the average monthly amount is respectively 400 250 and 300 then the value here will be 950. SOAP REST
Average Monthly Amount Owed within 3 Months A monetary figure summing the amount from each of a subject's accounts stating how much is outstanding on average each month satisfying the criteria for this aggregation as of the Trade Data Year Month. For example if a subject has three accounts where the average monthly amount is respectively 400 250 and 300 then the value here will be 950. SOAP REST
Average Monthly Past Due Amount - 12 Months Avg: Sum of Dollars 1-30 Days + Dollars 31-60 Days + Dollars 61-90 Days + Dollars 91-120 Days + Dollars 121-150 Days + Dollars 151-180 Days + Dollars > 180 Days, use the most recent experience date for each account. Use the past due field ; do not add up aging buckets SOAP REST
Average Monthly Past Due Amount within 3 Months Average of all experiences within the past three months showing Past Due Amounts SOAP REST
Bad Debt Total Amount Owing A monetary figure specifying how much is owed across all the subject's accounts where the suppliers could not collect payment and ultimately wrote off these accounts as bad debt as they had good reason to believe that they would never be able to collect the outstanding amount. Note: Not all suppliers provide these amounts. Format is Numeric, no decimals SOAP REST
Cumulative High Credit A monetary figure specifying the sum of the high credits from each of the subject’s accounts that was extended to the subject over a 12 month time period (ending with this trade data year and month). SOAP REST
Current Accounts Count The number of trading relationships between the subject and its suppliers that are still within terms. Note: It is possible for the subject to have more than one account with a given supplier; each will be counted SOAP REST
D&B Paydex Score - 12 Months of Trade Experiences It is calculation of Paydex score based on the most recent 12 months SOAP REST
Maximum Account Level Past Due A monetary figure specifying the highest amount owed that is beyond terms from amongst all of a subject's accounts used to calculate the derived value considering one month worth of data. SOAP REST
Maximum High Credit Amount - 12 Months The greatest monetary figure owed to the supplier by the subject over the period of time over a 12 month period. SOAP REST
Maximum High Credit Amount - 3 Months The greatest monetary figure owed to the supplier by the subject over the period of time over a 3 month period. SOAP REST
Monthly Account Quantity 121-150 Days Slow The total number of trade accounts in the D&B database matched to this purchaser D-U-N-S, representing the number of trade accounts that are 121 to 150 days beyond terms. Generally, trade experiences and trade accounts are synonymous. SOAP REST
Monthly Account Quantity 1-30 Days Slow The total number of trade accounts in the D&B database matched to this purchaser D-U-N-S, representing the number of trade accounts that are 1 to 30 days beyond terms. Generally, trade experiences and trade accounts are synonymous. SOAP REST
Monthly Account Quantity 151-180 Days Slow The total number of trade accounts in the D&B database matched to this purchaser D-U-N-S, representing the number of trade accounts that are 151 to 180 days beyond terms. Generally, trade experiences and trade accounts are synonymous. SOAP REST
Monthly Account Quantity 181-210 Days Slow The total number of trade accounts in the D&B database matched to this purchaser D-U-N-S, representing the number of trade accounts that are 181 to 210 days beyond terms. Generally, trade experiences and trade accounts are synonymous. SOAP REST
Monthly Account Quantity 211-240 Days Slow The total number of trade accounts in the D&B database matched to this purchaser D-U-N-S, representing the number of trade accounts that are 211 to 240 days beyond terms. Generally, trade experiences and trade accounts are synonymous. SOAP REST
Monthly Account Quantity 241+ Days Slow The total number of trade accounts in the D&B database matched to this purchaser D-U-N-S, representing the number of trade accounts that are greater than 240 days beyond terms. Generally, trade experiences and trade accounts are synonymous. SOAP REST
Monthly Account Quantity 31-60 Days Slow The total number of trade accounts in the D&B database matched to this purchaser D-U-N-S, representing the number of trade accounts that are 31 to 60 days beyond terms. Generally, trade experiences and trade accounts are synonymous. SOAP REST
Monthly Account Quantity 61-90 Days Slow The total number of trade accounts in the D&B database matched to this purchaser D-U-N-S, representing the number of trade accounts that are 61 to 90 days beyond terms. Generally, trade experiences and trade accounts are synonymous. SOAP REST
Monthly Account Quantity 91-120 Days Slow The total number of trade accounts in the D&B database matched to this purchaser D-U-N-S, representing the number of trade accounts that are 91 to 120 days beyond terms. Generally, trade experiences and trade accounts are synonymous. SOAP REST
Monthly Average High Credit Amount within 12 Months A monetary figure specifying the average high credit is determined by dividing the total dollar amount by the number of experiences in file for the last 12 months. SOAP REST
Monthly Average High Credit Amount within 3 Months A monetary figure specifying the average high credit is determined by dividing the total dollar amount by the number of experiences in file for the last 3 months. SOAP REST
Monthly Maximum Amount Owed A monetary figure specifying the highest amount that is due from amongst all the subject's accounts. The maximum account level amount owed contributed to Total Amount Owing. SOAP REST
Monthly Total Amount Owed Slow 121-150 Days A monetary figure representing payments that are between 121 and 150 days beyond the agreed upon payment terms. SOAP REST
Monthly Total Past Due Amount A monetary figure representing the sum of all the amounts owed by a subject that are a specified range of days beyond the agreed upon payment terms. SOAP REST
Monthly Total Past Due Amount of Trade Experiences Placed for Collection
SOAP REST
Monthly Trade Experience Bad Debt/Write Off Count The number of trading relationships between the subject and its suppliers where the supplier could not collect payment and ultimately wrote off these accounts as bad debt (thereby taking a loss on the outstanding amount). Note: It is possible for the sub SOAP REST
Monthly Trade Experience Cash Payments Count The number of cash experiences recorded in D&B's database. SOAP REST
Monthly Trade Experience Past Due Count The number of trading relationships between a subject and its suppliers that are beyond terms considering 1 month of data. SOAP REST
Number of Experiences Placed for Collection The number of trading relationships between the subject and its suppliers where the subject's accounts are placed with an external collection agency by its suppliers for its failure to pay in whole or part. SOAP REST
Out of Business Indicator Text that records the operating status of the business. SOAP REST
Paydex - 3 Month Calculation It is calculation of Paydex score based on the most recent 3 months SOAP REST
Paydex Date - 12 Months The month and year that the corresponding PAYDEX score was calculated. SOAP REST
Paydex Date - 3 Months The month and year that the corresponding PAYDEX score was calculated. SOAP REST
Prior D&B Paydex Score - 12 Months of Trade Experiences It is the prior month end 12 month paydex SOAP REST
Prior D&B Paydex Score - 3 Months of Trade Experiences in-date (active) matched trading accounts with suppliers SOAP REST
Prior Paydex Date - 12 Months The month and year that the corresponding PAYDEX score was calculated. SOAP REST
Summary Period - 3 Months A number specifying how many complete months (e.g., 3, 12) of payment experience data contributed to this account summary. The full summary period is through the Experience Date and therefore includes data that may extend somewhat beyond the number of months. SOAP REST
Total Amount Owing Slow 1-30 Days A monetary figure representing payments that are between 1 and 30 days beyond the agreed upon payment terms. SOAP REST
Total Amount Owing Slow 151-180 Days A monetary figure representing the sum of amount owing for payments that are between 151 and 180 days beyond the agreed upon payment terms. SOAP REST
Total Amount Owing Slow 181-210 Days A monetary figure representing payments that are between 181 and 210 days beyond the agreed upon payment terms. SOAP REST
Total Amount Owing Slow 211-240 Days A monetary figure representing payments that are between 211 and 240 days beyond the agreed upon payment terms. SOAP REST
Total Amount Owing Slow 241+ Days A monetary figure representing the sum of amount owing for payments that are 241+ days beyond the agreed upon payment terms. SOAP REST
Total Amount Owing Slow 31-60 Days A monetary figure representing the sum of amount owing for payments that are between 31 and 60 days beyond the agreed upon payment terms. SOAP REST
Total Amount Owing Slow 61-90 Days A monetary figure representing the sum of amount owing for payments that are between 61 and 90 days beyond the agreed upon payment terms. SOAP REST
Total Amount Owing Slow 91-120 Days A monetary figure representing the sum of amount owing for payments that are between 91 and 120 days beyond the agreed upon payment terms. SOAP REST
Total High Credit Amount - 12 Months A monetary figure representing the sum of all high credit amounts for trade experiences in the last 12 months. SOAP REST
Total Number of Experiences Past Due - 3 Months The number of trading relationships between a subject and its suppliers that are beyond terms considering 3 months of data. SOAP REST
Total Number of Experiences with Unfavorable Comments - 12 Months Records the number of trade experiences that have unfavorable comments within the last 12 months SOAP REST
Total Number of Experiences with Unfavorable Comments - 3 months The number of trading relationships between a subject and its suppliers that are unfavorable comments considering 3 months of data. SOAP REST
Total Number of Suppliers The number of unique suppliers whose payment data is required to calculate trade data considering one month data. SOAP REST
Trade Experience Count - 12 Month Paydex The number of trade experiences used for the 12 month Paydex Calculation SOAP REST
Trade Experiences used in 12 month Paydex Count The number of supplier's whose payment experiences contributed to this 12 month payment index score. As an example the score may have been derived using experiences from 8 different suppliers. Can repeat up to two times. SOAP REST
Trade Experiences used in 3 month Paydex Count The number of payment experiences that contributed to this 3 Month payment index score. As an example the score may have been derived from 18 payment experiences from various suppliers. SOAP REST
Trade Experiences with Past Due Amounts within 12 Months Count Records the number of trade experiences that have past due dollar amounts within the last 12 months SOAP REST
Trade Supplier Count - 3 Month Paydex The number of supplier's whose payment experiences contributed to this 3 month payment index score. As an example the score may have been derived using experiences from 8 different suppliers. SOAP REST

*The links in this column provide the technical characteristics for the data field of the respective business element in the XML or JSON response.

The preceding list is not presented in the order, nor manner, in which the information is packaged and delivered via the D&B Direct API.

While data for a particular company may not contain values for all of the business elements, there may be items that are considered by D&B to be essential to yield the maximum benefit of a data layer. If any of these essential elements do not contain a value for a particular company, an error code will be returned, and your organization will not incur a usage credit for the request.

The Product Availability Lookup feature may be utilized to determine if this D&B Direct product is available for a given D-U-N-S Number.

Additional Details

This product was formerly known as Detailed Trade Risk Insight (DTRI).

This product is only available for organizations domiciled in the United States. If the trade up option was selected, and the headquarters is domiciled in another country, an error may be returned depending on the scope of the particular database being accessed by the product request.

Access to this information is provided on a metered basis; and will require data layer entitlement prior to use in the production environment. A built-in feature exists to prevent duplicate billing when multiple requests with the same D-U-N-S Number and product code are submitted on the same calendar day (which is based on Eastern Standard Time [GMT-5]).

An option exists to retain the results from all successful requests for this product in a Product Request Archive, which may be retrieved without incurring additional usage charges.

Technical Specification

For details on how to obtain this data layer, please refer to the TradeDetail.OrderProduct (SOAP) or TradeDetail.OrderProduct (REST) page.


Product History

Back to Top