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).
Name | Type | Display Name | Foreign Reference | |
---|---|---|---|---|
AccountID | int | Account | ||
BranchID | int | Branch | ||
FinPeriodID | char(6) | |||
SubID | int | Sub | ||
VendorID | int | Vendor ID | Vendor | |
DetDeleted | bit | |||
FinBegBalance | decimal(19, 4) | |||
FinFlag Nonexistent in DB | bit | |||
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 |