GLAccount

Stores detailed metadata for General Ledger (GL) accounts, including account types, attributes, and configuration, to support financial tracking.

Columns


Name	Type	ReadOnly	Description
Recordno	Int64	False	Unique identifier for the GL account record.
Accountno [KEY]	String	False	Account number for the GL account.
Title	String	False	Title or name of the GL account.
Accounttype	String	False	Type of the GL account (e.g., asset, liability, equity).
Normalbalance	String	False	Normal balance type (debit or credit) for the account.
Closingtype	String	False	Specifies how the account is closed during the accounting period.
Closingaccountno	String	False	Account number used for closing entries.
Closingaccounttitle	String	False	Title of the closing account associated with this account.
Status	String	False	Current status of the GL account (e.g., active, inactive).
Requiredept	Boolean	False	Indicates if a department is required for transactions involving this account.
Requireloc	Boolean	False	Indicates if a location is required for transactions involving this account.
Taxable	Boolean	False	Indicates if transactions involving this account are taxable.
Categorykey	String	False	Key representing the category associated with this account.
Category	String	False	Category of the GL account.
Taxcode	String	False	Tax code associated with the GL account.
Mrccode	String	False	MRC code associated with the account, if applicable.
Closetoacctkey	Int64	False	Key for the account to which this account is closed.
Alternativeaccount	String	False	Alternative account number for reporting purposes.
Whencreated	Datetime	False	Timestamp when the account was created.
Whenmodified	Datetime	False	Timestamp when the account was last modified.
Createdby	Int64	False	Identifier of the user who created the account.
Modifiedby	Int64	False	Identifier of the user who last modified the account.
Megaentitykey	Int64	False	Key for the mega entity associated with this account.
Megaentityid	String	False	Identifier for the mega entity associated with this account.
Megaentityname	String	False	Name of the mega entity associated with this account.
Requireproject	Boolean	False	Indicates if a project is required for transactions involving this account.
Requirecustomer	Boolean	False	Indicates if a customer is required for transactions involving this account.
Requirevendor	Boolean	False	Indicates if a vendor is required for transactions involving this account.
Requireemployee	Boolean	False	Indicates if an employee is required for transactions involving this account.
Requireitem	Boolean	False	Indicates if an item is required for transactions involving this account.
Requireclass	Boolean	False	Indicates if a class is required for transactions involving this account.
Record_url	String	False	URL link to view the record of this GL account in the system.

SSIS Components for Sage Intacct

GLAccount

Columns