Portals
SPBalanceOverviewMaint.ARInvoiceFilterAlias
PX.Objects.Portals247 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 | - | ||
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 | - | ||
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 | - | ||
Description:No description available | ||||
CommnblAmt | decimal | - | ||
Description:No description available | ||||
CommnPct | decimal | 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 | 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 | 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 | Commission Amt. | - | |
Description:No description available | ||||
CuryCommnblAmt | decimal | Total Commissionable | - | |
Description:No description available | ||||
CuryDetailExtPriceTotal | decimal | Detail Total | - | |
Description:No description available | ||||
CuryDiscAppliedAmt | decimal | 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 | 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 | Document Discount | - | |
Description:No description available | ||||
CuryFreightAmt | decimal | Freight Price | - | |
Description:No description available | ||||
CuryFreightCost | decimal | Freight Cost | - | |
Description:No description available | ||||
CuryFreightTot | decimal | Freight Total | - | |
Description:No description available | ||||
CuryGoodsExtPriceTotal | decimal | Goods | - | |
Description:No description available | ||||
CuryGoodsTotal | decimal | Goods Total | - | |
Description:No description available | ||||
CuryGroupDiscTotal | decimal | 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 | Line Discounts | - | |
Description:No description available | ||||
CuryLineRetainageTotal | decimal(19, 4) | - | ||
Description:No description available | ||||
CuryLineTotal | decimal | Detail Total | - | |
Description:No description available | ||||
CuryMiscExtPriceTotal | decimal | Misc. Charges | - | |
Description:No description available | ||||
CuryMiscTot | decimal | 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 | Total Paid | - | |
Description:No description available | ||||
CuryPremiumFreightAmt | decimal | 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 | Tax Total | - | |
Description:No description available | ||||
CuryUnpaidBalance | decimal | Unpaid Balance | - | |
Description:No description available | ||||
CuryUnreleasedPaymentAmtNonexistent in DB | decimal | Not Released | - | |
Description:No description available | ||||
CuryVatExemptTotal | decimal | Tax Exempt Total | - | |
Description:No description available | ||||
CuryVatTaxableTotal | decimal | 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 | - | ||
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 | - | ||
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 | 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 | 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 | - | ||
Description:No description available | ||||
FreightCost | decimal | - | ||
Description:No description available | ||||
FreightTot | decimal | - | ||
Description:No description available | ||||
FromScheduleNonexistent in DB | bit | - | ||
Description:No description available | ||||
GoodsExtPriceTotal | decimal | - | ||
Description:No description available | ||||
GoodsTotal | decimal | - | ||
Description:No description available | ||||
GroupDiscTotal | decimal | 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 | 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:No description available | ||||
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 | 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 | 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 | Line Discounts | - | |
Description:No description available | ||||
LineRetainageTotal | decimal(19, 4) | - | ||
Description:No description available | ||||
LineTotal | decimal | - | ||
Description:No description available | ||||
MasterRefNbr | nvarchar(15) | - | ||
Description:No description available | ||||
MiscExtPriceTotal | decimal | - | ||
Description:No description available | ||||
MiscTot | decimal | - | ||
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 | 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 | - | ||
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 | char(1) | Status | - | |
Description:No description available | ||||
TaxCalcMode | char(1) | Tax Calculation Mode | - | |
Description:No description available | ||||
TaxTotal | decimal | - | ||
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 | - | ||
Description:No description available | ||||
UnreleasedPaymentAmtNonexistent in DB | decimal | - | ||
Description:No description available | ||||
VatExemptTotal | decimal | - | ||
Description:No description available | ||||
VatTaxableTotal | decimal | - | ||
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 | ||||