Table 10038 "IRS 1099 Form Doc. Line Detail" (US)
US country layer · Microsoft.Finance.VAT.Reporting
Across versions
- BC23-28not present
- BC29-30present
US country layer · Microsoft.Finance.VAT.Reporting · captioned “IRS 1099 Form Document Line Detail” · BC29-30 · source at ea08af5e · facts from BC29
An object of the US localization, not part of W1.
Properties
| Property | Value |
|---|---|
| Caption | IRS 1099 Form Document Line Detail |
| DataClassification | CustomerContent |
| LookupPageId | IRS 1099 Form Doc Line Details |
| DrillDownPageId | IRS 1099 Form Doc Line Details |
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 | Document ID | Integer | — | |
| 5 | Line No. | Integer | — | |
| 6 | Vendor Ledger Entry No. | Integer | — | |
| 100 | Document Type | Enum “Gen. Journal Document Type” | — | FlowField: lookup(“Vendor Ledger Entry”.“Document Type” where(“Entry No.” = field(“Vendor Ledger Entry No.”))); enum Enum 6 “Gen. Journal Document Type”; not editable |
| 101 | Document No. | Code[20] | — | FlowField: lookup(“Vendor Ledger Entry”.“Document No.” where(“Entry No.” = field(“Vendor Ledger Entry No.”))); not editable |
| 102 | Description | Text[100] | — | FlowField: lookup(“Vendor Ledger Entry”.Description where(“Entry No.” = field(“Vendor Ledger Entry No.”))); not editable |
| 110 | Currency Code | Code[10] | — | FlowField: lookup(“Vendor Ledger Entry”.“Currency Code” where(“Entry No.” = field(“Vendor Ledger Entry No.”))); not editable |
| 200 | IRS 1099 Reporting Amount | Decimal | — | FlowField: lookup(“Vendor Ledger Entry”.“IRS 1099 Reporting Amount” where(“Entry No.” = field(“Vendor Ledger Entry No.”))); not editable |
| 201 | Calculated Amount | Decimal | — | not editable |
Keys
- PK: Document ID, Line No., Vendor Ledger Entry No. (clustered)
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: "IRS 1099 Form Doc. Line Detail"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.
A US country object, not part of W1: the default corpus does not have it; bcatlas_list_countries shows which countries the atlas has.