tableFinanceofficial - Microsoftderived - from the source, no model text

Table 18474 "Sub. Comp. Rcpt. Header" (IN)

IN country layer · Microsoft.Finance.GST.Subcontracting

Across versions

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

IN country layer · Microsoft.Finance.GST.Subcontracting · BC29-30 · source at ea08af5e · facts from BC29

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

Properties

Property Value
Caption Sub. Comp. Rcpt. Header

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
2 Buy-from Vendor No. Code[20] — TableRelation Vendor; NotBlank; DataClassification EndUserIdentifiableInformation
3 No. Code[20] — DataClassification EndUserIdentifiableInformation
19 Order Date Date — DataClassification EndUserIdentifiableInformation
20 Posting Date Date — DataClassification EndUserIdentifiableInformation
28 Location Code Code[10] — TableRelation Location where(“Use As In-Transit” = const(false)); DataClassification EndUserIdentifiableInformation
44 Order No. Code[20] — DataClassification EndUserIdentifiableInformation
66 Vendor Order No. Code[35] — DataClassification EndUserIdentifiableInformation
67 Vendor Shipment No. Code[20] — DataClassification EndUserIdentifiableInformation
74 Gen. Bus. Posting Group Code[20] — TableRelation Gen. Business Posting Group; DataClassification EndUserIdentifiableInformation
79 Buy-from Vendor Name Text[100] — DataClassification EndUserIdentifiableInformation
80 Buy-from Vendor Name 2 Text[50] — DataClassification EndUserIdentifiableInformation
81 Buy-from Address Text[100] — DataClassification EndUserIdentifiableInformation
82 Buy-from Address 2 Text[50] — DataClassification EndUserIdentifiableInformation
83 Buy-from City Text[30] — TableRelation if (“Buy-from Country/Region Code” = const()) “Post Code”.City else if (“Buy-from Country/Region Code” = filter(<> ‘’)) “Post Code”.City where(“Country/Region Code” = field(“Buy-from Country/Region Code”)); DataClassification EndUserIdentifiableInformation
84 Buy-from Contact Text[100] — DataClassification EndUserIdentifiableInformation
88 Buy-from Post Code Code[20] — TableRelation if (“Buy-from Country/Region Code” = const()) “Post Code” else if (“Buy-from Country/Region Code” = filter(<> ‘’)) “Post Code” where(“Country/Region Code” = field(“Buy-from Country/Region Code”)); DataClassification EndUserIdentifiableInformation
89 Buy-from County Text[30] — DataClassification EndUserIdentifiableInformation
90 Buy-from Country/Region Code Code[10] — TableRelation Country/Region; DataClassification EndUserIdentifiableInformation
95 Order Address Code Code[10] — TableRelation “Order Address”.Code where(“Vendor No.” = field(“Buy-from Vendor No.”)); DataClassification EndUserIdentifiableInformation
99 Document Date Date — DataClassification EndUserIdentifiableInformation
101 Area Code[10] — TableRelation Area; DataClassification EndUserIdentifiableInformation
102 Transaction Specification Code[10] — TableRelation Transaction Specification; DataClassification EndUserIdentifiableInformation
104 Payment Method Code Code[10] — TableRelation Payment Method; DataClassification EndUserIdentifiableInformation
109 No. Series Code[20] — TableRelation No. Series; not editable; DataClassification EndUserIdentifiableInformation
110 Order No. Series Code[10] — TableRelation No. Series; DataClassification EndUserIdentifiableInformation
112 User ID Code[50] — TableRelation User.“User Name”; DataClassification EndUserIdentifiableInformation
113 Source Code Code[10] — TableRelation Source Code; DataClassification EndUserIdentifiableInformation
114 Tax Registration No. Text[20] — DataClassification EndUserIdentifiableInformation
117 Prod. Order No. Code[20] — DataClassification EndUserIdentifiableInformation
118 Prod. Order Line No. Integer — DataClassification EndUserIdentifiableInformation
119 Subcontracting Order Line No. Integer — DataClassification EndUserIdentifiableInformation
120 VAT Business Posting Group Code[20] — TableRelation VAT Business Posting Group; not editable; DataClassification EndUserIdentifiableInformation
121 Vendor Shipment Date Date — DataClassification EndUserIdentifiableInformation
480 Dimension Set ID Integer — TableRelation Dimension Set Entry; not editable; DataClassification EndUserIdentifiableInformation

Keys

  • Key1: No. (clustered)
  • Key2: Order No.
  • Key3: Posting Date

Procedures

  • Navigate()
  • ShowDimensions()

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: "Sub. Comp. Rcpt. Header"), 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.

Evidence 1 sources