XPT / Schema / Purchase Line Archive

Purchase Line Archive #5110

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

192
Fields
0
Records
5
Primary key
0
FlowFields
45
Relations
Open in Data Explorer →

Primary key

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

All fields (192)

Purchase Line Archive — FIELDS
NO.FIELDTYPECLASSRELATION
1 Document Type PK Option Normal
2 Buy-from Vendor No. Code Normal → Vendor #23
3 Document No. PK Code Normal → Purchase Header Archive #5109
4 Line No. PK Integer Normal
5 Type Option Normal
6 No. Code Normal
7 Location Code Code Normal → Location #14
8 Posting Group Code Normal
10 Expected Receipt Date Date Normal
11 Description Text Normal
12 Description 2 Text Normal
13 Unit of Measure Text Normal
15 Quantity Decimal Normal
16 Outstanding Quantity Decimal Normal
17 Qty. to Invoice Decimal Normal
18 Qty. to Receive Decimal Normal
22 Direct Unit Cost Decimal Normal
23 Unit Cost (LCY) Decimal Normal
25 VAT % Decimal Normal
26 Quantity Disc. % Decimal Normal
27 Line Discount % Decimal Normal
28 Line Discount Amount Decimal Normal
29 Amount Decimal Normal
30 Amount Including VAT Decimal Normal
31 Unit Price (LCY) Decimal Normal
32 Allow Invoice Disc. Boolean Normal
34 Gross Weight Decimal Normal
35 Net Weight Decimal Normal
36 Units per Parcel Decimal Normal
37 Unit Volume Decimal Normal
38 Appl.-to Item Entry Integer Normal
40 Shortcut Dimension 1 Code Code Normal → Dimension Value #349
41 Shortcut Dimension 2 Code Code Normal → Dimension Value #349
45 Project No. Code Normal → Job #167
54 Indirect Cost % Decimal Normal
57 Outstanding Amount Decimal Normal
58 Qty. Rcd. Not Invoiced Decimal Normal
59 Amt. Rcd. Not Invoiced Decimal Normal
60 Quantity Received Decimal Normal
61 Quantity Invoiced Decimal Normal
63 Receipt No. Code Normal
64 Receipt Line No. Integer Normal
67 Profit % Decimal Normal
68 Pay-to Vendor No. Code Normal → Vendor #23
69 Inv. Discount Amount Decimal Normal
70 Vendor Item No. Text Normal
71 Sales Order No. Code Normal
72 Sales Order Line No. Integer Normal
73 Drop Shipment Boolean Normal
74 Gen. Bus. Posting Group Code Normal → Gen. Business Posting Group #250
75 Gen. Prod. Posting Group Code Normal → Gen. Product Posting Group #251
77 VAT Calculation Type Option Normal
78 Transaction Type Code Normal → Transaction Type #258
79 Transport Method Code Normal → Transport Method #259
80 Attached to Line No. Integer Normal → Purchase Line Archive #5110
81 Entry Point Code Normal → Entry/Exit Point #282
82 Area Code Normal → Area #284
83 Transaction Specification Code Normal → Transaction Specification #285
85 Tax Area Code Code Normal → Tax Area #318
86 Tax Liable Boolean Normal
87 Tax Group Code Code Normal → Tax Group #321
88 Use Tax Boolean Normal
89 VAT Bus. Posting Group Code Normal → VAT Business Posting Group #323
90 VAT Prod. Posting Group Code Normal → VAT Product Posting Group #324
91 Currency Code Code Normal → Currency #4
92 Outstanding Amount (LCY) Decimal Normal
93 Amt. Rcd. Not Invoiced (LCY) Decimal Normal
97 Blanket Order No. Code Normal → Purchase Header #38
98 Blanket Order Line No. Integer Normal → Purchase Line #39
99 VAT Base Amount Decimal Normal
100 Unit Cost Decimal Normal
101 System-Created Entry Boolean Normal
103 Line Amount Decimal Normal
104 VAT Difference Decimal Normal
105 Inv. Disc. Amount to Invoice Decimal Normal
106 VAT Identifier Code Normal
107 IC Partner Ref. Type Option Normal
108 IC Partner Reference Code Normal
109 Prepayment % Decimal Normal
110 Prepmt. Line Amount Decimal Normal
111 Prepmt. Amt. Inv. Decimal Normal
112 Prepmt. Amt. Incl. VAT Decimal Normal
113 Prepayment Amount Decimal Normal
114 Prepmt. VAT Base Amt. Decimal Normal
115 Prepayment VAT % Decimal Normal
116 Prepmt. VAT Calc. Type Option Normal
117 Prepayment VAT Identifier Code Normal
118 Prepayment Tax Area Code Code Normal → Tax Area #318
119 Prepayment Tax Liable Boolean Normal
120 Prepayment Tax Group Code Code Normal → Tax Group #321
121 Prepmt Amt to Deduct Decimal Normal
122 Prepmt Amt Deducted Decimal Normal
123 Prepayment Line Boolean Normal
124 Prepmt. Amount Inv. Incl. VAT Decimal Normal
130 IC Partner Code Code Normal → IC Partner #413
138 IC Item Reference No. Code Normal
145 Pmt. Discount Amount Decimal Normal
480 Dimension Set ID Integer Normal → Dimension Set Entry #480
1001 Project Task No. Code Normal → Job Task #1001
1002 Project Line Type Option Normal
1003 Project Unit Price Decimal Normal
1004 Project Total Price Decimal Normal
1005 Project Line Amount Decimal Normal
1006 Project Line Discount Amount Decimal Normal
1007 Project Line Discount % Decimal Normal
1008 Project Unit Price (LCY) Decimal Normal
1009 Project Total Price (LCY) Decimal Normal
1010 Project Line Amount (LCY) Decimal Normal
1011 Project Line Disc. Amount (LCY) Decimal Normal
1012 Project Currency Factor Decimal Normal
1013 Project Currency Code Code Normal
1019 Project Planning Line No. Integer Normal
1030 Project Remaining Qty. Decimal Normal
1031 Project Remaining Qty. (Base) Decimal Normal
1700 Deferral Code Code Normal → Deferral Template #1700
1702 Returns Deferral Start Date Date Normal
5047 Version No. PK Integer Normal
5048 Doc. No. Occurrence PK Integer Normal
5401 Prod. Order No. Code Normal → Production Order #5405
5402 Variant Code Code Normal
5403 Bin Code Code Normal → Bin #7354
5404 Qty. per Unit of Measure Decimal Normal
5407 Unit of Measure Code Code Normal
5415 Quantity (Base) Decimal Normal
5416 Outstanding Qty. (Base) Decimal Normal
5417 Qty. to Invoice (Base) Decimal Normal
5418 Qty. to Receive (Base) Decimal Normal
5458 Qty. Rcd. Not Invoiced (Base) Decimal Normal
5460 Qty. Received (Base) Decimal Normal
5461 Qty. Invoiced (Base) Decimal Normal
5600 FA Posting Date Date Normal
5601 FA Posting Type Option Normal
5602 Depreciation Book Code Code Normal → Depreciation Book #5611
5603 Salvage Value Decimal Normal
5605 Depr. until FA Posting Date Boolean Normal
5606 Depr. Acquisition Cost Boolean Normal
5609 Maintenance Code Code Normal → Maintenance #5626
5610 Insurance No. Code Normal → Insurance #5628
5611 Budgeted FA No. Code Normal → Fixed Asset #5600
5612 Duplicate in Depreciation Book Code Normal → Depreciation Book #5611
5613 Use Duplication List Boolean Normal
5700 Responsibility Center Code Normal → Responsibility Center #5714
5709 Item Category Code Code Normal → Item Category #5722
5710 Catalog Boolean Normal
5711 Purchasing Code Code Normal → Purchasing #5721
5713 Special Order Boolean Normal
5714 Special Order Sales No. Code Normal
5715 Special Order Sales Line No. Integer Normal
5725 Item Reference No. Code Normal
5726 Reference Unit of Measure Code Normal
5727 Item Reference Type Option Normal
5728 Item Reference Type No. Code Normal
5752 Completely Received Boolean Normal
5790 Requested Receipt Date Date Normal
5791 Promised Receipt Date Date Normal
5792 Lead Time Calculation DateFormula Normal
5793 Inbound Whse. Handling Time DateFormula Normal
5794 Planned Receipt Date Date Normal
5795 Order Date Date Normal
5800 Allow Item Charge Assignment Boolean Normal
5803 Return Qty. to Ship Decimal Normal
5804 Return Qty. to Ship (Base) Decimal Normal
5805 Return Qty. Shipped Not Invd. Decimal Normal
5806 Ret. Qty. Shpd Not Invd.(Base) Decimal Normal
5807 Return Shpd. Not Invd. Decimal Normal
5808 Return Shpd. Not Invd. (LCY) Decimal Normal
5809 Return Qty. Shipped Decimal Normal
5810 Return Qty. Shipped (Base) Decimal Normal
6200 Non-Deductible VAT % Decimal Normal
6201 Non-Deductible VAT Base Decimal Normal
6202 Non-Deductible VAT Amount Decimal Normal
6203 Non-Deductible VAT Difference Decimal Normal
6600 Return Shipment No. Code Normal
6601 Return Shipment Line No. Integer Normal
6608 Return Reason Code Code Normal → Return Reason #6635
7000 Price Calculation Method Option Normal
12100 No. of Fixed Asset Cards Integer Normal
99000750 Routing No. Code Normal → Routing Header #99000763
99000751 Operation No. Code Normal → Prod. Order Routing Line #5409
99000752 Work Center No. Code Normal → Work Center #99000754
99000753 Finished Boolean Normal
99000754 Prod. Order Line No. Integer Normal → Prod. Order Line #5406
99000755 Overhead Rate Decimal Normal
99000756 MPS Order Boolean Normal
99000757 Planning Flexibility Option Normal
99000758 Safety Lead Time DateFormula Normal
99000759 Routing Reference No. Integer 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 (39)

Tables referenced by fields on the Purchase Line Archive table through TableRelation properties.

Vendor
#23 · Purchasing · via Buy-from Vendor No., Pay-to Vendor No.
Purchase Header Archive
#5109 · Other · via Document No.
Location
#14 · General Ledger · via Location Code
Dimension Value
#349 · Dimensions · via Shortcut Dimension 1 Code, Shortcut Dimension 2 Code
Job
#167 · Other · via Project No.
Gen. Business Posting Group
#250 · Other · via Gen. Bus. Posting Group
Gen. Product Posting Group
#251 · Other · via Gen. Prod. Posting Group
Transaction Type
#258 · Other · via Transaction Type
Transport Method
#259 · Other · via Transport Method
Purchase Line Archive
#5110 · Other · via Attached to Line No.
Entry/Exit Point
#282 · Other · via Entry Point
Area
#284 · Other · via Area
Transaction Specification
#285 · Other · via Transaction Specification
Tax Area
#318 · Other · via Tax Area Code, Prepayment Tax Area Code
Tax Group
#321 · Other · via Tax Group Code, Prepayment Tax Group Code
VAT Business Posting Group
#323 · Other · via VAT Bus. Posting Group
VAT Product Posting Group
#324 · Other · via VAT Prod. Posting Group
Currency
#4 · General Ledger · via Currency Code
Purchase Header
#38 · Sales Documents · via Blanket Order No.
Purchase Line
#39 · Sales Documents · via Blanket Order Line No.
IC Partner
#413 · Other · via IC Partner Code
Dimension Set Entry
#480 · Dimensions · via Dimension Set ID
Job Task
#1001 · Jobs · via Project Task No.
Deferral Template
#1700 · Other · via Deferral Code
Production Order
#5405 · Other · via Prod. Order No.
Bin
#7354 · Warehouse · via Bin Code
Depreciation Book
#5611 · Fixed Assets · via Depreciation Book Code, Duplicate in Depreciation Book
Maintenance
#5626 · Fixed Assets · via Maintenance Code
Insurance
#5628 · Fixed Assets · via Insurance No.
Fixed Asset
#5600 · Fixed Assets · via Budgeted FA No.
Responsibility Center
#5714 · Other · via Responsibility Center
Item Category
#5722 · Other · via Item Category Code
Purchasing
#5721 · Other · via Purchasing Code
Return Reason
#6635 · Other · via Return Reason Code
Routing Header
#99000763 · Manufacturing · via Routing No.
Prod. Order Routing Line
#5409 · Other · via Operation No.
Work Center
#99000754 · Manufacturing · via Work Center No.
Prod. Order Line
#5406 · Other · via Prod. Order Line No.

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

HomeData ExplorerPricingPrivacyTerms