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. |