Set Trip Actual Date Time - Code: SET_TRIP_ACT_DATE_TIME

General

This page contains the JSON of the function-set Code: SET_TRIP_ACT_DATE_TIME

This function can be added in the Status Template of a TMS Trip in status: 55-FINISHED . This functionset will get the actual starting date/time and ending date/time from the boardcomputerlog and save it on the the actual date/times of the Trip.

Json code snippet: SET_TRIP_ACT_DATE_TIME

{
  "FunctionSet": {
    "TableNo": 11172786,
    "Entries": [
      {
        "EntryNo": "10000",
        "CodeunitID": "11172846",
        "FunctionCode": "SET FIELD",
        "Description": "Actual Starting Date",
        "Parameters": [
          {
            "ParameterName": "FIELDNO",
            "Value": "510"
          },
          {
            "ParameterName": "VALUE",
            "ResultFunctionSetID": {
              "FunctionSet": {
                "TableNo": 11172786,
                "DataType": "11775",
                "Entries": [
                  {
                    "EntryNo": "20000",
                    "CodeunitID": "11237200",
                    "FunctionCode": "DT2DATE",
                    "Description": "Get Date from DateTime",
                    "Parameters": [
                      {
                        "ParameterName": "DATETIME",
                        "Description": "Specifies the datetime to be converted to date.",
                        "ResultFunctionSetID": {
                          "FunctionSet": {
                            "TableNo": 11172786,
                            "DataType": "31488",
                            "Entries": [
                              {
                                "EntryNo": "10000",
                                "CodeunitID": "11172846",
                                "FunctionCode": "GET",
                                "Parameters": [
                                  {
                                    "ParameterName": "TABLENO",
                                    "Value": "11172843"
                                  },
                                  {
                                    "ParameterName": "FIELDNO",
                                    "Value": "31"
                                  },
                                  {
                                    "ParameterName": "FIELD 1",
                                    "Value": "14"
                                  },
                                  {
                                    "ParameterName": "FILTER 1",
                                    "ResultFunctionSetID": {
                                      "FunctionSet": {
                                        "TableNo": 11172786,
                                        "DataType": "31488",
                                        "Entries": [
                                          {
                                            "EntryNo": "10000",
                                            "CodeunitID": "11172846",
                                            "FunctionCode": "FIELD",
                                            "Parameters": [
                                              {
                                                "ParameterName": "FIELDNO",
                                                "Value": "2"
                                              }
                                            ]
                                          }
                                        ]
                                      }
                                    }
                                  },
                                  {
                                    "ParameterName": "CHANGECOMPANY",
                                    "DataType": "31489",
                                    "RelatedFieldNo": "0"
                                  },
                                  {
                                    "ParameterName": "FINDWHAT",
                                    "Value": "1"
                                  },
                                  {
                                    "ParameterName": "READ ISOLATION",
                                    "Value": "1"
                                  }
                                ]
                              }
                            ]
                          }
                        }
                      },
                      {
                        "ParameterName": "TIME ZONE ID",
                        "Description": "Optional: Time Zone Id in which the date time is specified. If empty, the session time zone is used."
                      }
                    ]
                  }
                ]
              }
            }
          },
          {
            "ParameterName": "VALIDATE",
            "Value": "false"
          },
          {
            "ParameterName": "MODIFY",
            "Value": "1"
          }
        ]
      },
      {
        "EntryNo": "20000",
        "CodeunitID": "11172846",
        "FunctionCode": "SET FIELD",
        "Description": "Actual Starting Time",
        "Parameters": [
          {
            "ParameterName": "FIELDNO",
            "Value": "511"
          },
          {
            "ParameterName": "VALUE",
            "ResultFunctionSetID": {
              "FunctionSet": {
                "TableNo": 11172786,
                "DataType": "11776",
                "Entries": [
                  {
                    "EntryNo": "20000",
                    "CodeunitID": "11237200",
                    "FunctionCode": "DT2TIME",
                    "Description": "Get Time from DateTime",
                    "Parameters": [
                      {
                        "ParameterName": "DATETIME",
                        "Description": "Specifies the datetime to be converted to time.",
                        "ResultFunctionSetID": {
                          "FunctionSet": {
                            "TableNo": 11172786,
                            "DataType": "31488",
                            "Entries": [
                              {
                                "EntryNo": "10000",
                                "CodeunitID": "11172846",
                                "FunctionCode": "GET",
                                "Parameters": [
                                  {
                                    "ParameterName": "TABLENO",
                                    "Value": "11172843"
                                  },
                                  {
                                    "ParameterName": "FIELDNO",
                                    "Value": "31"
                                  },
                                  {
                                    "ParameterName": "FIELD 1",
                                    "Value": "14"
                                  },
                                  {
                                    "ParameterName": "FILTER 1",
                                    "ResultFunctionSetID": {
                                      "FunctionSet": {
                                        "TableNo": 11172786,
                                        "DataType": "31488",
                                        "Entries": [
                                          {
                                            "EntryNo": "10000",
                                            "CodeunitID": "11172846",
                                            "FunctionCode": "FIELD",
                                            "Parameters": [
                                              {
                                                "ParameterName": "FIELDNO",
                                                "Value": "2"
                                              }
                                            ]
                                          }
                                        ]
                                      }
                                    }
                                  },
                                  {
                                    "ParameterName": "CHANGECOMPANY",
                                    "DataType": "31489",
                                    "RelatedFieldNo": "0"
                                  },
                                  {
                                    "ParameterName": "FINDWHAT",
                                    "Value": "1"
                                  },
                                  {
                                    "ParameterName": "READ ISOLATION",
                                    "Value": "1"
                                  }
                                ]
                              }
                            ]
                          }
                        }
                      },
                      {
                        "ParameterName": "TIME ZONE ID",
                        "Description": "Optional: Time Zone Id in which the date time is specified. If empty, the session time zone is used."
                      }
                    ]
                  }
                ]
              }
            }
          },
          {
            "ParameterName": "VALIDATE",
            "Value": "false"
          },
          {
            "ParameterName": "MODIFY",
            "Value": "1"
          }
        ]
      },
      {
        "EntryNo": "30000",
        "CodeunitID": "11172846",
        "FunctionCode": "SET FIELD",
        "Description": "Actual Ending Date",
        "Parameters": [
          {
            "ParameterName": "FIELDNO",
            "Value": "513"
          },
          {
            "ParameterName": "VALUE",
            "ResultFunctionSetID": {
              "FunctionSet": {
                "TableNo": 11172786,
                "DataType": "11775",
                "Entries": [
                  {
                    "EntryNo": "20000",
                    "CodeunitID": "11237200",
                    "FunctionCode": "DT2DATE",
                    "Description": "Get Date from DateTime",
                    "Parameters": [
                      {
                        "ParameterName": "DATETIME",
                        "Description": "Specifies the datetime to be converted to date.",
                        "ResultFunctionSetID": {
                          "FunctionSet": {
                            "TableNo": 11172786,
                            "DataType": "31488",
                            "Entries": [
                              {
                                "EntryNo": "10000",
                                "CodeunitID": "11172846",
                                "FunctionCode": "GET",
                                "Parameters": [
                                  {
                                    "ParameterName": "TABLENO",
                                    "Value": "11172843"
                                  },
                                  {
                                    "ParameterName": "FIELDNO",
                                    "Value": "32"
                                  },
                                  {
                                    "ParameterName": "FIELD 1",
                                    "Value": "14"
                                  },
                                  {
                                    "ParameterName": "FILTER 1",
                                    "ResultFunctionSetID": {
                                      "FunctionSet": {
                                        "TableNo": 11172786,
                                        "DataType": "31488",
                                        "Entries": [
                                          {
                                            "EntryNo": "10000",
                                            "CodeunitID": "11172846",
                                            "FunctionCode": "FIELD",
                                            "Parameters": [
                                              {
                                                "ParameterName": "FIELDNO",
                                                "Value": "2"
                                              }
                                            ]
                                          }
                                        ]
                                      }
                                    }
                                  },
                                  {
                                    "ParameterName": "CHANGECOMPANY",
                                    "DataType": "31489",
                                    "RelatedFieldNo": "0"
                                  },
                                  {
                                    "ParameterName": "FINDWHAT",
                                    "Value": "2"
                                  },
                                  {
                                    "ParameterName": "READ ISOLATION",
                                    "Value": "1"
                                  }
                                ]
                              }
                            ]
                          }
                        }
                      },
                      {
                        "ParameterName": "TIME ZONE ID",
                        "Description": "Optional: Time Zone Id in which the date time is specified. If empty, the session time zone is used."
                      }
                    ]
                  }
                ]
              }
            }
          },
          {
            "ParameterName": "VALIDATE",
            "Value": "false"
          },
          {
            "ParameterName": "MODIFY",
            "Value": "1"
          }
        ]
      },
      {
        "EntryNo": "40000",
        "CodeunitID": "11172846",
        "FunctionCode": "SET FIELD",
        "Description": "Actual Ending Time",
        "Parameters": [
          {
            "ParameterName": "FIELDNO",
            "Value": "514"
          },
          {
            "ParameterName": "VALUE",
            "ResultFunctionSetID": {
              "FunctionSet": {
                "TableNo": 11172786,
                "DataType": "11776",
                "Entries": [
                  {
                    "EntryNo": "20000",
                    "CodeunitID": "11237200",
                    "FunctionCode": "DT2TIME",
                    "Description": "Get Time from DateTime",
                    "Parameters": [
                      {
                        "ParameterName": "DATETIME",
                        "Description": "Specifies the datetime to be converted to time.",
                        "ResultFunctionSetID": {
                          "FunctionSet": {
                            "TableNo": 11172786,
                            "DataType": "31488",
                            "Entries": [
                              {
                                "EntryNo": "10000",
                                "CodeunitID": "11172846",
                                "FunctionCode": "GET",
                                "Parameters": [
                                  {
                                    "ParameterName": "TABLENO",
                                    "Value": "11172843"
                                  },
                                  {
                                    "ParameterName": "FIELDNO",
                                    "Value": "32"
                                  },
                                  {
                                    "ParameterName": "FIELD 1",
                                    "Value": "14"
                                  },
                                  {
                                    "ParameterName": "FILTER 1",
                                    "ResultFunctionSetID": {
                                      "FunctionSet": {
                                        "TableNo": 11172786,
                                        "DataType": "31488",
                                        "Entries": [
                                          {
                                            "EntryNo": "10000",
                                            "CodeunitID": "11172846",
                                            "FunctionCode": "FIELD",
                                            "Parameters": [
                                              {
                                                "ParameterName": "FIELDNO",
                                                "Value": "2"
                                              }
                                            ]
                                          }
                                        ]
                                      }
                                    }
                                  },
                                  {
                                    "ParameterName": "CHANGECOMPANY",
                                    "DataType": "31489",
                                    "RelatedFieldNo": "0"
                                  },
                                  {
                                    "ParameterName": "FINDWHAT",
                                    "Value": "2"
                                  },
                                  {
                                    "ParameterName": "READ ISOLATION",
                                    "Value": "1"
                                  }
                                ]
                              }
                            ]
                          }
                        }
                      },
                      {
                        "ParameterName": "TIME ZONE ID",
                        "Description": "Optional: Time Zone Id in which the date time is specified. If empty, the session time zone is used."
                      }
                    ]
                  }
                ]
              }
            }
          },
          {
            "ParameterName": "VALIDATE",
            "Value": "true"
          },
          {
            "ParameterName": "MODIFY",
            "Value": "2"
          }
        ]
      }
    ]
  }
}