System Fields

System Fields

All tables have the following fields

Field Value Source

CreatedAt TimeStamp Record Created CreatedBy User Id (API logon) Id Unique Record Identifier CurrentRevision Tracks Revision History Starts at 0 UpdatedAt TimeStamp Record Updated UpdatedBy User Id (API logon) Workflow Stage Workflow Stage for Record Defined in the platform

[
  {
    "Id": 9919,
    "Name": "Created At",
    "SystemName": "CreatedAt",
    "ShortName": "CreatedAt",
    "ReadOnly": true,
    "Required": false,
    "FieldType": 3,
    "OneToMany": false,
    "MatrixRows": []
  },
  {
    "Id": 9920,
    "Name": "Created By",
    "SystemName": "CreatedBy",
    "ShortName": "CreatedBy",
    "ReadOnly": true,
    "Required": false,
    "FieldType": 5,
    "OneToMany": false,
    "MatrixRows": []
  },
  {
    "Id": 9918,
    "Name": "Current Revision",
    "SystemName": "Version",
    "ShortName": "Version",
    "ReadOnly": true,
    "Required": false,
    "FieldType": 2,
    "OneToMany": false,
    "MatrixRows": []
  },
  {
    "Id": 9926,
    "Name": "Deleted",
    "SystemName": "Deleted",
    "ShortName": "Deleted",
    "ReadOnly": true,
    "Required": false,
    "FieldType": 10,
    "OneToMany": false,
    "MatrixRows": []
  },
  {
    "Id": 9917,
    "Name": "Id",
    "SystemName": "Id",
    "ShortName": "Id",
    "ReadOnly": true,
    "Required": false,
    "FieldType": 2,
    "OneToMany": false,
    "MatrixRows": []
  },
  {
    "Id": 9929,
    "Name": "Published Revision",
    "SystemName": "PublishedVersion",
    "ShortName": "PublishedVersion",
    "ReadOnly": true,
    "Required": false,
    "FieldType": 2,
    "OneToMany": false,
    "MatrixRows": []
  },
  {
    "Id": 9922,
    "Name": "Updated At",
    "SystemName": "UpdatedAt",
    "ShortName": "UpdatedAt",
    "ReadOnly": true,
    "Required": false,
    "FieldType": 3,
    "OneToMany": false,
    "MatrixRows": []
  },
  {
    "Id": 9923,
    "Name": "Updated By",
    "SystemName": "UpdatedBy",
    "ShortName": "UpdatedBy",
    "ReadOnly": true,
    "Required": false,
    "FieldType": 5,
    "OneToMany": false,
    "MatrixRows": []
  },
  {
    "Id": 9927,
    "Name": "Workflow Stage",
    "SystemName": "WorkflowStage",
    "ShortName": "WorkflowStage",
    "ReadOnly": true,
    "Required": false,
    "FieldType": 5,
    "OneToMany": false,
    "MatrixRows": []
  }
]

The Analytics table as two additional fields

[
  {
    "Id": 9949,
    "Name": "Begin Date",
    "SystemName": "BeginDate",
    "ShortName": "BeginDate",
    "ReadOnly": true,
    "Required": false,
    "FieldType": 3,
    "OneToMany": false,
    "MatrixRows": []
  },
  {
    "Id": 9950,
    "Name": "End Date",
    "SystemName": "EndDate",
    "ShortName": "EndDate",
    "ReadOnly": true,
    "Required": false,
    "FieldType": 3,
    "OneToMany": false,
    "MatrixRows": []
  }
]