Versions Compared

Old Version 13

changes.mady.by.user Bao TRINH

Saved on

compared with

New Version 14

changes.mady.by.user Cam Mackay

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Overview

Provides access to Workbench Activity data.

Endpoints

The resources

Overview

Provides access to Workbench Activity data.

Endpoints

The resources available in this module.

ActivitiesListApi

Return all Workbench Activities

ActivityListApi

Provides API access to the Activities (#/Admin/ActivityList.aspx) Web Workbench screen.

/api/ActivityListApi

Method

Performed As

Request Query

Request Body

Response

POST
Returns all Workbench Activities as in the Activity list screen.Logged in Retrieve a filtered list of Activities.

Admin User

--

GridRequestParametersApi

GridResult<ActivityLine>

ActivityLookupApi

Return filtered Workbench ActivitiesProvides API access to the Activities Lookup functionality.

/api/ActivityLookupApi

Method

Performed As

Request Query

Request Body

Response

POST
Returns all filtered Workbench ActivitiesLogged in Retrieve a filtered list of Activities, for a specific Job and Financial Company

Admin User

--

GridRequestParametersApi

GridResult<ActivityLookupLine>

Models

The definitions of models specific to endpoints in this module.

AdminActivityLine

ActivityKey

Property

Type

Description

ActivityCode

String

The unique code

for

of the

activity

Activity.

ActivityLine

Description Description of the activity

Property

String

Type

Description

Key

ActivityKey

The unique key for the line.

ActivityCode

String

The unique code of the Activity.

ActivityCodeValue

CellData

The unique code of the Activity.

Description

String

The description of the Activity.

DescriptionValue

CellData

The description of the Activity.

ActivityCodeDescription

String

The Activity Code and Description.

ActivityType

String

Type of activity this is and where it can be used in Workbench. 

CostCategoryActivityTypeValue

StringCellData

 Category Type of activityActivitySubType this is and where it can be used in Workbench. 

CostCategory

String

 Subcategory  Category of activity.

GstTypeCostCategorySequenceNo

StringInteger

Type of GST

WorkCentreCode The Sequence Number of the Category.

CostCategoryValue

String

The default Work Centre for this Category of activity.

SalesCodeActivitySubType

StringThe Sales Code attributed to this activity

The sub-type of the Activity.

DrGLAccountActivitySubTypeValue

String

The General Ledger account that this activity will debit to.

CrGLAccount

String

The General Ledger account that this activity will credit to.

UpdatedDate

String

 Date of last update.

ActivityCodeValue

CellData

 The code for the activity.

DescriptionValue

CellData

 Activity description

ActivityTypeValue

CellData

Activity type

CostCategoryValue

String

  

CostCategorySequenceNo

Integer

 

GstTypeValue

CellData

Tax type

ActivitySubTypeValue

CellData

Sub type of Activity

WorkCentreCodeValue

CellData

 Code of the Work centre

SalesCodeValue

CellData

 Sale codeCellData

The sub-type of the Activity.

GstType

String

Type of GST

GstTypeValue

CellData

Type of GST

WorkCentreCode

String

The default Work Centre for this activity.

WorkCentreCodeValue

CellData

The default Work Centre for this activity.

SalesCode

String

The Sales Code attributed to this activity.

SalesCodeValue

CellData

The Sales Code attributed to this activity.

DrGLAccount

String

The General Ledger account that this activity will debit to.

DrGLAccountValue

CellData

 The General Ledger account that this activity will debit to.

CrGLAccount

String

The General Ledger account that this activity will credit to.

CrGLAccountValue

CellData

The General Ledger account that this activity will credit to.

BaseCostValue

Boolean

The cost areas of the Employee Class will be transferred to the transaction, and which ones will be ignored.

OverheadCostValue

Boolean

The cost areas of the Employee Class will be transferred to the transaction, and which ones will be ignored.

OtherCostValue

Boolean

The cost areas of the Employee Class will be transferred to the transaction, and which ones will be ignored.

AllowanceCostValue

Boolean

The cost areas of the Employee Class will be transferred to the transaction, and which ones will be ignored.

Time1CostValue

Boolean

The cost areas of the Employee Class will be transferred to the transaction, and which ones will be ignored.

Time2CostValue

Boolean

The cost areas of the Employee Class will be transferred to the transaction, and which ones will be ignored.

Time3CostValue

Boolean

The cost areas of the Employee Class will be transferred to the transaction, and which ones will be ignored.

InactiveValue

Boolean

Select

CellData

IncludedValue

CellData

Included

Boolean

Inactive

Integer

Selected

CellData

Delete

CellData

Status

String

ReadonlyFlag

Integer

ReadonlyMessage

String

OriginalKey

AdminActivityKey

CurrentKey

AdminActivityKey

Key

AdminActivityKey

Index

IntegerThe Inactive flag on the Activity.

UpdatedDate

String

The Date this record was last updated.

⬆️ Back to top

AdminActivityKey

ActivityLookupLine

ActivityCode

Property

Type

Description

Key

LookupKey

The unique key for the line.

Code

CellData

The unique code of the Activity.

Description

String

The description of the Activity code.

RetentionActivityCodeActivityType

String

Retention info

CopyFromActivity

Boolean

Source The type of the Activity.

ActivitySubType

String

The sub-type of the Activity.

 ⬆️ Back to top

Examples

Get the list of Activities.

Expand
titleClick to view.

Request

Code Block
languagejson
{
 "predicate": {
  "PredicateRows": [{
    "LeftOperand": "ActivityCode",
    "Operator": "Eq",
    "RightOperand": [ "" ],
    "Display": true
   }
  ]
 },
 "sidx": "ActivityCode",
 "sord": "asc",
 "page": 1,
 "rows": 20
}

Response

Code Block
languagejson
GridResult_AdminActivityLine {
total (integer, optional),
page (integer, optional),
records (integer, optional),
rows (Array[AdminActivityLine], optional),
form (object, optional),
widgets (Array[ViewData_GridWidget], optional)
}
AdminActivityLine {
ActivityCode (string, optional),
Description (string, optional),
ActivityCodeDescription (string, optional),
ActivityType (string, optional),
CostCategory (string, optional),
ActivitySubType (string, optional),
GstType (string, optional),
WorkCentreCode (string, optional),
SalesCode (string, optional),
DrGLAccount (string, optional),
CrGLAccount (string, optional),
UpdatedDate (string, optional),
ActivityCodeValue (CellData, optional),
DescriptionValue (CellData, optional),
ActivityTypeValue (CellData, optional),
CostCategoryValue (string, optional),
CostCategorySequenceNo (integer, optional),
GstTypeValue (CellData, optional),
ActivitySubTypeValue (CellData, optional),
WorkCentreCodeValue (CellData, optional),
SalesCodeValue (CellData, optional),
DrGLAccountValue (CellData, optional),
CrGLAccountValue (CellData, optional),
BaseCostValue (boolean, optional),
OverheadCostValue (boolean, optional),
OtherCostValue (boolean, optional),
AllowanceCostValue (boolean, optional),
Time1CostValue (boolean, optional),
Time2CostValue (boolean, optional),
Time3CostValue (boolean, optional),
InactiveValue (boolean, optional),
Select (CellData, optional),
IncludedValue (CellData, optional),
Included (boolean, optional),
Inactive (integer, optional),
Selected (CellData, optional),
Delete (CellData, optional),
Status (string, optional),
ReadonlyFlag (integer, optional),
ReadonlyMessage (string, optional),
OriginalKey (AdminActivityKey, optional),
CurrentKey (AdminActivityKey, optional),
Key (AdminActivityKey, optional),
Index (integer, optional)
}
ViewData_GridWidget {
WidgetId (integer, optional),
LayoutCode (string, optional),
Name (string, optional),
Colour (string, optional),
BGColour (string, optional),
Icon (string, optional),
Type (string, optional),
Visible (boolean, optional),
Order (integer, optional),
Count (integer, optional),
WidgetLines (Array[ViewData_GridWidgetLine], optional)
}
CellData {
CellId (string, optional),
CellValue (string, optional),
CellNumValue (number, optional),
CellBoolValue (boolean, optional),
CellTag (string, optional),
CellValueDate (string, optional),
CellValueInt (integer, optional)
}
AdminActivityKey {
ActivityCode (string, optional),
RetentionActivityCode (string, optional),
CopyFromActivity (boolean, optional)
}
ViewData_GridWidgetLine {
WidgetLineId (integer, optional),
WidgetId (integer, optional),
Name (string, optional),
Predicate (string, optional),
Order (integer, optional),
Count (integer, optional)
}

Response Sample

Code Block
languagejson
GridResult_AdminActivityLine {
total (integer, optional),
page (integer, optional),
records (integer, optional),
rows (Array[AdminActivityLine], optional),
form (object, optional),
widgets (Array[ViewData_GridWidget], optional)
}
AdminActivityLine {
ActivityCode (string, optional),
Description (string, optional),
ActivityCodeDescription (string, optional),
ActivityType (string, optional),
CostCategory (string, optional),
ActivitySubType (string, optional),
GstType (string, optional),
WorkCentreCode (string, optional),
SalesCode (string, optional),
DrGLAccount (string, optional),
CrGLAccount (string, optional),
UpdatedDate (string, optional),
ActivityCodeValue (CellData, optional),
DescriptionValue (CellData, optional),
ActivityTypeValue (CellData, optional),
CostCategoryValue (string, optional),
CostCategorySequenceNo (integer, optional),
GstTypeValue (CellData, optional),
ActivitySubTypeValue (CellData, optional),
WorkCentreCodeValue (CellData, optional),
SalesCodeValue (CellData, optional),
DrGLAccountValue (CellData, optional),
CrGLAccountValue (CellData, optional),
BaseCostValue (boolean, optional),
OverheadCostValue (boolean, optional),
OtherCostValue (boolean, optional),
AllowanceCostValue (boolean, optional),
Time1CostValue (boolean, optional),
Time2CostValue (boolean, optional),
Time3CostValue (boolean, optional),
InactiveValue (boolean, optional),
Select (CellData, optional),
IncludedValue (CellData, optional),
Included (boolean, optional),
Inactive (integer, optional),
Selected (CellData, optional),
Delete (CellData, optional),
Status (string, optional),
ReadonlyFlag (integer, optional),
ReadonlyMessage (string, optional),
OriginalKey (AdminActivityKey, optional),
CurrentKey (AdminActivityKey, optional),
Key (AdminActivityKey, optional),
Index (integer, optional)
}
ViewData_GridWidget {
WidgetId (integer, optional),
LayoutCode (string, optional),
Name (string, optional),
Colour (string, optional),
BGColour (string, optional),
Icon (string, optional),
Type (string, optional),
Visible (boolean, optional),
Order (integer, optional),
Count (integer, optional),
WidgetLines (Array[ViewData_GridWidgetLine], optional)
}
CellData {
CellId (string, optional),
CellValue (string, optional),
CellNumValue (number, optional),
CellBoolValue (boolean, optional),
CellTag (string, optional),
CellValueDate (string, optional),
CellValueInt (integer, optional)
}
AdminActivityKey {
ActivityCode (string, optional),
RetentionActivityCode (string, optional),
CopyFromActivity (boolean, optional)
}
ViewData_GridWidgetLine {
WidgetLineId (integer, optional),
WidgetId (integer, optional),
Name (string, optional),
Predicate (string, optional),
Order (integer, optional),
Count (integer, optional)
}

Get list of filtered activity

Expand
titleClick to view.

Request

Code Block
languagejson
GridRequestParametersApi {
predicate (DynamicPredicateApi),
sidx (string),
sord (string),
page (integer),
rows (integer),
jobCode (string, optional),
finCoCode (string, optional),
functionalCode (string, optional) = ['General', 'PurchaseOrders', 'PurchaseOrderApproval', 'PurchaseRequisitions', 'Timesheets', 'TimesheetReviews', 'TimesheetApproval', 'TimesheetApprovalList', 'ServiceLog', 'ServiceDesk', 'ExpenseClaims', 'ExpenseClaimReviews', 'ExpenseClaimApproval', 'ExpenseClaimAdminApproval', 'TabletTimesheet', 'TabletTimePlant', 'Scheduler', 'LeaveManagement', 'LeaveTypeManagement', 'CrewTimesheets', 'Refueling', 'HumanResources', 'DailyDiary', 'Datasheets', 'Stock', 'LogDaysheet', 'PortalPeople', 'PortalCompany', 'Workflow', 'Reporting', 'ProfitCentres', 'ExternalSalesCodes', 'InternalSalesCodes', 'ActivityReportCode', 'ProfitCentreReportCode', 'SalesCodeReportCode', 'Batch', 'Budget', 'Billing', 'TimeCodes', 'Disbursement', 'Jobs', 'ApInvoices', 'Adjustments', 'Plant', 'NonStockLocation', 'JobContract', 'Processes', 'JobReceipt', 'Forecast', 'SubContracts', 'WorkOrderApproval', 'StockItem', 'ApInvoiceApproval', 'ApCreditApproval', 'TimesheetAdminApproval', 'DocketEntry', 'Revenue', 'Vouchers', 'VoucherApproval', 'Quotes', 'ProductionMeasures', 'StockIssue', 'Utilities', 'SubcontractClaimWorkflowApproval', 'BulkInvoice', 'WorkOrder', 'DocumentRegister', 'Activities', 'SalesCodes', 'ContractorDaysheet', 'Materials', 'ExternalPlant', 'JobInvoices', 'BillOfMaterials', 'Users', 'Daysheet', 'Procurement', 'DocketReconciliation', 'Imports', 'ScheduleStoredProcedure', 'Internal', 'TrustAccount', 'Impersonation', 'SubContractRetentionTrustAccount', 'ContractRetentionTrustAccount'],
IntValue (integer, optional),
StringValue (string, optional),
BoolValue (boolean, optional),
DateValue (string, optional)
}
DynamicPredicateApi {
PredicateRows (Array[DynamicPredicateRowApi]),
IsOr (boolean, optional)
}
DynamicPredicateRowApi {
LeftOperand (string),
Operator (string) = ['Lt', 'Gt', 'Eq', 'Ne', 'Le', 'Ge', 'Like', 'IsOneOf', 'IsNotOneOf', 'Between', 'StartsWith', 'StartsWithIsOneOf', 'Either'],
RightOperand (Array[string]),
Display (boolean, optional)
}

Response

Code Block
languagejson
GridResult_LookupsActivityLine {
total (integer, optional),
page (integer, optional),
records (integer, optional),
rows (Array[LookupsActivityLine], optional),
form (object, optional),
widgets (Array[ViewData_GridWidget], optional)
}
LookupsActivityLine {
ActivityType (string, optional),
ActivitySubType (string, optional),
Code (CellData, optional),
Description (string, optional),
Status (string, optional),
ReadonlyFlag (integer, optional),
ReadonlyMessage (string, optional),
OriginalKey (LookupsLookupKey, optional),
CurrentKey (LookupsLookupKey, optional),
Key (LookupsLookupKey, optional),
Index (integer, optional)
}
ViewData_GridWidget {
WidgetId (integer, optional),
LayoutCode (string, optional),
Name (string, optional),
Colour (string, optional),
BGColour (string, optional),
Icon (string, optional),
Type (string, optional),
Visible (boolean, optional),
Order (integer, optional),
Count (integer, optional),
WidgetLines (Array[ViewData_GridWidgetLine], optional)
}
CellData {
CellId (string, optional),
CellValue (string, optional),
CellNumValue (number, optional),
CellBoolValue (boolean, optional),
CellTag (string, optional),
CellValueDate (string, optional),
CellValueInt (integer, optional)
}
LookupsLookupKey {
Code (string, optional)
}
ViewData_GridWidgetLine {
WidgetLineId (integer, optional),
WidgetId (integer, optional),
Name (string, optional),
Predicate (string, optional),
Order (integer, optional),
Count (integer, optional)
}

Response Sample

Code Block
languagejson
{
  "total": 0,
  "page": 0,
  "records": 0,
  "rows": [
    {
      "ActivityType": "string",
      "ActivitySubType": "string",
      "Code": {
        "CellId": "string",
        "CellValue": "string",
        "CellNumValue": 0,
        "CellBoolValue": true,
        "CellTag": "string",
        "CellValueDate": "2024-03-27T00:42:16.507Z",
        "CellValueInt": 0
      },
      "Description": "string",
      "Status": "string",
      "ReadonlyFlag": 0,
      "ReadonlyMessage": "string",
      "OriginalKey": {
        "Code": "string"
      },
      "CurrentKey": {
        "Code": "string"
      },
      "Key": {
        "Code": "string"
      },
      "Index": 0
    }
  ],
  "form": {},
  "widgets": [
    {
      "WidgetId": 0,
      "LayoutCode": "string",
      "Name": "string",
      "Colour": "string",
      "BGColour": "string",
      "Icon": "string",
      "Type": "string",
      "Visible": true,
      "Order": 0,
      "Count": 0,
      "WidgetLines": [
        {
          "WidgetLineId": 0,
          "WidgetId": 0,
          "Name": "string",
          "Predicate": "string",
          "Order": 0,
          "Count": 0
        }
      ]
    }
  ]
}

⬆️ Back to top

On this page

Table of Contents
minLevel1
maxLevel2
outlinefalse
styledefault
typelist
printablefalse