Objects/Tables/Table 5108 Sales Line Archive

Table 5108 Sales Line Archive in 26

Jonas Paprotka, Base Application 26.5.38752.40541, checked 2026-09-20

App: Base Application
Namespace: Microsoft.Sales.Archive

Fields, 165 Keys, 6 Procedures, 6 Events, 2

Versions17 18 19 20 21 22 23 24 252627 28 latest

Source29

Fields, 165

Id	Name	Type	Obsolete
1	Document Type	Enum Sales Document Type	-
2	Sell-to Customer No.	Code[20]	-
3	Document No.	Code[20]	-
4	Line No.	Integer	-
5	Type	Enum Sales Line Type	-
6	No.	Code[20]	-
7	Location Code	Code[10]	-
8	Posting Group	Code[20]	-
9	Quantity Disc. Code	Code[20]	-
10	Shipment Date	Date	-
11	Description	Text[100]	-
12	Description 2	Text[50]	-
13	Unit of Measure	Text[50]	-
15	Quantity	Decimal	-
16	Outstanding Quantity	Decimal	-
17	Qty. to Invoice	Decimal	-
18	Qty. to Ship	Decimal	-
22	Unit Price	Decimal	-
23	Unit Cost (LCY)	Decimal	-
25	VAT %	Decimal	-
26	Quantity Disc. %	Decimal	-
27	Line Discount %	Decimal	-
28	Line Discount Amount	Decimal	-
29	Amount	Decimal	-
30	Amount Including VAT	Decimal	-
32	Allow Invoice Disc.	Boolean	-
34	Gross Weight	Decimal	-
35	Net Weight	Decimal	-
36	Units per Parcel	Decimal	-
37	Unit Volume	Decimal	-
38	Appl.-to Item Entry	Integer	-
40	Shortcut Dimension 1 Code	Code[20]	-
41	Shortcut Dimension 2 Code	Code[20]	-
42	Price Group Code	Code[10]	-
43	Allow Quantity Disc.	Boolean	-
45	Job No.	Code[20]	-
52	Work Type Code	Code[10]	-
55	Cust./Item Disc. %	Decimal	-
57	Outstanding Amount	Decimal	-
58	Qty. Shipped Not Invoiced	Decimal	-
59	Shipped Not Invoiced	Decimal	-
60	Quantity Shipped	Decimal	-
61	Quantity Invoiced	Decimal	-
63	Shipment No.	Code[20]	-
64	Shipment Line No.	Integer	-
67	Profit %	Decimal	-
68	Bill-to Customer No.	Code[20]	-
69	Inv. Discount Amount	Decimal	-
71	Purchase Order No.	Code[20]	-
72	Purch. Order Line No.	Integer	-
73	Drop Shipment	Boolean	-
74	Gen. Bus. Posting Group	Code[20]	-
75	Gen. Prod. Posting Group	Code[20]	-
77	VAT Calculation Type	Enum Tax Calculation Type	-
78	Transaction Type	Code[10]	-
79	Transport Method	Code[10]	-
80	Attached to Line No.	Integer	-
81	Exit Point	Code[10]	-
82	Area	Code[10]	-
83	Transaction Specification	Code[10]	-
85	Tax Area Code	Code[20]	-
86	Tax Liable	Boolean	-
87	Tax Group Code	Code[20]	-
88	VAT Clause Code	Code[20]	-
89	VAT Bus. Posting Group	Code[20]	-
90	VAT Prod. Posting Group	Code[20]	-
91	Currency Code	Code[10]	-
92	Outstanding Amount (LCY)	Decimal	-
93	Shipped Not Invoiced (LCY)	Decimal	-
96	Reserve	Enum Reserve Method	-
97	Blanket Order No.	Code[20]	-
98	Blanket Order Line No.	Integer	-
99	VAT Base Amount	Decimal	-
100	Unit Cost	Decimal	-
101	System-Created Entry	Boolean	-
103	Line Amount	Decimal	-
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	-
108	IC Partner Reference	Code[20]	-
109	Prepayment %	Decimal	-
110	Prepmt. Line Amount	Decimal	-
111	Prepmt. Amt. Inv.	Decimal	-
112	Prepmt. Amt. Incl. VAT	Decimal	-
113	Prepayment Amount	Decimal	-
114	Prepmt. VAT Base Amt.	Decimal	-
115	Prepayment VAT %	Decimal	-
116	Prepmt. VAT Calc. Type	Enum Tax Calculation Type	-
117	Prepayment VAT Identifier	Code[20]	-
118	Prepayment Tax Area Code	Code[20]	-
119	Prepayment Tax Liable	Boolean	-
120	Prepayment Tax Group Code	Code[20]	-
121	Prepmt Amt to Deduct	Decimal	-
122	Prepmt Amt Deducted	Decimal	-
123	Prepayment Line	Boolean	-
124	Prepmt. Amount Inv. Incl. VAT	Decimal	-
130	IC Partner Code	Code[20]	-
138	IC Item Reference No.	Code[50]	-
145	Pmt. Discount Amount	Decimal	-
480	Dimension Set ID	Integer	-
1001	Job Task No.	Code[20]	-
1002	Job Contract Entry No.	Integer	-
1700	Deferral Code	Code[10]	-
1702	Returns Deferral Start Date	Date	-
5047	Version No.	Integer	-
5048	Doc. No. Occurrence	Integer	-
5402	Variant Code	Code[10]	-
5403	Bin Code	Code[20]	-
5404	Qty. per Unit of Measure	Decimal	-
5405	Planned	Boolean	-
5407	Unit of Measure Code	Code[10]	-
5415	Quantity (Base)	Decimal	-
5416	Outstanding Qty. (Base)	Decimal	-
5417	Qty. to Invoice (Base)	Decimal	-
5418	Qty. to Ship (Base)	Decimal	-
5458	Qty. Shipped Not Invd. (Base)	Decimal	-
5460	Qty. Shipped (Base)	Decimal	-
5461	Qty. Invoiced (Base)	Decimal	-
5600	FA Posting Date	Date	-
5602	Depreciation Book Code	Code[10]	-
5605	Depr. until FA Posting Date	Boolean	-
5612	Duplicate in Depreciation Book	Code[10]	-
5613	Use Duplication List	Boolean	-
5700	Responsibility Center	Code[10]	-
5701	Out-of-Stock Substitution	Boolean	-
5702	Substitution Available	Boolean	-
5703	Originally Ordered No.	Code[20]	-
5704	Originally Ordered Var. Code	Code[10]	-
5709	Item Category Code	Code[20]	-
5710	Nonstock	Boolean	-
5711	Purchasing Code	Code[10]	-
5713	Special Order	Boolean	-
5714	Special Order Purchase No.	Code[20]	-
5715	Special Order Purch. Line No.	Integer	-
5725	Item Reference No.	Code[50]	-
5726	Item Reference Unit of Measure	Code[10]	-
5727	Item Reference Type	Enum Item Reference Type	-
5728	Item Reference Type No.	Code[30]	-
5752	Completely Shipped	Boolean	-
5790	Requested Delivery Date	Date	-
5791	Promised Delivery Date	Date	-
5792	Shipping Time	DateFormula	-
5793	Outbound Whse. Handling Time	DateFormula	-
5794	Planned Delivery Date	Date	-
5795	Planned Shipment Date	Date	-
5796	Shipping Agent Code	Code[10]	-
5797	Shipping Agent Service Code	Code[10]	-
5800	Allow Item Charge Assignment	Boolean	-
5803	Return Qty. to Receive	Decimal	-
5804	Return Qty. to Receive (Base)	Decimal	-
5805	Return Qty. Rcd. Not Invd.	Decimal	-
5806	Ret. Qty. Rcd. Not Invd.(Base)	Decimal	-
5807	Return Amt. Rcd. Not Invd.	Decimal	-
5808	Ret. Amt. Rcd. Not Invd. (LCY)	Decimal	-
5809	Return Qty. Received	Decimal	-
5810	Return Qty. Received (Base)	Decimal	-
5811	Appl.-from Item Entry	Integer	-
5909	BOM Item No.	Code[20]	-
6600	Return Receipt No.	Code[20]	-
6601	Return Receipt Line No.	Integer	-
6608	Return Reason Code	Code[10]	-
7000	Price Calculation Method	Enum Price Calculation Method	-
7001	Allow Line Disc.	Boolean	-
7002	Customer Disc. Group	Code[20]	-

Keys, 6

Name	Fields	Obsolete
Key1, clustered	Document Type, Document No., Doc. No. Occurrence, Version No., Line No.	-
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.	-

Procedures, 6

Name	Parameters	Returns	Access	Obsolete
GetCaptionClass	(Integer)	Text[80]	public	-
ShowDimensions	()		public	-
ShowLineComments	()		public	-
ShowDeferrals	()		public	-
CopyTempLines	(Record Sales Header Archive, var Record Sales Line)		public	-
IsExtendedText	()	Boolean	public	-

Events, 2

Kind	Name	Parameters	Obsolete
Integration event	OnCopyTempLinesOnAfterSalesLineArchiveSetFilters	(var Record Sales Line Archive, Record Sales Header Archive)	-
Integration event	OnBeforeShowDeferrals	(var Record Sales Line Archive, var Boolean)	-