AR
ARHistoryByPeriod
A projection DAC over CuryARHistory that is intended to close the gaps in AR history records. (The gaps in AR history records appear if AR history records do not exist for every financial period defined in the system.) That is, the purpose of this DAC is to calculate the last activity period for every existing financial period, so that inquiries and reports that produce information for a given financial period can look at the latest available CuryARHistory record. For example, this projection is used in the Customer Summary (AR401000) form, which corresponds to the ARCustomerBalanceEnq graph.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AccountID | int | Account | Account | |
Description:No description available | ||||
BranchID | int | Branch | - | |
Description:No description available | ||||
CuryID | nvarchar(5) | - | ||
Description:No description available | ||||
CustomerID | int | Customer | BAccountR | |
Description:No description available | ||||
FinPeriodID | string | - | ||
Description:No description available | ||||
LastActivityPeriod | string | - | ||
Description:No description available | ||||
SubID | int | Subaccount | Sub | |
Description:No description available | ||||