Table 18000 "Detailed GST Entry Buffer" (IN)
IN country layer · Microsoft.Finance.GST.Base
Across versions
- BC23-28not present
- 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 Entry Buffer |
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 | Document Type | enum “Document Type Enum” | — | enum Document Type Enum; DataClassification SystemMetadata |
| 3 | Document No. | Code[20] | — | DataClassification SystemMetadata |
| 4 | Posting Date | Date | — | DataClassification SystemMetadata |
| 5 | Type | enum Type | — | enum Type; DataClassification SystemMetadata |
| 6 | No. | Code[20] | — | DataClassification SystemMetadata |
| 7 | Product Type | enum “Product Type” | — | enum Product Type; DataClassification SystemMetadata |
| 8 | Transaction Type | enum “Transaction Type Enum” | — | enum Transaction Type Enum; DataClassification SystemMetadata |
| 9 | Source Type | enum “Source Type” | — | enum Source Type; DataClassification SystemMetadata |
| 10 | Source No. | Code[20] | — | TableRelation if (“Source Type” = const(Customer)) Customer else if (“Source Type” = const(Vendor)) Vendor; DataClassification SystemMetadata |
| 11 | GST Component Code | Code[30] | — | DataClassification SystemMetadata |
| 12 | GST Base Amount | Decimal | — | DataClassification SystemMetadata |
| 13 | GST % | Decimal | — | DataClassification SystemMetadata |
| 14 | GST Amount | Decimal | — | DataClassification SystemMetadata |
| 15 | Quantity | Decimal | — | DataClassification SystemMetadata |
| 16 | GST Group Code | Code[20] | — | TableRelation GST Group; DataClassification SystemMetadata |
| 17 | HSN/SAC Code | Code[10] | — | TableRelation “HSN/SAC”.Code where(“GST Group Code” = field(“GST Group Code”)); DataClassification SystemMetadata |
| 18 | GST Input/Output Credit Amount | Decimal | — | DataClassification SystemMetadata |
| 19 | Amount Loaded on Item | Decimal | — | DataClassification SystemMetadata |
| 20 | Location Code | Code[10] | — | TableRelation Location where(“Use As In-Transit” = const(false)); DataClassification SystemMetadata |
| 21 | Line No. | Integer | — | DataClassification SystemMetadata |
| 22 | Item Charge Assgn. Line No. | Integer | — | DataClassification SystemMetadata |
| 24 | GST on Advance Payment | Boolean | — | DataClassification SystemMetadata |
| 25 | Reverse Charge | Boolean | — | DataClassification SystemMetadata |
| 26 | Item Charge Assgn. Doc. Type | enum “Item Charge Assgn Doc Type” | — | enum Item Charge Assgn Doc Type; DataClassification SystemMetadata |
| 27 | Item Charge Assgn Doc. No. | Code[20] | — | DataClassification SystemMetadata |
| 28 | Journal Template Name | Code[10] | — | TableRelation Gen. Journal Template; DataClassification SystemMetadata |
| 29 | Journal Batch Name | Code[10] | — | TableRelation “Gen. Journal Batch”.Name where(“Journal Template Name” = field(“Journal Template Name”)); DataClassification SystemMetadata |
| 30 | Bill Of Export No. | Code[20] | — | DataClassification SystemMetadata |
| 31 | Bill Of Export Date | Date | — | DataClassification SystemMetadata |
| 32 | e-Comm. Merchant Id | Code[30] | — | DataClassification SystemMetadata |
| 33 | e-Comm. Operator GST Reg. No. | Code[20] | — | DataClassification SystemMetadata |
| 34 | Invoice Type | enum “Sales Invoice Type” | — | enum Sales Invoice Type; DataClassification SystemMetadata |
| 35 | Original Invoice No. | Code[20] | — | DataClassification SystemMetadata |
| 36 | Original Invoice Date | Date | — | DataClassification SystemMetadata |
| 37 | Adv. Pmt. Adjustment | Boolean | — | not editable; DataClassification SystemMetadata |
| 38 | Original Adv. Pmt Doc. No. | Code[20] | — | not editable; DataClassification SystemMetadata |
| 39 | Original Adv. Pmt Doc. Date | Date | — | not editable; DataClassification SystemMetadata |
| 40 | Cess | Boolean | — | not editable; DataClassification SystemMetadata |
| 41 | GST Group Type | enum “GST Group Type” | — | enum GST Group Type; not editable; DataClassification SystemMetadata |
| 42 | Buyer/Seller State Code | Code[10] | — | TableRelation State; DataClassification SystemMetadata |
| 43 | Shipping Address State Code | Code[10] | — | TableRelation State; DataClassification SystemMetadata |
| 44 | Location State Code | Code[10] | — | TableRelation State; not editable; DataClassification SystemMetadata |
| 45 | Location Reg. No. | Code[20] | — | not editable; DataClassification SystemMetadata |
| 46 | Buyer/Seller Reg. No. | Code[20] | — | not editable; DataClassification SystemMetadata |
| 47 | GST Place of Supply | enum “GST Dependency Type” | — | enum GST Dependency Type; not editable; DataClassification SystemMetadata |
| 48 | Charge To Cust/Vend | Decimal | — | not editable; DataClassification SystemMetadata |
| 49 | Currency Code | Code[10] | — | DataClassification SystemMetadata |
| 50 | Currency Factor | Decimal | — | DataClassification SystemMetadata |
| 51 | GST Rounding Precision | Decimal | — | DataClassification SystemMetadata |
| 52 | GST Rounding Type | enum “GST Inv Rounding Type” | — | enum GST Inv Rounding Type; DataClassification SystemMetadata |
| 53 | GST Base Amount (LCY) | Decimal | — | DataClassification SystemMetadata |
| 54 | GST Amount (LCY) | Decimal | — | DataClassification SystemMetadata |
| 55 | TDS/TCS Amount | Decimal | — | not editable; DataClassification SystemMetadata |
| 56 | Input Service Distribution | Boolean | — | not editable; DataClassification SystemMetadata |
| 57 | Inward | Boolean | — | DataClassification SystemMetadata |
| 58 | Exempted | Boolean | — | not editable; DataClassification SystemMetadata |
| 59 | Delivery Challan Amount | Decimal | — | DataClassification SystemMetadata |
| 60 | Custom Duty Amount | Decimal | — | DataClassification SystemMetadata |
| 61 | GST Assessable Value | Decimal | — | DataClassification SystemMetadata |
| 62 | Custom Duty Amount (LCY) | Decimal | — | DataClassification SystemMetadata |
| 63 | GST Assessable Value (LCY) | Decimal | — | DataClassification SystemMetadata |
| 66 | Component Calc. Type | enum “Component Calc Type” | — | enum Component Calc Type; DataClassification SystemMetadata |
| 67 | Cess Amount Per Unit Factor | Decimal | — | DataClassification SystemMetadata |
| 68 | Cess UOM | Code[10] | — | TableRelation Unit of Measure; DataClassification SystemMetadata |
| 69 | Cess Factor Quantity | Decimal | — | DataClassification SystemMetadata |
| 70 | Cess Amt Per Unit Factor (LCY) | Decimal | — | DataClassification SystemMetadata |
| 71 | UOM | Code[10] | — | TableRelation Unit of Measure; DataClassification SystemMetadata |
| 72 | Jnl. Bank Charge | Code[10] | Bank Charge caption | DataClassification SystemMetadata |
| 73 | Bank Charge Entry | Boolean | — | DataClassification SystemMetadata |
| 74 | Non-Availment | Boolean | — | DataClassification SystemMetadata |
| 75 | GST Inv. Rounding Precision | Decimal | — | DataClassification SystemMetadata |
| 76 | GST Inv. Rounding Type | enum “GST Inv Rounding Type” | — | enum GST Inv Rounding Type; DataClassification SystemMetadata |
| 77 | GST Order Address State | Code[10] | — | DataClassification SystemMetadata |
| 78 | Buy-From GST Registration No | Code[20] | — | DataClassification SystemMetadata |
| 79 | Order Address Code | Code[10] | — | DataClassification SystemMetadata |
| 80 | Bill to-Location(POS) | Code[10] | — | DataClassification SystemMetadata |
| 85 | Recurring Journal | Boolean | — | DataClassification SystemMetadata |
| 86 | Allocations Line No. | Integer | — | DataClassification SystemMetadata |
| 87 | ARN No. | Code[20] | — | DataClassification SystemMetadata |
| 88 | FA Journal Entry | Boolean | — | DataClassification SystemMetadata |
| 89 | Without Bill Of Entry | Boolean | — | DataClassification SystemMetadata |
| 90 | Finance Charge Memo | Boolean | — | DataClassification SystemMetadata |
| 91 | GST TDS | Boolean | — | DataClassification SystemMetadata |
| 92 | GST TCS | Boolean | — | DataClassification SystemMetadata |
| 93 | POS Out Of India | Boolean | — | DataClassification SystemMetadata |
| 94 | External Document No. | Code[40] | — | DataClassification SystemMetadata |
Keys
- Key1: Entry No. (clustered)
- Key2: Transaction Type, Document Type, Document No., Line No.
- Key3: Transaction Type, Journal Template Name, Journal Batch Name, Line No.
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 Entry Buffer"), 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.