AP
APPayment
Represents Payments, Debit Adjustments, Prepayments, Refunds and Voided Payments in Accounts Payable module. This DAC extends APRegister with the fields specific to the documents of the above types.
View API Entity: Check
/entity/Default/25.200.001/Check| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
APAccountID | int | AP Account | Account | |
Description:This property was copied from the APRegister class. It is overriden only for correct order of the fields in _ClassFields list of PXCache class. The order of the fields is important for proper Restriction Groups operation. Corresponds to the Account.AccountID field. | ||||
APSubID | int | AP Subaccount | Sub | |
Description:This property was copied from the APRegister class. It is overriden only for correct order of the fields in _ClassFields list of PXCache class. The order of the fields is important for proper Restriction Groups operation. 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 | datetime | Application Date | - | |
Description:The date when the payment is applied. Defaults to the current business date. | ||||
AdjFinPeriodID | string | Application Period | FinPeriod | |
Description:The financial period of payment application. The value of this field is determined by the AdjDate field, but can be overriden manually. | ||||
AdjTranPeriodID | string | - | ||
Description:The financial period of payment application. Unlike the AdjFinPeriodID, the value of this field is determined solely by the AdjDate field and can't be overriden. | ||||
AmountToWordsNonexistent in DB | string | - | ||
Description:The amount that is spelled out. | ||||
ApplAmtNonexistent in DB | decimal? | - | ||
Description:The amount to be applied on the application date. (Presented in the base currency of the company, see Company.BaseCuryID) | ||||
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. | ||||
BatchPaymentRefNbrNonexistent in DB | string | - | ||
Description:No description available | ||||
BillCntr | int | - | ||
Description:The counter of the related bills. Note that this field is used internally for numbering purposes and its value may not reflect the actual count of the bills. | ||||
BranchBaseCuryIDNonexistent in DB | string | - | ||
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:Identifier of the Branch, to which the document belongs. The field must be located before the APPayment.APAccountID and APPayment.APSubID fields for correct Restriction Groups operation. Corresponds to the Branch.BranchID field. | ||||
CATranID | bigint | CATran | ||
Description:Identifier of the related transaction in Cash Management module. Corresponds to the CATran.CATranID field. | ||||
CanHaveBalanceNonexistent in DB | bool? | Can Have Balance | - | |
Description:Read-only field indicating whether the document can have balance. "true" for Debit Adjustments, Prepayments, Cash Purchases and Voided Payments. "false" for other documents. | ||||
CashAccountID API | int | Cash Account | CashAccount | |
Description:The cash account associated with the payment method. The field is irrelevant for debit adjustments. Corresponds to the CashAccount.CashAccountID field. Defaults to the cash account associated with the payment method and location. | ||||
ChargeAmt | decimal | - | ||
Description:The amount of charges associated with the document in the base currency of the company. (See Company.BaseCuryID) | ||||
ChargeCntr | int | - | ||
Description:The counter of the related charge entries. Note that this field is used internally for numbering purposes and its value may not reflect the actual count of the charges. | ||||
ClDisplayNameNonexistent in DB | string | - | ||
Description:No description available | ||||
ClearDate | datetime | Clear Date | - | |
Description:The date when the check was cleared. | ||||
Cleared | bit | Cleared | - | |
Description:When set to "true" indicates that the check was cleared in the process of reconciliation. | ||||
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 | ||||
CuryApplAmtNonexistent in DB | decimal? | Application Amount | - | |
Description:The amount to be applied on the application date. (Presented in the currency of the document, see CuryID) | ||||
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 API | 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 | Unapplied 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 API | decimal | Payment Amount | - | |
Description:The total payment amount that should be applied to the documents. (Presented in the currency of the document, see CuryID) | ||||
CuryOrigDocAmtWithRetainageTotalNonexistent in DB | decimal? | Total Amount | - | |
Description:No description available | ||||
CuryOrigTaxDiscAmt | decimal | - | ||
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) | ||||
CuryPOApplAmtNonexistent in DB | decimal? | Applied to Order | - | |
Description:The total prepayment amount that should be applied to the PO Orders. (Presented in the currency of the document, see CuryID) | ||||
CuryPOFullApplAmtNonexistent in DB | decimal? | - | ||
Description:The total prepayment amount (released and not, request and not documents) that should be applied to the PO Orders. (Presented in the currency of the document, see CuryID) | ||||
CuryPOUnreleasedApplAmtNonexistent in DB | decimal? | - | ||
Description:The total prepayment amount (unreleased documents) that should be applied to the PO Orders. (Presented 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) | ||||
decimal? | Unapplied Balance | - | ||
Description:The balance that has not been applied. This will be a nonzero value if the payment amount is not equal to a document’s total amount. Checks shall always have a zero unapplied balance. (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 | Deposit After | - | |
Description:Informational date specified on the document, which is the source of the deposit. Normally defaults to AdjDate for payments with DepositAsBatch set to "true". | ||||
DepositAsBatch | bit | Batch Deposit | - | |
Description:When set to "true" indicates that the payment can be included in a deposit. | ||||
DepositDateNonexistent in DB | DateTime? | Batch Deposit Date | - | |
Description:The date of deposit. Corresponds to the CADeposit.TranDate field | ||||
DepositNbr | nvarchar(15) | Batch Deposit Nbr. | CADeposit | |
Description:The reference number of the deposit document. Corresponds to the CADeposit.RefNbr field | ||||
DepositType | char(3) | - | ||
Description:The type of the deposit document. Corresponds to the CADeposit.TranType field | ||||
Deposited | bit | Deposited | - | |
Description:When equal to "true" indicates that the payment was deposited. | ||||
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 | Payment Date | - | |
Description:The date of the payment document. | ||||
DocDesc API | nvarchar(512) | Description | - | |
Description:Description of the document. | ||||
DocDiscNonexistent in DBObsolete | decimal? | - | ||
Description:No description available | ||||
DocType API | char(3) | Type | - | |
Description:Type of the document. Possible values are: "CHK" - Payment, "ADR" - Debit Adjustment, "PPM" - Prepayment, "REF" - Refund, "VCK" - Voided Payment | ||||
DontApprove | bit | - | ||
Description:No description available | ||||
DrCrNonexistent in DB | string | - | ||
Description:Read-only field indicating whether the document is of debit or credit type. The value of this field is based solely on the DocType field. Possible values are ""D"" (for Refund and Voided Cash Purchase) and ""C"" (for Payment, Voided Payment, Debit Adjustment, Prepayment and Cash Purchase). | ||||
EmailRemittances | bit | Send Remittances by Email | - | |
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 API | nvarchar(40) | Payment Ref. | - | |
Description:A payment reference number, which can be a system-generated number or an external reference number (such as a wire transfer number or a bank check number) entered manually. Irrelevant for Debit Adjustments. | ||||
ExternalOrganizationID | nvarchar(50) | External Organization ID | - | |
Description:External organization id | ||||
ExternalPaymentBatchNbr | nvarchar(10) | Batch Number | - | |
Description:External payment Batch number | ||||
ExternalPaymentCanceled | bit | - | ||
Description:Set to true if cancellation of payment is accepted by external payment processor. | ||||
ExternalPaymentCardNbr | nvarchar(20) | Card Number | - | |
Description:External payment check or card number | ||||
ExternalPaymentCheckNbr | nvarchar(20) | Check Number | - | |
Description:External payment check or card number | ||||
ExternalPaymentDisbursementType | nvarchar(25) | Disbursement Method | - | |
Description:Disbursement Type used to process the payment | ||||
ExternalPaymentID | nvarchar(50) | External Payment ID | - | |
Description:Payment ID in external payment processor | ||||
ExternalPaymentIsVoidable | bit | - | ||
Description:Set to false if payment can not be voided in external payment processor. | ||||
ExternalPaymentSentDate | datetime | Sent Date | - | |
Description:Date of payment sent. | ||||
ExternalPaymentStatus | nvarchar(50) | Processing Status | - | |
Description:External payment status | ||||
ExternalPaymentTraceNbr | nvarchar(10) | Trace Number | - | |
Description:External payment trace number | ||||
ExternalPaymentUpdateTime | datetime | Update Date | - | |
Description:Date of the document updated in external payment processor. | ||||
FinPeriodID | string | Payment Period | FinPeriod | |
Description:The financial period of the document. The value of this field is determined by the DocDate field, but can be overriden manually. | ||||
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 API | 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. | ||||
IncludeInT5018Report | bit | Include in T5018 Report | - | |
Description:Flag that indicates that the Prepayment should be included into T5018 Report even if the Prepayment is not applied in full. | ||||
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. | ||||
IsPrintingProcessNonexistent in DB | bool? | - | ||
Description:Indicates that this check under printing processing to prevent update CashAccountCheck table by AP.PaymentRefAttribute /> | ||||
IsReleaseCheckProcessNonexistent in DB | bool? | - | ||
Description:Indicates that this check under release processing to prevent the question about the saving of the last check number by AP.PaymentRefAttribute /> | ||||
IsRequestPrepaymentNonexistent in DB | bool? | - | ||
Description:No description available | ||||
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. | ||||
JointPayeeID | int | - | ||
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime API | 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. | ||||
OrigTaxDiscAmt | decimal | - | ||
Description:No description available | ||||
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. | ||||
POApplAmtNonexistent in DB | decimal? | - | ||
Description:The total prepayment amount that should be applied to the PO Orders. | ||||
POFullApplAmtNonexistent in DB | decimal? | - | ||
Description:The total prepayment amount (released and not, request and not documents) that should be applied to the PO Orders. | ||||
POUnreleasedApplAmtNonexistent in DB | decimal? | - | ||
Description:The total prepayment amount (unreleased documents) that should be applied to the PO Orders. | ||||
PaymentCannotbeVoidedMessageNonexistent in DB | string | - | ||
Description:Payment can not be voided message | ||||
PaymentMethodID API | nvarchar(10) | Payment Method | PaymentMethod | |
Description:The payment method used for the document. Corresponds to the PaymentMethod.PaymentMethodID field. Defaults to the payment method associated with the vendor location. | ||||
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. | ||||
PrintCheck | bit | Print Check | - | |
Description:When set to "true" indicates that a check must be printed for the payment represented by this record. | ||||
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. | ||||
PrintRemittances | bit | Print Remittances | - | |
Description:No description available | ||||
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 API | nvarchar(15) | Reference Nbr. | APRegisterAlias | |
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. | ||||
RemitAddressID | int | Address | ||
Description:Remittance address for the document. Defaults to the remittance address of the vendor. | ||||
RemitContactID | int | Remittance Contact | Contact | |
Description:Remittance contact for the document. Defaults to the remittance contact of the vendor. | ||||
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 API | char(1) | Status | - | |
Description:Status of the document. The field is calculated based on the values of status flag. It can't be changed directly. The fields tht determine status of a document are: Hold, Released, Voided, Scheduled, Prebooked, Printed Possible values are: ""H"" - Hold, ""B"" - Balanced, ""V"" - Voided, ""S"" - Scheduled, ""N"" - Open, ""C"" - Closed, ""P"" - Printed, ""K"" - Prebooked. Defaults to Hold. | ||||
StubCntr | int | - | ||
Description:The counter of the related pay stubs. Note that this field is used internally for numbering purposes and its value may not reflect the actual count of the pay stubs. | ||||
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:The financial period of the document corresponding to the payment date. Unlike the FinPeriodID, the value of this field is determined solely by the AdjDate field and can't be overriden. | ||||
UnappliedBalNonexistent in DB | decimal? | - | ||
Description:The balance that has not been applied. This will be a nonzero value if the payment amount is not equal to a document’s total amount. Checks shall always have a zero unapplied balance. (Presented in the base currency of the company, see Company.BaseCuryID) | ||||
VendorBaseCuryIDNonexistent in DB | string | - | ||
Description:No description available | ||||
VendorID API | int | Vendor | Vendor | |
Description:Identifier of the Vendor, whom the document belongs to. | ||||
VendorLocationID | 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. | ||||
VoidApplNonexistent in DB | bool? | Void Application | - | |
Description:When "true" indicates that the document is Voided Payment. Setting this field to "true" will change the type of the document to Voided Payment (""VCK""). | ||||
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 | Voided | - | |
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 | ||||