UDM_COLL_ITEM - Open Items

Open Items information is stored in SAP table UDM_COLL_ITEM.
It is part of development package UDM_BUPA_TRANSACTION_DATA in software component FIN-FSCM-COL. This development package consists of objects that can be grouped under "Transaction Data".

Fields for table UDM_COLL_ITEM

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	*
PARTNER	Business Partner Number	X	BU_PARTNER	CHAR	20	*
COMP_CODE	Company Code	X	BUKRS	CHAR	8	*
OPEN_ITEM_REF	Reference to Open Invoice Item	X	BDM_OPEN_ITEM_REF	CHAR	100
.INCLUDE				UDM_S_COLL_ITEM_ATTR	0
INVOICE_REF	Reference to Document (Invoice Reference)		BDM_INVOICE_REF	CHAR	100
INVOICE_REF_TYPE	Type of Follow-On Document		BDM_INVOICE_REF_TYPE	CHAR	4
OPEN_ITEM_AMT	Amount in Document Currency		UDM_OPEN_ITEM_AMT	CURR	8
OPEN_ITEM_CURR	Document Currency		BDM_OPEN_ITEM_CURR	CUKY	10	*
PAY_AMOUNT_DAYS1	Amount Payable on Payment within Cash Discount 1 Deadline		UDM_PAY_AMOUNT_DAYS1	CURR	8
PAY_AMOUNT_DAYS2	Amount Payable on Payment within Cash Discount 2 Deadline		UDM_PAY_AMOUNT_DAYS2	CURR	8
END_CASH_DISC1	Date to Which Cash Discount Terms 1 Are Valid		BDM_END_CASH_DISC1	DATS	16
END_CASH_DISC2	Date to Which Cash Discount Terms 2 Are Valid		BDM_END_CASH_DISC2	DATS	16
NET_DUE_DATE	Due Date for Net Payment		BDM_NET_DUE_DATE	DATS	16
BLINE_DATE	Baseline Date for Due Date Calculation		DZFBDT	DATS	16
XARRANGED_PAY	Arranged for Payment		UDM_XARRANGED_FOR_PAY	CHAR	2
LAST_DUNN_DATE	Date of Last Dunning Notice		BDM_LAST_DUNN_DATE	DATS	16
DUNN_LEVEL	Dunning Level		BDM_DUNN_LEVEL	NUMC	2
LEGAL_DUNN_ON	Date of Legal Dunning Procedure		BDM_LEGAL_DUNN_ON	DATS	16
TIMESTAMP	Time Stamep: Time Data Was Created or Updated		BDM_COLL_TIMESTAMP	DEC	8
HEAD_OFFICE	Business Partner Number of Head Office		BDM_HEAD_OFFICE	CHAR	20	*
PAYER	Business Partner Number of Payer		BDM_PAYER	CHAR	20	*
FIS_PERIOD	Fiscal period		MONAT	NUMC	4
XPAYMENT_BLOCK	Item Blocked for Payment?		UDM_COLL_XPAYMENT_BLOCK	CHAR	2
.INCLUDE				CI_UDM_S_COLL_ITEM_ATTR	0