/SRMSMC/D_DNB_LU - D&B Interface: Lookup - Persistence
D&B Interface: Lookup - Persistence information is stored in SAP table /SRMSMC/D_DNB_LU.
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_LU
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | * |
| DUNS | Unique D&B identifier for this company | X | /SRMSMC/DNB_DUNS_NBR | CHAR | 26 | |
| .INCLUDE | /SRMSMC/S_DNB_LU_DB | 0 | ||||
| REQUEST | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 8 | ||
| CREA_UNAME | User Name | UNAME | CHAR | 24 | ||
| ADR_LINE | Address line of physical location | /SRMSMC/DNB_ADR_LINE | CHAR | 140 | ||
| BR_IND | Indicates whether subject is a branch location | /SRMSMC/DNB_BR_IND | CHAR | 10 | ||
| CONF_CD | Confidence code for the matches obtained | /SRMSMC/DNB_CONF_CD | CHAR | 2 | ||
| CTRY_CD | The 2-character ISO code for the country/region | /SRMSMC/DNB_CTRY_CD | CHAR | 32 | ||
| DSR | Indicator signifying company is a D-U-N-SīŋŊ Support Record | /SRMSMC/DNB_DSR | CHAR | 2 | ||
| DUNS_NBR | Unique D&B identifier for this company | /SRMSMC/DNB_DUNS_NBR | CHAR | 26 | ||
| IN_DT_IND | An indicator | /SRMSMC/DNB_IN_DT_IND | CHAR | 480 | ||
| MTCH_GRD | A sequence of match grades for inputs | /SRMSMC/DNB_MTCH_GRD | CHAR | 22 | ||
| NME | Business name or principal name from inquiry request | /SRMSMC/DNB_NME | CHAR | 480 | ||
| NME_PCT_GRD | The percentage of match for the Name in the request | /SRMSMC/DNB_NME_PCT_GRD | NUMC | 6 | ||
| NON_POST_TOWN | Non-postal town | /SRMSMC/DNB_NON_POST_TOWN | CHAR | 100 | ||
| NON_POST_TWN_PCT_GRD | The percentage of match for the City in the request | /SRMSMC/DNB_NON_PSTTWN_PCT_GRD | NUMC | 6 | ||
| 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 | ||
| POST_TOWN | Postal town where the business is located | /SRMSMC/DNB_POST_TOWN | CHAR | 100 | ||
| PO_BOX_PCT_GRD | The percentage of match for the PO Box in the request | /SRMSMC/DNB_PO_BOX_PCT_GRD | NUMC | 6 | ||
| PRIM_GEO_AREA_NBR_PCT_GRD | The percentage match of the main sub-entity in the ctry/reg | /SRMSMC/DNB_PRIGEOANBR_PCT_GRD | CHAR | 480 | ||
| PROB_OF_ACCR | The field that reflects the overall quality of the match | /SRMSMC/DNB_PROB_OF_ACCR | NUMC | 20 | ||
| STR_NBR_PCT_GRD | The percentage of match for the Street Number in the request | /SRMSMC/DNB_STR_NBR_PCT_GRD | NUMC | 8 | ||
| STR_NME_PCT_GRD | The percentage of match for the Street Name in the request | /SRMSMC/DNB_STR_NME_PCT_GRD | NUMC | 14 | ||
| SBRI_UMTC_AGN | Gen. number from the Small Business Risk Insight database | /SRMSMC/DNB_SBRI_UMTC_AGN | NUMC | 22 | ||
| TLCM_NBR | The main telephone number of the business | /SRMSMC/DNB_TLCM_NBR | CHAR | 64 | ||
| TLCM_PCT_GRD | The percentage of match for the telephone | /SRMSMC/DNB_TLCM_PCT_GRD | CHAR | 480 | ||
| TRDG_STYL | Trade styles used by business | /SRMSMC/DNB_TRDG_STYL | CHAR | 480 |