BranchId | Branch | Lookup → Branch | | |
BusinessUnitId | Business Unit | Lookup → BusinessUnit | | |
CostCenterId | Cost Center | Lookup → CostCenter | | Cost-centre allocation for the line, mirroring the same dimension on journal lines and period balances so a projection can in principle be compared with cost-centre actuals. Note that the cash-flow forecast filters lines only by branch, business unit and GST registration, and the projected income statement does not scope by cost centre at all, so this is stored for analysis rather than acted on today. |
CreatedById | Created By | Lookup → UserAccount | Yes | |
CreatedDateTime | CreatedDateTime | DateAndTime | Yes | |
ExpectedCollectionDate | ExpectedCollectionDate | Date | | When the cash is expected to actually arrive (or leave, for expense projections) — the only line date the cash-flow forecast reads. A line with this left null is excluded from the forecast pipeline altogether, no matter how well populated its amounts are. |
ExpectedInvoiceDate | ExpectedInvoiceDate | Date | | When the line is expected to be billed. It captures billing intent for review and reporting; the first-party projected income statement and cash-flow forecast bucket on the collection date instead, so this date alone will not move money in either output. |
ExpectedRevenueDate | ExpectedRevenueDate | Date | | When the line is expected to be recognised in the profit and loss. It records the intended revenue period, but the projected income statement aggregates the whole projection rather than phasing by this date, so it does not by itself place the amount in a particular month. |
FinancialProjectionId | Financial Projection | Lookup → FinancialProjection | | |
FiscalPeriodId | Fiscal Period | Lookup → FiscalPeriod | | Optional accounting period for a period-phased plan. It is stored for analysis; the projected income statement does not split its columns by it, so phasing a projection across periods here does not produce a month-by-month projected profit and loss. |
GLAccountId | GL Account | Lookup → GLAccount | | The P&L account the projected amount rolls up to, and effectively mandatory: the projected income statement selects only lines that have one, so a customer-level line left without an account is forecast in cash-flow terms yet contributes nothing to the projected profit and loss. |
GSTRegistrationId | GST Registration | Lookup → GSTRegistration | | |
Id | Id | Guid | Yes | |
ItemId | Item | Lookup → Item | | |
ModifiedById | Modified By | Lookup → UserAccount | Yes | |
Name | Name | Text | Yes | |
OwnerId | Owner | Lookup → UserAccount | Yes | |
PartnerAccountId | Partner Account | Lookup → Account | | The owning company, duplicated from the header onto the line. Do not confuse it with PartyAccountId: this is the legal entity whose forecast this is, while the counterparty being billed or paid is the party account. |
PartyAccountId | Party Account | Lookup → Account | | The customer or supplier this line is expected to be transacted with — the counterparty, distinct from PartnerAccountId which holds the company doing the forecasting. It gives the line invoice-level granularity; leave it null for a purely account-level plan line. |
ProbabilityPercent | ProbabilityPercent | Percent | | Confidence in the line expressed as a whole percentage (100 means certain), not a fraction. It is used as the multiplier when WeightedAmount has not been stored, defaulting to 100 when null, and it also surfaces as the statement's Probability % column, which is derived as weighted divided by projected rather than read straight from here. |
ProjectedAmount | ProjectedAmount | Currency | | The expected gross or pre-tax value of the line, recorded for reference. Neither the projected income statement nor the cash-flow forecast reads it — both work from ProjectedNetAmount — so a line with only this populated will forecast as zero. |
ProjectedNetAmount | ProjectedNetAmount | Currency | | The operative figure. The projected income statement sums it per GL account for the full-value projection column, and the cash-flow forecast multiplies it by the probability when no weighted amount is stored. A line with a zero or null net amount is skipped entirely by the projected profit and loss. |
ProjectedTaxAmount | ProjectedTaxAmount | Currency | | Expected tax component of the line, held alongside the gross and net figures. Like ProjectedAmount it is descriptive: the forecasting services never add it to or subtract it from the amounts they report. |
ProjectId | Project | Lookup → Project | | |
RecordTypeId | RecordTypeId | Guid | | |
ReferenceId | ReferenceId | Guid | | Identifier of the originating record within the entity named by ReferenceType. |
ReferenceType | ReferenceType | Text | | Free-text name of the entity the projection line was derived from — an opportunity or a contract, for example. It pairs with ReferenceId as a soft, unenforced back-pointer with no foreign key behind it. |
Remarks | Remarks | Text | | |
Status | Status | Text | | |
UIProps | UIProps | Text | | |
UpdatedDateTime | UpdatedDateTime | DateAndTime | Yes | |
WeightedAmount | WeightedAmount | Currency | | The probability-adjusted value, conceptually net amount multiplied by probability divided by one hundred. |
