| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | JIL | Jil Name | nvarchar | 40 | 0 | CHAR | (N' ') | No | | OIUCM_REPID | Allow NULL? |
| 3 | REP_YEAR | Reporting Year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | OIU_REPYEAR | Allow NULL? |
| 4 | REP_MONTH | Reporting Month | nvarchar | 2 | 0 | NUMC | (N'00') | No | | OIU_REPMONTH | Allow NULL? |
| 5 | OR1_OR_LVL_1_NO | Company Level 1 - (ORG1) | nvarchar | 3 | 0 | CHAR | (N' ') | No | * | OIUH_OR1_OR_LVL_1_NO | Allow NULL? |
| 6 | AC_INDICATOR | Amended/current Report Indicator | char | 1 | 0 | CHAR | (N' ') | No | | OIU_REPAC_IND | Allow NULL? |
| 7 | STATE | Primary geographical location (PRI geo. loc.) | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | OIU_PRI_GEO_LOC | Allow NULL? |
| 8 | REG_NUMBER | Regulatory Reporting Run Number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | OIUREP_REG_NUMBER | Allow NULL? |
| 9 | STATUS | Production: Regulatory Rep. - Run Status | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | OIUREP_REG_RUN_STATUS | Allow NULL? |
| 10 | JOBNAME | Background job name | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | BTCJOB | Allow NULL? |
| 11 | JOBCOUNT | Job ID | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | BTCJOBCNT | Allow NULL? |
| 12 | OR2_OR_LVL_2_NO | Second-highest organization level number ( Company Code) | char | 1 | 0 | CHAR | (N' ') | Yes | | OIUH_OR2_OR_LVL_2_NO | Allow NULL? |
| 13 | OR3_OR_LVL_3_NO | Third-highest organization level number ( Company Code) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | OIUH_OR3_OR_LVL_3_NO | Allow NULL? |
| 14 | OR4_OR_LVL_4_NO | Fourth-highest organization level number ( Company Code) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | OIUH_OR4_OR_LVL_4_NO | Allow NULL? |
| 15 | TF_INDICATOR | Trial/Final Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | OIU_REPTF_IND | Allow NULL? |
| 16 | TF_INDICATOR_YN | Trial/Final Indicator (Yes/No) | char | 1 | 0 | CHAR | (N' ') | Yes | | OIU_REPTF_IND_YN | Allow NULL? |
| 17 | PRODUCT | Product Code for Reporting | char | 1 | 0 | CHAR | (N' ') | Yes | | OIU_REP_PRODUCT | Allow NULL? |
| 18 | SUBLEDGER_TYPE | SubLedger Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | OIU_REP_SUBLDGR | Allow NULL? |
| 19 | INTERCOMPANY_FL | InterCompany Flag | char | 1 | 0 | CHAR | (N' ') | Yes | | OIU_REP_ICOMPFL | Allow NULL? |
| 20 | TAXTYPE | Severance Tax Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | OIU_SEVT_TAX_TY | Allow NULL? |
| 21 | REP_TYPE | Report type used in e.g. Jil TRB340A | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | OIUREP_REP_TYPE | Allow NULL? |
| 22 | REP_ID | REPORT id use in jil trb550a | nvarchar | 7 | 0 | CHAR | (N' ') | Yes | | OIUREP_REP_ID | Allow NULL? |
| 23 | HYEAR | FILLING MONTH OF | char | 1 | 0 | CHAR | (N' ') | Yes | | OIUH_FILL_DATE | Allow NULL? |
| 24 | OIU_CRUSER | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 25 | OIU_TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TZNTSTMPS | |
