AR
ARDocumentEnq.ARDocumentResult
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: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. | ||||
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. | ||||
CuryAmountToPayNonexistent in DB | decimal? | Amount To Pay | - | |
Description:Sum of payment amounts already paid for the invoice | ||||
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. | ||||
CuryInvoiceBalNonexistent in DB | decimal? | Outstanding Total | - | |
Description:Sum of opened invoice | ||||
CuryInvoiceDue7DaysNonexistent in DB | decimal? | Overdue Total | - | |
Description:Sum of opened OverdueInvoice | ||||
CuryInvoiceOverdueBalNonexistent in DB | decimal? | Overdue Total | - | |
Description:Sum of opened OverdueInvoice | ||||
CuryOrigDiscAmtNonexistent in DB | decimal? | Cash Discount | - | |
Description:The cash discount entered for the document. Given in the currency of the document. | ||||
CuryOrigDocAmtNonexistent in DB | decimal? | Currency Origin. Amount | - | |
Description:The amount of the document. Given in the currency of the document. | ||||
CuryOrigDocAmtWithRetainageTotalNonexistent in DB | decimal? | Total Amount | - | |
Description:No description available | ||||
CuryPaymentBalNonexistent in DB | decimal? | - | ||
Description:Sum of opened Payment | ||||
CuryRetainageTotalNonexistent in DB | 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 | ||||
DiscDate | datetime | Discount Date | - | |
Description:Cash Discount Date | ||||
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 | ||||
ExtRefNbrNonexistent in DB | string | 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 overriden by user. | ||||
FinPostPeriodIDNonexistent in DB | string | - | ||
Description:No description available | ||||
GLTurnoverNonexistent in DB | decimal? | GL Turnover | - | |
Description:Expected GL turnover for the document. Given in the base currency of the company. | ||||
HasUnreleasedPaymentNonexistent in DB | bool? | - | ||
Description:Marks invoice having unreleased payment. | ||||
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 | Discount Amount | - | |
Description:The cash discount entered for the document. Given in the base currency of the company. | ||||
OrigDocAmtNonexistent in DB | decimal? | Origin. Amount | - | |
Description:The amount of the document. Given in the base currency of the company. | ||||
OrigDocAmtWithRetainageTotalNonexistent in DB | 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 | ||||
PendingPayment | bit | - | ||
Description:No description available | ||||
ProjectIDNonexistent in DB | int? | Project | PMProject | |
Description:Project ID | ||||
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. | ||||
RetainageTotalNonexistent in DB | 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. | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:No description available | ||||
SignBalanceNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
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:The identifier of the subaccount to which the document should be posted. Corresponds to the Sub.SubID field. | ||||
TotalOfPaymentsNonexistent in DB | decimal? | Amount Paid | - | |
Description:Sum of payment amounts already paid for the invoice | ||||
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 overriden by user. | ||||
TranPostPeriodIDNonexistent in DB | 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 | ||||