| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | ACTIVE | Table entry is active (A) or in suspense (S) | char | 1 | 0 | CHAR | (N' ') | No | | ICL_ACTIVE | Allow NULL? |
| 3 | CLAIM | Number of Claim | nvarchar | 17 | 0 | CHAR | (N' ') | No | ICLCLAIM | ICL_CLAIM | Allow NULL? |
| 4 | SUBCLAIM | Subclaim of Payment | nvarchar | 3 | 0 | CHAR | (N' ') | No | ICLSUBCL | ICL_SUBCLP | Allow NULL? |
| 5 | PAYMENT | Number of Claim Payment | nvarchar | 5 | 0 | NUMC | (N'00000') | No | ICLPAY | ICL_PAYMENT | Allow NULL? |
| 6 | PAYMENTITEM | Claim Payment Item | nvarchar | 3 | 0 | NUMC | (N'000') | No | | ICL_PAYMENTITEM | Allow NULL? |
| 7 | CHANGETIME | Changed: Date + Time | decimal | 15 | 0 | DEC | ((0)) | Yes | | ICL_CHANGEUTC1 | |
| 8 | CHANGEDBY | Changed By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | USR02 | ICL_CHANGEDBY | Allow NULL? |
| 9 | DELETED | Database Line Status (Original, Changed, Deleted) | char | 1 | 0 | CHAR | (N' ') | Yes | | ICL_RECSTATUS | Allow NULL? |
| 10 | ITEMSUBCL | Subclaim to Which a Payment Item Is Assigned | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | ICL_ITEMSUBCLAIM | Allow NULL? |
| 11 | PAYITEMCAT | Claim Payment Item Category | char | 1 | 0 | CHAR | (N' ') | Yes | | ICL_PAYITEMCAT | Allow NULL? |
| 12 | PAMPAID | Payment Amount | decimal | 15 | 2 | CURR | ((0)) | Yes | | ICL_SCLITEMAP | |
| 13 | BENTYPE | Benefit Type | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TICL055 | ICL_BENTYPE | Allow NULL? |
| 14 | COVTYPE | Coverage Type | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ICL_COVTYPE | Allow NULL? |
| 15 | PYMTYPE | Tax Category | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TICL551 | ICL_PYMTYPE | Allow NULL? |
| 16 | PAYTYPEI | Payment Type (Final Payment, Payment After Closure of Claim) | char | 1 | 0 | CHAR | (N' ') | Yes | | ICL_PAYTYPE | Allow NULL? |
| 17 | TREASONSET | Payment Reason Group | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TICL067 | ICL_PAYREASONSET | Allow NULL? |
| 18 | TREASON | Payment Reason | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TICL066 | ICL_PAYREASON | Allow NULL? |
| 19 | GROSS_NET | Tax Category of Amount (Gross/Net) | char | 1 | 0 | CHAR | (N' ') | Yes | | ICL_GROSS_NET | Allow NULL? |
| 20 | TXCOD | Tax Code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | ICL_TXCOD | Allow NULL? |
| 21 | TAXCODE_ID | Tax Code for Other Taxes | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ICL_TAXCODE_ID_D | Allow NULL? |
| 22 | REQUESTED | Amount Requested | decimal | 15 | 2 | CURR | ((0)) | Yes | | ICL_REQUESTED | |
| 23 | POSTDATEI | Posting Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ICL_POSTDATE | Allow NULL? |
| 24 | ITEM | Claim Item | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | ICLITEM | ICL_SCLITEM | Allow NULL? |
| 25 | REFNO | External Reference Number | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | ICL_SCLITEMREF | Allow NULL? |
| 26 | PAYITY | Payment Item Type | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TICL291 | ICL_PAYITY | Allow NULL? |
| 27 | REPID | Coinsurance Key | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ICL_REPID | Allow NULL? |
| 28 | VALIDFROM | Payment Item: Valid From | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ICL_PAYVALIDFROM | Allow NULL? |
| 29 | VALIDTO | Payment Item: Valid To | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ICL_PAYVALIDTO | Allow NULL? |
| 30 | ASSIGN_GUID | UUID of Entry to be Linked | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | ICL_ASSIGN_GUID | Allow NULL? |
| 31 | CDDOCITEM | Item Number in Payment Plan Document | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | ICL_DOCITEM | Allow NULL? |
| 32 | REQUESTED_ORIG | Original Amount Requested | decimal | 15 | 2 | CURR | ((0)) | Yes | | ICL_REQUESTED_ORIG | |
| 33 | DUP_PAMPAID | Payment Amount | decimal | 15 | 2 | CURR | ((0)) | Yes | | ICL_SCLITEMAP | |
| 34 | COUNTRY | Key of Tax Country | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | ICL_COUNTRYCD_D | Allow NULL? |
| 35 | REGION | Key of Tax Region | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | ICL_REGIONCD_D | Allow NULL? |
| 36 | TXJCD | Tax Jurisdiction Code | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | J_1BTXJUR | /GSINS/TXJCD | Allow NULL? |
| 37 | TXBSAMT | Tax Base Amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | /GSINS/TXBAS | |
