Table 18810 "TCS Entry" (IN)

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

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

Properties

Property	Value
Caption	TCS Entry
Access	Public
Extensible	true
LookupPageId	TCS Entries
DrillDownPageId	TCS Entries

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 EndUserIdentifiableInformation
2	Account Type	Enum “TCS Account Type”	—	enum TCS Account Type; DataClassification EndUserIdentifiableInformation
3	Account No.	Code[20]	—	TableRelation if (“Account Type” = const(“G/L Account”)) “G/L Account” else if (“Account Type” = const(Customer)) Customer; DataClassification EndUserIdentifiableInformation
4	Posting Date	Date	—	DataClassification EndUserIdentifiableInformation
5	Document Type	Enum “Gen. Journal Document Type”	—	enum Enum 6 “Gen. Journal Document Type”; DataClassification EndUserIdentifiableInformation
6	Document No.	Code[20]	—	DataClassification EndUserIdentifiableInformation
7	Description	Text[100]	—	DataClassification EndUserIdentifiableInformation
8	TCS Amount Including Surcharge	Decimal	—	DataClassification EndUserIdentifiableInformation
9	TCS Base Amount	Decimal	—	DataClassification EndUserIdentifiableInformation
10	Customer No.	Code[20]	—	DataClassification EndUserIdentifiableInformation
11	TCS Nature of Collection	Code[10]	—	not editable; DataClassification EndUserIdentifiableInformation
12	Assessee Code	Code[10]	—	DataClassification EndUserIdentifiableInformation
13	TCS Paid	Boolean	—	DataClassification EndUserIdentifiableInformation
15	Challan Date	Date	—	DataClassification EndUserIdentifiableInformation
16	Challan No.	Code[20]	—	DataClassification EndUserIdentifiableInformation
17	Bank Name	Text[100]	—	DataClassification EndUserIdentifiableInformation
18	TCS %	Decimal	—	DataClassification EndUserIdentifiableInformation
19	Adjusted	Boolean	—	DataClassification EndUserIdentifiableInformation
20	Adjusted TCS %	Decimal	—	DataClassification EndUserIdentifiableInformation
21	Bal. TCS Including SHE CESS	Decimal	—	DataClassification EndUserIdentifiableInformation
22	Pay TCS Document No.	Code[20]	—	DataClassification EndUserIdentifiableInformation
24	Surcharge %	Decimal	—	DataClassification EndUserIdentifiableInformation
25	Transaction No.	Integer	—	DataClassification EndUserIdentifiableInformation
26	Customer P.A.N. No.	Code[20]	—	DataClassification EndUserIdentifiableInformation
27	Surcharge Amount	Decimal	—	DataClassification EndUserIdentifiableInformation
28	Concessional Code	Code[10]	—	TableRelation Concessional Code; DataClassification EndUserIdentifiableInformation
29	Invoice Amount	Decimal	—	DataClassification EndUserIdentifiableInformation
30	Applied	Boolean	—	DataClassification EndUserIdentifiableInformation
31	TCS Amount	Decimal	—	DataClassification EndUserIdentifiableInformation
32	Remaining Surcharge Amount	Decimal	—	DataClassification EndUserIdentifiableInformation
33	Remaining TCS Amount	Decimal	—	DataClassification EndUserIdentifiableInformation
34	Adjusted Surcharge %	Decimal	—	DataClassification EndUserIdentifiableInformation
35	Surcharge Base Amount	Decimal	—	DataClassification EndUserIdentifiableInformation
36	G/L Enty No.	Integer	—	DataClassification EndUserIdentifiableInformation
37	eCESS %	Decimal	—	DataClassification EndUserIdentifiableInformation
38	eCESS Amount	Decimal	—	DataClassification EndUserIdentifiableInformation
39	Total TCS Including SHE CESS	Decimal	—	DataClassification EndUserIdentifiableInformation
40	Adjusted eCESS %	Decimal	—	DataClassification EndUserIdentifiableInformation
41	T.C.A.N. No.	Code[10]	—	DataClassification EndUserIdentifiableInformation
42	Customer Account No.	Code[20]	—	DataClassification EndUserIdentifiableInformation
43	Reversed	Boolean	—	DataClassification EndUserIdentifiableInformation
44	Reversed by Entry No.	Integer	—	DataClassification EndUserIdentifiableInformation
45	Reversed Entry No.	Integer	—	DataClassification EndUserIdentifiableInformation
46	User ID	Code[50]	—	TableRelation User.“User Name”; DataClassification EndUserIdentifiableInformation
47	Source Code	Code[10]	—	DataClassification EndUserIdentifiableInformation
48	TCS Payment Date	Date	—	DataClassification EndUserIdentifiableInformation
49	Challan Register Entry No.	Integer	—	DataClassification EndUserIdentifiableInformation
50	SHE Cess %	Decimal	—	DataClassification EndUserIdentifiableInformation
51	SHE Cess Amount	Decimal	—	DataClassification EndUserIdentifiableInformation
52	Adjusted SHE CESS %	Decimal	—	DataClassification EndUserIdentifiableInformation
53	Original TCS Base Amount	Decimal	—	not editable; DataClassification EndUserIdentifiableInformation
54	TCS Base Amount Adjusted	Boolean	—	not editable; DataClassification EndUserIdentifiableInformation
55	Payment Amount	Decimal	—	DataClassification EndUserIdentifiableInformation
56	Check/DD No.	Code[10]	—	DataClassification EndUserIdentifiableInformation
57	Check Date	Date	—	DataClassification EndUserIdentifiableInformation
58	Currency Code	Code[10]	—	TableRelation Currency; DataClassification EndUserIdentifiableInformation
59	Currency Factor	Decimal	—	DataClassification EndUserIdentifiableInformation
60	Rem. Total TCS Incl. SHE CESS	Decimal	—	DataClassification EndUserIdentifiableInformation
61	Concessional Form No.	Code[20]	—	DataClassification EndUserIdentifiableInformation
62	Per Contract	Boolean	—	DataClassification EndUserIdentifiableInformation
63	BSR Code	Code[20]	—	DataClassification EndUserIdentifiableInformation
64	Minor Head Code	Enum “Minor Head Type”	—	enum Minor Head Type; DataClassification EndUserIdentifiableInformation
65	TCS on Recpt. Of Pmt.	Boolean	—	DataClassification SystemMetadata

Keys

Key1: Entry No. (clustered)
Key2: Account Type
Key3: Posting Date, Assessee Code, Applied
Key4: Document No., Posting Date
Key5: Posting Date, Assessee Code, Document Type
Key6: Pay TCS Document No., Posting Date
Key7: Transaction No.
Key8: Posting Date, Document No.
Key9: Challan No.

Procedures

1 local procedures, no public ones.

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 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.