Skip to main content
AR

ARCashSale

PX.Objects.AR.StandaloneScreenAR304000Release 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.
ARInvoiceDocType
char(3)-
Description:No description available
ARInvoiceRefNbr
nvarchar(15)-
Description:No description available
ARPaymentDocType
char(3)-
Description:No description available
ARPaymentRefNbr
nvarchar(15)-
Description:No description available
ARSubIDDefault Navigation
intAR Sub.Sub
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.
AdjDate API
datetimeDate-
Description:No description available
AdjFinPeriodIDDefault Navigation
stringPost PeriodFinPeriod
Description:No description available
AdjTranPeriodID
string-
Description:No description available
ApplyOverdueCharge
bit-
Description:No description available
Approved
bit-
Description:No description available
ApprovedCredit
bit-
Description:No description available
ApprovedCreditAmt
decimal-
Description:No description available
ApproverIDDefault Navigation
intOwnerContact
Description:No description available
ApproverWorkgroupIDDefault Navigation
intEPCompanyTree
Description:No description available
AvalaraCustomerUsageType
char(1)Tax Exemption Type-
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.
BillAddressID
int-
Description:No description available
BillContactIDDefault Navigation
intBilling ContactARContact
Description:No description available
BranchIDDefault Navigation
intBranchBranch
Description:The identifier of the branch to which the document belongs. Corresponds to the Branch.BranchID field.
CATranID
bigint-
Description:No description available
CCActualExternalTransactionID
intExternalTransaction
Description:No description available
CCPaymentStateDescrNonexistent in DB
stringProcessing Status-
Description:No description available
Canceled
bit-
Description:When set to "true", indicates that the invoice was canceled or corrected.
CardPresent
bit-
Description:Indicates whether the payment is made in card-present mode
CashAccountID API Default Navigation
intCash Account-
Description:No description available
ChargeAmt
decimal-
Description:The total of all finance charges applied to the document. Given in the base currency of the company.
ChargeCntr
int-
Description:No description available
ClearDate
datetimeClear Date-
Description:No description available
Cleared
bitCleared-
Description:No description available
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 Master Period-
Description:The Financial Period, in which the document was closed. Corresponds to the TranPeriodID field.
CommnAmt
decimal-
Description:No description available
CommnPct
decimal-
Description:No description available
CommnblAmt
decimal-
Description:No description available
ConsolidateChargeTotal
decimal-
Description:No description available
CreatedByIDDefault Navigation
uniqueidentifierCreated ByUsers
Description:No description available
CreatedByScreenID
char(8)-
Description:No description available
CreatedDateTime API
datetimeCreated On-
Description:No description available
CreditHold
bit-
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.
CuryCommnAmt
decimalCommission Amt.-
Description:No description available
CuryCommnblAmt
decimalTotal Commissionable-
Description:No description available
CuryConsolidateChargeTotal
decimalDeducted Charges-
Description:No description available
CuryDetailExtPriceTotalNonexistent in DB
decimal?Detail Total-
Description:Sum of ext value (line total and line discount total)
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 API
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.
CuryGoodsExtPriceTotal
decimalGoods-
Description:The total amount on all lines of the document, except for Misc. Charges and empty or null Line Types (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.
CuryLineDiscTotal
decimalLine Discounts-
Description:The total discount of the document (in the currency of the document), which is calculated as the sum of line discounts of the order.
CuryLineRetainageTotal
decimal-
Description:No description available
CuryLineTotal
decimalDetail Total-
Description:No description available
CuryMiscExtPriceTotal
decimalMisc. Charges-
Description:The total amount calculated as the sum of the amounts in Ext. Price (in the currency of the document).
CuryOrigDiscAmt
decimalCash Discount Taken-
Description:The cash discount entered for the document. Given in the currency of the document.
CuryOrigDocAmt API
decimalPayment Amount-
Description:The amount of the document. Given in the currency of the document.
CuryOrigDocAmtWithRetainageTotalNonexistent in DB
decimal?Total Amount-
Description:No description available
CuryOrigTaxDiscAmt
decimalDiscounted Tax 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.
CuryTaxTotal API
decimalTax Total-
Description:No description available
CuryVatExemptTotal
decimalTax Exempt Total-
Description:No description available
CuryVatTaxableTotal
decimalTaxable Total-
Description:No description available
CustomerID API Default 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.
DRSchedCntr
int-
Description:No description available
DefRetainagePct
decimalDefault Retainage Percent-
Description:No description available
DepositAfter
datetimeDeposit After-
Description:No description available
DepositAsBatch
bitBatch Deposit-
Description:No description available
DepositDateNonexistent in DB
DateTime?Batch Deposit Date-
Description:No description available
DepositNbr
nvarchar(15)Batch Deposit Nbr.-
Description:No description available
DepositType
char(3)-
Description:No description available
Deposited
bitDeposited-
Description:No description available
DetailExtLineTotalNonexistent in DB
decimal?-
Description:Sum of ext value (line total and line discount total)
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 API
nvarchar(256)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 API
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 API
nvarchar(40)Payment Ref.-
Description:No description available
ExternalRef
nvarchar(80)-
Description:No description available
ExternalTaxExemptionNumber
nvarchar(30)Tax Exemption Number-
Description:The tax exemption number for reporting purposes. The field is used if the system is integrated with External Tax Calculation and the External Tax Calculation Integration feature is enabled.
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.
GoodsExtPriceTotal
decimal-
Description:The total amount on all lines of the document, except for Misc. Charges and empty or null Line Types (in base currency).
HasPPDTaxes
bit-
Description:If set to "true", indicates that the document has the taxes that reduce cash discount taxable amount on early payment.
Hold API
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.
InstallmentNbr
smallint-
Description:No description available
InternalDocTypeNonexistent in DB
stringDocument Type (Internal)-
Description:No description available
InvoiceDate
datetime-
Description:No description available
InvoiceNbr
nvarchar(40)-
Description:No description available
IsCCAuthorized
bit-
Description:No description available
IsCCCaptureFailed
bit-
Description:No description available
IsCCCaptured
bit-
Description:No description available
IsCCPayment
bit-
Description:No description available
IsCCRefunded
bit-
Description:No description available
IsCCUserAttention
bit-
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.
IsPaymentsTransferred
bit-
Description:A Boolean field that indicates whether the payments and prepayment applied to the related sales orders should be transferred to the invoice during the document creation. When set to false, the payments and prepayments will not be transferred to the invoice during the document creation but will be transferred within the Complete Processing actions execution when all orders are already added to the invoice.
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 API
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.
LineDiscTotal
decimalLine Discounts-
Description:The total line discount of the document, which is calculated as the sum of line discounts of the invoice.
LineRetainageTotal
decimal-
Description:No description available
LineTotal
decimal-
Description:No description available
MasterRefNbr
nvarchar(15)-
Description:No description available
MiscExtPriceTotal
decimal-
Description:The total amount calculated as the sum of the amounts in Ext. Price (in base currency).
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
decimal-
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.
OrigTaxDiscAmt
decimal-
Description:No description available
OwnerIDDefault Navigation
intOwner IDContact
Description:No description available
PMInstanceIDDefault Navigation
intCard/Account Nbr.CustomerPaymentMethod
Description:No description available
PaymentMethodID API Default Navigation
nvarchar(10)Payment MethodPaymentMethod
Description:No description available
PaymentProjectIDDefault Navigation
intProjectPMProject
Description:No description available
PaymentTaskIDDefault Navigation
intProject Task-
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.
ProcessingCenterIDDefault Navigation
nvarcharProc. Center IDCCProcessingCenter
Description:No description available
ProjectIDDefault Navigation
intProjectPMProject
Description:No description available
RGOLAmt
decimal-
Description:Realized Gain or Loss amount associated with the document. Given in the base currency of the company.
RefNbr API Default Navigation
nvarchar(15)Reference Nbr.-
Description:The reference number of the document. This field is a part of the compound key of the document.
RefNoteID
uniqueidentifier-
Description:!REV!
RefTranExtNbrDefault Navigation
nvarchar(50)Orig. TransactionExternalTransaction
Description:No description available
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
intDefault SalespersonSalesPerson
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.
Settled
bitSettled-
Description:No description available
ShipAddressID
int-
Description:No description available
ShipContactIDDefault Navigation
intShipping ContactARShippingContact
Description:No description available
StatementDate
datetime-
Description:The date of the Customer Statement, in which the document is reported. Corresponds to the ARStatement.StatementDate field.
Status API
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
TaxTotal
decimal-
Description:No description available
TaxZoneIDDefault Navigation
nvarchar(10)Customer Tax ZoneTaxZone
Description:No description available
TerminalIDDefault Navigation
nvarchar(36)TerminalCCProcessingCenterTerminal
Description:Terminal ID
TermsIDDefault Navigation
nvarchar(10)TermsTerms
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.
VatExemptTotal
decimal-
Description:No description available
VatTaxableTotal
decimal-
Description:No description available
VoidApplNonexistent in DB
bool?-
Description:No description available
Voided
bit-
Description:When set to "true" indicates that the document has been voided.
WorkgroupIDDefault Navigation
intEPCompanyTree
Description:No description available
tstamp
timestamp-
Description:No description available