Skip to main content

ARHistoricalData

ARHistoricalData. Represents the AR history balances per branch, account, currency, customer and financial period. Disabled in Production while testing is in progress. The schema remains documented for reference; the ARHistoricalData ETL is not available for Production use.

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