APRegister

PX.Objects.AP

134 of 134 fields

	Field Name	Type	Display Name	Foreign Key
	`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
	`RefNbr`Default Navigation	`nvarchar(15)`	Reference Nbr.	-
Description:Reference number of the document.
	`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.
	`APAccountID`Default Navigation	`int`	AP Account	Account
Description:This property was copied from the APRegister class. It is overridden only for correct order of the fields in _ClassFields list of PXCache<TNode> class. The order of the fields is important for proper Restriction Groups operation. Corresponds to the Account.AccountID field.
	`Approved`	`bit`		-
Description:No description available
	`APSubID`Default Navigation	`int`	AP Subaccount	Sub
Description:Identifier of the AP subaccount, to which the document belongs. Corresponds to the Sub.SubID field.
	`BatchNbr`Default Navigation	`nvarchar(15)`	Batch Nbr.	Batch
Description:No description available
	`BranchID`Default Navigation	`int`	Branch	Branch
Description:Identifier of the Branch, to which the document belongs. Corresponds to the Branch.BranchID field.
	`ChargeAmt`	`decimal(19, 4)`		-
Description:The amount of charges associated with the document in the base currency of the company. (See Company.BaseCuryID)
	`ClosedDate`	`datetime2`	Closed Date	-
Description:The date of the last application.
	`ClosedFinPeriodID`	`char(6)`	Closed Period	-
Description:No description available
	`ClosedTranPeriodID`	`char(6)`	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(19, 4)`	Finance Charges	-
Description:The amount of charges associated with the document in the currency of the document. (See CuryID)
	`CuryDiscBal`	`decimal(19, 4)`	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)
	`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
	`CuryDiscTaken`	`decimal(19, 4)`		-
Description:The amount of the cash discount taken. (Presented in the currency of the document, see CuryID)
	`CuryDiscTot`	`decimal(19, 4)`	Discount Total	-
Description:Total discount associated with the document in the currency of the document. (See CuryID)
	`CuryDocBal`	`decimal(19, 4)`	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(19, 4)`	Balance	-
Description:The entered in migration mode balance of the document. Given in the currency of the document.
	`CuryLineRetainageTotal`	`decimal(19, 4)`		-
Description:No description available
	`CuryOrigDiscAmt`	`decimal(19, 4)`	Cash Discount	-
Description:The amount of the cash discount taken for the original document. (Presented in the currency of the document, see CuryID)
	`CuryOrigDocAmt`	`decimal(19, 4)`	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(19, 4)`	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(19, 4)`	Released Retainage	-
Description:No description available
	`CuryRetainageTotal`	`decimal(19, 4)`	Original Retainage	-
Description:No description available
	`CuryRetainageUnpaidTotal`Nonexistent in DB	`decimal`	Unpaid Retainage	-
Description:No description available
	`CuryRetainageUnreleasedAmt`	`decimal(19, 4)`	Unreleased Retainage	-
Description:No description available
	`CuryRetainedDiscTotal`	`decimal(19, 4)`	Discount on Retainage	-
Description:No description available
	`CuryRetainedTaxTotal`	`decimal(19, 4)`	Tax on Retainage	-
Description:No description available
	`CuryRoundDiff`	`decimal(19, 4)`	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(19, 4)`	Rounding Diff.	-
Description:No description available
	`CuryTaxWheld`	`decimal(19, 4)`		-
Description:The amount of tax withheld from the payments to the document. (Presented in the currency of the document, see CuryID)
	`CuryWhTaxBal`	`decimal(19, 4)`		-
Description: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(9, 6)`	Default Retainage Percent	-
Description:No description available
	`DiscBal`	`decimal(19, 4)`		-
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)
	`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
	`DiscTaken`	`decimal(19, 4)`		-
Description:The amount of the cash discount taken. (Presented in the base currency of the company, see Company.BaseCuryID)
	`DiscTot`	`decimal(19, 4)`		-
Description:Total discount associated with the document in the base currency of the company. (See Company.BaseCuryID)
	`DisplayCuryInitDocBal`	`decimal`	Migrated Balance	-
Description:The non database field, displaying an entered in migration mode balance of the document . Given in the currency of the document. Added to configure the different visibility of one field on one DAC cache.
	`DocBal`	`decimal(19, 4)`		-
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	`nchar(1)`		-
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`	`datetime2`	Date	-
Description:Date of the document.
	`DocDesc`	`nvarchar(512)`	Description	-
Description:Description of the document.
	`DocDisc`Nonexistent in DBObsolete	`decimal`		-
Description:No description available
	`DontApprove`	`bit`		-
Description:No description available
	`EmployeeID`Default Navigation	`int`	Owner	Contact
Description:No description available
	`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	`char(6)`	Post Period	-
Description:No description available
	`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	`nvarchar(MAX)`		-
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(19, 4)`		-
Description:The entered in migration mode balance of the document. Given in the base currency of the company.
	`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(19, 4)`		-
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(19, 4)`		-
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(19, 4)`	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`	`datetime2`		-
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.	-
Description:Reference number of the original (source) document.
	`OrigWhTaxAmt`	`decimal(19, 4)`		-
Description:The amount of withholding tax calculated for the document, if applicable, in the base currency of the company. (See Company.BaseCuryID)
	`OwnerID`Default NavigationNonexistent in DB	`int`	Approver	Contact
Description:The contact responsible for document approval process. Corresponds to the Contact.ContactID field.
	`PaymentsByLinesAllowed`	`bit`	Pay by Line	-
Description:No description available
	`PendingPayment`	`bit`		-
Description:No description available
	`PendingPPD`	`bit`		-
Description:No description available
	`PendingProcessing`	`bit`		-
Description:No description available
	`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:No description available
	`PrepaymentSubID`Default Navigation	`int`	Prepayment Subaccount	Sub
Description:No description available
	`PrintDocType`Nonexistent in DB	`nchar(3)`	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
	`RefNoteID`	`uniqueidentifier`		-
Description:No description available
	`Rejected`	`bit`		-
Description:No description available
	`Released`	`bit`	Released	-
Description:When set to "true" indicates that the document was released.
	`ReleasedOrPrebooked`Nonexistent in DB	`bit`		-
Description:Read-only field that is equal to "true" in case the document was either prebooked or released.
	`ReleasedToVerify`Nonexistent in DB	`bit`		-
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(19, 4)`	Released Retainage	-
Description:No description available
	`RetainageSubID`Default Navigation	`int`	Retainage Payable Sub.	Sub
Description:No description available
	`RetainageTotal`	`decimal(19, 4)`	Original Retainage	-
Description:No description available
	`RetainageUnpaidTotal`Nonexistent in DB	`decimal`		-
Description:No description available
	`RetainageUnreleasedAmt`	`decimal(19, 4)`	Unreleased Retainage	-
Description:No description available
	`RetainedDiscTotal`	`decimal(19, 4)`		-
Description:No description available
	`RetainedTaxTotal`	`decimal(19, 4)`		-
Description:No description available
	`RGOLAmt`	`decimal(19, 4)`		-
Description:Realized Gain and Loss amount associated with the document.
	`RoundDiff`	`decimal(19, 4)`		-
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.)
	`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.
	`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.
	`Selected`Nonexistent in DB	`bit`	Selected	-
Description:Indicates whether the record is selected for mass processing or not.
	`Status`	`char(1)`	Status	-
Description:No description available
	`TaxCalcMode`	`char(1)`	Tax Calculation Mode	-
Description:No description available
	`TaxCostINAdjRefNbr`Default Navigation	`nvarchar(15)`	Adjustment Nbr.	INRegister
Description:No description available
	`TaxRoundDiff`	`decimal(19, 4)`		-
Description:No description available
	`TaxWheld`	`decimal(19, 4)`		-
Description:The amount of tax withheld from the payments to the document. (Presented in the base currency of the company, see Company.BaseCuryID)
	`TranPeriodID`	`char(6)`	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.
	`tstamp`	`timestamp`		-
Description:No description available
	`VendorID`Default Navigation	`int`	Vendor	Vendor
Description:No description available
	`VendorLocationID`Default Navigation	`int`	Location	Location
Description:No description available
	`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(19, 4)`		-
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:No description available