OIJ_EL_CP_LAYT - Charter party and laytime and demurrage agreement

Charter party and laytime and demurrage agreement information is stored in SAP table OIJ_EL_CP_LAYT.
It is part of development package OIJ_EL in software component IS-OIL-DS-TSW. This development package consists of objects that can be grouped under "TSW Trader's and Scheduler's Workbench - Execution Layer".

Fields for table OIJ_EL_CP_LAYT

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6T000
VBELNFreight contract numberXOIJ_EL_CPNOCHAR20
VBTYPTSW Details document typeXOIJ_EL_VBTYPCHAR8
POSNRContract item numberXOIJ_EL_POSNRNUMC12
VAL_FROMValidity period start dateOIJ_EL_VALFDATS16
VAL_TOValidity period end dateOIJ_EL_VALTDATS16
SINGLE_VOYSingle voyage flagOIJ_EL_SVCHAR2
VEHICLETD Vehicle NumberOIG_VHLNMRCHAR20OIGV
VEH_TYPETD vehicle typeOIG_VHLTYPCHAR8TOIGV
LD_STARTCharter laydays start dateOIJ_EL_LDSDATS16
LD_ENDCharter laydays end dateOIJ_EL_LDEDATS16
RD_STARTRedelivery time start dateOIJ_EL_RDSDATS16
RD_ENDRedelivery time end dateOIJ_EL_RDEDATS16
GRADES_NONumber of product gradesOIJ_EL_GNONUMC4
ROUTERoute agreed in charter contractOIJ_EL_ROUTECHAR12TVRO
SPEEDCharter contract: base speed for voyageOIJ_EL_SPEEDQUAN4
MIN_SPEEDCharter contract: Minimum speedOIJ_EL_MINSPQUAN4
MAX_SPEEDCharter contract: Maximum speedOIJ_EL_MAXSPQUAN4
SP_UOMSpeed unit of measurementOIJ_EL_SPUOMUNIT6T006
MIN_QUANCharter contract: Minimum transport quantityOIJ_EL_MINQUQUAN7
QUAN_UOMUnit of measurement for quantityOIJ_EL_QUUOMUNIT6T006
CAPACITYCharter contract: cargo sizeOIJ_EL_CAPQUAN7
CAP_UOMUnit of measurement for capacityOIJ_EL_CAPUOMUNIT6T006
TOL_MINCargo size tolerance - minimumOIJ_EL_TMINDEC2
TOL_MAXCargo size tolerance - maximumOIJ_EL_TMAXDEC2
PRESSUREManifold pressureOIJ_EL_PRESSQUAN4
PRES_UOMUnit of measurement for pressureOIJ_EL_PRUOMUNIT6T006
BUNKER_LBunker consumption ladenOIJ_EL_BULQUAN7
CL_UOMQuantity UoM for consumptionOIJ_EL_CSUOMUNIT6T006
CLT_UOMTime UoM for consumptionOIJ_EL_CLTUOMUNIT6T006
BUNKER_BBunker consumption under ballastOIJ_EL_BUBQUAN7
ST_F_CONSStandby bunker fuel consumptionOIJ_EL_STFCQUAN7
ST_D_CONSStandby bunker diesel consumptionOIJ_EL_STDCQUAN7
FUEL_MGBunker fuel material groupOIJ_EL_BFUELCHAR18T023
DIES_MGBunker diesel material groupOIJ_EL_BDIESCHAR18T023
DECLDeclare flag: charterer or owner drivenOIJ_EL_DECLCHAR2
DECL_QUDeclare flag: charterers or owners optionOIJ_EL_DEQUCHAR2
LPAOwner's or charterer's load port agentOIJ_EL_LPACHAR2
DPAOwner's or charterer's discharge port agentOIJ_EL_DPACHAR2
CONS_PERCOIL-TSW: Bunker Consumption Percentage for a Transp. SystemOIJ_CONS_PERCDEC3
.INCLUDEROIJ_EL_LAYT0
WP_EVENTWindow period eventOIJ_EL_WPEVCHAR8TOIGE
LC_EVENTLightering commencement eventOIJ_EL_LCEVCHAR8TOIGE
LAY_TOTALTotal allowed laytimeOIJ_EL_LAYTTQUAN2
DIS_TOTALTotal allowed discharge laytimeOIJ_EL_DISTQUAN2
LAY_UOMUnit of measurement for laytimeOIJ_EL_LAYTUOMUNIT6T006
LAY_QUANQuantity to which laytime is relatedOIJ_EL_LAYQUQUAN7
L_QU_UOMUnit of measurement for quantityOIJ_EL_QUUOMUNIT6T006
LAY_MINMinimum laytimeOIJ_EL_LAYMINQUAN2
LM_UOMUnit of measurement for laytimeOIJ_EL_LAYTUOMUNIT6T006
TIMEBARTimebar limitOIJ_EL_TBQUAN2
TB_UOMUnit of measurement for timebar limitOIJ_EL_TBUOMUNIT6T006
TB_EVENTTimebar start eventOIJ_EL_TBEVCHAR8TOIGE
COND_TYPEDemurrage rate condition typeOIJ_EL_DERACHAR8T685
DESP_CTYPEDespatch rate condition typeOIJ_EL_DSRACHAR8T685
FACT_TYPECalculation factor condition typeOIJ_EL_DEFACHAR8T685
RATE_DATECondition rate date determinationOIJ_EL_RADATECHAR12TOIJ_DET_DATE
.INCLUDEROIJSTAT0
ERDATDate on which the record was createdERDATDATS16
ERZEITTime of creationOI0_ERTIMTIMS12
ERNAMName of Person Responsible for Creating the ObjectERNAMCHAR24
AEDATLast Changed OnAEDATDATS16
AEZEITTime of day the record was changedOI0_AETIMTIMS12
AENAMName of Person Who Changed ObjectAENAMCHAR24
BLOINDBlocking indicatorOIJ_BLOINDCHAR2
DELINDDeletion indicatorOIJ_DELINDCHAR2
TKTSELECTFlag to Set Tickets SelectableOIJ_TKTSELECTCHAR2
.INCLUDEROIJ_EL_GA0
SERVTYPEField - Service TypeOIJ_SERVTYPECHAR30
TRANTYPTransaction TypeOIJ_TRANTYPCHAR10
PRIORITYCapacityOIJ_CAPACITYCHAR10
SHIPPERConnecting shipperOIJ_EL_CSHCHAR20*
TSYSTTransport systemOIJ_TSYSTCHAR20*
RLOCIDLocation IDOIJ_LOCIDCHAR20*
DLOCIDLocation IDOIJ_LOCIDCHAR20*
MDQ_QUANQuantity to which laytime is relatedOIJ_EL_LAYQUQUAN7
MDQ_UOMUnit of measurement for quantityOIJ_EL_QUUOMUNIT6T006
MDQBField - Maximum Daily QuantityOIJ_EL_MDQBCHAR2
FUEL_PERCOIL-TSW: Bunker Consumption Percentage for a Transp. SystemOIJ_CONS_PERCDEC3
FUELBFuel BasisOIJ_EL_FUELBCHAR2
_DATAAGINGData Filter Value for Data AgingDATA_TEMPERATUREDATS16
Privacy Policy