SAP ABAP Table ICSPAY (Payment)
Hierarchy
☛
INSURANCE (Software Component) SAP Insurance
⤷ FS-CM (Application Component) Claims Management
⤷ ICL_CF (Package) FS-CM: Claims Management Financials
⤷ FS-CM (Application Component) Claims Management
⤷ ICL_CF (Package) FS-CM: Claims Management Financials
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | ICSPAY | Table Relationship Diagram |
Short Description | Payment |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
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 | .INCLUDE | 0 | 0 | Shadow Tables Versioning: Include for Shade Table | |||||
8 | CHANGEDBY | ICL_CHANGEDBY | XUBNAME | CHAR | 12 | 0 | Changed By | USR02 | |
9 | DELETED | ICL_RECSTATUS | ICL_RECSTATUS | CHAR | 1 | 0 | Database Line Status (Original, Changed, Deleted) | ||
10 | .INCLUDE | 0 | 0 | Attributes of ICLPAY | |||||
11 | .INCLUDE | 0 | 0 | Organizational Include (Short Version) | |||||
12 | CREATEDBY | ICL_CREATEDBY | XUBNAME | CHAR | 12 | 0 | Created By | USR02 | |
13 | CREATETIME | ICL_CREATEUTC | ICL_TIMESTAMP | DEC | 15 | 0 | Created: UTC Date+Time | ||
14 | APPROVEDBY | ICL_PAYMENT13 | XUBNAME | CHAR | 12 | 0 | Checked By | USR02 | |
15 | APPROVEDTIME | ICL_PAYMENT15UTC | ICL_TIMESTAMP | DEC | 15 | 0 | Date Checked (UTC Date+Time) | ||
16 | TRANSFERTIME | ICL_PAYMENT17UTC | ICL_TIMESTAMP | DEC | 15 | 0 | Transfer Date (UTC Date+Time) | ||
17 | DOCUMENTREF | ICL_DOCUMENTREF | ICL_DOCUMENTREF | CHAR | 14 | 0 | Reference for Payment Document Created in Subledger | ||
18 | POSTDATE | ICL_POSTDATE | DATE | DATS | 8 | 0 | Posting Date | ||
19 | DOCDATE | ICL_DOCDATE | DATE | DATS | 8 | 0 | Document Date of Payment | ||
20 | DUEDATE | ICL_DUEDATENET | DATE | DATS | 8 | 0 | Due Date for Net Payment | ||
21 | XALREADYPAID | ICL_ALREADYPAID | CHAR1 | CHAR | 1 | 0 | Payment Already Made | ||
22 | PAYCAT | ICL_PAYCAT | ICL_PAYCAT | CHAR | 1 | 0 | Record Type of Payment | ||
23 | PAYTYPE | ICL_PAYTYPE | ICL_PAYTYPE | CHAR | 1 | 0 | Payment Type (Final Payment, Payment After Closure of Claim) | ||
24 | SUBSAL | ICL_SUBSAL | ICL_SUBRO | NUMC | 3 | 0 | Subrogation/Salvage | ||
25 | XPAYEE | ICL_XPAYEE | CHAR1 | CHAR | 1 | 0 | Additional Payee (ICLPAYEE) | ||
26 | ADDRNUMBER | ICL_ADDRNUM | AD_ADDRNUM | CHAR | 10 | 0 | Address Number for Checks | ADRC | |
27 | CRECADDR | ICL_ADDRNUM | AD_ADDRNUM | CHAR | 10 | 0 | Address Number for Checks | * | |
28 | BKID | ICL_BKID | CHAR4 | CHAR | 4 | 0 | Bank Details ID | BUT0BK | |
29 | CURR | ICL_PAYMENTCUR | WAERS | CUKY | 5 | 0 | Claim Payment Currency | TCURC | |
30 | EXCHRATE | ICL_PAYMENT18 | KURSF | DEC | 9 | 5 | Exchange Rate of Payment Currency into Policy Currency | ||
31 | STATUS | ICL_PAYMENT12 | ICL_PAYMENT12 | CHAR | 2 | 0 | Internal Payment Status (Database Status) | ||
32 | METHOD | ICL_PAYMENT01 | PYMET_KK | CHAR | 1 | 0 | Payment Method | TFK042Z | |
33 | CHECKNUMBER | ICL_CHECK | ICL_CHECK | CHAR | 13 | 0 | Check Number for Manual Check Payments | ||
34 | NOTE | ICL_PAYMENT04 | TEXT50 | CHAR | 50 | 0 | Payment Note | ||
35 | INVOICEREF | ICL_INVOICEREF | CHAR20 | CHAR | 20 | 0 | External Invoice Number | ||
36 | REFCLAIM | ICL_CLAIM_REFPAY | ICL_CLAIM | CHAR | 17 | 0 | Claim Number (Reassignment Reference) | * | |
37 | REFSUBCLAIM | ICL_SUBCL_REFPAY | ICL_SUBCL | CHAR | 3 | 0 | Subclaim (Reassignment Reference) | * | |
38 | REFPAYMENT | ICL_PAYMENT_REFPAY | ICL_PAYMENT | NUMC | 5 | 0 | Claim Payment (Reassignment Reference) | * | |
39 | AMTDONE | ICL_AMOUNT_DONE | ICL_ITAMTS | CURR | 15 | 2 | Amount Paid or Received | ||
40 | LIABRATE | ICL_LIABRATE_NEG | ICL_PERCENT | DEC | 5 | 2 | Negotiated Liability Rate in Percent | ||
41 | AMTNEG | ICL_AMOUNTNEG | ICL_ITAMTS | CURR | 15 | 2 | Amount Negotiated | ||
42 | SUBROSTATUS | ICL_SUBROSTATUS | ICL_SUBROSTATUS | CHAR | 1 | 0 | Legal Status of Subrogation | ||
43 | TAXROLE | ICL_TAXROLE | ICL_TAXROLE | CHAR | 4 | 0 | Tax Role of Claim Payment Recipient | * | |
44 | TAX_RPT | ICL_TAXRPT | XFELD | CHAR | 1 | 0 | Flag for Reportable Payments | ||
45 | XTAXRPTCT | ICL_XTAXRPTCT | XFELD | CHAR | 1 | 0 | Code for Withholding Tax in Statutory Reporting Category | ||
46 | MTAXRPTCT | ICL_TAXRPTCT | QSSKZ | CHAR | 2 | 0 | Withholding Tax Code for Statutory Reporting | * | |
47 | OVRD_TAXRPTCT | ICL_OVRDTAXRPTCT | XFELD | CHAR | 1 | 0 | Manual Withholding Tax Code | ||
48 | FUNDSRECDT | ICL_SALVFUNDREC | ICL_SALVFUNDREC | DATS | 8 | 0 | Salvage: Funds Received | ||
49 | XSALVESTEND | ICL_XSALVESTEND | XFELD | CHAR | 1 | 0 | End Estimation of Salvage Value | ||
50 | OWNERTYPE_GRP | ICL_OWNERTYPE_GRP3 | OTYPE | CHAR | 2 | 0 | Responsible Organization Category | * | |
51 | OWNER_GRP | ICL_OWNER_GRP3 | XUBNAME | CHAR | 12 | 0 | Responsible Organizational Unit | * | |
52 | REASONREJ | ICL_REASONREJ | ICL_REASONREJ | CHAR | 2 | 0 | Rejection Reasons for Payments and Reserves | TICL112 | |
53 | REFEXTSDOC | ICL_REFEXTSDOC | ICL_PAYMENT | NUMC | 5 | 0 | Referenced Statistical Payment Entry | * | |
54 | MOS | ICL_MOS | ICL_MOS | CHAR | 3 | 0 | Method of Settlement | * | |
55 | CL_PAYFREQPLAN | ICL_PAYFREQPLAN | PKEY_VK | CHAR | 2 | 0 | Payment Frequency of Scheduled Payment | TVS010B | |
56 | PMTTO | ICL_PMTTO | DATUM | DATS | 8 | 0 | End Date of a Scheduled Payment | ||
57 | PMTFR | ICL_PMTFR | DATUM | DATS | 8 | 0 | Start Date of a Scheduled Payment | ||
58 | SCHEDTYPE | ICL_SCHEDULE_TYPE | ICL_SCHEDULE_TYPE | CHAR | 2 | 0 | Type of Scheduled Payment | TICL180 | |
59 | NROFINVREQ | ICL_INVOICES_REQUIRED | NUMC2 | NUMC | 2 | 0 | Mininum Number of Inbound Invoices | ||
60 | DAMAGEDOBJ | ICL_DAMOBJ | ICL_DAMOBJ | NUMC | 4 | 0 | Damaged Object | * | |
61 | MIGRATION | ICL_PAYMIGRATION | CHAR1 | CHAR | 1 | 0 | Indicator for Migrated Payments | ||
62 | REQEVALCAT | ICL_REQEVALCAT_D_PE | ICL_REQEVALCAT_PE | CHAR | 1 | 0 | Determination Category of Receivable Amount | ||
63 | ASSIGN_GUID | ICL_ASSIGN_GUID | SYSUUID_C | CHAR | 32 | 0 | UUID of Entry to be Linked | ||
64 | PAYOUT_SCENARIO | ICL_PAYOUT_SCENARIO_D | ICL_PAYOUT_SCENARIO | CHAR | 1 | 0 | Repetitive Payment Scenario |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | ICSPAY | ADDRNUMBER | ADRC | ADDRNUMBER | |||
2 | ICSPAY | APPROVEDBY | USR02 | BNAME | |||
3 | ICSPAY | BKID | BUT0BK | BKVID | |||
4 | ICSPAY | CHANGEDBY | USR02 | BNAME | |||
5 | ICSPAY | CLAIM | ICLCLAIM | CLAIM | |||
6 | ICSPAY | CLIENT | T000 | MANDT | |||
7 | ICSPAY | CL_PAYFREQPLAN | TVS010B | PKEY | REF | 1 | CN |
8 | ICSPAY | CREATEDBY | USR02 | BNAME | |||
9 | ICSPAY | CURR | TCURC | WAERS | |||
10 | ICSPAY | METHOD | TFK042Z | ZLSCH | |||
11 | ICSPAY | REASONREJ | TICL112 | REASONREJ | |||
12 | ICSPAY | SCHEDTYPE | TICL180 | SCHEDTYPE | REF | 1 | CN |
13 | ICSPAY | SUBCLAIM | ICLSUBCL | SUBCLAIM |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |