- Created by Bao TRINH, last modified by Cam Mackay on May 10, 2024
You are viewing an old version of this page. View the current version.
Compare with Current View Page History
« Previous Version 13 Next »
Overview
Provides access to Batch related data. In Workbench, documents are stored in batches before they can be exported to the financial software.
Endpoints
The resources available in this module.
BatchListApi
Provides API access to the Export Control(#/Batch/BatchList.aspx) Web Workbench screen.
/api/BatchListApi | |||||
---|---|---|---|---|---|
Method | Description | Performed As | Request Query | Request Body | Response |
GET | Retrieve (and create, if necessary) the default System Batch for the specified Type, Date, Location, and Financial Company. | Logged in User | - | ||
POST | Retrieve a filtered list of Batches. | Logged in User | - |
BatchDetailApi
Provides API access to the Job Transaction Batch Entry (#/Batch/BatchEntryList.aspx) detail Web Workbench screens ('Job Adjustment Batch Entry', ‘Disbursement Batch Entry', ‘Stock Issue Batch Entry’, 'Stock Return Batch Entry’).
/api/BatchDetailApi | ||||
---|---|---|---|---|
Method | Performed As | Request Query | Request Body | Response |
GET Retrieve a specific Batch (including its Job Transactions). | Admin User | - | ||
POST Update an existing Batch and its Job Transactions. | Admin User | - |
Models
The definitions of models specific to endpoints in this module.
SystemBatchKey
Property | Type | Description |
---|---|---|
BatchType | String | The Batch Type. (required) |
DocDate | DateTime | The Date. (required) |
LocationCode | String | The Code of the Location. (required) |
FinCoCode | String | The Code of the Financial Company. (required) |
BatchGroup | String | The Batch Group. |
SystemBatchModel
Property | Type | Description |
---|---|---|
BatchNo | Integer | The Batch number. |
BatchType | String | Type of the Batch. |
BatchDate | String | The end date of the Period of the Batch.. |
PeriodNo | Integer | The period of the Batch. |
YearNo | Integer | The year of the Batch |
CreatedById | Integer | The ID of the user who created the Batch. |
CreatedDateTime | String | The date and time when the Batch was created. |
LocationCode | String | The Location Code from the Financial Company. |
CompanyCode | String | The Financial Company Code of the Batch. |
BatchReference | String | The Batch reference. |
BatchNotes | String | The Batch comment. |
ReversingJournal | Integer | The Reversing Journal flag on the Batch. |
ClosedFlag | Integer | The Closed flag on the Batch. |
ClosedDate | String | The date the Batch was closed. |
ClosedById | Integer | The ID of the user who closed the Batch. |
NotForExportFlag | Integer | The Not For Export flag on the Batch. |
NotForExportDate | String | The date the Batch was marked as Not For Export. |
NotForExportId | Integer | The ID of the user who marked the Batch as Not For Export. |
ExportDate | String | The date the Batch was exported. |
ExportedById | String | The ID of the user who exported the Batch. |
ExportStatus | String | The status of the Batch (Created, In Progress, Error, Successful). |
⬆️ Back to top
BatchKey
Property | Type | Description |
---|---|---|
BatchNo | Integer | The unique number of the Batch. |
BatchType | String | The Batch Type. |
FinCoCode | String | The Financial Company Code. |
InterCoStatus | String | The Inter-Company status of the Batch. |
Exported | Boolean | A flag indicating if the Batch has been exported. |
HasExportErrored | Boolean | A flag indicating if the Batch has a status of ‘Error’. |
BatchLine
Property | Type | Description |
---|---|---|
Key | The unique key for the line. | |
Type | String | The Type of the Batch. |
TypeValue | The Type of the Batch. | |
BatchNo | Integer | The unique number of the Batch. |
BatchNoValue | The unique number of the Batch. | |
Date | String | The date of the Batch. |
DateValue | The date of the Batch. | |
Year | String | The year of the Year/Period of the Batch. |
Period | Integer | The period of the Year/Period of the Batch. |
YearPeriodIndex | Integer | The unique index of the Year/Period of the Batch. |
YearPeriodValue | The formatted Year/Period of the Batch. | |
CreatedDate | String | The date the Batch was created. |
CreatedById | Integer | The ID of the user who created the Batch. |
CreatedByName | String | The name of the user who created the Batch. |
CreatedByValue | The name of the user who created the Batch. | |
Location | String | The Location Code of the Batch. |
FinancialCompany | String | The Financial Company Code of the Batch. |
FinancialCompanyValue | The Financial Company Code of the Batch. | |
Reference | String | The Batch reference. |
ReferenceValue | The Batch reference. | |
Notes | String | The Batch comment. |
NotesValue | The Batch comment. | |
Reversal | Integer | The Batch No of the Batch this Batch reverses. |
ReversalValue | The Batch No of the Batch this Batch reverses. | |
Closed | Boolean | The Closed flag on the Batch. |
ClosedValue | The Closed flag on the Batch. | |
ClosedById | Integer | The ID of the user who closed the Batch. |
NotForExport | Boolean | The Not For Export flag on the Batch. |
NotForExportValue | The Not For Export flag on the Batch. | |
Exported | Boolean | A flag indicating if the Batch has been exported. |
ExportedById | Integer | The ID of the user who exported the Batch. |
ExportDate | String | The date the Batch was exported. |
ExportDateValue | The date the Batch was exported. | |
ExportStatus | String | The status of the Batch (Created, In Progress, Error, Successful). |
ExportStatusValue | The status of the Batch (Created, In Progress, Error, Successful). | |
InterCoStatus | String | The Inter-Company status of the Batch. |
InterCoStatusValue | The Inter-Company status of the Batch. |
⬆️ Back to top
BatchBatchFields
Property | 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
Property | Type | Description |
---|---|---|
BatchNo | Integer | Batch number/code |
BatchType | String | Batch type. |
FinCoCode | String | Code of the finance company |
Exported | Boolean | Exported status. |
InterCoStatus | String |
|
HasExportErrored | Boolean | The exporting error status. |
⬆️ Back to top
BatchBatchLine
Property | Type | Description |
---|---|---|
Type | String | Line type |
BatchNo | Integer | Batch number |
Date | String | Date |
Year | String | Year |
Period | Integer | The financial period |
YearPeriodIndex | Integer |
|
CreatedDate | String | Date created. |
CreatedById | Integer | ID of person who created the batch. |
CreatedByName | String | Name of person who created the batch. |
FinancialCompany | String | Financial company. |
Location | String | Location. |
Reference | String | Reference text |
Notes | String | Batch note |
Reversal | Integer |
|
Closed | Boolean | Status of the batch. |
ReversingJournal | Boolean |
|
ClosedById | Integer | Code of person who closed the batch. |
NotForExport | Boolean | Value of Not For Export flag. |
Exported | Boolean | Exported status. |
ExportedById | Integer | ID of person exported the batch. |
ExportDate | String | Exported date. |
ClosedDate | String | Closed date. |
ExportStatus | String | Export status. |
InterCoStatus | String | Status of inter-company. |
Select |
| |
Export |
| |
TypeValue | Batch type. | |
BatchNoValue | Batch number. | |
DateValue | Batch date. | |
YearPeriodValue | Financial year period of the batch. | |
CreatedByValue | Person who created the batch. | |
FinancialCompanyValue | Financial company. | |
ReferenceValue | Reference text | |
NotesValue | Batch note. | |
ReversalValue |
| |
ClosedValue | Closed status. | |
NotForExportValue | Value of Not for Export flag. | |
ClosedDateValue | Closed date. | |
ExportDateValue | Exported date. | |
ExportStatusValue | Export status. | |
InterCo | Internal company. | |
InterCoStatusValue | Internal company. | |
BatchStatus | String | Batch status. |
Status | String | Batch status. |
ReadonlyFlag | Integer | Value of Read-Only property. |
ReadonlyMessage | String |
|
OriginalKey |
| |
CurrentKey |
| |
Key |
| |
Index | Integer |
|
⬆️ Back to top
JobTransactionApiModel
Property | Type | Description |
---|---|---|
Key |
| |
Fields |
| |
Rows |
| |
ValidationErrors | Array [MvcValidationError] |
|
⬆️ Back to top
JobTransactionsJobTransactionKey
Property | Type | Description |
---|---|---|
BatchNo | Integer | Number of the batch. |
BatchType | String | Batch type. |
⬆️ Back to top
JobTransactionsJobTransactionDetailKey
Property | 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 |
---|---|---|
Property | 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