| 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 | T000 | MANDT | Allow NULL? |
| 2 | SHNUMBER | TD shipment number | nvarchar | 10 | 0 | CHAR | (N' ') | No | OIGS | OIG_SHNUM | Allow NULL? |
| 3 | HIS_ITM | TD shipment history item number | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | OIG_HISITM | Allow NULL? |
| 4 | SEQ_NR | Dummy for B20 int1 (Local Everywhere) | tinyint | 3 | 0 | INT1 | ((0)) | No | | INT1 | |
| 5 | AKTYP | Activity category in SAP transaction | char | 1 | 0 | CHAR | (N' ') | Yes | | AKTYP | Allow NULL? |
| 6 | VEH_NR | Vehicle Sequence Number in Shipment | nvarchar | 3 | 0 | NUMC | (N'000') | No | OIGSV | OIG_VEHNR | Allow NULL? |
| 7 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001W | WERKS_D | Allow NULL? |
| 8 | PSTDAT | Posting Date in the Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BUDAT | Allow NULL? |
| 9 | PSTTIM | Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | UZEIT | Allow NULL? |
| 10 | DCMDAT | Document Date in Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BLDAT | Allow NULL? |
| 11 | CNFFLG | Single-Character Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR1 | Allow NULL? |
| 12 | MBLNR | Number of Material Document | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | MBLNR | Allow NULL? |
| 13 | MJAHR | Material Document Year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | MJAHR | Allow NULL? |
| 14 | CORRECT | Single-Character Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR1 | Allow NULL? |
| 15 | CRE_DATE | Created On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERSDA | Allow NULL? |
| 16 | CRE_NAME | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 17 | CRE_TIME | Time, at Which Record Was Added | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ERZEIT | Allow NULL? |
| 18 | CHA_DATE | Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | LAEDA | Allow NULL? |
| 19 | CHA_NAME | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENAM | Allow NULL? |
| 20 | CHA_TIME | Time of Change | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | AEZEIT | Allow NULL? |
| 21 | TCODE | Transaction Code | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | TCODE | Allow NULL? |
