OIJ_EL_CP_LAYT

Charter party and laytime and demurrage agreement | #transactional | Component: Trader's and Scheduler's Workbench

🔑 Keys (4)
💰 Amounts
∑ Quantities (16)
📅 Dates (11)
☰ Categorical (11)
Other (14)
🔗 Relations (24)

Column Name	Description
MANDT FK	Client
VBELN	Freight contract number
VBTYP	TSW Details document type	Show values
POSNR	Contract item number

Column Name	Description

Column Name	Description
📏 Speed unit of measurement (SP_UOM):
SPEED	Charter contract: base speed for voyage
MIN_SPEED	Charter contract: Minimum speed
MAX_SPEED	Charter contract: Maximum speed
📏 Unit of measurement for quantity (QUAN_UOM):
MIN_QUAN	Charter contract: Minimum transport quantity
📏 Unit of measurement for capacity (CAP_UOM):
CAPACITY	Charter contract: cargo size
📏 Unit of measurement for pressure (PRES_UOM):
PRESSURE	Manifold pressure
📏 Quantity UoM for consumption (CL_UOM):
BUNKER_L	Bunker consumption laden
BUNKER_B	Bunker consumption under ballast
ST_F_CONS	Standby bunker fuel consumption
ST_D_CONS	Standby bunker diesel consumption
📏 Unit of measurement for laytime (LAY_UOM):
LAY_TOTAL	Total allowed laytime
DIS_TOTAL	Total allowed discharge laytime
📏 Unit of measurement for quantity (L_QU_UOM):
LAY_QUAN	Quantity to which laytime is related
📏 Unit of measurement for laytime (LM_UOM):
LAY_MIN	Minimum laytime
📏 Unit of measurement for timebar limit (TB_UOM):
TIMEBAR	Timebar limit
📏 Unit of measurement for quantity (MDQ_UOM):
MDQ_QUAN	Quantity to which laytime is related

Column Name	Description
VAL_FROM	Validity period start date
VAL_TO	Validity period end date
LD_START	Charter laydays start date
LD_END	Charter laydays end date
RD_START	Redelivery time start date
RD_END	Redelivery time end date
ERDAT	Date on which the record was created
ERZEIT	Time of creation
AEDAT	Last Changed On
AEZEIT	Time of day the record was changed
_DATAAGING	Data Filter Value for Data Aging

Column Name	Description
VBTYP	TSW Details document type	Show values
SINGLE_VOY	Single voyage flag	Show values
DECL	Declare flag: charterer or owner driven	Show values
DECL_QU	Declare flag: charterers or owners option	Show values
LPA	Owner's or charterer's load port agent	Show values
DPA	Owner's or charterer's discharge port agent	Show values
BLOIND	Blocking indicator	Show values
DELIND	Deletion indicator	Show values
TKTSELECT	Flag to Set Tickets Selectable	Show values
MDQB	Field - Maximum Daily Quantity	Show values
FUELB	Fuel Basis	Show values

Column Name	Description	Domain name
GRADES_NO	Number of product grades	OIJ_NUMC2
TOL_MIN	Cargo size tolerance - minimum	PRZ21
TOL_MAX	Cargo size tolerance - maximum	PRZ21
CONS_PERC	OIL-TSW: Bunker Consumption Percentage for a Transp. System	OIJ_CONS_PERC
ERNAM	Name of Person Responsible for Creating the Object	USNAM
AENAM	Name of Person Who Changed Object	USNAM
SERVTYPE	Field - Service Type	OIJ_SERVTYPE
TRANTYP	Transaction Type	OIJ_TRANTYP
PRIORITY	Capacity	OIJ_CAPACITY
SHIPPER	Connecting shipper	LIFNR
TSYST	Transport system	OIJ_TSYST
RLOCID	Location ID	OIJ_LOCID
DLOCID	Location ID	OIJ_LOCID
FUEL_PERC	OIL-TSW: Bunker Consumption Percentage for a Transp. System	OIJ_CONS_PERC

Master Data Relations	Join Conditions
Unit of measurement for capacity	`OIJ_EL_CP_LAYT.MANDT == T006.MANDT` `OIJ_EL_CP_LAYT.CAP_UOM == T006.MSEHI`
Time UoM for consumption	`OIJ_EL_CP_LAYT.MANDT == T006.MANDT` `OIJ_EL_CP_LAYT.CLT_UOM == T006.MSEHI`
Quantity UoM for consumption	`OIJ_EL_CP_LAYT.MANDT == T006.MANDT` `OIJ_EL_CP_LAYT.CL_UOM == T006.MSEHI`
Demurrage rate condition type Demurrage rate condition type Client ? ?	`OIJ_EL_CP_LAYT.COND_TYPE == T685.KSCHL` `OIJ_EL_CP_LAYT.MANDT == T685.MANDT` `OIJ_EL_CP_LAYT.[column in domain "KVEWE"] == T685.KVEWE` `OIJ_EL_CP_LAYT.[column in domain "KAPPL"] == T685.KAPPL`
Despatch rate condition type Despatch rate condition type Client ? ?	`OIJ_EL_CP_LAYT.DESP_CTYPE == T685.KSCHL` `OIJ_EL_CP_LAYT.MANDT == T685.MANDT` `OIJ_EL_CP_LAYT.[column in domain "KVEWE"] == T685.KVEWE` `OIJ_EL_CP_LAYT.[column in domain "KAPPL"] == T685.KAPPL`
Bunker diesel material group	`OIJ_EL_CP_LAYT.MANDT == T023.MANDT` `OIJ_EL_CP_LAYT.DIES_MG == T023.MATKL`
Calculation factor condition type Calculation factor condition type Client ? ?	`OIJ_EL_CP_LAYT.FACT_TYPE == T685.KSCHL` `OIJ_EL_CP_LAYT.MANDT == T685.MANDT` `OIJ_EL_CP_LAYT.[column in domain "KVEWE"] == T685.KVEWE` `OIJ_EL_CP_LAYT.[column in domain "KAPPL"] == T685.KAPPL`
Bunker fuel material group	`OIJ_EL_CP_LAYT.MANDT == T023.MANDT` `OIJ_EL_CP_LAYT.FUEL_MG == T023.MATKL`
Unit of measurement for laytime	`OIJ_EL_CP_LAYT.MANDT == T006.MANDT` `OIJ_EL_CP_LAYT.LAY_UOM == T006.MSEHI`
Lightering commencement event	`OIJ_EL_CP_LAYT.MANDT == TOIGE.CLIENT` `OIJ_EL_CP_LAYT.LC_EVENT == TOIGE.TYPE`
Unit of measurement for laytime	`OIJ_EL_CP_LAYT.MANDT == T006.MANDT` `OIJ_EL_CP_LAYT.LM_UOM == T006.MSEHI`
Unit of measurement for quantity	`OIJ_EL_CP_LAYT.MANDT == T006.MANDT` `OIJ_EL_CP_LAYT.L_QU_UOM == T006.MSEHI`
Client	`OIJ_EL_CP_LAYT.MANDT == T000.MANDT`
Unit of measurement for quantity	`OIJ_EL_CP_LAYT.MANDT == T006.MANDT` `OIJ_EL_CP_LAYT.MDQ_UOM == T006.MSEHI`
Unit of measurement for pressure	`OIJ_EL_CP_LAYT.MANDT == T006.MANDT` `OIJ_EL_CP_LAYT.PRES_UOM == T006.MSEHI`
Unit of measurement for quantity	`OIJ_EL_CP_LAYT.MANDT == T006.MANDT` `OIJ_EL_CP_LAYT.QUAN_UOM == T006.MSEHI`
Condition rate date determination	`OIJ_EL_CP_LAYT.RATE_DATE == TOIJ_DET_DATE.DATE_RULE`
Route agreed in charter contract	`OIJ_EL_CP_LAYT.MANDT == TVRO.MANDT` `OIJ_EL_CP_LAYT.ROUTE == TVRO.ROUTE`
Speed unit of measurement	`OIJ_EL_CP_LAYT.MANDT == T006.MANDT` `OIJ_EL_CP_LAYT.SP_UOM == T006.MSEHI`
Timebar start event	`OIJ_EL_CP_LAYT.MANDT == TOIGE.CLIENT` `OIJ_EL_CP_LAYT.TB_EVENT == TOIGE.TYPE`
Unit of measurement for timebar limit	`OIJ_EL_CP_LAYT.MANDT == T006.MANDT` `OIJ_EL_CP_LAYT.TB_UOM == T006.MSEHI`
TD Vehicle Number	`OIJ_EL_CP_LAYT.MANDT == OIGV.CLIENT` `OIJ_EL_CP_LAYT.VEHICLE == OIGV.VEHICLE`
TD vehicle type TD vehicle type Client	`OIJ_EL_CP_LAYT.VEH_TYPE == TOIGV.VEH_TYPE` `OIJ_EL_CP_LAYT.MANDT == TOIGV.CLIENT`
Window period event	`OIJ_EL_CP_LAYT.MANDT == TOIGE.CLIENT` `OIJ_EL_CP_LAYT.WP_EVENT == TOIGE.TYPE`