All applications611

Find your application

611 applications

Open full catalog

Browse applications by category or open the full catalog.

  1. GST Return Preparation — India
  2. Data model
Reference

The tables behind GST Return Preparation — India

GST Return Preparation — India ships with 15 tables, grouped here by the feature that uses them. Every record your team works with lives in one of them, and you can add fields and tables in Proto.

Tables
15
Features
7, plus shared settings
Change it
Add fields and tables in Proto

How the model is organised

Instruction core

Accounting documents ties an organization, owner and counterparty to amount, date, revision and status.

Financial scope

Ledger accounts, journal entries, journal lines and accounting periods hold account identity, debit and credit scope, provider movements and dated balances.

Decision and evidence

Review decisions, document lines, record attachments and operation receipts retain approvals, provider events, documents and effect checks.

Organization and applications

Organizations, team members, Users and business partners define scope; return working papers retains provider account applications. Exchange rates holds effective rates.

Every table, by feature

Instruction preparation

4 tablesAbout this feature
  • Accounting documents

    Typed banking instructions moving through authorization, submission and confirmation.

    Linked to Organizations, Team members, Business partners
  • Business partners

    Banks, custodians and settlement counterparties eligible for banking instructions.

    Linked to Organizations
  • Record attachments

    Supporting documents attached to a banking instruction.

    Linked to Accounting documents, Team members
  • Journal entries

    Debit and credit account scopes that make an instruction balanced.

    Linked to Accounting documents, Ledger accounts

Independent review

4 tablesAbout this feature
  • Accounting documents

    Typed banking instructions moving through authorization, submission and confirmation.

    Linked to Organizations, Team members, Business partners
  • Review decisions

    Independent approver decisions recorded against a frozen instruction revision.

    Linked to Accounting documents, Team members
  • Team members

    Preparers, approvers, auditors and administrators working in the organization.

    Linked to Users, Organizations
  • Record attachments

    Supporting documents attached to a banking instruction.

    Linked to Accounting documents, Team members

Provider evidence

4 tablesAbout this feature
  • Accounting documents

    Typed banking instructions moving through authorization, submission and confirmation.

    Linked to Organizations, Team members, Business partners
  • Document lines

    Provider statements, confirmations, settlement notices and corrections for an instruction.

    Linked to Accounting documents
  • Operation receipts

    Idempotent operation receipts with stable operation keys and actual effect references.

    Linked to Accounting documents
  • Record attachments

    Supporting documents attached to a banking instruction.

    Linked to Accounting documents, Team members

Journal and accounts

5 tablesAbout this feature
  • Ledger accounts

    Provider-held financial accounts owned by a counterparty.

    Linked to Business partners
  • Journal entries

    Debit and credit account scopes that make an instruction balanced.

    Linked to Accounting documents, Ledger accounts
  • Accounting documents

    Typed banking instructions moving through authorization, submission and confirmation.

    Linked to Organizations, Team members, Business partners
  • Business partners

    Banks, custodians and settlement counterparties eligible for banking instructions.

    Linked to Organizations
  • Exchange rates

    Read-only effective exchange rates for this app.

Reconciliation

5 tablesAbout this feature
  • Journal lines

    Source-identified provider movements matched against banking instructions.

    Linked to Ledger accounts, Accounting documents
  • Accounting periods

    Dated provider balance snapshots for a financial account.

    Linked to Ledger accounts
  • Accounting documents

    Typed banking instructions moving through authorization, submission and confirmation.

    Linked to Organizations, Team members, Business partners
  • Ledger accounts

    Provider-held financial accounts owned by a counterparty.

    Linked to Business partners
  • Document lines

    Provider statements, confirmations, settlement notices and corrections for an instruction.

    Linked to Accounting documents

Account applications

4 tablesAbout this feature
  • Return working papers

    Applications to open a provider-authorized account against a banking instruction.

    Linked to Accounting documents, Organizations
  • Accounting documents

    Typed banking instructions moving through authorization, submission and confirmation.

    Linked to Organizations, Team members, Business partners
  • Review decisions

    Independent approver decisions recorded against a frozen instruction revision.

    Linked to Accounting documents, Team members
  • Record attachments

    Supporting documents attached to a banking instruction.

    Linked to Accounting documents, Team members

Operations evidence

4 tablesAbout this feature
  • Operation receipts

    Idempotent operation receipts with stable operation keys and actual effect references.

    Linked to Accounting documents
  • Accounting documents

    Typed banking instructions moving through authorization, submission and confirmation.

    Linked to Organizations, Team members, Business partners
  • Review decisions

    Independent approver decisions recorded against a frozen instruction revision.

    Linked to Accounting documents, Team members
  • Document lines

    Provider statements, confirmations, settlement notices and corrections for an instruction.

    Linked to Accounting documents

Shared and settings

2 tables
  • Organizations

    Banking organizations whose treasury operations are run in this app.

  • Users

    Users

    Linked to Users

Keys and references

Use accounting documents.record number for the instruction’s business identity and its Id for record references. Keep provider IDs on accounting documents, document lines, journal lines and accounting periods where the source supplies them. A review decisions.source revision must identify the instruction revision that was actually inspected. Operation receipts.operation key identifies a repeated operation. Preserve these keys during migration.

Migration order

  1. Create Organizations, Users and team members for access scope.
  2. Load business partners, ledger accounts and exchange rates with source identifiers.
  3. Bring in accounting documents and their journal entries, record attachments and return working papers.
  4. Import review decisions, document lines and operation receipts against their parent instructions.
  5. Load journal lines and accounting periods, then reconcile provider IDs, dates and balances.

Set up GST Return Preparation — India your way.

Start free, then use Proto to change fields, steps and approvals before your team goes live.

How to get started