Skip to main content

APHistoricalData

APHistoricalData. Represents the AP history balances per branch, account, subaccount, currency, supplier and financial period. Rows exist only for periods with activity: for period P, read the latest row at or before P with the same company, branch, account, subaccount, currency and supplier.

type APHistoricalData {
branchId: Int!
accountId: Int!
subaccountId: Int!
currencyId: String!
supplierId: Int!
finPeriodId: String!
beginningBalance: Decimal!
endingBalance: Decimal!
beginningBalanceInCurrency: Decimal!
endingBalanceInCurrency: Decimal!
revaluedGainLoss: Decimal!
endingPrepaymentBalance: Decimal!
endingPrepaymentBalanceInCurrency: Decimal!
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.endingPrepaymentBalance ● Decimal! non-null scalar​

endingPrepaymentBalance > The base-currency amount of open prepayments to the supplier at the end of the period, for this currency. It is not included in endingBalance; the supplier balance in ERP reports is endingBalance - endingPrepaymentBalance.

APHistoricalData.endingPrepaymentBalanceInCurrency ● Decimal! non-null scalar​

endingPrepaymentBalanceInCurrency > The same open-prepayment amount in the currency of the history record; compare with endingBalanceInCurrency.

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