Skip to main content
GL

Organization

PX.Objects.GL.DAC
Field NameTypeDisplay NameForeign Key
OrganizationCD
nvarchar(30)Company ID-
Description:No description available
Active
bitActive-
Description:No description available
ActualLedgerCDNonexistent in DB
nvarchar(10)-
Description:No description available
ActualLedgerID
intLedger
Description:No description available
BAccountIDDefault Navigation
intBAccountIDBAccount
Description:Identifier of the Business Account of the Organization. Corresponds to the BAccount.BAccountID field.
BackgroundColorNonexistent in DB
nvarchar(30)Background Color-
Description:No description available
BaseCuryIDDefault Navigation
nvarchar(5)Base Currency IDCurrencyList
Description:The base Currency of the company. Corresponds to the Currency.CuryID field.
CarrierFacility
nvarchar(50)Carrier Facility-
Description:No description available
CashDiscountBase
char(2)Cash Discount Base-
Description:Represents the type of cash discount base. The field can have one of the values listed in the CashDiscountBases class.
CEmail
nvarchar(255)Contact E-mail-
Description:Contact E-mail for the 1099 form.
CFSFiler
bitCombined Federal/State Filer-
Description:Combined Federal/State Filer for the 1099 form.
ContactName
nvarchar(255)Contact Name-
Description:Contact Name for the 1099 form.
CountryIDDefault Navigation
nvarchar(2)Default CountryCountry
Description:Identifier of the default Country of the Organization. Corresponds to the Country.CountryID field.
CreatedByIDDefault Navigation
uniqueidentifierCreated ByUsers
Description:No description available
CreatedByScreenID
char(8)-
Description:No description available
CreatedDateTime
datetimeCreated On-
Description:No description available
CTelNumber
nvarchar(25)Contact Telephone Number-
Description:Contact Phone Number for the 1099 form.
DefaultPrinterIDDefault Navigation
uniqueidentifierDefault PrinterSMPrinter
Description:No description available
DunningFeeBranchIDDefault Navigation
intDunning Letter BranchBranch
Description:No description available
FileTaxesByBranches
bitFile Taxes by Branch-
Description:No description available
ForeignEntity
bitForeign Entity-
Description:Indicates whether the Organization is considered a Foreign Entity in the context of 1099 form.
GroupMask
varbinary(32)-
Description:The group mask showing which restriction groups the Branch belongs to. To learn more about the way restriction groups are managed, see the documentation for the GL Account Access (GL104000) form (which corresponds to the GLAccess graph).
IncludedNonexistent in DB
bitIncluded-
Description:An unbound field used in the User Interface to include the Organization into a restriction group.
LastModifiedByIDDefault Navigation
uniqueidentifierLast Modified ByUsers
Description:No description available
LastModifiedByScreenID
char(8)-
Description:No description available
LastModifiedDateTime
datetimeLast Modified On-
Description:No description available
LogoName
nvarchar(255)Logo File-
Description:The name of the logo image file.
LogoNameReport
nvarchar(255)Report Logo File-
Description:The name of the report logo image file.
NameControl
nvarchar(4)Name Control-
Description:Name Control for the 1099 form.
NoteID
uniqueidentifier-
Description:No description available
OrganizationID
int-
Description:No description available
OrganizationLocalizationCode
nvarchar(2)Localization-
Description:No description available
OrganizationName
nvarchar(60)Company Name-
Description:The name of the organization.
OrganizationType
varchar(15)Company Type-
Description:No description available
OverrideThemeVariables
bitOverride Colors for the Selected Company-
Description:No description available
PhoneMask
varchar(50)Phone Mask-
Description:The mask used to display phone numbers for the objects, which belong to this Organization. See also the Company.PhoneMask.
PrimaryColorNonexistent in DB
nvarchar(30)Primary Color-
Description:No description available
Reporting1099
bit1099-MISC Reporting Entity-
Description:No description available
Reporting1099ByBranches
bitFile 1099-MISC by Branch-
Description:No description available
RoleNameDefault Navigation
nvarchar(64)Access RoleRoles
Description:The name of the Role to be used to grant users access to the data of the Organization. Corresponds to the Roles.Rolename field.
SelectedNonexistent in DB
bitSelected-
Description:No description available
Status
nchar(1)Status-
Description:No description available
TCC
nvarchar(5)Transmitter Control Code (TCC)-
Description:Transmitter Control Code (TCC) for the 1099 form.
tstamp
timestamp-
Description:No description available