| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | SHNUMBER | TD shipment number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | VEH_NR | Vehicle Sequence Number in Shipment | nvarchar | 3 | 0 | | | | Allow NULL? |
| 4 | VEHICLE | TD Vehicle Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 5 | COMP_GROUP | TD Vehicle Customer group | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | VEH_TYPE | TD vehicle type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 7 | VEH_ID | TD vehicle identifier | nvarchar | 18 | 0 | | | | Allow NULL? |
| 8 | CARRIER | TD carrier (vendor account number) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 9 | VEH_NRTUS | Number of transport units on vehicle (TD) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 10 | VOL_UOM | TD volume unit of measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 11 | WGT_UOM | TD weight unit of measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 12 | DIM_UOM | TD dimension unit of measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 13 | VEH_MAXWGT | TD vehicle maximum weight | float | 15 | 16 | | | | |
| 14 | VEH_UNLWGT | TD vehicle unladen weight | float | 15 | 16 | | | | |
| 15 | VEH_MAXVOL | TD vehicle maximum volume | float | 15 | 16 | | | | |
| 16 | EQUIP_NR | Equipment Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 17 | VEH_HEIGHT | Vehicle height | decimal | 13 | 3 | | | | |
| 18 | VEH_WIDTH | TD width | decimal | 13 | 3 | | | | |
| 19 | VEH_LENGTH | Vehicle length | decimal | 13 | 3 | | | | |
| 20 | ROUTE | TD-F vehicle route | nvarchar | 6 | 0 | | | | Allow NULL? |
| 21 | TZONE | Time Zone | nvarchar | 6 | 0 | | | | Allow NULL? |
| 22 | CALENDAR | Factory calendar ID | nvarchar | 2 | 0 | | | | Allow NULL? |
| 23 | DEPOT | Plant | nvarchar | 4 | 0 | | | | Allow NULL? |
| 24 | VEH_SCREL | Freight cost relevant vehicle | nvarchar | 10 | 0 | | | | Allow NULL? |
| 25 | NAME_EFF_DATE | Name Effective Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 26 | CLF_EFDT | Vehicle Classification Effective Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 27 | REG_CNTRY | Vehicle Registered Country | nvarchar | 3 | 0 | | | | Allow NULL? |
| 28 | REG_DATE | TD-Vehicle Registered Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 29 | OWNER | TD-Vehicle Owner | nvarchar | 20 | 0 | | | | Allow NULL? |
| 30 | REG_OWNER | TD-Vehicle Registered Owner | nvarchar | 20 | 0 | | | | Allow NULL? |
| 31 | GRP_ID | TD-Vehicle Berth Compatibility Group ID | nvarchar | 10 | 0 | | | | Allow NULL? |
| 32 | OWN_FLAG | TD-Vehicle Own Flag | char | 1 | 0 | | | | Allow NULL? |
| 33 | BALLCAP | TD-Vehicle Ballast Capacity | decimal | 13 | 3 | | | | |
| 34 | FL_BNK_CAPA | TD-Vehicle Fuel Bunker Capacity | decimal | 13 | 3 | | | | |
| 35 | DSL_BNK_CAPA | TD-Vehicle Diesel Bunker Capacity | decimal | 13 | 3 | | | | |
| 36 | CAP_UOM | UoM of TD-Vehicle Bunker Capacity | nvarchar | 3 | 0 | | | | Allow NULL? |
| 37 | WT_UOM | UoM of TD-Vehicle(For Draft) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 38 | CLASS_GRP | TD-Vehicle Classification Group | nvarchar | 10 | 0 | | | | Allow NULL? |
| 39 | VHCLSIGN | TD-Vehicle Call Sign | nvarchar | 10 | 0 | | | | Allow NULL? |
| 40 | STCMNR | TD-Vehicle Telex Number | nvarchar | 30 | 0 | | | | Allow NULL? |
| 41 | SRFXNR | TD-Vehicle Fax Number | nvarchar | 30 | 0 | | | | Allow NULL? |
| 42 | DRAFT | Maximum Vehicle Draft | decimal | 13 | 3 | | | | |
| 43 | OIG_SSTSF | TD Shipment Status (Functional) | char | 1 | 0 | | | | Allow NULL? |
| 44 | LDDATE | Loading Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 45 | LDTIME | Loading time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 46 | SHIFT | TD driver shift | char | 1 | 0 | | | | Allow NULL? |
| 47 | TRIP | Trip Number | nvarchar | 5 | 0 | | | | Allow NULL? |
| 48 | RTDATE | Date of return | nvarchar | 8 | 0 | | | | Allow NULL? |
| 49 | RTTIME | Time of return | nvarchar | 6 | 0 | | | | Allow NULL? |
| 50 | PRINTFLG | Output selection flag (indicates print required) | char | 1 | 0 | | | | Allow NULL? |
| 51 | DDCDAT | Document date in delivery confirmation | nvarchar | 8 | 0 | | | | Allow NULL? |
| 52 | PSTDAT | Posting date in delivery confirmation | nvarchar | 8 | 0 | | | | Allow NULL? |
| 53 | MBLNRGL | Number of Material Document | nvarchar | 10 | 0 | | | | Allow NULL? |
| 54 | MBLNR | Number of Material Document | nvarchar | 10 | 0 | | | | Allow NULL? |
| 55 | MJAHR | Material Document Year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 56 | VCLOSE | Vehicle close flag; set confirmation to complete (status=6) | char | 1 | 0 | | | | Allow NULL? |
| 57 | GLPST | TD gain/loss postings at vehicle close | char | 1 | 0 | | | | Allow NULL? |
| 58 | VBALNC | TD vehicle balance check against tolerance table (TOIGS5) | char | 1 | 0 | | | | Allow NULL? |
| 59 | REAS_CODE | Reason code - to group quantities in shipment process | nvarchar | 2 | 0 | | | | Allow NULL? |
| 60 | CHK_OVL | TD check overloading | char | 1 | 0 | | | | Allow NULL? |
| 61 | CRE_DATE | Created On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 62 | CRE_NAME | Name of Person who Created the Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 63 | CRE_TIME | Time, at Which Record Was Added | nvarchar | 6 | 0 | | | | Allow NULL? |
| 64 | CHA_DATE | Date of Last Change | nvarchar | 8 | 0 | | | | Allow NULL? |
| 65 | CHA_NAME | Name of Person Who Changed Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 66 | CHA_TIME | Time of Change | nvarchar | 6 | 0 | | | | Allow NULL? |
| 67 | TPPOINT | Transportation planning point | nvarchar | 4 | 0 | | | | Allow NULL? |
| 68 | FBSTA | Status of shipment costing vehicle level | char | 1 | 0 | | | | Allow NULL? |
| 69 | FBGST | Overall status of shipment costing vehicle level | char | 1 | 0 | | | | Allow NULL? |
| 70 | ARSTA | Status of shipment cost settlement vehicle level | char | 1 | 0 | | | | Allow NULL? |
| 71 | ARGST | Overall status of shipment cost settlement vehicle level | char | 1 | 0 | | | | Allow NULL? |
| 72 | SKALSM | Pricing procedure in vehicle of shipment | nvarchar | 6 | 0 | | | | Allow NULL? |
