/SRMSMC/D_DNB_PR - D&B Interface: Other GDP Products - Persistence
D&B Interface: Other GDP Products - Persistence information is stored in SAP table /SRMSMC/D_DNB_PR.
It is part of development package /SRMSMC/FND_MO_BP_BL in software component SLC-SUP. This development package consists of objects that can be grouped under "Package for Business Logic of the BO Business Partner".
It is part of development package /SRMSMC/FND_MO_BP_BL in software component SLC-SUP. This development package consists of objects that can be grouped under "Package for Business Logic of the BO Business Partner".
Fields for table /SRMSMC/D_DNB_PR
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | * |
| .INCLUDE | X | /SRMSMC/S_DNB_PR_KEY | 0 | |||
| REQUEST | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | X | TIMESTAMP | DEC | 8 | |
| PRODUCT | Type of the DNB Report | X | /SRMSMC/DNB_PRODUCT | CHAR | 64 | |
| DUNS | Unique D&B identifier for this company | X | /SRMSMC/DNB_DUNS_NBR | CHAR | 26 | |
| .INCLUDE | /SRMSMC/S_DNB_PR_DB | 0 | ||||
| CREA_UNAME | User Name | UNAME | CHAR | 24 | ||
| SRVRTID | D&B Server transaction identifier | /SRMSMC/DNB_SRVRTID | CHAR | 70 | ||
| GDA_ID | D&B GDA ID | /SRMSMC/DNB_GDA_ID | STRG | 8 | ||
| CACHE_IND | Indicator if the report is retrieved from the D&B archive | /SRMSMC/DNB_CACHE_IND | CHAR | 2 | ||
| PRD_DT | Original Request Date of the cached D&B report | /SRMSMC/DNB_PRD_DT | CHAR | 60 | ||
| DUNS_NBR | Unique D&B identifier for this company | /SRMSMC/DNB_DUNS_NBR | CHAR | 26 | ||
| PRIM_NME | The primary name of the business | /SRMSMC/DNB_PRIM_NME | STRG | 8 | ||
| POST_TOWN | Postal town where the business is located | /SRMSMC/DNB_POST_TOWN | CHAR | 100 | ||
| PRIM_GEO_AREA | Main sub-entity within the ctry/reg, such as state, province | /SRMSMC/DNB_PRIM_GEO_AREA | CHAR | 100 | ||
| POST_CODE | The country/region-specific post code | /SRMSMC/DNB_POST_CODE | CHAR | 20 | ||
| CTRY_CD | The 2-character ISO code for the country/region | /SRMSMC/DNB_CTRY_CD | CHAR | 32 | ||
| BR_IND | Indicates whether subject is a branch location | /SRMSMC/DNB_BR_IND | CHAR | 10 | ||
| ACT_PAY | Am. of merch. purch. on credit and not paid for by the bal. | /SRMSMC/DNB_ACT_PAY | CURR | 14 | ||
| ACT_REC | Amount of sales made and billed to customers on credit terms | /SRMSMC/DNB_ACT_REC | CURR | 14 | ||
| ACTIVITY_TEXT | Summary Primary Line Of Business | /SRMSMC/DNB_ACTIVITY_TEXT | STRG | 8 | ||
| ADDL_SIC | Standard Industrial Classification | /SRMSMC/DNB_ADDL_SIC | NUMC | 16 | ||
| ADDL_SIC_TYPE_CD | Version of SIC | /SRMSMC/DNB_ADDL_SIC_TYPE_CD | CHAR | 8 | ||
| ADR_TENR_TYPE_CD | Ind. wheth. premises at physical address are owned or rented | /SRMSMC/DNB_ADR_TENR_TYPE_CD | CHAR | 2 | ||
| ANN_SALE_CONS_IND | Qualifies annual sales volume | /SRMSMC/DNB_ANN_SALE_CONS_IND | CHAR | 10 | ||
| ANN_SALE_CRCY_CD | Currency code for annual sales if different than default. | /SRMSMC/DNB_ANN_SALE_CRCY_CD | CUKY | 10 | ||
| ANN_SALE_ESTD_IND | Qualifies annual sales volume | /SRMSMC/DNB_ANN_SALE_ESTD_IND | CHAR | 10 | ||
| ANN_SALE_VOL | Annual sales generated by the business | /SRMSMC/DNB_ANN_SALE_VOL | CURR | 14 | ||
| ANN_SALE_VOL_TEXT | Ann. sales gen. by the bus. when can not be mapped to num. | /SRMSMC/DNB_ANN_SALE_VOL_TEXT | CHAR | 60 | ||
| ASET | Describes items of value which are held, owned or managed by | /SRMSMC/DNB_ASET | NUMC | 14 | ||
| AUDT_IND | Indicates type of financial statement | /SRMSMC/DNB_AUDT_IND | CHAR | 10 | ||
| AUDT_QLFN_IND | Describes financial statement | /SRMSMC/DNB_AUDT_QLFN_IND | CHAR | 10 | ||
| AVG_HIGH_CR | Average of all high credit payment experiences | /SRMSMC/DNB_AVG_HIGH_CR | CURR | 14 | ||
| BUS_REGN_NBR | Prim. bus. ident. number assigned by a gov. agency | /SRMSMC/DNB_BUS_REGN_NBR | CHAR | 64 | ||
| BUS_REGN_NBR_TYPE_CD | Code repres. main business ident. number used in the ctry/rg | /SRMSMC/DNB_BUS_REGN_NBR_TC | CHAR | 10 | ||
| BUS_STRU | Indicates whether subject is a parent or subsidiary location | /SRMSMC/DNB_BUS_STRU | CHAR | 10 | ||
| CAPL_AMT | Amount of capital which has been issued | /SRMSMC/DNB_CAPL_AMT | CURR | 14 | ||
| CAPL_CRCY_CD | Currency code for capital amount if different than default | /SRMSMC/DNB_CAPL_CRCY_CD | CUKY | 10 | ||
| CAPL_TYPE_CD | Type of capital | /SRMSMC/DNB_CAPL_TYPE_CD | CHAR | 60 | ||
| CASH_LIQ_ASET | Amount of cash on hand and in banks and other liquid assets. | /SRMSMC/DNB_CASH_LIQ_ASET | CURR | 14 | ||
| CEO_NME | Name of the primary executive in the company | /SRMSMC/DNB_CEO_NME | STRG | 8 | ||
| CEO_TITL | Free form title of primary executive | /SRMSMC/DNB_CEO_TITL | STRG | 8 | ||
| CLM_IND | Indic. wheth. open, legal claims, lien(s), prot.bill(s) | /SRMSMC/DNB_CLM_IND | CHAR | 10 | ||
| CONS_IND | Indicates whether statement is consolidated or not. | /SRMSMC/DNB_CONS_IND | CHAR | 10 | ||
| COST_OF_SLS | Cost Of Goods Sold (Cost Of Goods Sold for Manufacturers) | /SRMSMC/DNB_COST_OF_SLS | CURR | 14 | ||
| CR_IND | Indicates credit recommendation when no amount available | /SRMSMC/DNB_CR_IND | CHAR | 4 | ||
| CR_SCR | Indicates the risk of delinquent payments. | /SRMSMC/DNB_CR_SCR | NUMC | 6 | ||
| CRCY_CD | Default currency code for figures in report code. | /SRMSMC/DNB_CRCY_CD | CUKY | 10 | ||
| CRIM_IND | Indicates whether criminal proceedings exist | /SRMSMC/DNB_CRIM_IND | CHAR | 10 | ||
| CURR_CNTL_YR | Year current control was assumed | /SRMSMC/DNB_CURR_CNTL_YR | NUMC | 8 | ||
| CURR_RATO | Current Assets divided by Current Liabilities | /SRMSMC/DNB_CURR_RATO | NUMC | 20 | ||
| DBTR_IN_POSN_IND | Indicates whether debtor is in possession of company | /SRMSMC/DNB_DBTR_IN_POSN_IND | CHAR | 2 | ||
| DIVD | Dividends paid to shareholders | /SRMSMC/DNB_DIVD | CURR | 14 | ||
| CR_SCR_CLAS | Score class description | /SRMSMC/DNB_CR_SCR_CLAS | CHAR | 240 | ||
| DNB_RATG | Rating assigned by D&B® | /SRMSMC/DNB_DNB_RATG | CHAR | 10 | ||
| DOM_ULT_CTRY_CD | Country/Region where business located | /SRMSMC/DNB_DOM_ULT_CTRY_CD | CHAR | 4 | ||
| DOM_ULT_PNT_DUNS | DUNS Nr. of ultimate parent company within the same county | /SRMSMC/DNB_DOM_ULT_PNT_DUNS | CHAR | 26 | ||
| DOM_ULT_PNT_NME | Name of the ultimate parent company within the same ctry/reg | /SRMSMC/DNB_DOM_ULT_PNT_NME | STRG | 8 | ||
| DSR | Indicator signifying company is a D-U-N-S� Support Record | /SRMSMC/DNB_DSR | CHAR | 2 | ||
| DSTR_IND | Ind. wheth. special events available concerning disasters | /SRMSMC/DNB_DSTR_IND | CHAR | 10 | ||
| EMPL_AT_PRIM_ADR | 10 | /SRMSMC/DNB_EMPL_AT_PRIM_ADR | CHAR | 20 | ||
| EMPL_AT_PRIM_ADR_ESTD_IND | Qualifies calculation of employees here (estimated) | /SRMSMC/DNB_EMPL_APRAD_EST_IND | CHAR | 10 | ||
| EMPL_AT_PRIM_ADR_MIN_IND | Qualifies calculation of employees here (minimum) | /SRMSMC/DNB_EMPL_APRAD_MIN_IND | CHAR | 10 | ||
| EMPL_AT_PRIM_ADR_TEXT | Nr of pers. employed by business at the referenced loc. text | /SRMSMC/DNB_EMPL_APRAD_TEXT | CHAR | 24 | ||
| ESTD_IND | Indicates type of financial statement | /SRMSMC/DNB_ESTD_IND | CHAR | 10 | ||
| EXPT_IND | Indicates whether exports or not | /SRMSMC/DNB_EXPT_IND | CHAR | 10 | ||
| FAIL_SCR | For US the value rep. the Fail. Risk (Financial Stress) 1-5 | /SRMSMC/DNB_FAIL_SCR | CHAR | 6 | ||
| FAIL_SCR_12_MO_AGO | Failure Risk Score calculated 12 months prior | /SRMSMC/DNB_FAIL_SCR_12_MO_AGO | NUMC | 6 | ||
| FAIL_SCR_6_MO_AGO | Failure Risk Score as it was calculated 6 prior | /SRMSMC/DNB_FAIL_SCR_6_MO_AGO | NUMC | 6 | ||
| FAIL_SCR_IND_PCTG | Industry percentile reflects the relative ranking of a comp. | /SRMSMC/DNB_FAIL_SCR_IND_PCTG | NUMC | 6 | ||
| FAIL_SCR_NATL_PCTG | National 1-100 score reflects the relative ranking of a comp | /SRMSMC/DNB_FAIL_SCR_NATL_PCTG | NUMC | 6 | ||
| FAIL_SCR_OVRD_CD | Europe: ind. the reason for var. betw. D&B and Failure nat. | /SRMSMC/DNB_FAIL_SCR_OVRD_CD | CHAR | 6 | * | |
| FAX_NBR | Main facsimile number of business | /SRMSMC/DNB_FAX_NBR | CHAR | 64 | ||
| FCST_IND | Describes financial statement | /SRMSMC/DNB_FCST_IND | CHAR | 10 | ||
| FINL_EMBT_IND | Ind. whet. open bankruptcy, receivership liquid. or equiv. | /SRMSMC/DNB_FINL_EMBT_IND | CHAR | 10 | ||
| FINL_LGL_EVNT_IND | Ind. whet. special events available including fin.emb. leg.f | /SRMSMC/DNB_FINL_LGL_EVNT_IND | CHAR | 10 | ||
| FISC_IND | Describes financial statement | /SRMSMC/DNB_FISC_IND | CHAR | 10 | ||
| FIXD_ASET | Am. of property owned by a business that has a life > 1 year | /SRMSMC/DNB_FIXD_ASET | CURR | 14 | ||
| FLNG_CRCY_CD | Currency code for value | /SRMSMC/DNB_FLNG_CRCY_CD | CUKY | 10 | ||
| FLNG_NBR | Number of filings in category | /SRMSMC/DNB_FLNG_NBR | NUMC | 10 | ||
| FLNG_TYPE | Type of Filing Category eg suit, claim, Judgement, prot.bill | /SRMSMC/DNB_FLNG_TYPE | CHAR | 10 | ||
| FLNG_VAL | Value of open filings | /SRMSMC/DNB_FLNG_VAL | CURR | 14 | ||
| FNAL_IND | Describes financial statement | /SRMSMC/DNB_FNAL_IND | CHAR | 10 | ||
| GBL_ULT_CTRY_CD | Country/Region where business located | /SRMSMC/DNB_GBL_ULT_CTRY_CD | CHAR | 4 | ||
| GBL_ULT_PNT_DUNS | DUNS Number of the ultimate parent company of business | /SRMSMC/DNB_GBL_ULT_PNT_DUNS | NUMC | 26 | ||
| GBL_ULT_PNT_NME | Name of the ultimate parent company of business. | /SRMSMC/DNB_GBL_ULT_PNT_NME | STRG | 8 | ||
| SER_RAT | Supplier Evaluation Risk Rating | /SRMSMC/DNB_SER_RAT | NUMC | 2 | ||
| GROS_INCM | Am. left over after deduc. the Cost of Gds. sold from n.sale | /SRMSMC/DNB_GROS_INCM | CURR | 14 | ||
| HIGH_CR | Maximum credit of any payment experience | /SRMSMC/DNB_HIGH_CR | CURR | 14 | ||
| HIST_IND | Code indicating whether detrimental information exists | /SRMSMC/DNB_HIST_IND | CHAR | 10 | ||
| HQ_CTRY_CD | Country/Region where business located | /SRMSMC/DNB_HQ_CTRY_CD | CHAR | 4 | ||
| HQ_DUNS | DUNS Number of Headquarters location. | /SRMSMC/DNB_HQ_DUNS | NUMC | 26 | ||
| HQ_NME | Name of Headquarters | /SRMSMC/DNB_HQ_NME | STRG | 8 | ||
| IMPT_IND | Indicates whether imports or not | /SRMSMC/DNB_IMPT_IND | CHAR | 10 | ||
| INCM_STMT_DT | Date of Income/Profit and Loss Statement | /SRMSMC/DNB_INCM_STMT_DT | DATS | 16 | ||
| INCN_YR | Year business incorporated | /SRMSMC/DNB_INCN_YR | NUMC | 8 | ||
| INTL_DLNG_CD | International dialing code for country/region | /SRMSMC/DNB_INTL_DLNG_CD | NUMC | 8 | ||
| ITNG_ASET | Total of intangible assets. | /SRMSMC/DNB_ITNG_ASET | CURR | 14 | ||
| LCL_ACTV_CD | Local Activity Classification Code | /SRMSMC/DNB_LCL_ACTV_CD | CHAR | 16 | ||
| LCL_ACTV_CD_TYPE | Activity Classification Code type identifier | /SRMSMC/DNB_LCL_ACTV_CD_TYPE | CHAR | 14 | ||
| LGL_FORM | Legal structure as registered with governmental authorities | /SRMSMC/DNB_LGL_FORM | CHAR | 20 | * | |
| LOCN_STAT | Ind. whet. subject is a headquarters, branch or single loc. | /SRMSMC/DNB_LOCN_STAT | CHAR | 10 | ||
| LT_DBT | Long Term Debt owed by business. | /SRMSMC/DNB_LT_DBT | CURR | 14 | ||
| MAX_CR | Maximum amount of credit recommended | /SRMSMC/DNB_MAX_CR | CURR | 14 | ||
| MAX_CR_CRCY_CD | Currency Code for credit recom. amount if different than def | /SRMSMC/DNB_MAX_CR_CRCY_CD | CUKY | 10 | ||
| NBR_NEG_PMT | Number of negative payment experiences | /SRMSMC/DNB_NBR_NEG_PMT | NUMC | 6 | ||
| NET_INCM | Amount left over after all expenses and taxes are deducted. | /SRMSMC/DNB_NET_INCM | CURR | 14 | ||
| NET_WRTH | Total am. of Equity (Net Worth) Includes capital stock etc. | /SRMSMC/DNB_NET_WRTH | CURR | 14 | ||
| NON_POST_TOWN | Non-postal town | /SRMSMC/DNB_NON_POST_TOWN | CHAR | 100 | ||
| OPEN_IND | Describes financial statement | /SRMSMC/DNB_OPEN_IND | CHAR | 10 | ||
| OPRG_SPEC_EVNT_IND | Ind. whet. special events available concerning change to op | /SRMSMC/DNB_OPRG_SPEC_EVNT_IND | CHAR | 10 | ||
| OTHR_SPEC_EVNT_IND | Ind. whet. special events available not otherwise specified | /SRMSMC/DNB_OTHR_SPEC_EVNT_IND | CHAR | 10 | ||
| OUT_BUS_IND | Indicator signifying company is out of business | /SRMSMC/DNB_OUT_BUS_IND | CHAR | 2 | ||
| PAYD_3_MO_AGO | D&B PAYDEX® Score 3 months ago | /SRMSMC/DNB_PAYD_3_MO_AGO | NUMC | 6 | ||
| PAYD_NORM | Industry D&B PAYDEX® score median or average | /SRMSMC/DNB_PAYD_NORM | NUMC | 6 | ||
| PAYD_SCR | D&B PAYDEX Score for last 12 months experiences | /SRMSMC/DNB_PAYD_SCR | NUMC | 6 | ||
| PNT_CTRY_CD | Country/Region where business is located | /SRMSMC/DNB_PNT_CTRY_CD | CHAR | 4 | ||
| PNT_DUNS | DUNS Number of immediate parent company of the subject bus. | /SRMSMC/DNB_PNT_DUNS | NUMC | 18 | ||
| PNT_NME | Name of immediate parent comp. (comp. owning more than 50%) | /SRMSMC/DNB_PNT_NME | STRG | 8 | ||
| PREV_NET_WRTH | Previous Net Worth minus intangibles | /SRMSMC/DNB_PREV_NET_WRTH | CURR | 14 | ||
| PREV_SLS | Net sales for previous period | /SRMSMC/DNB_PREV_SLS | CURR | 14 | ||
| PREV_STMT_DT | Date of previous financial statement | /SRMSMC/DNB_PREV_STMT_DT | CHAR | 8 | ||
| PREV_WRKG_CAPL | Previous Working Capital (Current Assets minus Current Liab) | /SRMSMC/DNB_PREV_WRKG_CAPL | CURR | 14 | ||
| PRIM_SIC | Standard Industrial Classification (SIC) Code | /SRMSMC/DNB_PRIM_SIC | CHAR | 16 | ||
| PRIM_SIC_TYPE_CD | Version of Standard Industrial Classification (SIC) | /SRMSMC/DNB_PRIM_SIC_TYPE_CD | CHAR | 8 | ||
| PRO_FRMA_IND | Indicates that the financial statement figures are pro forma | /SRMSMC/DNB_PRO_FRMA_IND | CHAR | 10 | ||
| QK_RATO | Cash plus Accounts Receivable divided by Current Liabilities | /SRMSMC/DNB_QK_RATO | NUMC | 20 | ||
| REGN_TYPE | Type of registration (for example, non-profit) | /SRMSMC/DNB_REGN_TYPE | CHAR | 12 | ||
| REST_IND | Indicates figures resubmitted after corrections to original | /SRMSMC/DNB_REST_IND | CHAR | 10 | ||
| RETN_ERNG | Retained earnings | /SRMSMC/DNB_RETN_ERNG | CURR | 14 | ||
| SCDY_GEO_AREA | County (or equivalent) where business located Second level | /SRMSMC/DNB_SCDY_GEO_AREA | CHAR | 100 | ||
| SCRD_FLNG_IND | Indicates whether open secured filings exist for a business | /SRMSMC/DNB_SCRD_FLNG_IND | CHAR | 10 | ||
| SD_IND | Ind. company record is on Stop Distribution stat in D&B DB | /SRMSMC/DNB_SD_IND | CHAR | 2 | ||
| SGND_IND | Indicates if figures are signed by principals | /SRMSMC/DNB_SGND_IND | CHAR | 10 | ||
| SLS | Net sales for the period after returns | /SRMSMC/DNB_SLS | CURR | 14 | ||
| STAT | Indicator containing in date status | /SRMSMC/DNB_STAT | CHAR | 2 | ||
| STK | Includes merchandise on hand, ready to be sold | /SRMSMC/DNB_STK | CURR | 14 | ||
| STMT_CRCY_CD | Currency code of financial statement if different than defau | /SRMSMC/DNB_STMT_CRCY_CD | CHAR | 6 | ||
| STMT_DT | Date of current financial statement | /SRMSMC/DNB_STMT_DT | DATS | 16 | ||
| STMT_FROM_DT | Starting Date of Profit and Loss Statement | /SRMSMC/DNB_STMT_FROM_DT | DATS | 16 | ||
| STMT_TO_DT | Ending Date or Profit and Loss Statement | /SRMSMC/DNB_STMT_TO_DT | DATS | 16 | ||
| STRT_YR | Year business actually started | /SRMSMC/DNB_STRT_YR | NUMC | 8 | ||
| SUIT_JDGT_IND | Indicates open suits, judgment, petitions or payment remarks | /SRMSMC/DNB_SUIT_JDGT_IND | CHAR | 10 | ||
| TANG_NET_WRTH | Net worth minus intangibles | /SRMSMC/DNB_TANG_NET_WRTH | CURR | 14 | ||
| TANG_NET_WRTH_CRCY_CD | Currency code for tangible net worth if different than defau | /SRMSMC/DNB_TANG_NET_WRTH_CRCY | CUKY | 10 | ||
| TANG_NET_WRTH_ESTD_IND | Code indicating reliability of Tangible Net Worth figure | /SRMSMC/DNB_TANG_NET_WRTH_ESTD | CHAR | 10 | ||
| TANG_NET_WRTH_TEXT | Net worth minus intangibles - text field | /SRMSMC/DNB_TANG_NET_WRTH_TEXT | CHAR | 60 | ||
| TLCM_NBR | The main telephone number of the business | /SRMSMC/DNB_TLCM_NBR | CHAR | 64 | ||
| TOT_ASET | Total amount of current and long-term assets | /SRMSMC/DNB_TOT_ASET | CURR | 14 | ||
| TOT_CURR_ASET | Total amount of all current (< 1 year) assets | /SRMSMC/DNB_TOT_CURR_ASET | CURR | 14 | ||
| TOT_CURR_LIAB | Total amount of all current (< 1 year) liabilities | /SRMSMC/DNB_TOT_CURR_LIAB | CURR | 14 | ||
| TOT_EMPL | Total number of personnel employed by business | /SRMSMC/DNB_TOT_EMPL | NUMC | 20 | ||
| TOT_EMPL_ESTD_IND | Indicator of reliability of total no. of employees | /SRMSMC/DNB_TOT_EMPL_ESTD_IND | CHAR | 10 | ||
| TOT_EMPL_IND | Qualifies calculation of total employees - indicator | /SRMSMC/DNB_TOT_EMPL_IND | CHAR | 10 | ||
| TOT_EMPL_MIN_IND | Indicates range of total employees figure (min/max/average) | /SRMSMC/DNB_TOT_EMPL_MIN_IND | CHAR | 10 | ||
| TOT_EMPL_TEXT | Total number of personnel employed by business (Text) | /SRMSMC/DNB_TOT_EMPL_TEXT | CHAR | 24 | ||
| TOT_LIAB | Total liabilities owed by business | /SRMSMC/DNB_TOT_LIAB | CURR | 14 | ||
| TOT_LIAB_AND_EQY | Total amount of Liabilities and Equity | /SRMSMC/DNB_TOT_LIAB_AND_EQY | CURR | 14 | ||
| TOT_LT_LIAB | Total long term liabilities owed by business | /SRMSMC/DNB_TOT_LT_LIAB | CURR | 14 | ||
| TOT_PMT | Total number of payment experiences | /SRMSMC/DNB_TOT_PMT | CURR | 2 | ||
| TRL_BAL_IND | Describes financial statement - trial balance Indicator | /SRMSMC/DNB_TRL_BAL_IND | CHAR | 10 | ||
| UBAL_IND | Describes financial statement - Unbalanced Indicator | /SRMSMC/DNB_UBAL_IND | CHAR | 10 | ||
| ADDL_SIC_DESC | Standard Industrial Classification | /SRMSMC/DNB_ADDL_SIC_DESC | CHAR | 60 | ||
| ENQ_DUNS | Id of case enq. upon, will be the same as DUNS unless branch | /SRMSMC/DNB_ENQ_DUNS | NUMC | 26 | ||
| PRIN_NME | The name of an individual listed in a business registration | /SRMSMC/DNB_PRIN_NME | CHAR | 80 | ||
| PRIN_TTL | Names and job titles of principal executives of case subject | /SRMSMC/DNB_PRIN_TTL | STRG | 8 | ||
| PFT_BEF_TAX | Net Income/Profit before taxes | /SRMSMC/DNB_PFT_BEF_TAX | CURR | 14 | ||
| CNGL_DIST_CD | A US gov. number repr. the congressional district number | /SRMSMC/DNB_CNGL_DIST_CD | NUMC | 4 | ||
| .INCLUDE | /SRMSMC/S_DNB_SECTION | 0 | ||||
| HDG | Head of the D&B Section | /SRMSMC/DNB_HEAD | STRG | 8 | ||
| BODY | Body of the D&B Section | /SRMSMC/DNB_BODY | STRG | 8 | ||
| LBR_SPLS_AREA_IND | Ind. of labour surplus area as def. by the Dept. of Labour | /SRMSMC/DNB_LBR_SPLS_AREA_IND | CHAR | 10 | ||
| LBR_SPLS_AREA_YR | The last year D&B rec. data ind. the area had lab. surplus | /SRMSMC/DNB_LBR_SPLS_AREA_YR | NUMC | 8 | ||
| SML_BUS_IND | Subject has been classified as a small business by SBA | /SRMSMC/DNB_SML_BUS_IND | CHAR | 2 | ||
| SML_BUS_YR | Last year that D&B rec. data ind. the bus. was a small bus. | /SRMSMC/DNB_SML_BUS_YR | NUMC | 8 | ||
| WOMN_OWND_IND | Indicator that business is woman-owned | /SRMSMC/DNB_WOMN_OWND_IND | CHAR | 2 | ||
| WOMN_OWND_YR | The last year that D&B rec. data ind. the bus. was wom. own. | /SRMSMC/DNB_WOMN_OWND_YR | NUMC | 8 | ||
| MINY_OWND_IND | Indicator that business is minority-owned | /SRMSMC/DNB_MINY_OWND_IND | CHAR | 2 | ||
| MINY_OWND_YR | The last year that D&B rec. data ind. the bus. was min.owned | /SRMSMC/DNB_MINY_OWND_YR | NUMC | 8 | ||
| DAVD_IND | Indic. small bus. class. by SBA as socially or econ. disadv. | /SRMSMC/DNB_DAVD_IND | CHAR | 2 | ||
| DBAR_CNT | A count of the debarments present in the D&B® file | /SRMSMC/DNB_DBAR_CNT | NUMC | 10 | ||
| DBAR_DT | The date of the last current debarment filing | /SRMSMC/DNB_DBAR_DT | DATS | 16 | ||
| DAVD_YR | The last year that D&B rec. data ind. the bus. small&disa. | /SRMSMC/DNB_DAVD_YR | NUMC | 8 | ||
| BKCY_OPEN_CNT | Bankruptcy Creditor Open Count | /SRMSMC/DNB_BKCY_OPEN_CNT | NUMC | 14 | ||
| BKCY_CLSD_CNT | Bankruptcy Creditor Closed Count | /SRMSMC/DNB_BKCY_CLSD_CNT | NUMC | 14 | ||
| BKCY_OPEN_MSG | Bankruptcy Creditor Open Message | /SRMSMC/DNB_BKCY_OPEN_MSG | STRG | 8 | ||
| BKCY_CLSD_MSG | D&B SLON Comment | /SRMSMC/DNB_BKCY_CLSD_MSG | STRG | 8 | ||
| SLON_CMNT | Bankruptcy Creditor Closed Message | /SRMSMC/DNB_SLON_CMNT | STRG | 8 |