| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | AGENCY | Agency for Reporting | nvarchar | 3 | 0 | | | | Allow NULL? |
| 3 | REP_NAME | Regulatory Report Name | nvarchar | 40 | 0 | | | | Allow NULL? |
| 4 | MP_NO | Measurement point number | nvarchar | 20 | 0 | | | | Allow NULL? |
| 5 | EFF_FROM_DT | Effective from date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | EFF_TO_DT | Effective To Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | EFF_TO_CD | Checkbox | char | 1 | 0 | | | | Allow NULL? |
| 8 | TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | | | |
| 9 | USERID | User Name | nvarchar | 12 | 0 | | | | Allow NULL? |
| 10 | FACILITY_CD | OGOR-B Facility Number | nvarchar | 11 | 0 | | | | Allow NULL? |
| 11 | OUT_FMP_NO | Reg.Reporting MMS PASR Output Facility | nvarchar | 11 | 0 | | | | Allow NULL? |
| 12 | SALES_FMP_NO | Reg.Reporting MMS PASR Sales Facility | nvarchar | 11 | 0 | | | | Allow NULL? |
| 13 | ORG1 | Company Level 1 - (ORG1) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 14 | ORG2 | Second-highest organization level number ( Company Code) | char | 1 | 0 | | | | Allow NULL? |
| 15 | ORG3 | Third-highest organization level number ( Company Code) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 16 | ORG4 | Fourth-highest organization level number ( Company Code) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 17 | FIELD_NO | Reg. ID specific field number - override | nvarchar | 8 | 0 | | | | Allow NULL? |
| 18 | CONS_DIST_NO | Regulatory Reporting - Conservation District Number | nvarchar | 4 | 0 | | | | Allow NULL? |
| 19 | AREA_CD | Regulatory Reporting - Area Code | char | 1 | 0 | | | | Allow NULL? |
| 20 | WL_SERIAL_NO | Well Serial Number | nvarchar | 6 | 0 | | | | Allow NULL? |
| 21 | COMNG_FAC_NO | Regulatory Reporting - Commingling Facility Number | nvarchar | 6 | 0 | | | | Allow NULL? |
| 22 | LUW_NO | Regulatory Reporting - Lease Unit / Well No | nvarchar | 6 | 0 | | | | Allow NULL? |
| 23 | INAC_STATUS_CD | Inactive Status Code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 24 | INAC_FUTURE_CD | Inactive Future Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 25 | INAC_ABANDON | Inactive Abandon Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 26 | SPLIT_GUID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | | | Allow NULL? |
| 27 | OVERRIDE_GRP | Override Group | nvarchar | 5 | 0 | | | | Allow NULL? |
