Objects/Tables/Table 5110 Purchase Line Archive

Table 5110 Purchase Line Archive in 19

Jonas Paprotka, Base Application 19.5.36567.56815, checked 2026-09-20

App: Base Application

Versions17 181920 21 22 23 24 25 26 27 28 latest

Source29

Fields, 187

Id	Name	Type	Obsolete
1	Document Type	Enum Purchase Document Type	-
2	Buy-from Vendor No.	Code[20]	-
3	Document No.	Code[20]	-
4	Line No.	Integer	-
5	Type	Enum Purchase Line Type	-
6	No.	Code[20]	-
7	Location Code	Code[10]	-
8	Posting Group	Code[20]	-
10	Expected Receipt Date	Date	-
11	Description	Text[100]	-
12	Description 2	Text[50]	-
13	Unit of Measure	Text[50]	-
15	Quantity	Decimal	-
16	Outstanding Quantity	Decimal	-
17	Qty. to Invoice	Decimal	-
18	Qty. to Receive	Decimal	-
22	Direct Unit Cost	Decimal	-
23	Unit Cost (LCY)	Decimal	-
25	VAT %	Decimal	-
26	Quantity Disc. %	Decimal	-
27	Line Discount %	Decimal	-
28	Line Discount Amount	Decimal	-
29	Amount	Decimal	-
30	Amount Including VAT	Decimal	-
31	Unit Price (LCY)	Decimal	-
32	Allow Invoice Disc.	Boolean	-
34	Gross Weight	Decimal	-
35	Net Weight	Decimal	-
36	Units per Parcel	Decimal	-
37	Unit Volume	Decimal	-
38	Appl.-to Item Entry	Integer	-
40	Shortcut Dimension 1 Code	Code[20]	-
41	Shortcut Dimension 2 Code	Code[20]	-
45	Job No.	Code[20]	-
54	Indirect Cost %	Decimal	-
57	Outstanding Amount	Decimal	-
58	Qty. Rcd. Not Invoiced	Decimal	-
59	Amt. Rcd. Not Invoiced	Decimal	-
60	Quantity Received	Decimal	-
61	Quantity Invoiced	Decimal	-
63	Receipt No.	Code[20]	-
64	Receipt Line No.	Integer	-
67	Profit %	Decimal	-
68	Pay-to Vendor No.	Code[20]	-
69	Inv. Discount Amount	Decimal	-
70	Vendor Item No.	Text[50]	-
71	Sales Order No.	Code[20]	-
72	Sales Order Line No.	Integer	-
73	Drop Shipment	Boolean	-
74	Gen. Bus. Posting Group	Code[20]	-
75	Gen. Prod. Posting Group	Code[20]	-
77	VAT Calculation Type	Enum Tax Calculation Type	-
78	Transaction Type	Code[10]	-
79	Transport Method	Code[10]	-
80	Attached to Line No.	Integer	-
81	Entry Point	Code[10]	-
82	Area	Code[10]	-
83	Transaction Specification	Code[10]	-
85	Tax Area Code	Code[20]	-
86	Tax Liable	Boolean	-
87	Tax Group Code	Code[20]	-
88	Use Tax	Boolean	-
89	VAT Bus. Posting Group	Code[20]	-
90	VAT Prod. Posting Group	Code[20]	-
91	Currency Code	Code[10]	-
92	Outstanding Amount (LCY)	Decimal	-
93	Amt. Rcd. Not Invoiced (LCY)	Decimal	-
97	Blanket Order No.	Code[20]	-
98	Blanket Order Line No.	Integer	-
99	VAT Base Amount	Decimal	-
100	Unit Cost	Decimal	-
101	System-Created Entry	Boolean	-
103	Line Amount	Decimal	-
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	-
108	IC Partner Reference	Code[20]	-
109	Prepayment %	Decimal	-
110	Prepmt. Line Amount	Decimal	-
111	Prepmt. Amt. Inv.	Decimal	-
112	Prepmt. Amt. Incl. VAT	Decimal	-
113	Prepayment Amount	Decimal	-
114	Prepmt. VAT Base Amt.	Decimal	-
115	Prepayment VAT %	Decimal	-
116	Prepmt. VAT Calc. Type	Enum Tax Calculation Type	-
117	Prepayment VAT Identifier	Code[20]	-
118	Prepayment Tax Area Code	Code[20]	-
119	Prepayment Tax Liable	Boolean	-
120	Prepayment Tax Group Code	Code[20]	-
121	Prepmt Amt to Deduct	Decimal	-
122	Prepmt Amt Deducted	Decimal	-
123	Prepayment Line	Boolean	-
124	Prepmt. Amount Inv. Incl. VAT	Decimal	-
130	IC Partner Code	Code[20]	-
138	IC Item Reference No.	Code[50]	-
145	Pmt. Discount Amount	Decimal	-
480	Dimension Set ID	Integer	-
1001	Job Task No.	Code[20]	-
1002	Job Line Type	Enum Job Line Type	-
1003	Job Unit Price	Decimal	-
1004	Job Total Price	Decimal	-
1005	Job Line Amount	Decimal	-
1006	Job Line Discount Amount	Decimal	-
1007	Job Line Discount %	Decimal	-
1008	Job Unit Price (LCY)	Decimal	-
1009	Job Total Price (LCY)	Decimal	-
1010	Job Line Amount (LCY)	Decimal	-
1011	Job Line Disc. Amount (LCY)	Decimal	-
1012	Job Currency Factor	Decimal	-
1013	Job Currency Code	Code[20]	-
1019	Job Planning Line No.	Integer	-
1030	Job Remaining Qty.	Decimal	-
1031	Job Remaining Qty. (Base)	Decimal	-
1700	Deferral Code	Code[10]	-
1702	Returns Deferral Start Date	Date	-
5047	Version No.	Integer	-
5048	Doc. No. Occurrence	Integer	-
5401	Prod. Order No.	Code[20]	-
5402	Variant Code	Code[10]	-
5403	Bin Code	Code[20]	-
5404	Qty. per Unit of Measure	Decimal	-
5407	Unit of Measure Code	Code[10]	-
5415	Quantity (Base)	Decimal	-
5416	Outstanding Qty. (Base)	Decimal	-
5417	Qty. to Invoice (Base)	Decimal	-
5418	Qty. to Receive (Base)	Decimal	-
5458	Qty. Rcd. Not Invoiced (Base)	Decimal	-
5460	Qty. Received (Base)	Decimal	-
5461	Qty. Invoiced (Base)	Decimal	-
5600	FA Posting Date	Date	-
5601	FA Posting Type	Option	-
5602	Depreciation Book Code	Code[10]	-
5603	Salvage Value	Decimal	-
5605	Depr. until FA Posting Date	Boolean	-
5606	Depr. Acquisition Cost	Boolean	-
5609	Maintenance Code	Code[10]	-
5610	Insurance No.	Code[20]	-
5611	Budgeted FA No.	Code[20]	-
5612	Duplicate in Depreciation Book	Code[10]	-
5613	Use Duplication List	Boolean	-
5700	Responsibility Center	Code[10]	-
5705	Cross-Reference No.	Code[20]	Pending 18.0
Cross-Reference replaced by Item Reference feature.
5706	Unit of Measure (Cross Ref.)	Code[10]	Pending 19.0
Cross-Reference replaced by Item Reference feature.
5707	Cross-Reference Type	Option	Pending 19.0
Cross-Reference replaced by Item Reference feature.
5708	Cross-Reference Type No.	Code[30]	Pending 19.0
Cross-Reference replaced by Item Reference feature.
5709	Item Category Code	Code[20]	-
5710	Nonstock	Boolean	-
5711	Purchasing Code	Code[10]	-
5712	Product Group Code	Code[10]	Removed 15.0
Product Groups became first level children of Item Categories.
5713	Special Order	Boolean	-
5714	Special Order Sales No.	Code[20]	-
5715	Special Order Sales Line No.	Integer	-
5725	Item Reference No.	Code[50]	-
5726	Item Reference Unit of Measure	Code[10]	-
5727	Item Reference Type	Enum Item Reference Type	-
5728	Item Reference Type No.	Code[30]	-
5752	Completely Received	Boolean	-
5790	Requested Receipt Date	Date	-
5791	Promised Receipt Date	Date	-
5792	Lead Time Calculation	DateFormula	-
5793	Inbound Whse. Handling Time	DateFormula	-
5794	Planned Receipt Date	Date	-
5795	Order Date	Date	-
5800	Allow Item Charge Assignment	Boolean	-
5803	Return Qty. to Ship	Decimal	-
5804	Return Qty. to Ship (Base)	Decimal	-
5805	Return Qty. Shipped Not Invd.	Decimal	-
5806	Ret. Qty. Shpd Not Invd.(Base)	Decimal	-
5807	Return Shpd. Not Invd.	Decimal	-
5808	Return Shpd. Not Invd. (LCY)	Decimal	-
5809	Return Qty. Shipped	Decimal	-
5810	Return Qty. Shipped (Base)	Decimal	-
6600	Return Shipment No.	Code[20]	-
6601	Return Shipment Line No.	Integer	-
6608	Return Reason Code	Code[10]	-
7000	Price Calculation Method	Enum Price Calculation Method	-
99000750	Routing No.	Code[20]	-
99000751	Operation No.	Code[10]	-
99000752	Work Center No.	Code[20]	-
99000753	Finished	Boolean	-
99000754	Prod. Order Line No.	Integer	-
99000755	Overhead Rate	Decimal	-
99000756	MPS Order	Boolean	-
99000757	Planning Flexibility	Enum Reservation Planning Flexibility	-
99000758	Safety Lead Time	DateFormula	-
99000759	Routing Reference No.	Integer	-

Keys, 5

Name	Fields	Obsolete
Key1, clustered	Document Type, Document No., Doc. No. Occurrence, Version No., Line No.	-
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.	-

Procedures, 4

Name	Parameters	Returns	Access	Obsolete
GetCaptionClass	(Integer)	Text[80]	public	-
ShowDimensions	()		public	-
ShowLineComments	()		public	-
ShowDeferrals	()		public	-