Table 5109 Purchase Header Archive

Base Application, Microsoft.Purchases.Archive

156 fields

IdNameTypeVersions
1Document TypeEnum "Purchase Document Type"17-29
2Buy-from Vendor No.Code[20]17-29
3No.Code[20]17-29
4Pay-to Vendor No.Code[20]17-29
5Pay-to NameText[100]17-29
6Pay-to Name 2Text[50]17-29
7Pay-to AddressText[100]17-29
8Pay-to Address 2Text[50]17-29
9Pay-to CityText[30]17-29
10Pay-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
21Expected Receipt 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
31Vendor Posting GroupCode[20]17-29
32Currency CodeCode[10]17-29
33Currency FactorDecimal17-29
35Prices Including VATBoolean17-29
37Invoice Disc. CodeCode[20]17-29
41Language CodeCode[10]17-29
42Format RegionText[80]new in 23
43Purchaser 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
57ReceiveBoolean17-29
58InvoiceBoolean17-29
60AmountDecimal17-29
61Amount Including VATDecimal17-29
62Receiving No.Code[20]17-29
63Posting No.Code[20]17-29
64Last Receiving No.Code[20]17-29
65Last Posting No.Code[20]17-29
66Vendor Order No.Code[35]17-29
67Vendor Shipment No.Code[35]17-29
68Vendor Invoice No.Code[35]17-29
69Vendor Cr. Memo No.Code[35]17-29
70VAT Registration No.Text[20]17-29
72Sell-to Customer No.Code[20]17-29
73Reason CodeCode[10]17-29
74Gen. Bus. Posting GroupCode[20]17-29
76Transaction TypeCode[10]17-29
77Transport MethodCode[10]17-29
78VAT Country/Region CodeCode[10]17-29
79Buy-from Vendor NameText[100]17-29
80Buy-from Vendor Name 2Text[50]17-29
81Buy-from AddressText[100]17-29
82Buy-from Address 2Text[50]17-29
83Buy-from CityText[30]17-29
84Buy-from ContactText[100]17-29
85Pay-to Post CodeCode[20]17-29
86Pay-to CountyText[30]17-29
87Pay-to Country/Region CodeCode[10]17-29
88Buy-from Post CodeCode[20]17-29
89Buy-from CountyText[30]17-29
90Buy-from 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
95Order Address CodeCode[10]17-29
97Entry PointCode[10]17-29
98CorrectionBoolean17-29
99Document DateDate17-29
101AreaCode[10]17-29
102Transaction SpecificationCode[10]17-29
104Payment Method CodeCode[10]17-29
107No. SeriesCode[20]17-29
108Posting No. SeriesCode[20]17-29
109Receiving No. SeriesCode[20]17-29
114Tax Area CodeCode[20]17-29
115Tax LiableBoolean17-29
116VAT Bus. Posting GroupCode[20]17-29
118Applies-to IDCode[50]17-29
119VAT Base Discount %Decimal17-29
120StatusEnum "Purchase Document Status"17-29changed in 23
121Invoice Discount CalculationOption17-29
122Invoice Discount ValueDecimal17-29
123Send IC DocumentBoolean17-29
124IC StatusEnum "Purchase Document IC Status"17-29changed in 18
125Buy-from IC Partner CodeCode[20]17-29
126Pay-to IC Partner CodeCode[20]17-29
127IC Reference Document No.Code[20]new in 22
129IC DirectionEnum "IC Direction Type"17-29changed in 21
130Prepayment No.Code[20]17-29
131Last Prepayment No.Code[20]17-29
132Prepmt. Cr. Memo No.Code[20]17-29
133Last Prepmt. Cr. Memo No.Code[20]17-29
134Prepayment %Decimal17-29
135Prepayment No. SeriesCode[20]17-29
136Compress PrepaymentBoolean17-29
137Prepayment Due DateDate17-29
138Prepmt. Cr. Memo No. SeriesCode[20]17-29
139Prepmt. Posting DescriptionText[100]17-29
142Prepmt. Pmt. Discount DateDate17-29
143Prepmt. Payment Terms CodeCode[10]17-29
144Prepmt. Payment Discount %Decimal17-29
145No. of Archived VersionsInteger17-29
146Spend Request No.Code[20]new in 29
147Spend Request CloseBooleannew in 29
151Purchase Quote No.Code[20]17-29
165Incoming Document Entry No.Integernew in 24
179VAT Reporting DateDatenew in 21
210Ship-to Phone No.Text[30]new in 25
480Dimension Set IDInteger17-29
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
5052Buy-from Contact No.Code[20]17-29
5053Pay-to Contact No.Code[20]17-29
5700Responsibility CenterCode[10]17-29
5752Completely ReceivedBoolean17-29
5753Posting from Whse. Ref.Integer17-29
5754Location FilterCode[10]17-29
5790Requested Receipt DateDate17-29
5791Promised Receipt DateDate17-29
5792Lead Time CalculationDateFormula17-29
5793Inbound Whse. Handling TimeDateFormula17-29
5796Date FilterDate17-29
5800Vendor Authorization No.Code[35]17-29
5801Return Shipment No.Code[20]17-29
5802Return Shipment No. SeriesCode[20]17-29
5803ShipBoolean17-29
5804Last Return Shipment No.Code[20]17-29
7000Price Calculation MethodEnum "Price Calculation Method"17-29
9000Assigned User IDCode[50]17-29
10005Ship-to UPS ZoneCode[2]17-29
10017Provincial Tax Area CodeCode[20]17-29
10018STE Transaction IDText[20]17-29
10020IRS 1099 CodeCode[10]17-29
Removed, tag 28.0, obsolete since 24.0: Moved to IRS Forms App.