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