ICLPROCURE - Claim Item Groupings

Claim Item Groupings information is stored in SAP table ICLPROCURE.
It is part of development package ICL_CDC in software component FS-CM. This development package consists of objects that can be grouped under "FS-CM: Data Capture".

Fields for table ICLPROCURE

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
CLIENT	Client	X	MANDT	CLNT	6	T000
ACTIVE	Table entry is active (A) or in suspense (S)	X	ICL_ACTIVE	CHAR	2
CLAIM	Number of Claim	X	ICL_CLAIM	CHAR	34	ICLCLAIM
SUBCLAIM	Subclaim of Payment	X	ICL_SUBCLP	CHAR	6	ICLSUBCL
PROCUREMENT	ID of Claim Item Grouping	X	ICL_PROCUREMENT	NUMC	8
.INCLUDE				ICL_INCL_VER5	0
CHANGETIME	Changed: Date + Time		ICL_CHANGEUTC1	DEC	8
CHANGEDBY	Changed By		ICL_CHANGEDBY	CHAR	24	USR02
DELETED	Database Line Status (Original, Changed, Deleted)		ICL_RECSTATUS	CHAR	2
.INCLUDE				ICS_PROCURE	0
.INCLUDE				ICL_INCL_ORG3	0
CREATEDBY	Created By		ICL_CREATEDBY	CHAR	24	USR02
CREATETIME	Created: Date + Time		ICL_CREATEUTC	DEC	8
PDOCTYPE	Benefit Type for Grouping of Lower Level Benefit Types		ICL_PDOCTYPE	CHAR	20	*
PDOCCAT	Claim Item Grouping Category		ICL_PDOCCAT	CHAR	4	TICL138
ISSUEDATE	Date Created		ICL_ISSUEDATE1	DATS	16
RECEIVEDATE	Date Received		ICL_RECEIVEDATE	DATS	16
DATEFROM	Start Date of Period		ICL_DATEFROM	DATS	16
TIMEFROM	Start Time of Claim Item Group		ICL_TIMEFROM	TIMS	12
DATETO	End Date of Period		ICL_DATETO	DATS	16
TIMETO	End Time of Claim Item Group		ICL_TIMETO	TIMS	12
ISSUEDATE_PRESCR	Date Prescription Created Acc. to Invoice		ICL_ISSUEDATE_PRESCR	DATS	16
ACQUISITIONDATE	Date Entered		ICL_ACQUISITIONDATE	DATS	16
AMOUNT1	General Amount Field		ICL_AMOUNT1	CURR	8
CURRENCY	Currency		ICL_CURRENCY	CUKY	10	TCURC
.INCLUDE				ICL_PROC_EXTERNAL_NO	0
EXTERNALREF	External Reference of Claim Item Grouping		ICL_EXTERNALREF	CHAR	40
EXTDOCUMENT	External Document Number		ICL_EXTDOCUMENT	CHAR	32
EXTCASENO	Hospital-Internal ID		ICLH_EXTCASENO	CHAR	46
EXTFILENO	HI: External Data Set Identification		ICLH_EXTFILENO	CHAR	40
PROC_REF	Reference to Claim Item Grouping		ICL_PROC_REF	NUMC	8	ICLPROCURE
DISCOUNTAMOUNT	Discount on Invoice Amount		ICL_DISCOUNTAMOUNT	CURR	8
DISCOUNTPERCENT	Discount on Total Invoice Amount in Percent		ICL_DISCOUNTPERCENT	DEC	3
.INCLUDE				ICL_PROC_ACCSUBR	0
ACCIDENT	Accident or Other Reason for Possible Recovery		ICL_ACCIDENT	CHAR	4	TICL158
SUBROGATION	Indication Whether Recovery Claim Might Be Involved		ICL_SUBROGATION	CHAR	4	TICL157
DUEDATE	Due Date		ICL_DUEDATE	DATS	16
DUEDATE_ORIG	Origin of Due Date		ICL_DUEDATE_ORIG	DATS	16
STATUS	Status of a Claim Item Grouping		ICL_PROCSTATUS	CHAR	4	TICL140
STATREASON	Reason for Changing the Status		ICL_FORMSET	CHAR	4	TICL018
OWNCONTRIB	Copayment		ICL_OWNCONTRIB	NUMC	6
REASON	Reason for Creating a Claim Item Grouping		ICL_REASON	CHAR	6	TICL152
CAUSE	Specification of Reason for Creating Claim Item Grouping		ICLH_CAUSE	CHAR	4	*
PDOCCATTYPE	Type of Claim Item Grouping Category		ICL_PDOCCATTYPE	CHAR	6	TICL153
SUBCL_ORIG	Original Subclaim Multiple Prescription/Curr.Subclm Appraisl		ICL_SUBCL_ORIG	CHAR	6	*
PROC_ORIG	Original Claim Item Grouping of Multiple Prescription		ICL_PROC_ORIG	NUMC	8
DATASOURCE	Data Origin		ICL_DATASOURCE	CHAR	4	TICL136
SETORDERDATE	Set Order Date		ICL_SETORDERDATE	DATS	16
COMPLETIONDATE	Completion Date		ICL_COMPLETIONDATE	DATS	16
.INCLUDE				ICLH_PROCURE_DENTAL	0
FEE	Fee		ICLH_FEE	CURR	8
MATLABCOST	Material and Laboratory Costs		ICLH_MATLABCOST	CURR	8
MATLABCOSTINT	will be deleted.		ICLH_MATLABCOSTINT	CURR	8
ADDCOST	Other Costs		ICLH_ADDCOST	CURR	8
VALPERUNIT	Value per Unit of Benefits Catalog Item		ICL_SERVCAT_POS_VALPERUNIT	DEC	11
SUBSIDYPERCENT	Subsidy in Percent (%)		ICLH_SUBSIDYPERCENT	DEC	3
SUBSIDYAMOUNT	Subsidy Amount		ICLH_SUBSIDYAMOUNT	CURR	8
SENTUTC	Sent: Date and Time		ICL_SENTUTC	DEC	8
SENT_BY_DME	Sent via External Interface (Not Yet Used)		ICL_SENT_BY_DME	CHAR	2
RECEIPT_BY_DME	Receipt via External Interface		ICL_RECEIPT_BY_DME	CHAR	2
.INCLUDE				ICL_PROC_STATUS	0
CANCEL	Status "Cancelled"		ICL_STATUS_CANCEL	CHAR	2
REJECTED	Status "Rejected"		ICL_STATUS_REJECTED	CHAR	2
INSUSPENSE	Status "Pending"		ICL_STATUS_INSUSPENSE	CHAR	2
INPROCESS	Status "In Process"		ICL_STATUS_INPROCESS	CHAR	2
RELEASED	Status "Released"		ICL_STATUS_RELEASED	CHAR	2
XFINISHED	Complete/Approved/Finished		ICL_XFINISHED	CHAR	2
ORDERED	Status "Commissioned"		ICL_STATUS_ORDERED	CHAR	2
TRANSFERRED	Status "Reassigned"		ICL_STATUS_TRANSFERRED	CHAR	2
TOBEAPPROVED	Status "To Be Approved"		ICL_STATUS_TOBEAPPROVED	CHAR	2
XCLINICCARD	Flag: Clinic Card		ICLH_CLINIC_CARD	CHAR	2
PAYFREQPLAN	Payment Frequency of a Repetitive Payment		ICL_PAYFREQPLAN_REP	CHAR	4	TVS010B
ASSIGN_GUID	UUID of Entry to be Linked		ICL_ASSIGN_GUID	CHAR	64
XREQUEST	Indicator: Receivable		ICL_XREQUEST	CHAR	2
COMPPER_DATEFROM	Comparision Period From		ICL_COMPPER_DATEFROM_D_PE	DATS	16
COMPPER_DATETO	Comparison Period To		ICL_COMPPER_DATETO_D_PE	DATS	16
PAYOUT_SCENARIO	Repetitive Payment Scenario		ICL_PAYOUT_SCENARIO_D	CHAR	2
REASONREJ	Rejection Reasons for Payments and Reserves		ICL_REASONREJ	CHAR	4	*
METHOD	Payment Method		ICL_PAYMENT01	CHAR	2	*
ADDRNUMBER	Address Number for Checks		ICL_ADDRNUM	CHAR	20	*
BKID	Bank Details ID		ICL_BKID	CHAR	8
_DATAAGING	Data Filter Value for Data Aging		DATA_TEMPERATURE	DATS	16