	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

222 COLUMNS | 1 INDEXES | ERP 6.0 | OIUPH_RV_RJE TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Industry Specific :: Industry Solution Oil :: Production and Revenue Accounting
1	ERP EHP7	6.0	OIUPH_RV_RJE	222	1	Journal Entry (PDM Shadow)	Production and Revenue Accounting

SQL: selectupdate insert create

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

SELECT MANDT, PDM_GUID, DUMMY_SEQ_FIELD, RJE_OR_LVL_1_NO, JE_ACCT_PERD_DT, RJE_ACCT_CAT_CD, RJE_BTCH_NO, RJE_BRD_CD, RJE_VOU_NO, RJE_LE_NO, RJE_REJ_FL, RJE_ACCT_NO, JE_BTCH_TYPE_CD, E_LE_PRCS_ST_CD, RJE_TRANS_AM, RJE_SYS_SRCE_CD, RJE_TRANS_QY, RJE_GR_AM, RJE_GR_QY, RJE_PD_CD, RJE_VL_TYPE_CD, RJE_CK_NO, RJE_VL_CLASS_CD, RJE_VL_SRCE_CD, RJE_VL_FRQ_CD, RJE_VL_LVL_CD, RJE_BTU_QY, JE_MMBTU_DET_CD, RJE_PS_BASE_QY, RJE_GRV_QY, RJE_OWN_NO9, RJE_OWN_NO, RJE_OWN_SEQ_NO9, RJE_OWN_SEQ_NO, RJE_PU_NO9, RJE_PU_NO, RJE_PU_SEQ_NO9, RJE_PU_SEQ_NO, RJE_PRDR_NO9, RJE_PRDR_NO, RJE_PRDR_SEQ_NO9, RJE_PRDR_SEQ_NO, OWN_INT_DCM_QY, E_OWN_INT_TP_CD, RJE_CK_DT9, RJE_CK_DT, RJE_RVRS_RSN_CD, UNITOF_MEAS_CD, JE_CASH_RCPT_DT9, JE_CASH_RCPT_DT, RJE_SUS_RSN_CD, RJE_CT_NO9, RJE_CT_NO, RJE_CT_TYPE_CD, RJE_DOI_PR_NO9, RJE_DOI_PR_NO, RJE_DOI_SEQ_NO9, RJE_DOI_SEQ_NO, RJE_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, RJE_TRACE_LE_NO, RJE_WL_NO9, RJE_WL_NO, RJE_WC_NO9, RJE_WC_NO, RJE_DED_RMB_AM, E_DED_GR_RMB_AM, RJE_TAX_1_AM, RJE_TAX_2_AM, RJE_TAX_3_AM, RJE_TAX_4_AM, RJE_TAX_5_AM, RJE_TAX_6_AM, RJE_TAX_7_AM, RJE_TAX_8_AM, RJE_TAX_9_AM, RJE_TAX_10_AM, RJE_TAX_RMB_AM, E_TAX_GR_RMB_AM, RJE_INV_NO, RJE_INV_DT9, RJE_INV_DT, RJE_INV_TYPE_CD, OWN_INT_SEQ_NO, RJE_PAY_CD, RJE_SA_MP_NO9, RJE_SA_MP_NO, RJE_SA_DT9, RJE_SA_DT, RJE_ST_CD, RJE_TAX_AUTH_NO, TAXAUTH_SEQ_NO, OWN_BAL_DCM_QY, RJE_PR_TYPE_CD, JE_OP_NON_OP_FL, RJE_PU_PR_NO, RJE_PU_PD_CD, RJE_ERROR_1_CD, RJE_ERROR_2_CD, RJE_ERROR_3_CD, RJE_ERROR_4_CD, RJE_ERROR_5_CD, RJE_UNIT_PR_NO9, RJE_UNIT_PR_NO, E_ARMT_LVL_1_CD, E_ARMT_LVL_2_CD, RJE_TRANS_DE9, RJE_TRANS_DE, RJE_GR_TAX_AM, RJE_PROC_CO, RJE_AES_FL, RJE_TAX_CD, JE_GRP_GROUP_NO9, JE_GRP_GROUP_NO, RJE_JIB_DOI_NO9, RJE_JIB_DOI_NO, JIB_DOI_SEQ_NO9, JIB_DOI_SEQ_NO, RJE_BILL_CD, RJE_TXN_VAL_AM, RJE_TXN_DT, JE_GAS_PLANT_NO9, JE_GAS_PLANT_NO, RJE_GPLT_SEQ_NO9, RJE_GPLT_SEQ_NO, RJE_REF_NO, RJE_SELLER_NO9, RJE_SELLER_NO, E_SELLER_SEQ_NO9, E_SELLER_SEQ_NO, RJE_AUD_BTCH_NO, RJE_DI_PR_NO, RJE_DI_NO, RJE_OWN_PVR_AM, RJE_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, RJE_INT_PAID_FL, MMBTUOWN_VL_AM, MMBTU_GR_VL_AM, RJE_REMT_NO9, RJE_REMT_NO, RJE_REMT_SEQ_NO9, RJE_REMT_SEQ_NO, RJE_RCV_GLWL_NO9, RJE_RCV_GLWL_NO, RJE_RCV_GLWC_NO9, RJE_RCV_GLWC_NO, RJE_REL_CT_NO9, RJE_REL_CT_NO, RJE_ORIG_MP_NO9, RJE_ORIG_MP_NO, E_ORIG_MP_TP_CD, RJE_PHS_NO, RJE_CMT_SYS_NO9, RJE_CMT_SYS_NO, RJE_ESCH_FL, RJE_INT_SYM_CD, RJE_LGND_CD, RJE_MK_TYPE_NO, RJE_OR_LVL_2_NO, E_SPEC_PYMNT_CD, RJE_OVRD_OWN_CD, RJE_RCPTN_PT_NO, RJE_TRNSP_NO, JE_TRNSP_SEQ_NO, RJE_OWN_VAL, JE_RBUR_DECM_PC, RJE_GR_TAX_1_AM, RJE_GR_TAX_2_AM, RJE_GR_TAX_3_AM, RJE_GR_TAX_4_AM, RJE_GR_TAX_5_AM, RJE_GR_TAX_6_AM, RJE_GR_TAX_7_AM, RJE_GR_TAX_8_AM, RJE_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, RJE_ORIG_PR_NO, RJE_INJ_DT9, RJE_INJ_DT, E_GR_APC_RMB_AM, NET_APC_RMB_AM, RJE_JI_OWN_NO, E_JI_OWN_SEQ_NO, RJE_SECT_PR_NO9, RJE_SECT_PR_NO, RJE_SECT_SEQ_NO9, RJE_SECT_SEQ_NO, RJE_NWK_NO9, RJE_NWK_NO, RJE_SUB_NWK_NO9, RJE_SUB_NWK_NO, RJE_CHV_RPT_CD, RJE_VER_NO, RJE_USER_ID, RJE_TIMESTAMP FROM OIUPH_RV_RJE

TOP ERP 6.0 | OIUPH_RV_RJE 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	*	MANDT	Allow NULL?
2	PDM_GUID	GUID in 'CHAR' Format in Uppercase	nvarchar	32	0	CHAR	(N' ')	No		GUID_32	Allow NULL?
3	DUMMY_SEQ_FIELD	System number	nvarchar	20	0	NUMC	(N'00000000000000000000')	No		OIUH_RJE_NO	Allow NULL?
4	RJE_OR_LVL_1_NO	OIUH_CHAR3	nvarchar	3	0	CHAR	(N' ')	No		OIUH_CHAR3	Allow NULL?
5	JE_ACCT_PERD_DT	OIUH_CHAR14	nvarchar	14	0	CHAR	(N' ')	No		OIUH_CHAR14	Allow NULL?
6	RJE_ACCT_CAT_CD	OIUH_CHAR4	nvarchar	4	0	CHAR	(N' ')	No		OIUH_CHAR4	Allow NULL?
7	RJE_BTCH_NO	OIUH_CHAR4	nvarchar	4	0	CHAR	(N' ')	No		OIUH_CHAR4	Allow NULL?
8	RJE_BRD_CD	OIUH_CHAR4	nvarchar	4	0	CHAR	(N' ')	No		OIUH_CHAR4	Allow NULL?
9	RJE_VOU_NO	OIUH_CHAR6	nvarchar	6	0	CHAR	(N' ')	No		OIUH_CHAR6	Allow NULL?
10	RJE_LE_NO	OIUH_CHAR8	nvarchar	8	0	CHAR	(N' ')	No		OIUH_CHAR8	Allow NULL?
11	RJE_REJ_FL	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
12	RJE_ACCT_NO	OIUH_CHAR10	nvarchar	10	0	CHAR	(N' ')	No		OIUH_CHAR10	Allow NULL?
13	JE_BTCH_TYPE_CD	OIUH_CHAR2	nvarchar	2	0	CHAR	(N' ')	No		OIUH_CHAR2	Allow NULL?
14	E_LE_PRCS_ST_CD	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
15	RJE_TRANS_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
16	RJE_SYS_SRCE_CD	OIUH_CHAR2	nvarchar	2	0	CHAR	(N' ')	No		OIUH_CHAR2	Allow NULL?
17	RJE_TRANS_QY	OIUH_DEC11_2	decimal	11	2	DEC	((0))	No		OIUH_DEC11_2
18	RJE_GR_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
19	RJE_GR_QY	OIUH_DEC11_2	decimal	11	2	DEC	((0))	No		OIUH_DEC11_2
20	RJE_PD_CD	OIUH_CHAR3	nvarchar	3	0	CHAR	(N' ')	No		OIUH_CHAR3	Allow NULL?
21	RJE_VL_TYPE_CD	OIUH_CHAR2	nvarchar	2	0	CHAR	(N' ')	No		OIUH_CHAR2	Allow NULL?
22	RJE_CK_NO	OIUH_CHAR10	nvarchar	10	0	CHAR	(N' ')	No		OIUH_CHAR10	Allow NULL?
23	RJE_VL_CLASS_CD	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
24	RJE_VL_SRCE_CD	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
25	RJE_VL_FRQ_CD	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
26	RJE_VL_LVL_CD	OIUH_CHAR2	nvarchar	2	0	CHAR	(N' ')	No		OIUH_CHAR2	Allow NULL?
27	RJE_BTU_QY	OIUH_DEC7_3	decimal	7	3	DEC	((0))	No		OIUH_DEC7_3
28	JE_MMBTU_DET_CD	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
29	RJE_PS_BASE_QY	OIUH_DEC6_3	decimal	6	3	DEC	((0))	No		OIUH_DEC6_3
30	RJE_GRV_QY	OIUH_DEC3_1	decimal	3	1	DEC	((0))	No		OIUH_DEC3_1
31	RJE_OWN_NO9	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
32	RJE_OWN_NO	OIUH_CHAR6	nvarchar	6	0	CHAR	(N' ')	Yes		OIUH_CHAR6	Allow NULL?
33	RJE_OWN_SEQ_NO9	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
34	RJE_OWN_SEQ_NO	OIUH_CHAR2	nvarchar	2	0	CHAR	(N' ')	Yes		OIUH_CHAR2	Allow NULL?
35	RJE_PU_NO9	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
36	RJE_PU_NO	OIUH_CHAR6	nvarchar	6	0	CHAR	(N' ')	Yes		OIUH_CHAR6	Allow NULL?
37	RJE_PU_SEQ_NO9	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
38	RJE_PU_SEQ_NO	OIUH_CHAR2	nvarchar	2	0	CHAR	(N' ')	Yes		OIUH_CHAR2	Allow NULL?
39	RJE_PRDR_NO9	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
40	RJE_PRDR_NO	OIUH_CHAR6	nvarchar	6	0	CHAR	(N' ')	Yes		OIUH_CHAR6	Allow NULL?
41	RJE_PRDR_SEQ_NO9	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
42	RJE_PRDR_SEQ_NO	OIUH_CHAR2	nvarchar	2	0	CHAR	(N' ')	Yes		OIUH_CHAR2	Allow NULL?
43	OWN_INT_DCM_QY	OIUH_DEC9_8	decimal	9	8	DEC	((0))	No		OIUH_DEC9_8
44	E_OWN_INT_TP_CD	OIUH_CHAR2	nvarchar	2	0	CHAR	(N' ')	No		OIUH_CHAR2	Allow NULL?
45	RJE_CK_DT9	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
46	RJE_CK_DT	OIUH_CHAR14	nvarchar	14	0	CHAR	(N' ')	Yes		OIUH_CHAR14	Allow NULL?
47	RJE_RVRS_RSN_CD	OIUH_CHAR2	nvarchar	2	0	CHAR	(N' ')	No		OIUH_CHAR2	Allow NULL?
48	UNITOF_MEAS_CD	OIUH_CHAR3	nvarchar	3	0	CHAR	(N' ')	No		OIUH_CHAR3	Allow NULL?
49	JE_CASH_RCPT_DT9	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
50	JE_CASH_RCPT_DT	OIUH_CHAR14	nvarchar	14	0	CHAR	(N' ')	Yes		OIUH_CHAR14	Allow NULL?
51	RJE_SUS_RSN_CD	OIUH_CHAR2	nvarchar	2	0	CHAR	(N' ')	No		OIUH_CHAR2	Allow NULL?
52	RJE_CT_NO9	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
53	RJE_CT_NO	Contract ID	nvarchar	6	0	CHAR	(N' ')	Yes		OIUH_CONTRACT_ID	Allow NULL?
54	RJE_CT_TYPE_CD	OIUH_CHAR2	nvarchar	2	0	CHAR	(N' ')	No		OIUH_CHAR2	Allow NULL?
55	RJE_DOI_PR_NO9	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
56	RJE_DOI_PR_NO	OIUH_CHAR8	nvarchar	8	0	CHAR	(N' ')	Yes		OIUH_CHAR8	Allow NULL?
57	RJE_DOI_SEQ_NO9	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
58	RJE_DOI_SEQ_NO	OIUH_CHAR5	nvarchar	5	0	CHAR	(N' ')	Yes		OIUH_CHAR5	Allow NULL?
59	RJE_TRACE_CO_NO	OIUH_CHAR3	nvarchar	3	0	CHAR	(N' ')	No		OIUH_CHAR3	Allow NULL?
60	E_TRACE_APRD_DT9	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
61	E_TRACE_APRD_DT	OIUH_CHAR14	nvarchar	14	0	CHAR	(N' ')	Yes		OIUH_CHAR14	Allow NULL?
62	E_TRACE_ACCT_NO	OIUH_CHAR10	nvarchar	10	0	CHAR	(N' ')	No		OIUH_CHAR10	Allow NULL?
63	E_TRACE_BTCH_NO	OIUH_CHAR4	nvarchar	4	0	CHAR	(N' ')	No		OIUH_CHAR4	Allow NULL?
64	E_TRACE_BTCH_CD	OIUH_CHAR2	nvarchar	2	0	CHAR	(N' ')	No		OIUH_CHAR2	Allow NULL?
65	E_TRACE_VOUC_NO	OIUH_CHAR6	nvarchar	6	0	CHAR	(N' ')	No		OIUH_CHAR6	Allow NULL?
66	RJE_TRACE_LE_NO	OIUH_CHAR8	nvarchar	8	0	CHAR	(N' ')	No		OIUH_CHAR8	Allow NULL?
67	RJE_WL_NO9	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
68	RJE_WL_NO	OIUH_CHAR6	nvarchar	6	0	CHAR	(N' ')	Yes		OIUH_CHAR6	Allow NULL?
69	RJE_WC_NO9	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
70	RJE_WC_NO	OIUH_CHAR2	nvarchar	2	0	CHAR	(N' ')	Yes		OIUH_CHAR2	Allow NULL?
71	RJE_DED_RMB_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
72	E_DED_GR_RMB_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
73	RJE_TAX_1_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
74	RJE_TAX_2_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
75	RJE_TAX_3_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
76	RJE_TAX_4_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
77	RJE_TAX_5_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
78	RJE_TAX_6_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
79	RJE_TAX_7_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
80	RJE_TAX_8_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
81	RJE_TAX_9_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
82	RJE_TAX_10_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
83	RJE_TAX_RMB_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
84	E_TAX_GR_RMB_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
85	RJE_INV_NO	OIUH_CHAR6	nvarchar	6	0	CHAR	(N' ')	No		OIUH_CHAR6	Allow NULL?
86	RJE_INV_DT9	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
87	RJE_INV_DT	OIUH_CHAR14	nvarchar	14	0	CHAR	(N' ')	Yes		OIUH_CHAR14	Allow NULL?
88	RJE_INV_TYPE_CD	OIUH_CHAR2	nvarchar	2	0	CHAR	(N' ')	No		OIUH_CHAR2	Allow NULL?
89	OWN_INT_SEQ_NO	OIUH_CHAR2	nvarchar	2	0	CHAR	(N' ')	No		OIUH_CHAR2	Allow NULL?
90	RJE_PAY_CD	OIUH_CHAR2	nvarchar	2	0	CHAR	(N' ')	No		OIUH_CHAR2	Allow NULL?
91	RJE_SA_MP_NO9	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
92	RJE_SA_MP_NO	OIUH_CHAR6	nvarchar	6	0	CHAR	(N' ')	Yes		OIUH_CHAR6	Allow NULL?
93	RJE_SA_DT9	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
94	RJE_SA_DT	OIUH_CHAR14	nvarchar	14	0	CHAR	(N' ')	Yes		OIUH_CHAR14	Allow NULL?
95	RJE_ST_CD	OIUH_CHAR2	nvarchar	2	0	CHAR	(N' ')	No		OIUH_CHAR2	Allow NULL?
96	RJE_TAX_AUTH_NO	OIUH_CHAR6	nvarchar	6	0	CHAR	(N' ')	No		OIUH_CHAR6	Allow NULL?
97	TAXAUTH_SEQ_NO	OIUH_CHAR2	nvarchar	2	0	CHAR	(N' ')	No		OIUH_CHAR2	Allow NULL?
98	OWN_BAL_DCM_QY	OIUH_DEC9_8	decimal	9	8	DEC	((0))	No		OIUH_DEC9_8
99	RJE_PR_TYPE_CD	OIUH_CHAR2	nvarchar	2	0	CHAR	(N' ')	No		OIUH_CHAR2	Allow NULL?
100	JE_OP_NON_OP_FL	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
101	RJE_PU_PR_NO	OIUH_CHAR18	nvarchar	18	0	CHAR	(N' ')	No		OIUH_CHAR18	Allow NULL?
102	RJE_PU_PD_CD	OIUH_CHAR3	nvarchar	3	0	CHAR	(N' ')	No		OIUH_CHAR3	Allow NULL?
103	RJE_ERROR_1_CD	OIUH_CHAR5	nvarchar	5	0	CHAR	(N' ')	No		OIUH_CHAR5	Allow NULL?
104	RJE_ERROR_2_CD	OIUH_CHAR5	nvarchar	5	0	CHAR	(N' ')	No		OIUH_CHAR5	Allow NULL?
105	RJE_ERROR_3_CD	OIUH_CHAR5	nvarchar	5	0	CHAR	(N' ')	No		OIUH_CHAR5	Allow NULL?
106	RJE_ERROR_4_CD	OIUH_CHAR5	nvarchar	5	0	CHAR	(N' ')	No		OIUH_CHAR5	Allow NULL?
107	RJE_ERROR_5_CD	OIUH_CHAR5	nvarchar	5	0	CHAR	(N' ')	No		OIUH_CHAR5	Allow NULL?
108	RJE_UNIT_PR_NO9	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
109	RJE_UNIT_PR_NO	OIUH_CHAR8	nvarchar	8	0	CHAR	(N' ')	Yes		OIUH_CHAR8	Allow NULL?
110	E_ARMT_LVL_1_CD	OIUH_CHAR8	nvarchar	8	0	CHAR	(N' ')	No		OIUH_CHAR8	Allow NULL?
111	E_ARMT_LVL_2_CD	OIUH_CHAR5	nvarchar	5	0	CHAR	(N' ')	No		OIUH_CHAR5	Allow NULL?
112	RJE_TRANS_DE9	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
113	RJE_TRANS_DE	OIUH_CHAR60	nvarchar	60	0	CHAR	(N' ')	Yes		OIUH_CHAR60	Allow NULL?
114	RJE_GR_TAX_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
115	RJE_PROC_CO	OIUH_CHAR3	nvarchar	3	0	CHAR	(N' ')	No		OIUH_CHAR3	Allow NULL?
116	RJE_AES_FL	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
117	RJE_TAX_CD	OIUH_CHAR2	nvarchar	2	0	CHAR	(N' ')	No		OIUH_CHAR2	Allow NULL?
118	JE_GRP_GROUP_NO9	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
119	JE_GRP_GROUP_NO	OIUH_CHAR8	nvarchar	8	0	CHAR	(N' ')	Yes		OIUH_CHAR8	Allow NULL?
120	RJE_JIB_DOI_NO9	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
121	RJE_JIB_DOI_NO	OIUH_CHAR8	nvarchar	8	0	CHAR	(N' ')	Yes		OIUH_CHAR8	Allow NULL?
122	JIB_DOI_SEQ_NO9	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
123	JIB_DOI_SEQ_NO	OIUH_CHAR5	nvarchar	5	0	CHAR	(N' ')	Yes		OIUH_CHAR5	Allow NULL?
124	RJE_BILL_CD	OIUH_CHAR2	nvarchar	2	0	CHAR	(N' ')	No		OIUH_CHAR2	Allow NULL?
125	RJE_TXN_VAL_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
126	RJE_TXN_DT	OIUH_CHAR14	nvarchar	14	0	CHAR	(N' ')	No		OIUH_CHAR14	Allow NULL?
127	JE_GAS_PLANT_NO9	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
128	JE_GAS_PLANT_NO	OIUH_CHAR8	nvarchar	8	0	CHAR	(N' ')	Yes		OIUH_CHAR8	Allow NULL?
129	RJE_GPLT_SEQ_NO9	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
130	RJE_GPLT_SEQ_NO	OIUH_CHAR5	nvarchar	5	0	CHAR	(N' ')	Yes		OIUH_CHAR5	Allow NULL?
131	RJE_REF_NO	OIUH_CHAR10	nvarchar	10	0	CHAR	(N' ')	No		OIUH_CHAR10	Allow NULL?
132	RJE_SELLER_NO9	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
133	RJE_SELLER_NO	OIUH_CHAR6	nvarchar	6	0	CHAR	(N' ')	Yes		OIUH_CHAR6	Allow NULL?
134	E_SELLER_SEQ_NO9	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
135	E_SELLER_SEQ_NO	OIUH_CHAR2	nvarchar	2	0	CHAR	(N' ')	Yes		OIUH_CHAR2	Allow NULL?
136	RJE_AUD_BTCH_NO	OIUH_CHAR4	nvarchar	4	0	CHAR	(N' ')	No		OIUH_CHAR4	Allow NULL?
137	RJE_DI_PR_NO	OIUH_CHAR8	nvarchar	8	0	CHAR	(N' ')	No		OIUH_CHAR8	Allow NULL?
138	RJE_DI_NO	OIUH_CHAR5	nvarchar	5	0	CHAR	(N' ')	No		OIUH_CHAR5	Allow NULL?
139	RJE_OWN_PVR_AM	OIUH_DEC11_2	decimal	11	2	DEC	((0))	No		OIUH_DEC11_2
140	RJE_GR_PVR_AM	OIUH_DEC11_2	decimal	11	2	DEC	((0))	No		OIUH_DEC11_2
141	E_OTH_DED_01_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
142	E_OTH_DED_02_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
143	E_OTH_DED_03_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
144	E_OTH_DED_04_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
145	E_OTH_DED_05_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
146	E_OTH_DED_06_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
147	E_OTH_DED_07_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
148	E_OTH_DED_08_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
149	E_OTH_DED_09_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
150	E_OTH_DED_10_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
151	E_OTH_DED_11_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
152	E_OTH_DED_12_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
153	E_OTH_DED_13_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
154	E_OTH_DED_14_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
155	E_OTH_DED_15_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
156	E_OTH_DED_16_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
157	E_OTH_DED_17_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
158	E_OTH_DED_18_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
159	RJE_INT_PAID_FL	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
160	MMBTUOWN_VL_AM	OIUH_DEC11_2	decimal	11	2	DEC	((0))	No		OIUH_DEC11_2
161	MMBTU_GR_VL_AM	OIUH_DEC11_2	decimal	11	2	DEC	((0))	No		OIUH_DEC11_2
162	RJE_REMT_NO9	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
163	RJE_REMT_NO	OIUH_CHAR6	nvarchar	6	0	CHAR	(N' ')	Yes		OIUH_CHAR6	Allow NULL?
164	RJE_REMT_SEQ_NO9	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
165	RJE_REMT_SEQ_NO	OIUH_CHAR2	nvarchar	2	0	CHAR	(N' ')	Yes		OIUH_CHAR2	Allow NULL?
166	RJE_RCV_GLWL_NO9	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
167	RJE_RCV_GLWL_NO	OIUH_CHAR6	nvarchar	6	0	CHAR	(N' ')	Yes		OIUH_CHAR6	Allow NULL?
168	RJE_RCV_GLWC_NO9	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
169	RJE_RCV_GLWC_NO	OIUH_CHAR2	nvarchar	2	0	CHAR	(N' ')	Yes		OIUH_CHAR2	Allow NULL?
170	RJE_REL_CT_NO9	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
171	RJE_REL_CT_NO	Contract ID	nvarchar	6	0	CHAR	(N' ')	Yes		OIUH_CONTRACT_ID	Allow NULL?
172	RJE_ORIG_MP_NO9	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
173	RJE_ORIG_MP_NO	OIUH_CHAR6	nvarchar	6	0	CHAR	(N' ')	Yes		OIUH_CHAR6	Allow NULL?
174	E_ORIG_MP_TP_CD	OIUH_CHAR2	nvarchar	2	0	CHAR	(N' ')	No		OIUH_CHAR2	Allow NULL?
175	RJE_PHS_NO	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
176	RJE_CMT_SYS_NO9	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
177	RJE_CMT_SYS_NO	OIUH_DEC18	decimal	18	0	DEC	((0))	Yes		OIUH_DEC18
178	RJE_ESCH_FL	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
179	RJE_INT_SYM_CD	OIUH_CHAR2	nvarchar	2	0	CHAR	(N' ')	No		OIUH_CHAR2	Allow NULL?
180	RJE_LGND_CD	OIUH_CHAR2	nvarchar	2	0	CHAR	(N' ')	No		OIUH_CHAR2	Allow NULL?
181	RJE_MK_TYPE_NO	OIUH_CHAR2	nvarchar	2	0	CHAR	(N' ')	No		OIUH_CHAR2	Allow NULL?
182	RJE_OR_LVL_2_NO	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
183	E_SPEC_PYMNT_CD	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
184	RJE_OVRD_OWN_CD	OIUH_CHAR2	nvarchar	2	0	CHAR	(N' ')	No		OIUH_CHAR2	Allow NULL?
185	RJE_RCPTN_PT_NO	OIUH_CHAR6	nvarchar	6	0	CHAR	(N' ')	No		OIUH_CHAR6	Allow NULL?
186	RJE_TRNSP_NO	OIUH_CHAR6	nvarchar	6	0	CHAR	(N' ')	No		OIUH_CHAR6	Allow NULL?
187	JE_TRNSP_SEQ_NO	OIUH_CHAR2	nvarchar	2	0	CHAR	(N' ')	No		OIUH_CHAR2	Allow NULL?
188	RJE_OWN_VAL	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
189	JE_RBUR_DECM_PC	OIUH_DEC9_8	decimal	9	8	DEC	((0))	No		OIUH_DEC9_8
190	RJE_GR_TAX_1_AM	Local amount	decimal	13	2	CURR	((0))	No		OIUH_CURR13_2
191	RJE_GR_TAX_2_AM	Local amount	decimal	13	2	CURR	((0))	No		OIUH_CURR13_2
192	RJE_GR_TAX_3_AM	Local amount	decimal	13	2	CURR	((0))	No		OIUH_CURR13_2
193	RJE_GR_TAX_4_AM	Local amount	decimal	13	2	CURR	((0))	No		OIUH_CURR13_2
194	RJE_GR_TAX_5_AM	Local amount	decimal	13	2	CURR	((0))	No		OIUH_CURR13_2
195	RJE_GR_TAX_6_AM	Local amount	decimal	13	2	CURR	((0))	No		OIUH_CURR13_2
196	RJE_GR_TAX_7_AM	Local amount	decimal	13	2	CURR	((0))	No		OIUH_CURR13_2
197	RJE_GR_TAX_8_AM	Local amount	decimal	13	2	CURR	((0))	No		OIUH_CURR13_2
198	RJE_GR_TAX_9_AM	Local amount	decimal	13	2	CURR	((0))	No		OIUH_CURR13_2
199	JE_GR_TAX_10_AM	Local amount	decimal	13	2	CURR	((0))	No		OIUH_CURR13_2
200	JE_GR_TRNDED_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
201	E_OWN_TRNDED_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
202	E_GR_OTH_MKD_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
203	OWN_OTH_MKD_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
204	RJE_ORIG_PR_NO	OIUH_CHAR8	nvarchar	8	0	CHAR	(N' ')	No		OIUH_CHAR8	Allow NULL?
205	RJE_INJ_DT9	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
206	RJE_INJ_DT	OIUH_CHAR14	nvarchar	14	0	CHAR	(N' ')	Yes		OIUH_CHAR14	Allow NULL?
207	E_GR_APC_RMB_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
208	NET_APC_RMB_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
209	RJE_JI_OWN_NO	OIUH_CHAR6	nvarchar	6	0	CHAR	(N' ')	No		OIUH_CHAR6	Allow NULL?
210	E_JI_OWN_SEQ_NO	OIUH_CHAR2	nvarchar	2	0	CHAR	(N' ')	No		OIUH_CHAR2	Allow NULL?
211	RJE_SECT_PR_NO9	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
212	RJE_SECT_PR_NO	OIUH_CHAR8	nvarchar	8	0	CHAR	(N' ')	Yes		OIUH_CHAR8	Allow NULL?
213	RJE_SECT_SEQ_NO9	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
214	RJE_SECT_SEQ_NO	OIUH_CHAR5	nvarchar	5	0	CHAR	(N' ')	Yes		OIUH_CHAR5	Allow NULL?
215	RJE_NWK_NO9	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
216	RJE_NWK_NO	OIUH_CHAR4	nvarchar	4	0	CHAR	(N' ')	Yes		OIUH_CHAR4	Allow NULL?
217	RJE_SUB_NWK_NO9	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
218	RJE_SUB_NWK_NO	OIUH_CHAR4	nvarchar	4	0	CHAR	(N' ')	Yes		OIUH_CHAR4	Allow NULL?
219	RJE_CHV_RPT_CD	OIUH_CHAR10	nvarchar	10	0	CHAR	(N' ')	No		OIUH_CHAR10	Allow NULL?
220	RJE_VER_NO	OIUH_DEC5	decimal	5	0	DEC	((0))	No		OIUH_DEC5
221	RJE_USER_ID	OIUH_CHAR8	nvarchar	8	0	CHAR	(N' ')	No		OIUH_CHAR8	Allow NULL?
222	RJE_TIMESTAMP	OIUH_CHAR14	nvarchar	14	0	CHAR	(N' ')	No		OIUH_CHAR14	Allow NULL?

TOP ERP 6.0 | OIUPH_RV_RJE INDEXES

Name	Primary	Unique	Type	Columns
OIUPH_RV_RJE~0	Yes	Yes	CLUSTERED	DUMMY_SEQ_FIELD, PDM_GUID, 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

222 COLUMNS | 1 INDEXES | ERP 6.0 | OIUPH_RV_RJE TABLE

TOP ERP 6.0 | OIUPH_RV_RJE COLUMNS

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

222 COLUMNS | 1 INDEXES | ERP 6.0 | OIUPH_RV_RJE TABLE

TOPERP 6.0 | OIUPH_RV_RJE COLUMNS

TOPERP 6.0 | OIUPH_RV_RJE INDEXES

TOP ERP 6.0 | OIUPH_RV_RJE COLUMNS

TOP ERP 6.0 | OIUPH_RV_RJE INDEXES