- Created by Bao TRINH, last modified on Apr 05, 2024
You are viewing an old version of this page. View the current version.
Compare with Current View Page History
« Previous Version 8 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
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. |
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. |
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. |
Parameters
Parameter | Data Type | Description | Parameter Type |
---|---|---|---|
batchType | String | Type of the batch | query |
docDate | date-time | Batch date? | query |
locationCode | String | Location comes from the FinCo | query |
finCoCode | String | Code of the finance company of the batch. | query |
batchGroup | String | Batch group. | query |
GridResult_BatchBatchLine
Field | Type | Description |
---|---|---|
Total | Integer | Total number of batches |
Page | Integer | Number of screen page or current page? |
Records | Integer | Total of record? |
Rows | Array | Array [BatchBatchLine] |
Form | Object |
|
Widgets |
|
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 |
| |
Button | ||
AttachmentsDialog |
| |
Import | Button | |
ImportAdjustment |
| |
PayrollPeriod |
| |
Currency | The currency | |
FcConversionRate | Foreign currency conversation rate. | |
UseForeignCurrency | Boolean | Does the batch use foreign currency? |
BatchBatchKey
Field | Type | Description |
---|---|---|
BatchNo | Integer | Batch number/code |
BatchType | String | Batch type. |
FinCoCode | String | Number code of the finance company |
Exported | Boolean | Is the batch exported? |
InterCoStatus | String |
|
HasExportErrored | Boolean | The exporting error. |
BatchBatchLine
Field | Type | Description |
---|---|---|
Type | String |
|
BatchNo | Integer | Code/number of the batch |
Date | String |
|
Year | String |
|
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 |
|
JobTransactionApiModel
Field | Type | Description |
---|---|---|
Key |
| |
Fields |
| |
Rows |
| |
ValidationErrors | Array [MvcValidationError] |
|
Parameters
Parameter | Data Type | Description | Parameter Type |
---|---|---|---|
batchNo | Integer | Number of the batch |
|
batchType | String | Batch type. |
|
JobTransactionsJobTransactionKey
Field | Type | Description |
---|---|---|
BatchNo | Integer | Number of the batch. |
BatchType | String | Batch type. |
JobTransactionsJobTransactionDetailKey
Field | Type | Description |
---|---|---|
JobTranId | Integer |
|
PersonId | Integer |
|
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 |
|
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 |
|
LogHeaderId | Integer |
|
KeyName | String |
|
CompanyId | Integer |
|
GSTTypeCodeValue | String |
|
JobTransactionsJobTransactionLine
Field | Type | Description |
---|---|---|
TranDate | String |
|
LogHeaderID | Integer |
|
FcCost | Number | Foreign currency code |
FcRetail | Number |
|
PurchaseOrderLineId | Integer |
|
StockLocationInactive | Boolean |
|
Unit | String |
|
EnteredByID | Integer | ID of person who entered data. |
SourceID | Integer |
|
FCGST | Number |
|
JobCodeValue | Job code. | |
LogHeader |
| |
ActivityCodeValue | Activity code. | |
WorkCentreCodeValue | Work Centre code. | |
QuantityValue | Quantity | |
FcCostValue |
| |
CostValue |
| |
GSTTypeValue | GST type. | |
GSTTypeCodeValue |
| |
GSTRateValue | GST rate | |
GSTValue | GST value | |
NetValueValue | Net value | |
ReferenceValue |
| |
FcRetailValue |
| |
RetailValue |
| |
LineDescriptionValue | Description of line | |
DetailsValue | Details | |
FromPONumberValue |
| |
PurchaseOrderLineIdValue |
| |
StockLocationCodeValue |
| |
StockItemCodeValue |
| |
TotalLineCostValue |
| |
CostRateValue |
| |
UnitValue |
| |
FCGSTValue |
| |
Delete |
| |
Serials |
| |
SerialRows | Array [TabletSerialLine] |
|
Status | String |
|
ReadonlyFlag | Integer |
|
ReadonlyMessage | String |
|
OriginalKey |
| |
CurrentKey |
| |
Key |
| |
Index | Integer |
|
MvcValidationError
Field | Type | Description |
---|---|---|
TranDate | String |
|
LogHeaderID | Integer |
|
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