tableSales & Receivablesofficial - Microsoftderived - from the source, no model text

Table 110 "Sales Shipment Header"

Base Application · Microsoft.Sales.History

Across versions

  1. BC23present
  2. BC244 procedures added, 2 fields added
  3. BC251 fields added
  4. BC26unchanged
  5. BC273 fields changed
  6. BC2854 fields changed, 3 procedures added
  7. BC29-30unchanged

Neighbourhood 69 connected objects and pages

Table 225 "Post Code" (relates to, 6 links)Post CodeTable 9 "Country/Region" (relates to, 4 links)Country/RegionTable 18 "Customer" (relates to, 2 links)Table 270 "Bank Account" (relates to, 2 links)Table 308 "No. Series" (relates to, 2 links)No. SeriesTable 349 "Dimension Value" (relates to, 2 links)Dimension ValueTable 5050 "Contact" (relates to, 2 links)ContactTable 10 "Shipment Method" (relates to)Shipment MethodTable 13 "Salesperson/Purchaser" (relates to)Table 14 "Location" (relates to)Table 15 "G/L Account" (relates to)Table 222 "Ship-to Address" (relates to)Table 230 "Source Code" (relates to)Table 231 "Reason Code" (relates to)Table 250 "Gen. Business Posting Group" (relates to)Page 142 "Posted Sales Shipments" (pages and codeunits on it, 3 links)Posted Sales ShipmentsCodeunit 314 "Sales Shpt.-Printed" (pages and codeunits on it)Codeunit 391 "Shipment Header - Edit" (pages and codeunits on it)Codeunit 6130 "E-Doc. Shipment Export To XML" (pages and codeunits on it)Page 130 "Posted Sales Shipment" (pages and codeunits on it)Page 1350 "Posted Sales Shipment - Update" (pages and codeunits on it)Page 30062 "APIV2 - Sales Shipments" (pages and codeunits on it)Page 396 "Sales Shipment Statistics" (pages and codeunits on it)Table extension 30106 "Shpfy Sales Shipment Header" (extended by)Codeunit 452 "Report Distribution Management" (calls, 3 links)Report Distribution ManagementCodeunit 10 "Type Helper" (calls, 2 links)Type HelperCodeunit 363 "PostSales-Delete" (calls, 2 links)PostSales-DeleteCodeunit 1535 "Approvals Mgmt." (calls)Codeunit 408 "DimensionManagement" (calls)Codeunit 5700 "User Setup Management" (calls)Table 111 "Sales Shipment Line" (referenced by, 2 links)Sales Shipment LineTable 18 "Customer" (referenced by, 2 links)CustomerTable 30100 "Shpfy Cue" (referenced by, 2 links)Shpfy CueTable 36 "Sales Header" (referenced by, 2 links)Sales HeaderEdit posted sales and purchase documents (Learn pages)GET salesShipments (Learn pages)How to work with VAT on sales and purchases (Learn pages)Posting sales documents (Learn pages)salesShipment resource type (Learn pages)Set Up Shipment Methods (Learn pages)

Open in the neighbourhood explorer

One hop out, from the extracted relations and call graph. Up to 40 shown; the sections below list them all.

Base Application · Microsoft.Sales.History · BC23-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 130 “Posted Sales Shipment” (4 Learn pages), Page 142 “Posted Sales Shipments” (4), Page 30062 “APIV2 - Sales Shipments” (2), Page 1350 “Posted Sales Shipment - Update” (1).

Properties

Property Value
Caption Sales Shipment Header
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
2 Sell-to Customer No. Code[20] — TableRelation Table 18 “Customer”; NotBlank
3 No. Δ BC28 Code[20] Specifies the number of the record.
4 Bill-to Customer No. Code[20] — TableRelation Table 18 “Customer”; NotBlank
5 Bill-to Name Δ BC28 Text[100] Specifies the name of the customer that you send or sent the invoice or credit memo to.
6 Bill-to Name 2 Δ BC27 Text[50] Specifies an additional part of the name of the customer that you send or sent the invoice or credit memo to.
7 Bill-to Address Δ BC28 Text[100] Specifies the address that you sent the invoice to.
8 Bill-to Address 2 Δ BC28 Text[50] Specifies the extended address that you sent the invoice to.
9 Bill-to City Δ BC28 Text[30] Specifies the city of the customer on the sales document. TableRelation Table 225 “Post Code” (“Post Code”.City)
10 Bill-to Contact Δ BC28 Text[100] Specifies the name of the contact person at the customer’s billing address.
11 Your Reference Text[35] —
12 Ship-to Code Δ BC28 Code[10] Specifies the code for the customer’s additional shipment address. TableRelation Table 222 “Ship-to Address” (“Ship-to Address”.Code where(“Customer No.” = field(“Sell-to Customer No.”)))
13 Ship-to Name Δ BC28 Text[100] Specifies the name of the customer at the address that the items are shipped to.
14 Ship-to Name 2 Δ BC28 Text[50] Specifies an additional part of the the name of the customer that you delivered the items to.
15 Ship-to Address Δ BC28 Text[100] Specifies the address that you delivered the items to.
16 Ship-to Address 2 Δ BC28 Text[50] Specifies the extended address that you delivered the items to.
17 Ship-to City Δ BC28 Text[30] Specifies the city of the customer on the sales document. TableRelation Table 225 “Post Code” (“Post Code”.City)
18 Ship-to Contact Δ BC28 Text[100] Specifies the name of the person you regularly contact at the address that the items were shipped to.
19 Order Date Date —
20 Posting Date Δ BC28 Date Specifies the posting date for the entry.
21 Shipment Date Δ BC28 Date Specifies when items on the document are shipped or were shipped. A shipment date is usually calculated from a requested delivery date plus lead time.
22 Posting Description Text[100] —
23 Payment Terms Code Code[10] — TableRelation Table 3 “Payment Terms” (Payment Terms)
24 Due Date Date —
25 Payment Discount % Δ BC28 Decimal —
26 Pmt. Discount Date Date —
27 Shipment Method Code Δ BC28 Code[10] Specifies the delivery conditions of the related shipment, such as free on board (FOB). TableRelation Table 10 “Shipment Method” (Shipment Method)
28 Location Code Δ BC28 Code[10] Specifies the location from which the items were shipped. TableRelation Table 14 “Location” (Location where(“Use As In-Transit” = const(false)))
29 Shortcut Dimension 1 Code Δ BC28 Code[20] Specifies the code for Shortcut Dimension 1, which is one of two global dimension codes that you set up in the General Ledger Setup window. TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1)))
30 Shortcut Dimension 2 Code Δ BC28 Code[20] Specifies the code for Shortcut Dimension 2, which is one of two global dimension codes that you set up in the General Ledger Setup window. TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2)))
31 Customer Posting Group Code[20] — TableRelation Table 92 “Customer Posting Group” (Customer Posting Group); not editable
32 Currency Code Δ BC28 Code[10] Specifies the currency code of the shipment. TableRelation Table 4 “Currency”; not editable
33 Currency Factor Δ BC28 Decimal —
34 Customer Price Group Code[10] — TableRelation Table 6 “Customer Price Group” (Customer Price Group)
35 Prices Including VAT Boolean —
37 Invoice Disc. Code Code[20] —
40 Customer Disc. Group Code[20] — TableRelation Table 340 “Customer Discount Group” (Customer Discount Group)
41 Language Code Code[10] — TableRelation Table 8 “Language”
42 Format Region Text[80] — TableRelation “Language Selection”.“Language Tag”
43 Salesperson Code Δ BC28 Code[20] Specifies a code for the salesperson who normally handles this customer’s account. TableRelation Table 13 “Salesperson/Purchaser” (Salesperson/Purchaser)
44 Order No. Δ BC28 Code[20] Specifies the number of the sales order that this invoice was posted from.
46 Comment Boolean — FlowField: exist(“Sales Comment Line” where(“Document Type” = const(Shipment), “No.” = field(“No.”), “Document Line No.” = const(0))); not editable
47 No. Printed Δ BC28 Integer Specifies how many times the document has been printed. not editable
51 On Hold Code[3] —
52 Applies-to Doc. Type Enum “Gen. Journal Document Type” — enum Enum 6 “Gen. Journal Document Type”
53 Applies-to Doc. No. Code[20] —
55 Bal. Account No. Code[20] — TableRelation Table 15 “G/L Account”, Table 270 “Bank Account” (if (“Bal. Account Type” = const(“G/L Account”)) “G/L Account” else if (“Bal. Account Type” = const(“Bank Account”)) “Bank Account”)
70 VAT Registration No. Text[20] —
73 Reason Code Code[10] — TableRelation Table 231 “Reason Code” (Reason Code)
74 Gen. Bus. Posting Group Code[20] — TableRelation Table 250 “Gen. Business Posting Group” (Gen. Business Posting Group)
75 EU 3-Party Trade Boolean —
76 Transaction Type Code[10] — TableRelation Table 258 “Transaction Type” (Transaction Type)
77 Transport Method Code[10] — TableRelation Table 259 “Transport Method” (Transport Method)
78 VAT Country/Region Code Code[10] — TableRelation Table 9 “Country/Region” (Country/Region)
79 Sell-to Customer Name Δ BC28 Text[100] Specifies the name of customer at the sell-to address.
80 Sell-to Customer Name 2 Δ BC27 Text[50] Specifies an additional part of the name of the customer who will receive the products and be billed by default.
81 Sell-to Address Δ BC28 Text[100] Specifies the customer’s sell-to address.
82 Sell-to Address 2 Δ BC28 Text[50] Specifies the customer’s extended sell-to address.
83 Sell-to City Δ BC28 Text[30] Specifies the city of the customer on the sales document. TableRelation Table 225 “Post Code” (“Post Code”.City)
84 Sell-to Contact Δ BC28 Text[100] Specifies the name of the contact person at the customer’s main address.
85 Bill-to Post Code Δ BC28 Code[20] Specifies the postal code of the customer’s billing address. TableRelation Table 225 “Post Code” (Post Code)
86 Bill-to County Δ BC28 Text[30] Specifies the state, province or county as a part of the address.
87 Bill-to Country/Region Code Δ BC28 Code[10] Specifies the country or region of the address. TableRelation Table 9 “Country/Region” (Country/Region)
88 Sell-to Post Code Δ BC28 Code[20] Specifies the post code of the customer’s sell-to address. TableRelation Table 225 “Post Code” (Post Code)
89 Sell-to County Δ BC28 Text[30] Specifies the state, province or county as a part of the address.
90 Sell-to Country/Region Code Δ BC28 Code[10] Specifies the country/region code of the customer’s main address. TableRelation Table 9 “Country/Region” (Country/Region)
91 Ship-to Post Code Δ BC28 Code[20] Specifies the postal code of the address that the items are shipped to. TableRelation Table 225 “Post Code” (Post Code)
92 Ship-to County Δ BC28 Text[30] Specifies the state, province or county as a part of the address.
93 Ship-to Country/Region Code Δ BC28 Code[10] Specifies the customer’s country/region. TableRelation Table 9 “Country/Region” (Country/Region)
94 Bal. Account Type enum “Payment Balance Account Type” — enum Enum 96 “Payment Balance Account Type”
97 Exit Point Code[10] — TableRelation Table 282 “Entry/Exit Point” (Entry/Exit Point)
98 Correction Boolean —
99 Document Date Δ BC28 Date Specifies the date when the related document was created.
100 External Document No. Δ BC28 Code[35] Specifies the number that the customer uses in their own system to refer to this sales document.
101 Area Code[10] — TableRelation Table 284 “Area”
102 Transaction Specification Code[10] — TableRelation Table 285 “Transaction Specification” (Transaction Specification)
104 Payment Method Code Code[10] — TableRelation Table 289 “Payment Method” (Payment Method)
105 Shipping Agent Code Δ BC28 Code[10] Specifies which shipping agent is used to transport the items on the sales document to the customer. TableRelation Table 291 “Shipping Agent” (Shipping Agent)
106 Package Tracking No. Δ BC24 Δ BC27 Δ BC28 Text[50] Specifies the shipping agent’s package number.
109 No. Series Code[20] — TableRelation Table 308 “No. Series” (No. Series); not editable
110 Order No. Series Code[20] — TableRelation Table 308 “No. Series” (No. Series)
112 User ID Code[50] — TableRelation User.“User Name”; DataClassification EndUserIdentifiableInformation
113 Source Code Code[10] — TableRelation Table 230 “Source Code” (Source Code)
114 Tax Area Code Code[20] — TableRelation Table 318 “Tax Area” (Tax Area)
115 Tax Liable Boolean —
116 VAT Bus. Posting Group Code[20] — TableRelation Table 323 “VAT Business Posting Group” (VAT Business Posting Group)
119 VAT Base Discount % Δ BC28 Decimal —
151 Quote No. Δ BC28 Code[20] Specifies the number of the sales quote document if a quote was used to start the sales process. not editable
163 Company Bank Account Code Code[20] — TableRelation Table 270 “Bank Account” (“Bank Account” where(“Currency Code” = field(“Currency Code”)))
171 Sell-to Phone No. Text[30] —
172 Sell-to E-Mail Text[80] Email caption
200 Work Description BLOB —
210 Ship-to Phone No. + BC25 Δ BC28 Text[30] Specifies the telephone number of the company’s shipping address.
480 Dimension Set ID Integer — TableRelation Table 480 “Dimension Set Entry” (Dimension Set Entry); not editable
5050 Campaign No. Code[20] — TableRelation Table 5071 “Campaign”
5052 Sell-to Contact No. Δ BC28 Code[20] Specifies the contact number. TableRelation Table 5050 “Contact”
5053 Bill-to Contact No. Δ BC28 Code[20] Specifies the number of the contact person at the customer’s bill-to address. TableRelation Table 5050 “Contact”
5055 Opportunity No. Code[20] — TableRelation Table 5092 “Opportunity”
5700 Responsibility Center Δ BC28 Code[10] Specifies the code for the responsibility center that serves the customer on this sales document. TableRelation Table 5714 “Responsibility Center” (Responsibility Center)
5790 Requested Delivery Date Δ BC28 Date Specifies the date that the customer has asked for the order to be delivered.
5791 Promised Delivery Date Δ BC28 Date Specifies the date that you have promised to deliver the order, as a result of the Order Promising function.
5792 Shipping Time Δ BC28 DateFormula Specifies how long it takes from when the items are shipped from the warehouse to when they are delivered.
5793 Outbound Whse. Handling Time Δ BC28 DateFormula Specifies a date formula for the time it takes to get items ready to ship from this location. The time element is used in the calculation of the delivery date as follows: Shipment Date + Outbound Warehouse Handling Time = Planned Shipment Date + Shipping Time = Planned Delivery Date.
5794 Shipping Agent Service Code Δ BC28 Code[10] Specifies which shipping agent service is used to transport the items on the sales document to the customer. TableRelation Table 5790 “Shipping Agent Services” (“Shipping Agent Services”.Code where(“Shipping Agent Code” = field(“Shipping Agent Code”)))
7000 Price Calculation Method Enum “Price Calculation Method” — enum Enum 7000 “Price Calculation Method”
7001 Allow Line Disc. Boolean —
9001 Customer Id + BC24 Guid — TableRelation Customer.SystemId; DataClassification SystemMetadata
9002 Bill-to Customer Id + BC24 Guid — TableRelation Customer.SystemId; DataClassification SystemMetadata

Keys

  • Key1: No. (clustered)
  • Key2: Order No.
  • Key3: Bill-to Customer No.
  • Key4: Sell-to Customer No.
  • Key5: Posting Date
  • Key6: Location Code
  • Key7: Salesperson Code

Events published

  • OnBeforeEmailRecords(var SalesShipmentHeader: Record "Sales Shipment Header"; var SendDialog: Boolean; var IsHandled: Boolean) (integration): Raised before emailing sales shipment records.
  • OnBeforePrintRecords(var SalesShipmentHeader: Record "Sales Shipment Header"; ShowDialog: Boolean; var IsHandled: Boolean) (integration): Raised before printing sales shipment records.
  • OnBeforeStartTrackingSite(var SalesShipmentHeader: Record "Sales Shipment Header"; var IsHandled: Boolean) (integration): Raised before starting the package tracking site for the shipment.
  • OnBeforeSendProfile(var DocumentSendingProfile: Record "Document Sending Profile"; var SalesShipmentHeader: Record "Sales Shipment Header"; var IsHandled: Boolean) (integration): Raised before sending the sales shipment using a document sending profile.
  • OnBeforeSetSecurityFilterOnRespCenter(var SalesShipmentHeader: Record "Sales Shipment Header"; var IsHandled: Boolean) (integration): Raised before setting the security filter on responsibility center for the sales shipment header.
  • OnLookupAppliesToDocNoOnAfterSetFilters(var CustLedgEntry: Record "Cust. Ledger Entry"; SalesShipmentHeader: Record "Sales Shipment Header") (integration): Raised after setting filters during the Applies-to Doc. No. lookup.
  • OnBeforeNavigate(SalesShipmentHeader: Record "Sales Shipment Header"; var IsHandled: Boolean) (integration): Raised before navigating to related entries for the sales shipment.
  • OnBeforeCheckNoPrinted(var SalesShipmentHeader: Record "Sales Shipment Header"; var IsHandled: Boolean) (integration): Raised before checking the number of times the sales shipment has been printed.

Procedures

  • SendProfile(var DocumentSendingProfile: Record "Document Sending Profile"): Sends the shipment document using the specified document sending profile.
  • SendRecords() + BC28: Sends the selected shipment records using the customer’s document sending profile.
  • PrintRecords(ShowRequestForm: Boolean): Prints the sales shipment records using the configured report selection.
  • CheckNoPrinted(): Validates that the shipment has been printed at least once.
  • EmailRecords(ShowDialog: Boolean): Sends the sales shipment records via email using the configured document sending profile.
  • Navigate(): Opens the Navigate page to show related entries for this sales shipment.
  • StartTrackingSite(): Opens the shipping agent’s tracking website for the package.
  • ShowDimensions(): Opens a page showing the dimension set for this sales shipment.
  • IsCompletlyInvoiced(): Boolean: Checks if all lines in the shipment have been fully invoiced.
  • SetSecurityFilterOnRespCenter(): Sets a security filter based on the user’s responsibility center.
  • GetCustomerVATRegistrationNumber(): Text: Gets the customer’s VAT registration number.
  • GetCustomerVATRegistrationNumberLbl(): Text: Gets the label for the VAT registration number field.
  • GetCustomerGlobalLocationNumber(): Text: Gets the customer’s global location number (GLN).
  • GetCustomerGlobalLocationNumberLbl(): Text: Gets the label for the GLN field.
  • GetLegalStatement(): Text: Gets the legal statement from sales setup for printing on shipments.
  • GetWorkDescription(): Text: Gets the work description text from the blob field.
  • PrintToDocumentAttachment(var SalesShipmentHeader: Record "Sales Shipment Header") + BC28: Prints the shipments and saves them as document attachments.

Plus 5 local procedures.

Triggers

OnInsert, OnDelete

Relations

Referenced by

15 fields in 11 objects relate to this table (TableRelation or CalcFormula).

Pages and codeunits on this 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.

Countries that replace it

BE, CA, ES, IT, MX, RU, US

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: "Sales Shipment Header"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

Evidence 1 sources