Q35AddF1205EquipmentMessageLog

Cantara Business function which inserts a record into the F1205 Equipment Log Message table.


Data Structure:

Name

Data Type

Inclusion

Direction

Parameter Notes

NUMB_mnAssetItemNumber

ASSETNUMBER

REQUIRED

BOTH

Must be valid F1201 record; ‘0626’ error if invalid.

ALPH_szNameAlpha

STRING

REQUIRED

BOTH

40 character string

EXPL_szExplanationFull

STRING

OPTIONAL

BOTH

1200 character string

DTE_jdDate

DATE

OPTIONAL

BOTH

Populate this to override current date, but TDAY must be populated as well.

DTECent_mnDateCentury

INTEGER

OPTIONAL

BOTH

Two digit century; 20 for 2024, 19 for 1996

TDT_jdDateScheduledTickler

DATE

OPTIONAL

BOTH

Default today’s date if blank.  If MOH contains value, this will be blanked out.

MOH_mnAmtMilesOrHoursUnit

FLOAT

OPTIONAL

BOTH

Cannot be negative number

EMT_cEquipmentMessageType

UDC

OPTIONAL

BOTH

UDC 12|EM; error ‘073Y’ if invalid

ITST_cItemMessageStatus

UDC

OPTIONAL

BOTH

UDC H12|IS; error ‘018A’ if invalid

LCT_jdDtLastChanged

DATE

OPTIONAL

BOTH

Default today’s date if blank. 

DSVJ_jdDateServiceCurrency

DATE

OPTIONAL

BOTH


ASPU_mnAmtSchedulePrimaryUm

FLOAT

OPTIONAL

BOTH


ASSU_mnAmtScheduleSecondUm

FLOAT

OPTIONAL

BOTH


ASD_mnAmountScheduleDays

FLOAT

OPTIONAL

BOTH


AALM_mnAmtActLastServMiHr

FLOAT

OPTIONAL

BOTH


AALP_mnAmtActLastServPriUm

FLOAT

OPTIONAL

BOTH


AALS_mnAmtActLastServSecUm

FLOAT

OPTIONAL

BOTH


AALD_mnAmtActLastServDays

FLOAT

OPTIONAL

BOTH


CMM_cCalcuMethodMilesHrs

CHARACTER

OPTIONAL

BOTH


CMPU_cCalculaMethodPriUm

CHARACTER

OPTIONAL

BOTH


CMSU_cCalculaMethodSecondUm

CHARACTER

OPTIONAL

BOTH


CMDY_cCalculationMethodDays

CHARACTER

OPTIONAL

BOTH


EV01_cSuppressErrors

CHARACTER

OPTIONAL

IN

‘1’ to suppress NER error

EV01_cErrorMessage

CHARACTER

OPTIONAL

OUT

‘1’ if error exists

DTAI_szErrorDataItem

ERRORALIAS

OPTIONAL

OUT

Error code

TDAY_mnTimeOfDay

INTEGER

OPTIONAL

BOTH

Populate this to override current TDAY, but DTE must be populated as well.