AR
ARPaymentInfo
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. | ||||
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 | datetime | Application Date | - | |
Description:No description available | ||||
AdjFinPeriodID | string | Application Period | FinPeriod | |
Description:No description available | ||||
AdjTranPeriodID | string | - | ||
Description:No description available | ||||
ApplAmtNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
Approved | bit | - | ||
Description:No description available | ||||
ApproverID | int | Owner | Contact | |
Description:No description available | ||||
ApproverWorkgroupID | int | EPCompanyTree | ||
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. | ||||
BatchSeq | smallint | - | ||
Description:The batch sequence number. The field is not used. | ||||
BranchBaseCuryIDNonexistent in DB | string | - | ||
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:The identifier of the branch to which the document belongs. Corresponds to the Branch.BranchID field. | ||||
CATranID | bigint | - | ||
Description:No description available | ||||
CCActualExternalTransactionID | int | ExternalTransaction | ||
Description:No description available | ||||
CCPaymentStateDescrNonexistent in DB | string | Processing Status | - | |
Description:No description available | ||||
CCReauthDate | datetime | - | ||
Description:No description available | ||||
CCReauthTriesLeft | int | - | ||
Description:No description available | ||||
CCTranDescrNonexistent in DB | string | Error Descr. | - | |
Description:No description available | ||||
CCTransactionRefund | bit | Use Orig. Transaction for Refund | - | |
Description:No description available | ||||
CanHaveBalanceNonexistent in DB | bool? | Can Have Balance | - | |
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 | int | Cash Account | CashAccount | |
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 | ||||
ClDisplayNameNonexistent in DB | string | - | ||
Description:No description available | ||||
ClearDate | datetime | Clear Date | - | |
Description:No description available | ||||
Cleared | bit | Cleared | - | |
Description:No description available | ||||
ClosedDate | datetime | Closed Date | - | |
Description:The date of the last application. | ||||
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. | ||||
ConsolidateChargeTotal | decimal | - | ||
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created On | - | |
Description:No description available | ||||
CuryApplAmtNonexistent in DB | decimal? | Applied to Documents | - | |
Description:No description available | ||||
CuryChargeAmt | decimal | Finance Charges | - | |
Description:The total of all finance charges applied to the document. Given in the currency of the document. | ||||
CuryConsolidateChargeTotal | decimal | Deducted Charges | - | |
Description:No description available | ||||
CuryDiscBal | decimal | Cash 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 | decimal | Balance | - | |
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. | ||||
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 | CurrencyInfo | ||
Description:The identifier of the CurrencyInfo object associated with the document. Corresponds to the CurrencyInfoID field. | ||||
CuryInitDocBal | decimal | Available Balance | - | |
Description:The entered in migration mode balance of the document. Given in the currency of the document. | ||||
CuryLineRetainageTotal | decimal | - | ||
Description:No description available | ||||
CuryOrigDiscAmt | decimal | Cash Discount | - | |
Description:The cash discount entered for the document. Given in the currency of the document. | ||||
CuryOrigDocAmt | decimal | Payment 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 | decimal | - | ||
Description:No description available | ||||
CuryRetainagePaidTotalNonexistent in DB | decimal? | Paid/Adjusted Retainage | - | |
Description:No description available | ||||
CuryRetainageReleased | decimal | Released Retainage | - | |
Description:No description available | ||||
CuryRetainageTotal | decimal | Original Retainage | - | |
Description:No description available | ||||
CuryRetainageUnpaidTotal | decimal | Unpaid Retainage | - | |
Description:No description available | ||||
CuryRetainageUnreleasedAmt | decimal | Unreleased Retainage | - | |
Description:No description available | ||||
CuryRetainedDiscTotal | decimal | Discount on Retainage | - | |
Description:No description available | ||||
CuryRetainedTaxTotal | decimal | Tax on Retainage | - | |
Description:No description available | ||||
CuryRoundDiff | decimal | Rounding 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. | ||||
CurySOApplAmtNonexistent in DB | decimal? | Applied to Orders | - | |
Description:No description available | ||||
CuryUnappliedBalNonexistent in DB | decimal? | Available Balance | - | |
Description:No description available | ||||
CuryWOAmtNonexistent in DB | decimal? | Write-Off Amount | - | |
Description:No description available | ||||
CustomerBaseCuryIDNonexistent in DB | string | - | ||
Description:No description available | ||||
CustomerID | int | Customer | Customer | |
Description:The identifier of the Customer record associated with the document. Corresponds to the BAccount.BAccountID field. | ||||
CustomerLocationID | int | Location | Location | |
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 | decimal | Default Retainage Percent | - | |
Description:No description available | ||||
DepositAfter | datetime | Deposit After | - | |
Description:No description available | ||||
DepositAsBatch | bit | Batch Deposit | - | |
Description:No description available | ||||
DepositDateNonexistent in DB | DateTime? | Batch Deposit Date | - | |
Description:No description available | ||||
DepositNbr | nvarchar(15) | Batch Deposit Nbr. | CADeposit | |
Description:No description available | ||||
DepositType | char(3) | - | ||
Description:No description available | ||||
Deposited | bit | Deposited | - | |
Description:No description available | ||||
DisableAutomaticTaxCalculation | bit | Disable 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 | datetime | Payment Date | - | |
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 | string | Document 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 | bit | Don'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. | ||||
DontPrint | bit | Don'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. | ||||
DrCrNonexistent in DB | string | - | ||
Description:No description available | ||||
DueDate | datetime | Due 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 | bit | Emailed | - | |
Description:Specifies (if set to "true") that the document has been emailed to the customer. | ||||
ExtRefNbr | nvarchar(40) | Payment Ref. | - | |
Description:No description available | ||||
ExternalRef | nvarchar(80) | - | ||
Description:No description available | ||||
FinPeriodID | string | Payment Period | FinPeriod | |
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 | bit | Hold | - | |
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 | string | Document Type (Internal) | - | |
Description:No description available | ||||
IsCCAuthorized | bit | - | ||
Description:No description available | ||||
IsCCCaptureFailed | bit | - | ||
Description:No description available | ||||
IsCCCaptured | bit | - | ||
Description:No description available | ||||
IsCCExpiredNonexistent in DB | bool? | Expired | - | |
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 | bit | Correction 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 | bit | Retainage Document | - | |
Description:No description available | ||||
IsRetainageReversing | bit | Retainage Reversing | - | |
Description:No description available | ||||
IsTaxPosted | bit | Tax 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 | bit | Tax 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 | bit | Tax 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. | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | Last 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 | ||||
NeedTaskValidationNonexistent in DB | bool? | - | ||
Description:Indicates whether validation for the presence of the correct TaskID must be performed for the line before it is persisted to the database. | ||||
NewAccountNonexistent in DB | bool? | New Account | - | |
Description:No description available | ||||
NewCardNonexistent in DB | bool? | New Card | - | |
Description:No description available | ||||
NonTaxable | bit | Non-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. Type | ARRegister | |
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. | ||||
OrigReleasedNonexistent in DB | bool? | - | ||
Description:No description available | ||||
OrigTaxDiscAmt | decimal | - | ||
Description:No description available | ||||
PMInstanceDescrNonexistent in DB | string | Card/Account Nbr. | - | |
Description:No description available | ||||
PMInstanceID | int | Card/Account Nbr. | CustomerPaymentMethod | |
Description:No description available | ||||
PaymentMethodID | nvarchar(10) | Payment Method | PaymentMethod | |
Description:No description available | ||||
PaymentsByLinesAllowed | bit | Pay 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 | ||||
PostponeReleasedFlagNonexistent in DB | bool? | - | ||
Description:No description available | ||||
PostponeVoidedFlagNonexistent in DB | bool? | - | ||
Description:No description available | ||||
PrepaymentAccountID | int | Prepayment Account | Account | |
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. | ||||
PrepaymentSubID | int | Prepayment Subaccount | Sub | |
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 | string | Type | - | |
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 | bit | Printed | - | |
Description:Specifies (if set to "true") that the document has been printed. | ||||
ProcessingCenterID | nvarchar(10) | Proc. Center ID | CCProcessingCenter | |
Description:No description available | ||||
ProjectID | int | Project | PMProject | |
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 | nvarchar(15) | Reference Nbr. | ARRegisterAlias | |
Description:The reference number of the document. This field is a part of the compound key of the document. | ||||
RefNoteID | uniqueidentifier | - | ||
Description:!REV! | ||||
RefTranExtNbr | nvarchar(50) | Orig. Transaction | ExternalTransaction | |
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. | ||||
RetainageAcctID | int | Retainage Receivable Account | Account | |
Description:No description available | ||||
RetainageApply | bit | Apply Retainage | - | |
Description:No description available | ||||
RetainagePaidTotalNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
RetainageReleased | decimal | Released Retainage | - | |
Description:No description available | ||||
RetainageSubID | int | Retainage Receivable Sub. | Sub | |
Description:No description available | ||||
RetainageTotal | decimal | Original Retainage | - | |
Description:No description available | ||||
RetainageUnpaidTotal | decimal | - | ||
Description:No description available | ||||
RetainageUnreleasedAmt | decimal | Unreleased 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. | ||||
SOApplAmtNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
SalesPersonID | int | Salesperson ID | SalesPerson | |
Description:The identifier of the salesperson to whom the document belongs. Corresponds to the CustSalesPeople.SalesPersonID field. | ||||
SaveAccountNonexistent in DB | bool? | Save Account | - | |
Description:No description available | ||||
SaveCard | bit | Save Card | - | |
Description:No description available | ||||
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 | bit | Settled | - | |
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 | 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. | ||||
SyncLock | bit | - | ||
Description:No description available | ||||
SyncLockReason | char(1) | - | ||
Description:No description available | ||||
TaskID | int | Project Task | - | |
Description:No description available | ||||
TaxCalcMode | char(1) | Tax Calculation Mode | - | |
Description:No description available | ||||
TerminalID | nvarchar(36) | Terminal | CCProcessingCenterTerminal | |
Description:Terminal ID | ||||
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. | ||||
UnappliedBalNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
UpdateNextNumberNonexistent in DB | bool? | Update Next Number | - | |
Description:No description available | ||||
VoidApplNonexistent in DB | bool? | Void Application | - | |
Description:No description available | ||||
Voided | bit | Voided | - | |
Description:When set to "true" indicates that the document has been voided. | ||||
WOAmtNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
chkServiceManagementNonexistent in DB | bool? | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||