AR
ARInvoice
PX.Objects.ARView API Entity: Invoice
/entity/Default/24.200.001/Invoice247 of 247 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
DocType | char(3) | Type | - | |
Description:No description available | ||||
RefNbr | nvarchar(15) | Reference Nbr. | ARRegister | |
Description:No description available | ||||
AdjCntr | int | - | ||
Description:No description available | ||||
ApplicationBalanceNonexistent in DB | decimal | - | ||
Description:No description available | ||||
ApplyOverdueCharge | bit | Apply Overdue Charges | - | |
Description:No description available | ||||
ApplyPaymentWhenTaxAvailableNonexistent in DB | bit | - | ||
Description:No description available | ||||
Approved | bit | - | ||
Description:No description available | ||||
ApprovedCaptureFailed | bit | - | ||
Description:No description available | ||||
ApprovedCredit | bit | - | ||
Description:No description available | ||||
ApprovedCreditAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
ApprovedPrepaymentRequired | bit | - | ||
Description:No description available | ||||
ApproverID | int | Owner | Contact | |
Description:No description available | ||||
ApproverWorkgroupID | int | Approval Workgroup ID | EPCompanyTree | |
Description:No description available | ||||
ARAccountID | int | AR Account | Account | |
Description:No description available | ||||
ARSubID | int | AR Subaccount | Sub | |
Description:No description available | ||||
AuthorizedPaymentCntr | int | - | ||
Description:No description available | ||||
AvalaraCustomerUsageType | char(1) | Tax Exemption Type | - | |
Description:No description available | ||||
BalanceWOTotal | decimal(19, 4) | - | ||
Description:No description available | ||||
BatchNbr | nvarchar(15) | Batch Nbr. | Batch | |
Description:No description available | ||||
BatchSeq | smallint | - | ||
Description:No description available | ||||
BillAddressID | int | ARAddress | ||
Description:No description available | ||||
BillContactID | int | Billing Contact | ARContact | |
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
Canceled | bit | - | ||
Description:No description available | ||||
CaptureFailedCntr | int | - | ||
Description:No description available | ||||
CashAccountID | int | Cash Account | CashAccount | |
Description:No description available | ||||
CCAuthorizedAmtNonexistent in DB | decimal | - | ||
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 Period | - | |
Description:No description available | ||||
CommnAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
CommnblAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
CommnPct | decimal(9, 6) | Commission % | - | |
Description:No description available | ||||
CorrectionDocTypeNonexistent in DB | nchar(3) | - | ||
Description:No description available | ||||
CorrectionRefNbrNonexistent in DB | nvarchar(15) | - | ||
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime API | datetime | Created On | - | |
Description:No description available | ||||
CreditHold | bit | Credit Hold | - | |
Description:No description available | ||||
CuryApplicationBalanceNonexistent in DB | decimal | Application Balance | - | |
Description:No description available | ||||
CuryBalanceWOTotal | decimal(19, 4) | Write-Off Total | - | |
Description:No description available | ||||
CuryCCAuthorizedAmtNonexistent in DB | decimal | Authorized | - | |
Description:No description available | ||||
CuryChargeAmt | decimal(19, 4) | Finance Charges | - | |
Description:No description available | ||||
CuryCommnAmt | decimal(19, 4) | Commission Amt. | - | |
Description:No description available | ||||
CuryCommnblAmt | decimal(19, 4) | Total Commissionable | - | |
Description:No description available | ||||
CuryDetailExtPriceTotal | decimal | Detail Total | - | |
Description:No description available | ||||
CuryDiscAppliedAmt | decimal(19, 4) | Cash Discount Taken | - | |
Description:No description available | ||||
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) | Group and Document 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 | ||||
CuryDocumentDiscTotal | decimal(19, 4) | Document Discount | - | |
Description:No description available | ||||
CuryFreightAmt | decimal(19, 4) | Freight Price | - | |
Description:No description available | ||||
CuryFreightCost | decimal(19, 4) | Freight Cost | - | |
Description:No description available | ||||
CuryFreightTot | decimal(19, 4) | Freight Total | - | |
Description:No description available | ||||
CuryGoodsExtPriceTotal | decimal(19, 4) | Goods | - | |
Description:The total amount on all lines of the document, except for Misc. Charges and null or empty Line Types (in the currency of the document). | ||||
CuryGoodsTotal | decimal(19, 4) | Goods Total | - | |
Description:No description available | ||||
CuryGroupDiscTotal | decimal(19, 4) | Group Discounts | - | |
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:No description available | ||||
CuryMiscExtPriceTotal | decimal(19, 4) | Misc. Charges | - | |
Description:The total amount calculated as the sum of the amounts in Ext. Price (in the currency of the document). | ||||
CuryMiscTot | decimal(19, 4) | Misc. Total | - | |
Description:No description available | ||||
CuryOrderDiscTotal | decimal | Discount Total | - | |
Description:No description available | ||||
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 | ||||
CuryPaidAmtNonexistent in DB | decimal | Released | - | |
Description:No description available | ||||
CuryPaymentTotal | decimal(19, 4) | Total Paid | - | |
Description:No description available | ||||
CuryPremiumFreightAmt | decimal(19, 4) | Premium Freight Price | - | |
Description:No description available | ||||
CuryRetainagePaidTotalNonexistent in DB | decimal | Paid/Adjusted Retainage | - | |
Description:No description available | ||||
CuryRetainageReleased | decimal(19, 4) | Released Retainage | - | |
Description:No description available | ||||
CuryRetainageTotal | decimal(19, 4) | Original Retainage | - | |
Description:No description available | ||||
CuryRetainageUnpaidTotal | decimal(19, 4) | 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 | ||||
CuryTaxTotal | decimal(19, 4) | Tax Total | - | |
Description:No description available | ||||
CuryUnpaidBalance | decimal(19, 4) | Unpaid Balance | - | |
Description:No description available | ||||
CuryUnreleasedPaymentAmtNonexistent in DB | decimal | Not Released | - | |
Description:No description available | ||||
CuryVatExemptTotal | decimal(19, 4) | Tax Exempt Total | - | |
Description:No description available | ||||
CuryVatTaxableTotal | decimal(19, 4) | Taxable Total | - | |
Description:No description available | ||||
CuryWhTaxBalNonexistent in DB | decimal | - | ||
Description:No description available | ||||
CustomerID | int | Customer | Customer | |
Description:No description available | ||||
CustomerLocationID | int | Location | Location | |
Description:No description available | ||||
DeferPriceDiscountRecalculationNonexistent in DB | bit | Defer Price/Discount Recalculation | - | |
Description:No description available | ||||
DefRetainagePct | decimal(9, 6) | Default Retainage Percent | - | |
Description:No description available | ||||
DeliveryMethod | char(1) | Link Delivery Method | - | |
Description:No description available | ||||
DetailExtPriceTotal | decimal | - | ||
Description:No description available | ||||
DisableAutomaticDiscountCalculation | bit | Disable Automatic Discount Update | - | |
Description:No description available | ||||
DisableAutomaticTaxCalculation | bit | Disable Automatic Tax Calculation | - | |
Description:No description available | ||||
DiscAppliedAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
DiscBal | decimal(19, 4) | - | ||
Description:No description available | ||||
DiscDate | datetime2 | Cash Discount Date | - | |
Description:No description available | ||||
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 | ||||
DocumentDiscTotal | decimal(19, 4) | Document Discount | - | |
Description:No description available | ||||
DocumentKey | nvarchar(50) | Document Description | - | |
Description:No description available | ||||
DontApprove | bit | - | ||
Description:No description available | ||||
DontEmail | bit | Don't Email | - | |
Description:No description available | ||||
DontPrint | bit | Don't Print | - | |
Description:No description available | ||||
DrCrNonexistent in DB | nchar(1) | - | ||
Description:No description available | ||||
DRSchedCntr | int | - | ||
Description:No description available | ||||
DueDate API | datetime2 | Due Date | - | |
Description:No description available | ||||
Emailed | bit | Emailed | - | |
Description:No description available | ||||
EmailInvoice | bit | - | ||
Description:No description available | ||||
ExternalRef | nvarchar(80) | - | ||
Description:No description available | ||||
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 | ||||
FreightAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
FreightCost | decimal(19, 4) | - | ||
Description:No description available | ||||
FreightTot | decimal(19, 4) | - | ||
Description:No description available | ||||
FromScheduleNonexistent in DB | bit | - | ||
Description:No description available | ||||
GoodsExtPriceTotal | decimal(19, 4) | - | ||
Description:The total amount on all lines of the document, except for Misc. Charges and null or empty Line Types (in base currency). | ||||
GoodsTotal | decimal(19, 4) | - | ||
Description:No description available | ||||
GroupDiscTotal | decimal(19, 4) | Group Discounts | - | |
Description:No description available | ||||
HasPPDTaxes | bit | - | ||
Description:No description available | ||||
HiddenNonexistent in DB | bit | - | ||
Description:No description available | ||||
HiddenByShipmentNonexistent in DB | bit | - | ||
Description:No description available | ||||
HiddenOrderNbrNonexistent in DB | nvarchar(MAX) | - | ||
Description:No description available | ||||
HiddenOrderTypeNonexistent in DB | nvarchar(MAX) | - | ||
Description:No description available | ||||
HiddenShipmentNbrNonexistent in DB | nvarchar(MAX) | - | ||
Description:No description available | ||||
HiddenShipmentTypeNonexistent 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 | - | ||
Description:No description available | ||||
InstallmentNbr | smallint | - | ||
Description:No description available | ||||
InvoiceDate | datetime2 | Customer Ref. Date | - | |
Description:No description available | ||||
InvoiceNbr | nvarchar(40) | Customer Order Nbr. | - | |
Description:No description available | ||||
IsCancellation | bit | - | ||
Description:No description available | ||||
IsCorrection | bit | Correction Inv. | - | |
Description:No description available | ||||
IsHiddenInIntercompanySales | bit | Exclude from Intercompany Processing | - | |
Description:No description available | ||||
IsLoadApplicationsNonexistent in DB | bit | - | ||
Description:No description available | ||||
IsMigratedRecord | bit | - | ||
Description:No description available | ||||
IsPaymentsTransferred | bit | - | ||
Description:A Boolean field that indicates whether the payments and prepayment applied to the related sales orders should be transferred to the invoice during the document creation. When set to , the payments and prepayments will not be transferred to the invoice during the document creation but will be transferred within the Complete Processing actions execution when all orders are already added to the invoice. | ||||
IsPriceAndDiscountsValidNonexistent in DB | bit | Prices and discounts are up to date. | - | |
Description:No description available | ||||
IsRetainageDocument | bit | Retainage Document | - | |
Description:No description available | ||||
IsRetainageReversing | bit | Retainage Reversing | - | |
Description:No description available | ||||
IsTaxPosted | bit | Tax Is Posted/Committed to External Tax Engine (Avalara) | - | |
Description:No description available | ||||
IsTaxSaved | bit | Tax Is Saved in External Tax Engine (Avalara) | - | |
Description:No description available | ||||
IsTaxValid API | bit | Tax Is Up to Date | - | |
Description:No description available | ||||
IsUnderCancellationNonexistent in DB | bit | - | ||
Description:No description available | ||||
IsUnderCorrection | bit | - | ||
Description:No description available | ||||
LastFinChargeDateNonexistent in DB | datetime | Last Fin. Charge 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 | ||||
LastPaymentDateNonexistent in DB | datetime | Last Payment Date | - | |
Description:No description available | ||||
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:No description available | ||||
MasterRefNbr | nvarchar(15) | - | ||
Description:No description available | ||||
MiscExtPriceTotal | decimal(19, 4) | - | ||
Description:The total amount calculated as the sum of the amounts in Ext. Price (in base currency). | ||||
MiscTot | decimal(19, 4) | - | ||
Description:No description available | ||||
MultiShipAddress | bit | Multiple Ship-To Addresses | - | |
Description:No description available | ||||
NonTaxable | bit | Non-Taxable | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OpenDoc | bit | - | ||
Description:No description available | ||||
OrderDiscTotal | decimal | Discount Total | - | |
Description:No description available | ||||
OrigDiscAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
OrigDocAmt | decimal(19, 4) | - | ||
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 | ||||
OwnerID | int | Owner | Contact | |
Description:No description available | ||||
PaidAmtNonexistent in DB | decimal | - | ||
Description:No description available | ||||
PayLinkID | int | - | ||
Description:No description available | ||||
PaymentMethodID | nvarchar(10) | Payment Method | PaymentMethod | |
Description:No description available | ||||
PaymentsByLinesAllowed | bit | Pay by Line | - | |
Description:No description available | ||||
PaymentTotal | decimal(19, 4) | Total Paid | - | |
Description:No description available | ||||
PendingPayment | bit | - | ||
Description:No description available | ||||
PendingPPD | bit | - | ||
Description:No description available | ||||
PendingProcessing | bit | - | ||
Description:No description available | ||||
PendingProcessingCntr | int | - | ||
Description:No description available | ||||
PMInstanceID | int | Card/Account Nbr. | CustomerPaymentMethod | |
Description:No description available | ||||
PostponePendingPaymentFlagNonexistent in DB | bit | - | ||
Description:No description available | ||||
PremiumFreightAmt | decimal(19, 4) | - | ||
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 | Printed | - | |
Description:No description available | ||||
PrintInvoice | bit | - | ||
Description:No description available | ||||
ProcessingCenterID | nvarchar(10) | Processing Center | - | |
Description:No description available | ||||
ProformaExists | bit | Pro Forma Invoice Exists | - | |
Description:No description available | ||||
ProjectID | int | Project/Contract | PMProject | |
Description:No description available | ||||
RefNoteID | uniqueidentifier | - | ||
Description:No description available | ||||
Rejected | bit | - | ||
Description:No description available | ||||
Released | bit | - | ||
Description:No description available | ||||
ReleasedToVerifyNonexistent in DB | bit | - | ||
Description:No description available | ||||
RetainageAcctID | int | Retainage Receivable 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 Receivable Sub. | Sub | |
Description:No description available | ||||
RetainageTotal | decimal(19, 4) | Original Retainage | - | |
Description:No description available | ||||
RetainageUnpaidTotal | decimal(19, 4) | - | ||
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 | ||||
Revoked | bit | Revoked | - | |
Description:No description available | ||||
RGOLAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
RoundDiff | decimal(19, 4) | - | ||
Description:No description available | ||||
SalesPersonID | int | Default Salesperson | SalesPerson | |
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 | ||||
SelfVoidingDocNonexistent in DB | bit | - | ||
Description:No description available | ||||
ShipAddressID | int | ARAddress | ||
Description:No description available | ||||
ShipContactID | int | Shipping Contact | ARContact | |
Description:No description available | ||||
StatementDate | datetime2 | - | ||
Description:No description available | ||||
Status API | char(1) | Status | - | |
Description:No description available | ||||
TaxCalcMode | char(1) | Tax Calculation Mode | - | |
Description:No description available | ||||
TaxTotal API | decimal(19, 4) | - | ||
Description:No description available | ||||
TaxZoneID | nvarchar(10) | Customer Tax Zone | TaxZone | |
Description:No description available | ||||
TermsID | nvarchar(10) | Terms | Terms | |
Description:No description available | ||||
TranPeriodID | char(6) | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UnpaidBalance | decimal(19, 4) | - | ||
Description:No description available | ||||
UnreleasedPaymentAmtNonexistent in DB | decimal | - | ||
Description:No description available | ||||
VatExemptTotal | decimal(19, 4) | - | ||
Description:No description available | ||||
VatTaxableTotal | decimal(19, 4) | - | ||
Description:No description available | ||||
Voided | bit | - | ||
Description:No description available | ||||
WhTaxBalNonexistent in DB | decimal | - | ||
Description:No description available | ||||
WorkgroupID | int | Workgroup ID | EPCompanyTree | |
Description:No description available | ||||