AP
VendorR
PX.Objects.AP95 of 95 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AcctCD | nvarchar(30) | Vendor ID | - | |
Description:No description available | ||||
AcctName | nvarchar(255) | Vendor Name | - | |
Description:The VendorR account name, which is the same as the Vendor.AcctName field. | ||||
AcctReferenceNbr | nvarchar(50) | Ext. Ref. Nbr. | - | |
Description:No description available | ||||
AllowOverrideCury | bit | Enable Currency Override | - | |
Description:No description available | ||||
AllowOverrideRate | bit | Enable Rate Override | - | |
Description:No description available | ||||
AutoGenerateTaxBill | bit | Automatically Generate Tax Bill | - | |
Description:No description available | ||||
BAccountClassID | nvarchar(10) | Business Account Class | - | |
Description:No description available | ||||
BAccountID | int | Business Account ID | - | |
Description:No description available | ||||
BaseCuryID | nvarchar(5) | Base Currency ID | - | |
Description:No description available | ||||
BaseRemitContactID | int | Default Contact | - | |
Description:No description available | ||||
Box1099 | smallint | 1099 Box | - | |
Description:No description available | ||||
CampaignSourceID | nvarchar(15) | Source Campaign | - | |
Description:No description available | ||||
CasesCountNonexistent in DBObsolete | int | - | ||
Description:No description available | ||||
ClassIDObsolete | nvarchar(10) | Class ID | - | |
Description:No description available | ||||
ConsolidateToParent | bit | Consolidate Balance | - | |
Description:No description available | ||||
ConsolidatingBAccountID | int | - | ||
Description:No description available | ||||
COrgBAccountID | int | Customer Restriction Group | - | |
Description:No description available | ||||
CountNonexistent in DBObsolete | int | Count | - | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | - | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created On | - | |
Description:No description available | ||||
CuryID | nvarchar(5) | Currency ID | - | |
Description:No description available | ||||
CuryRateTypeID | nvarchar(6) | Curr. Rate Type | - | |
Description:No description available | ||||
DefAddressID | int | Default Address | - | |
Description:No description available | ||||
DefaultUOM | nvarchar(10) | Default UOM | - | |
Description:No description available | ||||
DefContactID | int | Default Contact | - | |
Description:No description available | ||||
DefLocationID | int | Default Location | - | |
Description:No description available | ||||
DefPOAddressID | int | - | ||
Description:No description available | ||||
DiscTakenAcctID | int | Cash Discount Account | - | |
Description:No description available | ||||
DiscTakenSubID | int | Cash Discount Sub. | - | |
Description:No description available | ||||
FATCA | bit | FATCA | - | |
Description:No description available | ||||
ForeignEntity | bit | Foreign Entity | - | |
Description:No description available | ||||
GroupMask | varbinary(MAX) | - | ||
Description:No description available | ||||
IgnoreConfiguredDiscounts | bit | Ignore Configured Discounts When Vendor Price Is Defined | - | |
Description:No description available | ||||
IncludedNonexistent in DB | bit | Included | - | |
Description:No description available | ||||
IsBranch | bit | - | ||
Description:No description available | ||||
IsCustomerOrCombined | bit | - | ||
Description:No description available | ||||
LandedCostVendor | bit | Landed Cost Vendor | - | |
Description:No description available | ||||
LastActivityNonexistent in DBObsolete | datetime | Last Activity | - | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | - | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | Last Modified On | - | |
Description:No description available | ||||
LegalName | nvarchar(255) | Legal Name | - | |
Description:No description available | ||||
LineDiscountTarget | char(1) | Apply Line Discounts to | - | |
Description:No description available | ||||
LocaleName | nvarchar(10) | Language/Locale | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OverrideSalesTerritory | bit | Override Territory | - | |
Description:No description available | ||||
OwnerID | int | Owner | - | |
Description:No description available | ||||
ParentBAccountID | int | Parent Account | - | |
Description:No description available | ||||
PaymentsByLinesAllowed | bit | Pay by Line | - | |
Description:No description available | ||||
PayToVendorID | int | Pay-to Vendor | - | |
Description:No description available | ||||
POAccrualAcctID | int | PO Accrual Account | - | |
Description:No description available | ||||
POAccrualSubID | int | PO Accrual Sub. | - | |
Description:No description available | ||||
PrebookAcctID | int | Reclassification Account | - | |
Description:No description available | ||||
PrebookSubID | int | Reclassification Subaccount | - | |
Description:No description available | ||||
PrepaymentAcctID | int | Prepayment Account | - | |
Description:No description available | ||||
PrepaymentSubID | int | Prepayment Sub. | - | |
Description:No description available | ||||
PreviewHtmlNonexistent in DBObsolete | nvarchar(MAX) | - | ||
Description:No description available | ||||
PriceListCuryID | nvarchar(5) | Currency ID | - | |
Description:No description available | ||||
PrimaryContactID | int | Primary Contact | Contact | |
Description:No description available | ||||
PseudonymizationStatus | int | Pseudonymized | - | |
Description:No description available | ||||
PurchTaxAcctID | int | Tax Claimable Account | - | |
Description:No description available | ||||
PurchTaxSubID | int | Tax Claimable Sub. | - | |
Description:No description available | ||||
RegisteredEntityForReporting | bit | Registered Entity for Government Payroll Reporting | - | |
Description:No description available | ||||
RetainageApply | bit | Apply Retainage | - | |
Description:No description available | ||||
RetainagePct | decimal | Retainage Percent | - | |
Description:No description available | ||||
SalesTaxAcctID | int | Tax Payable Account | - | |
Description:No description available | ||||
SalesTaxSubID | int | Tax Payable Sub. | - | |
Description:No description available | ||||
SalesTerritoryID | nvarchar(15) | Sales Territory | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
Status | char(1) | Customer Status | - | |
Description:No description available | ||||
SVATInputTaxEntryRefNbr | char(1) | Input Tax Entry Ref. Nbr. | - | |
Description:No description available | ||||
SVATOutputTaxEntryRefNbr | char(1) | Output Tax Entry Ref. Nbr. | - | |
Description:No description available | ||||
SVATReversalMethod | char(1) | VAT Recognition Method | - | |
Description:No description available | ||||
SVATTaxInvoiceNumberingID | nvarchar(10) | Tax Invoice Numbering | - | |
Description:No description available | ||||
TaxAgency | bit | Vendor Is Tax Agency | - | |
Description:No description available | ||||
TaxExpenseAcctID | int | Tax Expense Account | - | |
Description:No description available | ||||
TaxExpenseSubID | int | Tax Expense Sub. | - | |
Description:No description available | ||||
TaxPeriodType | varchar(1) | Default Tax Period Type | - | |
Description:No description available | ||||
TaxRegistrationID | nvarchar(50) | Tax Registration ID | - | |
Description:No description available | ||||
TaxReportFinPeriod | bit | Define Tax Period by End Date of Financial Period | - | |
Description:No description available | ||||
TaxReportPrecision | smallint | Tax Report Precision | - | |
Description:No description available | ||||
TaxReportRounding | varchar(1) | Tax Report Rounding | - | |
Description:No description available | ||||
TaxUseVendorCurPrecision | bit | Use Currency Precision | - | |
Description:No description available | ||||
TermsID | nvarchar(10) | Terms | - | |
Description:No description available | ||||
TinType | char(1) | Type of TIN | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
Type | char(2) | Type | - | |
Description:No description available | ||||
UpdClosedTaxPeriods | bit | Update Closed Tax Periods | - | |
Description:No description available | ||||
Vendor1099 | bit | 1099 Vendor | - | |
Description:No description available | ||||
VendorClassID | nvarchar(10) | Vendor Class | - | |
Description:No description available | ||||
ViewInCrmNonexistent in DB | bit | View In CRM | - | |
Description:No description available | ||||
VOrgBAccountID | int | Restrict Visibility To | - | |
Description:No description available | ||||
VStatus | char(1) | Vendor Status | - | |
Description:No description available | ||||
WorkgroupID | int | Workgroup | - | |
Description:No description available | ||||