- Created by Bao TRINH, last modified on Apr 19, 2024
You are viewing an old version of this page. View the current version.
Compare with Current View Page History
« Previous Version 9 Next »
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
Field | 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
Field | Type | Description |
---|---|---|
Total | Integer | Total number of batches |
Page | Integer | Page |
Records | Integer | Records |
Rows | Array | Array [BatchBatchLine] |
Form | Object |
|
Widgets |
|
⬆️ Back to top
BatchBatchFields
Field | Type | Description |
---|---|---|
BatchNo | 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 |
| |
ReversingJournal |
| |
AttachmentsDialog |
| |
Import |
| |
ImportAdjustment |
| |
PayrollPeriod |
| |
Currency | The currency | |
FcConversionRate | Foreign currency conversation rate. | |
UseForeignCurrency | Boolean | Foreign currency status. |
⬆️ Back to top
BatchBatchKey
Field | Type | Description |
---|---|---|
BatchNo | Integer | Batch number/code |
BatchType | String | Batch type. |
FinCoCode | String | Code of the finance company |
Exported | Boolean | Exported status. |
InterCoStatus | String |
|
HasExportErrored | Boolean | The exporting error status. |
⬆️ Back to top
BatchBatchLine
Field | Type | Description |
---|---|---|
Type | String | Line type |
BatchNo | Integer | Batch number |
Date | String | Date |
Year | String | Year |
Period | Integer | The financial period |
YearPeriodIndex | Integer |
|
CreatedDate | String | Date 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
Field | Type | Description |
---|---|---|
Key |
| |
Fields |
| |
Rows |
| |
ValidationErrors | Array [MvcValidationError] |
|
⬆️ Back to top
JobTransactionsJobTransactionKey
Field | Type | Description |
---|---|---|
BatchNo | Integer | Number of the batch. |
BatchType | String | Batch type. |
⬆️ Back to top
JobTransactionsJobTransactionDetailKey
Field | 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 |
---|---|---|
TranDate | 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 | Job code. | |
LogHeader | Job code. | |
ActivityCodeValue | Activity code. | |
WorkCentreCodeValue | Work Centre code. | |
QuantityValue | Quantity | |
FcCostValue | Foreign currency cost. | |
CostValue | Cost. | |
GSTTypeValue | Tax type. | |
GSTTypeCodeValue | Code of tax type. | |
GSTRateValue | Tax rate | |
GSTValue | Tax value | |
NetValueValue | Net value | |
ReferenceValue | Reference. | |
FcRetailValue | Foreign currency retail | |
RetailValue | Retail. | |
LineDescriptionValue | Description of line | |
DetailsValue | Details | |
FromPONumberValue | From Purchase Order number | |
PurchaseOrderLineIdValue | Purchase Order line id. | |
StockLocationCodeValue |
| |
StockItemCodeValue | Stock item code. | |
TotalLineCostValue | Total line cost. | |
CostRateValue | Cost rate. | |
UnitValue | Unit. | |
FCGSTValue | Foreign currency tax. | |
Delete |
| |
Serials |
| |
SerialRows | Array [TabletSerialLine] |
|
Status | String | Status. |
ReadonlyFlag | Integer |
|
ReadonlyMessage | String |
|
OriginalKey |
| |
CurrentKey |
| |
Key |
| |
Index | Integer |
|
⬆️ Back to top
Sample
Returns a new Batch for Workbench Import.
Request
{ "predicate": { "PredicateRows": [{ "LeftOperand": "Closed", "Operator": "Eq", "RightOperand": [ "true" ], "Display": true }, { "LeftOperand": "Exported", "Operator": "Eq", "RightOperand": ["false"], "Display": true } ] }, "sidx": "Date", "sord": "desc", "page": 1, "rows": 20, "StringValue": "Adjustment,Adj Reversal,AP Credit,AP Invoice,AR Credit,AR Internal,AR Invoice,AR Receipt,CCC Accrual,Disbursement,Docket,Payroll,Plant Issue,PO Accrual,Revenue Journal,SCC Accrual,Stock Adjust,Stock Issue,Stock Qty,Stock Return,Stock Trf,Stock Value,Sub Claim,Timesheet,WIP Accrual" }
Response
SystemBatchApiModel { BatchNo (Integer, optional), BatchType (string, optional), BatchDate (string, optional), PeriodNo (Integer, optional), YearNo (Integer, optional), CreatedById (Integer, optional), CreatedDateTime (string, optional), LocationCode (string, optional), CompanyCode (string, optional), BatchReference (string, optional), BatchNotes (string, optional), ClosedFlag (Integer, optional), ReversingJournal (Integer, optional), ClosedDate (string, optional), ClosedById (Integer, optional), NotForExportFlag (Integer, optional), NotForExportDate (string, optional), NotForExportId (Integer, optional), ExportDate (string, optional), ExportedById (Integer, optional), ExportStatus (string, optional) }
Response Sample
{ "BatchNo": 224049, "BatchType": "AP Invoice", "BatchDate": "2023-11-30T00:00:00", "PeriodNo": 5, "YearNo": 2024, "CreatedDateTime": "2023-11-07T11:42:47.44", "LocationCode": "0", "CompanyCode": "01", "BatchReference": "AP Invoice Auto", "ClosedFlag": 0, "ReversingJournal": 0, "NotForExportFlag": 0 }
Get the list of Workbench batches
Request
GridRequestParametersApi { predicate (DynamicPredicateApi), sidx (string), sord (string), page (Integer), rows (Integer), jobCode (string, optional), finCoCode (string, optional), functionalCode (string, optional) = ['General', 'PurchaseOrders', 'PurchaseOrderApproval', 'PurchaseRequisitions', 'Timesheets', 'TimesheetReviews', 'TimesheetApproval', 'TimesheetApprovalList', 'ServiceLog', 'ServiceDesk', 'ExpenseClaims', 'ExpenseClaimReviews', 'ExpenseClaimApproval', 'ExpenseClaimAdminApproval', 'TabletTimesheet', 'TabletTimePlant', 'Scheduler', 'LeaveManagement', 'LeaveTypeManagement', 'CrewTimesheets', 'Refueling', 'HumanResources', 'DailyDiary', 'Datasheets', 'Stock', 'LogDaysheet', 'PortalPeople', 'PortalCompany', 'Workflow', 'Reporting', 'ProfitCentres', 'ExternalSalesCodes', 'InternalSalesCodes', 'ActivityReportCode', 'ProfitCentreReportCode', 'SalesCodeReportCode', 'Batch', 'Budget', 'Billing', 'TimeCodes', 'Disbursement', 'Jobs', 'ApInvoices', 'Adjustments', 'Plant', 'NonStockLocation', 'JobContract', 'Processes', 'JobReceipt', 'Forecast', 'SubContracts', 'WorkOrderApproval', 'StockItem', 'ApInvoiceApproval', 'ApCreditApproval', 'TimesheetAdminApproval', 'DocketEntry', 'Revenue', 'Vouchers', 'VoucherApproval', 'Quotes', 'ProductionMeasures', 'StockIssue', 'Utilities', 'SubcontractClaimWorkflowApproval', 'BulkInvoice', 'WorkOrder', 'DocumentRegister', 'Activities', 'SalesCodes', 'ContractorDaysheet', 'Materials', 'ExternalPlant', 'JobInvoices', 'BillOfMaterials', 'Users', 'Daysheet', 'Procurement', 'DocketReconciliation', 'Imports', 'ScheduleStoredProcedure', 'Internal', 'TrustAccount', 'Impersonation', 'SubContractRetentionTrustAccount', 'ContractRetentionTrustAccount'], IntValue (Integer, optional), StringValue (string, optional), BoolValue (boolean, optional), DateValue (string, optional) } DynamicPredicateApi { PredicateRows (Array[DynamicPredicateRowApi]), IsOr (boolean, optional) } DynamicPredicateRowApi { LeftOperand (string), Operator (string) = ['Lt', 'Gt', 'Eq', 'Ne', 'Le', 'Ge', 'Like', 'IsOneOf', 'IsNotOneOf', 'Between', 'StartsWith', 'StartsWithIsOneOf', 'Either'], RightOperand (Array[string]), Display (boolean, optional) }
Response
GridResult_BatchBatchLine { total (Integer, optional), page (Integer, optional), records (Integer, optional), rows (Array[BatchBatchLine], optional), form (object, optional), widgets (Array[ViewData_GridWidget], optional) } BatchBatchLine { Type (string, optional), BatchNo (Integer, optional), Date (string, optional), Year (Integer, optional), Period (Integer, optional), YearPeriodIndex (Integer, optional), CreatedDate (string, optional), CreatedById (Integer, optional), CreatedByName (string, optional), FinancialCompany (string, optional), Location (string, optional), Reference (string, optional), Notes (string, optional), Reversal (Integer, optional), Closed (boolean, optional), ReversingJournal (boolean, optional), ClosedById (Integer, optional), NotForExport (boolean, optional), Exported (boolean, optional), ExportedById (Integer, optional), ExportDate (string, optional), ClosedDate (string, optional), ExportStatus (string, optional), InterCoStatus (string, optional), Select (CellData, optional), Export (CellData, optional), TypeValue (CellData, optional), BatchNoValue (CellData, optional), DateValue (CellData, optional), YearPeriodValue (CellData, optional, read only), CreatedByValue (CellData, optional), FinancialCompanyValue (CellData, optional), ReferenceValue (CellData, optional), NotesValue (CellData, optional), ReversalValue (CellData, optional), ClosedValue (CellData, optional), NotForExportValue (CellData, optional), ClosedDateValue (CellData, optional), ExportDateValue (CellData, optional), ExportStatusValue (CellData, optional), InterCo (CellData, optional), InterCoStatusValue (CellData, optional), BatchStatus (string, optional), Status (string, optional), ReadonlyFlag (Integer, optional), ReadonlyMessage (string, optional), OriginalKey (BatchBatchKey, optional), CurrentKey (BatchBatchKey, optional), Key (BatchBatchKey, optional), Index (Integer, optional) } ViewData_GridWidget { WidgetId (Integer, optional), LayoutCode (string, optional), Name (string, optional), Colour (string, optional), BGColour (string, optional), Icon (string, optional), Type (string, optional), Visible (boolean, optional), Order (Integer, optional), Count (Integer, optional), WidgetLines (Array[ViewData_GridWidgetLine], optional) } CellData { CellId (string, optional), CellValue (string, optional), CellNumValue (number, optional), CellBoolValue (boolean, optional), CellTag (string, optional), CellValueDate (string, optional), CellValueInt (Integer, optional) } BatchBatchKey { BatchNo (Integer, optional), BatchType (string, optional), FinCoCode (string, optional), Exported (boolean, optional), InterCoStatus (string, optional), HasExportErrored (boolean, optional) } ViewData_GridWidgetLine { WidgetLineId (Integer, optional), WidgetId (Integer, optional), Name (string, optional), Predicate (string, optional), Order (Integer, optional), Count (Integer, optional) }
Response Sample
{ "total": 13, "page": 1, "records": 253, "rows": [ { "Type": "AP Invoice", "BatchNo": 224066, "Date": "2024-03-31T00:00:00", "Year": 2024, "Period": 9, "YearPeriodIndex": 24297, "CreatedDate": "2024-03-07T10:54:30.63", "FinancialCompany": "01", "Location": "0", "Reference": "AP Invoice Auto", "Notes": "This batch was flagged as Not For Export by WebWorkbench Admin on 13-Mar-2024\r\nThis batch was flagged as Closed by WebWorkbench Admin on 13-Mar-2024", "Closed": true, "ReversingJournal": false, "ClosedById": 340, "NotForExport": true, "Exported": false, "ExportStatus": "[Blank]", "Select": { "CellId": "224066", "CellValue": "224066", "CellTag": "224066" }, "Export": { "CellBoolValue": false }, "TypeValue": { "CellValue": "AP Invoice" }, "BatchNoValue": { "CellId": "UpdatePopupDialog", "CellValue": "224066", "CellBoolValue": false, "CellTag": "224066" }, "DateValue": { "CellValue": "31-Mar-2024", "CellValueDate": "2024-03-31T00:00:00" }, "YearPeriodValue": { "CellValue": "2024/09" }, "CreatedByValue": { "CellId": "" }, "FinancialCompanyValue": { "CellId": "01", "CellValue": "01" }, "ReferenceValue": { "CellValue": "AP Invoice Auto" }, "NotesValue": { "CellValue": "This batch was flagged as Not For Export by WebWorkbench Admin on 13-Mar-2024\r\nThis batch was flagged as Closed by WebWorkbench Admin on 13-Mar-2024" }, "ReversalValue": {}, "ClosedValue": { "CellBoolValue": true }, "NotForExportValue": { "CellBoolValue": true }, "ExportDateValue": {}, "ExportStatusValue": { "CellId": "StatusPopupDialog", "CellBoolValue": true }, "InterCo": { "CellBoolValue": false }, "InterCoStatusValue": { "CellId": "InterCoStatusPopupDialog", "CellBoolValue": true }, "ReadonlyFlag": 0, "OriginalKey": { "BatchNo": 224066, "BatchType": "AP Invoice", "FinCoCode": "01", "Exported": false, "HasExportErrored": false }, "CurrentKey": { "BatchNo": 224066, "BatchType": "AP Invoice", "FinCoCode": "01", "Exported": false, "HasExportErrored": false }, "Key": { "BatchNo": 224066, "BatchType": "AP Invoice", "FinCoCode": "01", "Exported": false, "HasExportErrored": false }, "Index": 0 }, { "Type": "AP Invoice", "BatchNo": 224067, "Date": "2024-03-31T00:00:00", "Year": 2024, "Period": 9, "YearPeriodIndex": 24297, "CreatedDate": "2024-03-13T10:32:13.49", "FinancialCompany": "01", "Location": "EQUIP", "Reference": "AP Invoice Auto", "Notes": "This batch was flagged as Closed by WebWorkbench Admin on 13-Mar-2024\r\nThis batch was flagged as Not For Export by WebWorkbench Admin on 13-Mar-2024", "Closed": true, "ReversingJournal": false, "ClosedById": 340, "NotForExport": true, "Exported": false, "ExportStatus": "[Blank]", "Select": { "CellId": "224067", "CellValue": "224067", "CellTag": "224067" }, "Export": { "CellBoolValue": false }, "TypeValue": { "CellValue": "AP Invoice" }, "BatchNoValue": { "CellId": "UpdatePopupDialog", "CellValue": "224067", "CellBoolValue": false, "CellTag": "224067" }, "DateValue": { "CellValue": "31-Mar-2024", "CellValueDate": "2024-03-31T00:00:00" }, "YearPeriodValue": { "CellValue": "2024/09" }, "CreatedByValue": { "CellId": "" }, "FinancialCompanyValue": { "CellId": "01", "CellValue": "01" }, "ReferenceValue": { "CellValue": "AP Invoice Auto" }, "NotesValue": { "CellValue": "This batch was flagged as Closed by WebWorkbench Admin on 13-Mar-2024\r\nThis batch was flagged as Not For Export by WebWorkbench Admin on 13-Mar-2024" }, "ReversalValue": {}, "ClosedValue": { "CellBoolValue": true }, "NotForExportValue": { "CellBoolValue": true }, "ExportDateValue": {}, "ExportStatusValue": { "CellId": "StatusPopupDialog", "CellBoolValue": true }, "InterCo": { "CellBoolValue": false }, "InterCoStatusValue": { "CellId": "InterCoStatusPopupDialog", "CellBoolValue": true }, "ReadonlyFlag": 0, "OriginalKey": { "BatchNo": 224067, "BatchType": "AP Invoice", "FinCoCode": "01", "Exported": false, "HasExportErrored": false }, "CurrentKey": { "BatchNo": 224067, "BatchType": "AP Invoice", "FinCoCode": "01", "Exported": false, "HasExportErrored": false }, "Key": { "BatchNo": 224067, "BatchType": "AP Invoice", "FinCoCode": "01", "Exported": false, "HasExportErrored": false }, "Index": 0 }, { "Type": "AP Invoice", "BatchNo": 224070, "Date": "2024-03-31T00:00:00", "Year": 2024, "Period": 9, "YearPeriodIndex": 24297, "CreatedDate": "2024-03-13T00:00:00", "CreatedById": 340, "CreatedByName": "WebWorkbench Admin", "FinancialCompany": "BAOT", "Location": "0", "Reference": "AP Invoice-2024/09-3", "Notes": "This batch was flagged as Not For Export by WebWorkbench Admin on 13-Mar-2024\r\nThis batch was flagged as Closed by WebWorkbench Admin on 13-Mar-2024", "Closed": true, "ReversingJournal": false, "ClosedById": 340, "NotForExport": true, "Exported": false, "ExportStatus": "[Blank]", "Select": { "CellId": "224070", "CellValue": "224070", "CellTag": "224070" }, "Export": { "CellBoolValue": false }, "TypeValue": { "CellValue": "AP Invoice" }, "BatchNoValue": { "CellId": "UpdatePopupDialog", "CellValue": "224070", "CellBoolValue": false, "CellTag": "224070" }, "DateValue": { "CellValue": "31-Mar-2024", "CellValueDate": "2024-03-31T00:00:00" }, "YearPeriodValue": { "CellValue": "2024/09" }, "CreatedByValue": { "CellId": "340", "CellValue": "WebWorkbench Admin" }, "FinancialCompanyValue": { "CellId": "BAOT", "CellValue": "BAOT" }, "ReferenceValue": { "CellValue": "AP Invoice-2024/09-3" }, "NotesValue": { "CellValue": "This batch was flagged as Not For Export by WebWorkbench Admin on 13-Mar-2024\r\nThis batch was flagged as Closed by WebWorkbench Admin on 13-Mar-2024" }, "ReversalValue": {}, "ClosedValue": { "CellBoolValue": true }, "NotForExportValue": { "CellBoolValue": true }, "ExportDateValue": {}, "ExportStatusValue": { "CellId": "StatusPopupDialog", "CellBoolValue": true }, "InterCo": { "CellBoolValue": false }, "InterCoStatusValue": { "CellId": "InterCoStatusPopupDialog", "CellBoolValue": true }, "ReadonlyFlag": 0, "OriginalKey": { "BatchNo": 224070, "BatchType": "AP Invoice", "FinCoCode": "BAOT", "Exported": false, "HasExportErrored": false }, "CurrentKey": { "BatchNo": 224070, "BatchType": "AP Invoice", "FinCoCode": "BAOT", "Exported": false, "HasExportErrored": false }, "Key": { "BatchNo": 224070, "BatchType": "AP Invoice", "FinCoCode": "BAOT", "Exported": false, "HasExportErrored": false }, "Index": 0 }, { "Type": "AP Invoice", "BatchNo": 224071, "Date": "2024-03-31T00:00:00", "Year": 2024, "Period": 9, "YearPeriodIndex": 24297, "CreatedDate": "2024-03-13T15:21:37.54", "FinancialCompany": "BAOT", "Location": "LTEST", "Reference": "AP Invoice Auto", "Notes": "This batch was flagged as Not For Export by WebWorkbench Admin on 13-Mar-2024\r\nThis batch was flagged as Closed by WebWorkbench Admin on 13-Mar-2024", "Closed": true, "ReversingJournal": false, "ClosedById": 340, "NotForExport": true, "Exported": false, "ExportStatus": "[Blank]", "Select": { "CellId": "224071", "CellValue": "224071", "CellTag": "224071" }, "Export": { "CellBoolValue": false }, "TypeValue": { "CellValue": "AP Invoice" }, "BatchNoValue": { "CellId": "UpdatePopupDialog", "CellValue": "224071", "CellBoolValue": false, "CellTag": "224071" }, "DateValue": { "CellValue": "31-Mar-2024", "CellValueDate": "2024-03-31T00:00:00" }, "YearPeriodValue": { "CellValue": "2024/09" }, "CreatedByValue": { "CellId": "" }, "FinancialCompanyValue": { "CellId": "BAOT", "CellValue": "BAOT" }, "ReferenceValue": { "CellValue": "AP Invoice Auto" }, "NotesValue": { "CellValue": "This batch was flagged as Not For Export by WebWorkbench Admin on 13-Mar-2024\r\nThis batch was flagged as Closed by WebWorkbench Admin on 13-Mar-2024" }, "ReversalValue": {}, "ClosedValue": { "CellBoolValue": true }, "NotForExportValue": { "CellBoolValue": true }, "ExportDateValue": {}, "ExportStatusValue": { "CellId": "StatusPopupDialog", "CellBoolValue": true }, "InterCo": { "CellBoolValue": false }, "InterCoStatusValue": { "CellId": "InterCoStatusPopupDialog", "CellBoolValue": true }, "ReadonlyFlag": 0, "OriginalKey": { "BatchNo": 224071, "BatchType": "AP Invoice", "FinCoCode": "BAOT", "Exported": false, "HasExportErrored": false }, "CurrentKey": { "BatchNo": 224071, "BatchType": "AP Invoice", "FinCoCode": "BAOT", "Exported": false, "HasExportErrored": false }, "Key": { "BatchNo": 224071, "BatchType": "AP Invoice", "FinCoCode": "BAOT", "Exported": false, "HasExportErrored": false }, "Index": 0 }, { "Type": "AP Credit", "BatchNo": 224075, "Date": "2024-03-31T00:00:00", "Year": 2024, "Period": 9, "YearPeriodIndex": 24297, "CreatedDate": "2024-03-19T12:01:29.77", "FinancialCompany": "01", "Location": "0", "Reference": "Auto", "Closed": true, "ReversingJournal": false, "NotForExport": false, "Exported": false, "ExportStatus": "[Blank]", "Select": { "CellId": "224075", "CellValue": "224075", "CellTag": "224075" }, "Export": { "CellBoolValue": false }, "TypeValue": { "CellValue": "AP Credit" }, "BatchNoValue": { "CellId": "UpdatePopupDialog", "CellValue": "224075", "CellBoolValue": false, "CellTag": "224075" }, "DateValue": { "CellValue": "31-Mar-2024", "CellValueDate": "2024-03-31T00:00:00" }, "YearPeriodValue": { "CellValue": "2024/09" }, "CreatedByValue": { "CellId": "" }, "FinancialCompanyValue": { "CellId": "01", "CellValue": "01" }, "ReferenceValue": { "CellValue": "Auto" }, "NotesValue": {}, "ReversalValue": {}, "ClosedValue": { "CellBoolValue": true }, "NotForExportValue": { "CellBoolValue": false }, "ExportDateValue": {}, "ExportStatusValue": { "CellId": "StatusPopupDialog", "CellBoolValue": true }, "InterCo": { "CellBoolValue": false }, "InterCoStatusValue": { "CellId": "InterCoStatusPopupDialog", "CellBoolValue": true }, "ReadonlyFlag": 0, "OriginalKey": { "BatchNo": 224075, "BatchType": "AP Credit", "FinCoCode": "01", "Exported": false, "HasExportErrored": false }, "CurrentKey": { "BatchNo": 224075, "BatchType": "AP Credit", "FinCoCode": "01", "Exported": false, "HasExportErrored": false }, "Key": { "BatchNo": 224075, "BatchType": "AP Credit", "FinCoCode": "01", "Exported": false, "HasExportErrored": false }, "Index": 0 }, { "Type": "AR Invoice", "BatchNo": 724024, "Date": "2024-03-31T00:00:00", "Year": 2024, "Period": 9, "YearPeriodIndex": 24297, "CreatedDate": "2024-03-13T16:09:55.457", "FinancialCompany": "01", "Location": "0", "Reference": "AR Invoice Auto", "Closed": true, "ReversingJournal": false, "ClosedById": 340, "NotForExport": false, "Exported": false, "ExportStatus": "Error", "Select": { "CellId": "724024", "CellValue": "724024", "CellTag": "724024" }, "Export": { "CellBoolValue": false }, "TypeValue": { "CellValue": "AR Invoice" }, "BatchNoValue": { "CellId": "UpdatePopupDialog", "CellValue": "724024", "CellBoolValue": false, "CellTag": "724024" }, "DateValue": { "CellValue": "31-Mar-2024", "CellValueDate": "2024-03-31T00:00:00" }, "YearPeriodValue": { "CellValue": "2024/09" }, "CreatedByValue": { "CellId": "" }, "FinancialCompanyValue": { "CellId": "01", "CellValue": "01" }, "ReferenceValue": { "CellValue": "AR Invoice Auto" }, "NotesValue": {}, "ReversalValue": {}, "ClosedValue": { "CellBoolValue": true }, "NotForExportValue": { "CellBoolValue": false }, "ExportDateValue": {}, "ExportStatusValue": { "CellId": "StatusPopupDialog", "CellValue": "Error", "CellBoolValue": false }, "InterCo": { "CellBoolValue": false }, "InterCoStatusValue": { "CellId": "InterCoStatusPopupDialog", "CellBoolValue": true }, "ReadonlyFlag": 0, "OriginalKey": { "BatchNo": 724024, "BatchType": "AR Invoice", "FinCoCode": "01", "Exported": false, "HasExportErrored": true }, "CurrentKey": { "BatchNo": 724024, "BatchType": "AR Invoice", "FinCoCode": "01", "Exported": false, "HasExportErrored": true }, "Key": { "BatchNo": 724024, "BatchType": "AR Invoice", "FinCoCode": "01", "Exported": false, "HasExportErrored": true }, "Index": 0 }, { "Type": "AR Invoice", "BatchNo": 724028, "Date": "2024-03-31T00:00:00", "Year": 2024, "Period": 9, "YearPeriodIndex": 24297, "CreatedDate": "2024-03-15T13:43:30.773", "FinancialCompany": "03", "Location": "0", "Reference": "AR Invoice Auto", "Closed": true, "ReversingJournal": false, "ClosedById": 340, "NotForExport": false, "Exported": false, "ExportStatus": "Error", "Select": { "CellId": "724028", "CellValue": "724028", "CellTag": "724028" }, "Export": { "CellBoolValue": false }, "TypeValue": { "CellValue": "AR Invoice" }, "BatchNoValue": { "CellId": "UpdatePopupDialog", "CellValue": "724028", "CellBoolValue": false, "CellTag": "724028" }, "DateValue": { "CellValue": "31-Mar-2024", "CellValueDate": "2024-03-31T00:00:00" }, "YearPeriodValue": { "CellValue": "2024/09" }, "CreatedByValue": { "CellId": "" }, "FinancialCompanyValue": { "CellId": "03", "CellValue": "03" }, "ReferenceValue": { "CellValue": "AR Invoice Auto" }, "NotesValue": {}, "ReversalValue": {}, "ClosedValue": { "CellBoolValue": true }, "NotForExportValue": { "CellBoolValue": false }, "ExportDateValue": {}, "ExportStatusValue": { "CellId": "StatusPopupDialog", "CellValue": "Error", "CellBoolValue": false }, "InterCo": { "CellBoolValue": false }, "InterCoStatusValue": { "CellId": "InterCoStatusPopupDialog", "CellBoolValue": true }, "ReadonlyFlag": 0, "OriginalKey": { "BatchNo": 724028, "BatchType": "AR Invoice", "FinCoCode": "03", "Exported": false, "HasExportErrored": true }, "CurrentKey": { "BatchNo": 724028, "BatchType": "AR Invoice", "FinCoCode": "03", "Exported": false, "HasExportErrored": true }, "Key": { "BatchNo": 724028, "BatchType": "AR Invoice", "FinCoCode": "03", "Exported": false, "HasExportErrored": true }, "Index": 0 }, { "Type": "AR Credit", "BatchNo": 724034, "Date": "2024-03-31T00:00:00", "Year": 2024, "Period": 9, "YearPeriodIndex": 24297, "CreatedDate": "2024-03-19T12:02:03.107", "FinancialCompany": "01", "Location": "0", "Reference": "Auto", "Closed": true, "ReversingJournal": false, "NotForExport": false, "Exported": false, "ExportStatus": "[Blank]", "Select": { "CellId": "724034", "CellValue": "724034", "CellTag": "724034" }, "Export": { "CellBoolValue": false }, "TypeValue": { "CellValue": "AR Credit" }, "BatchNoValue": { "CellId": "UpdatePopupDialog", "CellValue": "724034", "CellBoolValue": false, "CellTag": "724034" }, "DateValue": { "CellValue": "31-Mar-2024", "CellValueDate": "2024-03-31T00:00:00" }, "YearPeriodValue": { "CellValue": "2024/09" }, "CreatedByValue": { "CellId": "" }, "FinancialCompanyValue": { "CellId": "01", "CellValue": "01" }, "ReferenceValue": { "CellValue": "Auto" }, "NotesValue": {}, "ReversalValue": {}, "ClosedValue": { "CellBoolValue": true }, "NotForExportValue": { "CellBoolValue": false }, "ExportDateValue": {}, "ExportStatusValue": { "CellId": "StatusPopupDialog", "CellBoolValue": true }, "InterCo": { "CellBoolValue": false }, "InterCoStatusValue": { "CellId": "InterCoStatusPopupDialog", "CellBoolValue": true }, "ReadonlyFlag": 0, "OriginalKey": { "BatchNo": 724034, "BatchType": "AR Credit", "FinCoCode": "01", "Exported": false, "HasExportErrored": false }, "CurrentKey": { "BatchNo": 724034, "BatchType": "AR Credit", "FinCoCode": "01", "Exported": false, "HasExportErrored": false }, "Key": { "BatchNo": 724034, "BatchType": "AR Credit", "FinCoCode": "01", "Exported": false, "HasExportErrored": false }, "Index": 0 }, { "Type": "Adjustment", "BatchNo": 424019, "Date": "2024-03-13T00:00:00", "Year": 2024, "Period": 9, "YearPeriodIndex": 24297, "CreatedDate": "2024-03-13T16:57:14.073", "FinancialCompany": "01", "Location": "0", "Reference": "Inwards Goods", "Closed": true, "ReversingJournal": false, "NotForExport": false, "Exported": false, "ExportStatus": "[Blank]", "Select": { "CellId": "424019", "CellValue": "424019", "CellTag": "424019" }, "Export": { "CellBoolValue": false }, "TypeValue": { "CellValue": "Adjustment" }, "BatchNoValue": { "CellId": "UpdatePopupDialog", "CellValue": "424019", "CellBoolValue": false, "CellTag": "424019" }, "DateValue": { "CellValue": "13-Mar-2024", "CellValueDate": "2024-03-13T00:00:00" }, "YearPeriodValue": { "CellValue": "2024/09" }, "CreatedByValue": { "CellId": "" }, "FinancialCompanyValue": { "CellId": "01", "CellValue": "01" }, "ReferenceValue": { "CellValue": "Inwards Goods" }, "NotesValue": {}, "ReversalValue": {}, "ClosedValue": { "CellBoolValue": true }, "NotForExportValue": { "CellBoolValue": false }, "ExportDateValue": {}, "ExportStatusValue": { "CellId": "StatusPopupDialog", "CellBoolValue": true }, "InterCo": { "CellBoolValue": false }, "InterCoStatusValue": { "CellId": "InterCoStatusPopupDialog", "CellBoolValue": true }, "ReadonlyFlag": 0, "OriginalKey": { "BatchNo": 424019, "BatchType": "Adjustment", "FinCoCode": "01", "Exported": false, "HasExportErrored": false }, "CurrentKey": { "BatchNo": 424019, "BatchType": "Adjustment", "FinCoCode": "01", "Exported": false, "HasExportErrored": false }, "Key": { "BatchNo": 424019, "BatchType": "Adjustment", "FinCoCode": "01", "Exported": false, "HasExportErrored": false }, "Index": 0 }, { "Type": "AP Invoice", "BatchNo": 224063, "Date": "2024-03-01T00:00:00", "Year": 2024, "Period": 9, "YearPeriodIndex": 24297, "CreatedDate": "2024-02-02T00:00:00", "CreatedById": 340, "CreatedByName": "WebWorkbench Admin", "FinancialCompany": "01", "Location": "0", "Reference": "AP Invoice-2024/09-3", "Notes": "This batch was flagged as Not For Export by WebWorkbench Admin on 13-Mar-2024\r\nThis batch was flagged as Closed by WebWorkbench Admin on 13-Mar-2024", "Closed": true, "ReversingJournal": false, "ClosedById": 340, "NotForExport": true, "Exported": false, "ExportStatus": "[Blank]", "Select": { "CellId": "224063", "CellValue": "224063", "CellTag": "224063" }, "Export": { "CellBoolValue": false }, "TypeValue": { "CellValue": "AP Invoice" }, "BatchNoValue": { "CellId": "UpdatePopupDialog", "CellValue": "224063", "CellBoolValue": false, "CellTag": "224063" }, "DateValue": { "CellValue": "01-Mar-2024", "CellValueDate": "2024-03-01T00:00:00" }, "YearPeriodValue": { "CellValue": "2024/09" }, "CreatedByValue": { "CellId": "340", "CellValue": "WebWorkbench Admin" }, "FinancialCompanyValue": { "CellId": "01", "CellValue": "01" }, "ReferenceValue": { "CellValue": "AP Invoice-2024/09-3" }, "NotesValue": { "CellValue": "This batch was flagged as Not For Export by WebWorkbench Admin on 13-Mar-2024\r\nThis batch was flagged as Closed by WebWorkbench Admin on 13-Mar-2024" }, "ReversalValue": {}, "ClosedValue": { "CellBoolValue": true }, "NotForExportValue": { "CellBoolValue": true }, "ExportDateValue": {}, "ExportStatusValue": { "CellId": "StatusPopupDialog", "CellBoolValue": true }, "InterCo": { "CellBoolValue": false }, "InterCoStatusValue": { "CellId": "InterCoStatusPopupDialog", "CellBoolValue": true }, "ReadonlyFlag": 0, "OriginalKey": { "BatchNo": 224063, "BatchType": "AP Invoice", "FinCoCode": "01", "Exported": false, "HasExportErrored": false }, "CurrentKey": { "BatchNo": 224063, "BatchType": "AP Invoice", "FinCoCode": "01", "Exported": false, "HasExportErrored": false }, "Key": { "BatchNo": 224063, "BatchType": "AP Invoice", "FinCoCode": "01", "Exported": false, "HasExportErrored": false }, "Index": 0 }, { "Type": "AP Invoice", "BatchNo": 224057, "Date": "2024-01-31T00:00:00", "Year": 2024, "Period": 7, "YearPeriodIndex": 24295, "CreatedDate": "2024-01-12T11:12:30.16", "FinancialCompany": "01", "Location": "LAB", "Reference": "AP Invoice Auto", "Closed": true, "ReversingJournal": false, "ClosedById": 340, "NotForExport": false, "Exported": false, "ExportStatus": "[Blank]", "Select": { "CellId": "224057", "CellValue": "224057", "CellTag": "224057" }, "Export": { "CellBoolValue": false }, "TypeValue": { "CellValue": "AP Invoice" }, "BatchNoValue": { "CellId": "UpdatePopupDialog", "CellValue": "224057", "CellBoolValue": false, "CellTag": "224057" }, "DateValue": { "CellValue": "31-Jan-2024", "CellValueDate": "2024-01-31T00:00:00" }, "YearPeriodValue": { "CellValue": "2024/07" }, "CreatedByValue": { "CellId": "" }, "FinancialCompanyValue": { "CellId": "01", "CellValue": "01" }, "ReferenceValue": { "CellValue": "AP Invoice Auto" }, "NotesValue": {}, "ReversalValue": {}, "ClosedValue": { "CellBoolValue": true }, "NotForExportValue": { "CellBoolValue": false }, "ExportDateValue": {}, "ExportStatusValue": { "CellId": "StatusPopupDialog", "CellBoolValue": true }, "InterCo": { "CellBoolValue": false }, "InterCoStatusValue": { "CellId": "InterCoStatusPopupDialog", "CellBoolValue": true }, "ReadonlyFlag": 0, "OriginalKey": { "BatchNo": 224057, "BatchType": "AP Invoice", "FinCoCode": "01", "Exported": false, "HasExportErrored": false }, "CurrentKey": { "BatchNo": 224057, "BatchType": "AP Invoice", "FinCoCode": "01", "Exported": false, "HasExportErrored": false }, "Key": { "BatchNo": 224057, "BatchType": "AP Invoice", "FinCoCode": "01", "Exported": false, "HasExportErrored": false }, "Index": 0 }, { "Type": "AP Credit", "BatchNo": 224061, "Date": "2024-01-31T00:00:00", "Year": 2024, "Period": 7, "YearPeriodIndex": 24295, "CreatedDate": "2024-01-26T14:22:11", "FinancialCompany": "03", "Location": "0", "Reference": "AP Credit Auto", "Closed": true, "ReversingJournal": false, "ClosedById": 340, "NotForExport": false, "Exported": false, "ExportStatus": "[Blank]", "Select": { "CellId": "224061", "CellValue": "224061", "CellTag": "224061" }, "Export": { "CellBoolValue": false }, "TypeValue": { "CellValue": "AP Credit" }, "BatchNoValue": { "CellId": "UpdatePopupDialog", "CellValue": "224061", "CellBoolValue": false, "CellTag": "224061" }, "DateValue": { "CellValue": "31-Jan-2024", "CellValueDate": "2024-01-31T00:00:00" }, "YearPeriodValue": { "CellValue": "2024/07" }, "CreatedByValue": { "CellId": "" }, "FinancialCompanyValue": { "CellId": "03", "CellValue": "03" }, "ReferenceValue": { "CellValue": "AP Credit Auto" }, "NotesValue": {}, "ReversalValue": {}, "ClosedValue": { "CellBoolValue": true }, "NotForExportValue": { "CellBoolValue": false }, "ExportDateValue": {}, "ExportStatusValue": { "CellId": "StatusPopupDialog", "CellBoolValue": true }, "InterCo": { "CellBoolValue": false }, "InterCoStatusValue": { "CellId": "InterCoStatusPopupDialog", "CellBoolValue": true }, "ReadonlyFlag": 0, "OriginalKey": { "BatchNo": 224061, "BatchType": "AP Credit", "FinCoCode": "03", "Exported": false, "HasExportErrored": false }, "CurrentKey": { "BatchNo": 224061, "BatchType": "AP Credit", "FinCoCode": "03", "Exported": false, "HasExportErrored": false }, "Key": { "BatchNo": 224061, "BatchType": "AP Credit", "FinCoCode": "03", "Exported": false, "HasExportErrored": false }, "Index": 0 }, { "Type": "AP Credit", "BatchNo": 224068, "Date": "2024-01-31T00:00:00", "Year": 2024, "Period": 7, "YearPeriodIndex": 24295, "CreatedDate": "2024-03-13T00:00:00", "CreatedById": 340, "CreatedByName": "WebWorkbench Admin", "FinancialCompany": "BAOT", "Location": "0", "Reference": "AP Credit-2024/03", "Notes": "BaoT testing", "Closed": true, "ReversingJournal": false, "ClosedById": 340, "NotForExport": false, "Exported": false, "ExportStatus": "[Blank]", "Select": { "CellId": "224068", "CellValue": "224068", "CellTag": "224068" }, "Export": { "CellBoolValue": false }, "TypeValue": { "CellValue": "AP Credit" }, "BatchNoValue": { "CellId": "UpdatePopupDialog", "CellValue": "224068", "CellBoolValue": false, "CellTag": "224068" }, "DateValue": { "CellValue": "31-Jan-2024", "CellValueDate": "2024-01-31T00:00:00" }, "YearPeriodValue": { "CellValue": "2024/07" }, "CreatedByValue": { "CellId": "340", "CellValue": "WebWorkbench Admin" }, "FinancialCompanyValue": { "CellId": "BAOT", "CellValue": "BAOT" }, "ReferenceValue": { "CellValue": "AP Credit-2024/03" }, "NotesValue": { "CellValue": "BaoT testing" }, "ReversalValue": {}, "ClosedValue": { "CellBoolValue": true }, "NotForExportValue": { "CellBoolValue": false }, "ExportDateValue": {}, "ExportStatusValue": { "CellId": "StatusPopupDialog", "CellBoolValue": true }, "InterCo": { "CellBoolValue": false }, "InterCoStatusValue": { "CellId": "InterCoStatusPopupDialog", "CellBoolValue": true }, "ReadonlyFlag": 0, "OriginalKey": { "BatchNo": 224068, "BatchType": "AP Credit", "FinCoCode": "BAOT", "Exported": false, "HasExportErrored": false }, "CurrentKey": { "BatchNo": 224068, "BatchType": "AP Credit", "FinCoCode": "BAOT", "Exported": false, "HasExportErrored": false }, "Key": { "BatchNo": 224068, "BatchType": "AP Credit", "FinCoCode": "BAOT", "Exported": false, "HasExportErrored": false }, "Index": 0 }, { "Type": "AP Invoice", "BatchNo": 224069, "Date": "2024-01-31T00:00:00", "Year": 2024, "Period": 7, "YearPeriodIndex": 24295, "CreatedDate": "2024-03-13T00:00:00", "CreatedById": 340, "CreatedByName": "WebWorkbench Admin", "FinancialCompany": "BAOT", "Location": "0", "Reference": "AP Invoice-2024/07", "Notes": "BaoT testing AP batch\r\nThis batch was flagged as Not For Export by WebWorkbench Admin on 13-Mar-2024", "Closed": true, "ReversingJournal": false, "ClosedById": 340, "NotForExport": true, "Exported": false, "ExportStatus": "[Blank]", "Select": { "CellId": "224069", "CellValue": "224069", "CellTag": "224069" }, "Export": { "CellBoolValue": false }, "TypeValue": { "CellValue": "AP Invoice" }, "BatchNoValue": { "CellId": "UpdatePopupDialog", "CellValue": "224069", "CellBoolValue": false, "CellTag": "224069" }, "DateValue": { "CellValue": "31-Jan-2024", "CellValueDate": "2024-01-31T00:00:00" }, "YearPeriodValue": { "CellValue": "2024/07" }, "CreatedByValue": { "CellId": "340", "CellValue": "WebWorkbench Admin" }, "FinancialCompanyValue": { "CellId": "BAOT", "CellValue": "BAOT" }, "ReferenceValue": { "CellValue": "AP Invoice-2024/07" }, "NotesValue": { "CellValue": "BaoT testing AP batch\r\nThis batch was flagged as Not For Export by WebWorkbench Admin on 13-Mar-2024" }, "ReversalValue": {}, "ClosedValue": { "CellBoolValue": true }, "NotForExportValue": { "CellBoolValue": true }, "ExportDateValue": {}, "ExportStatusValue": { "CellId": "StatusPopupDialog", "CellBoolValue": true }, "InterCo": { "CellBoolValue": false }, "InterCoStatusValue": { "CellId": "InterCoStatusPopupDialog", "CellBoolValue": true }, "ReadonlyFlag": 0, "OriginalKey": { "BatchNo": 224069, "BatchType": "AP Invoice", "FinCoCode": "BAOT", "Exported": false, "HasExportErrored": false }, "CurrentKey": { "BatchNo": 224069, "BatchType": "AP Invoice", "FinCoCode": "BAOT", "Exported": false, "HasExportErrored": false }, "Key": { "BatchNo": 224069, "BatchType": "AP Invoice", "FinCoCode": "BAOT", "Exported": false, "HasExportErrored": false }, "Index": 0 }, { "Type": "SCC Accrual", "BatchNo": 824017, "Date": "2024-01-31T00:00:00", "Year": 2024, "Period": 7, "YearPeriodIndex": 24295, "CreatedDate": "2024-01-22T00:00:00", "CreatedById": 340, "CreatedByName": "WebWorkbench Admin", "FinancialCompany": "01", "Location": "0", "Reference": "SCC Accrual-2024/07-", "Notes": "Logic Test", "Closed": true, "ReversingJournal": false, "ClosedById": 340, "NotForExport": false, "Exported": false, "ExportStatus": "[Blank]", "Select": { "CellId": "824017", "CellValue": "824017", "CellTag": "824017" }, "Export": { "CellBoolValue": false }, "TypeValue": { "CellValue": "SCC Accrual" }, "BatchNoValue": { "CellId": "UpdatePopupDialog", "CellValue": "824017", "CellBoolValue": false, "CellTag": "824017" }, "DateValue": { "CellValue": "31-Jan-2024", "CellValueDate": "2024-01-31T00:00:00" }, "YearPeriodValue": { "CellValue": "2024/07" }, "CreatedByValue": { "CellId": "340", "CellValue": "WebWorkbench Admin" }, "FinancialCompanyValue": { "CellId": "01", "CellValue": "01" }, "ReferenceValue": { "CellValue": "SCC Accrual-2024/07-" }, "NotesValue": { "CellValue": "Logic Test" }, "ReversalValue": {}, "ClosedValue": { "CellBoolValue": true }, "NotForExportValue": { "CellBoolValue": false }, "ExportDateValue": {}, "ExportStatusValue": { "CellId": "StatusPopupDialog", "CellBoolValue": true }, "InterCo": { "CellBoolValue": false }, "InterCoStatusValue": { "CellId": "InterCoStatusPopupDialog", "CellBoolValue": true }, "ReadonlyFlag": 0, "OriginalKey": { "BatchNo": 824017, "BatchType": "SCC Accrual", "FinCoCode": "01", "Exported": false, "HasExportErrored": false }, "CurrentKey": { "BatchNo": 824017, "BatchType": "SCC Accrual", "FinCoCode": "01", "Exported": false, "HasExportErrored": false }, "Key": { "BatchNo": 824017, "BatchType": "SCC Accrual", "FinCoCode": "01", "Exported": false, "HasExportErrored": false }, "Index": 0 }, { "Type": "CCC Accrual", "BatchNo": 824018, "Date": "2024-01-31T00:00:00", "Year": 2024, "Period": 7, "YearPeriodIndex": 24295, "CreatedDate": "2024-01-22T00:00:00", "CreatedById": 340, "CreatedByName": "WebWorkbench Admin", "FinancialCompany": "01", "Location": "0", "Reference": "CCC Accrual-2024/07-", "Notes": "test", "Closed": true, "ReversingJournal": false, "ClosedById": 340, "NotForExport": false, "Exported": false, "ExportStatus": "[Blank]", "Select": { "CellId": "824018", "CellValue": "824018", "CellTag": "824018" }, "Export": { "CellBoolValue": false }, "TypeValue": { "CellValue": "CCC Accrual" }, "BatchNoValue": { "CellId": "UpdatePopupDialog", "CellValue": "824018", "CellBoolValue": false, "CellTag": "824018" }, "DateValue": { "CellValue": "31-Jan-2024", "CellValueDate": "2024-01-31T00:00:00" }, "YearPeriodValue": { "CellValue": "2024/07" }, "CreatedByValue": { "CellId": "340", "CellValue": "WebWorkbench Admin" }, "FinancialCompanyValue": { "CellId": "01", "CellValue": "01" }, "ReferenceValue": { "CellValue": "CCC Accrual-2024/07-" }, "NotesValue": { "CellValue": "test" }, "ReversalValue": {}, "ClosedValue": { "CellBoolValue": true }, "NotForExportValue": { "CellBoolValue": false }, "ExportDateValue": {}, "ExportStatusValue": { "CellId": "StatusPopupDialog", "CellBoolValue": true }, "InterCo": { "CellBoolValue": false }, "InterCoStatusValue": { "CellId": "InterCoStatusPopupDialog", "CellBoolValue": true }, "ReadonlyFlag": 0, "OriginalKey": { "BatchNo": 824018, "BatchType": "CCC Accrual", "FinCoCode": "01", "Exported": false, "HasExportErrored": false }, "CurrentKey": { "BatchNo": 824018, "BatchType": "CCC Accrual", "FinCoCode": "01", "Exported": false, "HasExportErrored": false }, "Key": { "BatchNo": 824018, "BatchType": "CCC Accrual", "FinCoCode": "01", "Exported": false, "HasExportErrored": false }, "Index": 0 }, { "Type": "CCC Accrual", "BatchNo": 824010, "Date": "2024-01-01T00:00:00", "Year": 2024, "Period": 7, "YearPeriodIndex": 24295, "CreatedDate": "2023-11-15T16:09:52.057", "CreatedById": 340, "CreatedByName": "WebWorkbench Admin", "FinancialCompany": "01", "Location": "0", "Reference": "Reversal of 824009", "Reversal": 824009, "Closed": true, "ReversingJournal": false, "ClosedById": 340, "NotForExport": false, "Exported": false, "ExportStatus": "[Blank]", "Select": { "CellId": "824010", "CellValue": "824010", "CellTag": "824010" }, "Export": { "CellBoolValue": false }, "TypeValue": { "CellValue": "CCC Accrual" }, "BatchNoValue": { "CellId": "UpdatePopupDialog", "CellValue": "824010", "CellBoolValue": false, "CellTag": "824010" }, "DateValue": { "CellValue": "01-Jan-2024", "CellValueDate": "2024-01-01T00:00:00" }, "YearPeriodValue": { "CellValue": "2024/07" }, "CreatedByValue": { "CellId": "340", "CellValue": "WebWorkbench Admin" }, "FinancialCompanyValue": { "CellId": "01", "CellValue": "01" }, "ReferenceValue": { "CellValue": "Reversal of 824009" }, "NotesValue": {}, "ReversalValue": { "CellNumValue": 824009 }, "ClosedValue": { "CellBoolValue": true }, "NotForExportValue": { "CellBoolValue": false }, "ExportDateValue": {}, "ExportStatusValue": { "CellId": "StatusPopupDialog", "CellBoolValue": true }, "InterCo": { "CellBoolValue": false }, "InterCoStatusValue": { "CellId": "InterCoStatusPopupDialog", "CellBoolValue": true }, "ReadonlyFlag": 0, "OriginalKey": { "BatchNo": 824010, "BatchType": "CCC Accrual", "FinCoCode": "01", "Exported": false, "HasExportErrored": false }, "CurrentKey": { "BatchNo": 824010, "BatchType": "CCC Accrual", "FinCoCode": "01", "Exported": false, "HasExportErrored": false }, "Key": { "BatchNo": 824010, "BatchType": "CCC Accrual", "FinCoCode": "01", "Exported": false, "HasExportErrored": false }, "Index": 0 }, { "Type": "CCC Accrual", "BatchNo": 824009, "Date": "2023-12-31T00:00:00", "Year": 2024, "Period": 6, "YearPeriodIndex": 24294, "CreatedDate": "2023-11-15T00:00:00", "CreatedById": 340, "CreatedByName": "WebWorkbench Admin", "FinancialCompany": "01", "Location": "0", "Reference": "CCC Accrual-2024/06-", "Notes": " This Batch was reversed using Batch 824010 dated 01/01/2024", "Closed": true, "ReversingJournal": false, "ClosedById": 340, "NotForExport": true, "Exported": false, "ExportStatus": "[Blank]", "Select": { "CellId": "824009", "CellValue": "824009", "CellTag": "824009" }, "Export": { "CellBoolValue": false }, "TypeValue": { "CellValue": "CCC Accrual" }, "BatchNoValue": { "CellId": "UpdatePopupDialog", "CellValue": "824009", "CellBoolValue": false, "CellTag": "824009" }, "DateValue": { "CellValue": "31-Dec-2023", "CellValueDate": "2023-12-31T00:00:00" }, "YearPeriodValue": { "CellValue": "2024/06" }, "CreatedByValue": { "CellId": "340", "CellValue": "WebWorkbench Admin" }, "FinancialCompanyValue": { "CellId": "01", "CellValue": "01" }, "ReferenceValue": { "CellValue": "CCC Accrual-2024/06-" }, "NotesValue": { "CellValue": " This Batch was reversed using Batch 824010 dated 01/01/2024" }, "ReversalValue": {}, "ClosedValue": { "CellBoolValue": true }, "NotForExportValue": { "CellBoolValue": true }, "ExportDateValue": {}, "ExportStatusValue": { "CellId": "StatusPopupDialog", "CellBoolValue": true }, "InterCo": { "CellBoolValue": false }, "InterCoStatusValue": { "CellId": "InterCoStatusPopupDialog", "CellBoolValue": true }, "ReadonlyFlag": 0, "OriginalKey": { "BatchNo": 824009, "BatchType": "CCC Accrual", "FinCoCode": "01", "Exported": false, "HasExportErrored": false }, "CurrentKey": { "BatchNo": 824009, "BatchType": "CCC Accrual", "FinCoCode": "01", "Exported": false, "HasExportErrored": false }, "Key": { "BatchNo": 824009, "BatchType": "CCC Accrual", "FinCoCode": "01", "Exported": false, "HasExportErrored": false }, "Index": 0 }, { "Type": "SCC Accrual", "BatchNo": 824016, "Date": "2023-12-31T00:00:00", "Year": 2024, "Period": 6, "YearPeriodIndex": 24294, "CreatedDate": "2024-01-08T00:00:00", "CreatedById": 340, "CreatedByName": "WebWorkbench Admin", "FinancialCompany": "01", "Location": "0", "Reference": "SCC Accrual-2024/06-", "Closed": true, "ReversingJournal": false, "ClosedById": 340, "NotForExport": false, "Exported": false, "ExportStatus": "[Blank]", "Select": { "CellId": "824016", "CellValue": "824016", "CellTag": "824016" }, "Export": { "CellBoolValue": false }, "TypeValue": { "CellValue": "SCC Accrual" }, "BatchNoValue": { "CellId": "UpdatePopupDialog", "CellValue": "824016", "CellBoolValue": false, "CellTag": "824016" }, "DateValue": { "CellValue": "31-Dec-2023", "CellValueDate": "2023-12-31T00:00:00" }, "YearPeriodValue": { "CellValue": "2024/06" }, "CreatedByValue": { "CellId": "340", "CellValue": "WebWorkbench Admin" }, "FinancialCompanyValue": { "CellId": "01", "CellValue": "01" }, "ReferenceValue": { "CellValue": "SCC Accrual-2024/06-" }, "NotesValue": {}, "ReversalValue": {}, "ClosedValue": { "CellBoolValue": true }, "NotForExportValue": { "CellBoolValue": false }, "ExportDateValue": {}, "ExportStatusValue": { "CellId": "StatusPopupDialog", "CellBoolValue": true }, "InterCo": { "CellBoolValue": false }, "InterCoStatusValue": { "CellId": "InterCoStatusPopupDialog", "CellBoolValue": true }, "ReadonlyFlag": 0, "OriginalKey": { "BatchNo": 824016, "BatchType": "SCC Accrual", "FinCoCode": "01", "Exported": false, "HasExportErrored": false }, "CurrentKey": { "BatchNo": 824016, "BatchType": "SCC Accrual", "FinCoCode": "01", "Exported": false, "HasExportErrored": false }, "Key": { "BatchNo": 824016, "BatchType": "SCC Accrual", "FinCoCode": "01", "Exported": false, "HasExportErrored": false }, "Index": 0 }, { "Type": "Adjustment", "BatchNo": 424009, "Date": "2023-12-06T00:00:00", "Year": 2024, "Period": 6, "YearPeriodIndex": 24294, "CreatedDate": "2023-12-06T13:22:28.573", "FinancialCompany": "01", "Location": "0", "Reference": "Inwards Goods", "Closed": true, "ReversingJournal": false, "NotForExport": false, "Exported": false, "ExportStatus": "[Blank]", "Select": { "CellId": "424009", "CellValue": "424009", "CellTag": "424009" }, "Export": { "CellBoolValue": false }, "TypeValue": { "CellValue": "Adjustment" }, "BatchNoValue": { "CellId": "UpdatePopupDialog", "CellValue": "424009", "CellBoolValue": false, "CellTag": "424009" }, "DateValue": { "CellValue": "06-Dec-2023", "CellValueDate": "2023-12-06T00:00:00" }, "YearPeriodValue": { "CellValue": "2024/06" }, "CreatedByValue": { "CellId": "" }, "FinancialCompanyValue": { "CellId": "01", "CellValue": "01" }, "ReferenceValue": { "CellValue": "Inwards Goods" }, "NotesValue": {}, "ReversalValue": {}, "ClosedValue": { "CellBoolValue": true }, "NotForExportValue": { "CellBoolValue": false }, "ExportDateValue": {}, "ExportStatusValue": { "CellId": "StatusPopupDialog", "CellBoolValue": true }, "InterCo": { "CellBoolValue": false }, "InterCoStatusValue": { "CellId": "InterCoStatusPopupDialog", "CellBoolValue": true }, "ReadonlyFlag": 0, "OriginalKey": { "BatchNo": 424009, "BatchType": "Adjustment", "FinCoCode": "01", "Exported": false, "HasExportErrored": false }, "CurrentKey": { "BatchNo": 424009, "BatchType": "Adjustment", "FinCoCode": "01", "Exported": false, "HasExportErrored": false }, "Key": { "BatchNo": 424009, "BatchType": "Adjustment", "FinCoCode": "01", "Exported": false, "HasExportErrored": false }, "Index": 0 } ] }
Get Batch with JobTransactions for a BatchID
Request
Response
JobTransactionApiModel { Key (JobTransactionsJobTransactionKey, optional), Fields (BatchBatchFields, optional), Rows (Array[JobTransactionsJobTransactionLine], optional), ValidationErrors (Array[MvcValidationError], optional) } JobTransactionsJobTransactionKey { BatchNo (Integer, optional), BatchType (string, optional) } BatchBatchFields { BatchNo (StringViewData, optional), BatchType (StringViewData, optional), BatchDate (DateViewData, optional), Period (StringViewData, optional), CreatedBy (StringViewData, optional), CreatedDate (DateViewData, optional), Location (StringViewData, optional), FinancialCompany (StringViewData, optional), Closed (BoolViewData, optional), ClosedDate (DateViewData, optional), ClosedBy (StringViewData, optional), Exported (BoolViewData, optional), ExportedDate (DateViewData, optional), ExportedBy (StringViewData, optional), NotForExport (BoolViewData, optional), NotForExportDate (DateViewData, optional), NotForExportBy (StringViewData, optional), Reference (StringViewData, optional), BatchNotes (StringViewData, optional), ReversalOfBatch (StringViewData, optional), HiddenBatchNotes (string, optional), BatchStatus (StringViewData, optional), BatchTotal (DecimalViewData, optional), ReversingJournal (BoolViewData, optional), Print (SplitButtonViewData, optional), AttachmentsDialog (FileAttachmentsViewData, optional), Import (ButtonViewData, optional), ImportAdjustment (SplitButtonViewData, optional), PayrollPeriod (OptionsViewData, optional), Currency (PickerViewData, optional), FcConversionRate (DecimalViewData, optional), UseForeignCurrency (boolean, optional) } JobTransactionsJobTransactionLine { TranDate (string, optional), LogHeaderID (Integer, optional), FcCost (number, optional), FcRetail (number, optional), PurchaseOrderLineId (Integer, optional), StockLocationInactive (boolean, optional), Unit (string, optional), EnteredByID (Integer, optional), SourceID (Integer, optional), FCGST (number, optional), JobCodeValue (CellData, optional), LogHeader (CellData, optional), ActivityCodeValue (CellData, optional), WorkCentreCodeValue (CellData, optional), QuantityValue (CellData, optional), FcCostValue (CellData, optional), CostValue (CellData, optional), GSTTypeValue (CellData, optional), GSTTypeCodeValue (CellData, optional), GSTRateValue (CellData, optional), GSTValue (CellData, optional), NetValueValue (CellData, optional), ReferenceValue (CellData, optional), FcRetailValue (CellData, optional), RetailValue (CellData, optional), LineDescriptionValue (CellData, optional), DetailsValue (CellData, optional), FromPONumberValue (CellData, optional), PurchaseOrderLineIdValue (CellData, optional), StockLocationCodeValue (CellData, optional), StockItemCodeValue (CellData, optional), TotalLineCostValue (CellData, optional), CostRateValue (CellData, optional), UnitValue (CellData, optional), FCGSTValue (CellData, optional), Delete (CellData, optional), Serials (CellData, optional), SerialRows (Array[TabletSerialLine], optional), Status (string, optional), ReadonlyFlag (Integer, optional), ReadonlyMessage (string, optional), OriginalKey (JobTransactionsJobTransactionDetailKey, optional), CurrentKey (JobTransactionsJobTransactionDetailKey, optional), Key (JobTransactionsJobTransactionDetailKey, optional), Index (Integer, optional) } MvcValidationError { n (string, optional), m (string, optional) } StringViewData { StringValue (string, optional), Name (string, optional), Visible (boolean, optional), Disabled (boolean, optional), Required (boolean, optional) } DateViewData { DateValue (string, optional), Name (string, optional), Visible (boolean, optional), Disabled (boolean, optional), Required (boolean, optional), InfoText (string, optional) } BoolViewData { BoolValue (boolean, optional), Name (string, optional), Visible (boolean, optional), InfoText (string, optional) } DecimalViewData { DecimalValue (number, optional), Name (string, optional), Visible (boolean, optional), InfoText (string, optional) } SplitButtonViewData {} FileAttachmentsViewData { RelatedRecordID (string, optional), RelatedRecord (string, optional), FileUrl (StringViewData, optional), Name (string, optional), InfoText (string, optional) } ButtonViewData { UseAttrDisable (boolean, optional), NotRelative (boolean, optional), Name (string, optional), Visible (boolean, optional), Disabled (boolean, optional), InfoText (string, optional) } OptionsViewData { SelectedOption (string, optional), Settings (Array[KeyValuePair], optional), Name (string, optional), Visible (boolean, optional), Disabled (boolean, optional), Required (boolean, optional), InfoText (string, optional) } PickerViewData { SelectedValue (string, optional), SelectedText (string, optional), Name (string, optional), Visible (boolean, optional), Disabled (boolean, optional), Required (boolean, optional), InfoText (string, optional) } CellData { CellId (string, optional), CellValue (string, optional), CellNumValue (number, optional), CellBoolValue (boolean, optional), CellTag (string, optional), CellValueDate (string, optional), CellValueInt (Integer, optional) } TabletSerialLine { SerialNo (CellData, optional), SerialNoSelect (CellData, optional), BatchNo (CellData, optional), BatchNoSelect (CellData, optional), ExpiryDate (string, optional), SerialDetails (CellData, optional), Quantity (CellData, optional), TransDetails (CellData, optional), Delete (CellData, optional), Status (string, optional), ReadonlyFlag (Integer, optional), ReadonlyMessage (string, optional), OriginalKey (TabletSerialLineKey, optional), CurrentKey (TabletSerialLineKey, optional), Key (TabletSerialLineKey, optional), Index (Integer, optional) } JobTransactionsJobTransactionDetailKey { JobTranId (Integer, optional), PersonId (Integer, optional), JobCode (string, optional), FinCoCode (string, optional), ActivityCode (string, optional), ActivityCodeValue (string, optional), ActivityType (string, optional), ActivitySubType (string, optional), WorkCentreCode (string, optional), WorkCentreCodeValue (string, optional), ItemId (Integer, optional), StockLocationCodeValue (string, optional), CostRateValue (number, optional), BatchType (string, optional), OrderDerivedLine (boolean, optional), DocketDerivedLine (boolean, optional), StockDerivedLine (boolean, optional), Type (string, optional) = ['InwardsGoodsEntry', 'InwardsGoodsEdit', 'Issue', 'Return', 'Transfer', 'Requisition'], PurchaseOrderLineIdValue (Integer, optional), LogHeaderId (Integer, optional), KeyName (string, optional), CompanyId (Integer, optional), GSTTypeCodeValue (string, optional) } KeyValuePair { Key (string, optional, read only), Value (string, optional, read only) } TabletSerialLineKey { SNID (Integer, optional), SNTranID (Integer, optional) }
Response Sample
{ "Key": { "BatchNo": 124007, "BatchType": "Payroll" }, "Fields": { "Print": { "Default": "/WorkbenchCivil/Reports/Batch_Reports/wbBatchPayroll001", "Labels": { "/WorkbenchCivil/Reports/Batch_Reports/wbBatchPayroll002": "wbBatchPayroll002", "/WorkbenchCivil/Reports/Batch_Reports/wbBatchPayroll003": "wbBatchPayroll003", "/WorkbenchCivil/Reports/Batch_Reports/wbBatchPayroll001": "wbBatchPayroll001" }, "UseAttrDisable": true, "NotRelative": false, "Name": "Print", "Visible": true, "Disabled": true, "Required": false }, "AttachmentsDialog": { "RelatedRecordID": "124007", "RelatedRecord": "BatchHeader", "FileUrl": { "Name": "File URL", "Visible": true, "Disabled": false, "Required": false }, "Visible": true, "Disabled": false, "Required": false }, "Import": { "UseAttrDisable": false, "NotRelative": false, "Name": "Import", "Visible": false, "Disabled": true, "Required": false }, "ImportAdjustment": { "Labels": { "2": "wbImportAdjustments", "71": "wbImportAdjustmentsWithGST", "84": "wbImportAdjustmentsWithLogNos" }, "UseAttrDisable": false, "NotRelative": false, "Name": "Import", "Visible": true, "Disabled": false, "Required": false }, "UseForeignCurrency": true }, "Rows": [] }
Request
Response
Response Sample
⬆️ Back to top
On this page
- No labels