OIUY6_WY_INTSTG - Royalty 2.0 - WY - Royalty Transaction Interface (Staging)

Royalty 2.0 - WY - Royalty Transaction Interface (Staging) information is stored in SAP table OIUY6_WY_INTSTG.
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_INTSTG

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6T000
OR_LVL_1_NOCompany Name CodeXOIUH_COMPANYCHAR6
ACCT_PERD_DTAccounting Period(YYYYMM01)XOIUH_ACCOUNTING_PERIOD8CHAR16
BTCH_NOBatch IDXOIUH_BATCH_IDCHAR8
LE_NOJournal Entry Line NumberXOIUH_JELINENOCHAR16
.INCLUDEROIUY6_WY_ROYTXN_KEYROIUY6_WY_ROYTXN_KEY0
.INCLUDEROIUY6_WY_REVTXN_KEYROIUY6_WY_REVTXN_KEY0
BUKRSCompany CodeBUKRSCHAR8OIU_CM_COMPC
SALES_DTSales Date / MonthOIU_SALE_DTDATS16
PDCDFull three char. product code (Major and Detail Products)OIU_FULL_PD_CDCHAR6OIUX3_PDCD
WL_NOWell ID numberOIU_WL_NOCHAR30OIU_PR_WELL
WC_NOWell Completion NumberOIU_WC_NOCHAR10OIU_PR_WC
MP_NOMeasurement point numberOIU_MP_NOCHAR40OIU_PR_MP
VNAMEJoint ventureJV_NAMECHAR12OIU_DO_JV
DOI_NODivision of interest (DOI)OIU_DOI_NOCHAR10OIU_DO_DI
DN_NODelivery network numberOIU_DN_NOCHAR40OIU_PR_DN
CT_NOContract NumberOIU_CT_NOCHAR20OIU_RV_CT
VL_TYPE_CDVolume type codeOIU_VT_CDCHAR4OIU_PR_VLTYP
OWNER_IDENTIFIERRoyalty 2.0 - Owner IdentifierOIUYC_OWNER_IDENTIFIERCHAR44
.INCLUDEROIUY6_WY_ROYTXN_NONKEYROIUY6_WY_ROYTXN_NONKEY0
UNIT_VNAMEJoint ventureJV_NAMECHAR12*
ACCT_NOAccount IDOIUH_ACCTIDCHAR20
UOMMeasurement unitOIU_MEAS_UUNIT6T006
GR_QYGross VolumeOIUX3_GROSS_VOLUMEDEC6
GR_AMGross ValueOIUX3_GROSS_VALUECURR6
DED_RMB_AMDeduction/Reimbursement AmountOIUH_DED_REIMB_AMOUNTCURR6
TAX_RMB_AMTax Reimbursement AmountOIUH_TAX_REIMBURSEMENT_AMTCURR6
NET_TRANSP_AMMarketing CostOIUX3_MARKETING_COSTCURR6
NET_OTH_MK_AMMarketing CostOIUX3_MARKETING_COSTCURR6
MKT_COST_01Marketing CostOIUX3_MARKETING_COSTCURR6
MKT_COST_02Marketing CostOIUX3_MARKETING_COSTCURR6
MKT_COST_03Marketing CostOIUX3_MARKETING_COSTCURR6
MKT_COST_04Marketing CostOIUX3_MARKETING_COSTCURR6
MKT_COST_05Marketing CostOIUX3_MARKETING_COSTCURR6
MKT_COST_06Marketing CostOIUX3_MARKETING_COSTCURR6
MKT_COST_07Marketing CostOIUX3_MARKETING_COSTCURR6
MKT_COST_08Marketing CostOIUX3_MARKETING_COSTCURR6
MKT_COST_09Marketing CostOIUX3_MARKETING_COSTCURR6
MKT_COST_10Marketing CostOIUX3_MARKETING_COSTCURR6
TXN_VAL_AMRoyalty 2.0 - WY - Owner Gross ValueOIUY6_WY_OWNER_GROSS_VALUECURR6
OWN_INT_DECM_QYRoyalty 2.0 - Wyoming - Owner NRIOIUY6_WY_OWNER_NRIDEC5
TRANS_AMJE Transaction AmountOIUX3_TRANS_AMTDEC6
TRANS_QYJE Transaction QuantityOIUH_TRANS_QUANTITYDEC6
BTU_QYBTU QuantityOIUH_BTU_QUANTITYDEC4
PS_BASE_QYPressure Base QuantityOIUH_PRESSURE_BASEDEC4
GRV_QYGravityOIUH_GRAVITYDEC2
PAY_CDPay CodeOIUH_PAY_CODECHAR4
OWN_BAL_DECM_QYOwner Disbursement (Balance) DecimalOIUH_OWNER_DISBUR_DECIMALDEC5
MMBTU_OVL_AMOwner MMBTUOIUH_OWNER_MMBTUDEC6
OPERATED_FLRoyalty 2.0 - WY - Operated FlagOIUY6_OPERATED_FLAGCHAR2
OPERATOR_NAMERoyalty 2.0 - WY - Operator NameOIUY6_WY_OPERATOR_NAMECHAR76
.INCLUDEROIUY6_WY_MASTER_SUBKEYROIUY6_WY_MASTER_SUBKEY0
STATE_LEASE_NORoyalty 2.0 - Wyoming - State Lease NumberOIUY6_WY_STATE_LEASE_NOCHAR30
UNIQUE_IDRoyalty 2.0 - Wyoming - PSAOIUY6_WY_UNIQUE_IDENTIFIERCHAR40
.INCLUDEROIUY6_WY_MASTER_NONKEYROIUY6_WY_MASTER_NONKEY0
REPORT_ONLYRoyalty 2.0 - WY - Report Only FlagOIUY6_WY_REPORT_ONLY_FLCHAR2
OVERRIDE_FLRoyalty 2.0 - WY - Override Operated FlagOIUY6_WY_OVERRIDE_OPERATED_FLCHAR2
TRACT_ALLOC_LSERoyalty 2.0 - Wyoming - Tract Allocation to LeaseOIUY6_WY_TRACT_ALLOC_TO_LEASEDEC5
ROYALTY_RATERoyalty 2.0 - Wyoming - Royalty RateOIUY6_WY_ROYALTY_RATEDEC5
ALLOC_PERCENTRoyalty 2.0 - Wyoming - Allocation PercentOIUY6_WY_ALLOCATION_PERCENTDEC5
REFERENCE_FIELDRoyalty 2.0 - WY - Reference FieldOIUY6_WY_REFERENCE_FIELDCHAR70
ALTERNATE_PSARoyalty 2.0 - Wyoming - Alternate PSAOIUY6_WY_ALTERNATE_PSACHAR40
CTRACT_ALLOC_LSERoyalty 2.0 - Wyoming - Calculated Tract Allocation to LeaseOIUY6_WY_CALC_TRACT_ALLOC_LSEDEC5
MASTER_LEVELRoyalty 2.0 - WY - Master LevelOIUY6_WY_MASTER_LEVELCHAR2
WY_PDCDRoyalty 2.0 - Wyoming - Product CodeOIUY6_WY_PRODUCT_CODENUMC6
PAYER_CODERoyalty 2.0 - Wyoming - Payer CodeOIUY6_WY_PAYER_CODENUMC8
ORIGINAL_REPORTRoyalty 2.0 - WY - Original ReportOIUY6_WY_ORIGINAL_REPORTCHAR2
DOC_NOVal. document numberOIURV_DOCNRCHAR40*
DOC_YEARDocument yearOIU_DOC_YEARNUMC8
INTERFACE_FLRoyalty 2.0 - WY - Interface FlagOIUY6_WY_INTERFACE_FLCHAR2
OPTION1CHAR2
OPTION2PPN FlagCHAR2
OPTION3CHAR2
.INCLUDEOIU_CREATIONOIU_CREATION0
OIU_CRUSERName of Person Responsible for Creating the ObjectERNAMCHAR24
OIU_TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)TZNTSTMPSDEC8
Privacy Policy