	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

361 COLUMNS | 1 INDEXES | ERP 6.0 | OIURV_DOC_RDSUM TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Industry Specific :: Industry Solution Oil :: Production and Revenue Accounting :: Revenue :: Valuation
1	ERP EHP7	6.0	OIURV_DOC_RDSUM	361	1	RD summary(VL interface records to RD)	Valuation

SQL: selectupdate insert create

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

SELECT MANDT, DOC_NO, DOC_YEAR, LINE_NO, DN_NO, WL_NO, WC_NO, MP_NO, MP_TYPE_CD, MATNR, BUKRS, VNAME, DOI_NO, CT_NO, MAJPD_CD, FRML_NO, WI_OWN_NO, WI_INT_TYPE_CD, WI_OWN_ISQ_NO, NI_OWN_NO, NI_INT_TYPE_CD, NI_OWN_ISQ_NO, LVL_CD, PU_NO, TAX_CLS, SALE_DT, LAND1, PRI_GEO_LOC, TAX_TYPE_1, TAX_TYPE_2, TAX_TYPE_3, TAX_TYPE_4, TAX_TYPE_5, TAX_TYPE_6, TAX_TYPE_7, TAX_TYPE_8, TAX_TYPE_9, TAX_TYPE_10, SEV_TAX_PAY_1, SEV_TAX_PAY_2, SEV_TAX_PAY_3, SEV_TAX_PAY_4, SEV_TAX_PAY_5, SEV_TAX_PAY_6, SEV_TAX_PAY_7, SEV_TAX_PAY_8, SEV_TAX_PAY_9, SEV_TAX_PAY_10, SM_REV_PRCS_CD, UNIT_VNAME, SYSTEM_SRCE_CD, VL_TYPE_CD, VL_CLS_CD, FRML_ACTL_FL, FRML_ENTL_FL, FRML_SETT_FL, TOT_GRI_PC, TOT_NRI_PC, CT_DECM, ADJ_CT_DECM, SLID_SCAL_IND, ACTL_GR_VL, ENTL_GR_VL, ACTL_ENERGY, ENTL_ENERGY, SM_PS_BASE, SM_ACTL_BTU_FAC, GRV_AM, ACTL_GR_VAL_AM, ENTL_GR_VAL_AM, SETT_GR_VL, SETT_GR_VAL_AM, SETT_ENERGY, INT_ACTL_MKCT_1, INT_ACTL_MKCT_2, INT_ACTL_MKCT_3, INT_ACTL_MKCT_4, INT_ACTL_MKCT_5, INT_ACTL_MKCT_6, INT_ACTL_MKCT_7, INT_ACTL_MKCT_8, INT_ACTL_MKCT_9, INT_ACTL_MKCT_10, EXT_ACTL_MKCT_1, EXT_ACTL_MKCT_2, EXT_ACTL_MKCT_3, EXT_ACTL_MKCT_4, EXT_ACTL_MKCT_5, EXT_ACTL_MKCT_6, EXT_ACTL_MKCT_7, EXT_ACTL_MKCT_8, EXT_ACTL_MKCT_9, EXT_ACTL_MKCT_10, EXT_ACTL_MCR_1, EXT_ACTL_MCR_2, EXT_ACTL_MCR_3, EXT_ACTL_MCR_4, EXT_ACTL_MCR_5, EXT_ACTL_MCR_6, EXT_ACTL_MCR_7, EXT_ACTL_MCR_8, EXT_ACTL_MCR_9, EXT_ACTL_MCR_10, TRNSP_NO_1, TRNSP_NO_2, TRNSP_NO_3, TRNSP_NO_4, TRNSP_NO_5, TRNSP_NO_6, TRNSP_NO_7, TRNSP_NO_8, TRNSP_NO_9, TRNSP_NO_10, TRNSP_CT_NO_1, TRNSP_CT_NO_2, TRNSP_CT_NO_3, TRNSP_CT_NO_4, TRNSP_CT_NO_5, TRNSP_CT_NO_6, TRNSP_CT_NO_7, TRNSP_CT_NO_8, TRNSP_CT_NO_9, TRNSP_CT_NO10, INT_ENTL_MKCT_1, INT_ENTL_MKCT_2, INT_ENTL_MKCT_3, INT_ENTL_MKCT_4, INT_ENTL_MKCT_5, INT_ENTL_MKCT_6, INT_ENTL_MKCT_7, INT_ENTL_MKCT_8, INT_ENTL_MKCT_9, INT_ENTL_MKCT_10, EXT_ENTL_MKCT_1, EXT_ENTL_MKCT_2, EXT_ENTL_MKCT_3, EXT_ENTL_MKCT_4, EXT_ENTL_MKCT_5, EXT_ENTL_MKCT_6, EXT_ENTL_MKCT_7, EXT_ENTL_MKCT_8, EXT_ENTL_MKCT_9, EXT_ENTL_MKCT_10, EXT_ENTL_MCR_1, EXT_ENTL_MCR_2, EXT_ENTL_MCR_3, EXT_ENTL_MCR_4, EXT_ENTL_MCR_5, EXT_ENTL_MCR_6, EXT_ENTL_MCR_7, EXT_ENTL_MCR_8, EXT_ENTL_MCR_9, EXT_ENTL_MCR_10, INT_SETT_MKCT_1, INT_SETT_MKCT_2, INT_SETT_MKCT_3, INT_SETT_MKCT_4, INT_SETT_MKCT_5, INT_SETT_MKCT_6, INT_SETT_MKCT_7, INT_SETT_MKCT_8, INT_SETT_MKCT_9, INT_SETT_MKCT_10, EXT_SETT_MKCT_1, EXT_SETT_MKCT_2, EXT_SETT_MKCT_3, EXT_SETT_MKCT_4, EXT_SETT_MKCT_5, EXT_SETT_MKCT_6, EXT_SETT_MKCT_7, EXT_SETT_MKCT_8, EXT_SETT_MKCT_9, EXT_SETT_MKCT_10, EXT_SETT_MCR_1, EXT_SETT_MCR_2, EXT_SETT_MCR_3, EXT_SETT_MCR_4, EXT_SETT_MCR_5, EXT_SETT_MCR_6, EXT_SETT_MCR_7, EXT_SETT_MCR_8, EXT_SETT_MCR_9, EXT_SETT_MCR_10, SM_SETT_BTU_FAC, TOTAL_TAX_PC_1, TOTAL_TAX_PC_2, TOTAL_TAX_PC_3, TOTAL_TAX_PC_4, TOTAL_TAX_PC_5, TOTAL_TAX_PC_6, TOTAL_TAX_PC_7, TOTAL_TAX_PC_8, TOTAL_TAX_PC_9, TOTAL_TAX_PC_10, ACTL_ST_TAX_1, ACTL_ST_TAX_2, ACTL_ST_TAX_3, ACTL_ST_TAX_4, ACTL_ST_TAX_5, ACTL_ST_TAX_6, ACTL_ST_TAX_7, ACTL_ST_TAX_8, ACTL_ST_TAX_9, ACTL_ST_TAX_10, ACTL_ST_TAX_RM_1, ACTL_ST_TAX_RM_2, ACTL_ST_TAX_RM_3, ACTL_ST_TAX_RM_4, ACTL_ST_TAX_RM_5, ACTL_ST_TAX_RM_6, ACTL_ST_TAX_RM_7, ACTL_ST_TAX_RM_8, ACTL_ST_TAX_RM_9, ACTL_ST_TAX_RM10, GROSS_ST_TAX_1, GROSS_ST_TAX_2, GROSS_ST_TAX_3, GROSS_ST_TAX_4, GROSS_ST_TAX_5, GROSS_ST_TAX_6, GROSS_ST_TAX_7, GROSS_ST_TAX_8, GROSS_ST_TAX_9, GROSS_ST_TAX_10, VL_TAX_RATE_PC_1, VL_TAX_RATE_PC_2, VL_TAX_RATE_PC_3, VL_TAX_RATE_PC_4, VL_TAX_RATE_PC_5, VL_TAX_RATE_PC_6, VL_TAX_RATE_PC_7, VL_TAX_RATE_PC_8, VL_TAX_RATE_PC_9, VL_TAX_RATE_PC10, ENTL_ST_TAX_1, ENTL_ST_TAX_2, ENTL_ST_TAX_3, ENTL_ST_TAX_4, ENTL_ST_TAX_5, ENTL_ST_TAX_6, ENTL_ST_TAX_7, ENTL_ST_TAX_8, ENTL_ST_TAX_9, ENTL_ST_TAX_10, ENTL_ST_TAX_RM_1, ENTL_ST_TAX_RM_2, ENTL_ST_TAX_RM_3, ENTL_ST_TAX_RM_4, ENTL_ST_TAX_RM_5, ENTL_ST_TAX_RM_6, ENTL_ST_TAX_RM_7, ENTL_ST_TAX_RM_8, ENTL_ST_TAX_RM_9, ENTL_ST_TAX_RM10, SETT_ST_TAX_1, SETT_ST_TAX_2, SETT_ST_TAX_3, SETT_ST_TAX_4, SETT_ST_TAX_5, SETT_ST_TAX_6, SETT_ST_TAX_7, SETT_ST_TAX_8, SETT_ST_TAX_9, SETT_ST_TAX_10, SETT_ST_TAX_RM_1, SETT_ST_TAX_RM_2, SETT_ST_TAX_RM_3, SETT_ST_TAX_RM_4, SETT_ST_TAX_RM_5, SETT_ST_TAX_RM_6, SETT_ST_TAX_RM_7, SETT_ST_TAX_RM_8, SETT_ST_TAX_RM_9, SETT_ST_TAX_RM10, SM_RCVBL_MP, TOT_TAX_RM_PC_1, TOT_TAX_RM_PC_2, TOT_TAX_RM_PC_3, TOT_TAX_RM_PC_4, TOT_TAX_RM_PC_5, TOT_TAX_RM_PC_6, TOT_TAX_RM_PC_7, TOT_TAX_RM_PC_8, TOT_TAX_RM_PC_9, TOT_TAX_RM_PC_10, GPLT_VNAME, GPLT_DOI_DOI, ACTL_WLR_VL_AM, ENTL_WLR_VL_AM, SETT_WLR_VL_AM, EXT_PROP_NO_1, EXT_DOI_NO_1, EXT_PROP_NO_2, EXT_DOI_NO_2, EXT_PROP_NO_3, EXT_DOI_NO_3, EXT_PROP_NO_4, EXT_DOI_NO_4, EXT_PROP_NO_5, EXT_DOI_NO_5, EXT_PROP_NO_6, EXT_DOI_NO_6, EXT_PROP_NO_7, EXT_DOI_NO_7, EXT_PROP_NO_8, EXT_DOI_NO_8, EXT_PROP_NO_9, EXT_DOI_NO_9, EXT_PROP_NO_10, EXT_DOI_NO_10, INT_PROP_NO_1, INT_DOI_NO_1, INT_PROP_NO_2, INT_DOI_NO_2, INT_PROP_NO_3, INT_DOI_NO_3, INT_PROP_NO_4, INT_DOI_NO_4, INT_PROP_NO_5, INT_DOI_NO_5, INT_PROP_NO_6, INT_DOI_NO_6, INT_PROP_NO_7, INT_DOI_NO_7, INT_PROP_NO_8, INT_DOI_NO_8, INT_PROP_NO_9, INT_DOI_NO_9, INT_PROP_NO_10, INT_DOI_NO_10, SM_REMITTER_NO, SM_REMITT_SEQ_NO, GASLIFT_WL_NO, GASLIFT_WC_NO, RELATED_CT, CT_TYPE_CD, DOI_SUM_FL, DUAL_ACCT_FL, ORIG_MP_NO, VNAME_TYPE_CD, SM_TAX_GRNT_FL, TAX_RMB_GRNT, SM_NRTF_CD, SM_REC_PYMT_CD, IGN_PYMT_CD, BY_SLL_CT_NO, BY_SLL_VAL, BRD_CD, SM_LSE_VOL, SM_LSE_VAL, SM_PCT_RET_LSE, SM_TIK_PA_PC, SM_ENTL_CT_DECM, SM_RM_FEE_FL, SECT_VNAME, SECT_DOI_NO, COST_CENTER, UNIT_OF_MEAS_CD, ACTL_PTR_VL_AM, ENTL_PTR_VL_AM, SETT_PTR_VL_AM FROM OIURV_DOC_RDSUM

TOP ERP 6.0 | OIURV_DOC_RDSUM COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	DOC_NO	Val. document number	nvarchar	20	0	Allow NULL?
3	DOC_YEAR	Document year	nvarchar	4	0	Allow NULL?
4	LINE_NO	Document Line Number	nvarchar	6	0	Allow NULL?
5	DN_NO	Delivery network number	nvarchar	20	0	Allow NULL?
6	WL_NO	Well ID number	nvarchar	15	0	Allow NULL?
7	WC_NO	Well Completion Number	nvarchar	5	0	Allow NULL?
8	MP_NO	Measurement point number	nvarchar	20	0	Allow NULL?
9	MP_TYPE_CD	Originating Measurement Point Type	nvarchar	2	0	Allow NULL?
10	MATNR	Material Number	nvarchar	18	0	Allow NULL?
11	BUKRS	Company Code	nvarchar	4	0	Allow NULL?
12	VNAME	Joint Venture	nvarchar	6	0	Allow NULL?
13	DOI_NO	Division of interest (DOI)	nvarchar	5	0	Allow NULL?
14	CT_NO	Contract Number	nvarchar	10	0	Allow NULL?
15	MAJPD_CD	Major product code	char	1	0	Allow NULL?
16	FRML_NO	Formula number	nvarchar	8	0	Allow NULL?
17	WI_OWN_NO	Working Interest Owner	nvarchar	10	0	Allow NULL?
18	WI_INT_TYPE_CD	Participant Interest Type	nvarchar	2	0	Allow NULL?
19	WI_OWN_ISQ_NO	Owner Interest Sequence Number	nvarchar	2	0	Allow NULL?
20	NI_OWN_NO	Net Interest Owner	nvarchar	10	0	Allow NULL?
21	NI_INT_TYPE_CD	Participant Interest Type	nvarchar	2	0	Allow NULL?
22	NI_OWN_ISQ_NO	Owner Interest Sequence Number	nvarchar	2	0	Allow NULL?
23	LVL_CD	Level Code	nvarchar	2	0	Allow NULL?
24	PU_NO	Sold-to party	nvarchar	10	0	Allow NULL?
25	TAX_CLS	Tax Class	nvarchar	4	0	Allow NULL?
26	SALE_DT	Sales Date / Month	nvarchar	8	0	Allow NULL?
27	LAND1	Country Key	nvarchar	3	0	Allow NULL?
28	PRI_GEO_LOC	Primary geographical location (PRI geo. loc.)	nvarchar	2	0	Allow NULL?
29	TAX_TYPE_1	Severance Tax Type	nvarchar	2	0	Allow NULL?
30	TAX_TYPE_2	Severance Tax Type	nvarchar	2	0	Allow NULL?
31	TAX_TYPE_3	Severance Tax Type	nvarchar	2	0	Allow NULL?
32	TAX_TYPE_4	Severance Tax Type	nvarchar	2	0	Allow NULL?
33	TAX_TYPE_5	Severance Tax Type	nvarchar	2	0	Allow NULL?
34	TAX_TYPE_6	Severance Tax Type	nvarchar	2	0	Allow NULL?
35	TAX_TYPE_7	Severance Tax Type	nvarchar	2	0	Allow NULL?
36	TAX_TYPE_8	Severance Tax Type	nvarchar	2	0	Allow NULL?
37	TAX_TYPE_9	Severance Tax Type	nvarchar	2	0	Allow NULL?
38	TAX_TYPE_10	Severance Tax Type	nvarchar	2	0	Allow NULL?
39	SEV_TAX_PAY_1	Tax Severance Tax Calculation Payment Obligations Types	char	1	0	Allow NULL?
40	SEV_TAX_PAY_2	Tax Severance Tax Calculation Payment Obligations Types	char	1	0	Allow NULL?
41	SEV_TAX_PAY_3	Tax Severance Tax Calculation Payment Obligations Types	char	1	0	Allow NULL?
42	SEV_TAX_PAY_4	Tax Severance Tax Calculation Payment Obligations Types	char	1	0	Allow NULL?
43	SEV_TAX_PAY_5	Tax Severance Tax Calculation Payment Obligations Types	char	1	0	Allow NULL?
44	SEV_TAX_PAY_6	Tax Severance Tax Calculation Payment Obligations Types	char	1	0	Allow NULL?
45	SEV_TAX_PAY_7	Tax Severance Tax Calculation Payment Obligations Types	char	1	0	Allow NULL?
46	SEV_TAX_PAY_8	Tax Severance Tax Calculation Payment Obligations Types	char	1	0	Allow NULL?
47	SEV_TAX_PAY_9	Tax Severance Tax Calculation Payment Obligations Types	char	1	0	Allow NULL?
48	SEV_TAX_PAY_10	Tax Severance Tax Calculation Payment Obligations Types	char	1	0	Allow NULL?
49	SM_REV_PRCS_CD	Revenue Process Code	nvarchar	2	0	Allow NULL?
50	UNIT_VNAME	Joint Venture	nvarchar	6	0	Allow NULL?
51	SYSTEM_SRCE_CD	Valuation Transaction Source Code	nvarchar	2	0	Allow NULL?
52	VL_TYPE_CD	Volume type code	nvarchar	2	0	Allow NULL?
53	VL_CLS_CD	Volume class code	char	1	0	Allow NULL?
54	FRML_ACTL_FL	Actual indicator	char	1	0	Allow NULL?
55	FRML_ENTL_FL	Entitled Flag	char	1	0	Allow NULL?
56	FRML_SETT_FL	Settlement Flag	char	1	0	Allow NULL?
57	TOT_GRI_PC	Total Gross Interest %	decimal	9	8
58	TOT_NRI_PC	Total Net Revenue Interest Percentage	decimal	9	8
59	CT_DECM	Contract Decimal	decimal	9	8
60	ADJ_CT_DECM	Contract Decimal	decimal	9	8
61	SLID_SCAL_IND	Sliding scale indicator	char	1	0	Allow NULL?
62	ACTL_GR_VL	Gross Quantity	decimal	11	2
63	ENTL_GR_VL	Gross Quantity	decimal	11	2
64	ACTL_ENERGY	MMBTU Gross Volume	decimal	11	2
65	ENTL_ENERGY	MMBTU Gross Volume	decimal	11	2
66	SM_PS_BASE	OIUH_DEC5_3	decimal	5	3
67	SM_ACTL_BTU_FAC	OIUH_DEC7_3	decimal	7	3
68	GRV_AM	OIUH_DEC3_1	decimal	3	1
69	ACTL_GR_VAL_AM	JE Transaction Quantity	decimal	11	2
70	ENTL_GR_VAL_AM	JE Transaction Quantity	decimal	11	2
71	SETT_GR_VL	Gross Quantity	decimal	11	2
72	SETT_GR_VAL_AM	JE Transaction Quantity	decimal	11	2
73	SETT_ENERGY	MMBTU Gross Volume	decimal	11	2
74	INT_ACTL_MKCT_1	Gross Other Marketing Amount	decimal	11	2
75	INT_ACTL_MKCT_2	Gross Other Marketing Amount	decimal	11	2
76	INT_ACTL_MKCT_3	Gross Other Marketing Amount	decimal	11	2
77	INT_ACTL_MKCT_4	Gross Other Marketing Amount	decimal	11	2
78	INT_ACTL_MKCT_5	Gross Other Marketing Amount	decimal	11	2
79	INT_ACTL_MKCT_6	Gross Other Marketing Amount	decimal	11	2
80	INT_ACTL_MKCT_7	Gross Other Marketing Amount	decimal	11	2
81	INT_ACTL_MKCT_8	Gross Other Marketing Amount	decimal	11	2
82	INT_ACTL_MKCT_9	Gross Other Marketing Amount	decimal	11	2
83	INT_ACTL_MKCT_10	Gross Other Marketing Amount	decimal	11	2
84	EXT_ACTL_MKCT_1	Gross Other Marketing Amount	decimal	11	2
85	EXT_ACTL_MKCT_2	Gross Other Marketing Amount	decimal	11	2
86	EXT_ACTL_MKCT_3	Gross Other Marketing Amount	decimal	11	2
87	EXT_ACTL_MKCT_4	Gross Other Marketing Amount	decimal	11	2
88	EXT_ACTL_MKCT_5	Gross Other Marketing Amount	decimal	11	2
89	EXT_ACTL_MKCT_6	Gross Other Marketing Amount	decimal	11	2
90	EXT_ACTL_MKCT_7	Gross Other Marketing Amount	decimal	11	2
91	EXT_ACTL_MKCT_8	Gross Other Marketing Amount	decimal	11	2
92	EXT_ACTL_MKCT_9	Gross Other Marketing Amount	decimal	11	2
93	EXT_ACTL_MKCT_10	Gross Other Marketing Amount	decimal	11	2
94	EXT_ACTL_MCR_1	Gross Other Marketing Amount	decimal	11	2
95	EXT_ACTL_MCR_2	Gross Other Marketing Amount	decimal	11	2
96	EXT_ACTL_MCR_3	Gross Other Marketing Amount	decimal	11	2
97	EXT_ACTL_MCR_4	Gross Other Marketing Amount	decimal	11	2
98	EXT_ACTL_MCR_5	Gross Other Marketing Amount	decimal	11	2
99	EXT_ACTL_MCR_6	Gross Other Marketing Amount	decimal	11	2
100	EXT_ACTL_MCR_7	Gross Other Marketing Amount	decimal	11	2
101	EXT_ACTL_MCR_8	Gross Other Marketing Amount	decimal	11	2
102	EXT_ACTL_MCR_9	Gross Other Marketing Amount	decimal	11	2
103	EXT_ACTL_MCR_10	Gross Other Marketing Amount	decimal	11	2
104	TRNSP_NO_1	Transporter number	nvarchar	10	0	Allow NULL?
105	TRNSP_NO_2	Transporter number	nvarchar	10	0	Allow NULL?
106	TRNSP_NO_3	Transporter number	nvarchar	10	0	Allow NULL?
107	TRNSP_NO_4	Transporter number	nvarchar	10	0	Allow NULL?
108	TRNSP_NO_5	Transporter number	nvarchar	10	0	Allow NULL?
109	TRNSP_NO_6	Transporter number	nvarchar	10	0	Allow NULL?
110	TRNSP_NO_7	Transporter number	nvarchar	10	0	Allow NULL?
111	TRNSP_NO_8	Transporter number	nvarchar	10	0	Allow NULL?
112	TRNSP_NO_9	Transporter number	nvarchar	10	0	Allow NULL?
113	TRNSP_NO_10	Transporter number	nvarchar	10	0	Allow NULL?
114	TRNSP_CT_NO_1	Transporter contract number	nvarchar	10	0	Allow NULL?
115	TRNSP_CT_NO_2	Transporter contract number	nvarchar	10	0	Allow NULL?
116	TRNSP_CT_NO_3	Transporter contract number	nvarchar	10	0	Allow NULL?
117	TRNSP_CT_NO_4	Transporter contract number	nvarchar	10	0	Allow NULL?
118	TRNSP_CT_NO_5	Transporter contract number	nvarchar	10	0	Allow NULL?
119	TRNSP_CT_NO_6	Transporter contract number	nvarchar	10	0	Allow NULL?
120	TRNSP_CT_NO_7	Transporter contract number	nvarchar	10	0	Allow NULL?
121	TRNSP_CT_NO_8	Transporter contract number	nvarchar	10	0	Allow NULL?
122	TRNSP_CT_NO_9	Transporter contract number	nvarchar	10	0	Allow NULL?
123	TRNSP_CT_NO10	Transporter contract number	nvarchar	10	0	Allow NULL?
124	INT_ENTL_MKCT_1	Gross Other Marketing Amount	decimal	11	2
125	INT_ENTL_MKCT_2	Gross Other Marketing Amount	decimal	11	2
126	INT_ENTL_MKCT_3	Gross Other Marketing Amount	decimal	11	2
127	INT_ENTL_MKCT_4	Gross Other Marketing Amount	decimal	11	2
128	INT_ENTL_MKCT_5	Gross Other Marketing Amount	decimal	11	2
129	INT_ENTL_MKCT_6	Gross Other Marketing Amount	decimal	11	2
130	INT_ENTL_MKCT_7	Gross Other Marketing Amount	decimal	11	2
131	INT_ENTL_MKCT_8	Gross Other Marketing Amount	decimal	11	2
132	INT_ENTL_MKCT_9	Gross Other Marketing Amount	decimal	11	2
133	INT_ENTL_MKCT_10	Gross Other Marketing Amount	decimal	11	2
134	EXT_ENTL_MKCT_1	Gross Other Marketing Amount	decimal	11	2
135	EXT_ENTL_MKCT_2	Gross Other Marketing Amount	decimal	11	2
136	EXT_ENTL_MKCT_3	Gross Other Marketing Amount	decimal	11	2
137	EXT_ENTL_MKCT_4	Gross Other Marketing Amount	decimal	11	2
138	EXT_ENTL_MKCT_5	Gross Other Marketing Amount	decimal	11	2
139	EXT_ENTL_MKCT_6	Gross Other Marketing Amount	decimal	11	2
140	EXT_ENTL_MKCT_7	Gross Other Marketing Amount	decimal	11	2
141	EXT_ENTL_MKCT_8	Gross Other Marketing Amount	decimal	11	2
142	EXT_ENTL_MKCT_9	Gross Other Marketing Amount	decimal	11	2
143	EXT_ENTL_MKCT_10	Gross Other Marketing Amount	decimal	11	2
144	EXT_ENTL_MCR_1	Gross Other Marketing Amount	decimal	11	2
145	EXT_ENTL_MCR_2	Gross Other Marketing Amount	decimal	11	2
146	EXT_ENTL_MCR_3	Gross Other Marketing Amount	decimal	11	2
147	EXT_ENTL_MCR_4	Gross Other Marketing Amount	decimal	11	2
148	EXT_ENTL_MCR_5	Gross Other Marketing Amount	decimal	11	2
149	EXT_ENTL_MCR_6	Gross Other Marketing Amount	decimal	11	2
150	EXT_ENTL_MCR_7	Gross Other Marketing Amount	decimal	11	2
151	EXT_ENTL_MCR_8	Gross Other Marketing Amount	decimal	11	2
152	EXT_ENTL_MCR_9	Gross Other Marketing Amount	decimal	11	2
153	EXT_ENTL_MCR_10	Gross Other Marketing Amount	decimal	11	2
154	INT_SETT_MKCT_1	Gross Other Marketing Amount	decimal	11	2
155	INT_SETT_MKCT_2	Gross Other Marketing Amount	decimal	11	2
156	INT_SETT_MKCT_3	Gross Other Marketing Amount	decimal	11	2
157	INT_SETT_MKCT_4	Gross Other Marketing Amount	decimal	11	2
158	INT_SETT_MKCT_5	Gross Other Marketing Amount	decimal	11	2
159	INT_SETT_MKCT_6	Gross Other Marketing Amount	decimal	11	2
160	INT_SETT_MKCT_7	Gross Other Marketing Amount	decimal	11	2
161	INT_SETT_MKCT_8	Gross Other Marketing Amount	decimal	11	2
162	INT_SETT_MKCT_9	Gross Other Marketing Amount	decimal	11	2
163	INT_SETT_MKCT_10	Gross Other Marketing Amount	decimal	11	2
164	EXT_SETT_MKCT_1	Gross Other Marketing Amount	decimal	11	2
165	EXT_SETT_MKCT_2	Gross Other Marketing Amount	decimal	11	2
166	EXT_SETT_MKCT_3	Gross Other Marketing Amount	decimal	11	2
167	EXT_SETT_MKCT_4	Gross Other Marketing Amount	decimal	11	2
168	EXT_SETT_MKCT_5	Gross Other Marketing Amount	decimal	11	2
169	EXT_SETT_MKCT_6	Gross Other Marketing Amount	decimal	11	2
170	EXT_SETT_MKCT_7	Gross Other Marketing Amount	decimal	11	2
171	EXT_SETT_MKCT_8	Gross Other Marketing Amount	decimal	11	2
172	EXT_SETT_MKCT_9	Gross Other Marketing Amount	decimal	11	2
173	EXT_SETT_MKCT_10	Gross Other Marketing Amount	decimal	11	2
174	EXT_SETT_MCR_1	Gross Other Marketing Amount	decimal	11	2
175	EXT_SETT_MCR_2	Gross Other Marketing Amount	decimal	11	2
176	EXT_SETT_MCR_3	Gross Other Marketing Amount	decimal	11	2
177	EXT_SETT_MCR_4	Gross Other Marketing Amount	decimal	11	2
178	EXT_SETT_MCR_5	Gross Other Marketing Amount	decimal	11	2
179	EXT_SETT_MCR_6	Gross Other Marketing Amount	decimal	11	2
180	EXT_SETT_MCR_7	Gross Other Marketing Amount	decimal	11	2
181	EXT_SETT_MCR_8	Gross Other Marketing Amount	decimal	11	2
182	EXT_SETT_MCR_9	Gross Other Marketing Amount	decimal	11	2
183	EXT_SETT_MCR_10	Gross Other Marketing Amount	decimal	11	2
184	SM_SETT_BTU_FAC	OIUH_DEC7_3	decimal	7	3
185	TOTAL_TAX_PC_1	Total tax percentage	decimal	9	8
186	TOTAL_TAX_PC_2	Total tax percentage	decimal	9	8
187	TOTAL_TAX_PC_3	Total tax percentage	decimal	9	8
188	TOTAL_TAX_PC_4	Total tax percentage	decimal	9	8
189	TOTAL_TAX_PC_5	Total tax percentage	decimal	9	8
190	TOTAL_TAX_PC_6	Total tax percentage	decimal	9	8
191	TOTAL_TAX_PC_7	Total tax percentage	decimal	9	8
192	TOTAL_TAX_PC_8	Total tax percentage	decimal	9	8
193	TOTAL_TAX_PC_9	Total tax percentage	decimal	9	8
194	TOTAL_TAX_PC_10	Total tax percentage	decimal	9	8
195	ACTL_ST_TAX_1	Tax amount	decimal	11	2
196	ACTL_ST_TAX_2	Tax amount	decimal	11	2
197	ACTL_ST_TAX_3	Tax amount	decimal	11	2
198	ACTL_ST_TAX_4	Tax amount	decimal	11	2
199	ACTL_ST_TAX_5	Tax amount	decimal	11	2
200	ACTL_ST_TAX_6	Tax amount	decimal	11	2
201	ACTL_ST_TAX_7	Tax amount	decimal	11	2
202	ACTL_ST_TAX_8	Tax amount	decimal	11	2
203	ACTL_ST_TAX_9	Tax amount	decimal	11	2
204	ACTL_ST_TAX_10	Tax amount	decimal	11	2
205	ACTL_ST_TAX_RM_1	Tax amount	decimal	11	2
206	ACTL_ST_TAX_RM_2	Tax amount	decimal	11	2
207	ACTL_ST_TAX_RM_3	Tax amount	decimal	11	2
208	ACTL_ST_TAX_RM_4	Tax amount	decimal	11	2
209	ACTL_ST_TAX_RM_5	Tax amount	decimal	11	2
210	ACTL_ST_TAX_RM_6	Tax amount	decimal	11	2
211	ACTL_ST_TAX_RM_7	Tax amount	decimal	11	2
212	ACTL_ST_TAX_RM_8	Tax amount	decimal	11	2
213	ACTL_ST_TAX_RM_9	Tax amount	decimal	11	2
214	ACTL_ST_TAX_RM10	Tax amount	decimal	11	2
215	GROSS_ST_TAX_1	Tax amount	decimal	11	2
216	GROSS_ST_TAX_2	Tax amount	decimal	11	2
217	GROSS_ST_TAX_3	Tax amount	decimal	11	2
218	GROSS_ST_TAX_4	Tax amount	decimal	11	2
219	GROSS_ST_TAX_5	Tax amount	decimal	11	2
220	GROSS_ST_TAX_6	Tax amount	decimal	11	2
221	GROSS_ST_TAX_7	Tax amount	decimal	11	2
222	GROSS_ST_TAX_8	Tax amount	decimal	11	2
223	GROSS_ST_TAX_9	Tax amount	decimal	11	2
224	GROSS_ST_TAX_10	Tax amount	decimal	11	2
225	VL_TAX_RATE_PC_1	Volume tax rate	decimal	7	6
226	VL_TAX_RATE_PC_2	Volume tax rate	decimal	7	6
227	VL_TAX_RATE_PC_3	Volume tax rate	decimal	7	6
228	VL_TAX_RATE_PC_4	Volume tax rate	decimal	7	6
229	VL_TAX_RATE_PC_5	Volume tax rate	decimal	7	6
230	VL_TAX_RATE_PC_6	Volume tax rate	decimal	7	6
231	VL_TAX_RATE_PC_7	Volume tax rate	decimal	7	6
232	VL_TAX_RATE_PC_8	Volume tax rate	decimal	7	6
233	VL_TAX_RATE_PC_9	Volume tax rate	decimal	7	6
234	VL_TAX_RATE_PC10	Volume tax rate	decimal	7	6
235	ENTL_ST_TAX_1	Tax amount	decimal	11	2
236	ENTL_ST_TAX_2	Tax amount	decimal	11	2
237	ENTL_ST_TAX_3	Tax amount	decimal	11	2
238	ENTL_ST_TAX_4	Tax amount	decimal	11	2
239	ENTL_ST_TAX_5	Tax amount	decimal	11	2
240	ENTL_ST_TAX_6	Tax amount	decimal	11	2
241	ENTL_ST_TAX_7	Tax amount	decimal	11	2
242	ENTL_ST_TAX_8	Tax amount	decimal	11	2
243	ENTL_ST_TAX_9	Tax amount	decimal	11	2
244	ENTL_ST_TAX_10	Tax amount	decimal	11	2
245	ENTL_ST_TAX_RM_1	Tax amount	decimal	11	2
246	ENTL_ST_TAX_RM_2	Tax amount	decimal	11	2
247	ENTL_ST_TAX_RM_3	Tax amount	decimal	11	2
248	ENTL_ST_TAX_RM_4	Tax amount	decimal	11	2
249	ENTL_ST_TAX_RM_5	Tax amount	decimal	11	2
250	ENTL_ST_TAX_RM_6	Tax amount	decimal	11	2
251	ENTL_ST_TAX_RM_7	Tax amount	decimal	11	2
252	ENTL_ST_TAX_RM_8	Tax amount	decimal	11	2
253	ENTL_ST_TAX_RM_9	Tax amount	decimal	11	2
254	ENTL_ST_TAX_RM10	Tax amount	decimal	11	2
255	SETT_ST_TAX_1	Tax amount	decimal	11	2
256	SETT_ST_TAX_2	Tax amount	decimal	11	2
257	SETT_ST_TAX_3	Tax amount	decimal	11	2
258	SETT_ST_TAX_4	Tax amount	decimal	11	2
259	SETT_ST_TAX_5	Tax amount	decimal	11	2
260	SETT_ST_TAX_6	Tax amount	decimal	11	2
261	SETT_ST_TAX_7	Tax amount	decimal	11	2
262	SETT_ST_TAX_8	Tax amount	decimal	11	2
263	SETT_ST_TAX_9	Tax amount	decimal	11	2
264	SETT_ST_TAX_10	Tax amount	decimal	11	2
265	SETT_ST_TAX_RM_1	Tax amount	decimal	11	2
266	SETT_ST_TAX_RM_2	Tax amount	decimal	11	2
267	SETT_ST_TAX_RM_3	Tax amount	decimal	11	2
268	SETT_ST_TAX_RM_4	Tax amount	decimal	11	2
269	SETT_ST_TAX_RM_5	Tax amount	decimal	11	2
270	SETT_ST_TAX_RM_6	Tax amount	decimal	11	2
271	SETT_ST_TAX_RM_7	Tax amount	decimal	11	2
272	SETT_ST_TAX_RM_8	Tax amount	decimal	11	2
273	SETT_ST_TAX_RM_9	Tax amount	decimal	11	2
274	SETT_ST_TAX_RM10	Tax amount	decimal	11	2
275	SM_RCVBL_MP	Measurement point number	nvarchar	20	0	Allow NULL?
276	TOT_TAX_RM_PC_1	Total tax reimbursement percentage	decimal	9	8
277	TOT_TAX_RM_PC_2	Total tax reimbursement percentage	decimal	9	8
278	TOT_TAX_RM_PC_3	Total tax reimbursement percentage	decimal	9	8
279	TOT_TAX_RM_PC_4	Total tax reimbursement percentage	decimal	9	8
280	TOT_TAX_RM_PC_5	Total tax reimbursement percentage	decimal	9	8
281	TOT_TAX_RM_PC_6	Total tax reimbursement percentage	decimal	9	8
282	TOT_TAX_RM_PC_7	Total tax reimbursement percentage	decimal	9	8
283	TOT_TAX_RM_PC_8	Total tax reimbursement percentage	decimal	9	8
284	TOT_TAX_RM_PC_9	Total tax reimbursement percentage	decimal	9	8
285	TOT_TAX_RM_PC_10	Total tax reimbursement percentage	decimal	9	8
286	GPLT_VNAME	Gas Plant Venture	nvarchar	6	0	Allow NULL?
287	GPLT_DOI_DOI	Gasplant DOI No	nvarchar	5	0	Allow NULL?
288	ACTL_WLR_VL_AM	JE Transaction Amount	decimal	11	2
289	ENTL_WLR_VL_AM	JE Transaction Amount	decimal	11	2
290	SETT_WLR_VL_AM	JE Transaction Amount	decimal	11	2
291	EXT_PROP_NO_1	External venture name	nvarchar	6	0	Allow NULL?
292	EXT_DOI_NO_1	External division of interest number	nvarchar	5	0	Allow NULL?
293	EXT_PROP_NO_2	External venture name	nvarchar	6	0	Allow NULL?
294	EXT_DOI_NO_2	External division of interest number	nvarchar	5	0	Allow NULL?
295	EXT_PROP_NO_3	External venture name	nvarchar	6	0	Allow NULL?
296	EXT_DOI_NO_3	External division of interest number	nvarchar	5	0	Allow NULL?
297	EXT_PROP_NO_4	External venture name	nvarchar	6	0	Allow NULL?
298	EXT_DOI_NO_4	External division of interest number	nvarchar	5	0	Allow NULL?
299	EXT_PROP_NO_5	External venture name	nvarchar	6	0	Allow NULL?
300	EXT_DOI_NO_5	External division of interest number	nvarchar	5	0	Allow NULL?
301	EXT_PROP_NO_6	External venture name	nvarchar	6	0	Allow NULL?
302	EXT_DOI_NO_6	External division of interest number	nvarchar	5	0	Allow NULL?
303	EXT_PROP_NO_7	External venture name	nvarchar	6	0	Allow NULL?
304	EXT_DOI_NO_7	External division of interest number	nvarchar	5	0	Allow NULL?
305	EXT_PROP_NO_8	External venture name	nvarchar	6	0	Allow NULL?
306	EXT_DOI_NO_8	External division of interest number	nvarchar	5	0	Allow NULL?
307	EXT_PROP_NO_9	External venture name	nvarchar	6	0	Allow NULL?
308	EXT_DOI_NO_9	External division of interest number	nvarchar	5	0	Allow NULL?
309	EXT_PROP_NO_10	External venture name	nvarchar	6	0	Allow NULL?
310	EXT_DOI_NO_10	External division of interest number	nvarchar	5	0	Allow NULL?
311	INT_PROP_NO_1	Internal venture name	nvarchar	6	0	Allow NULL?
312	INT_DOI_NO_1	Internal division of interest number	nvarchar	5	0	Allow NULL?
313	INT_PROP_NO_2	Internal venture name	nvarchar	6	0	Allow NULL?
314	INT_DOI_NO_2	Internal division of interest number	nvarchar	5	0	Allow NULL?
315	INT_PROP_NO_3	Internal venture name	nvarchar	6	0	Allow NULL?
316	INT_DOI_NO_3	Internal division of interest number	nvarchar	5	0	Allow NULL?
317	INT_PROP_NO_4	Internal venture name	nvarchar	6	0	Allow NULL?
318	INT_DOI_NO_4	Internal division of interest number	nvarchar	5	0	Allow NULL?
319	INT_PROP_NO_5	Internal venture name	nvarchar	6	0	Allow NULL?
320	INT_DOI_NO_5	Internal division of interest number	nvarchar	5	0	Allow NULL?
321	INT_PROP_NO_6	Internal venture name	nvarchar	6	0	Allow NULL?
322	INT_DOI_NO_6	Internal division of interest number	nvarchar	5	0	Allow NULL?
323	INT_PROP_NO_7	Internal venture name	nvarchar	6	0	Allow NULL?
324	INT_DOI_NO_7	Internal division of interest number	nvarchar	5	0	Allow NULL?
325	INT_PROP_NO_8	Internal venture name	nvarchar	6	0	Allow NULL?
326	INT_DOI_NO_8	Internal division of interest number	nvarchar	5	0	Allow NULL?
327	INT_PROP_NO_9	Internal venture name	nvarchar	6	0	Allow NULL?
328	INT_DOI_NO_9	Internal division of interest number	nvarchar	5	0	Allow NULL?
329	INT_PROP_NO_10	Internal venture name	nvarchar	6	0	Allow NULL?
330	INT_DOI_NO_10	Internal division of interest number	nvarchar	5	0	Allow NULL?
331	SM_REMITTER_NO	Seller Number	nvarchar	6	0	Allow NULL?
332	SM_REMITT_SEQ_NO	Seller Sequence Number	nvarchar	2	0	Allow NULL?
333	GASLIFT_WL_NO	Well ID number	nvarchar	15	0	Allow NULL?
334	GASLIFT_WC_NO	Well Completion Number	nvarchar	5	0	Allow NULL?
335	RELATED_CT	Related Contract	nvarchar	10	0	Allow NULL?
336	CT_TYPE_CD	Contract Type	nvarchar	2	0	Allow NULL?
337	DOI_SUM_FL	OIUH_CHAR1	char	1	0	Allow NULL?
338	DUAL_ACCT_FL	Dual Accounting Flag	char	1	0	Allow NULL?
339	ORIG_MP_NO	Measurement point number	nvarchar	20	0	Allow NULL?
340	VNAME_TYPE_CD	Venture Usage Type	nvarchar	2	0	Allow NULL?
341	SM_TAX_GRNT_FL	OIUH_CHAR1	char	1	0	Allow NULL?
342	TAX_RMB_GRNT	OIUH_CHAR1	char	1	0	Allow NULL?
343	SM_NRTF_CD	OIUH_CHAR1	char	1	0	Allow NULL?
344	SM_REC_PYMT_CD	OIUH_CHAR1	char	1	0	Allow NULL?
345	IGN_PYMT_CD	OIUH_CHAR1	char	1	0	Allow NULL?
346	BY_SLL_CT_NO	Buy/Sell Contract	nvarchar	10	0	Allow NULL?
347	BY_SLL_VAL	Buy/Sell Value	decimal	13	2
348	BRD_CD	Brand Code	nvarchar	4	0	Allow NULL?
349	SM_LSE_VOL	JE Transaction Quantity	decimal	11	2
350	SM_LSE_VAL	JE Transaction Amount	decimal	11	2
351	SM_PCT_RET_LSE	Percent Returned to Lease	decimal	7	4
352	SM_TIK_PA_PC	Processing Agreements Percent	decimal	7	3
353	SM_ENTL_CT_DECM	Contract Decimal	decimal	9	8
354	SM_RM_FEE_FL	OIUH_CHAR1	char	1	0	Allow NULL?
355	SECT_VNAME	Joint Venture	nvarchar	6	0	Allow NULL?
356	SECT_DOI_NO	Division of interest (DOI)	nvarchar	5	0	Allow NULL?
357	COST_CENTER	Cost Center	nvarchar	10	0	Allow NULL?
358	UNIT_OF_MEAS_CD	Unit of Measure Code	nvarchar	3	0	Allow NULL?
359	ACTL_PTR_VL_AM	JE Transaction Amount	decimal	11	2
360	ENTL_PTR_VL_AM	JE Transaction Amount	decimal	11	2
361	SETT_PTR_VL_AM	JE Transaction Amount	decimal	11	2

TOP ERP 6.0 | OIURV_DOC_RDSUM INDEXES

Name	Primary	Unique	Type	Columns
OIURV_DOC_RDSUM~0	Yes	Yes	CLUSTERED	LINE_NO, DOC_YEAR, DOC_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

361 COLUMNS | 1 INDEXES | ERP 6.0 | OIURV_DOC_RDSUM TABLE

TOP ERP 6.0 | OIURV_DOC_RDSUM COLUMNS

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

361 COLUMNS | 1 INDEXES | ERP 6.0 | OIURV_DOC_RDSUM TABLE

TOPERP 6.0 | OIURV_DOC_RDSUM COLUMNS

TOPERP 6.0 | OIURV_DOC_RDSUM INDEXES

TOP ERP 6.0 | OIURV_DOC_RDSUM COLUMNS

TOP ERP 6.0 | OIURV_DOC_RDSUM INDEXES