ICSPAY - Payment

Payment information is stored in SAP table ICSPAY.
It is part of development package ICL_CF in software component FS-CM. This development package consists of objects that can be grouped under "FS-CM: Claims Management Financials".

Fields for table ICSPAY

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
PAYMENT	Number of Claim Payment	X	ICL_PAYMENT	NUMC	10
CHANGETIME	Changed: Date + Time	X	ICL_CHANGEUTC1	DEC	8
.INCLUDE				ICL_INCL_VER6	0
CHANGEDBY	Changed By		ICL_CHANGEDBY	CHAR	24	USR02
DELETED	Database Line Status (Original, Changed, Deleted)		ICL_RECSTATUS	CHAR	2
.INCLUDE				ICS_PAY	0
.INCLUDE				ICL_INCL_ORG3	0
CREATEDBY	Created By		ICL_CREATEDBY	CHAR	24	USR02
CREATETIME	Created: Date + Time		ICL_CREATEUTC	DEC	8
APPROVEDBY	Checked By		ICL_PAYMENT13	CHAR	24	USR02
APPROVEDTIME	Date Checked (Date+Time)		ICL_PAYMENT15UTC	DEC	8
TRANSFERTIME	Transfer Date to Collections/Disbursements (Date+Time)		ICL_PAYMENT17UTC	DEC	8
DOCUMENTREF	Reference for Payment Document Created in Subledger		ICL_DOCUMENTREF	CHAR	28
POSTDATE	Posting Date		ICL_POSTDATE	DATS	16
DOCDATE	Document Date of Payment		ICL_DOCDATE	DATS	16
DUEDATE	Due Date for Net Payment		ICL_DUEDATENET	DATS	16
XALREADYPAID	Payment Already Made		ICL_ALREADYPAID	CHAR	2
PAYCAT	Record Type of Payment		ICL_PAYCAT	CHAR	2
PAYTYPE	Payment Type (Final Payment, Payment After Closure of Claim)		ICL_PAYTYPE	CHAR	2
SUBSAL	Subrogation/Recovery/Salvage		ICL_SUBSAL	NUMC	6
XPAYEE	Additional Payee (ICLPAYEE)		ICL_XPAYEE	CHAR	2
ADDRNUMBER	Address Number for Checks		ICL_ADDRNUM	CHAR	20	ADRC
CRECADDR	Address Number for Checks		ICL_ADDRNUM	CHAR	20	*
BKID	Bank Details ID		ICL_BKID	CHAR	8	BUT0BK
CURR	Claim Payment Currency		ICL_PAYMENTCUR	CUKY	10	TCURC
EXCHRATE	Exchange Rate of Payment Currency into Policy Currency		ICL_PAYMENT18	DEC	5
STATUS	Internal Payment Status (Database Status)		ICL_PAYMENT12	CHAR	4
METHOD	Payment Method		ICL_PAYMENT01	CHAR	2	TFK042Z
CHECKNUMBER	Check Number for Manual Check Payments		ICL_CHECK	CHAR	26
NOTE	Payment Note		ICL_PAYMENT04	CHAR	200
INVOICEREF	External Invoice Number		ICL_INVOICEREF	CHAR	40
REFCLAIM	Claim Number (Reassignment Reference)		ICL_CLAIM_REFPAY	CHAR	34
REFSUBCLAIM	Subclaim (Reassignment Reference)		ICL_SUBCL_REFPAY	CHAR	6	*
REFPAYMENT	Claim Payment (Reassignment Reference)		ICL_PAYMENT_REFPAY	NUMC	10	*
AMTDONE	Amount Paid or Received		ICL_AMOUNT_DONE	CURR	8
LIABRATE	Negotiated Liability Rate in Percent		ICL_LIABRATE_NEG	DEC	3
AMTNEG	Amount Negotiated		ICL_AMOUNTNEG	CURR	8
SUBROSTATUS	Legal Status of Subrogation/Recovery		ICL_SUBROSTATUS	CHAR	2
TAXROLE	Tax Role of Claim Payment Recipient		ICL_TAXROLE	CHAR	8	*
TAX_RPT	Flag for Reportable Payments		ICL_TAXRPT	CHAR	2
XTAXRPTCT	Code for Withholding Tax in Statutory Reporting Category		ICL_XTAXRPTCT	CHAR	2
MTAXRPTCT	Withholding Tax Code for Statutory Reporting		ICL_TAXRPTCT	CHAR	4	*
OVRD_TAXRPTCT	Manual Withholding Tax Code		ICL_OVRDTAXRPTCT	CHAR	2
FUNDSRECDT	Salvage: Funds Received		ICL_SALVFUNDREC	DATS	16
XSALVESTEND	End Estimation of Salvage Value		ICL_XSALVESTEND	CHAR	2
OWNERTYPE_GRP	Responsible Organization Category		ICL_OWNERTYPE_GRP3	CHAR	4	*
OWNER_GRP	Responsible Organizational Unit		ICL_OWNER_GRP3	CHAR	24	*
REASONREJ	Rejection Reasons for Payments and Reserves		ICL_REASONREJ	CHAR	4	TICL112
REFEXTSDOC	Referenced Statistical Payment Entry		ICL_REFEXTSDOC	NUMC	10	*
MOS	Method of Settlement		ICL_MOS	CHAR	6	*
CL_PAYFREQPLAN	Payment Frequency of Scheduled Payment		ICL_PAYFREQPLAN	CHAR	4	TVS010B
PMTTO	End Date of a Scheduled Payment		ICL_PMTTO	DATS	16
PMTFR	Start Date of a Scheduled Payment		ICL_PMTFR	DATS	16
SCHEDTYPE	Type of Scheduled Payment		ICL_SCHEDULE_TYPE	CHAR	4	TICL180
NROFINVREQ	Mininum Number of Inbound Invoices		ICL_INVOICES_REQUIRED	NUMC	4
DAMAGEDOBJ	Damaged Object		ICL_DAMOBJ	NUMC	8	*
MIGRATION	Indicator for Migrated Payments		ICL_PAYMIGRATION	CHAR	2
REQEVALCAT	Determination Category of Receivable Amount		ICL_REQEVALCAT_D_PE	CHAR	2
ASSIGN_GUID	UUID of Entry to be Linked		ICL_ASSIGN_GUID	CHAR	64
PAYOUT_SCENARIO	Repetitive Payment Scenario		ICL_PAYOUT_SCENARIO_D	CHAR	2
SERV_FROM	Service Start Date		ICL_SERVFR	DATS	16
SERV_TO	Service End Date		ICL_SERVTO	DATS	16
XREPPAY	Payment Creation from Repetitive Payment Record		ICL_XREPPAY_D_AL	CHAR	2
.INCLUDE				ICL_PAY_HDR_AS_DB	0
ALTPOSTTARGET	Alternative Posting Target		ICL_ALTPOSTTARGET_D	CHAR	100
GROSS_NET_PAYMENT	Gross/Net payment indicator		/GSINS/INSH_GROSS_NET_PAYMENT	CHAR	2
HCM_PAYMENT_STATE	Payment Processing State Indicator on the HCM system		/GSINS/INSH_HCM_PAYMENT_STATE	CHAR	2
_DATAAGING	Data Filter Value for Data Aging		DATA_TEMPERATURE	DATS	16
.INCLUDE				ICLVDM_PAY_INCL_EEW_PS	0
DUMMY_ICLVDM_PAY_INCL_EEW_PS	Custom Fields: Dummy for Use in Extension Includes		CFD_DUMMY	CHAR	2