AR
ARCustomerBalanceEnq.ARHistoryResult
PX.Objects.AR40 of 40 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AcctCD | nvarchar(30) | Customer ID | - | |
Description:No description available | ||||
CuryID | nvarchar(5) | Currency | - | |
Description:No description available | ||||
AcctName | nvarchar(60) | Customer 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 | ||||
COGS | decimal | PTD COGS | - | |
Description:No description available | ||||
Converted | bit | Converted to Base Currency | - | |
Description:No description available | ||||
CrAdjustmentsNonexistent in DB | decimal | PTD Credit Memos | - | |
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 Memos | - | |
Description:No description available | ||||
CuryDeposits | decimal | Currency PTD Prepayments | - | |
Description:No description available | ||||
CuryDepositsBalance | decimal | Currency Prepayments Balance | - | |
Description:No description available | ||||
CuryDiscount | decimal | Currency PTD Cash Discount Taken | - | |
Description:No description available | ||||
CuryDrAdjustments | decimal | Currency PTD Debit Memos | - | |
Description:No description available | ||||
CuryEndBalance | decimal | Currency Ending Balance | - | |
Description:No description available | ||||
CuryEndRetainedBalance | decimal | Currency Ending Retained Balance | - | |
Description:No description available | ||||
CuryFinCharges | decimal | Currency PTD Overdue Charges | - | |
Description:No description available | ||||
CuryPayments | decimal | Currency PTD Payments | - | |
Description:No description available | ||||
CuryRetainageReleased | decimal | Currency PTD Retainage Released | - | |
Description:No description available | ||||
CuryRetainageWithheld | decimal | Currency PTD Retainage Withheld | - | |
Description:No description available | ||||
CurySales | decimal | Currency PTD Sales | - | |
Description:No description available | ||||
CustomerID | int | - | ||
Description:No description available | ||||
DepositsNonexistent in DB | decimal | PTD Prepayments | - | |
Description:No description available | ||||
DepositsBalanceNonexistent in DB | decimal | Prepayments Balance | - | |
Description:No description available | ||||
DiscountNonexistent in DB | decimal | PTD Cash Discount Taken | - | |
Description:No description available | ||||
DrAdjustmentsNonexistent in DB | decimal | PTD Debit Memos | - | |
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 | ||||
FinCharges | decimal | PTD Overdue Charges | - | |
Description:No description available | ||||
FinPeriodID | char(6) | Last Activity Period | - | |
Description:No description available | ||||
FinPtdRevaluated | decimal | Unrealized Gain/Loss | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
PaymentsNonexistent in DB | decimal | PTD Payments | - | |
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 | ||||
SalesNonexistent in DB | decimal | PTD Sales | - | |
Description:No description available | ||||