Table 224 "Order Address"
Base Application · Microsoft.Purchases.Vendor
Across versions
- BC23present
- BC241 fields changed
- BC25-26unchanged
- BC274 events added, 1 fields changed
- BC2815 fields changed
- BC29-30unchanged
Neighbourhood 22 connected objects and pages
Base Application · Microsoft.Purchases.Vendor · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 368 “Order Address” (1 Learn page), Page 369 “Order Address List” (1).
Properties
| Property | Value |
|---|---|
| Caption | Order Address |
| 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 | Vendor No. | Code[20] | — | TableRelation Table 23 “Vendor”; NotBlank |
| 2 | Code Δ BC28 | Code[10] | Specifies an order-from address code. | NotBlank |
| 3 | Name Δ BC28 | Text[100] | Specifies the name of the company located at the address. | |
| 4 | Name 2 Δ BC28 | Text[50] | Specifies an additional part of the name. | |
| 5 | Address Δ BC28 | Text[100] | Specifies the order address. | |
| 6 | Address 2 Δ BC28 | Text[50] | Specifies additional address information. | |
| 7 | City Δ BC28 | Text[30] | Specifies the city of the order address. | TableRelation Table 225 “Post Code” (if (“Country/Region Code” = const(‘’)) “Post Code”.City else if (“Country/Region Code” = filter(<> ‘’)) “Post Code”.City where(“Country/Region Code” = field(“Country/Region Code”))) |
| 8 | Contact Δ BC28 | Text[100] | Specifies the name of the person you regularly contact when you do business with this vendor at this address. | |
| 9 | Phone No. Δ BC28 | Text[30] | Specifies the telephone number that is associated with the order address. | |
| 10 | Telex No. | Text[30] | — | |
| 35 | Country/Region Code Δ BC28 | Code[10] | Specifies the country/region of the address. | TableRelation Table 9 “Country/Region” (Country/Region) |
| 54 | Last Date Modified Δ BC28 | Date | Specifies when this order address was last modified. | not editable |
| 84 | Fax No. Δ BC28 | Text[30] | Specifies the fax number associated with the address. | |
| 85 | Telex Answer Back | Text[20] | — | |
| 91 | Post Code Δ BC28 | Code[20] | Specifies the postal code. | TableRelation Table 225 “Post Code” (if (“Country/Region Code” = const(‘’)) “Post Code” else if (“Country/Region Code” = filter(<> ‘’)) “Post Code” where(“Country/Region Code” = field(“Country/Region Code”))) |
| 92 | County Δ BC28 | Text[30] | Specifies the county of the address. | |
| 102 | E-Mail Δ BC28 | Text[80] | Specifies the email address associated with the order address. | |
| 103 | Home Page Δ BC24 Δ BC27 Δ BC28 | Text[255] | Specifies the recipient’s web site. |
Keys
- Key1: Vendor No., Code (clustered)
Events published
OnAfterLookupPostCode(var OrderAddress: Record "Order Address"; var PostCode: Record "Post Code"; FieldNo: Integer)(integration)OnBeforeValidateCity(var OrderAddress: Record "Order Address"; var PostCode: Record "Post Code"; CurrentFieldNo: Integer; var IsHandled: Boolean)(integration)OnBeforeValidatePostCode(var OrderAddress: Record "Order Address"; var PostCode: Record "Post Code"; CurrentFieldNo: Integer; var IsHandled: Boolean)(integration)OnBeforeLookupCity(var OrderAddress: Record "Order Address"; var PostCode: Record "Post Code")+ BC27 (integration)OnAfterValidateCity(var OrderAddress: Record "Order Address"; var PostCode: Record "Post Code")+ BC27 (integration)OnBeforeLookupPostCode(var OrderAddress: Record "Order Address"; var PostCode: Record "Post Code")+ BC27 (integration)OnAfterValidatePostCode(var OrderAddress: Record "Order Address"; var PostCode: Record "Post Code")+ BC27 (integration)
Procedures
Caption(): TextDisplayMap()
Plus 1 local procedures.
Triggers
OnInsert, OnModify, OnRename
Relations
- lookup page Page 369 “Order Address List”
- City: TableRelation Table 225 “Post Code” (conditional)
- Post Code: TableRelation Table 225 “Post Code” (conditional)
- Vendor No.: TableRelation Table 23 “Vendor”
- Country/Region Code: TableRelation Table 9 “Country/Region”
Referenced by
15 fields in 15 objects relate to this table (TableRelation or CalcFormula).
- Table 120 “Purch. Rcpt. Header”: Order Address Code
- Table 122 “Purch. Inv. Header”: Order Address Code
- Table 124 “Purch. Cr. Memo Hdr.”: Order Address Code
- Table 1571 “VAT Entry Posting Preview”: Ship-to/Order Address Code
- Table 181 “Posted Gen. Journal Line”: Ship-to/Order Address Code
- Table 23 “Vendor”: No. of Order Addresses
- Table 246 “Requisition Line”: Order Address Code
- Table 254 “VAT Entry”: Ship-to/Order Address Code
- Table 38 “Purchase Header”: Order Address Code
- Table 5109 “Purchase Header Archive”: Order Address Code
- Table 6650 “Return Shipment Header”: Order Address Code
- Table 6788 “Withholding Tax Entry”: Ship-to/Order Address Code
- Table 6790 “Temp Withholding Tax Entry”: Ship-to/Order Address Code
- Table 751 “Standard General Journal Line”: Ship-to/Order Address Code
- Table 81 “Gen. Journal Line”: Ship-to/Order Address Code
Pages and codeunits on this table
- Page 368 “Order Address” (source table)
- Page 369 “Order Address List” (source table)
Calls
From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.
- Codeunit 802 “Online Map Management” (1 call:
DisplayMap → MakeSelectionIfMapEnabled)
Ask your agent
Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. 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: "Order Address"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.