AP
APVendorBalanceEnq.APHistoryResult
PX.Objects.AP38 of 38 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AcctCD | nvarchar(30) | Vendor ID | - | |
Description:No description available | ||||
AcctName | nvarchar(60) | Vendor Name | - | |
Description:No description available | ||||
BalanceNonexistent in DB | decimal | Balance | - | |
Description:No description available | ||||
BegBalanceNonexistent in DB | decimal | Beginning Balance | - | |
Description:No description available | ||||
BegRetainedBalanceNonexistent in DB | decimal | Beginning Retained Balance | - | |
Description:No description available | ||||
Converted | bit | Converted to Base Currency | - | |
Description:No description available | ||||
CrAdjustmentsNonexistent in DB | decimal | PTD Credit Adjustments | - | |
Description:No description available | ||||
CuryBalance | decimal | Currency Balance | - | |
Description:No description available | ||||
CuryBegBalance | decimal | Currency Beginning Balance | - | |
Description:No description available | ||||
CuryBegRetainedBalance | decimal | Currency Beginning Retained Balance | - | |
Description:No description available | ||||
CuryCrAdjustments | decimal | Currency PTD Credit Adjustments | - | |
Description:No description available | ||||
CuryDeposits | decimal | Currency PTD Prepayments | - | |
Description:No description available | ||||
CuryDepositsBalance | decimal | Currency Prepayment Balance | - | |
Description:No description available | ||||
CuryDiscount | decimal | Currency PTD Cash Discount Taken | - | |
Description:No description available | ||||
CuryDrAdjustments | decimal | Currency PTD Debit Adjustments | - | |
Description:No description available | ||||
CuryEndBalance | decimal | Currency Ending Balance | - | |
Description:No description available | ||||
CuryEndRetainedBalance | decimal | Currency Ending Retained Balance | - | |
Description:No description available | ||||
CuryID | nvarchar(5) | Currency | - | |
Description:No description available | ||||
CuryPayments | decimal | Currency PTD Payments | - | |
Description:No description available | ||||
CuryPurchases | decimal | Currency PTD Purchases | - | |
Description:No description available | ||||
CuryRetainageReleased | decimal | Currency PTD Retainage Released | - | |
Description:No description available | ||||
CuryRetainageWithheld | decimal | Currency PTD Retainage Withheld | - | |
Description:No description available | ||||
CuryWhTax | decimal | Currency PTD Tax Withheld | - | |
Description:No description available | ||||
DepositsNonexistent in DB | decimal | PTD Prepayments | - | |
Description:No description available | ||||
DepositsBalanceNonexistent in DB | decimal | Prepayment Balance | - | |
Description:No description available | ||||
DiscountNonexistent in DB | decimal | PTD Cash Discount Taken | - | |
Description:No description available | ||||
DrAdjustmentsNonexistent in DB | decimal | PTD Debit Adjustments | - | |
Description:No description available | ||||
EndBalanceNonexistent in DB | decimal | Ending Balance | - | |
Description:No description available | ||||
EndRetainedBalanceNonexistent in DB | decimal | Ending Retained Balance | - | |
Description:No description available | ||||
FinPeriodID | char(6) | Last Activity Period | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
PaymentsNonexistent in DB | decimal | PTD Payments | - | |
Description:No description available | ||||
PurchasesNonexistent in DB | decimal | PTD Purchases | - | |
Description:No description available | ||||
RetainageReleasedNonexistent in DB | decimal | PTD Retainage Released | - | |
Description:No description available | ||||
RetainageWithheldNonexistent in DB | decimal | PTD Retainage Withheld | - | |
Description:No description available | ||||
RGOLNonexistent in DB | decimal | PTD Realized Gain/Loss | - | |
Description:No description available | ||||
VendorID | int | - | ||
Description:No description available | ||||
WhTaxNonexistent in DB | decimal | PTD Tax Withheld | - | |
Description:No description available | ||||