SAP ABAP Table E3OILK0 (IS-OIL/TAS: document header data)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-DS-TAS (Application Component) Interface to Terminal Automation System
     ⤷ OIK (Package) TAS/TPI Common Objects

Basic Data

Table Category	INTTAB	Structure
Structure	E3OILK0	Table Relationship Diagram
Short Description	IS-OIL/TAS: document header data

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	OID_EXTBOL	☐	OID_EXTBOL	OID_EXTBOL	CHAR	16	0	External bill of lading
2	OID_MISCDL	☐	OID_MISCDL	OID_MISCDL	CHAR	16	0	Miscellaneous delivery number
3	OIDMSG_SHP	☐	OIDMSG_SHP	OIDMSG_PRD	CHAR	1	0	Message type for contract restrictions ship-to party
4	OIDSTS_SHP	☐	OIDSTS_SHP	CHAR1_X	CHAR	1	0	Status of contract restriction for ship-to party
5	OIPIPEVAL	☐	OID_PIPEV	X	CHAR	1	0	Validation indicator for pipeline fields (X=ON, blank=OFF)
6	OIC_LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
7	OIC_DCITYC	☐	OIC_DCITYC	CITYC	CHAR	4	0	Destination city code	*
8	OIC_DCOUNC	☐	OIC_DCOUNC	COUNC	CHAR	3	0	Destination county code	*
9	OIC_DREGIO	☐	OIC_DREGIO	REGIO	CHAR	3	0	Destination region	*
10	OIC_DLAND1	☐	OIC_DLAND1	LAND1	CHAR	3	0	Destination country	*
11	OIC_OCITYC	☐	OIC_OCITYC	CITYC	CHAR	4	0	Origin city code	*
12	OIC_OCOUNC	☐	OIC_OCOUNC	COUNC	CHAR	3	0	Origin county code	*
13	OIC_OREGIO	☐	OIC_OREGIO	REGIO	CHAR	3	0	Origin region	*
14	OIC_OLAND1	☐	OIC_OLAND1	LAND1	CHAR	3	0	Origin country	*
15	OIC_PORGIN	☐	OIC_PORGIN	OIC_PORGIN	CHAR	15	0	Tax origin
16	OIC_PDESTN	☐	OIC_PDESTN	OIC_PDESTN	CHAR	15	0	Tax destination
17	OIC_PTRIP	☐	OIC_PTRIP	OIC_PTRIP	CHAR	16	0	Pipeline trip number (external)
18	OIC_PBATCH	☐	OIC_PBATCH	OIC_PBATCH	CHAR	16	0	Pipeline operator´s external batch number
19	OIC_MOT	☐	OIC_MOT	VKTRA	CHAR	2	0	IS-OIL MAP external details mode of transport	*
20	OIINEX	☐	OIH_INEX	OIH_INEX	CHAR	2	0	Code for internal or external excise duty rate determination	*
21	OIISOIL	☐	OID_ISOIL	OI0_XFELD	CHAR	1	0	Sales order created by IS-Oil: X=Yes BLANK=No
22	OIPTRFNC	☐	OID_PTRFNC	PARVW	CHAR	2	0	Partner function	*
23	OIPARTNR	☐	OID_PARTNR	KUNNR	CHAR	10	0	Customer name (sold-to party or ship-to party)	*
24	OILASTOR	☐	OID_LASTOR	VBELN	CHAR	10	0	Last order number	*
25	OIDRC	☐	OIC_DRC	OIC_DRC	CHAR	5	0	Differential Reference Code (DRC)	*
26	OIEXGNUM	☐	OIA_EXGNUM	OIA_EXGNUM	CHAR	10	0	Exchange agreement number	*
27	OIEXGTYP	☐	OIA_EXGTYP	OIA_EXGTYP	CHAR	4	0	Exchange type	*
28	OICHEADOFF	☐	KNRZE	KUNNR	CHAR	10	0	Head office account number (in branch accounts)	*
29	OIPBL	☐	OIF_PBLNR	OIF_PBLNR	CHAR	10	0	Business location identifier (IS-Oil MRN)	*
30	OIDRESTR	☐	OIDRESTR	CHAR1_X	CHAR	1	0	Contract restrictions flag
31	OIDMSG_PRD	☐	OIDMSG_PRD	OIDMSG_PRD	CHAR	1	0	Message type for product with contract restrictions
32	OIDMSG_QTY	☐	OIDMSG_QTY	OIDMSG_PRD	CHAR	1	0	Message type for contract restrictions quantity
33	OIDMSG_UOM	☐	OIDMSG_UOM	OIDMSG_PRD	CHAR	1	0	Message type for contract restrictions unit of measure
34	OIDMSG_DAT	☐	OIDMSG_DAT	OIDMSG_PRD	CHAR	1	0	Message type for contract restrictions validity period
35	OIDMSG_TRM	☐	OIDMSG_TRM	OIDMSG_PRD	CHAR	1	0	Message type for contract restrictions payment terms
36	OICNTPER	☐	OID_CNTPER	OID_CNTPER	CHAR	35	0	Contact person
37	OICNTNTE	☐	OID_CNTNTE	OID_CNTNTE	CHAR	35	0	Contact note
38	OICNTPHO	☐	OID_CNTPHO	OID_CNTPHO	CHAR	16	0	Contact tel. number
39	OID_SORTL	☐	OID_SORTL	OID_SORTL	NUMC	10	0	Descending sort key for sales orders (converted date)
40	OID_SORT2	☐	OID_SORT2	OID_SORTL	NUMC	10	0	Descending sort key for sales orders (converted time)
41	OICFKARTDI	☐	OICFKARTDI	FKART	CHAR	4	0	Differential invoice billing type proposal	*
42	OIAEVGTYPE	☐	OIA_EVTYPE	OIA_EVTYPE	CHAR	1	0	Evergreen type
43	OIC_TIME	☐	OIC_TIME	OIC_TIME	TIMS	6	0	Time for time-pricing
44	OITITLE	☐	OIC_TITLE	OIC_TITLE	CHAR	1	0	Location of title transfer for Incoterms purposes
45	OIPTRM1	☐	OIA_PTRM	ZTERM	CHAR	4	0	Payment terms for invoice cycle X
46	OIPTRM2	☐	OIA_PTRM	ZTERM	CHAR	4	0	Payment terms for invoice cycle X
47	OIPTRM3	☐	OIA_PTRM	ZTERM	CHAR	4	0	Payment terms for invoice cycle X
48	OIPTRM4	☐	OIA_PTRM	ZTERM	CHAR	4	0	Payment terms for invoice cycle X
49	OIPTRM5	☐	OIA_PTRM	ZTERM	CHAR	4	0	Payment terms for invoice cycle X
50	OIPTRM6	☐	OIA_PTRM	ZTERM	CHAR	4	0	Payment terms for invoice cycle X
51	OIPTRM7	☐	OIA_PTRM	ZTERM	CHAR	4	0	Payment terms for invoice cycle X
52	OIPTRM8	☐	OIA_PTRM	ZTERM	CHAR	4	0	Payment terms for invoice cycle X
53	OIPTRM9	☐	OIA_PTRM	ZTERM	CHAR	4	0	Payment terms for invoice cycle X
54	OIPFLIC	☐	OIH_PFLIC	PARVW	CHAR	2	0	IS-OIL partner function for tax exemption license	*

History

Last changed by/on	SAP	20110901
SAP Release Created in