xMatix
Sign in Request demo
xMatix
PRODUCTS
SalesField SalesCRMRewardsClaimsInventoryProcurementWarehouse ManagementField ServiceServiceSupportTelephony & MessagingFinance & AccountingPayrollExpense ManagementCommercePortalsAnalytics & ReportingData StudioMobile AppSee all products →
PLATFORM
Platform overviewApp BuilderAutomationIntegrationsSecurity & GovernanceChange ManagementDevelopers
SENSE AI
Sense AI overviewSense AssistSense ControlSense VisionAI StudioTrust & governanceIn Claude & ChatGPTUse cases
SOLUTIONS
FMCG & DistributionManufacturing & Dealer NetworksAutomotive & DealershipsPharma & HealthcareConsumer DurablesAgri-InputsBuilding MaterialsService NetworksWarehousing & 3PLFinancial AccountingERP SoftwareIndia GST ComplianceUAE VAT & e-InvoicingSaudi ZATCA & VATAll solutions →
RESOURCES
Knowledge CenterDeveloper & CLIBlogGuidesWhat is xMatix?Company facts
COMPANY
AboutCareersPartnersEventsContactAuthorsLegal
Sign in Request demo
Home/Docs/Entity Reference/General Ledger — entity reference
REFERENCE · Last reviewed

General Ledger — entity reference

A decommissioned legacy ledger table. Its physical table was dropped when the balanced journal ledger replaced it, and the general ledger is now a view over posted journal lines rather than a table of its own — reads and writes against this entity will not work, and first-party reports that referenced it were retired. Any question about ledger entries, account movements or postings should be answered from Journal and JournalLine instead. The metadata row survives only because entity definitions are upsert-only in the seed engine.

Fields

FieldLabelTypeRequiredWhat it does
AccountIdAccountLookup → Account
AmountAmount SignedCurrency
AmountCrDrAmountCalculated
BillIdBillLookup → Bill
BillLineIdBillLineLookup → BillLine
BranchIdBranchLookup → Branch
CreatedByIdCreated ByLookup → UserAccountYes
CreatedDateTimeCreated DateDateAndTimeYes
CreditCredit (Deprecated)Currency
DebitDebit (Deprecated)Currency
DetailsDetailsText
EffectiveAmountEffective AmountCalculated
ExternalIdExternalText
GLAccountIdGL AccountLookup → GLAccount
IdIdGuidYes
IsAccountBalancePostedIs Account Balance PostedBooleanYes
ModifiedByIdModified ByLookup → UserAccountYes
NameDocument NumberTextYes
OwnerIdOwnerLookup → UserAccountYes
PartnerAccountIdPartner AccountLookup → Account
PostingDatePosting DateDateYes
RecordTypeIdRecord TypeGuid, hidden
ReferenceReferenceText
SourceDocumentNameSource Document NameTextYes
TransactionTypeTransaction TypePickListYesValues: Invoice, InvoiceLine, PaymentTaken, PaymentTakenRelated, PaymentGiven, PaymentGivenRelated, BillLine, CreditNote, CreditNoteLine, DebitNote, DebitNoteLine, Journal, JournalLine, JournalRelated, Inventory, InventoryRelated, GoodReceipt.
UIPropsUI PropsText
UpdatedDateTimeModified DateDateAndTimeYes

Actions

ActionLabelTypeWhat it does
BulkDeleteDeleteDeleteDelete the selected records.
CloneCloneServerAction (Clone)Create a copy of this record
DeleteDeleteDeleteDelete
DeleteInListDeleteDeleteDelete in a list page
EditEditEditEdit
EditInLineEditEditEdit in page.
NewNewNewNew

Validations

ValidationApplies toError messageNotes
Amount ValidationAmount, ErrorAmount can't be zeroAmount rule Validation.