GST Register (lpind5130m000)

Use session to view all the GST transaction details after the sales and purchase transactions are generated using the Generate Sales Data (lpind5230m000)and Generate Purchase Data (lpind5230m100)sessions.

Field Information

Source Company

The logistic company from which the order is originating.

GSTR Source Type

Indicates the source of the document.

Allowed values

Interest
Customer Claim
Supplier Claim
Service Contract
Freight Order
Debit/Credit Note
Rebate
Purchase Order
Manual Sales
Not Applicable
Contract
Project
Sales Order
Intercompany Trade
Service Order
Maintainance Sales Order
Service Call
Tax Origin

Indicates if the tax origin is a Sales or Purchase transaction.

Order Number

The order number associated with the transaction.

Order Line

The order line number.

Invoice Number

The invoice number. The number can either be a Sales Invoice or Purchase Invoice number depending upon the origin.

Transaction Type

The transaction type.

Document

The invoice document number.

Date

The invoice date.

Tax Invoice Number

The tax invoice number. This number can either be a Sales Invoice or Purchase Invoice number depending upon the origin.

Invoice Line Type

The type of invoice line.

Allowed values

Advance Receipt Request
Material
Not Applicable
Labor
Equipment
Tooling
Traveling
Subcontracting
Helpdesk
Freight
Interest
WIP Transfer
Installment
Triangular
Holdback
Installment Additional Costs
Pay from Receipt
Other
Warehouse Order
Schedules
Retrobilling
Credit Note
Cost-Plus
Debit Note
Freight Order
Direct Delivery
Rebate Lines
PCS Order
Expenses
Triangular Purchase
Extension
Contract Delivery
Rental
Unit Rate
Activity
Progress Payment Request
Progress
Fees & Penalties
Advance Invoice
Advance Payment Request
Manual Sales
Sales Order
Contract Installment
Non-billable
Invoice Reference Number

The invoice reference number (IRN) generated for the invoice.

IRN Status

The status of the invoice reference number (IRN).

Allowed values

Created
Not Applicable
Submitted to External System
Approved by External system
Rejected by External System
Canceled
Document Deleted
General
Department

The department associated with the transaction.

Warehouse

The warehouse associated to the shipment.

Shipment/Receipt

The code of the shipment or receipt.

Shipment/Receipt Line

The shipment or receipt line associated to the transaction.

Shipment/Receipt Date

The shipment or receipt date of the order.

Tax Country

The tax country for which the tax codes are maintained.

Tax Code

The tax code.

Tax Year

The tax year for which the tax is applicable..

Tax Period

The tax period.

Identification Number (OWN)

The sequence and actual Identification number of the organization for the invoice. Depending upon the origin, the number can either belong to the supplier or the buyer.

Identification Number (BP)

The sequence and actual Identification number of the business partner for the invoice. Depending upon the origin, this number can either belong to the supplier or the buyer.

Business Partner

The business partner as mentioned in the invoice. Depending upon the origin, the BP can either be associated to the supplier or the buyer.

Name

The name of the business partner.

Ship From State

The state from where goods are being shipped. Depending upon the origin, this can be the state of the supplier or the buyer.

Ship To State

The state to which goods are being shipped. Depending upon the origin, this can either be the state of the buyer or the supplier.

Place of Supply

The place of supply of goods or services based on the place of supply rules.

File Number

The number that identifies the GSTR file.

Filing User

The user who is filing the GSTR.

File Date

The date when the GSTR is filed.

Status

The status of the GST return filed.

Allowed values

Created
Sent
Accepted
Rejected
Resent
Rejected External
Amended
Remark

Additional remarks on the GST transaction.

Invoice Line
Invoice Line
Number Of Invoice Lines

The number of lines in the invoice.

Item

The item for which invoice is being raised.

Scheme Base

The type of scheme code to be considered for tax transactions.

Allowed values

Services

Scheme base is set to Service, when:

  • item is not involved, for example, project installments, landed cost, freight and so on, OR
  • the item is undergoing service, for example, service order, maintenance sales order and so on, OR
  • the sales order or purchase order is related to a service item
Goods

The scheme base is set to Goods for all sales and purchase transactions related to inventory items, such as, sale of goods using sales order, sales schedule, contract deliverables, part receipt and part delivery, purchase of goods.

Not Applicable
Classification Scheme

The scheme for which the codes are listed.

Classification Scheme Code

The code related to the classification scheme for a product or service. The list of all codes that belong to a classification scheme is defined in the Classification Codes (lprou2109m000) session.

Product Class

product class

Delivered/Received Quantity

The delivered or received quantity.

Delivered/Received Unit

The unit of the delivered or received quantity.

Invoice Amount

The amount specified in the invoice.

Currency

The currency used for the invoice amount.

Invoice Discount

The discount on the invoice.

Invoice Line Amount

The amount on the invoice line.

Invoice Line Discount Amount

The discount amount of the invoice line.

Invoice Line Net Amount

The net amount of the invoice.

Paid Amount

The amount paid by the user.

Accounting
Debit/Credit

The debit or credit transaction.

Ledger Account

The ledger account of the transaction.

Dimension 1

Corresponding dimension of the ledger account.

Reporting
Reporting
Exempt

Indicates if tax is exempted from the sales/purchase transaction.

Interstate

Indicates if the tax is configured based on the interstate tax code.

Reverse Charge

Indicates if the transaction is a reverse charge transaction.

Note: This indicator is set to yes only if the VAT Type field is set to Shifted.
GSTR Transaction Identifier

The GSTR transaction identifier.

Note: 

A transaction can be identified as one of these categories:

  • Registered BP
  • Unregistered BP
  • Registered BP (Advances)
  • Unregistered BP (Advances)
  • Registered BP (SEZ without payment of taxes)
  • Registered BP (SEZ with payment of taxes)
  • Export Sales without payment of taxes
  • Export Sales with payment of taxes
  • Registered BP (Deemed Exports)
  • Registered BP (Credit Note)
  • Unregistered BP (Credit Note)
  • Registered BP (Assignments of Advance)
  • Unregistered BP (Assignments of Advance)
  • Registered BP (Sum of all taxes on invoice is ZERO)
  • Unregistered BP (Sum of all taxes on invoice is ZERO)
  • Registered BP (Non-GST )
  • Unregistered BP (Non-GST )
  • Registered BP (Exempt)
  • Unregistered BP (Exempt)
  • Import of Goods
  • Import of Service
  • Registered BP (Reverse Charge)
  • Unregistered BP (Reverse Charge)
Trade Type

The trade type.

Allowed values

Export
Import
Domestic Outbound
Domestic Inbound
Other
GSTR Document Type

Type of GSTR document.

Allowed values

Sales
Journal Voucher
Purchase
Not Applicable
Credit Note
Debit Note
Advance Receipt
Advance Payment
Assignment
Cash Journal
Write Off Bad Debt
Customs
Customs Document Number

The document number generated either during import (bill of entry) or export (shipping bill).

Customs Document Date

The date on which the customs document number is generated.

Customs Document Amount

The amount on the customs document number that is mentioned on Bill of Entry or Shipping Bill number.

Port Code

The Port of Entry or Port of Discharge depending upon the transaction.

Original Document
Original Invoice Company

The original invoice company. These details are specified in case of a credit note transaction.

Original Invoice Transaction Type

The original transaction type.

Original Invoice Number

The original invoice number for the credit note transaction.

Original Invoice Line

The original invoice line for the credit note transaction.

Original Invoice Date

The original invoice type for the credit note transaction.

Reason

The reason for rejection is specified for a return order or credit note.

Transport
E-Way Bill Number

The number of the E-way Bill document generated for the invoice.

Carrier/LSP

The carrier that picks up the goods associated with the e-way bill generated for the invoice.

LR Number

The LR number of the e-way bill associated with the invoice.

LR Date

The date and time when the LR number is generated for the E-Way Bill.

Reconciliation
Reconciled with

The entity with which the GSTR-2 or purchase register data is matched or reconciled.

Allowed values

GSTR-2A
GSTR-2B
Not Applicable
Reconciliation Status

The status of the GST reconciliation.

Allowed values

Open
Amended
Not Applicable
Matched
Partial Match
Probable Match
Not Matched
Not Found in PR
Not Found in 2A/2B
Reconciliation Reference

The additional information related to the GST matching process.