Skip to main content

APHistoricalData

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

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

Fields​

APHistoricalData.branchId ● Int! non-null scalar​

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

APHistoricalData.accountId ● Int! non-null scalar​

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

APHistoricalData.subaccountId ● Int! non-null scalar​

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

APHistoricalData.currencyId ● String! non-null scalar​

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

APHistoricalData.supplierId ● Int! non-null scalar​

supplierId > (PK) The unique identifier of the supplier business account.

APHistoricalData.finPeriodId ● String! non-null scalar​

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

APHistoricalData.beginningBalance ● Decimal! non-null scalar​

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

APHistoricalData.endingBalance ● Decimal! non-null scalar​

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

APHistoricalData.beginningBalanceInCurrency ● Decimal! non-null scalar​

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

APHistoricalData.endingBalanceInCurrency ● Decimal! non-null scalar​

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

APHistoricalData.revaluedGainLoss ● Decimal! non-null scalar​

revaluedGainLoss > The base-currency period-to-date revaluation gain/loss for this currency and period. Base currency only; the ERP has no currency-denominated mirror.

APHistoricalData.detailDeleted ● Boolean! non-null scalar​

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

APHistoricalData.companyId ● Int! non-null scalar​

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

APHistoricalData.id ● String! non-null scalar​

id > The unique identifier of the document in DataMart.

APHistoricalData.createdInDataMartDateTime ● DateTime! non-null scalar​

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

APHistoricalData.updatedInDataMartDateTime ● DateTime! non-null scalar​

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

Returned By​

apHistoricalData query