Payment Information - Detail
Product | D&B Direct 2.0 |
Product Code(s) | PI_DTL |
Level(s) | Standard |
Monitoring Available | No |
Interface | SOAP |
WSDL | download |
Format(s) | XML |
Service | TradeDetail |
Operation | OrderProduct |
{version} | 4.0 |
4.0 Released On | January 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 November 09, 2020.
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
<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.
<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: |
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,PD019 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.