Skip to main content

ARHistoricalData

ARHistoricalData. Represents the AR history balances per branch, account, currency, customer and financial period.

type ARHistoricalData {
  branchId: Int!
  accountId: Int!
  subaccountId: Int!
  currencyId: String!
  customerId: Int!
  finPeriodId: String!
  beginningBalance: Decimal!
  endingBalance: Decimal!
  beginningBalanceInCurrency: Decimal!
  endingBalanceInCurrency: Decimal!
  detailDeleted: Boolean!
  companyId: Int!
  id: String!
  createdInDataMartDateTime: DateTime!
  updatedInDataMartDateTime: DateTime!
}

Fields

`ARHistoricalData.branchId` ● `Int!` non-null scalar

branchId > (PK) The unique identifier of the branch.

`ARHistoricalData.accountId` ● `Int!` non-null scalar

accountId > (PK) The unique identifier of the general ledger account associated with the AR history record.

`ARHistoricalData.subaccountId` ● `Int!` non-null scalar

subaccountId > (PK) The unique identifier of the subaccount used for the AR history record.

`ARHistoricalData.currencyId` ● `String!` non-null scalar

currencyId > (PK) The currency identifier of the AR history record.

`ARHistoricalData.customerId` ● `Int!` non-null scalar

customerId > (PK) The unique identifier of the customer business account.

`ARHistoricalData.finPeriodId` ● `String!` non-null scalar

finPeriodId > (PK) The financial period identifier of the AR history record.

`ARHistoricalData.beginningBalance` ● `Decimal!` non-null scalar

beginningBalance > The base-currency financial beginning balance for this currency and period.

`ARHistoricalData.endingBalance` ● `Decimal!` non-null scalar

endingBalance > The base-currency financial year-to-date balance for this currency and period.

`ARHistoricalData.beginningBalanceInCurrency` ● `Decimal!` non-null scalar

beginningBalanceInCurrency > The currency-denominated beginning balance of the AR history record for the period.

`ARHistoricalData.endingBalanceInCurrency` ● `Decimal!` non-null scalar

endingBalanceInCurrency > The currency-denominated year-to-date balance of the AR history record at the end of the period.

`ARHistoricalData.detailDeleted` ● `Boolean!` non-null scalar

detailDeleted > Indicates whether the ERP history detail is marked as deleted.

`ARHistoricalData.companyId` ● `Int!` non-null scalar

companyId > (PK) The unique identifier of the company.

`ARHistoricalData.id` ● `String!` non-null scalar

id > The unique identifier of the document in DataMart.

`ARHistoricalData.createdInDataMartDateTime` ● `DateTime!` non-null scalar

createdInDataMartDateTime > The UTC DateTime when this document has been added to DataMart.

`ARHistoricalData.updatedInDataMartDateTime` ● `DateTime!` non-null scalar

updatedInDataMartDateTime > The UTC DateTime when this document has been updated in DataMart.

Returned By

arHistoricalData query

Fields
Returned By