OIUX6_WY_MASTER

Tax 2.0 - Wyoming Master Data | #masterdata | Component: Tax Reporting

🔑 Keys (9)
💰 Amounts
∑ Quantities
📅 Dates (4)
☰ Categorical (3)
Other (9)
🔗 Relations (8)

Column Name	Description
MANDT FK	Client
OGIND	Oil and Gas Indicator	Show values
WL_NO FK	Well ID number
WC_NO FK	Well Completion Number
MP_NO FK	Measurement point number
BUKRS FK	Company Code
VNAME FK	Joint venture
DOI_NO FK	Division of interest (DOI)
EFF_FROM_DT	Effective from date

Column Name	Description

Column Name	Description

Column Name	Description
EFF_FROM_DT	Effective from date
EFF_TO_DT	Effective To Date
CHANGE_DATE	Date of Last Change
CHANGE_TIME	Time of Last Change

Column Name	Description
OGIND	Oil and Gas Indicator	Show values
OPERATED_FLAG	Tax 2.0 - Operated Flag	Show values
PLANT_CD_EXISTS	Tax 2.0 - Wyoming Plant Code Exists flag	Show values

Column Name	Description	Domain name
API_WELL_NUMBER	Tax 2.0 - Wyoming API Well Number
SIDE_TRACK_NO	Tax 2.0 - Wyoming Side Track Number
RESERVOIR	Tax 2.0 - Wyoming Reservoir
RPT_GRP_NO	Tax 2.0 - Wyoming Report Group Number	OIUX6_WY_REPORT_GROUP_NUMBER
FIELD_NAME	Tax 2.0 - Wyoming Field Name
LEASE_UNIT_NAME	Tax 2.0 - Wyoming Lease Unit Name / API	CHAR35
TAX_DISTRICT	Tax 2.0 - Wyoming Tax District	NUMC4
GAS_PLANT_NAME	Tax 2.0 - WY Gas Plant Name
CHANGE_USER	Last Changed By	USNAM

Master Data Relations	Join Conditions
Company Code	`OIUX6_WY_MASTER.MANDT == OIU_CM_COMPC.MANDT` `OIUX6_WY_MASTER.BUKRS == OIU_CM_COMPC.BUKRS`
Tax 2.0 - Wyoming County Identifier ? Client ? Tax 2.0 - Wyoming County Identifier	`OIUX6_WY_MASTER.[column in domain "LAND1"] == OIU_CM_LXSGL.LAND1` `OIUX6_WY_MASTER.MANDT == OIU_CM_LXSGL.MANDT` `OIUX6_WY_MASTER.[column in domain "OIU_PRI_GEO_LOC"] == OIU_CM_LXSGL.PRI_GEO_LOC` `OIUX6_WY_MASTER.COUNTY == OIU_CM_LXSGL.SEC_GEO_LOC`
Division of interest (DOI) Joint venture Division of interest (DOI) Company Code	`OIUX6_WY_MASTER.MANDT == OIU_DO_DI.MANDT` `OIUX6_WY_MASTER.VNAME == OIU_DO_DI.VNAME` `OIUX6_WY_MASTER.DOI_NO == OIU_DO_DI.DOI_NO` `OIUX6_WY_MASTER.BUKRS == OIU_DO_DI.BUKRS`
Client	`OIUX6_WY_MASTER.MANDT == T000.MANDT`
Measurement point number	`OIUX6_WY_MASTER.MANDT == OIU_PR_MP.MANDT` `OIUX6_WY_MASTER.MP_NO == OIU_PR_MP.MP_NO`
Joint venture Joint venture Company Code	`OIUX6_WY_MASTER.MANDT == OIU_DO_JV.MANDT` `OIUX6_WY_MASTER.VNAME == OIU_DO_JV.VNAME` `OIUX6_WY_MASTER.BUKRS == OIU_DO_JV.BUKRS`
Well Completion Number Well ID number Well Completion Number	`OIUX6_WY_MASTER.MANDT == OIU_PR_WC.MANDT` `OIUX6_WY_MASTER.WL_NO == OIU_PR_WC.WL_NO` `OIUX6_WY_MASTER.WC_NO == OIU_PR_WC.WC_NO`
Well ID number	`OIUX6_WY_MASTER.MANDT == OIU_PR_WELL.MANDT` `OIUX6_WY_MASTER.WL_NO == OIU_PR_WELL.WL_NO`