| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | EMCSNR | EMCS Sequence Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | ITNEX | EMCS: Item Number of e-AAD | nvarchar | 3 | 0 | | | | Allow NULL? |
| 4 | TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | | | |
| 5 | ZEILE | Item in Material Document | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | ITVSY | External Identification Document Item from Feeder System | nvarchar | 10 | 0 | | | | Allow NULL? |
| 7 | MATNR | Material Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 8 | ITEPC | EMCS: Excise Duty Product Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 9 | CCNST | EMCS: Commodity Code | nvarchar | 8 | 0 | | | | Allow NULL? |
| 10 | FLFIS | EMCS: Fiscal Mark | char | 1 | 0 | | | | Allow NULL? |
| 11 | ALCSTR | Alcoholic Strength | nvarchar | 6 | 0 | | | | Allow NULL? |
| 12 | DEGPLA | Degree Plato | nvarchar | 6 | 0 | | | | Allow NULL? |
| 13 | PRODSI | EMCS: Annual Output | decimal | 20 | 3 | | | | |
| 14 | DENSIT | EMCS: Density | nvarchar | 6 | 0 | | | | Allow NULL? |
| 15 | WEIGRO | EMCS: Gross Weight | decimal | 19 | 3 | | | | |
| 16 | WEIGRO_PRE | Number of Decimal Places | char | 1 | 0 | | | | Allow NULL? |
| 17 | WEINET | EMCS: Net Weight | decimal | 19 | 3 | | | | |
| 18 | WEINET_PRE | Number of Decimal Places | char | 1 | 0 | | | | Allow NULL? |
| 19 | WEIDIM | EMCS: Unit of Weight | nvarchar | 3 | 0 | | | | Allow NULL? |
| 20 | WINZON | EMCS: Wine-Growing Zone | nvarchar | 2 | 0 | | | | Allow NULL? |
| 21 | WINCAT | EMCS: Category of Wine Product | char | 1 | 0 | | | | Allow NULL? |
| 22 | WINCOO | EMCS: Third Country of Origin | nvarchar | 3 | 0 | | | | Allow NULL? |
| 23 | WINOP_C | Treatment of Wine Product (Wine Operation) | nvarchar | 20 | 0 | | | | Allow NULL? |
| 24 | QUAITM | EMCS: Quantity | decimal | 16 | 3 | | | | |
| 25 | QUAITM_PRE | Number of Decimal Places | char | 1 | 0 | | | | Allow NULL? |
| 26 | QUAITM_UOM | EMCS: Unit of Measurement for Quantity | nvarchar | 3 | 0 | | | | Allow NULL? |
| 27 | DEVIND | EMCS: Type of Deviation | char | 1 | 0 | | | | Allow NULL? |
| 28 | QUASNE | EMCS: Quantity Deviation | decimal | 19 | 3 | | | | |
| 29 | QUASNE_UOM | EMCS: Unit of Measurement for Different Quantity | nvarchar | 3 | 0 | | | | Allow NULL? |
| 30 | QUAREF | EMCS: Rejected Quantity | decimal | 19 | 3 | | | | |
| 31 | QUAREF_UOM | EMCS: Rejected Unit of Measurement | nvarchar | 3 | 0 | | | | Allow NULL? |
| 32 | UNAME | User Name | nvarchar | 12 | 0 | | | | Allow NULL? |
