Page Comparison

Versions Compared

Old Version 11

changes.mady.by.user Cam Mackay

Saved on May 06, 2024

compared with

New Version Current

changes.mady.by.user Bao TRINH

Saved on May 13, 2024

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.

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

Return or create batch Web Workbench screenProvides 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

MethodDescription

Performed As

Request Query

Request Body

Response

GETGet Batch with JobTransactions for a BatchID

Retrieve a specific Batch (including its Job Transactions).

Admin User

JobTransactionKey

-

JobTransactionApiModel

POSTCreate

a new batch or update existing batch with batch transactions.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

BatchLine

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

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

Key

Number of the batch

BatchType

Batch type.

BatchDate

Batch date.

Period

The financial period of the batch

CreatedBy

Person who created the batch

CreatedDate

Created date..

Location

Location in the batch

FinancialCompany

Financial company for the batch

Closed

Status of the batch

ClosedDate

Date the batch has been closed.

ClosedBy

Who closed the batch.

Exported

Export status of the batch.

ExportedDate

Export date.

ExportedBy

Who exported the batch.

NotForExport

The batch is not for exporting.

NotForExportDate

Date marked as Not for Export

NotForExportBy

Who marked Not for Export.

Reference

Reference text.

BatchNotes

Notes/comments

ReversalOfBatch

HiddenBatchNotes

String

BatchStatus

Status of the batch

BatchTotal

DecimalViewData

ReversingJournal

Print

SplitButtonViewData

AttachmentsDialog

FileAttachmentsViewData

Import

ImportAdjustment

SplitButtonViewData

PayrollPeriod

OptionsViewData

Currency

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

Export

TypeValue

Batch type.

BatchNoValue

Batch number.

DateValue

Batch date.

YearPeriodValue

Financial year period of the batch.

CreatedByValue

Person who created the batch.

FinancialCompanyValue

Financial company.

ReferenceValue

Reference text

NotesValue

Batch note.

ReversalValue

ClosedValue

Closed status.

NotForExportValue

Value of Not for Export flag.

ClosedDateValue

Closed date.

ExportDateValue

Exported date.

ExportStatusValue

Export status.

InterCo

Internal company.

InterCoStatusValue

Internal company.

BatchStatus

String

Batch status.

Status

String

Batch status.

ReadonlyFlag

Integer

Value of Read-Only property.

ReadonlyMessage

String

OriginalKey

CurrentKey

Key

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

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

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

title	Click to view

Request

Code Block

language	json

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

language	json

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

language	json

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

title	Click to view

Request

Code Block

language	json

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

language	json

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

language	json

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

title	Click to view

Request

Code Block

language	json

Response

Code Block

language	json

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

language	json

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

title	Click to view

Request

Code Block

language	json

Response

Code Block

language	json

Response Sample

Code Blocklanguagejson

⬆️ Back to top

On this page

Table of Contents

minLevel	1
maxLevel	2
outline	false
style	default
type	list
printable	false

Include Page

	KB1:How-to footer
	KB1:How-to footer