| 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 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | BUKRS | Allow NULL? |
| 3 | TR_NUMBER | Excise Duty Revaluation Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | | OIH_TAX_REV_NUMBER | Allow NULL? |
| 4 | TR_YEAR | Excise Duty Revaluation Document Year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | OIH_TAX_REV_YEAR | Allow NULL? |
| 5 | TR_LINE | Item in tax revaluation document | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | OIH_TAX_REV_LINE | Allow NULL? |
| 6 | XBLNR | Reference Document Number | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | XBLNR1 | Allow NULL? |
| 7 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 8 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | MATNR | Allow NULL? |
| 9 | BWKEY | Valuation Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BWKEY | Allow NULL? |
| 10 | BWTAR | Valuation Type | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | BWTAR_D | Allow NULL? |
| 11 | OICURVAL | Excise Duty Current Value | decimal | 13 | 2 | CURR | ((0)) | Yes | | OIH_CURTAXV | |
| 12 | OICURDATE | Current date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | OIH_CURDAT | Allow NULL? |
| 13 | OICURQTY | Current quantity with sign | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIH_CURQTYV | |
| 14 | OICURUT | Current unit of measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | OIH_CURUT | Allow NULL? |
| 15 | OIFUTVAL | Excise Duty Future Value | decimal | 13 | 2 | CURR | ((0)) | Yes | | OIH_FUTTAXV | |
| 16 | OIFUTDATE | Future date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | OIH_FUTDAT | Allow NULL? |
| 17 | OIFUTQTY | Future quantity with sign | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIH_FUTQTYV | |
| 18 | OIFUTUT | Future unit of measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | OIH_FUTUT | Allow NULL? |
| 19 | OINVALQTY | Not to be used!!! (non valuated quantity) | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIH_NVALQT | |
| 20 | OIREQUAT | Quantity to be revaluated | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIH_REQUAT | |
| 21 | OITAXKEY | Excise Duty Status | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | OIH_TAXKEY | Allow NULL? |
| 22 | OITAXDIFF | Excise Duty Difference Value | decimal | 13 | 2 | CURR | ((0)) | Yes | | OIH_TAXDIFF | |
| 23 | OITAXDIFF1 | Excise Duty Difference Value (Element 1) | decimal | 13 | 2 | CURR | ((0)) | Yes | | OIH_TAXDIF1 | |
| 24 | OITAXDIFF2 | Excise Duty Difference Value (Element 2) | decimal | 13 | 2 | CURR | ((0)) | Yes | | OIH_TAXDIF2 | |
| 25 | OITAXDIFF3 | Excise Duty Difference Value (Element 3) | decimal | 13 | 2 | CURR | ((0)) | Yes | | OIH_TAXDIF3 | |
| 26 | OITAXDIFF4 | Excise Duty Difference Value (Element 4) | decimal | 13 | 2 | CURR | ((0)) | Yes | | OIH_TAXDIF4 | |
| 27 | OITAXDIFF5 | Excise Duty Difference Value (Element 5) | decimal | 13 | 2 | CURR | ((0)) | Yes | | OIH_TAXDIF5 | |
| 28 | OITAXDIFF6 | Excise Duty Difference Value (Element 6) | decimal | 13 | 2 | CURR | ((0)) | Yes | | OIH_TAXDIF6 | |
| 29 | OIHANTYP | Excise Duty Handling Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | OIH_HANTYP | Allow NULL? |
| 30 | OITAXGRP | Excise Duty Group | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | OIH2 | OIH_TAXGRP | Allow NULL? |
| 31 | SELKZ | Selection flag | char | 1 | 0 | CHAR | (N' ') | Yes | | SELKZ | Allow NULL? |
