AP
APInvoice
PX.Objects.APView API Entity: Bill
/entity/Default/24.200.001/Bill186 of 186 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
DocType | char(3) | Type | - | |
Description:Type of the document. Possible values are: "INV" - Invoice, "ACR" - Credit Adjustment, "ADR" - Debit Adjustment, "PPM" - Prepayment. | ||||
RefNbr | nvarchar(15) | Reference Nbr. | APRegister | |
Description:No description available | ||||
AdjCntr | int | - | ||
Description:No description available | ||||
APAccountID | int | AP Account | Account | |
Description:No description available | ||||
Approved | bit | - | ||
Description:No description available | ||||
APSubID | int | AP Subaccount | Sub | |
Description:No description available | ||||
BatchNbr | nvarchar(15) | Batch Nbr. | Batch | |
Description:No description available | ||||
BranchID API | int | Branch | Branch | |
Description:No description available | ||||
ChargeAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
ClosedDate | datetime2 | Closed Date | - | |
Description:No description available | ||||
ClosedFinPeriodID | char(6) | Closed Period | - | |
Description:No description available | ||||
ClosedTranPeriodID | char(6) | Closed Master Period | - | |
Description:No description available | ||||
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(19, 4) | Finance Charges | - | |
Description:No description available | ||||
CuryDetailExtPriceTotalNonexistent in DB | decimal | Detail Total | - | |
Description:Sum of ext value (line total and line discount total) | ||||
CuryDiscBal | decimal(19, 4) | Cash Discount Balance | - | |
Description:No description available | ||||
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 | ||||
CuryDiscTaken | decimal(19, 4) | - | ||
Description:No description available | ||||
CuryDiscTot | decimal(19, 4) | Discount Total | - | |
Description:No description available | ||||
CuryDocBal | decimal(19, 4) | Balance | - | |
Description:No description available | ||||
CuryDocDiscNonexistent in DBObsolete | decimal | Document Discount | - | |
Description:No description available | ||||
CuryID | nvarchar(5) | Currency | Currency | |
Description:No description available | ||||
CuryInfoID | bigint | CurrencyInfo | ||
Description:No description available | ||||
CuryInitDocBal | decimal(19, 4) | Balance | - | |
Description:No description available | ||||
CuryLineDiscTotal | decimal(19, 4) | 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(19, 4) | - | ||
Description:No description available | ||||
CuryLineTotal | decimal(19, 4) | 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(19, 4) | Cash Discount | - | |
Description:No description available | ||||
CuryOrigDocAmt | decimal(19, 4) | Amount | - | |
Description:No description available | ||||
CuryOrigDocAmtWithRetainageTotalNonexistent in DB | decimal | Total Amount | - | |
Description:No description available | ||||
CuryOrigWhTaxAmt | decimal(19, 4) | With. Tax | - | |
Description:No description available | ||||
CuryRetainagePaidTotalNonexistent 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 | ||||
CuryRetainageUnpaidTotalNonexistent 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:No description available | ||||
CuryTaxAmt | decimal(19, 4) | Tax Amount | - | |
Description:No description available | ||||
CuryTaxRoundDiff | decimal(19, 4) | Rounding Diff. | - | |
Description:No description available | ||||
CuryTaxTotal | decimal(19, 4) | Tax Total | - | |
Description:The total amount of taxes associated with the document. (Presented in the currency of the document, see CuryID) | ||||
CuryTaxWheld | decimal(19, 4) | - | ||
Description:No description available | ||||
CuryVatExemptTotal | decimal(19, 4) | 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(19, 4) | 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(19, 4) | - | ||
Description:No description available | ||||
DefRetainagePct | decimal(9, 6) | Default Retainage Percent | - | |
Description:No description available | ||||
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(19, 4) | - | ||
Description:No description available | ||||
DiscDate | datetime2 | Cash Discount Date | - | |
Description:The date when the cash discount can be taken in accordance with the credit terms. | ||||
DiscountedDocTotalNonexistent in DB | decimal | - | ||
Description:No description available | ||||
DiscountedPriceNonexistent in DB | decimal | - | ||
Description:No description available | ||||
DiscountedTaxableTotalNonexistent in DB | decimal | - | ||
Description:No description available | ||||
DiscTaken | decimal(19, 4) | - | ||
Description:No description available | ||||
DiscTot | decimal(19, 4) | - | ||
Description:No description available | ||||
DisplayCuryInitDocBal | decimal | Migrated Balance | - | |
Description:No description available | ||||
DocBal | decimal(19, 4) | - | ||
Description:No description available | ||||
DocClassNonexistent in DB | nchar(1) | - | ||
Description:No description available | ||||
DocDate | datetime2 | Date | - | |
Description:No description available | ||||
DocDesc | nvarchar(512) | Description | - | |
Description:No description available | ||||
DocDiscNonexistent in DBObsolete | decimal | - | ||
Description:No description available | ||||
DocumentKey | nvarchar(50) | 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 | nchar(1) | - | ||
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 | datetime2 | Due Date | - | |
Description:The date when payment for the document is due in accordance with the credit terms. | ||||
EmployeeID | int | Owner | Contact | |
Description:No description available | ||||
EmployeeWorkgroupID | int | Workgroup ID | EPCompanyTree | |
Description:No description available | ||||
EntityUsageType | char(1) | Tax Exemption Type | - | |
Description:No description available | ||||
EstPayDate | 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. | ||||
ExternalTaxesImportInProgressNonexistent in DB | bit | - | ||
Description:No description available | ||||
ExternalTaxExemptionNumber | nvarchar(30) | Tax Exemption Number | - | |
Description:No description available | ||||
FinPeriodID | char(6) | Post Period | - | |
Description:No description available | ||||
HasMultipleProjects | bit | - | ||
Description:No description available | ||||
HasPPDTaxes | bit | - | ||
Description:No description available | ||||
HasUseTaxNonexistent in DB | bit | - | ||
Description:No description available | ||||
HasWithHoldTaxNonexistent in DB | bit | - | ||
Description:No description available | ||||
HiddenKeyNonexistent in DB | nvarchar(MAX) | - | ||
Description:No description available | ||||
Hold API | bit | Hold | - | |
Description:No description available | ||||
ImpRefNbr | nvarchar(15) | - | ||
Description:No description available | ||||
InitDocBal | decimal(19, 4) | - | ||
Description:No description available | ||||
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 | ||||
InvoiceDate | datetime2 | Vendor Ref. Date | - | |
Description:The document’s original date as assigned by the vendor (for informational purposes). | ||||
InvoiceNbr | 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:No description available | ||||
IsJointPayees | bit | Joint Payees | - | |
Description:No description available | ||||
IsMigratedRecord | bit | - | ||
Description:No description available | ||||
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:No description available | ||||
IsTaxSaved | bit | Tax has been saved in the external tax provider | - | |
Description:No description available | ||||
IsTaxValid API | bit | Tax Is Up to Date | - | |
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 | ||||
LCEnabledNonexistent in DB | bit | LCEnabled | - | |
Description:Indicates whether landed cost is enabled for the document. Equals "true" if the vendor of the document is a Landed Cost vendor. | ||||
LineCntr | int | - | ||
Description:No description available | ||||
LineDiscTotal | decimal(19, 4) | Line Discounts | - | |
Description:The total line discount of the document, which is calculated as the sum of line discounts of the invoice. | ||||
LineRetainageTotal | decimal(19, 4) | - | ||
Description:No description available | ||||
LineTotal | decimal(19, 4) | - | ||
Description:The document total presented in the base currency of the company. (See Company.BaseCuryID) | ||||
ManualEntry | bit | - | ||
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:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OpenDoc | bit | Open | - | |
Description:No description available | ||||
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(19, 4) | - | ||
Description:No description available | ||||
OrigDocAmt | decimal(19, 4) | Amount | - | |
Description:No description available | ||||
OrigDocAmtWithRetainageTotalNonexistent in DB | decimal | Total Amount | - | |
Description:No description available | ||||
OrigDocDate | datetime2 | - | ||
Description:No description available | ||||
OrigDocType | char(3) | Orig. Doc. Type | - | |
Description:No description available | ||||
OrigModule | char(2) | Source | - | |
Description:No description available | ||||
OrigRefNbr | nvarchar(15) | Orig. Ref. Nbr. | - | |
Description:No description available | ||||
OrigWhTaxAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
OwnerIDNonexistent in DB | int | Approver | Contact | |
Description:No description available | ||||
PayAccountID | int | Cash Account | CashAccount | |
Description:No description available | ||||
PayDate | datetime2 | Pay Date | - | |
Description:No description available | ||||
PayLocationID | int | Payment Location | Location | |
Description:No description available | ||||
PaymentInfoLocationIDNonexistent in DB | int | Location | ||
Description:No description available | ||||
PaymentsByLinesAllowed | bit | Pay by Line | - | |
Description:No description available | ||||
PaySel | bit | Approved for Payment | - | |
Description:When set to "true" indicates that the document is approved for payment. | ||||
PayTypeID | nvarchar(10) | Payment Method | PaymentMethod | |
Description:No description available | ||||
PendingPayment | bit | - | ||
Description:No description available | ||||
PendingPPD | bit | - | ||
Description:No description available | ||||
PendingProcessing | bit | - | ||
Description:No description available | ||||
PrebookAcctID | int | Reclassification Account | Account | |
Description:No description available | ||||
PrebookBatchNbr | nvarchar(15) | Pre-Releasing Batch Nbr. | Batch | |
Description:No description available | ||||
Prebooked | bit | Prebooked | - | |
Description:No description available | ||||
PrebookSubID | int | Reclassification Subaccount | Sub | |
Description:No description available | ||||
PrepaymentAccountID | int | Prepayment Account | Account | |
Description:No description available | ||||
PrepaymentSubID | int | Prepayment Subaccount | Sub | |
Description:No description available | ||||
PrintDocTypeNonexistent in DB | nchar(3) | Type | - | |
Description:No description available | ||||
Printed | bit | - | ||
Description:No description available | ||||
ProjectID | int | Project | PMProject | |
Description:No description available | ||||
Reclassified | bit | - | ||
Description:No description available | ||||
RefNoteID | uniqueidentifier | - | ||
Description:No description available | ||||
Rejected | bit | - | ||
Description:No description available | ||||
Released | bit | Released | - | |
Description:No description available | ||||
ReleasedOrPrebookedNonexistent in DB | bit | - | ||
Description:No description available | ||||
ReleasedToVerifyNonexistent in DB | bit | - | ||
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(19, 4) | Released Retainage | - | |
Description:No description available | ||||
RetainageSubID | int | Retainage Payable Sub. | Sub | |
Description:No description available | ||||
RetainageTotal | decimal(19, 4) | Original Retainage | - | |
Description:No description available | ||||
RetainageUnpaidTotalNonexistent 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:No description available | ||||
RoundDiff | decimal(19, 4) | - | ||
Description:No description available | ||||
Scheduled | bit | - | ||
Description:No description available | ||||
ScheduleID | nvarchar(15) | Schedule | ||
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
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 | bit | - | ||
Description:No description available | ||||
Status API | char(1) | Status | - | |
Description:No description available | ||||
SuppliedByVendorID | int | Supplied-By Vendor | Vendor | |
Description:No description available | ||||
SuppliedByVendorLocationID | int | Supplied-By Vendor Location | Location | |
Description:No description available | ||||
TaxAmt | decimal(19, 4) | - | ||
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(19, 4) | - | ||
Description:No description available | ||||
TaxTotal API | decimal(19, 4) | - | ||
Description:The total amount of taxes associated with the document. (Presented in the base currency of the company, see Company.BaseCuryID) | ||||
TaxWheld | decimal(19, 4) | - | ||
Description:No description available | ||||
TaxZoneID | nvarchar(10) | Vendor Tax Zone | TaxZone | |
Description:Identifier of the tax zone associated with the document. Defaults to vendor's tax zone. | ||||
TermsID | nvarchar(10) | Terms | Terms | |
Description:No description available | ||||
TranPeriodID | char(6) | Master Period | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
VatExemptTotal | decimal(19, 4) | - | ||
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(19, 4) | - | ||
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) | ||||
VendorID | int | Vendor | Vendor | |
Description:No description available | ||||
VendorLocationID | int | Location | Location | |
Description:No description available | ||||
VoidBatchNbr | nvarchar(15) | Void Batch Nbr. | Batch | |
Description:No description available | ||||
Voided | bit | Void | - | |
Description:No description available | ||||
WhTaxBal | decimal(19, 4) | - | ||
Description:No description available | ||||
WorkgroupIDNonexistent in DB | int | Approval Workgroup ID | EPCompanyTree | |
Description:No description available | ||||