SAP ABAP Table ICLH_ICLH40 (General Data for Invoice Header)
Hierarchy
☛
INSURANCE (Software Component) SAP Insurance
⤷ FS-CM (Application Component) Claims Management
⤷ ICLH_INVOICE (Package) Bill
⤷ FS-CM (Application Component) Claims Management
⤷ ICLH_INVOICE (Package) Bill
Basic Data
Table Category | INTTAB | Structure |
Structure | ICLH_ICLH40 | Table Relationship Diagram |
Short Description | General Data for Invoice Header |
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 | XSELECT | ICL_SELECT | BOOLE | CHAR | 1 | 0 | General Selection Indicator | ||
2 | DETAIL_SELECT | ICL_DETAIL_SELECT | CHAR | 50 | 0 | Details | |||
3 | CLAIM | ICL_CLAIM | ICL_CLAIM | CHAR | 17 | 0 | Number of Claim | * | |
4 | SUBCLAIM | ICL_SUBCL | ICL_SUBCL | CHAR | 3 | 0 | Subclaim | * | |
5 | PROCUREMENT | ICL_PROCUREMENT | ICL_PROCUREMENT | NUMC | 4 | 0 | ID of Claim Item Grouping | * | |
6 | .INCLUDE | 0 | 0 | View ICLH37: InvEntry Header Top | |||||
7 | PARTNER | ICL_INSURED | BU_PARTNER | CHAR | 10 | 0 | Insured Person | * | |
8 | DESCRP_PARTNER | ICL_DESCRIP | CHAR50 | CHAR | 50 | 0 | Participant in Claim: Description | ||
9 | ACQUISITIONDATE | ICL_ACQUISITIONDATE | DATS | DATS | 8 | 0 | Date Entered | ||
10 | CREATEDBY | ICL_CREATEDBY_INV | XUBNAME | CHAR | 12 | 0 | Invoice Created by | * | |
11 | INVTYPE | ICL_INVTYPE | ICL_PDOCCATTYPE | CHAR | 3 | 0 | Invoice Type | * | |
12 | INVTYPEN | ICL_INVTYPEN | ICL_PDOCCATTYPEN | CHAR | 40 | 0 | Text for Invoice Type | ||
13 | LOSSTYPE | ICL_LOSSTYPE | ICL_LOSSTYPE | CHAR | 4 | 0 | Incident Type of a Claim | * | |
14 | SUBCLTYPE | ICL_SUBCLTYPE | ICL_SUBCLTYPE | CHAR | 4 | 0 | Subclaim Type | TICL004 | |
15 | STATUS | ICL_INVOICESTATUS | ICL_STATUS | CHAR | 2 | 0 | Status of an Invoice | * | |
16 | STATUSN | ICL_INVOICESTATUSN | TEXT25 | CHAR | 25 | 0 | Name of Invoice Status | ||
17 | .INCLUDE | 0 | 0 | View ICLH51, InvE+Proc Hdr: InvCreationDte, InvReceipt Date | |||||
18 | ISSUEDATE | ICL_ISSUEDATE_INV | DATS | DATS | 8 | 0 | Invoice Date | ||
19 | RECEIVEDATE | ICL_RECEIVEDATE | DATS | DATS | 8 | 0 | Date Received | ||
20 | DATEFROM | ICL_DATEFROM_INV | DATS | DATS | 8 | 0 | Start of Invoice Period: Date | ||
21 | DATETO | ICL_DATETO_INV | DATS | DATS | 8 | 0 | End of Invoice Period: Date | ||
22 | .INCLUDE | 0 | 0 | InvE+ProcHdr: ExtCollIRef + ExtCollInvNo | |||||
23 | EXTERNALREF_BULK | ICL_EXTERNALREF_BULK | ICL_EXTERNALREF_BULK | CHAR | 20 | 0 | External Collective Reference | ||
24 | INVOICEREF_BULK | ICL_INVOICEREF_BULK | CHAR16 | CHAR | 16 | 0 | External Collective Invoice Number | ||
25 | .INCLUDE | 0 | 0 | InvEntry+Proc Hdr: Int CollLInv, ExtInvNo | |||||
26 | CCEVENT | ICL_CCEVENT_INVOICE | ICL_CCEVENT | CHAR | 17 | 0 | Internal Collective Invoice Number | * | |
27 | EXTERNALREF | ICL_INVOICEREF | CHAR20 | CHAR | 20 | 0 | External Invoice Number | ||
28 | .INCLUDE | 0 | 0 | InvEntry Header: Total Amt, Deductible, Use, Currency | |||||
29 | CURRENCY | ICL_CURRENCY | WAERS | CUKY | 5 | 0 | Currency | * | |
30 | PURPOSE | ICL_PURPOSE | CHAR | 50 | 0 | Purpose | |||
31 | CONTRIBAMOUNT_INV | ICL_CONTRIBAMOUNT_INV | ICL_AMOUNT | CURR | 15 | 2 | Amount of Copayment (Acc. to Invoice) | ||
32 | XCONTRIBAMOUNT_INV | ICL_XHDCTRB_AMOUNT_INV | BOOLE | CHAR | 1 | 0 | Header Deductible Amount Distributed to Items (Acc. to Inv) | ||
33 | AMOUNT_INV | ICL_INV_AMOUNT_TOTAL | ICL_AMOUNT | CURR | 15 | 2 | Net Total: Total of Net Amounts of All Items (acc.to Inv) | ||
34 | FEE | ICLH_FEE | ICL_AMOUNT | CURR | 15 | 2 | Fee | ||
35 | MATLABCOST | ICLH_MATLABCOST | ICL_AMOUNT | CURR | 15 | 2 | Material and Laboratory Costs | ||
36 | MATLABCOSTINT | ICLH_MATLABCOSTINT | ICL_AMOUNT | CURR | 15 | 2 | will be deleted. | ||
37 | ADDCOST | ICLH_ADDCOST | ICL_AMOUNT | CURR | 15 | 2 | Other Costs | ||
38 | AMOUNT | ICL_AMOUNT_TOTAL | ICL_AMOUNT | CURR | 15 | 2 | Total Amount (Sum of Net Amounts of All Items) | ||
39 | CONTRIBAMOUNT | ICL_AMOUNT_CONTRIB | ICL_AMOUNT | CURR | 15 | 2 | Copayment Deducted by Service Provider | ||
40 | XCONTRIBAMOUNT | ICL_XCONTRIBAMOUNT_POS | BOOLE | CHAR | 1 | 0 | Deductible Transferred from Invoice Header to Invoice Item | ||
41 | AMOUNT_CANCELED | ICL_AMOUNT_CANCELED | ICL_AMOUNT | CURR | 15 | 2 | Difference Amount of Items with Reason | ||
42 | XCANCEL | ICL_XCANCELED | XFELD | CHAR | 1 | 0 | Rejected | ||
43 | .INCLUDE | 0 | 0 | Approval Number for Invoice | |||||
44 | CLAIM_APPR | ICL_CLAIM_APPR | ICL_CLAIM | CHAR | 17 | 0 | Approval Number | * | |
45 | PROCUREMENT_APPR | ICL_PROCUREMENT_APPR | ICL_PROCUREMENT | NUMC | 4 | 0 | ID of Claim Item Grouping as Part of Approval Number | * | |
46 | SUBCLAIM_APPR | ICL_SUBCL_APPR | ICL_SUBCL | CHAR | 3 | 0 | Subclaim Number as Second Part of Approval Number | * | |
47 | .INCLUDE | 0 | 0 | Data Origin + Document Number | |||||
48 | DATASOURCE | ICL_DATASOURCE | ICL_DATASOURCE | CHAR | 2 | 0 | Data Origin | TICL136 | |
49 | EXTDOCUMENT | ICL_EXTDOCUMENT | ICL_EXTDOCUMENT | CHAR | 16 | 0 | External Document Number | ||
50 | DISCOUNTAMOUNT | ICL_DISCOUNTAMOUNT | ICL_AMOUNT | CURR | 15 | 2 | Discount on Invoice Amount | ||
51 | DISCOUNTPERCENT | ICL_DISCOUNTPERCENT | ICL_PERCENT | DEC | 5 | 2 | Discount on Total Invoice Amount in Percent | ||
52 | XDISCOUNTPERCENT | ICL_XDISCOUNTPERCENT | BOOLE | CHAR | 1 | 0 | Discount Amount Without Reference to Percent Discount | ||
53 | XDISCOUNT_POS | ICL_XDISCOUNT_POS | BOOLE | CHAR | 1 | 0 | Discount Transferred from Invoice Items | ||
54 | TOBEPAIDAMOUNT | ICL_AMOUNT_TOBEPAID | ICL_AMOUNT | CURR | 15 | 2 | Payout Amount | ||
55 | METHOD | ICL_PAYMETHOD_INV | PYMET_KK | CHAR | 1 | 0 | Payment Method acc. to Invoice | * | |
56 | METHODTXT | ICL_METHODTXT | FORMT_PAY | CHAR | 30 | 0 | Name of Payment Method | * | |
57 | PAYEE_SCR | ICL_PAYE_INV | BU_PARTNER | CHAR | 10 | 0 | Payee Acc. to Invoice | * | |
58 | PAYEE | ICL_PAYE_INV | BU_PARTNER | CHAR | 10 | 0 | Payee Acc. to Invoice | * | |
59 | DESCRP_PAYEE | ICL_PAYEDSC | CHAR50 | CHAR | 50 | 0 | Payee | ||
60 | PAYEE_ROLE | ICL_ROLE | ICL_ROLE | CHAR | 4 | 0 | Participant Role Key | * | |
61 | LE_PART_SCR | ICLH_LE_PART | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number of Service Provider | * | |
62 | LE_PART | ICLH_LE_PART | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number of Service Provider | * | |
63 | DESCRP_LE | ICLH_LE_DESCRP | TEXT50 | CHAR | 50 | 0 | Description of Service Provider Business Partner | ||
64 | LE_ROLE | ICL_ROLE | ICL_ROLE | CHAR | 4 | 0 | Participant Role Key | * | |
65 | VO_PART_SCR | ICLH_VO_PART | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number of Prescriber | * | |
66 | VO_PART | ICLH_VO_PART | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number of Prescriber | * | |
67 | DESCRP_VO | ICLH_VO_DESCRP | TEXT50 | CHAR | 50 | 0 | Description of Business Partner Issuing Prescription | ||
68 | VO_ROLE | ICL_ROLE | ICL_ROLE | CHAR | 4 | 0 | Participant Role Key | * | |
69 | OWNER | ICL_CLAIMOWNER | ICL_CLAIMOWNER | CHAR | 12 | 0 | ID of Claim Handler | ||
70 | INV_PART_SCR | ICL_INVOICER | BU_PARTNER | CHAR | 10 | 0 | Invoicing Party | * | |
71 | INV_PART | ICL_INVOICER | BU_PARTNER | CHAR | 10 | 0 | Invoicing Party | * | |
72 | DESCRP_INV | ICLH_INV_DESCRP | CHAR50 | CHAR | 50 | 0 | Textual Description of Invoicing Party | ||
73 | INV_ROLE | ICL_ROLE | ICL_ROLE | CHAR | 4 | 0 | Participant Role Key | * | |
74 | EBR_PART_SCR | ICLH_EBR_PART | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number of External Bill Reviewer | * | |
75 | EBR_PART | ICLH_EBR_PART | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number of External Bill Reviewer | * | |
76 | DESCRP_EBR | ICLH_EBR_DESCRP | CHAR50 | CHAR | 50 | 0 | Description of External Bill Review Provider | ||
77 | EBR_ROLE | ICL_ROLE | ICL_ROLE | CHAR | 4 | 0 | Participant Role Key | * | |
78 | POLH_PART | ICL_POLH | BU_PARTNER | CHAR | 10 | 0 | Insured | * | |
79 | DESCRP_POLH | ICLH_POLH_DESCRP | CHAR50 | CHAR | 50 | 0 | Text Description of Policyholder in Invoice | ||
80 | COST_ROLE | ICL_ROLE | ICL_ROLE | CHAR | 4 | 0 | Participant Role Key | * | |
81 | COST_PART_SCR | ICL_COSTCARRIER | BU_PARTNER | CHAR | 10 | 0 | Carrier | * | |
82 | COST_PART | ICL_COSTCARRIER | BU_PARTNER | CHAR | 10 | 0 | Carrier | * | |
83 | DESCRP_COST | ICL_COSTCARRIERN | CHAR50 | CHAR | 50 | 0 | Description of Carrier | ||
84 | .INCLUDE | 0 | 0 | InvProcessing Hdr: Checkbox "Serial Error Exists" | |||||
85 | XBULKERROR | ICL_XBULKERROR | XFELD | CHAR | 1 | 0 | Serial Error in Cross Collective Invoice | ||
86 | .INCLUDE | 0 | 0 | Invoice Header: Ins Obj Fields from DME, Mass Entry | |||||
87 | ISSUEDATE_PRESCR | ICL_ISSUEDATE_PRESCR | DATS | DATS | 8 | 0 | Date Prescription Created Acc. to Invoice | ||
88 | DUEDATE | ICL_DUEDATE_PAY | DATE | DATS | 8 | 0 | Payment Target | ||
89 | DUEDATE_ORIG | ICL_DUEDATE_PAY_ORIG | ICL_DUEDATE_PAY_ORIG | CHAR | 1 | 0 | Origin of Payment Target | ||
90 | COLOR | CHAR4 | CHAR4 | CHAR | 4 | 0 | Not More Closely Defined Area, Possibly Used for Patchlevels | ||
91 | XREIMBURSE | BOOLE_D | BOOLE | CHAR | 1 | 0 | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | ||
92 | XREQUEST | ICL_XREQUEST | XFELD | CHAR | 1 | 0 | Indicator: Receivable | ||
93 | .INCLUDE | 0 | 0 | Status for Procurement | |||||
94 | CANCEL | ICL_STATUS_CANCEL | XFELD | CHAR | 1 | 0 | Status "Cancelled" | ||
95 | REJECTED | ICL_STATUS_REJECTED | XFELD | CHAR | 1 | 0 | Status "Rejected" | ||
96 | INSUSPENSE | ICL_STATUS_INSUSPENSE | XFELD | CHAR | 1 | 0 | Status "Pending" | ||
97 | INPROCESS | ICL_STATUS_INPROCESS | XFELD | CHAR | 1 | 0 | Status "In Process" | ||
98 | RELEASED | ICL_STATUS_RELEASED | XFELD | CHAR | 1 | 0 | Status "Released" | ||
99 | XFINISHED | ICL_XFINISHED | XFELD | CHAR | 1 | 0 | Complete/Approved/Finished | ||
100 | ORDERED | ICL_STATUS_ORDERED | XFELD | CHAR | 1 | 0 | Status "Commissioned" | ||
101 | TRANSFERRED | ICL_STATUS_TRANSFERRED | XFELD | CHAR | 1 | 0 | Status "Reassigned" | ||
102 | INVSEQNUM | ICL_INVSEQNUM | ICL_PROCUREMENT | NUMC | 4 | 0 | Sequence Invoice Number Within Invoice | * | |
103 | .INCLUDE | 0 | 0 | External Bill Review: Header (#1) | |||||
104 | DESCRIPTION_EBR | ICL_DPDESC_EBR | TEXT40 | CHAR | 40 | 0 | Description of Claim Item (EBR) | ||
105 | REJREASON_EBR | ICL_ADJREASON | ICL_REJREASON | CHAR | 2 | 0 | Adjustment Reason | * | |
106 | REFNO_EBR | ICL_SCLITEMREF_EBR | ICL_SCLITEMREF | CHAR | 15 | 0 | External Reference Number (EBR) | ||
107 | STARTDATE_EBR | ICL_STARTDATE_EBR | DATE | DATS | 8 | 0 | Start Data Acc.to External Bill Reviewer | ||
108 | ENDDATE_EBR | ICL_ENDDATE_EBR | DATUM | DATS | 8 | 0 | End Date According to Invoice (External Bill Review) | ||
109 | PDREF_EBR | ICL_PDREF_EBR | ICL_PDREF_DOMAIN | CHAR | 10 | 0 | Reference to Purchasing Document | ||
110 | PDPOS_EBR | ICL_PDPOS_EBR | ICL_PDPOS | NUMC | 10 | 0 | Reference to Item Number (EBR) | ||
111 | .INCLUDE | 0 | 0 | External Bill Review: Header (#2) | |||||
112 | EBR_AMOUNT_TOTAL | ICL_EBR_AMOUNT_TOTAL | ICL_AMOUNT | CURR | 15 | 2 | Net Total: Sum of Net Amounts of All Items (EBR) | ||
113 | DISCOUNTAMOUNT_EBR | ICL_DISCOUNTAMOUNT_EBR | ICL_AMOUNT | CURR | 15 | 2 | Deduction - Invoice Amount (EBR) | ||
114 | CONTRIBAMOUNT_EBR | ICL_CONTRIBAMOUNT_EBR | ICL_AMOUNT | CURR | 15 | 2 | Copayment Amount (EBR) | ||
115 | EVCURR_EBR | ICL_EVCURR | WAERS | CUKY | 5 | 0 | Currency of Evaluated Amount | TCURC |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | ICLH_ICLH40 | DATASOURCE | TICL136 | DATASOURCE | KEY | 1 | CN |
2 | ICLH_ICLH40 | EVCURR_EBR | TCURC | WAERS | |||
3 | ICLH_ICLH40 | SUBCLTYPE | TICL004 | SUBCLTYPE |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 464 |