tableFinanceofficial - Microsoftderived - from the source, no model text

Table 6788 "Withholding Tax Entry"

WithholdingTax · Microsoft.WithholdingTax

Across versions

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

Neighbourhood 23 connected objects and pages

Table 18 "Customer" (relates to)CustomerTable 222 "Ship-to Address" (relates to)Ship-to AddressTable 224 "Order Address" (relates to)Order AddressTable 23 "Vendor" (relates to)VendorTable 250 "Gen. Business Posting Group" (relates to)Table 251 "Gen. Product Posting Group" (relates to)Gen. Product Posting GroupTable 5200 "Employee" (relates to)EmployeeTable 6784 "Wthldg. Tax Bus. Post. Group" (relates to)Wthldg. Tax Bus. Post. GroupTable 6785 "Wthldg. Tax Prod. Post. Group" (relates to)Table 6787 "Withholding Tax Revenue Types" (relates to)Table 6792 "Withholding Tax Group" (relates to)Table 9 "Country/Region" (relates to)Page 6788 "Withholding Tax Entries" (pages and codeunits on it, 3 links)Withholding Tax EntriesCodeunit 6792 "Wthldg Tax Preview Handler" (event subscribers)Codeunit 8703 "Feature Telemetry" (calls, 2 links)Feature TelemetryCodeunit 703 "Find Record Management" (calls)Table extension 6798 "Withholding Purch. Inv. Header" (referenced by, 3 links)Withholding Purch. Inv. HeaderTable extension 6799 "WHT Purch. Cr. Memo Hdr." (referenced by, 3 links)WHT Purch. Cr. Memo Hdr.Table 6790 "Temp Withholding Tax Entry" (referenced by, 2 links)Temp Withholding Tax EntryTable extension 6792 "Withholding Vend Led Entry Ext" (referenced by, 2 links)Withholding Vend Led Entry ExtTable extension 6795 "Withholding G/L Register Ext" (referenced by, 2 links)Withholding G/L Register ExtSet up and post employee withholding tax (Learn pages)View withholding tax entries (Learn pages)

Open in the neighbourhood explorer

One hop out, from the extracted relations and call graph. Up to 40 shown; the sections below list them all.

WithholdingTax · Microsoft.WithholdingTax · BC29-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 6788 “Withholding Tax Entries” (2 Learn pages).

Properties

Property Value
Caption Withholding Tax Entry
DataClassification CustomerContent

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 Specifies an auto-generated unique key for every transaction in this table. via Page 6788 “Withholding Tax Entries” not editable
2 Gen. Bus. Posting Group Code[20] Specifies that the value is assigned from Gen. Bus. Posting Group in the Sales/Purchase/Journal transaction. via Page 6788 “Withholding Tax Entries” TableRelation Table 250 “Gen. Business Posting Group” (Gen. Business Posting Group); not editable
3 Gen. Prod. Posting Group Code[20] Specifies the value is assigned from Gen. Prod. Posting Group in the Sales/Purchase/Journal transaction. via Page 6788 “Withholding Tax Entries” TableRelation Table 251 “Gen. Product Posting Group” (Gen. Product Posting Group); not editable
4 Posting Date Date Specifies the date when the original entry was posted. via Page 6788 “Withholding Tax Entries” not editable
5 Document No. Code[20] Specifies the document number of the original transaction. via Page 6788 “Withholding Tax Entries” not editable
6 Document Type Enum “Gen. Journal Document Type” Specifies the value is assigned from Document Type in the Sales/Purchase/Journal transaction. via Page 6788 “Withholding Tax Entries” enum Enum 6 “Gen. Journal Document Type”; not editable
8 Base Decimal Specifies the calculated withholding tax base amount. via Page 6788 “Withholding Tax Entries” not editable
9 Amount Decimal Specifies the calculated withholding tax amount. via Page 6788 “Withholding Tax Entries” not editable
10 Withholding Tax Calc. Type Option Specifies the withholding tax calculation type. via Page 6788 “Withholding Tax Entries” OptionCaption: Normal Withholding Tax,Full Withholding Tax; not editable
11 Currency Code Code[10] Specifies that the value of Specifies that this field is assigned from Currency Code in the Sales/Purchase/Journal transaction. via Page 6788 “Withholding Tax Entries”
12 Bill-to/Pay-to No. Code[20] Specifies the number of the Bill-to Customer or Pay-to Vendor that the entry is linked to. via Page 6788 “Withholding Tax Entries” TableRelation Table 18 “Customer”, Table 23 “Vendor” (if (“Transaction Type” = const(Purchase)) Vendor else if (“Transaction Type” = const(Sale)) Customer)
14 User ID Code[50] Specifies the ID of the user that is associated with the entry. via Page 6788 “Withholding Tax Entries” not editable; DataClassification EndUserIdentifiableInformation
15 Source Code Code[10] Specifies the source code that is linked to the Withholding Tax entry. via Page 6788 “Withholding Tax Entries” TableRelation Source Code; not editable
16 Reason Code Code[10] Specifies the reason code for the entry. via Page 6788 “Withholding Tax Entries” TableRelation Reason Code; not editable
17 Closed by Entry No. Integer Specifies the entry number of the Withholding Tax entry that has been applied to (that has closed) the entry. via Page 6788 “Withholding Tax Entries” TableRelation Table 6788 “Withholding Tax Entry” (Withholding Tax Entry); not editable
18 Closed Boolean Specifies that the entry has been closed for transactions. via Page 6788 “Withholding Tax Entries” not editable
19 Country/Region Code Code[10] Specifies the country code for the customer or vendor that the Withholding Tax entry is linked to. via Page 6788 “Withholding Tax Entries” TableRelation Table 9 “Country/Region” (Country/Region)
21 Transaction No. Integer Specifies the transaction number assigned to the entry. via Page 6788 “Withholding Tax Entries” not editable
22 Unrealized Amount Decimal Specifies the withholding tax amount in the original currency that will be realized during payment as calculated during the posting of the document. via Page 6788 “Withholding Tax Entries” not editable
23 Unrealized Base Decimal Specifies the base amount in the original currency that the Withholding Tax Amount was calculated from. via Page 6788 “Withholding Tax Entries” not editable
24 Remaining Unrealized Amount Decimal Specifies the calculated remaining Withholding Tax amount. via Page 6788 “Withholding Tax Entries” not editable
25 Remaining Unrealized Base Decimal Specifies the calculated remaining base amount. via Page 6788 “Withholding Tax Entries” not editable
26 External Document No. Code[35] Specifies the external document number for this entry. via Page 6788 “Withholding Tax Entries” not editable
27 Transaction Type Option Specifies the source of the transaction. via Page 6788 “Withholding Tax Entries” OptionCaption: ,Purchase,Sale,Settlement
28 No. Series Code[20] Specifies the number series that the document number on this entry belongs to. via Page 6788 “Withholding Tax Entries” TableRelation No. Series; not editable
29 Unreal. Wthldg. Tax Entry No. Integer Specifies the number of the original Withholding Tax entry with the unrealized Withholding Tax amount. via Page 6788 “Withholding Tax Entries” TableRelation Table 6788 “Withholding Tax Entry” (Withholding Tax Entry); not editable
30 Wthldg. Tax Bus. Post. Group Code[20] Specifies the Withholding Tax Business Posting group code that was used when the entry was posted. via Page 6788 “Withholding Tax Entries” TableRelation Table 6784 “Wthldg. Tax Bus. Post. Group” (Wthldg. Tax Bus. Post. Group); not editable
31 Wthldg. Tax Prod. Post. Group Code[20] Specifies the Withholding Tax Product Posting group code that was used when the entry was posted. via Page 6788 “Withholding Tax Entries” TableRelation Table 6785 “Wthldg. Tax Prod. Post. Group” (Wthldg. Tax Prod. Post. Group); not editable
32 Base (LCY) Decimal Specifies the Base Amount in LCY of the Withholding Tax, which is realized during this transaction. via Page 6788 “Withholding Tax Entries” not editable
33 Amount (LCY) Decimal Specifies the Withholding Tax Amount in LCY of the Withholding Tax, which is realized during this transaction. via Page 6788 “Withholding Tax Entries” not editable
34 Unrealized Amount (LCY) Decimal Specifies the withholding tax amount that will be realized during payment as calculated during the posting of the document. via Page 6788 “Withholding Tax Entries” not editable
35 Unrealized Base (LCY) Decimal Specifies the base amount in your currency that the Withholding Tax Amount was calculated from. via Page 6788 “Withholding Tax Entries” not editable
36 Withholding Tax % Decimal Specifies the withholding tax percent used for calculations during this transaction. via Page 6788 “Withholding Tax Entries” not editable
37 Rem Unrealized Amount (LCY) Decimal Specifies the Remaining Unrealized Amount in LCY left for a particular transaction is stored. via Page 6788 “Withholding Tax Entries” not editable
38 Rem Unrealized Base (LCY) Decimal Specifies the Remaining Unrealized Base in LCY left for a particular transaction is stored. via Page 6788 “Withholding Tax Entries” not editable
39 Withholding Tax Difference Decimal Specifies the difference between the Unrealized and Realized Withholding Tax. via Page 6788 “Withholding Tax Entries” not editable
41 Ship-to/Order Address Code Code[10] Specifies the address of the entry. via Page 6788 “Withholding Tax Entries” TableRelation Table 222 “Ship-to Address”, Table 224 “Order Address” (if (“Transaction Type” = const(Purchase)) “Order Address”.Code where(“Vendor No.” = field(“Bill-to/Pay-to No.”)) else if (“Transaction Type” = const(Sale)) “Ship-to Address”.Code where(“Customer No.” = field(“Bill-to/Pay-to No.”)))
42 Document Date Date Specifies the Document Date from the applied Withholding Tax Entry is stored for applying the Withholding Tax Entry table. via Page 6788 “Withholding Tax Entries” not editable
44 Actual Vendor No. Code[20] Specifies the Actual Vendor No. from which Invoices or Journals is copied. via Page 6788 “Withholding Tax Entries”
45 Wthldg. Tax Certificate No. Code[20] Specifies an auto-generated no. based on the no. series. via Page 6788 “Withholding Tax Entries”
47 Void Check Boolean Specifies that this field is marked internally if the transactions have been reversed due to voiding of checks. via Page 6788 “Withholding Tax Entries”
48 Original Document No. Code[20] Specifies the original document no. from the Invoice or Journal is assigned to this field. via Page 6788 “Withholding Tax Entries”
49 Void Payment Entry No. Integer Specifies the entry no. of the Withholding Tax Entry, which has been voided, with this transaction. via Page 6788 “Withholding Tax Entries”
50 Wthldg. Tax Report Line No Code[20] Specifies an auto-generated field based on the no. series defined in the Withholding Tax Posting Setup for a particular Withholding Tax Report Type. via Page 6788 “Withholding Tax Entries”
52 Applies-to Doc. Type Enum “Gen. Journal Document Type” — enum Enum 6 “Gen. Journal Document Type”
53 Applies-to Doc. No. Code[20] —
54 Applies-to Entry No. Integer —
55 Withholding Tax Revenue Type Code[10] — TableRelation Table 6787 “Withholding Tax Revenue Types” (“Withholding Tax Revenue Types”.Code)
56 Settled Boolean —
57 Payment Amount Decimal —
58 Reversed by Entry No. Integer — TableRelation Table 6788 “Withholding Tax Entry” (“Withholding Tax Entry”.“Entry No.”)
59 Reversed Entry No. Integer — TableRelation Table 6788 “Withholding Tax Entry” (“Withholding Tax Entry”.“Entry No.”)
60 Reversed Boolean —
61 Rem Realized Amount Decimal — not editable
62 Rem Realized Amount (LCY) Decimal — not editable
63 Rem Realized Base Decimal — not editable
64 Rem Realized Base (LCY) Decimal — not editable
65 Prepayment Boolean —
100 Party Type Enum “Withholding Party Type” Specifies the type of party (Vendor, Customer, or Employee) that this withholding tax entry relates to. via Page 6788 “Withholding Tax Entries” enum Enum 6784 “Withholding Party Type”; not editable
101 Employee No. Code[20] Specifies the employee number if this withholding tax entry originated from an employee transaction. via Page 6788 “Withholding Tax Entries” TableRelation Table 5200 “Employee” (if (“Party Type” = const(Employee)) Employee); not editable
102 Empl. Ledger Entry No. Integer Specifies the employee ledger entry number that this withholding tax entry is linked to. via Page 6788 “Withholding Tax Entries” not editable
103 Calculation Base Enum “Withholding Calculation Base” Specifies whether the withholding tax was calculated on the gross or net (gross-up) base amount. via Page 6788 “Withholding Tax Entries” enum Enum 6785 “Withholding Calculation Base”; not editable
104 Calculation Method Enum “Withholding Calculation Method” Specifies the calculation method used: Simple or Compound. via Page 6788 “Withholding Tax Entries” enum Enum 6786 “Withholding Calculation Method”; not editable
105 Component Order Integer Specifies the order in which this tax component was applied when using compound calculation. via Page 6788 “Withholding Tax Entries” not editable
106 Threshold Base Enum “Withholding Threshold Base” Specifies the threshold evaluation level: Record, Document, Category in Period, or Total in Period. via Page 6788 “Withholding Tax Entries” enum Enum 6787 “Withholding Threshold Base”; not editable
107 Threshold Evaluated Boolean Specifies whether the threshold was evaluated for this entry. via Page 6788 “Withholding Tax Entries” not editable
108 Threshold Exceeded Boolean Specifies whether the threshold was exceeded for this entry. via Page 6788 “Withholding Tax Entries” not editable
109 Period Start Date Date — not editable
110 Period End Date Date — not editable
111 WHT Group Code Code[20] Specifies the withholding tax group code if a multi-component tax group was used. via Page 6788 “Withholding Tax Entries” TableRelation Table 6792 “Withholding Tax Group” (Withholding Tax Group); not editable
112 Taxable Base Amount Decimal Specifies the effective taxable base amount after threshold evaluation. This may differ from the original base when thresholds apply. via Page 6788 “Withholding Tax Entries” not editable
28101 Pymt. Disc. Diff. Base Decimal —
28102 Pymt. Disc. Diff. Amount Decimal —

Keys

  • Key1: Entry No. (clustered)
  • Key2: Transaction Type, Closed, Withholding Tax Difference, Amount (LCY), Base (LCY), Posting Date
  • Key3: Transaction Type, Country/Region Code, Withholding Tax Difference, Posting Date
  • Key4: Document No., Posting Date
  • Key5: Transaction No.
  • Key6: Amount (LCY), Unrealized Amount (LCY), Unrealized Base (LCY), Base (LCY), Posting Date
  • Key7: Document Type, Document No.
  • Key8: Transaction Type, Document No., Document Type, Bill-to/Pay-to No., Closed
  • Key9: Applies-to Entry No.
  • Key10: Bill-to/Pay-to No., Original Document No., Withholding Tax Revenue Type
  • Key11: Bill-to/Pay-to No., Withholding Tax Revenue Type, Wthldg. Tax Prod. Post. Group
  • Key12: Bill-to/Pay-to No., Wthldg. Tax Bus. Post. Group, Withholding Tax Revenue Type
  • Key13: Document Type, Transaction Type, Settled, Wthldg. Tax Bus. Post. Group, Wthldg. Tax Prod. Post. Group, Posting Date
  • Key14: Posting Date, Settled, Wthldg. Tax Certificate No.
  • Key15: Posting Date, Wthldg. Tax Certificate No.
  • Key16: Document Type, Transaction Type, Bill-to/Pay-to No., Transaction No.
  • Key17: Transaction Type, Bill-to/Pay-to No., Transaction No.
  • Key18: Withholding Tax Revenue Type, Posting Date
  • Key19: Transaction Type, Bill-to/Pay-to No.

Trigger event subscribers

Procedures

  • GetCurrencyCode(): Code[10]
  • GetLastEntryNo(): Integer

Triggers

OnInsert

Relations

Referenced by

16 fields in 6 objects relate to this table (TableRelation or CalcFormula).

Pages and codeunits on this table

Calls

From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.

Recent changes

Ask your agent

Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. 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: "Withholding Tax Entry"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

Evidence 1 sources