| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | BUKRS | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 3 | SALES_DT | Sales Date / Month | nvarchar | 8 | 0 | | | | Allow NULL? |
| 4 | PDCD | Full three char. product code (Major and Detail Products) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 5 | WL_NO | Well ID number | nvarchar | 15 | 0 | | | | Allow NULL? |
| 6 | WC_NO | Well Completion Number | nvarchar | 5 | 0 | | | | Allow NULL? |
| 7 | MP_NO | Measurement point number | nvarchar | 20 | 0 | | | | Allow NULL? |
| 8 | VNAME | Joint Venture | nvarchar | 6 | 0 | | | | Allow NULL? |
| 9 | DOI_NO | Division of interest (DOI) | nvarchar | 5 | 0 | | | | Allow NULL? |
| 10 | DN_NO | Delivery network number | nvarchar | 20 | 0 | | | | Allow NULL? |
| 11 | CT_NO | Contract Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 12 | VL_TYPE_CD | Volume type code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 13 | TAX_CLS | Tax Class | nvarchar | 4 | 0 | | | | Allow NULL? |
| 14 | REV_BOOK_ADJ_IND | Tax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustment | char | 1 | 0 | | | | Allow NULL? |
| 15 | PROD_PURC_IND | Producer or Purchaser | char | 1 | 0 | | | | Allow NULL? |
| 16 | UNIT_VNAME | Joint Venture | nvarchar | 6 | 0 | | | | Allow NULL? |
| 17 | PAY_FL | Tax Severance Tax Calculation Payment Obligations Types | char | 1 | 0 | | | | Allow NULL? |
| 18 | RPT_FL | State Severance Tax Reporting Indicators | char | 1 | 0 | | | | Allow NULL? |
| 19 | UOM | Measurement unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 20 | GROSS_VOL | Gross Volume | decimal | 11 | 2 | | | | |
| 21 | TAX_VOL | Taxable Volume | decimal | 11 | 2 | | | | |
| 22 | TAX_VAL | Taxable Value | decimal | 11 | 2 | | | | |
| 23 | EXEMPT_VOL | Exempt Volume | decimal | 11 | 2 | | | | |
| 24 | TAX_AMT | Tax Amount | decimal | 11 | 2 | | | | |
| 25 | TAX_REIMB | Tax Reimbursement | decimal | 11 | 2 | | | | |
| 26 | WET_LESS_RES | Tax 2.0 - Wet Less Residue Volume (MCF) | decimal | 11 | 2 | | | | |
| 27 | BLPS_GROSS_VOL | Tax 2.0 - Wyoming Before Lease Plant Split Gross Volume | decimal | 11 | 2 | | | | |
| 28 | RET_LSE_PC | Percent Returned to Lease | decimal | 6 | 3 | | | | |
| 29 | PLANT_PROC_VOL | Tax 2.0 - Wyoming Plant Processing Volume | decimal | 11 | 2 | | | | |
| 30 | COUNTY | Tax 2.0 - Wyoming County Identifier | nvarchar | 3 | 0 | | | | Allow NULL? |
| 31 | API_WELL_NUMBER | Tax 2.0 - Wyoming API Well Number | nvarchar | 5 | 0 | | | | Allow NULL? |
| 32 | SIDE_TRACK_NO | Tax 2.0 - Wyoming Side Track Number | nvarchar | 2 | 0 | | | | Allow NULL? |
| 33 | RESERVOIR | Tax 2.0 - Wyoming Reservoir | nvarchar | 3 | 0 | | | | Allow NULL? |
| 34 | RPT_GRP_NO | Tax 2.0 - Wyoming Report Group Number | nvarchar | 5 | 0 | | | | Allow NULL? |
| 35 | FIELD_NAME | Tax 2.0 - Wyoming Field Name | nvarchar | 35 | 0 | | | | Allow NULL? |
| 36 | LEASE_UNIT_NAME | Tax 2.0 - Wyoming Lease Unit Name / API | nvarchar | 35 | 0 | | | | Allow NULL? |
| 37 | OPERATED_FLAG | Tax 2.0 - Operated Flag | char | 1 | 0 | | | | Allow NULL? |
| 38 | TAX_DISTRICT | Tax 2.0 - Wyoming Tax District | nvarchar | 4 | 0 | | | | Allow NULL? |
| 39 | MASTER_LEVEL | Texas Master Data Level | char | 1 | 0 | | | | Allow NULL? |
| 40 | OPERATOR_ID | Tax 2.0 - Wyoming Operator ID | nvarchar | 4 | 0 | | | | Allow NULL? |
| 41 | OPERATOR_NO | Business Associate | nvarchar | 6 | 0 | | | | Allow NULL? |
| 42 | OPERATOR_SEQ_NO | Sequence Number | nvarchar | 2 | 0 | | | | Allow NULL? |
| 43 | OPERATOR_NAME | Tax 2.0 - Operator Name | nvarchar | 38 | 0 | | | | Allow NULL? |
| 44 | PURCHASER_NO | Business Associate | nvarchar | 6 | 0 | | | | Allow NULL? |
| 45 | PURCHASER_SEQ_NO | Sequence Number | nvarchar | 2 | 0 | | | | Allow NULL? |
| 46 | PURCHASER_NAME | Tax 2.0 - Purchaser Name | nvarchar | 38 | 0 | | | | Allow NULL? |
| 47 | OGIND | Oil and Gas Indicator | char | 1 | 0 | | | | Allow NULL? |
| 48 | DOC_NO | Val. document number | nvarchar | 20 | 0 | | | | Allow NULL? |
| 49 | DOC_YEAR | Document year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 50 | OPTION1 | | char | 1 | 0 | | | | Allow NULL? |
| 51 | OPTION2 | | char | 1 | 0 | | | | Allow NULL? |
| 52 | OPTION3 | Tax 2.0 - Indicator to identify external data update | char | 1 | 0 | | | | Allow NULL? |
| 53 | OPERATOR | Master Record | nvarchar | 10 | 0 | | | | Allow NULL? |
| 54 | PURCHASER | Master Record | nvarchar | 10 | 0 | | | | Allow NULL? |
| 55 | OIU_CRUSER | Name of Person who Created the Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 56 | OIU_TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | | | |
