Table 28044 "WHT Entry" (NZ)

NZ country layer · Microsoft.Finance.WithholdingTax · BC29-30 · source at ea08af5e · facts from BC29

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

Properties

Property	Value
Caption	WHT 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	—	not editable
2	Gen. Bus. Posting Group	Code[20]	—	TableRelation Gen. Business Posting Group; not editable
3	Gen. Prod. Posting Group	Code[20]	—	TableRelation Gen. Product Posting Group; not editable
4	Posting Date	Date	—	not editable
5	Document No.	Code[20]	—	not editable
6	Document Type	Enum “Gen. Journal Document Type”	—	enum Enum 6 “Gen. Journal Document Type”; not editable
8	Base	Decimal	—	not editable
9	Amount	Decimal	—	not editable
10	WHT Calculation Type	Option	—	OptionCaption: Normal WHT,Full WHT; not editable
11	Currency Code	Code[10]	—
12	Bill-to/Pay-to No.	Code[20]	—	TableRelation if (“Transaction Type” = const(Purchase)) Vendor else if (“Transaction Type” = const(Sale)) Customer
14	User ID	Code[50]	—	not editable; DataClassification EndUserIdentifiableInformation
15	Source Code	Code[10]	—	TableRelation Source Code; not editable
16	Reason Code	Code[10]	—	TableRelation Reason Code; not editable
17	Closed by Entry No.	Integer	—	TableRelation WHT Entry; not editable
18	Closed	Boolean	—	not editable
19	Country/Region Code	Code[10]	—	TableRelation Country/Region
21	Transaction No.	Integer	—	not editable
22	Unrealized Amount	Decimal	—	not editable
23	Unrealized Base	Decimal	—	not editable
24	Remaining Unrealized Amount	Decimal	—	not editable
25	Remaining Unrealized Base	Decimal	—	not editable
26	External Document No.	Code[35]	—	not editable
27	Transaction Type	Option	—	OptionCaption: ,Purchase,Sale,Settlement
28	No. Series	Code[20]	—	TableRelation No. Series; not editable
29	Unrealized WHT Entry No.	Integer	—	TableRelation WHT Entry; not editable
30	WHT Bus. Posting Group	Code[20]	—	TableRelation WHT Business Posting Group; not editable
31	WHT Prod. Posting Group	Code[20]	—	TableRelation WHT Product Posting Group; not editable
32	Base (LCY)	Decimal	—	not editable
33	Amount (LCY)	Decimal	—	not editable
34	Unrealized Amount (LCY)	Decimal	—	not editable
35	Unrealized Base (LCY)	Decimal	—	not editable
36	WHT %	Decimal	—	not editable
37	Rem Unrealized Amount (LCY)	Decimal	—	not editable
38	Rem Unrealized Base (LCY)	Decimal	—	not editable
39	WHT Difference	Decimal	—	not editable
41	Ship-to/Order Address Code	Code[10]	—	TableRelation 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	—	not editable
44	Actual Vendor No.	Code[20]	—
45	WHT Certificate No.	Code[20]	—
47	Void Check	Boolean	—
48	Original Document No.	Code[20]	—
49	Void Payment Entry No.	Integer	—
50	WHT Report Line No	Code[20]	—
51	WHT Report	Option	—	OptionCaption: ,Por Ngor Dor 1,Por Ngor Dor 2,Por Ngor Dor 3,Por Ngor Dor 53,Por Ngor Dor 54
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	WHT Revenue Type	Code[10]	—	TableRelation “WHT Revenue Types”.Code
56	Settled	Boolean	—
57	Payment Amount	Decimal	—
58	Reversed by Entry No.	Integer	—	TableRelation “WHT Entry”.“Entry No.”
59	Reversed Entry No.	Integer	—	TableRelation “WHT 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	—
28101	Pymt. Disc. Diff. Base	Decimal	—
28102	Pymt. Disc. Diff. Amount	Decimal	—

Keys

Key1: Entry No. (clustered)
Key2: Transaction Type, Closed, WHT Difference, Amount (LCY), Base (LCY), Posting Date
Key3: Transaction Type, Country/Region Code, WHT 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., WHT Revenue Type
Key11: Bill-to/Pay-to No., WHT Revenue Type, WHT Prod. Posting Group
Key12: Bill-to/Pay-to No., WHT Bus. Posting Group, WHT Revenue Type
Key13: Document Type, Transaction Type, Settled, WHT Bus. Posting Group, WHT Prod. Posting Group, Posting Date
Key14: Posting Date, Settled, WHT Certificate No.
Key15: Posting Date, WHT 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: WHT Revenue Type, Posting Date
Key19: Transaction Type, Bill-to/Pay-to No.

Procedures

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

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: "WHT Entry"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

A NZ country object, not part of W1: the default corpus does not have it; bcatlas_list_countries shows which countries the atlas has.