AR
ARHistory
PX.Objects.AR45 of 45 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AccountID | int | Account | ||
Description:Corresponds to the Account.AccountID 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. | ||||
FinPeriodID | char(6) | - | ||
Description:A reference to the Obsolete.FinPeriod to which the history belongs. This field is a key field. Corresponds to the FinPeriod.FinPeriodID field. | ||||
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. | ||||
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(19, 4) | - | ||
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 | bit | - | ||
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. | ||||
FinPtdCOGS | decimal(19, 4) | - | ||
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(19, 4) | - | ||
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(19, 4) | - | ||
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(19, 4) | - | ||
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(19, 4) | - | ||
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(19, 4) | - | ||
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(19, 4) | - | ||
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(19, 4) | - | ||
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 . | ||||
FinPtdRetainageReleased | decimal(19, 4) | - | ||
Description:No description available | ||||
FinPtdRetainageWithheld | decimal(19, 4) | - | ||
Description:No description available | ||||
FinPtdRevalued | decimal(19, 4) | - | ||
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. | ||||
FinPtdRGOL | decimal(19, 4) | - | ||
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 . | ||||
FinPtdSales | decimal(19, 4) | - | ||
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(19, 4) | - | ||
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(19, 4) | - | ||
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(19, 4) | - | ||
Description:No description available | ||||
FinYtdRetainageWithheld | decimal(19, 4) | - | ||
Description:No description available | ||||
NumberInvoicePaid | int | - | ||
Description:The field is not used. | ||||
PaidInvoiceDays | smallint | - | ||
Description:The field is not used. | ||||
TranBegBalance | decimal(19, 4) | - | ||
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(19, 4) | - | ||
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(19, 4) | - | ||
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(19, 4) | - | ||
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(19, 4) | - | ||
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(19, 4) | - | ||
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(19, 4) | - | ||
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(19, 4) | - | ||
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(19, 4) | - | ||
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 . | ||||
TranPtdRetainageReleased | decimal(19, 4) | - | ||
Description:No description available | ||||
TranPtdRetainageWithheld | decimal(19, 4) | - | ||
Description:No description available | ||||
TranPtdRGOL | decimal(19, 4) | - | ||
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 . | ||||
TranPtdSales | decimal(19, 4) | - | ||
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(19, 4) | - | ||
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(19, 4) | - | ||
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(19, 4) | - | ||
Description:No description available | ||||
TranYtdRetainageWithheld | decimal(19, 4) | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||