DAC Schema Browser
No entries have been found for the
Display Name: AP History
Namespace: PX.Objects.AP
Primary Screens:
Summary

An accounts payable history record, which accumulates a number of important year-to-date and period-to-date amounts (such as purchases, debit and credit adjustments, gains and losses) in base currency. The history is accumulated separately across the following dimensions: branch, GL account, GL subaccount, financial period, and vendor. History records are created and updated during the document release process (see APDocumentRelease graph). Various helper projections over this DAC are used in a number of AR inquiry forms and reports, such as Vendor Summary (AP401000).

Remarks

Fields
NameTypeDisplay NameForeign Reference
AccountID intAccount
BranchID intBranch
FinPeriodID char(6)
SubID intSub
VendorID Default NavigationintVendor IDVendor
DetDeleted bit
FinBegBalance decimal(19, 4)
FinFlag Nonexistent in DBbit
FinPtdCrAdjustments decimal(19, 4)
FinPtdDeposits decimal(19, 4)
FinPtdDiscTaken decimal(19, 4)
FinPtdDrAdjustments decimal(19, 4)
FinPtdPayments decimal(19, 4)
FinPtdPurchases decimal(19, 4)
FinPtdRetainageReleased decimal(19, 4)
FinPtdRetainageWithheld decimal(19, 4)
FinPtdRevalued decimal(19, 4)PTD Revalued Amount
FinPtdRGOL decimal(19, 4)
FinPtdWhTax decimal(19, 4)
FinYtdBalance decimal(19, 4)
FinYtdDeposits decimal(19, 4)
FinYtdRetainageReleased decimal(19, 4)
FinYtdRetainageWithheld decimal(19, 4)
TranBegBalance decimal(19, 4)
TranPtdCrAdjustments decimal(19, 4)
TranPtdDeposits decimal(19, 4)
TranPtdDiscTaken decimal(19, 4)
TranPtdDrAdjustments decimal(19, 4)
TranPtdPayments decimal(19, 4)
TranPtdPurchases decimal(19, 4)
TranPtdRetainageReleased decimal(19, 4)
TranPtdRetainageWithheld decimal(19, 4)
TranPtdRGOL decimal(19, 4)
TranPtdWhTax decimal(19, 4)
TranYtdBalance decimal(19, 4)
TranYtdDeposits decimal(19, 4)
TranYtdRetainageReleased decimal(19, 4)
TranYtdRetainageWithheld decimal(19, 4)
tstamp timestamp
Incoming References
The DAC contains no incoming references
Outgoing References
Child Key FieldsParent DACParent Key Fields
AccountID AccountAccountID
BranchID BranchBranchID
SubID SubSubID
VendorID VendorBAccountID