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

Table 18747 "TDS Journal Line" (IN)

IN country layer · Microsoft.Finance.TDS.TDSReturnAndSettlement

Open in Claude18747-in.mdSource on GitHub

Across versions

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

IN country layer · Microsoft.Finance.TDS.TDSReturnAndSettlement · BC29-30 · source at ea08af5e · facts from BC29

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

Properties

Property Value
Caption TDS Journal Line
Access Public
Extensible true

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 TDS Journal Template; DataClassification CustomerContent
2 Line No. Integer — DataClassification EndUserIdentifiableInformation
3 Account Type Enum “TDS Account Type” — enum TDS 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 Description Text[100] — DataClassification CustomerContent
9 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
10 Salespers./Purch. Code Code[20] — DataClassification CustomerContent
11 Amount Decimal — DataClassification CustomerContent
12 Debit Amount Decimal — DataClassification CustomerContent
13 Credit Amount Decimal — DataClassification CustomerContent
14 Balance (LCY) Decimal — not editable; DataClassification CustomerContent
15 Shortcut Dimension 1 Code Code[20] — TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(1)); DataClassification CustomerContent
16 Shortcut Dimension 2 Code Code[20] — TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(2)); DataClassification CustomerContent
17 Source Code Code[10] — TableRelation Source Code; not editable; DataClassification CustomerContent
18 System-Created Entry Boolean — not editable; DataClassification CustomerContent
19 Journal Batch Name Code[10] — TableRelation “TDS Journal Batch”.Name where(“Journal Template Name” = field(“Journal Template Name”)); DataClassification CustomerContent
20 Reason Code Code[10] — TableRelation Reason Code; DataClassification CustomerContent
21 Bal. Account Type Enum “TDS Bal. Account Type” — enum TDS Bal. Account Type; DataClassification CustomerContent
22 Document Date Date — DataClassification CustomerContent
23 External Document No. Code[35] — DataClassification CustomerContent
24 Posting No. Series Code[10] — TableRelation No. Series; DataClassification CustomerContent
25 Dimension Set ID Integer — TableRelation Dimension Set Entry; not editable; DataClassification SystemMetadata
26 State Code Code[10] — DataClassification CustomerContent
27 TDS Amount Decimal — not editable; DataClassification CustomerContent
28 Tax Amount Decimal — DataClassification CustomerContent
29 Location Code Code[10] — TableRelation Location; DataClassification CustomerContent
30 Assessee Code Code[10] — TableRelation Assessee Code; not editable; DataClassification CustomerContent
31 TDS % Decimal — not editable; DataClassification CustomerContent
32 TDS Amt Incl Surcharge Decimal — not editable; DataClassification CustomerContent
33 Bal. TDS Including SHE CESS Decimal — not editable; DataClassification CustomerContent
34 CESS Amount Decimal — DataClassification CustomerContent
35 eCess Amount Decimal — DataClassification CustomerContent
36 Surcharge % Decimal — not editable; DataClassification CustomerContent
37 Surcharge Amount Decimal — not editable; DataClassification CustomerContent
38 Concessional Code Code[10] — TableRelation Concessional Code; not editable; DataClassification CustomerContent
39 TDS Entry Boolean — DataClassification CustomerContent
40 TDS % Applied Decimal — DataClassification CustomerContent
41 TDS Invoice No. Code[20] — not editable; DataClassification CustomerContent
42 TDS Base Amount Decimal — not editable; DataClassification CustomerContent
43 Challan No. Code[20] — DataClassification CustomerContent
44 Challan Date Date — DataClassification CustomerContent
45 Adjustment Boolean — not editable; DataClassification CustomerContent
46 TDS Transaction No. Integer — not editable; DataClassification CustomerContent
47 E.C.C. No. Code[20] — DataClassification CustomerContent
48 Balance Surcharge Amount Decimal — not editable; DataClassification CustomerContent
49 Surcharge % Applied Decimal — DataClassification CustomerContent
50 Surcharge Base Amount Decimal — not editable; DataClassification CustomerContent
51 Balance TDS Amount Decimal — not editable; DataClassification CustomerContent
52 eCESS % Decimal — not editable; DataClassification CustomerContent
53 eCESS on TDS Amount Decimal — not editable; DataClassification CustomerContent
54 Total TDS Incl. SHE CESS Decimal — not editable; DataClassification CustomerContent
55 eCESS Base Amount Decimal — DataClassification CustomerContent
56 eCESS % Applied Decimal — DataClassification CustomerContent
58 Per Contract Boolean — DataClassification CustomerContent
59 Bal. SHE Cess on TDS Amt Decimal — DataClassification CustomerContent
60 T.A.N. No. Code[10] — TableRelation TAN Nos.; DataClassification CustomerContent
61 SHE Cess Amount Decimal — DataClassification CustomerContent
62 SHE Cess % Decimal — not editable; DataClassification CustomerContent
63 SHE Cess on TDS Amount Decimal — not editable; DataClassification CustomerContent
64 SHE Cess Base Amount Decimal — not editable; DataClassification CustomerContent
65 SHE Cess % Applied Decimal — DataClassification CustomerContent
66 TDS Adjusted Boolean — DataClassification CustomerContent
67 Surcharge Adjusted Boolean — DataClassification CustomerContent
68 TDS eCess Adjusted Boolean — DataClassification CustomerContent
69 TDS SHE Cess Adjusted Boolean — DataClassification CustomerContent
70 TDS Base Amount Applied Decimal — DataClassification CustomerContent
71 TDS Base Amount Adjusted Boolean — not editable; DataClassification CustomerContent
72 TDS Section Code Code[10] — TableRelation TDS Section; DataClassification CustomerContent
73 TDSEntry Boolean TDS Entry caption DataClassification CustomerContent
87 Balance eCESS on TDS Amt Decimal — DataClassification CustomerContent
88 TDS Adjustment Boolean — DataClassification CustomerContent
89 TDS Line Amount Decimal — DataClassification CustomerContent
90 Currency Code Code[10] — TableRelation Currency; DataClassification CustomerContent
91 Currency Factor Decimal — not editable; DataClassification CustomerContent

Keys

  • Key1: Journal Template Name, Journal Batch Name, Line No. (clustered)
  • Key2: Journal Template Name, Journal Batch Name, Posting Date, Document No.
  • Key3: Journal Template Name, Journal Batch Name, Location Code, Document No.

Procedures

  • EmptyLine(): Boolean
  • SetUpNewLine(LastTDSJournalLine: Record "TDS Journal Line"; BottomLine: Boolean)
  • CreateDim(DefaultDimSource: List of [Dictionary of [Integer, Code[20]]])
  • ValidateShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])
  • ShowShortcutDimCode(var ShortcutDimCode: array[8] of Code[20])
  • ShowDimensions()
  • CreateDimFromDefaultDim(FromFieldNo: Integer)

Plus 7 local procedures.

Triggers

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: "TDS 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.

Evidence 1 sources