OIUREP_AGY_LSE - Agency assigned Leases
Agency assigned Leases information is stored in SAP table OIUREP_AGY_LSE.
It is part of development package OIU_REP in software component IS-OIL-PRA-REP-ROY. This development package consists of objects that can be grouped under "Production, Tax & Royalty Reporting".
It is part of development package OIU_REP in software component IS-OIL-PRA-REP-ROY. This development package consists of objects that can be grouped under "Production, Tax & Royalty Reporting".
Fields for table OIUREP_AGY_LSE
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| AGENCY | Agency for Reporting | X | OIUREP_ROY_AGENCY | CHAR | 6 | OIUREP_ROY_AGY |
| AGENCY_LEASE | Agency assigned Lease No. | X | OIUREP_AGENCY_LEASE | CHAR | 30 | |
| RRC_LEASE_NO | RRC Oil Lease | OIUH_RRC_OIL_LEASE | CHAR | 14 | ||
| RRC_WL_LSE_NO | Gas Well Number (RRC) | OIUH_GAS_WELL_NO_RRC | CHAR | 18 | ||
| RRC_DIST_CD | RRC District ID | OIUH_RRC_DISTRICT_ID | CHAR | 6 | ||
| FIELD_ID | Field ID | OIU_FIELDID | CHAR | 20 | ||
| OPERATOR_NO | Business Associate | OIUCM_BUS_ASSOC | CHAR | 12 | ||
| SEQ_NO | Transaction code for Royalty reporting | OIUREP_TXN_CD | CHAR | 4 | ||
| TRANSP_ORG_CD | Transport Org Cd | OIUY1_TRNSP_ORG_CD | CHAR | 8 | ||
| LEASE_SHR_PCNT | Lease Share Percentage | OIUY1_LSE_SHR_PCNT | DEC | 6 | ||
| WELL_IND | Well Indicator | OIUY1_WELL_IND | CHAR | 2 | ||
| SW_SWEET_FL | Sweet or Sour Flag(Y/N) | OIUY1_SW_FLAG | CHAR | 2 | ||
| REPORT_NO | Plant Org Id | OIUY1_RPT_NO | CHAR | 8 | ||
| UNIT_NO | Unit Number | OIUY1_UNIT_NO | CHAR | 12 | ||
| SEC | Section Number | OIUY1_SECTION_NO | CHAR | 12 | ||
| TWP | Township number | OIU_TWP_NO | CHAR | 6 | ||
| RGE | RGE | OIUY1_RGE | CHAR | 6 | ||
| ROYALTY_DEC | Royalty Decimal | OIUY1_ROY_DEC | DEC | 5 | ||
| OPERATOR | Operator | OIUY1_OPERATOR | CHAR | 20 | ||
| PUR_TAXID | Purchaser Tax ID | OIUY1_PURTAXID | CHAR | 26 | ||
| OPER_TAXID | Operator TAX ID | OIUY1_OPERTAXID | CHAR | 26 | ||
| TRACT_NO | Tract Number | OIUY1_TRACT_NO | CHAR | 36 | ||
| .INCLUDE | 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 | ||
| LEASE_SHR_PCNTO | Lease Share Percentage | OIUY1_LSE_SHR_PCNT | DEC | 6 | ||
| TXN_CD_O | Transaction code for Royalty reporting | OIUREP_TXN_CD | CHAR | 4 | ||
| TYPE_IND | RRC Type | OIUY1_TYPE_IND | CHAR | 2 | ||
| DRILLPERMIT_NO | Drilling permit Number | OIUREP_PERMIT_NO | CHAR | 40 | ||
| WELL_SNO | Well Serial Number | OIUY1_WELL_SNO | CHAR | 12 |