Table 39 Purchase Line

Base Application, Microsoft.Purchases.Document

221 fields

IdNameTypeVersions
1Document TypeEnum "Purchase Document Type"17-29
2Buy-from Vendor No.Code[20]17-29
3Document No.Code[20]17-29
4Line No.Integer17-29
5TypeEnum "Purchase Line Type"17-29
6No.Code[20]17-29
7Location CodeCode[10]17-29
8Posting GroupCode[20]17-29
10Expected Receipt DateDate17-29
11DescriptionText[100]17-29
12Description 2Text[50]17-29
13Unit of MeasureText[50]17-29
15QuantityDecimal17-29
16Outstanding QuantityDecimal17-29
17Qty. to InvoiceDecimal17-29
18Qty. to ReceiveDecimal17-29
22Direct Unit CostDecimal17-29
23Unit Cost (LCY)Decimal17-29
25VAT %Decimal17-29
27Line Discount %Decimal17-29
28Line Discount AmountDecimal17-29
29AmountDecimal17-29
30Amount Including VATDecimal17-29
31Unit Price (LCY)Decimal17-29
32Allow Invoice Disc.Boolean17-29
34Gross WeightDecimal17-29
35Net WeightDecimal17-29
36Units per ParcelDecimal17-29
37Unit VolumeDecimal17-29
38Appl.-to Item EntryInteger17-29
40Shortcut Dimension 1 CodeCode[20]17-29
41Shortcut Dimension 2 CodeCode[20]17-29
45Job No.Code[20]17-29
54Indirect Cost %Decimal17-29
56Recalculate Invoice Disc.Boolean17-29
57Outstanding AmountDecimal17-29
58Qty. Rcd. Not InvoicedDecimal17-29
59Amt. Rcd. Not InvoicedDecimal17-29
60Quantity ReceivedDecimal17-29
61Quantity InvoicedDecimal17-29
63Receipt No.Code[20]17-29
64Receipt Line No.Integer17-29
65Order No.Code[20]17-29
66Order Line No.Integer17-29
67Profit %Decimal17-29
68Pay-to Vendor No.Code[20]17-29
69Inv. Discount AmountDecimal17-29
70Vendor Item No.Text[50]17-29
71Sales Order No.Code[20]17-29
72Sales Order Line No.Integer17-29
73Drop ShipmentBoolean17-29
74Gen. Bus. Posting GroupCode[20]17-29
75Gen. Prod. Posting GroupCode[20]17-29
77VAT Calculation TypeEnum "Tax Calculation Type"17-29
78Transaction TypeCode[10]17-29
79Transport MethodCode[10]17-29
80Attached to Line No.Integer17-29
81Entry PointCode[10]17-29
82AreaCode[10]17-29
83Transaction SpecificationCode[10]17-29
85Tax Area CodeCode[20]17-29
86Tax LiableBoolean17-29
87Tax Group CodeCode[20]17-29
88Use TaxBoolean17-29
89VAT Bus. Posting GroupCode[20]17-29
90VAT Prod. Posting GroupCode[20]17-29
91Currency CodeCode[10]17-29
92Outstanding Amount (LCY)Decimal17-29
93Amt. Rcd. Not Invoiced (LCY)Decimal17-29
95Reserved QuantityDecimal17-29
97Blanket Order No.Code[20]17-29
98Blanket Order Line No.Integer17-29
99VAT Base AmountDecimal17-29
100Unit CostDecimal17-29
101System-Created EntryBoolean17-29
103Line AmountDecimal17-29
104VAT DifferenceDecimal17-29
105Inv. Disc. Amount to InvoiceDecimal17-29
106VAT IdentifierCode[20]17-29
107IC Partner Ref. TypeEnum "IC Partner Reference Type"17-29
108IC Partner ReferenceCode[20]17-29
109Prepayment %Decimal17-29
110Prepmt. Line AmountDecimal17-29
111Prepmt. Amt. Inv.Decimal17-29
112Prepmt. Amt. Incl. VATDecimal17-29
113Prepayment AmountDecimal17-29
114Prepmt. VAT Base Amt.Decimal17-29
115Prepayment VAT %Decimal17-29
116Prepmt. VAT Calc. TypeEnum "Tax Calculation Type"17-29
117Prepayment VAT IdentifierCode[20]17-29
118Prepayment Tax Area CodeCode[20]17-29
119Prepayment Tax LiableBoolean17-29
120Prepayment Tax Group CodeCode[20]17-29
121Prepmt Amt to DeductDecimal17-29
122Prepmt Amt DeductedDecimal17-29
123Prepayment LineBoolean17-29
124Prepmt. Amount Inv. Incl. VATDecimal17-29
129Prepmt. Amount Inv. (LCY)Decimal17-29
130IC Partner CodeCode[20]17-29
132Prepmt. VAT Amount Inv. (LCY)Decimal17-29
135Prepayment VAT DifferenceDecimal17-29
136Prepmt VAT Diff. to DeductDecimal17-29
137Prepmt VAT Diff. DeductedDecimal17-29
138IC Item Reference No.Code[50]17-29
140Outstanding Amt. Ex. VAT (LCY)Decimal17-29
141A. Rcd. Not Inv. Ex. VAT (LCY)Decimal17-29
145Pmt. Discount AmountDecimal17-29
146Prepmt. Pmt. Discount AmountDecimalnew in 20
147Spend Request No.Code[20]new in 29
148Spend Request CloseBooleannew in 29
480Dimension Set IDInteger17-29
1001Job Task No.Code[20]17-29
1002Job Line TypeEnum "Job Line Type"17-29changed in 18
1003Job Unit PriceDecimal17-29
1004Job Total PriceDecimal17-29
1005Job Line AmountDecimal17-29
1006Job Line Discount AmountDecimal17-29
1007Job Line Discount %Decimal17-29
1008Job Unit Price (LCY)Decimal17-29
1009Job Total Price (LCY)Decimal17-29
1010Job Line Amount (LCY)Decimal17-29
1011Job Line Disc. Amount (LCY)Decimal17-29
1012Job Currency FactorDecimal17-29
1013Job Currency CodeCode[20]17-29
1019Job Planning Line No.Integer17-29
1030Job Remaining Qty.Decimal17-29
1031Job Remaining Qty. (Base)Decimal17-29
1700Deferral CodeCode[10]17-29
1702Returns Deferral Start DateDate17-29
2675Selected Alloc. Account No.Code[20]new in 23
2677Alloc. Acc. Modified by UserBooleannew in 23
2678Allocation Account No.Code[20]new in 23
2679Alloc. Purch. Line SystemIdGuidnew in 27
2700Invoicing From Line SystemIdGuidnew in 28
2701Matched Order LinesIntegernew in 28
2702Matched Inv./Cr. Memo LinesIntegernew in 28
5402Variant CodeCode[10]17-29
5403Bin CodeCode[20]17-29
5404Qty. per Unit of MeasureDecimal17-29
5405Qty. Rounding PrecisionDecimalnew in 19
5406Qty. Rounding Precision (Base)Decimalnew in 19
5407Unit of Measure CodeCode[10]17-29
5415Quantity (Base)Decimal17-29
5416Outstanding Qty. (Base)Decimal17-29
5417Qty. to Invoice (Base)Decimal17-29
5418Qty. to Receive (Base)Decimal17-29
5458Qty. Rcd. Not Invoiced (Base)Decimal17-29
5460Qty. Received (Base)Decimal17-29
5461Qty. Invoiced (Base)Decimal17-29
5495Reserved Qty. (Base)Decimal17-29
5600FA Posting DateDate17-29
5601FA Posting TypeEnum "Purchase FA Posting Type"17-29changed in 21
5602Depreciation Book CodeCode[10]17-29
5603Salvage ValueDecimal17-29
5605Depr. until FA Posting DateBoolean17-29
5606Depr. Acquisition CostBoolean17-29
5609Maintenance CodeCode[10]17-29
5610Insurance No.Code[20]17-29
5611Budgeted FA No.Code[20]17-29
5612Duplicate in Depreciation BookCode[10]17-29
5613Use Duplication ListBoolean17-29
5700Responsibility CenterCode[10]17-29
5709Item Category CodeCode[20]17-29
5710NonstockBoolean17-29
5711Purchasing CodeCode[10]17-29
5713Special OrderBoolean17-29
5714Special Order Sales No.Code[20]17-29
5715Special Order Sales Line No.Integer17-29
5725Item Reference No.Code[50]17-29
5726Item Reference Unit of MeasureCode[10]17-29
5727Item Reference TypeEnum "Item Reference Type"17-29
5728Item Reference Type No.Code[30]17-29
5750Whse. Outstanding Qty. (Base)Decimal17-29
5752Completely ReceivedBoolean17-29
5790Requested Receipt DateDate17-29
5791Promised Receipt DateDate17-29
5792Lead Time CalculationDateFormula17-29
5793Inbound Whse. Handling TimeDateFormula17-29
5794Planned Receipt DateDate17-29
5795Order DateDate17-29
5800Allow Item Charge AssignmentBoolean17-29
5801Qty. to AssignDecimal17-29
5802Qty. AssignedDecimal17-29
5803Return Qty. to ShipDecimal17-29
5804Return Qty. to Ship (Base)Decimal17-29
5805Return Qty. Shipped Not Invd.Decimal17-29
5806Ret. Qty. Shpd Not Invd.(Base)Decimal17-29
5807Return Shpd. Not Invd.Decimal17-29
5808Return Shpd. Not Invd. (LCY)Decimal17-29
5809Return Qty. ShippedDecimal17-29
5810Return Qty. Shipped (Base)Decimal17-29
5812Item Charge Qty. to HandleDecimalnew in 21
6200Non-Deductible VAT %Decimalnew in 22
6201Non-Deductible VAT BaseDecimalnew in 22
6202Non-Deductible VAT AmountDecimalnew in 22
6203Non-Deductible VAT Diff.Decimalnew in 22
6204Prepmt. Non-Deduct. VAT BaseDecimalnew in 22
6205Prepmt. Non-Deduct. VAT AmountDecimalnew in 22
6206Item Charge Has Non.Ded. VATBooleannew in 27
6600Return Shipment No.Code[20]17-29
6601Return Shipment Line No.Integer17-29
6608Return Reason CodeCode[10]17-29
6609SubtypeOption17-29
6610Copied From Posted Doc.Boolean17-29
7000Price Calculation MethodEnum "Price Calculation Method"17-29
7010Attached Doc CountInteger17-29
7011Attached Lines CountIntegernew in 22
8509Over-Receipt QuantityDecimal17-29
8510Over-Receipt CodeCode[20]17-29
8511Over-Receipt Approval StatusEnum "Over-Receipt Approval Status"17-29
8512Buy-from Vendor NameText[100]new in 26
8513Receipt on InvoiceBooleannew in 29
10001Tax To Be ExpensedDecimal17-29
10017Provincial Tax Area CodeCode[20]17-29
10022IRS 1099 LiableBoolean17-29
Removed, tag 28.0, obsolete since 24.0: Moved to IRS Forms App.
10025GST/HSTEnum "GST HST Tax Type"17-29changed in 19
12100No. of Fixed Asset CardsIntegernew in 27
99000755Overhead RateDecimal17-29
99000756MPS OrderBoolean17-29
99000757Planning FlexibilityEnum "Reservation Planning Flexibility"17-29
99000758Safety Lead TimeDateFormula17-29