SOOwner

PX.Objects.SO.StandaloneRelease 2025.2

No summary is documented for this DAC in the release source.

Select a row for its description 135 of 135 fields

	Field Name	Type	Display Name	Foreign Key
	`ABN`	`nvarchar(15)`	ABN	-
Description:No description available
	`AMProductionEmployee`	`bit`	Production Employee	-
Description:Indicates an employee is a production employee for use in Manufacturing processes such as labor transactions and scheduling as a resource
	`AcctCD`Default Navigation	`nvarchar(30)`	Employee ID	EPEmployee
Description:The human-readable identifier of the employee that is specified by the user or defined by the EMPLOYEE auto-numbering sequence during the creation of the employee. This field is a natural key, as opposed to the surrogate key BAccountID.
	`AcctName`	`nvarchar(60)`	Employee Name	-
Description:The employee name, which is usually a concatenation of the first and last name of the appropriate contact.
	`AcctReferenceNbr`	`nvarchar(50)`	Employee Ref. No.	-
Description:The external reference number of the employee. It can be an additional number of the employee used in external integration.
	`ActiveClockInTimerID`	`int`		-
Description:The unique identifier of the current timer associated with this employee. The value of this field corresponds to the timer identifier specified in EPClockInTimerData.timerDataID.
	`AllowOverrideCury`	`bit`	Enable Currency Override	-
Description:If set to true, indicates that the currency of business account documents (which is specified by BAccount.CuryID) can be overridden by a user during document entry.
	`AllowOverrideRate`	`bit`	Enable Rate Override	-
Description:If set to true, indicates that the currency rate for customer documents (which is calculated by the system from the currency rate history) can be overridden by a user during document entry. The field is used only if the business account is a customer (that is, IsCustomerOrCombined is true).
	`Attributes`Nonexistent in DB	`string`		-
Description:The attributes list available for the current employee.
	`AutoGenerateTaxBill`	`bit`	Automatically Generate Tax Bill	-
Description:No description available
	`BASInstalmentAmount`	`int`	G21 - GST instalment amount	-
Description:No description available
	`BASOptions`	`nvarchar(1)`	Options	-
Description:No description available
	`BAccountClassID`	`nvarchar(10)`	Business Account Class	-
Description:The BAccount.classID field, which is used for internal purposes.
	`BAccountID`	`int`	Business Account ID	-
Description:The identifier of the business account. This field is auto-incremental. This field is a surrogate key, as opposed to the natural key AcctCD.
	`BaseCuryID`Default Navigation	`nvarchar(5)`	Base Currency ID	CurrencyList
Description:The employee's base System.Currency, which is the base currency of the branch selected in the Branch box. This field corresponds to Organization.BaseCuryID.
	`BaseRemitContactID`Default Navigation	`int`	Default Contact	Contact
Description:No description available
	`Box1099`Default Navigation	`smallint`	1099 Box	AP1099Box
Description:No description available
	`COrgBAccountID`Default Navigation	`int`	Customer Restriction Group	-
Description:No description available
	`CalendarID`Default Navigation	`nvarchar(10)`	Calendar	CSCalendar
Description:The identifier of the calendar that records the working hours of the employee and the time zone of the employee. Corresponds to the CSCalendar.CalendarID field.
	`CampaignSourceID`Default Navigation	`nvarchar(15)`	Source Campaign	CRCampaign
Description:The identifier of the marketing or sales campaign that resulted in creation of the business account. Corresponds to the value of the CRCampaign.CampaignID field.
	`CasesCount`Nonexistent in DBObsolete	`int?`		-
Description:No description available
	`ClassID`Default NavigationObsolete	`nvarchar(10)`	Class ID	CRCustomerClass
Description:Identifier of the business acccount class to which the business account belongs.
	`ConsolidateToParent`	`bit`	Consolidate Balance	-
Description:The total balance of the parent customer account including balances of its child accounts for which the value of this field is true on the Billing Info tab of this form. The amount includes the balances of all open documents and prepayments. This field is used in the Customer class and showed only on the Customers (AR303000) form.
	`ConsolidatingBAccountID`	`int`		-
Description:The field is preserved for internal use.
	`Count`Nonexistent in DBObsolete	`int?`	Count	-
Description:No description available
	`CreatedByID`Default Navigation	`uniqueidentifier`	Created By	Users
Description:No description available
	`CreatedByScreenID`	`char(8)`		-
Description:No description available
	`CreatedDateTime`	`datetime`	Created On	-
Description:No description available
	`CuryID`Default Navigation	`nvarchar(5)`	Currency	Currency
Description:The identifier of the Currency, which is applied to the documents of the business account.
	`CuryRateTypeID`Default Navigation	`nvarchar(6)`	Curr. Rate Type	CurrencyRateType
Description:The identifier of the currency rate type, which is applied to the documents of the customer. The field is used only if the business account is a customer (that is, IsCustomerOrCombined is true).
	`DefAddressID`Default Navigation	`int`	Default Address	Address
Description:The identifier of the CR.Address object linked with the current employee as Address Info. Corresponds to the value of the Address.AddressID field.
	`DefContactID`Default Navigation	`int`	Default Contact	Contact
Description:The identifier of the CR.Contact object linked with the current employee as Contact Info. Corresponds to the value of the Contact.ContactID field.
	`DefLocationID`Default Navigation	`int`	Default Location	Location
Description:The identifier of the Location object linked with the employee and marked as default. The fields from the linked location are shown on the Financial Settings tab. Corresponds to the value of the Location.LocationID field. Also, the Location.BAccountID value must be equal to the BAccount.BAccountID value of the current employee.
	`DefPOAddressID`	`int`		Address
Description:No description available
	`DefaultUOM`	`nvarchar(10)`	Default UOM	-
Description:No description available
	`DefaultWorkgroupID`Default Navigation	`int`	Default Workgroup	EPCompanyTree
Description:The identifier of the workgroup that the system inserts by default for each new record entered on the Details tab of the Employee Time Card (EP305000) form for this employee. Corresponds to the EPCompanyTree.workGroupID field.
	`DepartmentID`Default Navigation	`nvarchar(10)`	Department	EPDepartment
Description:Identifier of the employee department that the employee belongs to.
	`DiscTakenAcctID`Default Navigation	`int`	Cash Discount Account	Account
Description:Identifier of the account used to record the cash discount amounts received from the vendor due to credit terms. Inherited from Vendor class. Corresponds to the Account.AccountID field.
	`DiscTakenSubID`Default Navigation	`int`	Cash Discount Sub.	Sub
Description:The identifier of the corresponding subaccount used to record the cash discount amounts received from the vendor due to credit terms. Inherited from Vendor class. Corresponds to the AccountID field.
	`EmailRemittances`	`bit`	Send Remittances by Email	-
Description:No description available
	`ExpenseAcctID`Default Navigation	`int`	Expense Account	Account
Description:Identifier of the account that will be used to record compensation amounts paid to the employee. Corresponds to the Account.AccountID field.
	`ExpenseSubID`Default Navigation	`int`	Expense Sub.	Sub
Description:The identifier of the corresponding subaccount that will be used to record compensation amounts paid to the employee. Corresponds to the AccountID field.
	`FATCA`	`bit`	FATCA	-
Description:No description available
	`ForeignEntity`	`bit`	Foreign Entity	-
Description:No description available
	`GroupMask`	`varbinary`		-
Description:The group mask that indicates which restriction groups the business account belongs to.
	`HoursValidation`	`nvarchar(1)`	Regular Hours Validation	-
Description:The extent of validation of regular work hours for this employee. The default value is set to the regular hours validation for the selected vendor class.
	`IgnoreConfiguredDiscounts`	`bit`	Ignore Configured Discounts When Vendor Price Is Defined	-
Description:No description available
	`Included`Nonexistent in DB	`bool?`	Included	-
Description:No description available
	`IsBranch`	`bit`		-
Description:No description available
	`IsCustomerOrCombined`Nonexistent in DB	`bool?`		-
Description:A calculated field that indicates (if set to "true") that BAccount.Type is either BAccountType.CustomerType or BAccountType.CombinedType.
	`IsDriver`	`bit`	Driver	-
Description:No description available
	`IsEmployeeUpdated`Nonexistent in DB	`bool?`		-
Description:Is employee updated
	`IsRelatedToProjectContact`Nonexistent in DB	`bool?`	Is Related To Project Contact	-
Description:No description available
	`JurisdictionCountryID`	`nvarchar(10)`	Jurisdiction	-
Description:No description available
	`LabourItemID`Default Navigation	`int`	Labor Item	InventoryItem
Description:The identifier of the labor item for the current employee. Corresponds to the value of the InventoryItem.InventoryID field. The labor item is a non-stock item (of the Labor type) associated with the employee and used as a source of expense accounts for transactions associated with projects or contracts.
	`LandedCostVendor`	`bit`	Landed Cost Vendor	-
Description:No description available
	`LastActivity`Nonexistent in DBObsolete	`DateTime?`	Last Activity	-
Description:No description available
	`LastModifiedByID`Default Navigation	`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:The legal name of the company that is used by the 1099 Reporting feature only (see DAC.Organization).
	`LineDiscountTarget`	`char(1)`	Apply Line Discounts to	-
Description:No description available
	`LocaleName`Default Navigation	`nvarchar(10)`	Language/Locale	Locale
Description:The name of the business account locale.
	`Mem_UnassignedDriver`Nonexistent in DB	`bool?`	Already Assigned	-
Description:No description available
	`NoteID`	`uniqueidentifier`		-
Description:No description available
	`OverrideSalesTerritory`	`bit`	Override Territory	-
Description:The flag identified that the salesTerritoryID is filled automatically based on Address.state and Address.countryID or can be assigned manually.
	`OwnerID`Default Navigation	`int`	Owner	Contact
Description:No description available
	`POAccrualAcctID`Default Navigation	`int`	PO Accrual Account	Account
Description:No description available
	`POAccrualSubID`Default Navigation	`int`	PO Accrual Sub.	Sub
Description:No description available
	`PTRS`	`bit`	Small business, track for PTRS	-
Description:No description available
	`ParentBAccountID`Default Navigation	`int`	Branch	BAccount
Description:Represents the branch of your organization where the employee works.
	`PayToVendorID`Default Navigation	`int`	Pay-to Vendor	Vendor
Description:A reference to the Vendor. An integer identifier of the vendor, whom the AP bill will belong to.
	`PaymentsByLinesAllowed`	`bit`	Pay by Line	-
Description:No description available
	`PositionLineCntr`	`int`		-
Description:No description available
	`PrebookAcctID`Default Navigation	`int`	Reclassification Account	Account
Description:No description available
	`PrebookSubID`Default Navigation	`int`	Reclassification Subaccount	Sub
Description:No description available
	`PrepaymentAcctID`Default Navigation	`int`	Prepayment Account	Account
Description:Identifier of the AP account to be used to record prepayments paid to the employee. Corresponds to the Account.AccountID field.
	`PrepaymentSubID`Default Navigation	`int`	Prepayment Sub.	Sub
Description:The identifier of the corresponding subaccount to be used to record prepayments paid to the employee. Corresponds to the AccountID field.
	`PreviewHtml`Nonexistent in DBObsolete	`string`		-
Description:No description available
	`PriceListCuryID`Default Navigation	`nvarchar(5)`	Currency ID	Currency
Description:No description available
	`PrimaryContactID`Default Navigation	`int`	Primary Contact	Contact
Description:The identifier of the CR.Contact object linked with the business account and marked as primary. Corresponds to the value of the Contact.ContactID field. Also, the Contact.BAccountID value must equal to the BAccount.BAccountID value of the current business account.
	`PrintRemittances`	`bit`	Print Remittances	-
Description:No description available
	`PseudonymizationStatus`	`int`	Pseudonymized	-
Description:No description available
	`PurchTaxAcctID`Default Navigation	`int`	Tax Claimable Account	Account
Description:No description available
	`PurchTaxSubID`Default Navigation	`int`	Tax Claimable Sub.	Sub
Description:No description available
	`ReceiptAndClaimTaxZoneID`	`nvarchar(10)`		-
Description:The identifier of the Receipt and Claim tax zone.
	`RegisteredEntityForReporting`	`bit`	Registered Entity for Government Payroll Reporting	-
Description:The registered entity for government payroll reporting.
	`RetainageApply`	`bit`	Apply Retainage	-
Description:No description available
	`RetainagePct`	`decimal`	Retainage Percent	-
Description:No description available
	`RouteEmails`	`bit`	Route Emails	-
Description:Specifies whether the emails addressed to this employee should be routed from an email account to the employee's email address if the processing of incoming mail is enabled for the email account and the Route Employee Emails check box is selected on the Email Accounts (SM204002) form. For details, see Incoming Mail Processing.
	`SDEnabled`	`bit`		-
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`Default Navigation	`nvarchar(10)`	Tax Invoice Numbering	Numbering
Description:No description available
	`SalesAcctID`Default Navigation	`int`	Sales Account	Account
Description:Identifier of the account to be used to record sales made by the employee, if applicable. Corresponds to the Account.AccountID field.
	`SalesPersonID`Default Navigation	`int`	Salesperson	SalesPerson
Description:The identifier of the sales person to whom the current employee matches. Corresponds to the value of the SalesPerson.SalesPersonID field.
	`SalesSubID`Default Navigation	`int`	Sales Sub.	Sub
Description:The identifier of the corresponding subaccount to be used to record sales made by the employee. Corresponds to the AccountID field.
	`SalesTaxAcctID`Default Navigation	`int`	Tax Payable Account	Account
Description:No description available
	`SalesTaxSubID`Default Navigation	`int`	Tax Payable Sub.	Sub
Description:No description available
	`SalesTerritoryID`Default Navigation	`nvarchar(15)`	Sales Territory	SalesTerritory
Description:The reference to SalesTerritory.salesTerritoryID. If overrideSalesTerritory is false then it's filled automatically based on Address.state and Address.countryID otherwise it's assigned by user.
	`Selected`Nonexistent in DB	`bool?`	Selected	-
Description:No description available
	`ShiftID`Default Navigation	`int`	Shift Code	EPShiftCode
Description:The identifier of the shift code that the system inserts by default for any new time activity or earning record entered for the employee. Corresponds to the value of the EPShiftCode.shiftID field.
	`ShouldGenerateLienWaivers`	`bit`	Generate Lien Waivers Based on Project Settings	-
Description:No description available
	`Status`	`char(1)`	Customer Status	-
Description:No description available
	`SupervisorID`Default Navigation	`int`	Reports to	EPEmployee
Description:The identifier of the employee to whom the current employee sends reports. Corresponds to the value of the BAccount.BAccountID field.
	`TPAR`	`bit`	Track for TPAR	-
Description:No description available
	`TPARLocation`Default Navigation	`int`	TPAR Location	LocationExtAddress
Description:No description available
	`TaxAgency`	`bit`	Vendor Is Tax Agency	-
Description:No description available
	`TaxExpenseAcctID`Default Navigation	`int`	Tax Expense Account	Account
Description:No description available
	`TaxExpenseSubID`Default Navigation	`int`	Tax Expense Sub.	Sub
Description:No description available
	`TaxPeriodType`	`nvarchar(1)`	Default Tax Period Type	-
Description:No description available
	`TaxRegistrationID`	`nvarchar(50)`	Tax Registration ID	-
Description:The registration ID of the company in the state tax authority.
	`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`	`nvarchar(1)`	Tax Report Rounding	-
Description:No description available
	`TaxUseVendorCurPrecision`	`bit`	Use Currency Precision	-
Description:No description available
	`TermsID`Default Navigation	`nvarchar(10)`	Terms	Terms
Description:No description available
	`TimeCardRequired`	`bit`	Time Card Is Required	-
Description:Specifies whether time cards are required for this employee.
	`TinType`	`char(1)`	Type of TIN	-
Description:No description available
	`Type`	`char(2)`	Type	-
Description:A field inherited from BAccount represents the type of the business account. The field can have one of the values listed in the BAccountType class. For Employee the only possible value is BAccountType.EmployeeType.
	`UnionID`Default Navigation	`nvarchar(15)`	Union Local ID	PMUnion
Description:The local identifier of the union associated with the employee. Corresponds to the value of the PMUnion.unionID field.
	`UpdClosedTaxPeriods`	`bit`	Update Closed Tax Periods	-
Description:No description available
	`UserID`	`uniqueidentifier`	Employee Login	Users
Description:The identifier of the Users to be used for the employee to sign into the system. Corresponds to the value of the Users.PKID field.
	`UsrMPATWFMEditableFields`Nonexistent in DB	`bool?`	Edit WFM fields	-
Description:No description available
	`VOrgBAccountID`Default Navigation	`int`	Restrict Visibility To	-
Description:No description available
	`VStatus`	`char(1)`	Status	-
Description:The status of the employee. The possible values of the field are listed in the VendorStatus class. The set of these values can be changed and extended by using the workflow engine.
	`Vendor1099`	`bit`	1099 Vendor	-
Description:No description available
	`VendorClassID`Default Navigation	`nvarchar(10)`	Employee Class	VendorClass
Description:The identifier of the employee class that the employee belongs to. The value of this field corresponds to the value of the EPEmployeeClass.VendorClassID field.
	`VendorDefaultCostCodeId`Default Navigation	`int`	Cost Code	PMCostCode
Description:No description available
	`VendorDefaultInventoryId`Default Navigation	`int`	Inventory ID	InventoryItem
Description:No description available
	`ViewInCrm`Nonexistent in DB	`bool?`	View In CRM	-
Description:No description available
	`WorkgroupID`Default Navigation	`int`	Workgroup	EPCompanyTree
Description:No description available
	`chkServiceManagement`Nonexistent in DB	`bool?`		-
Description:No description available
	`tstamp`	`timestamp`		-
Description:No description available