| 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 | T000 | MANDT | Allow NULL? |
| 2 | PEGID | Pegging identifier | nvarchar | 20 | 0 | CHAR | (N' ') | No | OIJPEG | OIJ_PEGID | Allow NULL? |
| 3 | VBELN | Freight contract number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | OIJ_EL_CP_LAYT | OIJ_EL_CPNO | Allow NULL? |
| 4 | VBTYP | TSW Details document type | char | 1 | 0 | CHAR | (N' ') | Yes | OIJ_EL_CP_LAYT | OIJ_EL_VBTYP | Allow NULL? |
| 5 | POSNR | Contract item number | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | OIJ_EL_CP_LAYT | OIJ_EL_POSNR | Allow NULL? |
| 6 | LT_POT | Potential Laytime | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIJ_LT_POTENTIAL | |
| 7 | LT_ACT | Actual Laytime | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIJ_LT_ACTUAL | |
| 8 | LT_ALLOWED | Allowed Laytime | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIJ_LT_ALLOWED | |
| 9 | LAY_UOM | Laytime unit of measurement | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIJ_LT_UOM | Allow NULL? |
| 10 | DM_POT | Potential Demurrage | decimal | 15 | 2 | CURR | ((0)) | Yes | | OIJ_DM_POTENTIAL | |
| 11 | DM_CURR | Currency for Demurrage Amount | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | OIJ_DM_CURR | Allow NULL? |
| 12 | CALCMETHLT | Method used for calculation of laytime | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | OIJ_METHLT | Allow NULL? |
| 13 | CALCMETHDM | Method used for calculation of demurrage | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | OIJ_METHDM | Allow NULL? |
| 14 | DMDAT | Demurrage Date determined via BADI | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | OIJ_DMDATE | Allow NULL? |
| 15 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERDAT | Allow NULL? |
| 16 | ERZEIT | Time of creation | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | OI0_ERTIM | Allow NULL? |
| 17 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 18 | AEDAT | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AEDAT | Allow NULL? |
| 19 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | OI0_AETIM | Allow NULL? |
| 20 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENAM | Allow NULL? |
| 21 | BLOIND | Blocking indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_BLOIND | Allow NULL? |
| 22 | DELIND | Deletion indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_DELIND | Allow NULL? |