Versions Compared

Old Version 10

changes.mady.by.user Bao TRINH

Saved on

compared with

New Version 11

changes.mady.by.user Cam Mackay

Saved on

Key

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

Overview

Provides access to Batch related data. In Workbench, documents are stored in batches before they can be exported to the financial software. These APIs are about these batches.

Endpoints

BatchDetailApi

Return or create batch

The resources available in this module.

BatchListApi

Provides API access to the Export Control(#/Batch/BatchList.aspx) Web Workbench screen.

/api/

BatchDetailApi

BatchListApi

Method

Description

Performed As

Request Query

Request Body

Response

GET

Get Batch with JobTransactions for a BatchID

-

POST

Create a new batch or update existing batch with batch transactions.

BatchListApi

Reuse or return a new System Batch for Workbench Import or list of all Workbench batches

Retrieve (and create, if necessary) the default System Batch for the specified Type, Date, Location, and Financial Company.

Logged in User

SystemBatchKey

-

SystemBatchModel

POST

Retrieve a filtered list of Batches.

Logged in User

-

GridRequestParametersApi

GridResult<BatchLine>

BatchDetailApi

Return or create batch Web Workbench screen.

/api/

BatchListApi-

BatchDetailApi

Method

Description

Performed As

Request Query

Request Body

Response

GET

Reuse or returns a new System Batch for Workbench Import. Requires: BatchType, LocationCode, FinCoCode, YearNo and PeriodNo

Get Batch with JobTransactions for a BatchID

-

POST

Return all Workbench batches

Create a new batch or update existing batch with batch transactions.

Models

The definitions of models specific to endpoints in this module.

SystemBatchApiModel

.

SystemBatchKey

Property

Type

Description

BatchType

String

The Batch Type. (required)

DocDate

DateTime

The Date. (required)

LocationCode

String

The Code of the Location. (required)

FinCoCode

String

The Code of the Financial Company. (required)

BatchGroup

String

 The Batch Group.

SystemBatchModel

Property

Type

Description

BatchNo

Integer

The Batch number.

BatchType

stringString

Type of the batchBatch.

BatchDate

StringTo

determines what period the batch is createdThe end date of the Period of the Batch..

PeriodNo

Integer

The period of the batchBatch.

YearNo

Integer

The year of the batchBatch

CreatedById

Integer

[The ID of user or account?]the user who created the Batch.

CreatedDateTime

String

Date The date and time when the batch is Batch was created.

LocationCode

String

The location Location Code from the financial companyFinancial Company.

CompanyCode

String

The Financial Company Code of the company for the batchBatch.

BatchReference

String

Reference textThe Batch reference.

BatchNotes

String

The Batch comment.

ClosedFlagReversingJournal

IntegerReversingJournal

The Reversing Journal flag on the Batch.

ClosedFlag

Integer

ReversingJournal

IntegerThe Closed flag on the Batch.

ClosedDate

String

Date the batch is The date the Batch was closed.

ClosedById

Integer

Code The ID of person the user who close closed the batchBatch.

NotForExportFlag

IntegerFlag

to mark the batch is for exporting or notThe Not For Export flag on the Batch.

NotForExportDate

String

Date the batch is The date the Batch was marked as Not for For Export.

NotForExportId

Integer

Code The ID of person the user who marked batch the Batch as Not for For Export.

ExportDate

StringDate

of the exportThe date the Batch was exported.

ExportedById

String

Code The ID of person the user who made exported the exportBatch.

ExportStatus

String

Includes: The status of the Batch (Created, In progressProgress, Error, Successful).

⬆️ Back to top

 

GridResult_BatchBatchLine

BatchLine

Property

Type

Description

Total

Integer

Total number of batches

Page

Integer

Page

Records

Integer

Records

Rows

Array

Array [BatchBatchLine]

Form

Object

 

Widgets

 

ViewData_GridWidget

⬆️ Back to top

 

BatchBatchFields

Property

Type

Description

BatchNo

StringViewData

 Number of the batch

BatchType

StringViewData

Batch type. 

BatchDate

DateViewData

Batch date.

Period

StringViewData

The financial period of the batch 

CreatedBy

StringViewData

Person who created the batch

CreatedDate

DateViewData

Created date.. 

Location

StringViewData

Location in the batch

FinancialCompany

StringViewData

Financial company for the batch

Closed

BoolViewData

Status of the batch

ClosedDate

DateViewData

Date the batch has been closed.

ClosedBy

StringViewData

Who closed the batch.

Exported

BoolViewData

Export status of the batch.

ExportedDate

DateViewData

Export date.

ExportedBy

StringViewData

Who exported the batch. 

NotForExport

BoolViewData

The batch is not for exporting.

NotForExportDate

DateViewData

Date marked as Not for Export 

NotForExportBy

StringViewData

 Who marked Not for Export.

Reference

StringViewData

Reference text.

BatchNotes

StringViewData

Notes/comments

ReversalOfBatch

StringViewData

 

HiddenBatchNotes

String

 

BatchStatus

StringViewData

 Status of the batch

BatchTotal

DecimalViewData

 

ReversingJournal

BoolViewData

 

Print

SplitButtonViewData

AttachmentsDialog

FileAttachmentsViewData

 

Import

ButtonViewData

 

ImportAdjustment

SplitButtonViewData

 

PayrollPeriod

OptionsViewData

 

Currency

PickerViewData

 The currency

FcConversionRate

DecimalViewData

Foreign currency conversation rate. 

UseForeignCurrency

Boolean

Foreign currency status.

 ⬆️ Back to top

BatchBatchKey

Property

Type

Description

BatchNo

Integer

 Batch number/code

BatchType

String

 Batch type.

FinCoCode

String

 Code of the finance company

Exported

Boolean

 Exported status.

InterCoStatus

String

 

HasExportErrored

Boolean

 The exporting error status.

⬆️ Back to top

BatchBatchLine

Property

Type

Description

Type

String

 Line type

BatchNo

Integer

 Batch number

Date

String

 Date

Year

String

Year 

Period

Integer

The financial period 

YearPeriodIndex

Integer

 

CreatedDate

String

Date created.

CreatedById

Integer

ID of person who created the batch. 

CreatedByName

String

 Name of person who created the batch. 

FinancialCompany

String

 Financial company.

Location

String

Location. 

Reference

String

 Reference text

Notes

String

 Batch note

Reversal

Integer

 

Closed

Boolean

 Status of the batch.

ReversingJournal

Boolean

 

ClosedById

Integer

Code of person who closed the batch.

NotForExport

Boolean

Value of Not For Export flag.

Exported

Boolean

Exported status. 

ExportedById

Integer

ID of person exported the batch.

ExportDate

String

Exported date. 

ClosedDate

String

Closed date.

ExportStatus

String

 Export status.

InterCoStatus

String

Status of inter-company. 

Select

CellData

 

Export

CellData

 

TypeValue

CellData

Batch type.

BatchNoValue

CellData

Batch number. 

DateValue

CellData

Batch date.

YearPeriodValue

CellData

Financial year period of the batch. 

CreatedByValue

CellData

Person who created the batch.

FinancialCompanyValue

CellData

Financial company. 

ReferenceValue

CellData

Reference text

NotesValue

CellData

Batch note.

ReversalValue

CellData

 

ClosedValue

CellData

Closed status. 

NotForExportValue

CellData

Value of Not for Export flag.

ClosedDateValue

CellData

 Closed date.

ExportDateValue

CellData

Exported date. 

ExportStatusValue

CellData

Export status.

InterCo

CellData

Internal company. 

InterCoStatusValue

CellData

Internal company.  

BatchStatus

String

Batch status.

Status

String

Batch status. 

ReadonlyFlag

Integer

Value of Read-Only property.

ReadonlyMessage

String

 

OriginalKey

BatchBatchKey

 

CurrentKey

BatchBatchKey

 

Key

BatchBatchKey

 

Index

Integer

 

⬆️ Back to top

 

JobTransactionApiModel

Property

Type

Description

Key

JobTransactionsJobTransactionKey

 

Fields

BatchBatchFields

 

Rows

Array [JobTransactionsJobTransactionLine]

 

ValidationErrors

Array [MvcValidationError]

 

⬆️ Back to top

 

JobTransactionsJobTransactionKey

Property

Type

Description

BatchNo

Integer

 Number of the batch.

BatchType

String

Batch type. 

⬆️ Back to top

 

JobTransactionsJobTransactionDetailKey

Property

Type

Description

JobTranId

Integer

 

PersonId

Integer

 Person id.

JobCode

String

 Job code.

FinCoCode

String

Code of financial company. 

ActivityCode

String

Activity code.

ActivityCodeValue

String

 Activity code.

ActivityType

String

Activity type.

ActivitySubType

String

Activity sub type 

WorkCentreCode

String

Code of Work Centre.

WorkCentreCodeValue

String

Code of Work Centre. 

ItemId

Integer

 Item id.

StockLocationCodeValue

String

Stock location code. 

CostRateValue

Number

 Cost rate.

BatchType

String

Batch type 

OrderDerivedLine

Boolean

DocketDerivedLine

Boolean

 

StockDerivedLine

Boolean

 

Type

String

  = ['InwardsGoodsEntry', 'InwardsGoodsEdit', 'Issue', 'Return', 'Transfer', 'Requisition']

PurchaseOrderLineIdValue

Integer

 Purchase Order line id.

LogHeaderId

Integer

 Log header id.

KeyName

String

 

CompanyId

Integer

 company id.

GSTTypeCodeValue

String

 

 ⬆️ Back to top

 JobTransactionsJobTransactionLine

Field

Type

Description

Property

String

 

LogHeaderID

Integer

Log header id.

lFcCost

Number

Foreign currency code

FcRetail

Number

Foreign currency retail.

PurchaseOrderLineId

Integer

Purchase Order line id.

StockLocationInactive

Boolean

 

Unit

String

Unit

EnteredByID

Integer

ID of person who entered data.

SourceID

Integer

 

FCGST

Number

Foreign currency tax.

JobCodeValue

CellData

Job code.

LogHeader

CellData

Job code.

ActivityCodeValue

CellData

Activity code.

WorkCentreCodeValue

CellData

Work Centre code. 

QuantityValue

CellData

Quantity

FcCostValue

CellData

Foreign currency cost.

CostValue

CellData

Cost.

GSTTypeValue

CellData

Tax type. 

GSTTypeCodeValue

CellData

Code of tax type.

GSTRateValue

CellData

Tax rate

GSTValue

CellData

Tax value 

NetValueValue

CellData

Net value

ReferenceValue

CellData

Reference.

FcRetailValue

CellData

Foreign currency retail

RetailValue

CellData

Retail.

LineDescriptionValue

CellData

Description of line

DetailsValue

CellData

Details 

FromPONumberValue

CellData

 From Purchase Order number

PurchaseOrderLineIdValue

CellData

 Purchase Order line id.

StockLocationCodeValue

CellData

 

StockItemCodeValue

CellData

 Stock item code.

TotalLineCostValue

CellData

Total line cost.

CostRateValue

CellData

 Cost rate.

UnitValue

CellData

 Unit.

FCGSTValue

CellData

 Foreign currency tax.

Delete

CellData

 

Serials

CellData

 

SerialRows

Array [TabletSerialLine]

 

Status

String

 Status.

ReadonlyFlag

Integer

 

ReadonlyMessage

String

 

OriginalKey

JobTransactionsJobTransactionDetailKey

 

CurrentKey

JobTransactionsJobTransactionDetailKey

 

Key

JobTransactionsJobTransactionDetailKey

 

Index

Integer

 

⬆️ Back to top

 

Sample

Returns a new Batch for Workbench Import.

Expand
titleClick to view

Request

Code Block
languagejson
{
 "predicate": {
  "PredicateRows": [{
    "LeftOperand": "Closed",
    "Operator": "Eq",
    "RightOperand": [ "true" ],
    "Display": true
   }, 
   {
    "LeftOperand": "Exported",
    "Operator": "Eq",
    "RightOperand": ["false"],
    "Display": true
   }
  ]
 },
 "sidx": "Date",
 "sord": "desc",
 "page": 1,
 "rows": 20,
 "StringValue": "Adjustment,Adj Reversal,AP Credit,AP Invoice,AR Credit,AR Internal,AR Invoice,AR Receipt,CCC Accrual,Disbursement,Docket,Payroll,Plant Issue,PO Accrual,Revenue Journal,SCC Accrual,Stock Adjust,Stock Issue,Stock Qty,Stock Return,Stock Trf,Stock Value,Sub Claim,Timesheet,WIP Accrual"
}

Response

Code Block
languagejson
SystemBatchApiModel {
BatchNo (Integer, optional),
BatchType (string, optional),
BatchDate (string, optional),
PeriodNo (Integer, optional),
YearNo (Integer, optional),
CreatedById (Integer, optional),
CreatedDateTime (string, optional),
LocationCode (string, optional),
CompanyCode (string, optional),
BatchReference (string, optional),
BatchNotes (string, optional),
ClosedFlag (Integer, optional),
ReversingJournal (Integer, optional),
ClosedDate (string, optional),
ClosedById (Integer, optional),
NotForExportFlag (Integer, optional),
NotForExportDate (string, optional),
NotForExportId (Integer, optional),
ExportDate (string, optional),
ExportedById (Integer, optional),
ExportStatus (string, optional)
}

Response Sample

Code Block
languagejson
{
  "BatchNo": 224049,
  "BatchType": "AP Invoice",
  "BatchDate": "2023-11-30T00:00:00",
  "PeriodNo": 5,
  "YearNo": 2024,
  "CreatedDateTime": "2023-11-07T11:42:47.44",
  "LocationCode": "0",
  "CompanyCode": "01",
  "BatchReference": "AP Invoice Auto",
  "ClosedFlag": 0,
  "ReversingJournal": 0,
  "NotForExportFlag": 0
}

Get the list of Workbench batches

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_BatchBatchLine {
total (Integer, optional),
page (Integer, optional),
records (Integer, optional),
rows (Array[BatchBatchLine], optional),
form (object, optional),
widgets (Array[ViewData_GridWidget], optional)
}
BatchBatchLine {
Type (string, optional),
BatchNo (Integer, optional),
Date (string, optional),
Year (Integer, optional),
Period (Integer, optional),
YearPeriodIndex (Integer, optional),
CreatedDate (string, optional),
CreatedById (Integer, optional),
CreatedByName (string, optional),
FinancialCompany (string, optional),
Location (string, optional),
Reference (string, optional),
Notes (string, optional),
Reversal (Integer, optional),
Closed (boolean, optional),
ReversingJournal (boolean, optional),
ClosedById (Integer, optional),
NotForExport (boolean, optional),
Exported (boolean, optional),
ExportedById (Integer, optional),
ExportDate (string, optional),
ClosedDate (string, optional),
ExportStatus (string, optional),
InterCoStatus (string, optional),
Select (CellData, optional),
Export (CellData, optional),
TypeValue (CellData, optional),
BatchNoValue (CellData, optional),
DateValue (CellData, optional),
YearPeriodValue (CellData, optional, read only),
CreatedByValue (CellData, optional),
FinancialCompanyValue (CellData, optional),
ReferenceValue (CellData, optional),
NotesValue (CellData, optional),
ReversalValue (CellData, optional),
ClosedValue (CellData, optional),
NotForExportValue (CellData, optional),
ClosedDateValue (CellData, optional),
ExportDateValue (CellData, optional),
ExportStatusValue (CellData, optional),
InterCo (CellData, optional),
InterCoStatusValue (CellData, optional),
BatchStatus (string, optional),
Status (string, optional),
ReadonlyFlag (Integer, optional),
ReadonlyMessage (string, optional),
OriginalKey (BatchBatchKey, optional),
CurrentKey (BatchBatchKey, optional),
Key (BatchBatchKey, 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)
}
BatchBatchKey {
BatchNo (Integer, optional),
BatchType (string, optional),
FinCoCode (string, optional),
Exported (boolean, optional),
InterCoStatus (string, optional),
HasExportErrored (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
{
  "total": 13,
  "page": 1,
  "records": 253,
  "rows": [
    {
      "Type": "AP Invoice",
      "BatchNo": 224066,
      "Date": "2024-03-31T00:00:00",
      "Year": 2024,
      "Period": 9,
      "YearPeriodIndex": 24297,
      "CreatedDate": "2024-03-07T10:54:30.63",
      "FinancialCompany": "01",
      "Location": "0",
      "Reference": "AP Invoice Auto",
      "Notes": "This batch was flagged as Not For Export by WebWorkbench Admin on 13-Mar-2024\r\nThis batch was flagged as Closed by WebWorkbench Admin on 13-Mar-2024",
      "Closed": true,
      "ReversingJournal": false,
      "ClosedById": 340,
      "NotForExport": true,
      "Exported": false,
      "ExportStatus": "[Blank]",
      "Select": {
        "CellId": "224066",
        "CellValue": "224066",
        "CellTag": "224066"
      },
      "Export": {
        "CellBoolValue": false
      },
      "TypeValue": {
        "CellValue": "AP Invoice"
      },
      "BatchNoValue": {
        "CellId": "UpdatePopupDialog",
        "CellValue": "224066",
        "CellBoolValue": false,
        "CellTag": "224066"
      },
      "DateValue": {
        "CellValue": "31-Mar-2024",
        "CellValueDate": "2024-03-31T00:00:00"
      },
      "YearPeriodValue": {
        "CellValue": "2024/09"
      },
      "CreatedByValue": {
        "CellId": ""
      },
      "FinancialCompanyValue": {
        "CellId": "01",
        "CellValue": "01"
      },
      "ReferenceValue": {
        "CellValue": "AP Invoice Auto"
      },
      "NotesValue": {
        "CellValue": "This batch was flagged as Not For Export by WebWorkbench Admin on 13-Mar-2024\r\nThis batch was flagged as Closed by WebWorkbench Admin on 13-Mar-2024"
      },
      "ReversalValue": {},
      "ClosedValue": {
        "CellBoolValue": true
      },
      "NotForExportValue": {
        "CellBoolValue": true
      },
      "ExportDateValue": {},
      "ExportStatusValue": {
        "CellId": "StatusPopupDialog",
        "CellBoolValue": true
      },
      "InterCo": {
        "CellBoolValue": false
      },
      "InterCoStatusValue": {
        "CellId": "InterCoStatusPopupDialog",
        "CellBoolValue": true
      },
      "ReadonlyFlag": 0,
      "OriginalKey": {
        "BatchNo": 224066,
        "BatchType": "AP Invoice",
        "FinCoCode": "01",
        "Exported": false,
        "HasExportErrored": false
      },
      "CurrentKey": {
        "BatchNo": 224066,
        "BatchType": "AP Invoice",
        "FinCoCode": "01",
        "Exported": false,
        "HasExportErrored": false
      },
      "Key": {
        "BatchNo": 224066,
        "BatchType": "AP Invoice",
        "FinCoCode": "01",
        "Exported": false,
        "HasExportErrored": false
      },
      "Index": 0
    },
    {
      "Type": "AP Invoice",
      "BatchNo": 224067,
      "Date": "2024-03-31T00:00:00",
      "Year": 2024,
      "Period": 9,
      "YearPeriodIndex": 24297,
      "CreatedDate": "2024-03-13T10:32:13.49",
      "FinancialCompany": "01",
      "Location": "EQUIP",
      "Reference": "AP Invoice Auto",
      "Notes": "This batch was flagged as Closed by WebWorkbench Admin on 13-Mar-2024\r\nThis batch was flagged as Not For Export by WebWorkbench Admin on 13-Mar-2024",
      "Closed": true,
      "ReversingJournal": false,
      "ClosedById": 340,
      "NotForExport": true,
      "Exported": false,
      "ExportStatus": "[Blank]",
      "Select": {
        "CellId": "224067",
        "CellValue": "224067",
        "CellTag": "224067"
      },
      "Export": {
        "CellBoolValue": false
      },
      "TypeValue": {
        "CellValue": "AP Invoice"
      },
      "BatchNoValue": {
        "CellId": "UpdatePopupDialog",
        "CellValue": "224067",
        "CellBoolValue": false,
        "CellTag": "224067"
      },
      "DateValue": {
        "CellValue": "31-Mar-2024",
        "CellValueDate": "2024-03-31T00:00:00"
      },
      "YearPeriodValue": {
        "CellValue": "2024/09"
      },
      "CreatedByValue": {
        "CellId": ""
      },
      "FinancialCompanyValue": {
        "CellId": "01",
        "CellValue": "01"
      },
      "ReferenceValue": {
        "CellValue": "AP Invoice Auto"
      },
      "NotesValue": {
        "CellValue": "This batch was flagged as Closed by WebWorkbench Admin on 13-Mar-2024\r\nThis batch was flagged as Not For Export by WebWorkbench Admin on 13-Mar-2024"
      },
      "ReversalValue": {},
      "ClosedValue": {
        "CellBoolValue": true
      },
      "NotForExportValue": {
        "CellBoolValue": true
      },
      "ExportDateValue": {},
      "ExportStatusValue": {
        "CellId": "StatusPopupDialog",
        "CellBoolValue": true
      },
      "InterCo": {
        "CellBoolValue": false
      },
      "InterCoStatusValue": {
        "CellId": "InterCoStatusPopupDialog",
        "CellBoolValue": true
      },
      "ReadonlyFlag": 0,
      "OriginalKey": {
        "BatchNo": 224067,
        "BatchType": "AP Invoice",
        "FinCoCode": "01",
        "Exported": false,
        "HasExportErrored": false
      },
      "CurrentKey": {
        "BatchNo": 224067,
        "BatchType": "AP Invoice",
        "FinCoCode": "01",
        "Exported": false,
        "HasExportErrored": false
      },
      "Key": {
        "BatchNo": 224067,
        "BatchType": "AP Invoice",
        "FinCoCode": "01",
        "Exported": false,
        "HasExportErrored": false
      },
      "Index": 0
    },
    {
      "Type": "AP Invoice",
      "BatchNo": 224070,
      "Date": "2024-03-31T00:00:00",
      "Year": 2024,
      "Period": 9,
      "YearPeriodIndex": 24297,
      "CreatedDate": "2024-03-13T00:00:00",
      "CreatedById": 340,
      "CreatedByName": "WebWorkbench Admin",
      "FinancialCompany": "BAOT",
      "Location": "0",
      "Reference": "AP Invoice-2024/09-3",
      "Notes": "This batch was flagged as Not For Export by WebWorkbench Admin on 13-Mar-2024\r\nThis batch was flagged as Closed by WebWorkbench Admin on 13-Mar-2024",
      "Closed": true,
      "ReversingJournal": false,
      "ClosedById": 340,
      "NotForExport": true,
      "Exported": false,
      "ExportStatus": "[Blank]",
      "Select": {
        "CellId": "224070",
        "CellValue": "224070",
        "CellTag": "224070"
      },
      "Export": {
        "CellBoolValue": false
      },
      "TypeValue": {
        "CellValue": "AP Invoice"
      },
      "BatchNoValue": {
        "CellId": "UpdatePopupDialog",
        "CellValue": "224070",
        "CellBoolValue": false,
        "CellTag": "224070"
      },
      "DateValue": {
        "CellValue": "31-Mar-2024",
        "CellValueDate": "2024-03-31T00:00:00"
      },
      "YearPeriodValue": {
        "CellValue": "2024/09"
      },
      "CreatedByValue": {
        "CellId": "340",
        "CellValue": "WebWorkbench Admin"
      },
      "FinancialCompanyValue": {
        "CellId": "BAOT",
        "CellValue": "BAOT"
      },
      "ReferenceValue": {
        "CellValue": "AP Invoice-2024/09-3"
      },
      "NotesValue": {
        "CellValue": "This batch was flagged as Not For Export by WebWorkbench Admin on 13-Mar-2024\r\nThis batch was flagged as Closed by WebWorkbench Admin on 13-Mar-2024"
      },
      "ReversalValue": {},
      "ClosedValue": {
        "CellBoolValue": true
      },
      "NotForExportValue": {
        "CellBoolValue": true
      },
      "ExportDateValue": {},
      "ExportStatusValue": {
        "CellId": "StatusPopupDialog",
        "CellBoolValue": true
      },
      "InterCo": {
        "CellBoolValue": false
      },
      "InterCoStatusValue": {
        "CellId": "InterCoStatusPopupDialog",
        "CellBoolValue": true
      },
      "ReadonlyFlag": 0,
      "OriginalKey": {
        "BatchNo": 224070,
        "BatchType": "AP Invoice",
        "FinCoCode": "BAOT",
        "Exported": false,
        "HasExportErrored": false
      },
      "CurrentKey": {
        "BatchNo": 224070,
        "BatchType": "AP Invoice",
        "FinCoCode": "BAOT",
        "Exported": false,
        "HasExportErrored": false
      },
      "Key": {
        "BatchNo": 224070,
        "BatchType": "AP Invoice",
        "FinCoCode": "BAOT",
        "Exported": false,
        "HasExportErrored": false
      },
      "Index": 0
    },
    {
      "Type": "AP Invoice",
      "BatchNo": 224071,
      "Date": "2024-03-31T00:00:00",
      "Year": 2024,
      "Period": 9,
      "YearPeriodIndex": 24297,
      "CreatedDate": "2024-03-13T15:21:37.54",
      "FinancialCompany": "BAOT",
      "Location": "LTEST",
      "Reference": "AP Invoice Auto",
      "Notes": "This batch was flagged as Not For Export by WebWorkbench Admin on 13-Mar-2024\r\nThis batch was flagged as Closed by WebWorkbench Admin on 13-Mar-2024",
      "Closed": true,
      "ReversingJournal": false,
      "ClosedById": 340,
      "NotForExport": true,
      "Exported": false,
      "ExportStatus": "[Blank]",
      "Select": {
        "CellId": "224071",
        "CellValue": "224071",
        "CellTag": "224071"
      },
      "Export": {
        "CellBoolValue": false
      },
      "TypeValue": {
        "CellValue": "AP Invoice"
      },
      "BatchNoValue": {
        "CellId": "UpdatePopupDialog",
        "CellValue": "224071",
        "CellBoolValue": false,
        "CellTag": "224071"
      },
      "DateValue": {
        "CellValue": "31-Mar-2024",
        "CellValueDate": "2024-03-31T00:00:00"
      },
      "YearPeriodValue": {
        "CellValue": "2024/09"
      },
      "CreatedByValue": {
        "CellId": ""
      },
      "FinancialCompanyValue": {
        "CellId": "BAOT",
        "CellValue": "BAOT"
      },
      "ReferenceValue": {
        "CellValue": "AP Invoice Auto"
      },
      "NotesValue": {
        "CellValue": "This batch was flagged as Not For Export by WebWorkbench Admin on 13-Mar-2024\r\nThis batch was flagged as Closed by WebWorkbench Admin on 13-Mar-2024"
      },
      "ReversalValue": {},
      "ClosedValue": {
        "CellBoolValue": true
      },
      "NotForExportValue": {
        "CellBoolValue": true
      },
      "ExportDateValue": {},
      "ExportStatusValue": {
        "CellId": "StatusPopupDialog",
        "CellBoolValue": true
      },
      "InterCo": {
        "CellBoolValue": false
      },
      "InterCoStatusValue": {
        "CellId": "InterCoStatusPopupDialog",
        "CellBoolValue": true
      },
      "ReadonlyFlag": 0,
      "OriginalKey": {
        "BatchNo": 224071,
        "BatchType": "AP Invoice",
        "FinCoCode": "BAOT",
        "Exported": false,
        "HasExportErrored": false
      },
      "CurrentKey": {
        "BatchNo": 224071,
        "BatchType": "AP Invoice",
        "FinCoCode": "BAOT",
        "Exported": false,
        "HasExportErrored": false
      },
      "Key": {
        "BatchNo": 224071,
        "BatchType": "AP Invoice",
        "FinCoCode": "BAOT",
        "Exported": false,
        "HasExportErrored": false
      },
      "Index": 0
    },
    {
      "Type": "AP Credit",
      "BatchNo": 224075,
      "Date": "2024-03-31T00:00:00",
      "Year": 2024,
      "Period": 9,
      "YearPeriodIndex": 24297,
      "CreatedDate": "2024-03-19T12:01:29.77",
      "FinancialCompany": "01",
      "Location": "0",
      "Reference": "Auto",
      "Closed": true,
      "ReversingJournal": false,
      "NotForExport": false,
      "Exported": false,
      "ExportStatus": "[Blank]",
      "Select": {
        "CellId": "224075",
        "CellValue": "224075",
        "CellTag": "224075"
      },
      "Export": {
        "CellBoolValue": false
      },
      "TypeValue": {
        "CellValue": "AP Credit"
      },
      "BatchNoValue": {
        "CellId": "UpdatePopupDialog",
        "CellValue": "224075",
        "CellBoolValue": false,
        "CellTag": "224075"
      },
      "DateValue": {
        "CellValue": "31-Mar-2024",
        "CellValueDate": "2024-03-31T00:00:00"
      },
      "YearPeriodValue": {
        "CellValue": "2024/09"
      },
      "CreatedByValue": {
        "CellId": ""
      },
      "FinancialCompanyValue": {
        "CellId": "01",
        "CellValue": "01"
      },
      "ReferenceValue": {
        "CellValue": "Auto"
      },
      "NotesValue": {},
      "ReversalValue": {},
      "ClosedValue": {
        "CellBoolValue": true
      },
      "NotForExportValue": {
        "CellBoolValue": false
      },
      "ExportDateValue": {},
      "ExportStatusValue": {
        "CellId": "StatusPopupDialog",
        "CellBoolValue": true
      },
      "InterCo": {
        "CellBoolValue": false
      },
      "InterCoStatusValue": {
        "CellId": "InterCoStatusPopupDialog",
        "CellBoolValue": true
      },
      "ReadonlyFlag": 0,
      "OriginalKey": {
        "BatchNo": 224075,
        "BatchType": "AP Credit",
        "FinCoCode": "01",
        "Exported": false,
        "HasExportErrored": false
      },
      "CurrentKey": {
        "BatchNo": 224075,
        "BatchType": "AP Credit",
        "FinCoCode": "01",
        "Exported": false,
        "HasExportErrored": false
      },
      "Key": {
        "BatchNo": 224075,
        "BatchType": "AP Credit",
        "FinCoCode": "01",
        "Exported": false,
        "HasExportErrored": false
      },
      "Index": 0
    },
    {
      "Type": "AR Invoice",
      "BatchNo": 724024,
      "Date": "2024-03-31T00:00:00",
      "Year": 2024,
      "Period": 9,
      "YearPeriodIndex": 24297,
      "CreatedDate": "2024-03-13T16:09:55.457",
      "FinancialCompany": "01",
      "Location": "0",
      "Reference": "AR Invoice Auto",
      "Closed": true,
      "ReversingJournal": false,
      "ClosedById": 340,
      "NotForExport": false,
      "Exported": false,
      "ExportStatus": "Error",
      "Select": {
        "CellId": "724024",
        "CellValue": "724024",
        "CellTag": "724024"
      },
      "Export": {
        "CellBoolValue": false
      },
      "TypeValue": {
        "CellValue": "AR Invoice"
      },
      "BatchNoValue": {
        "CellId": "UpdatePopupDialog",
        "CellValue": "724024",
        "CellBoolValue": false,
        "CellTag": "724024"
      },
      "DateValue": {
        "CellValue": "31-Mar-2024",
        "CellValueDate": "2024-03-31T00:00:00"
      },
      "YearPeriodValue": {
        "CellValue": "2024/09"
      },
      "CreatedByValue": {
        "CellId": ""
      },
      "FinancialCompanyValue": {
        "CellId": "01",
        "CellValue": "01"
      },
      "ReferenceValue": {
        "CellValue": "AR Invoice Auto"
      },
      "NotesValue": {},
      "ReversalValue": {},
      "ClosedValue": {
        "CellBoolValue": true
      },
      "NotForExportValue": {
        "CellBoolValue": false
      },
      "ExportDateValue": {},
      "ExportStatusValue": {
        "CellId": "StatusPopupDialog",
        "CellValue": "Error",
        "CellBoolValue": false
      },
      "InterCo": {
        "CellBoolValue": false
      },
      "InterCoStatusValue": {
        "CellId": "InterCoStatusPopupDialog",
        "CellBoolValue": true
      },
      "ReadonlyFlag": 0,
      "OriginalKey": {
        "BatchNo": 724024,
        "BatchType": "AR Invoice",
        "FinCoCode": "01",
        "Exported": false,
        "HasExportErrored": true
      },
      "CurrentKey": {
        "BatchNo": 724024,
        "BatchType": "AR Invoice",
        "FinCoCode": "01",
        "Exported": false,
        "HasExportErrored": true
      },
      "Key": {
        "BatchNo": 724024,
        "BatchType": "AR Invoice",
        "FinCoCode": "01",
        "Exported": false,
        "HasExportErrored": true
      },
      "Index": 0
    },
    {
      "Type": "AR Invoice",
      "BatchNo": 724028,
      "Date": "2024-03-31T00:00:00",
      "Year": 2024,
      "Period": 9,
      "YearPeriodIndex": 24297,
      "CreatedDate": "2024-03-15T13:43:30.773",
      "FinancialCompany": "03",
      "Location": "0",
      "Reference": "AR Invoice Auto",
      "Closed": true,
      "ReversingJournal": false,
      "ClosedById": 340,
      "NotForExport": false,
      "Exported": false,
      "ExportStatus": "Error",
      "Select": {
        "CellId": "724028",
        "CellValue": "724028",
        "CellTag": "724028"
      },
      "Export": {
        "CellBoolValue": false
      },
      "TypeValue": {
        "CellValue": "AR Invoice"
      },
      "BatchNoValue": {
        "CellId": "UpdatePopupDialog",
        "CellValue": "724028",
        "CellBoolValue": false,
        "CellTag": "724028"
      },
      "DateValue": {
        "CellValue": "31-Mar-2024",
        "CellValueDate": "2024-03-31T00:00:00"
      },
      "YearPeriodValue": {
        "CellValue": "2024/09"
      },
      "CreatedByValue": {
        "CellId": ""
      },
      "FinancialCompanyValue": {
        "CellId": "03",
        "CellValue": "03"
      },
      "ReferenceValue": {
        "CellValue": "AR Invoice Auto"
      },
      "NotesValue": {},
      "ReversalValue": {},
      "ClosedValue": {
        "CellBoolValue": true
      },
      "NotForExportValue": {
        "CellBoolValue": false
      },
      "ExportDateValue": {},
      "ExportStatusValue": {
        "CellId": "StatusPopupDialog",
        "CellValue": "Error",
        "CellBoolValue": false
      },
      "InterCo": {
        "CellBoolValue": false
      },
      "InterCoStatusValue": {
        "CellId": "InterCoStatusPopupDialog",
        "CellBoolValue": true
      },
      "ReadonlyFlag": 0,
      "OriginalKey": {
        "BatchNo": 724028,
        "BatchType": "AR Invoice",
        "FinCoCode": "03",
        "Exported": false,
        "HasExportErrored": true
      },
      "CurrentKey": {
        "BatchNo": 724028,
        "BatchType": "AR Invoice",
        "FinCoCode": "03",
        "Exported": false,
        "HasExportErrored": true
      },
      "Key": {
        "BatchNo": 724028,
        "BatchType": "AR Invoice",
        "FinCoCode": "03",
        "Exported": false,
        "HasExportErrored": true
      },
      "Index": 0
    },
    {
      "Type": "AR Credit",
      "BatchNo": 724034,
      "Date": "2024-03-31T00:00:00",
      "Year": 2024,
      "Period": 9,
      "YearPeriodIndex": 24297,
      "CreatedDate": "2024-03-19T12:02:03.107",
      "FinancialCompany": "01",
      "Location": "0",
      "Reference": "Auto",
      "Closed": true,
      "ReversingJournal": false,
      "NotForExport": false,
      "Exported": false,
      "ExportStatus": "[Blank]",
      "Select": {
        "CellId": "724034",
        "CellValue": "724034",
        "CellTag": "724034"
      },
      "Export": {
        "CellBoolValue": false
      },
      "TypeValue": {
        "CellValue": "AR Credit"
      },
      "BatchNoValue": {
        "CellId": "UpdatePopupDialog",
        "CellValue": "724034",
        "CellBoolValue": false,
        "CellTag": "724034"
      },
      "DateValue": {
        "CellValue": "31-Mar-2024",
        "CellValueDate": "2024-03-31T00:00:00"
      },
      "YearPeriodValue": {
        "CellValue": "2024/09"
      },
      "CreatedByValue": {
        "CellId": ""
      },
      "FinancialCompanyValue": {
        "CellId": "01",
        "CellValue": "01"
      },
      "ReferenceValue": {
        "CellValue": "Auto"
      },
      "NotesValue": {},
      "ReversalValue": {},
      "ClosedValue": {
        "CellBoolValue": true
      },
      "NotForExportValue": {
        "CellBoolValue": false
      },
      "ExportDateValue": {},
      "ExportStatusValue": {
        "CellId": "StatusPopupDialog",
        "CellBoolValue": true
      },
      "InterCo": {
        "CellBoolValue": false
      },
      "InterCoStatusValue": {
        "CellId": "InterCoStatusPopupDialog",
        "CellBoolValue": true
      },
      "ReadonlyFlag": 0,
      "OriginalKey": {
        "BatchNo": 724034,
        "BatchType": "AR Credit",
        "FinCoCode": "01",
        "Exported": false,
        "HasExportErrored": false
      },
      "CurrentKey": {
        "BatchNo": 724034,
        "BatchType": "AR Credit",
        "FinCoCode": "01",
        "Exported": false,
        "HasExportErrored": false
      },
      "Key": {
        "BatchNo": 724034,
        "BatchType": "AR Credit",
        "FinCoCode": "01",
        "Exported": false,
        "HasExportErrored": false
      },
      "Index": 0
    },
    {
      "Type": "Adjustment",
      "BatchNo": 424019,
      "Date": "2024-03-13T00:00:00",
      "Year": 2024,
      "Period": 9,
      "YearPeriodIndex": 24297,
      "CreatedDate": "2024-03-13T16:57:14.073",
      "FinancialCompany": "01",
      "Location": "0",
      "Reference": "Inwards Goods",
      "Closed": true,
      "ReversingJournal": false,
      "NotForExport": false,
      "Exported": false,
      "ExportStatus": "[Blank]",
      "Select": {
        "CellId": "424019",
        "CellValue": "424019",
        "CellTag": "424019"
      },
      "Export": {
        "CellBoolValue": false
      },
      "TypeValue": {
        "CellValue": "Adjustment"
      },
      "BatchNoValue": {
        "CellId": "UpdatePopupDialog",
        "CellValue": "424019",
        "CellBoolValue": false,
        "CellTag": "424019"
      },
      "DateValue": {
        "CellValue": "13-Mar-2024",
        "CellValueDate": "2024-03-13T00:00:00"
      },
      "YearPeriodValue": {
        "CellValue": "2024/09"
      },
      "CreatedByValue": {
        "CellId": ""
      },
      "FinancialCompanyValue": {
        "CellId": "01",
        "CellValue": "01"
      },
      "ReferenceValue": {
        "CellValue": "Inwards Goods"
      },
      "NotesValue": {},
      "ReversalValue": {},
      "ClosedValue": {
        "CellBoolValue": true
      },
      "NotForExportValue": {
        "CellBoolValue": false
      },
      "ExportDateValue": {},
      "ExportStatusValue": {
        "CellId": "StatusPopupDialog",
        "CellBoolValue": true
      },
      "InterCo": {
        "CellBoolValue": false
      },
      "InterCoStatusValue": {
        "CellId": "InterCoStatusPopupDialog",
        "CellBoolValue": true
      },
      "ReadonlyFlag": 0,
      "OriginalKey": {
        "BatchNo": 424019,
        "BatchType": "Adjustment",
        "FinCoCode": "01",
        "Exported": false,
        "HasExportErrored": false
      },
      "CurrentKey": {
        "BatchNo": 424019,
        "BatchType": "Adjustment",
        "FinCoCode": "01",
        "Exported": false,
        "HasExportErrored": false
      },
      "Key": {
        "BatchNo": 424019,
        "BatchType": "Adjustment",
        "FinCoCode": "01",
        "Exported": false,
        "HasExportErrored": false
      },
      "Index": 0
    },
    {
      "Type": "AP Invoice",
      "BatchNo": 224063,
      "Date": "2024-03-01T00:00:00",
      "Year": 2024,
      "Period": 9,
      "YearPeriodIndex": 24297,
      "CreatedDate": "2024-02-02T00:00:00",
      "CreatedById": 340,
      "CreatedByName": "WebWorkbench Admin",
      "FinancialCompany": "01",
      "Location": "0",
      "Reference": "AP Invoice-2024/09-3",
      "Notes": "This batch was flagged as Not For Export by WebWorkbench Admin on 13-Mar-2024\r\nThis batch was flagged as Closed by WebWorkbench Admin on 13-Mar-2024",
      "Closed": true,
      "ReversingJournal": false,
      "ClosedById": 340,
      "NotForExport": true,
      "Exported": false,
      "ExportStatus": "[Blank]",
      "Select": {
        "CellId": "224063",
        "CellValue": "224063",
        "CellTag": "224063"
      },
      "Export": {
        "CellBoolValue": false
      },
      "TypeValue": {
        "CellValue": "AP Invoice"
      },
      "BatchNoValue": {
        "CellId": "UpdatePopupDialog",
        "CellValue": "224063",
        "CellBoolValue": false,
        "CellTag": "224063"
      },
      "DateValue": {
        "CellValue": "01-Mar-2024",
        "CellValueDate": "2024-03-01T00:00:00"
      },
      "YearPeriodValue": {
        "CellValue": "2024/09"
      },
      "CreatedByValue": {
        "CellId": "340",
        "CellValue": "WebWorkbench Admin"
      },
      "FinancialCompanyValue": {
        "CellId": "01",
        "CellValue": "01"
      },
      "ReferenceValue": {
        "CellValue": "AP Invoice-2024/09-3"
      },
      "NotesValue": {
        "CellValue": "This batch was flagged as Not For Export by WebWorkbench Admin on 13-Mar-2024\r\nThis batch was flagged as Closed by WebWorkbench Admin on 13-Mar-2024"
      },
      "ReversalValue": {},
      "ClosedValue": {
        "CellBoolValue": true
      },
      "NotForExportValue": {
        "CellBoolValue": true
      },
      "ExportDateValue": {},
      "ExportStatusValue": {
        "CellId": "StatusPopupDialog",
        "CellBoolValue": true
      },
      "InterCo": {
        "CellBoolValue": false
      },
      "InterCoStatusValue": {
        "CellId": "InterCoStatusPopupDialog",
        "CellBoolValue": true
      },
      "ReadonlyFlag": 0,
      "OriginalKey": {
        "BatchNo": 224063,
        "BatchType": "AP Invoice",
        "FinCoCode": "01",
        "Exported": false,
        "HasExportErrored": false
      },
      "CurrentKey": {
        "BatchNo": 224063,
        "BatchType": "AP Invoice",
        "FinCoCode": "01",
        "Exported": false,
        "HasExportErrored": false
      },
      "Key": {
        "BatchNo": 224063,
        "BatchType": "AP Invoice",
        "FinCoCode": "01",
        "Exported": false,
        "HasExportErrored": false
      },
      "Index": 0
    },
    {
      "Type": "AP Invoice",
      "BatchNo": 224057,
      "Date": "2024-01-31T00:00:00",
      "Year": 2024,
      "Period": 7,
      "YearPeriodIndex": 24295,
      "CreatedDate": "2024-01-12T11:12:30.16",
      "FinancialCompany": "01",
      "Location": "LAB",
      "Reference": "AP Invoice Auto",
      "Closed": true,
      "ReversingJournal": false,
      "ClosedById": 340,
      "NotForExport": false,
      "Exported": false,
      "ExportStatus": "[Blank]",
      "Select": {
        "CellId": "224057",
        "CellValue": "224057",
        "CellTag": "224057"
      },
      "Export": {
        "CellBoolValue": false
      },
      "TypeValue": {
        "CellValue": "AP Invoice"
      },
      "BatchNoValue": {
        "CellId": "UpdatePopupDialog",
        "CellValue": "224057",
        "CellBoolValue": false,
        "CellTag": "224057"
      },
      "DateValue": {
        "CellValue": "31-Jan-2024",
        "CellValueDate": "2024-01-31T00:00:00"
      },
      "YearPeriodValue": {
        "CellValue": "2024/07"
      },
      "CreatedByValue": {
        "CellId": ""
      },
      "FinancialCompanyValue": {
        "CellId": "01",
        "CellValue": "01"
      },
      "ReferenceValue": {
        "CellValue": "AP Invoice Auto"
      },
      "NotesValue": {},
      "ReversalValue": {},
      "ClosedValue": {
        "CellBoolValue": true
      },
      "NotForExportValue": {
        "CellBoolValue": false
      },
      "ExportDateValue": {},
      "ExportStatusValue": {
        "CellId": "StatusPopupDialog",
        "CellBoolValue": true
      },
      "InterCo": {
        "CellBoolValue": false
      },
      "InterCoStatusValue": {
        "CellId": "InterCoStatusPopupDialog",
        "CellBoolValue": true
      },
      "ReadonlyFlag": 0,
      "OriginalKey": {
        "BatchNo": 224057,
        "BatchType": "AP Invoice",
        "FinCoCode": "01",
        "Exported": false,
        "HasExportErrored": false
      },
      "CurrentKey": {
        "BatchNo": 224057,
        "BatchType": "AP Invoice",
        "FinCoCode": "01",
        "Exported": false,
        "HasExportErrored": false
      },
      "Key": {
        "BatchNo": 224057,
        "BatchType": "AP Invoice",
        "FinCoCode": "01",
        "Exported": false,
        "HasExportErrored": false
      },
      "Index": 0
    },
    {
      "Type": "AP Credit",
      "BatchNo": 224061,
      "Date": "2024-01-31T00:00:00",
      "Year": 2024,
      "Period": 7,
      "YearPeriodIndex": 24295,
      "CreatedDate": "2024-01-26T14:22:11",
      "FinancialCompany": "03",
      "Location": "0",
      "Reference": "AP Credit Auto",
      "Closed": true,
      "ReversingJournal": false,
      "ClosedById": 340,
      "NotForExport": false,
      "Exported": false,
      "ExportStatus": "[Blank]",
      "Select": {
        "CellId": "224061",
        "CellValue": "224061",
        "CellTag": "224061"
      },
      "Export": {
        "CellBoolValue": false
      },
      "TypeValue": {
        "CellValue": "AP Credit"
      },
      "BatchNoValue": {
        "CellId": "UpdatePopupDialog",
        "CellValue": "224061",
        "CellBoolValue": false,
        "CellTag": "224061"
      },
      "DateValue": {
        "CellValue": "31-Jan-2024",
        "CellValueDate": "2024-01-31T00:00:00"
      },
      "YearPeriodValue": {
        "CellValue": "2024/07"
      },
      "CreatedByValue": {
        "CellId": ""
      },
      "FinancialCompanyValue": {
        "CellId": "03",
        "CellValue": "03"
      },
      "ReferenceValue": {
        "CellValue": "AP Credit Auto"
      },
      "NotesValue": {},
      "ReversalValue": {},
      "ClosedValue": {
        "CellBoolValue": true
      },
      "NotForExportValue": {
        "CellBoolValue": false
      },
      "ExportDateValue": {},
      "ExportStatusValue": {
        "CellId": "StatusPopupDialog",
        "CellBoolValue": true
      },
      "InterCo": {
        "CellBoolValue": false
      },
      "InterCoStatusValue": {
        "CellId": "InterCoStatusPopupDialog",
        "CellBoolValue": true
      },
      "ReadonlyFlag": 0,
      "OriginalKey": {
        "BatchNo": 224061,
        "BatchType": "AP Credit",
        "FinCoCode": "03",
        "Exported": false,
        "HasExportErrored": false
      },
      "CurrentKey": {
        "BatchNo": 224061,
        "BatchType": "AP Credit",
        "FinCoCode": "03",
        "Exported": false,
        "HasExportErrored": false
      },
      "Key": {
        "BatchNo": 224061,
        "BatchType": "AP Credit",
        "FinCoCode": "03",
        "Exported": false,
        "HasExportErrored": false
      },
      "Index": 0
    },
    {
      "Type": "AP Credit",
      "BatchNo": 224068,
      "Date": "2024-01-31T00:00:00",
      "Year": 2024,
      "Period": 7,
      "YearPeriodIndex": 24295,
      "CreatedDate": "2024-03-13T00:00:00",
      "CreatedById": 340,
      "CreatedByName": "WebWorkbench Admin",
      "FinancialCompany": "BAOT",
      "Location": "0",
      "Reference": "AP Credit-2024/03",
      "Notes": "BaoT testing",
      "Closed": true,
      "ReversingJournal": false,
      "ClosedById": 340,
      "NotForExport": false,
      "Exported": false,
      "ExportStatus": "[Blank]",
      "Select": {
        "CellId": "224068",
        "CellValue": "224068",
        "CellTag": "224068"
      },
      "Export": {
        "CellBoolValue": false
      },
      "TypeValue": {
        "CellValue": "AP Credit"
      },
      "BatchNoValue": {
        "CellId": "UpdatePopupDialog",
        "CellValue": "224068",
        "CellBoolValue": false,
        "CellTag": "224068"
      },
      "DateValue": {
        "CellValue": "31-Jan-2024",
        "CellValueDate": "2024-01-31T00:00:00"
      },
      "YearPeriodValue": {
        "CellValue": "2024/07"
      },
      "CreatedByValue": {
        "CellId": "340",
        "CellValue": "WebWorkbench Admin"
      },
      "FinancialCompanyValue": {
        "CellId": "BAOT",
        "CellValue": "BAOT"
      },
      "ReferenceValue": {
        "CellValue": "AP Credit-2024/03"
      },
      "NotesValue": {
        "CellValue": "BaoT testing"
      },
      "ReversalValue": {},
      "ClosedValue": {
        "CellBoolValue": true
      },
      "NotForExportValue": {
        "CellBoolValue": false
      },
      "ExportDateValue": {},
      "ExportStatusValue": {
        "CellId": "StatusPopupDialog",
        "CellBoolValue": true
      },
      "InterCo": {
        "CellBoolValue": false
      },
      "InterCoStatusValue": {
        "CellId": "InterCoStatusPopupDialog",
        "CellBoolValue": true
      },
      "ReadonlyFlag": 0,
      "OriginalKey": {
        "BatchNo": 224068,
        "BatchType": "AP Credit",
        "FinCoCode": "BAOT",
        "Exported": false,
        "HasExportErrored": false
      },
      "CurrentKey": {
        "BatchNo": 224068,
        "BatchType": "AP Credit",
        "FinCoCode": "BAOT",
        "Exported": false,
        "HasExportErrored": false
      },
      "Key": {
        "BatchNo": 224068,
        "BatchType": "AP Credit",
        "FinCoCode": "BAOT",
        "Exported": false,
        "HasExportErrored": false
      },
      "Index": 0
    },
    {
      "Type": "AP Invoice",
      "BatchNo": 224069,
      "Date": "2024-01-31T00:00:00",
      "Year": 2024,
      "Period": 7,
      "YearPeriodIndex": 24295,
      "CreatedDate": "2024-03-13T00:00:00",
      "CreatedById": 340,
      "CreatedByName": "WebWorkbench Admin",
      "FinancialCompany": "BAOT",
      "Location": "0",
      "Reference": "AP Invoice-2024/07",
      "Notes": "BaoT testing AP batch\r\nThis batch was flagged as Not For Export by WebWorkbench Admin on 13-Mar-2024",
      "Closed": true,
      "ReversingJournal": false,
      "ClosedById": 340,
      "NotForExport": true,
      "Exported": false,
      "ExportStatus": "[Blank]",
      "Select": {
        "CellId": "224069",
        "CellValue": "224069",
        "CellTag": "224069"
      },
      "Export": {
        "CellBoolValue": false
      },
      "TypeValue": {
        "CellValue": "AP Invoice"
      },
      "BatchNoValue": {
        "CellId": "UpdatePopupDialog",
        "CellValue": "224069",
        "CellBoolValue": false,
        "CellTag": "224069"
      },
      "DateValue": {
        "CellValue": "31-Jan-2024",
        "CellValueDate": "2024-01-31T00:00:00"
      },
      "YearPeriodValue": {
        "CellValue": "2024/07"
      },
      "CreatedByValue": {
        "CellId": "340",
        "CellValue": "WebWorkbench Admin"
      },
      "FinancialCompanyValue": {
        "CellId": "BAOT",
        "CellValue": "BAOT"
      },
      "ReferenceValue": {
        "CellValue": "AP Invoice-2024/07"
      },
      "NotesValue": {
        "CellValue": "BaoT testing AP batch\r\nThis batch was flagged as Not For Export by WebWorkbench Admin on 13-Mar-2024"
      },
      "ReversalValue": {},
      "ClosedValue": {
        "CellBoolValue": true
      },
      "NotForExportValue": {
        "CellBoolValue": true
      },
      "ExportDateValue": {},
      "ExportStatusValue": {
        "CellId": "StatusPopupDialog",
        "CellBoolValue": true
      },
      "InterCo": {
        "CellBoolValue": false
      },
      "InterCoStatusValue": {
        "CellId": "InterCoStatusPopupDialog",
        "CellBoolValue": true
      },
      "ReadonlyFlag": 0,
      "OriginalKey": {
        "BatchNo": 224069,
        "BatchType": "AP Invoice",
        "FinCoCode": "BAOT",
        "Exported": false,
        "HasExportErrored": false
      },
      "CurrentKey": {
        "BatchNo": 224069,
        "BatchType": "AP Invoice",
        "FinCoCode": "BAOT",
        "Exported": false,
        "HasExportErrored": false
      },
      "Key": {
        "BatchNo": 224069,
        "BatchType": "AP Invoice",
        "FinCoCode": "BAOT",
        "Exported": false,
        "HasExportErrored": false
      },
      "Index": 0
    },
    {
      "Type": "SCC Accrual",
      "BatchNo": 824017,
      "Date": "2024-01-31T00:00:00",
      "Year": 2024,
      "Period": 7,
      "YearPeriodIndex": 24295,
      "CreatedDate": "2024-01-22T00:00:00",
      "CreatedById": 340,
      "CreatedByName": "WebWorkbench Admin",
      "FinancialCompany": "01",
      "Location": "0",
      "Reference": "SCC Accrual-2024/07-",
      "Notes": "Logic Test",
      "Closed": true,
      "ReversingJournal": false,
      "ClosedById": 340,
      "NotForExport": false,
      "Exported": false,
      "ExportStatus": "[Blank]",
      "Select": {
        "CellId": "824017",
        "CellValue": "824017",
        "CellTag": "824017"
      },
      "Export": {
        "CellBoolValue": false
      },
      "TypeValue": {
        "CellValue": "SCC Accrual"
      },
      "BatchNoValue": {
        "CellId": "UpdatePopupDialog",
        "CellValue": "824017",
        "CellBoolValue": false,
        "CellTag": "824017"
      },
      "DateValue": {
        "CellValue": "31-Jan-2024",
        "CellValueDate": "2024-01-31T00:00:00"
      },
      "YearPeriodValue": {
        "CellValue": "2024/07"
      },
      "CreatedByValue": {
        "CellId": "340",
        "CellValue": "WebWorkbench Admin"
      },
      "FinancialCompanyValue": {
        "CellId": "01",
        "CellValue": "01"
      },
      "ReferenceValue": {
        "CellValue": "SCC Accrual-2024/07-"
      },
      "NotesValue": {
        "CellValue": "Logic Test"
      },
      "ReversalValue": {},
      "ClosedValue": {
        "CellBoolValue": true
      },
      "NotForExportValue": {
        "CellBoolValue": false
      },
      "ExportDateValue": {},
      "ExportStatusValue": {
        "CellId": "StatusPopupDialog",
        "CellBoolValue": true
      },
      "InterCo": {
        "CellBoolValue": false
      },
      "InterCoStatusValue": {
        "CellId": "InterCoStatusPopupDialog",
        "CellBoolValue": true
      },
      "ReadonlyFlag": 0,
      "OriginalKey": {
        "BatchNo": 824017,
        "BatchType": "SCC Accrual",
        "FinCoCode": "01",
        "Exported": false,
        "HasExportErrored": false
      },
      "CurrentKey": {
        "BatchNo": 824017,
        "BatchType": "SCC Accrual",
        "FinCoCode": "01",
        "Exported": false,
        "HasExportErrored": false
      },
      "Key": {
        "BatchNo": 824017,
        "BatchType": "SCC Accrual",
        "FinCoCode": "01",
        "Exported": false,
        "HasExportErrored": false
      },
      "Index": 0
    },
    {
      "Type": "CCC Accrual",
      "BatchNo": 824018,
      "Date": "2024-01-31T00:00:00",
      "Year": 2024,
      "Period": 7,
      "YearPeriodIndex": 24295,
      "CreatedDate": "2024-01-22T00:00:00",
      "CreatedById": 340,
      "CreatedByName": "WebWorkbench Admin",
      "FinancialCompany": "01",
      "Location": "0",
      "Reference": "CCC Accrual-2024/07-",
      "Notes": "test",
      "Closed": true,
      "ReversingJournal": false,
      "ClosedById": 340,
      "NotForExport": false,
      "Exported": false,
      "ExportStatus": "[Blank]",
      "Select": {
        "CellId": "824018",
        "CellValue": "824018",
        "CellTag": "824018"
      },
      "Export": {
        "CellBoolValue": false
      },
      "TypeValue": {
        "CellValue": "CCC Accrual"
      },
      "BatchNoValue": {
        "CellId": "UpdatePopupDialog",
        "CellValue": "824018",
        "CellBoolValue": false,
        "CellTag": "824018"
      },
      "DateValue": {
        "CellValue": "31-Jan-2024",
        "CellValueDate": "2024-01-31T00:00:00"
      },
      "YearPeriodValue": {
        "CellValue": "2024/07"
      },
      "CreatedByValue": {
        "CellId": "340",
        "CellValue": "WebWorkbench Admin"
      },
      "FinancialCompanyValue": {
        "CellId": "01",
        "CellValue": "01"
      },
      "ReferenceValue": {
        "CellValue": "CCC Accrual-2024/07-"
      },
      "NotesValue": {
        "CellValue": "test"
      },
      "ReversalValue": {},
      "ClosedValue": {
        "CellBoolValue": true
      },
      "NotForExportValue": {
        "CellBoolValue": false
      },
      "ExportDateValue": {},
      "ExportStatusValue": {
        "CellId": "StatusPopupDialog",
        "CellBoolValue": true
      },
      "InterCo": {
        "CellBoolValue": false
      },
      "InterCoStatusValue": {
        "CellId": "InterCoStatusPopupDialog",
        "CellBoolValue": true
      },
      "ReadonlyFlag": 0,
      "OriginalKey": {
        "BatchNo": 824018,
        "BatchType": "CCC Accrual",
        "FinCoCode": "01",
        "Exported": false,
        "HasExportErrored": false
      },
      "CurrentKey": {
        "BatchNo": 824018,
        "BatchType": "CCC Accrual",
        "FinCoCode": "01",
        "Exported": false,
        "HasExportErrored": false
      },
      "Key": {
        "BatchNo": 824018,
        "BatchType": "CCC Accrual",
        "FinCoCode": "01",
        "Exported": false,
        "HasExportErrored": false
      },
      "Index": 0
    },
    {
      "Type": "CCC Accrual",
      "BatchNo": 824010,
      "Date": "2024-01-01T00:00:00",
      "Year": 2024,
      "Period": 7,
      "YearPeriodIndex": 24295,
      "CreatedDate": "2023-11-15T16:09:52.057",
      "CreatedById": 340,
      "CreatedByName": "WebWorkbench Admin",
      "FinancialCompany": "01",
      "Location": "0",
      "Reference": "Reversal of 824009",
      "Reversal": 824009,
      "Closed": true,
      "ReversingJournal": false,
      "ClosedById": 340,
      "NotForExport": false,
      "Exported": false,
      "ExportStatus": "[Blank]",
      "Select": {
        "CellId": "824010",
        "CellValue": "824010",
        "CellTag": "824010"
      },
      "Export": {
        "CellBoolValue": false
      },
      "TypeValue": {
        "CellValue": "CCC Accrual"
      },
      "BatchNoValue": {
        "CellId": "UpdatePopupDialog",
        "CellValue": "824010",
        "CellBoolValue": false,
        "CellTag": "824010"
      },
      "DateValue": {
        "CellValue": "01-Jan-2024",
        "CellValueDate": "2024-01-01T00:00:00"
      },
      "YearPeriodValue": {
        "CellValue": "2024/07"
      },
      "CreatedByValue": {
        "CellId": "340",
        "CellValue": "WebWorkbench Admin"
      },
      "FinancialCompanyValue": {
        "CellId": "01",
        "CellValue": "01"
      },
      "ReferenceValue": {
        "CellValue": "Reversal of 824009"
      },
      "NotesValue": {},
      "ReversalValue": {
        "CellNumValue": 824009
      },
      "ClosedValue": {
        "CellBoolValue": true
      },
      "NotForExportValue": {
        "CellBoolValue": false
      },
      "ExportDateValue": {},
      "ExportStatusValue": {
        "CellId": "StatusPopupDialog",
        "CellBoolValue": true
      },
      "InterCo": {
        "CellBoolValue": false
      },
      "InterCoStatusValue": {
        "CellId": "InterCoStatusPopupDialog",
        "CellBoolValue": true
      },
      "ReadonlyFlag": 0,
      "OriginalKey": {
        "BatchNo": 824010,
        "BatchType": "CCC Accrual",
        "FinCoCode": "01",
        "Exported": false,
        "HasExportErrored": false
      },
      "CurrentKey": {
        "BatchNo": 824010,
        "BatchType": "CCC Accrual",
        "FinCoCode": "01",
        "Exported": false,
        "HasExportErrored": false
      },
      "Key": {
        "BatchNo": 824010,
        "BatchType": "CCC Accrual",
        "FinCoCode": "01",
        "Exported": false,
        "HasExportErrored": false
      },
      "Index": 0
    },
    {
      "Type": "CCC Accrual",
      "BatchNo": 824009,
      "Date": "2023-12-31T00:00:00",
      "Year": 2024,
      "Period": 6,
      "YearPeriodIndex": 24294,
      "CreatedDate": "2023-11-15T00:00:00",
      "CreatedById": 340,
      "CreatedByName": "WebWorkbench Admin",
      "FinancialCompany": "01",
      "Location": "0",
      "Reference": "CCC Accrual-2024/06-",
      "Notes": " This Batch was reversed using Batch 824010 dated 01/01/2024",
      "Closed": true,
      "ReversingJournal": false,
      "ClosedById": 340,
      "NotForExport": true,
      "Exported": false,
      "ExportStatus": "[Blank]",
      "Select": {
        "CellId": "824009",
        "CellValue": "824009",
        "CellTag": "824009"
      },
      "Export": {
        "CellBoolValue": false
      },
      "TypeValue": {
        "CellValue": "CCC Accrual"
      },
      "BatchNoValue": {
        "CellId": "UpdatePopupDialog",
        "CellValue": "824009",
        "CellBoolValue": false,
        "CellTag": "824009"
      },
      "DateValue": {
        "CellValue": "31-Dec-2023",
        "CellValueDate": "2023-12-31T00:00:00"
      },
      "YearPeriodValue": {
        "CellValue": "2024/06"
      },
      "CreatedByValue": {
        "CellId": "340",
        "CellValue": "WebWorkbench Admin"
      },
      "FinancialCompanyValue": {
        "CellId": "01",
        "CellValue": "01"
      },
      "ReferenceValue": {
        "CellValue": "CCC Accrual-2024/06-"
      },
      "NotesValue": {
        "CellValue": " This Batch was reversed using Batch 824010 dated 01/01/2024"
      },
      "ReversalValue": {},
      "ClosedValue": {
        "CellBoolValue": true
      },
      "NotForExportValue": {
        "CellBoolValue": true
      },
      "ExportDateValue": {},
      "ExportStatusValue": {
        "CellId": "StatusPopupDialog",
        "CellBoolValue": true
      },
      "InterCo": {
        "CellBoolValue": false
      },
      "InterCoStatusValue": {
        "CellId": "InterCoStatusPopupDialog",
        "CellBoolValue": true
      },
      "ReadonlyFlag": 0,
      "OriginalKey": {
        "BatchNo": 824009,
        "BatchType": "CCC Accrual",
        "FinCoCode": "01",
        "Exported": false,
        "HasExportErrored": false
      },
      "CurrentKey": {
        "BatchNo": 824009,
        "BatchType": "CCC Accrual",
        "FinCoCode": "01",
        "Exported": false,
        "HasExportErrored": false
      },
      "Key": {
        "BatchNo": 824009,
        "BatchType": "CCC Accrual",
        "FinCoCode": "01",
        "Exported": false,
        "HasExportErrored": false
      },
      "Index": 0
    },
    {
      "Type": "SCC Accrual",
      "BatchNo": 824016,
      "Date": "2023-12-31T00:00:00",
      "Year": 2024,
      "Period": 6,
      "YearPeriodIndex": 24294,
      "CreatedDate": "2024-01-08T00:00:00",
      "CreatedById": 340,
      "CreatedByName": "WebWorkbench Admin",
      "FinancialCompany": "01",
      "Location": "0",
      "Reference": "SCC Accrual-2024/06-",
      "Closed": true,
      "ReversingJournal": false,
      "ClosedById": 340,
      "NotForExport": false,
      "Exported": false,
      "ExportStatus": "[Blank]",
      "Select": {
        "CellId": "824016",
        "CellValue": "824016",
        "CellTag": "824016"
      },
      "Export": {
        "CellBoolValue": false
      },
      "TypeValue": {
        "CellValue": "SCC Accrual"
      },
      "BatchNoValue": {
        "CellId": "UpdatePopupDialog",
        "CellValue": "824016",
        "CellBoolValue": false,
        "CellTag": "824016"
      },
      "DateValue": {
        "CellValue": "31-Dec-2023",
        "CellValueDate": "2023-12-31T00:00:00"
      },
      "YearPeriodValue": {
        "CellValue": "2024/06"
      },
      "CreatedByValue": {
        "CellId": "340",
        "CellValue": "WebWorkbench Admin"
      },
      "FinancialCompanyValue": {
        "CellId": "01",
        "CellValue": "01"
      },
      "ReferenceValue": {
        "CellValue": "SCC Accrual-2024/06-"
      },
      "NotesValue": {},
      "ReversalValue": {},
      "ClosedValue": {
        "CellBoolValue": true
      },
      "NotForExportValue": {
        "CellBoolValue": false
      },
      "ExportDateValue": {},
      "ExportStatusValue": {
        "CellId": "StatusPopupDialog",
        "CellBoolValue": true
      },
      "InterCo": {
        "CellBoolValue": false
      },
      "InterCoStatusValue": {
        "CellId": "InterCoStatusPopupDialog",
        "CellBoolValue": true
      },
      "ReadonlyFlag": 0,
      "OriginalKey": {
        "BatchNo": 824016,
        "BatchType": "SCC Accrual",
        "FinCoCode": "01",
        "Exported": false,
        "HasExportErrored": false
      },
      "CurrentKey": {
        "BatchNo": 824016,
        "BatchType": "SCC Accrual",
        "FinCoCode": "01",
        "Exported": false,
        "HasExportErrored": false
      },
      "Key": {
        "BatchNo": 824016,
        "BatchType": "SCC Accrual",
        "FinCoCode": "01",
        "Exported": false,
        "HasExportErrored": false
      },
      "Index": 0
    },
    {
      "Type": "Adjustment",
      "BatchNo": 424009,
      "Date": "2023-12-06T00:00:00",
      "Year": 2024,
      "Period": 6,
      "YearPeriodIndex": 24294,
      "CreatedDate": "2023-12-06T13:22:28.573",
      "FinancialCompany": "01",
      "Location": "0",
      "Reference": "Inwards Goods",
      "Closed": true,
      "ReversingJournal": false,
      "NotForExport": false,
      "Exported": false,
      "ExportStatus": "[Blank]",
      "Select": {
        "CellId": "424009",
        "CellValue": "424009",
        "CellTag": "424009"
      },
      "Export": {
        "CellBoolValue": false
      },
      "TypeValue": {
        "CellValue": "Adjustment"
      },
      "BatchNoValue": {
        "CellId": "UpdatePopupDialog",
        "CellValue": "424009",
        "CellBoolValue": false,
        "CellTag": "424009"
      },
      "DateValue": {
        "CellValue": "06-Dec-2023",
        "CellValueDate": "2023-12-06T00:00:00"
      },
      "YearPeriodValue": {
        "CellValue": "2024/06"
      },
      "CreatedByValue": {
        "CellId": ""
      },
      "FinancialCompanyValue": {
        "CellId": "01",
        "CellValue": "01"
      },
      "ReferenceValue": {
        "CellValue": "Inwards Goods"
      },
      "NotesValue": {},
      "ReversalValue": {},
      "ClosedValue": {
        "CellBoolValue": true
      },
      "NotForExportValue": {
        "CellBoolValue": false
      },
      "ExportDateValue": {},
      "ExportStatusValue": {
        "CellId": "StatusPopupDialog",
        "CellBoolValue": true
      },
      "InterCo": {
        "CellBoolValue": false
      },
      "InterCoStatusValue": {
        "CellId": "InterCoStatusPopupDialog",
        "CellBoolValue": true
      },
      "ReadonlyFlag": 0,
      "OriginalKey": {
        "BatchNo": 424009,
        "BatchType": "Adjustment",
        "FinCoCode": "01",
        "Exported": false,
        "HasExportErrored": false
      },
      "CurrentKey": {
        "BatchNo": 424009,
        "BatchType": "Adjustment",
        "FinCoCode": "01",
        "Exported": false,
        "HasExportErrored": false
      },
      "Key": {
        "BatchNo": 424009,
        "BatchType": "Adjustment",
        "FinCoCode": "01",
        "Exported": false,
        "HasExportErrored": false
      },
      "Index": 0
    }
  ]
}

Get Batch with JobTransactions for a BatchID

Expand
titleClick to view

Request

Code Block
languagejson
Response
 Code Block
languagejson
JobTransactionApiModel {
Key (JobTransactionsJobTransactionKey, optional),
Fields (BatchBatchFields, optional),
Rows (Array[JobTransactionsJobTransactionLine], optional),
ValidationErrors (Array[MvcValidationError], optional)
}
JobTransactionsJobTransactionKey {
BatchNo (Integer, optional),
BatchType (string, optional)
}
BatchBatchFields {
BatchNo (StringViewData, optional),
BatchType (StringViewData, optional),
BatchDate (DateViewData, optional),
Period (StringViewData, optional),
CreatedBy (StringViewData, optional),
CreatedDate (DateViewData, optional),
Location (StringViewData, optional),
FinancialCompany (StringViewData, optional),
Closed (BoolViewData, optional),
ClosedDate (DateViewData, optional),
ClosedBy (StringViewData, optional),
Exported (BoolViewData, optional),
ExportedDate (DateViewData, optional),
ExportedBy (StringViewData, optional),
NotForExport (BoolViewData, optional),
NotForExportDate (DateViewData, optional),
NotForExportBy (StringViewData, optional),
Reference (StringViewData, optional),
BatchNotes (StringViewData, optional),
ReversalOfBatch (StringViewData, optional),
HiddenBatchNotes (string, optional),
BatchStatus (StringViewData, optional),
BatchTotal (DecimalViewData, optional),
ReversingJournal (BoolViewData, optional),
Print (SplitButtonViewData, optional),
AttachmentsDialog (FileAttachmentsViewData, optional),
Import (ButtonViewData, optional),
ImportAdjustment (SplitButtonViewData, optional),
PayrollPeriod (OptionsViewData, optional),
Currency (PickerViewData, optional),
FcConversionRate (DecimalViewData, optional),
UseForeignCurrency (boolean, optional)
}
JobTransactionsJobTransactionLine {
TranDate (string, optional),
LogHeaderID (Integer, optional),
FcCost (number, optional),
FcRetail (number, optional),
PurchaseOrderLineId (Integer, optional),
StockLocationInactive (boolean, optional),
Unit (string, optional),
EnteredByID (Integer, optional),
SourceID (Integer, optional),
FCGST (number, optional),
JobCodeValue (CellData, optional),
LogHeader (CellData, optional),
ActivityCodeValue (CellData, optional),
WorkCentreCodeValue (CellData, optional),
QuantityValue (CellData, optional),
FcCostValue (CellData, optional),
CostValue (CellData, optional),
GSTTypeValue (CellData, optional),
GSTTypeCodeValue (CellData, optional),
GSTRateValue (CellData, optional),
GSTValue (CellData, optional),
NetValueValue (CellData, optional),
ReferenceValue (CellData, optional),
FcRetailValue (CellData, optional),
RetailValue (CellData, optional),
LineDescriptionValue (CellData, optional),
DetailsValue (CellData, optional),
FromPONumberValue (CellData, optional),
PurchaseOrderLineIdValue (CellData, optional),
StockLocationCodeValue (CellData, optional),
StockItemCodeValue (CellData, optional),
TotalLineCostValue (CellData, optional),
CostRateValue (CellData, optional),
UnitValue (CellData, optional),
FCGSTValue (CellData, optional),
Delete (CellData, optional),
Serials (CellData, optional),
SerialRows (Array[TabletSerialLine], optional),
Status (string, optional),
ReadonlyFlag (Integer, optional),
ReadonlyMessage (string, optional),
OriginalKey (JobTransactionsJobTransactionDetailKey, optional),
CurrentKey (JobTransactionsJobTransactionDetailKey, optional),
Key (JobTransactionsJobTransactionDetailKey, optional),
Index (Integer, optional)
}
MvcValidationError {
n (string, optional),
m (string, optional)
}
StringViewData {
StringValue (string, optional),
Name (string, optional),
Visible (boolean, optional),
Disabled (boolean, optional),
Required (boolean, optional)
}
DateViewData {
DateValue (string, optional),
Name (string, optional),
Visible (boolean, optional),
Disabled (boolean, optional),
Required (boolean, optional),
InfoText (string, optional)
}
BoolViewData {
BoolValue (boolean, optional),
Name (string, optional),
Visible (boolean, optional),
InfoText (string, optional)
}
DecimalViewData {
DecimalValue (number, optional),
Name (string, optional),
Visible (boolean, optional),
InfoText (string, optional)
}
SplitButtonViewData {}
FileAttachmentsViewData {
RelatedRecordID (string, optional),
RelatedRecord (string, optional),
FileUrl (StringViewData, optional),
Name (string, optional),
InfoText (string, optional)
}
ButtonViewData {
UseAttrDisable (boolean, optional),
NotRelative (boolean, optional),
Name (string, optional),
Visible (boolean, optional),
Disabled (boolean, optional),
InfoText (string, optional)
}
OptionsViewData {
SelectedOption (string, optional),
Settings (Array[KeyValuePair], optional),
Name (string, optional),
Visible (boolean, optional),
Disabled (boolean, optional),
Required (boolean, optional),
InfoText (string, optional)
}
PickerViewData {
SelectedValue (string, optional),
SelectedText (string, optional),
Name (string, optional),
Visible (boolean, optional),
Disabled (boolean, optional),
Required (boolean, optional),
InfoText (string, optional)
}
CellData {
CellId (string, optional),
CellValue (string, optional),
CellNumValue (number, optional),
CellBoolValue (boolean, optional),
CellTag (string, optional),
CellValueDate (string, optional),
CellValueInt (Integer, optional)
}
TabletSerialLine {
SerialNo (CellData, optional),
SerialNoSelect (CellData, optional),
BatchNo (CellData, optional),
BatchNoSelect (CellData, optional),
ExpiryDate (string, optional),
SerialDetails (CellData, optional),
Quantity (CellData, optional),
TransDetails (CellData, optional),
Delete (CellData, optional),
Status (string, optional),
ReadonlyFlag (Integer, optional),
ReadonlyMessage (string, optional),
OriginalKey (TabletSerialLineKey, optional),
CurrentKey (TabletSerialLineKey, optional),
Key (TabletSerialLineKey, optional),
Index (Integer, optional)
}
JobTransactionsJobTransactionDetailKey {
JobTranId (Integer, optional),
PersonId (Integer, optional),
JobCode (string, optional),
FinCoCode (string, optional),
ActivityCode (string, optional),
ActivityCodeValue (string, optional),
ActivityType (string, optional),
ActivitySubType (string, optional),
WorkCentreCode (string, optional),
WorkCentreCodeValue (string, optional),
ItemId (Integer, optional),
StockLocationCodeValue (string, optional),
CostRateValue (number, optional),
BatchType (string, optional),
OrderDerivedLine (boolean, optional),
DocketDerivedLine (boolean, optional),
StockDerivedLine (boolean, optional),
Type (string, optional) = ['InwardsGoodsEntry', 'InwardsGoodsEdit', 'Issue', 'Return', 'Transfer', 'Requisition'],
PurchaseOrderLineIdValue (Integer, optional),
LogHeaderId (Integer, optional),
KeyName (string, optional),
CompanyId (Integer, optional),
GSTTypeCodeValue (string, optional)
}
KeyValuePair {
Key (string, optional, read only),
Value (string, optional, read only)
}
TabletSerialLineKey {
SNID (Integer, optional),
SNTranID (Integer, optional)
}
Response Sample
 Code Block
languagejson
{
  "Key": {
    "BatchNo": 124007,
    "BatchType": "Payroll"
  },
  "Fields": {
    "Print": {
      "Default": "/WorkbenchCivil/Reports/Batch_Reports/wbBatchPayroll001",
      "Labels": {
        "/WorkbenchCivil/Reports/Batch_Reports/wbBatchPayroll002": "wbBatchPayroll002",
        "/WorkbenchCivil/Reports/Batch_Reports/wbBatchPayroll003": "wbBatchPayroll003",
        "/WorkbenchCivil/Reports/Batch_Reports/wbBatchPayroll001": "wbBatchPayroll001"
      },
      "UseAttrDisable": true,
      "NotRelative": false,
      "Name": "Print",
      "Visible": true,
      "Disabled": true,
      "Required": false
    },
    "AttachmentsDialog": {
      "RelatedRecordID": "124007",
      "RelatedRecord": "BatchHeader",
      "FileUrl": {
        "Name": "File URL",
        "Visible": true,
        "Disabled": false,
        "Required": false
      },
      "Visible": true,
      "Disabled": false,
      "Required": false
    },
    "Import": {
      "UseAttrDisable": false,
      "NotRelative": false,
      "Name": "Import",
      "Visible": false,
      "Disabled": true,
      "Required": false
    },
    "ImportAdjustment": {
      "Labels": {
        "2": "wbImportAdjustments",
        "71": "wbImportAdjustmentsWithGST",
        "84": "wbImportAdjustmentsWithLogNos"
      },
      "UseAttrDisable": false,
      "NotRelative": false,
      "Name": "Import",
      "Visible": true,
      "Disabled": false,
      "Required": false
    },
    "UseForeignCurrency": true
  },
  "Rows": []
}
 Expand
titleClick to view
Request
 Code Block
languagejson
Response
 Code Block
languagejson
Response Sample
 Code Block
languagejson
⬆️ Back to top
On this page
 Table of Contents
minLevel1
maxLevel2
outlinefalse
styledefault
typelist
printablefalse
 
 Include Page
KB1:How-to footer
KB1:How-to footer