SO
SOOwner
PX.Objects.SO.Standalone113 of 113 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AcctCD | nvarchar(30) | Employee ID | - | |
Description:No description available | ||||
AcctName | nvarchar(255) | Employee Name | - | |
Description:No description available | ||||
AcctReferenceNbr | nvarchar(50) | Employee Ref. No. | - | |
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 | CurrencyList | |
Description:No description available | ||||
BaseRemitContactID | int | Default Contact | - | |
Description:No description available | ||||
Box1099 | smallint | 1099 Box | - | |
Description:No description available | ||||
CalendarID | nvarchar(10) | Calendar | CSCalendar | |
Description:No description available | ||||
CampaignSourceID | nvarchar(15) | Source Campaign | CRCampaign | |
Description:No description available | ||||
CasesCountNonexistent in DBObsolete | int | - | ||
Description:No description available | ||||
ClassIDObsolete | nvarchar(10) | Class ID | CRCustomerClass | |
Description:No description available | ||||
ConsolidateToParent | bit | Consolidate Balance | - | |
Description:No description available | ||||
ConsolidatingBAccountID | int | - | ||
Description:No description available | ||||
COrgBAccountID | int | Customer Restriction Group | BAccount | |
Description:No description available | ||||
CountNonexistent in DBObsolete | int | Count | - | |
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 | ||||
CuryID | nvarchar(5) | Currency | Currency | |
Description:No description available | ||||
CuryRateTypeID | nvarchar(6) | Curr. Rate Type | CurrencyRateType | |
Description:No description available | ||||
DefAddressID | int | Default Address | Address | |
Description:No description available | ||||
DefaultUOM | nvarchar(10) | Default UOM | - | |
Description:No description available | ||||
DefaultWorkgroupID | int | Default Workgroup | - | |
Description:No description available | ||||
DefContactID | int | Default Contact | Contact | |
Description:No description available | ||||
DefLocationID | int | Default Location | Location | |
Description:No description available | ||||
DefPOAddressID | int | - | ||
Description:No description available | ||||
DepartmentID | nvarchar(10) | Department | EPDepartment | |
Description:No description available | ||||
DiscTakenAcctID | int | Cash Discount Account | - | |
Description:No description available | ||||
DiscTakenSubID | int | Cash Discount Sub. | - | |
Description:No description available | ||||
ExpenseAcctID | int | Expense Account | Account | |
Description:No description available | ||||
ExpenseSubID | int | Expense Sub. | Sub | |
Description:No description available | ||||
FATCA | bit | FATCA | - | |
Description:No description available | ||||
ForeignEntity | bit | Foreign Entity | - | |
Description:No description available | ||||
GroupMask | varbinary(32) | - | ||
Description:No description available | ||||
HoursValidation | varchar(1) | Regular Hours Validation | - | |
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 | ||||
LabourItemID | int | Labor Item | InventoryItem | |
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 | Users | |
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 | Locale | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OverrideSalesTerritory | bit | Override Territory | - | |
Description:No description available | ||||
OwnerID | int | Owner | Contact | |
Description:No description available | ||||
ParentBAccountID | int | Branch | Branch | |
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 | ||||
PositionLineCntr | int | - | ||
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 | ||||
ReceiptAndClaimTaxZoneID | nvarchar(10) | - | ||
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(9, 6) | Retainage Percent | - | |
Description:No description available | ||||
RouteEmails | bit | Route Emails | - | |
Description:No description available | ||||
SalesAcctID | int | Sales Account | Account | |
Description:No description available | ||||
SalesPersonID | int | Salesperson | SalesPerson | |
Description:No description available | ||||
SalesSubID | int | Sales Sub. | Sub | |
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 | SalesTerritory | |
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
ShiftID | int | Shift Code | EPShiftCode | |
Description:No description available | ||||
Status | char(1) | Customer Status | - | |
Description:No description available | ||||
SupervisorID | int | Reports to | EPEmployee | |
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 | char(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 | char(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 | ||||
TimeCardRequired | bit | Time Card Is Required | - | |
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 | ||||
UnionID | nvarchar(15) | Union Local ID | PMUnion | |
Description:No description available | ||||
UpdClosedTaxPeriods | bit | Update Closed Tax Periods | - | |
Description:No description available | ||||
UserID | uniqueidentifier | Employee Login | Users | |
Description:No description available | ||||
Vendor1099 | bit | 1099 Vendor | - | |
Description:No description available | ||||
VendorClassID | nvarchar(10) | Employee Class | - | |
Description:No description available | ||||
ViewInCrmNonexistent in DB | bit | View In CRM | - | |
Description:No description available | ||||
VOrgBAccountID | int | Restrict Visibility To | BAccount | |
Description:No description available | ||||
VStatus | char(1) | Status | - | |
Description:No description available | ||||
WorkgroupID | int | Workgroup | EPCompanyTree | |
Description:No description available | ||||