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