Objects/Tables/Table 5107 Sales Header Archive

Fields, 172

Jonas Paprotka, Base Application 28.5.54151.54365, versions 17-28, checked 2026-09-20

Id	Name	Type	Versions	Obsolete
1	Document Type	Enum Sales Document Type	17-28	-
2	Sell-to Customer No.	Code[20]	17-28	-
3	No.	Code[20]	17-28	-
4	Bill-to Customer No.	Code[20]	17-28	-
5	Bill-to Name	Text[100]	17-28	-
6	Bill-to Name 2	Text[50]	17-28	-
7	Bill-to Address	Text[100]	17-28	-
8	Bill-to Address 2	Text[50]	17-28	-
9	Bill-to City	Text[30]	17-28	-
10	Bill-to Contact	Text[100]	17-28	-
11	Your Reference	Text[35]	17-28	-
12	Ship-to Code	Code[10]	17-28	-
13	Ship-to Name	Text[100]	17-28	-
14	Ship-to Name 2	Text[50]	17-28	-
15	Ship-to Address	Text[100]	17-28	-
16	Ship-to Address 2	Text[50]	17-28	-
17	Ship-to City	Text[30]	17-28	-
18	Ship-to Contact	Text[100]	17-28	-
19	Order Date	Date	17-28	-
20	Posting Date	Date	17-28	-
21	Shipment Date	Date	17-28	-
22	Posting Description	Text[100]	17-28	-
23	Payment Terms Code	Code[10]	17-28	-
24	Due Date	Date	17-28	-
25	Payment Discount %	Decimal	17-28	-
26	Pmt. Discount Date	Date	17-28	-
27	Shipment Method Code	Code[10]	17-28	-
28	Location Code	Code[10]	17-28	-
29	Shortcut Dimension 1 Code	Code[20]	17-28	-
30	Shortcut Dimension 2 Code	Code[20]	17-28	-
31	Customer Posting Group	Code[20]	17-28	-
32	Currency Code	Code[10]	17-28	-
33	Currency Factor	Decimal	17-28	-
34	Price Group Code	Code[10]	17-28	-
35	Prices Including VAT	Boolean	17-28	-
37	Invoice Disc. Code	Code[20]	17-28	-
40	Cust./Item Disc. Gr.	Code[20]	17-28	-
41	Language Code	Code[10]	17-28	-
42	Format Region	Text[80]	23-28	-
43	Salesperson Code	Code[20]	17-28	-
45	Order Class	Code[10]	17-28	-
46	Comment	Boolean	17-28	-
47	No. Printed	Integer	17-28	-
51	On Hold	Code[3]	17-28	-
52	Applies-to Doc. Type	Enum Gen. Journal Document Type	17-28	-
53	Applies-to Doc. No.	Code[20]	17-28	-
55	Bal. Account No.	Code[20]	17-28	-
57	Ship	Boolean	17-28	-
58	Invoice	Boolean	17-28	-
60	Amount	Decimal	17-28	-
61	Amount Including VAT	Decimal	17-28	-
62	Shipping No.	Code[20]	17-28	-
63	Posting No.	Code[20]	17-28	-
64	Last Shipping No.	Code[20]	17-28	-
65	Last Posting No.	Code[20]	17-28	-
66	Prepayment No.	Code[20]	17-28	-
67	Last Prepayment No.	Code[20]	17-28	-
68	Prepmt. Cr. Memo No.	Code[20]	17-28	-
69	Last Prepmt. Cr. Memo No.	Code[20]	17-28	-
70	VAT Registration No.	Text[20]	17-28	-
71	Combine Shipments	Boolean	17-28	-
73	Reason Code	Code[10]	17-28	-
74	Gen. Bus. Posting Group	Code[20]	17-28	-
75	EU 3-Party Trade	Boolean	17-28	-
76	Transaction Type	Code[10]	17-28	-
77	Transport Method	Code[10]	17-28	-
78	VAT Country/Region Code	Code[10]	17-28	-
79	Sell-to Customer Name	Text[100]	17-28	-
80	Sell-to Customer Name 2	Text[50]	17-28	-
81	Sell-to Address	Text[100]	17-28	-
82	Sell-to Address 2	Text[50]	17-28	-
83	Sell-to City	Text[30]	17-28	-
84	Sell-to Contact	Text[100]	17-28	-
85	Bill-to Post Code	Code[20]	17-28	-
86	Bill-to County	Text[30]	17-28	-
87	Bill-to Country/Region Code	Code[10]	17-28	-
88	Sell-to Post Code	Code[20]	17-28	-
89	Sell-to County	Text[30]	17-28	-
90	Sell-to Country/Region Code	Code[10]	17-28	-
91	Ship-to Post Code	Code[20]	17-28	-
92	Ship-to County	Text[30]	17-28	-
93	Ship-to Country/Region Code	Code[10]	17-28	-
94	Bal. Account Type	Enum Payment Balance Account Type	17-28	-
97	Exit Point	Code[10]	17-28	-
98	Correction	Boolean	17-28	-
99	Document Date	Date	17-28	-
100	External Document No.	Code[35]	17-28	-
101	Area	Code[10]	17-28	-
102	Transaction Specification	Code[10]	17-28	-
104	Payment Method Code	Code[10]	17-28	-
105	Shipping Agent Code	Code[10]	17-28	-
106	Package Tracking No.	Text[50]	17-28	-
107	No. Series	Code[20]	17-28	-
108	Posting No. Series	Code[20]	17-28	-
109	Shipping No. Series	Code[20]	17-28	-
114	Tax Area Code	Code[20]	17-28	-
115	Tax Liable	Boolean	17-28	-
116	VAT Bus. Posting Group	Code[20]	17-28	-
117	Reserve	Enum Reserve Method	17-28	-
118	Applies-to ID	Code[50]	17-28	-
119	VAT Base Discount %	Decimal	17-28	-
120	Status	Enum Sales Document Status	17-28	-
121	Invoice Discount Calculation	Option	17-28	-
122	Invoice Discount Value	Decimal	17-28	-
123	Send IC Document	Boolean	17-28	-
124	IC Status	Enum Sales Document IC Status	17-28	-
125	Sell-to IC Partner Code	Code[20]	17-28	-
126	Bill-to IC Partner Code	Code[20]	17-28	-
127	IC Reference Document No.	Code[20]	21-28	-
129	IC Direction	Enum IC Direction Type	17-28	-
130	Prepayment %	Decimal	17-28	-
131	Prepayment No. Series	Code[20]	17-28	-
132	Compress Prepayment	Boolean	17-28	-
133	Prepayment Due Date	Date	17-28	-
134	Prepmt. Cr. Memo No. Series	Code[20]	17-28	-
135	Prepmt. Posting Description	Text[100]	17-28	-
138	Prepmt. Pmt. Discount Date	Date	17-28	-
139	Prepmt. Payment Terms Code	Code[10]	17-28	-
140	Prepmt. Payment Discount %	Decimal	17-28	-
145	No. of Archived Versions	Integer	17-28	-
151	Sales Quote No.	Code[20]	17-28	-
152	Quote Valid Until Date	Date	17-28	-
153	Quote Sent to Customer	DateTime	17-28	-
154	Quote Accepted	Boolean	17-28	-
155	Quote Accepted Date	Date	17-28	-
163	Company Bank Account Code	Code[20]	20-28	-
165	Incoming Document Entry No.	Integer	24-28	-
171	Sell-to Phone No.	Text[30]	17-28	-
172	Sell-to E-Mail	Text[80]	17-28	-
179	VAT Reporting Date	Date	21-28	-
180	Rcvd-from Country/Region Code	Code[10]	22-25, gone	Removed 23.0
Use new field on range 181
181	Rcvd.-from Count./Region Code	Code[10]	22-28	-
200	Work Description	Blob	17-28	-
210	Ship-to Phone No.	Text[30]	25-28	-
480	Dimension Set ID	Integer	17-28	-
827	Credit Card No.	Code[20]	17-25, gone	Removed 15.0
This field is not needed and it is not used anymore.
3998	Source Doc. Exists	Boolean	18-28	-
3999	Last Archived Date	DateTime	18-28	-
5043	Interaction Exist	Boolean	17-28	-
5044	Time Archived	Time	17-28	-
5045	Date Archived	Date	17-28	-
5046	Archived By	Code[50]	17-28	-
5047	Version No.	Integer	17-28	-
5048	Doc. No. Occurrence	Integer	17-28	-
5050	Campaign No.	Code[20]	17-28	-
5051	Sell-to Customer Template Code	Code[10]	17-25, gone	Removed 21.0
Will be removed with other functionality related to "old" templates. Replaced by "Sell-to Customer Templ. Code".
5052	Sell-to Contact No.	Code[20]	17-28	-
5053	Bill-to Contact No.	Code[20]	17-28	-
5054	Bill-to Customer Template Code	Code[10]	17-28	Removed 25.0
Will be removed with other functionality related to "old" templates. Replaced by "Bill-to Customer Templ. Code".
5055	Opportunity No.	Code[20]	17-28	-
5056	Sell-to Customer Templ. Code	Code[20]	18-28	-
5057	Bill-to Customer Templ. Code	Code[20]	21-28	-
5700	Responsibility Center	Code[10]	17-28	-
5750	Shipping Advice	Enum Sales Header Shipping Advice	17-28	-
5752	Completely Shipped	Boolean	17-28	-
5753	Posting from Whse. Ref.	Integer	17-28	-
5754	Location Filter	Code[10]	17-28	-
5790	Requested Delivery Date	Date	17-28	-
5791	Promised Delivery Date	Date	17-28	-
5792	Shipping Time	DateFormula	17-28	-
5793	Outbound Whse. Handling Time	DateFormula	17-28	-
5794	Shipping Agent Service Code	Code[10]	17-28	-
5795	Late Order Shipping	Boolean	17-28	-
5796	Date Filter	Date	17-28	-
5800	Receive	Boolean	17-28	-
5801	Return Receipt No.	Code[20]	17-28	-
5802	Return Receipt No. Series	Code[20]	17-28	-
5803	Last Return Receipt No.	Code[20]	17-28	-
7000	Price Calculation Method	Enum Price Calculation Method	17-28	-
7001	Allow Line Disc.	Boolean	17-28	-
7200	Get Shipment Used	Boolean	17-28	-
9000	Assigned User ID	Code[50]	17-28	-