Table 18325 "GST Journal Line" (IN)
IN country layer · Microsoft.Finance.GST.ReturnSettlement
Across versions
- BC23-28not present
- BC29-30present
IN country layer · Microsoft.Finance.GST.ReturnSettlement · BC29-30 · source at ea08af5e · facts from BC29
An object of the IN localization, not part of W1.
Properties
| Property | Value |
|---|---|
| Caption | GST Journal Line |
Fields
Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.
| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 1 | Journal Template Name | Code[10] | — | TableRelation GST Journal Template; DataClassification CustomerContent |
| 2 | Line No. | Integer | — | DataClassification CustomerContent |
| 3 | Account Type | Enum “Gen. Journal Account Type” | — | enum Enum 81 “Gen. Journal Account Type”; DataClassification CustomerContent |
| 4 | Account No. | Code[20] | — | TableRelation if (“Account Type” = const(“G/L Account”)) “G/L Account” else if (“Account Type” = const(Customer)) Customer else if (“Account Type” = const(Vendor)) Vendor else if (“Account Type” = const(“Bank Account”)) “Bank Account”; DataClassification CustomerContent |
| 5 | Posting Date | Date | — | DataClassification CustomerContent |
| 6 | Document Type | Enum “Gen. Journal Document Type” | — | enum Enum 6 “Gen. Journal Document Type”; DataClassification CustomerContent |
| 7 | Document No. | Code[20] | — | DataClassification CustomerContent |
| 8 | Document Line No. | Integer | — | DataClassification CustomerContent |
| 9 | Adjustment Type | Enum “Adjustment Type” | — | enum Adjustment Type; DataClassification CustomerContent |
| 10 | Description | Text[50] | — | DataClassification CustomerContent |
| 11 | Bal. Account Type | Enum “Gen. Journal Account Type” | — | enum Enum 81 “Gen. Journal Account Type”; DataClassification CustomerContent |
| 12 | Bal. Account No. | Code[20] | — | TableRelation if (“Bal. Account Type” = const(“G/L Account”)) “G/L Account” else if (“Bal. Account Type” = const(Customer)) Customer else if (“Bal. Account Type” = const(Vendor)) Vendor else if (“Bal. Account Type” = const(“Bank Account”)) “Bank Account”; DataClassification CustomerContent |
| 13 | Amount | Decimal | — | DataClassification CustomerContent |
| 14 | Debit Amount | Decimal | — | DataClassification CustomerContent |
| 15 | Credit Amount | Decimal | — | DataClassification CustomerContent |
| 16 | Shortcut Dimension 1 Code | Code[20] | — | TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(1)); DataClassification CustomerContent |
| 17 | Shortcut Dimension 2 Code | Code[20] | — | TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(2)); DataClassification CustomerContent |
| 18 | Salespers./Purch. Code | Code[20] | — | TableRelation Salesperson/Purchaser; DataClassification CustomerContent |
| 19 | Source Code | Code[10] | — | TableRelation Source Code; not editable; DataClassification CustomerContent |
| 20 | System-Created Entry | Boolean | — | not editable; DataClassification CustomerContent |
| 21 | Journal Batch Name | Code[10] | — | TableRelation “GST Journal Batch”.Name where(“Journal Template Name” = field(“Journal Template Name”)); DataClassification CustomerContent |
| 22 | No. Series | Code[10] | — | TableRelation No. Series; DataClassification CustomerContent |
| 23 | Posting No. Series | Code[10] | — | TableRelation No. Series; DataClassification CustomerContent |
| 24 | Template Type | Enum “GST Adjustment Journal Type” | — | enum GST Adjustment Journal Type; DataClassification CustomerContent |
| 25 | Location Code | Code[10] | — | TableRelation Location; DataClassification CustomerContent |
| 26 | Reason Code | Code[10] | — | TableRelation Reason Code; DataClassification CustomerContent |
| 27 | External Document No. | Code[35] | — | DataClassification CustomerContent |
| 28 | Dimension Set ID | Integer | — | TableRelation Dimension Set Entry; not editable; DataClassification SystemMetadata |
| 29 | DGL From Entry No. | Integer | — | DataClassification CustomerContent |
| 30 | DGL From To No. | Integer | — | DataClassification CustomerContent |
| 31 | Original Location GSTIN | Code[20] | — | DataClassification CustomerContent |
| 32 | Original Location | Code[10] | — | TableRelation Location; not editable; DataClassification CustomerContent |
| 33 | Original Quantity | Decimal | — | not editable; DataClassification CustomerContent |
| 34 | GST Base Amount | Decimal | — | DataClassification CustomerContent |
| 35 | GST Amount | Decimal | — | DataClassification CustomerContent |
| 36 | Total GST Amount | Decimal | — | DataClassification CustomerContent |
| 37 | Total ITC Amount Available | Decimal | — | DataClassification CustomerContent |
| 38 | Quantity to be Adjusted | Decimal | — | DataClassification CustomerContent |
| 39 | Amount of Adjustment | Decimal | — | DataClassification CustomerContent |
| 40 | Input Credit/Output Tax Amount | Decimal | — | DataClassification CustomerContent |
| 41 | Amount to be Loaded on Invento | Decimal | — | DataClassification CustomerContent |
| 42 | GST Adjustment Entry | Boolean | — | DataClassification CustomerContent |
| 43 | GST Transaction No. | Integer | — | DataClassification CustomerContent |
| 44 | Quantity | Decimal | — | DataClassification CustomerContent |
Keys
- Key1: Journal Template Name, Journal Batch Name, Line No. (clustered)
- Key2: GST Transaction No., Document No., Document Line No.
Procedures
EmptyLine(): BooleanSetUpNewLine(LastGSTJournalLine: Record "GST Journal Line"; Balance: Decimal; BottomLine: Boolean)CreateDim(DefaultDimSource: List of [Dictionary of [Integer, Code[20]]])ValidateShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])LookupShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])ShowShortcutDimCode(var ShortcutDimCode: array[8] of Code[20])ShowDimensions()OpenTracking()CreateDimFromDefaultDim(FromFieldNo: Integer)
Plus 3 local procedures.
Triggers
OnDelete, OnInsert
Ask your agent
Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "GST Journal Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.
A IN country object, not part of W1: the default corpus does not have it; bcatlas_list_countries shows which countries the atlas has.