Auto accounting

Tabelle public.auto_accounting

Spalten

• id: internal

• org_id: ID to organisation

• supplier_name: Supplier Name

• description: internal

• item_number: internal

• line_amount: double precision

• total_amount: double precision

• mapped_amount: double precision

• ledger_account: internal

• doc_id: internal

Analyse & Beschreibung

Technical Documentation for public.auto_accounting Table

Introduction

The public.auto_accounting table appears to be designed for managing and storing accounting data related to various suppliers and organizations. The table captures information about financial transactions, including amounts and ledger accounts, which are essential for financial reporting and analysis.

Column Descriptions

id

• Meaning: A unique identifier for each record in the table.

• Role: Primary key.

• Typical Contents: A UUID string representing each entry uniquely.

• Note: Ensures each record can be distinctly identified.

org_id

• Meaning: Identifier for the organization associated with the accounting entry.

• Role: Foreign key.

• Typical Contents: A UUID string linking to an organization in a parent table.

• Note: Used to associate accounting entries with specific organizations.

supplier_name

• Meaning: The name of the supplier involved in the transaction.

• Role: Descriptive field.

• Typical Contents: Text representing the supplier's name, like "Fellow Consulting AG".

• Note: Provides information about the supplier related to the transaction.

description

• Meaning: A short description of the transaction or item.

• Role: Descriptive field.

• Typical Contents: Text that describes the transaction, such as the name of an item ("apple" or "Peaches").

• Note: Helpful for understanding the nature of the transaction.

item_number

• Meaning: Identifier for a specific item involved in the transaction.

• Role: Descriptive field.

• Typical Contents: Could be a product or SKU identifier, although no example data is provided.

• Note: Useful for tracking or referencing specific items.

line_amount

• Meaning: The monetary amount for a specific line item in the transaction.

• Role: Financial field.

• Typical Contents: A decimal value representing the amount for an individual line item.

• Note: Important for detailed financial analysis at the line-item level.

total_amount

• Meaning: The total monetary amount for the transaction.

• Role: Financial field.

• Typical Contents: A decimal value representing the total transaction amount.

• Note: Represents the sum of all line amounts in a transaction.

mapped_amount

• Meaning: The amount that has been allocated or mapped to a specific account.

• Role: Financial field.

• Typical Contents: A decimal value indicating how much of the transaction has been allocated.

• Note: Useful for understanding how funds are distributed across accounts.

ledger_account

• Meaning: The account number in the ledger where the transaction is recorded.

• Role: Descriptive field.

• Typical Contents: Text representing an account number, such as "2200" or "2500".

• Note: Critical for accounting purposes to track where transactions are posted.

doc_id

• Meaning: An identifier for a related document or record.

• Role: Foreign key or reference.

• Typical Contents: A UUID string or other identifier linking to related documents.

• Note: Helps in associating transactions with specific documents or records for traceability.

This documentation provides a detailed overview of the public.auto_accounting table, describing its structure and the purpose of each column to aid developers and database administrators in understanding and utilizing the data effectively.