Overview

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 Web Workbench screen.

/api/BatchDetailApi
Method	Description	Performed As	Request Query	Request Body	Response
GET	Get Batch with JobTransactions for a BatchID		-
POST	Create a new batch or update existing batch with batch transactions.

BatchListApi

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

/api/BatchListApi
Method	Description	Performed As	Request Query	Request Body	Response
GET	Reuse or returns a new System Batch for Workbench Import. Requires: BatchType, LocationCode, FinCoCode, YearNo and PeriodNo		-	-
POST	Return all Workbench batches.

Models

The definitions of models specific to endpoints in this module.

SystemBatchApiModel

FieldProperty	Type	Description
BatchNo	Integer	Batch number.
BatchType	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 created.
LocationCode	String	The location from the financial company
CompanyCode	String	Code of the company for the batch
BatchReference	String	Reference text.
BatchNotes	String	Batch comment.
ClosedFlag	Integer
ReversingJournal	Integer
ReversingJournal	Integer
ClosedDate	String	Date the batch is closed.
ClosedById	Integer	Code of person who close the batch.
NotForExportFlag	Integer	Flag to mark the batch is for exporting or not.
NotForExportDate	String	Date the batch is marked as Not for Export.
NotForExportId	Integer	Code of person who marked batch as Not for Export.
ExportDate	String	Date of the export
ExportedById	String	Code of person who made the export.
ExportStatus	String	Includes: Created, In progress, Error, Successful.

⬆️ Back to top

GridResult_BatchBatchLine

FieldProperty	Type	Description
Total	Integer	Total number of batches
Page	Integer	Page
Records	Integer	Records
Rows	Array	Array [BatchBatchLine]
Form	Object
Widgets		ViewData_GridWidget

⬆️ Back to top

BatchBatchFields

FieldProperty	Type	Description
BatchNo	StringViewData	Number of the batch
BatchType	StringViewData	Batch type.
BatchDate	DateViewData	Batch date.
Period	StringViewData	The financial period of the batch
CreatedBy	StringViewData	Person who created the batch
CreatedDate	DateViewData	Created date..
Location	StringViewData	Location in the batch
FinancialCompany	StringViewData	Financial company for the batch
Closed	BoolViewData	Status of the batch
ClosedDate	DateViewData	Date the batch has been closed.
ClosedBy	StringViewData	Who closed the batch.
Exported	BoolViewData	Export status of the batch.
ExportedDate	DateViewData	Export date.
ExportedBy	StringViewData	Who exported the batch.
NotForExport	BoolViewData	The batch is not for exporting.
NotForExportDate	DateViewData	Date marked as Not for Export
NotForExportBy	StringViewData	Who marked Not for Export.
Reference	StringViewData	Reference text.
BatchNotes	StringViewData	Notes/comments
ReversalOfBatch	StringViewData
HiddenBatchNotes	String
BatchStatus	StringViewData	Status of the batch
BatchTotal	DecimalViewData
ReversingJournal	BoolViewData
Print	SplitButtonViewData
AttachmentsDialog	FileAttachmentsViewData
Import	ButtonViewData
ImportAdjustment	SplitButtonViewData
PayrollPeriod	OptionsViewData
Currency	PickerViewData	The currency
FcConversionRate	DecimalViewData	Foreign currency conversation rate.
UseForeignCurrency	Boolean	Foreign currency status.

⬆️ Back to top

BatchBatchKey

FieldProperty	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

FieldProperty	Type	Description
Type	String	Line type
BatchNo	Integer	Batch number
Date	String	Date
Year	String	Year
Period	Integer	The financial period
YearPeriodIndex	Integer
CreatedDate	String	Date created.
CreatedById	Integer	ID of person who created the batch.
CreatedByName	String	Name of person who created the batch.
FinancialCompany	String	Financial company.
Location	String	Location.
Reference	String	Reference text
Notes	String	Batch note
Reversal	Integer
Closed	Boolean	Status of the batch.
ReversingJournal	Boolean
ClosedById	Integer	Code of person who closed the batch.
NotForExport	Boolean	Value of Not For Export flag.
Exported	Boolean	Exported status.
ExportedById	Integer	ID of person exported the batch.
ExportDate	String	Exported date.
ClosedDate	String	Closed date.
ExportStatus	String	Export status.
InterCoStatus	String	Status of inter-company.
Select	CellData
Export	CellData
TypeValue	CellData	Batch type.
BatchNoValue	CellData	Batch number.
DateValue	CellData	Batch date.
YearPeriodValue	CellData	Financial year period of the batch.
CreatedByValue	CellData	Person who created the batch.
FinancialCompanyValue	CellData	Financial company.
ReferenceValue	CellData	Reference text
NotesValue	CellData	Batch note.
ReversalValue	CellData
ClosedValue	CellData	Closed status.
NotForExportValue	CellData	Value of Not for Export flag.
ClosedDateValue	CellData	Closed date.
ExportDateValue	CellData	Exported date.
ExportStatusValue	CellData	Export status.
InterCo	CellData	Internal company.
InterCoStatusValue	CellData	Internal company.
BatchStatus	String	Batch status.
Status	String	Batch status.
ReadonlyFlag	Integer	Value of Read-Only property.
ReadonlyMessage	String
OriginalKey	BatchBatchKey
CurrentKey	BatchBatchKey
Key	BatchBatchKey
Index	Integer

⬆️ Back to top

JobTransactionApiModel

FieldProperty	Type	Description
Key	JobTransactionsJobTransactionKey
Fields	BatchBatchFields
Rows	Array [JobTransactionsJobTransactionLine]
ValidationErrors	Array [MvcValidationError]

⬆️ Back to top

JobTransactionsJobTransactionKey

FieldProperty	Type	Description
BatchNo	Integer	Number of the batch.
BatchType	String	Batch type.

⬆️ Back to top

JobTransactionsJobTransactionDetailKey

FieldProperty	Type	Description
JobTranId	Integer
PersonId	Integer	Person id.
JobCode	String	Job code.
FinCoCode	String	Code of financial company.
ActivityCode	String	Activity code.
ActivityCodeValue	String	Activity code.
ActivityType	String	Activity type.
ActivitySubType	String	Activity sub type
WorkCentreCode	String	Code of Work Centre.
WorkCentreCodeValue	String	Code of Work Centre.
ItemId	Integer	Item id.
StockLocationCodeValue	String	Stock location code.
CostRateValue	Number	Cost rate.
BatchType	String	Batch type
OrderDerivedLine	Boolean
DocketDerivedLine	Boolean
StockDerivedLine	Boolean
Type	String	= ['InwardsGoodsEntry', 'InwardsGoodsEdit', 'Issue', 'Return', 'Transfer', 'Requisition']
PurchaseOrderLineIdValue	Integer	Purchase Order line id.
LogHeaderId	Integer	Log header id.
KeyName	String
CompanyId	Integer	company id.
GSTTypeCodeValue	String

⬆️ Back to top

JobTransactionsJobTransactionLine

Field	Type	Description
TranDateProperty	String
LogHeaderID	Integer	Log header id.
lFcCost	Number	Foreign currency code
FcRetail	Number	Foreign currency retail.
PurchaseOrderLineId	Integer	Purchase Order line id.
StockLocationInactive	Boolean
Unit	String	Unit
EnteredByID	Integer	ID of person who entered data.
SourceID	Integer
FCGST	Number	Foreign currency tax.
JobCodeValue	CellData	Job code.
LogHeader	CellData	Job code.
ActivityCodeValue	CellData	Activity code.
WorkCentreCodeValue	CellData	Work Centre code.
QuantityValue	CellData	Quantity
FcCostValue	CellData	Foreign currency cost.
CostValue	CellData	Cost.
GSTTypeValue	CellData	Tax type.
GSTTypeCodeValue	CellData	Code of tax type.
GSTRateValue	CellData	Tax rate
GSTValue	CellData	Tax value
NetValueValue	CellData	Net value
ReferenceValue	CellData	Reference.
FcRetailValue	CellData	Foreign currency retail
RetailValue	CellData	Retail.
LineDescriptionValue	CellData	Description of line
DetailsValue	CellData	Details
FromPONumberValue	CellData	From Purchase Order number
PurchaseOrderLineIdValue	CellData	Purchase Order line id.
StockLocationCodeValue	CellData
StockItemCodeValue	CellData	Stock item code.
TotalLineCostValue	CellData	Total line cost.
CostRateValue	CellData	Cost rate.
UnitValue	CellData	Unit.
FCGSTValue	CellData	Foreign currency tax.
Delete	CellData
Serials	CellData
SerialRows	Array [TabletSerialLine]
Status	String	Status.
ReadonlyFlag	Integer
ReadonlyMessage	String
OriginalKey	JobTransactionsJobTransactionDetailKey
CurrentKey	JobTransactionsJobTransactionDetailKey
Key	JobTransactionsJobTransactionDetailKey
Index	Integer

⬆️ Back to top

Sample

Returns a new Batch for Workbench Import.

Expand

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 Block

language	json

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

Versions Compared

Old Version 9

New Version 10

Key

Overview

Endpoints

BatchDetailApi

BatchListApi

Models

SystemBatchApiModel

GridResult_BatchBatchLine

BatchBatchFields

BatchBatchKey

BatchBatchLine

JobTransactionApiModel

JobTransactionsJobTransactionKey

JobTransactionsJobTransactionDetailKey

JobTransactionsJobTransactionLine

Sample

Returns a new Batch for Workbench Import.

Request

Response

Response Sample

Get the list of Workbench batches

Request

Response

Response Sample

Get Batch with JobTransactions for a BatchID

Request

Response

Response Sample

Request

Response

Response Sample

Page Comparison

Versions Compared

Old Version 9

New Version 10

Key

Overview

Endpoints

BatchDetailApi

BatchListApi

Models

SystemBatchApiModel

GridResult_BatchBatchLine

BatchBatchFields

BatchBatchKey

BatchBatchLine

JobTransactionApiModel

JobTransactionsJobTransactionKey

JobTransactionsJobTransactionDetailKey

JobTransactionsJobTransactionLine

Sample

Returns a new Batch for Workbench Import.

Request

Response

Response Sample

Get the list of Workbench batches

Request

Response

Response Sample

Get Batch with JobTransactions for a BatchID

Request

Response

Response Sample

Request

Response

Response Sample