Loading

Direct 2.0
Collapse

Payment Information - Detail

ProductD&B Direct 2.0
Product Code(s)PI_DTL
Level(s)Standard
Monitoring AvailableNo
InterfaceSOAP
WSDLdownload
Format(s)XML
ServiceTradeDetail
OperationOrderProduct
{version}4.0
4.0 Released OnJanuary 3, 2014

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.

Update History

  • August 9, 2019 (ALL SOAP & REST): An error message from the Services Local FeedsDB , when there is NO Match DUNS from CA DUnslink & GSRL has been fixed for Canada.
  • January 3, 2014 (v4.0 SOAP & REST): To support changes to the delivery of PAYDEX data, several XPATH's have changed/were added to the OrderProduct response, affecting the Payment Information & Paydex (Rating) - Detail and Payment Information - Detail data layer responses.

Product Request

IMPORTANT: Due to a known issue, please do not include request values for SubmittingOfficeID.

IMPORTANT: Please see the new Online Services Security Enhancement Release, effective December 14, 2018.

Overview

When requesting this feature, a valid D&B D-U-N-S Number for a company and the appropriate product code will be required. For improved performance, include a country code of "US".

A trade up option exists to request data for a headquarters location when the requested organization is a branch.

Global Availability

This data layer is only available for businesses domiciled in the United States.

Data Layer Entitlement

For customers in U.S. and Canadian markets, the API is provisioned for specific collections of products, reports, and/or features (collectively referred to as data layers) for production and trial usage. Entitlement is not required for testing in the sandbox environment.

  • This product is entitled as "Payment Information - Detail" for D&B Direct 2.0 customers.

For customers in the UK, Ireland, Belgium, Netherlands and Luxembourg markets, the API is provisioned as a specific set of data layers for production, trial, and sandbox usage.

  • This particular data layer is NOT included in the D&B Direct Onboard suite.

Specification

Sample Request (PI_DTL)
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:trad="http://services.dnb.com/TradeDetailProductServiceV2.0">
   <soapenv:Header>
      <wsse:Security soapenv:mustUnderstand="0" xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd" xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd">
         <wsse:UsernameToken wsu:Id="UsernameToken-11">
            <wsse:Username>MyUserName</wsse:Username>
            <wsse:Password Type="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-username-token-profile-1.0#PasswordText">MyPassword</wsse:Password>
         </wsse:UsernameToken>
      </wsse:Security>
   </soapenv:Header>
   <soapenv:Body>
      <trad:OrderProductRequest ServiceVersionNumber="4.0">
         <OrderProductRequestDetail>
            <InquiryDetail>
               <DUNSNumber>804735132</DUNSNumber>
               <CountryISOAlpha2Code>US</CountryISOAlpha2Code>
            </InquiryDetail>
            <ProductSpecification>
               <DNBProductID>PI_DTL</DNBProductID>
            </ProductSpecification>
         </OrderProductRequestDetail>
      </trad:OrderProductRequest>
   </soapenv:Body>
</soapenv:Envelope>
Name Characteristics
OrderProductRequest Aggregate
OrderProductRequest@ServiceVersionNumber Attribute
OrderProductRequest. TransactionDetail Aggregate, Optional

Records information necessary to process this request.

OrderProductRequest. TransactionDetail. ApplicationTransactionID string, up to 64 chars, Optional

A number assigned by the calling application to uniquely identify this request.

OrderProductRequest. TransactionDetail. TransactionTimestamp DateTimestamp, Optional

The date and time when this request was created. When the request is from an intermediary, such as a workflow manager or service bus, this is the date and time when the message was sent to the D&B function, i.e., the date and time when the xml document was created by the requesting intermediary.

OrderProductRequest. TransactionDetail. SubmittingOfficeID string, up to 64 chars, Optional

A number that identifies the system or the software application from where this request originated. / A number used to uniquely identfy the D&B business segment or delivery channel from where this request originated.

END: OrderProductRequest. TransactionDetail /Aggregate
OrderProductRequest. OrderProductRequestDetail Aggregate, Optional

Records data relating to requests for a product. This may include such details as the product required, the subject about which the product should be produced, the content of the product.

OrderProductRequest. OrderProductRequestDetail. InquiryDetail Aggregate, Required

Records data that allows the customer to specify identifying information about the subject being inquired, e.g., the DUNS Number, the address, the telephone number.

OrderProductRequest. OrderProductRequestDetail. InquiryDetail. DUNSNumber string, up to 15 chars Pattern: {([0-9a-zA-Z]*)}, Optional

The D-U-N-S Number is D&B's identification number, which provides unique identification of this organization, in accordance with the Data Universal Numbering System (D-U-N-S).

OrderProductRequest. OrderProductRequestDetail. InquiryDetail. CountryISOAlpha2Code string, at least 2 chars up to 2 chars, Optional

The two-letter country code, defined in the ISO 3166-1 scheme published by International Organization for Standardization (ISO)identifying the country of the inquired subject.

END: OrderProductRequest. OrderProductRequestDetail. InquiryDetail /Aggregate
OrderProductRequest. OrderProductRequestDetail. ProductSpecification Aggregate, Required

Records data that allows the customer to specify the details of the requested product. This may include details such as the identifier of the product, the language in which the product needs to be rendered, the format in which the product needs to be rendered.

OrderProductRequest. OrderProductRequestDetail. ProductSpecification. DNBProductID string, Optional

An alphanumeric string that uniquely identifies the product being requested.

OrderProductRequest. OrderProductRequestDetail. ProductSpecification. LanguagePreferenceCode integer, up to 7 digits, Optional

A D&B code value that defines the language in which the customer wants this product to be rendered.

Possible values: 39 [English]

OrderProductRequest. OrderProductRequestDetail. ProductSpecification. TradeUpIndicator boolean, Optional

When 'true' indicates that the customer has requested that D&B return the data for the Headquarters when the requested organization is a Branch. When 'false' indicates that the customer has not requested that D&B return the data for the Headquarters when the requested organization is a Branch; however as this is the assumed condition there is no requirement to create this tag to represent this fact. Note: There are D&B WorldWide Network operations where the Headquarters information will be returned automatically, regardless of the customer request.

Possible values: true; false

OrderProductRequest. OrderProductRequestDetail. ProductSpecification. OrderReasonCode integer, up to 7 digits, Optional

Possible values: 6332 [Credit Decision]; 6333 [Assessment of credit solvency for intended business connection]; 6334 [Assessment of credit solvency for ongoing business connection]; 6335 [Debt Collection]; 6336 [Commercial Credit Insurance]; 6337 [Insurance Contract]; 6338 [Leasing Agreement]; 6339 [Rental Agreement]

END: OrderProductRequest. OrderProductRequestDetail. ProductSpecification /Aggregate
OrderProductRequest. OrderProductRequestDetail. ArchiveDetail Aggregate, Optional
OrderProductRequest. OrderProductRequestDetail. ArchiveDetail. ArchiveProductOptOutIndicator boolean, Optional

When 'true' indicates that the product being ordered is not to be stored. When 'false' indicates that the product being ordered is to be stored; however as this is the assumed condition there is no requirement to create this tag to represent this fact.

OrderProductRequest. OrderProductRequestDetail. ArchiveDetail. ExtendArchivePeriodIndicator boolean, Optional

When 'true' the duration to archive the data is to be extended. Note: There is an additional cost for extending the archival period of the data purchased. When 'false' the duration to archive the data is not to be extended.

OrderProductRequest. OrderProductRequestDetail. ArchiveDetail. PortfolioAssetContainerID long, Optional

A number used to uniquely identify the location where this product is to be stored.

END: OrderProductRequest. OrderProductRequestDetail. ArchiveDetail /Aggregate
OrderProductRequest. OrderProductRequestDetail. InquiryReferenceDetail Aggregate, Optional

Records data that allows the customer to specify information to be linked to the request in order to support subsequent order reconciliation.

OrderProductRequest. OrderProductRequestDetail. InquiryReferenceDetail. CustomerReferenceText string, up to 240 chars, Optional (Up to 5x)

A freeform reference string provided by the customer to be linked to the product in order to support subsequent order reconciliation.

OrderProductRequest. OrderProductRequestDetail. InquiryReferenceDetail. CustomerBillingEndorsementText string, at least 1 chars, up to 240 chars, Optional

Text that is filled in by customer and commonly contains requesting individual or department name, or customer's own account/reference number and/or name for the case on which the product was provided.This text is a reference used during the billing process.

END: OrderProductRequest. OrderProductRequestDetail. InquiryReferenceDetail /Aggregate
END: OrderProductRequest. OrderProductRequestDetail /Aggregate
END: OrderProductRequest /Aggregate

Endpoint

Use the following endpoint with the downloadable WSDL to request this product.

SOAP (TradeDetail)
https://direct.dnb.com/TradeDetailProduct/V{version}

Testing

Sandbox

The following parameters may be used for D&B Direct 2.0 developer sandbox requests to retrieve successful responses. The data returned from sandbox requests may not represent actual values that this feature will deliver.

D-U-N-S Number (Country Code)
804735132 (US)

Trials

When conducting testing in the production environment during a trial period, product requests will be limited to the local market of the customer.

Production

A set of D-U-N-S Numbers is available to D&B Direct 2.0 customers for performing non-billable transactions in the production environment.

Product Response

While data for a particular company may not contain values for each 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, a PD005 response code will be returned, and your organization will not incur a usage credit for the request.

For all codified data delivered by D&B Direct, the response package will include the decoded text value as a data element with the code value attached as an attribute. Refer to the Reference Data Service for access to the D&B standard code tables.

Specification

The following is a list of the possible data fields returned by this operation in the XML response. Samples are provided for testing successful and failed retrieval, and to demonstrate the basic layout of a response. The data returned in samples may not represent actual values that this feature will deliver.

NOTE: The D-U-N-S Number returned in the response will be a nine-digit zero-padded, numeric value.

Sample Response (PI_DTL)
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
   <soap-env:Body xmlns:soap-env="http://schemas.xmlsoap.org/soap/envelope/">
      <trad:OrderProductResponse ServiceVersionNumber="4.0" xmlns:trad="http://services.dnb.com/TradeDetailProductServiceV2.0">
         <TransactionDetail>
            <ServiceTransactionID>Id-49a19a8452cda7ee0d6b8437-2</ServiceTransactionID>
            <TransactionTimestamp>2014-01-08T14:33:04.641-05:00</TransactionTimestamp>
         </TransactionDetail>
         <TransactionResult>
            <SeverityText>Information</SeverityText>
            <ResultID>CM000</ResultID>
            <ResultText>Success</ResultText>
         </TransactionResult>
         <OrderProductResponseDetail>
            <InquiryDetail>
               <DUNSNumber>804735132</DUNSNumber>
               <CountryISOAlpha2Code>US</CountryISOAlpha2Code>
            </InquiryDetail>
            <Product>
               <DNBProductID>PI_DTL</DNBProductID>
               <Organization>
                  <SubjectHeader>
                     <DUNSNumber>804735132</DUNSNumber>
                  </SubjectHeader>
                  <Telecommunication>
                     <TelephoneNumber>
                        <TelecommunicationNumber>(650) 555-0000</TelecommunicationNumber>
                        <InternationalDialingCode>1</InternationalDialingCode>
                     </TelephoneNumber>
                  </Telecommunication>
                  <Location>
                     <PrimaryAddress>
                        <StreetAddressLine>
                           <LineText>492 Koller St</LineText>
                        </StreetAddressLine>
                        <PrimaryTownName>San Francisco</PrimaryTownName>
                        <CountryISOAlpha2Code>US</CountryISOAlpha2Code>
                        <TerritoryAbbreviatedName>CA</TerritoryAbbreviatedName>
                        <PostalCode>94110</PostalCode>
                        <TerritoryOfficialName>California</TerritoryOfficialName>
                     </PrimaryAddress>
                  </Location>
                  <OrganizationName>
                     <OrganizationPrimaryName>
                        <OrganizationName>Gorman Manufacturing Company, Inc.</OrganizationName>
                     </OrganizationPrimaryName>
                  </OrganizationName>
                  <BusinessTrading>
                     <Purchaser>
                        <CurrentPaydexScore>
                           <TwelveMonthsPaydex>
                              <PaydexScore>75</PaydexScore>
                           </TwelveMonthsPaydex>
                        </CurrentPaydexScore>
                        <PurchaserDerivedData>
                           <TwelveMonthsDataCoveragePayments>
                              <PaymentPeriodSummary>
                                 <SummaryPeriod>P12M</SummaryPeriod>
                                 <PaymentsWithHighCredit>
                                    <ExperienceCount>13</ExperienceCount>
                                    <HighCreditMaximumAmount>15000</HighCreditMaximumAmount>
                                    <AverageHighCreditAmount>3440</AverageHighCreditAmount>
                                 </PaymentsWithHighCredit>
                              </PaymentPeriodSummary>
                           </TwelveMonthsDataCoveragePayments>
                        </PurchaserDerivedData>
                        <PurchaserDerivedData>
                           <TradeDataYearMonth>2013-10</TradeDataYearMonth>
                           <OneMonthDataCoveragePayments>
                              <OwedTotalMaximumAmount>920</OwedTotalMaximumAmount>
                              <PastDueTotalMaximumAmount>920</PastDueTotalMaximumAmount>
                              <SuppliersCount>1</SuppliersCount>
                              <AccountsCount>1</AccountsCount>
                              <OwedTotalAmount>920</OwedTotalAmount>
                              <TotalPastDueTotalAmount>920</TotalPastDueTotalAmount>
                              <CurrentTotalAmount>0</CurrentTotalAmount>
                              <SummarizedPastDue>
                                 <DaysLowQuantity>121</DaysLowQuantity>
                                 <DaysHighQuantity>150</DaysHighQuantity>
                                 <ExperiencesCount>1</ExperiencesCount>
                                 <TotalAmount>920</TotalAmount>
                              </SummarizedPastDue>
                           </OneMonthDataCoveragePayments>
                        </PurchaserDerivedData>
                        <PurchaserDerivedData>
                           <TradeDataYearMonth>2013-09</TradeDataYearMonth>
                           <OneMonthDataCoveragePayments>
                              <OwedTotalMaximumAmount>920</OwedTotalMaximumAmount>
                              <PastDueTotalMaximumAmount>920</PastDueTotalMaximumAmount>
                              <SuppliersCount>1</SuppliersCount>
                              <AccountsCount>1</AccountsCount>
                              <OwedTotalAmount>920</OwedTotalAmount>
                              <TotalPastDueTotalAmount>920</TotalPastDueTotalAmount>
                              <CurrentTotalAmount>0</CurrentTotalAmount>
                              <SummarizedPastDue>
                                 <DaysLowQuantity>121</DaysLowQuantity>
                                 <DaysHighQuantity>150</DaysHighQuantity>
                                 <ExperiencesCount>1</ExperiencesCount>
                                 <TotalAmount>920</TotalAmount>
                              </SummarizedPastDue>
                           </OneMonthDataCoveragePayments>
                        </PurchaserDerivedData>
                        <PurchaserDerivedData>
                           <TradeDataYearMonth>2013-08</TradeDataYearMonth>
                           <OneMonthDataCoveragePayments>
                              <OwedTotalMaximumAmount>920</OwedTotalMaximumAmount>
                              <PastDueTotalMaximumAmount>920</PastDueTotalMaximumAmount>
                              <SuppliersCount>1</SuppliersCount>
                              <AccountsCount>1</AccountsCount>
                              <OwedTotalAmount>920</OwedTotalAmount>
                              <TotalPastDueTotalAmount>920</TotalPastDueTotalAmount>
                              <CurrentTotalAmount>0</CurrentTotalAmount>
                              <SummarizedPastDue>
                                 <DaysLowQuantity>121</DaysLowQuantity>
                                 <DaysHighQuantity>150</DaysHighQuantity>
                                 <ExperiencesCount>1</ExperiencesCount>
                                 <TotalAmount>920</TotalAmount>
                              </SummarizedPastDue>
                           </OneMonthDataCoveragePayments>
                        </PurchaserDerivedData>
                        <PurchaserDerivedData>
                           <TradeDataYearMonth>2013-07</TradeDataYearMonth>
                           <OneMonthDataCoveragePayments>
                              <OwedTotalMaximumAmount>920</OwedTotalMaximumAmount>
                              <PastDueTotalMaximumAmount>920</PastDueTotalMaximumAmount>
                              <SuppliersCount>1</SuppliersCount>
                              <AccountsCount>1</AccountsCount>
                              <OwedTotalAmount>920</OwedTotalAmount>
                              <TotalPastDueTotalAmount>920</TotalPastDueTotalAmount>
                              <CurrentTotalAmount>0</CurrentTotalAmount>
                              <SummarizedPastDue>
                                 <DaysLowQuantity>121</DaysLowQuantity>
                                 <DaysHighQuantity>150</DaysHighQuantity>
                                 <ExperiencesCount>1</ExperiencesCount>
                                 <TotalAmount>920</TotalAmount>
                              </SummarizedPastDue>
                           </OneMonthDataCoveragePayments>
                        </PurchaserDerivedData>
                        <PurchaserDerivedData>
                           <TradeDataYearMonth>2013-06</TradeDataYearMonth>
                           <OneMonthDataCoveragePayments>
                              <OwedTotalMaximumAmount>920</OwedTotalMaximumAmount>
                              <PastDueTotalMaximumAmount>920</PastDueTotalMaximumAmount>
                              <SuppliersCount>1</SuppliersCount>
                              <AccountsCount>1</AccountsCount>
                              <OwedTotalAmount>920</OwedTotalAmount>
                              <TotalPastDueTotalAmount>920</TotalPastDueTotalAmount>
                              <CurrentTotalAmount>0</CurrentTotalAmount>
                              <SummarizedPastDue>
                                 <DaysLowQuantity>121</DaysLowQuantity>
                                 <DaysHighQuantity>150</DaysHighQuantity>
                                 <ExperiencesCount>1</ExperiencesCount>
                                 <TotalAmount>920</TotalAmount>
                              </SummarizedPastDue>
                           </OneMonthDataCoveragePayments>
                        </PurchaserDerivedData>
                        <PurchaserDerivedData>
                           <TradeDataYearMonth>2013-05</TradeDataYearMonth>
                           <OneMonthDataCoveragePayments>
                              <OwedTotalMaximumAmount>920</OwedTotalMaximumAmount>
                              <PastDueTotalMaximumAmount>920</PastDueTotalMaximumAmount>
                              <SuppliersCount>1</SuppliersCount>
                              <AccountsCount>1</AccountsCount>
                              <OwedTotalAmount>920</OwedTotalAmount>
                              <TotalPastDueTotalAmount>920</TotalPastDueTotalAmount>
                              <CurrentTotalAmount>0</CurrentTotalAmount>
                              <SummarizedPastDue>
                                 <DaysLowQuantity>121</DaysLowQuantity>
                                 <DaysHighQuantity>150</DaysHighQuantity>
                                 <ExperiencesCount>1</ExperiencesCount>
                                 <TotalAmount>920</TotalAmount>
                              </SummarizedPastDue>
                           </OneMonthDataCoveragePayments>
                        </PurchaserDerivedData>
                        <PurchaserDerivedData>
                           <TradeDataYearMonth>2013-04</TradeDataYearMonth>
                           <OneMonthDataCoveragePayments>
                              <OwedTotalMaximumAmount>920</OwedTotalMaximumAmount>
                              <PastDueTotalMaximumAmount>920</PastDueTotalMaximumAmount>
                              <SuppliersCount>1</SuppliersCount>
                              <AccountsCount>1</AccountsCount>
                              <OwedTotalAmount>920</OwedTotalAmount>
                              <TotalPastDueTotalAmount>920</TotalPastDueTotalAmount>
                              <CurrentTotalAmount>0</CurrentTotalAmount>
                              <SummarizedPastDue>
                                 <DaysLowQuantity>121</DaysLowQuantity>
                                 <DaysHighQuantity>150</DaysHighQuantity>
                                 <ExperiencesCount>1</ExperiencesCount>
                                 <TotalAmount>920</TotalAmount>
                              </SummarizedPastDue>
                           </OneMonthDataCoveragePayments>
                        </PurchaserDerivedData>
                        <PurchaserDerivedData>
                           <TradeDataYearMonth>2013-03</TradeDataYearMonth>
                           <OneMonthDataCoveragePayments>
                              <OwedTotalMaximumAmount>920</OwedTotalMaximumAmount>
                              <PastDueTotalMaximumAmount>920</PastDueTotalMaximumAmount>
                              <SuppliersCount>1</SuppliersCount>
                              <AccountsCount>1</AccountsCount>
                              <OwedTotalAmount>920</OwedTotalAmount>
                              <TotalPastDueTotalAmount>920</TotalPastDueTotalAmount>
                              <CurrentTotalAmount>0</CurrentTotalAmount>
                              <SummarizedPastDue>
                                 <DaysLowQuantity>121</DaysLowQuantity>
                                 <DaysHighQuantity>150</DaysHighQuantity>
                                 <ExperiencesCount>1</ExperiencesCount>
                                 <TotalAmount>920</TotalAmount>
                              </SummarizedPastDue>
                           </OneMonthDataCoveragePayments>
                        </PurchaserDerivedData>
                        <PurchaserDerivedData>
                           <TradeDataYearMonth>2013-02</TradeDataYearMonth>
                           <OneMonthDataCoveragePayments>
                              <OwedTotalMaximumAmount>920</OwedTotalMaximumAmount>
                              <PastDueTotalMaximumAmount>920</PastDueTotalMaximumAmount>
                              <SuppliersCount>1</SuppliersCount>
                              <AccountsCount>1</AccountsCount>
                              <OwedTotalAmount>920</OwedTotalAmount>
                              <TotalPastDueTotalAmount>920</TotalPastDueTotalAmount>
                              <CurrentTotalAmount>0</CurrentTotalAmount>
                              <SummarizedPastDue>
                                 <DaysLowQuantity>121</DaysLowQuantity>
                                 <DaysHighQuantity>150</DaysHighQuantity>
                                 <ExperiencesCount>1</ExperiencesCount>
                                 <TotalAmount>920</TotalAmount>
                              </SummarizedPastDue>
                           </OneMonthDataCoveragePayments>
                        </PurchaserDerivedData>
                        <PurchaserDerivedData>
                           <TradeDataYearMonth>2013-01</TradeDataYearMonth>
                           <OneMonthDataCoveragePayments>
                              <OwedTotalMaximumAmount>920</OwedTotalMaximumAmount>
                              <PastDueTotalMaximumAmount>920</PastDueTotalMaximumAmount>
                              <SuppliersCount>1</SuppliersCount>
                              <AccountsCount>1</AccountsCount>
                              <OwedTotalAmount>920</OwedTotalAmount>
                              <TotalPastDueTotalAmount>920</TotalPastDueTotalAmount>
                              <CurrentTotalAmount>0</CurrentTotalAmount>
                              <SummarizedPastDue>
                                 <DaysLowQuantity>121</DaysLowQuantity>
                                 <DaysHighQuantity>150</DaysHighQuantity>
                                 <ExperiencesCount>1</ExperiencesCount>
                                 <TotalAmount>920</TotalAmount>
                              </SummarizedPastDue>
                           </OneMonthDataCoveragePayments>
                        </PurchaserDerivedData>
                     </Purchaser>
                  </BusinessTrading>
               </Organization>
            </Product>
         </OrderProductResponseDetail>
      </trad:OrderProductResponse>
   </soap-env:Body>
</soapenv:Envelope>
Name Characteristics
OrderProductResponse Aggregate
OrderProductResponse. OrderProductResponseDetail Aggregate, Optional

Records the data being returned to the customer as a result of a product request.

OrderProductResponse. OrderProductResponseDetail. Product Aggregate, Required

Records data about the product ordered by the customer and data about the organization on which the customer has placed this order.

OrderProductResponse. OrderProductResponseDetail. Product. Organization Aggregate, Required

Records data about an organization, a legal or commercial entity established to provide products and/or services in the marketplace or to the community.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. SubjectHeader Aggregate, Required

Records high level information about the subject such as the primary language of the subject and the primary currency in which this subject trades. When the subject is an organizantion, this may also include details such as DUNS Number.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. SubjectHeader. DUNSNumber string, up to 15 chars Pattern: {([0-9a-zA-Z]*)}, Optional [M]

The D-U-N-S Number is D&B's identification number, which provides unique identification of this organization, in accordance with the Data Universal Numbering System (D-U-N-S).

END: OrderProductResponse. OrderProductResponseDetail. Product. Organization. SubjectHeader /Aggregate
OrderProductResponse. OrderProductResponseDetail. Product. Organization. Location Aggregate, Optional

Records the address details for a subject. An address is the designation of a place where a subject can be located or may be communicated with, e.g., primary address, registered address, mailing address.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. Location. PrimaryAddress Aggregate, Optional (Array)

An entry loop to allow the recording of a single primary or physical address of the subject in multiple languages and/or writing scripts. For an organization this is the principal address at which the organization is located. For an individual, this is the home address.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. Location. PrimaryAddress. StreetAddressLine Aggregate, Optional (Array)

An entry loop which can repeat multiple times to allow the recording of several lines where each address line contains one or more named address elements. Examples of named address elements are Street Name, Street Number, Building Name, Estate Name. They are called “lines” because an addres can be divided into multiple lines. When there are multiple lines the sequence of the lines must be preserved.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. Location. PrimaryAddress. StreetAddressLine. LineText string, up to 240 chars, Required [M+]

Text that records the street address components as it would be presented on an address label. This includes, but is not limited to, details such as street name, street number, building name, estate name.

Monitor Path: //Organization /Location /PrimaryAddress

END: OrderProductResponse. OrderProductResponseDetail. Product. Organization. Location. PrimaryAddress. StreetAddressLine /Aggregate
OrderProductResponse. OrderProductResponseDetail. Product. Organization. Location. PrimaryAddress. PrimaryTownName string, up to 64 chars, Optional [M+]

The name of the town or city recognized by the Postal Authority for delivering mail.

Monitor Path: //Organization /Location /PrimaryAddress

OrderProductResponse. OrderProductResponseDetail. Product. Organization. Location. PrimaryAddress. CountryISOAlpha2Code string, at least 2 chars, up to 2 chars, Optional [M+]

The two-letter country code, defined in the ISO 3166-1 scheme published by International Organization for Standardization (ISO), identifying the country for this address.

Monitor Path: //Organization /Location /PrimaryAddress

OrderProductResponse. OrderProductResponseDetail. Product. Organization. Location. PrimaryAddress. CountyOfficialName string, up to 64 chars, Optional [M+]

Monitor Path: //Organization /Location /PrimaryAddress

OrderProductResponse. OrderProductResponseDetail. Product. Organization. Location. PrimaryAddress. PostalCode string, up to 16 chars, Optional [M+]

An identifier used by the local country Postal Authority to identify a particular geographic location. For example, in Belgium, Postal Code 9000 identifies the town of GHENT.

Monitor Path: //Organization /Location /PrimaryAddress

OrderProductResponse. OrderProductResponseDetail. Product. Organization. Location. PrimaryAddress. TerritoryOfficialName string, up to 64 chars, Optional [M+]

Monitor Path: //Organization /Location /PrimaryAddress

OrderProductResponse. OrderProductResponseDetail. Product. Organization. Location. PrimaryAddress. TerritoryAbbreviatedName string, up to 64 chars, Optional [M+]

The shortened name of the locally governed area which forms part of a centrally governed nation. For example 'NJ' for the US State New Jersey within Country United States of America.

Monitor Path: //Organization /Location /PrimaryAddress

END: OrderProductResponse. OrderProductResponseDetail. Product. Organization. Location. PrimaryAddress /Aggregate
OrderProductResponse. OrderProductResponseDetail. Product. Organization. Location. MailingAddress Aggregate, Optional (Array)

An entry loop which can repeat multiple times to allow the recording of address which is mainly utilized for the purpose of mail delivery. This usually includes a Post Office Box number or similar mailing details.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. Location. MailingAddress. StreetAddressLine Aggregate, Optional (Array)

An entry loop which can repeat multiple times to allow the recording of several lines where each address line contains one or more named address elements. Examples of named address elements are Street Name, Street Number, Building Name, Estate Name. They are called “lines” because an addres can be divided into multiple lines. When there are multiple lines the sequence of the lines must be preserved.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. Location. MailingAddress. StreetAddressLine. LineText string, up to 240 chars, Required [M+]

Text that records the street address components as it would be presented on an address label. This includes, but is not limited to, details such as street name, street number, building name, estate name.

Monitor Path: //Organization /Location /MailingAddress

END: OrderProductResponse. OrderProductResponseDetail. Product. Organization. Location. MailingAddress. StreetAddressLine /Aggregate
OrderProductResponse. OrderProductResponseDetail. Product. Organization. Location. MailingAddress. PrimaryTownName string, up to 64 chars, Optional [M+]

The name of the town or city recognized by the Postal Authority for delivering mail.

Monitor Path: //Organization /Location /MailingAddress

OrderProductResponse. OrderProductResponseDetail. Product. Organization. Location. MailingAddress. CountryISOAlpha2Code string, at least 2 chars, up to 2 chars, Optional [M+]

The two-letter country code, defined in the ISO 3166-1 scheme published by International Organization for Standardization (ISO), identifying the country for this address.

Monitor Path: //Organization /Location /MailingAddress

OrderProductResponse. OrderProductResponseDetail. Product. Organization. Location. MailingAddress. CountyOfficialName string, up to 64 chars, Optional [M+]

Monitor Path: //Organization /Location /MailingAddress

OrderProductResponse. OrderProductResponseDetail. Product. Organization. Location. MailingAddress. PostalCode string, up to 16 chars, Optional [M+]

An identifier used by the local country Postal Authority to identify a particular geographic location. For example, in Belgium, Postal Code 9000 identifies the town of GHENT.

Monitor Path: //Organization /Location /MailingAddress

OrderProductResponse. OrderProductResponseDetail. Product. Organization. Location. MailingAddress. TerritoryOfficialName string, up to 64 chars, Optional [M+]

Monitor Path: //Organization /Location /MailingAddress

OrderProductResponse. OrderProductResponseDetail. Product. Organization. Location. MailingAddress. TerritoryAbbreviatedName string, up to 64 chars, Optional [M+]

The shortened name of the locally governed area which forms part of a centrally governed nation. For example 'NJ' for the US State New Jersey within Country United States of America.

Monitor Path: //Organization /Location /MailingAddress

END: OrderProductResponse. OrderProductResponseDetail. Product. Organization. Location. MailingAddress /Aggregate
END: OrderProductResponse. OrderProductResponseDetail. Product. Organization. Location /Aggregate
OrderProductResponse. OrderProductResponseDetail. Product. Organization. Telecommunication Aggregate, Optional

Records information about the different modes of Telecommunication addresses used by a subject for external contact purposes. The modes of communication include telephone, fax, e-mail, web address.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. Telecommunication. TelephoneNumber Aggregate, Optional (Array)

An entry loop which can allow multiple Telephone contact information used for voice communication with the subject.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. Telecommunication. TelephoneNumber. TelecommunicationNumber string, at least 1 char, up to 50 chars, Required [M+]

A sequence of digits used by the subject for voice communication in a public switched telephone network. This sequence of digits includes the area code or city code.

NOTE: This number does not include the International Dialing Code and Domestic Dialing Code.

NOTE: Data provided is formatted as per national conventions for each country

Monitor Path: //Organization /Telecommunication

OrderProductResponse. OrderProductResponseDetail. Product. Organization. Telecommunication. TelephoneNumber. InternationalDialingCode string, up to 7 chars, Optional [M+]

The country calling code assigned by the International Telecommunication Union (ITU) required to connect to this Telecommunication Number of the subject country when dialing from outside the subject country; e.g., '1' for the US, '44' for the UK, '91' for India.

Monitor Path: //Organization /Telecommunication

END: OrderProductResponse. OrderProductResponseDetail. Product. Organization. Telecommunication. TelephoneNumber /Aggregate
OrderProductResponse. OrderProductResponseDetail. Product. Organization. Telecommunication. FacsimileNumber Aggregate, Optional (Array)

An entry loop which can allow multiple Facsimile contact information used for data communication with the subject.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. Telecommunication. FacsimileNumber. TelecommunicationNumber string, at least 1 char, up to 50 chars, Required [M+]

A sequence of digits used by the subject for voice communication in a public switched telephone network. This sequence of digits includes the area code or city code.

NOTE: This number does not include the International Dialing Code and Domestic Dialing Code.

NOTE: Data provided is formatted as per national conventions for each country

Monitor Path: //Organization /Telecommunication

OrderProductResponse. OrderProductResponseDetail. Product. Organization. Telecommunication. FacsimileNumber. InternationalDialingCode string, up to 7 chars, Optional [M+]

The country calling code assigned by the International Telecommunication Union (ITU) required to connect to this Telecommunication Number of the subject country when dialing from outside the subject country; e.g., '1' for the US, '44' for the UK, '91' for India.

Monitor Path: //Organization /Telecommunication

END: OrderProductResponse. OrderProductResponseDetail. Product. Organization. Telecommunication. FacsimileNumber /Aggregate
END: OrderProductResponse. OrderProductResponseDetail. Product. Organization. Telecommunication /Aggregate
OrderProductResponse. OrderProductResponseDetail. Product. Organization. OrganizationName Aggregate, Optional

Records the different names of the organization by which it is known as well as names of other organizations that have a similar name to this organization.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. OrganizationName. OrganizationPrimaryName Aggregate, Optional (Array)

An entry loop which can repeat multiple times to allow the recording of a single name by which the organization is primarily known / identified in different languages and/or writing scripts.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. OrganizationName. OrganizationPrimaryName. OrganizationName string, up to 256 chars, Required [M]

Text recording a name of this organization in the specified language and/or writing script.

END: OrderProductResponse. OrderProductResponseDetail. Product. Organization. OrganizationName. OrganizationPrimaryName /Aggregate
OrderProductResponse. OrderProductResponseDetail. Product. Organization. OrganizationName. TradeStyleName Aggregate, Optional (Array)

An entry loop which can repeat multiple times to allow the recording of a name which an organization trades under for commercial purposes, although its registered, legal name, used for contracts and other formal situations, may be another.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. OrganizationName. TradeStyleName. OrganizationName string, up to 256 chars, Required [M+]

Text recording a name of this organization in the specified language and/or writing script.

Monitor Path: //Organization /OrganizationName /TradeStyleName

END: OrderProductResponse. OrderProductResponseDetail. Product. Organization. OrganizationName. TradeStyleName /Aggregate
End: OrderProductResponse. OrderProductResponseDetail. Product. Organization. OrganizationName /Aggregate
OrderProductResponse. OrderProductResponseDetail. Product. Organization. OrganizationDetail. OperatingStatusText string, up to 256 chars, Optional [M+]

Text describing this organization's functional state / trading status, e.g. active, out of business, dormant.

Possible values: Out of Business; Active; Dormant; Out of business - Unfavourable; Out of business - Favourable; Ceased trading; Assumed Out of Business - Unable to Confirm Active Operations

For US cases - 9077 [Out of business - Favourable]; 9076 [Out of business - Unfavourable]; 9074 [Active]; 403 [Out of business];

For CA cases - 9077 [Out of business - Favourable]; 9076 [Out of business - Unfavourable]; 9074 [Active];

Monitor Path: //Organization /OrganizationDetail /OperatingStatusText@DNBCodeValue

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading Aggregate, Optional

Records references or opinions in terms of the timeliness of payment, the amounts of the transactions and the terms of sale applied to the transactions and summarized views of this data that involves the subject either as a buyer or supplier of goods or services.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser Aggregate, Optional

Records trade data where the subject is a purchaser of good or services.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. CurrentPaydexScore Aggregate, Optional

Records subject's current Paydex Score. A calculated element summarizing the payment habits of a subject based on trade experiences obtained from its suppliers.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. CurrentPaydexScore. TwelveMonthsPaydex Aggregate, Optional (Up to 2x)

An entry loop which can repeat to allow the recording of the numeric value assigned to an organization by a D&B algorithm, assessing the organization's ability to meet future obligations of a particular monetary range based on the twelve most recent months of trade experiences as of the current month, from different sources.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. CurrentPaydexScore. TwelveMonthsPaydex. PaydexScore integer, up to 3 digits, Required [M]

A calculated element summarizing the payment habits of a subject based on trade experiences obtained from its suppliers over the last 3 months.

Paydex score range is from 1 – 100

NOTE: For CA & some more countries, 999 could be the possible value indicating No Score available.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. CurrentPaydexScore. TwelveMonthsPaydex. PaydexDate date, Optional

The date marking the end of the time period covered by the payment performance score.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. CurrentPaydexScore. TwelveMonthsPaydex. TotalUniqueSuppliersUsedCount long, Optional

The number of supplier's whose payment experiences contributed to this payment index score.As an example, the score may have been derived using experiences from 8 different suppliers.

NOTE: Element is only available in DTRI source, not available for RISK and Marketing products.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. CurrentPaydexScore. TwelveMonthsPaydex. TotalPaymentExperiencesUsedCount long, Optional [M]

The number of payment experiences that contributed to this payment index score. As an example, the score may have been derived from 18 payment experiences from various suppliers.

END: OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. CurrentPaydexScore. TwelveMonthsPaydex /Aggregate
OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. CurrentPaydexScore. ThreeMonthsPaydex Aggregate, Optional (Up to 2x)

An entry loop which can repeat to allow the recording of the numeric value assigned to an organization by a D&B algorithm, assessing the organization's ability to meet future obligations of a particular monetary range based on the three most recent months of trade experiences as of the current month, from different sources.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. CurrentPaydexScore. ThreeMonthsPaydex. PaydexScore integer, up to 3 digits, Required

A calculated element summarizing the payment habits of a subject based on trade experiences obtained from its suppliers over the last 3 months.

Paydex score range is from 1 – 100

NOTE: For CA & some more countries, 999 could be the possible value indicating No Score available.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. CurrentPaydexScore. ThreeMonthsPaydex. PaydexDate date, Optional

The date marking the end of the time period covered by the payment performance score.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. CurrentPaydexScore. ThreeMonthsPaydex. TotalUniqueSuppliersUsedCount long, Optional

The number of supplier's whose payment experiences contributed to this payment index score.As an example, the score may have been derived using experiences from 8 different suppliers.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. CurrentPaydexScore. ThreeMonthsPaydex. TotalPaymentExperiencesUsedCount long, Optional

The number of payment experiences that contributed to this payment index score. As an example, the score may have been derived from 18 payment experiences from various suppliers.

END: OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. CurrentPaydexScore. ThreeMonthsPaydex /Aggregate
END: OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. CurrentPaydexScore /Aggregate
OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PaydexScoreHistory. TwelveMonthsPaydex Aggregate, Optional (Array)

An entry loop which can repeat to allow the recording of the calculated element summarizing the payment habits of a subject based on the last twelve months of trade experiences as of the paydex calculation date, from different sources.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PaydexScoreHistory. TwelveMonthsPaydex. PaydexScore integer, up to 3 digits, Required

A calculated element summarizing the payment habits of a subject based on trade experiences obtained from its suppliers over the last 3 months.

Paydex score range is from 1 – 100

NOTE: For CA & some more countries, 999 could be the possible value indicating No Score available.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PaydexScoreHistory. TwelveMonthsPaydex. PaydexDate date, Optional

The date marking the end of the time period covered by the payment performance score.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PaydexScoreHistory. TwelveMonthsPaydex. PaydexDate @DatePrecisionText string, up to 256 chars, Attribute (1x)
OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PaydexScoreHistory. TwelveMonthsPaydex. PaydexDate @DatePrecisionDNBCodeValue integer, up to 7 digits, Attribute (1x)
OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PaydexScoreHistory. TwelveMonthsPaydex. PaydexDate @DatePrecisionDNBCodeTableNumber integer, up to 7 digits, Attribute (1x)
OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PaydexScoreHistory. TwelveMonthsPaydex. TotalUniqueSuppliersUsedCount long, Optional

The number of supplier's whose payment experiences contributed to this payment index score.As an example, the score may have been derived using experiences from 8 different suppliers.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PaydexScoreHistory. TwelveMonthsPaydex. TotalPaymentExperiencesUsedCount long, Optional

The number of payment experiences that contributed to this payment index score. As an example, the score may have been derived from 18 payment experiences from various suppliers.

END: OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PaydexScoreHistory. TwelveMonthsPaydex /Aggregate
OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PaydexScoreHistory. ThreeMonthsPaydex. PaydexScore integer, up to 3 digits, Required [M]

A calculated element summarizing the payment habits of a subject based on trade experiences obtained from its suppliers over the last 3 months.

Paydex score range is from 1 – 100

NOTE: For CA & some more countries, 999 could be the possible value indicating No Score available.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PaydexScoreHistory. ThreeMonthsPaydex. PaydexDate date, Optional

The date marking the end of the time period covered by the payment performance score.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PaydexScoreHistory. ThreeMonthsPaydex. PaydexDate @DatePrecisionText string, up to 256 chars, Attribute (1x)
OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PaydexScoreHistory. ThreeMonthsPaydex. PaydexDate @DatePrecisionDNBCodeValue integer, up to 7 digits, Attribute (1x)
OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PaydexScoreHistory. ThreeMonthsPaydex. PaydexDate @DatePrecisionDNBCodeTableNumber integer, up to 7 digits, Attribute (1x)
OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PaydexScoreHistory. ThreeMonthsPaydex. TotalUniqueSuppliersUsedCount long, Optional

The number of supplier's whose payment experiences contributed to this payment index score.As an example, the score may have been derived using experiences from 8 different suppliers.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PaydexScoreHistory. ThreeMonthsPaydex. TotalPaymentExperiencesUsedCount long, Optional

The number of payment experiences that contributed to this payment index score. As an example, the score may have been derived from 18 payment experiences from various suppliers.

END: OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PaydexScoreHistory. ThreeMonthsPaydex /Aggregate
END: OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PaydexScoreHistory /Aggregate
OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. TradeDataYearMonth date, Optional

The year and month of the payment data which has been grouped and summarized here. Note: For underlying posting data contributing to this summary, this is that data's year and month from the posting date. For underlying pre-summarized data contributing to this summary, this is that data's year and month from the experience date. Only data YYYYMM is valid here, where YYYY denotes the Year and MM denotes the Month. MM is always a number in the range of 1 to 12.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. TradeDataYearMonth @DatePrecisionText string, up to 256 chars, Attribute (1x)
OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. TradeDataYearMonth @DatePrecisionDNBCodeValue integer, up to 7 digits, Attribute (1x)
OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. TradeDataYearMonth @DatePrecisionDNBCodeTableNumber integer, up to 7 digits, Attribute (1x)
OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. ThreeMonthsDataCoveragePayments Aggregate, Optional

Records the details of the data required to calculate the derived value considering three months data.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. ThreeMonthsDataCoveragePayments. PaymentPeriodSummary. SummaryPeriod string, up to 20 chars, Required [M+]

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 specified here. For example, if the value here is 3, meaning 3 months, and the experience date is July 5, 2008, then the summary period is from April 1st through July 4th, or in other words, the complete months of April, May, and June, plus the first four days of July.

Monitor Path: //Organization /BusinessTrading /Purchaser /PurchaserDerivedData

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. ThreeMonthsDataCoveragePayments. PaymentPeriodSummary. PaymentsWithHighCredit. HighCreditMaximumAmount decimal, Optional

The greatest monetary figure owed to the supplier by the subject over the period of time specified by the Summary Period.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. ThreeMonthsDataCoveragePayments. AccountsCount integer, Optional

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 'n' months ending in the Trade Data Year Month.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. ThreeMonthsDataCoveragePayments. TotalPastDueTotalAmount @UnitOfSize string, up to 12 chars, Attribute (1x)
OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. ThreeMonthsDataCoveragePayments. TotalPastDueTotalAmount @CurrencyISOAlpha3Code string, up to 3 chars, Attribute (1x)
OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. ThreeMonthsDataCoveragePayments. TotalPastDueTotalAmount @ReliabilityText string, up to 256 chars, Attribute (1x)
OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. ThreeMonthsDataCoveragePayments. PastDueExperiencesCount integer, Optional

The number of trading relationships between a subject and its suppliers that are beyond terms, satifying the criteria for this aggregation.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. ThreeMonthsDataCoveragePayments. UnfavorableExperiencesCount integer, Optional

The number of trading relationships between a subject and its suppliers that are derogatory, satifying the criteria for this aggregation.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. ThreeMonthsDataCoveragePayments. MonthlyAverageOwedTotalAmount decimal, Optional

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.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. ThreeMonthsDataCoveragePayments. MonthlyAverageOwedTotalAmount @UnitOfSize string, up to 12 chars, Attribute (1x)
OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. ThreeMonthsDataCoveragePayments. MonthlyAverageOwedTotalAmount @CurrencyISOAlpha3Code string, up to 3 chars, Attribute (1x)
OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. ThreeMonthsDataCoveragePayments. MonthlyAverageOwedTotalAmount @ReliabilityText string, up to 256 chars, Attribute (1x)
OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. ThreeMonthsDataCoveragePayments. MonthlyAveragePastDueTotalAmount decimal, Optional

A monetary figure summing the amount from each of a subject's accounts stating how much is beyond terms on average each month, satifying 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.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. ThreeMonthsDataCoveragePayments. MonthlyAveragePastDueTotalAmount @UnitOfSize string, up to 12 chars, Attribute (1x)
OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. ThreeMonthsDataCoveragePayments. MonthlyAveragePastDueTotalAmount @CurrencyISOAlpha3Code string, up to 3 chars, Attribute (1x)
OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. ThreeMonthsDataCoveragePayments. MonthlyAveragePastDueTotalAmount @ReliabilityText string, up to 256 chars, Attribute (1x)
OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. ThreeMonthsDataCoveragePayments. SummarizedPastDue. DaysLowQuantity integer, up to 3 digits, Required
OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. ThreeMonthsDataCoveragePayments. SummarizedPastDue. MonthlyAveragePastDueTotalAmount decimal, Optional

A monetary figure summing the amount from each of a subject's accounts stating how much is beyond terms on average each month, satifying the criteria for this within a specified range of days beyond terms (e.g., 1-30 days, 31-60 days).

END: OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. ThreeMonthsDataCoveragePayments. SummarizedPastDue /Aggregate
END: OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. ThreeMonthsDataCoveragePayments /Aggregate
OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. TwelveMonthsDataCoveragePayments Aggregate, Optional

Records the details of the data required to calculate the derived value considering twelve months data.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. TwelveMonthsDataCoveragePayments. PaymentPeriodSummary. PaymentsWithHighCredit. HighCreditTotalAmount decimal, Optional

A monetary figure specifying the sum of the highest amount from each of a subject’s accounts that was extended to it on the expectation of payment within the agreed upon terms.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. TwelveMonthsDataCoveragePayments. PaymentPeriodSummary. PaymentsWithHighCredit. HighCreditMaximumAmount decimal, Optional [M+]

The greatest monetary figure owed to the supplier by the subject over the period of time specified by the Summary Period.

Monitor Path: //Organization /BusinessTrading /Purchaser /PurchaserDerivedData

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. TwelveMonthsDataCoveragePayments. AccountsCount integer, Optional

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 'n' months ending in the Trade Data Year Month.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. TwelveMonthsDataCoveragePayments. TotalPastDueTotalAmount @UnitOfSize string, up to 12 chars, Attribute (1x)
OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. TwelveMonthsDataCoveragePayments. TotalPastDueTotalAmount @CurrencyISOAlpha3Code string, up to 3 chars, Attribute (1x)
OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. TwelveMonthsDataCoveragePayments. TotalPastDueTotalAmount @ReliabilityText string, up to 256 chars, Attribute (1x)
OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. TwelveMonthsDataCoveragePayments. PastDueExperiencesCount integer, Optional

The number of trading relationships between a subject and its suppliers that are beyond terms, satifying the criteria for this aggregation.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. TwelveMonthsDataCoveragePayments. UnfavorableExperiencesCount integer, Optional

The number of trading relationships between a subject and its suppliers that are derogatory, satifying the criteria for this aggregation.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. TwelveMonthsDataCoveragePayments. MonthlyAverageOwedTotalAmount decimal, Optional

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.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. TwelveMonthsDataCoveragePayments. MonthlyAverageOwedTotalAmount @UnitOfSize string, up to 12 chars, Attribute (1x)
OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. TwelveMonthsDataCoveragePayments. MonthlyAverageOwedTotalAmount @CurrencyISOAlpha3Code string, up to 3 chars, Attribute (1x)
OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. TwelveMonthsDataCoveragePayments. MonthlyAverageOwedTotalAmount @ReliabilityText string, up to 256 chars, Attribute (1x)
OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. TwelveMonthsDataCoveragePayments. MonthlyAveragePastDueTotalAmount decimal, Optional

A monetary figure summing the amount from each of a subject's accounts stating how much is beyond terms on average each month, satifying 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.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. TwelveMonthsDataCoveragePayments. MonthlyAveragePastDueTotalAmount @UnitOfSize string, up to 12 chars, Attribute (1x)
OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. TwelveMonthsDataCoveragePayments. MonthlyAveragePastDueTotalAmount @CurrencyISOAlpha3Code string, up to 3 chars, Attribute (1x)
OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. TwelveMonthsDataCoveragePayments. MonthlyAveragePastDueTotalAmount @ReliabilityText string, up to 256 chars, Attribute (1x)
OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. TwelveMonthsDataCoveragePayments. SummarizedPastDue. DaysLowQuantity integer, up to 3 digits, Required
OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. TwelveMonthsDataCoveragePayments. SummarizedPastDue. MonthlyAveragePastDueTotalAmount decimal, Optional

A monetary figure summing the amount from each of a subject's accounts stating how much is beyond terms on average each month, satifying the criteria for this within a specified range of days beyond terms (e.g., 1-30 days, 31-60 days).

END: OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. TwelveMonthsDataCoveragePayments. SummarizedPastDue /Aggregate
END: OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. TwelveMonthsDataCoveragePayments /Aggregate
OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. TwentyFourMonthsDataCoveragePayments. PaymentPeriodSummary. SatisfactoryPayments Aggregate, Optional

Records the details of payment experiences considered satisfactory.Satisfactory indicated by SATISFACTORY" in Payment notes or indication of "ANTIC"

END: OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. TwentyFourMonthsDataCoveragePayments. PaymentPeriodSummary. SatisfactoryPayments /Aggregate
OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. OneMonthDataCoveragePayments Aggregate, Optional

Records the details of the data required to calculate the derived value considering one month data.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. OneMonthDataCoveragePayments. CashPayments. ExperienceCount integer, Optional

The number of payment experiences which the D&B Worldwide Network has recorded against the subject.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. OneMonthDataCoveragePayments. OwedTotalMaximumAmount decimal, Optional

A monetary figure specifying the highest amount that is due from amongst all of a subject's accounts that satisfy the criteria for this aggregation.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. OneMonthDataCoveragePayments. PastDueTotalMaximumAmount decimal, Optional

A monetary figure specifying the highest amount owed that is beyond terms from amongst all of a subject's accounts satisfying the criteria for this aggregation.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. OneMonthDataCoveragePayments. PaymentPeriodSummary. SummaryPeriod string, up to 20 chars, Required

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 specified here. For example, if the value here is 3, meaning 3 months, and the experience date is July 5, 2008, then the summary period is from April 1st through July 4th, or in other words, the complete months of April, May, and June, plus the first four days of July.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. OneMonthDataCoveragePayments. PaymentPeriodSummary. PaymentsWithHighCredit. HighCreditTotalAmount decimal, Optional

A monetary figure specifying the sum of the highest amount from each of a subject’s accounts that was extended to it on the expectation of payment within the agreed upon terms.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. OneMonthDataCoveragePayments. PaymentPeriodSummary. PaymentsWithHighCredit. AverageHighCreditAmount decimal, Optional

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.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. OneMonthDataCoveragePayments. SuppliersCount integer, Optional

The number of unique suppliers whose payment data that satisfy the criteria for the aggregation.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. OneMonthDataCoveragePayments. CurrentAccountsCount integer, Optional

The number of trading relationships between a subject and its suppliers that are still within terms and that satisfy the criteria for this aggregation.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. OneMonthDataCoveragePayments. OwedTotalAmount decimal, Optional

A monetary figure specifying the cumulative amount that is due to fully settle all of a subject's accounts satisfying the criteria for this aggregation.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. OneMonthDataCoveragePayments. TotalPastDueTotalAmount decimal, Optional

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.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. OneMonthDataCoveragePayments. PastDueExperiencesCount integer, Optional

The number of trading relationships between a subject and its suppliers that are beyond terms, satifying the criteria for this aggregation.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. OneMonthDataCoveragePayments. CurrentAccountsCount integer, Optional

The number of trading relationships between a subject and its suppliers that are still within terms and that satisfy the criteria for this aggregation.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. OneMonthDataCoveragePayments. CurrentTotalAmount decimal, Optional

A monetary figure specifying the cumulative amount owed that is still within terms for all of a subject's accounts that satisfy the criteria for this aggregation.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. OneMonthDataCoveragePayments. PlacedForCollectionExperiencesCount integer, Optional

The number of trading relationships between a subject and its suppliers satisfying the criteria for this aggregation where the subject's accounts are placed with an external collection agency by its suppliers for its failure to pay in whole or part.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. OneMonthDataCoveragePayments. PlacedforCollectionPastDueTotalAmount decimal, Optional

A monetary figure specifying how much has been placed with external collection agencies, satisfying the criteria for this aggregation, across all of a subject's accounts that.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. OneMonthDataCoveragePayments. BadDebtExperiencesCount integer, Optional

The number of trading relationships between a subject and its suppliers, satisfying the criteria for this aggregation, where the suppliers could not collect payment and ultimately wrote off the account as bad debt (thereby taking losses on the outstanding amounts).

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. OneMonthDataCoveragePayments. BadDebtTotalAmount decimal, Optional

A monetary figure specifying how much is owed across all of a subject's accounts, satisfying the criteria for this aggregation, 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 amounts.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. OneMonthDataCoveragePayments. SummarizedPastDue. DaysLowQuantity integer, up to 3 digits, Required
OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. OneMonthDataCoveragePayments. SummarizedPastDue. DaysHighQuantity integer, up to 3 digits, Optional

A number specifying the higher end of the range of days beyond terms, e.g., 30 in the range 1-30 days past due.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. OneMonthDataCoveragePayments. SummarizedPastDue. TotalAmount decimal, Optional

A monetary figure specifying the cumulative amount that is owed within a specified range of days beyond terms (e.g., 1-30 days, 31-60 days), for all the subject's accounts.

OrderProductResponse. OrderProductResponseDetail. Product. Organization. BusinessTrading. Purchaser. PurchaserDerivedData. OneMonthDataCoveragePayments. SummarizedPastDue. AccountsCount integer, Optional

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) for this summary.

END: OrderProductResponse. OrderProductResponseDetail. Product. Organization /Aggregate
END: OrderProductResponse. OrderProductResponseDetail. Product /Aggregate
END: OrderProductResponse. OrderProductResponseDetail /Aggregate
END: OrderProductResponse /Aggregate

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.

Lists of possible values (when present) are subject to change. Additional values not presented in this documentation may be delivered in the response and should be anticipated in any implementation.

Empty/NULL Values

A NULL returned for an element indicates that the information was not provided to D&B when the related data items were collected. The absence of a value for a particular item should not be considered indicative of any implied value (e.g., NULL for a boolean indicator is NOT the same as a value of 'false').

NOTE: There may be additional request and/or response elements specified in the WSDL that are not applicable for D&B Direct customers. Data elements that are not listed on this page are currently unused by this operation.

Response Codes & Error Handling

Successful service requests will return a CM000 response code in the TransactionResult ResultID field. Otherwise, one of the D&B Direct standard response codes will be returned.

This operation may return the following response codes: CM001-CM005, CM007-CM012, CM014, CM017, CM018, PD001, PD003, PD005, PD006, PD015, PD016, and SC001-SC012.

IMPORTANT: PD006 code - Applicable only for US/CA cases when TradeUpIndicator="true" for Risk packets.

D&B Direct 2.0 API requests are provided on a metered basis; and may require entitlement prior to use in the production environment. In addition, a concurrency limit (QPS) is monitored to ensure that it is not exceeded. An error code will be returned in the event that a transaction is throttled.

Qualified usage (e.g., a successful response) is tracked and billed according to the terms & conditions of the customer's contract. The response codes CM000, CM010, PD002 and PD015 are considered successful. A built-in feature exists to prevent duplicate billing when multiple successful 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]).

Retrieving Archived Copies

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.

NOTE: The default value for ArchiveProductOptOutIndicator is 'true', indicating that the request will NOT be automatically archived.

Business Elements

While D&B Direct uses a product canonical naming model in the request/response, many customers may be more familiar with the following business element labels.

This product will also 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, etc.) in addition to the business elements listed.

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

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ TwelveMonthsDataCoveragePayments/ AccountsCount

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.

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ ThreeMonthsDataCoveragePayments/ AccountsCount

Aggregated Experience Date The year and month of the payment data which has been grouped and summarized here.

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ TradeDataYearMonth

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.

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ TwelveMonthsDataCoveragePayments/ SummarizedPastDue/ MonthlyAveragePastDueTotalAmount

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.

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ ThreeMonthsDataCoveragePayments/ SummarizedPastDue/ MonthlyAveragePastDueTotalAmount

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.

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ TwelveMonthsDataCoveragePayments/ SummarizedPastDue/ MonthlyAveragePastDueTotalAmount

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.

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ ThreeMonthsDataCoveragePayments/ SummarizedPastDue/ MonthlyAveragePastDueTotalAmount

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.

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ TwelveMonthsDataCoveragePayments/ SummarizedPastDue/ MonthlyAveragePastDueTotalAmount

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.

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ ThreeMonthsDataCoveragePayments/ SummarizedPastDue/ MonthlyAveragePastDueTotalAmount

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.

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ TwelveMonthsDataCoveragePayments/ MonthlyAverageOwedTotalAmount

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.

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ ThreeMonthsDataCoveragePayments/ MonthlyAverageOwedTotalAmount

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

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ TwelveMonthsDataCoveragePayments/ MonthlyAveragePastDueTotalAmount

Average Monthly Past Due Amount within 3 Months Average of all experiences within the past three months showing Past Due Amounts

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ ThreeMonthsDataCoveragePayments/ MonthlyAveragePastDueTotalAmount

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

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ OneMonthDataCoveragePayments/ BadDebtTotalAmount

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

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ OneMonthDataCoveragePayments/ PaymentPeriodSummary/ PaymentsWithHighCredit/ HighCreditTotalAmount

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

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ OneMonthDataCoveragePayments/ CurrentAccountsCount

D&B Paydex Score - 12 Months of Trade Experiences It is calculation of Paydex score based on the most recent 12 months

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ CurrentPaydexScore/ TwelveMonthsPaydex/ PaydexScore

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.

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ OneMonthDataCoveragePayments/ PastDueTotalMaximumAmount

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.

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ TwelveMonthsDataCoveragePayments/ PaymentPeriodSummary/ PaymentsWithHighCredit/ HighCreditMaximumAmount

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.

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ ThreeMonthsDataCoveragePayments/ PaymentPeriodSummary/ PaymentsWithHighCredit/ HighCreditMaximumAmount

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.

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ OneMonthDataCoveragePayments/ SummarizedPastDue/ AccountsCount

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.

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ OneMonthDataCoveragePayments/ SummarizedPastDue/ AccountsCount

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.

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ OneMonthDataCoveragePayments/ SummarizedPastDue/ AccountsCount

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.

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ OneMonthDataCoveragePayments/ SummarizedPastDue/ AccountsCount

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.

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ OneMonthDataCoveragePayments/ SummarizedPastDue/ AccountsCount

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.

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ OneMonthDataCoveragePayments/ SummarizedPastDue/ AccountsCount

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.

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ OneMonthDataCoveragePayments/ SummarizedPastDue/ AccountsCount

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.

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ OneMonthDataCoveragePayments/ SummarizedPastDue/ AccountsCount

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.

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ OneMonthDataCoveragePayments/ SummarizedPastDue/ AccountsCount

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.

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ OneMonthDataCoveragePayments/ PaymentPeriodSummary/ PaymentsWithHighCredit/ AverageHighCreditAmount

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.

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ OneMonthDataCoveragePayments/ PaymentPeriodSummary/ PaymentsWithHighCredit/ AverageHighCreditAmount

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.

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ OneMonthDataCoveragePayments/ OwedTotalMaximumAmount

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.

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ OneMonthDataCoveragePayments/ SummarizedPastDue/ TotalAmount

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.

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ OneMonthDataCoveragePayments/ TotalPastDueTotalAmount

Monthly Total Past Due Amount of Trade Experiences Placed for Collection

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ OneMonthDataCoveragePayments/ PlacedforCollectionPastDueTotalAmount

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

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ OneMonthDataCoveragePayments/ BadDebtExperiencesCount

Monthly Trade Experience Cash Payments Count The number of cash experiences recorded in D&B's database.

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ OneMonthDataCoveragePayments/ CashPayments/ ExperienceCount

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.

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ OneMonthDataCoveragePayments/ PastDueExperiencesCount

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.

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ OneMonthDataCoveragePayments/ PlacedForCollectionExperiencesCount

Out of Business Indicator Text that records the operating status of the business.

PCM XPath: //Organization/ OrganizationDetail/ OperatingStatusText

Paydex - 3 Month Calculation It is calculation of Paydex score based on the most recent 3 months

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ CurrentPaydexScore/ ThreeMonthsPaydex/ PaydexScore

Paydex Date - 12 Months The month and year that the corresponding PAYDEX score was calculated.

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ CurrentPaydexScore/ TwelveMonthsPaydex/ PaydexDate

Paydex Date - 3 Months The month and year that the corresponding PAYDEX score was calculated.

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ CurrentPaydexScore/ ThreeMonthsPaydex/ PaydexDate

Prior D&B Paydex Score - 12 Months of Trade Experiences It is the prior month end 12 month paydex

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PaydexScoreHistory/ TwelveMonthsPaydex/ PaydexScore

Prior D&B Paydex Score - 3 Months of Trade Experiences in-date (active) matched trading accounts with suppliers

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PaydexScoreHistory/ ThreeMonthsPaydex/ PaydexScore

Prior Paydex Date - 12 Months The month and year that the corresponding PAYDEX score was calculated.

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PaydexScoreHistory/ TwelveMonthsPaydex/ PaydexDate

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.

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ ThreeMonthsDataCoveragePayments/ PaymentPeriodSummary/ SummaryPeriod

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.

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ OneMonthDataCoveragePayments/ SummarizedPastDue/ TotalAmount

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.

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ OneMonthDataCoveragePayments/ SummarizedPastDue/ TotalAmount

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.

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ OneMonthDataCoveragePayments/ SummarizedPastDue/ TotalAmount

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.

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ OneMonthDataCoveragePayments/ SummarizedPastDue/ TotalAmount

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.

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ OneMonthDataCoveragePayments/ SummarizedPastDue/ TotalAmount

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.

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ OneMonthDataCoveragePayments/ SummarizedPastDue/ TotalAmount

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.

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ OneMonthDataCoveragePayments/ SummarizedPastDue/ TotalAmount

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.

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ OneMonthDataCoveragePayments/ SummarizedPastDue/ TotalAmount

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.

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ TwelveMonthsDataCoveragePayments/ PaymentPeriodSummary/ PaymentsWithHighCredit/ HighCreditTotalAmount

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.

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ ThreeMonthsDataCoveragePayments/ PastDueExperiencesCount

Total Number of Experiences with Unfavorable Comments - 12 Months Records the number of trade experiences that have unfavorable comments within the last 12 months

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ TwelveMonthsDataCoveragePayments/ UnfavorableExperiencesCount

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.

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ ThreeMonthsDataCoveragePayments/ UnfavorableExperiencesCount

Total Number of Suppliers The number of unique suppliers whose payment data is required to calculate trade data considering one month data.

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ OneMonthDataCoveragePayments/ SuppliersCount

Trade Experience Count - 12 Month Paydex The number of trade experiences used for the 12 month Paydex Calculation

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ CurrentPaydexScore/ TwelveMonthsPaydex/ TotalPaymentExperiencesUsedCount

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.

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ CurrentPaydexScore/ TwelveMonthsPaydex/ TotalUniqueSuppliersUsedCount

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.

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ CurrentPaydexScore/ ThreeMonthsPaydex/ TotalPaymentExperiencesUsedCount

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

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ PurchaserDerivedData/ TwelveMonthsDataCoveragePayments/ PastDueExperiencesCount

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.

PCM XPath: //Organization/ BusinessTrading/ Purchaser/ CurrentPaydexScore/ ThreeMonthsPaydex/ TotalUniqueSuppliersUsedCount

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

Standard Elements

Whenever a D&B Direct data or report product request returns a single D-U-N-S Number, several business elements pertaining to that company will be included with the results.

These elements include D-U-N-S Number*, Organization Name, Primary Address** (including street, city, state, postal code, country), Mailing Address** (including street, city, state, postal code, county), Telephone Number, Fax Number, Trade Styles (up to five), Family Tree Role (HQ, branch), a Standalone Organization Indicator(true/false) and the PortfolioAssetID***.

All standard elements (with the exception of Family Tree Role and PortfolioAssetID) may be referenced by the Monitoring process.

* The D-U-N-S Number of the organization referenced in the results. In the case of a trade up, this will be the headquarters D-U-N-S Number.

** Addresses are returned as they are recieved by D&B and therefore may not conform to local postal formatting specifications.

*** This is an identification number that can be used to retrieve a given results package at a later date from the Product Request Archive (if/when that feature is enabled in a request).

Name Description
D-U-N-S Number The D-U-N-S Number is D&B's identification number, which provides unique identification of this organization, in accordance with the Data Universal Numbering System (D-U-N-S). This DUNS Number represents the business entity.
Country Code The two-letter country code, defined by the International Organization for Standardization (ISO) ISO 3166-1 scheme identifying the country of the business entity.
County Name Text recording the name of the county in which the business is located.
Family Tree Member Role Text recording of various parts that the Subject plays as a member of an ownership structured family tree.
FAX Number The FAX number of the business.
FAX Number International Dialing Code The FAX number international dialing code of the business.
Mailing Country Code The two-letter country code, defined by the International Organization for Standardization (ISO) ISO 3166-1 scheme identifying the country which the business uses for mailing purposes.
Mailing County Name Text recording the name of the county which the business uses for mailing purposes.
Mailing Postal Code An identifier used by the local country Postal Authority which the business uses for mailing purposes.
Mailing Street Text recording an address which is mainly utilized for the purpose of mail delivery to the business. This usually includes a Post Office Box number or similar mailing details.
Mailing Street (2) Text recording an address which is mainly utilized for the purpose of mail delivery to the business. This usually includes a Post Office Box number or similar mailing details.
Mailing Territory Abbreviation Text recording the shortened name of the locally governed area which forms part of a centrally governed nation which the business uses for mailing purposes.
Mailing Territory Name Text recording the name of the locally governed area which forms part of a centrally governed nation which the business uses for mailing purposes.
Mailing Town Name The address number, or post office box number, and street name which a business uses for mailing purposes.
Postal Code An identifier used by the local country Postal Authority to identify where the business is located.
Primary Business Name Text recording of a single name by which the organization is primarily known or identified.
Standalone Organization Indicator When true indicates that this organization is not a member of a legal family tree. The Subject has no Parent Company, no subsidiaries or no branch/division locations.
Street Address Text recording the address number, or post office box number and street name where the business is located.
Street Address (2) Text recording the address number, or post office box number and street name where the business is located.
Telephone Number The telephone number of the business.
Telephone Number International Dialing Code The telephone number international dialing code of the business.
Territory Abbreviated Name Text recording the shortened name of the locally governed area which forms part of a centrally governed nation to identify where the business is located.
Territory Name Text recording the name of the locally governed area which forms part of a centrally governed nation to identify where the business is located.
Town Name Text recording the name of a city, town, township, village, borough, etc. where the business is located.
Trade Style Name Text recording the name which an organization trades under for commercial purposes although its registered legal name used for contracts and other formal situations may be another name.

Product Notes

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.