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

Table 18870 "TCS Journal Line" (IN)

IN country layer · Microsoft.Finance.TCS.TCSReturnAndSettlement

Open in Claude18870-in.mdSource on GitHub

Across versions

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

IN country layer · Microsoft.Finance.TCS.TCSReturnAndSettlement · BC29-30 · source at ea08af5e · facts from BC29

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

Properties

Property Value
Caption TCS 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 TCS Journal Template; DataClassification CustomerContent
2 Line No. Integer — DataClassification EndUserIdentifiableInformation
3 Account Type Enum “TCS Account Type” — enum TCS 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; 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 Customer No. Code[20] — TableRelation Customer.“No.”; 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 EndUserIdentifiableInformation
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 Journal Batch Name Code[10] — TableRelation “TCS Journal Batch”.Name where(“Journal Template Name” = field(“Journal Template Name”)); DataClassification CustomerContent
18 TCS Adjusted Boolean — DataClassification EndUserIdentifiableInformation
19 Surcharge Adjusted Boolean — DataClassification EndUserIdentifiableInformation
20 eCess Adjusted Boolean — DataClassification EndUserIdentifiableInformation
21 Bal. Account Type Enum “Bal. Account Type” — enum 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 EndUserIdentifiableInformation
25 Dimension Set ID Integer — TableRelation Dimension Set Entry; not editable; DataClassification SystemMetadata
26 State Code Code[10] — DataClassification EndUserIdentifiableInformation
27 TCS Nature of Collection Code[10] — TableRelation TCS Nature Of Collection; DataClassification CustomerContent
28 TCS Amount Decimal — not editable; DataClassification CustomerContent
29 SHE Cess Adjusted Boolean — DataClassification CustomerContent
30 Location Code Code[10] — TableRelation Location; DataClassification CustomerContent
31 Assessee Code Code[10] — TableRelation Assessee Code; not editable; DataClassification EndUserIdentifiableInformation
32 TCS % Decimal — not editable; DataClassification CustomerContent
33 TCS Amt Incl Surcharge Decimal — not editable; DataClassification CustomerContent
34 Bal. TCS Including SHECESS Decimal — not editable; 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 TCS % Applied Decimal — DataClassification CustomerContent
40 TCS Invoice No. Code[20] — not editable; DataClassification CustomerContent
41 TCS Base Amount Decimal — not editable; DataClassification CustomerContent
42 Challan No. Code[20] — DataClassification CustomerContent
43 Challan Date Date — DataClassification CustomerContent
44 Adjustment Boolean — not editable; DataClassification CustomerContent
45 TCS Transaction No. Integer — not editable; DataClassification EndUserIdentifiableInformation
46 Balance Surcharge Amount Decimal — not editable; DataClassification CustomerContent
47 Surcharge % Applied Decimal — DataClassification CustomerContent
48 Surcharge Base Amount Decimal — not editable; DataClassification CustomerContent
49 Balance TCS Amount Decimal — not editable; DataClassification CustomerContent
50 eCESS % Decimal — not editable; DataClassification CustomerContent
51 eCESS on TCS Amount Decimal — not editable; DataClassification CustomerContent
52 Total TCS Incl. SHE CESS Decimal — not editable; DataClassification CustomerContent
53 eCESS Base Amount Decimal — DataClassification CustomerContent
54 eCESS % Applied Decimal — DataClassification CustomerContent
55 Balance eCESS on TCS Amt Decimal — DataClassification CustomerContent
56 Bal. SHE Cess on TCS Amt Decimal — DataClassification CustomerContent
57 Pay TCS Boolean — DataClassification CustomerContent
58 T.C.A.N. No. Code[10] — TableRelation T.C.A.N. No.; DataClassification CustomerContent
59 SHE Cess Amount Decimal — DataClassification CustomerContent
60 SHE Cess % on TCS Decimal — not editable; DataClassification CustomerContent
61 SHE Cess on TCS Amount Decimal — not editable; DataClassification CustomerContent
62 SHE Cess Base Amount Decimal — not editable; DataClassification CustomerContent
63 SHE Cess % Applied Decimal — DataClassification CustomerContent
64 TCS Base Amount Applied Decimal — DataClassification CustomerContent
65 TCS Base Amount Adjusted Boolean — not editable; DataClassification CustomerContent
66 Source Code Code[10] — TableRelation Source Code; 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(LastTCSJournalLine: Record "TCS Journal Line"; BottomLine: Boolean)
  • CreateDim(DefaultDimSource: List of [Dictionary of [Integer, Code[20]]])
  • ShowShortcutDimCode(var ShortcutDimCode: array[8] of Code[20])
  • ShowDimensions()
  • CreateDimFromDefaultDim(FromFieldNo: Integer)

Plus 12 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: "TCS 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