AP
APHistoryByPeriod
A projection DAC over CuryAPHistory that is intended to close the gaps in AP history records. (The gaps in AP history records appear if AP 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 CuryAPHistory record. For example, this projection is used in the Vendor Summary (AP401000) inquiry, which corresponds to the APVendorBalanceEnq 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 | ||||
FinPeriodID | string | - | ||
Description:No description available | ||||
LastActivityPeriod | string | - | ||
Description:No description available | ||||
SubID | int | Subaccount | Sub | |
Description:No description available | ||||
VendorID | int | Vendor | BAccountR | |
Description:No description available | ||||