APHistoricalDataPeriodBalance
One financial period of a supplier history group, produced by apHistoricalDataForwardByGroup. A carried period repeats the last known ending balances; see hasActivity.
type APHistoricalDataPeriodBalance {
hasActivity: Boolean!
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
APHistoricalDataPeriodBalance.hasActivity ● Boolean! non-null scalar
hasActivity > True when ERP has a history row for this period. False when the period is carried forward from the last period with activity: beginningBalance equals endingBalance, revaluedGainLoss is 0 and the ending balances repeat the last real row.
APHistoricalDataPeriodBalance.branchId ● Int! non-null scalar
branchId > (PK) The unique identifier of the branch.
APHistoricalDataPeriodBalance.accountId ● Int! non-null scalar
accountId > (PK) The unique identifier of the general ledger account associated with the AP history record.
APHistoricalDataPeriodBalance.subaccountId ● Int! non-null scalar
subaccountId > (PK) The unique identifier of the subaccount used for the AP history record.
APHistoricalDataPeriodBalance.currencyId ● String! non-null scalar
currencyId > (PK) The currency identifier of the AP history record.
APHistoricalDataPeriodBalance.supplierId ● Int! non-null scalar
supplierId > (PK) The unique identifier of the supplier business account.
APHistoricalDataPeriodBalance.finPeriodId ● String! non-null scalar
finPeriodId > (PK) The financial period identifier of the AP history record.
APHistoricalDataPeriodBalance.beginningBalance ● Decimal! non-null scalar
beginningBalance > The base-currency financial beginning balance for this currency and period.
APHistoricalDataPeriodBalance.endingBalance ● Decimal! non-null scalar
endingBalance > The base-currency financial year-to-date balance for this currency and period.
APHistoricalDataPeriodBalance.beginningBalanceInCurrency ● Decimal! non-null scalar
beginningBalanceInCurrency > The currency-denominated beginning balance of the AP history record for the period.
APHistoricalDataPeriodBalance.endingBalanceInCurrency ● Decimal! non-null scalar
endingBalanceInCurrency > The currency-denominated year-to-date balance of the AP history record at the end of the period.
APHistoricalDataPeriodBalance.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.
APHistoricalDataPeriodBalance.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.
APHistoricalDataPeriodBalance.endingPrepaymentBalanceInCurrency ● Decimal! non-null scalar
endingPrepaymentBalanceInCurrency > The same open-prepayment amount in the currency of the history record; compare with endingBalanceInCurrency.
APHistoricalDataPeriodBalance.companyId ● Int! non-null scalar
companyId > (PK) The unique identifier of the company.
APHistoricalDataPeriodBalance.id ● String! non-null scalar
id > The unique identifier of the document in DataMart.
APHistoricalDataPeriodBalance.createdInDataMartDateTime ● DateTime! non-null scalar
createdInDataMartDateTime > The UTC DateTime when this document has been added to DataMart.
APHistoricalDataPeriodBalance.updatedInDataMartDateTime ● DateTime! non-null scalar
updatedInDataMartDateTime > The UTC DateTime when this document has been updated in DataMart.
Member Of
APHistoricalDataForwardPage object