Table 5107 "Sales Header Archive"
Base Application · Microsoft.Sales.Archive
Across versions
- BC23present
- BC241 fields changed, 1 fields added
- BC251 fields added, 1 fields changed
- BC2685 fields changed, 3 fields removed
- BC273 fields changed
- BC286 fields changed
- BC29-30unchanged
Neighbourhood 70 connected objects and pages
Base Application · Microsoft.Sales.Archive · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 6629 “Sales Return List Archive” (2 Learn pages), Page 5159 “Sales Order Archive” (1), Page 5162 “Sales Quote Archive” (1), Page 6620 “Blanket Sales Order Archive” (1), Page 6622 “Blanket Sales Order Archives” (1), Page 6627 “Sales Return Order Archive” (1), Page 9348 “Sales Quote Archives” (1), Page 9349 “Sales Order Archives” (1).
Properties
| Property | Value |
|---|---|
| Caption | Sales Header Archive |
| 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 | Document Type | Enum “Sales Document Type” | — | enum Enum 36 “Sales Document Type” |
| 2 | Sell-to Customer No. Δ BC26 | Code[20] | Specifies the number of the customer who will receive the products and be billed by default. | TableRelation Table 18 “Customer” |
| 3 | No. Δ BC26 | Code[20] | Specifies the number of the involved entry or record, according to the specified number series. | |
| 4 | Bill-to Customer No. Δ BC26 | Code[20] | Specifies the number of the customer that you send or sent the invoice or credit memo to. | TableRelation Table 18 “Customer”; NotBlank |
| 5 | Bill-to Name Δ BC26 | 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 Δ BC26 | Text[100] | Specifies the address of the customer to whom you sent the invoice. | |
| 8 | Bill-to Address 2 Δ BC26 | Text[50] | Specifies an additional line of the address. | |
| 9 | Bill-to City Δ BC26 | Text[30] | Specifies the city of the address. | TableRelation Table 225 “Post Code” (“Post Code”.City) |
| 10 | Bill-to Contact Δ BC26 | Text[100] | Specifies the name of the contact person at the customer’s billing address. | |
| 11 | Your Reference Δ BC26 | Text[35] | Specifies the customer’s reference. The content will be printed on sales documents. | |
| 12 | Ship-to Code Δ BC26 | Code[10] | Specifies a code for an alternate shipment address if you want to ship to another address than the one that has been entered automatically. This field is also used in case of drop shipment. | TableRelation Table 222 “Ship-to Address” (“Ship-to Address”.Code where(“Customer No.” = field(“Sell-to Customer No.”))) |
| 13 | Ship-to Name Δ BC26 | Text[100] | Specifies the name of the customer at the address that the items are shipped to. | |
| 14 | Ship-to Name 2 Δ BC26 | Text[50] | Specifies an additional part of the name of the customer at the address that the items are shipped to. | |
| 15 | Ship-to Address Δ BC26 | Text[100] | Specifies the address that the items are shipped to. | |
| 16 | Ship-to Address 2 Δ BC26 | Text[50] | Specifies an additional part of the ship-to address, in case it is a long address. | |
| 17 | Ship-to City Δ BC26 | Text[30] | Specifies the city of the address that the items are shipped to. | TableRelation Table 225 “Post Code” (“Post Code”.City) |
| 18 | Ship-to Contact Δ BC26 | Text[100] | Specifies the name of the contact person at the address that the items are shipped to. | |
| 19 | Order Date Δ BC26 | Date | Specifies the date the order was created. The order date is also used to determine the prices and discounts on the document. | |
| 20 | Posting Date Δ BC26 | Date | Specifies the date when the document was posted. | |
| 21 | Shipment Date Δ BC26 | 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 Δ BC26 | Code[10] | Specifies a formula that calculates the payment due date, payment discount date, and payment discount amount on the sales document. | TableRelation Table 3 “Payment Terms” (Payment Terms) |
| 24 | Due Date Δ BC26 | Date | Specifies when the related sales invoice must be paid. | |
| 25 | Payment Discount % Δ BC26 Δ BC28 | Decimal | Specifies the payment discount percentage that is granted if the customer pays on or before the date entered in the Pmt. Discount Date field. The discount percentage is specified in the Payment Terms Code field. | |
| 26 | Pmt. Discount Date Δ BC26 | Date | Specifies the date on which the amount in the entry must be paid for a payment discount to be granted. | |
| 27 | Shipment Method Code Δ BC26 | 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 Δ BC26 | Code[10] | Specifies the location from where items are to be shipped. This field acts as the default location for new lines. Location code for individual lines can differ from it. | TableRelation Table 14 “Location” (Location where(“Use As In-Transit” = const(false))) |
| 29 | Shortcut Dimension 1 Code Δ BC26 | 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 Δ BC26 | 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) |
| 32 | Currency Code Δ BC26 | Code[10] | Specifies the currency that is used on the entry. | TableRelation Table 4 “Currency” |
| 33 | Currency Factor Δ BC28 | Decimal | — | |
| 34 | Price Group Code | Code[10] | — | TableRelation Table 6 “Customer Price Group” (Customer Price Group) |
| 35 | Prices Including VAT Δ BC26 | Boolean | Specifies if the Unit Price and Line Amount fields on document lines should be shown with or without VAT. | |
| 37 | Invoice Disc. Code | Code[20] | — | |
| 40 | Cust./Item Disc. Gr. | 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 Δ BC26 | Code[20] | Specifies which salesperson is associated with the sales document. | TableRelation Table 13 “Salesperson/Purchaser” (Salesperson/Purchaser) |
| 45 | Order Class | Code[10] | — | |
| 46 | Comment | Boolean | — | FlowField: exist(“Sales Comment Line Archive” where(“Document Type” = field(“Document Type”), “No.” = field(“No.”), “Document Line No.” = const(0), “Doc. No. Occurrence” = field(“Doc. No. Occurrence”), “Version No.” = field(“Version No.”))); not editable |
| 47 | No. Printed | Integer | — | |
| 51 | On Hold | Code[3] | — | |
| 52 | Applies-to Doc. Type Δ BC26 | Enum “Gen. Journal Document Type” | Specifies the type of the posted document that this document or journal line will be applied to when you post, for example to register payment. | enum Enum 6 “Gen. Journal Document Type” |
| 53 | Applies-to Doc. No. Δ BC26 | Code[20] | Specifies the number of the posted document that this document or journal line will be applied to when you post, for example to register payment. | |
| 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”) |
| 57 | Ship | Boolean | — | |
| 58 | Invoice | Boolean | — | |
| 60 | Amount | Decimal | — | FlowField: sum(“Sales Line Archive”.Amount where(“Document Type” = field(“Document Type”), “Document No.” = field(“No.”), “Doc. No. Occurrence” = field(“Doc. No. Occurrence”), “Version No.” = field(“Version No.”))); not editable |
| 61 | Amount Including VAT | Decimal | — | FlowField: sum(“Sales Line Archive”.“Amount Including VAT” where(“Document Type” = field(“Document Type”), “Document No.” = field(“No.”), “Doc. No. Occurrence” = field(“Doc. No. Occurrence”), “Version No.” = field(“Version No.”))); not editable |
| 62 | Shipping No. | Code[20] | — | |
| 63 | Posting No. | Code[20] | — | |
| 64 | Last Shipping No. | Code[20] | — | TableRelation Table 110 “Sales Shipment Header” (Sales Shipment Header) |
| 65 | Last Posting No. | Code[20] | — | TableRelation Table 112 “Sales Invoice Header” (Sales Invoice Header) |
| 66 | Prepayment No. | Code[20] | — | |
| 67 | Last Prepayment No. | Code[20] | — | TableRelation Table 112 “Sales Invoice Header” (Sales Invoice Header) |
| 68 | Prepmt. Cr. Memo No. | Code[20] | — | |
| 69 | Last Prepmt. Cr. Memo No. | Code[20] | — | TableRelation Table 112 “Sales Invoice Header” (Sales Invoice Header) |
| 70 | VAT Registration No. | Text[20] | — | |
| 71 | Combine Shipments | Boolean | — | |
| 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 Δ BC26 | Boolean | Specifies if the transaction is related to trade with a third party within the EU. | |
| 76 | Transaction Type Δ BC26 | Code[10] | Specifies the type of transaction that the document represents, for the purpose of reporting to INTRASTAT. | TableRelation Table 258 “Transaction Type” (Transaction Type) |
| 77 | Transport Method Δ BC26 | Code[10] | Specifies the transport method, for the purpose of reporting to INTRASTAT. | 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 Δ BC26 | Text[100] | Specifies the name of the customer who will receive the products and be billed by default. | |
| 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 Δ BC26 | Text[100] | Specifies the main address of the customer. | |
| 82 | Sell-to Address 2 Δ BC26 | Text[50] | Specifies an additional part of the address. | |
| 83 | Sell-to City Δ BC26 | Text[30] | Specifies the city of the customer’s main address. | TableRelation Table 225 “Post Code” (“Post Code”.City) |
| 84 | Sell-to Contact Δ BC26 | Text[100] | Specifies the name of the contact person at the customer’s main address. | |
| 85 | Bill-to Post Code Δ BC26 | Code[20] | Specifies the postal code of the customer’s billing address. | TableRelation Table 225 “Post Code” (Post Code) |
| 86 | Bill-to County Δ BC26 | Text[30] | Specifies the county of the customer on the sales document. | |
| 87 | Bill-to Country/Region Code Δ BC26 | Code[10] | Specifies the country or region of the customer on the sales document. | TableRelation Table 9 “Country/Region” (Country/Region) |
| 88 | Sell-to Post Code Δ BC26 | Code[20] | Specifies the postal code of the customer’s main address. | TableRelation Table 225 “Post Code” (Post Code) |
| 89 | Sell-to County Δ BC26 | Text[30] | Specifies the county of your customer. | |
| 90 | Sell-to Country/Region Code Δ BC26 | Code[10] | Specifies the country or region of your customer. | TableRelation Table 9 “Country/Region” (Country/Region) |
| 91 | Ship-to Post Code Δ BC26 | 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 Δ BC26 | Text[30] | Specifies the county of the ship-to address. | |
| 93 | Ship-to Country/Region Code Δ BC26 | Code[10] | Specifies the country/region code of the address that the items are shipped to. | 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 Δ BC26 | Code[10] | Specifies the point of exit through which you ship the items out of your country/region, for reporting to Intrastat. | TableRelation Table 282 “Entry/Exit Point” (Entry/Exit Point) |
| 98 | Correction | Boolean | — | |
| 99 | Document Date Δ BC26 | Date | Specifies the date the document was created. | |
| 100 | External Document No. Δ BC26 | Code[35] | Specifies a document number that refers to the customer’s or vendor’s numbering system. | |
| 101 | Area Δ BC26 | Code[10] | Specifies the country or region of origin for the purpose of Intrastat reporting. | TableRelation Table 284 “Area” |
| 102 | Transaction Specification Δ BC26 | Code[10] | Specifies a specification of the document’s transaction, for the purpose of reporting to INTRASTAT. | TableRelation Table 285 “Transaction Specification” (Transaction Specification) |
| 104 | Payment Method Code Δ BC26 | Code[10] | Specifies how the customer must pay for products on the sales document. | TableRelation Table 289 “Payment Method” (Payment Method) |
| 105 | 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) |
| 106 | Package Tracking No. Δ BC24 Δ BC26 Δ BC27 | Text[50] | Specifies the shipping agent’s package number. | |
| 107 | No. Series | Code[20] | — | TableRelation Table 308 “No. Series” (No. Series) |
| 108 | Posting No. Series | Code[20] | — | TableRelation Table 308 “No. Series” (No. Series) |
| 109 | Shipping No. Series | Code[20] | — | TableRelation Table 308 “No. Series” (No. Series) |
| 114 | Tax Area Code Δ BC26 | Code[20] | Specifies the tax area that is used to calculate and post sales tax. | TableRelation Table 318 “Tax Area” (Tax Area) |
| 115 | Tax Liable Δ BC26 | Boolean | Specifies if the customer or vendor is liable for sales tax. | |
| 116 | VAT Bus. Posting Group Δ BC26 | Code[20] | Specifies the VAT specification of the involved customer or vendor to link transactions made for this record with the appropriate general ledger account according to the VAT posting setup. | TableRelation Table 323 “VAT Business Posting Group” (VAT Business Posting Group) |
| 117 | Reserve | Enum “Reserve Method” | — | enum Enum 100 “Reserve Method” |
| 118 | Applies-to ID Δ BC26 | Code[50] | Specifies the ID of entries that will be applied to when you choose the Apply Entries action. | |
| 119 | VAT Base Discount % Δ BC28 | Decimal | — | |
| 120 | Status Δ BC26 | Enum “Sales Document Status” | Specifies whether the document is open, waiting to be approved, has been invoiced for prepayment, or has been released to the next stage of processing. | enum Enum 3612 “Sales Document Status” |
| 121 | Invoice Discount Calculation | Option | — | OptionCaption: None,%,Amount |
| 122 | Invoice Discount Value Δ BC28 | Decimal | — | |
| 123 | Send IC Document | Boolean | — | |
| 124 | IC Status | Enum “Sales Document IC Status” | — | enum Enum 124 “Sales Document IC Status” |
| 125 | Sell-to IC Partner Code | Code[20] | — | TableRelation Table 413 “IC Partner” (IC Partner); not editable |
| 126 | Bill-to IC Partner Code | Code[20] | — | TableRelation Table 413 “IC Partner” (IC Partner); not editable |
| 127 | IC Reference Document No. | Code[20] | — | not editable |
| 129 | IC Direction | Enum “IC Direction Type” | — | enum Enum 129 “IC Direction Type” |
| 130 | Prepayment % Δ BC28 | Decimal | — | |
| 131 | Prepayment No. Series | Code[20] | — | TableRelation Table 308 “No. Series” (No. Series) |
| 132 | Compress Prepayment | Boolean | — | |
| 133 | Prepayment Due Date | Date | — | |
| 134 | Prepmt. Cr. Memo No. Series | Code[20] | — | TableRelation Table 308 “No. Series” (No. Series) |
| 135 | Prepmt. Posting Description | Text[100] | — | |
| 138 | Prepmt. Pmt. Discount Date | Date | — | |
| 139 | Prepmt. Payment Terms Code | Code[10] | — | TableRelation Table 3 “Payment Terms” (Payment Terms) |
| 140 | Prepmt. Payment Discount % Δ BC28 | Decimal | — | |
| 145 | No. of Archived Versions | Integer | — | FlowField: max(“Sales Header Archive”.“Version No.” where(“Document Type” = field(“Document Type”), “No.” = field(“No.”), “Doc. No. Occurrence” = field(“Doc. No. Occurrence”))); not editable |
| 151 | Sales Quote No. | Code[20] | — | TableRelation Table 36 “Sales Header” (“Sales Header”.“No.” where(“Document Type” = const(Quote), “No.” = field(“Sales Quote No.”))); not editable |
| 152 | Quote Valid Until Date Δ BC26 | Date | Specifies how long the quote is valid. | |
| 153 | Quote Sent to Customer | DateTime | — | |
| 154 | Quote Accepted | Boolean | — | |
| 155 | Quote Accepted Date | Date | — | not editable |
| 163 | Company Bank Account Code | Code[20] | — | TableRelation Table 270 “Bank Account” (“Bank Account” where(“Currency Code” = field(“Currency Code”))) |
| 165 | Incoming Document Entry No. + BC24 | Integer | — | TableRelation Table 130 “Incoming Document” (Incoming Document) |
| 171 | Sell-to Phone No. | Text[30] | — | |
| 172 | Sell-to E-Mail | Text[80] | — | |
| 179 | VAT Reporting Date Δ BC26 | Date | Specifies the entry’s VAT date. | |
| 181 | Rcvd.-from Count./Region Code | Code[10] | Received-from Country/Region Code caption | TableRelation Table 9 “Country/Region” (Country/Region) |
| 200 | Work Description | BLOB | — | |
| 210 | Ship-to Phone No. + BC25 Δ BC26 | 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 |
| 3998 | Source Doc. Exists | Boolean | — | FlowField: exist(“Sales Header” where(“Document Type” = field(“Document Type”), “No.” = field(“No.”))); not editable |
| 3999 | Last Archived Date | DateTime | — | FlowField: max(“Sales Header Archive”.SystemCreatedAt where(“Document Type” = field(“Document Type”), “No.” = field(“No.”), “Doc. No. Occurrence” = field(“Doc. No. Occurrence”))); not editable |
| 5043 | Interaction Exist Δ BC26 | Boolean | Specifies that the archived document is linked to an interaction log entry. | |
| 5044 | Time Archived Δ BC26 | Time | Specifies what time the document was archived. | |
| 5045 | Date Archived Δ BC26 | Date | Specifies the date when the document was archived. | |
| 5046 | Archived By Δ BC26 | Code[50] | Specifies the user ID of the person who archived this document. | TableRelation User.“User Name”; not editable; DataClassification EndUserIdentifiableInformation |
| 5047 | Version No. Δ BC26 | Integer | Specifies the version number of the archived document. | |
| 5048 | Doc. No. Occurrence | Integer | — | |
| 5050 | Campaign No. Δ BC26 | Code[20] | Specifies the campaign number the document is linked to. | TableRelation Table 5071 “Campaign” |
| 5052 | Sell-to Contact No. Δ BC26 | Code[20] | Specifies the number of the contact person at the customer’s main address. | TableRelation Table 5050 “Contact” |
| 5053 | Bill-to Contact No. Δ BC26 | Code[20] | Specifies the number of the contact person at the customer’s billing address. | TableRelation Table 5050 “Contact” |
| 5054 | Bill-to Customer Template Code Δ BC25 Δ BC26 | Code[10] | Bill-to Customer Template Code (obsoleted) caption | obsolete Removed 25.0; #if not CLEANSCHEMA25 |
| 5055 | Opportunity No. | Code[20] | — | TableRelation Opportunity.“No.” where(“Contact No.” = field(“Sell-to Contact No.”), Closed = const(false)) |
| 5056 | Sell-to Customer Templ. Code Δ BC26 | Code[20] | Specifies information about sales quotes, purchase quotes, or orders in earlier versions of the document | TableRelation Table 1381 “Customer Templ.” (Customer Templ.) |
| 5057 | Bill-to Customer Templ. Code Δ BC26 | Code[20] | Specifies information about sales quotes, purchase quotes, or orders in earlier versions of the document. | TableRelation Table 1381 “Customer Templ.” (Customer Templ.) |
| 5700 | Responsibility Center Δ BC26 | Code[10] | Specifies the code of the responsibility center (for example, a distribution center) assigned to the customer or associated with the order. | TableRelation Table 5714 “Responsibility Center” (Responsibility Center) |
| 5750 | Shipping Advice Δ BC26 | Enum “Sales Header Shipping Advice” | Specifies the shipping advice, which informs whether partial deliveries are acceptable. | enum Enum 3657 “Sales Header Shipping Advice” |
| 5752 | Completely Shipped | Boolean | — | FlowField: min(“Sales Line Archive”.“Completely Shipped” where(“Document Type” = field(“Document Type”), “Document No.” = field(“No.”), “Version No.” = field(“Version No.”), “Shipment Date” = field(“Date Filter”), “Location Code” = field(“Location Filter”))); not editable |
| 5753 | Posting from Whse. Ref. | Integer | — | |
| 5754 | Location Filter | Code[10] | — | TableRelation Table 14 “Location”; FlowFilter |
| 5790 | Requested Delivery Date Δ BC26 | Date | Specifies the date that your customer has asked for the order to be delivered. | |
| 5791 | Promised Delivery Date Δ BC26 | Date | Specifies the date that you have promised to deliver the order, as a result of the Order Promising function. | |
| 5792 | Shipping Time Δ BC26 | 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 Δ BC26 | 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 Δ 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”))) |
| 5795 | Late Order Shipping Δ BC26 | Boolean | Indicates a delay in the shipment of one or more lines, or that the shipment date is either the same as or earlier than the work date. | FlowField: exist(“Sales Line Archive” where(“Document Type” = field(“Document Type”), “Sell-to Customer No.” = field(“Sell-to Customer No.”), “Document No.” = field(“No.”), “Doc. No. Occurrence” = field(“Doc. No. Occurrence”), “Version No.” = field(“Version No.”), “Shipment Date” = field(“Date Filter”))); not editable |
| 5796 | Date Filter | Date | — | FlowFilter |
| 5800 | Receive | Boolean | — | |
| 5801 | Return Receipt No. | Code[20] | — | |
| 5802 | Return Receipt No. Series | Code[20] | — | TableRelation Table 308 “No. Series” (No. Series) |
| 5803 | Last Return Receipt No. | Code[20] | — | TableRelation Table 6660 “Return Receipt Header” (Return Receipt Header) |
| 7000 | Price Calculation Method | Enum “Price Calculation Method” | — | enum Enum 7000 “Price Calculation Method” |
| 7001 | Allow Line Disc. | Boolean | — | |
| 7200 | Get Shipment Used | Boolean | — | not editable |
| 9000 | Assigned User ID Δ BC26 | Code[50] | Specifies the ID of the user who is responsible for the document. | TableRelation Table 91 “User Setup” (User Setup); DataClassification EndUserIdentifiableInformation |
Keys
- Key1: Document Type, No., Doc. No. Occurrence, Version No. (clustered)
- Key2: Document Type, Sell-to Customer No.
- Key3: Document Type, Bill-to Customer No.
- Key4: Incoming Document Entry No.
Events published
OnBeforeSetSecurityFilterOnRespCenter(var SalesHeaderArchive: Record "Sales Header Archive"; var IsHandled: Boolean)(integration): Raises an event before applying the security filter based on the user’s responsibility center.
Procedures
ShowDimensions(): Opens the Dimension Set Entries page to display the dimensions associated with this archived sales header.SetSecurityFilterOnRespCenter(): Applies a security filter to restrict records based on the current user’s assigned responsibility center.GetWorkDescription(): Text+ BC26: Retrieves the work description text from the BLOB field as a readable text string.
Triggers
OnDelete
Relations
- drill-down page Page 5161 “Sales List Archive”
- lookup page Page 5161 “Sales List Archive”
- Shipment Method Code: TableRelation Table 10 “Shipment Method”
- Last Shipping No.: TableRelation Table 110 “Sales Shipment Header”
- Last Posting No.: TableRelation Table 112 “Sales Invoice Header”
- Last Prepayment No.: TableRelation Table 112 “Sales Invoice Header”
- Last Prepmt. Cr. Memo No.: TableRelation Table 112 “Sales Invoice Header”
- Salesperson Code: TableRelation Table 13 “Salesperson/Purchaser”
- Incoming Document Entry No.: TableRelation Table 130 “Incoming Document”
- Bill-to Customer Templ. Code: TableRelation Table 1381 “Customer Templ.”
- Sell-to Customer Templ. Code: TableRelation Table 1381 “Customer Templ.”
- Location Code: TableRelation Table 14 “Location”
- Location Filter: 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”
- 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”
- Prepmt. Payment Terms Code: TableRelation Table 3 “Payment Terms”
- No. Series: TableRelation Table 308 “No. Series”
- Posting No. Series: TableRelation Table 308 “No. Series”
- Prepayment No. Series: TableRelation Table 308 “No. Series”
- Prepmt. Cr. Memo No. Series: TableRelation Table 308 “No. Series”
- Return Receipt No. Series: TableRelation Table 308 “No. Series”
- Shipping 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”
- Cust./Item Disc. Gr.: TableRelation Table 340 “Customer Discount Group”
- Shortcut Dimension 1 Code: TableRelation Table 349 “Dimension Value”
- Shortcut Dimension 2 Code: TableRelation Table 349 “Dimension Value”
- Source Doc. Exists: CalcFormula Table 36 “Sales Header”
- Sales Quote No.: TableRelation Table 36 “Sales Header”
- Currency Code: TableRelation Table 4 “Currency”
- Bill-to IC Partner Code: TableRelation Table 413 “IC Partner”
- Sell-to IC Partner Code: TableRelation Table 413 “IC Partner”
- 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”
- Last Archived Date: CalcFormula Table 5107 “Sales Header Archive”
- No. of Archived Versions: CalcFormula Table 5107 “Sales Header Archive”
- Amount: CalcFormula Table 5108 “Sales Line Archive”
- Amount Including VAT: CalcFormula Table 5108 “Sales Line Archive”
- Completely Shipped: CalcFormula Table 5108 “Sales Line Archive”
- Late Order Shipping: CalcFormula Table 5108 “Sales Line Archive”
- Comment: CalcFormula Table 5126 “Sales Comment Line Archive”
- Responsibility Center: TableRelation Table 5714 “Responsibility Center”
- Shipping Agent Service Code: TableRelation Table 5790 “Shipping Agent Services”
- Price Group Code: TableRelation Table 6 “Customer Price Group”
- Last Return Receipt No.: TableRelation Table 6660 “Return Receipt Header”
- Language Code: TableRelation Table 8 “Language”
- Bill-to Country/Region Code: TableRelation Table 9 “Country/Region”
- Rcvd.-from Count./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”
- Assigned User ID: TableRelation Table 91 “User Setup”
- Customer Posting Group: TableRelation Table 92 “Customer Posting Group”
Referenced by
7 fields in 5 objects relate to this table (TableRelation or CalcFormula).
- Table 18 “Customer”: Bill-to No. Of Archived Doc., Sell-to No. Of Archived Doc.
- Table 5107 “Sales Header Archive”: Last Archived Date, No. of Archived Versions
- Table 36 “Sales Header”: No. of Archived Versions
- Table 5108 “Sales Line Archive”: Document No.
- Table 8069 “Sales Sub. Line Archive”: Document No.
Pages and codeunits on this table
- Page 30212 “APIV2 - Sales Qt. Archives” (source table)
- Page 30214 “APIV2 - Sales Ord. Archives” (source table)
- Page 30220 “APIV2 - S. Ret. Ord. Archives” (source table)
- Page 30228 “APIV2 - S. Bl. Ord. Archives” (source table)
- Page 5159 “Sales Order Archive” (source table)
- Page 5161 “Sales List Archive” (source table)
- Page 5162 “Sales Quote Archive” (source table)
- Page 6620 “Blanket Sales Order Archive” (source table)
- Page 6622 “Blanket Sales Order Archives” (source table)
- Page 6627 “Sales Return Order Archive” (source table)
- Page 6629 “Sales Return List Archive” (source table)
- Page 9348 “Sales Quote Archives” (source table)
- Page 9349 “Sales Order Archives” (source table)
- Codeunit 322 “SalesCount-PrintedArch” (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 10 “Type Helper” (2 calls:
GetWorkDescription → LFSeparator,GetWorkDescription → TryReadAsTextWithSepAndFieldErrMsg) - Codeunit 408 “DimensionManagement” (1 call:
ShowDimensions → ShowDimensionSet) - Codeunit 5700 “User Setup Management” (1 call:
SetSecurityFilterOnRespCenter → GetSalesFilter) - Codeunit 5703 “Catalog Item Management” (1 call:
OnDelete → DelNonStockSalesArch)
Countries that replace it
AU, BE, CA, CH, IT, MX, NO, NZ, RU, US
Deprecations
- field Bill-to Customer Template Code: Removed 25.0 (#if not CLEANSCHEMA25), “Will be removed with other functionality related to “old” templates. Replaced by “Bill-to Customer Templ. Code”.”
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 Header Archive"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.