SAP ABAP Table ICL_BW_PAYMENT (Extract Structure for Claim Payments (Header + Items))
Hierarchy
☛
INSURANCE (Software Component) SAP Insurance
⤷ FS-CM (Application Component) Claims Management
⤷ ICL_EXTRACT (Package) FS-CM: Claims Management: Data Extracts
⤷ FS-CM (Application Component) Claims Management
⤷ ICL_EXTRACT (Package) FS-CM: Claims Management: Data Extracts
Basic Data
Table Category | INTTAB | Structure |
Structure | ICL_BW_PAYMENT | Table Relationship Diagram |
Short Description | Extract Structure for Claim Payments (Header + Items) |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | ACTIVE | ICL_ACTIVE | ICL_ACTIVE | CHAR | 1 | 0 | Table entry is active (A) or in suspense (S) | ||
3 | CLAIM | ICL_CLAIM | ICL_CLAIM | CHAR | 17 | 0 | Number of Claim | ICLCLAIM | |
4 | SUBCLAIM | ICL_SUBCLP | ICL_SUBCL | CHAR | 3 | 0 | Subclaim of Payment | ICLSUBCL | |
5 | PAYMENT | ICL_PAYMENT | ICL_PAYMENT | NUMC | 5 | 0 | Number of Claim Payment | * | |
6 | CHANGETIME | ICL_CHANGEUTC1 | ICL_TIMESTAMP | DEC | 15 | 0 | Changed: UTC Date+Time | ||
7 | CHANGEDBY | ICL_CHANGEDBY | XUBNAME | CHAR | 12 | 0 | Changed By | USR02 | |
8 | DELETED | ICL_RECSTATUS | ICL_RECSTATUS | CHAR | 1 | 0 | Database Line Status (Original, Changed, Deleted) | ||
9 | CREATEDBY | ICL_CREATEDBY | XUBNAME | CHAR | 12 | 0 | Created By | USR02 | |
10 | CREATETIME | ICL_CREATEUTC | ICL_TIMESTAMP | DEC | 15 | 0 | Created: UTC Date+Time | ||
11 | APPROVEDBY | ICL_PAYMENT13 | XUBNAME | CHAR | 12 | 0 | Checked By | USR02 | |
12 | APPROVEDTIME | ICL_PAYMENT15UTC | ICL_TIMESTAMP | DEC | 15 | 0 | Date Checked (UTC Date+Time) | ||
13 | TRANSFERTIME | ICL_PAYMENT17UTC | ICL_TIMESTAMP | DEC | 15 | 0 | Transfer Date (UTC Date+Time) | ||
14 | DOCUMENTREF | ICL_DOCUMENTREF | ICL_DOCUMENTREF | CHAR | 14 | 0 | Reference for Payment Document Created in Subledger | ||
15 | POSTDATE | ICL_POSTDATE | DATE | DATS | 8 | 0 | Posting Date | ||
16 | DOCDATE | ICL_DOCDATE | DATE | DATS | 8 | 0 | Document Date of Payment | ||
17 | DUEDATE | ICL_DUEDATENET | DATE | DATS | 8 | 0 | Due Date for Net Payment | ||
18 | XALREADYPAID | ICL_ALREADYPAID | CHAR1 | CHAR | 1 | 0 | Payment Already Made | ||
19 | PAYCAT | ICL_PAYCAT | ICL_PAYCAT | CHAR | 1 | 0 | Record Type of Payment | ||
20 | PAYTYPE | ICL_PAYTYPE | ICL_PAYTYPE | CHAR | 1 | 0 | Payment Type (Final Payment, Payment After Closure of Claim) | ||
21 | SUBSAL | ICL_SUBSAL | ICL_SUBRO | NUMC | 3 | 0 | Subrogation/Salvage | ||
22 | XPAYEE | ICL_XPAYEE | CHAR1 | CHAR | 1 | 0 | Additional Payee (ICLPAYEE) | ||
23 | ADDRNUMBER | ICL_ADDRNUM | AD_ADDRNUM | CHAR | 10 | 0 | Address Number for Checks | ADRC | |
24 | CRECADDR | ICL_ADDRNUM | AD_ADDRNUM | CHAR | 10 | 0 | Address Number for Checks | * | |
25 | BKID | ICL_BKID | CHAR4 | CHAR | 4 | 0 | Bank Details ID | BUT0BK | |
26 | CURR | ICL_PAYMENTCUR | WAERS | CUKY | 5 | 0 | Claim Payment Currency | TCURC | |
27 | EXCHRATE | ICL_PAYMENT18 | KURSF | DEC | 9 | 5 | Exchange Rate of Payment Currency into Policy Currency | ||
28 | STATUS | ICL_PAYMENT12 | ICL_PAYMENT12 | CHAR | 2 | 0 | Internal Payment Status (Database Status) | ||
29 | METHOD | ICL_PAYMENT01 | PYMET_KK | CHAR | 1 | 0 | Payment Method | TFK042Z | |
30 | CHECKNUMBER | ICL_CHECK | ICL_CHECK | CHAR | 13 | 0 | Check Number for Manual Check Payments | ||
31 | NOTE | ICL_PAYMENT04 | TEXT50 | CHAR | 50 | 0 | Payment Note | ||
32 | INVOICEREF | ICL_INVOICEREF | CHAR20 | CHAR | 20 | 0 | External Invoice Number | ||
33 | REFCLAIM | ICL_CLAIM_REFPAY | ICL_CLAIM | CHAR | 17 | 0 | Claim Number (Reassignment Reference) | * | |
34 | REFSUBCLAIM | ICL_SUBCL_REFPAY | ICL_SUBCL | CHAR | 3 | 0 | Subclaim (Reassignment Reference) | * | |
35 | REFPAYMENT | ICL_PAYMENT_REFPAY | ICL_PAYMENT | NUMC | 5 | 0 | Claim Payment (Reassignment Reference) | * | |
36 | AMTDONE | ICL_AMOUNT_DONE | ICL_ITAMTS | CURR | 15 | 2 | Amount Paid or Received | ||
37 | LIABRATE | ICL_LIABRATE_NEG | ICL_PERCENT | DEC | 5 | 2 | Negotiated Liability Rate in Percent | ||
38 | AMTNEG | ICL_AMOUNTNEG | ICL_ITAMTS | CURR | 15 | 2 | Amount Negotiated | ||
39 | SUBROSTATUS | ICL_SUBROSTATUS | ICL_SUBROSTATUS | CHAR | 1 | 0 | Legal Status of Subrogation | ||
40 | TAXROLE | ICL_TAXROLE | ICL_TAXROLE | CHAR | 4 | 0 | Tax Role of Claim Payment Recipient | * | |
41 | TAX_RPT | ICL_TAXRPT | XFELD | CHAR | 1 | 0 | Flag for Reportable Payments | ||
42 | XTAXRPTCT | ICL_XTAXRPTCT | XFELD | CHAR | 1 | 0 | Code for Withholding Tax in Statutory Reporting Category | ||
43 | MTAXRPTCT | ICL_TAXRPTCT | QSSKZ | CHAR | 2 | 0 | Withholding Tax Code for Statutory Reporting | * | |
44 | OVRD_TAXRPTCT | ICL_OVRDTAXRPTCT | XFELD | CHAR | 1 | 0 | Manual Withholding Tax Code | ||
45 | FUNDSRECDT | ICL_SALVFUNDREC | ICL_SALVFUNDREC | DATS | 8 | 0 | Salvage: Funds Received | ||
46 | XSALVESTEND | ICL_XSALVESTEND | XFELD | CHAR | 1 | 0 | End Estimation of Salvage Value | ||
47 | OWNERTYPE_GRP | ICL_OWNERTYPE_GRP3 | OTYPE | CHAR | 2 | 0 | Responsible Organization Category | * | |
48 | OWNER_GRP | ICL_OWNER_GRP3 | XUBNAME | CHAR | 12 | 0 | Responsible Organizational Unit | * | |
49 | REASONREJ | ICL_REASONREJ | ICL_REASONREJ | CHAR | 2 | 0 | Rejection Reasons for Payments and Reserves | TICL112 | |
50 | REFEXTSDOC | ICL_REFEXTSDOC | ICL_PAYMENT | NUMC | 5 | 0 | Referenced Statistical Payment Entry | * | |
51 | MOS | ICL_MOS | ICL_MOS | CHAR | 3 | 0 | Method of Settlement | * | |
52 | CL_PAYFREQPLAN | ICL_PAYFREQPLAN | PKEY_VK | CHAR | 2 | 0 | Payment Frequency of Scheduled Payment | TVS010B | |
53 | PMTTO | ICL_PMTTO | DATUM | DATS | 8 | 0 | End Date of a Scheduled Payment | ||
54 | PMTFR | ICL_PMTFR | DATUM | DATS | 8 | 0 | Start Date of a Scheduled Payment | ||
55 | SCHEDTYPE | ICL_SCHEDULE_TYPE | ICL_SCHEDULE_TYPE | CHAR | 2 | 0 | Type of Scheduled Payment | TICL180 | |
56 | NROFINVREQ | ICL_INVOICES_REQUIRED | NUMC2 | NUMC | 2 | 0 | Mininum Number of Inbound Invoices | ||
57 | DAMAGEDOBJ | ICL_DAMOBJ | ICL_DAMOBJ | NUMC | 4 | 0 | Damaged Object | * | |
58 | PAYMENTITEM | ICL_PAYMENTITEM | ICL_PAYMENTITEM | NUMC | 3 | 0 | Claim Payment Item | * | |
59 | ITEMSUBCL | ICL_ITEMSUBCLAIM | CHAR3 | CHAR | 3 | 0 | Subclaim to Which a Payment Item Is Assigned | ||
60 | PAYITEMCAT | ICL_PAYITEMCAT | ICL_PAYITEMCAT | CHAR | 1 | 0 | Claim Payment Item Category | ||
61 | PAMPAID | ICL_SCLITEMAP | ICL_ITAMTS | CURR | 15 | 2 | Payment Amount | ||
62 | BENTYPE | ICL_BENTYPE | ICL_BENTYPE | CHAR | 10 | 0 | Benefit Type | TICL055 | |
63 | COVTYPE | ICL_COVTYPE | ICL_COVTYPE | CHAR | 10 | 0 | Coverage Type | * | |
64 | PYMTYPE | ICL_PYMTYPE | ICL_PYMTYPE | CHAR | 4 | 0 | Tax Category | TICL551 | |
65 | PAYTYPEI | ICL_PAYTYPE | ICL_PAYTYPE | CHAR | 1 | 0 | Payment Type (Final Payment, Payment After Closure of Claim) | ||
66 | TREASONSET | ICL_PAYREASONSET | ICL_PAYREASONSET | CHAR | 2 | 0 | Payment Reason Group | TICL067 | |
67 | TREASON | ICL_PAYREASON | ICL_PAYREASON | CHAR | 4 | 0 | Payment Reason | TICL066 | |
68 | GROSS_NET | ICL_GROSS_NET | ICL_GROSS_NET | CHAR | 1 | 0 | Tax Category of Amount (Gross/Net) | ||
69 | TXCOD | ICL_TXCOD | MWSKZ | CHAR | 2 | 0 | Tax Code | * | |
70 | REQUESTED | ICL_REQUESTED | ICL_ITAMTS | CURR | 15 | 2 | Amount Requested | ||
71 | POSTDATEI | ICL_POSTDATE | DATE | DATS | 8 | 0 | Posting Date | ||
72 | ITEM | ICL_SCLITEM | ICL_SCLITEM | CHAR | 4 | 0 | Claim Item | ICLITEM | |
73 | REFNO | ICL_SCLITEMREF | ICL_SCLITEMREF | CHAR | 15 | 0 | External Reference Number | ||
74 | PAYITY | ICL_PAYITY | ICL_PAYITY | CHAR | 10 | 0 | Payment Item Type | TICL291 | |
75 | REPID | ICL_REPID | CHAR | 10 | 0 | Coinsurance Key | |||
76 | VALIDFROM | ICL_PAYVALIDFROM | DATE | DATS | 8 | 0 | Payment Item: Valid From | ||
77 | VALIDTO | ICL_PAYVALIDTO | DATE | DATS | 8 | 0 | Payment Item: Valid To | ||
78 | ASSIGN_GUID | ICL_ASSIGN_GUID | SYSUUID_C | CHAR | 32 | 0 | UUID of Entry to be Linked | ||
79 | P_CHANGETIME | ICL_CHANGEUTC1 | ICL_TIMESTAMP | DEC | 15 | 0 | Changed: UTC Date+Time | ||
80 | P_CHANGEDBY | ICL_CHANGEDBY | XUBNAME | CHAR | 12 | 0 | Changed By | USR02 | |
81 | P_DELETED | ICL_RECSTATUS | ICL_RECSTATUS | CHAR | 1 | 0 | Database Line Status (Original, Changed, Deleted) | ||
82 | CLAIMTYPE | ICL_CLTYPE | ICL_CLTYPE | CHAR | 4 | 0 | Internal Claim Type | TICL011 | |
83 | PAYEE | ICL_PAYE | BU_PARTNER | CHAR | 10 | 0 | Payee | * | |
84 | DATELOSS | ICL_LOSSDATE | DATE | DATS | 8 | 0 | Date of Loss/Claim | ||
85 | PLINEOFBUS | ICL_LINEOFBUS | ICL_LINEOFBUS | CHAR | 3 | 0 | Insurance Line of Business | * | |
86 | COMPANYCODE | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
87 | UPDMOD | RODMUPDMOD | RODMUPDMOD | CHAR | 1 | 0 | BW Delta Process: Record Mode |
Foreign Keys
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 464 |