Skip to main content
AR

BalancedARDocument

PX.Objects.ARScreenAR501000Release 2025.2

No summary is documented for this DAC in the release source.

Field NameTypeDisplay NameForeign Key
ARAccountIDDefault Navigation
intAR AccountAccount
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.
ARSubIDDefault Navigation
intAR SubaccountSub
Description:The identifier of the subaccount to which the document should be posted. Corresponds to the Sub.SubID field.
AdjCntr
int-
Description:The counter of the document applications, which is used internally to assign numbers to newly created lines. The value is used to determine old and new applications.
Approved
bit-
Description:No description available
ApproverIDDefault Navigation
intOwnerContact
Description:No description available
ApproverWorkgroupIDDefault Navigation
intEPCompanyTree
Description:No description available
BatchNbrDefault Navigation
nvarchar(15)Batch Nbr.Batch
Description:The number of the Batch created from the document on release. Corresponds to the Batch.BatchNbr field.
BatchSeq
smallint-
Description:The batch sequence number. The field is not used.
BranchIDDefault Navigation
intBranchBranch
Description:The identifier of the branch to which the document belongs. Corresponds to the Branch.BranchID field.
Canceled
bit-
Description:When set to "true", indicates that the invoice was canceled or corrected.
ChargeAmt
decimal-
Description:The total of all finance charges applied to the document. Given in the base currency of the company.
ClosedDate
datetimeClosed Date-
Description:The date of the last application.
ClosedFinPeriodID
stringClosed Period-
Description:The Financial Period, in which the document was closed. Corresponds to the FinPeriodID field.
ClosedTranPeriodID
stringClosed Period-
Description:The Financial Period, in which the document was closed. Corresponds to the TranPeriodID field.
CreatedByIDDefault Navigation
uniqueidentifierCreated ByUsers
Description:No description available
CreatedByScreenID
char(8)-
Description:No description available
CreatedDateTime
datetimeCreated On-
Description:No description available
CuryChargeAmt
decimalFinance Charges-
Description:The total of all finance charges applied to the document. Given in the currency of the document.
CuryDiscBal
decimalCash Discount Balance-
Description:The cash discount balance of the document. Given in the currency of the document.
CuryDiscTaken
decimal-
Description:The cash discount amount actually applied to the document. Given in the currency of the document.
CuryDiscountedDocTotalNonexistent in DB
decimal?Discounted Doc. Total-
Description:The discounted amount of the document. Given in the currency of the document.
CuryDiscountedPriceNonexistent in DB
decimal?Tax on Discounted Price-
Description:The total tax amount reduced on early payment, according to cash discount. Given in the currency of the document.
CuryDiscountedTaxableTotalNonexistent in DB
decimal?Discounted Taxable Total-
Description:No description available
CuryDocBal
decimalBalance-
Description:The open balance of the document. Given in the currency of the document.
CuryDocDiscNonexistent in DBObsolete
decimal?Document Discount-
Description:The document discount total (without group discounts). Given in the currency of the document.
CuryIDDefault Navigation
nvarchar(5)CurrencyCurrency
Description:The code of the Currency of the document. Defaults to the base currency of the company. Corresponds to the Currency.CuryID field.
CuryInfoID
bigintCurrencyInfo
Description:The identifier of the CurrencyInfo object associated with the document. Corresponds to the CurrencyInfoID field.
CuryInitDocBal
decimalBalance-
Description:The entered in migration mode balance of the document. Given in the currency of the document.
CuryLineRetainageTotal
decimal-
Description:No description available
CuryOrigDiscAmt
decimalCash Discount-
Description:The cash discount entered for the document. Given in the currency of the document.
CuryOrigDocAmt
decimalAmount-
Description:The amount of the document. Given in the currency of the document.
CuryOrigDocAmtWithRetainageTotalNonexistent in DB
decimal?Total Amount-
Description:No description available
CuryRetainagePaidTotalNonexistent in DB
decimal?Paid/Adjusted Retainage-
Description:No description available
CuryRetainageReleased
decimalReleased Retainage-
Description:No description available
CuryRetainageTotal
decimalOriginal Retainage-
Description:No description available
CuryRetainageUnpaidTotal
decimalUnpaid Retainage-
Description:No description available
CuryRetainageUnreleasedAmt
decimalUnreleased Retainage-
Description:No description available
CuryRetainedDiscTotal
decimalDiscount on Retainage-
Description:No description available
CuryRetainedTaxTotal
decimalTax on Retainage-
Description:No description available
CuryRoundDiff
decimalRounding Diff.-
Description:The difference between the original amount of the document and the rounded amount. Given in the currency of the document. Applicable only if Invoice Rounding feature is enabled.
CustomerIDDefault Navigation
intCustomerCustomer
Description:The identifier of the Customer record associated with the document. Corresponds to the BAccount.BAccountID field.
CustomerLocationIDDefault Navigation
intLocationLocation
Description:Identifier of the Location of the Customer. Defaults to the Default Location of the Customer if it is specified, or to the first found Location, associated with the Customer. Corresponds to the Location.LocationID field.
CustomerRefNbrNonexistent in DB
stringCustomer Order Nbr.-
Description:No description available
DRSchedCntr
int-
Description:No description available
DefRetainagePct
decimalDefault Retainage Percent-
Description:No description available
DisableAutomaticTaxCalculation
bitDisable Automatic Tax Calculation-
Description:No description available
DiscBal
decimal-
Description:The cash discount balance of the document. Given in the base currency of the company.
DiscTaken
decimal-
Description:The cash discount amount actually applied to the document. Given in the base currency of the company.
DiscountedDocTotalNonexistent in DB
decimal?-
Description:The discounted amount of the document. Given in the base currency of the company.
DiscountedPriceNonexistent in DB
decimal?-
Description:The total tax amount reduced on early payment, according to cash discount. Given in the base currency of the company.
DiscountedTaxableTotalNonexistent in DB
decimal?-
Description:The total taxable amount reduced on early payment, according to cash discount. Given in the base currency of the company.
DisplayCuryInitDocBalNonexistent in DB
decimal?Migrated Balance-
Description:The non database field, displaying an entered in migration mode balance of the document ARRegister.CuryInitDocBal. Given in the currency of the document. Added to configure the different visibility of one field on one DAC cache.
DocBal
decimal-
Description:The open balance of the document. Given in the base currency of the company.
DocClassNonexistent in DB
string-
Description:Reserved for internal use. The read-only class of the document determined by the DocType. Affects the way the document is posted to the General Ledger. Corresponds to the GLTran.TranClass field.
DocDate
datetimeDate-
Description:The date of the document. Defaults to the current Business Date.
DocDesc
nvarchar(512)Description-
Description:The description of the document.
DocDiscNonexistent in DBObsolete
decimal?-
Description:The document discount total (without group discounts). Given in the base currency of the company.
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.
DocumentKeyNonexistent in DB
stringDocument Description-
Description:No description available
DontApprove
bit-
Description:Indicates that the current document should be excluded from the approval process. Maintenance of this property is on graph level.
DontEmail
bitDon't Email-
Description:When set to "true" indicates that the document should not be sent to the Customer by email, and thus the system should not include it in the list of documents available for mass-emailing. Defaults to the value of the Customer.MailInvoices setting of the Customer.
DontPrint
bitDon't Print-
Description:When set to "true" indicates that the document should not be sent to the Customer as a printed document, and thus the system should not include it in the list of documents available for mass-printing. Defaults to the value of the Customer.PrintInvoices setting of the Customer.
DueDate
datetimeDue Date-
Description:The due date of the document.
EmailInvoiceNonexistent in DB
bool?-
Description:When set to "true", indicates that the document awaits emailing. The field is used in automation steps for the Invoices and Memos (SO303000) form and thus defines participates in determining whether the document is available for processing on the Process Invoices and Memos (SO505000) form.
Emailed
bitEmailed-
Description:Specifies (if set to "true") that the document has been emailed to the customer.
ExtRefNbr
nvarchar(40)-
Description:No description available
ExternalRef
nvarchar(80)-
Description:No description available
FinPeriodIDDefault Navigation
stringPost PeriodFinPeriod
Description:Financial Period of the document. Defaults to the period, to which the ARRegister.DocDate belongs, but can be overriden by user.
FromScheduleNonexistent in DB
bool?-
Description:When set to "true" indicates that the document is generating by a "Scedule" process.
HasPPDTaxes
bit-
Description:If set to "true", indicates that the document has the taxes that reduce cash discount taxable amount on early payment.
Hold
bitHold-
Description:When set to "true" indicates that the document is on hold and thus cannot be released.
ImpRefNbr
nvarchar(15)-
Description:Implementation specific reference number of the document. This field is neither filled nor used by the core Acumatica itself, but may be utilized by customizations or extensions.
InitDocBal
decimal-
Description:The entered in migration mode balance of the document. Given in the base currency of the company.
InternalDocTypeNonexistent in DB
stringDocument Type (Internal)-
Description:No description available
InvoiceNbr
nvarchar(40)-
Description:No description available
IsCancellation
bit-
Description:When set to "true", indicates that the invoice is a cancellation invoice (credit memo).
IsCorrection
bitCorrection Inv.-
Description:When set to "true", indicates that the invoice is a correction invoice.
IsMigratedRecord
bit-
Description:Specifies (if set to "true") that the record has been created in migration mode without affecting GL module.
IsRetainageDocument
bitRetainage Document-
Description:No description available
IsRetainageReversing
bitRetainage Reversing-
Description:No description available
IsTaxPosted
bitTax Is Posted/Committed to External Tax Engine (Avalara)-
Description:When "true", indicates that the tax information was successfully commited to the external Tax Engine(Avalara).
IsTaxSaved
bitTax Is Saved in External Tax Engine (Avalara)-
Description:Indicates whether the tax information related to the document was saved to the external Tax Engine (Avalara).
IsTaxValid
bitTax Is Up to Date-
Description:When "true", indicates that the amount of tax calculated with the external Tax Engine(Avalara) is up to date. If this field equals "false", the document was updated since last synchronization with the Tax Engine and taxes might need recalculation.
IsUnderCorrection
bit-
Description:When set to "true", indicates that Cancel or Correct action was applied to the invoice.
LastModifiedByIDDefault Navigation
uniqueidentifierLast Modified ByUsers
Description:No description available
LastModifiedByScreenID
char(8)-
Description:No description available
LastModifiedDateTime
datetimeLast Modified On-
Description:No description available
LineCntr
int-
Description:The counter of the document lines, which is used internally to assign numbers to newly created lines. We do not recommended that you rely on this field to determine the exact number of lines, which might not be reflected by the value of this field under various conditions.
LineRetainageTotal
decimal-
Description:No description available
NonTaxable
bitNon-Taxable-
Description:Get or set NonTaxable that mark current document does not impose sales taxes.
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
decimalAmount-
Description:The amount of the document. Given in the base currency of the company.
OrigDocAmtWithRetainageTotalNonexistent in DB
decimal?Total Amount-
Description:No description available
OrigDocDate
datetime-
Description:The date of the original document (e.g. the one reversed by this document).
OrigDocType
char(3)Orig. Doc. TypeARRegister
Description:The type of the original (source) document. Corresponds to the DocType field.
OrigModule
char(2)Source-
Description:The module from which the document originates. The field can have one of the values described in BatchModule.FullListAttribute.
OrigRefNbr
nvarchar(15)Orig. Ref. Nbr.ARRegister
Description:The reference number of the original (source) document. Corresponds to the RefNbr field.
PaymentMethodID
nvarchar(10)Payment Method-
Description:No description available
PaymentsByLinesAllowed
bitPay by Line-
Description:Specifies (if set to "true") that the record has been created with activated FeaturesSet.PaymentsByLines feature and such document allow payments by lines.
PendingPPD
bit-
Description:If set to "true", indicates that the document has been fully paid and to close the document, you need to apply the cash discount by generating a credit memo on the Generate AR Tax Adjustments (AR504500) form.
PendingPayment
bit-
Description:When set to "true", indicates that the prepayment ready for payment applicaton when the feature FeaturesSet.VATRecognitionOnPrepaymentsAR is activated.
PendingProcessing
bit-
Description:No description available
PostponePendingPaymentFlagNonexistent in DB
bool?-
Description:Indicates that events will be invoke in the ARDocumentRelease.ProcessPostponedFlags() method for pendingPayment field. Uses when the feature FeaturesSet.VATRecognitionOnPrepaymentsAR is activated.
PrepaymentAccountIDDefault Navigation
intPrepayment AccountAccount
Description:The identifier of the account to which the Tax and Taxable amounts should be posted when the feature FeaturesSet.VATRecognitionOnPrepaymentsAR is activated. 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.
PrepaymentSubIDDefault Navigation
intPrepayment SubaccountSub
Description:The identifier of the subaccount to which the Tax and Taxable amounts should be posted when the feature FeaturesSet.VATRecognitionOnPrepaymentsAR is activated. Corresponds to the Sub.SubID field.
PrintDocTypeNonexistent in DB
stringType-
Description:The type of the document for printing, which is used in reports. The field can have one of the values described in ARDocType.PrintListAttribute.
PrintInvoiceNonexistent in DB
bool?-
Description:When set to "true", indicates that the document awaits printing. The field is used in automation steps for the Invoices and Memos (SO303000) form and thus defines participates in determining whether the document is available for processing on the Process Invoices and Memos (SO505000) form.
Printed
bitPrinted-
Description:Specifies (if set to "true") that the document has been printed.
RGOLAmt
decimal-
Description:Realized Gain or Loss amount associated with the document. Given in the base currency of the company.
RefNbrDefault Navigation
nvarchar(15)Reference Nbr.ARRegister
Description:The reference number of the document. This field is a part of the compound key of the document.
RefNoteID
uniqueidentifier-
Description:!REV!
Rejected
bit-
Description:No description available
Released
bit-
Description:When set to "true", indicates that the document has been released.
ReleasedToVerifyNonexistent in DB
bool?-
Description:When set, on persist checks, that the document has the corresponded Released original value. When not set, on persist checks, that Released value is not changed. Throws an error otherwise.
RetainageAcctIDDefault Navigation
intRetainage Receivable AccountAccount
Description:No description available
RetainageApply
bitApply Retainage-
Description:No description available
RetainagePaidTotalNonexistent in DB
decimal?-
Description:No description available
RetainageReleased
decimalReleased Retainage-
Description:No description available
RetainageSubIDDefault Navigation
intRetainage Receivable Sub.Sub
Description:No description available
RetainageTotal
decimalOriginal Retainage-
Description:No description available
RetainageUnpaidTotal
decimal-
Description:No description available
RetainageUnreleasedAmt
decimalUnreleased Retainage-
Description:No description available
RetainedDiscTotal
decimal-
Description:No description available
RetainedTaxTotal
decimal-
Description:No description available
RoundDiff
decimal-
Description:The difference between the original amount of the document and the rounded amount, in the base currency of the company. The field is used only if the Invoice Rounding feature is enabled.
SalesPersonIDDefault Navigation
intSalesperson IDSalesPerson
Description:The identifier of the salesperson to whom the document belongs. Corresponds to the CustSalesPeople.SalesPersonID field.
ScheduleID
nvarchar(15)Schedule
Description:Identifier of the Schedule, associated with the document. In case Scheduled is "true", the field points to the Schedule, to which the document belongs as a template. Otherwise, the field points to the Schedule, from which this document was generated, if any. Corresponds to the Schedule.ScheduleID field.
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:Indicates whether the record is selected for processing.
SelfVoidingDocNonexistent in DB
bool?-
Description:When "true", indicates that the document can be voided only in full and it is not allow to delete reversing applications partially.
StatementDate
datetime-
Description:The date of the Customer Statement, in which the document is reported. Corresponds to the ARStatement.StatementDate field.
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.
TaxCalcMode
char(1)Tax Calculation Mode-
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 overriden by user.
Voided
bit-
Description:When set to "true" indicates that the document has been voided.
tstamp
timestamp-
Description:No description available