- Created by Bao TRINH, last modified on Apr 05, 2024
You are viewing an old version of this page. View the current version.
Compare with Current View Page History
« Previous Version 3 Next »
Overview
Return list of companies in Workbench.
Endpoints
The resources available in this module.
CompanyListApi
Return companies list in Workbench.
/api/CompanyListApi | |||||
---|---|---|---|---|---|
Method | Description | Performed As | Request Query | Request Body | Response |
GET | Return first 20 companies. | - | |||
POST | Get list of all companies |
CompanyDetailApi
Return company details, people, addresses and attributes.
/api/CompanyDetailApi | |||||
---|---|---|---|---|---|
Method | Description | Performed As | Request Query | Request Body | Response |
GET | Return company details, people, addresses and attributes. | - |
Models
The definitions of models specific to endpoints in this module.
CompanyApiModel
Field | Type | Description |
---|---|---|
Key | GeneralCompanyKey | |
Main | GeneralCompanyMainFields | |
Financials | GeneralCompanyFinancialsFields | |
People | CompanyApiGridLines_GeneralPersonLine | |
Attributes | CompanyApiGridLines_GeneralAttributeLine | |
Addresses | CompanyApiGridLines_GeneralAddressLine | |
Notes | CompanyApiGridLines_GeneralNoteLine |
GeneralCompanyLine
Field | Type | Description |
---|---|---|
CompanyId | Integer | Unique ID code of the company. |
CompanyName | String | Company name. |
AlphaCode | String | The shorthand code for the company |
ApAccount | String | The AP linking code to the financial system |
ArAccount | String | The AR linking code to the financial system |
CreditStatus | String | The company's credit status is with your organization. |
Location | String | The location has been assigned to this company. |
FinancialCompanyCode | String | The internal Financial Company this company sits under. |
CompanyType | String | The company type of this company. |
Phone | String | Phone number. |
Client | Boolean | This company as a client or not. |
Supplier | Boolean | This company as a supplier or not. |
Subcontractor | Boolean | This company as a Subcontractor or not. |
Other | Boolean | The company is marked as Other type or not. |
Inactive | Boolean | The company is inactive or not. |
GSTNumber | String | The tax identifier for the company. |
Select | ||
CompanyNameValue | Company name. | |
AlphaCodeValue | The shorthand code for the company. | |
ApAccountValue | The AP linking code to the financial system. | |
ArAccountValue | The AR linking code to the financial system. | |
CreditStatusValue | The company's credit status is with your organization. | |
LocationValue | The location has been assigned to this company. | |
FinancialCompanyCodeValue | The internal Financial Company this company sits under. | |
CompanyTypeValue | The company type of this company. | |
PhoneValue | Phone number. | |
CostValue | Price cost? | |
CatalogueValue | ||
Group 1 | String | The group of the company. |
Group 2 | String | The group of the company. |
Group 3 | String | The group of the company. |
UpdatedDate | String | Updated date. |
Status | String | |
ReadonlyFlag | Integer | |
ReadonlyMessage | String | |
OriginalKey | ||
CurrentKey | ||
Key | ||
Index | Integer |
GeneralCompanyKey
Field | Type | Description |
---|---|---|
CompanyID | Integer | Code of the company |
GeneralCompanyMainFields
Field | Type | Description |
---|---|---|
CompanyID | Code of the company | |
CompanyName | Company name | |
AlphaCode | The shorthand code for the company. | |
CompanyType | The type of the company. | |
PriceCode | Price code of the company. | |
Location | Location has been assigned to company. | |
Branch | ||
FinancialCompany | The internal Financial Company this company sits under. | |
ArAccount | The AR linking code to the financial system | |
ApAccount | The AP linking code to the financial system | |
Currency | The default currency of the company. | |
CompanyReference | ||
InactiveCompany | ||
Client | Marked as Client or not. | |
Supplier | Marked as Supplier or not. | |
Subcontractor | Marked as Subcontractor or not. | |
Other | Marked as Other or not. | |
GSTNumber | The tax identifier for the company. | |
DefaultJobManager | Person as default Job manager. | |
DefaultAccountManager | Person as default Account manager. |
GeneralCompanyFinancialsFields
Field | Type | Description |
---|---|---|
PaymentTerms | The numerical value for days | |
PaymentTermsType | To nominate the payment terms for Job Sales Invoices to this company | |
CreditStatus | The company's credit status is with your organization | |
CashLimit | To nominate a cash limit. | |
BankAccountRef1 | Account details. | |
BankAccountRef2 | Account details. | |
BankAccountRef3 | Account details. | |
UseGST | Include tax on any sales to this company or not | |
CashOnly | This company as a cash-only or not | |
UseBuyerCreatedInvoices | Use the BCI/RCTI with this company or not. |
Examples
Get list of first 20 companies
Request
Response
GridResult_GeneralCompanyLine { total (integer, optional), page (integer, optional), records (integer, optional), rows (Array[GeneralCompanyLine], optional), form (object, optional), widgets (Array[ViewData_GridWidget], optional) } GeneralCompanyLine { CompanyId (integer, optional), CompanyName (string, optional), AlphaCode (string, optional), ApAccount (string, optional), ArAccount (string, optional), CreditStatus (string, optional), Location (string, optional), FinancialCompanyCode (string, optional), CompanyType (string, optional), Phone (string, optional), Client (boolean, optional), Supplier (boolean, optional), Subcontractor (boolean, optional), Other (boolean, optional), Inactive (boolean, optional), GSTNumber (string, optional), Select (CellData, optional), CompanyNameValue (CellData, optional), AlphaCodeValue (CellData, optional), ApAccountValue (CellData, optional), ArAccountValue (CellData, optional), CreditStatusValue (CellData, optional), LocationValue (CellData, optional), FinancialCompanyCodeValue (CellData, optional), CompanyTypeValue (CellData, optional), PhoneValue (CellData, optional), CostValue (CellData, optional), CatalogueValue (CellData, optional), Group1 (string, optional), Group2 (string, optional), Group3 (string, optional), UpdatedDate (string, optional), Status (string, optional), ReadonlyFlag (integer, optional), ReadonlyMessage (string, optional), OriginalKey (GeneralCompanyKey, optional), CurrentKey (GeneralCompanyKey, optional), Key (GeneralCompanyKey, 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) } GeneralCompanyKey { CompanyId (integer) } ViewData_GridWidgetLine { WidgetLineId (integer, optional), WidgetId (integer, optional), Name (string, optional), Predicate (string, optional), Order (integer, optional), Count (integer, optional) }
Response sample
{ "total": 15, "page": 1, "records": 285, "rows": [ { "CompanyId": 596, "CompanyName": " Adatum Sandbox", "AlphaCode": "ADATUMCORP", "ApAccount": "10001", "ArAccount": "10000", "CreditStatus": "Credit", "Location": "0", "FinancialCompanyCode": "03", "CompanyType": "GEN", "Phone": "22222221111", "Client": true, "Supplier": true, "Subcontractor": false, "Other": true, "Inactive": false, "GSTNumber": "31608459409", "Select": { "CellId": "596", "CellValue": " Adatum Sandbox", "CellTag": " Adatum Sandbox" }, "CompanyNameValue": { "CellId": "PopupDialog", "CellValue": " Adatum Sandbox", "CellTag": "openDialog(\"596\")" }, "AlphaCodeValue": { "CellValue": "ADATUMCORP" }, "ApAccountValue": { "CellValue": "10001" }, "ArAccountValue": { "CellValue": "10000" }, "CreditStatusValue": { "CellValue": "Credit" }, "LocationValue": { "CellId": "0", "CellValue": "0 : Head Office - Civil company" }, "FinancialCompanyCodeValue": { "CellId": "03", "CellValue": "03 : ASIA / PACIFIC LABOUR (Business Cent)" }, "CompanyTypeValue": { "CellId": "GEN", "CellValue": "GEN : General" }, "PhoneValue": { "CellValue": "22222221111" }, "CostValue": { "CellNumValue": 0 }, "CatalogueValue": {}, "UpdatedDate": "2023-09-22T03:00:51.4565009+00:00", "OriginalKey": { "CompanyId": 596 }, "CurrentKey": { "CompanyId": 596 }, "Key": { "CompanyId": 596 }, "Index": 0 }, { "CompanyId": 738, "CompanyName": "132 Collins", "AlphaCode": "132COLLINS", "ApAccount": "123COLL", "CreditStatus": "Credit", "Location": "0", "FinancialCompanyCode": "04", "CompanyType": "GEN", "Phone": " 03 3699876", "Client": false, "Supplier": true, "Subcontractor": false, "Other": true, "Inactive": false, "Select": { "CellId": "738", "CellValue": "132 Collins", "CellTag": "132 Collins" }, "CompanyNameValue": { "CellId": "PopupDialog", "CellValue": "132 Collins", "CellTag": "openDialog(\"738\")" }, "AlphaCodeValue": { "CellValue": "132COLLINS" }, "ApAccountValue": { "CellValue": "123COLL" }, "ArAccountValue": {}, "CreditStatusValue": { "CellValue": "Credit" }, "LocationValue": { "CellId": "0", "CellValue": "0 : Head Office - Civil company" }, "FinancialCompanyCodeValue": { "CellId": "04", "CellValue": "04 : ASIA / PACIFIC RECYCLING (Xero)" }, "CompanyTypeValue": { "CellId": "GEN", "CellValue": "GEN : General" }, "PhoneValue": { "CellValue": " 03 3699876" }, "CostValue": { "CellNumValue": 0 }, "CatalogueValue": {}, "UpdatedDate": "2024-02-26T23:23:24.3840362+00:00", "OriginalKey": { "CompanyId": 738 }, "CurrentKey": { "CompanyId": 738 }, "Key": { "CompanyId": 738 }, "Index": 0 }, { "CompanyId": 749, "CompanyName": "3M International 3", "AlphaCode": "3M INTERNA", "ArAccount": "3M", "CreditStatus": "Credit", "Location": "0", "FinancialCompanyCode": "01", "CompanyType": "GEN", "Client": true, "Supplier": false, "Subcontractor": false, "Other": true, "Inactive": false, "Select": { "CellId": "749", "CellValue": "3M International 3", "CellTag": "3M International 3" }, "CompanyNameValue": { "CellId": "PopupDialog", "CellValue": "3M International 3", "CellTag": "openDialog(\"749\")" }, "AlphaCodeValue": { "CellValue": "3M INTERNA" }, "ApAccountValue": {}, "ArAccountValue": { "CellValue": "3M" }, "CreditStatusValue": { "CellValue": "Credit" }, "LocationValue": { "CellId": "0", "CellValue": "0 : Head Office - Civil company" }, "FinancialCompanyCodeValue": { "CellId": "01", "CellValue": "01 : ASIA / PACIFIC CIVIL (AccountRight)" }, "CompanyTypeValue": { "CellId": "GEN", "CellValue": "GEN : General" }, "PhoneValue": {}, "CostValue": { "CellNumValue": 0 }, "CatalogueValue": {}, "UpdatedDate": "2024-02-29T02:47:23.487+00:00", "OriginalKey": { "CompanyId": 749 }, "CurrentKey": { "CompanyId": 749 }, "Key": { "CompanyId": 749 }, "Index": 0 }, { "CompanyId": 617, "CompanyName": "3M International 3", "AlphaCode": "3M INTERNA", "ApAccount": "4M", "ArAccount": "3M", "CreditStatus": "Credit", "Location": "0", "FinancialCompanyCode": "02", "CompanyType": "GEN", "Client": true, "Supplier": false, "Subcontractor": true, "Other": true, "Inactive": false, "Select": { "CellId": "617", "CellValue": "3M International 3", "CellTag": "3M International 3" }, "CompanyNameValue": { "CellId": "PopupDialog", "CellValue": "3M International 3", "CellTag": "openDialog(\"617\")" }, "AlphaCodeValue": { "CellValue": "3M INTERNA" }, "ApAccountValue": { "CellValue": "4M" }, "ArAccountValue": { "CellValue": "3M" }, "CreditStatusValue": { "CellValue": "Credit" }, "LocationValue": { "CellId": "0", "CellValue": "0 : Head Office - Civil company" }, "FinancialCompanyCodeValue": { "CellId": "02", "CellValue": "02 : ASIA / PACIFIC EQUIPMENT (MYOB-ADV)" }, "CompanyTypeValue": { "CellId": "GEN", "CellValue": "GEN : General" }, "PhoneValue": {}, "CostValue": { "CellNumValue": 0 }, "CatalogueValue": {}, "UpdatedDate": "2023-08-10T02:28:35.8535551+00:00", "OriginalKey": { "CompanyId": 617 }, "CurrentKey": { "CompanyId": 617 }, "Key": { "CompanyId": 617 }, "Index": 0 }, { "CompanyId": 613, "CompanyName": "7-Eleven", "AlphaCode": "7_ELEVEN", "ApAccount": "6621", "ArAccount": "X001", "CreditStatus": "Credit", "Location": "0", "FinancialCompanyCode": "04", "CompanyType": "GEN", "Phone": " ", "Client": true, "Supplier": false, "Subcontractor": false, "Other": true, "Inactive": false, "Select": { "CellId": "613", "CellValue": "7-Eleven", "CellTag": "7-Eleven" }, "CompanyNameValue": { "CellId": "PopupDialog", "CellValue": "7-Eleven", "CellTag": "openDialog(\"613\")" }, "AlphaCodeValue": { "CellValue": "7_ELEVEN" }, "ApAccountValue": { "CellValue": "6621" }, "ArAccountValue": { "CellValue": "X001" }, "CreditStatusValue": { "CellValue": "Credit" }, "LocationValue": { "CellId": "0", "CellValue": "0 : Head Office - Civil company" }, "FinancialCompanyCodeValue": { "CellId": "04", "CellValue": "04 : ASIA / PACIFIC RECYCLING (Xero)" }, "CompanyTypeValue": { "CellId": "GEN", "CellValue": "GEN : General" }, "PhoneValue": { "CellValue": " " }, "CostValue": { "CellNumValue": 0 }, "CatalogueValue": {}, "UpdatedDate": "2023-03-12T00:02:07.2149894+00:00", "OriginalKey": { "CompanyId": 613 }, "CurrentKey": { "CompanyId": 613 }, "Key": { "CompanyId": 613 }, "Index": 0 }, { "CompanyId": 712, "CompanyName": "7-Eleven", "AlphaCode": "7_ELEVEN", "ArAccount": "7Elev1", "CreditStatus": "Credit", "Location": "0", "FinancialCompanyCode": "01", "CompanyType": "GEN", "Phone": " ", "Client": true, "Supplier": false, "Subcontractor": false, "Other": true, "Inactive": false, "Select": { "CellId": "712", "CellValue": "7-Eleven", "CellTag": "7-Eleven" }, "CompanyNameValue": { "CellId": "PopupDialog", "CellValue": "7-Eleven", "CellTag": "openDialog(\"712\")" }, "AlphaCodeValue": { "CellValue": "7_ELEVEN" }, "ApAccountValue": {}, "ArAccountValue": { "CellValue": "7Elev1" }, "CreditStatusValue": { "CellValue": "Credit" }, "LocationValue": { "CellId": "0", "CellValue": "0 : Head Office - Civil company" }, "FinancialCompanyCodeValue": { "CellId": "01", "CellValue": "01 : ASIA / PACIFIC CIVIL (AccountRight)" }, "CompanyTypeValue": { "CellId": "GEN", "CellValue": "GEN : General" }, "PhoneValue": { "CellValue": " " }, "CostValue": { "CellNumValue": 0 }, "CatalogueValue": {}, "UpdatedDate": "2023-07-20T04:34:49.7561455+00:00", "OriginalKey": { "CompanyId": 712 }, "CurrentKey": { "CompanyId": 712 }, "Key": { "CompanyId": 712 }, "Index": 0 }, { "CompanyId": 645, "CompanyName": "A & B CONSTRUCTIONS LTD", "AlphaCode": "A&BCONSTRU", "ApAccount": "20044", "CreditStatus": "Credit", "Location": "0", "FinancialCompanyCode": "01", "CompanyType": "GEN", "Phone": "6582999231", "Client": false, "Supplier": true, "Subcontractor": false, "Other": true, "Inactive": false, "GSTNumber": "11 223 344 555", "Select": { "CellId": "645", "CellValue": "A & B CONSTRUCTIONS LTD", "CellTag": "A & B CONSTRUCTIONS LTD" }, "CompanyNameValue": { "CellId": "PopupDialog", "CellValue": "A & B CONSTRUCTIONS LTD", "CellTag": "openDialog(\"645\")" }, "AlphaCodeValue": { "CellValue": "A&BCONSTRU" }, "ApAccountValue": { "CellValue": "20044" }, "ArAccountValue": {}, "CreditStatusValue": { "CellValue": "Credit" }, "LocationValue": { "CellId": "0", "CellValue": "0 : Head Office - Civil company" }, "FinancialCompanyCodeValue": { "CellId": "01", "CellValue": "01 : ASIA / PACIFIC CIVIL (AccountRight)" }, "CompanyTypeValue": { "CellId": "GEN", "CellValue": "GEN : General" }, "PhoneValue": { "CellValue": "6582999231" }, "CostValue": { "CellNumValue": 0 }, "CatalogueValue": {}, "UpdatedDate": "2023-03-31T11:22:12.003+00:00", "OriginalKey": { "CompanyId": 645 }, "CurrentKey": { "CompanyId": 645 }, "Key": { "CompanyId": 645 }, "Index": 0 }, { "CompanyId": 498, "CompanyName": "A & B CONSTRUCTIONS PTY LTD", "AlphaCode": "A & B CONS", "ApAccount": "266", "CreditStatus": "Credit", "Location": "0", "FinancialCompanyCode": "01", "CompanyType": "GEN", "Phone": "7762800461", "Client": false, "Supplier": true, "Subcontractor": false, "Other": true, "Inactive": false, "Select": { "CellId": "498", "CellValue": "A & B CONSTRUCTIONS PTY LTD", "CellTag": "A & B CONSTRUCTIONS PTY LTD" }, "CompanyNameValue": { "CellId": "PopupDialog", "CellValue": "A & B CONSTRUCTIONS PTY LTD", "CellTag": "openDialog(\"498\")" }, "AlphaCodeValue": { "CellValue": "A & B CONS" }, "ApAccountValue": { "CellValue": "266" }, "ArAccountValue": {}, "CreditStatusValue": { "CellValue": "Credit" }, "LocationValue": { "CellId": "0", "CellValue": "0 : Head Office - Civil company" }, "FinancialCompanyCodeValue": { "CellId": "01", "CellValue": "01 : ASIA / PACIFIC CIVIL (AccountRight)" }, "CompanyTypeValue": { "CellId": "GEN", "CellValue": "GEN : General" }, "PhoneValue": { "CellValue": "7762800461" }, "CostValue": { "CellNumValue": 0 }, "CatalogueValue": {}, "UpdatedDate": "2022-04-25T21:14:14.9809085+00:00", "OriginalKey": { "CompanyId": 498 }, "CurrentKey": { "CompanyId": 498 }, "Key": { "CompanyId": 498 }, "Index": 0 }, { "CompanyId": 521, "CompanyName": "ABC & 123 PLUMBER LTD", "AlphaCode": "ABC & 123 ", "ApAccount": "289", "CreditStatus": "Credit", "Location": "0", "FinancialCompanyCode": "01", "CompanyType": "GEN", "Phone": "3702820496", "Client": false, "Supplier": true, "Subcontractor": true, "Other": true, "Inactive": false, "Select": { "CellId": "521", "CellValue": "ABC & 123 PLUMBER LTD", "CellTag": "ABC & 123 PLUMBER LTD" }, "CompanyNameValue": { "CellId": "PopupDialog", "CellValue": "ABC & 123 PLUMBER LTD", "CellTag": "openDialog(\"521\")" }, "AlphaCodeValue": { "CellValue": "ABC & 123 " }, "ApAccountValue": { "CellValue": "289" }, "ArAccountValue": {}, "CreditStatusValue": { "CellValue": "Credit" }, "LocationValue": { "CellId": "0", "CellValue": "0 : Head Office - Civil company" }, "FinancialCompanyCodeValue": { "CellId": "01", "CellValue": "01 : ASIA / PACIFIC CIVIL (AccountRight)" }, "CompanyTypeValue": { "CellId": "GEN", "CellValue": "GEN : General" }, "PhoneValue": { "CellValue": "3702820496" }, "CostValue": { "CellNumValue": 0 }, "CatalogueValue": {}, "UpdatedDate": "2023-01-31T01:16:17.8709216+00:00", "OriginalKey": { "CompanyId": 521 }, "CurrentKey": { "CompanyId": 521 }, "Key": { "CompanyId": 521 }, "Index": 0 }, { "CompanyId": 612, "CompanyName": "ABC Furniture", "AlphaCode": "ABCFURNITU", "ApAccount": "X002", "ArAccount": "X002", "CreditStatus": "Credit", "Location": "0", "FinancialCompanyCode": "04", "CompanyType": "GEN", "Phone": " 0800 124578", "Client": true, "Supplier": true, "Subcontractor": true, "Other": true, "Inactive": false, "Select": { "CellId": "612", "CellValue": "ABC Furniture", "CellTag": "ABC Furniture" }, "CompanyNameValue": { "CellId": "PopupDialog", "CellValue": "ABC Furniture", "CellTag": "openDialog(\"612\")" }, "AlphaCodeValue": { "CellValue": "ABCFURNITU" }, "ApAccountValue": { "CellValue": "X002" }, "ArAccountValue": { "CellValue": "X002" }, "CreditStatusValue": { "CellValue": "Credit" }, "LocationValue": { "CellId": "0", "CellValue": "0 : Head Office - Civil company" }, "FinancialCompanyCodeValue": { "CellId": "04", "CellValue": "04 : ASIA / PACIFIC RECYCLING (Xero)" }, "CompanyTypeValue": { "CellId": "GEN", "CellValue": "GEN : General" }, "PhoneValue": { "CellValue": " 0800 124578" }, "CostValue": { "CellNumValue": 0 }, "CatalogueValue": {}, "UpdatedDate": "2023-09-13T01:48:43.9832641+00:00", "OriginalKey": { "CompanyId": 612 }, "CurrentKey": { "CompanyId": 612 }, "Key": { "CompanyId": 612 }, "Index": 0 }, { "CompanyId": 649, "CompanyName": "ABC Furniture", "AlphaCode": "ABCFURNITU", "ArAccount": "ABCFu1", "CreditStatus": "Credit", "Location": "0", "FinancialCompanyCode": "04", "CompanyType": "GEN", "Phone": " 0800 124578", "Client": true, "Supplier": false, "Subcontractor": false, "Other": true, "Inactive": false, "Select": { "CellId": "649", "CellValue": "ABC Furniture", "CellTag": "ABC Furniture" }, "CompanyNameValue": { "CellId": "PopupDialog", "CellValue": "ABC Furniture", "CellTag": "openDialog(\"649\")" }, "AlphaCodeValue": { "CellValue": "ABCFURNITU" }, "ApAccountValue": {}, "ArAccountValue": { "CellValue": "ABCFu1" }, "CreditStatusValue": { "CellValue": "Credit" }, "LocationValue": { "CellId": "0", "CellValue": "0 : Head Office - Civil company" }, "FinancialCompanyCodeValue": { "CellId": "04", "CellValue": "04 : ASIA / PACIFIC RECYCLING (Xero)" }, "CompanyTypeValue": { "CellId": "GEN", "CellValue": "GEN : General" }, "PhoneValue": { "CellValue": " 0800 124578" }, "CostValue": { "CellNumValue": 0 }, "CatalogueValue": {}, "UpdatedDate": "2023-04-05T04:33:01.11+00:00", "OriginalKey": { "CompanyId": 649 }, "CurrentKey": { "CompanyId": 649 }, "Key": { "CompanyId": 649 }, "Index": 0 }, { "CompanyId": 690, "CompanyName": "ABC Furniture", "AlphaCode": "ABCFURNITU", "ArAccount": "ABCFu1", "CreditStatus": "Credit", "Location": "0", "FinancialCompanyCode": "01", "CompanyType": "GEN", "Phone": " 0800 124578", "Client": true, "Supplier": false, "Subcontractor": false, "Other": true, "Inactive": false, "Select": { "CellId": "690", "CellValue": "ABC Furniture", "CellTag": "ABC Furniture" }, "CompanyNameValue": { "CellId": "PopupDialog", "CellValue": "ABC Furniture", "CellTag": "openDialog(\"690\")" }, "AlphaCodeValue": { "CellValue": "ABCFURNITU" }, "ApAccountValue": {}, "ArAccountValue": { "CellValue": "ABCFu1" }, "CreditStatusValue": { "CellValue": "Credit" }, "LocationValue": { "CellId": "0", "CellValue": "0 : Head Office - Civil company" }, "FinancialCompanyCodeValue": { "CellId": "01", "CellValue": "01 : ASIA / PACIFIC CIVIL (AccountRight)" }, "CompanyTypeValue": { "CellId": "GEN", "CellValue": "GEN : General" }, "PhoneValue": { "CellValue": " 0800 124578" }, "CostValue": { "CellNumValue": 0 }, "CatalogueValue": {}, "UpdatedDate": "2023-04-05T05:09:18.59+00:00", "OriginalKey": { "CompanyId": 690 }, "CurrentKey": { "CompanyId": 690 }, "Key": { "CompanyId": 690 }, "Index": 0 }, { "CompanyId": 616, "CompanyName": "ABC RESOURCE CO SM Test Mar 2022", "AlphaCode": "ABC RESOUR", "ArAccount": "ABCRESOURC", "CreditStatus": "Credit", "Location": "0", "FinancialCompanyCode": "02", "CompanyType": "GEN", "Phone": "61396546989", "Client": true, "Supplier": false, "Subcontractor": false, "Other": true, "Inactive": false, "Select": { "CellId": "616", "CellValue": "ABC RESOURCE CO SM Test Mar 2022", "CellTag": "ABC RESOURCE CO SM Test Mar 2022" }, "CompanyNameValue": { "CellId": "PopupDialog", "CellValue": "ABC RESOURCE CO SM Test Mar 2022", "CellTag": "openDialog(\"616\")" }, "AlphaCodeValue": { "CellValue": "ABC RESOUR" }, "ApAccountValue": {}, "ArAccountValue": { "CellValue": "ABCRESOURC" }, "CreditStatusValue": { "CellValue": "Credit" }, "LocationValue": { "CellId": "0", "CellValue": "0 : Head Office - Civil company" }, "FinancialCompanyCodeValue": { "CellId": "02", "CellValue": "02 : ASIA / PACIFIC EQUIPMENT (MYOB-ADV)" }, "CompanyTypeValue": { "CellId": "GEN", "CellValue": "GEN : General" }, "PhoneValue": { "CellValue": "61396546989" }, "CostValue": { "CellNumValue": 0 }, "CatalogueValue": {}, "UpdatedDate": "2022-05-11T04:29:51.257+00:00", "OriginalKey": { "CompanyId": 616 }, "CurrentKey": { "CompanyId": 616 }, "Key": { "CompanyId": 616 }, "Index": 0 }, { "CompanyId": 6, "CompanyName": "ABC RESOURCE COMP LTD", "AlphaCode": "ABC RESOUR", "ApAccount": "test", "ArAccount": "ABCRESOURC", "CreditStatus": "Credit", "Location": "0", "FinancialCompanyCode": "01", "CompanyType": "GEN", "Phone": "61396546989", "Client": true, "Supplier": true, "Subcontractor": false, "Other": true, "Inactive": false, "Select": { "CellId": "6", "CellValue": "ABC RESOURCE COMP LTD", "CellTag": "ABC RESOURCE COMP LTD" }, "CompanyNameValue": { "CellId": "PopupDialog", "CellValue": "ABC RESOURCE COMP LTD", "CellTag": "openDialog(\"6\")" }, "AlphaCodeValue": { "CellValue": "ABC RESOUR" }, "ApAccountValue": { "CellValue": "test" }, "ArAccountValue": { "CellValue": "ABCRESOURC" }, "CreditStatusValue": { "CellValue": "Credit" }, "LocationValue": { "CellId": "0", "CellValue": "0 : Head Office - Civil company" }, "FinancialCompanyCodeValue": { "CellId": "01", "CellValue": "01 : ASIA / PACIFIC CIVIL (AccountRight)" }, "CompanyTypeValue": { "CellId": "GEN", "CellValue": "GEN : General" }, "PhoneValue": { "CellValue": "61396546989" }, "CostValue": { "CellNumValue": 0 }, "CatalogueValue": {}, "UpdatedDate": "2024-03-07T20:58:20.2796344+00:00", "OriginalKey": { "CompanyId": 6 }, "CurrentKey": { "CompanyId": 6 }, "Key": { "CompanyId": 6 }, "Index": 0 }, { "CompanyId": 647, "CompanyName": "ABPA1", "AlphaCode": "ABPA", "ApAccount": "ABPAAR", "CreditStatus": "Credit", "Location": "0", "FinancialCompanyCode": "04", "CompanyType": "GEN", "Phone": " ", "Client": false, "Supplier": true, "Subcontractor": false, "Other": true, "Inactive": false, "Select": { "CellId": "647", "CellValue": "ABPA1", "CellTag": "ABPA1" }, "CompanyNameValue": { "CellId": "PopupDialog", "CellValue": "ABPA1", "CellTag": "openDialog(\"647\")" }, "AlphaCodeValue": { "CellValue": "ABPA" }, "ApAccountValue": { "CellValue": "ABPAAR" }, "ArAccountValue": {}, "CreditStatusValue": { "CellValue": "Credit" }, "LocationValue": { "CellId": "0", "CellValue": "0 : Head Office - Civil company" }, "FinancialCompanyCodeValue": { "CellId": "04", "CellValue": "04 : ASIA / PACIFIC RECYCLING (Xero)" }, "CompanyTypeValue": { "CellId": "GEN", "CellValue": "GEN : General" }, "PhoneValue": { "CellValue": " " }, "CostValue": { "CellNumValue": 0 }, "CatalogueValue": {}, "UpdatedDate": "2023-11-30T22:40:31.6512052+00:00", "OriginalKey": { "CompanyId": 647 }, "CurrentKey": { "CompanyId": 647 }, "Key": { "CompanyId": 647 }, "Index": 0 }, { "CompanyId": 648, "CompanyName": "ABPA1a", "AlphaCode": "ABPA", "ArAccount": "ABPA1", "CreditStatus": "Credit", "Location": "0", "FinancialCompanyCode": "01", "CompanyType": "GEN", "Phone": " ", "Client": true, "Supplier": false, "Subcontractor": false, "Other": true, "Inactive": false, "Select": { "CellId": "648", "CellValue": "ABPA1a", "CellTag": "ABPA1a" }, "CompanyNameValue": { "CellId": "PopupDialog", "CellValue": "ABPA1a", "CellTag": "openDialog(\"648\")" }, "AlphaCodeValue": { "CellValue": "ABPA" }, "ApAccountValue": {}, "ArAccountValue": { "CellValue": "ABPA1" }, "CreditStatusValue": { "CellValue": "Credit" }, "LocationValue": { "CellId": "0", "CellValue": "0 : Head Office - Civil company" }, "FinancialCompanyCodeValue": { "CellId": "01", "CellValue": "01 : ASIA / PACIFIC CIVIL (AccountRight)" }, "CompanyTypeValue": { "CellId": "GEN", "CellValue": "GEN : General" }, "PhoneValue": { "CellValue": " " }, "CostValue": { "CellNumValue": 0 }, "CatalogueValue": {}, "UpdatedDate": "2023-10-31T01:54:55.9741035+00:00", "OriginalKey": { "CompanyId": 648 }, "CurrentKey": { "CompanyId": 648 }, "Key": { "CompanyId": 648 }, "Index": 0 }, { "CompanyId": 646, "CompanyName": "ABPA4", "AlphaCode": "ABPA", "ApAccount": "ABPA1", "ArAccount": "ABPA1", "CreditStatus": "Credit", "Location": "0", "FinancialCompanyCode": "04", "CompanyType": "GEN", "Phone": " ", "Client": true, "Supplier": true, "Subcontractor": false, "Other": true, "Inactive": false, "Select": { "CellId": "646", "CellValue": "ABPA4", "CellTag": "ABPA4" }, "CompanyNameValue": { "CellId": "PopupDialog", "CellValue": "ABPA4", "CellTag": "openDialog(\"646\")" }, "AlphaCodeValue": { "CellValue": "ABPA" }, "ApAccountValue": { "CellValue": "ABPA1" }, "ArAccountValue": { "CellValue": "ABPA1" }, "CreditStatusValue": { "CellValue": "Credit" }, "LocationValue": { "CellId": "0", "CellValue": "0 : Head Office - Civil company" }, "FinancialCompanyCodeValue": { "CellId": "04", "CellValue": "04 : ASIA / PACIFIC RECYCLING (Xero)" }, "CompanyTypeValue": { "CellId": "GEN", "CellValue": "GEN : General" }, "PhoneValue": { "CellValue": " " }, "CostValue": { "CellNumValue": 0 }, "CatalogueValue": {}, "UpdatedDate": "2023-07-24T23:30:57.5847388+00:00", "OriginalKey": { "CompanyId": 646 }, "CurrentKey": { "CompanyId": 646 }, "Key": { "CompanyId": 646 }, "Index": 0 }, { "CompanyId": 636, "CompanyName": "ACT HIRE", "AlphaCode": "ACTHIRE", "ApAccount": "20001", "CreditStatus": "Credit", "Location": "0", "FinancialCompanyCode": "01", "CompanyType": "GEN", "Phone": "+614421676915", "Client": false, "Supplier": true, "Subcontractor": true, "Other": true, "Inactive": false, "Select": { "CellId": "636", "CellValue": "ACT HIRE", "CellTag": "ACT HIRE" }, "CompanyNameValue": { "CellId": "PopupDialog", "CellValue": "ACT HIRE", "CellTag": "openDialog(\"636\")" }, "AlphaCodeValue": { "CellValue": "ACTHIRE" }, "ApAccountValue": { "CellValue": "20001" }, "ArAccountValue": {}, "CreditStatusValue": { "CellValue": "Credit" }, "LocationValue": { "CellId": "0", "CellValue": "0 : Head Office - Civil company" }, "FinancialCompanyCodeValue": { "CellId": "01", "CellValue": "01 : ASIA / PACIFIC CIVIL (AccountRight)" }, "CompanyTypeValue": { "CellId": "GEN", "CellValue": "GEN : General" }, "PhoneValue": { "CellValue": "+614421676915" }, "CostValue": { "CellNumValue": 0 }, "CatalogueValue": {}, "UpdatedDate": "2023-08-10T02:44:27.8697641+00:00", "OriginalKey": { "CompanyId": 636 }, "CurrentKey": { "CompanyId": 636 }, "Key": { "CompanyId": 636 }, "Index": 0 }, { "CompanyId": 455, "CompanyName": "ACT HIRE 2020", "AlphaCode": "ACT HIRE 2", "ApAccount": "223", "CreditStatus": "Credit", "Location": "EQUIP", "FinancialCompanyCode": "01", "CompanyType": "GEN", "Phone": "6582999231", "Client": false, "Supplier": true, "Subcontractor": false, "Other": true, "Inactive": false, "Select": { "CellId": "455", "CellValue": "ACT HIRE 2020", "CellTag": "ACT HIRE 2020" }, "CompanyNameValue": { "CellId": "PopupDialog", "CellValue": "ACT HIRE 2020", "CellTag": "openDialog(\"455\")" }, "AlphaCodeValue": { "CellValue": "ACT HIRE 2" }, "ApAccountValue": { "CellValue": "223" }, "ArAccountValue": {}, "CreditStatusValue": { "CellValue": "Credit" }, "LocationValue": { "CellId": "EQUIP", "CellValue": "EQUIP : Equipment" }, "FinancialCompanyCodeValue": { "CellId": "01", "CellValue": "01 : ASIA / PACIFIC CIVIL (AccountRight)" }, "CompanyTypeValue": { "CellId": "GEN", "CellValue": "GEN : General" }, "PhoneValue": { "CellValue": "6582999231" }, "CostValue": { "CellNumValue": 0 }, "CatalogueValue": {}, "UpdatedDate": "2022-09-12T02:54:49.4431434+00:00", "OriginalKey": { "CompanyId": 455 }, "CurrentKey": { "CompanyId": 455 }, "Key": { "CompanyId": 455 }, "Index": 0 }, { "CompanyId": 615, "CompanyName": "ACT HIRE 2020 US", "AlphaCode": "ACT HIRE 2", "ApAccount": "223", "CreditStatus": "Credit", "Location": "0", "FinancialCompanyCode": "02", "CompanyType": "GEN", "Phone": "6582999231", "Client": false, "Supplier": true, "Subcontractor": false, "Other": true, "Inactive": false, "Select": { "CellId": "615", "CellValue": "ACT HIRE 2020 US", "CellTag": "ACT HIRE 2020 US" }, "CompanyNameValue": { "CellId": "PopupDialog", "CellValue": "ACT HIRE 2020 US", "CellTag": "openDialog(\"615\")" }, "AlphaCodeValue": { "CellValue": "ACT HIRE 2" }, "ApAccountValue": { "CellValue": "223" }, "ArAccountValue": {}, "CreditStatusValue": { "CellValue": "Credit" }, "LocationValue": { "CellId": "0", "CellValue": "0 : Head Office - Civil company" }, "FinancialCompanyCodeValue": { "CellId": "02", "CellValue": "02 : ASIA / PACIFIC EQUIPMENT (MYOB-ADV)" }, "CompanyTypeValue": { "CellId": "GEN", "CellValue": "GEN : General" }, "PhoneValue": { "CellValue": "6582999231" }, "CostValue": { "CellNumValue": 0 }, "CatalogueValue": {}, "UpdatedDate": "2023-04-19T01:19:51.4653571+00:00", "OriginalKey": { "CompanyId": 615 }, "CurrentKey": { "CompanyId": 615 }, "Key": { "CompanyId": 615 }, "Index": 0 } ] }
Get the list of all Workbench companies
Request
Response
{ "total": 0, "page": 0, "records": 0, "rows": [ { "CompanyId": 0, "CompanyName": "string", "AlphaCode": "string", "ApAccount": "string", "ArAccount": "string", "CreditStatus": "string", "Location": "string", "FinancialCompanyCode": "string", "CompanyType": "string", "Phone": "string", "Client": true, "Supplier": true, "Subcontractor": true, "Other": true, "Inactive": true, "GSTNumber": "string", "Select": { "CellId": "string", "CellValue": "string", "CellNumValue": 0, "CellBoolValue": true, "CellTag": "string", "CellValueDate": "2024-04-05T02:31:14.689Z", "CellValueInt": 0 }, "CompanyNameValue": { "CellId": "string", "CellValue": "string", "CellNumValue": 0, "CellBoolValue": true, "CellTag": "string", "CellValueDate": "2024-04-05T02:31:14.689Z", "CellValueInt": 0 }, "AlphaCodeValue": { "CellId": "string", "CellValue": "string", "CellNumValue": 0, "CellBoolValue": true, "CellTag": "string", "CellValueDate": "2024-04-05T02:31:14.689Z", "CellValueInt": 0 }, "ApAccountValue": { "CellId": "string", "CellValue": "string", "CellNumValue": 0, "CellBoolValue": true, "CellTag": "string", "CellValueDate": "2024-04-05T02:31:14.689Z", "CellValueInt": 0 }, "ArAccountValue": { "CellId": "string", "CellValue": "string", "CellNumValue": 0, "CellBoolValue": true, "CellTag": "string", "CellValueDate": "2024-04-05T02:31:14.689Z", "CellValueInt": 0 }, "CreditStatusValue": { "CellId": "string", "CellValue": "string", "CellNumValue": 0, "CellBoolValue": true, "CellTag": "string", "CellValueDate": "2024-04-05T02:31:14.689Z", "CellValueInt": 0 }, "LocationValue": { "CellId": "string", "CellValue": "string", "CellNumValue": 0, "CellBoolValue": true, "CellTag": "string", "CellValueDate": "2024-04-05T02:31:14.689Z", "CellValueInt": 0 }, "FinancialCompanyCodeValue": { "CellId": "string", "CellValue": "string", "CellNumValue": 0, "CellBoolValue": true, "CellTag": "string", "CellValueDate": "2024-04-05T02:31:14.689Z", "CellValueInt": 0 }, "CompanyTypeValue": { "CellId": "string", "CellValue": "string", "CellNumValue": 0, "CellBoolValue": true, "CellTag": "string", "CellValueDate": "2024-04-05T02:31:14.689Z", "CellValueInt": 0 }, "PhoneValue": { "CellId": "string", "CellValue": "string", "CellNumValue": 0, "CellBoolValue": true, "CellTag": "string", "CellValueDate": "2024-04-05T02:31:14.689Z", "CellValueInt": 0 }, "CostValue": { "CellId": "string", "CellValue": "string", "CellNumValue": 0, "CellBoolValue": true, "CellTag": "string", "CellValueDate": "2024-04-05T02:31:14.690Z", "CellValueInt": 0 }, "CatalogueValue": { "CellId": "string", "CellValue": "string", "CellNumValue": 0, "CellBoolValue": true, "CellTag": "string", "CellValueDate": "2024-04-05T02:31:14.690Z", "CellValueInt": 0 }, "Group1": "string", "Group2": "string", "Group3": "string", "UpdatedDate": "2024-04-05T02:31:14.690Z", "Status": "string", "ReadonlyFlag": 0, "ReadonlyMessage": "string", "OriginalKey": { "CompanyId": 0 }, "CurrentKey": { "CompanyId": 0 }, "Key": { "CompanyId": 0 }, "Index": 0 } ], "form": {}, "widgets": [ { "WidgetId": 0, "LayoutCode": "string", "Name": "string", "Colour": "string", "BGColour": "string", "Icon": "string", "Type": "string", "Visible": true, "Order": 0, "Count": 0, "WidgetLines": [ { "WidgetLineId": 0, "WidgetId": 0, "Name": "string", "Predicate": "string", "Order": 0, "Count": 0 } ] } ] }
Response sample
{ "total": 15, "page": 1, "records": 285, "rows": [ { "CompanyId": 596, "CompanyName": " Adatum Sandbox", "AlphaCode": "ADATUMCORP", "ApAccount": "10001", "ArAccount": "10000", "CreditStatus": "Credit", "Location": "0", "FinancialCompanyCode": "03", "CompanyType": "GEN", "Phone": "22222221111", "Client": true, "Supplier": true, "Subcontractor": false, "Other": true, "Inactive": false, "GSTNumber": "31608459409", "Select": { "CellId": "596", "CellValue": " Adatum Sandbox", "CellTag": " Adatum Sandbox" }, "CompanyNameValue": { "CellId": "PopupDialog", "CellValue": " Adatum Sandbox", "CellTag": "openDialog(\"596\")" }, "AlphaCodeValue": { "CellValue": "ADATUMCORP" }, "ApAccountValue": { "CellValue": "10001" }, "ArAccountValue": { "CellValue": "10000" }, "CreditStatusValue": { "CellValue": "Credit" }, "LocationValue": { "CellId": "0", "CellValue": "0 : Head Office - Civil company" }, "FinancialCompanyCodeValue": { "CellId": "03", "CellValue": "03 : ASIA / PACIFIC LABOUR (Business Cent)" }, "CompanyTypeValue": { "CellId": "GEN", "CellValue": "GEN : General" }, "PhoneValue": { "CellValue": "22222221111" }, "CostValue": { "CellNumValue": 0 }, "CatalogueValue": {}, "UpdatedDate": "2023-09-22T03:00:51.4565009+00:00", "OriginalKey": { "CompanyId": 596 }, "CurrentKey": { "CompanyId": 596 }, "Key": { "CompanyId": 596 }, "Index": 0 }, { "CompanyId": 738, "CompanyName": "132 Collins", "AlphaCode": "132COLLINS", "ApAccount": "123COLL", "CreditStatus": "Credit", "Location": "0", "FinancialCompanyCode": "04", "CompanyType": "GEN", "Phone": " 03 3699876", "Client": false, "Supplier": true, "Subcontractor": false, "Other": true, "Inactive": false, "Select": { "CellId": "738", "CellValue": "132 Collins", "CellTag": "132 Collins" }, "CompanyNameValue": { "CellId": "PopupDialog", "CellValue": "132 Collins", "CellTag": "openDialog(\"738\")" }, "AlphaCodeValue": { "CellValue": "132COLLINS" }, "ApAccountValue": { "CellValue": "123COLL" }, "ArAccountValue": {}, "CreditStatusValue": { "CellValue": "Credit" }, "LocationValue": { "CellId": "0", "CellValue": "0 : Head Office - Civil company" }, "FinancialCompanyCodeValue": { "CellId": "04", "CellValue": "04 : ASIA / PACIFIC RECYCLING (Xero)" }, "CompanyTypeValue": { "CellId": "GEN", "CellValue": "GEN : General" }, "PhoneValue": { "CellValue": " 03 3699876" }, "CostValue": { "CellNumValue": 0 }, "CatalogueValue": {}, "UpdatedDate": "2024-02-26T23:23:24.3840362+00:00", "OriginalKey": { "CompanyId": 738 }, "CurrentKey": { "CompanyId": 738 }, "Key": { "CompanyId": 738 }, "Index": 0 }, { "CompanyId": 749, "CompanyName": "3M International 3", "AlphaCode": "3M INTERNA", "ArAccount": "3M", "CreditStatus": "Credit", "Location": "0", "FinancialCompanyCode": "01", "CompanyType": "GEN", "Client": true, "Supplier": false, "Subcontractor": false, "Other": true, "Inactive": false, "Select": { "CellId": "749", "CellValue": "3M International 3", "CellTag": "3M International 3" }, "CompanyNameValue": { "CellId": "PopupDialog", "CellValue": "3M International 3", "CellTag": "openDialog(\"749\")" }, "AlphaCodeValue": { "CellValue": "3M INTERNA" }, "ApAccountValue": {}, "ArAccountValue": { "CellValue": "3M" }, "CreditStatusValue": { "CellValue": "Credit" }, "LocationValue": { "CellId": "0", "CellValue": "0 : Head Office - Civil company" }, "FinancialCompanyCodeValue": { "CellId": "01", "CellValue": "01 : ASIA / PACIFIC CIVIL (AccountRight)" }, "CompanyTypeValue": { "CellId": "GEN", "CellValue": "GEN : General" }, "PhoneValue": {}, "CostValue": { "CellNumValue": 0 }, "CatalogueValue": {}, "UpdatedDate": "2024-02-29T02:47:23.487+00:00", "OriginalKey": { "CompanyId": 749 }, "CurrentKey": { "CompanyId": 749 }, "Key": { "CompanyId": 749 }, "Index": 0 }, { "CompanyId": 617, "CompanyName": "3M International 3", "AlphaCode": "3M INTERNA", "ApAccount": "4M", "ArAccount": "3M", "CreditStatus": "Credit", "Location": "0", "FinancialCompanyCode": "02", "CompanyType": "GEN", "Client": true, "Supplier": false, "Subcontractor": true, "Other": true, "Inactive": false, "Select": { "CellId": "617", "CellValue": "3M International 3", "CellTag": "3M International 3" }, "CompanyNameValue": { "CellId": "PopupDialog", "CellValue": "3M International 3", "CellTag": "openDialog(\"617\")" }, "AlphaCodeValue": { "CellValue": "3M INTERNA" }, "ApAccountValue": { "CellValue": "4M" }, "ArAccountValue": { "CellValue": "3M" }, "CreditStatusValue": { "CellValue": "Credit" }, "LocationValue": { "CellId": "0", "CellValue": "0 : Head Office - Civil company" }, "FinancialCompanyCodeValue": { "CellId": "02", "CellValue": "02 : ASIA / PACIFIC EQUIPMENT (MYOB-ADV)" }, "CompanyTypeValue": { "CellId": "GEN", "CellValue": "GEN : General" }, "PhoneValue": {}, "CostValue": { "CellNumValue": 0 }, "CatalogueValue": {}, "UpdatedDate": "2023-08-10T02:28:35.8535551+00:00", "OriginalKey": { "CompanyId": 617 }, "CurrentKey": { "CompanyId": 617 }, "Key": { "CompanyId": 617 }, "Index": 0 }, { "CompanyId": 613, "CompanyName": "7-Eleven", "AlphaCode": "7_ELEVEN", "ApAccount": "6621", "ArAccount": "X001", "CreditStatus": "Credit", "Location": "0", "FinancialCompanyCode": "04", "CompanyType": "GEN", "Phone": " ", "Client": true, "Supplier": false, "Subcontractor": false, "Other": true, "Inactive": false, "Select": { "CellId": "613", "CellValue": "7-Eleven", "CellTag": "7-Eleven" }, "CompanyNameValue": { "CellId": "PopupDialog", "CellValue": "7-Eleven", "CellTag": "openDialog(\"613\")" }, "AlphaCodeValue": { "CellValue": "7_ELEVEN" }, "ApAccountValue": { "CellValue": "6621" }, "ArAccountValue": { "CellValue": "X001" }, "CreditStatusValue": { "CellValue": "Credit" }, "LocationValue": { "CellId": "0", "CellValue": "0 : Head Office - Civil company" }, "FinancialCompanyCodeValue": { "CellId": "04", "CellValue": "04 : ASIA / PACIFIC RECYCLING (Xero)" }, "CompanyTypeValue": { "CellId": "GEN", "CellValue": "GEN : General" }, "PhoneValue": { "CellValue": " " }, "CostValue": { "CellNumValue": 0 }, "CatalogueValue": {}, "UpdatedDate": "2023-03-12T00:02:07.2149894+00:00", "OriginalKey": { "CompanyId": 613 }, "CurrentKey": { "CompanyId": 613 }, "Key": { "CompanyId": 613 }, "Index": 0 }, { "CompanyId": 712, "CompanyName": "7-Eleven", "AlphaCode": "7_ELEVEN", "ArAccount": "7Elev1", "CreditStatus": "Credit", "Location": "0", "FinancialCompanyCode": "01", "CompanyType": "GEN", "Phone": " ", "Client": true, "Supplier": false, "Subcontractor": false, "Other": true, "Inactive": false, "Select": { "CellId": "712", "CellValue": "7-Eleven", "CellTag": "7-Eleven" }, "CompanyNameValue": { "CellId": "PopupDialog", "CellValue": "7-Eleven", "CellTag": "openDialog(\"712\")" }, "AlphaCodeValue": { "CellValue": "7_ELEVEN" }, "ApAccountValue": {}, "ArAccountValue": { "CellValue": "7Elev1" }, "CreditStatusValue": { "CellValue": "Credit" }, "LocationValue": { "CellId": "0", "CellValue": "0 : Head Office - Civil company" }, "FinancialCompanyCodeValue": { "CellId": "01", "CellValue": "01 : ASIA / PACIFIC CIVIL (AccountRight)" }, "CompanyTypeValue": { "CellId": "GEN", "CellValue": "GEN : General" }, "PhoneValue": { "CellValue": " " }, "CostValue": { "CellNumValue": 0 }, "CatalogueValue": {}, "UpdatedDate": "2023-07-20T04:34:49.7561455+00:00", "OriginalKey": { "CompanyId": 712 }, "CurrentKey": { "CompanyId": 712 }, "Key": { "CompanyId": 712 }, "Index": 0 }, { "CompanyId": 645, "CompanyName": "A & B CONSTRUCTIONS LTD", "AlphaCode": "A&BCONSTRU", "ApAccount": "20044", "CreditStatus": "Credit", "Location": "0", "FinancialCompanyCode": "01", "CompanyType": "GEN", "Phone": "6582999231", "Client": false, "Supplier": true, "Subcontractor": false, "Other": true, "Inactive": false, "GSTNumber": "11 223 344 555", "Select": { "CellId": "645", "CellValue": "A & B CONSTRUCTIONS LTD", "CellTag": "A & B CONSTRUCTIONS LTD" }, "CompanyNameValue": { "CellId": "PopupDialog", "CellValue": "A & B CONSTRUCTIONS LTD", "CellTag": "openDialog(\"645\")" }, "AlphaCodeValue": { "CellValue": "A&BCONSTRU" }, "ApAccountValue": { "CellValue": "20044" }, "ArAccountValue": {}, "CreditStatusValue": { "CellValue": "Credit" }, "LocationValue": { "CellId": "0", "CellValue": "0 : Head Office - Civil company" }, "FinancialCompanyCodeValue": { "CellId": "01", "CellValue": "01 : ASIA / PACIFIC CIVIL (AccountRight)" }, "CompanyTypeValue": { "CellId": "GEN", "CellValue": "GEN : General" }, "PhoneValue": { "CellValue": "6582999231" }, "CostValue": { "CellNumValue": 0 }, "CatalogueValue": {}, "UpdatedDate": "2023-03-31T11:22:12.003+00:00", "OriginalKey": { "CompanyId": 645 }, "CurrentKey": { "CompanyId": 645 }, "Key": { "CompanyId": 645 }, "Index": 0 }, { "CompanyId": 498, "CompanyName": "A & B CONSTRUCTIONS PTY LTD", "AlphaCode": "A & B CONS", "ApAccount": "266", "CreditStatus": "Credit", "Location": "0", "FinancialCompanyCode": "01", "CompanyType": "GEN", "Phone": "7762800461", "Client": false, "Supplier": true, "Subcontractor": false, "Other": true, "Inactive": false, "Select": { "CellId": "498", "CellValue": "A & B CONSTRUCTIONS PTY LTD", "CellTag": "A & B CONSTRUCTIONS PTY LTD" }, "CompanyNameValue": { "CellId": "PopupDialog", "CellValue": "A & B CONSTRUCTIONS PTY LTD", "CellTag": "openDialog(\"498\")" }, "AlphaCodeValue": { "CellValue": "A & B CONS" }, "ApAccountValue": { "CellValue": "266" }, "ArAccountValue": {}, "CreditStatusValue": { "CellValue": "Credit" }, "LocationValue": { "CellId": "0", "CellValue": "0 : Head Office - Civil company" }, "FinancialCompanyCodeValue": { "CellId": "01", "CellValue": "01 : ASIA / PACIFIC CIVIL (AccountRight)" }, "CompanyTypeValue": { "CellId": "GEN", "CellValue": "GEN : General" }, "PhoneValue": { "CellValue": "7762800461" }, "CostValue": { "CellNumValue": 0 }, "CatalogueValue": {}, "UpdatedDate": "2022-04-25T21:14:14.9809085+00:00", "OriginalKey": { "CompanyId": 498 }, "CurrentKey": { "CompanyId": 498 }, "Key": { "CompanyId": 498 }, "Index": 0 }, { "CompanyId": 521, "CompanyName": "ABC & 123 PLUMBER LTD", "AlphaCode": "ABC & 123 ", "ApAccount": "289", "CreditStatus": "Credit", "Location": "0", "FinancialCompanyCode": "01", "CompanyType": "GEN", "Phone": "3702820496", "Client": false, "Supplier": true, "Subcontractor": true, "Other": true, "Inactive": false, "Select": { "CellId": "521", "CellValue": "ABC & 123 PLUMBER LTD", "CellTag": "ABC & 123 PLUMBER LTD" }, "CompanyNameValue": { "CellId": "PopupDialog", "CellValue": "ABC & 123 PLUMBER LTD", "CellTag": "openDialog(\"521\")" }, "AlphaCodeValue": { "CellValue": "ABC & 123 " }, "ApAccountValue": { "CellValue": "289" }, "ArAccountValue": {}, "CreditStatusValue": { "CellValue": "Credit" }, "LocationValue": { "CellId": "0", "CellValue": "0 : Head Office - Civil company" }, "FinancialCompanyCodeValue": { "CellId": "01", "CellValue": "01 : ASIA / PACIFIC CIVIL (AccountRight)" }, "CompanyTypeValue": { "CellId": "GEN", "CellValue": "GEN : General" }, "PhoneValue": { "CellValue": "3702820496" }, "CostValue": { "CellNumValue": 0 }, "CatalogueValue": {}, "UpdatedDate": "2023-01-31T01:16:17.8709216+00:00", "OriginalKey": { "CompanyId": 521 }, "CurrentKey": { "CompanyId": 521 }, "Key": { "CompanyId": 521 }, "Index": 0 }, { "CompanyId": 612, "CompanyName": "ABC Furniture", "AlphaCode": "ABCFURNITU", "ApAccount": "X002", "ArAccount": "X002", "CreditStatus": "Credit", "Location": "0", "FinancialCompanyCode": "04", "CompanyType": "GEN", "Phone": " 0800 124578", "Client": true, "Supplier": true, "Subcontractor": true, "Other": true, "Inactive": false, "Select": { "CellId": "612", "CellValue": "ABC Furniture", "CellTag": "ABC Furniture" }, "CompanyNameValue": { "CellId": "PopupDialog", "CellValue": "ABC Furniture", "CellTag": "openDialog(\"612\")" }, "AlphaCodeValue": { "CellValue": "ABCFURNITU" }, "ApAccountValue": { "CellValue": "X002" }, "ArAccountValue": { "CellValue": "X002" }, "CreditStatusValue": { "CellValue": "Credit" }, "LocationValue": { "CellId": "0", "CellValue": "0 : Head Office - Civil company" }, "FinancialCompanyCodeValue": { "CellId": "04", "CellValue": "04 : ASIA / PACIFIC RECYCLING (Xero)" }, "CompanyTypeValue": { "CellId": "GEN", "CellValue": "GEN : General" }, "PhoneValue": { "CellValue": " 0800 124578" }, "CostValue": { "CellNumValue": 0 }, "CatalogueValue": {}, "UpdatedDate": "2023-09-13T01:48:43.9832641+00:00", "OriginalKey": { "CompanyId": 612 }, "CurrentKey": { "CompanyId": 612 }, "Key": { "CompanyId": 612 }, "Index": 0 }, { "CompanyId": 649, "CompanyName": "ABC Furniture", "AlphaCode": "ABCFURNITU", "ArAccount": "ABCFu1", "CreditStatus": "Credit", "Location": "0", "FinancialCompanyCode": "04", "CompanyType": "GEN", "Phone": " 0800 124578", "Client": true, "Supplier": false, "Subcontractor": false, "Other": true, "Inactive": false, "Select": { "CellId": "649", "CellValue": "ABC Furniture", "CellTag": "ABC Furniture" }, "CompanyNameValue": { "CellId": "PopupDialog", "CellValue": "ABC Furniture", "CellTag": "openDialog(\"649\")" }, "AlphaCodeValue": { "CellValue": "ABCFURNITU" }, "ApAccountValue": {}, "ArAccountValue": { "CellValue": "ABCFu1" }, "CreditStatusValue": { "CellValue": "Credit" }, "LocationValue": { "CellId": "0", "CellValue": "0 : Head Office - Civil company" }, "FinancialCompanyCodeValue": { "CellId": "04", "CellValue": "04 : ASIA / PACIFIC RECYCLING (Xero)" }, "CompanyTypeValue": { "CellId": "GEN", "CellValue": "GEN : General" }, "PhoneValue": { "CellValue": " 0800 124578" }, "CostValue": { "CellNumValue": 0 }, "CatalogueValue": {}, "UpdatedDate": "2023-04-05T04:33:01.11+00:00", "OriginalKey": { "CompanyId": 649 }, "CurrentKey": { "CompanyId": 649 }, "Key": { "CompanyId": 649 }, "Index": 0 }, { "CompanyId": 690, "CompanyName": "ABC Furniture", "AlphaCode": "ABCFURNITU", "ArAccount": "ABCFu1", "CreditStatus": "Credit", "Location": "0", "FinancialCompanyCode": "01", "CompanyType": "GEN", "Phone": " 0800 124578", "Client": true, "Supplier": false, "Subcontractor": false, "Other": true, "Inactive": false, "Select": { "CellId": "690", "CellValue": "ABC Furniture", "CellTag": "ABC Furniture" }, "CompanyNameValue": { "CellId": "PopupDialog", "CellValue": "ABC Furniture", "CellTag": "openDialog(\"690\")" }, "AlphaCodeValue": { "CellValue": "ABCFURNITU" }, "ApAccountValue": {}, "ArAccountValue": { "CellValue": "ABCFu1" }, "CreditStatusValue": { "CellValue": "Credit" }, "LocationValue": { "CellId": "0", "CellValue": "0 : Head Office - Civil company" }, "FinancialCompanyCodeValue": { "CellId": "01", "CellValue": "01 : ASIA / PACIFIC CIVIL (AccountRight)" }, "CompanyTypeValue": { "CellId": "GEN", "CellValue": "GEN : General" }, "PhoneValue": { "CellValue": " 0800 124578" }, "CostValue": { "CellNumValue": 0 }, "CatalogueValue": {}, "UpdatedDate": "2023-04-05T05:09:18.59+00:00", "OriginalKey": { "CompanyId": 690 }, "CurrentKey": { "CompanyId": 690 }, "Key": { "CompanyId": 690 }, "Index": 0 }, { "CompanyId": 616, "CompanyName": "ABC RESOURCE CO SM Test Mar 2022", "AlphaCode": "ABC RESOUR", "ArAccount": "ABCRESOURC", "CreditStatus": "Credit", "Location": "0", "FinancialCompanyCode": "02", "CompanyType": "GEN", "Phone": "61396546989", "Client": true, "Supplier": false, "Subcontractor": false, "Other": true, "Inactive": false, "Select": { "CellId": "616", "CellValue": "ABC RESOURCE CO SM Test Mar 2022", "CellTag": "ABC RESOURCE CO SM Test Mar 2022" }, "CompanyNameValue": { "CellId": "PopupDialog", "CellValue": "ABC RESOURCE CO SM Test Mar 2022", "CellTag": "openDialog(\"616\")" }, "AlphaCodeValue": { "CellValue": "ABC RESOUR" }, "ApAccountValue": {}, "ArAccountValue": { "CellValue": "ABCRESOURC" }, "CreditStatusValue": { "CellValue": "Credit" }, "LocationValue": { "CellId": "0", "CellValue": "0 : Head Office - Civil company" }, "FinancialCompanyCodeValue": { "CellId": "02", "CellValue": "02 : ASIA / PACIFIC EQUIPMENT (MYOB-ADV)" }, "CompanyTypeValue": { "CellId": "GEN", "CellValue": "GEN : General" }, "PhoneValue": { "CellValue": "61396546989" }, "CostValue": { "CellNumValue": 0 }, "CatalogueValue": {}, "UpdatedDate": "2022-05-11T04:29:51.257+00:00", "OriginalKey": { "CompanyId": 616 }, "CurrentKey": { "CompanyId": 616 }, "Key": { "CompanyId": 616 }, "Index": 0 }, { "CompanyId": 6, "CompanyName": "ABC RESOURCE COMP LTD", "AlphaCode": "ABC RESOUR", "ApAccount": "test", "ArAccount": "ABCRESOURC", "CreditStatus": "Credit", "Location": "0", "FinancialCompanyCode": "01", "CompanyType": "GEN", "Phone": "61396546989", "Client": true, "Supplier": true, "Subcontractor": false, "Other": true, "Inactive": false, "Select": { "CellId": "6", "CellValue": "ABC RESOURCE COMP LTD", "CellTag": "ABC RESOURCE COMP LTD" }, "CompanyNameValue": { "CellId": "PopupDialog", "CellValue": "ABC RESOURCE COMP LTD", "CellTag": "openDialog(\"6\")" }, "AlphaCodeValue": { "CellValue": "ABC RESOUR" }, "ApAccountValue": { "CellValue": "test" }, "ArAccountValue": { "CellValue": "ABCRESOURC" }, "CreditStatusValue": { "CellValue": "Credit" }, "LocationValue": { "CellId": "0", "CellValue": "0 : Head Office - Civil company" }, "FinancialCompanyCodeValue": { "CellId": "01", "CellValue": "01 : ASIA / PACIFIC CIVIL (AccountRight)" }, "CompanyTypeValue": { "CellId": "GEN", "CellValue": "GEN : General" }, "PhoneValue": { "CellValue": "61396546989" }, "CostValue": { "CellNumValue": 0 }, "CatalogueValue": {}, "UpdatedDate": "2024-03-07T20:58:20.2796344+00:00", "OriginalKey": { "CompanyId": 6 }, "CurrentKey": { "CompanyId": 6 }, "Key": { "CompanyId": 6 }, "Index": 0 }, { "CompanyId": 647, "CompanyName": "ABPA1", "AlphaCode": "ABPA", "ApAccount": "ABPAAR", "CreditStatus": "Credit", "Location": "0", "FinancialCompanyCode": "04", "CompanyType": "GEN", "Phone": " ", "Client": false, "Supplier": true, "Subcontractor": false, "Other": true, "Inactive": false, "Select": { "CellId": "647", "CellValue": "ABPA1", "CellTag": "ABPA1" }, "CompanyNameValue": { "CellId": "PopupDialog", "CellValue": "ABPA1", "CellTag": "openDialog(\"647\")" }, "AlphaCodeValue": { "CellValue": "ABPA" }, "ApAccountValue": { "CellValue": "ABPAAR" }, "ArAccountValue": {}, "CreditStatusValue": { "CellValue": "Credit" }, "LocationValue": { "CellId": "0", "CellValue": "0 : Head Office - Civil company" }, "FinancialCompanyCodeValue": { "CellId": "04", "CellValue": "04 : ASIA / PACIFIC RECYCLING (Xero)" }, "CompanyTypeValue": { "CellId": "GEN", "CellValue": "GEN : General" }, "PhoneValue": { "CellValue": " " }, "CostValue": { "CellNumValue": 0 }, "CatalogueValue": {}, "UpdatedDate": "2023-11-30T22:40:31.6512052+00:00", "OriginalKey": { "CompanyId": 647 }, "CurrentKey": { "CompanyId": 647 }, "Key": { "CompanyId": 647 }, "Index": 0 }, { "CompanyId": 648, "CompanyName": "ABPA1a", "AlphaCode": "ABPA", "ArAccount": "ABPA1", "CreditStatus": "Credit", "Location": "0", "FinancialCompanyCode": "01", "CompanyType": "GEN", "Phone": " ", "Client": true, "Supplier": false, "Subcontractor": false, "Other": true, "Inactive": false, "Select": { "CellId": "648", "CellValue": "ABPA1a", "CellTag": "ABPA1a" }, "CompanyNameValue": { "CellId": "PopupDialog", "CellValue": "ABPA1a", "CellTag": "openDialog(\"648\")" }, "AlphaCodeValue": { "CellValue": "ABPA" }, "ApAccountValue": {}, "ArAccountValue": { "CellValue": "ABPA1" }, "CreditStatusValue": { "CellValue": "Credit" }, "LocationValue": { "CellId": "0", "CellValue": "0 : Head Office - Civil company" }, "FinancialCompanyCodeValue": { "CellId": "01", "CellValue": "01 : ASIA / PACIFIC CIVIL (AccountRight)" }, "CompanyTypeValue": { "CellId": "GEN", "CellValue": "GEN : General" }, "PhoneValue": { "CellValue": " " }, "CostValue": { "CellNumValue": 0 }, "CatalogueValue": {}, "UpdatedDate": "2023-10-31T01:54:55.9741035+00:00", "OriginalKey": { "CompanyId": 648 }, "CurrentKey": { "CompanyId": 648 }, "Key": { "CompanyId": 648 }, "Index": 0 }, { "CompanyId": 646, "CompanyName": "ABPA4", "AlphaCode": "ABPA", "ApAccount": "ABPA1", "ArAccount": "ABPA1", "CreditStatus": "Credit", "Location": "0", "FinancialCompanyCode": "04", "CompanyType": "GEN", "Phone": " ", "Client": true, "Supplier": true, "Subcontractor": false, "Other": true, "Inactive": false, "Select": { "CellId": "646", "CellValue": "ABPA4", "CellTag": "ABPA4" }, "CompanyNameValue": { "CellId": "PopupDialog", "CellValue": "ABPA4", "CellTag": "openDialog(\"646\")" }, "AlphaCodeValue": { "CellValue": "ABPA" }, "ApAccountValue": { "CellValue": "ABPA1" }, "ArAccountValue": { "CellValue": "ABPA1" }, "CreditStatusValue": { "CellValue": "Credit" }, "LocationValue": { "CellId": "0", "CellValue": "0 : Head Office - Civil company" }, "FinancialCompanyCodeValue": { "CellId": "04", "CellValue": "04 : ASIA / PACIFIC RECYCLING (Xero)" }, "CompanyTypeValue": { "CellId": "GEN", "CellValue": "GEN : General" }, "PhoneValue": { "CellValue": " " }, "CostValue": { "CellNumValue": 0 }, "CatalogueValue": {}, "UpdatedDate": "2023-07-24T23:30:57.5847388+00:00", "OriginalKey": { "CompanyId": 646 }, "CurrentKey": { "CompanyId": 646 }, "Key": { "CompanyId": 646 }, "Index": 0 }, { "CompanyId": 636, "CompanyName": "ACT HIRE", "AlphaCode": "ACTHIRE", "ApAccount": "20001", "CreditStatus": "Credit", "Location": "0", "FinancialCompanyCode": "01", "CompanyType": "GEN", "Phone": "+614421676915", "Client": false, "Supplier": true, "Subcontractor": true, "Other": true, "Inactive": false, "Select": { "CellId": "636", "CellValue": "ACT HIRE", "CellTag": "ACT HIRE" }, "CompanyNameValue": { "CellId": "PopupDialog", "CellValue": "ACT HIRE", "CellTag": "openDialog(\"636\")" }, "AlphaCodeValue": { "CellValue": "ACTHIRE" }, "ApAccountValue": { "CellValue": "20001" }, "ArAccountValue": {}, "CreditStatusValue": { "CellValue": "Credit" }, "LocationValue": { "CellId": "0", "CellValue": "0 : Head Office - Civil company" }, "FinancialCompanyCodeValue": { "CellId": "01", "CellValue": "01 : ASIA / PACIFIC CIVIL (AccountRight)" }, "CompanyTypeValue": { "CellId": "GEN", "CellValue": "GEN : General" }, "PhoneValue": { "CellValue": "+614421676915" }, "CostValue": { "CellNumValue": 0 }, "CatalogueValue": {}, "UpdatedDate": "2023-08-10T02:44:27.8697641+00:00", "OriginalKey": { "CompanyId": 636 }, "CurrentKey": { "CompanyId": 636 }, "Key": { "CompanyId": 636 }, "Index": 0 }, { "CompanyId": 455, "CompanyName": "ACT HIRE 2020", "AlphaCode": "ACT HIRE 2", "ApAccount": "223", "CreditStatus": "Credit", "Location": "EQUIP", "FinancialCompanyCode": "01", "CompanyType": "GEN", "Phone": "6582999231", "Client": false, "Supplier": true, "Subcontractor": false, "Other": true, "Inactive": false, "Select": { "CellId": "455", "CellValue": "ACT HIRE 2020", "CellTag": "ACT HIRE 2020" }, "CompanyNameValue": { "CellId": "PopupDialog", "CellValue": "ACT HIRE 2020", "CellTag": "openDialog(\"455\")" }, "AlphaCodeValue": { "CellValue": "ACT HIRE 2" }, "ApAccountValue": { "CellValue": "223" }, "ArAccountValue": {}, "CreditStatusValue": { "CellValue": "Credit" }, "LocationValue": { "CellId": "EQUIP", "CellValue": "EQUIP : Equipment" }, "FinancialCompanyCodeValue": { "CellId": "01", "CellValue": "01 : ASIA / PACIFIC CIVIL (AccountRight)" }, "CompanyTypeValue": { "CellId": "GEN", "CellValue": "GEN : General" }, "PhoneValue": { "CellValue": "6582999231" }, "CostValue": { "CellNumValue": 0 }, "CatalogueValue": {}, "UpdatedDate": "2022-09-12T02:54:49.4431434+00:00", "OriginalKey": { "CompanyId": 455 }, "CurrentKey": { "CompanyId": 455 }, "Key": { "CompanyId": 455 }, "Index": 0 }, { "CompanyId": 615, "CompanyName": "ACT HIRE 2020 US", "AlphaCode": "ACT HIRE 2", "ApAccount": "223", "CreditStatus": "Credit", "Location": "0", "FinancialCompanyCode": "02", "CompanyType": "GEN", "Phone": "6582999231", "Client": false, "Supplier": true, "Subcontractor": false, "Other": true, "Inactive": false, "Select": { "CellId": "615", "CellValue": "ACT HIRE 2020 US", "CellTag": "ACT HIRE 2020 US" }, "CompanyNameValue": { "CellId": "PopupDialog", "CellValue": "ACT HIRE 2020 US", "CellTag": "openDialog(\"615\")" }, "AlphaCodeValue": { "CellValue": "ACT HIRE 2" }, "ApAccountValue": { "CellValue": "223" }, "ArAccountValue": {}, "CreditStatusValue": { "CellValue": "Credit" }, "LocationValue": { "CellId": "0", "CellValue": "0 : Head Office - Civil company" }, "FinancialCompanyCodeValue": { "CellId": "02", "CellValue": "02 : ASIA / PACIFIC EQUIPMENT (MYOB-ADV)" }, "CompanyTypeValue": { "CellId": "GEN", "CellValue": "GEN : General" }, "PhoneValue": { "CellValue": "6582999231" }, "CostValue": { "CellNumValue": 0 }, "CatalogueValue": {}, "UpdatedDate": "2023-04-19T01:19:51.4653571+00:00", "OriginalKey": { "CompanyId": 615 }, "CurrentKey": { "CompanyId": 615 }, "Key": { "CompanyId": 615 }, "Index": 0 } ] }
⬆️ Back to top
On this page
- No labels