/FLDQ/HNACLNSOUT - DQM for SAP output table for transactional cleanse TASK

DQM for SAP output table for transactional cleanse TASK information is stored in SAP table /FLDQ/HNACLNSOUT.
It is part of development package /FLDQ/DQM_ON_HANA in software component EIM-DQM-SAP. This development package consists of objects that can be grouped under "Development Package for Data Quality on SAP HANA".

Fields for table /FLDQ/HNACLNSOUT

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
CLIENT	Client	X	MANDT	CLNT	6
ADDRNUMBER	Address Number	X	AD_ADDRNUM	CHAR	20
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
.INCLUDE				/FLDQ/AD_ADRC_STRUC	0
.INCLUDE				ADRC_STRUC	0
NAME_CO	c/o name		AD_NAME_CO	CHAR	80
CITY1	City		AD_CITY1	CHAR	80
CITY2	District		AD_CITY2	CHAR	80
CITY_CODE	City code for city/street file		AD_CITYNUM	CHAR	24	*
CITYP_CODE	District code for City and Street file		AD_CITYPNM	CHAR	16	*
HOME_CITY	City (different from postal city)		AD_CITY3	CHAR	80
CITYH_CODE	Different city for city/street file		AD_CITYHNM	CHAR	24	*
CHCKSTATUS	City file test status		AD_CHECKST	CHAR	2
REGIOGROUP	Regional structure grouping		REGIOGROUP	CHAR	16	*
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
PCODE1_EXT	(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code		AD_PST1XT	CHAR	20
PCODE2_EXT	(Not Supported) PO Box Postal Code Extension		AD_PST2XT	CHAR	20
PCODE3_EXT	(Not Supported) Major Customer Postal Code Extension		AD_PST3XT	CHAR	20
PO_BOX	PO Box		AD_POBX	CHAR	20
DONT_USE_P	PO Box Address Undeliverable Flag		AD_NO_USEP	CHAR	8	TSAD12
PO_BOX_NUM	Flag: PO Box Without Number		AD_POBXNUM	CHAR	2
PO_BOX_LOC	PO Box city		AD_POBXLOC	CHAR	80
CITY_CODE2	City PO box code (City file)		AD_CIT2NUM	CHAR	24	*
PO_BOX_REG	Region for PO Box (Country/Region, State, Province, ...)		AD_POBXREG	CHAR	6	T005S
PO_BOX_CTY	PO Box of Country/Region		AD_POBXCTY	CHAR	6	*
POSTALAREA	(Not Supported) Post Delivery District		AD_PSTLAR	CHAR	30
TRANSPZONE	Transportation zone to or from which the goods are delivered		LZONE	CHAR	20	*
STREET	Street		AD_STREET	CHAR	120
DONT_USE_S	Street Address Undeliverable Flag		AD_NO_USES	CHAR	8	TSAD12
STREETCODE	Street Number for City/Street File		AD_STRNUM	CHAR	24	*
STREETABBR	(Not Supported) Abbreviation of Street Name		AD_STRABBR	CHAR	4	*
HOUSE_NUM1	House Number		AD_HSNM1	CHAR	20
HOUSE_NUM2	House number supplement		AD_HSNM2	CHAR	20
HOUSE_NUM3	(Not supported) House Number Range		AD_HSNM3	CHAR	20
STR_SUPPL1	Street 2		AD_STRSPP1	CHAR	80
STR_SUPPL2	Street 3		AD_STRSPP2	CHAR	80
STR_SUPPL3	Street 4		AD_STRSPP3	CHAR	80
LOCATION	Street 5		AD_LCTN	CHAR	80
BUILDING	Building (Number or Code)		AD_BLDNG	CHAR	40
FLOOR	Floor in building		AD_FLOOR	CHAR	20
ROOMNUMBER	Room or Apartment Number		AD_ROOMNUM	CHAR	20
COUNTRY	Country/Region Key		LAND1	CHAR	6	*
LANGU	Language Key		SPRAS	LANG	2	*
REGION	Region (State, Province, County)		REGIO	CHAR	6	T005S
SORT1	Search Term 1		AD_SORT1UL	CHAR	40
SORT2	Search Term 2		AD_SORT2UL	CHAR	40
SORT_PHN	(Not Supported) Phonetic Search Sort Field		AD_SRTPHN	CHAR	40
ADDRORIGIN	(Not Supported) Address Data Source (Key)		AD_ORIGINA	CHAR	8	*
EXTENSION1	Extension (only for data conversion) (e.g. data line)		AD_EXTENS1	CHAR	80
EXTENSION2	Extension (only for data conversion) (e.g. telebox)		AD_EXTENS2	CHAR	80
TIME_ZONE	Address time zone		AD_TZONE	CHAR	12	*
TAXJURCODE	Tax Jurisdiction		AD_TXJCD	CHAR	30
ADDRESS_ID	(Not supported) Physical address ID		AD_ADDR_ID	CHAR	20
REMARK	Address notes		AD_REMARK1	CHAR	100
LANGU_CREA	Address record creation original language		AD_LANGUCR	LANG	2	*
PO_BOX_LOBBY	PO Box Lobby		AD_PO_BOX_LBY	CHAR	80
DELI_SERV_TYPE	Type of Delivery Service		AD_DELIVERY_SERVICE_TYPE	CHAR	8	ADDRC_DELI_SERV
DELI_SERV_NUMBER	Number of Delivery Service		AD_DELIVERY_SERVICE_NUMBER	CHAR	20
COUNTY_CODE	County code for county		AD_CNTYNUM	CHAR	16	ADRCOUNTY
COUNTY	County		AD_COUNTY	CHAR	80
TOWNSHIP_CODE	Township code for Township		AD_TWSHPNUM	CHAR	16	ADRTOWNSHIP
TOWNSHIP	Township		AD_TOWNSHIP	CHAR	80
STATUS_CODE	Address Engine Status Code		/FLDQ/AD_STATUS_CODE	CHAR	20
STATUS_CODE_PO	Address Engine PO Status Code		/FLDQ/AD_STATUS_CODE_PO	CHAR	20
INFO_CODE	Address Information Code		/FLDQ/AD_INFO_CODE	CHAR	8
INFO_CODE_PO	PO Address Information Code		/FLDQ/AD_INFO_CODE_PO	CHAR	8
ASGMT_TYPE	Address Assignment Type		/FLDQ/AD_ASGMT_TYPE	CHAR	10
ASGMT_TYPE_PO	PO Address Assignment Type		/FLDQ/AD_ASGMT_TYPE_PO	CHAR	10
ASGMT_LEVEL	Assignment level		/FLDQ/AD_ASGMT_LVL	CHAR	4
ASGMT_LEVEL_PO	PO Assignment level		/FLDQ/AD_ASGMT_LVL_PO	CHAR	4
REPLY1	Suggestion list prompt string		/FLDQ/AD_PROMPT_LIST	CHAR	256
REGION2_LONG	region2 long name		/FLDQ/AD_REGION2_LONG	CHAR	120
REGION2	Region (State, Province, County)		REGIO	CHAR	6	*
PO_BOX_REG2	Region (State, Province, County)		REGIO	CHAR	6	*
SUGG_ERROR	ADDR_SUGG_ERROR			CHAR	4
SUGG_STATUS	ADDR_SUGG_STATUS			CHAR	4
ASGMT_INFO	ADDR_ASMT_INFO			CHAR	2
ASGMT_INFO_PO	ADDR_PO_ASMT_INFO			CHAR	2