Table 5108 "Sales Line Archive"

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

Properties

Property	Value
Caption	Sales Line 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 Δ BC26	Enum “Sales Document Type”	Specifies the type of sales document.	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	Document No. Δ BC26	Code[20]	Specifies the document number.	TableRelation Table 5107 “Sales Header Archive” (“Sales Header Archive”.“No.” where(“Document Type” = field(“Document Type”), “Version No.” = field(“Version No.”)))
4	Line No. Δ BC26	Integer	Specifies the number of the line.
5	Type Δ BC26	Enum “Sales Line Type”	Specifies the type of entity that will be posted for this sales line, such as Item, Resource, or G/L Account.	enum Enum 37 “Sales Line Type”
6	No. Δ BC26	Code[20]	Specifies the number of the involved entry or record, according to the specified number series.	TableRelation Table 15 “G/L Account”, Table 156 “Resource”, Table 27 “Item” (if (Type = const(” “)) “Standard Text” else if (Type = const(“G/L Account”)) “G/L Account” else if (Type = const(Item)) Item else if (Type = const(Resource)) Resource else if (Type = const(“Fixed Asset”)) “Fixed Asset” else if (Type = const(“Charge (Item)”)) “Item Charge”)
7	Location Code Δ BC26	Code[10]	Specifies the location from where inventory items to the customer on the sales document are to be shipped by default.	TableRelation Table 14 “Location” (Location where(“Use As In-Transit” = const(false)))
8	Posting Group	Code[20]	—	TableRelation Table 5606 “FA Posting Group”, Table 94 “Inventory Posting Group” (if (Type = const(Item)) “Inventory Posting Group” else if (Type = const(“Fixed Asset”)) “FA Posting Group”)
9	Quantity Disc. Code	Code[20]	—
10	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.
11	Description Δ BC26	Text[100]	Specifies a description of the record.
12	Description 2 Δ BC26	Text[50]	Specifies information in addition to the description.
13	Unit of Measure Δ BC26	Text[50]	Specifies the name of the item or resource’s unit of measure, such as piece or hour.
15	Quantity Δ BC26 Δ BC28	Decimal	Specifies how many units are being sold.
16	Outstanding Quantity Δ BC28	Decimal	—
17	Qty. to Invoice Δ BC26 Δ BC28	Decimal	Specifies the quantity that remains to be invoiced. It is calculated as Quantity - Qty. Invoiced.
18	Qty. to Ship Δ BC26 Δ BC28	Decimal	Specifies the quantity of items that remain to be shipped.
22	Unit Price Δ BC26	Decimal	Specifies the price of one unit of the item or resource. You can enter a price manually or have it entered according to the Price/Profit Calculation field on the related card.
23	Unit Cost (LCY) Δ BC26 Δ BC28	Decimal	Specifies the cost, in LCY, of one unit of the item or resource on the line.
25	VAT % Δ BC28	Decimal	—
26	Quantity Disc. % Δ BC28	Decimal	—
27	Line Discount % Δ BC26 Δ BC28	Decimal	Specifies the discount percentage that is granted for the item on the line.
28	Line Discount Amount Δ BC26	Decimal	Specifies the discount amount that is granted for the item on the line.
29	Amount Δ BC26	Decimal	Specifies the sum of amounts in the Line Amount field on the sales lines.
30	Amount Including VAT Δ BC26	Decimal	Specifies the net amount, including VAT, for this line.
32	Allow Invoice Disc. Δ BC26	Boolean	Specifies if the invoice line is included when the invoice discount is calculated.
34	Gross Weight Δ BC26 Δ BC28	Decimal	Specifies the gross weight of one unit of the item. In the sales statistics window, the gross weight on the line is included in the total gross weight of all the lines for the particular sales document.
35	Net Weight Δ BC26 Δ BC28	Decimal	Specifies the net weight of one unit of the item. In the sales statistics window, the net weight on the line is included in the total net weight of all the lines for the particular sales document.
36	Units per Parcel Δ BC26 Δ BC28	Decimal	Specifies the number of units per parcel of the item. In the sales statistics window, the number of units per parcel on the line helps to determine the total number of units for all the lines for the particular sales document.
37	Unit Volume Δ BC26 Δ BC28	Decimal	Specifies the volume of one unit of the item. In the sales statistics window, the volume of one unit of the item on the line is included in the total volume of all the lines for the particular sales document.
38	Appl.-to Item Entry Δ BC26	Integer	Specifies the number of the item ledger entry that the document or journal line is applied to.
40	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)))
41	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)))
42	Price Group Code	Code[10]	—	TableRelation Table 6 “Customer Price Group” (Customer Price Group)
43	Allow Quantity Disc.	Boolean	—
45	Job No. Δ BC24 Δ BC26	Code[20]	Specifies the number of the related project.	TableRelation Table 167 “Job”
52	Work Type Code	Code[10]	—	TableRelation Table 200 “Work Type” (Work Type)
55	Cust./Item Disc. % Δ BC28	Decimal	—
57	Outstanding Amount	Decimal	—	not editable
58	Qty. Shipped Not Invoiced Δ BC28	Decimal	—
59	Shipped Not Invoiced	Decimal	—
60	Quantity Shipped Δ BC26 Δ BC28	Decimal	Specifies how many units of the item on the line have been posted as shipped.
61	Quantity Invoiced Δ BC26 Δ BC28	Decimal	Specifies how many units of the item on the line have been posted as invoiced.
63	Shipment No.	Code[20]	—
64	Shipment Line No.	Integer	—
67	Profit % Δ BC28	Decimal	—
68	Bill-to Customer No.	Code[20]	—	TableRelation Table 18 “Customer”
69	Inv. Discount Amount Δ BC26	Decimal	Specifies the total calculated invoice discount amount for the line.
71	Purchase Order No.	Code[20]	—	TableRelation Table 38 “Purchase Header” (if (“Drop Shipment” = const(true)) “Purchase Header”.“No.” where(“Document Type” = const(Order)))
72	Purch. Order Line No.	Integer	—	TableRelation Table 39 “Purchase Line” (if (“Drop Shipment” = const(true)) “Purchase Line”.“Line No.” where(“Document Type” = const(Order), “Document No.” = field(“Purchase Order No.”)))
73	Drop Shipment Δ BC26	Boolean	Specifies if your vendor ships the items directly to your customer.
74	Gen. Bus. Posting Group Δ BC26	Code[20]	Specifies the vendor’s or customer’s trade type to link transactions made for this business partner with the appropriate general ledger account according to the general posting setup.	TableRelation Table 250 “Gen. Business Posting Group” (Gen. Business Posting Group)
75	Gen. Prod. Posting Group Δ BC26	Code[20]	Specifies the item’s product type to link transactions made for this item with the appropriate general ledger account according to the general posting setup.	TableRelation Table 251 “Gen. Product Posting Group” (Gen. Product Posting Group)
77	VAT Calculation Type	Enum “Tax Calculation Type”	—	enum Enum 254 “Tax Calculation Type”
78	Transaction Type	Code[10]	—	TableRelation Table 258 “Transaction Type” (Transaction Type)
79	Transport Method	Code[10]	—	TableRelation Table 259 “Transport Method” (Transport Method)
80	Attached to Line No.	Integer	—	TableRelation Table 5108 “Sales Line Archive” (“Sales Line Archive”.“Line No.” where(“Document Type” = field(“Document Type”), “Document No.” = field(“Document No.”), “Doc. No. Occurrence” = field(“Doc. No. Occurrence”), “Version No.” = field(“Version No.”)))
81	Exit Point	Code[10]	—	TableRelation Table 282 “Entry/Exit Point” (Entry/Exit Point)
82	Area	Code[10]	—	TableRelation Table 284 “Area”
83	Transaction Specification	Code[10]	—	TableRelation Table 285 “Transaction Specification” (Transaction Specification)
85	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)
86	Tax Liable Δ BC26	Boolean	Specifies if the customer or vendor is liable for sales tax.
87	Tax Group Code Δ BC26	Code[20]	Specifies the tax group that is used to calculate and post sales tax.	TableRelation Table 321 “Tax Group” (Tax Group)
88	VAT Clause Code	Code[20]	—	TableRelation Table 560 “VAT Clause” (VAT Clause)
89	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)
90	VAT Prod. Posting Group Δ BC26	Code[20]	Specifies the VAT specification of the involved item or resource to link transactions made for this record with the appropriate general ledger account according to the VAT posting setup.	TableRelation Table 324 “VAT Product Posting Group” (VAT Product Posting Group)
91	Currency Code	Code[10]	—	TableRelation Table 4 “Currency”
92	Outstanding Amount (LCY) Δ BC28	Decimal	—
93	Shipped Not Invoiced (LCY) Δ BC28	Decimal	—
96	Reserve Δ BC26	Enum “Reserve Method”	Specifies whether items will never, automatically (Always), or optionally be reserved for this customer. Optional means that you must manually reserve items for this customer.	enum Enum 100 “Reserve Method”
97	Blanket Order No. Δ BC26	Code[20]	Specifies the number of the blanket order that the record originates from.	TableRelation Table 36 “Sales Header” (“Sales Header”.“No.” where(“Document Type” = const(“Blanket Order”)))
98	Blanket Order Line No. Δ BC26	Integer	Specifies the number of the blanket order line that the record originates from.	TableRelation Table 37 “Sales Line” (“Sales Line”.“Line No.” where(“Document Type” = const(“Blanket Order”), “Document No.” = field(“Blanket Order No.”)))
99	VAT Base Amount	Decimal	—
100	Unit Cost	Decimal	—
101	System-Created Entry	Boolean	—
103	Line Amount Δ BC26	Decimal	Specifies the net amount, excluding any invoice discount amount, that must be paid for products on the line.
104	VAT Difference	Decimal	—
105	Inv. Disc. Amount to Invoice	Decimal	—
106	VAT Identifier	Code[20]	—
107	IC Partner Ref. Type	Enum “IC Partner Reference Type”	—	enum Enum 107 “IC Partner Reference Type”
108	IC Partner Reference	Code[20]	—
109	Prepayment % Δ BC28	Decimal	—
110	Prepmt. Line Amount	Decimal	—
111	Prepmt. Amt. Inv.	Decimal	—	not editable
112	Prepmt. Amt. Incl. VAT	Decimal	—	not editable
113	Prepayment Amount	Decimal	—	not editable
114	Prepmt. VAT Base Amt.	Decimal	—	not editable
115	Prepayment VAT % Δ BC28	Decimal	—	not editable
116	Prepmt. VAT Calc. Type	Enum “Tax Calculation Type”	—	enum Enum 254 “Tax Calculation Type”; not editable
117	Prepayment VAT Identifier	Code[20]	—	not editable
118	Prepayment Tax Area Code	Code[20]	—	TableRelation Table 318 “Tax Area” (Tax Area)
119	Prepayment Tax Liable	Boolean	—
120	Prepayment Tax Group Code	Code[20]	—	TableRelation Table 321 “Tax Group” (Tax Group)
121	Prepmt Amt to Deduct	Decimal	—
122	Prepmt Amt Deducted	Decimal	—	not editable
123	Prepayment Line	Boolean	—	not editable
124	Prepmt. Amount Inv. Incl. VAT	Decimal	—	not editable
130	IC Partner Code	Code[20]	—	TableRelation Table 413 “IC Partner” (IC Partner)
138	IC Item Reference No.	Code[50]	—
145	Pmt. Discount Amount	Decimal	—
480	Dimension Set ID	Integer	—	TableRelation Table 480 “Dimension Set Entry” (Dimension Set Entry); not editable
1001	Job Task No. Δ BC24 Δ BC26	Code[20]	Specifies the number of the related project task.	TableRelation Table 1001 “Job Task” (“Job Task”.“Job Task No.” where(“Job No.” = field(“Job No.”))); not editable
1002	Job Contract Entry No. Δ BC24 Δ BC26	Integer	Specifies the entry number of the project planning line that the sales line is linked to.
1700	Deferral Code Δ BC26	Code[10]	Specifies the deferral template that governs how revenue earned with this sales document is deferred to the different accounting periods when the good or service was delivered.	TableRelation Table 1700 “Deferral Template” (“Deferral Template”.“Deferral Code”)
1702	Returns Deferral Start Date Δ BC26	Date	Specifies the starting date of the returns deferral period.
5047	Version No.	Integer	—
5048	Doc. No. Occurrence	Integer	—
5402	Variant Code Δ BC26	Code[10]	Specifies the variant of the item on the line.	TableRelation Table 5401 “Item Variant” (if (Type = const(Item)) “Item Variant”.Code where(“Item No.” = field(“No.”)))
5403	Bin Code	Code[20]	—	TableRelation Table 7354 “Bin” (Bin.Code where(“Location Code” = field(“Location Code”)))
5404	Qty. per Unit of Measure Δ BC28	Decimal	—
5405	Planned	Boolean	—
5407	Unit of Measure Code Δ BC26	Code[10]	Specifies how each unit of the item or resource is measured, such as in pieces or hours. By default, the value in the Base Unit of Measure field on the item or resource card is inserted.	TableRelation Table 204 “Unit of Measure”, Table 5404 “Item Unit of Measure” (if (Type = const(Item)) “Item Unit of Measure”.Code where(“Item No.” = field(“No.”)) else “Unit of Measure”)
5415	Quantity (Base) Δ BC28	Decimal	—
5416	Outstanding Qty. (Base) Δ BC28	Decimal	—
5417	Qty. to Invoice (Base) Δ BC28	Decimal	—
5418	Qty. to Ship (Base) Δ BC28	Decimal	—
5458	Qty. Shipped Not Invd. (Base) Δ BC28	Decimal	—
5460	Qty. Shipped (Base) Δ BC28	Decimal	—
5461	Qty. Invoiced (Base) Δ BC28	Decimal	—
5600	FA Posting Date Δ BC26	Date	Specifies the posting date of the related fixed asset transaction, such as a depreciation.
5602	Depreciation Book Code Δ BC26	Code[10]	Specifies the code for the depreciation book to which the line will be posted if you have selected Fixed Asset in the Type field for this line.	TableRelation Table 5611 “Depreciation Book” (Depreciation Book)
5605	Depr. until FA Posting Date Δ BC26	Boolean	Specifies if depreciation was calculated until the FA posting date of the line.
5612	Duplicate in Depreciation Book Δ BC26	Code[10]	Specifies a depreciation book code if you want the journal line to be posted to that depreciation book, as well as to the depreciation book in the Depreciation Book Code field.	TableRelation Table 5611 “Depreciation Book” (Depreciation Book)
5613	Use Duplication List Δ BC26	Boolean	Specifies, if the type is Fixed Asset, that information on the line is to be posted to all the assets defined depreciation books.
5700	Responsibility Center	Code[10]	—	TableRelation Table 5714 “Responsibility Center” (Responsibility Center)
5701	Out-of-Stock Substitution	Boolean	—
5702	Substitution Available Δ BC26	Boolean	Specifies whether a substitute is available for the item.	FlowField: exist(“Item Substitution” where(Type = const(Item), “No.” = field(“No.”), “Substitute Type” = const(Item))); not editable
5703	Originally Ordered No.	Code[20]	—	TableRelation Table 27 “Item” (if (Type = const(Item)) Item)
5704	Originally Ordered Var. Code	Code[10]	—	TableRelation Table 5401 “Item Variant” (if (Type = const(Item)) “Item Variant”.Code where(“Item No.” = field(“Originally Ordered No.”)))
5709	Item Category Code	Code[20]	—	TableRelation Table 5722 “Item Category” (Item Category)
5710	Nonstock Δ BC26	Boolean	Specifies that the item on the sales line is a catalog item, which means it is not normally kept in inventory.
5711	Purchasing Code Δ BC26	Code[10]	Specifies the code for a special procurement method, such as drop shipment.	TableRelation Table 5721 “Purchasing”
5713	Special Order Δ BC26	Boolean	Specifies that the item on the sales line is a special-order item.
5714	Special Order Purchase No.	Code[20]	—	TableRelation Table 38 “Purchase Header” (if (“Special Order” = const(true)) “Purchase Header”.“No.” where(“Document Type” = const(Order)))
5715	Special Order Purch. Line No.	Integer	—	TableRelation Table 39 “Purchase Line” (if (“Special Order” = const(true)) “Purchase Line”.“Line No.” where(“Document Type” = const(Order), “Document No.” = field(“Special Order Purchase No.”)))
5725	Item Reference No. Δ BC26	Code[50]	Specifies the referenced item number.
5726	Item Reference Unit of Measure	Code[10]	Reference Unit of Measure caption	TableRelation Table 5404 “Item Unit of Measure” (if (Type = const(Item)) “Item Unit of Measure”.Code where(“Item No.” = field(“No.”)))
5727	Item Reference Type	Enum “Item Reference Type”	—	enum Enum 5726 “Item Reference Type”
5728	Item Reference Type No.	Code[30]	—
5752	Completely Shipped	Boolean	—
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	Planned Delivery Date Δ BC26	Date	Specifies the planned date that the shipment will be delivered at the customer’s address. If the customer requests a delivery date, the program calculates whether the items will be available for delivery on this date. If the items are available, the planned delivery date will be the same as the requ…
5795	Planned Shipment Date Δ BC26	Date	Specifies the date that the shipment should ship from the warehouse. If the customer requests a delivery date, the program calculates the planned shipment date by subtracting the shipping time from the requested delivery date. If the customer does not request a delivery date or the requested deliver…
5796	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)
5797	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”)))
5800	Allow Item Charge Assignment Δ BC26	Boolean	Specifies that you can assign item charges to this line.
5803	Return Qty. to Receive Δ BC28	Decimal	—
5804	Return Qty. to Receive (Base) Δ BC28	Decimal	—
5805	Return Qty. Rcd. Not Invd. Δ BC28	Decimal	—
5806	Ret. Qty. Rcd. Not Invd.(Base) Δ BC28	Decimal	—
5807	Return Amt. Rcd. Not Invd.	Decimal	—
5808	Ret. Amt. Rcd. Not Invd. (LCY) Δ BC28	Decimal	—
5809	Return Qty. Received Δ BC28	Decimal	—
5810	Return Qty. Received (Base) Δ BC28	Decimal	—
5811	Appl.-from Item Entry Δ BC26	Integer	Specifies the number of the item ledger entry that the document or journal line is applied from.
5909	BOM Item No.	Code[20]	—	TableRelation Table 27 “Item”
6600	Return Receipt No.	Code[20]	—
6601	Return Receipt Line No.	Integer	—
6608	Return Reason Code Δ BC26	Code[10]	Specifies the code explaining why the item was returned.	TableRelation Table 6635 “Return Reason” (Return Reason)
7000	Price Calculation Method	Enum “Price Calculation Method”	—	enum Enum 7000 “Price Calculation Method”
7001	Allow Line Disc.	Boolean	—
7002	Customer Disc. Group	Code[20]	—	TableRelation Table 340 “Customer Discount Group” (Customer Discount Group)

Keys

Key1: Document Type, Document No., Doc. No. Occurrence, Version No., Line No. (clustered)
Key2: Document Type, Document No., Line No., Doc. No. Occurrence, Version No.
Key3: Sell-to Customer No.
Key4: Bill-to Customer No.
Key5: Type, No.
Key6: Document No., Document Type, Doc. No. Occurrence, Version No.

Events published

OnCopyTempLinesOnAfterSalesLineArchiveSetFilters(var SalesLineArchive: Record "Sales Line Archive"; SalesHeaderArchive: Record "Sales Header Archive") (integration): Raises an event after setting filters on the sales line archive record for copying lines.
OnBeforeShowDeferrals(var SalesLineArchive: Record "Sales Line Archive"; var IsHandled: Boolean) (integration): Raises an event before displaying the deferral schedule for the archived sales line.

Procedures

GetCaptionClass(FieldNumber: Integer): Text[80]: Returns the caption class string for the specified field number based on whether prices include VAT.
IsExtendedText(): Boolean: Determines whether this line is an extended text line attached to another document line.
ShowDimensions(): Opens the Dimension Set Entries page to display the dimensions associated with this archived sales line.
ShowLineComments(): Opens the Sales Archive Comment Sheet page to display comments associated with this archived sales line.
ShowDeferrals(): Opens the Deferral Schedule Archive page to display the deferral schedule for this archived sales line.
CopyTempLines(SalesHeaderArchive: Record "Sales Header Archive"; var TempSalesLine: Record "Sales Line" temporary): Copies archived sales lines to a temporary sales line record set for use in document restoration.

Plus 1 local procedures.

Triggers

OnDelete

Relations

Job Task No.: TableRelation Table 1001 “Job Task”
Location Code: TableRelation Table 14 “Location”
No.: TableRelation Table 15 “G/L Account” (conditional)
No.: TableRelation Table 156 “Resource” (conditional)
Job No.: TableRelation Table 167 “Job”
Deferral Code: TableRelation Table 1700 “Deferral Template”
Bill-to Customer No.: TableRelation Table 18 “Customer”
Sell-to Customer No.: TableRelation Table 18 “Customer”
Work Type Code: TableRelation Table 200 “Work Type”
Unit of Measure Code: TableRelation Table 204 “Unit of Measure” (conditional)
Gen. Bus. Posting Group: TableRelation Table 250 “Gen. Business Posting Group”
Gen. Prod. Posting Group: TableRelation Table 251 “Gen. Product Posting Group”
Transaction Type: TableRelation Table 258 “Transaction Type”
Transport Method: TableRelation Table 259 “Transport Method”
BOM Item No.: TableRelation Table 27 “Item”
No.: TableRelation Table 27 “Item” (conditional)
Originally Ordered No.: TableRelation Table 27 “Item”
Exit Point: TableRelation Table 282 “Entry/Exit Point”
Area: TableRelation Table 284 “Area”
Transaction Specification: TableRelation Table 285 “Transaction Specification”
Shipping Agent Code: TableRelation Table 291 “Shipping Agent”
Prepayment Tax Area Code: TableRelation Table 318 “Tax Area”
Tax Area Code: TableRelation Table 318 “Tax Area”
Prepayment Tax Group Code: TableRelation Table 321 “Tax Group”
Tax Group Code: TableRelation Table 321 “Tax Group”
VAT Bus. Posting Group: TableRelation Table 323 “VAT Business Posting Group”
VAT Prod. Posting Group: TableRelation Table 324 “VAT Product 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”
Blanket Order No.: TableRelation Table 36 “Sales Header”
Blanket Order Line No.: TableRelation Table 37 “Sales Line”
Purchase Order No.: TableRelation Table 38 “Purchase Header”
Special Order Purchase No.: TableRelation Table 38 “Purchase Header”
Purch. Order Line No.: TableRelation Table 39 “Purchase Line”
Special Order Purch. Line No.: TableRelation Table 39 “Purchase Line”
Currency Code: TableRelation Table 4 “Currency”
IC Partner Code: TableRelation Table 413 “IC Partner”
Dimension Set ID: TableRelation Table 480 “Dimension Set Entry”
Document No.: TableRelation Table 5107 “Sales Header Archive”
Attached to Line No.: TableRelation Table 5108 “Sales Line Archive”
Originally Ordered Var. Code: TableRelation Table 5401 “Item Variant”
Variant Code: TableRelation Table 5401 “Item Variant”
Item Reference Unit of Measure: TableRelation Table 5404 “Item Unit of Measure”
Unit of Measure Code: TableRelation Table 5404 “Item Unit of Measure” (conditional)
VAT Clause Code: TableRelation Table 560 “VAT Clause”
No.: TableRelation Table 5600 “Fixed Asset” (conditional)
Posting Group: TableRelation Table 5606 “FA Posting Group” (conditional)
Depreciation Book Code: TableRelation Table 5611 “Depreciation Book”
Duplicate in Depreciation Book: TableRelation Table 5611 “Depreciation Book”
Responsibility Center: TableRelation Table 5714 “Responsibility Center”
Substitution Available: CalcFormula Table 5715 “Item Substitution”
Purchasing Code: TableRelation Table 5721 “Purchasing”
Item Category Code: TableRelation Table 5722 “Item Category”
Shipping Agent Service Code: TableRelation Table 5790 “Shipping Agent Services”
No.: TableRelation Table 5800 “Item Charge” (conditional)
Price Group Code: TableRelation Table 6 “Customer Price Group”
Return Reason Code: TableRelation Table 6635 “Return Reason”
No.: TableRelation Table 7 “Standard Text” (conditional)
Bin Code: TableRelation Table 7354 “Bin”
Posting Group: TableRelation Table 94 “Inventory Posting Group” (conditional)

Referenced by

5 fields in 2 objects relate to this table (TableRelation or CalcFormula).

Table 5107 “Sales Header Archive”: Amount, Amount Including VAT, Completely Shipped, Late Order Shipping
Table 5108 “Sales Line Archive”: Attached to Line No.

Pages and codeunits on this table

Page 30213 “APIV2 - Sales Qt. Arch. Lines” (source table)
Page 30215 “APIV2 - S. Ord. Arch. Lines” (source table)
Page 30221 “APIV2 - S. Ret. Ord. A. Lines” (source table)
Page 30229 “APIV2 - S. Bl. O. Arch. Lines” (source table)
Page 5160 “Sales Order Archive Subform” (source table)
Page 5163 “Sales Quote Archive Subform” (source table)
Page 6619 “Sales Line Archive List” (source table)
Page 6621 “Blanket Sales Order Arch. Sub.” (source table)
Page 6628 “Sales Return Order Arc Subform” (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 1720 “Deferral Utilities” (1 call: ShowDeferrals → OpenLineScheduleArchive)
Codeunit 408 “DimensionManagement” (1 call: ShowDimensions → ShowDimensionSet)

Countries that replace it

AT, CA, CH, DE, ES, IT, MX, NO, 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 Line Archive"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.