AR
ARDocumentEnq.GLDocumentPeriodResult
No summary is documented for this DAC in the release source.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
ARAccountID | int | AR Account | Account | |
Description:The identifier of the AR account to which the document should be posted. The Cash account and Year-to-Date Net Income account cannot be selected as the value of this field. Corresponds to the Account.AccountID field. | ||||
ARSubID | int | AR Subaccount | Sub | |
Description:The identifier of the subaccount to which the document should be posted. Corresponds to the Sub.SubID field. | ||||
ARTurnoverNonexistent in DB | decimal? | AR Turnover | - | |
Description:Expected GL turnover for the document. Given in the base currency of the company. | ||||
AccountID | int | Account | Account | |
Description:No description available | ||||
BatchNbr | nvarchar(15) | Batch Nbr. | Batch | |
Description:The number of the Batch created from the document on release. Corresponds to the Batch.BatchNbr field. | ||||
BegBalanceNonexistent in DB | decimal? | Period Beg. Balance | - | |
Description:No description available | ||||
BranchID | int | Branch | - | |
Description:The identifier of the branch to which the document belongs. Corresponds to the Branch.BranchID field. | ||||
ClosedFinPeriodID | string | Closed Period | - | |
Description:The Financial Period, in which the document was closed. Corresponds to the FinPeriodID field. | ||||
ClosedTranPeriodID | string | Closed Period | - | |
Description:The Financial Period, in which the document was closed. Corresponds to the TranPeriodID field. | ||||
CuryBegBalanceNonexistent in DB | decimal? | Currency Period Beg. Balance | - | |
Description:No description available | ||||
CuryDiscActTakenNonexistent in DB | decimal? | Currency Cash Discount Taken | - | |
Description:No description available | ||||
CuryDocBalNonexistent in DB | decimal? | Currency Balance | - | |
Description:No description available | ||||
CuryID | nvarchar(5) | Currency | Currency | |
Description:The code of the Currency of the document. Defaults to the base currency of the company. Corresponds to the Currency.CuryID field. | ||||
CuryInfoID | bigint | - | ||
Description:The identifier of the CurrencyInfo object associated with the document. Corresponds to the CurrencyInfoID field. | ||||
CuryOrigDiscAmt | decimal | Cash Discount | - | |
Description:The cash discount entered for the document. Given in the currency of the document. | ||||
CuryOrigDocAmt | decimal | Currency Origin. Amount | - | |
Description:The amount of the document. Given in the currency of the document. | ||||
CuryOrigDocAmtWithRetainageTotal | decimal | Total Amount | - | |
Description:No description available | ||||
CuryRetainageTotal | decimal | Original Retainage | - | |
Description:No description available | ||||
CuryRetainageUnreleasedAmtNonexistent in DB | decimal? | Unreleased Retainage | - | |
Description:No description available | ||||
CuryWOAmtNonexistent in DB | decimal? | Currency Write-Off Amount | - | |
Description:No description available | ||||
CustomerID | int | Customer | BAccountR | |
Description:No description available | ||||
DiscActTakenNonexistent in DB | decimal? | Cash Discount Taken | - | |
Description:No description available | ||||
DocBalNonexistent in DB | decimal? | Balance | - | |
Description:No description available | ||||
DocDate | datetime | Date | - | |
Description:The date of the document. Defaults to the current Business Date. | ||||
DocDesc | nvarchar(256) | Description | - | |
Description:The description of the document. | ||||
DocType | char(3) | Type | - | |
Description:The type of the document. This field is a part of the compound key of the document. The field can have one of the values described in ARDocType.ListAttribute. | ||||
DueDate | datetime | Due Date | - | |
Description:No description available | ||||
ExtRefNbr | nvarchar(30) | Customer Order Nbr./Payment Nbr. | - | |
Description:No description available | ||||
FinPeriodID | string | Post Period | FinPeriod | |
Description:Financial Period of the document. Defaults to the period, to which the ARRegister.DocDate belongs, but can be virtualn by user. | ||||
FinPostPeriodID | string | FinPeriod | ||
Description:Financial Period of the document. Defaults to the period, to which the ARRegister.DocDate belongs, but can be virtualn by user. | ||||
GLTurnoverNonexistent in DB | decimal? | GL Turnover | - | |
Description:Expected GL turnover for the document. Given in the base currency of the company. | ||||
InstallmentCntr | smallint | - | ||
Description:The counter of installments associated with the document. | ||||
IsMigratedRecord | bit | - | ||
Description:Specifies (if set to "true") that the record has been created in migration mode without affecting GL module. | ||||
IsRetainageDocument | bit | Retainage Document | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:Identifier of the Note object, associated with the document. Corresponds to the Note.NoteID field. | ||||
OpenDoc | bit | - | ||
Description:When set to "true", indicates that the document is open. | ||||
OrigDiscAmt | decimal | - | ||
Description:The cash discount entered for the document. Given in the base currency of the company. | ||||
OrigDocAmt | decimal | Origin. Amount | - | |
Description:The amount of the document. Given in the base currency of the company. | ||||
OrigDocAmtWithRetainageTotal | decimal | Total Amount | - | |
Description:No description available | ||||
OrigDocType | char(3) | Orig. Doc. Type | - | |
Description:The type of the original (source) document. Corresponds to the DocType field. | ||||
OrigRefNbr | nvarchar(15) | Orig. Ref. Nbr. | - | |
Description:The reference number of the original (source) document. Corresponds to the RefNbr field. | ||||
PaymentMethodID | nvarchar(10) | Payment Method | - | |
Description:No description available | ||||
ProjectID | int | Project | PMProject | |
Description:No description available | ||||
RGOLAmtNonexistent in DB | decimal? | RGOL Amount | - | |
Description:No description available | ||||
RefNbr | nvarchar(15) | Reference Nbr. | ARDocumentEnq.ARRegister | |
Description:The reference number of the document. This field is a part of the compound key of the document. | ||||
Released | bit | - | ||
Description:When set to "true", indicates that the document has been released. | ||||
RetainageTotal | decimal | Original Retainage | - | |
Description:No description available | ||||
RetainageUnreleasedAmtNonexistent in DB | decimal? | Unreleased Retainage | - | |
Description:No description available | ||||
Scheduled | bit | - | ||
Description:When set to "true" indicates that the document is part of a "Schedule" and serves as a template for generating other documents according to it. | ||||
Status | char(1) | Status | - | |
Description:The status of the document. The value of the field is determined by the values of the status flags, such as Hold, Released, Voided, Scheduled. The field can have one of the values described in ARDocStatus.ListAttribute. Defaults to ARDocStatus.Hold. | ||||
SubID | int | Subaccount | Sub | |
Description:No description available | ||||
TranPeriodID | string | - | ||
Description:Financial Period of the document. Determined by the date of the document. Unlike ARRegister.FinPeriodID the value of this field can't be virtualn by user. | ||||
TranPostPeriodID | string | - | ||
Description:No description available | ||||
Voided | bit | - | ||
Description:When set to "true" indicates that the document has been voided. | ||||
WOAmtNonexistent in DB | decimal? | Write-Off Amount | - | |
Description:No description available | ||||