| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | GUID_EVENT_DATA | Worldwide-Unique Key for Check-in/Check-out Process Data | nvarchar | 22 | 0 | CHAR | (N' ') | No | | LECI_GUID_EVENT_DATA | Allow NULL? |
| 3 | SHPMNT_NUMB | Shipment Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | TKNUM | Allow NULL? |
| 4 | DELIV_NUMB | Delivery | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | VBELN_VL | Allow NULL? |
| 5 | VEHICLE_REG_NUMB | Truck's/Car's License Plate Number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | VREGNB | Allow NULL? |
| 6 | TRAILER_REG_NUMB | Trailer's License Plate Number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | TREGNB | Allow NULL? |
| 7 | CONT_REG_NUMB1 | Number of the First Container | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | C1RENB | Allow NULL? |
| 8 | CONT_REG_NUMB2 | Number of the Second Container | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | C2RENB | Allow NULL? |
| 9 | VEND_NUMB | Number of forwarding agent | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | TDLNR | Allow NULL? |
| 10 | NAME_DRVR | Driver name | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | NAMEF | Allow NULL? |
| 11 | FST_NAME_DRVR | First Name | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | LECI_NAMEFIR | Allow NULL? |
| 12 | NAME_CODRVR | Alternate Driver's Name | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | NAMBE | Allow NULL? |
| 13 | FST_NAME_CODRVR | First Name | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | LECI_NAMEFIR | Allow NULL? |
| 14 | NAT_DRVR | Driver's Nationality | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | LANDF | Allow NULL? |
| 15 | CARD_NUMB | Extended Pass Number for Check-in at Plant Grounds | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | PCRD_NUMB | Allow NULL? |
| 16 | ALLOWED_WGHT | Allowed Loading Weight of a Handling Unit | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MAGEW_VEKP | |
| 17 | UNIT_OF_WGHT | Weight Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | GEWEI | Allow NULL? |
| 18 | PARKING_TXT | Text Field for Entering the Parking Space | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | PARKING_TXT | Allow NULL? |
| 19 | CARGO_TXT | Text Relating to the Load | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | CARGO_TXT | Allow NULL? |
| 20 | STAGING_AREA | Staging Area for Warehouse Complex | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | LGBZO | Allow NULL? |
| 21 | SHP_POINT | Shipping Point/Receiving Point | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | VSTEL | Allow NULL? |
| 22 | WHS_NUMB | Warehouse Number / Warehouse Complex | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | LGNUM | Allow NULL? |
| 23 | WHS_GATE | Door for Warehouse Number | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | LGTOR | Allow NULL? |
| 24 | COMPANY | Company name | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | COMP_TXT | Allow NULL? |
| 25 | CITY | City | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_CITY1 | Allow NULL? |
| 26 | DEPARTMENT | Department | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_DPRTMNT | Allow NULL? |
| 27 | BUILDING | Building (number or code) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_BLDNG_P | Allow NULL? |
| 28 | NAME_CONTACT | Search for a user name | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | MIGO_USERNAME | Allow NULL? |
| 29 | PHONE | First telephone no.: dialling code+number | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | AD_TLNMBR1 | Allow NULL? |
| 30 | ID_CARD_NUMB | ID Number | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | ID_CARD_NUMB | Allow NULL? |
| 31 | CARR_OBJECTS | Personal Effects | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | COBJCTS_TXT | Allow NULL? |
| 32 | CHK_IN_TYPE | Classification of the Check-in Object (M. of Tran., Visitor) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | CHKI_TYPE | Allow NULL? |
