Table 6790 "Temp Withholding Tax Entry"
WithholdingTax · Microsoft.WithholdingTax
Across versions
- BC23-28not present
- BC29-30present
Neighbourhood 11 connected objects and pages
WithholdingTax · Microsoft.WithholdingTax · BC29-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| Caption | Temp 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 | — | not editable; DataClassification SystemMetadata |
| 2 | Gen. Bus. Posting Group | Code[20] | — | TableRelation Table 250 “Gen. Business Posting Group” (Gen. Business Posting Group); not editable; DataClassification SystemMetadata |
| 3 | Gen. Prod. Posting Group | Code[20] | — | TableRelation Table 251 “Gen. Product Posting Group” (Gen. Product Posting Group); not editable; DataClassification SystemMetadata |
| 4 | Posting Date | Date | — | not editable; DataClassification SystemMetadata |
| 5 | Document No. | Code[20] | — | not editable; DataClassification SystemMetadata |
| 6 | Document Type | Enum “Gen. Journal Document Type” | — | enum Enum 6 “Gen. Journal Document Type”; not editable; DataClassification SystemMetadata |
| 8 | Base | Decimal | — | not editable; DataClassification SystemMetadata |
| 9 | Amount | Decimal | — | not editable; DataClassification SystemMetadata |
| 10 | Withholding Tax Calc. Type | Option | Withholding Tax Calculation Type caption | OptionCaption: Normal Withholding Tax,Full Withholding Tax; not editable; DataClassification SystemMetadata |
| 11 | Currency Code | Code[10] | — | DataClassification SystemMetadata |
| 12 | Bill-to/Pay-to No. | Code[20] | — | TableRelation Table 18 “Customer”, Table 23 “Vendor” (if (“Transaction Type” = const(Purchase)) Vendor else if (“Transaction Type” = const(Sale)) Customer); DataClassification SystemMetadata |
| 14 | User ID | Code[50] | — | not editable; DataClassification EndUserIdentifiableInformation |
| 15 | Source Code | Code[10] | — | TableRelation Source Code; not editable; DataClassification SystemMetadata |
| 16 | Reason Code | Code[10] | — | TableRelation Reason Code; not editable; DataClassification SystemMetadata |
| 17 | Closed by Entry No. | Integer | — | TableRelation Table 6790 “Temp Withholding Tax Entry” (Temp Withholding Tax Entry); not editable; DataClassification SystemMetadata |
| 18 | Closed | Boolean | — | not editable; DataClassification SystemMetadata |
| 19 | Country/Region Code | Code[10] | — | TableRelation Table 9 “Country/Region” (Country/Region); DataClassification SystemMetadata |
| 21 | Transaction No. | Integer | — | not editable; DataClassification SystemMetadata |
| 22 | Unrealized Amount | Decimal | — | not editable; DataClassification SystemMetadata |
| 23 | Unrealized Base | Decimal | — | not editable; DataClassification SystemMetadata |
| 24 | Remaining Unrealized Amount | Decimal | — | not editable; DataClassification SystemMetadata |
| 25 | Remaining Unrealized Base | Decimal | — | not editable; DataClassification SystemMetadata |
| 26 | External Document No. | Code[35] | — | not editable; DataClassification SystemMetadata |
| 27 | Transaction Type | Option | — | OptionCaption: ,Purchase,Sale,Settlement; DataClassification SystemMetadata |
| 28 | No. Series | Code[20] | — | TableRelation No. Series; not editable; DataClassification SystemMetadata |
| 29 | Unreal. Wthldg. Tax Entry No. | Integer | Unrealized Withholding Tax Entry No. caption | TableRelation Table 6790 “Temp Withholding Tax Entry” (Temp Withholding Tax Entry); not editable; DataClassification SystemMetadata |
| 30 | Wthldg. Tax Bus. Post. Group | Code[20] | Withholding Tax Bus. Post. Group caption | TableRelation Table 6784 “Wthldg. Tax Bus. Post. Group” (Wthldg. Tax Bus. Post. Group); not editable; DataClassification SystemMetadata |
| 31 | Wthldg. Tax Prod. Post. Group | Code[20] | Withholding Tax Prod. Post. Group caption | TableRelation Table 6785 “Wthldg. Tax Prod. Post. Group” (Wthldg. Tax Prod. Post. Group); not editable; DataClassification SystemMetadata |
| 32 | Base (LCY) | Decimal | — | not editable; DataClassification SystemMetadata |
| 33 | Amount (LCY) | Decimal | — | not editable; DataClassification SystemMetadata |
| 34 | Unrealized Amount (LCY) | Decimal | — | not editable; DataClassification SystemMetadata |
| 35 | Unrealized Base (LCY) | Decimal | — | not editable; DataClassification SystemMetadata |
| 36 | Withholding Tax % | Decimal | — | not editable; DataClassification SystemMetadata |
| 37 | Rem Unrealized Amount (LCY) | Decimal | — | not editable; DataClassification SystemMetadata |
| 38 | Rem Unrealized Base (LCY) | Decimal | — | not editable; DataClassification SystemMetadata |
| 39 | Withholding Tax Difference | Decimal | — | not editable; DataClassification SystemMetadata |
| 41 | Ship-to/Order Address Code | Code[10] | — | 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.”))); DataClassification SystemMetadata |
| 42 | Document Date | Date | — | not editable; DataClassification SystemMetadata |
| 44 | Actual Vendor No. | Code[20] | Withholding Actual Vendor No. caption | |
| 45 | Wthldg. Tax Certificate No. | Code[20] | Withholding Tax Certificate No. caption | DataClassification SystemMetadata |
| 47 | Void Check | Boolean | — | DataClassification SystemMetadata |
| 48 | Original Document No. | Code[20] | — | DataClassification SystemMetadata |
| 49 | Void Payment Entry No. | Integer | — | DataClassification SystemMetadata |
| 50 | Wthldg. Tax Report Line No | Code[20] | Withholding Tax Report Line No caption | DataClassification SystemMetadata |
| 51 | Withholding Tax Report | Option | Withholding Report caption | OptionCaption: ,Por Ngor Dor 1,Por Ngor Dor 2,Por Ngor Dor 3,Por Ngor Dor 53,Por Ngor Dor 54; DataClassification SystemMetadata |
| 52 | Applies-to Doc. Type | Enum “Gen. Journal Document Type” | — | enum Enum 6 “Gen. Journal Document Type”; DataClassification SystemMetadata |
| 53 | Applies-to Doc. No. | Code[20] | — | DataClassification SystemMetadata |
| 54 | Applies-to Entry No. | Integer | — | DataClassification SystemMetadata |
| 55 | Withholding Tax Revenue Type | Code[10] | — | DataClassification SystemMetadata |
| 57 | Payment Amount | Decimal | — | DataClassification SystemMetadata |
| 58 | Reversed by Entry No. | Integer | — | TableRelation Table 6788 “Withholding Tax Entry” (“Withholding Tax Entry”.“Entry No.”); DataClassification SystemMetadata |
| 59 | Reversed Entry No. | Integer | — | TableRelation Table 6788 “Withholding Tax Entry” (“Withholding Tax Entry”.“Entry No.”); DataClassification SystemMetadata |
| 60 | Reversed | Boolean | — | DataClassification SystemMetadata |
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.
- 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
Procedures
GetCurrencyCode(): Code[10]
Relations
- lookup page Page 6788 “Withholding Tax Entries”
- Bill-to/Pay-to No.: TableRelation Table 18 “Customer” (conditional)
- Ship-to/Order Address Code: TableRelation Table 222 “Ship-to Address” (conditional)
- Ship-to/Order Address Code: TableRelation Table 224 “Order Address” (conditional)
- Bill-to/Pay-to No.: TableRelation Table 23 “Vendor” (conditional)
- Gen. Bus. Posting Group: TableRelation Table 250 “Gen. Business Posting Group”
- Gen. Prod. Posting Group: TableRelation Table 251 “Gen. Product Posting Group”
- Wthldg. Tax Bus. Post. Group: TableRelation Table 6784 “Wthldg. Tax Bus. Post. Group”
- Wthldg. Tax Prod. Post. Group: TableRelation Table 6785 “Wthldg. Tax Prod. Post. Group”
- Reversed by Entry No.: TableRelation Table 6788 “Withholding Tax Entry”
- Reversed Entry No.: TableRelation Table 6788 “Withholding Tax Entry”
- Closed by Entry No.: TableRelation Table 6790 “Temp Withholding Tax Entry”
- Unreal. Wthldg. Tax Entry No.: TableRelation Table 6790 “Temp Withholding Tax Entry”
- Country/Region Code: TableRelation Table 9 “Country/Region”
Referenced by
2 fields in 1 objects relate to this table (TableRelation or CalcFormula).
- Table 6790 “Temp Withholding Tax Entry”: Closed by Entry No., Unreal. Wthldg. Tax Entry No.
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: "Temp Withholding Tax Entry"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.