- 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 14 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
JobTransactionKey
Property | Type | Description |
---|---|---|
BatchNo | Integer | The unique number of the Batch. |
BatchType | String | The Batch Type. |
⬆️ Back to top
JobTransactionApiModel
Property | Type | Description |
---|---|---|
Key | The unique key of the Batch. | |
Fields | General data associated with the Batch. | |
Rows | Array<JobTransactionLine> | Job Transactions associated with the Batch. |
ValidationErrors | Array<MvcValidationError> | A list of specific validation errors if the save was unsuccessful. |
⬆️ Back to top
BatchFields
Property | Type | Description |
---|---|---|
BatchNo | 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
JobTransactionDetailKey
Property | Type | Description |
---|---|---|
JobTranId | Integer | The unique ID of the Job Transaction. |
PersonId | Integer | The ID of the User. |
FinCoCode | String | The Financial Company Code on the Batch. |
BatchType | String | The Batch Type of the Batch. |
JobCode | String | The Job Code on the Job Transaction. |
ActivityCodeValue | String | The Activity Code on the Job Transaction. |
WorkCentreCodeValue | String | The Work Centre Code on the Job Transaction. |
ItemId | Integer | The ID of the Item on the Job Transaction. |
StockLocationCodeValue | String | The Reference on the Job Transaction. |
Type | String | The Job Transaction Type ('Issue' or 'Return'). |
GSTTypeCodeValue | String | The GST Type Code on the Job Transaction. |
⬆️ Back to top
JobTransactionLine
Field | Type | Description |
---|---|---|
Key | The unique key for the line. | |
EnteredByID | Integer | The ID of the Person who created the Job Transaction. |
JobCode | String | The Job Code on the Job Transaction. |
JobCodeValue | The Job Code on the Job Transaction. | |
LogHeaderID | Integer | The Log Header on the Job Transaction. |
LogHeader | The Log Header on the Job Transaction. | |
StockItemCode | String | The Stock Item on the Job Transaction |
StockItemCodeValue | The Stock Item on the Job Transaction | |
StockLocationCode | String | The Stock Location on the Job Transaction |
StockLocationCodeValue | The Stock Location on the Job Transaction | |
StockLocationInactive | Boolean | A flag to indicate if the Stock Location is closed and finalised. |
ActivityCode | String | The Activity Code on the Job Transaction. |
ActivityCodeValue | The Activity Code on the Job Transaction. | |
WorkCentreCode | String | The Work Centre Code on the Job Transaction. |
WorkCentreCodeValue | The Work Centre Code on the Job Transaction. | |
Unit | String | The Unit of the Stock Item on the Job Transaction. |
UnitValue | The Unit of the Stock Item on the Job Transaction. | |
CostRate | Decimal | The Cost Rate. |
CostRateValue | The Cost Rate. | |
Quantity | Decimal | The Quantity. |
QuantityValue | The Quantity. | |
FcCost | Decimal | The Foreign Currency Cost. |
FcCostValue | The Foreign Currency Cost. | |
Cost | Decimal | The Cost. |
CostValue | The Cost. | |
FcRetail | Decimal | The Foreign Currency Retail Value. |
FcRetailValue | The Foreign Currency Retail Value. | |
Retail | Decimal | The Retail Value. |
RetailValue | The Retail Value. | |
FCGST | Decimal | The Foreign Currency Tax. |
FCGSTValue | The Foreign Currency Tax. | |
LineDescription | String | The Description on the Job Transaction. |
LineDescriptionValue | The Description on the Job Transaction. | |
Details | String | The Details on the Job Transaction. |
DetailsValue | The Details on the Job Transaction. | |
GSTType | String | The GST Type Code on the Job Transaction. |
GSTTypeDescription | String | The Description of the GST Type on the Job Transaction. |
GSTTypeCodeValue | The GST Type on the Job Transaction. | |
GSTRate | Decimal | The Tax Rate of the GST Type on the Job Transaction. |
GSTRateValue | The Tax Rate of the GST Type on the Job Transaction. | |
TotalLineCost | Decimal | The Cost Rate multiplied by the Quantity. |
TotalLineCostValue | The Cost Rate multiplied by the Quantity. |
⬆️ 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