OIUY6_WY_ROYTXN - Royalty 2.0 - WY - Royalty Transactions
Royalty 2.0 - WY - Royalty Transactions information is stored in SAP table OIUY6_WY_ROYTXN.
It is part of development package OIU_Y6 in software component IS-OIL-PRA-REP-ROY. This development package consists of objects that can be grouped under "Royalty 2.0 - WY".
It is part of development package OIU_Y6 in software component IS-OIL-PRA-REP-ROY. This development package consists of objects that can be grouped under "Royalty 2.0 - WY".
Fields for table OIUY6_WY_ROYTXN
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | Client | X | MANDT | CLNT | 6 | T000 |
.INCLUDE | ROIUY6_WY_ROYTXN_KEY | X | ROIUY6_WY_ROYTXN_KEY | 0 | ||
.INCLUDE | ROIUY6_WY_REVTXN_KEY | X | ROIUY6_WY_REVTXN_KEY | 0 | ||
BUKRS | Company Code | X | BUKRS | CHAR | 8 | OIU_CM_COMPC |
SALES_DT | Sales Date / Month | X | OIU_SALE_DT | DATS | 16 | |
PDCD | Full three char. product code (Major and Detail Products) | X | OIU_FULL_PD_CD | CHAR | 6 | OIUX3_PDCD |
WL_NO | Well ID number | X | OIU_WL_NO | CHAR | 30 | OIU_PR_WELL |
WC_NO | Well Completion Number | X | OIU_WC_NO | CHAR | 10 | OIU_PR_WC |
MP_NO | Measurement point number | X | OIU_MP_NO | CHAR | 40 | OIU_PR_MP |
VNAME | Joint venture | X | JV_NAME | CHAR | 12 | OIU_DO_JV |
DOI_NO | Division of interest (DOI) | X | OIU_DOI_NO | CHAR | 10 | OIU_DO_DI |
DN_NO | Delivery network number | X | OIU_DN_NO | CHAR | 40 | OIU_PR_DN |
CT_NO | Contract Number | X | OIU_CT_NO | CHAR | 20 | OIU_RV_CT |
VL_TYPE_CD | Volume type code | X | OIU_VT_CD | CHAR | 4 | OIU_PR_VLTYP |
OWNER_IDENTIFIER | Royalty 2.0 - Owner Identifier | X | OIUYC_OWNER_IDENTIFIER | CHAR | 44 | |
REV_BOOK_ADJ_IND | Royalty 2.0 - WY - Reversal/Booking/Reversal Adjustment/Adjs | X | OIUY6_REV_BOOK_REVADJ_ADJ_IND | CHAR | 2 | |
.INCLUDE | ROIUY6_WY_ROYTXN_NONKEY | ROIUY6_WY_ROYTXN_NONKEY | 0 | |||
UNIT_VNAME | Joint venture | JV_NAME | CHAR | 12 | OIU_DO_JV | |
ACCT_NO | Account ID | OIUH_ACCTID | CHAR | 20 | ||
UOM | Measurement unit | OIU_MEAS_U | UNIT | 6 | T006 | |
GR_QY | Gross Volume | OIUX3_GROSS_VOLUME | DEC | 6 | ||
GR_AM | Gross Value | OIUX3_GROSS_VALUE | CURR | 6 | ||
DED_RMB_AM | Deduction/Reimbursement Amount | OIUH_DED_REIMB_AMOUNT | CURR | 6 | ||
TAX_RMB_AM | Tax Reimbursement Amount | OIUH_TAX_REIMBURSEMENT_AMT | CURR | 6 | ||
NET_TRANSP_AM | Marketing Cost | OIUX3_MARKETING_COST | CURR | 6 | ||
NET_OTH_MK_AM | Marketing Cost | OIUX3_MARKETING_COST | CURR | 6 | ||
MKT_COST_01 | Marketing Cost | OIUX3_MARKETING_COST | CURR | 6 | ||
MKT_COST_02 | Marketing Cost | OIUX3_MARKETING_COST | CURR | 6 | ||
MKT_COST_03 | Marketing Cost | OIUX3_MARKETING_COST | CURR | 6 | ||
MKT_COST_04 | Marketing Cost | OIUX3_MARKETING_COST | CURR | 6 | ||
MKT_COST_05 | Marketing Cost | OIUX3_MARKETING_COST | CURR | 6 | ||
MKT_COST_06 | Marketing Cost | OIUX3_MARKETING_COST | CURR | 6 | ||
MKT_COST_07 | Marketing Cost | OIUX3_MARKETING_COST | CURR | 6 | ||
MKT_COST_08 | Marketing Cost | OIUX3_MARKETING_COST | CURR | 6 | ||
MKT_COST_09 | Marketing Cost | OIUX3_MARKETING_COST | CURR | 6 | ||
MKT_COST_10 | Marketing Cost | OIUX3_MARKETING_COST | CURR | 6 | ||
TXN_VAL_AM | Royalty 2.0 - WY - Owner Gross Value | OIUY6_WY_OWNER_GROSS_VALUE | CURR | 6 | ||
OWN_INT_DECM_QY | Royalty 2.0 - Wyoming - Owner NRI | OIUY6_WY_OWNER_NRI | DEC | 5 | ||
TRANS_AM | JE Transaction Amount | OIUX3_TRANS_AMT | DEC | 6 | ||
TRANS_QY | JE Transaction Quantity | OIUH_TRANS_QUANTITY | DEC | 6 | ||
BTU_QY | BTU Quantity | OIUH_BTU_QUANTITY | DEC | 4 | ||
PS_BASE_QY | Pressure Base Quantity | OIUH_PRESSURE_BASE | DEC | 4 | ||
GRV_QY | Gravity | OIUH_GRAVITY | DEC | 2 | ||
PAY_CD | Pay Code | OIUH_PAY_CODE | CHAR | 4 | ||
OWN_BAL_DECM_QY | Owner Disbursement (Balance) Decimal | OIUH_OWNER_DISBUR_DECIMAL | DEC | 5 | ||
MMBTU_OVL_AM | Owner MMBTU | OIUH_OWNER_MMBTU | DEC | 6 | ||
OPERATED_FL | Royalty 2.0 - WY - Operated Flag | OIUY6_OPERATED_FLAG | CHAR | 2 | ||
OPERATOR_NAME | Royalty 2.0 - WY - Operator Name | OIUY6_WY_OPERATOR_NAME | CHAR | 76 | ||
.INCLUDE | ROIUY6_WY_MASTER_SUBKEY | ROIUY6_WY_MASTER_SUBKEY | 0 | |||
STATE_LEASE_NO | Royalty 2.0 - Wyoming - State Lease Number | OIUY6_WY_STATE_LEASE_NO | CHAR | 30 | ||
UNIQUE_ID | Royalty 2.0 - Wyoming - PSA | OIUY6_WY_UNIQUE_IDENTIFIER | CHAR | 40 | ||
.INCLUDE | ROIUY6_WY_MASTER_NONKEY | ROIUY6_WY_MASTER_NONKEY | 0 | |||
REPORT_ONLY | Royalty 2.0 - WY - Report Only Flag | OIUY6_WY_REPORT_ONLY_FL | CHAR | 2 | ||
OVERRIDE_FL | Royalty 2.0 - WY - Override Operated Flag | OIUY6_WY_OVERRIDE_OPERATED_FL | CHAR | 2 | ||
TRACT_ALLOC_LSE | Royalty 2.0 - Wyoming - Tract Allocation to Lease | OIUY6_WY_TRACT_ALLOC_TO_LEASE | DEC | 5 | ||
ROYALTY_RATE | Royalty 2.0 - Wyoming - Royalty Rate | OIUY6_WY_ROYALTY_RATE | DEC | 5 | ||
ALLOC_PERCENT | Royalty 2.0 - Wyoming - Allocation Percent | OIUY6_WY_ALLOCATION_PERCENT | DEC | 5 | ||
REFERENCE_FIELD | Royalty 2.0 - WY - Reference Field | OIUY6_WY_REFERENCE_FIELD | CHAR | 70 | ||
ALTERNATE_PSA | Royalty 2.0 - Wyoming - Alternate PSA | OIUY6_WY_ALTERNATE_PSA | CHAR | 40 | ||
CTRACT_ALLOC_LSE | Royalty 2.0 - Wyoming - Calculated Tract Allocation to Lease | OIUY6_WY_CALC_TRACT_ALLOC_LSE | DEC | 5 | ||
MASTER_LEVEL | Royalty 2.0 - WY - Master Level | OIUY6_WY_MASTER_LEVEL | CHAR | 2 | ||
WY_PDCD | Royalty 2.0 - Wyoming - Product Code | OIUY6_WY_PRODUCT_CODE | NUMC | 6 | ||
PAYER_CODE | Royalty 2.0 - Wyoming - Payer Code | OIUY6_WY_PAYER_CODE | NUMC | 8 | ||
ORIGINAL_REPORT | Royalty 2.0 - WY - Original Report | OIUY6_WY_ORIGINAL_REPORT | CHAR | 2 | ||
DOC_NO | Val. document number | OIURV_DOCNR | CHAR | 40 | * | |
DOC_YEAR | Document year | OIU_DOC_YEAR | NUMC | 8 | ||
INTERFACE_FL | Royalty 2.0 - WY - Interface Flag | OIUY6_WY_INTERFACE_FL | CHAR | 2 | ||
OPTION1 | CHAR | 2 | ||||
OPTION2 | PPN Flag | CHAR | 2 | |||
OPTION3 | CHAR | 2 | ||||
REJ_SUSP_IND | Rejection-Suspension Status | OIUX3_REJECT_SUSPEND_IND | CHAR | 2 | ||
REJ_CD | Royalty 2.0 - WY - Reject Code | OIUY6_WY_REJECT_CODE | CHAR | 4 | OIUY6_WY_REJ | |
.INCLUDE | OIU_CREATION | OIU_CREATION | 0 | |||
OIU_CRUSER | Name of Person Responsible for Creating the Object | ERNAM | CHAR | 24 | ||
OIU_TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | DEC | 8 |