| 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 | REG_NUMBER | Regulatory Reporting Run Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 5 | HEAD_SEQNR | Regulatory Reporting Header Sequence Number | nvarchar | 5 | 0 | | | | Allow NULL? |
| 6 | REC_TYPE | Detail Layout Record Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 7 | LINE_NBR | OGOR Detail Line Number | nvarchar | 4 | 0 | | | | Allow NULL? |
| 8 | ACTION_CD | OGOR Detail Layout Action Code | char | 1 | 0 | | | | Allow NULL? |
| 9 | VER_NO | Version Number | int | 10 | 0 | | | | Allow NULL? |
| 10 | OPERATOR_BLOCK | Reg.Reporting MMS PASR Operator Area Block | nvarchar | 30 | 0 | | | | Allow NULL? |
| 11 | INJECTOR | Reg.Reporting MMS PASR Injector | char | 1 | 0 | | | | Allow NULL? |
| 12 | METERING_PT_NO | MMS Metering Point | nvarchar | 11 | 0 | | | | Allow NULL? |
| 13 | LSE_NO | Lease Number (Externally-Issued ID) | nvarchar | 11 | 0 | | | | Allow NULL? |
| 14 | SALES_VOL | Reg.Reporting MMS PASR Sales Transfer Volume | decimal | 9 | 0 | | | | |
| 15 | OTHER_VOL | Reg.Reporting MMS PASR other Source Volume | decimal | 9 | 0 | | | | |
| 16 | ADJUSTMENTS | Adjustment Indicator | char | 1 | 0 | | | | Allow NULL? |
| 17 | RPT_FLAG | Report Flag - Determines if included in Current/Amended Adj | char | 1 | 0 | | | | Allow NULL? |
| 18 | USERID | User Name | nvarchar | 12 | 0 | | | | Allow NULL? |
| 19 | TIMESTAMP | Time Stamp - Short Format | nvarchar | 15 | 0 | | | | Allow NULL? |