Versions Compared

Old Version 9

changes.mady.by.user Bao TRINH

Saved on

compared with

New Version Current

changes.mady.by.user Bao TRINH

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

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

Logged in User

SystemBatchKey

-

SystemBatchModel

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.

Performed As

/api/BatchListApi

Method

Description

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

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

-

-

POST

Return all Workbench batches.

Retrieve a specific Batch (including its Job Transactions).

Admin User

JobTransactionKey

-

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.

SystemBatchApiModel

SystemBatchKey

Field

Property

Type

Description

BatchNo

BatchType

Integer

String

The Batch

number

Type. (required)

BatchType

DocDate

string

Type of the batch.

BatchDate

String

To determines what period the batch is created.

PeriodNo

Integer

The period of the batch.

YearNo

Integer

The year of the batch

CreatedById

Integer

[ID of user or account?]

CreatedDateTime

String

Date and time when the batch is

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

Field

BatchKey

Property

Type

Description

Total

BatchNo

Integer

Total

 The unique number of

batches

the Batch.

Page

BatchType

Integer

Page

Records

Integer

Records

Rows

Array

Array [BatchBatchLine]

Form

Object

 

Widgets

 

ViewData_GridWidget

⬆️ Back to top

 

BatchBatchFields

Field

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

BatchNo

⬆️ Back to top

BatchBatchLine

Field

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

Key

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

Field

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.

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

person

the user who created the

batch

Batch.

 

CreatedByName

String

 Name of person who created the batch

Location

String

Location

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

 Financial company.

The Financial Company Code of the Batch. 

FinancialCompanyValue

CellData

The Financial Company Code of the Batch. 

Reference

String

 Reference text

The Batch reference.

ReferenceValue

CellData

The Batch reference.

Notes

String

 Batch note

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

 Status of the batch

The Closed flag on the Batch.

ReversingJournal 

ClosedValue

Boolean

CellData

The Closed flag on the Batch.

ClosedById

Integer

Code

The ID of

person

the user who closed the

batch

Batch.

NotForExport

Boolean

Value of

The Not For Export flag on the Batch.

NotForExportValue

CellData

The Not For Export flag on the Batch.

Exported

Boolean

Exported status. 

 A flag indicating if the Batch has been exported.

ExportedById

Integer

The ID of

person

the user who exported the

batch

Batch.

ExportDate

String

Exported

The date the Batch was exported.

 

ClosedDate

ExportDateValue

String

CellData

Closed

The date the Batch was exported.

ExportStatus

String

 Export status.

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

ExportStatusValue

CellData

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

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

Field

Type

Description

Key

JobTransactionsJobTransactionKey

 

Fields

BatchBatchFields

 

Rows

Array [JobTransactionsJobTransactionLine]

 

ValidationErrors

Array [MvcValidationError]

 

⬆️ Back to top

 

JobTransactionsJobTransactionKey

Field

Type

Description

BatchNo

Integer

 Number of the batch.

BatchType

String

Batch type. 

⬆️ Back to top

 

JobTransactionsJobTransactionDetailKey

Field

The Inter-Company status of the Batch.

InterCoStatusValue

CellData

The Inter-Company status of the Batch.

⬆️ Back to top

JobTransactionKey

Property

Type

Description

BatchNo

Integer

 The unique number of the Batch.

BatchType

String

 The Batch Type.

⬆️ Back to top

JobTransactionApiModel

Property

Type

Description

Key

JobTransactionKey

 The unique key of the Batch.

Fields

BatchFields

 General data associated with the Batch.

Rows

Array<JobTransactionLine>

 Job Transactions associated with the Batch.

ValidationErrors

Array<MvcValidationError>

 A list of specific validation errors if the save was unsuccessful.

⬆️ Back to top

BatchFields

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

 The Batch this Batch is a reversal of.

BatchStatus

StringViewData

 Status of the batch

ReversingJournal

BoolViewData

 The Reversing Journal flag on the Batch.

AttachmentsDialog

FileAttachmentsViewData

 The file attachments information for the Batch.

Currency

PickerViewData

 The currency

FcConversionRate

DecimalViewData

Foreign currency conversation rate. 

UseForeignCurrency

Boolean

Foreign currency status.

 ⬆️ Back to top

JobTransactionDetailKey

Property

Type

Description

JobTranId

Integer

 

PersonId

Integer

 Person id.

JobCode

String

 Job code The unique ID of the Job Transaction.

PersonId

Integer

 The ID of the User.

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 CentreThe Financial Company Code on the Batch.

BatchType

String

The Batch Type of the Batch.

JobCode

String

 The Job Code on the Job Transaction.

ActivityCodeValue

String

 The Activity Code on the Job Transaction.

WorkCentreCodeValue

String

Code of  The Work Centre Code on the Job Transaction. 

ItemId

Integer Item

id The ID of the Item on the Job Transaction.

StockLocationCodeValue

String

Stock location code. 

CostRateValue

Number

 Cost rate.

BatchType

String

Batch type 

OrderDerivedLine

Boolean

DocketDerivedLine

Boolean

 

StockDerivedLine

Boolean

 The Reference on the Job Transaction.

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

 The Job Transaction Type ('Issue' or 'Return').

GSTTypeCodeValue

String

  The GST Type Code on the Job Transaction.

 ⬆️ Back to top

 JobTransactionsJobTransactionLine

JobTransactionLine

Field

Type

Description

TranDateKey

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

 

JobTransactionDetailKey

 The unique key for the line.

EnteredByID

Integer

The ID of the Person who created the Job Transaction.

JobCode

String

The Job Code on the Job Transaction.

JobCodeValue

CellData

The Job Code on the Job Transaction.

LogHeaderID

Integer

The Log Header on the Job Transaction.

LogHeader

CellData

The Log Header on the Job Transaction.

StockItemCode

String

The Stock Item on the Job Transaction

StockItemCodeValue

CellData

The Stock Item on the Job Transaction

StockLocationCode

String

The Stock Location on the Job Transaction

StockLocationCodeValue

CellData

The Stock Location on the Job Transaction

StockLocationInactive

Boolean

 A flag to indicate if the Stock Location is closed and finalised.

ActivityCode

String

The Activity Code on the Job Transaction.

ActivityCodeValue

CellData

The Activity Code on the Job Transaction.

WorkCentreCode

String

The Work Centre Code on the Job Transaction.

WorkCentreCodeValue

CellData

The Work Centre Code on the Job Transaction.

Unit

String

The Unit of the Stock Item on the Job Transaction.

UnitValue

CellData

The Unit of the Stock Item on the Job Transaction.

CostRate

Decimal

The Cost Rate.

CostRateValue

CellData

The Cost Rate.

Quantity

Decimal

The Quantity.

QuantityValue

CellData

The Quantity.

FcCost

Decimal

The Foreign Currency Cost.

FcCostValue

CellData

The Foreign Currency Cost.

Cost

Decimal

The Cost.

CostValue

CellData

The Cost.

FcRetail

Decimal

The Foreign Currency Retail Value.

FcRetailValue

CellData

The Foreign Currency Retail Value.

Retail

Decimal

The Retail Value.

RetailValue

CellData

The Retail Value.

FCGST

Decimal

The Foreign Currency Tax.

FCGSTValue

CellData

The Foreign Currency Tax.

LineDescription

String

The Description on the Job Transaction.

LineDescriptionValue

CellData

The Description on the Job Transaction.

Details

String

The Details on the Job Transaction.

DetailsValue

CellData

The Details on the Job Transaction.

GSTType

String

The GST Type Code on the Job Transaction.

GSTTypeDescription

String

The Description of the GST Type on the Job Transaction.

GSTTypeCodeValue

CellData

The GST Type on the Job Transaction.

GSTRate

Decimal

The Tax Rate of the GST Type on the Job Transaction.

GSTRateValue

CellData

The Tax Rate of the GST Type on the Job Transaction.

TotalLineCost

Decimal

The Cost Rate multiplied by the Quantity.

TotalLineCostValue

CellData

The Cost Rate multiplied by the Quantity.

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