| 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 | EMCSNR | EMCS Sequence Number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | /BEV2/CS_HD | /BEV2/CS_EMCSNR | Allow NULL? |
| 3 | LFDNR | Sequence Number | nvarchar | 3 | 0 | NUMC | (N'000') | No | | /BEV2/CS_LFDNR | Allow NULL? |
| 4 | TRAID | EMCS: Transport Unit Code | char | 1 | 0 | CHAR | (N' ') | Yes | | /BEV2/CS_TRANSPORT_UNIT_CODE | Allow NULL? |
| 5 | UNIID | EMCS: Identity of Transport Unit | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | /BEV2/CS_TRANSPORT_UNIT_ID | Allow NULL? |
| 6 | SEALID | EMCS: Number of Seal | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | /BEV2/CS_SEAL_ID | Allow NULL? |
| 7 | SEALIN | EMCS: Information on Seal | ntext | 1073741823 | 0 | | | Yes | | /BEV2/CS_SEAL_INFO_STR | |
| 8 | SEALLA | EMCS: Information on Seal (Language) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | /BEV2/CS_SEAL_INFO_LANGU | Allow NULL? |
| 9 | COIN | EMCS: Additional Information | ntext | 1073741823 | 0 | | | Yes | | /BEV2/CS_ADDED_INFO_STR | |
| 10 | COINLA | EMCS: Additional Information (Language) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | /BEV2/CS_ADDED_INFO_LANGU | Allow NULL? |
| 11 | TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
| 12 | UNAME | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | UNAME | Allow NULL? |
