Versions Compared

Old Version 11

changes.mady.by.user Cam Mackay

Saved on

compared with

New Version 12

changes.mady.by.user Cam Mackay

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Overview

Provides access to Company related data.

Endpoints

The resources available in this module.

CompanyListApi

Provides API access to the Companies (#/General/CompanyList.aspx) Web Workbench screen.

/api/CompanyListApi

Method

Performed As

Request Query

Request Body

Response

GET
Retrieve the first 20 companies.

Logged in User

-

-

GridResult<CompanyLine>

POST
Retrieve a filtered list of companies.

Logged in User

-

GridRequestParametersApi

GridResult<CompanyLine>

CompanyDetailApi

Provides API access to the Company Detail (#/General/CompanyList.aspx) dialog Web Workbench screen.

/api/CompanyDetailApi

Method

Performed As

Request Query

Request Body

Response

GET
Retrieve a specific Company (including details, people, addresses and attributes).

Admin User

CompanyKey

-

CompanyApiModel

POST
Update a Company ( or create, when Key.CompanyID = 0)

Admin User

-

CompanyApiModel

CompanyApiModel

Models

The definitions of models specific to endpoints in this module.

CompanyKey

Property

Type

Description

CompanyID

Integer

The unique Company ID of the Company

CompanyLine

Property

Type

Description

Key

CompanyKey

The unique key for the line.

CompanyId

Integer

The unique Company ID of the Company

CompanyName

String

The name of the Company.

CompanyNameValue

CellData

The name of the Company.

AlphaCode

String

The shorthand code for the Company.

AlphaCodeValue

CellData

The shorthand code for the Company.

ApAccount

String

The AP linking code to the financial system.

ApAccountValue

CellData

The AP linking code to the financial system.

ArAccount

String

The AR linking code to the financial system.

ArAccountValue

CellData

The AR linking code to the financial system.

CreditStatus

String

The Company's credit status with your organization.

CreditStatusValue

CellData

The Company's credit status with your organization.

Location

String

The location the Company has been assigned to.

LocationValue

CellData

The location the Company has been assigned to.

FinancialCompanyCode

String

The internal Financial Company this company sits under.

FinancialCompanyCodeValue

CellData

The internal Financial Company this company sits under.

CompanyType

String

The company type of this Company.

CompanyTypeValue

CellData

The company type of this Company.

Phone

String

The Phone Number of this Company.

PhoneValue

CellData

The Phone Number of this Company.

Client

Boolean

The Client flag on the Company.

Supplier

Boolean

The Supplier flag on the Company.

Subcontractor

Boolean

The Subcontractor flag on the Company.

Other

Boolean

The Other flag on the Company.

Inactive

Boolean

The Inactive flag on the Company.

GSTNumber

String

The tax identifier for the Company.

CostValue

CellData

(if GridRequestParametersApi.IntValue2 is populated with an ItemID) The Cost on the Catalogue Line

CatalogueValue

CellData

(if GridRequestParametersApi.IntValue2 is populated with an ItemID) The Name of the Catalogue

Group1

String

The Attribute Group of the first Attribute Category filter

Group2

String

The Attribute Group of the second Attribute Category filter

Group3

String

The Attribute Group of the third Attribute Category filter

UpdatedDate

DateTime

The Date this record was last updated.

CompanyApiModel

Property

Type

Description

Key

GeneralCompanyKey

Main

GeneralCompanyMainFields

Financials

GeneralCompanyFinancialsFields

People

CompanyApiGridLines_GeneralPersonLine

Attributes

CompanyApiGridLines_GeneralAttributeLine

Addresses

CompanyApiGridLines_GeneralAddressLine

Notes

CompanyApiGridLines_GeneralNoteLine

⬆️ Back to top

GeneralCompanyLine

CompanyMainFields

Property

Type

Description

CompanyId

CompanyID

Integer

StringViewData

Unique ID code

Code of the company

.

CompanyName

String

StringViewData

Company name

.

AlphaCode

String

StringViewData

The shorthand code for the company.

ApAccount

CompanyType

String

DropdownViewData

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

type of the company.

PriceCode

PickerViewData

Price code of the company.

Location

String

PickerViewData

The location

Location has been assigned to

this

company.

Branch

StringViewData

FinancialCompanyCode

FinancialCompany

String

DropdownViewData

The internal Financial Company this company sits under.

CompanyType

String

The company type of this company.

Phone

String

Phone number

ArAccount

StringViewData

The AR linking code to the financial system

ApAccount

StringViewData

The AP linking code to the financial system

Currency

PickerViewData

The default currency of the company.

CompanyReference

StringViewData

Reference.

InactiveCompany

BoolViewData

Inactive status.

Client

Boolean

BoolViewData

This company

Marked as

a client

Client or not.

Supplier

Boolean

BoolViewData

This company

Marked as

a supplier

Supplier or not.

Subcontractor

Boolean

BoolViewData

This company

Marked as

a The company is marked

Subcontractor or not.

Other

Boolean

BoolViewData

Marked as Other

type

or not.

Inactive

Boolean

The company is inactive or not.

GSTNumber

String

StringViewData

The tax identifier for the company.

Select

DefaultJobManager

CellData

CompanyNameValue

CellData

Company name.

AlphaCodeValue

CellData

The shorthand code for the company.

ApAccountValue

CellData

The AP linking code to the financial system.

ArAccountValue

CellData

The AR linking code to the financial system.

CreditStatusValue

CellData

The company's credit status is with your organization.

LocationValue

CellData

The location has been assigned to this company.

FinancialCompanyCodeValue

CellData

The internal Financial Company this company sits under.

CompanyTypeValue

CellData

The company type of this company.

PhoneValue

CellData

Phone number.

CostValue

CellData

Cost.

CatalogueValue

CellData

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

Read Only status.

ReadonlyMessage

String

Read Only message.

OriginalKey

GeneralCompanyKey

CurrentKey

GeneralCompanyKey

Key

GeneralCompanyKey

Index

Integer

⬆️ Back to top

GeneralCompanyKey

Property

Type

Description

CompanyID

Integer

Code of the company

⬆️ Back to top

GeneralCompanyMainFields

Property

Type

Description

CompanyID

StringViewData

Code of the company

CompanyName

StringViewData

Company name

AlphaCode

StringViewData

The shorthand code for the company.

CompanyType

DropdownViewData

The type of the company.

PriceCode

PickerViewData

Price code of the company.

Location

PickerViewData

Location has been assigned to company.

Branch

StringViewData

FinancialCompany

DropdownViewData

The internal Financial Company this company sits under.

ArAccount

StringViewData

The AR linking code to the financial system

ApAccount

StringViewData

The AP linking code to the financial system

Currency

PickerViewData

The default currency of the company.

CompanyReference

StringViewData

Reference.

InactiveCompany

BoolViewData

Inactive status.

Client

BoolViewData

Marked as Client or not.

Supplier

BoolViewData

Marked as Supplier or not.

Subcontractor

BoolViewData

Marked as Subcontractor or not.

Other

BoolViewData

Marked as Other or not.

GSTNumber

StringViewData

The tax identifier for the company.

DefaultJobManager

PickerViewData

Person as default Job manager.

DefaultAccountManager

PickerViewData

Person as default Account manager.

⬆️ Back to top

GeneralCompanyFinancialsFields

PickerViewData

Person as default Job manager.

DefaultAccountManager

PickerViewData

Person as default Account manager.

⬆️ Back to top

CompanyFinancialsFields

Property

Type

Description

PaymentTerms

DecimalViewData

The numerical value for days

PaymentTermsType

DropdownViewData

To nominate the payment terms for Job Sales Invoices to this company

CreditStatus

DropdownViewData

The company's credit status is with your organization

CashLimit

DecimalViewData

To nominate a cash limit.

BankAccountRef1

StringViewData

Account details.

BankAccountRef2

StringViewData

Account details.

BankAccountRef3

StringViewData

Account details.

UseGST

BoolViewData

Have tax or not.

CashOnly

BoolViewData

This company as a cash-only or not

UseBuyerCreatedInvoices

BoolViewData

Use the BCI/RCTI or not.

⬆️ Back to top

GeneralPersonLine

PersonLine

Property

Type

Description

PersonId

Integer

The unique ID of the Person

DisplayName

String

 Displayed name.

Surname

String

Family name

FirstName

String

First name

CompanyId

Integer

The company id of the person.

Company

String

The company name of this person.

Role

String

Person role.

JobTitle

String

User's official title.

EmailAddress

String

Email address.

MobilePhone

String

Mobile number

BusinessPhone

String

Working phone number

IsEmployee

Boolean

The person is an employee or not.

IsActive

Boolean

The account is active or not.

Inactive

Boolean

The account status is inactive or not.

IsBillingContact

Boolean

The person is the billing contact or not.

IsSiteContact

Boolean

The person is the Site contact or not.

IsCommercialContact

Boolean

The person is the Site Contact or not.

EmployeeNo

String

Employee code

SelectId

String

SelectTag

String

Select

CellData

PersonIdValue

CellData

Code of the person

SurnameValue

CellData

Surname of the person

FirstNameValue

CellData

First name of the person.

CompanyValue

CellData

Company of the person.

RoleValue

CellData

Person role.

JobTitleValue

CellData

User's official title.

EmailAddressValue

CellData

Person email address

MobilePhoneValue

CellData

Person mobile number

BusinessPhoneValue

CellData

Person business phone

Delete

CellData

Group1

String

The first Attribute Group.

Group2

String

The second Attribute Group.

Group3

String

The Third Attribute Group.

UpdatedDate

String

Updated date.

Status

String

 

ReadonlyFlag

Integer

ReadonlyMessage

String

OriginalKey

GeneralPersonKey

CurrentKey

GeneralPersonKey

Key

GeneralPersonKey

Index

Integer

⬆️ Back to top

Examples

Get list of first 20 companies.

Expand
titleClick to view

Request

Code Block
languagejson
Response
 Code Block
languagejson
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
 Code Block
languagejson
{
  "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.
 Expand
titleClick to view
Request
 Code Block
languagejson
Response
 Code Block
languagejson
{
  "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
 Code Block
languagejson
{
  "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
    }
  ]
}
Create a new company.
 Expand
titleClick to view
Request
 Code Block
languagejson
{
    "Key": {
        "CompanyId": 0
    },
    "Main": {
    "CompanyName": {
        "StringValue": "FromAPI"
    },
    "AlphaCode": {
        "StringValue": "AG01"
    },
    "CompanyType": {
        "SelectedValue": "DEV"
    },
    "PriceCode": {
        "SelectedValue": "NZ"
    },
    "Location": {
        "SelectedValue": "AK"
    },
    "FinancialCompany": {
        "SelectedValue": "NZ"
    },
    "ArAccount": {
        "StringValue": "01"
    },
    "ApAccount": {
        "StringValue": "02"
    },
    "Currency": {
        "SelectedValue": "NZD"
    },
    "InactiveCompany": {
        "BoolValue": false
    },
    "Client": {
        "BoolValue": false
    },
    "Supplier": {
        "BoolValue": false
    },
    "Subcontractor": {
        "BoolValue": false
    },
    "Other": {
        "BoolValue": false
    },
    "GSTNumber": {
        "StringValue": ""
    },
    "DefaultJobManager": {
        "SelectedValue": null
    },
    "DefaultAccountManager": {
        "SelectedValue": null
    }
    },
    "Financials": {
    "PaymentTerms": {
        "DecimalValue": 5
    },
    "PaymentTermsType": {
        "SelectedValue": "1",
        "DropdownList": {
        "1": "Days from invoice date",
        "2": "Day of the following month",
        "3": "Last day of the following month",
        "4": "Days after end of this month",
        "": "Select..."
        }
    },
    "CreditStatus": {
        "SelectedValue": "Credit",
        "DropdownList": {
        "": "Select...",
        "Credit": "Credit",
        "Cash": "Cash",
        "Overdue": "Overdue",
        "Stop Credit": "Stop Credit"
        }
    },
    "CashLimit": {
        "DecimalValue": 10000
    },
    "BankAccountRef1": {
        "StringValue": ""
    },
    "BankAccountRef2": {
        "StringValue": ""
    },
    "BankAccountRef3": {
        "StringValue": ""
    },
    "UseGST": {
        "BoolValue": false
    },
    "CashOnly": {
        "BoolValue": true
    },
    "UseBuyerCreatedInvoices": {
        "BoolValue": false
    }
    },
    "Attributes": {
    "Rows": []
    },
    "CompanyInsurance": {
    "Rows": []
    },
    "Addresses": {
    "Rows": [
        {
        "Inactive": false,
        "IsPostalAddress": true,
        "IsPhysicalAddress": true,
        "NameValue": {
            "CellValue": "Name"
        },
        "Line1Value": {
            "CellValue": "Line1"
        },
        "Line2Value": {
            "CellValue": "Line2"
        },
        "PhoneValue": {
            "CellValue": "Phone"
        },
        "PostCodeValue": {
            "CellValue": "Post Code"
        },
        "Changed": false,
        "OriginalKey": {
            "AddressId": 0
        },
        "CurrentKey": {
            "AddressId": 0
        },
        "Key": {
            "AddressId": 0
        },
        "IsNew": true,
        "Index": 1
        }
    ]
    }
}
Response
 Code Block
languagejson
Response sample
 Code Block
languagejson
⬆️ Back to top
On this page
 Table of Contents
minLevel1
maxLevel3
outlinefalse
typelist
separatorbrackets
printablefalse
 Include Page
KB1:How-to footer
KB1:How-to footer