Skip to main content

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