Table 5110 "Purchase Line Archive"

Base Application · Microsoft.Purchases.Archive · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Purchase Line Archive
DataClassification	CustomerContent

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No.	Name	Type	Explanation	Notes
1	Document Type Δ BC28	Enum “Purchase Document Type”	Specifies the type of purchase document.	enum Enum 38 “Purchase Document Type”
2	Buy-from Vendor No. Δ BC28	Code[20]	Specifies the name of the vendor who delivered the items.	TableRelation Table 23 “Vendor”
3	Document No. Δ BC28	Code[20]	Specifies the document number.	TableRelation Table 5109 “Purchase Header Archive” (“Purchase Header Archive”.“No.” where(“Document Type” = field(“Document Type”), “Version No.” = field(“Version No.”)))
4	Line No. Δ BC28	Integer	Specifies the number of the line.
5	Type Δ BC28	Enum “Purchase Line Type”	Specifies the line type.	enum Enum 39 “Purchase Line Type”
6	No. Δ BC28	Code[20]	Specifies the number of the involved entry or record, according to the specified number series.	TableRelation Table 15 “G/L Account”, Table 27 “Item”, Table 5600 “Fixed Asset” (if (Type = const(” “)) “Standard Text” else if (Type = const(“G/L Account”)) “G/L Account” else if (Type = const(Item)) Item else if (Type = const(“Fixed Asset”)) “Fixed Asset” else if (Type = const(“Charge (Item)”)) “Item Charge”)
7	Location Code Δ BC28	Code[10]	Specifies a code for the location where you want the items to be placed when they are received.	TableRelation Table 14 “Location” (Location where(“Use As In-Transit” = const(false)))
8	Posting Group	Code[20]	—	TableRelation Table 5606 “FA Posting Group”, Table 94 “Inventory Posting Group” (if (Type = const(Item)) “Inventory Posting Group” else if (Type = const(“Fixed Asset”)) “FA Posting Group”)
10	Expected Receipt Date Δ BC28	Date	Specifies the date you expect the items to be available in your warehouse. If you leave the field blank, it will be calculated as follows: Planned Receipt Date + Safety Lead Time + Inbound Warehouse Handling Time = Expected Receipt Date.
11	Description Δ BC28	Text[100]	Specifies a description of the record.
12	Description 2 Δ BC28	Text[50]	Specifies information in addition to the description.
13	Unit of Measure Δ BC28	Text[50]	Specifies the name of the item or resource’s unit of measure, such as piece or hour.
15	Quantity Δ BC28	Decimal	Specifies the quantity of the record.
16	Outstanding Quantity Δ BC28	Decimal	—
17	Qty. to Invoice Δ BC28	Decimal	Specifies the quantity that remains to be invoiced. It is calculated as Quantity - Qty. Invoiced.
18	Qty. to Receive Δ BC28	Decimal	Specifies the quantity of items that remains to be received.
22	Direct Unit Cost Δ BC28	Decimal	Specifies the cost of one unit of the selected item or resource.
23	Unit Cost (LCY) Δ BC28	Decimal	Specifies the cost, in LCY, of one unit of the item or resource on the line. via Page 5165 “Purchase Quote Archive Subform”
25	VAT % Δ BC28	Decimal	—
26	Quantity Disc. % Δ BC28	Decimal	—
27	Line Discount % Δ BC28	Decimal	Specifies the discount percentage that is granted for the item on the line.
28	Line Discount Amount Δ BC28	Decimal	Specifies the discount amount that is granted for the item on the line.
29	Amount Δ BC28	Decimal	Specifies the sum of amounts in the Line Amount field on the purchase lines.
30	Amount Including VAT Δ BC28	Decimal	Specifies the net amount, including VAT, for this line.
31	Unit Price (LCY) Δ BC28	Decimal	Specifies the price, in LCY, of one unit of the item or resource. You can enter a price manually or have it entered according to the Price/Profit Calculation field on the related card. via Page 5165 “Purchase Quote Archive Subform”
32	Allow Invoice Disc. Δ BC28	Boolean	Specifies if the invoice line is included when the invoice discount is calculated.
34	Gross Weight Δ BC28	Decimal	Specifies the gross weight of one unit of the item. In the purchase statistics window, the gross weight on the line is included in the total gross weight of all the lines for the particular purchase document.
35	Net Weight Δ BC28	Decimal	Specifies the net weight of one unit of the item. In the purchase statistics window, the net weight on the line is included in the total net weight of all the lines for the particular purchase document.
36	Units per Parcel Δ BC28	Decimal	Specifies the number of units per parcel of the item. In the purchase statistics window, the number of units per parcel on the line helps to determine the total number of units for all the lines for the particular purchase document.
37	Unit Volume Δ BC28	Decimal	Specifies the volume of one unit of the item. In the purchase statistics window, the volume of one unit of the item on the line is included in the total volume of all the lines for the particular purchase document.
38	Appl.-to Item Entry Δ BC28	Integer	Specifies the number of the item ledger entry that the document or journal line is applied to.
40	Shortcut Dimension 1 Code Δ BC28	Code[20]	Specifies the code for Shortcut Dimension 1, which is one of two global dimension codes that you set up in the General Ledger Setup window.	TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1)))
41	Shortcut Dimension 2 Code Δ BC28	Code[20]	Specifies the code for Shortcut Dimension 2, which is one of two global dimension codes that you set up in the General Ledger Setup window.	TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2)))
45	Job No. Δ BC24 Δ BC28	Code[20]	Specifies the project number that the archived document was linked to.	TableRelation Table 167 “Job”
54	Indirect Cost % Δ BC28	Decimal	Specifies the percentage of the item’s last purchase cost that includes indirect costs, such as freight that is associated with the purchase of the item.
57	Outstanding Amount	Decimal	—
58	Qty. Rcd. Not Invoiced Δ BC28	Decimal	—
59	Amt. Rcd. Not Invoiced	Decimal	—
60	Quantity Received Δ BC28	Decimal	Specifies how many units of the item on the line have been posted as received.
61	Quantity Invoiced Δ BC28	Decimal	Specifies how many units of the item on the line have been posted as invoiced.
63	Receipt No.	Code[20]	—
64	Receipt Line No.	Integer	—
67	Profit % Δ BC28	Decimal	—
68	Pay-to Vendor No.	Code[20]	—	TableRelation Table 23 “Vendor”
69	Inv. Discount Amount Δ BC28	Decimal	Specifies the total calculated invoice discount amount for the line.
70	Vendor Item No.	Text[50]	—
71	Sales Order No.	Code[20]	—	TableRelation Table 36 “Sales Header” (if (“Drop Shipment” = const(true)) “Sales Header”.“No.” where(“Document Type” = const(Order)))
72	Sales Order Line No.	Integer	—	TableRelation Table 37 “Sales Line” (if (“Drop Shipment” = const(true)) “Sales Line”.“Line No.” where(“Document Type” = const(Order), “Document No.” = field(“Sales Order No.”)))
73	Drop Shipment Δ BC28	Boolean	Specifies if your vendor ships the items directly to your customer.
74	Gen. Bus. Posting Group Δ BC28	Code[20]	Specifies the vendor’s or customer’s trade type to link transactions made for this business partner with the appropriate general ledger account according to the general posting setup.	TableRelation Table 250 “Gen. Business Posting Group” (Gen. Business Posting Group)
75	Gen. Prod. Posting Group Δ BC28	Code[20]	Specifies the item’s product type to link transactions made for this item with the appropriate general ledger account according to the general posting setup.	TableRelation Table 251 “Gen. Product Posting Group” (Gen. Product Posting Group)
77	VAT Calculation Type	Enum “Tax Calculation Type”	—	enum Enum 254 “Tax Calculation Type”
78	Transaction Type	Code[10]	—	TableRelation Table 258 “Transaction Type” (Transaction Type)
79	Transport Method	Code[10]	—	TableRelation Table 259 “Transport Method” (Transport Method)
80	Attached to Line No.	Integer	—	TableRelation Table 5110 “Purchase Line Archive” (“Purchase Line Archive”.“Line No.” where(“Document Type” = field(“Document Type”), “Document No.” = field(“Document No.”), “Doc. No. Occurrence” = field(“Doc. No. Occurrence”), “Version No.” = field(“Version No.”))); not editable
81	Entry Point	Code[10]	—	TableRelation Table 282 “Entry/Exit Point” (Entry/Exit Point)
82	Area	Code[10]	—	TableRelation Table 284 “Area”
83	Transaction Specification	Code[10]	—	TableRelation Table 285 “Transaction Specification” (Transaction Specification)
85	Tax Area Code Δ BC28	Code[20]	Specifies the tax area that is used to calculate and post sales tax.	TableRelation Table 318 “Tax Area” (Tax Area)
86	Tax Liable Δ BC28	Boolean	Specifies if this vendor charges you sales tax for purchases.
87	Tax Group Code Δ BC28	Code[20]	Specifies the tax group that is used to calculate and post sales tax.	TableRelation Table 321 “Tax Group” (Tax Group)
88	Use Tax Δ BC28	Boolean	Specifies a U.S. sales tax that is paid on items purchased by a company that are used by the company, instead of being sold to a customer.
89	VAT Bus. Posting Group Δ BC28	Code[20]	Specifies the VAT specification of the involved customer or vendor to link transactions made for this record with the appropriate general ledger account according to the VAT posting setup.	TableRelation Table 323 “VAT Business Posting Group” (VAT Business Posting Group)
90	VAT Prod. Posting Group Δ BC28	Code[20]	Specifies the VAT specification of the involved item or resource to link transactions made for this record with the appropriate general ledger account according to the VAT posting setup.	TableRelation Table 324 “VAT Product Posting Group” (VAT Product Posting Group)
91	Currency Code	Code[10]	—	TableRelation Table 4 “Currency”
92	Outstanding Amount (LCY) Δ BC28	Decimal	—
93	Amt. Rcd. Not Invoiced (LCY) Δ BC28	Decimal	—
97	Blanket Order No. Δ BC28	Code[20]	Specifies the number of the blanket order that the record originates from.	TableRelation Table 38 “Purchase Header” (“Purchase Header”.“No.” where(“Document Type” = const(“Blanket Order”)))
98	Blanket Order Line No. Δ BC28	Integer	Specifies the number of the blanket order line that the record originates from.	TableRelation Table 39 “Purchase Line” (“Purchase Line”.“Line No.” where(“Document Type” = const(“Blanket Order”), “Document No.” = field(“Blanket Order No.”)))
99	VAT Base Amount	Decimal	—
100	Unit Cost	Decimal	—
101	System-Created Entry	Boolean	—
103	Line Amount Δ BC28	Decimal	Specifies the net amount, excluding any invoice discount amount, that must be paid for products on the line.
104	VAT Difference	Decimal	—
105	Inv. Disc. Amount to Invoice	Decimal	—
106	VAT Identifier	Code[20]	—
107	IC Partner Ref. Type	Enum “IC Partner Reference Type”	—	enum Enum 107 “IC Partner Reference Type”
108	IC Partner Reference	Code[20]	—
109	Prepayment % Δ BC28	Decimal	—
110	Prepmt. Line Amount	Decimal	—
111	Prepmt. Amt. Inv.	Decimal	—	not editable
112	Prepmt. Amt. Incl. VAT	Decimal	—	not editable
113	Prepayment Amount	Decimal	—	not editable
114	Prepmt. VAT Base Amt.	Decimal	—	not editable
115	Prepayment VAT % Δ BC28	Decimal	—	not editable
116	Prepmt. VAT Calc. Type	Enum “Tax Calculation Type”	—	enum Enum 254 “Tax Calculation Type”; not editable
117	Prepayment VAT Identifier	Code[20]	—	not editable
118	Prepayment Tax Area Code	Code[20]	—	TableRelation Table 318 “Tax Area” (Tax Area)
119	Prepayment Tax Liable	Boolean	—
120	Prepayment Tax Group Code	Code[20]	—	TableRelation Table 321 “Tax Group” (Tax Group)
121	Prepmt Amt to Deduct	Decimal	—
122	Prepmt Amt Deducted	Decimal	—	not editable
123	Prepayment Line	Boolean	—	not editable
124	Prepmt. Amount Inv. Incl. VAT	Decimal	—	not editable
130	IC Partner Code	Code[20]	—	TableRelation Table 413 “IC Partner” (IC Partner)
138	IC Item Reference No.	Code[50]	—
145	Pmt. Discount Amount	Decimal	—
480	Dimension Set ID	Integer	—	TableRelation Table 480 “Dimension Set Entry” (Dimension Set Entry); not editable
1001	Job Task No. Δ BC24 Δ BC28	Code[20]	Specifies the number of the related project task.	TableRelation Table 1001 “Job Task” (“Job Task”.“Job Task No.” where(“Job No.” = field(“Job No.”))); not editable
1002	Job Line Type Δ BC24 Δ BC28	Enum “Job Line Type”	Specifies the type of planning line that was created when the project ledger entry is posted from the purchase line. If the field is empty, no planning lines were created for this entry.	enum Enum 1002 “Job Line Type”
1003	Job Unit Price Δ BC24 Δ BC28	Decimal	Specifies the sales price per unit that applies to the item or general ledger expense that will be posted.
1004	Job Total Price Δ BC24 Δ BC28	Decimal	Specifies the gross amount of the line that the purchase line applies to.
1005	Job Line Amount Δ BC24 Δ BC28	Decimal	Specifies the line amount of the project ledger entry that is related to the purchase line.
1006	Job Line Discount Amount Δ BC24 Δ BC28	Decimal	Specifies the line discount amount of the project ledger entry that is related to the purchase line.
1007	Job Line Discount % Δ BC24 Δ BC28	Decimal	Specifies the line discount percentage of the project ledger entry that is related to the purchase line.
1008	Job Unit Price (LCY) Δ BC24 Δ BC27 Δ BC28	Decimal	Specifies the sales price per unit that applies to the item or general ledger expense that will be posted. via Page 5165 “Purchase Quote Archive Subform”
1009	Job Total Price (LCY) Δ BC24 Δ BC27 Δ BC28	Decimal	Specifies the gross amount of the line, in the local currency. via Page 5165 “Purchase Quote Archive Subform”
1010	Job Line Amount (LCY) Δ BC24 Δ BC27 Δ BC28	Decimal	Specifies the line amount of the project ledger entry that is related to the purchase line. via Page 5165 “Purchase Quote Archive Subform”
1011	Job Line Disc. Amount (LCY) Δ BC24 Δ BC27 Δ BC28	Decimal	Specifies the line discount amount of the project ledger entry that is related to the purchase line. via Page 5165 “Purchase Quote Archive Subform”
1012	Job Currency Factor Δ BC24 Δ BC28	Decimal	Project Currency Factor caption
1013	Job Currency Code Δ BC24	Code[20]	Project Currency Code caption
1019	Job Planning Line No. Δ BC24 Δ BC26 Δ BC28	Integer	Specifies the project planning line number to which the usage should be linked when the Project Journal is posted. You can only link to Project Planning Lines that have the Apply Usage Link option enabled.
1030	Job Remaining Qty. Δ BC24 Δ BC28	Decimal	Project Remaining Qty. caption
1031	Job Remaining Qty. (Base) Δ BC24 Δ BC28	Decimal	Project Remaining Qty. (Base) caption
1700	Deferral Code Δ BC28	Code[10]	Specifies the deferral template that governs how expenses paid with this purchase document are deferred to the different accounting periods when the expenses were incurred.	TableRelation Table 1700 “Deferral Template” (“Deferral Template”.“Deferral Code”)
1702	Returns Deferral Start Date Δ BC28	Date	Specifies the starting date of the returns deferral period.
5047	Version No.	Integer	—
5048	Doc. No. Occurrence	Integer	—
5402	Variant Code Δ BC28	Code[10]	Specifies the variant of the item on the line.	TableRelation Table 5401 “Item Variant” (if (Type = const(Item)) “Item Variant”.Code where(“Item No.” = field(“No.”)))
5403	Bin Code	Code[20]	—	TableRelation Table 7354 “Bin” (Bin.Code where(“Location Code” = field(“Location Code”)))
5404	Qty. per Unit of Measure Δ BC28	Decimal	—
5407	Unit of Measure Code Δ BC28	Code[10]	Specifies how each unit of the item or resource is measured, such as in pieces or hours. By default, the value in the Base Unit of Measure field on the item or resource card is inserted.	TableRelation Table 204 “Unit of Measure”, Table 5404 “Item Unit of Measure” (if (Type = const(Item)) “Item Unit of Measure”.Code where(“Item No.” = field(“No.”)) else “Unit of Measure”)
5415	Quantity (Base) Δ BC28	Decimal	—
5416	Outstanding Qty. (Base) Δ BC28	Decimal	—
5417	Qty. to Invoice (Base) Δ BC28	Decimal	—
5418	Qty. to Receive (Base) Δ BC28	Decimal	—
5458	Qty. Rcd. Not Invoiced (Base) Δ BC28	Decimal	—
5460	Qty. Received (Base) Δ BC28	Decimal	—
5461	Qty. Invoiced (Base) Δ BC28	Decimal	—
5600	FA Posting Date	Date	—
5601	FA Posting Type	Enum “Purchase FA Posting Type”	—	enum Enum 5607 “Purchase FA Posting Type”
5602	Depreciation Book Code	Code[10]	—	TableRelation Table 5611 “Depreciation Book” (Depreciation Book)
5603	Salvage Value Δ BC28	Decimal	—
5605	Depr. until FA Posting Date	Boolean	—
5606	Depr. Acquisition Cost	Boolean	—
5609	Maintenance Code	Code[10]	—	TableRelation Table 5626 “Maintenance”
5610	Insurance No.	Code[20]	—	TableRelation Table 5628 “Insurance”
5611	Budgeted FA No.	Code[20]	—	TableRelation Table 5600 “Fixed Asset” (Fixed Asset)
5612	Duplicate in Depreciation Book	Code[10]	—	TableRelation Table 5611 “Depreciation Book” (Depreciation Book)
5613	Use Duplication List	Boolean	—
5700	Responsibility Center	Code[10]	—	TableRelation Table 5714 “Responsibility Center” (Responsibility Center)
5709	Item Category Code	Code[20]	—	TableRelation Table 5722 “Item Category” (Item Category)
5710	Nonstock Δ BC28	Boolean	Specifies that this item is a catalog item.
5711	Purchasing Code	Code[10]	—	TableRelation Table 5721 “Purchasing”
5713	Special Order	Boolean	—
5714	Special Order Sales No.	Code[20]	—	TableRelation Table 36 “Sales Header” (if (“Special Order” = const(true)) “Sales Header”.“No.” where(“Document Type” = const(Order)))
5715	Special Order Sales Line No.	Integer	—	TableRelation Table 37 “Sales Line” (if (“Special Order” = const(true)) “Sales Line”.“Line No.” where(“Document Type” = const(Order), “Document No.” = field(“Special Order Sales No.”)))
5725	Item Reference No. Δ BC28	Code[50]	Specifies the referenced item number.
5726	Item Reference Unit of Measure	Code[10]	Reference Unit of Measure caption	TableRelation Table 5404 “Item Unit of Measure” (if (Type = const(Item)) “Item Unit of Measure”.Code where(“Item No.” = field(“No.”)))
5727	Item Reference Type	Enum “Item Reference Type”	—	enum Enum 5726 “Item Reference Type”
5728	Item Reference Type No.	Code[30]	—
5752	Completely Received	Boolean	—
5790	Requested Receipt Date Δ BC28	Date	Specifies the requested date of receipt for the purchase return order.
5791	Promised Receipt Date Δ BC28	Date	Specifies the date that the vendor has promised to deliver the order.
5792	Lead Time Calculation Δ BC28	DateFormula	Specifies a date formula for the amount of time it takes to replenish the item.
5793	Inbound Whse. Handling Time Δ BC28	DateFormula	Specifies the time it takes to make items part of available inventory, after the items have been posted as received.
5794	Planned Receipt Date Δ BC28	Date	Specifies the date when the item is planned to arrive in inventory. Forward calculation: planned receipt date = order date + vendor lead time (per the vendor calendar and rounded to the next working day in first the vendor calendar and then the location calendar). If no vendor calendar exists, then:…
5795	Order Date Δ BC28	Date	Specifies the date when the order was created.
5800	Allow Item Charge Assignment Δ BC28	Boolean	Specifies that you can assign item charges to this line.
5803	Return Qty. to Ship Δ BC28	Decimal	Specifies the quantity of items that remains to be shipped.
5804	Return Qty. to Ship (Base) Δ BC28	Decimal	—
5805	Return Qty. Shipped Not Invd. Δ BC28	Decimal	—
5806	Ret. Qty. Shpd Not Invd.(Base) Δ BC28	Decimal	—
5807	Return Shpd. Not Invd.	Decimal	—
5808	Return Shpd. Not Invd. (LCY) Δ BC28	Decimal	—
5809	Return Qty. Shipped Δ BC28	Decimal	Specifies how many units of the item on the line have been posted as shipped.
5810	Return Qty. Shipped (Base) Δ BC28	Decimal	—
6200	Non-Deductible VAT % Δ BC28	Decimal	—
6201	Non-Deductible VAT Base Δ BC28	Decimal	—
6202	Non-Deductible VAT Amount Δ BC28	Decimal	—
6203	Non-Deductible VAT Diff. Δ BC28	Decimal	Non-Deductible VAT Difference caption
6600	Return Shipment No.	Code[20]	—
6601	Return Shipment Line No.	Integer	—	not editable
6608	Return Reason Code Δ BC28	Code[10]	Specifies the code explaining why the item was returned.	TableRelation Table 6635 “Return Reason” (Return Reason)
7000	Price Calculation Method	Enum “Price Calculation Method”	—	enum Enum 7000 “Price Calculation Method”
12100	No. of Fixed Asset Cards + BC27	Integer	Specifies the number of fixed assets that is being purchased.
99000755	Overhead Rate Δ BC28	Decimal	—
99000756	MPS Order	Boolean	—
99000757	Planning Flexibility Δ BC28	Enum “Reservation Planning Flexibility”	Specifies whether the supply represented by this line is considered by the planning system when calculating action messages.	enum Enum 340 “Reservation Planning Flexibility”
99000758	Safety Lead Time	DateFormula	—
147	Spend Request No. + BC29	Code[20]	Specifies the spend request that this purchase document relates to.	TableRelation Table 6840 “Spend Request” (Spend Request)
148	Spend Request Close + BC29	Boolean	Specifies that the spend request will be closed when the purchase document is posted.

Keys

Key1: Document Type, Document No., Doc. No. Occurrence, Version No., Line No. (clustered)
Key2: Document Type, Document No., Line No., Doc. No. Occurrence, Version No.
Key3: Buy-from Vendor No.
Key4: Pay-to Vendor No.
Key5: Document No., Document Type, Doc. No. Occurrence, Version No.

Events published

OnBeforeShowDeferrals(PurchaseLineArchive: Record "Purchase Line Archive"; var IsHandled: Boolean) (integration)

Procedures

GetCaptionClass(FieldNumber: Integer): Text[80]
IsExtendedText(): Boolean
ShowDimensions()
ShowLineComments()
ShowDeferrals()
CopyTempLines(PurchaseHeaderArchive: Record "Purchase Header Archive"; var TempPurchaseLine: Record "Purchase Line" temporary)

Plus 1 local procedures.

Triggers

OnDelete

Relations

Job Task No.: TableRelation Table 1001 “Job Task”
Location Code: TableRelation Table 14 “Location”
No.: TableRelation Table 15 “G/L Account” (conditional)
Job No.: TableRelation Table 167 “Job”
Deferral Code: TableRelation Table 1700 “Deferral Template”
Unit of Measure Code: TableRelation Table 204 “Unit of Measure” (conditional)
Buy-from Vendor No.: TableRelation Table 23 “Vendor”
Pay-to Vendor No.: TableRelation Table 23 “Vendor”
Gen. Bus. Posting Group: TableRelation Table 250 “Gen. Business Posting Group”
Gen. Prod. Posting Group: TableRelation Table 251 “Gen. Product Posting Group”
Transaction Type: TableRelation Table 258 “Transaction Type”
Transport Method: TableRelation Table 259 “Transport Method”
No.: TableRelation Table 27 “Item” (conditional)
Entry Point: TableRelation Table 282 “Entry/Exit Point”
Area: TableRelation Table 284 “Area”
Transaction Specification: TableRelation Table 285 “Transaction Specification”
Prepayment Tax Area Code: TableRelation Table 318 “Tax Area”
Tax Area Code: TableRelation Table 318 “Tax Area”
Prepayment Tax Group Code: TableRelation Table 321 “Tax Group”
Tax Group Code: TableRelation Table 321 “Tax Group”
VAT Bus. Posting Group: TableRelation Table 323 “VAT Business Posting Group”
VAT Prod. Posting Group: TableRelation Table 324 “VAT Product Posting Group”
Shortcut Dimension 1 Code: TableRelation Table 349 “Dimension Value”
Shortcut Dimension 2 Code: TableRelation Table 349 “Dimension Value”
Sales Order No.: TableRelation Table 36 “Sales Header”
Special Order Sales No.: TableRelation Table 36 “Sales Header”
Sales Order Line No.: TableRelation Table 37 “Sales Line”
Special Order Sales Line No.: TableRelation Table 37 “Sales Line”
Blanket Order No.: TableRelation Table 38 “Purchase Header”
Blanket Order Line No.: TableRelation Table 39 “Purchase Line”
Currency Code: TableRelation Table 4 “Currency”
IC Partner Code: TableRelation Table 413 “IC Partner”
Dimension Set ID: TableRelation Table 480 “Dimension Set Entry”
Document No.: TableRelation Table 5109 “Purchase Header Archive”
Attached to Line No.: TableRelation Table 5110 “Purchase Line Archive”
Variant Code: TableRelation Table 5401 “Item Variant”
Item Reference Unit of Measure: TableRelation Table 5404 “Item Unit of Measure”
Unit of Measure Code: TableRelation Table 5404 “Item Unit of Measure” (conditional)
Budgeted FA No.: TableRelation Table 5600 “Fixed Asset”
No.: TableRelation Table 5600 “Fixed Asset” (conditional)
Posting Group: TableRelation Table 5606 “FA Posting Group” (conditional)
Depreciation Book Code: TableRelation Table 5611 “Depreciation Book”
Duplicate in Depreciation Book: TableRelation Table 5611 “Depreciation Book”
Maintenance Code: TableRelation Table 5626 “Maintenance”
Insurance No.: TableRelation Table 5628 “Insurance”
Responsibility Center: TableRelation Table 5714 “Responsibility Center”
Purchasing Code: TableRelation Table 5721 “Purchasing”
Item Category Code: TableRelation Table 5722 “Item Category”
No.: TableRelation Table 5800 “Item Charge” (conditional)
Return Reason Code: TableRelation Table 6635 “Return Reason”
Spend Request No.: TableRelation Table 6840 “Spend Request”
No.: TableRelation Table 7 “Standard Text” (conditional)
Bin Code: TableRelation Table 7354 “Bin”
Posting Group: TableRelation Table 94 “Inventory Posting Group” (conditional)

Referenced by

4 fields in 2 objects relate to this table (TableRelation or CalcFormula).

Table 5109 “Purchase Header Archive”: Amount, Amount Including VAT, Completely Received
Table 5110 “Purchase Line Archive”: Attached to Line No.

Pages and codeunits on this table

Page 30217 “APIV2 - P. Qt. Arch. Lines” (source table)
Page 30219 “APIV2 - P. Ord. Arch. Lines” (source table)
Page 30223 “APIV2 - P. Ret. Ord. A. Lines” (source table)
Page 30231 “APIV2 - P. Bl. O. Arch. Lines” (source table)
Page 5165 “Purchase Quote Archive Subform” (source table)
Page 5168 “Purchase Order Archive Subform” (source table)
Page 6624 “Blanket Purch. Order Arch.Sub.” (source table)
Page 6626 “Purchase Line Archive List” (source table)
Page 6645 “Purch Return Order Arc Subform” (source table)

Extended by

Calls

From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.

Codeunit 1720 “Deferral Utilities” (1 call: ShowDeferrals → OpenLineScheduleArchive)
Codeunit 408 “DimensionManagement” (1 call: ShowDimensions → ShowDimensionSet)

Recent changes

2026-07-31 #8959 Deliverable 638799: Spend Requests in Base App (main, BC30, feature)

Countries that replace it

AT, CA, CH, DE, ES, IT, MX, RU, US

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

Ask your agent

Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Purchase Line Archive"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.