AR
ARHistoryYtd
No summary is documented for this DAC in the release source.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AccountID | int | Account | ||
Description:Corresponds to the Account.AccountID field. | ||||
BegBalanceNonexistent in DB | decimal? | - | ||
Description:If FinFlag is "true", represents the FinBegBalance field. If FinFlag is "false", represents the field. | ||||
BranchID | int | Branch | ||
Description:A reference to the Branch to which the history belongs. This field is a key field. Corresponds to the Branch.BranchID field. | ||||
CustomerID | int | Customer ID | Customer | |
Description:A reference to the Customer to which the history belongs. This field is a key field. Corresponds to the Customer.CustomerID field. | ||||
DetDeleted | bit | - | ||
Description:A Boolean field that indicates (if set to "true") that the documents that are related to this record have been deleted (archived). | ||||
FinBegBalance | decimal | - | ||
Description:The beginning balance of documents for the FinPeriodID period (which is related to the ARRegister.FinPeriodID field). The amount is specified in the base currency of the company. | ||||
FinFlagNonexistent in DB | bool? | - | ||
Description:When "true", indicates that the fields with 'Fin' prefix should be used. When "false", indicates that the fields with 'Tran' prefix should be used. | ||||
FinPeriodID | string | - | ||
Description:A reference to the Obsolete.FinPeriod to which the history belongs. This field is a key field. Corresponds to the FinPeriod.FinPeriodID field. | ||||
FinPtdCOGS | decimal | - | ||
Description:The period-to-date cost of goods that are sold during the FinPeriodID period (which is related to the ARRegister.FinPeriodID field). The value is specified in the base currency of the company. | ||||
FinPtdCrAdjustments | decimal | - | ||
Description:The period-to-date amount of credit adjustments for the FinPeriodID period (which is related to the ARRegister.FinPeriodID field). The amount is specified in the base currency of the company. The sign of the amount is taken from . | ||||
FinPtdDeposits | decimal | - | ||
Description:The period-to-date amount of deposits for the FinPeriodID period (which is related to the ARRegister.FinPeriodID field). The amount is specified in the base currency of the company. The sign of the amount is taken from . | ||||
FinPtdDiscounts | decimal | - | ||
Description:The period-to-date amount of discounts for the FinPeriodID period (which is related to the ARRegister.FinPeriodID field). The amount is specified in the base currency of the company. The sign of the amount is taken from . | ||||
FinPtdDrAdjustments | decimal | - | ||
Description:The period-to-date amount of debit adjustments for the FinPeriodID period (which is related to the ARRegister.FinPeriodID field). The amount is specified in the base currency of the company. The sign of the amount is taken from . | ||||
FinPtdFinCharges | decimal | - | ||
Description:The period-to-date amount of financial charges for the FinPeriodID period (which is related to the ARRegister.FinPeriodID field). The amount is specified in the base currency of the company. The sign of the amount is taken from . | ||||
FinPtdItemDiscounts | decimal | - | ||
Description:The period-to-date amount of item discounts for the FinPeriodID period (which is related to the ARRegister.FinPeriodID field). The amount is specified in the base currency of the company. The sign of the amount is taken from . | ||||
FinPtdPayments | decimal | - | ||
Description:The period-to-date amount of payments for the FinPeriodID period (which is related to the ARRegister.FinPeriodID field). The amount is specified in the base currency of the company. The sign of the amount is taken from . | ||||
FinPtdRGOL | decimal | - | ||
Description:The period-to-date amount of realized gains or losses for the FinPeriodID period (which is related to the ARRegister.FinPeriodID field). The amount is specified in the base currency of the company. The sign of the amount is taken from . | ||||
FinPtdRetainageReleased | decimal | - | ||
Description:No description available | ||||
FinPtdRetainageWithheld | decimal | - | ||
Description:No description available | ||||
FinPtdRevalued | decimal | - | ||
Description:The period-to-date amount of item discounts for the FinPeriodID period (which is related to the ARRegister.FinPeriodID field). The amount is specified in the base currency of the company. | ||||
FinPtdSales | decimal | - | ||
Description:The period-to-date amount of sales for the FinPeriodID period (which is related to the ARRegister.FinPeriodID field). The amount is specified in the base currency of the company. The sign of the amount is taken from . | ||||
FinYtdBalance | decimal | - | ||
Description:The year-to-date balance of documents for the FinPeriodID period (which is related to the ARRegister.FinPeriodID field). The amount is specified in the base currency of the company. The sign of the amount is taken from . | ||||
FinYtdDeposits | decimal | - | ||
Description:The year-to-date amount of deposits for the FinPeriodID period (which is related to the ARRegister.FinPeriodID field). The amount is specified in the base currency of the company. The sign of the amount is taken from . | ||||
FinYtdRetainageReleased | decimal | - | ||
Description:No description available | ||||
FinYtdRetainageWithheld | decimal | - | ||
Description:No description available | ||||
NumberInvoicePaid | int | - | ||
Description:The field is not used. | ||||
PaidInvoiceDays | smallint | - | ||
Description:The field is not used. | ||||
PtdCOGSNonexistent in DB | decimal? | - | ||
Description:If FinFlag is "true", represents the FinPtdCOGS field. If FinFlag is "false", represents the field. | ||||
PtdCrAdjustmentsNonexistent in DB | decimal? | - | ||
Description:If FinFlag is "true", represents the FinPtdCrAdjustments field. If FinFlag is "false", represents the field. | ||||
PtdDepositsNonexistent in DB | decimal? | - | ||
Description:If FinFlag is "true", represents the FinPtdDeposits field. If FinFlag is "false", represents the field. | ||||
PtdDiscountsNonexistent in DB | decimal? | - | ||
Description:If FinFlag is "true", represents the FinPtdDiscounts field. If FinFlag is "false", represents the field. | ||||
PtdDrAdjustmentsNonexistent in DB | decimal? | - | ||
Description:If FinFlag is "true", represents the FinPtdDrAdjustments field. If FinFlag is "false", represents the field. | ||||
PtdFinChargesNonexistent in DB | decimal? | - | ||
Description:If FinFlag is "true", represents the FinPtdFinCharges field. If FinFlag is "false", represents the field. | ||||
PtdItemDiscountsNonexistent in DB | decimal? | - | ||
Description:If FinFlag is "true", represents the FinPtdItemDiscounts field. If FinFlag is "false", represents the field. | ||||
PtdPaymentsNonexistent in DB | decimal? | - | ||
Description:If FinFlag is "true", represents the FinPtdPayments field. If FinFlag is "false", represents the field. | ||||
PtdRGOLNonexistent in DB | decimal? | - | ||
Description:If FinFlag is "true", represents the FinPtdRGOL field. If FinFlag is "false", represents the field. | ||||
PtdRetainageReleasedNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
PtdRetainageWithheldNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
PtdSalesNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
SubID | int | Sub | ||
Description:A reference to the Sub to which the history belongs. This field is a key field. Corresponds to the Sub.SubID field. | ||||
TranBegBalance | decimal | - | ||
Description:The beginning balance of documents for the FinPeriodID period (which is related to the ARRegister.TranPeriodID field). The amount is specified in the base currency of the company. | ||||
TranPtdCOGS | decimal | - | ||
Description:The period-to-date cost of goods that are sold during the FinPeriodID period (which is related to the ARRegister.TranPeriodID field). The value is specified in the base currency of the company. | ||||
TranPtdCrAdjustments | decimal | - | ||
Description:The period-to-date amount of credit adjustments for the FinPeriodID period (which is related to the ARRegister.TranPeriodID field). The amount is specified in the base currency of the company. The sign of the amount is taken from . | ||||
TranPtdDeposits | decimal | - | ||
Description:The period-to-date amount of deposits for the FinPeriodID period (which is related to the ARRegister.TranPeriodID field). The amount is specified in the base currency of the company. The sign of the amount is taken from . | ||||
TranPtdDiscounts | decimal | - | ||
Description:The period-to-date amount of discounts for the FinPeriodID period (which is related to the ARRegister.TranPeriodID field). The amount is specified in the base currency of the company. The sign of the amount is taken from . | ||||
TranPtdDrAdjustments | decimal | - | ||
Description:The period-to-date amount of debit adjustments for the FinPeriodID period (which is related to the ARRegister.TranPeriodID field). The amount is specified in the base currency of the company. The sign of the amount is taken from . | ||||
TranPtdFinCharges | decimal | - | ||
Description:The period-to-date amount of financial charges for the FinPeriodID period (which is related to the ARRegister.TranPeriodID field). The amount is specified in the base currency of the company. The sign of the amount is taken from . | ||||
TranPtdItemDiscounts | decimal | - | ||
Description:The period-to-date amount of item discounts for the FinPeriodID period (which is related to the ARRegister.TranPeriodID field). The amount is specified in the base currency of the company. The sign of the amount is taken from . | ||||
TranPtdPayments | decimal | - | ||
Description:The period-to-date amount of payments for the FinPeriodID period (which is related to the ARRegister.TranPeriodID field). The amount is specified in the base currency of the company. The sign of the amount is taken from . | ||||
TranPtdRGOL | decimal | - | ||
Description:The period-to-date amount of realized gains or losses for the FinPeriodID period (which is related to the ARRegister.TranPeriodID field). The amount is specified in the base currency of the company. The sign of the amount is taken from . | ||||
TranPtdRetainageReleased | decimal | - | ||
Description:No description available | ||||
TranPtdRetainageWithheld | decimal | - | ||
Description:No description available | ||||
TranPtdSales | decimal | - | ||
Description:The period-to-date amount of sales for the FinPeriodID period (which is related to the ARRegister.TranPeriodID field). The amount is specified in the base currency of the company. The sign of the amount is taken from . | ||||
TranYtdBalance | decimal | - | ||
Description:The year-to-date balance of documents for the FinPeriodID period (which is related to the ARRegister.TranPeriodID field). The amount is specified in the base currency of the company. The sign of the amount is taken from . | ||||
TranYtdDeposits | decimal | - | ||
Description:The year-to-date amount of deposits for the FinPeriodID period (which is related to the ARRegister.TranPeriodID field). The amount is specified in the base currency of the company. The sign of the amount is taken from . | ||||
TranYtdRetainageReleased | decimal | - | ||
Description:No description available | ||||
TranYtdRetainageWithheld | decimal | - | ||
Description:No description available | ||||
YtdBalanceNonexistent in DB | decimal? | - | ||
Description:If FinFlag is "true", represents the FinYtdBalance field. If FinFlag is "false", represents the field. | ||||
YtdDepositsNonexistent in DB | decimal? | - | ||
Description:If FinFlag is "true", represents the FinYtdDeposits field. If FinFlag is "false", represents the field. | ||||
YtdRetainageReleasedNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
YtdRetainageWithheldNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||