/FLDQ/AD_MTCCODE - FirstLogic Match Code Index Table

FirstLogic Match Code Index Table information is stored in SAP table /FLDQ/AD_MTCCODE.
It is part of development package /FLDQ/GDQC_LINK in software component EIM-DQM-SAP. This development package consists of objects that can be grouped under "Development class for SAP BusinessObjects : DQM for SAP".

Fields for table /FLDQ/AD_MTCCODE

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
CLIENT	Client	X	MANDT	CLNT	6
.INCLUDE		X		ADDR_KEYNR	0
ADDRNUMBER	Address Number	X	AD_ADDRNUM	CHAR	20	*
PERSNUMBER	Person Number	X	AD_PERSNUM	CHAR	20
ADDR_TYPE	Address type (1=Organization, 2=Person, 3=Contact person)	X	AD_ADRTYPE	CHAR	2
DATE_FROM	Valid-from date - in current Release only 00010101 possible	X	AD_DATE_FR	DATS	16
NATION	Version ID for International Addresses	X	AD_NATION	CHAR	2
APPL_TABLE	Application table logical name (address management)	X	AD_APPLTAB	CHAR	20
APPL_FIELD	Application table address where-used list logical field name	X	AD_APPLFLD	CHAR	20
.INCLUDE				/FLDQ/AD_MTCCODE_STRUC	0
MATCH_CODE1	Address Match Code		/FLDQ/AD_MATCH_CODE	CHAR	40
PO_MATCH_CODE	Address Match Code		/FLDQ/AD_MATCH_CODE	CHAR	40
MTC_CODE_NM1	Name Match Code		/FLDQ/AD_NAME_MATCH_CODE	CHAR	40
MTC_CODE_NM2	Name Match Code		/FLDQ/AD_NAME_MATCH_CODE	CHAR	40
MTC_CODE_NM3	Name Match Code		/FLDQ/AD_NAME_MATCH_CODE	CHAR	40
MTC_CODE_NM4	Name Match Code		/FLDQ/AD_NAME_MATCH_CODE	CHAR	40
MTC_CODE_NM5	Name Match Code		/FLDQ/AD_NAME_MATCH_CODE	CHAR	40
DEPARTMENT	Department		AD_DPRTMNT	CHAR	80
FUNCTION	Company contact person function		AD_FUNC	CHAR	80
ID_CODE	Short name for correspondence		AD_ID_CODE	CHAR	20
IH_MAIL	Internal Mail Postal Code		AD_IH_MAIL	CHAR	20
ROOMNUMBER	Room or Apartment Number		AD_ROOMNUM	CHAR	20
BUILDING	Building (Number or Code)		AD_BLDNG	CHAR	40
CITY1	City		AD_CITY1	CHAR	80
CITY2	District		AD_CITY2	CHAR	80
COUNTRY	Country/Region Key		LAND1	CHAR	6	*
FLOOR	Floor in building		AD_FLOOR	CHAR	20
HOUSE_NUM1	House Number		AD_HSNM1	CHAR	20
HOUSE_NUM2	House number supplement		AD_HSNM2	CHAR	20
LOCATION	Street 5		AD_LCTN	CHAR	80
NAME1	Name 1		AD_NAME1	CHAR	80
NAME2	Name 2		AD_NAME2	CHAR	80
NAME3	Name 3		AD_NAME3	CHAR	80
NAME4	Name 4		AD_NAME4	CHAR	80
NAME_CO	c/o name		AD_NAME_CO	CHAR	80
POST_CODE1	City postal code		AD_PSTCD1	CHAR	20
POST_CODE2	PO Box Postal Code		AD_PSTCD2	CHAR	20
POST_CODE3	Company Postal Code (for Large Customers)		AD_PSTCD3	CHAR	20
PO_BOX	PO Box		AD_POBX	CHAR	20
PO_BOX_LOC	PO Box city		AD_POBXLOC	CHAR	80
PO_BOX_CTY	PO Box of Country/Region		AD_POBXCTY	CHAR	6	*
REGION	Region (State, Province, County)		REGIO	CHAR	6	*
SORT1	Search Term 1		AD_SORT1	CHAR	40
SORT2	Search Term 2		AD_SORT2	CHAR	40
STREET	Street		AD_STREET	CHAR	120
STR_SUPPL1	Street 2		AD_STRSPP1	CHAR	80
STR_SUPPL2	Street 3		AD_STRSPP2	CHAR	80
STR_SUPPL3	Street 4		AD_STRSPP3	CHAR	80
NAME_FIRST	First name		AD_NAMEFIR	CHAR	80
NAME_LAST	Last name		AD_NAMELAS	CHAR	80
SMTP_ADDR	E-Mail Address		AD_SMTPADR	CHAR	482
TEL_NUMBER	First telephone no.: dialling code+number		AD_TLNMBR1	CHAR	60
TEL_EXTENS	First Telephone No.: Extension		AD_TLXTNS1	CHAR	20
PO_BOX_LOBBY	PO Box Lobby		AD_PO_BOX_LBY	CHAR	80
EXTRA1	Text, 255 Characters		/FLDQ/AD_TEXT255	CHAR	510
EXTRA2	Text, 255 Characters		/FLDQ/AD_TEXT255	CHAR	510
MTCSTD1	Match Standard		/FLDQ/AD_MATCH_STD	CHAR	80
MTCSTD2	Match Standard		/FLDQ/AD_MATCH_STD	CHAR	80
BIRTHDT	Date of Birth of Business Partner		BU_BIRTHDT	DATS	16