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