Table 5108 Sales Line Archive

Base Application, Microsoft.Sales.Archive

176 fields

IdNameTypeVersions
1Document TypeEnum "Sales Document Type"17-29
2Sell-to Customer No.Code[20]17-29
3Document No.Code[20]17-29
4Line No.Integer17-29
5TypeEnum "Sales Line Type"17-29
6No.Code[20]17-29
7Location CodeCode[10]17-29
8Posting GroupCode[20]17-29
9Quantity Disc. CodeCode[20]17-29
10Shipment DateDate17-29
11DescriptionText[100]17-29
12Description 2Text[50]17-29
13Unit of MeasureText[50]17-29
15QuantityDecimal17-29
16Outstanding QuantityDecimal17-29
17Qty. to InvoiceDecimal17-29
18Qty. to ShipDecimal17-29
22Unit PriceDecimal17-29
23Unit Cost (LCY)Decimal17-29
25VAT %Decimal17-29
26Quantity Disc. %Decimal17-29
27Line Discount %Decimal17-29
28Line Discount AmountDecimal17-29
29AmountDecimal17-29
30Amount Including VATDecimal17-29
32Allow Invoice Disc.Boolean17-29
34Gross WeightDecimal17-29
35Net WeightDecimal17-29
36Units per ParcelDecimal17-29
37Unit VolumeDecimal17-29
38Appl.-to Item EntryInteger17-29
40Shortcut Dimension 1 CodeCode[20]17-29
41Shortcut Dimension 2 CodeCode[20]17-29
42Price Group CodeCode[10]17-29
43Allow Quantity Disc.Boolean17-29
45Job No.Code[20]17-29
52Work Type CodeCode[10]17-29
55Cust./Item Disc. %Decimal17-29
57Outstanding AmountDecimal17-29
58Qty. Shipped Not InvoicedDecimal17-29
59Shipped Not InvoicedDecimal17-29
60Quantity ShippedDecimal17-29
61Quantity InvoicedDecimal17-29
63Shipment No.Code[20]17-29
64Shipment Line No.Integer17-29
67Profit %Decimal17-29
68Bill-to Customer No.Code[20]17-29
69Inv. Discount AmountDecimal17-29
71Purchase Order No.Code[20]17-29
72Purch. Order Line No.Integer17-29
73Drop ShipmentBoolean17-29
74Gen. Bus. Posting GroupCode[20]17-29
75Gen. Prod. Posting GroupCode[20]17-29
77VAT Calculation TypeEnum "Tax Calculation Type"17-29
78Transaction TypeCode[10]17-29
79Transport MethodCode[10]17-29
80Attached to Line No.Integer17-29
81Exit PointCode[10]17-29
82AreaCode[10]17-29
83Transaction SpecificationCode[10]17-29
85Tax Area CodeCode[20]17-29
86Tax LiableBoolean17-29
87Tax Group CodeCode[20]17-29
88VAT Clause CodeCode[20]17-29
89VAT Bus. Posting GroupCode[20]17-29
90VAT Prod. Posting GroupCode[20]17-29
91Currency CodeCode[10]17-29
92Outstanding Amount (LCY)Decimal17-29
93Shipped Not Invoiced (LCY)Decimal17-29
96ReserveEnum "Reserve Method"17-29
97Blanket Order No.Code[20]17-29
98Blanket Order Line No.Integer17-29
99VAT Base AmountDecimal17-29
100Unit CostDecimal17-29
101System-Created EntryBoolean17-29
103Line AmountDecimal17-29
104VAT DifferenceDecimal17-29
105Inv. Disc. Amount to InvoiceDecimal17-29
106VAT IdentifierCode[20]17-29
107IC Partner Ref. TypeEnum "IC Partner Reference Type"17-29
108IC Partner ReferenceCode[20]17-29
109Prepayment %Decimal17-29
110Prepmt. Line AmountDecimal17-29
111Prepmt. Amt. Inv.Decimal17-29
112Prepmt. Amt. Incl. VATDecimal17-29
113Prepayment AmountDecimal17-29
114Prepmt. VAT Base Amt.Decimal17-29
115Prepayment VAT %Decimal17-29
116Prepmt. VAT Calc. TypeEnum "Tax Calculation Type"17-29
117Prepayment VAT IdentifierCode[20]17-29
118Prepayment Tax Area CodeCode[20]17-29
119Prepayment Tax LiableBoolean17-29
120Prepayment Tax Group CodeCode[20]17-29
121Prepmt Amt to DeductDecimal17-29
122Prepmt Amt DeductedDecimal17-29
123Prepayment LineBoolean17-29
124Prepmt. Amount Inv. Incl. VATDecimal17-29
130IC Partner CodeCode[20]17-29
138IC Item Reference No.Code[50]17-29
145Pmt. Discount AmountDecimal17-29
480Dimension Set IDInteger17-29
1001Job Task No.Code[20]17-29
1002Job Contract Entry No.Integer17-29
1700Deferral CodeCode[10]17-29
1702Returns Deferral Start DateDate17-29
5047Version No.Integer17-29
5048Doc. No. OccurrenceInteger17-29
5402Variant CodeCode[10]17-29
5403Bin CodeCode[20]17-29
5404Qty. per Unit of MeasureDecimal17-29
5405PlannedBoolean17-29
5407Unit of Measure CodeCode[10]17-29
5415Quantity (Base)Decimal17-29
5416Outstanding Qty. (Base)Decimal17-29
5417Qty. to Invoice (Base)Decimal17-29
5418Qty. to Ship (Base)Decimal17-29
5458Qty. Shipped Not Invd. (Base)Decimal17-29
5460Qty. Shipped (Base)Decimal17-29
5461Qty. Invoiced (Base)Decimal17-29
5600FA Posting DateDate17-29
5602Depreciation Book CodeCode[10]17-29
5605Depr. until FA Posting DateBoolean17-29
5612Duplicate in Depreciation BookCode[10]17-29
5613Use Duplication ListBoolean17-29
5700Responsibility CenterCode[10]17-29
5701Out-of-Stock SubstitutionBoolean17-29
5702Substitution AvailableBoolean17-29
5703Originally Ordered No.Code[20]17-29
5704Originally Ordered Var. CodeCode[10]17-29
5705Cross-Reference No.Code[20]gone after 25
Removed, tag 22.0, obsolete since 18: Cross-Reference replaced by Item Reference feature.
5706Unit of Measure (Cross Ref.)Code[10]gone after 25
Removed, tag 22.0, obsolete since 19: Cross-Reference replaced by Item Reference feature.
5707Cross-Reference TypeOptiongone after 25
Removed, tag 22.0, obsolete since 19: Cross-Reference replaced by Item Reference feature.
5708Cross-Reference Type No.Code[30]gone after 25
Removed, tag 22.0, obsolete since 19: Cross-Reference replaced by Item Reference feature.
5709Item Category CodeCode[20]17-29
5710NonstockBoolean17-29
5711Purchasing CodeCode[10]17-29
5712Product Group CodeCode[10]gone after 25
Removed, tag 15.0, obsolete since 17: Product Groups became first level children of Item Categories.
5713Special OrderBoolean17-29
5714Special Order Purchase No.Code[20]17-29
5715Special Order Purch. Line No.Integer17-29
5725Item Reference No.Code[50]17-29
5726Item Reference Unit of MeasureCode[10]17-29
5727Item Reference TypeEnum "Item Reference Type"17-29
5728Item Reference Type No.Code[30]17-29
5752Completely ShippedBoolean17-29
5790Requested Delivery DateDate17-29
5791Promised Delivery DateDate17-29
5792Shipping TimeDateFormula17-29
5793Outbound Whse. Handling TimeDateFormula17-29
5794Planned Delivery DateDate17-29
5795Planned Shipment DateDate17-29
5796Shipping Agent CodeCode[10]17-29
5797Shipping Agent Service CodeCode[10]17-29
5800Allow Item Charge AssignmentBoolean17-29
5803Return Qty. to ReceiveDecimal17-29
5804Return Qty. to Receive (Base)Decimal17-29
5805Return Qty. Rcd. Not Invd.Decimal17-29
5806Ret. Qty. Rcd. Not Invd.(Base)Decimal17-29
5807Return Amt. Rcd. Not Invd.Decimal17-29
5808Ret. Amt. Rcd. Not Invd. (LCY)Decimal17-29
5809Return Qty. ReceivedDecimal17-29
5810Return Qty. Received (Base)Decimal17-29
5811Appl.-from Item EntryInteger17-29
5900Service Contract No.Code[20]gone after 24
5901Service Order No.Code[20]gone after 24
5902Service Item No.Code[20]gone after 24
5903Appl.-to Service EntryIntegergone after 24
5904Service Item Line No.Integergone after 24
5907Serv. Price Adjmt. Gr. CodeCode[10]gone after 24
5909BOM Item No.Code[20]17-29
6600Return Receipt No.Code[20]17-29
6601Return Receipt Line No.Integer17-29
6608Return Reason CodeCode[10]17-29
7000Price Calculation MethodEnum "Price Calculation Method"17-29
7001Allow Line Disc.Boolean17-29
7002Customer Disc. GroupCode[20]17-29