AP
APInvoice
Represents AP Invoices, Credit and Debit Adjustments. The DAC is based on APRegister and extends it with the fields relevant to the documents of the above types.
View API Entity: Bill
/entity/Default/25.200.001/Bill| 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. | ||||
BranchBaseCuryIDNonexistent in DB | string | - | ||
Description:No description available | ||||
BranchID API | 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) | ||||
ClDisplayNameNonexistent in DB | string | - | ||
Description:No description available | ||||
ClosedDate | datetime | Closed Date | - | |
Description:The date of the last application. | ||||
ClosedFinPeriodID | string | Closed Period | - | |
Description:The Financial Period, in which the document was closed. Corresponds to the FinPeriodID field. | ||||
ClosedTranPeriodID | string | Closed 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) | ||||
CuryDetailExtPriceTotalNonexistent in DB | decimal? | Detail Total | - | |
Description:Sum of ext value (line total and line discount total) | ||||
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 API | 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 | Balance | - | |
Description:The entered in migration mode balance of the document. Given in the currency of the document. | ||||
CuryLineDiscTotal | decimal | Line Discounts | - | |
Description:The total discount of the document (in the currency of the document), which is calculated as the sum of line discounts of the order. | ||||
CuryLineRetainageTotal | decimal | - | ||
Description:No description available | ||||
CuryLineTotal | decimal | Detail Total | - | |
Description:The document total presented in the currency of the document. (See CuryID) | ||||
CuryOrderDiscTotalNonexistent in DB | decimal? | Discount Total | - | |
Description:The total discount of the document (in the currency of the document), which is calculated as the sum of all group, document and line discounts of the invoice. | ||||
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 | 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.) | ||||
CuryTaxAmt | decimal | Tax Amount | - | |
Description:No description available | ||||
CuryTaxRoundDiff | decimal | Rounding Diff. | - | |
Description:No description available | ||||
CuryTaxTotal API | decimal | Tax Total | - | |
Description:The total amount of taxes associated with the document. (Presented in the currency of the document, see CuryID) | ||||
CuryTaxWheld | decimal | - | ||
Description:!REV! The amount of tax withheld from the payments to the document. (Presented in the currency of the document, see CuryID) | ||||
CuryVatExemptTotal | decimal | Tax Exempt Total | - | |
Description:The part of the document total that is exempt from VAT. This total is calculated as a sum of the taxable amounts for the taxes of type VAT, which are marked as exempt and are neither statistical nor reverse. (Presented in the currency of the document, see CuryID) | ||||
CuryVatTaxableTotal | decimal | Taxable Total | - | |
Description:The part of the document total, which is subject to VAT. This total is calculated as a sum of the taxable amounts for the taxes of type VAT, which are neither exempt, nor statistical, nor reverse. (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. | ||||
DetailExtPriceTotalNonexistent in DB | decimal? | - | ||
Description:Sum of ext value (line total and line discount total) | ||||
DisableAutomaticDiscountCalculation | bit | Disable Automatic Discount Update | - | |
Description:No description available | ||||
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) | ||||
DiscDate | datetime | Cash Discount Date | - | |
Description:The date when the cash discount can be taken in accordance with the credit terms. | ||||
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 API | datetime | Date | - | |
Description:Date of the 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: "INV" - Invoice, "ACR" - Credit Adjustment, "ADR" - Debit Adjustment, "PPM" - Prepayment, "PPI" - Prepayment Invoice | ||||
DocumentKeyNonexistent in DB | string | Document Description | - | |
Description:No description available | ||||
DontApprove | bit | Don't Approve | - | |
Description:Indicates that the current document should be excluded from the approval process. | ||||
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 Invoice, Credit Adjustment, Prepayment, Cash Purchase) and ""C"" (for Debit Adjustment and Voided Cash Purchase). | ||||
DueDate API | datetime | Due Date | - | |
Description:The date when payment for the document is due in accordance with the credit terms. | ||||
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. | ||||
EntityUsageType | char(1) | Tax Exemption Type | - | |
Description:The entity usage type for reporting purposes. The field is used if the system is integrated with External Tax Calculation and the External Tax Calculation Integration feature is enabled. The field can have one of the values described in . Defaults to the Tax Exemption Type that is specified for the location of the branch. | ||||
EstPayDateNonexistent in DB | DateTime? | - | ||
Description:Estimated payment date. The field is calculated and equals either APInvoice.PayDate if the document is selected for payment or the APInvoice.DueDate otherwise. | ||||
ExternalTaxExemptionNumber | nvarchar(30) | Tax Exemption Number | - | |
Description:The tax exemption number for reporting purposes. The field is used if the system is integrated with External Tax Calculation and the External Tax Calculation Integration feature is enabled. | ||||
bool? | - | |||
Description:No description available | ||||
FinPeriodID API | 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 | ||||
HasUseTaxNonexistent in DB | bool? | - | ||
Description:No description available | ||||
HasWithHoldTaxNonexistent in DB | bool? | - | ||
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. | ||||
InitDocBal | decimal | - | ||
Description:The entered in migration mode balance of the document. Given in the base currency of the company. | ||||
InstallmentCntr | smallint | Number of Installments | - | |
Description:Counter of the document's installments. | ||||
InstallmentNbr | smallint | - | ||
Description:The number of the installment, which the document represents. Corresponds to the TermsInstallments.InstallmentNbr field. | ||||
IntercompanyInvoiceNoteID | uniqueidentifier | Related AR Document | ARInvoice | |
Description:No description available | ||||
InternalDocTypeNonexistent in DB | string | Document Type (Internal) | - | |
Description:No description available | ||||
InvoiceDate | datetime | Vendor Ref. Date | - | |
Description:The document’s original date as assigned by the vendor (for informational purposes). | ||||
InvoiceNbr API | nvarchar(40) | Vendor Ref. | - | |
Description:The document’s original reference number as assigned by the vendor (for informational purposes). The reference to the vendor document is required if APSetup.RequireVendorRef is set to "true". The reference should also be unique if APSetup.RaiseErrorOnDoubleInvoiceNbr is set to "true". | ||||
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. | ||||
IsJointPayees | bit | Joint Payees | - | |
Description:No description available | ||||
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 | ||||
IsTaxDocument | bit | - | ||
Description:Specifies (if set to "true") that the document is tax bill and orginally has been created by tax reporting process. | ||||
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. | ||||
LCEnabledNonexistent in DB | bool? | - | ||
Description:Indicates whether landed cost is enabled for the document. Equals "true" if the vendor of the document is a Landed Cost vendor. | ||||
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. | ||||
LineDiscTotal | decimal | Line Discounts | - | |
Description:The total line discount of the document, which is calculated as the sum of line discounts of the invoice. | ||||
LineRetainageTotal | decimal | - | ||
Description:No description available | ||||
LineTotal | decimal | - | ||
Description:The document total presented in the base currency of the company. (See Company.BaseCuryID) | ||||
ManualEntryNonexistent in DB | bool? | - | ||
Description:No description available | ||||
MasterRefNbr | nvarchar(15) | - | ||
Description:For an installment this field holds the reference number of the master document. | ||||
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. | ||||
OrderDiscTotalNonexistent in DB | decimal? | Discount Total | - | |
Description:The total discount of the document, which is calculated as the sum of group, document and line discounts of the invoice. | ||||
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. | ||||
PayAccountID API | int | Cash Account | CashAccount | |
Description:The cash account used for the payment. Defaults to the cash account associated with the selected location and payment method. In case such account is not found the default value will be the cash account which is specified as default for AP for the selected payment method. | ||||
PayDate | datetime | Pay Date | - | |
Description:The date when the bill has been approved for payment. | ||||
PayLocationID | int | Payment Location | - | |
Description:Vendor location for payment. Defaults to vendor's default location or to the first active location of the vendor if the former is not set. | ||||
PaySel API | bit | Approved for Payment | - | |
Description:When set to "true" indicates that the document is approved for payment. | ||||
PayTypeID | 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. | ||||
PaymentInfoLocationIDNonexistent in DB | int? | Location | ||
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. | ||||
PrebookAcctID | int | Reclassification Account | Account | |
Description:The expense account used to record the expenses pending reclassification. The field is relevant only if the Support for Expense Reclassification feature is activated and the document has or has had the Prebooked (""K"") status. (See APRegister.Prebooked) Defaults to the account associated with the vendor of the document. Corresponds to the AccountID field. | ||||
PrebookBatchNbr | nvarchar(15) | Pre-Releasing Batch Nbr. | Batch | |
Description:Stores the number of the Batch generated during prebooking. Corresponds to the Batch.BatchNbr field. | ||||
PrebookSubID | int | Reclassification Subaccount | Sub | |
Description:The subaccount used to record the expenses pending reclassification. The field is relevant only if the Support for Expense Reclassification feature is activated and the document has or has had the Prebooked (""K"") status. (See APRegister.Prebooked) Defaults to the subaccount associated with the vendor of the document. Corresponds to the AccountID 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 API | int | Project | PMProject | |
Description:No description available | ||||
RGOLAmt | decimal | - | ||
Description:Realized Gain and Loss amount associated with the document. | ||||
ReceivedDate | datetime | Received Date | - | |
Description:No description available | ||||
Reclassified | bit | - | ||
Description:True if the invoice was reclassified | ||||
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. | ||||
RenameFileScreenIdNonexistent in DB | bool? | - | ||
Description:No description available | ||||
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. | ||||
SeparateCheck | bit | Pay Separately | - | |
Description:When set to "true" indicates that the document should be paid for by a separate check. In other words, the payment to such a document must not be consolidated with other payments. Defaults to the value of the same setting for vendor. | ||||
SetWarningOnDiscountNonexistent in DB | bool? | - | ||
Description:No description available | ||||
SquareSumProjectID | bigint | - | ||
Description:The sum of squares of integer IDs of all projects in document's detail lines. | ||||
Status API | 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. | ||||
SuppliedByVendorID | int | Supplied-By Vendor | Vendor | |
Description:A reference to the Vendor. An integer identifier of the vendor that supplied the goods. | ||||
SuppliedByVendorLocationID | int | Supplied-By Vendor Location | Location | |
Description:Identifier of the Location of the Supplied-By Vendor, associated with the document. Corresponds to the Location.LocationID field. Defaults to AP bill's vendor location. | ||||
TPAR | bit | Track for TPAR | - | |
Description:No description available | ||||
TaxAmt | decimal | - | ||
Description:No description available | ||||
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 | ||||
TaxTotal | decimal | - | ||
Description:The total amount of taxes associated with the document. (Presented in the base currency of the company, see Company.BaseCuryID) | ||||
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) | ||||
TaxZoneID | nvarchar(10) | Vendor Tax Zone | TaxZone | |
Description:Identifier of the tax zone associated with the document. Defaults to vendor's tax zone. | ||||
TermsID API | nvarchar(10) | Terms | Terms | |
Description:The credit terms associated with the document (unavailable for prepayments and debit adjustments).\ Defaults to the credit terms of the vendor. | ||||
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. | ||||
VatExemptTotal | decimal | - | ||
Description:The part of the document total that is exempt from VAT. This total is calculated as a sum of the taxable amounts for the taxes of type VAT, which are marked as exempt and are neither statistical nor reverse. (Presented in the base currency of the company, see Company.BaseCuryID) | ||||
VatTaxableTotal | decimal | - | ||
Description:The part of the document total, which is subject to VAT. This total is calculated as a sum of the taxable amounts for the taxes of type VAT, which are neither exempt, nor statistical, nor reverse. (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 API | 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 | 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 | ||||