APRegisterAlias

PX.Objects.AP.StandaloneRelease 2025.2

An alias descendant version of APRegister. Can be used e.g. to avoid behaviour when PXSubstituteAttribute substitutes APRegister for derived classes. Can also be used as a table alias if APRegister is joined multiple times in BQL.

Select a row for its description 138 of 138 fields

	Field Name	Type	Display Name	Foreign Key
	`APAccountID`Default Navigation	`int`	AP Account	Account
Description:Identifier of the AP account, to which the document belongs. Corresponds to the Account.AccountID field.
	`APSubID`Default Navigation	`int`	AP Subaccount	Sub
Description:Identifier of the AP subaccount, to which the document belongs. 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
	`BatchNbr`Default Navigation	`nvarchar(15)`	Batch Nbr.	Batch
Description:Number of the Batch, generated for the document on release. Corresponds to the Batch.BatchNbr field.
	`BranchID`Default Navigation	`int`	Branch	Branch
Description:Identifier of the Branch, to which the document belongs. Corresponds to the Branch.BranchID field.
	`ChargeAmt`	`decimal`		-
Description:The amount of charges associated with the document in the base currency of the company. (See Company.BaseCuryID)
	`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 Master Period	-
Description:The Financial Period, in which the document was closed. Corresponds to the TranPeriodID field.
	`CreatedByID`Default Navigation	`uniqueidentifier`	Created By	Users
Description:No description available
	`CreatedByScreenID`	`char(8)`		-
Description:No description available
	`CreatedDateTime`	`datetime`	Created On	-
Description:No description available
	`CuryChargeAmt`	`decimal`	Finance Charges	-
Description:The amount of charges associated with the document in the currency of the document. (See CuryID)
	`CuryDiscBal`	`decimal`	Cash Discount Balance	-
Description:The difference between the cash discount that was available and the actual amount of cash discount taken. (Presented in the currency of the document, see CuryID)
	`CuryDiscTaken`	`decimal`		-
Description:!REV! The amount of the cash discount taken. (Presented in the currency of the document, see CuryID)
	`CuryDiscTot`	`decimal`	Discount Total	-
Description:Total discount associated with the document in the currency of the document. (See CuryID)
	`CuryDiscountedDocTotal`Nonexistent in DB	`decimal?`	Discounted Doc. Total	-
Description:No description available
	`CuryDiscountedPrice`Nonexistent in DB	`decimal?`	Tax on Discounted Price	-
Description:No description available
	`CuryDiscountedTaxableTotal`Nonexistent in DB	`decimal?`	Discounted Taxable Total	-
Description:No description available
	`CuryDocBal`	`decimal`	Balance	-
Description:The balance of the Accounts Payable document after tax (if inclusive) and the discount in the currency of the document. (See CuryID)
	`CuryDocDisc`Nonexistent in DBObsolete	`decimal?`	Document Discount	-
Description:No description available
	`CuryID`Default Navigation	`nvarchar(5)`	Currency	Currency
Description:Code of the Currency of the document. Defaults to the company's base currency.
	`CuryInfoID`	`bigint`		CurrencyInfo
Description:Identifier of the CurrencyInfo object associated with the document. Generated automatically. Corresponds to the CurrencyInfo.CurrencyInfoID field.
	`CuryInitDocBal`	`decimal`	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:!REV! The amount of the cash discount taken for the original document. (Presented in the currency of the document, see CuryID)
	`CuryOrigDocAmt`	`decimal`	Amount	-
Description:The amount to be paid for the document in the currency of the document. (See CuryID)
	`CuryOrigDocAmtWithRetainageTotal`Nonexistent in DB	`decimal?`	Total Amount	-
Description:No description available
	`CuryOrigWhTaxAmt`	`decimal`	With. Tax	-
Description:The amount of withholding tax calculated for the document, if applicable, in the currency of the document. (See CuryID)
	`CuryRetainagePaidTotal`Nonexistent in DB	`decimal?`	Paid Retainage	-
Description:No description available
	`CuryRetainageReleased`	`decimal`	Released Retainage	-
Description:No description available
	`CuryRetainageTotal`	`decimal`	Original Retainage	-
Description:No description available
	`CuryRetainageUnpaidTotal`Nonexistent in DB	`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 and the rounded amount in the currency of the document. (See CuryID) (Applicable only in case Invoice Rounding feature is on.)
	`CuryTaxRoundDiff`	`decimal`	Rounding Diff.	-
Description:No description available
	`CuryTaxWheld`	`decimal`		-
Description:!REV! The amount of tax withheld from the payments to the document. (Presented in the currency of the document, see CuryID)
	`CuryWhTaxBal`	`decimal`		-
Description:!REV! The difference between the original amount of withholding tax to be payed and the amount that was actually paid. (Presented in the currency of the document, see CuryID)
	`DefRetainagePct`	`decimal`	Default Retainage Percent	-
Description:No description available
	`DetailCount`	`int`		-
Description:The number of detail lines of the document.
	`DiscBal`	`decimal`		-
Description:The difference between the cash discount that was available and the actual amount of cash discount taken. (Presented in the base currency of the company, see Company.BaseCuryID)
	`DiscTaken`	`decimal`		-
Description:The amount of the cash discount taken. (Presented in the base currency of the company, see Company.BaseCuryID)
	`DiscTot`	`decimal`		-
Description:Total discount associated with the document in the base currency of the company. (See Company.BaseCuryID)
	`DiscountedDocTotal`Nonexistent in DB	`decimal?`		-
Description:No description available
	`DiscountedPrice`Nonexistent in DB	`decimal?`		-
Description:No description available
	`DiscountedTaxableTotal`Nonexistent in DB	`decimal?`		-
Description:No description available
	`DisplayCuryInitDocBal`Nonexistent in DB	`decimal?`	Migrated Balance	-
Description:The non database field, displaying an entered in migration mode balance of the document APRegister.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 balance of the Accounts Payable document after tax (if inclusive) and the discount in the base currency of the company. (See Company.BaseCuryID)
	`DocClass`Nonexistent in DB	`string`		-
Description:Class of the document. This field is calculated based on the DocType. Possible values are: "N" - for Invoice, Credit Adjustment, Debit Adjustment, Cash Purchase, Voided Cash Purchase and Cash Return ; "P" - for Payment, Voided Payment and Refund; "U" - for Prepayment.
	`DocDate`	`datetime`	Date	-
Description:Date of the document.
	`DocDesc`	`nvarchar(512)`	Description	-
Description:Description of the document.
	`DocDisc`Nonexistent in DBObsolete	`decimal?`		-
Description:No description available
	`DocType`	`char(3)`	Type	-
Description:The type of the document. The field can have one of the following values: - INV: Invoice - ACR: Credit Adjustment - ADR: Debit Adjustment - CHK: Payment - VCK: Voided Payment - PPM: Prepayment - REF: Refund - VRF: Voided Refund - QCK: Cash Purchase - VQC: Voided Cash Purchase
	`DontApprove`	`bit`		-
Description:No description available
	`EmployeeID`Default Navigation	`int`	Owner	EPEmployee
Description:The Contact responsible for the document. Corresponds to the Contact.ContactID field.
	`EmployeeWorkgroupID`Default Navigation	`int`	Workgroup ID	EPCompanyTree
Description:The workgroup that is responsible for the document. Corresponds to the EPCompanyTree.WorkGroupID field.
	`FinPeriodID`Default Navigation	`string`	Post Period	FinPeriod
Description:Financial Period of the document. Defaults to the period, to which the APRegister.DocDate belongs, but can be overriden by user.
	`HasMultipleProjects`	`bit`		-
Description:A Boolean value that shows whether the AP document contains lines for different projects.
	`HasPPDTaxes`	`bit`		-
Description:No description available
	`HiddenKey`Nonexistent in DB	`string`		-
Description:If not null, this field indicates that the document represents a payment by a separate check. In this case the payment cannot be combined with other payments to the vendor. Applicable only in case VSeparateCheck option is turned on for the Vendor.
	`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.
	`InternalDocType`Nonexistent in DB	`string`	Document Type (Internal)	-
Description:No description available
	`IsExpectedPPVValid`	`bit`		-
Description:Indicates that related APTran.ExpectedPPVAmount contains an actual values. If value is false, the APTran.ExpectedPPVAmount values will be recalculated during the document saving.
	`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 has been posted to the external tax provider	-
Description:When "true", indicates that the tax information was successfully commited to the External Tax Provider.
	`IsTaxSaved`	`bit`	Tax has been saved in the external tax provider	-
Description:Indicates whether the tax information related to the document was saved to the External Tax Provider.
	`IsTaxValid`	`bit`	Tax Is Up to Date	-
Description:When "true", indicates that the amount of tax calculated with the External Tax Provider 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.
	`LastModifiedByID`Default Navigation	`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:Counter of the document lines, used internally to assign numbers to newly created lines. It is not recommended to rely on this fields to determine the exact count of lines, because it might not reflect the latter under various conditions.
	`LineRetainageTotal`	`decimal`		-
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`	Open	-
Description:When set to "true" indicates that the document is open.
	`OrigDiscAmt`	`decimal`		-
Description:The amount of the cash discount taken for the original document. (Presented in the base currency of the company, see Company.BaseCuryID)
	`OrigDocAmt`	`decimal`	Amount	-
Description:The amount to be paid for the document in the base currency of the company. (See Company.BaseCuryID)
	`OrigDocAmtWithRetainageTotal`Nonexistent in DB	`decimal?`	Total Amount	-
Description:No description available
	`OrigDocDate`	`datetime`		-
Description:Date of the original (source) document.
	`OrigDocType`	`char(3)`	Orig. Doc. Type	APRegister
Description:Type of the original (source) document.
	`OrigModule`	`char(2)`	Source	-
Description:Module, from which the document originates. Code of the module of the system. Defaults to "AP". Possible values are: "GL", "AP", "AR", "CM", "CA", "IN", "DR", "FA", "PM", "TX", "SO", "PO".
	`OrigRefNbr`	`nvarchar(15)`	Orig. Ref. Nbr.	APRegister
Description:Reference number of the original (source) document.
	`OrigWhTaxAmt`	`decimal`		-
Description:The amount of withholding tax calculated for the document, if applicable, in the base currency of the company. (See Company.BaseCuryID)
	`OwnerID`Default Navigation	`int`	Approver	Contact
Description:The contact responsible for document approval process. Corresponds to the Contact.ContactID field.
	`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:No description available
	`PendingPayment`	`bit`		-
Description:When set to "true", indicates that the prepayment is ready for payment applicaton when the feature FeaturesSet.VATRecognitionOnPrepaymentsAP is activated.
	`PendingProcessing`	`bit`		-
Description:Set to true when external payment processor is used to process the payment and payment is not processed yet.
	`PrebookBatchNbr`Default Navigation	`nvarchar(15)`	Pre-Releasing Batch Nbr.	Batch
Description:Stores the number of the Batch generated during prebooking. Corresponds to the Batch.BatchNbr field.
	`Prebooked`	`bit`	Prebooked	-
Description:When set to "true" indicates that the document was prebooked.
	`PrepaymentAccountID`Default Navigation	`int`	Prepayment Account	Account
Description:The identifier of the account to which the Tax and Taxable amounts should be posted when the feature FeaturesSet.VATRecognitionOnPrepaymentsAP 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`Default Navigation	`int`	Prepayment Subaccount	Sub
Description:The identifier of the subaccount to which the Tax and Taxable amounts should be posted when the feature FeaturesSet.VATRecognitionOnPrepaymentsAP is activated. Corresponds to the Sub.SubID field.
	`PrintDocType`Nonexistent in DB	`string`	Type	-
Description:Type of the document for displaying in reports. This field has the same set of possible internal values as the DocType field, but exposes different user-friendly values.
	`Printed`	`bit`		-
Description:When set to "true" indicates that the document was printed.
	`ProjectID`Default Navigation	`int`	Project	PMProject
Description:No description available
	`RGOLAmt`	`decimal`		-
Description:Realized Gain and Loss amount associated with the document.
	`RefNbr`Default Navigation	`nvarchar(15)`	Reference Nbr.	APRegister
Description:Reference number of the document.
	`RefNoteID`	`uniqueidentifier`		-
Description:!REV!
	`Rejected`	`bit`		-
Description:No description available
	`Released`	`bit`	Released	-
Description:When set to "true" indicates that the document was released.
	`ReleasedOrPrebooked`Nonexistent in DB	`bool?`		-
Description:Read-only field that is equal to "true" in case the document was either prebooked or released.
	`ReleasedToVerify`Nonexistent 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`Default Navigation	`int`	Retainage Payable Account	Account
Description:No description available
	`RetainageApply`	`bit`	Apply Retainage	-
Description:No description available
	`RetainagePaidTotal`Nonexistent in DB	`decimal?`		-
Description:No description available
	`RetainageReleased`	`decimal`	Released Retainage	-
Description:No description available
	`RetainageSubID`Default Navigation	`int`	Retainage Payable Sub.	Sub
Description:No description available
	`RetainageTotal`	`decimal`	Original Retainage	-
Description:No description available
	`RetainageUnpaidTotal`Nonexistent in DB	`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 and the rounded amount in the base currency of the company. (See Company.BaseCuryID) (Applicable only in case Invoice Rounding feature is on.)
	`ScheduleID`	`nvarchar(15)`		Schedule
Description:Identifier of the Schedule object, associated with the document. In case Scheduled is "true", ScheduleID points to the Schedule, to which the document belongs as a template. Otherwise, ScheduleID 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.
	`Selected`Nonexistent in DB	`bool?`	Selected	-
Description:Indicates whether the record is selected for mass processing or not.
	`SquareSumProjectID`	`bigint`		-
Description:The sum of squares of integer IDs of all projects in document's detail lines.
	`Status`	`char(1)`	Status	-
Description:The status of the document. The field is calculated based on the values of the status flag. It can't be changed directly. The following fields determine the status of the document: Hold, Released, Voided, Scheduled, Prebooked, Printed, Approved, Rejected. The field can have the following values: ""H"" - On Hold, ""B"" - Balanced, ""V"" - Voided, ""S"" - Scheduled, ""N"" - Open, ""C"" - Closed, ""P"" - Printed, ""K"" - Pre-Released, ""E"" - Pending Approval, ""R"" - Rejected, ""Z"" - Reserved. The value defaults to On Hold.
	`SumProjectID`	`bigint`		-
Description:The sum of integer IDs of all projects in document's detail lines.
	`TaxCalcMode`	`char(1)`	Tax Calculation Mode	-
Description:No description available
	`TaxCostINAdjRefNbr`Default Navigation	`nvarchar(15)`	Adjustment Nbr.	INRegister
Description:No description available
	`TaxRoundDiff`	`decimal`		-
Description:No description available
	`TaxWheld`	`decimal`		-
Description:The amount of tax withheld from the payments to the document. (Presented in the base currency of the company, see Company.BaseCuryID)
	`TranPeriodID`	`string`	Master Period	-
Description:Financial Period of the document. Determined by the date of the document. Unlike APRegister.FinPeriodID the value of this field can't be overriden by user.
	`VendorID`Default Navigation	`int`	Vendor	Vendor
Description:Identifier of the Vendor, whom the document belongs to.
	`VendorLocationID`Default Navigation	`int`	Location	Location
Description:Identifier of the Location of the Vendor, associated with the document. Corresponds to the Location.LocationID field. Defaults to vendor's default location.
	`VoidBatchNbr`Default Navigation	`nvarchar(15)`	Void Batch Nbr.	Batch
Description:Stores the number of the Batch generated when the document was voided. Corresponds to the Batch.BatchNbr field.
	`Voided`	`bit`	Void	-
Description:When set to "true" indicates that the document was voided. In this case VoidBatchNbr field will hold the number of the voiding Batch.
	`WhTaxBal`	`decimal`		-
Description:The difference between the original amount of withholding tax to be payed and the amount that was actually paid. (Presented in the base currency of the company, see Company.BaseCuryID)
	`WorkgroupID`Default NavigationNonexistent in DB	`int?`	Approval Workgroup ID	EPCompanyTree
Description:The workgroup that is responsible for document approval process.
	`tstamp`	`timestamp`		-
Description:No description available