	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OVPM	154	Outgoing Payments
5	OIVL	77	Whse Journal
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

177 COLUMNS | 3 INDEXES | ERP 6.0 | OIJNOMI TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Industry Specific :: Industry Solution Oil :: Downstream :: Traders and Schedulers Workbench
1	ERP EHP7	6.0	OIJNOMI	177	3	Nomination Item	Traders and Schedulers Workbench

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, NOMTK, NOMIT, SITYP, ISTAT, ISUBSTAT, IDATE, SCHED_TST_FROM, SCHED_TST_TO, LOCID, S_MATNR_I, MATNR_I, MENGE, UNIT_I, UNIT_I_T, DOCIND, DOCNR, DOCITM, DOCSCHEDLN, QTYFCR, QTYFCR_UOM, WORKLIST_I, TANK, CONS, PARTNR, CONPAT, INSPE, IMPOEXPO, FLAG_IMEX, OWNER, CHARG_O, CHARG_D, RVP, VALUATIONTYPE_O, VALUATIONTYPE_D, SHNUM, SHITEM, ILOCK, PRORATEQTY, ASSIGNEDQTY, ACTDAT, ACTTIME, ACTUALS, ACTUALQTY, ACTUALUOM, ITBOTOL, ITBUTOL, ITBOTOLABS, ITBUTOLABS, ITTOLUNIT, UNLIMITED, BLOIND, DELIND, UPDATEXDOK, INCOMPLETE_FLAG, DOCTYP, LDRATE, LDQUOM, LDTUOM, THIRD_NOMNR, UPMAT, REFITEM, STLTY, STLKN, CHARG_D_CREATE, CHARG_O_CREATE, CO_CARR, CO_SHIP, CO_TSYST, COMMCTL, SOLDTO, PRORATE_ROUTINE, CHARG_L, CHARG_L_CREATE, TCNUM, TCITM, GA_NMSHIPPER, GA_CONF_QTY, GA_CONF_UOM, GA_TECHSCH_QTY, GA_TECHSCH_UOM, GA_CONF_QTY_CAL, GA_TSCH_QTY_CAL, GA_ALLOCATED_QTY, GA_ALLOCATED_UOM, GA_RANK, CYCLE_ITEM, LESSHNUM, LESTPNUM, ATL_DELV_NUMBER, ATL_DELV_ITM, ATL_CRDT_QTY, ATL_CRDT_UOM, ATL_CRDT_VAL, ATL_CRDT_CURR, PRE_EXIST_IND, PLANIND, LOCPT, LOCSL, QUICKCONF, ERDAT, ERZEIT, ERNAM, AEDAT, AEZEIT, AENAM, LOCNAM, VBELN, POSNR, NOMIT_CONS, ACTUALQTY_PAR, ACTUALUOM_PAR, LOV_IND, FERRYIND, RAILCARQTY, OITAXFROM, OIHANTYP, OITAXGRP, OITAXTO, OIOILCON, OIEDBAL, OIPRICIE, OIINEX, OIEDBALM, LOG_PROC, TAX_PROC, OICERTF1, OIDATFM1, OIDATTO1, OIH_LICTP, OIH_LICIN, OIH_LCFOL, OIH_FOLQTY, OICERTF1_GI, OIDATFM1_GI, OIDATTO1_GI, OIH_LICTP_GI, OIH_LICIN_GI, OIH_LCFOL_GI, OIH_FOLQTY_GI, OIPIPEVAL, OIC_LIFNR, OIC_DCITYC, OIC_DCOUNC, OIC_DREGIO, OIC_DLAND1, OIC_OCITYC, OIC_OCOUNC, OIC_OREGIO, OIC_OLAND1, OIC_PORGIN, OIC_PDESTN, OIC_PTRIP, OIC_PBATCH, OIC_MOT, OIC_AORGIN, OIC_ADESTN, OIC_TRUCKN, OIA_BASELO, OIEDOK, OIEDOK_GI, OIEDBAL_GI, OIEDBALM_GI, OIHANTYP_GI, OIINEX_GI, OITAXGRP_GI, OITAXFROM_GI, OITAXTO_GI, BWTAR_INTRANSIT, HT_GL, HT_LOAD, HT_DIS, LICIN_NUM, LICEXT_NUM, OIH_DISTLIC, SHIP_FROM, DUTY_TO FROM OIJNOMI

TOP ERP 6.0 | OIJNOMI COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	CLNT	(N'000')	No	T000	MANDT	Allow NULL?
2	NOMTK	Nomination (technical) Key	nvarchar	20	0	CHAR	(N' ')	No	OIJNOMH	OIJ_NOMTK	Allow NULL?
3	NOMIT	Nomination Key Item	nvarchar	10	0	NUMC	(N'0000000000')	No		OIJ_ITEM	Allow NULL?
4	SITYP	Schedule type	nvarchar	2	0	CHAR	(N' ')	Yes	TOIJ_EL_SITYPES	OIJ_SITYP	Allow NULL?
5	ISTAT	Nomination Item status	char	1	0	CHAR	(N' ')	Yes	OIJSTAT	OIJ_ISTAT	Allow NULL?
6	ISUBSTAT	Nomination Item sub-status	char	1	0	CHAR	(N' ')	Yes	OIJSUBSTAT	OIJ_SSTAT	Allow NULL?
7	IDATE	Scheduled date	nvarchar	8	0	DATS	(N'00000000')	Yes		OIJ_IDATE	Allow NULL?
8	SCHED_TST_FROM	Scheduled / Acceptance / Pipe Batch Start Timestamp	decimal	15	0	DEC	((0))	Yes		OIJ_SCHED_F
9	SCHED_TST_TO	Scheduled / Acceptance / Pipe Batch End Timestamp	decimal	15	0	DEC	((0))	Yes		OIJ_SCHED_T
10	LOCID	Location ID	nvarchar	10	0	CHAR	(N' ')	Yes	OIJLOC	OIJ_LOCID	Allow NULL?
11	S_MATNR_I	Scheduled material	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	OIJ_SMATNR	Allow NULL?
12	MATNR_I	Demand material	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	OIJ_MATNRI	Allow NULL?
13	MENGE	Scheduled qty	decimal	13	3	QUAN	((0))	Yes		OIJ_MENGE
14	UNIT_I	Scheduled UoM	nvarchar	3	0	UNIT	(N' ')	Yes	T006	OIJ_UNITI	Allow NULL?
15	UNIT_I_T	Scheduled UoM Time	nvarchar	3	0	UNIT	(N' ')	Yes	*	OIJ_UNITI_T	Allow NULL?
16	DOCIND	Reference document indicator (PSX)	char	1	0	CHAR	(N' ')	Yes		OIJ_DOCIND	Allow NULL?
17	DOCNR	Nomination Reference Document	nvarchar	10	0	CHAR	(N' ')	Yes		OIJ_DOCNR	Allow NULL?
18	DOCITM	Nomination Reference Document Item	nvarchar	6	0	NUMC	(N'000000')	Yes		OIJ_DOCITM	Allow NULL?
19	DOCSCHEDLN	Nomination Reference Document Schedule line	nvarchar	4	0	NUMC	(N'0000')	Yes	*	OIJ_DOCSCHEDLN	Allow NULL?
20	QTYFCR	First requested quantity	decimal	13	3	QUAN	((0))	Yes		OIJ_QTYFCR
21	QTYFCR_UOM	First Requested Quantity UoM	nvarchar	3	0	UNIT	(N' ')	Yes	*	OIJ_QTYFCR_UOM	Allow NULL?
22	WORKLIST_I	Worklist entry indicator	char	1	0	CHAR	(N' ')	Yes		OIJ_WORKLT	Allow NULL?
23	TANK	Tankage Partner	nvarchar	10	0	CHAR	(N' ')	Yes		OIJ_TANKAGE	Allow NULL?
24	CONS	Consignee Partner	nvarchar	10	0	CHAR	(N' ')	Yes		OIJ_CONSIGNEE	Allow NULL?
25	PARTNR	Location Partner	nvarchar	10	0	CHAR	(N' ')	Yes		OIJ_PARTNR	Allow NULL?
26	CONPAT	Contract Partner	nvarchar	10	0	CHAR	(N' ')	Yes		OIJ_CONPAT	Allow NULL?
27	INSPE	Inspector	nvarchar	10	0	CHAR	(N' ')	Yes		OIJ_INSPECTOR	Allow NULL?
28	IMPOEXPO	Import / Export Partner	nvarchar	10	0	CHAR	(N' ')	Yes	LFA1	OIJ_IMEXPO	Allow NULL?
29	FLAG_IMEX	Import / Export Partner Indicator	nvarchar	2	0	CHAR	(N' ')	Yes	OIJIMEX	OIJ_IMEXFL	Allow NULL?
30	OWNER	Valuation Type	nvarchar	10	0	CHAR	(N' ')	Yes	T149D	BWTAR_D	Allow NULL?
31	CHARG_O	Batch origin Location	nvarchar	10	0	CHAR	(N' ')	Yes	*	OIJ_CHARGO	Allow NULL?
32	CHARG_D	Batch destination Location	nvarchar	10	0	CHAR	(N' ')	Yes	*	OIJ_CHARGD	Allow NULL?
33	RVP	RVP value	decimal	4	1	DEC	((0))	Yes		OIJ_RVP
34	VALUATIONTYPE_O	Valuation Type Origin Loc.	nvarchar	10	0	CHAR	(N' ')	Yes	T149D	OIJ_BWTAR_O	Allow NULL?
35	VALUATIONTYPE_D	Valuation Type Destination Loc.	nvarchar	10	0	CHAR	(N' ')	Yes	T149D	OIJ_BWTAR_D	Allow NULL?
36	SHNUM	TD shipment number	nvarchar	10	0	CHAR	(N' ')	Yes	OIGS	OIG_SHNUM	Allow NULL?
37	SHITEM	Shipment item	nvarchar	4	0	NUMC	(N'0000')	Yes	OIGSI	OIG_SHITM	Allow NULL?
38	ILOCK	Nomination item complete flag	char	1	0	CHAR	(N' ')	Yes		OIJ_ILOCK	Allow NULL?
39	PRORATEQTY	Prorated Quantity	decimal	13	3	QUAN	((0))	Yes		OIJ_PRRA_QTY
40	ASSIGNEDQTY	Assigned Quantity	decimal	13	3	QUAN	((0))	Yes		OIJ_ASSG_QTY
41	ACTDAT	Last item action date	nvarchar	8	0	DATS	(N'00000000')	Yes		OIJ_ACTDAT	Allow NULL?
42	ACTTIME	Last item action time	nvarchar	6	0	TIMS	(N'000000')	Yes		OIJ_ACTIME	Allow NULL?
43	ACTUALS	Nomination item partially complete	char	1	0	CHAR	(N' ')	Yes		OIJ_ACTUAL	Allow NULL?
44	ACTUALQTY	Actual posted quantity	decimal	13	3	QUAN	((0))	Yes		OIJ_ACTQTY
45	ACTUALUOM	Actual posted quantity Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	OIJ_ACTUOM	Allow NULL?
46	ITBOTOL	Quantity tolerance over (percentage)	decimal	4	1	DEC	((0))	Yes		OIJ_BOTOL
47	ITBUTOL	Quantity tolerance under (%)	decimal	4	1	DEC	((0))	Yes		OIJ_BUTOL
48	ITBOTOLABS	Absolute tolerance qty over	decimal	13	3	QUAN	((0))	Yes		OIJ_TOLABO
49	ITBUTOLABS	Absolute tolerance qty under	decimal	13	3	QUAN	((0))	Yes		OIJ_TOLABS
50	ITTOLUNIT	Absolute tolerance UoM	nvarchar	3	0	UNIT	(N' ')	Yes	T006	OIJ_TOLUOM	Allow NULL?
51	UNLIMITED	Indicator: Unlimited Overdelivery Allowed	char	1	0	CHAR	(N' ')	Yes		UEBTK	Allow NULL?
52	BLOIND	Blocking indicator	char	1	0	CHAR	(N' ')	Yes		OIJ_BLOIND	Allow NULL?
53	DELIND	Deletion indicator	char	1	0	CHAR	(N' ')	Yes		OIJ_DELIND	Allow NULL?
54	UPDATEXDOK	Update external details failure flag	char	1	0	CHAR	(N' ')	Yes		OIJ_EXDOK	Allow NULL?
55	INCOMPLETE_FLAG	Incompletion Flag	char	1	0	CHAR	(N' ')	Yes		OIJ_INCOMPLETE_FLAG	Allow NULL?
56	DOCTYP	Reference Document Type	nvarchar	4	0	CHAR	(N' ')	Yes		OIJ_DOCTYP	Allow NULL?
57	LDRATE	Planned load/discharge rate	decimal	13	3	QUAN	((0))	Yes		OIJ_EL_LDRATE
58	LDQUOM	Planned load/discharge rate quantity UoM	nvarchar	3	0	UNIT	(N' ')	Yes	*	OIJ_EL_LDQUOM	Allow NULL?
59	LDTUOM	Planned load/discharge rate time UOM	nvarchar	3	0	UNIT	(N' ')	Yes	*	OIJ_EL_LDTUOM	Allow NULL?
60	THIRD_NOMNR	Partner Nomination number	nvarchar	20	0	CHAR	(N' ')	Yes		OIJ_3RD_NOMNR	Allow NULL?
61	UPMAT	Pricing reference material of main item	nvarchar	18	0	CHAR	(N' ')	Yes	*	UPMAT	Allow NULL?
62	REFITEM	Higher-level item in bill of material structures	nvarchar	10	0	NUMC	(N'0000000000')	Yes	*	OIJ_REF_BOM_ITEM	Allow NULL?
63	STLTY	BOM category	char	1	0	CHAR	(N' ')	Yes		STLTY	Allow NULL?
64	STLKN	BOM item node number	nvarchar	8	0	NUMC	(N'00000000')	Yes		STLKN	Allow NULL?
65	CHARG_D_CREATE	Destination Batch create new flag	char	1	0	CHAR	(N' ')	Yes		OIJ_CHARG_D_C	Allow NULL?
66	CHARG_O_CREATE	Origin Batch create new flag	char	1	0	CHAR	(N' ')	Yes		OIJ_CHARG_O_C	Allow NULL?
67	CO_CARR	Connecting carrier	nvarchar	10	0	CHAR	(N' ')	Yes	*	OIJ_EL_CCA	Allow NULL?
68	CO_SHIP	Connecting shipper	nvarchar	10	0	CHAR	(N' ')	Yes	*	OIJ_EL_CSH	Allow NULL?
69	CO_TSYST	Connecting Transport System	nvarchar	10	0	CHAR	(N' ')	Yes	*	OIJ_EL_CTSYST	Allow NULL?
70	COMMCTL	Nomination Communication Control	nvarchar	2	0	CHAR	(N' ')	Yes		OIJ_NOMCOMM	Allow NULL?
71	SOLDTO	Customer Sold-to or Vendor	nvarchar	10	0	CHAR	(N' ')	Yes		OIJ_SOLDTO	Allow NULL?
72	PRORATE_ROUTINE	Prorate Calculation Routine Type	nvarchar	6	0	CHAR	(N' ')	Yes	TOIJ_EL_PR_RT	OIJ_EL_DE_PR_RT	Allow NULL?
73	CHARG_L	Batch load	nvarchar	10	0	CHAR	(N' ')	Yes	*	OIJ_CHARGL	Allow NULL?
74	CHARG_L_CREATE	Load Batch create new flag	char	1	0	CHAR	(N' ')	Yes		OIJ_CHARG_L_C	Allow NULL?
75	TCNUM	TSW :Trading Contract number	nvarchar	10	0	CHAR	(N' ')	Yes		OIJ_TCNR	Allow NULL?
76	TCITM	TSW: Trading contract item number	nvarchar	6	0	NUMC	(N'000000')	Yes		OIJ_TCITM	Allow NULL?
77	GA_NMSHIPPER	Shipper	nvarchar	10	0	CHAR	(N' ')	Yes	*	OIJ_SHIPNR	Allow NULL?
78	GA_CONF_QTY	Confirmed Quantity	decimal	13	3	QUAN	((0))	Yes		OIJ_CONFQTY
79	GA_CONF_UOM	Unit of Measure for Confirmed Quantity Field	nvarchar	3	0	UNIT	(N' ')	Yes	*	OIJ_CONFUOM	Allow NULL?
80	GA_TECHSCH_QTY	Technical Scheduled Quantity Field	decimal	13	3	QUAN	((0))	Yes		OIJ_TECHSCHQTY
81	GA_TECHSCH_UOM	Unit of Measure for Technical Scheduled Quantity Field	nvarchar	3	0	UNIT	(N' ')	Yes	*	OIJ_TECHSCHUOM	Allow NULL?
82	GA_CONF_QTY_CAL	Calculated Values of Confirmed Quantity Field	decimal	13	3	QUAN	((0))	Yes		OIJ_CONFQTY_CAL
83	GA_TSCH_QTY_CAL	Calculated Values of Technical Scheduled Quantity Field	decimal	13	3	QUAN	((0))	Yes		OIJ_TECHSCH_QTY_CAL
84	GA_ALLOCATED_QTY	Allocated Quantity	decimal	13	3	QUAN	((0))	Yes		OIJ_ALLOCATED_QTY
85	GA_ALLOCATED_UOM	Unit of Measure for Allocated Quantity Field	nvarchar	3	0	UNIT	(N' ')	Yes	*	OIJ_ALLOCATED_UOM	Allow NULL?
86	GA_RANK	Rank	tinyint	3	0	INT1	((0))	Yes		OIJ_RANK
87	CYCLE_ITEM	Nomination Pipeline cycle ID at Item Level	nvarchar	10	0	CHAR	(N' ')	Yes		OIJ_ITEMCYCLE	Allow NULL?
88	LESSHNUM	Shipment Number	nvarchar	10	0	CHAR	(N' ')	Yes	VTTK	TKNUM	Allow NULL?
89	LESTPNUM	Shipment item	nvarchar	4	0	NUMC	(N'0000')	Yes	VTTP	TPNUM	Allow NULL?
90	ATL_DELV_NUMBER	ATL credit check delivery number	nvarchar	10	0	CHAR	(N' ')	Yes	*	OIJ_ATL_DELV	Allow NULL?
91	ATL_DELV_ITM	ATL credit check delivery item	nvarchar	6	0	NUMC	(N'000000')	Yes	*	OIJ_ATL_DELV_ITM	Allow NULL?
92	ATL_CRDT_QTY	ATL Credit Quantity	decimal	13	3	QUAN	((0))	Yes		OIJ_ATL_CREDIT_QTY
93	ATL_CRDT_UOM	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	*	MEINS	Allow NULL?
94	ATL_CRDT_VAL	ATL Credit Amount	decimal	15	2	CURR	((0))	Yes		OIJ_ATL_CREDIT_AMT
95	ATL_CRDT_CURR	ATL Credit Currency	nvarchar	5	0	CUKY	(N' ')	Yes	*	OIJ_ATL_CREDIT_CURR	Allow NULL?
96	PRE_EXIST_IND	ATL Preexisting Delivery Indicator	char	1	0	CHAR	(N' ')	Yes		OIJ_ATL_PREEXIST_IND	Allow NULL?
97	PLANIND	Planning location flag	char	1	0	CHAR	(N' ')	Yes		OIJ_PLANIN	Allow NULL?
98	LOCPT	Location Partner Plant	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	OIJ_LOCPT	Allow NULL?
99	LOCSL	Location Partner Storage Location	nvarchar	4	0	CHAR	(N' ')	Yes	T001L	OIJ_LOCSL	Allow NULL?
100	QUICKCONF	Quick Confirm check box	char	1	0	CHAR	(N' ')	Yes		OIJ_QC	Allow NULL?
101	ERDAT	Date on Which Record Was Created	nvarchar	8	0	DATS	(N'00000000')	Yes		ERDAT	Allow NULL?
102	ERZEIT	Time of creation	nvarchar	6	0	TIMS	(N'000000')	Yes		OI0_ERTIM	Allow NULL?
103	ERNAM	Name of Person who Created the Object	nvarchar	12	0	CHAR	(N' ')	Yes		ERNAM	Allow NULL?
104	AEDAT	Changed On	nvarchar	8	0	DATS	(N'00000000')	Yes		AEDAT	Allow NULL?
105	AEZEIT	Time of day the record was changed	nvarchar	6	0	TIMS	(N'000000')	Yes		OI0_AETIM	Allow NULL?
106	AENAM	Name of Person Who Changed Object	nvarchar	12	0	CHAR	(N' ')	Yes		AENAM	Allow NULL?
107	LOCNAM	Location name (used by system owner)	nvarchar	60	0	CHAR	(N' ')	Yes		OIJ_LOCNAM	Allow NULL?
108	VBELN	Delivery	nvarchar	10	0	CHAR	(N' ')	Yes	VBUK	VBELN_VL	Allow NULL?
109	POSNR	Delivery Item	nvarchar	6	0	NUMC	(N'000000')	Yes	VBUP	POSNR_VL	Allow NULL?
110	NOMIT_CONS	OIL-TSW: Referenced nomination item for bunker consumption	nvarchar	10	0	NUMC	(N'0000000000')	Yes		OIJ_NOMIT_CONS	Allow NULL?
111	ACTUALQTY_PAR	Actual posted parallel quantity	decimal	13	3	QUAN	((0))	Yes		OIJ_ACTQTY_PAR
112	ACTUALUOM_PAR	Actual posted quantity Parallel Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	*	OIJ_ACTUOM_PAR	Allow NULL?
113	LOV_IND	TSW: Ticket Type 'Left on Vehicle'	char	1	0	CHAR	(N' ')	Yes		OIJ_LOV	Allow NULL?
114	FERRYIND	By Ferry	char	1	0	CHAR	(N' ')	Yes		OIJ_RU_FERRIND	Allow NULL?
115	RAILCARQTY	Number of Railcars	int	10	0	INT4	((0))	Yes		OIJ_RU_RAILQTY	Allow NULL?
116	OITAXFROM	Excise duty tax key for 'from' location	nvarchar	2	0	CHAR	(N' ')	Yes	OIH4	OIH_TAXFRO	Allow NULL?
117	OIHANTYP	Excise Duty Handling Type	nvarchar	2	0	CHAR	(N' ')	Yes	OIH5	OIH_HANTYP	Allow NULL?
118	OITAXGRP	Excise Duty Group	nvarchar	2	0	CHAR	(N' ')	Yes	OIH2	OIH_TAXGRP	Allow NULL?
119	OITAXTO	Excise duty tax key for 'to' location	nvarchar	2	0	CHAR	(N' ')	Yes	OIH4	OIH_TAXTO	Allow NULL?
120	OIOILCON	Oil content in a material as a percentage	decimal	5	2	DEC	((0))	Yes		OIH_OILCON
121	OIEDBAL	Excise duty balancing is required (indicator)	char	1	0	CHAR	(N' ')	Yes		OIH_EDBAL	Allow NULL?
122	OIPRICIE	ED pricing: external (indicator)	char	1	0	CHAR	(N' ')	Yes		OIH_PRICIE	Allow NULL?
123	OIINEX	Code for internal or external excise duty rate determination	nvarchar	2	0	CHAR	(N' ')	Yes	OIH16	OIH_INEX	Allow NULL?
124	OIEDBALM	Excise duty balancing method indicator	char	1	0	CHAR	(N' ')	Yes		OIH_EDBALM	Allow NULL?
125	LOG_PROC	Logistic Procedure	char	1	0	CHAR	(N' ')	Yes	*	OIH_LOGPROC	Allow NULL?
126	TAX_PROC	Tax Procedure	nvarchar	2	0	CHAR	(N' ')	Yes	*	OIH_TAXPROC	Allow NULL?
127	OICERTF1	Excise tax external license number	nvarchar	15	0	CHAR	(N' ')	Yes		OIH_CERTF1	Allow NULL?
128	OIDATFM1	Excise Duty License Valid from Date	nvarchar	8	0	DATS	(N'00000000')	Yes		OIH_DATFM1	Allow NULL?
129	OIDATTO1	Valid to date for excise duty tax certificate	nvarchar	8	0	DATS	(N'00000000')	Yes		OIH_DATTO1	Allow NULL?
130	OIH_LICTP	License type	nvarchar	4	0	CHAR	(N' ')	Yes	OIH20	OIH_LICTP	Allow NULL?
131	OIH_LICIN	Excise tax internal license number	nvarchar	10	0	CHAR	(N' ')	Yes	OIHL	OIH_LICIN	Allow NULL?
132	OIH_LCFOL	Follow-on license for quantity license	nvarchar	10	0	CHAR	(N' ')	Yes	OIHL	OIH_LCFOL	Allow NULL?
133	OIH_FOLQTY	Excise Tax Follow-On License Quantity	decimal	13	3	QUAN	((0))	Yes		OIH_FOLQTY
134	OICERTF1_GI	Excise Tax External License Number Used During GI (STO)	nvarchar	15	0	CHAR	(N' ')	Yes		OIH_CERTF1_GI	Allow NULL?
135	OIDATFM1_GI	Excise Duty License Valid from Date for Mat. (STO)	nvarchar	8	0	DATS	(N'00000000')	Yes		OIH_DATFM1_GI	Allow NULL?
136	OIDATTO1_GI	Valid To Date for Excise Duty Tax Certificate for Mat. (STO)	nvarchar	8	0	DATS	(N'00000000')	Yes		OIH_DATTO1_GI	Allow NULL?
137	OIH_LICTP_GI	License Type to Material (STO)	nvarchar	4	0	CHAR	(N' ')	Yes	OIH20	OIH_LICTP_GI	Allow NULL?
138	OIH_LICIN_GI	Excise Tax Internal License Number to Mat. (STO)	nvarchar	10	0	CHAR	(N' ')	Yes	OIHL	OIH_LICIN_GI	Allow NULL?
139	OIH_LCFOL_GI	Follow-On License for Quantity License to Mat. (STO)	nvarchar	10	0	CHAR	(N' ')	Yes	OIHL	OIH_LCFOL_GI	Allow NULL?
140	OIH_FOLQTY_GI	Excise Tax Follow-On License Quantity to Mat. (STO)	decimal	13	3	QUAN	((0))	Yes		OIH_FOLQTY_GI
141	OIPIPEVAL	Validation indicator for pipeline fields (X=ON, blank=OFF)	char	1	0	CHAR	(N' ')	Yes		OID_PIPEV	Allow NULL?
142	OIC_LIFNR	Account Number of Vendor or Creditor	nvarchar	10	0	CHAR	(N' ')	Yes	LFA1	LIFNR	Allow NULL?
143	OIC_DCITYC	Destination city code	nvarchar	4	0	CHAR	(N' ')	Yes	T005G	OIC_DCITYC	Allow NULL?
144	OIC_DCOUNC	Destination county code	nvarchar	3	0	CHAR	(N' ')	Yes	T005E	OIC_DCOUNC	Allow NULL?
145	OIC_DREGIO	Destination region	nvarchar	3	0	CHAR	(N' ')	Yes	T005S	OIC_DREGIO	Allow NULL?
146	OIC_DLAND1	Destination country	nvarchar	3	0	CHAR	(N' ')	Yes	T005	OIC_DLAND1	Allow NULL?
147	OIC_OCITYC	Origin city code	nvarchar	4	0	CHAR	(N' ')	Yes	T005G	OIC_OCITYC	Allow NULL?
148	OIC_OCOUNC	Origin county code	nvarchar	3	0	CHAR	(N' ')	Yes	T005E	OIC_OCOUNC	Allow NULL?
149	OIC_OREGIO	Origin region	nvarchar	3	0	CHAR	(N' ')	Yes	T005S	OIC_OREGIO	Allow NULL?
150	OIC_OLAND1	Origin country	nvarchar	3	0	CHAR	(N' ')	Yes	T005	OIC_OLAND1	Allow NULL?
151	OIC_PORGIN	Tax origin	nvarchar	15	0	CHAR	(N' ')	Yes		OIC_PORGIN	Allow NULL?
152	OIC_PDESTN	Tax destination	nvarchar	15	0	CHAR	(N' ')	Yes		OIC_PDESTN	Allow NULL?
153	OIC_PTRIP	Pipeline trip number (external)	nvarchar	16	0	CHAR	(N' ')	Yes		OIC_PTRIP	Allow NULL?
154	OIC_PBATCH	Pipeline operator´s external batch number	nvarchar	16	0	CHAR	(N' ')	Yes		OIC_PBATCH	Allow NULL?
155	OIC_MOT	IS-OIL MAP external details mode of transport	nvarchar	2	0	CHAR	(N' ')	Yes	TVTR	OIC_MOT	Allow NULL?
156	OIC_AORGIN	Alternate origin	nvarchar	15	0	CHAR	(N' ')	Yes		OIC_AORGIN	Allow NULL?
157	OIC_ADESTN	Alternate destination	nvarchar	15	0	CHAR	(N' ')	Yes		OIC_ADESTN	Allow NULL?
158	OIC_TRUCKN	Truck number	nvarchar	10	0	CHAR	(N' ')	Yes		OIC_TRUCKN	Allow NULL?
159	OIA_BASELO	Base location	nvarchar	15	0	CHAR	(N' ')	Yes		OIA_BASELO	Allow NULL?
160	OIEDOK	Excise duty validation indicator	char	1	0	CHAR	(N' ')	Yes		OIH_EDOK	Allow NULL?
161	OIEDOK_GI	Excise Duty Validation Indicator for Material (STO)	char	1	0	CHAR	(N' ')	Yes		OIH_EDOK_GI	Allow NULL?
162	OIEDBAL_GI	Excise Duty Balancing is Required for Mat. (STO)	char	1	0	CHAR	(N' ')	Yes		OIH_EDBAL_GI	Allow NULL?
163	OIEDBALM_GI	Excise Duty Balancing Method Indicator for Mat. (STO)	char	1	0	CHAR	(N' ')	Yes		OIH_EDBALM_GI	Allow NULL?
164	OIHANTYP_GI	Excise Duty Handling Type - Denotes Use of Material	nvarchar	2	0	CHAR	(N' ')	Yes	OIH5	OIH_HANTYP_GI	Allow NULL?
165	OIINEX_GI	Code for Internal or External Excise Duty Rate Determination	nvarchar	2	0	CHAR	(N' ')	Yes	OIH16	OIH_INEX_GI	Allow NULL?
166	OITAXGRP_GI	Excise Duty Group	nvarchar	2	0	CHAR	(N' ')	Yes	OIH2	OIH_TAXGRP	Allow NULL?
167	OITAXFROM_GI	Excise duty tax key for 'from' location	nvarchar	2	0	CHAR	(N' ')	Yes	OIH4	OIH_TAXFRO	Allow NULL?
168	OITAXTO_GI	Excise duty tax key for 'to' location	nvarchar	2	0	CHAR	(N' ')	Yes	OIH4	OIH_TAXTO	Allow NULL?
169	BWTAR_INTRANSIT	Valuation Type in Transit	nvarchar	10	0	CHAR	(N' ')	Yes	T149D	OIH_VALTYP_TRAN	Allow NULL?
170	HT_GL	Excise Duty Handling Type Gain/Loss	nvarchar	2	0	CHAR	(N' ')	Yes	OIH5	OIH_HANTYP_GL	Allow NULL?
171	HT_LOAD	Excise Duty Handling Type at Load	nvarchar	2	0	CHAR	(N' ')	Yes	OIH5	OIH_HANTYP_LD	Allow NULL?
172	HT_DIS	Excise Duty Handling Type at Discharge	nvarchar	2	0	CHAR	(N' ')	Yes	OIH5	OIH_HANTYP_DS	Allow NULL?
173	LICIN_NUM	Excise tax internal license number	nvarchar	10	0	CHAR	(N' ')	Yes	*	OIH_LICIN	Allow NULL?
174	LICEXT_NUM	Excise tax external license number	nvarchar	15	0	CHAR	(N' ')	Yes		OIH_CERTF1	Allow NULL?
175	OIH_DISTLIC	Distributor License	char	1	0	CHAR	(N' ')	Yes		OIH_DISTLIC	Allow NULL?
176	SHIP_FROM	Ship From	nvarchar	10	0	CHAR	(N' ')	Yes	LFA1	OIH_SHIP_FROM	Allow NULL?
177	DUTY_TO	Duty To	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	OIH_DUTYTO	Allow NULL?

TOP ERP 6.0 | OIJNOMI INDEXES

Name	Primary	Unique	Type	Columns
OIJNOMI~0	Yes	Yes	CLUSTERED	NOMIT, NOMTK, MANDT
OIJNOMI~DOC	No	No	NONCLUSTERED	DOCITM, DOCIND, DOCNR, MANDT
OIJNOMI~RD1	No	No	NONCLUSTERED	IDATE, LOCID, S_MATNR_I, MANDT

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

177 COLUMNS | 3 INDEXES | ERP 6.0 | OIJNOMI TABLE

TOP ERP 6.0 | OIJNOMI COLUMNS

TOP ERP 6.0 | OIJNOMI INDEXES

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

177 COLUMNS | 3 INDEXES | ERP 6.0 | OIJNOMI TABLE

TOPERP 6.0 | OIJNOMI COLUMNS

TOPERP 6.0 | OIJNOMI INDEXES

TOP ERP 6.0 | OIJNOMI COLUMNS

TOP ERP 6.0 | OIJNOMI INDEXES