Magidoc

CashForecastBankCashAccount
Object

One GL cash account's position at the bank, beside the same account's position in the books.

Stated per GL account rather than per bank account because that is the unit the anchor rule and the books balance are both stated at: two bank accounts mapped to one GL account hold one position between them.

Fields

#

glAccountId

ID !
Non-null

glAccountName

Non-null

bankAccountNames

[String !]!
Non-null

The bank accounts whose balances this row sums.

asOf

Non-null

The oldest contributing balance's own stamp — a row is never fresher than its stalest part.

isFresh

Non-null

Whether that stamp still falls inside the window a balance is trusted to describe today's cash.

currentBalance

Non-null

availableBalance

Null unless every contributing account states one: a sum over some of them is not a balance.

bankBalance

Non-null

What the bank says is there — the available balance where it states one, else the current.

booksCashBalance

Non-null

The posted GL balance of the account, as of the forecast's own day.

gapVsBooks

Non-null

Bank less books, unexplained by design: payments the books posted in the last few days may not have reached the bank, and bank items Hive has not imported sit on the other side. Explaining it means matching rows, which this rail exists to do without.

pendingIn

Non-null

Pending money the bank is holding for this account, in and out. Displayed, never projected.

pendingOut

Non-null

openingCash

Non-null

The position this account contributes to the projection's opening cash, and which figure it is.

anchor

Non-null

Usages

#

References

#