CA
CADepositEntry.APPaymentUpdate
No summary is documented for this DAC in the release source.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
APAccountID | int | AP Account | Account | |
Description:Identifier of the AP account, to which the document belongs. Corresponds to the Account.AccountID field. | ||||
APSubID | 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 | nvarchar(15) | Batch Nbr. | Batch | |
Description:Number of the Batch, generated for the document on release. Corresponds to the Batch.BatchNbr field. | ||||
BranchID | int | Branch | Branch | |
Description:Identifier of the Branch, to which the document belongs. Corresponds to the Branch.BranchID field. | ||||
CATranID | bigint | - | ||
Description:No description available | ||||
CashAccountID | int | - | ||
Description:No description available | ||||
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 | 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) | ||||
CuryDiscountedDocTotalNonexistent in DB | decimal? | Discounted Doc. Total | - | |
Description:No description available | ||||
CuryDiscountedPriceNonexistent in DB | decimal? | Tax on Discounted Price | - | |
Description:No description available | ||||
CuryDiscountedTaxableTotalNonexistent 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) | ||||
CuryDocDiscNonexistent in DBObsolete | decimal? | Document Discount | - | |
Description:No description available | ||||
CuryID | 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) | ||||
CuryOrigDocAmtWithRetainageTotalNonexistent 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) | ||||
CuryRetainagePaidTotalNonexistent 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 | ||||
CuryRetainageUnpaidTotalNonexistent 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 | ||||
DepositAfter | datetime | - | ||
Description:No description available | ||||
DepositAsBatch | bit | - | ||
Description:No description available | ||||
DepositNbr | nvarchar(15) | - | ||
Description:No description available | ||||
DepositType | char(3) | - | ||
Description:No description available | ||||
Deposited | bit | - | ||
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) | ||||
DiscountedDocTotalNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
DiscountedPriceNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
DiscountedTaxableTotalNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
DisplayCuryInitDocBalNonexistent 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) | ||||
DocClassNonexistent 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. | ||||
DocDiscNonexistent 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 | int | Owner | EPEmployee | |
Description:The Contact responsible for the document. Corresponds to the Contact.ContactID field. | ||||
EmployeeWorkgroupID | int | Workgroup ID | EPCompanyTree | |
Description:The workgroup that is responsible for the document. Corresponds to the EPCompanyTree.WorkGroupID field. | ||||
ExtRefNbr | nvarchar(40) | - | ||
Description:No description available | ||||
FinPeriodID | 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 | ||||
HiddenKeyNonexistent 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. | ||||
InternalDocTypeNonexistent 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 | 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) | ||||
OrigDocAmtWithRetainageTotalNonexistent 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 | int | Approver | Contact | |
Description:The contact responsible for document approval process. Corresponds to the Contact.ContactID field. | ||||
PaymentMethodID | nvarchar(10) | - | ||
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: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 | 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 | 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 | 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. | ||||
PrintDocTypeNonexistent 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 | int | Project | PMProject | |
Description:No description available | ||||
RGOLAmt | decimal | - | ||
Description:Realized Gain and Loss amount associated with the document. | ||||
RefNbr | 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. | ||||
ReleasedOrPrebookedNonexistent in DB | bool? | - | ||
Description:Read-only field that is equal to "true" in case the document was either prebooked or 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 Payable 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 Payable Sub. | Sub | |
Description:No description available | ||||
RetainageTotal | decimal | Original Retainage | - | |
Description:No description available | ||||
RetainageUnpaidTotalNonexistent 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. | ||||
SelectedNonexistent 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 | 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. | ||||
VendorAcctNameNonexistent in DB | string | - | ||
Description:Identifier of the BAccount of the Vendor. Corresponds to the BAccount.AcctName field. | ||||
VendorCDNonexistent in DB | string | - | ||
Description:Identifier of the BAccount of the Vendor. Corresponds to the BAccount.AcctCD field. | ||||
VendorID | int | Vendor | Vendor | |
Description:Identifier of the BAccount of the Vendor. Corresponds to the BAccount.BAccountID field. | ||||
VendorLocationCDNonexistent in DB | string | - | ||
Description:Identifier of the Location of the Vendor. Corresponds to the Location.LocationCD field. | ||||
VendorLocationID | int | Location | Location | |
Description:Identifier of the Location of the Vendor. Corresponds to the Location.LocationID field. | ||||
VoidBatchNbr | 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) | ||||
WorkgroupIDNonexistent in DB | int? | Approval Workgroup ID | EPCompanyTree | |
Description:The workgroup that is responsible for document approval process. | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||