Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 13 Next »

Overview

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

Endpoints

The resources available in this module.

BatchListApi

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

/api/BatchListApi

Method

Description

Performed As

Request Query

Request Body

Response

GET

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

Provides API access to the Job Transaction Batch Entry (#/Batch/BatchEntryList.aspx) detail Web Workbench screens ('Job Adjustment Batch Entry', ‘Disbursement Batch Entry', ‘Stock Issue Batch Entry’, 'Stock Return Batch Entry’).

/api/BatchDetailApi

Method

Performed As

Request Query

Request Body

Response

GET

Retrieve a specific Batch (including its Job Transactions).

Admin User

BatchKey

-

JobTransactionApiModel

POST

Update an existing Batch and its Job Transactions.

Admin User

-

JobTransactionApiModel

JobTransactionApiModel

Models

The definitions of models specific to endpoints in this module.

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

String

Type of the Batch.

BatchDate

String

The end date of the Period of the Batch..

PeriodNo

Integer

The period of the Batch.

YearNo

Integer

The year of the Batch

CreatedById

Integer

The ID of the user who created the Batch.

CreatedDateTime

String

The date and time when the Batch was created.

LocationCode

String

The Location Code from the Financial Company.

CompanyCode

String

The Financial Company Code of the Batch.

BatchReference

String

The Batch reference.

BatchNotes

String

The Batch comment.

ReversingJournal

Integer

The Reversing Journal flag on the Batch.

ClosedFlag

Integer

The Closed flag on the Batch.

ClosedDate

String

The date the Batch was closed.

ClosedById

Integer

The ID of the user who closed the Batch.

NotForExportFlag

Integer

The Not For Export flag on the Batch.

NotForExportDate

String

The date the Batch was marked as Not For Export.

NotForExportId

Integer

The ID of the user who marked the Batch as Not For Export.

ExportDate

String

The date the Batch was exported.

ExportedById

String

The ID of the user who exported the Batch.

ExportStatus

String

The status of the Batch (Created, In Progress, Error, Successful).

⬆️ Back to top

BatchKey

Property

Type

Description

BatchNo

Integer

 The unique number of the Batch.

BatchType

String

 The Batch Type.

FinCoCode

String

 The Financial Company Code.

InterCoStatus

String

 The Inter-Company status of the Batch.

Exported

Boolean

 A flag indicating if the Batch has been exported.

HasExportErrored

Boolean

 A flag indicating if the Batch has a status of ‘Error’.

BatchLine

Property

Type

Description

Key

BatchKey

The unique key for the line.

Type

String

The Type of the Batch.

TypeValue

CellData

The Type of the Batch.

BatchNo

Integer

The unique number of the Batch.

BatchNoValue

CellData

The unique number of the Batch.

Date

String

The date of the Batch.

DateValue

CellData

The date of the Batch.

Year

String

The year of the Year/Period of the Batch.  

Period

Integer

The period of the Year/Period of the Batch.

YearPeriodIndex

Integer

The unique index of the Year/Period of the Batch. 

YearPeriodValue

CellData

The formatted Year/Period of the Batch. 

CreatedDate

String

The date the Batch was created.

CreatedById

Integer

The ID of the user who created the Batch.

CreatedByName

String

The name of the user who created the Batch.

CreatedByValue

CellData

The name of the user who created the Batch.

Location

String

The Location Code of the Batch. 

FinancialCompany

String

The Financial Company Code of the Batch. 

FinancialCompanyValue

CellData

The Financial Company Code of the Batch. 

Reference

String

The Batch reference.

ReferenceValue

CellData

The Batch reference.

Notes

String

The Batch comment.

NotesValue

CellData

The Batch comment.

Reversal

Integer

The Batch No of the Batch this Batch reverses.

ReversalValue

CellData

The Batch No of the Batch this Batch reverses.

Closed

Boolean

The Closed flag on the Batch.

ClosedValue

CellData

The Closed flag on the Batch.

ClosedById

Integer

The ID of the user who closed the Batch.

NotForExport

Boolean

The Not For Export flag on the Batch.

NotForExportValue

CellData

The Not For Export flag on the Batch.

Exported

Boolean

 A flag indicating if the Batch has been exported.

ExportedById

Integer

The ID of the user who exported the Batch.

ExportDate

String

The date the Batch was exported.

ExportDateValue

CellData

The date the Batch was exported.

ExportStatus

String

The status of the Batch (Created, In Progress, Error, Successful).

ExportStatusValue

CellData

The status of the Batch (Created, In Progress, Error, Successful).

InterCoStatus

String

The Inter-Company status of the Batch.

InterCoStatusValue

CellData

The Inter-Company status of the Batch.

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

 Click to view

Request

{
 "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

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

{
  "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

 Click to view

Request

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

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

{
  "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

 Click to view

Request

 

Response

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

{
  "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": []
}

 Click to view

Request

 

Response

 

Response Sample

 

⬆️ Back to top

On this page


Unable to render {include} The included page could not be found.
  • No labels