| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | RPT_YYYYMM | Reporting Year and Month | nvarchar | 6 | 0 | | | | Allow NULL? |
| 3 | RSG | Report Submission Group | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | AGENCY | Agency for Reporting | nvarchar | 3 | 0 | | | | Allow NULL? |
| 5 | OGIND | Oil and Gas Indicator | char | 1 | 0 | | | | Allow NULL? |
| 6 | TFIND | Run type indicator | char | 1 | 0 | | | | Allow NULL? |
| 7 | MSTR_CHNG_TS | Time stamp indicating when tax master data last changed | nvarchar | 14 | 0 | | | | Allow NULL? |
| 8 | ADJ_TS | Time stamp for adjustments | nvarchar | 14 | 0 | | | | Allow NULL? |
| 9 | VALID_TS | Time stamp for tax master data validation | nvarchar | 14 | 0 | | | | Allow NULL? |
| 10 | LOCK_TS | Time stamp for locking | nvarchar | 14 | 0 | | | | Allow NULL? |
| 11 | TAX_XTRCT_TS | Time stamp for tax data extraction | nvarchar | 14 | 0 | | | | Allow NULL? |
| 12 | UNLOCK_TS | Time stamp for unlocking | nvarchar | 14 | 0 | | | | Allow NULL? |
| 13 | VOL_XTRCT_TS | Time stamp for volume extraction in tax reporting | nvarchar | 14 | 0 | | | | Allow NULL? |
| 14 | RPT_PROC_TS | Time stamp for report processing in tax reporting | nvarchar | 14 | 0 | | | | Allow NULL? |
| 15 | FINAL_TS | Time stamp for finalization in tax reporting | nvarchar | 14 | 0 | | | | Allow NULL? |
| 16 | VALID_ST | Status for master data validation run | char | 1 | 0 | | | | Allow NULL? |
| 17 | TAX_XTRCT_ST | Status for tax data extraction run | char | 1 | 0 | | | | Allow NULL? |
| 18 | VOL_XTRCT_ST | Status for volume extraction run | char | 1 | 0 | | | | Allow NULL? |
| 19 | RPT_PROC_ST | Status for report processing | char | 1 | 0 | | | | Allow NULL? |
| 20 | FINAL_ST | Status for report finalization run | char | 1 | 0 | | | | Allow NULL? |
| 21 | VALID_JOB | Background job name | nvarchar | 32 | 0 | | | | Allow NULL? |
| 22 | TAX_XTRCT_JOB | Background job name | nvarchar | 32 | 0 | | | | Allow NULL? |
| 23 | VOL_XTRCT_JOB | Background job name | nvarchar | 32 | 0 | | | | Allow NULL? |
| 24 | RPT_PROC_JOB | Background job name | nvarchar | 32 | 0 | | | | Allow NULL? |
| 25 | FINAL_JOB | Background job name | nvarchar | 32 | 0 | | | | Allow NULL? |
| 26 | VALID_CNT | Job ID | nvarchar | 8 | 0 | | | | Allow NULL? |
| 27 | TAX_XTRCT_CNT | Job ID | nvarchar | 8 | 0 | | | | Allow NULL? |
| 28 | VOL_XTRCT_CNT | Job ID | nvarchar | 8 | 0 | | | | Allow NULL? |
| 29 | RPT_PROC_CNT | Job ID | nvarchar | 8 | 0 | | | | Allow NULL? |
| 30 | FINAL_CNT | Job ID | nvarchar | 8 | 0 | | | | Allow NULL? |
| 31 | OIU_CRUSER | Name of Person who Created the Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 32 | OIU_TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | | | |