Table 110 "Sales Shipment Header"
Base Application · Microsoft.Sales.History
Across versions
- BC23present
- BC244 procedures added, 2 fields added
- BC251 fields added
- BC26unchanged
- BC273 fields changed
- BC2854 fields changed, 3 procedures added
- BC29-30unchanged
Neighbourhood 69 connected objects and pages
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.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.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
- drill-down page Page 142 “Posted Sales Shipments”
- lookup page Page 142 “Posted Sales Shipments”
- Shipment Method Code: TableRelation Table 10 “Shipment Method”
- Salesperson Code: TableRelation Table 13 “Salesperson/Purchaser”
- Location Code: TableRelation Table 14 “Location”
- Bal. Account No.: TableRelation Table 15 “G/L Account” (conditional)
- Bill-to Customer No.: TableRelation Table 18 “Customer”
- Sell-to Customer No.: TableRelation Table 18 “Customer”
- Ship-to Code: TableRelation Table 222 “Ship-to Address”
- Bill-to City: TableRelation Table 225 “Post Code”
- Bill-to Post Code: TableRelation Table 225 “Post Code”
- Sell-to City: TableRelation Table 225 “Post Code”
- Sell-to Post Code: TableRelation Table 225 “Post Code”
- Ship-to City: TableRelation Table 225 “Post Code”
- Ship-to Post Code: TableRelation Table 225 “Post Code”
- Source Code: TableRelation Table 230 “Source Code”
- Reason Code: TableRelation Table 231 “Reason Code”
- Gen. Bus. Posting Group: TableRelation Table 250 “Gen. Business Posting Group”
- Transaction Type: TableRelation Table 258 “Transaction Type”
- Transport Method: TableRelation Table 259 “Transport Method”
- Bal. Account No.: TableRelation Table 270 “Bank Account” (conditional)
- Company Bank Account Code: TableRelation Table 270 “Bank Account”
- Exit Point: TableRelation Table 282 “Entry/Exit Point”
- Area: TableRelation Table 284 “Area”
- Transaction Specification: TableRelation Table 285 “Transaction Specification”
- Payment Method Code: TableRelation Table 289 “Payment Method”
- Shipping Agent Code: TableRelation Table 291 “Shipping Agent”
- Payment Terms Code: TableRelation Table 3 “Payment Terms”
- No. Series: TableRelation Table 308 “No. Series”
- Order No. Series: TableRelation Table 308 “No. Series”
- Tax Area Code: TableRelation Table 318 “Tax Area”
- VAT Bus. Posting Group: TableRelation Table 323 “VAT Business Posting Group”
- Customer Disc. Group: TableRelation Table 340 “Customer Discount Group”
- Shortcut Dimension 1 Code: TableRelation Table 349 “Dimension Value”
- Shortcut Dimension 2 Code: TableRelation Table 349 “Dimension Value”
- Currency Code: TableRelation Table 4 “Currency”
- Comment: CalcFormula Table 44 “Sales Comment Line”
- Dimension Set ID: TableRelation Table 480 “Dimension Set Entry”
- Bill-to Contact No.: TableRelation Table 5050 “Contact”
- Sell-to Contact No.: TableRelation Table 5050 “Contact”
- Campaign No.: TableRelation Table 5071 “Campaign”
- Opportunity No.: TableRelation Table 5092 “Opportunity”
- Responsibility Center: TableRelation Table 5714 “Responsibility Center”
- Shipping Agent Service Code: TableRelation Table 5790 “Shipping Agent Services”
- Customer Price Group: TableRelation Table 6 “Customer Price Group”
- Language Code: TableRelation Table 8 “Language”
- Bill-to Country/Region Code: TableRelation Table 9 “Country/Region”
- Sell-to Country/Region Code: TableRelation Table 9 “Country/Region”
- Ship-to Country/Region Code: TableRelation Table 9 “Country/Region”
- VAT Country/Region Code: TableRelation Table 9 “Country/Region”
- Customer Posting Group: TableRelation Table 92 “Customer Posting Group”
Referenced by
15 fields in 11 objects relate to this table (TableRelation or CalcFormula).
- Table 111 “Sales Shipment Line”: Currency Code, Document No.
- Table 18 “Customer”: Bill-To No. of Pstd. Shipments, No. of Pstd. Shipments
- Table 30100 “Shpfy Cue”: Shipment Errors, Unprocessed Shipments
- Table 36 “Sales Header”: Last Shipment Date, Last Shipping No.
- Table 5107 “Sales Header Archive”: Last Shipping No.
- Table 5992 “Service Invoice Header”: Last Shipping No.
- Table 7340 “Posted Invt. Put-away Header”: Source No.
- Table 7342 “Posted Invt. Pick Header”: Source No.
- Table 7344 “Registered Invt. Movement Hdr.”: Source No.
- Table 780 “Certificate of Supply”: Document No.
- Table 9050 “Warehouse Basic Cue”: Posted Sales Shipments - Today
Pages and codeunits on this table
- Page 130 “Posted Sales Shipment” (source table)
- Page 1350 “Posted Sales Shipment - Update” (source table)
- Page 142 “Posted Sales Shipments” (source table)
- Page 30062 “APIV2 - Sales Shipments” (source table)
- Page 396 “Sales Shipment Statistics” (source table)
- Codeunit 314 “Sales Shpt.-Printed” (codeunit runs on it)
- Codeunit 391 “Shipment Header - Edit” (codeunit runs on it)
- Codeunit 6130 “E-Doc. Shipment Export To XML” (codeunit runs on it)
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 452 “Report Distribution Management” (3 calls:
EmailRecords → GetFullDocumentTypeText,SendProfile → GetFullDocumentTypeText,SendRecords → GetFullDocumentTypeText) - Codeunit 10 “Type Helper” (2 calls:
GetWorkDescription → LFSeparator,GetWorkDescription → TryReadAsTextWithSepAndFieldErrMsg) - Codeunit 363 “PostSales-Delete” (2 calls:
OnDelete → DeleteSalesShptLines,OnDelete → IsDocumentDeletionAllowed) - Codeunit 1535 “Approvals Mgmt.” (1 call:
OnDelete → DeletePostedApprovalEntries) - Codeunit 408 “DimensionManagement” (1 call:
ShowDimensions → ShowDimensionSet) - Codeunit 5700 “User Setup Management” (1 call:
SetSecurityFilterOnRespCenter → GetSalesFilter)
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: "Sales Shipment Header"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.