UDM_WL_ITEM - Worklist Item

Worklist Item information is stored in SAP table UDM_WL_ITEM.
It is part of development package UDM_WORK_LIST in software component FIN-FSCM-COL. This development package consists of objects that can be grouped under "Work list".

Fields for table UDM_WL_ITEM

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
WORKITEM_ID	Key of Worklist Item	X	UDM_WORKLIST_ITEM_GUID	RAW	16
.INCLUDE				UDM_S_WORKLIST_ITEM_C	0
.INCLUDE				UDM_S_WORKLIST_ITEM	0
COLL_SPECIALIST	Collection Specialist		BDM_COLL_SPECIALIST	CHAR	24	*
COLL_GROUP	Collection Group		UDM_COLL_GROUP	CHAR	20	*
COLL_SEGMENT	Collection Segment		UDM_COLL_SEGMENT	CHAR	20
WL_ITEM_DATE	Date of Worklist Item		UDM_WORKLIST_ITEM_DATE	DATS	16
RUN_ID	Run ID		UDM_COLL_RUN_ID	CHAR	24
STATUS	Indicator: Worklist Item Is Completed		UDM_WORKLIST_ITEM_STATUS	CHAR	2
STRATEGY	Collection Strategy		UDM_COLL_STRATEGY	CHAR	20	*
STRATEGY_VERSION	Collection Strategy Version		UDM_STRATEGY_VERSION	NUMC	16
VALUATION	Valuation		UDM_COLL_VALUATION	INT4	4
PERCENTAGE	Percentage Valuation		UDM_VALUATION_BY_PERCENTAGE	NUMC	8
MAX_SEQUENCE_ID	Sequence Number of a Strategy		UDM_SEQUENCE_ID	INT4	4
PARTNER_ID	Business Partner Number		BU_PARTNER	CHAR	20
PARTNER_DESC	Short name of business partner		BU_DESCRIP	CHAR	100
PARTNER_ACCNO	Customer Key in Accounts Receivable Accounting		UDM_KUNNR	CHAR	20
PARTNER_AUGRP	Authorization Group		BU_AUGRP	CHAR	8	*
CONTACT_NAME	Description of Main Contact Person		UDM_LAST_CONTACT_DESC	CHAR	100
CONTACT_PHONE	Telephone Number of Contact Person at Business Partner		UDM_COLL_CONTACT_PHONE	CHAR	60
CCT_RESULT	Result of Customer Contact		UDM_CCT_RESULT_ID	CHAR	6
LAST_CCT_TIME	Last Customer Contact		UDM_LAST_CCT_TIME	DEC	8
CALLTIMEFROM	Start of Call Time		UDM_CALLTIMEFROM	DEC	8
CALLTIMETO	End of Calling Hours		UDM_CALLTIMETO	DEC	8
VISITINGTIMEFROM	Start of Visit Time		UDM_VISITINGTIMEFROM	DEC	8
VISITINGTIMETO	End of Visit Time		UDM_VISITINGTIMETO	DEC	8
TOTAL_AMT	Outstanding Amounts of Business Partner in Segment		UDM_AMOUNT_TOTAL	CURR	8
DEBIT_AMT	Total of All Receivables of Business Partner in Segment		UDM_AMOUNT_DEBIT	CURR	8
CREDIT_AMT	Total of All Credits of Business Partner in Segment		UDM_AMOUNT_CREDIT	CURR	8
AMT_COLLECTED	Amount to Be Collected		UDM_AMOUNT_TO_BE_COLLECTED	CURR	8
DUE_AMT	Total of All Items Due on Key Date or in the Future		UDM_AMOUNT_DUE	CURR	8
OVERDUE_AMT	Total of All Overdue Items		UDM_AMOUNT_OVERDUE	CURR	8
PROMISED_AMT	Outstanding Amount Promised		UDM_AMOUNT_TOTAL_PROMISED	CURR	8
DISPUTED_AMT	Total of All Items Included in Dispute Cases		UDM_AMOUNT_DISPUTED	CURR	8
DUNNED_AMT	Dunned Amount		UDM_AMOUNT_TOTAL_DUNNED	CURR	8
ARRANGED_AMT	Amount Arranged		UDM_AMOUNT_ARRANGED	CURR	8
BROKEN_AMT	Amount Promised but Not Paid		UDM_AMOUNT_BROKEN	CURR	8
CURRENCY	Strategy Currency		UDM_COLL_STRATEGY_CURRENCY	CUKY	10	*
DUE_AMT_INT1	Total Amount in Interval		UDM_AMOUNT_INTERVAL	CURR	8
DUE_AMT_INT2	Total Amount in Interval		UDM_AMOUNT_INTERVAL	CURR	8
DUE_AMT_INT3	Total Amount in Interval		UDM_AMOUNT_INTERVAL	CURR	8
DUE_AMT_INT4	Total Amount in Interval		UDM_AMOUNT_INTERVAL	CURR	8
DUE_AMT_INT5	Total Amount in Interval		UDM_AMOUNT_INTERVAL	CURR	8
OVERDUE_AMT_INT1	Total Amount in Interval		UDM_AMOUNT_INTERVAL	CURR	8
OVERDUE_AMT_INT2	Total Amount in Interval		UDM_AMOUNT_INTERVAL	CURR	8
OVERDUE_AMT_INT3	Total Amount in Interval		UDM_AMOUNT_INTERVAL	CURR	8
OVERDUE_AMT_INT4	Total Amount in Interval		UDM_AMOUNT_INTERVAL	CURR	8
OVERDUE_AMT_INT5	Total Amount in Interval		UDM_AMOUNT_INTERVAL	CURR	8
LAST_PAY_DATE	Date of Last Payment		BDM_LAST_PAYMENT_DATE	DATS	16
RSM_DATE	Resubmission Date		BDM_RSM_DATE	DATS	16
RSM_TIME	Resubmission Time		BDM_RSM_TIME	DEC	8
RSM_REASON	Reason for Resubmission		UDM_RSM_REASON_ID	CHAR	8
MAX_DUNNLEVEL	Highest Dunning Level		UDM_MAX_DUNN_LEVEL	NUMC	2
LAST_DUNNDATE	Date of Last Dunning Notice		BDM_LAST_DUNN_DATE	DATS	16
CREDIT_SGMNT	Credit Segment		UKM_CREDIT_SGMNT	CHAR	20	*
CREDIT_LIMIT	Credit Limit		UKM_CREDIT_LIMIT	CURR	8
CREDIT_RATING	Score		UKM_OWN_RATING	CHAR	20
CREDIT_EXPOSURE	Credit Limit Utilization in Percent		UDM_CREDLIMIT_USED	DEC	5
CREDIT_RISK_CLS	Risk Class		UDM_RISK_CLASS	CHAR	6	*
GRADE	External Valuation		UDM_GRADE	CHAR	20	*
GRADE_METHOD	External Valuation Procedure		UDM_GRADE_METHOD	CHAR	20	*
GRADE_VALID_TO	External Valuation Valid To		UDM_GRADE_VALID_TO	DATS	16
CREATED_BY	Created By		SCMG_CREATE_USER	CHAR	24	*
CREATE_TIME	Created On		SCMG_CREATE_TIME	DEC	8
CHANGED_BY	Last Changed By		SCMG_CHANGE_USER	CHAR	24	*
CHANGE_TIME	Last Changed On		SCMG_CHANGE_TIME	DEC	8
HEAD_OFFICE	Head Office on the Worklist		UDM_WL_HEAD_OFFICE	CHAR	20	*
XAMBIG_HO	Worklist Entry: Other Head Offices Exist		UDM_XAMBIG_HO	CHAR	2
GLOBAL_EVAL	Global Valuation		UDM_GLOBAL_EVAL	CHAR	2
.INCLUDE				CI_WORKLIST_ITEM	0