XPT / Schema / Service Header Archive

Service Header Archive #6010

Other table in Microsoft Dynamics 365 Business Central. 159 fields, 0 records in Cronus demo.

159
Fields
0
Records
4
Primary key
6
FlowFields
60
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Document Type, No., Version No., Doc. No. Occurrence.

All fields (159)

Service Header Archive — FIELDS
NO.FIELDTYPECLASSRELATION
1 Document Type PK Option Normal
2 Customer No. Code Normal → Customer #18
3 No. PK Code Normal
4 Bill-to Customer No. Code Normal → Customer #18
5 Bill-to Name Text Normal
6 Bill-to Name 2 Text Normal
7 Bill-to Address Text Normal
8 Bill-to Address 2 Text Normal
9 Bill-to City Text Normal → Post Code #225
10 Bill-to Contact Text Normal
11 Your Reference Text Normal
12 Ship-to Code Code Normal → Ship-to Address #222
13 Ship-to Name Text Normal
14 Ship-to Name 2 Text Normal
15 Ship-to Address Text Normal
16 Ship-to Address 2 Text Normal
17 Ship-to City Text Normal → Post Code #225
18 Ship-to Contact Text Normal
19 Order Date Date Normal
20 Posting Date Date Normal
22 Posting Description Text Normal
23 Payment Terms Code Code Normal → Payment Terms #3
24 Due Date Date Normal
25 Payment Discount % Decimal Normal
26 Pmt. Discount Date Date Normal
27 Shipment Method Code Code Normal → Shipment Method #10
28 Location Code Code Normal → Location #14
29 Shortcut Dimension 1 Code Code Normal → Dimension Value #349
30 Shortcut Dimension 2 Code Code Normal → Dimension Value #349
31 Customer Posting Group Code Normal → Customer Posting Group #92
32 Currency Code Code Normal → Currency #4
33 Currency Factor Decimal Normal
34 Customer Price Group Code Normal → Customer Price Group #6
35 Prices Including VAT Boolean Normal
37 Invoice Disc. Code Code Normal
40 Customer Disc. Group Code Normal → Customer Discount Group #340
41 Language Code Code Normal → Language #8
42 Format Region Text Normal
43 Salesperson Code Code Normal → Salesperson/Purchaser #13
46 Comment ⚡ FLOW Boolean FlowField
47 No. Printed Integer Normal
52 Applies-to Doc. Type Option Normal
53 Applies-to Doc. No. Code Normal
55 Bal. Account No. Code Normal
62 Shipping No. Code Normal
63 Posting No. Code Normal
64 Last Shipping No. Code Normal → Service Shipment Header #5990
65 Last Posting No. Code Normal → Service Invoice Header #5992
70 VAT Registration No. Text Normal
71 Combine Shipments Boolean Normal
73 Reason Code Code Normal → Reason Code #231
74 Gen. Bus. Posting Group Code Normal → Gen. Business Posting Group #250
75 EU 3-Party Trade Boolean Normal
76 Transaction Type Code Normal → Transaction Type #258
77 Transport Method Code Normal → Transport Method #259
78 VAT Country/Region Code Code Normal → Country/Region #9
79 Name Text Normal
80 Name 2 Text Normal
81 Address Text Normal
82 Address 2 Text Normal
83 City Text Normal → Post Code #225
84 Contact Name Text Normal
85 Bill-to Post Code Code Normal → Post Code #225
86 Bill-to County Text Normal
87 Bill-to Country/Region Code Code Normal → Country/Region #9
88 Post Code Code Normal → Post Code #225
89 County Text Normal
90 Country/Region Code Code Normal → Country/Region #9
91 Ship-to Post Code Code Normal → Post Code #225
92 Ship-to County Text Normal
93 Ship-to Country/Region Code Code Normal → Country/Region #9
94 Bal. Account Type Option Normal
97 Exit Point Code Normal → Entry/Exit Point #282
98 Correction Boolean Normal
99 Document Date Date Normal
100 External Document No. Code Normal
101 Area Code Normal → Area #284
102 Transaction Specification Code Normal → Transaction Specification #285
104 Payment Method Code Code Normal → Payment Method #289
105 Shipping Agent Code Code Normal → Shipping Agent #291
107 No. Series Code Normal → No. Series #308
108 Posting No. Series Code Normal → No. Series #308
109 Shipping No. Series Code Normal → No. Series #308
114 Tax Area Code Code Normal → Tax Area #318
115 Tax Liable Boolean Normal
116 VAT Bus. Posting Group Code Normal → VAT Business Posting Group #323
117 Reserve Option Normal
118 Applies-to ID Code Normal
119 VAT Base Discount % Decimal Normal
120 Status Option Normal
121 Invoice Discount Calculation Option Normal
122 Invoice Discount Value Decimal Normal
129 Bank Account Code Code Normal → Bank Account #270
130 Release Status Option Normal
131 VAT Date Date Normal
145 No. of Archived Versions ⚡ FLOW Integer FlowField
165 Incoming Document Entry No. Integer Normal → Incoming Document #130
178 Journal Template Name Code Normal → Gen. Journal Template #80
200 Work Description BLOB Normal
480 Dimension Set ID Integer Normal → Dimension Set Entry #480
1200 Direct Debit Mandate ID Code Normal → SEPA Direct Debit Mandate #1230
3998 Source Doc. Exists ⚡ FLOW Boolean FlowField
3999 Last Archived Date ⚡ FLOW DateTime FlowField
5043 Interaction Exist Boolean Normal
5044 Time Archived Time Normal
5045 Date Archived Date Normal
5046 Archived By Code Normal
5047 Version No. PK Integer Normal
5048 Doc. No. Occurrence PK Integer Normal
5052 Contact No. Code Normal → Contact #5050
5053 Bill-to Contact No. Code Normal → Contact #5050
5700 Responsibility Center Code Normal → Responsibility Center #5714
5750 Shipping Advice Option Normal
5754 Location Filter Code FlowFilter → Location #14
5792 Shipping Time DateFormula Normal
5794 Shipping Agent Service Code Code Normal → Shipping Agent Services #5790
5796 Date Filter Date FlowFilter
5902 Description Text Normal
5904 Service Order Type Code Normal → Service Order Type #5903
5905 Link Service to Service Item Boolean Normal
5907 Priority Option Normal
5911 Allocated Hours ⚡ FLOW Decimal FlowField
5915 Phone No. Text Normal
5916 Email Text Normal
5917 Phone No. 2 Text Normal
5918 Fax No. Text Normal
5921 No. of Unallocated Items Integer Normal
5923 Order Time Time Normal
5924 Default Response Time (Hours) Decimal Normal
5925 Actual Response Time (Hours) Decimal Normal
5926 Service Time (Hours) Decimal Normal
5927 Response Date Date Normal
5928 Response Time Time Normal
5929 Starting Date Date Normal
5930 Starting Time Time Normal
5931 Finishing Date Date Normal
5932 Finishing Time Time Normal
5936 Notify Customer Option Normal
5937 Max. Labor Unit Price Decimal Normal
5938 Warning Status Option Normal
5939 No. of Allocations ⚡ FLOW Integer FlowField
5940 Contract No. Code Normal → Service Contract Header #5965
5953 Resource Filter Code FlowFilter → Resource #156
5955 Ship-to Fax No. Text Normal
5956 Ship-to Email Text Normal
5957 Resource Group Filter Code FlowFilter → Resource Group #152
5958 Ship-to Phone Text Normal
5959 Ship-to Phone 2 Text Normal
5968 Service Zone Code Code Normal → Service Zone #5957
5981 Expected Finishing Date Date Normal
7000 Price Calculation Method Option Normal
7001 Allow Line Disc. Boolean Normal
9000 Assigned User ID Code Normal → User Setup #91
9001 Service Quote No. Code Normal
2000000000 System ID GUID Normal
2000000001 Created At DateTime Normal
2000000002 Created By GUID Normal
2000000003 Modified At DateTime Normal
2000000004 Modified By GUID Normal

Related tables (44)

Tables referenced by fields on the Service Header Archive table through TableRelation properties.

Customer
#18 · Sales · via Customer No., Bill-to Customer No.
Post Code
#225 · Other · via Bill-to City, Ship-to City, City, Bill-to Post Code, Post Code, Ship-to Post Code
Ship-to Address
#222 · Other · via Ship-to Code
Payment Terms
#3 · General Ledger · via Payment Terms Code
Shipment Method
#10 · General Ledger · via Shipment Method Code
Location
#14 · General Ledger · via Location Code, Location Filter
Dimension Value
#349 · Dimensions · via Shortcut Dimension 1 Code, Shortcut Dimension 2 Code
Customer Posting Group
#92 · Other · via Customer Posting Group
Currency
#4 · General Ledger · via Currency Code
Customer Price Group
#6 · General Ledger · via Customer Price Group
Customer Discount Group
#340 · Other · via Customer Disc. Group
Language
#8 · General Ledger · via Language Code
Salesperson/Purchaser
#13 · General Ledger · via Salesperson Code
Service Shipment Header
#5990 · Service · via Last Shipping No.
Service Invoice Header
#5992 · Service · via Last Posting No.
Reason Code
#231 · Other · via Reason Code
Gen. Business Posting Group
#250 · Other · via Gen. Bus. Posting Group
Transaction Type
#258 · Other · via Transaction Type
Transport Method
#259 · Other · via Transport Method
Country/Region
#9 · General Ledger · via VAT Country/Region Code, Bill-to Country/Region Code, Country/Region Code, Ship-to Country/Region Code
Entry/Exit Point
#282 · Other · via Exit Point
Area
#284 · Other · via Area
Transaction Specification
#285 · Other · via Transaction Specification
Payment Method
#289 · Other · via Payment Method Code
Shipping Agent
#291 · Other · via Shipping Agent Code
No. Series
#308 · Other · via No. Series, Posting No. Series, Shipping No. Series
Tax Area
#318 · Other · via Tax Area Code
VAT Business Posting Group
#323 · Other · via VAT Bus. Posting Group
Bank Account
#270 · Other · via Bank Account Code
Incoming Document
#130 · Other · via Incoming Document Entry No.
Gen. Journal Template
#80 · Other · via Journal Template Name
Dimension Set Entry
#480 · Dimensions · via Dimension Set ID
SEPA Direct Debit Mandate
#1230 · Other · via Direct Debit Mandate ID
Contact
#5050 · Other · via Contact No., Bill-to Contact No.
Responsibility Center
#5714 · Other · via Responsibility Center
Shipping Agent Services
#5790 · Other · via Shipping Agent Service Code
Service Order Type
#5903 · Service · via Service Order Type
Service Contract Header
#5965 · Service · via Contract No.
Resource
#156 · Other · via Resource Filter
Resource Group
#152 · Other · via Resource Group Filter
Service Zone
#5957 · Service · via Service Zone Code
User Setup
#91 · Other · via Assigned User ID

© 2026 Xpertly Ltd · Company No. 14753894 · VAT No. 452840787

HomeData ExplorerPricingPrivacyTerms