Table 18474 "Sub. Comp. Rcpt. Header" (IN)
IN country layer · Microsoft.Finance.GST.Subcontracting
Across versions
- BC23-28not present
- 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
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.