BC Observatoryunofficial, made by waldo
tableFinanceofficial - Microsoftderived - from the source, no model text

Table 18001 "Detailed GST Ledger Entry" (IN)

IN country layer · Microsoft.Finance.GST.Base

Open in Claude18001-in.mdSource on GitHub

Across versions

  1. BC23-28not present
  2. BC29-30present

IN country layer · Microsoft.Finance.GST.Base · BC29-30 · source at ea08af5e · facts from BC29

An object of the IN localization, not part of W1.

Properties

Property Value
Caption Detailed GST Ledger Entry
LookupPageId Detailed GST Ledger Entry
DrillDownPageId Detailed GST Ledger Entry

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 Entry No. Integer — AutoIncrement; DataClassification SystemMetadata
2 Entry Type Enum “Detail Ledger Entry Type” — enum Detail Ledger Entry Type; DataClassification CustomerContent
3 Transaction Type Enum “Detail Ledger Transaction Type” — enum Detail Ledger Transaction Type; DataClassification CustomerContent
4 Document Type Enum “GST Document Type” — enum GST Document Type; DataClassification CustomerContent
5 Document No. Code[20] — DataClassification CustomerContent
6 Posting Date Date — DataClassification CustomerContent
7 Type enum Type — enum Type; DataClassification CustomerContent
8 No. Code[20] — TableRelation if (Type = const(“G/L Account”)) “G/L Account” else if (Type = const(Item)) Item else if (Type = const(Resource)) Resource else if (Type = const(“Fixed Asset”)) “Fixed Asset” else if (Type = const(“Charge (Item)”)) “Item Charge”; DataClassification CustomerContent
9 Product Type enum “Product Type” — enum Product Type; DataClassification CustomerContent
10 Source Type enum “Source Type” — enum Source Type; DataClassification CustomerContent
11 Source No. Code[20] — TableRelation if (“Source Type” = const(Customer)) Customer else if (“Source Type” = const(Vendor)) Vendor; DataClassification CustomerContent
12 HSN/SAC Code Code[10] — TableRelation “HSN/SAC”.Code where(“GST Group Code” = field(“GST Group Code”)); DataClassification CustomerContent
13 GST Component Code Code[30] — DataClassification CustomerContent
14 GST Group Code Code[20] — TableRelation GST Group; DataClassification CustomerContent
15 GST Jurisdiction Type enum “GST Jurisdiction Type” — enum GST Jurisdiction Type; DataClassification CustomerContent
16 GST Base Amount Decimal — DataClassification CustomerContent
17 GST % Decimal — DataClassification CustomerContent
18 GST Amount Decimal — DataClassification CustomerContent
19 External Document No. Code[40] — DataClassification CustomerContent
20 Amount Loaded on Item Decimal — DataClassification CustomerContent
21 Quantity Decimal — DataClassification CustomerContent
22 GST Without Payment of Duty Boolean — DataClassification CustomerContent
23 G/L Account No. Code[20] — TableRelation G/L Account; DataClassification CustomerContent
24 Reversed by Entry No. Integer — DataClassification CustomerContent
25 Reversed Boolean — DataClassification CustomerContent
26 Document Line No. Integer — DataClassification CustomerContent
27 Item Charge Entry Boolean — DataClassification CustomerContent
28 Reverse Charge Boolean — DataClassification CustomerContent
29 GST on Advance Payment Boolean — DataClassification CustomerContent
30 Payment Document No. Code[20] — DataClassification CustomerContent
31 GST Exempted Goods Boolean — DataClassification CustomerContent
32 Location Reg. No. Code[20] — DataClassification CustomerContent
33 Buyer/Seller Reg. No. Code[20] — DataClassification CustomerContent
34 GST Group Type enum “GST Group Type” — enum GST Group Type; DataClassification CustomerContent
35 GST Credit enum “GST Credit” — enum GST Credit; DataClassification CustomerContent
36 Reversal Entry Boolean — DataClassification CustomerContent
37 Transaction No. Integer — DataClassification CustomerContent
38 Currency Code Code[10] — DataClassification CustomerContent
39 Currency Factor Decimal — DataClassification CustomerContent
40 Application Doc. Type Enum “Application Doc Type” — enum Application Doc Type; DataClassification CustomerContent
41 Application Doc. No Code[20] — DataClassification CustomerContent
42 Applied From Entry No. Integer — DataClassification CustomerContent
43 Reversed Entry No. Integer — DataClassification CustomerContent
44 Remaining Closed Boolean — DataClassification CustomerContent
45 GST Rounding Precision Decimal — DataClassification CustomerContent
46 GST Rounding Type Enum “GST Inv Rounding Type” — enum GST Inv Rounding Type; DataClassification CustomerContent
47 Location Code Code[10] — TableRelation Location where(“Use As In-Transit” = const(false)); DataClassification CustomerContent
48 GST Customer Type Enum “GST Customer Type” — enum GST Customer Type; not editable; DataClassification CustomerContent
49 GST Vendor Type Enum “GST Vendor Type” — enum GST Vendor Type; not editable; DataClassification CustomerContent
50 Original Invoice No. Code[20] — DataClassification CustomerContent
51 Reconciliation Month Integer — DataClassification CustomerContent
52 Reconciliation Year Integer — DataClassification CustomerContent
53 Reconciled Boolean — DataClassification CustomerContent
54 Credit Availed Boolean — DataClassification CustomerContent
55 Paid Boolean — DataClassification CustomerContent
56 Credit Adjustment Type Enum “Credit Adjustment Type” — enum Credit Adjustment Type; DataClassification CustomerContent
57 UnApplied Boolean — DataClassification CustomerContent
58 GST Place of Supply enum “GST Dependency Type” — enum GST Dependency Type; not editable; DataClassification CustomerContent
59 Payment Type Enum “Payment Type” — enum Payment Type; DataClassification CustomerContent
60 Distributed Boolean — DataClassification CustomerContent
61 Distributed Reversed Boolean — DataClassification CustomerContent
62 Input Service Distribution Boolean — not editable; DataClassification CustomerContent
63 Opening Boolean — DataClassification CustomerContent
64 Remaining Base Amount Decimal — not editable; DataClassification CustomerContent
65 Remaining GST Amount Decimal — not editable; DataClassification CustomerContent
66 Dist. Document No. Code[20] — DataClassification CustomerContent
67 Associated Enterprises Boolean — not editable; DataClassification CustomerContent
68 Liable to Pay Boolean — not editable; DataClassification CustomerContent
69 Dist. Input GST Credit Boolean — DataClassification CustomerContent
70 Dist. Reverse Document No. Code[20] — DataClassification CustomerContent
71 Eligibility for ITC Enum “Eligibility for ITC” — enum Eligibility for ITC; DataClassification CustomerContent
72 GST Assessable Value Decimal — DataClassification CustomerContent
73 GST Inv. Rounding Precision Decimal — not editable; DataClassification CustomerContent
74 GST Inv. Rounding Type enum “GST Inv Rounding Type” — enum GST Inv Rounding Type; not editable; DataClassification CustomerContent
75 Cr. & Liab. Adjustment Type Enum “Cr Libty Adjustment Type” — enum Cr Libty Adjustment Type; DataClassification CustomerContent
76 AdjustmentBase Amount Decimal — DataClassification CustomerContent
77 Adjustment Amount Decimal — DataClassification CustomerContent
78 Custom Duty Amount Decimal — DataClassification CustomerContent
79 Journal Entry Boolean — not editable; DataClassification CustomerContent
80 Remaining Quantity Decimal — DataClassification CustomerContent
81 ARN No. Code[20] — DataClassification CustomerContent
82 Forex Fluctuation Boolean — DataClassification CustomerContent
83 Fluctuation Amt. Credit Boolean — DataClassification CustomerContent
84 CAJ % Decimal — DataClassification CustomerContent
85 CAJ Amount Decimal — DataClassification CustomerContent
86 CAJ % Permanent Reversal Decimal — DataClassification CustomerContent
87 CAJ Amount Permanent Reversal Decimal — DataClassification CustomerContent
88 Remaining CAJ Adj. Base Amt Decimal — DataClassification CustomerContent
89 Remaining CAJ Adj. Amt Decimal — DataClassification CustomerContent
90 CAJ Base Amount Decimal — DataClassification CustomerContent
91 G/L Entry No. Integer — not editable; DataClassification CustomerContent
92 Skip Tax Engine Trigger Boolean — not editable; DataClassification CustomerContent
93 Executed Use Case ID Guid — not editable; DataClassification CustomerContent
94 Post GST to Customer Boolean — not editable; DataClassification CustomerContent

Keys

  • Key1: Entry No. (clustered)
  • Key2: Transaction No.
  • Key3: Transaction Type, Location Reg. No., Document Type, Reconciled, GST Vendor Type, Reversed, Posting Date, Paid, Credit Adjustment Type
  • Key4: Location Reg. No., Transaction Type, Entry Type, GST Vendor Type, GST Credit, Reconciliation Month, Reconciliation Year
  • Key5: Document No., Document Line No., GST Component Code
  • Key6: Transaction Type, Document Type, Document No., Document Line No.
  • Key7: Payment Document No.
  • Key9: Transaction Type, Document Type, Document No., Transaction No.
  • Key11: Document No., HSN/SAC Code
  • Key14: Transaction Type, Document Type, Document No., Document Line No., GST Component Code
  • Key15: Transaction Type, Source Type, Source No., Document Type, Document No., GST Group Type
  • Key17: Document No., GST Component Code
  • Key18: Entry Type, Transaction Type, Document Type, Document No., Document Line No.
  • Key19: Transaction Type, Entry Type, Document No., Document Line No.
  • Key20: Dist. Document No., Distributed
  • Key21: Location Reg. No., Reconciled, Reconciliation Month, Reconciliation Year
  • Key22: Location Reg. No., Transaction Type, Entry Type, GST Vendor Type, GST Credit, Posting Date, Source No., Document Type, Document No.
  • Key23: Location Reg. No., Transaction Type, Entry Type, GST Vendor Type, GST Credit, Posting Date, Source No., Document Type, Document No., Document Line No.
  • Key24: Transaction Type, GST Jurisdiction Type, Source No., Document Type, Document No., Posting Date
  • Key25: Location Reg. No., GST Component Code, Paid, Posting Date, Liable to Pay, Reverse Charge
  • Key26: Location Reg. No., GST Component Code, Paid, Posting Date, Credit Availed
  • Key27: Location Reg. No., Posting Date, Entry Type, Transaction Type, Document Type
  • Key28: Location Reg. No., Document Type, Document No., HSN/SAC Code, GST %
  • Key29: Transaction Type, Entry Type, Document Type, Document No., Posting Date

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: "Detailed GST Ledger Entry"), 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.

Evidence 1 sources