Table 222 "Ship-to Address"
Base Application · Microsoft.Sales.Customer
Across versions
- BC23present
- BC241 fields added, 1 fields changed
- BC251 fields removed
- BC2622 fields changed
- BC271 fields changed
- BC281 events added
- BC29-30unchanged
Neighbourhood 67 connected objects and pages
Base Application · Microsoft.Sales.Customer · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 300 “Ship-to Address” (2 Learn pages), Page 301 “Ship-to Address List” (2).
Properties
| Property | Value |
|---|---|
| Caption | Ship-to 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 | Customer No. Δ BC26 | Code[20] | Specifies the customer number. | TableRelation Table 18 “Customer”; NotBlank |
| 2 | Code Δ BC26 | Code[10] | Specifies a ship-to address code. | NotBlank |
| 3 | Name Δ BC26 | Text[100] | Specifies the name associated with the ship-to address. | |
| 4 | Name 2 Δ BC26 | Text[50] | Specifies an additional part of the name. | |
| 5 | Address Δ BC26 | Text[100] | Specifies the ship-to address. | |
| 6 | Address 2 Δ BC26 | Text[50] | Specifies additional address information. | |
| 7 | City Δ BC26 | Text[30] | Specifies the city the items are being shipped to. | 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 Δ BC26 | Text[100] | Specifies the name of the person you contact about orders shipped to this address. | |
| 9 | Phone No. Δ BC26 | Text[30] | Specifies the recipient’s telephone number. | |
| 10 | Telex No. | Text[30] | — | |
| 29 | Salesperson Code + BC24 Δ BC26 | Code[20] | Specifies a code for the salesperson who normally handles this customer’s recipient. | TableRelation Table 13 “Salesperson/Purchaser” (“Salesperson/Purchaser” where(Blocked = const(false))) |
| 30 | Shipment Method Code Δ BC26 | Code[10] | Specifies a code for the shipment method to be used for the recipient. | TableRelation Table 10 “Shipment Method” (Shipment Method) |
| 31 | Shipping Agent Code Δ BC26 | Code[10] | Specifies the code for the shipping agent who is transporting the items. | TableRelation Table 291 “Shipping Agent” (Shipping Agent) |
| 32 | Place of Export | Code[20] | — | |
| 35 | Country/Region Code Δ BC26 | Code[10] | Specifies the country/region of the address. | TableRelation Table 9 “Country/Region” (Country/Region) |
| 54 | Last Date Modified Δ BC26 | Date | Specifies when the ship-to address was last modified. | not editable |
| 83 | Location Code Δ BC26 | Code[10] | Specifies the location code to be used for the recipient. | TableRelation Table 14 “Location” (Location where(“Use As In-Transit” = const(false))) |
| 84 | Fax No. Δ BC26 | Text[30] | Specifies the recipient’s fax number. | |
| 85 | Telex Answer Back | Text[20] | — | |
| 90 | GLN Δ BC26 | Code[13] | Specifies the recipient’s GLN code. | |
| 91 | Post Code Δ BC26 | 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 Δ BC26 | Text[30] | Specifies the state, province, or county as a part of the address. | |
| 102 | E-Mail Δ BC26 | Text[80] | Specifies the recipient’s email address. | |
| 103 | Home Page Δ BC24 Δ BC26 Δ BC27 | Text[255] | Specifies the recipient’s web site. | |
| 108 | Tax Area Code | Code[20] | — | TableRelation Table 318 “Tax Area” (Tax Area) |
| 109 | Tax Liable | Boolean | — | |
| 5792 | Shipping Agent Service Code Δ BC26 | Code[10] | Specifies the code for the service, such as a one-day delivery, that is offered by the shipping agent. | TableRelation Table 5790 “Shipping Agent Services” (“Shipping Agent Services”.Code where(“Shipping Agent Code” = field(“Shipping Agent Code”))) |
Keys
- Key1: Customer No., Code (clustered)
Events published
OnAfterLookupPostCode(var ShipToAddress: Record "Ship-to Address"; var PostCodeRec: Record "Post Code"; xShipToAddress: Record "Ship-to Address")(integration): Raised after looking up the post code.OnAfterLookupCity(var ShipToAddress: Record "Ship-to Address"; var PostCodeRec: Record "Post Code"; xShipToAddress: Record "Ship-to Address")(integration): Raised after looking up the city.OnAfterValidateCity(var ShipToAddress: Record "Ship-to Address"; var PostCode: Record "Post Code")(integration): Raised after validating the city field.OnAfterValidatePostCode(var ShipToAddress: Record "Ship-to Address"; var PostCode: Record "Post Code")(integration): Raised after validating the post code field.OnBeforeLookupCity(var ShipToAddress: Record "Ship-to Address"; var PostCodeRec: Record "Post Code")(integration): Raised before looking up the city.OnBeforeLookupPostCode(var ShipToAddress: Record "Ship-to Address"; var PostCodeRec: Record "Post Code")(integration): Raised before looking up the post code.OnBeforeValidateCity(var ShipToAddress: Record "Ship-to Address"; var PostCodeRec: Record "Post Code"; CurrentFieldNo: Integer; var IsHandled: Boolean)(integration): Raised before validating the city field.OnBeforeValidateEmail(var ShiptoAddress: Record "Ship-to Address"; xShiptoAddress: Record "Ship-to Address"; var IsHandled: Boolean)(integration): Raised before validating the email field.OnBeforeValidatePostCode(var ShipToAddress: Record "Ship-to Address"; var PostCodeRec: Record "Post Code"; CurrentFieldNo: Integer; var IsHandled: Boolean)(integration): Raised before validating the post code field.OnBeforeGetFilterCustNo(var ShipToAddress: Record "Ship-to Address")+ BC28 (integration): Raised before retrieving the filtered customer number.
Procedures
Caption(): Text: Generates a caption text for the ship-to address including customer and address information.DisplayMap(): Displays the ship-to address on an online map service.GetFilterCustNo(): Code[20]: Gets the customer number from the current filter if a single value is specified.
Plus 2 local procedures.
Triggers
OnInsert, OnDelete, OnModify, OnRename
Relations
- lookup page Page 301 “Ship-to Address List”
- Shipment Method Code: TableRelation Table 10 “Shipment Method”
- Salesperson Code: TableRelation Table 13 “Salesperson/Purchaser”
- Location Code: TableRelation Table 14 “Location”
- Customer No.: TableRelation Table 18 “Customer”
- City: TableRelation Table 225 “Post Code” (conditional)
- Post Code: TableRelation Table 225 “Post Code” (conditional)
- Shipping Agent Code: TableRelation Table 291 “Shipping Agent”
- Tax Area Code: TableRelation Table 318 “Tax Area”
- Shipping Agent Service Code: TableRelation Table 5790 “Shipping Agent Services”
- Country/Region Code: TableRelation Table 9 “Country/Region”
Referenced by
71 fields in 50 objects relate to this table (TableRelation or CalcFormula).
- Table 5940 “Service Item”: Ship-to Address, Ship-to Address 2, Ship-to City, Ship-to Contact, Ship-to Country/Region Code, Ship-to County, Ship-to E-Mail, Ship-to Name, Ship-to Name 2, Ship-to Phone No., Ship-to Post Code, Ship-to Code
- Table 5965 “Service Contract Header”: Ship-to Address, Ship-to Address 2, Ship-to City, Ship-to Country/Region Code, Ship-to County, Ship-to Name, Ship-to Name 2, Ship-to Phone No., Ship-to Post Code, Ship-to Code
- Table 18 “Customer”: No. of Ship-to Addresses, Ship-to Code
- Table 1001 “Job Task”: Ship-to Code
- Table 110 “Sales Shipment Header”: Ship-to Code
- Table 112 “Sales Invoice Header”: Ship-to Code
- Table 114 “Sales Cr.Memo Header”: Ship-to Code
- Table 120 “Purch. Rcpt. Header”: Ship-to Code
- Table 122 “Purch. Inv. Header”: Ship-to Code
- Table 124 “Purch. Cr. Memo Hdr.”: Ship-to Code
- Table 1571 “VAT Entry Posting Preview”: Ship-to/Order Address Code
- Table 167 “Job”: Ship-to Code
- Table 181 “Posted Gen. Journal Line”: Ship-to/Order Address Code
- Table 246 “Requisition Line”: Ship-to Code
- Table 254 “VAT Entry”: Ship-to/Order Address Code
- Table 36 “Sales Header”: Ship-to Code
- Table 38 “Purchase Header”: Ship-to Code
- Table 5107 “Sales Header Archive”: Ship-to Code
- Table 5135 “Job Archive”: Ship-to Code
- Table 5136 “Job Task Archive”: Ship-to Code
- Table 5900 “Service Header”: Ship-to Code
- Table 5901 “Service Item Line”: Ship-to Code
- Table 5902 “Service Line”: Ship-to Code
- Table 5907 “Service Ledger Entry”: Ship-to Code
- Table 5908 “Warranty Ledger Entry”: Ship-to Code
- Table 5964 “Service Contract Line”: Ship-to Code
- Table 5969 “Contract Gain/Loss Entry”: Ship-to Code
- Table 5970 “Filed Service Contract Header”: Ship-to Code
- Table 5971 “Filed Contract Line”: Ship-to Code
- Table 5989 “Service Shipment Item Line”: Ship-to Code
- Table 5990 “Service Shipment Header”: Ship-to Code
- Table 5991 “Service Shipment Line”: Ship-to Code
- Table 5992 “Service Invoice Header”: Ship-to Code
- Table 5993 “Service Invoice Line”: Ship-to Code
- Table 5994 “Service Cr.Memo Header”: Ship-to Code
- Table 5995 “Service Cr.Memo Line”: Ship-to Code
- Table 6010 “Service Header Archive”: Ship-to Code
- Table 6011 “Service Item Line Archive”: Ship-to Code
- Table 6012 “Service Line Archive”: Ship-to Code
- Table 6650 “Return Shipment Header”: Ship-to Code
- Table 6660 “Return Receipt Header”: Ship-to 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 8008 “Imported Subscription Header”: Ship-to Code
- Table 8010 “Imported Cust. Sub. Contract”: Ship-to Code
- Table 8052 “Customer Subscription Contract”: Ship-to Code
- Table 8057 “Subscription Header”: Ship-to Code
- Table 81 “Gen. Journal Line”: Ship-to/Order Address Code
- Table extension 6450 “Serv. Customer”: Ship-to Filter
Pages and codeunits on this table
- Page 300 “Ship-to Address” (source table)
- Page 301 “Ship-to Address List” (source table)
Extended by
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) - Codeunit 9520 “Mail Management” (1 call:
ValidateEmail → ValidateEmailAddressField)
Recent changes
- 2026-07-15 #9397 [main] Ship to address Var/protected var fix (main, BC30, fix)
Countries that replace it
Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).
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: "Ship-to Address"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.