Table 5107 Sales Header Archive

Base Application, Microsoft.Sales.Archive

172 fields

IdNameTypeVersions
1Document TypeEnum "Sales Document Type"17-29
2Sell-to Customer No.Code[20]17-29
3No.Code[20]17-29
4Bill-to Customer No.Code[20]17-29
5Bill-to NameText[100]17-29
6Bill-to Name 2Text[50]17-29
7Bill-to AddressText[100]17-29
8Bill-to Address 2Text[50]17-29
9Bill-to CityText[30]17-29
10Bill-to ContactText[100]17-29
11Your ReferenceText[35]17-29
12Ship-to CodeCode[10]17-29
13Ship-to NameText[100]17-29
14Ship-to Name 2Text[50]17-29
15Ship-to AddressText[100]17-29
16Ship-to Address 2Text[50]17-29
17Ship-to CityText[30]17-29
18Ship-to ContactText[100]17-29
19Order DateDate17-29
20Posting DateDate17-29
21Shipment DateDate17-29
22Posting DescriptionText[100]17-29
23Payment Terms CodeCode[10]17-29
24Due DateDate17-29
25Payment Discount %Decimal17-29
26Pmt. Discount DateDate17-29
27Shipment Method CodeCode[10]17-29
28Location CodeCode[10]17-29
29Shortcut Dimension 1 CodeCode[20]17-29
30Shortcut Dimension 2 CodeCode[20]17-29
31Customer Posting GroupCode[20]17-29
32Currency CodeCode[10]17-29
33Currency FactorDecimal17-29
34Price Group CodeCode[10]17-29
35Prices Including VATBoolean17-29
37Invoice Disc. CodeCode[20]17-29
40Cust./Item Disc. Gr.Code[20]17-29
41Language CodeCode[10]17-29
42Format RegionText[80]new in 23
43Salesperson CodeCode[20]17-29
45Order ClassCode[10]17-29
46CommentBoolean17-29
47No. PrintedInteger17-29
51On HoldCode[3]17-29
52Applies-to Doc. TypeEnum "Gen. Journal Document Type"17-29
53Applies-to Doc. No.Code[20]17-29
55Bal. Account No.Code[20]17-29
57ShipBoolean17-29
58InvoiceBoolean17-29
60AmountDecimal17-29
61Amount Including VATDecimal17-29
62Shipping No.Code[20]17-29
63Posting No.Code[20]17-29
64Last Shipping No.Code[20]17-29
65Last Posting No.Code[20]17-29
66Prepayment No.Code[20]17-29
67Last Prepayment No.Code[20]17-29
68Prepmt. Cr. Memo No.Code[20]17-29
69Last Prepmt. Cr. Memo No.Code[20]17-29
70VAT Registration No.Text[20]17-29
71Combine ShipmentsBoolean17-29
73Reason CodeCode[10]17-29
74Gen. Bus. Posting GroupCode[20]17-29
75EU 3-Party TradeBoolean17-29
76Transaction TypeCode[10]17-29
77Transport MethodCode[10]17-29
78VAT Country/Region CodeCode[10]17-29
79Sell-to Customer NameText[100]17-29
80Sell-to Customer Name 2Text[50]17-29
81Sell-to AddressText[100]17-29
82Sell-to Address 2Text[50]17-29
83Sell-to CityText[30]17-29
84Sell-to ContactText[100]17-29
85Bill-to Post CodeCode[20]17-29
86Bill-to CountyText[30]17-29
87Bill-to Country/Region CodeCode[10]17-29
88Sell-to Post CodeCode[20]17-29
89Sell-to CountyText[30]17-29
90Sell-to Country/Region CodeCode[10]17-29
91Ship-to Post CodeCode[20]17-29
92Ship-to CountyText[30]17-29
93Ship-to Country/Region CodeCode[10]17-29
94Bal. Account TypeEnum "Payment Balance Account Type"17-29
97Exit PointCode[10]17-29
98CorrectionBoolean17-29
99Document DateDate17-29
100External Document No.Code[35]17-29
101AreaCode[10]17-29
102Transaction SpecificationCode[10]17-29
104Payment Method CodeCode[10]17-29
105Shipping Agent CodeCode[10]17-29
106Package Tracking No.Text[50]17-29changed in 27
107No. SeriesCode[20]17-29
108Posting No. SeriesCode[20]17-29
109Shipping No. SeriesCode[20]17-29
114Tax Area CodeCode[20]17-29
115Tax LiableBoolean17-29
116VAT Bus. Posting GroupCode[20]17-29
117ReserveEnum "Reserve Method"17-29
118Applies-to IDCode[50]17-29
119VAT Base Discount %Decimal17-29
120StatusEnum "Sales Document Status"17-29changed in 18
121Invoice Discount CalculationOption17-29
122Invoice Discount ValueDecimal17-29
123Send IC DocumentBoolean17-29
124IC StatusEnum "Sales Document IC Status"17-29changed in 18
125Sell-to IC Partner CodeCode[20]17-29
126Bill-to IC Partner CodeCode[20]17-29
127IC Reference Document No.Code[20]new in 21
129IC DirectionEnum "IC Direction Type"17-29changed in 21
130Prepayment %Decimal17-29
131Prepayment No. SeriesCode[20]17-29
132Compress PrepaymentBoolean17-29
133Prepayment Due DateDate17-29
134Prepmt. Cr. Memo No. SeriesCode[20]17-29
135Prepmt. Posting DescriptionText[100]17-29
138Prepmt. Pmt. Discount DateDate17-29
139Prepmt. Payment Terms CodeCode[10]17-29
140Prepmt. Payment Discount %Decimal17-29
145No. of Archived VersionsInteger17-29
151Sales Quote No.Code[20]17-29
152Quote Valid Until DateDate17-29
153Quote Sent to CustomerDateTime17-29
154Quote AcceptedBoolean17-29
155Quote Accepted DateDate17-29
163Company Bank Account CodeCode[20]new in 20
165Incoming Document Entry No.Integernew in 24
171Sell-to Phone No.Text[30]17-29
172Sell-to E-MailText[80]17-29
179VAT Reporting DateDatenew in 21
180Rcvd-from Country/Region CodeCode[10]22 to 25
Removed, tag 23.0, obsolete since 22: Use new field on range 181
181Rcvd.-from Count./Region CodeCode[10]new in 22
200Work DescriptionBlob17-29
210Ship-to Phone No.Text[30]new in 25
480Dimension Set IDInteger17-29
827Credit Card No.Code[20]gone after 25
Removed, tag 15.0, obsolete since 17: This field is not needed and it is not used anymore.
3998Source Doc. ExistsBooleannew in 18
3999Last Archived DateDateTimenew in 18
5043Interaction ExistBoolean17-29
5044Time ArchivedTime17-29
5045Date ArchivedDate17-29
5046Archived ByCode[50]17-29
5047Version No.Integer17-29
5048Doc. No. OccurrenceInteger17-29
5050Campaign No.Code[20]17-29
5051Sell-to Customer Template CodeCode[10]gone after 25
Removed, tag 21.0, obsolete since 18: Will be removed with other functionality related to "old" templates. Replaced by "Sell-to Customer Templ. Code".
5052Sell-to Contact No.Code[20]17-29
5053Bill-to Contact No.Code[20]17-29
5054Bill-to Customer Template CodeCode[10]17-29
Removed, tag 25.0, obsolete since 22: Will be removed with other functionality related to "old" templates. Replaced by "Bill-to Customer Templ. Code".
5055Opportunity No.Code[20]17-29
5056Sell-to Customer Templ. CodeCode[20]new in 18
5057Bill-to Customer Templ. CodeCode[20]new in 21
5700Responsibility CenterCode[10]17-29
5750Shipping AdviceEnum "Sales Header Shipping Advice"17-29changed in 18
5752Completely ShippedBoolean17-29
5753Posting from Whse. Ref.Integer17-29
5754Location FilterCode[10]17-29
5790Requested Delivery DateDate17-29
5791Promised Delivery DateDate17-29
5792Shipping TimeDateFormula17-29
5793Outbound Whse. Handling TimeDateFormula17-29
5794Shipping Agent Service CodeCode[10]17-29
5795Late Order ShippingBoolean17-29
5796Date FilterDate17-29
5800ReceiveBoolean17-29
5801Return Receipt No.Code[20]17-29
5802Return Receipt No. SeriesCode[20]17-29
5803Last Return Receipt No.Code[20]17-29
7000Price Calculation MethodEnum "Price Calculation Method"17-29
7001Allow Line Disc.Boolean17-29
7200Get Shipment UsedBoolean17-29
9000Assigned User IDCode[50]17-29