	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	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
10	FMARCPAR	4	Parallelization of FMARC_BATCH

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

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

266 COLUMNS | 3 INDEXES | ERP 6.0 | OIUH_RV_JE TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Industry Specific :: Industry Solution Oil :: Production and Revenue Accounting :: Revenue
1	ERP EHP7	6.0	OIUH_RV_JE	266	3	Journal Entry	Revenue

SQL: selectupdate insert create

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

SELECT MANDT, JE_OR_LVL_1_NO, JE_ACCT_PERD_DT, JE_BTCH_NO, JE_LE_NO, JE_VOU_NO, JE_REJ_FL, JE_ACCT_CAT_CD, JE_BRD_CD, JE_ACCT_NO, JE_BTCH_TYPE_CD, E_LE_PRCS_ST_CD, JE_TRANS_AM, JE_SYS_SRCE_CD, JE_TRANS_QY, JE_GR_AM, JE_GR_QY, JE_PD_CD, JE_VL_TYPE_CD, JE_CK_NO, JE_VL_CLASS_CD, JE_VL_SRCE_CD, JE_VL_FRQ_CD, JE_VL_LVL_CD, JE_BTU_QY, JE_MMBTU_DET_CD, JE_PS_BASE_QY, JE_GRV_QY, JE_OWN_NO9, JE_OWN_NO, JE_OWN_SEQ_NO9, JE_OWN_SEQ_NO, JE_PU_NO9, JE_PU_NO, JE_PU_SEQ_NO9, JE_PU_SEQ_NO, JE_PRDR_NO9, JE_PRDR_NO, JE_PRDR_SEQ_NO9, JE_PRDR_SEQ_NO, OWN_INT_DECM_QY, OWN_INT_TYPE_CD, JE_CK_DT9, JE_CK_DT, JE_RVRS_RSN_CD, UNIT_OF_MEAS_CD, JE_CASH_RCPT_DT9, JE_CASH_RCPT_DT, JE_SUS_RSN_CD, JE_CT_NO9, JE_CT_NO, JE_CT_TYPE_CD, JE_DOI_PR_NO9, JE_DOI_PR_NO, JE_DOI_SEQ_NO9, JE_DOI_SEQ_NO, JE_TRACE_CO_NO, E_TRACE_APRD_DT9, E_TRACE_APRD_DT, E_TRACE_ACCT_NO, E_TRACE_BTCH_NO, E_TRACE_BTCH_CD, E_TRACE_VOUC_NO, JE_TRACE_LE_NO, JE_WL_NO9, JE_WL_NO, JE_WC_NO9, JE_WC_NO, JE_DED_RMB_AM, E_DED_GR_RMB_AM, JE_TAX_1_AM, JE_TAX_2_AM, JE_TAX_3_AM, JE_TAX_4_AM, JE_TAX_5_AM, JE_TAX_6_AM, JE_TAX_7_AM, JE_TAX_8_AM, JE_TAX_9_AM, JE_TAX_10_AM, JE_TAX_RMB_AM, E_TAX_GR_RMB_AM, JE_INV_NO, JE_INV_DT9, JE_INV_DT, JE_INV_TYPE_CD, OWN_INT_SEQ_NO, JE_PAY_CD, JE_SA_MP_NO9, JE_SA_MP_NO, JE_SA_DT9, JE_SA_DT, JE_ST_CD, JE_TAX_AUTH_NO, TAX_AUTH_SEQ_NO, OWN_BAL_DECM_QY, JE_PR_TYPE_CD, JE_OP_NON_OP_FL, JE_PU_PR_NO, JE_PU_PD_CD, JE_ERROR_1_CD, JE_ERROR_2_CD, JE_ERROR_3_CD, JE_ERROR_4_CD, JE_ERROR_5_CD, JE_UNIT_PR_NO9, JE_UNIT_PR_NO, E_ARMT_LVL_1_CD, E_ARMT_LVL_2_CD, JE_TRANS_DE9, JE_TRANS_DE, JE_GR_TAX_AM, JE_PROC_CO, JE_AES_FL, JE_TAX_CD, JE_GRP_GROUP_NO9, JE_GRP_GROUP_NO, JE_JIB_DOI_NO9, JE_JIB_DOI_NO, JIB_DOI_SEQ_NO9, JIB_DOI_SEQ_NO, JE_BILL_CD, JE_TXN_VAL_AM, JE_TXN_DT, JE_GAS_PLANT_NO9, JE_GAS_PLANT_NO, JE_GPLT_SEQ_NO9, JE_GPLT_SEQ_NO, JE_REF_NO, JE_SELLER_NO9, JE_SELLER_NO, E_SELLER_SEQ_NO9, E_SELLER_SEQ_NO, JE_AUD_BTCH_NO, JE_DI_PR_NO, JE_DI_NO, JE_JDI_PR_NO, JE_JDI_NO, JE_OWN_PVR_AM, JE_GR_PVR_AM, E_OTH_DED_01_AM, E_OTH_DED_02_AM, E_OTH_DED_03_AM, E_OTH_DED_04_AM, E_OTH_DED_05_AM, E_OTH_DED_06_AM, E_OTH_DED_07_AM, E_OTH_DED_08_AM, E_OTH_DED_09_AM, E_OTH_DED_10_AM, E_OTH_DED_11_AM, E_OTH_DED_12_AM, E_OTH_DED_13_AM, E_OTH_DED_14_AM, E_OTH_DED_15_AM, E_OTH_DED_16_AM, E_OTH_DED_17_AM, E_OTH_DED_18_AM, JE_INT_PAID_FL, MMBTU_OWN_VL_AM, MMBTU_GR_VL_AM, JE_REMT_NO9, JE_REMT_NO, JE_REMT_SEQ_NO9, JE_REMT_SEQ_NO, JE_RCV_GLWL_NO9, JE_RCV_GLWL_NO, JE_RCV_GLWC_NO9, JE_RCV_GLWC_NO, JE_REL_CT_NO9, JE_REL_CT_NO, JE_ORIG_MP_NO9, JE_ORIG_MP_NO, E_ORIG_MP_TP_CD, JE_PHS_NO, JE_CMT_SYS_NO9, JE_CMT_SYS_NO, JE_ESCH_FL, JE_INT_SYM_CD, JE_LGND_CD, JE_MK_TYPE_NO, JE_OR_LVL_2_NO, E_SPEC_PYMNT_CD, JE_OVRD_OWN_CD, JE_RCPTN_PT_NO, JE_TRNSP_NO, JE_TRNSP_SEQ_NO, JE_OWN_VAL, JE_RBUR_DECM_PC, JE_GR_TAX_1_AM, JE_GR_TAX_2_AM, JE_GR_TAX_3_AM, JE_GR_TAX_4_AM, JE_GR_TAX_5_AM, JE_GR_TAX_6_AM, JE_GR_TAX_7_AM, JE_GR_TAX_8_AM, JE_GR_TAX_9_AM, JE_GR_TAX_10_AM, JE_GR_TRNDED_AM, E_OWN_TRNDED_AM, E_GR_OTH_MKD_AM, OWN_OTH_MKD_AM, JE_ORIG_PR_NO, JE_INJ_DT9, JE_INJ_DT, E_GR_APC_RMB_AM, NET_APC_RMB_AM, JE_JI_OWN_NO, E_JI_OWN_SEQ_NO, JE_SECT_PR_NO9, JE_SECT_PR_NO, JE_SECT_SEQ_NO9, JE_SECT_SEQ_NO, JE_NWK_NO9, JE_NWK_NO, JE_SUB_NWK_NO9, JE_SUB_NWK_NO, JE_CHV_RPT_CD, E_CUSA_TRSPK_NO, JE_DEAL_I_NO, JE_VER_NO, JE_USER_ID, JE_TIMESTAMP, JE_GR_PTR_AM, JE_OWN_PTR_AM, O_INT_1_AM, O_INT_2_AM, O_INT_3_AM, O_INT_4_AM, O_INT_5_AM, O_INT_6_AM, O_INT_7_AM, O_INT_8_AM, O_INT_9_AM, O_INT_10_AM, O_EXT_1_AM, O_EXT_2_AM, O_EXT_3_AM, O_EXT_4_AM, O_EXT_5_AM, O_EXT_6_AM, O_EXT_7_AM, O_EXT_8_AM, O_EXT_9_AM, O_EXT_10_AM, G_INT_1_AM, G_INT_2_AM, G_INT_3_AM, G_INT_4_AM, G_INT_5_AM, G_INT_6_AM, G_INT_7_AM, G_INT_8_AM, G_INT_9_AM, G_INT_10_AM, G_EXT_1_AM, G_EXT_2_AM, G_EXT_3_AM, G_EXT_4_AM, G_EXT_5_AM, G_EXT_6_AM, G_EXT_7_AM, G_EXT_8_AM, G_EXT_9_AM, G_EXT_10_AM FROM OIUH_RV_JE

TOP ERP 6.0 | OIUH_RV_JE COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	JE_OR_LVL_1_NO	Company Name Code	nvarchar	3	0	Allow NULL?
3	JE_ACCT_PERD_DT	Accounting Period(YYYYMM01)	nvarchar	8	0	Allow NULL?
4	JE_BTCH_NO	Batch ID	nvarchar	4	0	Allow NULL?
5	JE_LE_NO	Journal Entry Line Number	nvarchar	8	0	Allow NULL?
6	JE_VOU_NO	OIUH_CHAR6	nvarchar	6	0	Allow NULL?
7	JE_REJ_FL	OIUH_CHAR1	char	1	0	Allow NULL?
8	JE_ACCT_CAT_CD	OIUH_CHAR4	nvarchar	4	0	Allow NULL?
9	JE_BRD_CD	OIUH_CHAR4	nvarchar	4	0	Allow NULL?
10	JE_ACCT_NO	OIUH_CHAR10	nvarchar	10	0	Allow NULL?
11	JE_BTCH_TYPE_CD	OIUH_CHAR2	nvarchar	2	0	Allow NULL?
12	E_LE_PRCS_ST_CD	OIUH_CHAR1	char	1	0	Allow NULL?
13	JE_TRANS_AM	Local amount	decimal	11	2
14	JE_SYS_SRCE_CD	OIUH_CHAR2	nvarchar	2	0	Allow NULL?
15	JE_TRANS_QY	OIUH_DEC11_2	decimal	11	2
16	JE_GR_AM	Local amount	decimal	11	2
17	JE_GR_QY	OIUH_DEC11_2	decimal	11	2
18	JE_PD_CD	OIUH_CHAR3	nvarchar	3	0	Allow NULL?
19	JE_VL_TYPE_CD	Volume Type Code	nvarchar	2	0	Allow NULL?
20	JE_CK_NO	OIUH_CHAR10	nvarchar	10	0	Allow NULL?
21	JE_VL_CLASS_CD	OIUH_CHAR1	char	1	0	Allow NULL?
22	JE_VL_SRCE_CD	OIUH_CHAR1	char	1	0	Allow NULL?
23	JE_VL_FRQ_CD	OIUH_CHAR1	char	1	0	Allow NULL?
24	JE_VL_LVL_CD	OIUH_CHAR2	nvarchar	2	0	Allow NULL?
25	JE_BTU_QY	OIUH_DEC7_3	decimal	7	3
26	JE_MMBTU_DET_CD	OIUH_CHAR1	char	1	0	Allow NULL?
27	JE_PS_BASE_QY	OIUH_DEC6_3	decimal	6	3
28	JE_GRV_QY	OIUH_DEC3_1	decimal	3	1
29	JE_OWN_NO9	OIUH_CHAR1	char	1	0	Allow NULL?
30	JE_OWN_NO	OIUH_CHAR6	nvarchar	6	0	Allow NULL?
31	JE_OWN_SEQ_NO9	OIUH_CHAR1	char	1	0	Allow NULL?
32	JE_OWN_SEQ_NO	OIUH_CHAR2	nvarchar	2	0	Allow NULL?
33	JE_PU_NO9	OIUH_CHAR1	char	1	0	Allow NULL?
34	JE_PU_NO	OIUH_CHAR6	nvarchar	6	0	Allow NULL?
35	JE_PU_SEQ_NO9	OIUH_CHAR1	char	1	0	Allow NULL?
36	JE_PU_SEQ_NO	OIUH_CHAR2	nvarchar	2	0	Allow NULL?
37	JE_PRDR_NO9	OIUH_CHAR1	char	1	0	Allow NULL?
38	JE_PRDR_NO	OIUH_CHAR6	nvarchar	6	0	Allow NULL?
39	JE_PRDR_SEQ_NO9	OIUH_CHAR1	char	1	0	Allow NULL?
40	JE_PRDR_SEQ_NO	OIUH_CHAR2	nvarchar	2	0	Allow NULL?
41	OWN_INT_DECM_QY	OIUH_DEC9_8	decimal	9	8
42	OWN_INT_TYPE_CD	OIUH_CHAR2	nvarchar	2	0	Allow NULL?
43	JE_CK_DT9	OIUH_CHAR1	char	1	0	Allow NULL?
44	JE_CK_DT	OIUH_CHAR14	nvarchar	14	0	Allow NULL?
45	JE_RVRS_RSN_CD	OIUH_CHAR2	nvarchar	2	0	Allow NULL?
46	UNIT_OF_MEAS_CD	OIUH_CHAR3	nvarchar	3	0	Allow NULL?
47	JE_CASH_RCPT_DT9	OIUH_CHAR1	char	1	0	Allow NULL?
48	JE_CASH_RCPT_DT	OIUH_CHAR14	nvarchar	14	0	Allow NULL?
49	JE_SUS_RSN_CD	OIUH_CHAR2	nvarchar	2	0	Allow NULL?
50	JE_CT_NO9	OIUH_CHAR1	char	1	0	Allow NULL?
51	JE_CT_NO	Contract ID	nvarchar	6	0	Allow NULL?
52	JE_CT_TYPE_CD	OIUH_CHAR2	nvarchar	2	0	Allow NULL?
53	JE_DOI_PR_NO9	OIUH_CHAR1	char	1	0	Allow NULL?
54	JE_DOI_PR_NO	OIUH_CHAR8	nvarchar	8	0	Allow NULL?
55	JE_DOI_SEQ_NO9	OIUH_CHAR1	char	1	0	Allow NULL?
56	JE_DOI_SEQ_NO	OIUH_CHAR5	nvarchar	5	0	Allow NULL?
57	JE_TRACE_CO_NO	OIUH_CHAR3	nvarchar	3	0	Allow NULL?
58	E_TRACE_APRD_DT9	OIUH_CHAR1	char	1	0	Allow NULL?
59	E_TRACE_APRD_DT	Accounting Period(YYYYMM01)	nvarchar	8	0	Allow NULL?
60	E_TRACE_ACCT_NO	OIUH_CHAR10	nvarchar	10	0	Allow NULL?
61	E_TRACE_BTCH_NO	OIUH_CHAR4	nvarchar	4	0	Allow NULL?
62	E_TRACE_BTCH_CD	OIUH_CHAR2	nvarchar	2	0	Allow NULL?
63	E_TRACE_VOUC_NO	OIUH_CHAR6	nvarchar	6	0	Allow NULL?
64	JE_TRACE_LE_NO	OIUH_CHAR8	nvarchar	8	0	Allow NULL?
65	JE_WL_NO9	OIUH_CHAR1	char	1	0	Allow NULL?
66	JE_WL_NO	OIUH_CHAR6	nvarchar	6	0	Allow NULL?
67	JE_WC_NO9	OIUH_CHAR1	char	1	0	Allow NULL?
68	JE_WC_NO	OIUH_CHAR2	nvarchar	2	0	Allow NULL?
69	JE_DED_RMB_AM	Local amount	decimal	11	2
70	E_DED_GR_RMB_AM	Local amount	decimal	11	2
71	JE_TAX_1_AM	Local amount	decimal	11	2
72	JE_TAX_2_AM	Local amount	decimal	11	2
73	JE_TAX_3_AM	Local amount	decimal	11	2
74	JE_TAX_4_AM	Local amount	decimal	11	2
75	JE_TAX_5_AM	Local amount	decimal	11	2
76	JE_TAX_6_AM	Local amount	decimal	11	2
77	JE_TAX_7_AM	Local amount	decimal	11	2
78	JE_TAX_8_AM	Local amount	decimal	11	2
79	JE_TAX_9_AM	Local amount	decimal	11	2
80	JE_TAX_10_AM	Local amount	decimal	11	2
81	JE_TAX_RMB_AM	Local amount	decimal	11	2
82	E_TAX_GR_RMB_AM	Local amount	decimal	11	2
83	JE_INV_NO	OIUH_CHAR6	nvarchar	6	0	Allow NULL?
84	JE_INV_DT9	OIUH_CHAR1	char	1	0	Allow NULL?
85	JE_INV_DT	OIUH_CHAR14	nvarchar	14	0	Allow NULL?
86	JE_INV_TYPE_CD	OIUH_CHAR2	nvarchar	2	0	Allow NULL?
87	OWN_INT_SEQ_NO	OIUH_CHAR2	nvarchar	2	0	Allow NULL?
88	JE_PAY_CD	OIUH_CHAR2	nvarchar	2	0	Allow NULL?
89	JE_SA_MP_NO9	OIUH_CHAR1	char	1	0	Allow NULL?
90	JE_SA_MP_NO	OIUH_CHAR6	nvarchar	6	0	Allow NULL?
91	JE_SA_DT9	OIUH_CHAR1	char	1	0	Allow NULL?
92	JE_SA_DT	OIUH_CHAR14	nvarchar	14	0	Allow NULL?
93	JE_ST_CD	OIUH_CHAR2	nvarchar	2	0	Allow NULL?
94	JE_TAX_AUTH_NO	OIUH_CHAR6	nvarchar	6	0	Allow NULL?
95	TAX_AUTH_SEQ_NO	OIUH_CHAR2	nvarchar	2	0	Allow NULL?
96	OWN_BAL_DECM_QY	OIUH_DEC9_8	decimal	9	8
97	JE_PR_TYPE_CD	OIUH_CHAR2	nvarchar	2	0	Allow NULL?
98	JE_OP_NON_OP_FL	OIUH_CHAR1	char	1	0	Allow NULL?
99	JE_PU_PR_NO	OIUH_CHAR18	nvarchar	18	0	Allow NULL?
100	JE_PU_PD_CD	OIUH_CHAR3	nvarchar	3	0	Allow NULL?
101	JE_ERROR_1_CD	OIUH_CHAR5	nvarchar	5	0	Allow NULL?
102	JE_ERROR_2_CD	OIUH_CHAR5	nvarchar	5	0	Allow NULL?
103	JE_ERROR_3_CD	OIUH_CHAR5	nvarchar	5	0	Allow NULL?
104	JE_ERROR_4_CD	OIUH_CHAR5	nvarchar	5	0	Allow NULL?
105	JE_ERROR_5_CD	OIUH_CHAR5	nvarchar	5	0	Allow NULL?
106	JE_UNIT_PR_NO9	OIUH_CHAR1	char	1	0	Allow NULL?
107	JE_UNIT_PR_NO	OIUH_CHAR8	nvarchar	8	0	Allow NULL?
108	E_ARMT_LVL_1_CD	OIUH_CHAR8	nvarchar	8	0	Allow NULL?
109	E_ARMT_LVL_2_CD	OIUH_CHAR5	nvarchar	5	0	Allow NULL?
110	JE_TRANS_DE9	OIUH_CHAR1	char	1	0	Allow NULL?
111	JE_TRANS_DE	OIUH_CHAR60	nvarchar	60	0	Allow NULL?
112	JE_GR_TAX_AM	Local amount	decimal	11	2
113	JE_PROC_CO	OIUH_CHAR3	nvarchar	3	0	Allow NULL?
114	JE_AES_FL	OIUH_CHAR1	char	1	0	Allow NULL?
115	JE_TAX_CD	OIUH_CHAR2	nvarchar	2	0	Allow NULL?
116	JE_GRP_GROUP_NO9	OIUH_CHAR1	char	1	0	Allow NULL?
117	JE_GRP_GROUP_NO	OIUH_CHAR8	nvarchar	8	0	Allow NULL?
118	JE_JIB_DOI_NO9	OIUH_CHAR1	char	1	0	Allow NULL?
119	JE_JIB_DOI_NO	OIUH_CHAR8	nvarchar	8	0	Allow NULL?
120	JIB_DOI_SEQ_NO9	OIUH_CHAR1	char	1	0	Allow NULL?
121	JIB_DOI_SEQ_NO	OIUH_CHAR5	nvarchar	5	0	Allow NULL?
122	JE_BILL_CD	OIUH_CHAR2	nvarchar	2	0	Allow NULL?
123	JE_TXN_VAL_AM	Local amount	decimal	11	2
124	JE_TXN_DT	OIUH_CHAR14	nvarchar	14	0	Allow NULL?
125	JE_GAS_PLANT_NO9	OIUH_CHAR1	char	1	0	Allow NULL?
126	JE_GAS_PLANT_NO	OIUH_CHAR8	nvarchar	8	0	Allow NULL?
127	JE_GPLT_SEQ_NO9	OIUH_CHAR1	char	1	0	Allow NULL?
128	JE_GPLT_SEQ_NO	OIUH_CHAR5	nvarchar	5	0	Allow NULL?
129	JE_REF_NO	OIUH_CHAR10	nvarchar	10	0	Allow NULL?
130	JE_SELLER_NO9	OIUH_CHAR1	char	1	0	Allow NULL?
131	JE_SELLER_NO	OIUH_CHAR6	nvarchar	6	0	Allow NULL?
132	E_SELLER_SEQ_NO9	OIUH_CHAR1	char	1	0	Allow NULL?
133	E_SELLER_SEQ_NO	OIUH_CHAR2	nvarchar	2	0	Allow NULL?
134	JE_AUD_BTCH_NO	OIUH_CHAR4	nvarchar	4	0	Allow NULL?
135	JE_DI_PR_NO	OIUH_CHAR8	nvarchar	8	0	Allow NULL?
136	JE_DI_NO	OIUH_CHAR5	nvarchar	5	0	Allow NULL?
137	JE_JDI_PR_NO	OIUH_CHAR8	nvarchar	8	0	Allow NULL?
138	JE_JDI_NO	OIUH_CHAR5	nvarchar	5	0	Allow NULL?
139	JE_OWN_PVR_AM	OIUH_DEC11_2	decimal	11	2
140	JE_GR_PVR_AM	OIUH_DEC11_2	decimal	11	2
141	E_OTH_DED_01_AM	Local amount	decimal	11	2
142	E_OTH_DED_02_AM	Local amount	decimal	11	2
143	E_OTH_DED_03_AM	Local amount	decimal	11	2
144	E_OTH_DED_04_AM	Local amount	decimal	11	2
145	E_OTH_DED_05_AM	Local amount	decimal	11	2
146	E_OTH_DED_06_AM	Local amount	decimal	11	2
147	E_OTH_DED_07_AM	Local amount	decimal	11	2
148	E_OTH_DED_08_AM	Local amount	decimal	11	2
149	E_OTH_DED_09_AM	Local amount	decimal	11	2
150	E_OTH_DED_10_AM	Local amount	decimal	11	2
151	E_OTH_DED_11_AM	Local amount	decimal	11	2
152	E_OTH_DED_12_AM	Local amount	decimal	11	2
153	E_OTH_DED_13_AM	Local amount	decimal	11	2
154	E_OTH_DED_14_AM	Local amount	decimal	11	2
155	E_OTH_DED_15_AM	Local amount	decimal	11	2
156	E_OTH_DED_16_AM	Local amount	decimal	11	2
157	E_OTH_DED_17_AM	Local amount	decimal	11	2
158	E_OTH_DED_18_AM	Local amount	decimal	11	2
159	JE_INT_PAID_FL	OIUH_CHAR1	char	1	0	Allow NULL?
160	MMBTU_OWN_VL_AM	OIUH_DEC11_2	decimal	11	2
161	MMBTU_GR_VL_AM	OIUH_DEC11_2	decimal	11	2
162	JE_REMT_NO9	OIUH_CHAR1	char	1	0	Allow NULL?
163	JE_REMT_NO	OIUH_CHAR6	nvarchar	6	0	Allow NULL?
164	JE_REMT_SEQ_NO9	OIUH_CHAR1	char	1	0	Allow NULL?
165	JE_REMT_SEQ_NO	OIUH_CHAR2	nvarchar	2	0	Allow NULL?
166	JE_RCV_GLWL_NO9	OIUH_CHAR1	char	1	0	Allow NULL?
167	JE_RCV_GLWL_NO	OIUH_CHAR6	nvarchar	6	0	Allow NULL?
168	JE_RCV_GLWC_NO9	OIUH_CHAR1	char	1	0	Allow NULL?
169	JE_RCV_GLWC_NO	OIUH_CHAR2	nvarchar	2	0	Allow NULL?
170	JE_REL_CT_NO9	OIUH_CHAR1	char	1	0	Allow NULL?
171	JE_REL_CT_NO	Contract ID	nvarchar	6	0	Allow NULL?
172	JE_ORIG_MP_NO9	OIUH_CHAR1	char	1	0	Allow NULL?
173	JE_ORIG_MP_NO	OIUH_CHAR6	nvarchar	6	0	Allow NULL?
174	E_ORIG_MP_TP_CD	OIUH_CHAR2	nvarchar	2	0	Allow NULL?
175	JE_PHS_NO	OIUH_CHAR1	char	1	0	Allow NULL?
176	JE_CMT_SYS_NO9	OIUH_CHAR1	char	1	0	Allow NULL?
177	JE_CMT_SYS_NO	OIUH_DEC18	decimal	18	0
178	JE_ESCH_FL	OIUH_CHAR1	char	1	0	Allow NULL?
179	JE_INT_SYM_CD	OIUH_CHAR2	nvarchar	2	0	Allow NULL?
180	JE_LGND_CD	OIUH_CHAR2	nvarchar	2	0	Allow NULL?
181	JE_MK_TYPE_NO	OIUH_CHAR2	nvarchar	2	0	Allow NULL?
182	JE_OR_LVL_2_NO	OIUH_CHAR1	char	1	0	Allow NULL?
183	E_SPEC_PYMNT_CD	OIUH_CHAR1	char	1	0	Allow NULL?
184	JE_OVRD_OWN_CD	OIUH_CHAR2	nvarchar	2	0	Allow NULL?
185	JE_RCPTN_PT_NO	OIUH_CHAR6	nvarchar	6	0	Allow NULL?
186	JE_TRNSP_NO	OIUH_CHAR6	nvarchar	6	0	Allow NULL?
187	JE_TRNSP_SEQ_NO	OIUH_CHAR2	nvarchar	2	0	Allow NULL?
188	JE_OWN_VAL	Local amount	decimal	11	2
189	JE_RBUR_DECM_PC	OIUH_DEC9_8	decimal	9	8
190	JE_GR_TAX_1_AM	Local amount	decimal	13	2
191	JE_GR_TAX_2_AM	Local amount	decimal	13	2
192	JE_GR_TAX_3_AM	Local amount	decimal	13	2
193	JE_GR_TAX_4_AM	Local amount	decimal	13	2
194	JE_GR_TAX_5_AM	Local amount	decimal	13	2
195	JE_GR_TAX_6_AM	Local amount	decimal	13	2
196	JE_GR_TAX_7_AM	Local amount	decimal	13	2
197	JE_GR_TAX_8_AM	Local amount	decimal	13	2
198	JE_GR_TAX_9_AM	Local amount	decimal	13	2
199	JE_GR_TAX_10_AM	Local amount	decimal	13	2
200	JE_GR_TRNDED_AM	Local amount	decimal	11	2
201	E_OWN_TRNDED_AM	Local amount	decimal	11	2
202	E_GR_OTH_MKD_AM	Local amount	decimal	11	2
203	OWN_OTH_MKD_AM	Local amount	decimal	11	2
204	JE_ORIG_PR_NO	OIUH_CHAR8	nvarchar	8	0	Allow NULL?
205	JE_INJ_DT9	OIUH_CHAR1	char	1	0	Allow NULL?
206	JE_INJ_DT	OIUH_CHAR14	nvarchar	14	0	Allow NULL?
207	E_GR_APC_RMB_AM	Local amount	decimal	11	2
208	NET_APC_RMB_AM	Local amount	decimal	11	2
209	JE_JI_OWN_NO	OIUH_CHAR6	nvarchar	6	0	Allow NULL?
210	E_JI_OWN_SEQ_NO	OIUH_CHAR2	nvarchar	2	0	Allow NULL?
211	JE_SECT_PR_NO9	OIUH_CHAR1	char	1	0	Allow NULL?
212	JE_SECT_PR_NO	OIUH_CHAR8	nvarchar	8	0	Allow NULL?
213	JE_SECT_SEQ_NO9	OIUH_CHAR1	char	1	0	Allow NULL?
214	JE_SECT_SEQ_NO	OIUH_CHAR5	nvarchar	5	0	Allow NULL?
215	JE_NWK_NO9	OIUH_CHAR1	char	1	0	Allow NULL?
216	JE_NWK_NO	OIUH_CHAR4	nvarchar	4	0	Allow NULL?
217	JE_SUB_NWK_NO9	OIUH_CHAR1	char	1	0	Allow NULL?
218	JE_SUB_NWK_NO	OIUH_CHAR4	nvarchar	4	0	Allow NULL?
219	JE_CHV_RPT_CD	OIUH_CHAR10	nvarchar	10	0	Allow NULL?
220	E_CUSA_TRSPK_NO	OIUH_CHAR8	nvarchar	8	0	Allow NULL?
221	JE_DEAL_I_NO	OIUH_CHAR12	nvarchar	12	0	Allow NULL?
222	JE_VER_NO	OIUH_DEC5	decimal	5	0
223	JE_USER_ID	OIUH_CHAR8	nvarchar	8	0	Allow NULL?
224	JE_TIMESTAMP	OIUH_CHAR14	nvarchar	14	0	Allow NULL?
225	JE_GR_PTR_AM	Gross Plant Thermal Reduction amount	decimal	11	2
226	JE_OWN_PTR_AM	Owner Plant Thermal Reduction amount	decimal	11	2
227	O_INT_1_AM	Owner internal mkt amt 1	decimal	11	2
228	O_INT_2_AM	Owner internal mkt amt 2	decimal	11	2
229	O_INT_3_AM	Owner internal mkt amt 3	decimal	11	2
230	O_INT_4_AM	Owner internal mkt amt 4	decimal	11	2
231	O_INT_5_AM	Owner internal mkt amt 5	decimal	11	2
232	O_INT_6_AM	Owner internal mkt amt 6	decimal	11	2
233	O_INT_7_AM	Owner internal mkt amt 7	decimal	11	2
234	O_INT_8_AM	Owner internal mkt amt 8	decimal	11	2
235	O_INT_9_AM	Owner internal mkt amt 9	decimal	11	2
236	O_INT_10_AM	Owner internal mkt amt10	decimal	11	2
237	O_EXT_1_AM	Owner external mkt amt 1	decimal	11	2
238	O_EXT_2_AM	Owner external mkt amt 2	decimal	11	2
239	O_EXT_3_AM	Owner external mkt amt 3	decimal	11	2
240	O_EXT_4_AM	Owner external mkt amt 4	decimal	11	2
241	O_EXT_5_AM	Owner external mkt amt 5	decimal	11	2
242	O_EXT_6_AM	Owner external mkt amt 6	decimal	11	2
243	O_EXT_7_AM	Owner external mkt amt 7	decimal	11	2
244	O_EXT_8_AM	Owner external mkt amt 8	decimal	11	2
245	O_EXT_9_AM	Owner external mkt amt 9	decimal	11	2
246	O_EXT_10_AM	Owner external mkt amt10	decimal	11	2
247	G_INT_1_AM	Gross internal mkt amt 1	decimal	11	2
248	G_INT_2_AM	Gross internal mkt amt 2	decimal	11	2
249	G_INT_3_AM	Gross internal mkt amt 3	decimal	11	2
250	G_INT_4_AM	Gross internal mkt amt 4	decimal	11	2
251	G_INT_5_AM	Gross internal mkt amt 5	decimal	11	2
252	G_INT_6_AM	Gross internal mkt amt 6	decimal	11	2
253	G_INT_7_AM	Gross internal mkt amt 7	decimal	11	2
254	G_INT_8_AM	Gross internal mkt amt 8	decimal	11	2
255	G_INT_9_AM	Gross internal mkt amt 9	decimal	11	2
256	G_INT_10_AM	Gross internal mkt amt10	decimal	11	2
257	G_EXT_1_AM	Gross external mkt amt 1	decimal	11	2
258	G_EXT_2_AM	Gross external mkt amt 2	decimal	11	2
259	G_EXT_3_AM	Gross external mkt amt 3	decimal	11	2
260	G_EXT_4_AM	Gross external mkt amt 4	decimal	11	2
261	G_EXT_5_AM	Gross external mkt amt 5	decimal	11	2
262	G_EXT_6_AM	Gross external mkt amt 6	decimal	11	2
263	G_EXT_7_AM	Gross external mkt amt 7	decimal	11	2
264	G_EXT_8_AM	Gross external mkt amt 8	decimal	11	2
265	G_EXT_9_AM	Gross external mkt amt 9	decimal	11	2
266	G_EXT_10_AM	Gross external mkt amt 10	decimal	11	2

TOP ERP 6.0 | OIUH_RV_JE INDEXES

Name	Primary	Unique	Type	Columns
OIUH_RV_JE~0	Yes	Yes	CLUSTERED	JE_LE_NO, JE_BTCH_NO, JE_ACCT_PERD_DT, JE_OR_LVL_1_NO, MANDT
OIUH_RV_JE~I02	No	No	NONCLUSTERED	JE_SA_DT, JE_SA_MP_NO, JE_WC_NO, JE_WL_NO, JE_DOI_SEQ_NO, JE_DOI_PR_NO, MANDT
OIUH_RV_JE~I03	No	No	NONCLUSTERED	JE_PD_CD, JE_DOI_SEQ_NO, JE_DOI_PR_NO, JE_ACCT_CAT_CD, JE_ACCT_NO, 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

266 COLUMNS | 3 INDEXES | ERP 6.0 | OIUH_RV_JE TABLE

TOP ERP 6.0 | OIUH_RV_JE COLUMNS

TOP ERP 6.0 | OIUH_RV_JE 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

266 COLUMNS | 3 INDEXES | ERP 6.0 | OIUH_RV_JE TABLE

TOPERP 6.0 | OIUH_RV_JE COLUMNS

TOPERP 6.0 | OIUH_RV_JE INDEXES

TOP ERP 6.0 | OIUH_RV_JE COLUMNS

TOP ERP 6.0 | OIUH_RV_JE INDEXES