| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | EXGRP | Excise Group | nvarchar | 2 | 0 | | | | Allow NULL? |
| 3 | SYEAR | Year of Register Entry | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | SERIALNO | RG1 serial number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 5 | CHAPID | Chapter ID | nvarchar | 12 | 0 | | | | Allow NULL? |
| 6 | MBLNR | Number of Material Document | nvarchar | 10 | 0 | | | | Allow NULL? |
| 7 | MJAHR | Material Document Year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 8 | ZEILE | Item in Material Document | nvarchar | 4 | 0 | | | | Allow NULL? |
| 9 | RULES | Rule/Section | nvarchar | 10 | 0 | | | | Allow NULL? |
| 10 | BWART | Movement Type (Inventory Management) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 11 | MATNR | Material Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 12 | MATFORM | Material packaging form: Packed, Loose | char | 1 | 0 | | | | Allow NULL? |
| 13 | MENGE | Quantity | decimal | 13 | 3 | | | | |
| 14 | MEINS | Base Unit of Measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 15 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | | | Allow NULL? |
| 16 | WERKS | Plant | nvarchar | 4 | 0 | | | | Allow NULL? |
| 17 | LGORT | Storage Location | nvarchar | 4 | 0 | | | | Allow NULL? |
| 18 | CHARG | Batch Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 19 | LGORTIND | Storage location type indicator | char | 1 | 0 | | | | Allow NULL? |
| 20 | RISIND | Goods Movement Direction | char | 1 | 0 | | | | Allow NULL? |
| 21 | RCPTISSRSN | Rcpt/Issu classification codes | nvarchar | 3 | 0 | | | | Allow NULL? |
| 22 | DOWNL | Download indicator | char | 1 | 0 | | | | Allow NULL? |
| 23 | DECLRD | Item declared for Excise | char | 1 | 0 | | | | Allow NULL? |
| 24 | EXPIND | Export Type | char | 1 | 0 | | | | Allow NULL? |
| 25 | REASON | reason for movement | nvarchar | 40 | 0 | | | | Allow NULL? |
| 26 | REMARKS | Remarks containing RG1 prod.ser.no or excise inv. ranges | nvarchar | 45 | 0 | | | | Allow NULL? |
| 27 | RDOC1 | Reference Document 1 | nvarchar | 10 | 0 | | | | Allow NULL? |
| 28 | RYEAR1 | Reference year 1 | nvarchar | 4 | 0 | | | | Allow NULL? |
| 29 | RIND1 | Reference Document Type 1 | char | 1 | 0 | | | | Allow NULL? |
| 30 | BEDRATE | BED percentage | decimal | 7 | 4 | | | | |
| 31 | AEDRATE | Additional Excise Duty % | decimal | 7 | 4 | | | | |
| 32 | SEDRATE | Special Excise Duty % | decimal | 7 | 4 | | | | |
| 33 | EXCUR | Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 34 | EXBAS | Excise Duty Base Amount | decimal | 13 | 2 | | | | |
| 35 | EXBED | Basic Excise Duty | decimal | 13 | 2 | | | | |
| 36 | EXAED | Additional Excise Duty | decimal | 13 | 2 | | | | |
| 37 | EXSED | Special Excise Duty | decimal | 13 | 2 | | | | |
| 38 | CESS | Cess amount | decimal | 13 | 2 | | | | |
| 39 | STATUS | Register Entry Status | char | 1 | 0 | | | | Allow NULL? |
| 40 | USNAM | Created By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 41 | CPUDT | Excise Document Entry Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 42 | CPUTM | Time of Entry | nvarchar | 6 | 0 | | | | Allow NULL? |
| 43 | AEDAT | Changed On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 44 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 45 | NCCDRATE | NCCD Rate in % | decimal | 7 | 4 | | | | |
| 46 | NCCD | NCCD Value | decimal | 13 | 2 | | | | |
| 47 | ECSRATE | ECS rate in % | decimal | 7 | 4 | | | | |
| 48 | ECS | ECS Value | decimal | 13 | 2 | | | | |
| 49 | EXADDRATE1 | AT1 rate in % | decimal | 7 | 4 | | | | |
| 50 | EXADDTAX1 | Additional Tax1 value | decimal | 13 | 2 | | | | |
| 51 | EXADDRATE2 | AT2 rate in % | decimal | 7 | 4 | | | | |
| 52 | EXADDTAX2 | Additional Tax2 value | decimal | 13 | 2 | | | | |
| 53 | EXADDRATE3 | AT3 rate in % | decimal | 7 | 4 | | | | |
| 54 | EXADDTAX3 | Additional Tax3 value | decimal | 13 | 2 | | | | |
