ICSPAYI

Payment Item | #transactional | Component: Claims Management
Column Name Description
CLIENT FK Client
ACTIVE Table entry is active (A) or in suspense (S) Show values
CLAIM FK Number of Claim
SUBCLAIM FK Subclaim of Payment
PAYMENT FK Number of Claim Payment
PAYMENTITEM Claim Payment Item
CHANGETIME Changed: Date + Time
Column Name Description
PAMPAID Payment Amount
REQUESTED Amount Requested
REQUESTED_ORIG Original Amount Requested
DUP_PAMPAID Payment Amount
TXBSAMT Tax Base Amount
Column Name Description
Column Name Description
POSTDATEI Posting Date
VALIDFROM Payment Item: Valid From
VALIDTO Payment Item: Valid To
_DATAAGING Data Filter Value for Data Aging
Column Name Description
ACTIVE Table entry is active (A) or in suspense (S) Show values
DELETED Database Line Status (Original, Changed, Deleted) Show values
PAYITEMCAT Claim Payment Item Category Show values
PAYTYPEI Payment Type (Final Payment, Payment After Closure of Claim) Show values
GROSS_NET Tax Category of Amount (Gross/Net) Show values
Column Name Description Domain name
ITEMSUBCL Subclaim to Which a Payment Item Is Assigned CHAR3
COVTYPE Coverage Type ICL_COVTYPE
TREASONSET Payment Reason Group ICL_PAYREASONSET
TREASON Payment Reason ICL_PAYREASON
TXCOD Tax Code MWSKZ
TAXCODE_ID Tax Code for Other Taxes ICL_TAXCODE_ID
REFNO External Reference Number ICL_SCLITEMREF
REPID Coinsurance Key
ASSIGN_GUID UUID of Entry to be Linked SYSUUID_C
CDDOCITEM Item Number in Payment Plan Document ICL_DOCITEM
COUNTRY Key of Tax Country/Region CHAR3
REGION Key of Tax Region CHAR3
REFPAYITEM Claim Payment Item ICL_PAYMENTITEM
MSATZ Tax rate PRZ43V
KTOSL Transaction Key CHAR3
KSCHL Condition Type KSCHL
Master Data Relations Join Conditions
Changed By
  • ICSPAYI.CLIENT == USR02.MANDT
  • ICSPAYI.CHANGEDBY == USR02.BNAME
Client ICSPAYI.CLIENT == T000.MANDT
Payment Item Type
  • Payment Item Type
  • Client
  • ?
  • ICSPAYI.PAYITY == TICL291.PAYITY
  • ICSPAYI.CLIENT == TICL291.CLIENT
  • ICSPAYI.[column in domain "ICL_CMAREA"] == TICL291.CMAREA
Tax Category
Tax Jurisdiction Code
  • ?
  • Tax Jurisdiction Code
Other Relations | to Master Data Relations ↑ Join Conditions
Benefit Type
  • ?
  • ?
  • Client
  • ?
  • ?
  • Benefit Type
  • ICSPAYI.[column in domain "ICL_CLTYPE"] == TICL056.CLTYPE
  • ICSPAYI.[column in domain "ICL_SUBCLTYPE"] == TICL056.SUBCLTYPE
  • ICSPAYI.CLIENT == TICL056.CLIENT
  • ICSPAYI.[column in domain "ICL_CLTYPEG"] == TICL056.GENERAT
  • ICSPAYI.[column in domain "ICL_CLTYPEV"] == TICL056.VERSION
  • ICSPAYI.BENTYPE == TICL056.BENTYPE